phpBB2 by Przemo

IceCold · **Pomógł:** 5 razy Posty: 100

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 ...

Gadatliwa Kasia

NineX · **Pomógł:** 546 razy Posty: 1983

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 · **Pomógł:** 5 razy Posty: 100

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 · **Pomógł:** 1411 razy Posty: 4780

IceCold · **Pomógł:** 5 razy Posty: 100

Tommekk80, sprawdzałem, działało, ale wolałem się upewnić by wszystko grało jak należy heh... :roll:

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ąć