a_bertrand

So basically you want that the display displays something different that the database contains? Yes you can, if you have some very well defined rules. For example we could replace all the A with a B: echo str_replace("A","B","AAAAAAA"); You may also try regular expressions in case.

Sorry my mistake, I was meaning from PHP.

Good review thanks!

To be used from MySQL? Honestly I never needed a ORM even from strongly related languages like C# as I do the DB serialization and de-serialization myself.

Well don't know if I would use it, for quick thingy notepad++ is not bad, for more complex thing I use ZendStudio for PHP/JS and Visual Studio for my C# applications... So this wouldn't really fit in my pipeline. However it may interest people which don't have the budget to buy more complex tools, and still want something more than notepad++

Much better, now if I can rise another point, the register / login buttons on top are somewhat hidden.

There is a limit, but not due to the size of the condition, it would be something like the limit of the string size of the query, but honestly I never reached it. Now for your query instead of having id=1 or id=2 etc use [mysql]SELECT * FROM tablename WHERE id in (1,7,9,10)[/mysql] It will be faster, shorter to write, and more easy to read. Also if you produce this list from php you can do something like:   $search=array(); for($i=0;$i < 10;$i++) $search[]=mt_rand(1,1000); $sql="SELECT * FROM tablename WHERE id in (".implode(",",$search).")";

It's indeed hard to read...

This starts to be quiet off topic and... not really nice. So please come back to the topic and stop bashing you guys between how many posts or the knowledge of somebody.

As said, you cannot overlap tiles with a grid (like a table). You need to use CSS to place your images on a pixel precise location.

Seems to be a quiet complete game... Now I still feel it a bit like an McCode game (maybe to the use of Gym / Hospital and others terms). But still, it's quiet full of things. To advertise, I would suggest to check my article here: http://phpgamespace.com/how-to-tell-that-you-exist

http://www.vmware.com/products/player/ It's free and allows you to create / use virtual machines.

The best way to test google os yet is to use a virtual machine like vmware (can be downloaded for free). A dual boot is not something I would try with such early preview release.

Honestly, Google OS seems nothing really interesting. Sorry, but why would I need something which requires more or less to be always online? And offers me only what I could find on web? Sorry but I use a lot of things which doesn't yet (at least) run on web. Also, having a company like Google controlling what runs on my PC is even worse than having to pay Microsoft for using my PC. BTW for those which doesn't know what Google OS is: - It's a stripped version of Linux - It contains mainly only a browser - let you run those google doc and other app more or less offline and online... that's it.

Apache (any version) PHP 4 or 5 MySQL 4 or above

I will try to improve a few things... if people seems to like it.

Download and use a package like that if you want drop downs menu: http://www.lwis.net/free-css-drop-down-menu/

Well, of course it depends of how many players you will have. You can start with a free or shared hosting, and as any other web game, you will need a growing CPU / Disk / Network allocation as the number of players grow.

Well as soon as you want some sort of interaction, then you need a programming language. So a guest book or a newsletter need some coding or the usage of the 1000's existing script which does them.

Well to get something like that you will need a lot of CSS positioning as no table will allow you to overlap images. Now of course you could render the full image on the server side (via GD) and then show the rendered image directly. For the client side rendering you have the choice of render it via PHP & HTML and if you need to modify the map you need to reload the page or do it via JS.

Depends what you want to use, you could use flash, java or silverlight to make your maps, or if you want to stick with JS / HTML then all is different. So unless you tell us which technology you are willing to use, I'm not sure how we can help you.

LEFT JOIN drugs_drugs d LEFT JOIN drugs_inv ... You need an "ON" condition for each left join...

yes right. Variables can store basically anything, from a single text line like you mentioned, to complex structure like nested tables and more. Where to use them? Well anywhere you need them, I mean, as soon as you need to store something you can use them. However remember that variables will not survive between two page loads (until you use the special array $_SESSION.

First of all, hacking because you can is kinda childish, I mean, of course if you know security holes you can hack something, and as far as I know McCode is full of those. Now does it means you are smart or anything doing it? No, actually quiet the reverse, but this is of course my own opinion. On the other side, if you know that there is some security holes and inform the owner, well, that would help him avoid that his game could be trashed or at least reset. I would say it would make sense to do it, sure it would be a real pain with all those just installing a simple script and pretending being a game owner. Finally, a thread giving a word of warning on who is potentially dangerous can help those new players in the field to avoid to invite them, by the way, I would strongly suggest to NOT upload any script on your host until your are 100% sure that it will not help somebody to snake in. Even phpBB which is a well known forums software is dangerous as there is way too many mods and some of them are not secure, plus phpBB is so wide spread that there is a lot of people trying to hack it. So see, not only game script can be a source of problem but actually any script can be.

I must admit I'm lost, on one side you know what a variable is, and before you say you don't know how to use them. A programming language without variables would not be a programming language as you would not be able to store information nor react to some conditions.