Help with small problem I am having!.

[Razor42]

Basically I have added this to glob_funcs:

function drinking_check()
{
$thug = mysql_query("SELECT `drinking_lvl`,`drinking_exp`,`drinking_expneed` FROM `users` WHERE (`userid`=".$_SESSION['userid'].")");
$s = mysql_fetch_array($thug);

$s['drinking_expneeded']=(int) (($s['drinking_lvl']+1)*($s['drinking_lvl']+1)*($s['drinking_lvl']+1)*2.2);
if($s['drinking_exp'] >= $s['drinking_expneed'])
{
$expu=$s['drinking_exp']-$s['drinking_expneed'];
$s['drinking_lvl']+=1;
$s['drinking_exp']=$expu;
$s['drunk_max']=+15;
mysql_query("UPDATE `users` SET `drinking_lvl`=`drinking_lvl`+1,`drinking_exp`=$expu WHERE (`userid`=".$_SESSION['userid'].")");
}
}

 

This code is to check that if they have reached the exp needed then they advance to the next level but currently when they reach the needed exp they do not advance a level instead they just stay at the same level and there exp just keeps going up.

[Infamous]

As I never used mccodes,

I believe its something to do with this part.

 

mysql_query("UPDATE `users` SET `drinking_lvl`=`drinking_lvl`+1,`drinking_exp`=$ex  pu WHERE (`userid`=".$_SESSION['userid'].")");
}
}

[Razor42]

Yeah I changed it to the $db->query which it should be but still nothing.

[Infamous]

function drinking_check()
{
$thug = $db->query("SELECT `drinking_lvl`,`drinking_exp`,`drinking_expneed` FROM `users` WHERE (`userid`=".$_SESSION['userid'].")");
$r =$db_fetch_row($thug);

$s['drinking_expneeded']=(int) (($s['drinking_lvl']+1)*($s['drinking_lvl']+1)*($r['drinking_lvl']+1)*2.2);
if($r['drinking_exp'] >= $r['drinking_expneed'])
{
$expu=$s['drinking_exp']-$s['drinking_expneed'];
$r['drinking_lvl']+=1;
$r['drinking_exp']=$expp;
$r['drunk_max']=+15;
$db->query("UPDATE `users` SET `drinking_lvl`=`drinking_lvl`+1,`drinking_exp`=$expp WHERE (`userid`=".$_SESSION['userid'].")");
}
}

 

Try this?

Edited December 22, 2012 by Infamous
Mistake made.

[Razor42]

Tried that bud

[Infamous]

Post update,

[Razor42]

Nope nothing

[Infamous]

Sorry bud, dont know whats wrong. An sorry for wasting your time.

[Razor42]

Not wasting my time at all, thanks for the help mate.

[URBANZ]

in your main globals u need to add the function or how else will it check like this drinking_check(); add in your globals

[Someone]

Think urban mafi is on to something there.

In general when debugging. It can be useful to do something like this

 

function drinking_check()
{
$thug = mysql_query("SELECT `drinking_lvl`,`drinking_exp`,`drinking_expneed` FROM `users` WHERE (`userid`=".$_SESSION['userid'].")");
echo "SELECT `drinking_lvl`,`drinking_exp`,`drinking_expneed` FROM `users` WHERE (`userid`=".$_SESSION['userid'].")";
$s = mysql_fetch_array($thug);

print_r($s);

$s['drinking_expneeded']=(int) (($s['drinking_lvl']+1)*($s['drinking_lvl']+1)*($s['drinking_lvl']+1)*2.2);
if($s['drinking_exp'] >= $s['drinking_expneed'])
{
echo '$s[\'drinking_exp\'] >= $s[\'drinking_expneed\'] is true';
$expu=$s['drinking_exp']-$s['drinking_expneed'];
$s['drinking_lvl']+=1;
$s['drinking_exp']=$expu;
$s['drunk_max']=+15;
mysql_query("UPDATE `users` SET `drinking_lvl`=`drinking_lvl`+1,`drinking_exp`=$ex  pu WHERE (`userid`=".$_SESSION['userid'].")");

echo "UPDATE `users` SET `drinking_lvl`=`drinking_lvl`+1,`drinking_exp`=$ex  pu WHERE (`userid`=".$_SESSION['userid'].")";
// or do 
// mysql_query("UPDATE `users` SET `drinking_lvl`=`drinking_lvl`+1,`drinking_exp`=$ex  pu WHERE (`userid`=".$_SESSION['userid'].")") or die(mysql_error());
}
}

Edited December 22, 2012 by Someone

[Dayo]

 `drinking_lvl`=`drinking_lvl`+1,`drinking_exp`=$ex  pu 

try removing the space between the '$ex' and 'pu'

Edited December 22, 2012 by Dayo

[Razor42]

The space isn't there on the file on the server for some reason it was just added when I uploaded the code here. Like Urban said I think it needs adding to globals not glob_funcs. Ill give it a try when I get on my laptop

[Razor42]

Problem has been fixed, thaanks for everyones help.