Help with referral system errors!!!!

[Habbz96]

Hi,
Im fixing up an automatic referral system but am stuck on one thing which ive been trying to fix for days now.

So the code is:

if(!empty($_SESSION['refer'])){
$execute = $db->query("UPDATE users SET refer_count = refer_count + '1' WHERE username = '".$this->filtertext($_SESSION['refer'])."' LIMIT 1");
}
header("LOCATION: ". PATH ."/me.php");
return true;

The bit I highlighted in red is the problem, I forced PHP to display errors and the following errors displayed:

Notice: Undefined variable: db in C:\xampp\htdocs\inc\functions.php on line 438

Fatal error: Call to a member function query() on null in C:\xampp\htdocs\inc\functions.php on line 438

If you can help me fix this error I would greatly appreciate it, Thank You!!!!

- - - Updated - - -

Someone please help me ASAP!!!!

[MentaL]

[mateuscm]

Hi,
Im fixing up an automatic referral system but am stuck on one thing which ive been trying to fix for days now.

So the code is:

if(!empty($_SESSION['refer'])){
$execute = $db->query("UPDATE users SET refer_count = refer_count + '1' WHERE username = '".$this->filtertext($_SESSION['refer'])."' LIMIT 1");
}
header("LOCATION: ". PATH ."/me.php");
return true;

The bit I highlighted in red is the problem, I forced PHP to display errors and the following errors displayed:

Notice: Undefined variable: db in C:\xampp\htdocs\inc\functions.php on line 438

Fatal error: Call to a member function query() on null in C:\xampp\htdocs\inc\functions.php on line 438

If you can help me fix this error I would greatly appreciate it, Thank You!!!!

- - - Updated - - -

Someone please help me ASAP!!!!

Sorry, I've been out for a while, can you pastebin the functions.php again?

[Habbz96]

http://pastebin.com/6hqt8faP

[mateuscm]

http://pastebin.com/6hqt8faP

This might be your lucky day amigo!

Replace this (Lines 437- 439)

if(!empty($_SESSION['refer'])){                                                $execute = $db->query("UPDATE users SET refer_count = refer_count + '1' WHERE username = '".$this->filtertext($_SESSION['refer'])."' LIMIT 1");                                        } 

To this:

if(!empty($_SESSION['refer'])){
global $db;
$execute=$db->query("UPDATE users SET refer_count = refer_count + '1' WHERE username = '".$this->filtertext($_SESSION['refer'])."' LIMIT 1");
} 

Best of luck!

[Habbz96]

OMG, THANK YOU SO MUCH IT WORKS, I CANT THANK YOU ENOUGH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU,

[mateuscm]

OMG, THANK YOU SO MUCH IT WORKS, I CANT THANK YOU ENOUGH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU,

It's only a matter of identifying the error haha

Have an awesome time, cheers