Books or tuts on Mmorpg web coding ? (mysql/php)

category: general [glöplog]
hi guys

i would like to learn how to develop a php-oriented web game (like ogame or worldofdungeons for example), and particularly a MMORPG.

i know i need some strong database knowlegde and my MySQL knowledge is actually not sufficient to know how to manage objects and all.

you know, in a mmorpg, people can drop objects in dungeons, unique items, regular objects, ressources etc.. equip items etc. and i would like to know how to manage this in php/mysql.

so my question is : anyone knows a good book i could buy ?, or ebook, or tutorials etc.. to learn all those techniques ? (i think it's related to database directly, i know the basics of relational databases already, but not those things)


added on the 2010-03-03 13:12:57 by bull bull
first learn how to program
then learn how to design scaleable systems
then learn how to program game play
then start doing the mmorg
omfg "I WANT TO CODE MMORPG" on pouët
added on the 2010-03-03 13:33:09 by havoc havoc
OK, as the lead coder of http://www.project-space.de I assume I can safely say this:

what macaw/loonies said.
added on the 2010-03-03 13:35:05 by xTr1m xTr1m
go make a MySQL demo about it
added on the 2010-03-03 13:35:17 by ponce ponce
i would guess making a game with php would be silly. but i guess its possible too do. but i think its very unwise to make some game only in php. for database use it may be okay. why not use java or even flash(why am I even suggesting flash?). bah. Kuni: go learn some basic language and read about some mmorpg tutorial, some basic language and rpg game design. over and out.
added on the 2010-03-03 13:52:13 by rudi rudi
it's not like farmville isnt wildly successful.
added on the 2010-03-03 14:19:49 by Gargaj Gargaj
i would guess making a game with php would be silly.

No. If you're making a web-based game then having some portion of it run on a web server, in a language such as PHP, is a very sensible idea. Really. Sure, you probably want something more advanced than static HTML on the client side too, but one thing at a time.

Kuni: Modelling a game in a relational database is exactly the same as modelling a CD collection, or a warehouse inventory system, or anything else. You have business objects (people, objects, dungeons) and relations between them (person has many objects, person belongs to room). If it isn't clear how to make it work, then I'd suggest reading more about database design in general (i.e. don't look for a tutorial specifically about games).
added on the 2010-03-03 15:05:15 by gasman gasman
php + gaming = sux =\
added on the 2010-03-03 15:53:09 by panic panic
i agree with panic.
added on the 2010-03-03 16:12:15 by rudi rudi
No shame in it really, my friend had wrote an online rpg when he was 16, has probably turned over more than £120k since, I've got nothing but respect and EXTREME RESENTMENT for the guy!
http://sol.gfxile.net/mmorpg.html A bit old but still relevant.
added on the 2010-03-03 18:07:41 by thec thec
+1 gasman too.. good advice.
added on the 2010-03-03 18:09:36 by thec thec
why not use java or even flash(why am I even suggesting flash?)

Good question. Some people would argue that Flash is on the way out anyway, with fewer use cases left for it every day, considering HTML5/Web.GL/accelerated Javascript will take its place. But we are not there yet.

i know the basics of relational databases already, but not those things

As gasman pointed out, it is "those things".
added on the 2010-03-03 18:16:40 by tomaes tomaes
BB Image
added on the 2010-03-03 18:49:01 by stijn stijn
what sol says (in thec's link).

rc55: deep respect for your friend, he's probably the exception
added on the 2010-03-03 23:15:01 by BarZoule BarZoule
thec: If he's doing an online MMORPG with php and mysql, then it might actually not be that difficult. We can assume that it's just a turn-based thing showing a one-page snapshot of what's going on, and then waiting for input. Most of the hard stuff about making a full MMORPG, like having tons of graphics, models, 3D simulation, prediction to overcome latency, keeping client/server synchronized, are all completely irrelevant. I think it's doable if you think of it less like an MMORPG and something more like those old door games like LORD.
added on the 2010-03-04 00:15:57 by yesso yesso
well, i can code "basic" php, and know the basics of relational databases, relations etc.

i know how to allow many objects to one person etc.. how to design a "simple" database with simple relations.

but i dunno how to make it work "properly" with PHP, and manage counters etc..

added on the 2010-03-04 00:27:39 by bull bull
stjin: lol
added on the 2010-03-04 01:31:21 by bdk bdk