Jump to content
MakeWebGames

Function error

Syed

By Syed
in Game Support

 Share

Recommended Posts

Syed Newbie

Syed

Posted
Posted (edited)

I get an error saying:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/syedboyz/public_html/games/includes/functionsmini.php on line 9

and

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/syedboyz/public_html/games/includes/functionsmini.php on line 25

 

Functionsmini.php=

 

<?php
session_start(); 
include_once "db_connect.php";
$username=$_SESSION['username'];
echo "<link rel=stylesheet href=includes/in.css type=text/css>";

$query=mysql_query("SELECT * FROM user_info WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);
$num=mysql_num_rows("SELECT * FROM user_info WHERE userlevel='6'");
$don=mysql_num_rows(mysql_query("SELECT * FROM donaters WHERE username='$username'"));
$newmoney=round($info->money);
mysql_query("UPDATE `user_info` SET `money`='$newmoney' WHERE `username`='$username'");

///////////////////////////// If the User is dead kill the session and show him the dead page
$date = gmdate('Y-m-d h:i:s');
if ($info->status == "Dead"){
session_destroy();
echo "<meta http-equiv=\"refresh\" content=\"3;URL=dead.php\">";
exit();}
//////////////////////////////////////////// if Health is more than 100 set it back to 100
if ($info->health > 100){
mysql_query("UPDATE user_info SET health='100' WHERE username='$username'");}
/////////////////////////////////////// credit market
$checkcredit =mysql_query("SELECT * FROM creditsell");
while($credget= mysql_fetch_object($crew_check)){
if($credget->time < time()){
$creduser=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$credget->username'"));
$newpoints=$creduser->points+$credget->amount;
mysql_query("UPDATE `user_info` SET `points`='$newpoints' WHERE `username`='$credget->username'");
mysql_query("DELETE FROM `creditget` WHERE `id`='$credget->id'");
}}
////////////////////////// Crew Checking remove the dead
$crew_check =mysql_query("SELECT * FROM crews");
while($k = mysql_fetch_object($crew_check)){
$user=mysql_fetch_object(mysql_query("SELECT status FROM user_info WHERE username='$k->owner'"));
$rhm=mysql_fetch_object(mysql_query("SELECT status FROM user_info WHERE username='$k->rhm'"));
if ($user->status == "Dead" || $user->status == "Banned"){
mysql_query("UPDATE `user_info` SET `crew`='0' WHERE `crew`='$k->name'");
mysql_query("DELETE FROM crews WHERE name='$k->name'");}
if ($k->rhm != "0" && $rhm->status == "Alive"){
mysql_query("UPDATE crews SET owner='$k->rhm', rhm='0' WHERE name='$k->name'"); 
}
elseif ($rhm->status == "Dead" || $rhm->status == "Banned"){
mysql_query("UPDATE `user_info` SET `crew`='0' WHERE `crew`='$k->name'");
mysql_query("DELETE FROM crews WHERE name='$k->name'");
}}
/////////////////////////////////// If Oc players are dead!
$oc_query=mysql_query("SELECT * FROM oc");
while($ttfn = mysql_fetch_object($oc_query)){
$user_oc=mysql_fetch_object(mysql_query("SELECT status FROM user_info WHERE username='$ttfn->leader'"));
if ($user_oc->status == "Dead" || $user_oc->status == "Banned"){
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->we'");
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->ee'");
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->driver'");
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->leader'");
mysql_query("DELETE FROM oc WHERE id='$ttfn->id'");
}}
///////////////////////////////////////////////////////////
///////// function for logincheck()
function logincheck(){
if (empty($_SESSION['username'])){
echo "<meta http-equiv=\"refresh\" content=\"3;URL=error.php\">";
exit();
}}
////////////////////////////////////////
////UPDATE ONLINE
$time = time() + (60 * 10);
mysql_query("UPDATE user_info SET online='$time' WHERE username='$username'");
///FINSH UPDATING ONLINE
///////////////////// fuction for makecomma()
function makecomma($input){
if(strlen($input)<=3)
{return $input; }
$length=substr($input,0,strlen($input)-3);
$formatted_input = makecomma($length).",".substr($input,-3);
return $formatted_input;
}
////////////////////////////ranking check
function rankcheck(){
$username=$_SESSION['username'];
$query=mysql_query("SELECT * FROM user_info WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);
$date = gmdate('Y-m-d h:i:s');}
/////////////////////////////// now for the ranking info if a rankpoint is higher than it should be promote that user to the next.
//////////////////////////////////////////
if (($info->rank == "Begger") && ($info->rankpoints >= "100")){ $newrank="Scum Bag"; $done="1"; }
elseif (($info->rank == "Scum Bag") && ($info->rankpoints >= "200")){ $newrank="Chav"; $done="1"; }
elseif (($info->rank == "Chav") && ($info->rankpoints >= "300")){ $newrank="Thug"; $done="1"; }
elseif (($info->rank == "Thug") && ($info->rankpoints >= "500")){ $newrank="Theif"; $done="1"; }
elseif (($info->rank == "Theif") && ($info->rankpoints >= "900")){ $newrank="Gangster"; $done="1"; }
elseif (($info->rank == "Gangster") && ($info->rankpoints >= "1400")){ $newrank="Local Gangster"; $done="1"; }
elseif (($info->rank == "Local Gangster") && ($info->rankpoints >= "2300")){ $newrank="Boss"; $done="1"; }
elseif (($info->rank == "Boss") && ($info->rankpoints >= "3800")){ $newrank="Local Boss"; $done="1"; }
elseif (($info->rank == "Local Boss") && ($info->rankpoints >= "9300")){ $newrank="Don"; $done="1"; }
elseif (($info->rank == "Don") && ($info->rankpoints >= "15400")){ $newrank="Golbal Killer"; $done="1"; }
elseif (($info->rank == "Golbal Killer") && ($info->rankpoints >= "29300")){ $newrank="Goodfella"; $done="1"; }
elseif (($info->rank == "Goodfella") && ($info->rankpoints >= "42700")){ $newrank="Untouchable Goodfella"; $done="1"; }
elseif (($info->rank == "Untouchable Goodfella") && ($info->rankpoints >= "65000")){ $newrank="Godfather"; $done="1"; }
elseif (($info->rank == "Godfather") && ($info->rankpoints >= "98700")){ $newrank="Untouchable Godfather"; $done="1"; }
elseif (($info->rank == "Untouchable Godfather") && ($info->rankpoints >= "159700")){ $newrank="Legend"; $done="1"; }
elseif (($info->rank == "Legend") && ($info->rankpoints >= "258400")){
$newrank="Lock Down Legend"; $done="1"; }
elseif (($info->rank == "Lock Down Legend") && ($info->rankpoints >= "400000")){
$newrank="Offical Lock Down Legend"; $done="1"; }
elseif (($info->rank == "Offical Lock Down Legend") && ($info->rankpoints >= "620000")){
$newrank="lock Down Master"; $done="1"; }
elseif (($info->rank == "lock Down Master") && ($info->rankpoints >= "800000")){
$newrank="Offical Lock Down Master"; $done="1"; }
if (!$done){
$done="0";}
///////////////////////////////// update to the new rank
if ($done == "1"){
mysql_query("UPDATE user_info SET rank='$newrank' WHERE username='$username'");
/////////////// message the user telling them they have been promoted
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` ) 
VALUES (
'', '$username', '$username', 'You have been promoted to <b>$newrank</b> your doing well! ', '$date', '0', '0', '0'
)");}
////////////////////////////////////////////////////////////////////
rankcheck();
/////// if the time in jail as passed deleted the username.
$jail_check=mysql_query("SELECT username, time_left FROM jail");
while($monster=mysql_fetch_object($jail_check)){
if (time() > $monster->time_left){
mysql_query("DELETE FROM jail WHERE username='$monster->username'");
}}
//////////////////////////
/////////////////// make time function()
function maketime($last){
$timenow = time();
if($last>$timenow){
$order = $last-$timenow;
while($order >= 60){
$order = $order-60;
$ordermleft++;
}
while($ordermleft >= 60){
$ordermleft = $ordermleft-60;
$orderhleft++;
}

if($ordermleft == 0){
$ordermleft = "";
} else {
$ordermleft = "$ordermleft Minutes";
					}
if($orderhleft == 0){
$orderhleft = "";
} else {
$orderhleft = "$orderhleft Hours";
}	
return "$orderhleft $ordermleft $order Seconds";
}}
/////////////////////////////////////////////////
/////////////////////////////// update most online if it is more than the pervious
$most_online=mysql_fetch_object(mysql_query("SELECT online FROM site_stats WHERE id='1'"));
$timenow=time();
$now_online =mysql_num_rows(mysql_query("SELECT online FROM user_info WHERE online > '$timenow'"));
if ($now_online > $most_online->online){
mysql_query("UPDATE site_stats SET online='$now_online' WHERE id='1'");
}
////////////////// casino drops 
$drop =mysql_query("SELECT * FROM casinos");

while($tard=mysql_fetch_object($drop)){
$per = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard->owner'"));
if ($per->status == "Dead" || $per->status == "Banned"){
mysql_query("UPDATE casinos SET owner='0' WHERE casino='$tard->casino' AND owner='$tard->owner'");
}}
////////////////////////////////////////////////// Blackjack drop!
$drop_bj =mysql_query("SELECT * FROM bj");

while($tard_bj=mysql_fetch_object($drop_bj)){
$per_bj = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard_bj->bjowner'"));
if ($per_bj->status == "Dead" || $per_bj->status == "Banned"){
mysql_query("UPDATE bj SET bjowner='0' WHERE bjowner='$tard_bj->bjowner'");
}}
/////////////////////////////////////////////////////////////
////////// bullet stroe drop
$drop_bullet =mysql_query("SELECT owner FROM bullets ");
while($tard_bullet=mysql_fetch_object($drop_bullet)){
$per_bullet = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard_bullet->owner'"));
if ($per_bullet->status == "Dead" || $per_bullet->status == "Banned"){
mysql_query("UPDATE bullets SET owner='0' WHERE owner='$tard_bullet->owner'");
}}
///////////////////// armour drop
$drop_bullet2 =mysql_query("SELECT owner FROM armour");

while($tard_bullet2=mysql_fetch_object($drop_bullet2)){
$per_bullet2 = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard_bullet2->owner'"));
if ($per_bullet2->status == "Dead" || $per_bullet2->status == "Banned"){
mysql_query("UPDATE armour SET owner='0' WHERE owner='$tard_bullet2->owner'");
}}
///////////////////// weapons store
$drop_bullet3 =mysql_query("SELECT owner FROM Weapons");

while($tard_bullet3=mysql_fetch_object($drop_bullet3)){
$per_bullet3 = mysql_fetch_object(mysql_query("SELECT username, status FROM user_info WHERE username='$tard_bullet3->owner'"));
if ($per_bullet3->status == "Dead" || $per_bullet3->status == "Banned"){
mysql_query("UPDATE Weapons SET owner='0' WHERE owner='$tard_bullet3->owner'");
}}
//////////////////////// bank payout
if ($info->banktime <= time() && $info->bank > "0"){
$nmoney =  10 * $info->bank / 100;
$money_in = $info->bank + $nmoney;
$money_in= round($money_in); 
$recieve = $info->money + $money_in;
mysql_query("UPDATE user_info SET money = '$recieve', bank='0', banktime='0' WHERE username='$username'");
}
///////////////////////////////////
$user_info=mysql_fetch_object(mysql_query("SELECT jail_able, jail_untill FROM user_info WHERE username='$username'"));
if ($user_info->jail_able == "1" && $user_info->jail_untill <= time()){
mysql_query("UPDATE user_info SET jail_able='0' WHERE username='$username'");
}
/////////////////////////////////////////
/////////////////////// respect updates
$user_****=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$username'"));
if ($user_****->last_respect < time() && $fetch->rank != "Bitch"){
if ($info->rank == "chavers sister"){ $new_res="1"; }elseif($info->rank == "chav"){  $new_res="2"; }elseif($info->rank == "Thug"){  $new_res="3"; }elseif($info->rank == "joey"){  $new_res="4";    }elseif($info->rank == "Gangster"){  $new_res="5";   }elseif($info->rank == "Soild Gangster"){  $new_res="6";  }elseif($info->rank == "Boss"){  $new_res="7";
}elseif($info->rank == "Soild Boss"){  $new_res="8"; }elseif($info->rank == "Don"){  $new_res="9"; }elseif($info->rank == "Golbal Scare"){  $new_res="10"; }elseif($info->rank == "Goodfella"){  $new_res="11"; }elseif($info->rank == "Respectable Goodfella"){  $new_res="12"; }elseif($info->rank == "Godfather"){$new_res="13"; }elseif($info->rank =="Respectable Godfather"){$new_res="14"; }elseif($info->rank == "Legend"){$new_res="15"; }elseif($info->rank == "Offical GH legend"){$new_res="16";}elseif($info->rank == "Boss"){$new_res="17";}elseif($info->rank == "Godfather")
{$new_res="18";}elseif($info->rank == "Don"){$new_res="19";}elseif($info->rank == "Bosses of Boss"){$new_res="20";}elseif($info->rank == "Mob Boss"){$new_res="21";}elseif($info->rank == "WarGod"){$new_res="22";}elseif($info->rank == "Slayer"){$new_res="23";}elseif($info->rank == "Messiah"){$new_res="24";}elseif($info->rank == "Supreme Being
"){$new_res="25";}elseif($info->rank == "God"){$new_res="26";}
$now=time() + (3600 * 24 * 7);
mysql_query("UPDATE user_info SET respect='$new_res', last_respect='$now' WHERE username='$username'");}
//////////////////////////////////////////////////////////////////////////////////////////////////////
?>

 

Thats the full code for functionsmini.php[/php]

could some one tell me the fix, and also explain to me why?

Edited by Syed
Syed Newbie

Syed

Posted
  • Author
Posted
Could be a number of reasons. Post more of the code.
<?php
session_start(); 
include_once "db_connect.php";
$username=$_SESSION['username'];
echo "<link rel=stylesheet href=includes/in.css type=text/css>";
$query=mysql_query("SELECT * FROM user_info WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);
$num=mysql_num_rows("SELECT * FROM user_info WHERE userlevel='6'");
$don=mysql_num_rows(mysql_query("SELECT * FROM donaters WHERE username='$username'"));
$newmoney=round($info->money);
mysql_query("UPDATE `user_info` SET `money`='$newmoney' WHERE `username`='$username'");
Syed Newbie

Syed

Posted
  • Author
Posted 
<?php
session_start(); 
include_once "db_connect.php";
$username=$_SESSION['username'];
echo "<link rel=stylesheet href=includes/in.css type=text/css>";

$query=mysql_query("SELECT * FROM user_info WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);
$num=mysql_num_rows("SELECT * FROM user_info WHERE userlevel='6'");
$don=mysql_num_rows(mysql_query("SELECT * FROM donaters WHERE username='$username'"));
$newmoney=round($info->money);
mysql_query("UPDATE `user_info` SET `money`='$newmoney' WHERE `username`='$username'");

///////////////////////////// If the User is dead kill the session and show him the dead page
$date = gmdate('Y-m-d h:i:s');
if ($info->status == "Dead"){
session_destroy();
echo "<meta http-equiv=\"refresh\" content=\"3;URL=dead.php\">";
exit();}
//////////////////////////////////////////// if Health is more than 100 set it back to 100
if ($info->health > 100){
mysql_query("UPDATE user_info SET health='100' WHERE username='$username'");}
/////////////////////////////////////// credit market
$checkcredit =mysql_query("SELECT * FROM creditsell");
while($credget= mysql_fetch_object($crew_check)){
if($credget->time < time()){
$creduser=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$credget->username'"));
$newpoints=$creduser->points+$credget->amount;
mysql_query("UPDATE `user_info` SET `points`='$newpoints' WHERE `username`='$credget->username'");
mysql_query("DELETE FROM `creditget` WHERE `id`='$credget->id'");
}}
////////////////////////// Crew Checking remove the dead
$crew_check =mysql_query("SELECT * FROM crews");
while($k = mysql_fetch_object($crew_check)){
$user=mysql_fetch_object(mysql_query("SELECT status FROM user_info WHERE username='$k->owner'"));
$rhm=mysql_fetch_object(mysql_query("SELECT status FROM user_info WHERE username='$k->rhm'"));
if ($user->status == "Dead" || $user->status == "Banned"){
mysql_query("UPDATE `user_info` SET `crew`='0' WHERE `crew`='$k->name'");
mysql_query("DELETE FROM crews WHERE name='$k->name'");}
if ($k->rhm != "0" && $rhm->status == "Alive"){
mysql_query("UPDATE crews SET owner='$k->rhm', rhm='0' WHERE name='$k->name'"); 
}
elseif ($rhm->status == "Dead" || $rhm->status == "Banned"){
mysql_query("UPDATE `user_info` SET `crew`='0' WHERE `crew`='$k->name'");
mysql_query("DELETE FROM crews WHERE name='$k->name'");
}}
/////////////////////////////////// If Oc players are dead!
$oc_query=mysql_query("SELECT * FROM oc");
while($ttfn = mysql_fetch_object($oc_query)){
$user_oc=mysql_fetch_object(mysql_query("SELECT status FROM user_info WHERE username='$ttfn->leader'"));
if ($user_oc->status == "Dead" || $user_oc->status == "Banned"){
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->we'");
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->ee'");
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->driver'");
mysql_query("UPDATE user_info SET oc='0' WHERE username='$ttfn->leader'");
mysql_query("DELETE FROM oc WHERE id='$ttfn->id'");
}}
///////////////////////////////////////////////////////////
///////// function for logincheck()
function logincheck(){
if (empty($_SESSION['username'])){
echo "<meta http-equiv=\"refresh\" content=\"3;URL=error.php\">";
exit();
}}
////////////////////////////////////////
////UPDATE ONLINE
$time = time() + (60 * 10);
mysql_query("UPDATE user_info SET online='$time' WHERE username='$username'");
///FINSH UPDATING ONLINE
///////////////////// fuction for makecomma()
function makecomma($input){
if(strlen($input)<=3)
{return $input; }
$length=substr($input,0,strlen($input)-3);
$formatted_input = makecomma($length).",".substr($input,-3);
return $formatted_input;
}
////////////////////////////ranking check
function rankcheck(){
$username=$_SESSION['username'];
$query=mysql_query("SELECT * FROM user_info WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);
$date = gmdate('Y-m-d h:i:s');}
/////////////////////////////// now for the ranking info if a rankpoint is higher than it should be promote that user to the next.
//////////////////////////////////////////
if (($info->rank == "Begger") && ($info->rankpoints >= "100")){ $newrank="Scum Bag"; $done="1"; }
elseif (($info->rank == "Scum Bag") && ($info->rankpoints >= "200")){ $newrank="Chav"; $done="1"; }
elseif (($info->rank == "Chav") && ($info->rankpoints >= "300")){ $newrank="Thug"; $done="1"; }
elseif (($info->rank == "Thug") && ($info->rankpoints >= "500")){ $newrank="Theif"; $done="1"; }
elseif (($info->rank == "Theif") && ($info->rankpoints >= "900")){ $newrank="Gangster"; $done="1"; }
elseif (($info->rank == "Gangster") && ($info->rankpoints >= "1400")){ $newrank="Local Gangster"; $done="1"; }
elseif (($info->rank == "Local Gangster") && ($info->rankpoints >= "2300")){ $newrank="Boss"; $done="1"; }
elseif (($info->rank == "Boss") && ($info->rankpoints >= "3800")){ $newrank="Local Boss"; $done="1"; }
elseif (($info->rank == "Local Boss") && ($info->rankpoints >= "9300")){ $newrank="Don"; $done="1"; }
elseif (($info->rank == "Don") && ($info->rankpoints >= "15400")){ $newrank="Golbal Killer"; $done="1"; }
elseif (($info->rank == "Golbal Killer") && ($info->rankpoints >= "29300")){ $newrank="Goodfella"; $done="1"; }
elseif (($info->rank == "Goodfella") && ($info->rankpoints >= "42700")){ $newrank="Untouchable Goodfella"; $done="1"; }
elseif (($info->rank == "Untouchable Goodfella") && ($info->rankpoints >= "65000")){ $newrank="Godfather"; $done="1"; }
elseif (($info->rank == "Godfather") && ($info->rankpoints >= "98700")){ $newrank="Untouchable Godfather"; $done="1"; }
elseif (($info->rank == "Untouchable Godfather") && ($info->rankpoints >= "159700")){ $newrank="Legend"; $done="1"; }
elseif (($info->rank == "Legend") && ($info->rankpoints >= "258400")){
$newrank="Lock Down Legend"; $done="1"; }
elseif (($info->rank == "Lock Down Legend") && ($info->rankpoints >= "400000")){
$newrank="Offical Lock Down Legend"; $done="1"; }
elseif (($info->rank == "Offical Lock Down Legend") && ($info->rankpoints >= "620000")){
$newrank="lock Down Master"; $done="1"; }
elseif (($info->rank == "lock Down Master") && ($info->rankpoints >= "800000")){
$newrank="Offical Lock Down Master"; $done="1"; }
if (!$done){
$done="0";}
///////////////////////////////// update to the new rank
if ($done == "1"){
mysql_query("UPDATE user_info SET rank='$newrank' WHERE username='$username'");
/////////////// message the user telling them they have been promoted
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` ) 
VALUES (
'', '$username', '$username', 'You have been promoted to <b>$newrank</b> your doing well! ', '$date', '0', '0', '0'
)");}
////////////////////////////////////////////////////////////////////
rankcheck();
/////// if the time in jail as passed deleted the username.
$jail_check=mysql_query("SELECT username, time_left FROM jail");
while($monster=mysql_fetch_object($jail_check)){
if (time() > $monster->time_left){
mysql_query("DELETE FROM jail WHERE username='$monster->username'");
}}
//////////////////////////
/////////////////// make time function()
function maketime($last){
$timenow = time();
if($last>$timenow){
$order = $last-$timenow;
while($order >= 60){
$order = $order-60;
$ordermleft++;
}
while($ordermleft >= 60){
$ordermleft = $ordermleft-60;
$orderhleft++;
}

if($ordermleft == 0){
$ordermleft = "";
} else {
$ordermleft = "$ordermleft Minutes";
					}
if($orderhleft == 0){
$orderhleft = "";
} else {
$orderhleft = "$orderhleft Hours";
}	
return "$orderhleft $ordermleft $order Seconds";
}}
/////////////////////////////////////////////////
/////////////////////////////// update most online if it is more than the pervious
$most_online=mysql_fetch_object(mysql_query("SELECT online FROM site_stats WHERE id='1'"));
$timenow=time();
$now_online =mysql_num_rows(mysql_query("SELECT online FROM user_info WHERE online > '$timenow'"));
if ($now_online > $most_online->online){
mysql_query("UPDATE site_stats SET online='$now_online' WHERE id='1'");
}
////////////////// casino drops 
$drop =mysql_query("SELECT * FROM casinos");

while($tard=mysql_fetch_object($drop)){
$per = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard->owner'"));
if ($per->status == "Dead" || $per->status == "Banned"){
mysql_query("UPDATE casinos SET owner='0' WHERE casino='$tard->casino' AND owner='$tard->owner'");
}}
////////////////////////////////////////////////// Blackjack drop!
$drop_bj =mysql_query("SELECT * FROM bj");

while($tard_bj=mysql_fetch_object($drop_bj)){
$per_bj = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard_bj->bjowner'"));
if ($per_bj->status == "Dead" || $per_bj->status == "Banned"){
mysql_query("UPDATE bj SET bjowner='0' WHERE bjowner='$tard_bj->bjowner'");
}}
/////////////////////////////////////////////////////////////
////////// bullet stroe drop
$drop_bullet =mysql_query("SELECT owner FROM bullets ");
while($tard_bullet=mysql_fetch_object($drop_bullet)){
$per_bullet = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard_bullet->owner'"));
if ($per_bullet->status == "Dead" || $per_bullet->status == "Banned"){
mysql_query("UPDATE bullets SET owner='0' WHERE owner='$tard_bullet->owner'");
}}
///////////////////// armour drop
$drop_bullet2 =mysql_query("SELECT owner FROM armour");

while($tard_bullet2=mysql_fetch_object($drop_bullet2)){
$per_bullet2 = mysql_fetch_object(mysql_query("SELECT username,status FROM user_info WHERE username='$tard_bullet2->owner'"));
if ($per_bullet2->status == "Dead" || $per_bullet2->status == "Banned"){
mysql_query("UPDATE armour SET owner='0' WHERE owner='$tard_bullet2->owner'");
}}
///////////////////// weapons store
$drop_bullet3 =mysql_query("SELECT owner FROM Weapons");

while($tard_bullet3=mysql_fetch_object($drop_bullet3)){
$per_bullet3 = mysql_fetch_object(mysql_query("SELECT username, status FROM user_info WHERE username='$tard_bullet3->owner'"));
if ($per_bullet3->status == "Dead" || $per_bullet3->status == "Banned"){
mysql_query("UPDATE Weapons SET owner='0' WHERE owner='$tard_bullet3->owner'");
}}
//////////////////////// bank payout
if ($info->banktime <= time() && $info->bank > "0"){
$nmoney =  10 * $info->bank / 100;
$money_in = $info->bank + $nmoney;
$money_in= round($money_in); 
$recieve = $info->money + $money_in;
mysql_query("UPDATE user_info SET money = '$recieve', bank='0', banktime='0' WHERE username='$username'");
}
///////////////////////////////////
$user_info=mysql_fetch_object(mysql_query("SELECT jail_able, jail_untill FROM user_info WHERE username='$username'"));
if ($user_info->jail_able == "1" && $user_info->jail_untill <= time()){
mysql_query("UPDATE user_info SET jail_able='0' WHERE username='$username'");
}
/////////////////////////////////////////
/////////////////////// respect updates
$user_****=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$username'"));
if ($user_****->last_respect < time() && $fetch->rank != "Bitch"){
if ($info->rank == "chavers sister"){ $new_res="1"; }elseif($info->rank == "chav"){  $new_res="2"; }elseif($info->rank == "Thug"){  $new_res="3"; }elseif($info->rank == "joey"){  $new_res="4";    }elseif($info->rank == "Gangster"){  $new_res="5";   }elseif($info->rank == "Soild Gangster"){  $new_res="6";  }elseif($info->rank == "Boss"){  $new_res="7";
}elseif($info->rank == "Soild Boss"){  $new_res="8"; }elseif($info->rank == "Don"){  $new_res="9"; }elseif($info->rank == "Golbal Scare"){  $new_res="10"; }elseif($info->rank == "Goodfella"){  $new_res="11"; }elseif($info->rank == "Respectable Goodfella"){  $new_res="12"; }elseif($info->rank == "Godfather"){$new_res="13"; }elseif($info->rank =="Respectable Godfather"){$new_res="14"; }elseif($info->rank == "Legend"){$new_res="15"; }elseif($info->rank == "Offical GH legend"){$new_res="16";}elseif($info->rank == "Boss"){$new_res="17";}elseif($info->rank == "Godfather")
{$new_res="18";}elseif($info->rank == "Don"){$new_res="19";}elseif($info->rank == "Bosses of Boss"){$new_res="20";}elseif($info->rank == "Mob Boss"){$new_res="21";}elseif($info->rank == "WarGod"){$new_res="22";}elseif($info->rank == "Slayer"){$new_res="23";}elseif($info->rank == "Messiah"){$new_res="24";}elseif($info->rank == "Supreme Being
"){$new_res="25";}elseif($info->rank == "God"){$new_res="26";}
$now=time() + (3600 * 24 * 7);
mysql_query("UPDATE user_info SET respect='$new_res', last_respect='$now' WHERE username='$username'");}
//////////////////////////////////////////////////////////////////////////////////////////////////////
?>

 

Thats the full code for functionsmini.php

Djkanna Apprentice

Djkanna

Posted
Posted
Sorry ....ive been caught by DJK for pulling your leg!

Muahahaha.

Run the query first; then pass the result to mysql_num_rows(); in this case $num = mysql_num_rows(mysql_query( ... ));

  • 2 weeks later...
Primed Newbie

Primed

Posted
Posted

You don't appear to have got a fix yet, incase you haven't done it yourself, the following will work (probably)

 

Change:

$num=mysql_num_rows("SELECT * FROM user_info WHERE userlevel='6'");

 

To:

$num_query= mysql_query("SELECT * FROM user_info WHERE userlevel='6'");
$num = mysql_num_rows($num_query);

 

The error on line 25 isn't as straightforward.. 

while($credget= mysql_fetch_object($crew_check)){

The "$crew_check" variable isn't mentioned before this, so perhaps you meant

while($credget= mysql_fetch_object($checkcredit))

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...