Hi ich versuche auf meine hp einige wbb Forum infos anzeigen zu lassen habe es so versucht
und dann
leider klappt es nicht.
Hatt eine nee idee?
PHP-Code:
<?
mysql_connect(localhost, web10, xxxxxx);
mysql_select_db(usr_web10_1);
$wbb['post'] = mysql_fetch_array(mysql_query("SELECT * FROM bb1_posts ORDER BY postid DESC"));
$wbb['topic'] = mysql_fetch_array(mysql_query("SELECT * FROM bb1_threads WHERE threadid='".$wbb['post']['threadparentid']."'"));
$wbb['user'] = mysql_fetch_array(mysql_query("SELECT * FROM bb1_users WHERE userid='".$wbb['post']['userid']."'"));
$wbb['posts'] = mysql_num_rows(mysql_query("SELECT * FROM bb1_posts"));
$wbb['threads'] = mysql_num_rows(mysql_query("SELECT * FROM bb1_threads"));
$wbb['users'] = mysql_num_rows(mysql_query("SELECT * FROM bb1_users WHERE activation='1' AND blocked='0'"));
$wbb['n_user'] = mysql_fetch_array(mysql_query("SELECT * FROM bb1_users WHERE activation='1' AND blocked='0' ORDER BY userid DESC"));
$n_user = $wbb['n_user']['username'];
$anzahlposts = $wbb['posts'];
$anzahlthreads = $wbb['threads'];
$anzahluser = $wbb['users'];
$newestuser = $wbb['n_user'];
$thema = $wbb['topic']['threadname'];
$von = $wbb['user']['username'];
$thema_id = $wbb['topic']['boardparentid'];
$user_id = $wbb['user']['userid'];
?>
PHP-Code:
<p><u>Forum Info</u></br>Neuster Beitrag: <? echo $thema; ?> von <? $von; ?>
<? $anzahlposts; ?> Beiträge in <? $anzahlthreads ?> Themen Registrierte Mitglieder: <? $anzahluser; ?> neustes Mitglied: <? $n_user; ?>
</p>
Hatt eine nee idee?
Kommentar