HITMAN 17

Re: [mccode] Supporter Packs   CREATE TABLE `sps_process` ( ```sp_id``` int(11) NOT NULL default '0', ```sp_userid``` int(11) NOT NULL default '0', ```sp_time``` int(11) NOT NULL default '0', ```sp_type``` varchar(255) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; thats y mate

Re: Help With level cap vr1   if u do it properly it shud work yes

Re: honourexchange.php you shud use iseeyou's honours there much better and neater

Re: honourexchange.php try this <?php include "globals.php"; if(!$_GET['spend']) { print "Welcome to the Honor Award Exchange Center! You have [b]{$ir['honor']}[/b] Honor Awards. What would you like to spend your Honor Awards on? [url='HonorExchange.php?spend=IQ']IQ - 100 IQ per Honor Award[/url] [url='HonorExchange.php?spend=labour3']Trade for Labour Points - 3,000 Labour Points per Honor Award[/url] [url='HonorExchange.php?spend=guard3']Trade for Defense - 3,000 Defense per Honor Award[/url] [url='HonorExchange.php?spend=agility3']Trade for Agility - 3,000 Speed per Honor Award[/url] [url='HonorExchange.php?spend=strength3']Trade for Strength - 3,000 strength per Honor Award[/url] [url='HonorExchange.php?spend=money']Money - \$2,000,000 per Honor Award[/url] "; } else if($_GET['spend'] == 'IQ') { print "Type in the amount of Honor Awards you want to swap for IQ. You have [b]{$ir['honor']}[/b] Honor Awards. One Honor Award = 100 IQ.<form action='HonorExchange.php?spend=IQ2' method='post'><input type='text' name='honor' /> <input type='submit' value='Swap' /></form>"; } else if($_GET['spend'] == 'IQ2') { $_POST['honor']=(int) $_POST['honor']; if($_POST['honor'] <= 0 || $_POST['honor'] > $ir['honor']) { print "Error, you either do not have enough Honor Awards or did not fill out the form. [url='HonorExchange.php?spend=IQ']Back[/url]"; } else { $iqgain=$_POST['honor']*100; $_POST['honor']=strip_tags($_POST['honor']); $_POST['honor']=mny_stripfmt($_POST['honor']); $_POST['honor']=abs((int)($_POST['honor'])); mysql_query("UPDATE users SET honor=honor-{$_POST['honor']} WHERE userid=$userid",$c); mysql_query("UPDATE userstats SET IQ=IQ+$iqgain WHERE userid=$userid",$c); print "You traded {$_POST['honor']} Honor Awards for $iqgain IQ."; } } else if($_GET['spend'] == 'labour3') { print "Type in the amount of Honor Awards you want to swap for labour points. You have [b]{$ir['honor']}[/b] Honor Awards. One Honor Award = 300,000 labour points.<form action='HonorExchange.php?spend=labour4' method='post'><input type='text' name='honor' /> <input type='submit' value='Swap' /></form>"; } else if($_GET['spend'] == 'labour4') { $_POST['honor']=(int) $_POST['honor']; if($_POST['honor'] <= 0 || $_POST['honor'] > $ir['honor']) { print "Error, you either do not have enough Honor Awards or did not fill out the form. [url='HonorExchange.php?spend=labour3']Back[/url]"; } else { $labourgain=$_POST['honor']*3000; $_POST['honor']=strip_tags($_POST['honor']); $_POST['honor']=mny_stripfmt($_POST['honor'], ENT_QUOTES); $_POST['honor']=abs((int)($_POST['honor'])); mysql_query("UPDATE users SET honor=honor-{$_POST['honor']} WHERE userid=$userid",$c); mysql_query("UPDATE userstats SET labour=labour+$labourgain WHERE userid=$userid",$c); print "You traded {$_POST['honor']} Honor Awards for $labourgain labour points."; } } else if($_GET['spend'] == 'guard3') { print "Type in the amount of Honor Awards you want to swap for Defense. You have [b]{$ir['honor']}[/b] Honor Awards. One Honor Award = 3,000 Defense.<form action='HonorExchange.php?spend=guard4' method='post'><input type='text' name='honor' /> <input type='submit' value='Swap' /></form>"; } else if($_GET['spend'] == 'guard4') { $_POST['honor']=(int) $_POST['honor']; $_POST['honor']=strip_tags($_POST['honor']); $_POST['honor']=mny_stripfmt($_POST['honor'], ENT_QUOTES); $_POST['honor']=abs((int)($_POST['honor'])); if($_POST['honor'] <= 0 || $_POST['honor'] > $ir['honor']) { print "Error, you either do not have enough Honor Awards or did not fill out the form. [url='HonorExchange.php?spend=guard3']Back[/url]"; } else { $guardgain=$_POST['honor']*3000; $_POST['honor']=strip_tags($_POST['honor']); $_POST['honor']=mny_stripfmt($_POST['honor'], ENT_QUOTES); $_POST['honor']=abs((int)($_POST['honor'])); mysql_query("UPDATE users SET honor=honor-{$_POST['honor']} WHERE userid=$userid",$c); mysql_query("UPDATE userstats SET guard=guard+$guardgain WHERE userid=$userid",$c); print "You traded {$_POST['honor']} Honor Awards for $guardgain Defense."; } } else if($_GET['spend'] == 'agility3') { print "Type in the amount of Honor Awards you want to swap for Agility. You have [b]{$ir['honor']}[/b] Honor Awards. One Honor Award = 3,000 Agility.<form action='HonorExchange.php?spend=agility4' method='post'><input type='text' name='honor' /> <input type='submit' value='Swap' /></form>"; } else if($_GET['spend'] == 'agility4') { $_POST['honor']=(int) $_POST['honor']; if($_POST['honor'] <= 0 || $_POST['honor'] > $ir['honor']) { print "Error, you either do not have enough Honor Awards or did not fill out the form. [url='HonorExchange.php?spend=agility3']Back[/url]"; } else { $agilitygain=$_POST['honor']*3000; $_POST['honor']=strip_tags($_POST['honor']); $_POST['honor']=mny_stripfmt($_POST['honor'], ENT_QUOTES); $_POST['honor']=abs((int)($_POST['honor'])); mysql_query("UPDATE users SET honor=honor-{$_POST['honor']} WHERE userid=$userid",$c); mysql_query("UPDATE userstats SET agility=agility+$agilitygain WHERE userid=$userid",$c); print "You traded {$_POST['honor']} Honor Awards for $agilitygain Agility."; } } else if($_GET['spend'] == 'strength3') { print "Type in the amount of Honor Awards you want to swap for Strength. You have [b]{$ir['honor']}[/b] Honor Awards. One Honor Award = 3,000 Strength.<form action='HonorExchange.php?spend=strength4' method='post'><input type='text' name='honor' /> <input type='submit' value='Swap' /></form>"; } else if($_GET['spend'] == 'strength4') { $_POST['honor']=(int) $_POST['honor']; if($_POST['honor'] <= 0 || $_POST['honor'] > $ir['honor']) { print "Error, you either do not have enough Honor Awards or did not fill out the form. [url='HonorExchange.php?spend=strength3']Back[/url]"; } else { $strengthgain=$_POST['honor']*3000; $_POST['honor']=strip_tags($_POST['honor']); $_POST['honor']=mny_stripfmt($_POST['honor'], ENT_QUOTES); $_POST['honor']=abs((int)($_POST['honor'])); mysql_query("UPDATE users SET honor=honor-{$_POST['honor']} WHERE userid=$userid",$c); mysql_query("UPDATE userstats SET strength=strength+$strengthgain WHERE userid=$userid",$c); print "You traded {$_POST['honor']} Honor Awards for $strengthgain Strength."; } } else if($_GET['spend'] == 'money') { print "Type in the amount of Honor Awards you want to swap for \$\$\$. You have [b]{$ir['honor']}[/b] Honor Awards. One Honor Award = \$2,000,000.<form action='HonorExchange.php?spend=money2' method='post'><input type='text' name='honor' /> <input type='submit' value='Swap' /></form>"; } else if($_GET['spend'] == 'money2') { $_POST['honor']=(int) $_POST['honor']; if($_POST['honor'] <= 0 || $_POST['honor'] > $ir['honor']) { print "Error, you either do not have enough Honor Awards or did not fill out the form. [url='HonorExchange.php?spend=money']Back[/url]"; } else { $iqgain=$_POST['honor']*2000000; $_POST['honor']=strip_tags($_POST['honor']); $_POST['honor']=mny_stripfmt($_POST['honor'], ENT_QUOTES); $_POST['honor']=abs((int)($_POST['honor'])); $_POST['money']=strip_tags($_POST['money']); $_POST['money']=mny_stripfmt($_POST['money'], ENT_QUOTES); $_POST['money']=abs($_POST['money']); mysql_query("UPDATE users SET honor=honor-{$_POST['honor']},money=money+$iqgain WHERE userid=$userid",$c); print "You traded {$_POST['honor']} Honor Awards for \$$iqgain."; } } $h->endpage(); ?>

Re: [Free] Jail / Prison as i am still a noob isomer where do u think i shud add the jail for crimes

Re: [Free] [v1] Jail wats the code to add if u fail a crime u got to jail and where abouts to add it

Re: [V2]Crystal Smuggling Mod[V2] ye i do lol and now i get this You Can Only Go Sailing Once A Day and i have 20 sails

Re: [V2]Crystal Smuggling Mod[V2]   PDATE `users` ADD `csmuggling` int( 11 ) NOT NULL default '10' MySQL said: Documentation #1064 - 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 'ADD `csmuggling` int(11) NOT NULL default'10'' at line 1

Re: [mccode] Profile Signatures this is my v2 view userpofile and it is not showing anyone know y   <?php include "globals.php"; $_GET['u'] = abs((int) $_GET['u']); if(!$_GET['u']) { print "Invalid use of file"; } else { $q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}"); if($db->num_rows($q) == 0) { print "Sorry, we could not find a user with that ID, check your source."; } else { $r=$db->fetch_row($q); if($r['user_level'] == 1) { $userl="Member"; } else if($r['user_level'] == 2) { $userl="Admin"; } else if ($r['user_level'] == 3) { $userl="Secretary"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="Assistant"; } $lon=($r['laston'] > 0) ?date('F j, Y g:i:s a',$r['laston']) : "Never"; $sup=date('F j, Y g:i:s a',$r['signedup']); $ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ']; $d=""; 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="--"; } if($r['donatordays']) { $r['username'] = "<font color=red>{$r['username']}</font>";$d="[img=donator.gif]"; } if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; } print "<h3>Profile for {$r['username']}</h3> <table width=100% cellspacing=1 class='table'><tr style='background:gray'><th>General Info</th><th>Financial Info</th> <th>Display Pic</th></tr> <tr><td>Name: {$r['username']} [{$r['userid']}] $d User Level: $userl Duties: {$r['duties']} Gender: {$r['gender']} Signed Up: $sup Last Active: $lon Last Action: $str Last Login: $str2 Online: $on [b]Days Old:[/b] {$r['daysold']} Days Old "; $w=$db->query("SELECT * FROM warnings WHERE user={$r['userid']}",$c); print " <font color=red>Warnings: ".mysql_num_rows($w)." "; if($ir['user_level'] > 1) { print "|| [<a href=warnings.php?action=index&user={$r['userid']}>Manage</a>]"; } print " Location: {$r['cityname']}</td><td> Money: \${$r['money']} Crystals: {$r['crystals']} Property: {$r['hNAME']} Referals: "; $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print " Friends: {$r['friend_count']} Enemies: {$r['enemy_count']} </td> <td>"; if($r['display_pic']) { print "[img={$r[]"; } else { print "This user has no display pic!"; } $sh=($ir['user_level'] >1) ? "Staff Info" : " "; print "</td></tr> <tr style='background:gray'><th>Physical Info</th><th>Links</th><th>$sh</th></tr> <tr><td>Level: {$r['level']} Health: {$r['hp']}/{$r['maxhp']} Gang: "; if($r['gang']) { print "[url='gangs.php?action=view&ID={$r[']{$r['gangNAME']}[/url]"; } else { print "N/A"; } if($r['fedjail']) { print " [b]<font color=red>In federal jail for {$r['fed_days']} day(s). {$r['fed_reason']}</font>"; } if($r['hospital']) { print " [b]<font color=red>In hospital for {$r['hospital']} minutes. {$r['hospreason']}</font>[/b]"; } if($r['jail']) { print " [b]<font color=red>In jail for {$r['jail']} minutes. {$r['jail_reason']}</font>[/b]"; } print "</td><td>[[url='mailbox.php?action=compose&ID={$r[']Send Mail[/url]] [[url='sendcash.php?ID={$r[']Send Cash[/url]] [[url='assassin.php?ID={$r[']Assassinate[/url]] "; if($set['sendcrys_on']) { print "[[url='sendcrys.php?ID={$r[']Send Crystals[/url]] "; } if($set['sendbank_on']) { if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0) { print "[[url='sendbank.php?ID={$r[']Bank Xfer[/url]] "; } if($ir['cybermoney'] >= 0 && $r['cybermoney'] >= 0) { print "[[url='sendcyber.php?ID={$r[']CyberBank Xfer[/url]] "; } } print " [[url='attack.php?ID={$r[']Attack[/url]] [[url='contactlist.php?action=add&ID={$r[']Add Contact[/url]]"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { print " [[url='jailuser.php?userid={$r[']Jail[/url]] [[url='mailban.php?userid={$r[']MailBan[/url]]"; } if($ir['donatordays'] > 0) { print " [[url='friendslist.php?action=add&ID={$r[']Add Friends[/url]] [[url='blacklist.php?action=add&ID={$r[']Add Enemies[/url]] "; } print "</td><td>"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { $r['lastiph']=@gethostbyaddr($r['lastip']); $r['lastiph']=checkblank($r['lastiph']); $r['lastip_loginh']=@gethostbyaddr($r['lastip_login']); $r['lastip_loginh']=checkblank($r['lastip_loginh']); $r['lastip_signuph']=@gethostbyaddr($r['lastip_signup']); $r['lastip_signuph']=checkblank($r['lastip_signuph']); print "<h3>Internet Info</h3><table width='100%' border='0' cellspacing='1' class='table'> <tr><td></td><td class='h'>IP</td><td class='h'>Hostname</td></tr> <tr><td class='h'>Last Hit</td><td>$r[lastip]</td><td>$r[lastiph]</td></tr> <tr><td class='h'>Last Login</td><td>$r[lastip_login]</td><td>$r[lastip_loginh]</td></tr> <tr><td class='h'>Signup</td><td>$r[lastip_signup]</td><td>$r[lastip_signuph]</td></tr></table>"; print "<form action='staffnotes.php' method='post'> Staff Notes: <textarea rows=7 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea> <input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; } else { print " "; } print "</tr></table>"; } } function checkblank($in) { if(!$in) { return "N/A"; } return $in; } print "</td></tr> "; print " <table width=100%><tr style='background:gray'><th>Profile Signature</th> <tr><td rowspan='1'>"; if($r['signature']) { print "{$r['signature']}"; } else { print "[b]This User has no Profile Signature[/b]"; } print "</td></tr></table>"; $h->endpage(); ?>

i know its a bit late but i have been meaning to ask what your guys got for christmas i got ps3 with loads of games and clothes also some dedorant and a few other little things

Re: Advanced Dating (v1) nice mod man

Re: Ajax chat for V2 works perfect http://www.tbrpg.890m.com/chat.php

Re: can anyone fix this still dont work is the cron right ***** curl http://tbrpg.890m.com/auctoncron.php?co ... 65fe77b1b4

Re: [v2]Take Your Partner On A Date[v2]   well if its much better ye plz

Re: No Attack i dont as it means u the game money goes up when someone cheated and didnt earn the money themselves

Re: Ajax chat for V2 http://www.tbrpg.890m.com/chat.php it dont work right have a look

Re: [MCCode lite & V1.0 & V1.1] [ES] - Pin Mod V1.0B can some one do this v2 plz

Re: No Attack emm wat about v2 no attack ppl in fed

Re: [mccode] Mining mod works perfect except wrong cron $query7="UPDATE users SET power=power+5 WHERE power<max_power"; $db->query($query7);

Re: v2 attack bug lol nope my fault soz cheers lol

Re: [V2] cars_mod staff_cars nice one mate well done

when someone ever leaves mugs or hospitalizes someone when there in a gang the dont gain respect can someone help plz

Re: [mccode] Profile Signatures anyone have a v2 as i dont know where to add it on v2 view_user.php thnx

happy valentines all u ce members have a good one XX

this auction cron is not working y? ?php include "config.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $db->query("update auctions set time=time-1",$c); $qqq=$db->query("select * from auctions where time=0",$c); while($win=mysql_fetch_array($qqq)) { $time=$win['time']; $item=$win['itemname']; $winner=$win['bidder']; $owner=$win['owner']; $iname=mysql_result($db->query("SELECT itmname FROM items WHERE itmid={$item}", $c), 0, 0); if($win['bids']>0) { $db->query("insert into inventory VALUES('',$item,$winner,1)",$c) or die(mysql_error()); event_add($winner,"You won the auction of the {$iname} for \${$win['current']}",$c); event_add($owner, "Your {$iname} sold succesfully on the auction market with {$win['bids']} bids. You have been paid \${$win['current']}", $c); $db->query("update users set money=money+{$win['current']},auctionquota=auctionquota-1 where userid=$owner", $c); } if($win['bids']==0) { event_add($win['owner'],"Your auction has ended with no bidders. Your {$iname} has been returned to your inventory.",$c); $winner=$win['owner']; $db->query("insert into inventory VALUES('',$item,$winner,1)",$c) or die(mysql_error()); } } $db->query("delete from auctions where time=0", $c); ?>