Thomisback Posted March 6, 2008 Share Posted March 6, 2008 Hi, I am trying to run a MySQL quary using a php file but when I run it on my host I get: Parse error: syntax error, unexpected T_STRING in /home/content/X/X/X/X/html/X.php on line X The line of code is: mysql_query("INSERT INTO $weapons VALUES (2, 'Walter P99', 1, 5000, 'item-Walter_P99', 50, 50, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->{''Walter P99''}; return $num;', 'Al je $type_p hebben al een Walter P99', NULL") I have a few other similar to these and don't work either, if anyone knows how to solve this please help! Thomisback P.S. Excuse my English, it's not my first language. Quote Link to comment Share on other sites More sharing options...
Baabu Posted March 6, 2008 Share Posted March 6, 2008 can u tell what's in $weapons or what are the columns in $weapons? Quote Link to comment Share on other sites More sharing options...
Thomisback Posted March 6, 2008 Author Share Posted March 6, 2008 Sure: $querynine = "CREATE TABLE $weapons ( `id` int(4) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `area` int(2) default NULL, `costs` int(7) default NULL, `url` varchar(40) default NULL, `attack` int(5) default NULL, `defence` int(5) default NULL, `max` text, `eval` text, `error` text, `extra` text, PRIMARY KEY (`id`) )"; mysql_query($querynine); Quote Link to comment Share on other sites More sharing options...
Thomisback Posted March 6, 2008 Author Share Posted March 6, 2008 Sorry for the double post but I just wanted to say that I will be giving away: - 5GB linux hosting - 3 MySql databases (10 MB each) for at least 1 year to the person who can give me the answer. Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted March 6, 2008 Share Posted March 6, 2008 The parse error you are receiving is not caused by that line. This is just the line that php was able to figure out there was a syntax error on one of the previous lines. You would need to post the 10 lines of code before that line to get help with what the actual problem is. My guess is short open tags are being used in the code. Quote Link to comment Share on other sites More sharing options...
Thomisback Posted March 6, 2008 Author Share Posted March 6, 2008 Hi, sorry I left but i'm back now, The lines where PHP is having trouble are: $querynine = "CREATE TABLE $weapons ( `id` int(4) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `area` int(2) default NULL, `costs` int(7) default NULL, `url` varchar(40) default NULL, `attack` int(5) default NULL, `defence` int(5) default NULL, `max` text, `eval` text, `error` text, `extra` text, PRIMARY KEY (`id`) )"; mysql_query($querynine); $password = md5("$pw"); mysql_query("INSERT INTO $weapons VALUES (1, 'Mes', 1, 2000, 'item-Knife', 20, 20, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->Mes; return $num;', 'Al je $type_p hebben al een mes', NULL") mysql_query("INSERT INTO $weapons VALUES (2, 'Walter P99', 1, 5000, 'item-Walter_P99', 50, 50, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->{''Walter P99''}; return $num;', 'Al je $type_p hebben al een Walter P99', NULL") mysql_query("INSERT INTO $weapons VALUES (3, 'Uzi', 1, 6000, 'item-Uzi', 65, 65, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->Uzi; return $num;', 'Al je $type_p hebben al een uzi', NULL)" mysql_query("INSERT INTO $weapons VALUES (4, 'Flashbang', 1, 10000, 'item-Flashbang', 110, 110, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Flashbang; return $num;', 'Al je $type_p hebben al een flashbang', NULL)" mysql_query("INSERT INTO $weapons VALUES (5, 'Granaat', 1, 15000, 'item-Grenade', 170, 170, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Granaat; return $num;', 'Al je $type_p hebben al een granaat', NULL)" mysql_query("INSERT INTO $weapons VALUES (6, 'MP5k', 1, 7500, 'item-MP5k', 80, 80, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (7, 'Shotgun', 1, 17500, 'item-Shotgun', 200, 200, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (8, 'G36C', 1, 22500, 'item-G36C', 270, 270, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (9, 'SIG 552', 1, 25000, 'item-SIG_552', 310, 310, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (10, 'Ak47', 1, 30000, 'item-Ak47', 390, 390, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (11, 'Ak Beta', 1, 40000, 'item-Ak_Beta', 570, 570, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (12, 'Scherpschut geweer', 1, 45000, 'item-Sniper_rifle', 670, 670, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (13, 'M4', 1, 50000, 'item-M4', 780, 780, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (14, 'Granaat Lanceerder', 1, 60000, 'item-Grenade_Launcher', 1030, 1030, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (15, 'Bazooka', 1, 75000, 'item-Bazooka', 1490, 1490, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (16, 'Kogelvrij vest', 2, 12500, 'item-Bulletproof_vest', 140, 140, '1 per $type_s (Je hebt $num $type_p die dit vest nog niet hebben)', '$num = $data->clicks-$data->{''Kogelvrij vest''}; return $num;', 'Je hebt geen $type_s die dit vest kan dragen', NULL)" mysql_query("INSERT INTO $weapons VALUES (17, 'Bulldog', 3, 2500, 'item-Bulldog', 0, 30, '5 (Je kan nog $num honden meer hebben)', '$num = 5-$data->Bulldog; return $num;', 'Je hebt al 5 honden', NULL)" mysql_query("INSERT INTO $weapons VALUES (18, 'Camera', 3, 8000, 'item-Cam', 0, 90, '7 (Je kan nog $num cameras plaatsen)', '$num = 7-$data->Camera; return $num;', 'Je hebt al 7 cameras', NULL)" mysql_query("INSERT INTO $weapons VALUES (19, 'Hek', 3, 15000, 'item-Barbed_wire', 0, 170, '3 (Je kan nog $num hekken neerzetten)', '$num = 3-$data->Hek; return $num;', 'Je hebt al 3 hekken', NULL)" mysql_query("INSERT INTO $weapons VALUES (20, 'Muur', 3, 20000, 'item-Stone_wall', 0, 240, '3 (Je kan nog $num muren bouwen)', '$num = 3-$data->Muur; return $num;', 'Je hebt al 3 muren', NULL)" mysql_query("INSERT INTO $weapons VALUES (21, 'Bunker', 3, 35000, 'item-Bunker', 0, 470, '5 (Je kan nog $num bunkers bouwen)', '$num = 5-$data->Bunker; return $num;', 'Je hebt al 5 bunkers', NULL)" mysql_query("INSERT INTO $weapons VALUES (22, 'Mobieltje', 4, 1000, 'item-Cellphone', NULL, NULL, '1 (Je kan nog $num mobieltjes kopen)', '$num = 1-$data->Mobieltje; return $num;', 'Je hebt al een mobieltje', 'Als je een mobiel hebt kun je berichten versturen en ontvangen')" mysql_query("INSERT INTO $weapons VALUES (23, 'FN P90', 5, 50000, 'item-FN_P90', 900, 900, '1 per junkie (Je hebt nog $num junkies die dit wapen kunnen dragen)', '$num = $data->clicks-$data->{''FN P90''}; return $num;', 'Al je junkies hebben dit wapen al', NULL)" mysql_query("INSERT INTO $weapons VALUES (24, 'Chip', 6, 25000, 'item-Chip', 400, 400, '1 per kloon (Je hebt $num klonen die nog geen chip hebben)', '$num = $data->clicks-$data->Chip; return $num;', 'Al je klonen hebben al een chip in hun hoofd', NULL)" mysql_query("INSERT INTO $weapons VALUES (25, 'Helm', 7, 20000, 'item-Helmet', 240, 240, '1 per agent (Je hebt nog $num agenten zonder helm)', '$num = $data->clicks-$data->Helm; return $num;', 'Elke agent heeft al een helm', NULL)" mysql_query("INSERT INTO $weapons VALUES (26, 'Politie wagen', 7, 35000, 'item-Police_car', 470, 470, '1 per agent (Je kan nog $num wagens kopen)', '$num = $data->clicks-$data->{''Politie wagen''}; return $num;', 'Elke agent heeft al een wagen', NULL)" mysql_query("INSERT INTO $weapons VALUES (27, 'Huis', 8, 25000, 'item-Home', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een huis te bouwen', 'In ieder huis kunnen 5 clan-members')" mysql_query("INSERT INTO $weapons VALUES (28, 'Muur', 8, 50000, 'item-Stone_wall', NULL, 3000, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een muur te bouwen', NULL)" mysql_query("INSERT INTO $weapons VALUES (29, 'Coffeeshop', 9, 90000, 'item-Joint', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een coffeeshop te bouwen', 'Met een coffeeshop verdient elke clan-member per uur:<br>Bank: $150,contant: $50')" mysql_query("INSERT INTO $weapons VALUES (30, 'Chemie Lab', 10, 90000, 'item-Alchemy', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een lab te bouwen', 'Met een chemie lab verdient elke clan-member per uur:<br>Bank: $100,contant: $100')" mysql_query("INSERT INTO $users (`id`, `signup`, `login`, `pass`, `level`, `IP`, `email`, `type`, `url`, `info`, `cash`, `bank`, `bankleft`, `bankmax`, `clicks`, `clickstoday`, `attack`, `defence`, `attwins`, `attlosses`, `defwins`, `deflosses`, `clan`, `clanlevel`, `bonus`, `turns`, `showonline`, `online`, `activated`, `Mes`, `Walter P99`, `Uzi`, `MP5k`, `Flashbang`, `Granaat`, `Shotgun`, `G36C`, `SIG 552`, `Ak47`, `Ak Beta`, `Scherpschut geweer`, `M4`, `Granaat Lanceerder`, `Bazooka`, `Kogelvrij vest`, `Bulldog`, `Camera`, `Hek`, `Muur`, `Bunker`, `Mobieltje`, `FN P90`, `Chip`, `Helm`, `Politie wagen`, `IPs`, `blocklist`) VALUES (1, '2008-02-29 21:06:02', '$usr', '$password', 255, '0.0.0.0', '$email', 1, '', '', 500, 500, 5, 2500, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', 100, 1, '2008-02-29 21:09:17', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '')" mysql_close(); The line which the error refers to is: mysql_query("INSERT INTO $weapons VALUES (2, 'Walter P99', 1, 5000, 'item-Walter_P99', 50, 50, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->{''Walter P99''}; return $num;', 'Al je $type_p hebben al een Walter P99', NULL") Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted March 6, 2008 Share Posted March 6, 2008 Several of the lines do not have a semi-colon ; at the end. There is no way that code was ever executing. It is likely that error reporting was just turned off (display errors) and you were not seeing the fatal parse error. You need to fix the syntax on all the lines of code. Quote Link to comment Share on other sites More sharing options...
Thomisback Posted March 6, 2008 Author Share Posted March 6, 2008 Thanks, I already tried error reporting all without any luck, i'm going to try what you just said now. Quote Link to comment Share on other sites More sharing options...
Thomisback Posted March 6, 2008 Author Share Posted March 6, 2008 I think i am a bit further now, but I'm getting another error now: Parse error: syntax error, unexpected '{', expecting T_STRING in etc. etc. My new code: $querynine = "CREATE TABLE $weapons ( `id` int(4) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `area` int(2) default NULL, `costs` int(7) default NULL, `url` varchar(40) default NULL, `attack` int(5) default NULL, `defence` int(5) default NULL, `max` text, `eval` text, `error` text, `extra` text, PRIMARY KEY (`id`) )"; mysql_query($querynine); $password = md5("$pw"); mysql_query("INSERT INTO $weapons VALUES (1, 'Mes', 1, 2000, 'item-Knife', 20, 20, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->Mes; return $num;', 'Al je $type_p hebben al een mes', NULL"); mysql_query("INSERT INTO $weapons VALUES (2, 'Walter P99', 1, 5000, 'item-Walter_P99', 50, 50, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->{''Walter P99''}; return $num;', 'Al je $type_p hebben al een Walter P99', NULL"); mysql_query("INSERT INTO $weapons VALUES (3, 'Uzi', 1, 6000, 'item-Uzi', 65, 65, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->Uzi; return $num;', 'Al je $type_p hebben al een uzi', NULL"); mysql_query("INSERT INTO $weapons VALUES (4, 'Flashbang', 1, 10000, 'item-Flashbang', 110, 110, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Flashbang; return $num;', 'Al je $type_p hebben al een flashbang', NULL"); mysql_query("INSERT INTO $weapons VALUES (5, 'Granaat', 1, 15000, 'item-Grenade', 170, 170, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Granaat; return $num;', 'Al je $type_p hebben al een granaat', NULL"); mysql_query("INSERT INTO $weapons VALUES (6, 'MP5k', 1, 7500, 'item-MP5k', 80, 80, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (7, 'Shotgun', 1, 17500, 'item-Shotgun', 200, 200, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (8, 'G36C', 1, 22500, 'item-G36C', 270, 270, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (9, 'SIG 552', 1, 25000, 'item-SIG_552', 310, 310, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (10, 'Ak47', 1, 30000, 'item-Ak47', 390, 390, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (11, 'Ak Beta', 1, 40000, 'item-Ak_Beta', 570, 570, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (12, 'Scherpschut geweer', 1, 45000, 'item-Sniper_rifle', 670, 670, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (13, 'M4', 1, 50000, 'item-M4', 780, 780, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (14, 'Granaat Lanceerder', 1, 60000, 'item-Grenade_Launcher', 1030, 1030, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (15, 'Bazooka', 1, 75000, 'item-Bazooka', 1490, 1490, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (16, 'Kogelvrij vest', 2, 12500, 'item-Bulletproof_vest', 140, 140, '1 per $type_s (Je hebt $num $type_p die dit vest nog niet hebben)', '$num = $data->clicks-$data->{''Kogelvrij vest''}; return $num;', 'Je hebt geen $type_s die dit vest kan dragen', NULL"); mysql_query("INSERT INTO $weapons VALUES (17, 'Bulldog', 3, 2500, 'item-Bulldog', 0, 30, '5 (Je kan nog $num honden meer hebben)', '$num = 5-$data->Bulldog; return $num;', 'Je hebt al 5 honden', NULL"); mysql_query("INSERT INTO $weapons VALUES (18, 'Camera', 3, 8000, 'item-Cam', 0, 90, '7 (Je kan nog $num cameras plaatsen)', '$num = 7-$data->Camera; return $num;', 'Je hebt al 7 cameras', NULL"); mysql_query("INSERT INTO $weapons VALUES (19, 'Hek', 3, 15000, 'item-Barbed_wire', 0, 170, '3 (Je kan nog $num hekken neerzetten)', '$num = 3-$data->Hek; return $num;', 'Je hebt al 3 hekken', NULL"); mysql_query("INSERT INTO $weapons VALUES (20, 'Muur', 3, 20000, 'item-Stone_wall', 0, 240, '3 (Je kan nog $num muren bouwen)', '$num = 3-$data->Muur; return $num;', 'Je hebt al 3 muren', NULL"); mysql_query("INSERT INTO $weapons VALUES (21, 'Bunker', 3, 35000, 'item-Bunker', 0, 470, '5 (Je kan nog $num bunkers bouwen)', '$num = 5-$data->Bunker; return $num;', 'Je hebt al 5 bunkers', NULL"); mysql_query("INSERT INTO $weapons VALUES (22, 'Mobieltje', 4, 1000, 'item-Cellphone', NULL, NULL, '1 (Je kan nog $num mobieltjes kopen)', '$num = 1-$data->Mobieltje; return $num;', 'Je hebt al een mobieltje', 'Als je een mobiel hebt kun je berichten versturen en ontvangen'"); mysql_query("INSERT INTO $weapons VALUES (23, 'FN P90', 5, 50000, 'item-FN_P90', 900, 900, '1 per junkie (Je hebt nog $num junkies die dit wapen kunnen dragen)', '$num = $data->clicks-$data->{''FN P90''}; return $num;', 'Al je junkies hebben dit wapen al', NULL"); mysql_query("INSERT INTO $weapons VALUES (24, 'Chip', 6, 25000, 'item-Chip', 400, 400, '1 per kloon (Je hebt $num klonen die nog geen chip hebben)', '$num = $data->clicks-$data->Chip; return $num;', 'Al je klonen hebben al een chip in hun hoofd', NULL"); mysql_query("INSERT INTO $weapons VALUES (25, 'Helm', 7, 20000, 'item-Helmet', 240, 240, '1 per agent (Je hebt nog $num agenten zonder helm)', '$num = $data->clicks-$data->Helm; return $num;', 'Elke agent heeft al een helm', NULL"); mysql_query("INSERT INTO $weapons VALUES (26, 'Politie wagen', 7, 35000, 'item-Police_car', 470, 470, '1 per agent (Je kan nog $num wagens kopen)', '$num = $data->clicks-$data->{''Politie wagen''}; return $num;', 'Elke agent heeft al een wagen', NULL"); mysql_query("INSERT INTO $weapons VALUES (27, 'Huis', 8, 25000, 'item-Home', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een huis te bouwen', 'In ieder huis kunnen 5 clan-members'"); mysql_query("INSERT INTO $weapons VALUES (28, 'Muur', 8, 50000, 'item-Stone_wall', NULL, 3000, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een muur te bouwen', NULL"); mysql_query("INSERT INTO $weapons VALUES (29, 'Coffeeshop', 9, 90000, 'item-Joint', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een coffeeshop te bouwen', 'Met een coffeeshop verdient elke clan-member per uur:<br>Bank: $150,contant: $50'"); mysql_query("INSERT INTO $weapons VALUES (30, 'Chemie Lab', 10, 90000, 'item-Alchemy', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*150+$clan->money_lvl3*200+$clan->def_lvl1*25+$clan->def_lvl2*100+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een lab te bouwen', 'Met een chemie lab verdient elke clan-member per uur:<br>Bank: $100,contant: $100'"); mysql_query("INSERT INTO $users (`id`, `signup`, `login`, `pass`, `level`, `IP`, `email`, `type`, `url`, `info`, `cash`, `bank`, `bankleft`, `bankmax`, `clicks`, `clickstoday`, `attack`, `defence`, `attwins`, `attlosses`, `defwins`, `deflosses`, `clan`, `clanlevel`, `bonus`, `turns`, `showonline`, `online`, `activated`, `Mes`, `Walter P99`, `Uzi`, `MP5k`, `Flashbang`, `Granaat`, `Shotgun`, `G36C`, `SIG 552`, `Ak47`, `Ak Beta`, `Scherpschut geweer`, `M4`, `Granaat Lanceerder`, `Bazooka`, `Kogelvrij vest`, `Bulldog`, `Camera`, `Hek`, `Muur`, `Bunker`, `Mobieltje`, `FN P90`, `Chip`, `Helm`, `Politie wagen`, `IPs`, `blocklist`) VALUES (1, '2008-02-29 21:06:02', '$usr', '$password', 255, '0.0.0.0', '$email', 1, '', '', 500, 500, 5, 2500, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', 100, 1, '2008-02-29 21:09:17', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', ''"); mysql_close(); The line the error refers to is: mysql_query("INSERT INTO $weapons VALUES (2, 'Walter P99', 1, 5000, 'item-Walter_P99', 50, 50, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->{''Walter P99''}; return $num;', 'Al je $type_p hebben al een Walter P99', NULL"); Thanks for your help, very appreciated! Quote Link to comment Share on other sites More sharing options...
Thomisback Posted March 6, 2008 Author Share Posted March 6, 2008 I am a bit further already but still getting this error: Parse error: syntax error, unexpected '{', expecting T_STRING in etc. etc. Please, any help? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.