05-18-2010, 09:37 PM
Hello, im having trouble figuring this out. I have a mod in phpBB called Ultimate Points, and I want to intergrate it with THT. I found this little snippet of code in the p2h.php and im wondering, how do I replace posts with points.
The snippet:
And the sql table for the counting of the points is in the users table. Can anyone make edits.
The snippet:
PHP Code:
case "phpbb":
$n = 0;
$result = mysql_query("SELECT * FROM `{$prefix}users` WHERE username = '{$fuser}'", $this->con);
$mem = mysql_fetch_array($result);
$select = mysql_query("SELECT * FROM {$prefix}posts WHERE `poster_id` = '{$mem['user_id']}'", $this->con);
while($data2 = mysql_fetch_array($select)) {
$date = explode(":", strftime("%m:%y" ,$data2['post_time']));
if($nmonth <= $date[0] && $nyear <= $date[1]) {
$n++;
}
}
break;
And the sql table for the counting of the points is in the users table. Can anyone make edits.