Need PHP expert to solve some bugs and error in SQL database and PHP files!

• Project ID:

  252650

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Hi,

I need a PHP expert to solve some bugs and error in SQL database and PHP files, well let’s start from what kind of sites I have:

My site is:
MMORPG text based browser online game

Game link:
Provided after we reach with an agreement with the service provider.

Game errors and database errors:

Here some of error the players found it when they were playing:

1. When searching the player list, the page won’t move to the next page, when pressing (next) button it shift you to the same first page! (battlefield.php)
2. Some problems while players (steal) and (spy) on other players, the mission done successfully but there is no report after the mission accomplished! (steal.php) and (spy.php)
3. Some database errors appers in managing player account (manage.php) the error is: Query failed: Table 'zahad_hadara.Alliance' doesn't exist
4. Fonts is too small in the overall game pages, need to increase the font size.

Here I found errors while I am in the game admin control panel:
1. There is an error while updating the player data, such as increasing account gold, increasing his weapons or change his type from normal player to donator player (admins.php) this error appears:

Warning: Invalid argument supplied for foreach() in /home/zahad/public_html/admins/new_unit.php on line 20
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID='1235'' at line 1

Error while saving

I am expecting the service provider to be expert in MYSQL database and PHP files and especially in text based game.

The payment will be through GAF only.

Skills required:

Linux, PHP, Script Install, XML