array(0=>"X-Metal/small/Romeo_XMetal_Black.jpg", 1=>"", 2=>"Romeo"), "C"=>array(0=>"X-Metal/small/Mars_XMetalCrater_Black.jpg", 1=>"CJ;CBP", 2=>"Crater Mars"), "CJ"=>array(0=>"X-Metal/small/Juliet_Carbon_Black.jpg", 1=>"", 2=>"Carbon Juliet"), "CBP"=>array(0=>"X-Metal/small/Juliet_Carbon_Black.jpg", 1=>"", 2=>"Carbon Juliet"), "DUCATI"=>array(0=>"X-Metal/small/Ducati_Juliet.jpg", 1=>"", 2=>"Ducati Juliet"), "FINITO"=>array(0=>"X-Metal/small/Finito_JulietCarbon_VR50Black.jpg", 1=>"" , 2=>"Finito Juliet"), "IP"=>array(0=>"X-Metal/small/Juliet_Plasma_IcePolarized.jpg", 1=>"" , 2=>"Ice Polarized Juliet"), "IS"=>array(0=>"X-Metal/small/Ichiro_JulietPolished_Blue.jpg", 1=>"IS 51;IS 08", 2=>"Ichiro Blue"), "IS 51"=>array(0=>"X-Metal/small/Ichiro_JulietPolished_EmeraldSlate.jpg", 1=>"" , 2=>"Ichiro Emerald Slate"), "I 51"=>array(0=>"X-Metal/small/Ichiro_JulietPolished_Slate.jpg", 1=>"" , 2=>"Ichiro Slate"), "ICHIRO 06"=>array(0=>"X-Metal/small/Ichiro_JulietX-Metal_Slate.jpg", 1=>"" , 2=>"Ichiro X-Metal"), "IS 08"=>array(0=>"X-Metal/small/Juliet_PolishedCarbon_Slate.jpg", 1=>"" , 2=>"Ichiro Carbon"), "J"=>array(0=>"X-Metal/small/Juliet_XMetal_Black.jpg", 1=>"JB;JBR;JC;JE;JF;JG;JI;JP;JT", 2=>"X-Metal Juliet"), "JB"=>array(0=>"X-Metal/small/Juliet_Polished_Blue.jpg", 1=>"JBR" , 2=>"Polished/Blue Juliet"), "JBR"=>array(0=>"X-Metal/small/Juliet_Brown_VR28Black.jpg", 1=>"" , 2=>"Brown Juliet"), "JC"=>array(0=>"X-Metal/small/Juliet_Carbon_24k.jpg", 1=>"" , 2=>"Carbon 24K Juliet"), "JE"=>array(0=>"X-Metal/small/Juliet_Plasma_Emerald.jpg", 1=>"" , 2=>"Emerald Juliet"), "JF"=>array(0=>"X-Metal/small/Juliet_Polished_Fire.jpg", 1=>"" , 2=>"Fire Polished Juliet"), "JG"=>array(0=>"X-Metal/small/Juliet_Polished_G30.jpg", 1=>"" , 2=>"G30 Juliet"), "JI"=>array(0=>"X-Metal/small/Juliet_Plasma_Ice.jpg", 1=>"" , 2=>"Ice Juliet"), "JP"=>array(0=>"X-Metal/small/Juliet_Polished_Fire.jpg", 1=>"JPPO;JPPL", 2=>"Fire Polished Juliet"), "JPPO"=>array(0=>"X-Metal/small/Juliet_Polished_Clear.jpg", 1=>"" , 2=>"Polished Clear Juliet"), "JPPL"=>array(0=>"X-Metal/small/Juliet_Plasma_Clear.jpg", 1=>"" , 2=>"Plasma Clear Juliet"), "JT"=>array(0=>"X-Metal/small/Juliet_TiO2_VR28.jpg", 1=>"" , 2=>"TiO2 Juliet"), "M*"=>array(0=>"X-Metal/small/Mars_Leather_Gold.jpg", 1=>"" , 2=>"Leather Mars"), "M" =>array(0=>"X-Metal/small/Mars_XMetal_Black.jpg", 1=>"M*", 2=>"X-Metal Mars"), "P" =>array(0=>"X-Metal/small/Juliet_Plasma_Fire.jpg", 1=>"PB;PC;PI;PV", 2=>"Fire Juliet"), "PB" =>array(0=>"X-Metal/small/Penny_Polished_Black.jpg", 1=>"" , 2=>"Black Penny"), "PC" =>array(0=>"X-Metal/small/Penny_Copper_VR28.jpg", 1=>"" , 2=>"Copper Penny"), "PI" =>array(0=>"X-Metal/small/Penny_Titanium_Ice.jpg", 1=>"" , 2=>"Ice Penny"), "PV" =>array(0=>"X-Metal/small/Penny_Titanium_VR28.jpg", 1=>"" , 2=>"VR28 Penny"), "T" =>array(0=>"X-Metal/small/Juliet_Titanium_Gold.jpg", 1=>"" , 2=>"Gold Juliet"), "X" =>array(0=>"X-Metal/small/Juliet_XMetal_Ruby.jpg", 1=>"XG;XM;XP;XT;XX", 2=>"Ruby Juliet"), "XG" =>array(0=>"X-Metal/small/XMetalXX_24K_24K.jpg", 1=>"" , 2=>"24K XX"), "XM" =>array(0=>"X-Metal/small/Penny_XMetal_Ruby.jpg", 1=>"" , 2=>"Ruby Penny"), "XP" =>array(0=>"X-Metal/small/XMetalXX_Plasma_Ice.jpg", 1=>"" , 2=>"Ice XX"), "XT" =>array(0=>"X-Metal/small/XMetalXX_TiO2_Black.jpg", 1=>"" , 2=>"TiO2 XX"), "XX" =>array(0=>"X-Metal/small/XMetalXX_Xmetal_Black.jpg", 1=>"" , 2=>"X-Metal XX"), "24J" =>array(0=>"X-Metal/small/Juliet_24K_TitaniumPolarized.jpg", 1=>"" , 2=>"24K Juliet"), "24X" =>array(0=>"X-Metal/small/X-Squared_24K_TitaniumPolarized.jpg", 1=>"" , 2=>"24K X-Squared"), "MM" =>array(0=>"X-Metal/small/Madman_XRaw_FirePolarized.jpg", 1=>"" , 2=>"Madman Raw"), "MWMC" =>array(0=>"Accessories/small/CarbonMoneyClip_Black.jpg", 1=>"" , 2=>"Carbon Money Clip"), "MWCC" =>array(0=>"Accessories/small/CarbonCarabineer_Black.jpg", 1=>"" , 2=>"Carbon Carabineer"), "MWBC" =>array(0=>"Accessories/small/MetalWorksBlacklineCarabiner_JetBlack.jpg", 1=>"" , 2=>"Blackline Carabineer"), "BNK" =>array(0=>"Accessories/small/BunkerOrnament_Silver.jpg", 1=>"" , 2=>"Bunker Ornament"), "RSF" =>array(0=>"Accessories/small/RoboticStoreFront_AntiqueSilver.jpg", 1=>"" , 2=>"Robotic Store Front"), "LGWP" =>array(0=>"Packs/small/LatchGWP_Folded.jpg", 1=>"" , 2=>"Latch GWP"), "KSHB" =>array(0=>"Accessories/small/KillSwitch_HeritageBezel_HonedStainless.jpg", 1=>"" , 2=>"Heritage Bezel") ); if (!empty($serial)) { echo "
"; echo "
"; echo "
".$serials[$serial][2]."
"; echo "
"; echo "
"; if ($serial == "-") { $query = "SELECT * FROM collection WHERE model LIKE '%romeo%' AND model NOT LIKE '%2%' AND serial LIKE '0%' AND family = 'Eyewear:X-Metal' "; } else if ($serial == "24J") { $query = "SELECT * FROM collection WHERE model LIKE '%juliet%' AND color LIKE '%24%' AND color NOT LIKE '%carbon%' AND serial != '' AND serial NOT LIKE 'J%' AND serial NOT LIKE 'T%' AND serial NOT LIKE 'X%' AND family = 'Eyewear:X-Metal' "; } else if ($serial == "24X") { $query = "SELECT * FROM collection WHERE model LIKE '%squared%' AND color LIKE '%24%' AND serial != '' AND family = 'Eyewear:X-Metal' "; } else if ($serial == "MM") { $query = "SELECT * FROM collection WHERE model LIKE '%mad%' AND color LIKE '%raw%' AND serial != '' AND family = 'Eyewear:X-Metal' "; } else if ($serial == "BNK") { $query = "SELECT * FROM collection WHERE model LIKE '%bunker%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial == "MWCC") { $query = "SELECT * FROM collection WHERE model LIKE '%metal%' AND model LIKE '%works%' AND model LIKE '%carbon%' AND model LIKE '%carabiner%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial == "MWBC") { $query = "SELECT * FROM collection WHERE model LIKE '%metal%' AND model LIKE '%works%' AND model LIKE '%blackline%' AND model LIKE '%carabiner%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial == "MWMC") { $query = "SELECT * FROM collection WHERE model LIKE '%metal%' AND model LIKE '%works%' AND model LIKE '%money%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial == "RSF") { $query = "SELECT * FROM collection WHERE model LIKE '%robot%' AND model LIKE '%store%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial == "LGWP") { $query = "SELECT * FROM collection WHERE model LIKE '%latch%' AND (model LIKE '%gwp%' OR model LIKE '%limited%') AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial == "KSHB") { $query = "SELECT * FROM collection WHERE model LIKE '%bezel%' AND color LIKE '%heritage%' AND serial != '' AND family LIKE 'Accessories:%' "; } else { $query = "SELECT * FROM collection WHERE serial LIKE '".$serial."%' AND serial NOT LIKE '".$serial."#%' AND family = 'Eyewear:X-Metal' "; } if (!empty($serials[$serial][1])) { $conditions = explode(";",$serials[$serial][1]); foreach ($conditions as $condition){ $query .= "AND serial NOT LIKE '".$condition."%' "; } } $query .= " AND active = 'Yes' ORDER BY serial ASC"; $result = mysql_query($query); if($result) { while ($row = mysql_fetch_array($result)) { echo "".strtoupper($row["serial"])." - ".$row["member_name"]."
"; } } echo "
"; echo "
"; } else { echo "


"; $x = 1; foreach ($serials AS $serial_str => $s_arr) { echo "
"; echo "
"; echo "
".$s_arr[2]."
"; echo "
"; echo "
"; if ($serial_str == "-") { $query = "SELECT * FROM collection WHERE model LIKE '%romeo%' AND model NOT LIKE '%2%' AND serial LIKE '0%' AND family = 'Eyewear:X-Metal' "; } else if ($serial_str == "24J") { $query = "SELECT * FROM collection WHERE model LIKE '%juliet%' AND color LIKE '%24%' AND color NOT LIKE '%carbon%' AND serial != '' AND serial NOT LIKE 'J%' AND serial NOT LIKE 'T%' AND serial NOT LIKE 'X%' AND family = 'Eyewear:X-Metal' "; } else if ($serial_str == "24X") { $query = "SELECT * FROM collection WHERE model LIKE '%squared%' AND color LIKE '%24%' AND serial != '' AND family = 'Eyewear:X-Metal' "; } else if ($serial_str == "MM") { $query = "SELECT * FROM collection WHERE model LIKE '%mad%' AND color LIKE '%raw%' AND serial != '' AND family = 'Eyewear:X-Metal' "; } else if ($serial_str == "BNK") { $query = "SELECT * FROM collection WHERE model LIKE '%bunker%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial_str == "MWCC") { $query = "SELECT * FROM collection WHERE model LIKE '%metal%' AND model LIKE '%works%' AND model LIKE '%carbon%' AND model LIKE '%carabiner%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial_str == "MWBC") { $query = "SELECT * FROM collection WHERE model LIKE '%metal%' AND model LIKE '%works%' AND model LIKE '%blackline%' AND model LIKE '%carabiner%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial_str == "MWMC") { $query = "SELECT * FROM collection WHERE model LIKE '%metal%' AND model LIKE '%works%' AND model LIKE '%money%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial_str == "RSF") { $query = "SELECT * FROM collection WHERE model LIKE '%robot%' AND model LIKE '%store%' AND serial != '' AND family LIKE 'Accessories:%' "; } else if ($serial_str == "LGWP") { $query = "SELECT * FROM collection WHERE model LIKE '%latch%' AND (model LIKE '%gwp%' OR model LIKE '%limited%') AND serial != '' "; } else if ($serial_str == "KSHB") { $query = "SELECT * FROM collection WHERE model LIKE '%bezel%' AND color LIKE '%heritage%' AND serial != '' AND family LIKE 'Accessories:%' "; } else { $query = "SELECT * FROM collection WHERE serial LIKE '".$serial_str."%' AND serial NOT LIKE '".$serial_str."#%' AND family = 'Eyewear:X-Metal' "; } if (!empty($s_arr[1])) { $conditions = explode(";",$s_arr[1]); foreach ($conditions as $condition){ $query .= "AND serial NOT LIKE '".$condition."%' "; } } $query .= " AND active = 'Yes' ORDER BY serial ASC LIMIT 5"; $result = mysql_query($query); if($result) { while ($row = mysql_fetch_array($result)) { echo "".strtoupper($row["serial"])." - ".$row["member_name"]."
"; } echo "
View Full List
"; } echo "
"; echo "
"; if ($x%2 == 0) { echo "
"; } $x++; } } echo "
"; echo "
Additions to this list are through the Collection Tracker, by filling in the Serial field for an X-Metal. Do ensure the proper characters and length is correct to ensure consistency.
"; include 'inc/footer.php'; ?>