Gesior Acc Search Bug .. Please Help .!!

[fewdox]

Warning: Division by zero in C:\Jogos\Nova pasta\xampp\htdocs\characters.php on line 164

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'time' in 'order clause'' in C:\Jogos\Nova pasta\xampp\htdocs\characters.php:200 Stack trace: #0 C:\Jogos\Nova pasta\xampp\htdocs\characters.php(200): PDO->query('SELECT * FROM p...') #1 C:\Jogos\Nova pasta\xampp\htdocs\index.php(142): include('C:\Jogos\Nova p...') #2 {main} thrown in C:\Jogos\Nova pasta\xampp\htdocs\characters.php on line 200

"When i search : Account Mananger " ;

tanks

 

[Derek Boom Boom]

Stop divising by 0? -.-'

 

[fewdox]

..

i dont know about this error .. ;P .. but i need to solve it

 

[Derek Boom Boom]

First error: Go to line 164 and find equation with division by 0.
Second Error: Find query @ line 200 and remove time thing + remove time thing from rest code or simply add column in database structure.

 

[fewdox]

..

 

[fewdox]

...

      //Hp/Mana/Exp Status by ballack13
                        $hp = ($player->getHealth() / $player->getHealthMax() * 100);
                        $mana = ($player->getMana() / $player->getManaMax() * 100);
          		$main_content .= '<td align=center ><table width=100%><tr><td align=center><table CELLSPACING="1" CELLPADDING="4"><tr><td BGCOLOR="#D4C0A1" align="left" width="20%"><b>Player Health:</b></td>
                  		          <td BGCOLOR="#D4C0A1" align="left">'.$player->getHealth().'/'.$player->getHealthMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$hp.'%; height: 3px;"></td></tr>
                  		          <tr><td BGCOLOR="#F1E0C6" align="left"><b>Player Mana:</b></td><td BGCOLOR="#F1E0C6" align="left">'.$player->getMana().'/'.$player->getManaMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: blue; width: '.$mana.'%; height: 3px;"></td></tr></table><tr>';

                        $next = ($player->getLevel() + 1);
                        $exp = ((50 / 3) * ($player->getLevel() * $player->getLevel() * $player->getLevel()) - (100 * ($player->getLevel() * $player->getLevel())) + ((850/3) * $player->getLevel()) - 200);
                        $expnext = ((50 / 3) * ($next * $next * $next) - (100 * ($next * $next)) + ((850/3) * $next) - 200 - $player->getExperience());
                        $expresult = (100 - ($expnext / (($expnext  + $player->getExperience()) - $exp) * 100));
           	        $main_content .= '<tr><table CELLSPACING="1" CELLPADDING="4"><tr><td BGCOLOR="#D4C0A1" align="left" width="20%"><b>Player Level:</b></td><td BGCOLOR="#D4C0A1" align="left">'.$player->getLevel().'</td></tr>
                        		  <tr><td BGCOLOR="#F1E0C6" align="left"><b>Player Experience:</b></td><td BGCOLOR="#F1E0C6" align="left">'.$player->getExperience().' EXP.</td></tr>
                		          <tr><td BGCOLOR="#D4C0A1" align="left"><b>To Next Level:</b></td><td BGCOLOR="#D4C0A1" align="left">You need <b>'.$expnext.' EXP</b> to Level <b>'.$next.'</b>.<div title="99.320604545 %" style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$expresult.'%; height: 3px;"></td></tr></table></td></tr></table></tr></TABLE></td>';

 

[fewdox]

.....

line 200

	$player_deaths = $SQL->query('SELECT * FROM player_deaths WHERE '.$player->getId().' = player_id ORDER BY time DESC');

 

[fewdox]

i fixed that problem. ..

Just need to go in

1. http://localhost/phpmyadmin
2. you 'db name '
3. and go SQl

Execute this code .!

ALTER TABLE `player_deaths` ADD `time` bigint(20) unsigned NOT NULL DEFAULT '0';

Problem now is fixed .!