kingarmy

Anyone have it? I'm having problems configuring.

Re: will this secure my website? Whatever you do, there'll always be a way to hack, abuse or exploit your site.

Re: Need help with sql :? I still can't get it...

Re: Need help with sql Someone another hint? EDIT: K I fixed that problem but now my cars won't show   print " <table width=100% border=6> <tr style='background:#cc9966'><th>Horses</th><th>Acceleration</th> <th>Handling</th><th>Speed</th><th>Shield</th><th>In Challenge?</th><th>Tune</th></tr>"; $q=$db->query("SELECT cp.*, ct.* FROM cars_playercars cp LEFT JOIN cars_types ct ON cp.cpcCAR=ct.carID WHERE cp.cpcPLAYER=$userid LIMIT $start, $cpp", $c); $count=0; $cars=array(); while($r=mysql_fetch_row($q)) { $count++; $acc=$r['cpcACCLV']*$r['carACC']; $han=$r['cpcHANLV']*$r['carHAN']; $spd=$r['cpcSPDLV']*$r['carSPD']; $shd=$r['cpcSHDLV']*$r['carSHD']; $q2=$db->query("SELECT * FROM challenges WHERE chCHRCAR={$r['cpcID']} chSTATUS='open'", $c); if(mysql_num_rows($q2) == 1) { $challenge="<font color='red'>Yes</font>"; } else { $challenge="<font color='green'>No</font>"; } print "<tr><td>{$r['carNAME']} </td> <td>Lv{$r['cpcACCLV']} ($acc)</td> <td>Lv{$r['cpcHANLV']} ($han)</td> <td>Lv{$r['cpcSPDLV']} ($spd)</td> <td>Lv{$r['cpcSHDLV']} ($shd)</td><td>$challenge</td> <td>[url='tune.php?id={$r[']Tune[/url]</td> </tr>"; $cars[$r['cpcID']]="{$r['carNAME']} - {$r['cpcACCLV']}/{$r['cpcHANLV']}/{$r['cpcSPDLV']}/{$r['cpcSHDLV']}"; } if($count == 0) { print "<tr><th colspan=6>No Horses In Your stable</th></tr>"; } print "</table>";     -- -- 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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=169 ; -- -- Dumping data for table `cars_playercars` -- INSERT INTO `cars_playercars` (`cpcID`, `cpcPLAYER`, `cpcCAR`, `cpcACCLV`, `cpcHANLV`, `cpcSPDLV`, `cpcSHDLV`) VALUES (168, 5, 1, 1, 1, 1, 1), (167, 5, 1, 1, 1, 1, 1), (166, 1, 1001, 1, 1, 1, 1), (165, 1, 1, 1, 1, 1, 1);

Re: Need help with sql damn now I don't know where to put the ".

Re: Need help with sql Lol I must of spent 6 hours only to find out I was missing a " EDIT: nvm

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 'AND chSTATUS='open'' at line 1 Query was SELECT * FROM challenges WHERE chCHRCAR= AND chSTATUS='open'   SQL entry: -- -- Table structure for table `challenges` -- CREATE TABLE `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 ; Garage.php:   { $count++; $acc=$r['cpcACCLV']*$r['carACC']; $han=$r['cpcHANLV']*$r['carHAN']; $spd=$r['cpcSPDLV']*$r['carSPD']; $shd=$r['cpcSHDLV']*$r['carSHD']; $q2=$db->query("SELECT * FROM challenges WHERE chCHRCAR={$r['cpcID']} AND chSTATUS='open'", $c); if(mysql_num_rows($q2) == 1) { $challenge="<font color='red'>Yes</font>"; } else { $challenge="<font color='green'>No</font>"; } print "<tr><td>{$r['carNAME']} </td> <td>Lv{$r['cpcACCLV']} ($acc)</td> <td>Lv{$r['cpcHANLV']} ($han)</td> <td>Lv{$r['cpcSPDLV']} ($spd)</td> <td>Lv{$r['cpcSHDLV']} ($shd)</td><td>$challenge</td> <td>[url='tune.php?id={$r[']Tune[/url]</td> </tr>"; $cars[$r['cpcID']]="{$r['carNAME']} - {$r['cpcACCLV']}/{$r['cpcHANLV']}/{$r['cpcSPDLV']}/{$r['cpcSHDLV']}"; }   You don't have to give me the answer if you don't want to, maybe a hint.

Re: Sql queries yup

Re: Sql queries oh nvm, broken comment lol

Can anyone help me? I've tried searching the forums, and google didn't give me precise answers. -- Table structure for table `race_results` -- CREATE TABLE `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;   MySQL said: #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 '- phpMyAdmin SQL Dump CREATE TABLE `race_results` ( `rrID` int(11) NOT' at line 1

Can someone help me install my copy of car mod? The instructions don't work for me. I'm not sure whch files to link and the sql scripts don't work.

Re: Updating oh lol thanks anyway, i changed to v2 now so I don't have to reinstall it everytime.

hey, can someone tell me how to edit crimes and places on dbdata.sql without reinstalling? that's the only way I can update it. I use cpanel.