function saveThread($id, $title) { $sql = sprintf("call sp_save_thread(%s, %s)", $id, prep_str($title)); $db = DB_GetConnection(); if ($db->multi_query($sql)) { $result = $db->store_result(); $row = $result->fetch_assoc(); return $row["thread_id"]; } else { return 0; } }
function save_item($d) { global $database; $stats = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0); $stats[$d[29]] = $d[30]; $stats[$d[31]] = $d[32]; $stats[$d[33]] = $d[34]; $stats[$d[35]] = $d[36]; $stats[$d[37]] = $d[38]; $stats[$d[39]] = $d[40]; $stats[$d[41]] = $d[42]; $stats[$d[43]] = $d[44]; $stats[$d[45]] = $d[46]; $stats[$d[47]] = $d[48]; $q = "call sp_saveitem("; $q .= $d[1] . ","; //item id $q .= $d[3] . ","; //class id $q .= $d[4] . ","; //subclass id $q .= prep_str($d[5]) . ","; //name $q .= $d[9] . ","; //icon id $q .= $d[10] . ","; //quality id $q .= $d[14] . ","; //slot id $q .= $d[17] . ","; //item level $q .= $d[18] . ","; //req'd level $q .= $d[26] . ","; //is unique $q .= $stats[3] . ","; //agility $q .= $stats[4] . ","; //strength $q .= $stats[7] . ","; //stamina $q .= $stats[5] . ","; //intelligence $q .= $stats[6] . ","; //spirit $q .= $d[64] . ","; //armor $q .= $d[65] . ","; //resist holy $q .= $d[66] . ","; //resist fire $q .= $d[67] . ","; //resist nature $q .= $d[68] . ","; //resist frost $q .= $d[69] . ","; //resist shadow $q .= $d[70] . ","; //resist arcane $q .= $d[71] . ","; //weapon delay $q .= $d[72] . ","; //ammo type $q .= $d[104] . ","; //bond id $q .= $d[111] . ","; //materiel id $q .= $d[114] . ","; //block value $q .= $d[115] . ","; //set id $q .= $d[116] . ","; //durability $q .= prep_str($d[105]) . ","; //description $q .= $d[74] . ","; //spell id 1 $q .= $d[75] . ","; //spell trigger 1 $q .= $d[80] . ","; //spell id 2 $q .= $d[81] . ","; //spell trigger 2 $q .= $d[86] . ","; //spell id 3 $q .= $d[87] . ","; //spell trigger 3 $q .= $d[49] . ","; //damage min 1 $q .= $d[50] . ","; //damage max 1 $q .= $d[109] . ")"; //begin quest id if (!isset($database)) { $database = DB_GetConnection(); } if ($result = $database->multi_query($q)) { do { /* store first result set */ if ($result = $database->store_result()) { $result->close(); } } while ($database->next_result()); } //printf($database->error . "<hr/>"); }