[ SWUnleashed Rules ] { Starships }
Warning: mysql_db_query() [function.mysql-db-query]: Access denied for user 'swunlea'@'localhost' (using password: NO) in /home/swunlea/public_html/rules/ships.php on line 111
Warning: mysql_db_query() [function.mysql-db-query]: A link to the server could not be established in /home/swunlea/public_html/rules/ships.php on line 111
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/swunlea/public_html/rules/ships.php on line 112
Warning: mysql_db_query() [function.mysql-db-query]: Access denied for user 'swunlea'@'localhost' (using password: NO) in /home/swunlea/public_html/rules/ships.php on line 180
Warning: mysql_db_query() [function.mysql-db-query]: A link to the server could not be established in /home/swunlea/public_html/rules/ships.php on line 180
SELECT a.class_id as class_id, a.name as name,a.type as type,a.is_fighter as is_fighter, a.is_unique as is_unique,a.hyperdrive as hyperdrive,
a.sublight as sublight,a.shields as shields,a.hull as hull,a.sensors as sensors,a.jammers as jammers,a.crew as crew, a.durasteel as durasteel, a.tibanna as tibanna, a.quantum as quantum, a.ardanium as ardanium, a.durelium as durelium,
a.passengers as passengers ,a.length as length,a.width as width,a.height as height, a.image as image, a.cost as cost, a.cargo_surface as cargo_surface, a.cargo_height as cargo_height, a.methane as methane, a.plasteel as plasteel,
a.maneuver as maneuver,a.pods as pods,a.is_capital as is_capital, a.docking_surface as docking_surface, a.docking_height as docking_height,
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,
a.wp_5 as wp_5,a.wp_5_num as wp_5_num,a.wp_6 as wp_6,a.wp_6_num as wp_6_num,
w1.name as w1_name, w2.name as w2_name, w3.name as w3_name, w4.name as w4_name, w5.name as w5_name, w6.name as w6_name
FROM ship_class a, weapon_class as w1,weapon_class as w2,weapon_class as w3,weapon_class as w4,weapon_class as w5,weapon_class as w6
WHERE a.type=2 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.wp_5=w5.class_id AND a.wp_6=w6.class_id AND a.needs_research=0 ORDER BY a.name |