[ SWUnleashed Rules ] { Vehicles }
Warning: mysql_db_query() [function.mysql-db-query]: Access denied for user 'swunlea'@'localhost' (using password: NO) in /home/swunlea/public_html/rules/vehicles.php on line 84
Warning: mysql_db_query() [function.mysql-db-query]: A link to the server could not be established in /home/swunlea/public_html/rules/vehicles.php on line 84
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/swunlea/public_html/rules/vehicles.php on line 85
Warning: mysql_query() [function.mysql-query]: Access denied for user 'swunlea'@'localhost' (using password: NO) in /home/swunlea/public_html/rules/vehicles.php on line 155
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/swunlea/public_html/rules/vehicles.php on line 155
SELECT a.class_id as class_id, a.name as name,a.type as type, a.is_unique as is_unique,
a.shield as shield,a.hull as hull,a.sensors as sensors,a.counters as counters,a.crew as crew,
a.passengers as passengers ,a.length as length,a.width as width,a.height as height, a.cargo_surface as cargo_surface,
a.durasteel as durasteel, a.tibanna as tibanna, a.methane as methane, a.cost as cost, a.cargo_height as cargo_height,
a.speed as speed, a.image as image, a.restrictions as restrictions, a.cost as cost, a.plasteel as plasteel,
a.wp_1 as wp_1,a.wp_1_num as wp_1_num,a.wp_2 as wp_2,a.wp_2_num as wp_2_num,
a.wp_3 as wp_3,a.wp_3_num as wp_3_num,a.wp_4 as wp_4,a.wp_4_num as wp_4_num,
w1.name as w1_name,w1.damage as w1_damage,w2.name as w2_name,
w3.name as w3_name,w3.damage as w3_damage,w4.name as w4_name
FROM vehicle_class as a, weapon_class as w1,weapon_class as w2,weapon_class as w3,weapon_class as w4
WHERE a.type=3 AND a.is_unique=0 AND a.wp_1=w1.class_id AND a.wp_2=w2.class_id AND a.wp_3=w3.class_id AND a.wp_4=w4.class_id AND a.needs_research=0 ORDER BY a.name |