» Forum » Clanscript » Module und Modifikationen » Lastregistuser
  Mitglieder   |   Gallery   |   FAQ's   |   Regeln

[ Anmelden zum schreiben ]

Lastregistuser
StyLe
Mitglied
4 Beitragspunkte
Posts: 277

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 06.08.2010 - 21:58:53     Zitieren
Hallo

Habe da mal eine Frage

Wie kann ich im Forum {lastregistuser} mit einbauen?
zb: Wir begrüßen unseren neuesten Benutzer: Test


Visit! / Gaming Community - TeamSpeak, WebSpace & Gameserver Sponsoring!
www.Die-chillout-Lounge.de
Lord|Schirmer
Administrator
823 Beitragspunkte
Posts: 4603

User Pic

2 Mitglieder finden den Beitrag gut.

Merkliste 06.08.2010 - 23:51:16     Zitieren
so zum Beispiel:

$erg = db_query("SELECT id, name, regist FROM prefix_user ORDER BY regist DESC LIMIT 5");
$lastregistuser = '';
while ( $row = db_fetch_object($erg) ) 
{
$lastregistuser	.= '<a class="box" href="?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
$lastregistuser = substr($lastregistuser, 0, -2);


und dann passend an das Template ausgeben!

PS.: Deine Shift-Taste klemmt Zwinker


Zuletzt modifiziert von Lord|Schirmer am 07.08.2010 - 00:02:18


"In mir schlummert ein Genie, leider wacht es nicht auf!"

my portfolio | my community | important link
StyLe
Mitglied
4 Beitragspunkte
Posts: 277

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 07.08.2010 - 00:18:01     Zitieren
Meine Shift Taste klemmt???



//

Wo muss ich diesen Code einbauen - showforum.php?


Zuletzt modifiziert von StyLe am 07.08.2010 - 00:18:49


Visit! / Gaming Community - TeamSpeak, WebSpace & Gameserver Sponsoring!
www.Die-chillout-Lounge.de
Lord|Schirmer
Administrator
823 Beitragspunkte
Posts: 4603

User Pic

1 Mitglieder finden den Beitrag gut.

Merkliste 07.08.2010 - 09:42:49     Zitieren
Ja in showforum.php. Hast Du das Standard-Forum?
Falls die Einbindung nicht klappt bitte Datei posten!


"In mir schlummert ein Genie, leider wacht es nicht auf!"

my portfolio | my community | important link
StyLe
Mitglied
4 Beitragspunkte
Posts: 277

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 07.08.2010 - 13:48:49     Zitieren
Habe das von Pixelbash.
In der html Datei {lastregistuser} einfügen richtig?

show_forum.php


<?php
#   Copyright by: Manuel
#   Support: www.ilch.de
 
 
defined ('main') or die ( 'no direct access' );
 
 
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
 
if ($menu->get(1) == 'markallasread') {
  user_markallasread ();
}
 
 
$tpl = new tpl ( 'forum/showforum' );
$tpl->out (0);
 
$category_array = array();
$forum_array = array();
 
$q = "SELECT
a.id, a.cid, a.name, a.besch,
a.topics, a.posts, b.name as topic,
c.id as pid, c.tid, b.rep, c.erst, c.time,
a.cid, k.name as cname
FROM prefix_forums a
LEFT JOIN prefix_forumcats k ON k.id = a.cid
LEFT JOIN prefix_posts c ON a.last_post_id = c.id
LEFT JOIN prefix_topics b ON c.tid = b.id
 
LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = a.view
LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = a.reply
LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = a.start
 
WHERE ((".$_SESSION['authright']." <= a.view AND a.view < 1)
OR (".$_SESSION['authright']." <= a.reply AND a.reply < 1)
OR (".$_SESSION['authright']." <= a.start AND a.start < 1)
   OR vg.fid IS NOT NULL
   OR rg.fid IS NOT NULL
   OR sg.fid IS NOT NULL
   OR -9 = ".$_SESSION['authright'].")
   AND k.cid = 0
ORDER BY k.pos, a.pos";
$erg1 = db_query($q);
$xcid = 0;
while ($r = db_fetch_assoc($erg1) ) {
 
  $r['topicl'] = $r['topic'];
  $r['topic']  = html_enc_substr($r['topic'],0,23);
  $r['ORD']    = forum_get_ordner($r['time'],$r['id']);
  $r['mods']   = getmods($r['id']);
  $r['datum']  = date('d.m.y - H:i', $r['time']);
  $r['page']   = ceil ( ($r['rep']+1)  / $allgAr['Fpanz'] );
  $tpl->set_ar ($r);
 
  if ($r['cid'] <> $xcid) {
    $tpl->out(1);
    //Unterkategorien
    $sql = db_query("SELECT DISTINCT a.name as cname, a.id as cid FROM `prefix_forumcats` a LEFT JOIN `prefix_forums` b ON a.id = b.cid WHERE a.cid = {$r['cid']} AND a.id = b.cid ORDER BY a.pos, a.name");
    while ($ucat = db_fetch_assoc($sql)) {
      $tpl->set_ar_out($ucat,2);
    }
    //Unterkategorien - Ende
    $xcid = $r['cid'];
  }
  $tpl->set_ar_out($r,3);
}
 
##### Moderartoren
 
$moda = array();
 
$erg = db_query("SELECT b.id as uid, b.name, b.recht,c.id FROM prefix_forummods a LEFT JOIN prefix_user b ON b.id = a.uid LEFT JOIN prefix_grundrechte c ON c.id = b.recht GROUP BY b.name ORDER BY b.id");
while ($row = db_fetch_object($erg)) {
    //$recht_name=@db_result(db_query('SELECT name FROM prefix_grundrechte WHERE id='.$row->recht),0);
    switch($row->recht)    {
        case -9:            $color = '#ff0000'; break; //Super Administrator
        case -8:            $color = '#ff8c00'; break; //Co Administrator
        case -7:            $color = '#1e90ff'; break; //Super-Moderator
        case -6:            $color = '#9F00FF'; break; //Css Admin
        case -5:            $color = '#33E500'; break; //Coder und Designer
        case -4:            $color = '#ff1493'; break; //Member
        case -3:            $color = '#a0522d'; break; //Trialmember
        case -2: case -1: default: $color = '#ffffff'; break; //User
    }
    $moda[] = '<a href="index.php?user-details-'.$row->uid.'" style="font-weight: bold; color:'.$color.'">'.$row->name.'</a>';
}
 
# statistic #
$ges_online_user = ges_online();
$stats_array = array (  

  'privmsgpopup' => check_for_pm_popup (),
  'topics' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
  'posts' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0),
  'users' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_user`"),0),
  'istsind' => ( $ges_online_user > 1 ? 'sind' : 'ist' ),
  'gesonline' => $ges_online_user,
  'gastonline' => ges_gast_online(),
  'useronline' => ges_user_online(),
  'userliste' => user_online_liste(),
  'moda' => implode(', ', $moda),
  'userliste_today' => user_online_today_liste(),



);

$tpl->set_ar_out($stats_array,4);function user_online_today_liste(){ 
    $OnListe = ''; 
  $dif = mktime(0,0,0,date('m'),date('d'),date('Y')); 
    $erg = db_query("SELECT a.id, a.name, a.llogin, b.bez, a.spezrank FROM `prefix_user` a LEFT JOIN prefix_ranks b ON b.id = a.spezrank  WHERE a.llogin > '". $dif."' ORDER BY llogin"); 
    while($row = db_fetch_object($erg)) { 
      if ( $row->spezrank <> 0 ) { 
      $OnListe .= '<a class="'.$row->bez.'" title="'.$row->bez.'" href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, '; 
    } else { 
      $OnListe .= '<a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, '; 
      } 
  } 
    $OnListe = substr($OnListe,0,strlen($OnListe) - 3); 
  return ($OnListe); 

}

$design->footer();
?>


Visit! / Gaming Community - TeamSpeak, WebSpace & Gameserver Sponsoring!
www.Die-chillout-Lounge.de
Lord|Schirmer
Administrator
823 Beitragspunkte
Posts: 4603

User Pic

2 Mitglieder finden den Beitrag gut.

Merkliste 07.08.2010 - 14:32:58     Zitieren
Probiers mal!

show_forum.php
<?php
#   Copyright by: Manuel
#   Support: www.ilch.de
 
 
defined ('main') or die ( 'no direct access' );
 
 
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
 
if ($menu->get(1) == 'markallasread') {
  user_markallasread ();
}
 
 
$tpl = new tpl ( 'forum/showforum' );
$tpl->out (0);
 
$category_array = array();
$forum_array = array();
 
$q = "SELECT
a.id, a.cid, a.name, a.besch,
a.topics, a.posts, b.name as topic,
c.id as pid, c.tid, b.rep, c.erst, c.time,
a.cid, k.name as cname
FROM prefix_forums a
LEFT JOIN prefix_forumcats k ON k.id = a.cid
LEFT JOIN prefix_posts c ON a.last_post_id = c.id
LEFT JOIN prefix_topics b ON c.tid = b.id
 
LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = a.view
LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = a.reply
LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = a.start
 
WHERE ((".$_SESSION['authright']." <= a.view AND a.view < 1)
OR (".$_SESSION['authright']." <= a.reply AND a.reply < 1)
OR (".$_SESSION['authright']." <= a.start AND a.start < 1)
   OR vg.fid IS NOT NULL
   OR rg.fid IS NOT NULL
   OR sg.fid IS NOT NULL
   OR -9 = ".$_SESSION['authright'].")
   AND k.cid = 0
ORDER BY k.pos, a.pos";
$erg1 = db_query($q);
$xcid = 0;
while ($r = db_fetch_assoc($erg1) ) {
 
  $r['topicl'] = $r['topic'];
  $r['topic']  = html_enc_substr($r['topic'],0,23);
  $r['ORD']    = forum_get_ordner($r['time'],$r['id']);
  $r['mods']   = getmods($r['id']);
  $r['datum']  = date('d.m.y - H:i', $r['time']);
  $r['page']   = ceil ( ($r['rep']+1)  / $allgAr['Fpanz'] );
  $tpl->set_ar ($r);
 
  if ($r['cid'] <> $xcid) {
    $tpl->out(1);
    //Unterkategorien
    $sql = db_query("SELECT DISTINCT a.name as cname, a.id as cid FROM `prefix_forumcats` a LEFT JOIN `prefix_forums` b ON a.id = b.cid WHERE a.cid = {$r['cid']} AND a.id = b.cid ORDER BY a.pos, a.name");
    while ($ucat = db_fetch_assoc($sql)) {
      $tpl->set_ar_out($ucat,2);
    }
    //Unterkategorien - Ende
    $xcid = $r['cid'];
  }
  $tpl->set_ar_out($r,3);
}
 
##### Moderartoren
 
$moda = array();
 
$erg = db_query("SELECT b.id as uid, b.name, b.recht,c.id FROM prefix_forummods a LEFT JOIN prefix_user b ON b.id = a.uid LEFT JOIN prefix_grundrechte c ON c.id = b.recht GROUP BY b.name ORDER BY b.id");
while ($row = db_fetch_object($erg)) {
    //$recht_name=@db_result(db_query('SELECT name FROM prefix_grundrechte WHERE id='.$row->recht),0);
    switch($row->recht)    {
        case -9:            $color = '#ff0000'; break; //Super Administrator
        case -8:            $color = '#ff8c00'; break; //Co Administrator
        case -7:            $color = '#1e90ff'; break; //Super-Moderator
        case -6:            $color = '#9F00FF'; break; //Css Admin
        case -5:            $color = '#33E500'; break; //Coder und Designer
        case -4:            $color = '#ff1493'; break; //Member
        case -3:            $color = '#a0522d'; break; //Trialmember
        case -2: case -1: default: $color = '#ffffff'; break; //User
    }
    $moda[] = '<a href="index.php?user-details-'.$row->uid.'" style="font-weight: bold; color:'.$color.'">'.$row->name.'</a>';
}

# lastregistuser #
$erg = db_query("SELECT id, name, regist FROM prefix_user ORDER BY regist DESC LIMIT 5");
$lastregistuser = '';
while ( $row = db_fetch_object($erg) ) 
{
$lastregistuser .= '<a class="box" href="?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
$lastregistuser = substr($lastregistuser, 0, -2);

# statistic #
$ges_online_user = ges_online();
$stats_array = array (  

  'lastregistuser' => $lastregistuser,  
  'privmsgpopup' => check_for_pm_popup (),
  'topics' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
  'posts' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0),
  'users' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_user`"),0),
  'istsind' => ( $ges_online_user > 1 ? 'sind' : 'ist' ),
  'gesonline' => $ges_online_user,
  'gastonline' => ges_gast_online(),
  'useronline' => ges_user_online(),
  'userliste' => user_online_liste(),
  'moda' => implode(', ', $moda),
  'userliste_today' => user_online_today_liste(),

);
 
$tpl->set_ar_out($stats_array,4);function user_online_today_liste(){ 
    $OnListe = ''; 
  $dif = mktime(0,0,0,date('m'),date('d'),date('Y')); 
    $erg = db_query("SELECT a.id, a.name, a.llogin, b.bez, a.spezrank FROM `prefix_user` a LEFT JOIN prefix_ranks b ON b.id = a.spezrank  WHERE a.llogin > '". $dif."' ORDER BY llogin"); 
    while($row = db_fetch_object($erg)) { 
      if ( $row->spezrank <> 0 ) { 
      $OnListe .= '<a class="'.$row->bez.'" title="'.$row->bez.'" href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, '; 
    } else { 
      $OnListe .= '<a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a>, '; 
      } 
  } 
    $OnListe = substr($OnListe,0,strlen($OnListe) - 3); 
  return ($OnListe); 
 
}
 
$design->footer();
?>


Wie schon richtig gesagt in die showforum.htm das {lastregistuser} an die passende Stelle einfügen!


"In mir schlummert ein Genie, leider wacht es nicht auf!"

my portfolio | my community | important link
StyLe
Mitglied
4 Beitragspunkte
Posts: 277

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 07.08.2010 - 16:44:04     Zitieren
Danke
Echt nett von dir...


Visit! / Gaming Community - TeamSpeak, WebSpace & Gameserver Sponsoring!
www.Die-chillout-Lounge.de
Sunshine Live
Mitglied
69 Beitragspunkte
Posts: 913

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 28.09.2011 - 01:09:59     Zitieren
Hay, ich auch ne frage hier zu und zwar moecht ich es auch einbauen nur leider weiß ich nicht genau wo hier das rein muss..Traurig
Ich benutze das ilchbb_forum
Hoffe kann mir wer helfen
<?php 
#   Copyright by: Manuel
#   Support: www.ilch.de

/**
 * @name    IlchBB Forum
 * @version 3.1
 * @author  Florian Koerner
 * @link    http://www.koerner-ws.de/
 * @license GNU General Public License
 */


defined ('main') or die ( 'no direct access' );

// IlchBB Forum 3.1 :: Loader :: Start
require_once ('include/contents/ilchbb_forum/ilchbb_loader.php');
// IlchBB Forum 3.1 :: Loader :: Ende

$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();

// IlchBB Forum 3.1 :: Extensions :: Start
$ilchbb_tpl = new tpl('ilchbb_forum/load_extensions');
$ilchbb_tpl->out(0);
// IlchBB Forum 3.1 :: Extensions :: End

if ($menu->get(1) == 'markallasread') {
    $ilchBB->deleteNewTopics();
}


$tpl = new tpl ( 'ilchbb_forum/showforum' );
$tpl->out (0);

$category_array = array();
$forum_array = array();

$q = "SELECT
  a.id, a.cid, a.name, a.besch,
  a.topics, a.posts, b.name as topic,
  c.id as pid, c.tid, b.rep, c.erst, c.time,
  a.cid, k.name as cname
FROM prefix_forums a
  LEFT JOIN prefix_forumcats k ON k.id = a.cid
  LEFT JOIN prefix_posts c ON a.last_post_id = c.id
  LEFT JOIN prefix_topics b ON c.tid = b.id
	
  LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = a.view
  LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = a.reply
  LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = a.start
	
WHERE ((".$_SESSION['authright']." <= a.view AND a.view < 1) 
   OR (".$_SESSION['authright']." <= a.reply AND a.reply < 1)
   OR (".$_SESSION['authright']." <= a.start AND a.start < 1)
	 OR vg.fid IS NOT NULL
	 OR rg.fid IS NOT NULL
	 OR sg.fid IS NOT NULL
	 OR -9 = ".$_SESSION['authright'].")
	 AND k.cid = 0
ORDER BY k.pos, a.pos";
$erg1 = db_query($q);
$xcid = 0;

while ($r = db_fetch_assoc($erg1) ) {

    // IlchBB Forum 3.1 :: Get Forum Status :: Start
    $ord = $ilchBB->checkNewTopics($r['id']);

    if ($ord === TRUE) {
        $r['ORD'] = 'forum_unread';
        $r['TORD'] = 'Neue Beitr&auml;ge';
    } else {
        $r['ORD'] = 'forum_read';
        $r['TORD'] = 'Keine neuen Beitr&auml;ge';
    }
    // IlchBB Forum 3.1 :: Get Forum Status :: Ende
    
    $r['topicl'] = $r['topic'];
    $r['topic']  = html_enc_substr($r['topic'],0,23);
    $r['mods']   = getmods($r['id']);
    $r['datum']  = date('d.m.y - H:i', $r['time']);
    $r['page']   = ceil ( ($r['rep']+1)  / $allgAr['Fpanz'] );
    $r['erst'] = forum_farbname($r['erst']);
    $r['name']   = bbcode($r['name']);
    $tpl->set_ar($r);

    if ($r['cid'] <> $xcid) {
        $tpl->out(1);

        // IlchBB Forum 3.1 :: Set CSS Class :: Start
        $class = 'ilchbb_Cmite';
        // IlchBB Forum 3.1 :: Set CSS Class :: End

        //Unterkategorien
        $sql = db_query("SELECT DISTINCT a.name as cname, a.id as cid FROM `prefix_forumcats` a LEFT JOIN `prefix_forums` b ON a.id = b.cid WHERE a.cid = {$r['cid']} AND a.id = b.cid ORDER BY a.pos, a.name");
        while ($ucat = db_fetch_assoc($sql)) {

            // IlchBB Forum 3.1 :: Change CSS Class :: Start
            $class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
            $ucat['class'] = $class;
            // IlchBB Forum 3.1 :: Change CSS Class :: Start

            $tpl->set_ar_out($ucat,2);
        }
        //Unterkategorien - Ende
        $xcid = $r['cid'];
    }

    // IlchBB Forum 3.1 :: Change CSS Class :: Start
    $class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
    $r['class'] = $class;
    // IlchBB Forum 3.1 :: Change CSS Class :: Start

    $tpl->set_ar_out($r,3);
}

// IlchBB Forum 3.1 :: Online Today :: Start
if ($allgAr['ilchbb_forum_dayonline'] == 1) {
    $time = mktime (0,0,0,date("n"),date("j"),date("Y"));

    $query = 'SELECT `id`,`name` FROM `prefix_user` WHERE llogin > '.$time;
    $query = db_query($query);

    $cache = '';

    while ($row = db_fetch_assoc($query)) {
        if (!empty($cache)) $cache .= ', ';
        $cache .= '<a href="index.php?user-details-'.$row['id'].'">'.$row['name'].'</a>';
    }

    $tpl->set('dayonline','<br /><br />Heute waren bereits online:<br />'.$cache);
} else {
    $tpl->set('dayonline','');
}
// IlchBB Forum 3.1 :: Online Today :: End

# statistic #
$dif = date('Y-m-d H:i:s', time() - USERUPTIME);
$erg = db_query("SELECT DISTINCT uid, name, prefix_ranks.bez, spezrank FROM `prefix_online` left join prefix_user on prefix_user.id = prefix_online.uid left join prefix_ranks ON prefix_ranks.id = prefix_user.spezrank WHERE uid > 0 and uptime > '" . $dif . "'");
while ($row = db_fetch_object($erg))
{
  if ($row->spezrank != 0)
  {
  $userliste .= '<a title="' . $row->bez . '" href="index.php?user-details-' . $row->uid . '"><b><i>' . forum_farbname($row->name) . '</i></b></a> , ';
  } else {
  $userliste .= '<a href="index.php?user-details-' . $row->uid . '">' . forum_farbname($row->name) . '</a> , ';
  }
}
$userliste = substr($userliste, 0, strlen($userliste) - 3);
$ges_online_user = ges_online();
$stats_array = array (
  'privmsgpopup' => check_for_pm_popup (),
  'topics' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
  'posts' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0),
  'users' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_user`"),0),
  'istsind' => ( $ges_online_user > 1 ? 'sind' : 'ist' ),
  'gesonline' => $ges_online_user,
  'gastonline' => ges_gast_online(),
  'useronline' => ges_user_online(),
  'userliste' => $userliste,
);

$tpl->set_ar_out($stats_array,4);

// IlchBB Forum 3.1 :: Copyright :: Start
$ilchbb_tpl->out(1);
// IlchBB Forum 3.1 :: Copryright :: End



$design->footer();
?>


Meine Page
Profilansicht 1.2b
Profilansicht 1.2
Fonsi1
Mitglied
32 Beitragspunkte
Posts: 453

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 28.09.2011 - 20:07:03     Zitieren
Ich würde es so versuchen, ob es klappt oder mit dem Forum Kompatibel ist weiß ich net??
Und dann in die showforum.htm das {lastregistuser} an die passende Stelle einfügen

<?php
#   Copyright by: Manuel
#   Support: www.ilch.de
 
/**
 * @name    IlchBB Forum
 * @version 3.1
 * @author  Florian Koerner
 * @link    http://www.koerner-ws.de/
 * @license GNU General Public License
 */
 
 
defined ('main') or die ( 'no direct access' );
 
// IlchBB Forum 3.1 :: Loader :: Start
require_once ('include/contents/ilchbb_forum/ilchbb_loader.php');
// IlchBB Forum 3.1 :: Loader :: Ende
 
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
 
// IlchBB Forum 3.1 :: Extensions :: Start
$ilchbb_tpl = new tpl('ilchbb_forum/load_extensions');
$ilchbb_tpl->out(0);
// IlchBB Forum 3.1 :: Extensions :: End
 
if ($menu->get(1) == 'markallasread') {
    $ilchBB->deleteNewTopics();
}
 
 
$tpl = new tpl ( 'ilchbb_forum/showforum' );
$tpl->out (0);
 
$category_array = array();
$forum_array = array();
 
$q = "SELECT
 a.id, a.cid, a.name, a.besch,
 a.topics, a.posts, b.name as topic,
 c.id as pid, c.tid, b.rep, c.erst, c.time,
 a.cid, k.name as cname
FROM prefix_forums a
 LEFT JOIN prefix_forumcats k ON k.id = a.cid
 LEFT JOIN prefix_posts c ON a.last_post_id = c.id
 LEFT JOIN prefix_topics b ON c.tid = b.id
   
 LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = a.view
 LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = a.reply
 LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = a.start
   
WHERE ((".$_SESSION['authright']." <= a.view AND a.view < 1)
  OR (".$_SESSION['authright']." <= a.reply AND a.reply < 1)
  OR (".$_SESSION['authright']." <= a.start AND a.start < 1)
     OR vg.fid IS NOT NULL
     OR rg.fid IS NOT NULL
     OR sg.fid IS NOT NULL
     OR -9 = ".$_SESSION['authright'].")
     AND k.cid = 0
ORDER BY k.pos, a.pos";
$erg1 = db_query($q);
$xcid = 0;
 
while ($r = db_fetch_assoc($erg1) ) {
 
    // IlchBB Forum 3.1 :: Get Forum Status :: Start
    $ord = $ilchBB->checkNewTopics($r['id']);
 
    if ($ord === TRUE) {
        $r['ORD'] = 'forum_unread';
        $r['TORD'] = 'Neue Beitr&auml;ge';
    } else {
        $r['ORD'] = 'forum_read';
        $r['TORD'] = 'Keine neuen Beitr&auml;ge';
    }
    // IlchBB Forum 3.1 :: Get Forum Status :: Ende
   
    $r['topicl'] = $r['topic'];
    $r['topic']  = html_enc_substr($r['topic'],0,23);
    $r['mods']   = getmods($r['id']);
    $r['datum']  = date('d.m.y - H:i', $r['time']);
    $r['page']   = ceil ( ($r['rep']+1)  / $allgAr['Fpanz'] );
    $r['erst'] = forum_farbname($r['erst']);
    $r['name']   = bbcode($r['name']);
    $tpl->set_ar($r);
 
    if ($r['cid'] <> $xcid) {
        $tpl->out(1);
 
        // IlchBB Forum 3.1 :: Set CSS Class :: Start
        $class = 'ilchbb_Cmite';
        // IlchBB Forum 3.1 :: Set CSS Class :: End
 
        //Unterkategorien
        $sql = db_query("SELECT DISTINCT a.name as cname, a.id as cid FROM `prefix_forumcats` a LEFT JOIN `prefix_forums` b ON a.id = b.cid WHERE a.cid = {$r['cid']} AND a.id = b.cid ORDER BY a.pos, a.name");
        while ($ucat = db_fetch_assoc($sql)) {
 
            // IlchBB Forum 3.1 :: Change CSS Class :: Start
            $class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
            $ucat['class'] = $class;
            // IlchBB Forum 3.1 :: Change CSS Class :: Start
 
            $tpl->set_ar_out($ucat,2);
        }
        //Unterkategorien - Ende
        $xcid = $r['cid'];
    }
 
    // IlchBB Forum 3.1 :: Change CSS Class :: Start
    $class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
    $r['class'] = $class;
    // IlchBB Forum 3.1 :: Change CSS Class :: Start
 
    $tpl->set_ar_out($r,3);
}
 
// IlchBB Forum 3.1 :: Online Today :: Start
if ($allgAr['ilchbb_forum_dayonline'] == 1) {
    $time = mktime (0,0,0,date("n"),date("j"),date("Y"));
 
    $query = 'SELECT `id`,`name` FROM `prefix_user` WHERE llogin > '.$time;
    $query = db_query($query);
 
    $cache = '';
 
    while ($row = db_fetch_assoc($query)) {
        if (!empty($cache)) $cache .= ', ';
        $cache .= '<a href="index.php?user-details-'.$row['id'].'">'.$row['name'].'</a>';
    }
 
    $tpl->set('dayonline','<br /><br />Heute waren bereits online:<br />'.$cache);
} else {
    $tpl->set('dayonline','');
}
// IlchBB Forum 3.1 :: Online Today :: End

 # lastregistuser #
$erg = db_query("SELECT id, name, regist FROM prefix_user ORDER BY regist DESC LIMIT 5");
$lastregistuser = '';
while ( $row = db_fetch_object($erg) )
{
$lastregistuser .= '<a class="box" href="?user-details-'.$row->id.'">'.$row->name.'</a>, ';
}
$lastregistuser = substr($lastregistuser, 0, -2);

# statistic #
$dif = date('Y-m-d H:i:s', time() - USERUPTIME);
$erg = db_query("SELECT DISTINCT uid, name, prefix_ranks.bez, spezrank FROM `prefix_online` left join prefix_user on prefix_user.id = prefix_online.uid left join prefix_ranks ON prefix_ranks.id = prefix_user.spezrank WHERE uid > 0 and uptime > '" . $dif . "'");
while ($row = db_fetch_object($erg))
{
  if ($row->spezrank != 0)
  {
  $userliste .= '<a title="' . $row->bez . '" href="index.php?user-details-' . $row->uid . '"><b><i>' . forum_farbname($row->name) . '</i></b></a> , ';
  } else {
  $userliste .= '<a href="index.php?user-details-' . $row->uid . '">' . forum_farbname($row->name) . '</a> , ';
  }
}
$userliste = substr($userliste, 0, strlen($userliste) - 3);
$ges_online_user = ges_online();
$stats_array = array (
  'privmsgpopup' => check_for_pm_popup (),
  'topics' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
  'posts' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0),
  'users' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_user`"),0),
  'istsind' => ( $ges_online_user > 1 ? 'sind' : 'ist' ),
  'gesonline' => $ges_online_user,
  'gastonline' => ges_gast_online(),
  'useronline' => ges_user_online(),
  'userliste' => $userliste,
);
 
$tpl->set_ar_out($stats_array,4);
 
// IlchBB Forum 3.1 :: Copyright :: Start
$ilchbb_tpl->out(1);
// IlchBB Forum 3.1 :: Copryright :: End
 
 
 
$design->footer();
?>
Tr3icio
Mitglied
 Beitragspunkte

1 Mitglieder finden den Beitrag gut.

Merkliste 28.09.2011 - 20:17:39     Zitieren
{lgu} ist der Platzhalter.

<?php
#   Copyright by: Manuel
#   Support: www.ilch.de
 
/**
 * @name    IlchBB Forum
 * @version 3.1
 * @author  Florian Koerner
 * @link    http://www.koerner-ws.de/
 * @license GNU General Public License
 */
 
 
defined ('main') or die ( 'no direct access' );
 
// IlchBB Forum 3.1 :: Loader :: Start
require_once ('include/contents/ilchbb_forum/ilchbb_loader.php');
// IlchBB Forum 3.1 :: Loader :: Ende
 
$title = $allgAr['title'].' :: Forum';
$hmenu = $extented_forum_menu.'Forum'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
 
// IlchBB Forum 3.1 :: Extensions :: Start
$ilchbb_tpl = new tpl('ilchbb_forum/load_extensions');
$ilchbb_tpl->out(0);
// IlchBB Forum 3.1 :: Extensions :: End
 
if ($menu->get(1) == 'markallasread') {
    $ilchBB->deleteNewTopics();
}
 
 
$tpl = new tpl ( 'ilchbb_forum/showforum' );
$tpl->out (0);
 
$category_array = array();
$forum_array = array();
 
$q = "SELECT
 a.id, a.cid, a.name, a.besch,
 a.topics, a.posts, b.name as topic,
 c.id as pid, c.tid, b.rep, c.erst, c.time,
 a.cid, k.name as cname
FROM prefix_forums a
 LEFT JOIN prefix_forumcats k ON k.id = a.cid
 LEFT JOIN prefix_posts c ON a.last_post_id = c.id
 LEFT JOIN prefix_topics b ON c.tid = b.id
   
 LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = a.view
 LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = a.reply
 LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = a.start
   
WHERE ((".$_SESSION['authright']." <= a.view AND a.view < 1)
  OR (".$_SESSION['authright']." <= a.reply AND a.reply < 1)
  OR (".$_SESSION['authright']." <= a.start AND a.start < 1)
     OR vg.fid IS NOT NULL
     OR rg.fid IS NOT NULL
     OR sg.fid IS NOT NULL
     OR -9 = ".$_SESSION['authright'].")
     AND k.cid = 0
ORDER BY k.pos, a.pos";
$erg1 = db_query($q);
$xcid = 0;
 
while ($r = db_fetch_assoc($erg1) ) {
 
    // IlchBB Forum 3.1 :: Get Forum Status :: Start
    $ord = $ilchBB->checkNewTopics($r['id']);
 
    if ($ord === TRUE) {
        $r['ORD'] = 'forum_unread';
        $r['TORD'] = 'Neue Beitr&auml;ge';
    } else {
        $r['ORD'] = 'forum_read';
        $r['TORD'] = 'Keine neuen Beitr&auml;ge';
    }
    // IlchBB Forum 3.1 :: Get Forum Status :: Ende
   
    $r['topicl'] = $r['topic'];
    $r['topic']  = html_enc_substr($r['topic'],0,23);
    $r['mods']   = getmods($r['id']);
    $r['datum']  = date('d.m.y - H:i', $r['time']);
    $r['page']   = ceil ( ($r['rep']+1)  / $allgAr['Fpanz'] );
    $r['erst'] = forum_farbname($r['erst']);
    $r['name']   = bbcode($r['name']);
    $tpl->set_ar($r);
 
    if ($r['cid'] <> $xcid) {
        $tpl->out(1);
 
        // IlchBB Forum 3.1 :: Set CSS Class :: Start
        $class = 'ilchbb_Cmite';
        // IlchBB Forum 3.1 :: Set CSS Class :: End
 
        //Unterkategorien
        $sql = db_query("SELECT DISTINCT a.name as cname, a.id as cid FROM `prefix_forumcats` a LEFT JOIN `prefix_forums` b ON a.id = b.cid WHERE a.cid = {$r['cid']} AND a.id = b.cid ORDER BY a.pos, a.name");
        while ($ucat = db_fetch_assoc($sql)) {
 
            // IlchBB Forum 3.1 :: Change CSS Class :: Start
            $class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
            $ucat['class'] = $class;
            // IlchBB Forum 3.1 :: Change CSS Class :: Start
 
            $tpl->set_ar_out($ucat,2);
        }
        //Unterkategorien - Ende
        $xcid = $r['cid'];
    }
 
    // IlchBB Forum 3.1 :: Change CSS Class :: Start
    $class = ( $class == 'ilchbb_Cmite' ? 'ilchbb_Cnorm' : 'ilchbb_Cmite' );
    $r['class'] = $class;
    // IlchBB Forum 3.1 :: Change CSS Class :: Start
 
    $tpl->set_ar_out($r,3);
}
 
// IlchBB Forum 3.1 :: Online Today :: Start
if ($allgAr['ilchbb_forum_dayonline'] == 1) {
    $time = mktime (0,0,0,date("n"),date("j"),date("Y"));
 
    $query = 'SELECT `id`,`name` FROM `prefix_user` WHERE llogin > '.$time;
    $query = db_query($query);
 
    $cache = '';
 
    while ($row = db_fetch_assoc($query)) {
        if (!empty($cache)) $cache .= ', ';
        $cache .= '<a href="index.php?user-details-'.$row['id'].'">'.$row['name'].'</a>';
    }
 
    $tpl->set('dayonline','<br /><br />Heute waren bereits online:<br />'.$cache);
} else {
    $tpl->set('dayonline','');
}
// IlchBB Forum 3.1 :: Online Today :: End
 
# statistic #
$dif = date('Y-m-d H:i:s', time() - USERUPTIME);
$erg = db_query("SELECT DISTINCT uid, name, prefix_ranks.bez, spezrank FROM `prefix_online` left join prefix_user on prefix_user.id = prefix_online.uid left join prefix_ranks ON prefix_ranks.id = prefix_user.spezrank WHERE uid > 0 and uptime > '" . $dif . "'");
while ($row = db_fetch_object($erg))
{
  if ($row->spezrank != 0)
  {
  $userliste .= '<a title="' . $row->bez . '" href="index.php?user-details-' . $row->uid . '"><b><i>' . forum_farbname($row->name) . '</i></b></a> , ';
  } else {
  $userliste .= '<a href="index.php?user-details-' . $row->uid . '">' . forum_farbname($row->name) . '</a> , ';
  }
}

$lgu = db_result(db_query("SELECT name FROM prefix_user ORDER BY id DESC LIMIT 1"), 0);

$userliste = substr($userliste, 0, strlen($userliste) - 3);
$ges_online_user = ges_online();
$stats_array = array (
  'privmsgpopup' => check_for_pm_popup (),
  'topics' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
  'posts' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0),
  'users' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_user`"),0),
  'istsind' => ( $ges_online_user > 1 ? 'sind' : 'ist' ),
  'gesonline' => $ges_online_user,
  'gastonline' => ges_gast_online(),
  'useronline' => ges_user_online(),
  'userliste' => $userliste,
  'lgu' => $lgu
);
 
$tpl->set_ar_out($stats_array,4);
 
// IlchBB Forum 3.1 :: Copyright :: Start
$ilchbb_tpl->out(1);
// IlchBB Forum 3.1 :: Copryright :: End
 
 
 
$design->footer();
?>
wildhorse
Mitglied
2 Beitragspunkte
Posts: 404

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 29.09.2011 - 00:07:11     Zitieren
Danke funktioniert super.
mfg wildhorse


Freiheit für Grönland,weg mit dem Packeis.

[ Anmelden zum schreiben ]