/** Displays the results of a query for objects returning the 'id' and 'name' fields.
* The query must have been done with at least a limit of '$MaxRowsReturned + 1'.
* '$MaxObjectsReturned' can be '0', which means the query had no limits (ex: $MaxNpcsReturned).
* '$OpenObjectById' must contain the name of the page used to open one of the object (ex: npc.php) by passing it
* the ID by GET method.
* 'IdAttribute' and 'NameAttribute' are the name of the columns retrieved used for ID and Name (ex: 'id' and 'name').
* '$ObjectDescription' is the text describing the kind of objects to display (ex: 'NPC'). '$ObjectsDescription' is the plural.
*/
function PrintQueryResults($FoundObjects, $MaxObjectsReturned, $OpenObjectByIdPage, $ObjectDescription, $ObjectsDescription, $IdAttribute, $NameAttribute, $ExtraField, $ExtraFieldDescription, $ExtraSkill)
{
global $dbskills;
$ObjectsToShow = mysql_num_rows($FoundObjects);
if ($ObjectsToShow > LimitToUse($MaxObjectsReturned)) {
$ObjectsToShow = LimitToUse($MaxObjectsReturned);
$MoreObjectsExist = True;
} else {
$MoreObjectsExist = False;
}
if ($ObjectsToShow == 0) {
echo "<ul><li><b>No " . $ObjectDescription . " found.</b></li></ul>\n";
} else {
echo "<ul><li><b>" . $ObjectsToShow . " " . ($ObjectsToShow == 1 ? $ObjectDescription : $ObjectsDescription) . " displayed.";
if ($MoreObjectsExist) {
echo " More " . $ObjectsDescription . " exist but you have reached the search limit.";
}
echo "</b></li>\n";
echo "<ul>\n";
for ($j = 1; $j <= $ObjectsToShow; $j++) {
$row = mysql_fetch_array($FoundObjects);
$PrintString = " <li><a href='" . $OpenObjectByIdPage . "?id=" . $row[$IdAttribute] . "'>";
if ($ObjectDescription == "npc") {
// Clean up the name for NPCs
$PrintString .= ReadableNpcName($row[$NameAttribute]);
} else {
$PrintString .= $row[$NameAttribute];
}
$PrintString .= " (" . $row[$IdAttribute] . ")</a>";
if ($ExtraField && $ExtraFieldDescription && $ExtraSkill) {
$PrintString .= " - " . ucfirstwords(str_replace("_", " ", $dbskills[$row[$ExtraSkill]])) . ", {$ExtraFieldDescription} " . $row[$ExtraField];
}
echo $PrintString;
echo "</li>\n";
}
echo "</ul>\n</ul>\n";
}
}
$iname = isset($_GET['iname']) ? $_GET['iname'] : '';
if ($isearch != "") {
if ($iname == "") {
$name = "";
} else {
$name = addslashes($iname);
}
$Query = "SELECT {$tbnpctypes}.id,{$tbnpctypes}.name\n\t\tFROM {$tbnpctypes}\n\t\tWHERE 1=1";
if ($name != "") {
$name = str_replace('`', '-', str_replace('_', '%', str_replace(' ', '%', $name)));
$Query .= " AND {$tbnpctypes}.Name like '%{$name}%'";
}
if ($HideInvisibleMen) {
$Query .= " AND {$tbnpctypes}.race != 127 AND {$tbnpctypes}.race != 240";
}
$Query .= " ORDER BY {$tbnpctypes}.Name, {$tbnpctypes}.id LIMIT " . (LimitToUse($MaxNpcsReturned) + 1);
$QueryResult = mysql_query($Query) or message_die('npcs.php', 'MYSQL_QUERY', $Query, mysql_error());
if (mysql_num_rows($QueryResult) == 1) {
$row = mysql_fetch_array($QueryResult);
header("Location: npc.php?id=" . $row["id"]);
exit;
}
}
/** Here the following holds :
* $QueryResult : NPCs queried for if any query was issued, otherwise it is not defined
* $iname : previously-typed query, or empty by default
* $isearch is set if a query was issued
*/
$Title = "NPCs search";
$XhtmlCompliant = TRUE;
include $includes_dir . 'headers.php';
echo "</td></tr>\n";
echo "<tr><td nowrap='1'><b>Deity : </b></td><td>";
SelectDeity("ideity", $ideity);
echo "</td></tr>\n";
echo "</td></tr></table>";
echo "<tr align='center'><td nowrap='1' colspan='2'><input type='submit' value='Search' name='isearch'/> <input type='reset' value='Reset'/></td></tr>\n";
echo "</form>\n";
echo "</tbody>";
echo "</table>\n";
// Print the query results if any
if (isset($QueryResult)) {
$Tableborder = 0;
$num_rows = mysql_num_rows($QueryResult);
$total_row_count = $num_rows;
if ($num_rows > LimitToUse($MaxItemsReturned)) {
$num_rows = LimitToUse($MaxItemsReturned);
}
echo "<center>";
if ($num_rows == 0) {
echo "<b>No items found...</b><br>";
} else {
$OutOf = "";
if ($total_row_count > $num_rows) {
$OutOf = " (Searches are limited to 100 Max Results)";
}
echo "<b>" . $num_rows . " " . ($num_rows == 1 ? "item" : "items") . " displayed</b>" . $OutOf . "<br>";
echo "</center>";
echo "<center><table border='{$Tableborder}' cellpadding='5' width='0%'>";
echo "<tr>\n\t\t\t\t\t<th class='menuh'>Icon</th>\n\t\t\t\t\t<th class='menuh'>Item Name</th>\n\t\t\t\t\t<th class='menuh'>Item Type</th>\n\t\t\t\t\t<th class='menuh'>AC</th>\n\t\t\t\t\t<th class='menuh'>HPs</th>\n\t\t\t\t\t<th class='menuh'>Mana</th>\n\t\t\t\t\t<th class='menuh'>Damage</th>\n\t\t\t\t\t<th class='menuh'>Delay</th>\n\t\t\t\t\t<th class='menuh'>Item ID</th>\n\t\t\t\t\t</tr>";
$RowClass = "lr";
for ($count = 1; $count <= $num_rows; $count++) {
* If 'iname' is not set then it is equivalent to searching for all factions.
* For compatbility with Wikis and multi-word searches, underscores are treated as jokers in 'iname'.
*/
include './includes/constantes.php';
include './includes/config.php';
include $includes_dir . 'mysql.php';
include $includes_dir . 'functions.php';
$isearch = isset($_GET['isearch']) ? $_GET['isearch'] : '';
$iname = isset($_GET['iname']) ? $_GET['iname'] : '';
if ($isearch != "") {
if ($iname == "") {
$name = "";
} else {
$name = str_replace('_', '%', addslashes($iname));
}
$Query = "SELECT {$tbfactionlist}.id,{$tbfactionlist}.name\n\t\t\t\tFROM {$tbfactionlist}\n\t\t\t\tWHERE {$tbfactionlist}.name like '%" . $name . "%'\n\t\t\t\tORDER BY {$tbfactionlist}.name\n\t\t\t\tLIMIT " . (LimitToUse($MaxFactionsReturned) + 1);
$QueryResult = mysql_query($Query) or message_die('factions.php', 'MYSQL_QUERY', $Query, mysql_error());
if (mysql_num_rows($QueryResult) == 1) {
$row = mysql_fetch_array($QueryResult);
header("Location: faction.php?id=" . $row["id"]);
exit;
}
}
/** Here the following holds :
* $QueryResult : factions queried for if any query was issued, otherwise it is not defined
* $iname : previously-typed query, or empty by default
* $isearch is set if a query was issued
*/
$Title = "Faction Search";
$XhtmlCompliant = TRUE;
include $includes_dir . 'headers.php';
header("Location: items.php");
exit;
}
// Query for factions
$Query = "SELECT {$tbfactionlist}.id,{$tbfactionlist}.name\n FROM {$tbfactionlist}\n WHERE {$Where}\n ORDER BY {$tbfactionlist}.name,{$tbfactionlist}.id\n LIMIT " . (LimitToUse($MaxFactionsReturned) + 1);
$FoundFactions = mysql_query($Query) or message_die('fullsearch.php', 'MYSQL_QUERY', $Query, mysql_error());
// Query for Items
if ($DiscoveredItemsOnly == TRUE) {
$Query = "SELECT * FROM {$tbitems}, discovered_items WHERE {$tbitems}.id='" . $id . "' AND discovered_items.item_id={$tbitems}.id";
$Query = "SELECT {$tbitems}.id,{$tbitems}.name\n\t\tFROM {$tbitems}, discovered_items\n\t\tWHERE {$Where}\n\t\tAND discovered_items.item_id={$tbitems}.id \n\t\tORDER BY {$tbitems}.name,{$tbitems}.id\n\t\tLIMIT " . (LimitToUse($MaxItemsReturned) + 1);
} else {
$Query = "SELECT {$tbitems}.id,{$tbitems}.name\n\t\tFROM {$tbitems}\n\t\tWHERE {$Where}\n\t\tORDER BY {$tbitems}.name,{$tbitems}.id\n\t\tLIMIT " . (LimitToUse($MaxItemsReturned) + 1);
}
$FoundItems = mysql_query($Query) or message_die('fullsearch.php', 'MYSQL_QUERY', $Query, mysql_error());
// Query for NPCs
$Query = "SELECT {$tbnpctypes}.id,{$tbnpctypes}.name\n FROM {$tbnpctypes}\n WHERE {$Where}\n ORDER BY {$tbnpctypes}.name,{$tbnpctypes}.id\n LIMIT " . (LimitToUse($MaxNpcsReturned) + 1);
$FoundNpcs = mysql_query($Query) or message_die('fullsearch.php', 'MYSQL_QUERY', $Query, mysql_error());
// In case only one object is found, redirect to its page
if (mysql_num_rows($FoundFactions) == 1 and mysql_num_rows($FoundItems) == 0 and mysql_num_rows($FoundNpcs) == 0) {
$FactionRow = mysql_fetch_array($FoundFactions);
header("Location: faction.php?id=" . $FactionRow["id"]);
exit;
}
if (mysql_num_rows($FoundFactions) == 0 and mysql_num_rows($FoundItems) == 1 and mysql_num_rows($FoundNpcs) == 0) {
$ItemRow = mysql_fetch_array($FoundItems);
header("Location: item.php?id=" . $ItemRow["id"]);
exit;
}
if (mysql_num_rows($FoundFactions) == 0 and mysql_num_rows($FoundItems) == 0 and mysql_num_rows($FoundNpcs) == 1) {
$NpcRow = mysql_fetch_array($FoundNpcs);
header("Location: npc.php?id=" . $NpcRow["id"]);
