D Danneh3 New Member Mar 16, 2011 16 0 Mar 26, 2011 #1 right well im a complete moron at sql so what would be the sql code to alter the user table to set everyones vip at 0? as mines bugged and like 100 peeps have vip, halp? thanks
right well im a complete moron at sql so what would be the sql code to alter the user table to set everyones vip at 0? as mines bugged and like 100 peeps have vip, halp? thanks
D Danneh3 New Member Mar 16, 2011 16 0 Mar 26, 2011 Thread starter #3 oh easy enough thanks Edward mod close thread, kfnx Upvote 0 Downvote
Livar Now 35% cooler! Oct 15, 2010 846 86 Mar 27, 2011 #4 Wrong; UPDATE users SET rank = '1' or no-one will be able to log in. Upvote 0 Downvote
D Danneh3 New Member Mar 16, 2011 16 0 Mar 27, 2011 Thread starter #5 all I needed to do was edit it so no-one had vip as it glitched and 178 peole had vip so, yano Lol Upvote 0 Downvote
Livar Now 35% cooler! Oct 15, 2010 846 86 Mar 27, 2011 #6 Oh actually, that was wrong. You'd need to do; UPDATE users WHERE rank = '2' SET rank = '1' otherwise everyone would be rank 1. Upvote 0 Downvote
Oh actually, that was wrong. You'd need to do; UPDATE users WHERE rank = '2' SET rank = '1' otherwise everyone would be rank 1.
D Danneh3 New Member Mar 16, 2011 16 0 Mar 27, 2011 Thread starter #7 Im only doing vip is set to 1, rank 2 will be super vip Lol Upvote 0 Downvote
Livar Now 35% cooler! Oct 15, 2010 846 86 Mar 27, 2011 #8 So you've made rank 0 = user? Upvote 0 Downvote
D Danneh3 New Member Mar 16, 2011 16 0 Mar 27, 2011 Thread starter #9 No I changed edwards thing to UPDATE users SET vip = '0' then gave vip back to the people who had it Upvote 0 Downvote
Cablink http://www.vroleplay.net - join now! Feb 4, 2011 382 27 Mar 27, 2011 #10 Its obviously 0 because, if its 1 it is vip :L thats pretty easy. Upvote 0 Downvote
