Код за потвърждение: Избери целия код
[phpBB Debug] PHP Warning: in file /home/csrevolu/public_html/inc/left_menu.php on line 96: mysql_fetch_array() expects parameter 1 to be resource, boolean given
Код за потвърждение: Избери целия код
<div class="r_menu_cnt">
<div class="r_menubg">Навигация</div>
<ul class="navbar">
<li class="first"><a href="Начало" title="Начало">Начало</a></li>
<li><a href="Изтегли-CS-1.6" title="SMS Админ">Изтегли CS 1.6</a></li>
<li><a href="EXTRA-ADMIN-Привилегии" title="SMS Админ">Екстра Админ</a></li>
<li><a href="Банер-Генератор" title="Банер Генератор">Банер Генератор</a></li>
<li><a href="Уеб-Компилатор" title="Уеб Компилатор">Уеб Компилатор</a></li>
<li><a href="Console-Maker" title="Console Maker">Console Maker</a></li>
<li><a href="CFG-Maker" title="CFG Maker">CFG Maker</a></li>
<li><a href="Какъв-е-моят-IP-адрес" title="Твоят IP Адрес">Твоят IP Адрес</a></li>
</ul>
</div>
<div class="r_menu_bottom"></div>
<div class="r_menu_cnt">
<div class="r_menubg">Препоръчано от нас...</div>
<div style="background:#FFF;border:1px solid #666;">
<table style="width:100%;border:0;">
<tr>
<td valign="top" width="50%">
<div align="center">
<?php require "inc/88x31.php"; ?>
<?php require "inc/88x31.php"; ?>
<div style="padding:2px;"></div>
<?php require "inc/88x31.php"; ?>
<?php require "inc/88x31.php"; ?>
</div>
</td>
</tr></table></div><br />
<?php echo '<div id="paidlinks">';
$sql = "SELECT * FROM `ads` WHERE size = 'text' ORDER BY RAND() LIMIT 4";
$result = mysql_query($sql) or die(mysql_error());
$banners = mysql_num_rows($result);
if ($banners <= 0)
{
echo '<ul>
<li><a href="#" target="_blank" title="" rel="nofollow">Текстова реклама</a></li>
<li><a href="#" target="_blank" title="" rel="nofollow">Текстова реклама</a></li>
<li><a href="#" target="_blank" title="" rel="nofollow">Текстова реклама</a></li>
</ul>';
} else {
while ($row = mysql_fetch_assoc($result))
{
echo '<ul>
<li><a href="'.$row['url'].'" title="">'.$row['url'].'</a></li>
<li><a href="'.$row['url'].'" title="">'.$row['url'].'</a></li>
<li><a href="'.$row['url'].'" title="">'.$row['url'].'</a></li>
</ul>';
}
}
echo '</div>';
?><br />
<p style="margin:0;text-align:center"><a href="advertising.php" title="Рекламирайте сайта си при нас!">вашият сайт тук?</a></p>
</div>
<div class="r_menu_bottom"></div>
<div class="r_menu_cnt">
<div class="r_menubg">Статистика</div>
Има<b>
<?php
$our = mysql_query("SELECT count(id) as total FROM novini");
while($raw=mysql_fetch_array($our)){
$total=$raw['total'];
echo ' '.$total.' ';
}
?></b> новини<br />
Има<b>
<?php
$our = mysql_query("SELECT count(id) as total FROM ads");
while($raw=mysql_fetch_array($our)){
$total=$raw['total'];
echo ' '.$total.' ';
}
?></b> реклами<br />
Има<b>
<?php
$our = mysql_query("SELECT count(id) as total FROM klipove");
while($raw=mysql_fetch_array($our)){
$total=$raw['total'];
echo ' '.$total.' ';
}
?></b> видеоклипа<br />
Има<b>
<?php
$our = mysql_query("SELECT count(id) as total FROM banneri");
while($raw=mysql_fetch_array($our)){
$total=$raw['total'];
echo ' '.$total.' ';
}
?></b> банери<br />
Има<b>
<?php
$our = mysql_query("SELECT count(id) as total FROM vaprosi");
while($raw=mysql_fetch_array($our)){
$total=$raw['total'];
echo ' '.$total.' ';
}
?></b> анкети<br />
Има <b><?php
$our = mysql_query("SELECT count(id) as total FROM servers");
while($raw=mysql_fetch_array($our)){
$total=$raw['total'];
echo ' '.$total.' ';
}
?></b> сървъри<br />
<hr />
<?php
include("forum/config.php");
//users//
$query = mysql_query('SELECT * FROM phpbb_users WHERE user_type != 2');
$count = mysql_num_rows($query);
$realusers = $count; //users - bots :)
if($count > 0) {
echo "Има <b>{$realusers}</b> потребители";
} else {
echo "Няма потребители";
}
//topics
echo "<br />";
$query2 = mysql_query('SELECT * FROM phpbb_topics');
$count2 = mysql_num_rows($query2);
if($count2 > 0) {
echo "Има <b>{$count2}</b> теми";
} else {
echo "Няма теми";
}
//posts
echo "<br />";
$query3 = mysql_query('SELECT * FROM phpbb_posts');
$count3 = mysql_num_rows($query3);
if($count3 > 0) {
echo "Има <b>{$count3}</b> мнения";
} else {
echo "Няма мнения";
}
//bans
echo "<br />";
$query5 = mysql_query('SELECT * FROM phpbb_banlist');
$count5 = mysql_num_rows($query5);
if($count5 > 0) {
echo "Има <b>{$count5}</b> баннати";
} else {
echo "Няма баннати потребители";
}
//users
echo "<br />";
$query6 = mysql_query('SELECT * FROM phpbb_users WHERE user_type != 2 ORDER by user_regdate ASC');
while($row1 = mysql_fetch_assoc($query6)) {
{
$count6 = $row1['username'];
$count7 = $row1['user_colour'];
$count8 = $row1['user_id'];
}
}
echo "Най-нов: <a href='forum/memberlist.php?mode=viewprofile&u=$count8'><b style='color:#$count7'>{$count6}</b></a>";
//most active user
echo "<br />";
$query15 = mysql_query('SELECT * FROM phpbb_users ORDER by user_posts');
while($row4 = mysql_fetch_assoc($query15)) {
{
$count15 = $row4['username'];
$count16 = $row4['user_colour'];
$count17 = $row4['user_id'];
}
}
echo "Топ потребител: <a href='forum/memberlist.php?mode=viewprofile&u=$count17'><b style='color:#$count16'>{$count15}</b></a>";
//legends
echo "<br />";
$query4 = mysql_query("SELECT * FROM phpbb_groups WHERE (`group_name` != 'Bots' AND `group_name`!='GUESTS' AND `group_name`!='NEWLY_Регистрирани'
AND `group_name` !='Регистрирани_COPPA' AND `group_name` !='BOTS')");
echo '';
//last topic
echo "";
$query9 = mysql_query('SELECT * FROM phpbb_topics ORDER by topic_time ASC');
while($row2 = mysql_fetch_assoc($query9)) {
{
$count9 = $row2['topic_title'];
$count10 = $row2['topic_first_post_id'];
$count11 = $row2['forum_id'];
}
}
echo "Последна тема: <a href='forum/viewtopic.php?f=$count11&p=$count10'><b>{$count9}</b></a>";
//most active topic
echo "<br />";
$query12 = mysql_query('SELECT * FROM phpbb_topics ORDER by topic_replies');
while($row3 = mysql_fetch_assoc($query12)) {
{
$count12 = $row3['topic_title'];
$count13 = $row3['topic_first_post_id'];
$count14 = $row3['forum_id'];
}
}
echo "Най-активна тема: <a href='forum/viewtopic.php?f=$count14&p=$count13'><b>{$count12}</b></a>";
//online users
echo "<br />";
$query16=mysql_query("select * from `phpbb_sessions` s INNER JOIN phpbb_users u ON u.user_id = s.session_user_id WHERE session_user_id <> 1 AND (session_time + 300) > UNIX_TIMESTAMP(NOW())");
$count17 = mysql_num_rows($query16);
echo "Онлайн в момента: <b>$count17</b> потребителя";
?>
<br />
<hr />
<?php
$sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type
FROM ' . GROUPS_TABLE . ' g
LEFT JOIN ' . USER_GROUP_TABLE . ' ug
ON (
g.group_id = ug.group_id
AND ug.user_id = ' . $phpbb_user->data['user_id'] . '
AND ug.user_pending = 0
)
WHERE g.group_legend = 1
AND (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $phpbb_user->data['user_id'] . ')
ORDER BY g.group_name ASC';
$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
{
$colour_text = ($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . '"' : '';
$group_name = ($row['group_type'] == GROUP_SPECIAL) ? $phpbb_user->lang['G_' . $row['group_name']] : $row['group_name'];
if ($row['group_name'] == 'BOTS' || ($phpbb_user->data['user_id'] != ANONYMOUS && !$auth->acl_get('u_viewprofile')))
{
echo '<span' . $colour_text . '>' . $group_name . '</span>, ';
}
else
{
echo '<a' . $colour_text . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']) . '">' . $group_name . '</a><br /> ';
}
}
?>
</form>
<div style="padding-top: 5px;"></div>
<div style="padding-top: 3px;"></div>
</div>
<div class="r_menu_bottom"></div>
<div class="r_menu_cnt">
<div class="r_menubg">Анкета</div>
<?php require "inc/anketa.php"; ?>
</div>
<div class="r_menu_bottom"></div>