CJ - Twitch

  Done, Original post updated. Thanks a lot! Also does this work with v1 also?

Great Idea! I will test soon! :)

Thank you! Do you think you could make it so you can send a message when sending things.

I know this is a old topic.. maybe? Does it work with v2? Or is it v2? I can't get it to work... Please help, CJ

Thank you guys I fixed it :) I needed to delete a field that I had from an old mod ;)

Lol Its the default one. xD

Ok thanks :) I was just trying to learn how to use tables xD

its the attack won code ...

When i attack some one I get this error QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO events VALUES('',4,UNIX_TIMESTAMP(),0,'Twitch mugged you and stole $0.')   What is this? I also get this on many other things like sending money. Help would be appreciated. Thank you, CJ

Screenies added! Ok I have added screen shots now. Please rate plus if you like it. Enjoy, CJ.

Sorry please replace city.php with explore.php.

Ok so I "recoded" this monorail. It is more of a visual "recode" please rate + Call this travel.php <?php include "globals.php"; print "<font face='Arial' size='4'>Travel</font><hr width='85%'>"; $_GET['to'] = abs((int) $_GET['to']); if(!$_GET['to']) { print "Welcome to the train station. Tickets cost $10,000. Where would you like to travel?<hr width=85%> "; $q=$db->query("SELECT * FROM cities WHERE cityid != {$ir['location']} AND cityminlevel <= {$ir['level']}"); print "<table border='0' width=85% bgcolor=#DEDEDE><tr bgcolor=#999999> <TH>City</TH> <TH>Description</TH> <TH>Min Level</TH> <TH>Travel?</TH> <tr>"; while($r=$db->fetch_row($q)) { print " <TD>{$r['cityname']}</TD> <TD>{$r['citydesc']}</TD> <TD>{$r['cityminlevel']}</TD> <TD>[url='travel.php?to={$r[']Travel[/url]</TD></tr>"; } print "</table> "; print "<hr width='85%'>> [url='city.php']Back[/url]<hr width='85%'>"; } else { if($ir['money'] < 10000) { print " Sorry you don't have enough money."; print "<hr width='85%'>> [url='city.php']Back[/url]<hr width='85%'>"; } else if( ((int) $_GET['to']) != $_GET['to']) { print "Sorry invalid city ID"; print "<hr width='85%'>> [url='city.php']Back[/url]<hr width='85%'>"; } else { $q=$db->query("SELECT * FROM cities WHERE cityid = {$_GET['to']} AND cityminlevel <= {$ir['level']}"); if(!$db->num_rows($q)) { print "Sorry this city does not exist."; print "<hr width='85%'>> [url='city.php']Back[/url]<hr width='85%'>"; } else { $db->query("UPDATE users SET money=money-10000,location={$_GET['to']} WHERE userid=$userid"); $r=$db->fetch_row($q); print "You paid \$10,000 and travelled to {$r['cityname']} on the train, congratulations."; print "<hr width='85%'>> [url='city.php']Back[/url]<hr width='85%'>"; } } } $h->endpage(); ?> I only changed the visual looks so give the credit to DBS please :) Thanks, CJ Screenies: White line to separate screenies. :P Thanks again, CJ

First I would like to say I didn't make this! Im just trying to convert it to work with Richards faction mod [v2]   function faction_online() { echo "<h3>Users Online</h3> "; $cn=0; $q=$db->query("SELECT `laston`, `userid`, `username` FROM `users` WHERE `faction`=".$factiondata['faID']." ORDER BY laston DESC"); while($r=$db->fetch_row($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"; } } $cn++; echo "$cn. [url='viewuser.php?u={$r[']".stripslashes(htmlspecialchars($r['username']))."[/url] ($la $unit) "; } }   It shows users in your gang that are online. Please give credit to Twisted. Thanks, CJ.