Jump to content

[SOLVED] Error in my script??

i3lack

By i3lack
in MySQL Help

 Share

Recommended Posts

i3lack Newbie

i3lack

Posted
Posted

i keep getting this error and i cant seem to fix any help please

 

Parse error: syntax error, unexpected $end in /home/grandma/public_html/functions.php on line 305

 

Here is the script!

 

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

<link rel=stylesheet href=includes/in.css type=text/css>
<link rel=stylesheet href=in.css type=text/css>
<?php
$query=mysql_query("SELECT * FROM users WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);
$don=mysql_num_rows(mysql_query("SELECT * FROM donaters WHERE username='$username'"));

$date = gmdate('Y-m-d h:i:s');

if ($info->health <= "0"){
mysql_query("UPDATE users SET status='Dead' WHERE username='$username'");
session_destroy();
}
if ($info->status == "Dead"){
session_destroy();
echo "You're Dead!";
include("killed.php");
exit();
}

if ($info->status == "Banned"){
session_destroy();
echo "You Have Been Banned";
include("banned.php");
exit();
}

$crew_check =mysql_query("SELECT * FROM crews");
while($k = mysql_fetch_object($crew_check)){
$user=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$k->owner'"));
$rhm=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$k->rhm'"));
if ($user->status == "Dead" || $user->status == "Banned"){
if ($k->rhm != "0" && $rhm->status == "Alive"){
mysql_query("UPDATE crews SET owner='$k->rhm', rhm='0' WHERE name='$k->name'"); 

}
elseif ($k->rhm == "0" || $rhm->status == "Dead" || $rhm->status == "Banned"){
mysql_query("UPDATE `users` SET `crew`='0' WHERE `crew`='$k->name'");
mysql_query("DELETE FROM crews WHERE name='$k->name'");

}
}
}
$bba=mysql_query("SELECT * FROM bank");
while($nana =mysql_fetch_object($bba)){
$ppl=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$nana->owner'"));
if ($ppl->status == "Dead" || $ppl->status == "Banned"){
mysql_query("UPDATE bank SET owner='0' WHERE id='$nana->id'");
}

}




$oc_query=mysql_query("SELECT * FROM oc");
while($ttfn = mysql_fetch_object($oc_query)){
$user_oc=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$ttfn->leader'"));

if ($user_oc->status == "Dead" || $user_oc->status == "Banned"){
mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->we'");
mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->ee'");
mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->driver'");
mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->leader'");
mysql_query("DELETE FROM oc WHERE id='$ttfn->id'");

}}


function logincheck(){


if (empty($_SESSION['username'])){
echo "
<SCRIPT LANGUAGE='JavaScript'>
window.location='index.php';

</script>
";
exit();
}
?>

////UPDATE ONLINE
$time = time() + (60 * 10);
mysql_query("UPDATE users SET online='$time' WHERE username='$username'");
///FINSH UPDATING ONLINE

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;
}
/////////NOW TO THE BB CODES ETC....







function rankcheck(){
$username=$_SESSION['username'];
$query=mysql_query("SELECT * FROM users WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);
$date = gmdate('Y-m-d h:i:s');

if ($info->rank == "Tramp" && $info->rankpoints >= "350"){ $newrank="Thief"; $done="1"; }
elseif ($info->rank == "Thief" && $info->rankpoints >= "750"){ $newrank="Hooligan"; $done="1"; }
elseif ($info->rank == "Hooligan" && $info->rankpoints >= "2320"){ $newrank="Criminal"; $done="1"; }
elseif ($info->rank == "Criminal" && $info->rankpoints >= "4000"){ $newrank="Gangster"; $done="1"; }
elseif ($info->rank == "Gangster" && $info->rankpoints >= "6000"){ $newrank="Boss"; $done="1"; }
elseif ($info->rank == "Boss" && $info->rankpoints >= "7200"){ $newrank="Supreme Boss"; $done="1"; }
elseif ($info->rank == "Supreme Boss" && $info->rankpoints >= "11500"){ $newrank="Don"; $done="1"; }
elseif ($info->rank == "Don" && $info->rankpoints >= "17500"){ $newrank="Legendary Don"; $done="1"; }
elseif ($info->rank == "Legendary Don" && $info->rankpoints >= "150000"){ $newrank="Legendary Don"; $done="0"; }

if (!$done){
$done="0";
}
if ($done == "1"){

mysql_query("UPDATE users SET rank='$newrank' WHERE username='$username'");
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` ) 
VALUES (
'', '$username', '$username', 'You have been promoted to $newrank your doing well!', '$date', '0', '0', '0'
)");

}}

rankcheck();
///////HOUSTON WE HAVE JAIL CHECK!


$jail_check=mysql_query("SELECT * FROM jail");


while($monster=mysql_fetch_object($jail_check)){

if (time() > $monster->time_left){
mysql_query("DELETE FROM jail WHERE username='$monster->username'");
}}

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";
}}

function loose_energy(){
$username=$_SESSION['username'];
$query=mysql_query("SELECT * FROM users WHERE username='$username' LIMIT 1");
$info = mysql_fetch_object($query);

$energy=$info->energy - rand(1,3);
if ($energy <= "0"){
$update=health;
$thing=$info->health - rand(1,3);
$energy_new="0";

}elseif ($energy > "0"){
$update=energy;
$thing=$info->energy - rand(1,3);
}
if (!$energy_new){
mysql_query("UPDATE users SET $update='$thing' WHERE username='$username'");
}elseif ($energy_new){

mysql_query("UPDATE users SET $update='$thing', energy='0' WHERE username='$username'");
}
}


$most_online=mysql_fetch_object(mysql_query("SELECT * FROM site_stats WHERE id='1'"));
$timenow=time();
$now_online =mysql_num_rows(mysql_query("SELECT * FROM users WHERE online > '$timenow'"));

if ($now_online > $most_online->online){

mysql_query("UPDATE site_stats SET online='$now_online' WHERE id='1'");
}



$drop =mysql_query("SELECT * FROM casinos");

while($tard=mysql_fetch_object($drop)){
$per = mysql_fetch_object(mysql_query("SELECT * FROM users 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'");
}

}
$drop_bar =mysql_query("SELECT * FROM bar");

while($tard_bar=mysql_fetch_object($drop_bar)){
$per_bar = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$tard_bar->owner'"));
if ($per_bar->status == "Dead" || $per_bar->status == "Banned"){
mysql_query("UPDATE bar SET owner='0' WHERE owner='$tard_bar->owner'");
}

}
$drop_bf =mysql_query("SELECT * FROM bf");

while($tard_bf=mysql_fetch_object($drop_bf)){
$per_bf = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$tard_bf->owner'"));
if ($per_bf->status == "Dead" || $per_bf->status == "Banned"){
mysql_query("UPDATE bf SET owner='0' WHERE owner='$tard_bf->owner'");
}

}
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 users SET money = '$recieve', bank='0', banktime='0' WHERE username='$username'");

}
$drop_und =mysql_query("SELECT * FROM shop");

while($tard_und=mysql_fetch_object($drop_und)){
$per_und = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$tard_und->owner'"));
if ($per_und->status == "Dead" || $per_und->status == "Banned"){
mysql_query("UPDATE shop SET owner='0' WHERE owner='$tard_und->owner'");
}

}
$user_info=mysql_fetch_object(mysql_query("SELECT * 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'");

}


$user_shit=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$username'"));

if ($user_shit->last_respect < time() && $fetch->rank != "Tramp"){
if ($info->rank == "Paper Kid"){ $new_res="1"; }elseif($info->rank == "Thief"){
$new_res="2";   }elseif($info->rank == "Hooligan"){ 
$new_res="3";   }elseif($info->rank == "Criminal"){
$new_res="4";   }elseif($info->rank == "Gangster"){  
$new_res="5";   }elseif($info->rank == "Boss"){  
$new_res="6";   }elseif($info->rank == "Supreme Boss"){  
$new_res="7";   }elseif($info->rank == "Don"){  
$new_res="8";   }elseif($info->rank == "Legendry Don"){  
$new_res="9";   }elseif($info->rank == "Head Moderator"){  
$new_res="10"; }elseif($info->rank == "Moderator"){  
$new_res="11"; }elseif($info->rank == "Admin"){  
$new_res="12"; }elseif($info->rank == "MadeMan"){ 
$new_res="13"; }elseif($info->rank == "General"){ 
$new_res="14"; }elseif($info->rank == "Capo"){ 
$new_res="15"; }elseif($info->rank == "WarMaster"){ 
$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 == "Boss of Bosses"){ 
$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 == "SupremeBeing"){ 
$new_res="25"; }elseif($info->rank == "God"){ 



$now=time() + (3600 * 24 * 7);
mysql_query("UPDATE user_info SET respect='$new_res', last_respect='$now' WHERE username='$username'"); 

}
}
?>

 

Any help please

Link to comment
Share on other sites
rhodesa Newbie

rhodesa

Posted
Posted

you were missing a close brace at the end of your function. it's a common mistake. work on properly indenting, it's easy to spot mistakes that way.

 

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

<link rel=stylesheet href=includes/in.css type=text/css>
<link rel=stylesheet href=in.css type=text/css>
<?php
  $query=mysql_query("SELECT * FROM users WHERE username='$username' LIMIT 1");
  $info = mysql_fetch_object($query);
  $don=mysql_num_rows(mysql_query("SELECT * FROM donaters WHERE username='$username'"));

  $date = gmdate('Y-m-d h:i:s');

  if ($info->health <= "0")
  {
    mysql_query("UPDATE users SET status='Dead' WHERE username='$username'");
    session_destroy();
  }
  if ($info->status == "Dead")
  {
    session_destroy();
    echo "You're Dead!";
    include("killed.php");
    exit();
  }

  if ($info->status == "Banned")
  {
    session_destroy();
    echo "You Have Been Banned";
    include("banned.php");
    exit();
  }

  $crew_check =mysql_query("SELECT * FROM crews");
  while($k = mysql_fetch_object($crew_check))
  {
    $user=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$k->owner'"));
    $rhm=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$k->rhm'"));
    if ($user->status == "Dead" || $user->status == "Banned")
    {
      if ($k->rhm != "0" && $rhm->status == "Alive")
      {
        mysql_query("UPDATE crews SET owner='$k->rhm', rhm='0' WHERE name='$k->name'"); 

      }
      elseif ($k->rhm == "0" || $rhm->status == "Dead" || $rhm->status == "Banned")
      {
        mysql_query("UPDATE `users` SET `crew`='0' WHERE `crew`='$k->name'");
        mysql_query("DELETE FROM crews WHERE name='$k->name'");
      }
    }
  }
  $bba=mysql_query("SELECT * FROM bank");
  while($nana =mysql_fetch_object($bba))
  {
    $ppl=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$nana->owner'"));
    if ($ppl->status == "Dead" || $ppl->status == "Banned")
    {
      mysql_query("UPDATE bank SET owner='0' WHERE id='$nana->id'");
    }
  }

  $oc_query=mysql_query("SELECT * FROM oc");
  while($ttfn = mysql_fetch_object($oc_query))
  {
    $user_oc=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$ttfn->leader'"));

    if ($user_oc->status == "Dead" || $user_oc->status == "Banned")
    {
      mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->we'");
      mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->ee'");
      mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->driver'");
      mysql_query("UPDATE users SET oc='0' WHERE username='$ttfn->leader'");
      mysql_query("DELETE FROM oc WHERE id='$ttfn->id'");

    }
  }


  function logincheck()
  {

    if (empty($_SESSION['username']))
    {
      echo "
      <SCRIPT LANGUAGE='JavaScript'>
      window.location='index.php';
      
      </script>
      ";
      exit();
    }
  } //Missing close brace here
?>

Link to comment
Share on other sites
i3lack Newbie

i3lack

Posted
  • Author
Posted

kk thats fixed but now its this issue

 

Fatal error: Cannot redeclare logincheck() (previously declared in /home/grandma/public_html/includes/functions.php:79) in /home/grandma/public_html/functions.php on line 97

 

Line 97    if(strlen($input)<=3)

Link to comment
Share on other sites
rhodesa Newbie

rhodesa

Posted
Posted

line 97 is the closing of the function. do you already have a function in functions.php called logincheck? if so, you need to rename one of them. although i don't see functions.php included...is it included via db_connect.php?

Link to comment
Share on other sites
rhodesa Newbie

rhodesa

Posted
Posted

nice, glad i could help...could things though

 

1) Can you click the Topic Solved button

2) Next time, try to post in the right forum. I just realized you posted this under MySQL, when it should be in the PHP forum

 

...moderator, if you see this, can you move it?

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

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.   Restore formatting

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

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.