hij geeft deze foutmelding aan:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jtouwen/domains/2pacparadise.com/public_html/site/top10.php on line 32
Wanneer ontstond het probleem? vandaag 11/12
Adres van je forum: http://2pacparadise.com/site/
Directe link naar de modification: http://www.phpbbhacks.com/download/3095
phpBB versie: 2.0.21
Heb je onlangs een andere mod of stijl geïnstalleerd? ja best veel
Heb je gezocht naar een antwoord? ja, op google en phpbb forums afgezocht, maar de zoekwoorden zijn te moeilijk om te vinden
hier is de code van de top 10 posters.
top10.php:
Code: Selecteer alles
<?
/**
* Mod Title: Top 10 Posters
* Mod Version: phpBB 2.0.4
* Author: Charlie Page
* Description: Shows the top 10 posters at your board
* Release: v1.0, 05.31.2004
***
* Demo: http://www.xboxassassin.com/e3/forums
* Installation Level: Easy
* Installation Time: 2 minutes
* Files To Edit: This one
* Included Files: top10.php
***
* Installation Notes:
* Upload this file and set $ppath, change the prefix and $url,
* Include this into a page and your done!
*/
$url = "http://www.2pacparadise.com/site/"; // No trailing slash
$ppath = "../secured/config.php"; // Physical path to the config.php file
if(empty($count))
//-----------------[ DO NOT EDIT BELOW HERE ]-------------------------
include_once("$ppath");
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection");
@mysql_select_db("$dbname",$db) or die("here we die");
echo "<table cellspacing=\"3\" cellpadding=\"5\" border=\"0\" align=\"center\"><tr><td><b>Username</b></td><td><b>Posts</b></td><td><b>Topics</b></td></tr>";
$query="SELECT * FROM gocms2_users ORDER BY `user_posts` DESC LIMIT 0, 10";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$username = "$row[username]";
$id = "$row[user_id]";
if ($row[user_id] == "-1") {
} else {
$query2 = mysql_query("SELECT * FROM gocms2_topics WHERE topic_poster='$id'") or die(mysql_error());
$num = mysql_num_rows($query2);
echo "<tr><td><a href=\"$url/profile.php?mode=viewprofile&u=$row[user_id]\"><center>$row[username]</center></a></td><td><center>$row[user_posts]</center></td><td>$num</td></tr>";
}
}
?>