a_bertrand

Art and specially images are not easy to create if you want some quality. So asking for free is normally out of question. On the other side, once your game is up and running you may have some of your players willing to help you.

Great reviews so far, thanks for sharing!

I would maybe not use music found from those sites ;) And... as I always say: I'm an old monkey, so I play with such things since a long time.

http://www.amazingben.com/rpg.html http://www.seventhsanctum.com/index-writ.php http://www.io.com/~sjohn/plots.htm http://www.the-elite.net/---/story/ http://tvtropes.org/pmwiki/storygen.php Etc... all those can help you to setup plots / stories. I would not directly pick up the result without some work ;)

I get it on all pages... but not on every load... from time to time let's say. I would say the problem is still not solved. Also last week I got again a "too many connections"...

Nope doublet you should do it like Djkanna said.

normally with MySQLi you don't escape data as you pass them as query parameters which in returns avoid SQL injections: http://www.php.net/manual/en/mysqli-stmt.bind-param.php

Well 2D like zelda and voice acting is not something you get easily on the browser specially when you have no programming skills. So I would maybe point to something like RPG maker (which version is for me unkown), which would offer a nearly complete kit to get an RPG with little programming. If voice acting is not really a requirement and you want to go for a web based game then miniNEaB could be a solution as the result is similar to the old Zelda RPGs and programming is not required beside some in game scripting for the quests (which again is not done in PHP but via the web interface).

Easy: [mysql]select userRefID, count(userID) from user where userRefID is not null and userRefId <> 0 group by userRefID order by count(userID) desc limit 0,10[/mysql]

http://www.cddesigns.org/OLD/mods.php?dl=chat

WHERE userID=userRefID ?? Are you sure you have users which point to their own ref? I'm quiet sure it doesn't happen... Also it is really a bad practice to quote numbers. If it is a number keep it as number!

Well there is certainly multiple possibilities to create an RPG, either inside the browser or outside. Teaching via a game could be a good ideas, but for that you need some dialogs / interactions and not simply some click to grow. Therefore I would avoid McCode and other similar gang / mafia games. To help you better we should get a bit more details of what kind of game you would like to create, what are your computer skills and how much time you want to invest.

Hand drawn could offer a more artistic feeling where 3D could offer a more modern look. Both could have it charms. However 3D must be of very high quality otherwise people will not like it.

Changes little... as you offer little to no info. If I was you, I would wait until I would have at least my website ready before starting to advertise it. But this only my personal opinion.

Well somehow, by the fact you don't show us your website it seems fishy to me... Why should we use your network and not another trusted one?

Well... you should give more info out, like price, which site the ad will be run on, the link to your site etc... Also cost per impression are somewhat biased as people tend to be advert blind lately. That's why most advert network work on the clicks and not the impressions.

Well, in theory you can say that you download crypted data from somewhere else. However you need to have the decryption algorithm & code locally... so no you cannot protect any code like that.

True Zeggy but honestly I saw so much of such bad practices that I would say it is the first thing to solve ;)

Not really as if you encrypt you must provide as well the code to decrypt otherwise it would not run... So the only pseudo solutions are code obfuscation (which makes the code nearly unreadable) or tools like http://www.zend.com/en/products/guard/ Yet those are useful only if you plan to distribute your code and do not want that others modify / check how you did it. It is by no way more secure in term of web exploits.

Danny can certainly ask 5$ for the script (for a distribution) but at the same time he must give anybody a way to get the full script for free. This is due to the fact lite is based on the GNU copyright (if I remember well) and GNU state clearly that you are free to sell as well as are other free to get it for free.

Why do you think it "refreshes"? Could it not be that simply you replace ALL the HTML? (something btw which is a non sense normally).

It is certainly important to use correctly the index (as well as the right DB engine), however I would personally first think about my own code and for example avoid 100 queries within a loop and replace it with a single query (if possible). That has too a major impact.

Payed advertisement: Advert experiences and feeback Alternative ways: http://engine.nowhere-else.org/article_3.html

You should count about 50 cents per registrations... and that should be a quiet good result already. Now from those registrations how many will remain after the first few impressions of the game is another story. So with 500$ you can count 1000 registrations... which may end up between 100-300 true players (depending if your advert find the right target and how good your game is). Also, advert is not the only reason why game fails... as you could advert without spending money. Now if you take the quick way to get players payed advert is certainly a good solution but as you see 500$ will not bring you that many players.

Actually ints are from -2147483648 to 2147483647 in MySQL where in PHP it depends if you are in a 32 or 64 bit plateform. Also unsigned values in PHP do not exists and as soon as you try to make numbers bigger than what ints handle in PHP it is automagically converted to floats.