Предисловие:
В таблице "character_inventory" в колонке "item" хранится информация о guid предмета
В таблице "item_instance" в колонке "itemEntry" хранится информация об ID по GUID предмета
Требуется получить guid предмета, далее подключиться к другой таблице и получить ID по GUID
При этом мы имеем 18 значений
т.е каждый итем в своем слоте
Мой код выводит NULL по каждой переменной. Подскажите как реализовать?
PHP:
скопировать код в буфер обмена
<?PHP include('config.php'); $sql = mysql_query("SELECT * FROM `character_inventory` WHERE `guid` = '{$guid['guid']}' AND slot > 0 AND slot < 19 AND `bag` = 0", $connect) or die(mysql_error()); // Generic xml $xml_data = '<?xml version="1.0" encoding="utf-8" ?>' . "\n"; $xml_data .= "<Characters>\n"; $xml_data .= "\t<Stat>\n"; { if ($result['slot']==0) { $head = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $head = $head['itemEntry']; } if ($result['slot']==1) { $neck = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $neck = $neck['itemEntry']; } if ($result['slot']==2) { $shoulders = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $shoulders = $shoulders['itemEntry']; } if ($result['slot']==3) { $bodyChar = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $bodyChar = $bodyChar['itemEntry']; } if ($result['slot']==4) { $cheast = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $cheast = $cheast['itemEntry']; } if ($result['slot']==5) { $waist = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $waist = $waist['itemEntry']; } if ($result['slot']==6) { $legs = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $legs = $legs['itemEntry']; } if ($result['slot']==7) { $feet = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $feet = $feet['itemEntry']; } if ($result['slot']==8) { $wrists = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $wrists = $wrists['itemEntry']; } if ($result['slot']==9) { $hands = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $hands = $hands['itemEntry']; } if ($result['slot']==10) { $finger1 = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $finger1 = $finger1['itemEntry']; } if ($result['slot']==11) { $finger2 = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $finger2 = $finger2['itemEntry']; } if ($result['slot']==12) { $trinket1 = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $trinket1 = $trinket1['itemEntry']; } if ($result['slot']==13) { $trinket2 = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $trinket2 = $trinket2['itemEntry']; } if ($result['slot']==14) { $back = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $back = $back['itemEntry']; } if ($result['slot']==15) { $mainHand = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $mainHand = $mainHand['itemEntry']; } if ($result['slot']==16) { $offHand = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $offHand = $offHand['itemEntry']; } if ($result['slot']==17) { $ranged = mysql_query("SELECT itemEntry FROM `item_instance` WHERE guid = '{$result['item']}' AND owner_guid = '{$guid['guid']}'", $connect) or die(mysql_error()); $ranged = $ranged['itemEntry']; } } $xml_data .= "\t<CharBlock>\n"; $xml_data .= "\t\t<HeadChar>$head</HeadChar>\n"; $xml_data .= "\t\t<Neck>$neck</Neck>\n"; $xml_data .= "\t\t<Shoulders>$shoulders</Shoulders>\n"; $xml_data .= "\t\t<BodyChar>$bodyChar</BodyChar>\n"; $xml_data .= "\t\t<ChestChar>$cheast</ChestChar>\n"; $xml_data .= "\t\t<Waist>$waist</Waist>\n"; $xml_data .= "\t\t<Legs>$legs</Legs>\n"; $xml_data .= "\t\t<Feet>$feet</Feet>\n"; $xml_data .= "\t\t<Wrists>$wrists</Wrists>\n"; $xml_data .= "\t\t<Hands>$hands</Hands>\n"; $xml_data .= "\t\t<Finger1>$finger1</Finger1>\n"; $xml_data .= "\t\t<Finger2>$finger2</Finger2>\n"; $xml_data .= "\t\t<Trinket1>$trinket1</Trinket1>\n"; $xml_data .= "\t\t<Trinket2>$trinket2</Trinket2>\n"; $xml_data .= "\t\t<Back>$back</Back>\n"; $xml_data .= "\t\t<MainHand>$mainHand</MainHand>\n"; $xml_data .= "\t\t<OffHand>$offHand</OffHand>\n"; $xml_data .= "\t\t<Ranget>$ranged</Ranget>\n"; $xml_data .= "\t</CharBlock>\n"; $xml_data .= "\t</Stat>\n"; $xml_data .= "</Characters>"; echo $xml_data; ?>
|