Devam Ediyor

small PHP and mySQL project

Hello, I'd like a small PHP/mySQL system that I will use for testing a turn based multiplayer game.

I'd like you to write the following 6 php scripts:

1) [url removed, login to view] ( Inputs : None )

-------------------------------------------

This will create an mySQL database with one table containing the following fields,( I'll run this php file to setup the system initially. )

table name = GameTable

String( max 64 characters ) : gameID

String( max 64 characters ) : player1ID

String( max 64 characters ) : player2ID

String( max 16384 characters ) : gameData

Number ( integer ) : moveNumber

Time : startTime ( this should be the server side date and time that the game started )

If the table already exists then it should be deleted and then recreated.

Return "OK" unless there was an error creating the table in which case return "error_2"

[url removed, login to view] ( Inputs: playerID )

----------------------------------------

First search the GameTable for a row which has "NONE" for the player2ID.

If a row is found then return the gameID.

else

if no row is found then create a new row using:

* the input playerID for player1ID

* "NONE" for the player2ID

* a random sequence of 64 characters for the gameID

* the current server time for startTime

* 0 for moveNumber

and then return the gameID that was just created ( if there is an error creating the row then return "error_2" )

[url removed, login to view] ( Inputs: gameID , moveNumber )

-------------------------------------------------------------

If no row with gameID exists then return "ERROR_1"

else

if the row with gameID has a moveNumber greater than the input then return gameData

else

return "NO_NEW_MOVE"

If any other error occurred then return "ERROR_2"

[url removed, login to view] ( Inputs gameID, newGameData )

-----------------------------------------------------------

If no row with gameID exists then return "ERROR_1"

else

replace the gameData in the row that has a matching gameID with the input newGameData

return "OK"

If any other error occurred then return "ERROR_2"

DeleteGame( input gameID )

---------------------------------

If no row with gameID exists then return "ERROR_1"

else

delete the row which has a matching gameID

return "OK"

If any other error occurred then return "ERROR_2"

[url removed, login to view] ( inputs : NONE )

-----------------------------------------

This php script should

* display the contents of the GameTable

* display the number of rows

* display the number of rows which have no player2ID

--------------------

Many Thanks!

Beceriler: MySQL, PHP, Yazılım Mimarisi

Daha fazlasını görün: use case sequence, string matching in c, matching string, creating php table, database scripts with php and mysql, write php and mysql, string matching, software search replace, small php, small php project, small architecture, php script create table, newgame, d max project, script game multiplayer, mysql characters, mysql replace string, php random file name, game server mysql, php delete mysql row, mysql search table, mysql delete using, php random name, php search replace, server turn based

İşveren Hakkında:
( 2 değerlendirme ) Hexham, United Kingdom

Proje NO: #4435383

Seçilen:

truewaycompany

Easy task for me. Ready to get started. Thanks!

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0

17 freelancers are bidding on average $127 for this job

websree

We have reviewed the project description and we are ready to do this work.

in 3 gün içinde154$ USD
(156 Değerlendirme)
7.5
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

in 2 gün içinde300$ USD
(368 Değerlendirme)
6.9
ValueCoders

Hi, Experts team of SEO/Wordpress/PHP/cakephp/joomla/Drupal/Magento/AJAX/Codeigniter developers and designers. Thanks Gaurav

in 10 gün içinde412$ USD
(103 Değerlendirme)
6.6
netxpertindia

We will develop these php scripts

in 3 gün içinde178$ USD
(77 Değerlendirme)
6.6
webzin

Lets get it done...

in 3 gün içinde144$ USD
(50 Değerlendirme)
6.1
tvoodoo

Hello, I would love to assist in getting this done for you as fast as possible. Please check your private message board. Thanks !

in 3 gün içinde140$ USD
(84 Değerlendirme)
5.5
lokjaiswal12

Hello, I can create this system.

in 2 gün içinde70$ USD
(38 Değerlendirme)
4.7
Digi7Solutions

Hi, Please Check Pm

in 2 gün içinde50$ USD
(46 Değerlendirme)
4.6
manish973

check pmb.......lets start this

in 6 gün içinde110$ USD
(5 Değerlendirme)
4.7
truongnx15fl

Hi, I can help you to develop your desired functions

in 3 gün içinde45$ USD
(24 Değerlendirme)
4.2
bestphpjobs

This seems really interesting task, I would love to work on it, I will make you happy by my work :)

in 2 gün içinde99$ USD
(28 Değerlendirme)
4.1
LogikaKita

Very ready to make those php files for you. :)

in 3 gün içinde48$ USD
(26 Değerlendirme)
4.0
miraclesolution

Quality work [url removed, login to view] to work on the project..

in 3 gün içinde140$ USD
(9 Değerlendirme)
3.6
thenomader

Respected Sir or Madam I understand perfectly your needs and I am ready to start right now if you give me the chance to work with you. I have strong knowledge in XHTML, CSS, PHP, JQUERY, AJAX, DRUPAL, WORDPRESS, JO Daha fazlası

in 3 gün içinde120$ USD
(6 Değerlendirme)
3.4
tonyshaeeb

Lets have a discussion.

in 3 gün içinde65$ USD
(8 Değerlendirme)
3.2
SurfrazAhmad

I am Ready to Start Work on this

in 2 gün içinde40$ USD
(3 Değerlendirme)
3.1
mishel2006eu

hi, i can done this task

1 gün içinde 40$ USD
(0 Değerlendirme)
0.0