TheBigChief

Re: [V2]Lock Down[V2] Just for fun I like to bring old posts back to life...... :-D But seriously, I tried the method HDawg advised and it won't update the DB to set locked to 1. Any ideas?

Re: Businesses Mod [Mccode V2] In business_view.php there is a part coded   <td width="275" align="right">'.stripslashes($r['className']).' •</td>   What is the ' • part?

Re: Businesses Mod [Mccode V2] which explore versionyou using? And whereinexplore did place the links? Do the links work ok when entered as an address on their own?

Re: Businesses Mod [Mccode V2] The best mod I have seen on this game!

Re: [v2] Iframes in header.php Still unable to get this to work but I would be willing if you are to pay half of a paid mod to get it working?

Re: [v2] Killing Users I'm willing to talk to anyone who could make me this mod (paid or not). [email protected]

Re: [v2] Killing Users Guys your oppinions are fine but please keep it to not being nasty eh? The game I mention is http://www.gangster-game.com and it plays very very well. Just because its not feature you all like it dont mean it wont work.

Re: [v2] Killing Users We all have different ideas for our games. My game is based on a game where this happens and the game has a running population of 1000+ players who take this as a chance to silent re-rank and take revenge. I will be removing DP's from my game as the players should not have to pay for anything inmy eyes so this wont be an issue.

Is there a way to have users killed off when and attack finishes them to make them re-sign up?

Re: [v2] Iframes in header.php Yeah and I almost have it working with help from Eternal and Dawg but I can only get it to display the frame and the output of any clicked link stays in that frame instead of moving to main screen

Hi all, I would love it if anyone could help me with making mainmenu.php a frame. Zero Affect recommended using iframes and removing include "mainmenu.php"; but this didn't work for me. Please help!!! [email protected]

Re: 3 Revamps [V2] Got all working except the index.php and houses mods :-(

Re: [mccode V2] Chat Mod NEW Please can anyone help me with this? I seem to get so far and then get stuck with the thing hanging on loading. [email protected]

Can anyone help me with this error please? Fatal error: Cannot redeclare money_formatter() (previously declared in /customers/a-sweet-review.co.uk/a-sweet-review.co.uk/httpd.www/global_func.php:2) in /customers/a-sweet-review.co.uk/a-sweet-review.co.uk/httpd.www/global_func.php on line 5   <?php function money_formatter($muny,$symb='$') { return $symb.number_format($muny); } function itemtype_dropdown($connection,$ddname="item_type",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM itemtypes ORDER BY itmtypename ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['itmtypeid']}'"; if ($selected == $r['itmtypeid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['itmtypename']}</option>"; } $ret.="\n</select>"; return $ret; } function item_dropdown($connection,$ddname="item",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM items ORDER BY itmname ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['itmid']}'"; if ($selected == $r['itmid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['itmname']}</option>"; } $ret.="\n</select>"; return $ret; } function item2_dropdown($connection,$ddname="item",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM items ORDER BY itmname ASC"); if($selected < 1) { $ret.="<option value='0' selected='selected'>-- None --</option>"; } else { $ret.="<option value='0'>-- None --</option>"; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['itmid']}'"; if ($selected == $r['itmid']) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['itmname']}</option>"; } $ret.="\n</select>"; return $ret; } function location_dropdown($connection,$ddname="location",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM cities ORDER BY cityname ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['cityid']}'"; if ($selected == $r['cityid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['cityname']}</option>"; } $ret.="\n</select>"; return $ret; } function shop_dropdown($connection,$ddname="shop",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM shops ORDER BY shopNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['shopID']}'"; if ($selected == $r['shopID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['shopNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function user_dropdown($connection,$ddname="user",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM users ORDER BY username ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['userid']}'"; if ($selected == $r['userid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['username']}</option>"; } $ret.="\n</select>"; return $ret; } function orgcrime_dropdown($connection,$ddname="orgcrime",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM orgcrimes ORDER BY ocID ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['ocID']}'"; if ($selected == $r['ocID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['ocNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function gang_dropdown($connection,$ddname="gang",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM gangs ORDER BY gangID ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['gangID']}'"; if ($selected == $r['gangID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['gangNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function challengebot_dropdown($connection,$ddname="bot",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT cb.*,u.* FROM challengebots AS cb LEFT JOIN users AS u ON cb.cb_npcid=u.userid ORDER BY u.username ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['userid']}'"; if ($selected == $r['userid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['username']}</option>"; } $ret.="\n</select>"; return $ret; } function fed_user_dropdown($connection,$ddname="user",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM users WHERE fedjail=1 ORDER BY username ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['userid']}'"; if ($selected == $r['userid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['username']}</option>"; } $ret.="\n</select>"; return $ret; } function mailb_user_dropdown($connection,$ddname="user",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM users WHERE mailban > 0 ORDER BY username ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['userid']}'"; if ($selected == $r['userid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['username']}</option>"; } $ret.="\n</select>"; return $ret; } function forumb_user_dropdown($connection,$ddname="user",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM users WHERE forumban > 0 ORDER BY username ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['userid']}'"; if ($selected == $r['userid'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['username']}</option>"; } $ret.="\n</select>"; return $ret; } function job_dropdown($connection,$ddname="job",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM jobs ORDER BY jNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['jID']}'"; if ($selected == $r['jID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['jNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function jobrank_dropdown($connection,$ddname="jobrank",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT jr.*,j.* FROM jobranks jr LEFT JOIN jobs j ON jr.jrJOB=j.jID ORDER BY j.jNAME ASC, jr.jrNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['jrID']}'"; if ($selected == $r['jrID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['jNAME']} - {$r['jrNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function house_dropdown($connection,$ddname="house",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM houses ORDER BY hNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['hID']}'"; if ($selected == $r['hID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['hNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function house2_dropdown($connection,$ddname="house",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM houses ORDER BY hNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['hWILL']}'"; if ($selected == $r['hWILL'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['hNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function course_dropdown($connection,$ddname="course",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM courses ORDER BY crNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['crID']}'"; if ($selected == $r['crID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['crNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function crime_dropdown($connection,$ddname="crime",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM crimes ORDER BY crimeNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['crimeID']}'"; if ($selected == $r['crimeID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['crimeNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function crimegroup_dropdown($connection,$ddname="crimegroup",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM crimegroups ORDER BY cgNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['cgID']}'"; if ($selected == $r['cgID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['cgNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function event_add($userid,$text,$connection=0) { global $db; $text=mysql_escape($text); $db->query("INSERT INTO events VALUES('',$userid,UNIX_TIMESTAMP(),0,'$text')"); $db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$userid}"); return 1; } function mysql_escape($str) { return str_replace("'","''",$str); } function check_level() { global $db; global $ir,$c,$userid; $ir['exp_needed']=(int) (($ir['level']+1)*($ir['level']+1)*($ir['level']+1)*2.2); if($ir['exp'] >= $ir['exp_needed']) { $expu=$ir['exp']-$ir['exp_needed']; $ir['level']+=1; $ir['exp']=$expu; $ir['energy']+=2; $ir['brave']+=2; $ir['maxenergy']+=2; $ir['maxbrave']+=2; $ir['hp']+=50; $ir['maxhp']+=50; $ir['exp_needed']=(int) (($ir['level']+1)*($ir['level']+1)*($ir['level']+1)*2.2); $db->query("UPDATE users SET level=level+1,exp=$expu,energy=energy+2,brave=brave+2,maxenergy=maxenergy+2,maxbrave=maxbrave+2, hp=hp+50,maxhp=maxhp+50 where userid=$userid"); } } function get_rank($stat, $mykey) { global $db; global $ir,$userid,$c; $q=$db->query("SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.$mykey > $stat AND us.userid != $userid AND u.user_level != 0") ; return $db->fetch_single($q)+1; } function item_add($user, $itemid, $qty, $notid=0) { global $db; if($notid > 0) { $q=$db->query("SELECT * FROM inventory WHERE inv_userid={$user} and inv_itemid={$itemid} AND inv_id != {$notid}"); } else { $q=$db->query("SELECT * FROM inventory WHERE inv_userid={$user} and inv_itemid={$itemid}"); } if($db->num_rows($q) > 0) { $r=$db->fetch_row($q); $db->query("UPDATE inventory SET inv_qty=inv_qty+{$qty} WHERE inv_id={$r['inv_id']}"); } else { $db->query("INSERT INTO inventory (inv_itemid, inv_userid, inv_qty) VALUES ({$itemid}, {$user}, {$qty})"); } } function item_remove($user, $itemid, $qty) { global $db; $q=$db->query("SELECT * FROM inventory WHERE inv_userid={$user} AND inv_itemid={$itemid}"); if($db->num_rows($q) > 0) { $r=$db->fetch_row($q); if($r['inv_qty']>$qty) { $db->query("UPDATE inventory SET inv_qty=inv_qty-{$qty} WHERE inv_id={$r['inv_id']}"); } else { $db->query("DELETE FROM inventory WHERE inv_id={$r['inv_id']}"); } } } function forum_dropdown($connection,$ddname="forum",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM forum_forums ORDER BY ff_name ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['ff_id']}'"; if ($selected == $r['ff_id'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['ff_name']}</option>"; } $ret.="\n</select>"; return $ret; } function forum2_dropdown($connection,$ddname="forum",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM forum_forums WHERE ff_auth != 'gang' ORDER BY ff_name ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['ff_id']}'"; if ($selected == $r['ff_id'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.= ">{$r['ff_name']}</option>"; } $ret.="\n</select>"; return $ret; } function make_bigint($str, $positive=1) { $str = (string) $str; $ret = ""; for($i=0;$i<strlen($str);$i++) { if((ord($str[$i]) > 47 && ord($str[$i]) < 58) or ($str[$i]=="-" && $positive == 0)) { $ret.=$str[$i]; } } if(strlen($ret) == 0) { return "0"; } return $ret; } function stafflog_add($text) { global $db, $ir; $IP = ($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR']; $text=$db->escape($text); $db->query("INSERT INTO stafflog VALUES(NULL, {$ir['userid']}, unix_timestamp(), '$text', '$IP')"); } function player_rank($tp) { if ($tp < 50) { return "#1 Absolute Newbie"; } else if ($tp < 100) { return "#2 Newbie"; } else if ($tp < 150) { return "#3 Beginner"; } else if ($tp < 18) { return "#4 Not Experienced"; } else if ($tp < 25) { return "#5 Rookie"; } else if ($tp < 50) { return "#6 Average"; } else if ($tp < 100) { return "#7 Good"; } else if ($tp < 200) { return "#8 Very Good"; } else if ($tp < 350) { return "#9 Greater Than Average"; } else if ($tp < 500) { return "#10 Experienced"; } else if ($tp < 750) { return "#11 Highly Experienced"; } else if ($tp < 1200) { return "#12 Honoured"; } else if ($tp < 1800) { return "#13 Highly Hounoured"; } else if ($tp < 2500) { return "#14 Respect King"; } else if ($tp < 5000) { return "#15 True Champion"; } } ?>

Re: [v2] Commiting Crimes (Exp Help) CrimeXP aint the same Exp though or do i have that wrong? It seems that the the only thing that you can set up on Staff Panel is the CrimeXP which does not make the EXP bar climb.

I know that comiting crimes makes the Exp go up dependant on the value of money taken from that crime however I have it set so that no money is given but a random array car is given which means that the exp won't climb. Is this something anyone could fix for me?

Re: [V2] Current Status - What's going on? Sorry which file should I be editing?

Re: [MCCODES V2] Compare Items and Houses Yep used it and works great, thanks for the mod!

Re: [v2] Shops.php This worked a treat and when I go to shops I now see every shop but I want it so that when I create a shop I dont need to choose a city otherwise when I go to shops it tells me I am in the wrong city.

Re: [V2] Quick Question - Crimes So impressed that this worked!!!!

Re: [v2] Shops.php What? Where is that?

I found a nice mod on the web and I'm not too sure who created it but its good. On one of the files I get this error: QUERY ERROR: Unknown column 'cars_owned' in 'field list' Query was UPDATE users SET money=money-3000,cars_owned=cars_owned+1 where userid=1 Here is the code, can anyone help?   <?php include "globals.php"; print "<h3>Car Yard</h3><hr />"; $car=abs((int) $_GET['car']); if($car) { $q=$db->query("SELECT * FROM cars_types WHERE carID={$car} and carBUYABLE=1", $c); if($db->num_rows($q) == 0) { die("Invalid Car"); } $r=$db->fetch_row($q); if($r['carCOST'] > $ir['money']) { die("You do not have enough money to buy this car."); } $db->query("UPDATE users SET money=money-{$r['carCOST']},cars_owned=cars_owned+1 where userid=$userid", $c); $db->query("INSERT INTO cars_playercars VALUES('', $userid, $car, 1, 1, 1, 1)", $c); print "You bought a {$r['carNAME']}! > [url='caryard.php']Back to Caryard[/url] > [url='garage.php']Goto Your Garage[/url] "; } else { print "<table width=100% border=6> <tr style='background:#cc9966'> <th>Car</th><th>Description</th><th>Base Acceleration</th><th>Base Handling</th><th>Base Speed</th><th>Base Shield</th><th>Price</th><th>Buy</th></tr>"; $q=$db->query("SELECT * FROM cars_types WHERE carBUYABLE=1 ORDER BY carCOST", $c); while($r=$db->fetch_row($q)) { $price='$'.number_format($r['carCOST']); print "<tr><td>{$r['carNAME']}</td><td>{$r['carDESC']}</td> <td>{$r['carACC']}</td> <td>{$r['carHAN']}</td><td>{$r['carSPD']}</td> <td>{$r['carSHD']}</td> <td>$price</td> <td>[url='caryard.php?car={$r[']Buy[/url]</td> </tr>"; } print "</table>"; } $h->endpage(); ?>   the sql was   -- -- Table structure for table `carmarket` -- CREATE TABLE IF NOT EXISTS `carmarket` ( `cmID` int(11) NOT NULL auto_increment, `cmCAR` int(11) NOT NULL default '0', `cmACC` int(11) NOT NULL default '0', `cmHAN` int(11) NOT NULL default '0', `cmSPD` int(11) NOT NULL default '0', `cmSHD` int(11) NOT NULL default '0', `cmADDER` int(11) NOT NULL default '0', `cmPRICE` bigint(20) NOT NULL default '0', PRIMARY KEY (`cmID`) ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1 AUTO_INCREMENT=60 ; -- -- Dumping data for table `carmarket` -- -- --------------------------------------------------------------------------------------------------- -- -- Table structure for table `cars_challenges` -- CREATE TABLE IF NOT EXISTS `cars_challenges` ( `chgID` int(11) NOT NULL auto_increment, `chgNAME` varchar(255) NOT NULL default '', `chgDESC` text NOT NULL, `chgUNLOCK` int(11) NOT NULL default '0', `chgMULT` decimal(11,4) NOT NULL default '0.0000', `chgTRACK` int(11) NOT NULL default '0', `chgRACER1` int(11) NOT NULL default '0', `chgRACER2` int(11) NOT NULL default '0', `chgRACER3` int(11) NOT NULL default '0', `chgDRPTS` int(11) NOT NULL default '0', `chgMONEY` int(11) NOT NULL default '0', PRIMARY KEY (`chgID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cars_challenges` -- -- -------------------------------------------------------------------------------------------------- -- -- Table structure for table `cars_npcs` -- CREATE TABLE IF NOT EXISTS `cars_npcs` ( `cnpcID` int(11) NOT NULL auto_increment, `cnpcNAME` varchar(255) NOT NULL default '', `cnpcLEVEL` tinyint(4) NOT NULL default '0', `cnpcACC` int(11) NOT NULL default '0', `cnpcHND` int(11) NOT NULL default '0', `cnpcSPD` int(11) NOT NULL default '0', `cnpcSHD` int(11) NOT NULL default '0', PRIMARY KEY (`cnpcID`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ; -- -- Dumping data for table `cars_npcs` -- INSERT INTO `cars_npcs` VALUES (1, 'Punk', 1, 2, 3, 3, 1); INSERT INTO `cars_npcs` VALUES (2, 'Walt', 1, 1, 4, 1, 3); INSERT INTO `cars_npcs` VALUES (3, 'Leo', 1, 4, 1, 1, 3); INSERT INTO `cars_npcs` VALUES (4, 'Blast FTP', 1, 2, 1, 4, 2); INSERT INTO `cars_npcs` VALUES (5, 'Bash FTP', 1, 1, 1, 1, 6); INSERT INTO `cars_npcs` VALUES (6, 'Marcus', 1, 1, 2, 1, 5); INSERT INTO `cars_npcs` VALUES (7, 'Ark NSS', 2, 4, 2, 4, 5); INSERT INTO `cars_npcs` VALUES (8, 'Ollie DN', 2, 3, 4, 4, 4); INSERT INTO `cars_npcs` VALUES (9, 'Eti Y', 2, 7, 4, 1, 3); INSERT INTO `cars_npcs` VALUES (10, 'Flash BK', 2, 2, 1, 9, 3); INSERT INTO `cars_npcs` VALUES (11, 'Nervous AF', 2, 3, 5, 3, 4); INSERT INTO `cars_npcs` VALUES (12, 'Guy ED', 2, 4, 4, 5, 2); INSERT INTO `cars_npcs` VALUES (13, 'Doll', 3, 5, 8, 4, 8); INSERT INTO `cars_npcs` VALUES (14, 'Dash R', 3, 3, 9, 3, 10); INSERT INTO `cars_npcs` VALUES (15, 'Walt', 3, 3, 12, 3, 7); INSERT INTO `cars_npcs` VALUES (16, 'Ollie DN', 3, 5, 7, 7, 6); INSERT INTO `cars_npcs` VALUES (17, 'Flash BK', 3, 3, 2, 15, 5); INSERT INTO `cars_npcs` VALUES (18, 'Bash FTP', 3, 3, 3, 3, 16); -- -- Insert Complete -- -- -------------------------------------------------------- -- -- Table structure for table `cars_playercars` -- CREATE TABLE IF NOT EXISTS `cars_playercars` ( `cpcID` int(11) NOT NULL auto_increment, `cpcPLAYER` int(11) NOT NULL default '0', `cpcCAR` int(11) NOT NULL default '0', `cpcACCLV` int(11) NOT NULL default '0', `cpcHANLV` int(11) NOT NULL default '0', `cpcSPDLV` int(11) NOT NULL default '0', `cpcSHDLV` int(11) NOT NULL default '0', PRIMARY KEY (`cpcID`) ) ENGINE=MyISAM AUTO_INCREMENT=161 DEFAULT CHARSET=latin1 AUTO_INCREMENT=161 ; -- -- Dumping data for table `cars_playercars` -- -- -------------------------------------------------------- -- -- Table structure for table `cars_tracks` -- CREATE TABLE IF NOT EXISTS `cars_tracks` ( `ctrkID` int(11) NOT NULL auto_increment, `ctrkNAME` varchar(255) NOT NULL default '', `ctrkDESC` text NOT NULL, `ctrkACC` decimal(11,1) NOT NULL default '0.0', `ctrkHAN` decimal(11,1) NOT NULL default '0.0', `ctrkSPD` decimal(11,1) NOT NULL default '0.0', `ctrkSHD` double(11,1) NOT NULL default '0.0', PRIMARY KEY (`ctrkID`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `cars_tracks` -- INSERT INTO `cars_tracks` VALUES (1, 'Central City', 'This track has a bit of everything... straights... curves... drops...', 1.0, 1.0, 1.0, 1.0); INSERT INTO `cars_tracks` VALUES (2, 'Country Farmside', 'Undaunted straights. So there.', 0.9, 0.2, 1.7, 0.2); INSERT INTO `cars_tracks` VALUES (3, 'Hill Zone', 'Weave your way around the curviest hills in the country, you will need to be able to turn well.', 1.2, 1.8, 0.3, 1.1); INSERT INTO `cars_tracks` VALUES (4, 'Meat Factory', 'This track is obsessively dangerous. Your shield will have to be good for you to stay alive.', 0.5, 0.5, 0.5, 2.8); INSERT INTO `cars_tracks` VALUES (5, 'Slip Slop Oil', 'Straight... yes... Oily... yes... you are going to need good acceleration and speed to win here.', 1.6, 0.4, 1.6, 0.4); INSERT INTO `cars_tracks` VALUES (6, 'Beachy', 'An elegant driving course by the Mono River.', 1.2, 0.9, 1.1, 1.0); INSERT INTO `cars_tracks` VALUES (7, 'Windy City', 'With the wind constantly slowing you down, you are going to need good acceleration to keep up.', 2.8, 1.2, 0.7, 0.1); INSERT INTO `cars_tracks` VALUES (8, 'The 4 Slopes', '4 incredibly curvy slopes. Individually they dont make much, but together, your handling will have to be extremely good to win.', 1.8, 5.5, 0.3, 0.9); INSERT INTO `cars_tracks` VALUES (9, 'Open Space', '8km of straight, set in a cool space theme park.', 0.4, 0.2, 6.0, 0.1); INSERT INTO `cars_tracks` VALUES (10, 'Cyber State', 'Head into the unknown and test your skill.', 3.0, 1.5, 0.8, 2.0); -- -- Insert Complete -- -- -------------------------------------------------------- -- -- Table structure for table `cars_types` -- CREATE TABLE IF NOT EXISTS `cars_types` ( `carID` int(11) NOT NULL auto_increment, `carNAME` varchar(255) NOT NULL default '', `carDESC` text NOT NULL, `carCOST` bigint(20) NOT NULL default '0', `carACC` int(11) NOT NULL default '0', `carHAN` int(11) NOT NULL default '0', `carSPD` int(11) NOT NULL default '0', `carSHD` int(11) NOT NULL default '0', `carBUYABLE` int(11) NOT NULL default '1', PRIMARY KEY (`carID`) ) ENGINE=MyISAM AUTO_INCREMENT=1001 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1001 ; -- -- Dumping data for table `cars_types` -- INSERT INTO `cars_types` VALUES (1, 'Mini Roxi', 'The Mini Roxi is a very compact car. It is not designed to go at a very high speed otherwise, it will wable and drift away. Very good collective car type', 3000, 2, 2, 2, 2, 1); INSERT INTO `cars_types` VALUES (2, 'Lararus Colt', 'The Lararus Colt is a good long term car. It has slow acceleration, but once it starts going on a stable speed, then it rolls along well.', 10000, 8, 7, 8, 8, 1); INSERT INTO `cars_types` VALUES (3, 'Olegon', 'The sporty, high-performance hatchback. Acceleration is an understatement.\r\nAnd searching for a big enough parking spot is a thing of the past.', 20000, 18, 16, 19, 19, 1); INSERT INTO `cars_types` VALUES (4, 'Daron Family Model', 'The acclaimed shape of the 2007 Daron Family Model lets you know right from the beginning. This is no ordinary sports coupe. And the Family Model''s 3.8-liter MIVEC engine confirms the promise. At low revolutions the engine?s 260 lb-ft of torque give the Daron stoplight authority, while at higher revs variable valve timing provides pure top-end power.', 35000, 33, 29, 35, 34, 1); INSERT INTO `cars_types` VALUES (5, 'Necon GD 500', 'The Necon GD 500 is among the easiest of the big luxury cars to live with. It whisks occupants along in supreme comfort. Its ride is silky smooth. It handles well, with effortless steering and excellent grip. Its powerful V8 delivers strong performance and is paired with a smooth six-speed automatic. ', 50000, 50, 51, 53, 45, 1); INSERT INTO `cars_types` VALUES (6, 'Toloas Bumer', 'Toloas put the sports car world on edge with its Bumer model. A rear driver sports car driven by a six cylinder engine, it became a true performance car with the addition of dual turbos.', 125000, 77, 67, 68, 72, 1); INSERT INTO `cars_types` VALUES (7, 'Vlisha Montage RR2', 'Just when you thought the pure pleasure of driving had been stolen forever by electronic gizmos, along comes a car that gives total control back to the driver. Quite simply, Montage comes to you pure. Whatever you ask from it - it delivers. No ifs, no buts. So leave the games consoles to the boys and come back to the real world.', 270000, 107, 92, 92, 93, 1); INSERT INTO `cars_types` VALUES (8, 'Daron Killer XV', ' This latest edition to the Killer model line, designed to compete against far more expensive sports cars, easily lives up to its Daron motorsports pedigree. By combining brute power and graceful agility, the Killer XV is sure to raise the adrenaline of driving enthusiasts at every turn.', 500000, 136, 123, 116, 121, 1); INSERT INTO `cars_types` VALUES (9, 'Supalo Laxa', 'Although the TSI is new from the A-pillar forward, its familiar Supalo look has been retained. The new grill and cats-eye headlights are, perhaps, the most apparent changes. The others, like the new fenders, the new hood scoop and the new bumper are more subtle.', 1250000, 150, 175, 149, 174, 1); INSERT INTO `cars_types` VALUES (12, 'Lamborno Outsa', 'The Outsa oozes supercar cool and has the performance and handling to back it up. It?s also useable everyday and is a sound financial bet.', 2350000, 261, 292, 299, 305, 1); INSERT INTO `cars_types` VALUES (10, 'Mono GHD', 'The Mono GHD is built in with highly strong copper. It can resist the impact of any damage which is caused.\r\n', 1700000, 214, 216, 219, 185, 1); INSERT INTO `cars_types` VALUES (11, 'Callo Creator MI', 'Don''t believe your eyes. This car may look like the current Creator with fixed headlamps, but it''s an all-new interpretation of the Classic American Sports Car.', 2000000, 255, 239, 260, 222, 1); INSERT INTO `cars_types` VALUES (13, 'Loomus Grand', 'What?s truly special about this limited run supercar is the fact that it can be used on the highway or on the racetrack. And since it is known to outperform cars like the Mono, Lararus, and Lamborno, it?s no wonder that the Grand has been touted as the ultimate Loomus.', 3500000, 358, 354, 324, 320, 1); INSERT INTO `cars_types` VALUES (15, 'Oomph', 'The Oomph is one known as the fastest car ever made in human life. The fastest land machine. 6.0L engine. Top speeds 500km/ph. However it''s handling and crash resistants is very low rated.', 20000000, 434, 484, 442, 444, 1); INSERT INTO `cars_types` VALUES (14, 'Mono Cheetah', 'Cheetah represents the animal Cheetah. Wild machine on land. Going up to 480km/ph. Nearly reaching the speed an Oomph can attain. It''s been made from higly strong copper. Driver will survive if crashed at 400km/ph. Great Car.', 10000000, 428, 390, 394, 365, 1); INSERT INTO `cars_types` VALUES (16, 'Lararus Dominator', 'Only built for racing at licenced tracks. Flat and speedy, reaching speeds upto 500km/ph on straight roads. However, it''s weak against any crashs or huge impacts.', 50000000, 486, 536, 557, 513, 1); INSERT INTO `cars_types` VALUES (17, 'Toloas A7', 'Formula car racing. Powered with rocket fuel and boosting system. Impossible to catch on a straight surface race. ', 75000000, 606, 539, 590, 580, 1); INSERT INTO `cars_types` VALUES (18, 'Thrust SSC', 'The best of all! Thrust SSC, powered with rocket engine producing heat from the back of the car. Going up to 200km per second with its amazing 2 jet engine. Sells at very high price.', 2500000000, 2684, 3625, 1623, 4655, 1); INSERT INTO `cars_types` VALUES (19, 'Supalo RGB', 'The out leading Supalo RGB. Great comfort with safety car bags attached. Secured and high tech car. The future is now.', 4000000, 398, 364, 349, 330, 1); INSERT INTO `cars_types` VALUES (20, 'Suaplo Enopawn', 'Another Supalo brand car. Supalo Enopawn is most advanced Supalo car. Very spacy and once again, very safe in driving. This car is build for the race.', 5000000, 400, 400, 359, 340, 1); INSERT INTO `cars_types` VALUES (21, 'Aeroline 4WD', 'Beasty car with 4WD\r\n\r\nnyuubi owns one..need i say more?', 1, 429, 442, 422, 414, 0); INSERT INTO `cars_types` VALUES (22, 'Daron Zala Z', 'The Daron Zala is a supercar made by relatively unknown Daron.This 2008 model is not just a car, it is a SUPERCAR. It is a mid-engined 2-seat coupe and convertible. Construction is mainly of carbon fiber.It is similar to the coupe, but with a removable carbon fibre roof and canvas side curtains weighing just 11 lb (5 kg). Excellent Cornering.', 150000000, 1494, 2390, 1000, 2505, 1); -- -- Insert Complete -- -- -------------------------------------------------------- -- -- Table structure for table `challenges` -- CREATE TABLE IF NOT EXISTS `challenges` ( `chID` int(11) NOT NULL auto_increment, `chCHR` int(11) NOT NULL default '0', `chCHD` int(11) NOT NULL default '0', `chSTATUS` enum('open','accepted','declined','expired','cancelled') NOT NULL default 'open', `chCHRCAR` int(11) NOT NULL default '0', `chTYPE` enum('Friendly','Betted','High-Stakes') NOT NULL default 'Friendly', `chBET` int(11) NOT NULL default '0', `chTIME` int(11) NOT NULL default '0', PRIMARY KEY (`chID`) ) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ; -- -- Dumping data for table `challenges` -- -- -------------------------------------------------------- -- -- Table structure for table `challengesbeaten` -- CREATE TABLE IF NOT EXISTS `challengesbeaten` ( `userid` int(11) NOT NULL default '0', `npcid` int(11) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `challengesbeaten` -- -- -------------------------------------------------------- -- -- Table structure for table `race_results` -- CREATE TABLE IF NOT EXISTS `race_results` ( `rrID` int(11) NOT NULL auto_increment, `rrTYPE` varchar(255) NOT NULL default '', `rrBET` int(11) NOT NULL default '0', `rrCHALLENGER` varchar(255) NOT NULL default '', `rrCHALLENGED` varchar(255) NOT NULL default '', `rrCHRCAR` varchar(255) NOT NULL default '', `rrCHDCAR` varchar(255) NOT NULL default '', `rrWINNER` varchar(255) NOT NULL default '', `rrNOTES` text NOT NULL, PRIMARY KEY (`rrID`) ) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ; -- -- Dumping data for table `race_results` --

Is there a way to ditch the shops per city and have 1 shop or a set of shops that are global and can be viewed in all cities?

Re: [mccode v2] Ranks Mod!!!! Please I beg of you all to help me get this working.......

Re: [McCodes][v2] Mailbox Layout Mod WOW, you made it work for me. How can I change the colour of the bars though? I would like a dark grey colour