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/>");
}
<?php
//quest.php
include "includes/common.php";
if (!empty($_REQUEST["i"])) {
$id = $_REQUEST["i"];
} else {
die("No quest specified!");
}
$sql = sprintf("call sp_getquest(%s);", $id);
$db = DB_GetConnection();
if ($db->multi_query($sql)) {
$result = $db->store_result();
}
$db->close();
$d = $result->fetch_assoc();
$skin = new skin("quest.skn");
$skin->token("QUEST_NAME", $d["quest_name"]);
$skin->token("QUEST_DESCRIPTION", $d["quest_description"]);
$skin->token("LEVEL", $d["quest_level"]);
$text = $d["quest_details"];
$text = str_replace('$B', "<br/>", $text);
$text = str_replace('$b', "<br/>", $text);
$skin->token("DETAILS", $text);
//objective section
$skin->flag("obj", !empty($d["quest_objective1"]));
for ($i = 1; $i < 5; $i++) {
if (!empty($d["quest_objective" . $i])) {
$skin->addRow("obj", $d["quest_objective" . $i]);
}
}
