Renkia

Lol no biggy. And yeah ill post it at the top. And Take credit? Lol i carnt even work out a simple table SQL plus most people on MWG know i couldnt make somthing like this. :P

Yeah i knew some one would say that. My mate PAUL said he coulnt remeber the owner. Was a mate of his, so i guess he wouldnt mind. Plus it was going for free he said after a couple of weeks.

REMOVED!

Lol 1 Month laring everythig about PHP? Ha I Am going to learm everything about PHP in 1 month. Not to perfect it, getr everything into my head, and keep on getting better at it. Simple :thumbsup:

Actually. Ill stay. The W3 Really helps. I Wont be on as much but ill stay. Sorry for wating your times. :(

Ok make that 2 Hours of learning HTML. Know all of it. Just need to remember some parts. :P

It makes perfect sense. :P I Admit this is a great place to learn. But i wouldn't learn everything would I? ;) Please trust me on this. 1 Month on every Language, I Shall do fine. If i can get loads of information in fats. I Would say 2-4 Months then ill come back. Plus I dont wont to come on here most and other things. Laptop time = Learing time = Listening to LP , ITS :rolleyes:

Well not really for a game. I Want to try all the Languages for my game and to make myself proud. I Fairly want to learn all this for Mccodes. I Could get some money out of it, orders etc.. And yeah i do thank everyone has helped allot and don't mind. Plus i could hardly make a simple code. But this why i just wanna put all my time reading over & over again untill i can fit most of the Languages into my head. Basicly it what i feal like doing. ^^

Goodbye for 6 Months Ok ive made my mind up. Since I keep posting topic that i think are hard and so easy for you. And I feel like a dick, wondering why do i even try. You`s are always gonna going to be better then me, unless i take some action. So ive decided to take a 6 Month course by myself. I Am going to learn of the following links. http://www.w3schools.com http://www.php.net http://www.mysql.com Languages I am to try and learn. HTML PHP MYSQL XHTML SQL Parts of CSS =/ Hoping to convert all the into Mc codes. I Am hoping to learn a majority of these when i come back. I Would like to thank most members of MWG for being kind, and helping me through problem. I Will still be updating my game. Wont be open till 1 Year. Its long but creating it myself would be nice. :P If you want to stay in contact with me on MSN just add me. [email protected] Cheers, Rasheed Saeed / Best of luck to MWG :thumbsup:

Need some help on these 1 SQLS. & Another problem. Sorry about the Title [mysql]QUERY ERROR: Unknown column 'admin' in 'field list' Query was UPDATE users SET admin=1 WHERE userid=2[/mysql] [mysql]QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query was UPDATE users SET admin=1 WHERE userid=[/mysql] CODE LINE: $db->query("DELETE FROM admin WHERE admin_userid={$_POST['userID']}");   If you could post these that would be great. 8o Cheers, Rasheed :thumbsup:

Cheers guys., Problem solved. :thumbsup:

Looking good Zeggy Nice job. :D

Nice job pudda. I Shall be adding this to my game. Maybe a few changes could be done to improve performance (Or not =P) Great job, Keep the free mods coming, :thumbsup:

Looking Good. ;)

Nice Zero. Cheers, :thumbup:

Willie Nelson Hmm... Never heard if him.. Youtube to the rescue :P

Music I Was listening to some music and decided to make a little Thread. What kind of music do you like? Hop hop, Rap, Rock'n'rool, etc..... So if you don`t mind, Would you post your. ]TOP 5 Bands TOP 5 Song Anyway`s hers mine. :D Top 5 bands 1: Linkin Park 2: Coldplay 3: The Rasmus 4: Green Day 5: Snow Patrol Top 5 songs 1: In the shadows - The Rasmus 2: Braking the Habit - Linkin Park 3: Viva la vida - Coldplay 4: What ive done - Linkin Park 5: 21 Guns - Green Day Now most of the music i like is Mosher type. I Wouldn't call myself one but i understand why then enjoy listening to it. :thumbup:

Working. 8| Cheers. :thumbsup:

Wow great. 8o But small problem.... QUERY ERROR: Unknown column 'loan' in 'field list' Query was UPDATE users SET loan = loan + 5000, money = money + 5000 WHERE userid = 1 I Was no good with these kind of things. Reserach shall be done. But if you have the code mind posting? :D Cheers

Cheers Eternal I Saw the problem but you already fixed it so i thank you. :P

Nice Free Mod. :D

Well to be honest the Casinos are getting abit poo on Games. Mind making one thats intresting? :P Ohh and Jobs.php Ive looked through MWG and carnt seam to find any for V2. Mind whiping one up? :thumbup:

Lol sorry pudda. Plus i told you on MSN. :huh: Call to a member function query() on a non-object in /home/chaotic/public_html/usersonline.php on line 45 Nope. :( :( ):

Yeah i know. While speaking to Pudda on MSN i said that to him and adding / $q=$db->query("SELECT `username`,`userid`,`laston`,`gender`,`money`,`level` FROM users WHERE laston>unix_timestamp()-5*60 ORDER BY laston DESC"); He just replied back. Phail. :P Somthing about   case 'fiveminutes': fiveminutes(); break; case 'thirtyminutes': thirtyminutes(); break; case 'onehour': onehour(); break; case 'oneday': oneday(); break; default: index(); break;   The right function or somthing? :rolleyes:

Hey guys Having abit of trouble with a code. Problem: When clicking on USERSONLINE.PHP no user appear to come up. If i click FIVE MINS it shows how many people were on in the last 5 Minutes. I Was wondering could any one help me with this? :D BTW Found on MWG, Edited by Jordan - Pudda <?php require ("globals.php"); switch($_GET['online']) { case 'fiveminutes': fiveminutes(); break; case 'thirtyminutes': thirtyminutes(); break; case 'onehour': onehour(); break; case 'oneday': oneday(); break; default: index(); break; } function index() { print " <table width='90%' border='1' height='20'> <tr> <th><u>[url='usersonline.php?online=fiveminutes']Five Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=thirtyminutes']Thirty Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=onehour']One Hour[/url]</u></th> <th><u>[url='usersonline.php?online=oneday']One Day[/url]</u></th> </tr> </table>"; } function fiveminutes() { global $db; print " <table width='90%' border='1' height='20'> <tr> <th><u>[url='usersonline.php?online=fiveminutes']Five Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=thirtyminutes']Thirty Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=onehour']One Hour[/url]</u></th> <th><u>[url='usersonline.php?online=oneday']One Day[/url]</u></th> </tr> </table>"; echo "<table width='90%' border='1' height='20'> <tr> <th height='6'><u>Order</u></th> <th><u>Name</u></th> <th><u>ID</u></th> <th><u>Level</u></th> <th><u>Gender<u/></th> <th><u>Last Action<u/></th> <th><u>Money</u></th> <th><u>Attack</u></th> </tr>"; $q=$db->query("SELECT `username`,`userid`,`laston`,`gender`,`money`,`level` FROM users WHERE laston>unix_timestamp()-5*60 ORDER BY laston DESC"); while($r=mysql_fetch_array($q)) { $la=time()-$r['laston']; $unit="secs"; if($la >= 60) { $la=(int) ($la/60); $unit="mins"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } if($r['laston'] > 0) { $la=time()-$r['laston']; $unit="seconds"; if($la >= 60) { $la=(int) ($la/60); $unit="minutes"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $str="$la $unit ago"; } else { $str="--"; } if($r['last_login'] > 0) { $ll=time()-$r['last_login']; $unit2="seconds"; if($ll >= 60) { $ll=(int) ($ll/60); $unit2="minutes"; } if($ll >= 60) { $ll=(int) ($ll/60); $unit2="hours"; if($ll >= 24) { $ll=(int) ($ll/24); $unit2="days"; } } $str2="$ll $unit2 ago"; } else { $str2="--"; } $cn++; echo "<tr> <th>$cn.</th> <th>[url='viewuser.php?u=".$r[']".rasheed($r['username'])."[/url]</th> <th>".rasheed($r['userid'])."</th> <th>".rasheed($r['level'])."</th> <th>".$r['gender']."</th> <th>$str</th> <th>$".rasheed($r['money'])."</th> <th><a href='attack.php?ID=".$r['userid']."'>Attack ".$r['gender']." "; if($r['gender'] == 'Female') { echo "her"; } else { echo "him"; } echo "</a></th> </tr>"; } echo "</table>";} function thirtyminutes() { global $db; print " <table width='90%' border='1' height='20'> <tr> <th><u>[url='usersonline.php?online=fiveminutes']Five Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=thirtyminutes']Thirty Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=onehour']One Hour[/url]</u></th> <th><u>[url='usersonline.php?online=oneday']One Day[/url]</u></th> </tr> </table>"; echo "<table width='90%' border='1' height='20'> <tr> <th height='6'><u>Order</u></th> <th><u>Name</u></th> <th><u>ID</u></th> <th><u>Level</u></th> <th><u>Gender<u/></th> <th><u>Last Action<u/></th> <th><u>Money</u></th> <th><u>Attack</u></th> </tr>"; $q=$db->query("SELECT `username`,`userid`,`laston`,`gender`,`money`,`level` FROM users WHERE laston>unix_timestamp()-30*60 ORDER BY laston DESC"); while($r=mysql_fetch_array($q)) { $la=time()-$r['laston']; $unit="secs"; if($la >= 60) { $la=(int) ($la/60); $unit="mins"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } if($r['laston'] > 0) { $la=time()-$r['laston']; $unit="seconds"; if($la >= 60) { $la=(int) ($la/60); $unit="minutes"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $str="$la $unit ago"; } else { $str="--"; } if($r['last_login'] > 0) { $ll=time()-$r['last_login']; $unit2="seconds"; if($ll >= 60) { $ll=(int) ($ll/60); $unit2="minutes"; } if($ll >= 60) { $ll=(int) ($ll/60); $unit2="hours"; if($ll >= 24) { $ll=(int) ($ll/24); $unit2="days"; } } $str2="$ll $unit2 ago"; } else { $str2="--"; } $cn++; echo "<tr> <th>$cn.</th> <th>[url='viewuser.php?u=".$r[']".rasheed($r['username'])."[/url]</th> <th>".rasheed($r['userid'])."</th> <th>".rasheed($r['level'])."</th> <th>".$r['gender']."</th> <th>$str</th> <th>$".rasheed($r['money'])."</th> <th><a href='attack.php?ID=".$r['userid']."'>Attack ".$r['gender']." "; if($r['gender'] == 'Female') { echo "her"; } else { echo "him"; } echo "</a></th> </tr>"; } echo "</table>";} function onehour() { global $db; print " <table width='90%' border='1' height='20'> <tr> <th><u>[url='usersonline.php?online=fiveminutes']Five Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=thirtyminutes']Thirty Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=onehour']One Hour[/url]</u></th> <th><u>[url='usersonline.php?online=oneday']One Day[/url]</u></th> </tr> </table>"; echo "<table width='90%' border='1' height='20'> <tr> <th height='6'><u>Order</u></th> <th><u>Name</u></th> <th><u>ID</u></th> <th><u>Level</u></th> <th><u>Gender<u/></th> <th><u>Last Action<u/></th> <th><u>Money</u></th> <th><u>Attack</u></th> </tr>"; $q=$db->query("SELECT `username`,`userid`,`laston`,`gender`,`money`,`level` FROM users WHERE laston>unix_timestamp()-60*60 ORDER BY laston DESC"); while($r=mysql_fetch_array($q)) { $la=time()-$r['laston']; $unit="secs"; if($la >= 60) { $la=(int) ($la/60); $unit="mins"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } if($r['laston'] > 0) { $la=time()-$r['laston']; $unit="seconds"; if($la >= 60) { $la=(int) ($la/60); $unit="minutes"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $str="$la $unit ago"; } else { $str="--"; } if($r['last_login'] > 0) { $ll=time()-$r['last_login']; $unit2="seconds"; if($ll >= 60) { $ll=(int) ($ll/60); $unit2="minutes"; } if($ll >= 60) { $ll=(int) ($ll/60); $unit2="hours"; if($ll >= 24) { $ll=(int) ($ll/24); $unit2="days"; } } $str2="$ll $unit2 ago"; } else { $str2="--"; } $cn++; echo " <th>$cn.</th> <th>[url='viewuser.php?u=".$r[']".rasheed($r['username'])."[/url]</th> <th>".rasheed($r['userid'])."</th> <th>".rasheed($r['level'])."</th> <th>".$r['gender']."</th> <th>$str</th> <th>$".rasheed($r['money'])."</th> <th><a href='attack.php?ID=".$r['userid']."'>Attack ".$r['gender']." "; if($r['gender'] == 'Female') { echo "her"; } else { echo "him"; } echo "</a></th> </tr>"; } echo "</table>";} function oneday() { global $db; print " <table width='90%' border='1' height='20'> <tr> <th><u>[url='usersonline.php?online=fiveminutes']Five Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=thirtyminutes']Thirty Minutes[/url]</u></th> <th><u>[url='usersonline.php?online=onehour']One Hour[/url]</u></th> <th><u>[url='usersonline.php?online=oneday']One Day[/url]</u></th> </tr> </table>"; echo "<table width='90%' border='1' height='20'> <tr> <th height='6'><u>Order</u></th> <th><u>Name</u></th> <th><u>ID</u></th> <th><u>Level</u></th> <th><u>Gender<u/></th> <th><u>Last Action<u/></th> <th><u>Money</u></th> <th><u>Attack</u></th> </tr>"; $q=$db->query("SELECT `username`,`userid`,`laston`,`gender`,`money`,`level` FROM users WHERE laston>unix_timestamp()-1440*60 ORDER BY laston DESC"); while($r=mysql_fetch_array($q)) { $la=time()-$r['laston']; $unit="secs"; if($la >= 60) { $la=(int) ($la/60); $unit="mins"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } if($r['laston'] > 0) { $la=time()-$r['laston']; $unit="seconds"; if($la >= 60) { $la=(int) ($la/60); $unit="minutes"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $str="$la $unit ago"; } else { $str="--"; } if($r['last_login'] > 0) { $ll=time()-$r['last_login']; $unit2="seconds"; if($ll >= 60) { $ll=(int) ($ll/60); $unit2="minutes"; } if($ll >= 60) { $ll=(int) ($ll/60); $unit2="hours"; if($ll >= 24) { $ll=(int) ($ll/24); $unit2="days"; } } $str2="$ll $unit2 ago"; } else { $str2="--"; } $cn++; echo "<tr> <th>$cn.</th> <th>[url='viewuser.php?u=".$r[']".rasheed($r['username'])."[/url]</th> <th>".rasheed($r['userid'])."</th> <th>".rasheed($r['level'])."</th> <th>".$r['gender']."</th> <th>$str</th> <th>$".rasheed($r['money'])."</th> <th><a href='attack.php?ID=".$r['userid']."'>Attack ".$r['gender']." "; if($r['gender'] == 'Female') { echo "her"; } else { echo "him"; } echo "</a></th> </tr>"; } echo "</table>";} $h->endpage(); ?> Cheers, Rasheed :D