Problem z modyfikacją - Nie dzia?aj? statystyki top5 by lui
IceCold - 07-11-2013, 20:35
Temat postu: Nie działają statystyki top5 by lui
Witam, chce dodać statystyki top5, lecz gdy dodaje zawartość do index.php mam takie błędy ... :
Modyfikacja + edytowałem że można zwijać tabelki oraz dodany avek: http://www.przemo.org/php...pic.php?t=69528
| Kod: | Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 554
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 554
Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 581
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 581
Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 620
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 620
Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 660
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 660
Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 675
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 675
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/onlyshot/public_html/index.php on line 678
Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 711
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 711
Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 752
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 752
Warning: mysql_query() [function.mysql-query]: Access denied for user 'onlyshot'@'localhost' (using password: NO) in /home/onlyshot/public_html/index.php on line 791
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/onlyshot/public_html/index.php on line 791 |
Dziwny błąd, nie wiem naprawdę o co chodzi ...
NineX - 07-11-2013, 20:40
IceCold, zapewne masz wersję 1.12.8 i korzystasz z modułu mysqli, a więc zastosowany czysty mysql_query w modyfikacji nie zadziała - musi być koniecznie $db->sql_query.
IceCold - 07-11-2013, 20:56
NineX, za bardzo się na tym nie znam, więc co powinienem zmienić? Nie jestem pewien, ale chodzi może o to:
$result = mysql_query($sql); trzeba zamienić na: $result = $db->sql_query($sql); ?
cały kod:
| Kod: | //Najlepszy moderator
$sql = "SELECT COUNT(*) AS 'how_many', b.username, b.user_id, b.user_level, b.user_jr, b.user_avatar, b.user_avatar_type, b.user_avatar
FROM " . LOGS_TABLE . " a, " . USERS_TABLE . " b
WHERE b.user_id=a.user_id
GROUP BY b.username, b.user_id, b.user_level, b.user_jr
ORDER BY how_many DESC
LIMIT 5";
$most_active = $db->sql_query($sql);
$i=0;
while ($row = $db->sql_fetchrow($most_active))
{
$colored_username = color_username($row['user_level'], $row['user_jr'], $row['user_id'], $row['username']);
$row_user_name = $colored_username[0];
$i++;
$who = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '" class="gensmall"' . $colored_username[1] . '>' . $row_user_name . '</a>';
$how_many = '' . $row['how_many'] . '';
$colored_username = color_username($row['user_level'], $row['user_jr'], $row['user_id'], $row['username']);
$row_user_name = $colored_username[0];
$userAvatar = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $row['user_id']) . '" ><img src="images/noavatar.png" alt="avatar" border="0" width="25" heigh="25" /></a>'; //avatar domyslny
if ( $row['user_avatar_type'] == USER_AVATAR_UPLOAD)
{
$userAvatar = ( $board_config['allow_avatar_upload'] ) ? '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $row['user_id']) . '" ><img src="' . $board_config['avatar_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" width="25" height="25" /></a>' : '';
}
if ( $row['user_avatar_type'] == USER_AVATAR_REMOTE)
{
$userAvatar = ( $board_config['allow_avatar_remote'] ) ? '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $row['user_id']) . '" ><img src="' . $row['user_avatar'] . '" alt="" border="0" width="25" height="25" /></a>' : '';
}
if ( $row['user_avatar_type'] == USER_AVATAR_GALLERY)
{
$userAvatar = ( $board_config['allow_avatar_local'] ) ? '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $row['user_id']) . '" ><img src="' . $board_config['avatar_gallery_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" width="25" height="25" /></a>' : '';
}
$template->assign_block_vars('mod', array(
'LI' => $i+0,
'WHO' => $who,
'ROW_CLASS' => (!($i % 2)) ? $theme['td_class2'] : $theme['td_class1'],
'AVATAR' => $userAvatar,
'HOW_MANY' => $how_many)
);
} |
Tommekk80 - 07-11-2013, 21:04
| IceCold napisał/a: | | $result = mysql_query($sql); trzeba zamienić na: $result = $db->sql_query($sql); |
A sprawdzałeś? Tak, to masz zamienić.
IceCold - 07-11-2013, 22:34
Tommekk80, sprawdzałem, działało, ale wolałem się upewnić by wszystko grało jak należy heh... 
Pozostaje tylko to: while($row = mysql_fetch_assoc($result))
| Kod: | | Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/onlyshot/public_html/index.php on line 678 |
Dałem rade, już działa  można zamknąć
|
|
|
