Decepti0n

Re: Shafted by LunarPages how can you not realise the link is screwed and adapt it so that it does work :s does typing in a url not happen anymore or something :|

Re: Help what do you think the error is trying to tell you :) check your connection page

Re: Welcoming Myself hi Damien.............. *resists suspicions that you're GF*

Re: Shafted by LunarPages no, it was more like if ($energyrechargetimestamp < mktime()) { //update // update users set energyrechargetimestamp = next ten minute mark (something with the time function) }

Re: New story called the coming internet Crash? what a load of shit

Re: Shafted by LunarPages timestamps can reduce your # or queries/crons dramatically :D

Re: Question: Servers and Queries i just get amazed at how many people use $count=mysql_query("SELECT * FROM users WHERE blah = 1"); if (mysql_num_rows($count) etc using COUNT(*) in the query saves loading the whole table into memory

Re: New Gang Staff Panel(Free) that was my picture XD

Re: Some Code Confusion??????? $db isn't an object either you aren't including the right files, you didn't put $db = new Database; or whatever, or you're using stolen code or code that wont fit. for a quick fix just use mysql_query instead of $db->query and @cronus, spaces dont matter :p

Re: staff applications $db->query is the instance of the database class...and classes are the basis for oop, which is waaaaaay more efficent

Re: If user in jail/hosp lawl, and here i was writing a big check thing, didn't even see the second page xD

Re: Sick and Tired of Them that isn't even a site? you should be able to send a DMCA notice to their host anyways, except lunarpages, i tried that when some dickwad stole my shit and they said they didn't get involved..pfft

Re: staff applications <textarea rows='7' cols='40' name='app'>$_GET'app'</textarea>   to <textarea rows='7' cols='40' name='app'>$_GET['app']</textarea>

Re: Help with crons please always look on the brightttttt side of life *whistles*

Re: I need some advice oh geez also you can increase your max connections to mysql somewhereeeee i just can't remember where

Re: Help with crons please are they your boyfriends as well

Re: Randomizing users ;)

Re: Randomizing users Select * from users where Gang = Gang B ORDER BY RAND() LIMIT 3 thats to order it randomly, i didn't really understand the question though XD

Re: Seanybob's Arcade Mod pfft he has enough already :p

Re: How to hack windows pinball, and any other games (with pics) cheater ;) i used artmoney to cheat on c&c generals lol

Re: ...!Help Me Please!... if you wanna get technical <span style="color:#color;">text</span>

Re: Gang War --- Help Needed add or die(mysql_error()); to the end of all your queries then it'll at least show the SQL error

Re: mailbox with smilies spellbyte, off the top of my head, you can use str_ireplace to replace case-insensitive strings (would match : s and : S)

Re: Tables... Only returning one entry? if you get say, all users with a in their name, and join it with, all users who have an item worth more than $70, and 40 people have an a in their name, and two people have $70 items, it'll only return the 2 IDs eg: SELECT u.*, a.* FROM users u, items a WHERE u.id = a.ownerID AND a.price > 70 AND u.name LIKE '%a%'   would return the 2 people (i think, wrote it quickly)

Re: Question: Servers and Queries should do, especially if you have effective keys on them but i can't be too sure, i usually try and keep my query count down even if i have to access 4 or 5 tables in one go