awakenedlands.com

Re: property market error I assume players can only post 1 house on the market at a time, correct? If so, try changing your remove_house query to something more simple like the following: SELECT pr.* FROM propertymarket WHERE userid = $userid   See if that fixes it. If they can post more than one house, you'll need to pass the prID field to select only that record.

Re: Strong enforcement of the rules. #1 reason why I stopped frequenting these forums was the lack of moderation. That was a long time ago. Good to see the staff deciding to take back control.

Re: [V1 and V2] Optimize Tables once an hour. When you start getting a lot of traffic or your tables start getting huge (like a gig) you won't want to do this, unless you don't mind having your game down for a few minutes. Like was said earlier, you probably only want to do it once a week or so.

Re: MC Code Mailbox Exploit? Normally when there is an exploit, it's polite to post the fix so those who have no idea what the vulnerability is can see what the issue is.

Re: SQL Injections Or you can use simple sites like this to "decrypt" the md5 passwords... http://nz.md5.crysm.net/

Re: LARGE ammount of stolen code in use. Lol, not anymore.

Re: LARGE ammount of stolen code in use. Who's paypal account were the donations going to?

Re: speedtest Not too bad when you consider I have 3 servers using bandwidth at the time I did this. Wonder what it would be at the faster connection plan.

Re: Anyone know Vorlens paypal?? I couldn't imagine running a game and NOT having IPN enabled.

Re: Question: Servers and Queries The number of queries and the complexity of a query both have the same effect -- load time lag. Just take all the queries you have on a given page and run them in phpmyadmin's SQL tab. This will give you a query load time in seconds. Add them up. Or add in a microtime page load script for your pages to find out what taking too long. Proper indexing of tables for commonly used data is important. There are plenty of unindexed tables in the default game code that make what should be a 0.2 second page turn into a 2.5 second page. I've posted on here in the past that adding indexes to certain tables basically saves you the need of getting a dedicated server. I'm sure there are plenty of mccode games out there on dedicated servers that get poorer performance than a shared host game with optimized tables. The hosts that get pissy with your SQL use probably oversold their server space and don't want your activity on the servers. Otherwise they wouldn't care.

Re: Dedicated Hosting What sort of cpu requirements does this game possibly need? I don't see any games out there that get Torn City traffic. My game isn't huge, but we still get over 50 users online in the last 10 seconds every now and then without any degrade in performance on our shared hosting server. I think the real problem is the game database isn't designed for performance. Proper indexing of often-searched tables in the database will save a lot of cpu cycles, thus saving a lot of money. I log page load times in a table to track our server's performance, and there really isn't a noticable difference between peak hours and slow times (we are talking less than 0.02 seconds increase in load times). Prior to optimizing the tables server performance was still a non-issue, but could lag when slow pages were accessed. I'm curious to know what sort of traffic and concurrent connections the dedicated server users are getting out there. I'm not talking about the obvious Torn City's of the world either, but real game owners here. There aren't too many 200+ concurrent users for games of this kind out there.

Re: Dedicated Hosting Just curious why you guys are going dedicated. I know running your own server prevents others from lagging your server with their sites, but seriously... how much bandwidth are you guys using that you require dedicated hosting plans?

Re: Proxy Banning Fighting proxy users is tough. You could blacklist known IPs but this could be a lot of work. Check out this site http://proxy.org/cgi_proxies.shtml They have a list of known TOR proxy IPs. It might be overwhelming at how many proxies are out there. I've managed to keep cheating down fairly well by preventing certain functions from working between players who have shared IPs in the past. I have a table with all IPs used by each user. If anyone tries to do a certain game function (send cash for example), they get blocked. The info also gets entered into a log. This has worked very well since cheaters ALWAYS end up having both accounts sharing an IP. It's a permanent block too, automatic, and requires no eyes to know it happens.

Re: attacklost.php and attackwon.php   Not saying he stole it or not, but it's not surprising to me that if you sell code to one player soon everyone will have it without you getting props or cash for it. That just seems to be the community here. :|

Re: Phone Billing Not sure if I remember correctly, but doesn't PayPal offer phone billing as well? I seem to remember seeing some offer on there before.