Function error

Syed · July 18, 2012

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 July 18, 2012 by Syed

rulerofzu · July 18, 2012

Could be a number of reasons. Post more of the code.

Syed · July 18, 2012

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'");

rulerofzu · July 18, 2012

Whats line 7 and 8 seen as the error is on line 9 and what engine is it from?

Syed · July 18, 2012

<?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

rulerofzu · July 18, 2012

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

Djkanna · July 18, 2012

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( ... ));

Syed · July 18, 2012

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

?

what dya mean pal?

rulerofzu · July 18, 2012

Your spoiling my fun DJK :P

Primed · July 27, 2012

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))

Sign In

Function error

Recommended Posts

Syed

Link to comment

Share on other sites

rulerofzu

Link to comment

Share on other sites

Syed

Link to comment

Share on other sites

rulerofzu

Link to comment

Share on other sites

Syed

Link to comment

Share on other sites

rulerofzu

Link to comment

Share on other sites

Djkanna

Link to comment

Share on other sites

Syed

Link to comment

Share on other sites

rulerofzu

Link to comment

Share on other sites

Primed

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Hosting

Marketplace