Help to solve error needed

[lynm77]

Hello All

I have just added sms notifications to mccodes v2

But when i installed i get the following error from pages

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/swisou/public_html/global_func.php on line 561

I have attached the following lines below to see if someone can help me please.

All solved

Thank you all

Edited June 4, 2012 by lynm77

[Seker]

Hello All

I have just added sms notifications to mccodes v2

But when i installed i get the following error from pages

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/swisou/public_html/global_func.php on line 561

I have attached the following lines below to see if someone can help me please.

559.

560. $blah=mysql_query("SELECT * FROM users WHERE userid=$user",$c);

561. $r=mysql_fetch_array($blah);

562. if($type == 1 && $r['phoneon'] == 1)

563. {

564. $Name = "$gamename"; //senders name

 

Thank you

Change

$blah=mysql_query("SELECT * FROM users WHERE userid=$user",$c);

 

To

$blah=mysql_query("SELECT * FROM users WHERE userid=$userid",$c);

[Lithium]

SMS notification... that seems a Cronus paid mod! Contact him, or wait for him to reply, as you should not post the code!

[lynm77]

Don't fancy waiting a week for support.

But thanks to help.

Chhers

[sniko]

May wish to optimize that query, or use the pre-defined $ir ?