Satans_Pimp

Item Market Viewing all listings... QUERY ERROR: Unknown column 'im.ilogITEM' in 'on clause' Query was SELECT im.*, i.*, u.*,it.* FROM itemmarket im LEFT JOIN items i ON im.ilogITEM=i.itmid LEFT JOIN users u ON u.userid=im.ilogSELLER LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid ORDER BY i.itmtype, i.itmname ASC Can someone please help :?

Re: estate.php anyone :?

Re: estate.php i have tried to add s different estates but get the same result..   <?php include "globals.php"; $mpq=$db->query("SELECT * FROM houses WHERE hWILL={$ir['maxwill']}"); $mp=$db->fetch_row($mpq); $_GET['property']=abs((int) $_GET['property']); if($_GET['property']) { $npq=$db->query("SELECT * FROM houses WHERE hID={$_GET['property']}"); $np=$db->fetch_row($npq); if($np['hWILL'] < $mp['hWILL']) { print "You cannot go backwards in houses!"; } else if ($np['hPRICE'] > $ir['money']) { print "You do not have enough money to buy the {$np['hrNAME']}."; } else { $db->query("UPDATE users SET money=money-{$np['hPRICE']},will=0,maxwill={$np['hWILL']} WHERE userid=$userid"); print "Congrats, you bought the {$np['hNAME']} for \${$np['hPRICE']}!"; } } else if (isset($_GET['sellhouse'])) { $npq=$db->query("SELECT * FROM houses WHERE hWILL={$ir['maxwill']}"); $np=$db->fetch_row($npq); if($ir['maxwill'] == 100) { print "You already live in the lowest property!"; } else { $hprice=$np['hPRICE']; $db->query("UPDATE users SET money=money+{$hprice},will=0,maxwill=100 WHERE userid=$userid"); print "You sold your {$np['hNAME']} and went back to your shed."; } } else { print "<center>Your current property: <font color=red>[b]{$mp['hNAME']}[/b]</font> The houses you can buy are listed below. Click a house to buy it. "; print "[url='estate.php?sellhouse']Sell Your Property[/url] "; if($ir['willmax'] < 100) { print "[url='estate.php?sellhouse']Sell Your Property[/url] "; } $hq=$db->query("SELECT * FROM houses WHERE hWILL>{$ir['maxwill']} ORDER BY hWILL ASC"); while($r=$db->fetch_row($hq)) { print " <table cellspacing=1 class='table'><tr style='background:gray;'><th>House</th><th>House Price</th><th>House Will</th><th>Tax</th>Tax<th>Buy?</th></tr>"; $hq=$db->query("SELECT * FROM houses WHERE hWILL>{$ir['maxwill']} ORDER BY hWILL ASC"); while($r=$db->fetch_row($hq)) { print "<tr><td>{$r['hNAME']}</a></td><td>\$$t".money_formatter($r['hPRICE'],'')."</td><td>{$r['hWILL']}</td><td>{$r2['hTAX']}</td><td><a href='estate.php?property={$r['hID']}'>Buy</tr>"; } print "</table>"; } } $h->endpage(); ?>

on estate i can buy a house but it wont keep the house..does anyone know why this would be..i been trying and trying to figure out why..just don't see it.. B.T.W it takes the money also have no error code to show? Thanks for any help giving

Re: [mccode] Mail Signatures! so how whould i fix the problem?

Re: [mccode] Mail Signatures! I tried and tried and still cant get it to work i am using v2 got everything working right except cant send mail..i keep getting this msg Please do not select a contact AND enter a username, only do one. > Back thanks for the support :-D

Re: battlearena yeap i have V2 would anyone mind helping me to get this to v2?

Re: FREE ADVANCED USERSONLINE MOD V2   <?php // Made by Daniel Robert // Free mod advanced useronline for v1 // Please do not resell // Please leave this note // Other than that have a nice time // Don't do drugs. They aren't good for you. // Usersonline.php include "globals.php"; $cn=0; echo "<table width='500' border='2' height='20' class='table' bordercolor='#666666'> <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>Location</u></th> <th><u>Gang</u></th> <th><u>Attack</u></th> </tr>"; $q=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-15*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++; $gq=mysql_query("SELECT g.*,oc.* FROM gangs g LEFT JOIN orgcrimes oc ON g.gangCRIME=oc.ocID WHERE g.gangID={$r['gang']}",$c);$gangdata=mysql_fetch_array($gq); $cz = mysql_query("SELECT * FROM `cities` WHERE `cityid` = '".$r["location"]."'"); $ck = mysql_fetch_array($cz); echo "<tr> <td>$cn.</td> <td>[url='viewuser.php?u={$r[']{$r['username']}[/url]</td> <td>{$r['userid']}</td> <td>{$r['level']}</td> <td>{$r['gender']}</td> <td>$str</td> <td>$".money_formatter($r['money'], "")."</td> <td>{$ck['cityname']}</td> <td>[url='gangs.php?action=view&ID={$r[']<font color=red>{$gangdata['gangNAME']}[/url]</font></td> <td><a href='attack.php?ID={$r['userid']}'>Attack "; if($r['gender'] == 'Female') { echo "Her"; } else { echo "Him"; } echo "</a></td> </tr>"; } echo "</table>"; $h->endpage(); ?>

Re: [TGM] Joinable Organised Crimes [TGM] Preach on brother!!!

Re: BANK cap V2 Thank you Seanybob +1 :-D

NOOB ALERT!!!!! :evil: how do i remove the cap from the bank? thanks :-D

Re: [FREE][CRYSTAL GYM]   thats for V2

Re: [mccode] Close page system ok V2 cant say it works ..but Here it is

Re: FREE ADVANCED USERSONLINE MOD This works for V2 but the location only shows the # of location :?Yes I realize Lostone posted the code but could not get it to work right.Thanks for the help :-D <?php // Made by Daniel Robert // Free mod advanced useronline for v1 // Please do not resell // Please leave this note // Other than that have a nice time // Don't do drugs. They aren't good for you. // Usersonline.php session_start(); include "globals.php"; $cn=0; echo "<table width='500' border='2' 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>Location<u/></th> <th><u>Last Action<u/></th> <th><u>Money</u></th> <th><u>Attack</u></th> </tr>"; $q=$db->query("SELECT * FROM users WHERE laston>unix_timestamp()-15*60 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"; } } 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[']{$r['username']}[/url]</th> <th>{$r['userid']}</th> <th>{$r['level']}</th> <th>{$r['gender']}</th> <th>{$r['location']}</th> <th>$str</th> <th>{$r['money']}</th> <th><a href='attack.php?ID={$r['userid']}'>Attack "; if($r['gender'] == 'Female') { echo "her"; } else { echo "him"; } echo "</a></th> </tr>"; } echo "</table>"; $h->endpage(); ?>

Re: [FREE][CRYSTAL GYM] V2 here it is EASy <?php include "globals.php"; print $out; print "Enter the amount of times you wish to train and choose the stat to train. You can train up to {$ir['crystals']} times. <form action='cgym.php' method='get'> <input type='text' name='times' value='1' /><select type='dropdown' name='train'> <option value='strength'>Strength</option> <option value='agility'>Speed</option> <option value='labour'>Work Skill</option> <option value='guard'>Defence</option></select> <input type='submit' value='Train!' /></form>"; $h->endpage(); ?>

Re: [TGM] Joinable Organised Crimes [TGM] DID this mod ever get FIXED??????

Re: [TGM] Federal Jail Court System [TGM]   Thank you both for your response we are indeed contacting Scarlet about this subject And hope other ppl do!!

Re: [TGM] Federal Jail Court System [TGM] I have to say it is hard to trust anyone from this forum or any other seems I been scammed 3 + now ..why is this community so evil cant be straight up..don't know who to trust.what a sad place..

Re: [TGM] Federal Jail Court System [TGM] Yeah my partner tried to get a response from this subject and never got any help..IT all seems to work but would never no ..I had MY game partner fed me nothing showed up.could not make a report? and yes seems no body wants to get involed with Cronus mod everone says the same thing to me way to many bugs ,but damm paid 20 bucks for Garbage would like to see it come to life?<yes I know $20 is not alot just the point> Almost feel like I we got rip off on this mod? BUt thank you Cruisey for your response!!!

Re: [TGM] Federal Jail Court System [TGM] DID Know one get this mod working ?

Re: Good Hosts? WE are going back to www.Hostmonster.com they have 24/7 phone tec's free and also cheap for what they give 5.95 a month they do have a different packs, 300 Gigabytes of Hosting Space Host UNLIMITED Domains!! Unlimited Pop/Imap Email Accounts SSH Access (Secure Shell) 3,000 Gigs of Transfer SSL, FTP, Stats CGI, Ruby (RoR), Perl, PHP, MYSQL Front Page Extensions Free Domain Forever Free Site Builder Best Support in the Industry +you get $30 free add word google search $50 free yahoo search service $50 Microsoft add center ppc add credits I dont make money off this site ..so it is just a great host comp..it went down once on us and the told us ETA back up and running over the phone..it just a great host site! more space then you will ever need but are you going to complain ..lol yes I have read all the post but this host comp was great we had no problems with them.and very easy to talk to.got all questions and answers answers in min.cant say that about many host sites.and never had a problem with lagging..cant wait to go back to them

Re: [TGM] Federal Jail Court System [TGM] WOW ppl have have made it that far i can not even get the damm thing to show up in fed jail to make a report :? :?dont know about to trash it..I have ask ppl to look at it and I was told way to many bugs.. :? :? :? :? :? :? :? :? :?dont know does any one know what is wrong w/ it :? :?By the way dont get any errors just dont show in fed jail

Re: Free Carnival works for me when i used it

Re: Free Carnival V2 carnigames.php <?php require "globals.php"; if($ir['tickets']<1) die("<center>You are out of tickets. [url='carnival.php']<font color=red>Go buy some</font>[/url]"); if ($_GET['action'] == 'balloon') { $bal=rand(1,100); if ($bal>=10) { print "You missed! [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } else { print "You pop a balloon and win 5 Crystals! "; $db->mysql_query("update users set tickets=tickets-5 where userid=$userid"); $db->query("update users set crystals=crystals+5 where userid=$userid"); } } if ($_GET['action'] == 'duck') { $dck=rand(1,10); if ($dck==1) { print "You picked up the duck with the number 1 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==2) { print "You picked up the duck with the number 2 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->$db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==3) { print "You picked up the duck with the number 3 on the bottom! You won 3 Crystals! [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); $db->query("update users set crystals=crystals+3 where userid=$userid"); } if ($dck==4) { print "You picked up the duck with the number 4 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==5) { print "You picked up the duck with the number 5 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==6) { print "You picked up the duck with the number 6 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==7) { print "You picked up the duck with the number 7 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==8) { print "You picked up the duck with the number 8 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==9) { print "You picked up the duck with the number 9 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($dck==10) { print "You picked up the duck with the number 10 on the bottom! Sorry the lucky number was 3 [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } } if ($_GET['action'] == 'strongman') { $mrk=rand(1,10); if ($mrk==1) { print "You pick up the hammer and swing! The little marker barely moves...pityful [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==2) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...weakling [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==3) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...wimpy [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==4) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...give it up [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==5) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...only halfway how sad [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==6) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...getting there [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==7) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...almost [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==8) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...Good Girl [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==9) { print "You pick up the hammer and swing! The marker moves up a little to the spot that says ...Good boy [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($mrk==10) { print "You pick up the hammer and swing! You hear the bell ring!!! You won 2 Demon Claws [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); $db->query("update users set crystals=crystals+2 where userid=$userid"); } } if ($_GET['action'] == 'dunk') { print"staffmember is currently in the Dunking Booth "; $bal=rand(1,10); if ($bal==1) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==2) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==3) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==4) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==5) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==6) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==7) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==8) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==9) { print "You throw the ball and miss so staff taunts you [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); } if ($bal==10) { print "You throw the ball and hit the target and staff goes for a dip!!! You won 5 crystals [url='carnival.php']Back[/url]"; $db->query("update users set tickets=tickets-5 where userid=$userid"); $db->query("update users set crystals=crystals+5 where userid=$userid"); } } ?>   carnival.php <?php require "globals.php"; if($ir['jail']>0 || $ir['hospital']>0) die("<center>You can not move around right now."); if(!$_GET['buy']) { print "<h2><center>Welcome to the Carnival. You currently have {$ir['tickets']} tickets do you want to buy some?</h2></center>"; print "<center>What would you like to do? <table BORDER=2 CELLPADDING=2 CELLSPACING=2> <tr><td> [url='carnival.php?buy=ticket']Buy Tickets - $5000 for 5 tickets[/url] </td><td> [url='carnigames.php?action=balloon'] Balloon Dart Game - 5 Tickets per dart.[/url] </td></tr> <tr><td> [url='carnigames.php?action=duck']Lucky Ducks - 5 Tickets per duck[/url] </center></td> <td> [url='carnigames.php?action=strongman']Strongman Game - 5 Tickets per swing[/url] </center></td> </tr> <tr><td> [url='carnigames.php?action=dunk']Dunking Booth - 5 Tickets per throw[/url] </center></td> </tr> </table>"; } else { if($_GET['buy'] == 'ticket') { if($ir['money'] <5000) { print "You don't have enough money for tickets"; } else { $db->query("UPDATE users SET money=money-5000,tickets=tickets+5 WHERE userid=$userid"); print "You have paid $5000 for 5 carnival tickets."; } } } ?>   php_my_admin alter table users add `tickets` int(11) NOT NULL default '0';

Re: Mod Discussion Combined Mods (2 coders make one big mod) Well this is always great 2 minds better then one some times!!! Graphic Mods----again great for stuff like what you and twysted did on the pick 3 mod Non-Graphical Mods-----well not all mods need grafics Little Addons-----like forum (0) was great Anti-Piracy Mods-----well that is always gd