Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Show Site Donators Icon In Forums

Hey guys,

I searched the forums for the answer to this question, but didn't find an answer. So I apologize if I missed it.

I'm using Telli's killer donate mod and would like to show an icon near the user's avatar in the forums if they're a donator (very similar to how it's listed here). I think I've got the sql query down right, but I'm not sure what files I need to edit to get it to work.

Here's the code I've written so far, just not sure what to do with it...I could be WAY off:

global $db, $prefix, $user, $userinfo;
$user_id = intval($user_id);

$donator = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_donators WHERE donshow = 1 AND uid = $user_id"));

if ($donator > 0) {
$site_donator = "GV Site Donator!";
} else {
$site_donator = "";
}

Well, looks like I'm way off because it's returning the text for every user.

So I said to myself..."Self? Can we figure something out?"

Okay, well I love this site so much that I keep notes here sometimes as I go along, so thanks for hangin' in there with me.

Here's what I've done so far.

Using the CZUser-Info block, I edited the code as follows:

Around line 101, I removed "//" from before the line to activate the code

$uid = intval($session['user_id']);