"; $ot = $catsubs[$cat][$bonus]; /* if ($id == $aid) $catsubs[$cat][$bonus] = "";*/ /*else*/if (!$ot) $catsubs[$cat][$bonus] = ""; $ot = $catsubitems[$cat][$bonus]; if ($plus == 0 && !$wasplus0) { $catsubitems[$cat][$bonus] = $aid. ($ot?",":""). $ot; $wasplus0 = true; } else $catsubitems[$cat][$bonus] = $ot. ($ot?",":""). $aid; ++$totalitems; } $id = secure($_GET['id']); if (!is_valid_itemid($id)) die; $links = GetLinks(); $texts = GetTexts(); $extid = $id % 1000 + 1000*intval($id / 1000000000); $baseid = $id-($id%1000); $found = false; $alliorg = "*"; //Changed to * because of the discrepancy between $alliext = "*"; //tables of different versions $version = secure($_GET['version']); $countries = ko_versions(); if (in_array($version, $countries, true)) $cs = array($version); else $cs = $countries; foreach($cs as $country) { $iorg = tablename($country,"item_org"); $result = mysql_query("select $alliorg from $iorg where id=$baseid"); if ($result && mysql_num_rows($result)>0){ $item = mysql_fetch_array($result, MYSQL_ASSOC); $ext = $item["Category"]; $iext = tablename($country,"item_ext_$ext"); $extsql = mysql_query("select $alliext from $iext where id=$extid"); if ($extsql && mysql_num_rows($extsql)>0) { $found = true; break; } } } if (!$found) { show_header("Item Information"); if ($version) { ko_error("This item doesn't exist in the specified KO version!"); } else { ko_error("Item not found in any KO version!"); } } /* Why was this needed? It broke some valid items. if ($ext == 22 && $extid != 0 && $item["byAttachPoint"] >= 10) { show_header("Item Information"); ko_error("Invalid Item ID"); } */ //moved this to the foreach country //$item = &mysql_fetch_array($result, MYSQL_ASSOC); //$ext = $item["Category"]; //$iext = tablename($country,"item_ext_$ext"); //$extsql = mysql_query("SELECT $alliext FROM $iext WHERE id=$extid"); $olditem = $item; $notrade = (($id >= 900000000 && $id < 1000000000) || $item["byNeedRace"] == 20); $purename = $item["Name"]; $enc = country_enc($country); $itemext = mysql_fetch_array($extsql); $olditemext = $itemext; $totalitems = 0; $wasplus0 = false; $base = $id; $class = $itemext["type"]; $isplain = true; if ($class == 12) { $isplain = false; $name = $itemext["name"]; $purename = trim(preg_replace("/\(\+[0-9]*\)/", "", $name)); $pp = strpos($name, "(+"); if ($pp) { $plus = substr($name,$pp+2, -1); } else $plus = ($extid-1)%30+1; $base = $base-$plus+1; $rbitemext = mysql_fetch_assoc(mysql_query //echo "ALMA ".( ("SELECT $alliext FROM $iext WHERE id=".($extid-$plus+1))); $rbext = $ext; $cond = "name LIKE '$purename%' AND ap=".$rbitemext["ap"]; $baseext = ext_rb_to_base($ext); $ibext = tablename($country,"item_ext_$baseext"); $basesql = mysql_query // echo ("SELECT $alliext FROM $ibext WHERE $cond"); if (mysql_num_rows($basesql) == 0) { $baseext = 23; $ibext = tablename($country,"item_ext_$baseext"); $basesql = mysql_query ("SELECT $alliext FROM $ibext WHERE $cond"); } // echo "
match:".mysql_num_rows($basesql)."
"; if (mysql_num_rows($basesql)) { //transition to Unique $baseitemext = mysql_fetch_assoc($basesql); $base = itemcomposeid($baseitemext["baseitem"],$baseitemext["ID"]); $class = $baseitemext["type"]; $iext = $ibext; $itemext = $baseitemext; $result = mysql_query // echo ("select $alliorg from $iorg where id=".$baseitemext["baseitem"]); $item = mysql_fetch_assoc($result); } } if ($class == 4) { $isplain = false; $name = $itemext["name"]; $purename = preg_replace("/\(\+[0-9]*\)/", "", $name); $cond = ci_binop("name","=",$purename); if ($purename != trim($purename)) $cond .= " OR ".ci_binop("name","=",trim($purename)); $basesql = mysql_query // echo ("SELECT $alliext FROM $iext WHERE $cond"); // echo mysql_num_rows($basesql)."
"; } if ($basesql && mysql_num_rows($basesql)) { $baseitemext = mysql_fetch_assoc($basesql); $base = itemcomposeid($baseitemext["baseitem"],$baseitemext["ID"]); } $isupgrade = false; if ($class == 11) { $up_rb = $baseid; $item_rb = $item; $basesql = mysql_query("SELECT $alliorg FROM $iorg WHERE ".ci_binop("name", "=",$item["Name"])." AND $nonrbpred AND `Attack Power`=". $item["Attack Power"]); $item_normal = mysql_fetch_assoc($basesql); $base = $item_normal["ID"]; // echo mysql_num_rows($basesql)."
"; $isupgrade = true; $isplain = false; } if ($ext != 22 && $class == 0 || $class == 1 || $class == 2 || $class == 5) { $base = $baseid; $item_normal = $item; $basesql = mysql_query // echo ("SELECT $alliorg FROM $iorg WHERE ".ci_binop("name", "=",$item["Name"])." AND $rbpred AND `Attack Power`=". $item["Attack Power"]); if ($basesql && mysql_num_rows($basesql)) { $item_rb = mysql_fetch_assoc($basesql); $up_rb = $item_rb["ID"]; // echo mysql_num_rows($basesql)."
"; } $isupgrade = true; $isplain = false; } if ($isupgrade) $purename = $item_normal["Name"]; if ($class == 3 || $class == 9)// || $class == 6 || $class == 8 // USE org name instead $purename = $itemext["name"]; //small fix for Ext 22 //if ($class == 4 && $item["Category"] == 22) $purename = $item["Name"]; // echo "org:".$base.":".ko_item($base); $disname = $purename; if ($disname == "supply item") $disname = $item["Name"];//FIX lame bug $namedisp = iconv($enc,"utf-8",$disname); show_header($namedisp); ?>
var iSel = '$id'; var aStats = new Array(); EOF; $allcats = array(); $catsubs = array(); $catsubitems = array(); if ($class == 4) { $purename = trim($purename); $ext = $item["Category"]; $iext = tablename($country,"item_ext_$ext"); $baseitem = $item["ID"];//////// Added by ct $normal = mysql_query // $query = ("SELECT $alliext FROM $iext WHERE SUBSTR(".ci_binop("name",",1,". strlen($purename).") = ",$purename). " AND baseitem = $baseitem ORDER BY ID"); //////// Added by ct // echo "alert('$query');"; while ($itemext = mysql_fetch_assoc($normal)) { add_item($item,$itemext,$bs,"Unique"); } $rbsql = mysql_query // echo ("SELECT $alliorg FROM $iorg WHERE ".ci_binop("name","=", $item["Name"])." AND id != $item[ID] AND $rbpred"); // echo "rb match:".mysql_num_rows($rbsql)."
"; if (mysql_num_rows($rbsql)) { $item = mysql_fetch_assoc($rbsql); $baseitem = $item["ID"];//////// Added by ct $ext = $item["Category"]; $iext = tablename($country,"item_ext_$ext"); $rebirth = mysql_query ("SELECT $alliext FROM $iext WHERE SUBSTR(".ci_binop("name",",1,". strlen($purename).") = ",$purename). " AND baseitem = $baseitem ORDER BY ID"); //////// Added by ct while ($itemext = mysql_fetch_assoc($rebirth)) { add_item($item,$itemext,$bs,"Rebirth unique"); } } } elseif ($isupgrade) { $bs = ($item_normal["byNeedRace"] >= 111); $iext = tablename($country,"item_ext_$item_normal[Category]"); $normal = mysql_query // echo ("SELECT $alliext FROM $iext WHERE type IN ('0','1','2','5')"); // echo mysql_num_rows($normal)."
"; while ($itemext = mysql_fetch_assoc($normal)) { add_item($item_normal,$itemext,$bs,cat_sub($itemext)); } $iext = tablename($country,"item_ext_$item_rb[Category]"); $normal = mysql_query("SELECT $alliext FROM $iext WHERE type IN ('11')"); if ($normal && mysql_num_rows($normal)) while ($itemext = mysql_fetch_assoc($normal)) { add_item($item_rb,$itemext,$bs,cat_sub($itemext)); } }/* else { $tbody = ItemDisplay($item, $itemext, $links, $texts, $country); echo "$tbody
"; }*/ if ($totalitems <= 1) { $isplain = true; $isupgrade = false; echo << EOF; $tbody = ItemDisplay($olditem, $olditemext, $links, $texts, $country); echo "$tbody
"; } if (!$isplain) { echo <<0) plus.remove(0); left = selitem.value; while(left != "") { var comma = left.indexOf(","); var nextid; if (comma == -1) { nextid = parseInt(left); left = ""; } else { nextid = parseInt(left.substr(0,comma)); left = left.substr(comma+1); } $("#plus").append(''); $("#plus").removeClass().addClass("c"+aStats[nextid].Class); } plusChange(); } var oldplus; function plusChange() { var plus = document.getElementById("plus"); var disp = document.getElementById("itemdisp"); var id = plus.options[plus.selectedIndex].value; if (oldplus != id) { oldplus = id; disp.innerHTML = aStats[id].Display; EOF; // ShowMerchant(); // Prices feature removed due to distance check echo <<
Item TypePlus
"; echo <<

You must have Javascript enabled to view this.

Link Item

EOF; } echo ""; /* echo ""; echo ""; if ($notrade) { echo ""; } else { echo ""; echo ""; } echo "
Merchant
$sitetext[k2isgaynotice]
This item is not tradeable therefore it cannot be put into merchant.

Server:"; echo "

"; echo "";*/ echo ""; echo ""; echo quests_involving($base,$country); echo "
"; ?> "; if (!$isplain) { echo << -1) { cats.selectedIndex = i; } } catChange(); for (var i=0; i -1) { plus.selectedIndex = i; } } plusChange(); EOF; } else echo ""; // echo "ShowMerchant();"; echo ""; if ($country == "us") { $link = ko_comments(8, $purename, $base); echo <<$link EOF; } show_footer(); ?>