Menu
▾
▴
[PlaneShift-svn] SF.net SVN: planeshift:[10027] www/webconsole-new
|
From: <lpa...@us...> - 2025-07-05 10:48:53
|
Revision: 10027
http://sourceforge.net/p/planeshift/code/10027
Author: lpancallo
Date: 2025-07-05 10:48:46 +0000 (Sat, 05 Jul 2025)
Log Message:
-----------
Fixed edit item for new fields
Added search item by name
Added check npc distribution
Modified Paths:
--------------
www/webconsole-new/items/createitem.php
www/webconsole-new/items/editcategory.php
www/webconsole-new/items/edititem.php
www/webconsole-new/items/itemmain.php
www/webconsole-new/npcs/npc_details.php
www/webconsole-new/npcs/npcmain.php
www/webconsole-new/quests/validatequest.php
Added Paths:
-----------
www/webconsole-new/items/searchitems.php
www/webconsole-new/menu_actions.php
www/webconsole-new/menu_top.php
www/webconsole-new/npcs/viewnpcdistribution.php
Modified: www/webconsole-new/items/createitem.php
===================================================================
--- www/webconsole-new/items/createitem.php 2025-06-30 17:10:55 UTC (rev 10026)
+++ www/webconsole-new/items/createitem.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -259,9 +259,9 @@
$cols = $cols . ', extra_info';
$values = $values . ", '$extra_info'";
}
- if (isset($_POST['spell_feature_timing'])){
- $spell_feature_timing = escapeSqlString($_POST['spell_feature_timing']);
- $cols = $cols . ', spell_feature_timing';
+ if (isset($_POST['script_can_use'])){
+ $spell_feature_timing = escapeSqlString($_POST['script_can_use']);
+ $cols = $cols . ', script_can_use';
$values = $values . ", '$spell_feature_timing'";
}
if (isset($_POST['item_anim_id'])){
@@ -373,7 +373,7 @@
echo '<tr><td>spell_on_hit_prob</td><td><input type="text" name="spell_on_hit_prob" /></td></tr>';
echo '<tr><td>spell_id_feature</td><td><input type="text" name="spell_id_feature" /></td></tr>';
echo '<tr><td>extra_info</td><td><input type="text" name="extra_info" /></td></tr>';
- echo '<tr><td>spell_feature_timing</td><td><input type="text" name="spell_feature_timing" /></td></tr>';
+ echo '<tr><td>script_can_use</td><td><input type="text" name="script_can_use" /></td></tr>';
echo '<tr><td>item_anim_id</td><td><input type="text" name="item_anim_id" /></td></tr>';
$script_result = PrepSelect('scripts');
echo '<tr><td>equip_script</td><td>'.DrawSelectBox('scripts', $script_result, 'equip_script' , '', 'true').'</td></tr>';
Modified: www/webconsole-new/items/editcategory.php
===================================================================
--- www/webconsole-new/items/editcategory.php 2025-06-30 17:10:55 UTC (rev 10026)
+++ www/webconsole-new/items/editcategory.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -9,12 +9,12 @@
{
$id = escapeSqlString($_GET['id']);
$name = escapeSqlString($_POST['name']);
- $item_stat_id_repair_tool = escapeSqlString($_POST['item_stat_id_repair_tool']);
+ $item_stat_id_repair_tool = escapeSqlString($_POST['repair_tool_id']);
$is_repair_tool_consumed = escapeSqlString($_POST['is_repair_tool_consumed']);
$skill_id_repair = escapeSqlString($_POST['skill_id_repair']);
$identify_skill_id = escapeSqlString($_POST['identify_skill_id']);
$identify_min_skill = escapeSqlString($_POST['identify_min_skill']);
- $query = "UPDATE item_categories SET name='$name', item_stat_id_repair_tool='$item_stat_id_repair_tool', is_repair_tool_consumed='$is_repair_tool_consumed', skill_id_repair='$skill_id_repair', identify_skill_id='$identify_skill_id', identify_min_skill='$identify_min_skill' WHERE category_id='$id'";
+ $query = "UPDATE item_categories SET name='$name', repair_tool_id='$item_stat_id_repair_tool', is_repair_tool_consumed='$is_repair_tool_consumed', skill_id_repair='$skill_id_repair', identify_skill_id='$identify_skill_id', identify_min_skill='$identify_min_skill' WHERE category_id='$id'";
$result = mysql_query2($query);
echo '<script language="javascript">';
@@ -29,7 +29,7 @@
return;
}
$id = escapeSqlString($_GET['id']);
- $query = "SELECT category_id, name, item_stat_id_repair_tool, is_repair_tool_consumed, skill_id_repair, identify_skill_id, identify_min_skill FROM item_categories WHERE category_id='$id'";
+ $query = "SELECT category_id, name, repair_tool_id, is_repair_tool_consumed, skill_id_repair, identify_skill_id, identify_min_skill FROM item_categories WHERE category_id='$id'";
$result = mysql_query2($query);
$row = fetchSqlAssoc($result);
@@ -39,7 +39,7 @@
echo '<table border="1"><form action="./index.php?do=editcategory&commit&id='.$row['category_id'].'" method="post">';
echo '<tr><th>Field</th><th>Value</th></tr>';
echo '<tr><td>Name: </td><td><input type="text" name="name" value="'.$row['name'].'"/></td></tr>';
- echo '<tr><td>Repair Tool: </td><td>'.DrawSelectBox('items', $item_result, 'item_stat_id_repair_tool', $row['item_stat_id_repair_tool'], 'true').'</td></tr>';
+ echo '<tr><td>Repair Tool: </td><td>'.DrawSelectBox('items', $item_result, 'repair_tool_id', $row['item_stat_id_repair_tool'], 'true').'</td></tr>';
echo '<tr><td>Consume Repair Tool: </td><td>';
if ($row['is_repair_tool_consumed'] == "Y")
{
@@ -59,7 +59,7 @@
}
else
{
- $query = "SELECT ic.category_id, ic.name, i.name AS repair_item_name FROM item_categories AS ic LEFT JOIN item_stats AS i ON i.id=item_stat_id_repair_tool ORDER BY name ASC";
+ $query = "SELECT ic.category_id, ic.name, i.name AS repair_item_name FROM item_categories AS ic LEFT JOIN item_stats AS i ON i.id=repair_tool_id ORDER BY name ASC";
$result = mysql_query2($query);
$q2 = 'SELECT c.category_id, COUNT(i.id) AS items FROM item_categories AS c LEFT JOIN item_stats AS i ON c.category_id=i.category_id GROUP by c.category_id';
$r2 = mysql_query2($q2);
Modified: www/webconsole-new/items/edititem.php
===================================================================
--- www/webconsole-new/items/edititem.php 2025-06-30 17:10:55 UTC (rev 10026)
+++ www/webconsole-new/items/edititem.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -78,7 +78,7 @@
echo '<tr><td>spell_on_hit_prob</td><td><input type="text" name="spell_on_hit_prob" value="'.$row['spell_on_hit_prob'].'"/></td></tr>';
echo '<tr><td>spell_id_feature</td><td><input type="text" name="spell_id_feature" value="'.$row['spell_id_feature'].'"/></td></tr>';
echo '<tr><td>extra_info</td><td><input type="text" name="extra_info" value="'.$row['extra_info'].'"/></td></tr>';
- echo '<tr><td>spell_feature_timing</td><td><input type="text" name="spell_feature_timing" value="'.$row['spell_feature_timing'].'" /></td></tr>';
+ echo '<tr><td>script_can_use</td><td><input type="text" name="script_can_use" value="'.$row['script_can_use'].'" /></td></tr>';
echo '<tr><td>item_anim_id</td><td><input type="text" name="item_anim_id" value="'.$row['item_anim_id'].'"/></td></tr>';
echo '<tr><td>item_max_quality</td><td><input type="text" name="item_max_quality" value="'.$row['item_max_quality'].'"/></td></tr>';
echo '<tr><td>equip_script</td><td><textarea name="equip_script" rows="6" cols="55">'.htmlspecialchars($row['equip_script']).'</textarea></td></tr>';
@@ -220,8 +220,8 @@
$query = $query . "spell_id_feature='$spell_id_feature', ";
$extra_info = escapeSqlString($_POST['extra_info']);
$query = $query . "extra_info='$extra_info', ";
- $spell_feature_timing = escapeSqlString($_POST['spell_feature_timing']);
- $query = $query . "spell_feature_timing='$spell_feature_timing', ";
+ $script_can_use = escapeSqlString($_POST['script_can_use']);
+ $query = $query . "script_can_use='$script_can_use', ";
$item_anim_id = escapeSqlString($_POST['item_anim_id']);
$query = $query . "item_anim_id='$item_anim_id', ";
$item_max_quality = escapeSqlString($_POST['item_max_quality']);
Modified: www/webconsole-new/items/itemmain.php
===================================================================
--- www/webconsole-new/items/itemmain.php 2025-06-30 17:10:55 UTC (rev 10026)
+++ www/webconsole-new/items/itemmain.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -4,7 +4,8 @@
if (checkaccess('items', 'read'))
{
echo '<div class="menu_left">'."\n";
- echo '<a href="./index.php?do=listitems">List items</a> <br/>'."\n";
+ echo '<a href="./index.php?do=listitems">List items by category</a> <br/>'."\n";
+ echo '<a href="./index.php?do=searchitems">Search items by name</a> <br/>'."\n";
echo '<a href="./index.php?do=compareitems">Compare items</a> <br/>'."\n";
echo '<a href="./index.php?do=listitemicons">List item icons</a> <br/>'."\n";
echo '<a href="./index.php?do=finditem">Locate Items</a> <br/>'."\n";
Added: www/webconsole-new/items/searchitems.php
===================================================================
--- www/webconsole-new/items/searchitems.php (rev 0)
+++ www/webconsole-new/items/searchitems.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -0,0 +1,82 @@
+<?php
+function searchitems()
+{
+ if (!checkaccess('items', 'read'))
+ {
+ echo '<p class="error">You are not authorized to use these functions</p>';
+ return;
+ }
+ $Search1 = "";
+ if (!empty($_POST['word1']))
+ $Search1 = $_POST['word1'];
+ $Search2 = "";
+ if (!empty($_POST['word2']))
+ $Search2 = $_POST['word2'];
+ $Search3 = "";
+ if (!empty($_POST['word3']))
+ $Search3 = $_POST['word3'];
+
+ echo '<p class="bold">Search by name all item definitions (item_stats)<br/></p>'."\n";
+ echo '<form action="./index.php?do=searchitems" method="post"><table>'."\n";
+ echo '<tr><td>Name: </td><td><input type="text" name="word1" value="'.$Search1.'"/></td></tr>'."\n";
+ echo '<tr><td>AND</td></tr>'."\n";
+ echo '<tr><td>Description: </td><td><input type="text" name="word2" value="'.$Search2.'"/></td></tr>'."\n";
+ echo '<tr><td>AND</td></tr>'."\n";
+ echo '<tr><td>Mesh Name: </td><td><input type="text" name="word3" value="'.$Search3.'"/></td></tr>'."\n";
+ echo '<tr><td><input type="submit" name="commit" value="Search" /></td><td></td></tr>';
+ echo '</table></form>';
+
+ // at least one criteria is present
+ if( (isset($_POST['word1']) && $_POST['word1'] != "") ||
+ (isset($_POST['word2']) && $_POST['word2'] != "") ||
+ (isset($_POST['word3']) && $_POST['word3'] != ""))
+ {
+ $query = "SELECT i.id, i.name, c.name as cname, i.description, i.cstr_gfx_mesh FROM item_stats as i, item_categories as c WHERE i.category_id = c.category_id AND ";
+ // check criterias
+ $first = true;
+ $escSearch1 = escapeSqlString($_POST['word1']);
+ if(isset($_POST['word1']) && $_POST['word1'] != "") {
+
+ $query = $query . " i.name like '%" . $escSearch1 . "%'";
+ $first = false;
+ }
+ if(isset($_POST['word2']) && $_POST['word2'] != "") {
+ $escSearch2 = escapeSqlString($_POST['word2']);
+ if ($first)
+ $query = $query . " i.description like '%" . $escSearch2 . "%'";
+ else
+ $query = $query . " and i.description like '%" . $escSearch2 . "%'";
+ $first = false;
+ }
+ if(isset($_POST['word3']) && $_POST['word3'] != "") {
+ $escSearch3 = escapeSqlString($_POST['word3']);
+ if ($first)
+ $query = $query . " cstr_gfx_mesh like '%" . $escSearch3 . "%'";
+ else
+ $query = $query . " and cstr_gfx_mesh like '%" . $escSearch3 . "%'";
+ }
+
+ $query = $query . " ORDER BY cname ASC, i.name ASC";
+ $result = mysql_query2($query);
+
+ echo "Found ".sqlNumRows($result)." results<br/>";
+ if (sqlNumRows($result) > 0)
+ {
+ echo '<table border="1">'."\n";
+ echo '<tr><th>Category</th><th>ID</th><th>Name</th><th>Description</th><th>Mesh</th>';
+
+ while ($row = fetchSqlAssoc($result))
+ {
+ echo '<tr>';
+ echo '<td>'.$row['cname'].'</td>';
+ echo '<td>'.$row['id'].'</td>';
+ echo '<td><a href="./index.php?do=listitems&item='.$row['id'].'">'.$row['name'].'</a></td>';
+ echo '<td>'.$row['description'].'</td>';
+ echo '<td>'.$row['cstr_gfx_mesh'].'</td>';
+ echo '</tr>'."\n";
+ }
+ echo '</table>';
+ }
+ }
+}
+?>
Property changes on: www/webconsole-new/items/searchitems.php
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: www/webconsole-new/menu_actions.php
===================================================================
--- www/webconsole-new/menu_actions.php (rev 0)
+++ www/webconsole-new/menu_actions.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -0,0 +1,1077 @@
+<?php
+switch ($_GET['do']){
+ case 'listquests':
+ include('./quests/questmain.php');
+ include('./quests/listquests.php');
+ questmain();
+ listquests();
+ countquests();
+ break;
+ case 'readquest':
+ include('./quests/questmain.php');
+ include('./quests/listquests.php');
+ questmain();
+ readquest();
+ break;
+ case 'validatequest':
+ include('./quests/questmain.php');
+ include('./quests/validatequest.php');
+ questmain();
+ validatequest();
+ break;
+ case 'editquest':
+ include('./quests/questmain.php');
+ include('./quests/editquest.php');
+ questmain();
+ editquest();
+ break;
+ case 'npcquests':
+ include('./quests/questmain.php');
+ include('./quests/listquests.php');
+ questmain();
+ npcquests();
+ break;
+ case 'createquest':
+ include('./quests/questmain.php');
+ include('./quests/createquest.php');
+ questmain();
+ createquest();
+ break;
+ case 'deletequest':
+ include('./quests/questmain.php');
+ include('./quests/deletequest.php');
+ questmain();
+ deletequest();
+ break;
+ case 'items':
+ include('./items/itemmain.php');
+ itemmain();
+ break;
+ case 'listitems':
+ include('./items/itemmain.php');
+ include('./items/listitems.php');
+ itemmain();
+ listitems();
+ break;
+ case 'compareitems':
+ include('./items/itemmain.php');
+ include('./items/compareitems.php');
+ itemmain();
+ compareitems();
+ break;
+ case 'listitemicons':
+ include('./items/itemmain.php');
+ include('./items/listitemicons.php');
+ itemmain();
+ listitemicons();
+ break;
+ case 'showitemusage':
+ include('./items/itemmain.php');
+ include('./items/listitems.php');
+ itemmain();
+ showitemusage();
+ break;
+ case 'edititem':
+ include('./items/itemmain.php');
+ include('./items/edititem.php');
+ itemmain();
+ edititem();
+ break;
+ case 'deleteitem':
+ include('./items/itemmain.php');
+ include('./items/deleteitem.php');
+ itemmain();
+ deleteitem();
+ break;
+ case 'createitem':
+ include('./items/itemmain.php');
+ include('./items/createitem.php');
+ itemmain();
+ createitem();
+ break;
+ case 'searchbooks':
+ include('./items/itemmain.php');
+ include('./items/searchbooks.php');
+ itemmain();
+ searchbooks();
+ break;
+ case 'searchitems':
+ include('./items/itemmain.php');
+ include('./items/searchitems.php');
+ itemmain();
+ searchitems();
+ break;
+ case 'wherebooks':
+ include('./items/itemmain.php');
+ include('./items/wherebooks.php');
+ itemmain();
+ wherebooks();
+ break;
+ case 'codexbooks':
+ include('./items/itemmain.php');
+ include('./items/codexbooks.php');
+ itemmain();
+ codexbooks();
+ break;
+ case 'editcategory':
+ include('./items/itemmain.php');
+ include('./items/editcategory.php');
+ itemmain();
+ editcategory();
+ break;
+ case 'deletecategory':
+ include('./items/itemmain.php');
+ include('./items/deletecategory.php');
+ itemmain();
+ deletecategory();
+ break;
+ case 'createcategory':
+ include('./items/itemmain.php');
+ include('./items/editcategory.php');
+ itemmain();
+ createcategory();
+ break;
+ case 'finditem':
+ include('./items/itemmain.php');
+ include('./items/locateitem.php');
+ itemmain();
+ locateitem();
+ break;
+ case 'als':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/als.php');
+ almain();
+ alsector();
+ break;
+ case 'alsector':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/als.php');
+ almain();
+ alsector();
+ break;
+ case 'listals':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/als.php');
+ almain();
+ listals();
+ break;
+ case 'edital':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/als.php');
+ almain();
+ edital();
+ break;
+ case 'deleteal':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/als.php');
+ almain();
+ deleteal();
+ break;
+ case 'checkbooks':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/checkbooks.php');
+ almain();
+ checkbooks();
+ break;
+ case 'gameboards':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/gameboards.php');
+ almain();
+ gameboards();
+ break;
+ case 'editgameboard':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/gameboards.php');
+ almain();
+ editgameboard();
+ break;
+ case 'deletegameboard':
+ include('./actionlocations/almain.php');
+ include('./actionlocations/gameboards.php');
+ almain();
+ deletegameboard();
+ break;
+ case 'npcs':
+ include('./npcs/npcmain.php');
+ npcmain();
+ break;
+ case 'createnpc':
+ include('./npcs/npcmain.php');
+ include('./npcs/createnpc.php');
+ npcmain();
+ createnpc();
+ break;
+ case 'deletenpc':
+ include('./npcs/npcmain.php');
+ include('./npcs/deletenpc.php');
+ npcmain();
+ deletenpc();
+ break;
+ case 'listnpcs':
+ include('./npcs/npcmain.php');
+ include('./npcs/listnpcs.php');
+ npcmain();
+ listnpcs('true');
+ break;
+ case 'listvuln':
+ include('./npcs/npcmain.php');
+ include('./npcs/listnpcs.php');
+ npcmain();
+ listnpcs('false');
+ break;
+ case 'listnpctypes':
+ include('./npcs/npcmain.php');
+ include('./npcs/npctypes.php');
+ npcmain();
+ listnpctypes();
+ break;
+ case 'editnpctypes':
+ include('./npcs/npcmain.php');
+ include('./npcs/npctypes.php');
+ npcmain();
+ editnpctypes();
+ break;
+ case 'createnpctypes':
+ include('./npcs/npcmain.php');
+ include('./npcs/npctypes.php');
+ npcmain();
+ createnpctypes();
+ break;
+ case 'listnpcscombat':
+ include('./npcs/npcmain.php');
+ include('./npcs/listnpcscombat.php');
+ npcmain();
+ listnpcscombat();
+ break;
+ case 'listnpcsector':
+ include('./npcs/npcmain.php');
+ include('./npcs/listnpcsector.php');
+ npcmain();
+ listnpcsector();
+ break;
+ case 'listspawn':
+ include('./npcs/npcmain.php');
+ include('./npcs/listspawnrules.php');
+ npcmain();
+ listspawnrules();
+ break;
+ case 'editspawnrule':
+ include('./npcs/npcmain.php');
+ include('./npcs/listspawnrules.php');
+ npcmain();
+ editspawnrule();
+ break;
+ case 'listloot':
+ include('./npcs/npcmain.php');
+ include('./npcs/listlootrules.php');
+ npcmain();
+ listlootrules();
+ break;
+ case 'editlootruledetail':
+ include('./npcs/npcmain.php');
+ include('./npcs/listlootrules.php');
+ npcmain();
+ editlootruledetail();
+ break;
+ case 'createlootruledetail':
+ include('./npcs/npcmain.php');
+ include('./npcs/listlootrules.php');
+ npcmain();
+ createlootruledetail();
+ break;
+ case 'editlootrule':
+ include('./npcs/npcmain.php');
+ include('./npcs/listlootrules.php');
+ npcmain();
+ editlootrule();
+ break;
+ case 'listmerchant':
+ include('./npcs/npcmain.php');
+ include('./npcs/listmerchant.php');
+ npcmain();
+ listmerchant();
+ break;
+ case 'editmerchant':
+ include('./npcs/npcmain.php');
+ include('./npcs/listmerchant.php');
+ npcmain();
+ editmerchant();
+ break;
+ case 'listnpcfactions':
+ include('./npcs/npcmain.php');
+ include('./npcs/listnpcfactions.php');
+ npcmain();
+ listnpcfactions();
+ break;
+ case 'listtrainer':
+ include('./npcs/npcmain.php');
+ include('./npcs/listtrainer.php');
+ npcmain();
+ listtrainer();
+ break;
+ case 'edittrainer':
+ include('./npcs/npcmain.php');
+ include('./npcs/listtrainer.php');
+ npcmain();
+ edittrainer();
+ break;
+ case 'npc_details':
+ include('./npcs/npcmain.php');
+ include('./npcs/npc_details.php');
+ npcmain();
+ npcdetails();
+ break;
+ case 'searchnpc':
+ include('./npcs/npcmain.php');
+ include('./npcs/npc_search.php');
+ npcmain();
+ npc_search();
+ break;
+ case 'synonyms':
+ include('./npcs/npcmain.php');
+ include('./npcs/synonyms.php');
+ npcmain();
+ synonyms();
+ break;
+ case 'ka_trigg':
+ include('./npcs/npcmain.php');
+ include('./npcs/ka_trigger.php');
+ npcmain();
+ ka_trigger();
+ break;
+ case 'ka_detail':
+ include('./npcs/npcmain.php');
+ include('./npcs/ka_trigger.php');
+ npcmain();
+ ka_detail();
+ break;
+ case 'ka_scripts':
+ include('./npcs/npcmain.php');
+ include('./npcs/ka_scripts.php');
+ npcmain();
+ ka_scripts();
+ break;
+ case 'findtrigger':
+ include('./npcs/npcmain.php');
+ include('./npcs/findtrigger.php');
+ npcmain();
+ findtrigger();
+ break;
+ case 'checknpctriggers':
+ include('./npcs/npcmain.php');
+ include('./npcs/checknpctriggers.php');
+ npcmain();
+ checknpctriggers();
+ break;
+ case 'checknpcloaded':
+ include('./npcs/npcmain.php');
+ include('./npcs/checknpcloaded.php');
+ npcmain();
+ checknpcloaded();
+ break;
+ case 'checktrainers':
+ include('./npcs/npcmain.php');
+ include('./npcs/checktrainers.php');
+ npcmain();
+ checktrainers();
+ break;
+ case 'checkmerchants':
+ include('./npcs/npcmain.php');
+ include('./npcs/checkmerchants.php');
+ npcmain();
+ checkmerchants();
+ break;
+ case 'checknpcchar':
+ include('./npcs/npcmain.php');
+ include('./npcs/checknpcchar.php');
+ npcmain();
+ checknpcchar();
+ break;
+ case 'viewnpcmap':
+ include('./npcs/npcmain.php');
+ include('./npcs/viewnpcmap.php');
+ npcmain();
+ viewnpcmap();
+ break;
+ case 'checkdistribution':
+ include('./npcs/npcmain.php');
+ include('./npcs/viewnpcdistribution.php');
+ npcmain();
+ viewnpcdistribution();
+ break;
+ case 'tribes':
+ include('./tribes/tribemain.php');
+ tribemain();
+ break;
+ case 'listtribes':
+ include('./tribes/tribemain.php');
+ include('./tribes/listtribes.php');
+ tribemain();
+ listtribes();
+ break;
+ case 'edittribes':
+ include('./tribes/tribemain.php');
+ include('./tribes/listtribes.php');
+ tribemain();
+ edittribes();
+ break;
+ case 'tribe_details':
+ include('./tribes/tribemain.php');
+ include('./tribes/tribe_details.php');
+ tribemain();
+ tribedetails();
+ break;
+ case 'listrecipes':
+ include('./tribes/tribemain.php');
+ include('./tribes/listrecipes.php');
+ tribemain();
+ listrecipes();
+ break;
+ case 'editrecipes':
+ include('./tribes/tribemain.php');
+ include('./tribes/listrecipes.php');
+ tribemain();
+ editrecipes();
+ break;
+ case 'listtribemembers':
+ include('./tribes/tribemain.php');
+ include('./tribes/listtribemembers.php');
+ tribemain();
+ listtribemembers();
+ break;
+ case 'rules':
+ include('./rules/rulesmain.php');
+ rulesmain();
+ break;
+ case 'scripts':
+ include('./rules/rulesmain.php');
+ include('./rules/scripts.php');
+ rulesmain();
+ rule_scripts();
+ break;
+ case 'mscripts':
+ include('./rules/rulesmain.php');
+ include('./rules/mscripts.php');
+ rulesmain();
+ rule_mscripts();
+ break;
+ case 'spells':
+ include('./rules/rulesmain.php');
+ include('./rules/spells.php');
+ rulesmain();
+ spells();
+ break;
+ case 'spell':
+ include('./rules/rulesmain.php');
+ include('./rules/spells.php');
+ rulesmain();
+ spell();
+ break;
+ case 'listglyph':
+ include('./rules/rulesmain.php');
+ include('./rules/glyphs.php');
+ rulesmain();
+ glyphs_used();
+ break;
+ case 'createspell':
+ include('./rules/rulesmain.php');
+ include('./rules/spells.php');
+ rulesmain();
+ createspell();
+ break;
+ case 'waypoint':
+ include('./rules/rulesmain.php');
+ include('./rules/waypoints.php');
+ rulesmain();
+ listwaypoints();
+ break;
+ case 'waypointalias':
+ include('./rules/rulesmain.php');
+ include('./rules/waypointaliases.php');
+ rulesmain();
+ listwaypointaliases();
+ break;
+ case 'listwaypointlinks':
+ include('./rules/rulesmain.php');
+ include('./rules/waypointlinks.php');
+ rulesmain();
+ listwaypointlinks();
+ break;
+ case 'editwaypointlink':
+ include('./rules/rulesmain.php');
+ include('./rules/waypointlinks.php');
+ rulesmain();
+ editwaypointlink();
+ break;
+ case 'createwaypointlink':
+ include('./rules/rulesmain.php');
+ include('./rules/waypointlinks.php');
+ rulesmain();
+ createwaypointlink();
+ break;
+ case 'deletewaypointlink':
+ include('./rules/rulesmain.php');
+ include('./rules/waypointlinks.php');
+ rulesmain();
+ deletewaypointlink();
+ break;
+ case 'waypointmap':
+ include('./rules/rulesmain.php');
+ include('./rules/waypointmap.php');
+ rulesmain();
+ waypoint_map();
+ break;
+ case 'listpathpoints':
+ include('./rules/rulesmain.php');
+ include('./rules/pathpoints.php');
+ rulesmain();
+ listpathpoints();
+ break;
+ case 'rulesmap':
+ include('./rules/rulesmain.php');
+ include('./rules/map.php');
+ rulesmain();
+ rulesmap();
+ break;
+ case 'editpathpoint':
+ include('./rules/rulesmain.php');
+ include('./rules/pathpoints.php');
+ rulesmain();
+ editpathpoint();
+ break;
+ case 'createpathpoint':
+ include('./rules/rulesmain.php');
+ include('./rules/pathpoints.php');
+ rulesmain();
+ createpathpoint();
+ break;
+ case 'deletepathpoint':
+ include('./rules/rulesmain.php');
+ include('./rules/pathpoints.php');
+ rulesmain();
+ deletepathpoint();
+ break;
+ case 'location':
+ include('./rules/rulesmain.php');
+ include('./rules/locations.php');
+ rulesmain();
+ listlocations();
+ break;
+ case 'locationtype':
+ include('./rules/rulesmain.php');
+ include('./rules/locationtypes.php');
+ rulesmain();
+ listlocationtypes();
+ break;
+ case 'locationmap':
+ include('./rules/rulesmain.php');
+ include('./rules/locationmap.php');
+ rulesmain();
+ location_map();
+ break;
+ case 'skills':
+ include('./rules/rulesmain.php');
+ include('./rules/skills.php');
+ rulesmain();
+ listskills();
+ break;
+ case 'factions':
+ include('./rules/rulesmain.php');
+ include('./rules/factions.php');
+ rulesmain();
+ listfactions();
+ break;
+ case 'raceinfo':
+ include('./rules/rulesmain.php');
+ include('./rules/raceinfo.php');
+ rulesmain();
+ raceinfo();
+ break;
+ case 'listattacks':
+ include('./rules/rulesmain.php');
+ include('./rules/attacks.php');
+ rulesmain();
+ listattacks();
+ break;
+ case 'editattacks':
+ include('./rules/rulesmain.php');
+ include('./rules/attacks.php');
+ rulesmain();
+ editattacks();
+ break;
+ case 'listattacktypes':
+ include('./rules/rulesmain.php');
+ include('./rules/attacktypes.php');
+ rulesmain();
+ listattacktypes();
+ break;
+ case 'editattacktypes':
+ include('./rules/rulesmain.php');
+ include('./rules/attacktypes.php');
+ rulesmain();
+ editattacktypes();
+ break;
+ case 'listweapontypes':
+ include('./rules/rulesmain.php');
+ include('./rules/weapontypes.php');
+ rulesmain();
+ listweapontypes();
+ break;
+ case 'editweapontypes':
+ include('./rules/rulesmain.php');
+ include('./rules/weapontypes.php');
+ rulesmain();
+ editweapontypes();
+ break;
+ case 'liststances':
+ include('./rules/rulesmain.php');
+ include('./rules/stances.php');
+ rulesmain();
+ liststances();
+ break;
+ case 'editstances':
+ include('./rules/rulesmain.php');
+ include('./rules/stances.php');
+ rulesmain();
+ editstances();
+ break;
+ case 'listarmorvsweapon':
+ include('./rules/rulesmain.php');
+ include('./rules/armorvsweapon.php');
+ rulesmain();
+ listarmorvsweapon();
+ break;
+ case 'editarmorvsweapon':
+ include('./rules/rulesmain.php');
+ include('./rules/armorvsweapon.php');
+ rulesmain();
+ editarmorvsweapon();
+ break;
+ case 'listlootmodifiers':
+ include('./rules/rulesmain.php');
+ include('./rules/lootmodifiers.php');
+ rulesmain();
+ listLootModifiers();
+ break;
+ case 'lootmodifierrestraints':
+ include('./rules/rulesmain.php');
+ include('./rules/lootmodifierrestraints.php');
+ rulesmain();
+ lootmodifierrestraints();
+ break;
+ case 'editlootmodifiers':
+ include('./rules/rulesmain.php');
+ include('./rules/lootmodifiers.php');
+ rulesmain();
+ editLootModifiers();
+ break;
+ case 'listrandomizeditems':
+ include('./rules/rulesmain.php');
+ include('./rules/lootmodifiers.php');
+ rulesmain();
+ listRandomizedItems();
+ break;
+ case 'xmlscriptvalidator':
+ include('./rules/rulesmain.php');
+ include('./rules/XMLScriptValidator.php');
+ rulesmain();
+ XMLScriptValidator();
+ break;
+ case 'crafting':
+ include('./crafting/craftingmain.php');
+ craftingmain();
+ break;
+ case 'listcraftitems':
+ include('./crafting/craftingmain.php');
+ include('./crafting/listcraftitems.php');
+ craftingmain();
+ listcraftitems();
+ break;
+ case 'checkminditemusage':
+ include('./crafting/craftingmain.php');
+ include('./crafting/checkminditemusage.php');
+ craftingmain();
+ checkMindItemUsage();
+ break;
+ case 'listpatterns':
+ include('./crafting/craftingmain.php');
+ include('./crafting/patterns.php');
+ craftingmain();
+ listpatterns();
+ break;
+ case 'editpattern':
+ include('./crafting/craftingmain.php');
+ include('./crafting/patterns.php');
+ craftingmain();
+ editpattern();
+ break;
+ case 'createpattern':
+ include('./crafting/craftingmain.php');
+ include('./crafting/patterns.php');
+ craftingmain();
+ createpattern();
+ break;
+ case 'deletepattern':
+ include('./crafting/craftingmain.php');
+ include('./crafting/patterns.php');
+ craftingmain();
+ deletepattern();
+ break;
+ case 'editcombine':
+ include('./crafting/craftingmain.php');
+ include('./crafting/combines.php');
+ craftingmain();
+ editcombine();
+ break;
+ case 'createcombine':
+ include('./crafting/craftingmain.php');
+ include('./crafting/combines.php');
+ craftingmain();
+ createcombine();
+ break;
+ case 'deletecombine':
+ include('./crafting/craftingmain.php');
+ include('./crafting/combines.php');
+ craftingmain();
+ deletecombine();
+ break;
+ case 'transform':
+ include('./crafting/craftingmain.php');
+ include('./crafting/transforms.php');
+ craftingmain();
+ edittransform();
+ break;
+ case 'createtransform':
+ include('./crafting/craftingmain.php');
+ include('./crafting/transforms.php');
+ craftingmain();
+ createtransform();
+ break;
+ case 'deletetransform':
+ include('./crafting/craftingmain.php');
+ include('./crafting/transforms.php');
+ craftingmain();
+ deletetransform();
+ break;
+ case 'listprocess':
+ include('./crafting/craftingmain.php');
+ include('./crafting/process.php');
+ craftingmain();
+ listprocess();
+ break;
+ case 'process':
+ include('./crafting/craftingmain.php');
+ include('./crafting/process.php');
+ craftingmain();
+ editprocess();
+ break;
+ case 'editsubprocess':
+ include('./crafting/craftingmain.php');
+ include('./crafting/process.php');
+ craftingmain();
+ editsubprocess();
+ break;
+ case 'createprocess':
+ include('./crafting/craftingmain.php');
+ include('./crafting/process.php');
+ craftingmain();
+ createprocess();
+ break;
+ case 'deleteprocess':
+ include('./crafting/craftingmain.php');
+ include('./crafting/process.php');
+ craftingmain();
+ deleteprocess();
+ break;
+ case 'resource':
+ include('./crafting/craftingmain.php');
+ include('./crafting/resources.php');
+ craftingmain();
+ listresources();
+ break;
+ case 'resourcemap':
+ include('./crafting/craftingmain.php');
+ include('./crafting/resourcemap.php');
+ craftingmain();
+ natural_resources_map();
+ break;
+ case 'resourceitem':
+ include('./crafting/craftingmain.php');
+ include('./crafting/resources.php');
+ craftingmain();
+ listresourceitems();
+ break;
+ case 'huntlocations':
+ include('./crafting/craftingmain.php');
+ include('./crafting/huntlocations.php');
+ craftingmain();
+ huntlocations();
+ break;
+ case 'other':
+ include('./other/othermain.php');
+ othermain();
+ break;
+ case 'statistics':
+ include('./statistics/statsmain.php');
+ statsmain();
+ break;
+ case 'statshardware':
+ include('./statistics/statsmain.php');
+ include('./statistics/statshardware.php');
+ statsmain();
+ statshardware();
+ break;
+ case 'liststats':
+ include('./statistics/statsmain.php');
+ include('./statistics/liststats.php');
+ statsmain();
+ liststats();
+ break;
+ case 'liststats_retention':
+ include('./statistics/statsmain.php');
+ include('./statistics/liststats_retention.php');
+ statsmain();
+ liststats_retention();
+ break;
+ case 'liststats_charstats':
+ include('./statistics/statsmain.php');
+ include('./statistics/liststats_charstats.php');
+ statsmain();
+ liststats_charstats();
+ break;
+ case 'liststats_achievements':
+ include('./statistics/statsmain.php');
+ include('./statistics/liststats_achievements.php');
+ statsmain();
+ liststats_achievements();
+ break;
+ case 'assets':
+ include('./assets/assetsmain.php');
+ assetsmain();
+ break;
+ case 'assetsnpc':
+ include('./assets/assetsmain.php');
+ include('./assets/assetsnpc.php');
+ assetsmain();
+ assetsnpc();
+ break;
+ case 'assetsitem':
+ include('./assets/assetsmain.php');
+ include('./assets/assetsitem.php');
+ assetsmain();
+ assetsitem();
+ break;
+ case 'characteraffinity':
+ include('./other/othermain.php');
+ include('./other/character_affinity.php');
+ othermain();
+ characteraffinity();
+ break;
+ case 'charactercreationevents':
+ include('./other/othermain.php');
+ include('./other/character_creation_events.php');
+ othermain();
+ charactercreationevents();
+ break;
+ case 'characterlifeevents':
+ include('./other/othermain.php');
+ include('./other/character_life_events.php');
+ othermain();
+ characterlifeevents();
+ break;
+ case 'lifeeventrelations':
+ include('./other/othermain.php');
+ include('./other/character_life_event_relations.php');
+ othermain();
+ lifeeventrelations();
+ break;
+ case 'servernews':
+ include('./other/othermain.php');
+ include('./other/servernews.php');
+ othermain();
+ serverNews();
+ break;
+ case 'listguilds':
+ include('./other/othermain.php');
+ include('./other/guilds.php');
+ othermain();
+ listguilds();
+ break;
+ case 'editguildmember':
+ include('./other/othermain.php');
+ include('./other/guilds.php');
+ othermain();
+ editguildmember();
+ break;
+ case 'deleteguildmember':
+ include('./other/othermain.php');
+ include('./other/guilds.php');
+ othermain();
+ deleteguildmember();
+ break;
+ case 'listpetitions':
+ include('./other/othermain.php');
+ include('./other/listpetitions.php');
+ othermain();
+ listpetitions();
+ break;
+ /* commented pending a decision on what to do with this since there is no more such table, but the information is still out there.
+ case 'listcommonstrings':
+ include('./other/othermain.php');
+ include('./other/commonstrings.php');
+ othermain();
+ listcommonstrings();
+ break;
+ case 'addcommonstrings':
+ include('./other/othermain.php');
+ include('./other/commonstrings.php');
+ othermain();
+ addcommonstrings();
+ break;
+ case 'editcommonstrings':
+ include('./other/othermain.php');
+ include('./other/commonstrings.php');
+ othermain();
+ editcommonstrings();
+ break;
+ case 'deletecommonstrings':
+ include('./other/othermain.php');
+ include('./other/commonstrings.php');
+ othermain();
+ deletecommonstrings();
+ break;
+ */
+ case 'listaccounts':
+ include('./other/othermain.php');
+ include('./other/accounts.php');
+ othermain();
+ listaccounts();
+ break;
+ case 'viewaccount':
+ include('./other/othermain.php');
+ include('./other/accounts.php');
+ othermain();
+ viewaccount();
+ break;
+ case 'listcharacters':
+ include('./other/othermain.php');
+ include('./other/characters.php');
+ othermain();
+ listcharacters();
+ break;
+ case 'viewcharacter':
+ include('./other/othermain.php');
+ include('./other/characters.php');
+ othermain();
+ viewcharacter();
+ break;
+ case 'listtraits':
+ include('./other/othermain.php');
+ include('./other/traits.php');
+ othermain();
+ list_traits();
+ break;
+ case 'showraces':
+ include('./other/othermain.php');
+ include('./other/traits.php');
+ othermain();
+ show_races();
+ break;
+ case 'trait_actions':
+ include('./other/othermain.php');
+ include('./other/traits.php');
+ othermain();
+ trait_actions();
+ break;
+ case 'handletrait':
+ include('./other/othermain.php');
+ include('./other/traits.php');
+ othermain();
+ handle_trait();
+ break;
+ case 'admin':
+ include('./admin/adminmain.php');
+ adminmain();
+ break;
+ case 'listtips':
+ include('./admin/adminmain.php');
+ include('./admin/tips.php');
+ adminmain();
+ listtips();
+ break;
+ case 'edittips':
+ include('./admin/adminmain.php');
+ include('./admin/tips.php');
+ adminmain();
+ edittips();
+ break;
+ case 'viewcommands':
+ include('./admin/adminmain.php');
+ include('./admin/viewcommands.php');
+ adminmain();
+ viewcommands();
+ break;
+ case 'deletecommand':
+ include('./admin/adminmain.php');
+ include('./admin/viewcommands.php');
+ adminmain();
+ deletecommand();
+ break;
+ case 'createcommand':
+ include('./admin/adminmain.php');
+ include('./admin/viewcommands.php');
+ adminmain();
+ createcommand();
+ break;
+ case 'viewserveroptions':
+ include('./admin/adminmain.php');
+ include('./admin/viewserveroptions.php');
+ adminmain();
+ viewserveroptions();
+ break;
+ case 'listgms':
+ include('./admin/adminmain.php');
+ include('./admin/gms.php');
+ adminmain();
+ listgms();
+ break;
+ case 'viewgmlog':
+ include('./admin/adminmain.php');
+ include('./admin/gms.php');
+ adminmain();
+ viewgmlog();
+ break;
+ case 'addgm':
+ include('./admin/adminmain.php');
+ include('./admin/gms.php');
+ adminmain();
+ addgm();
+ break;
+ case 'editgm':
+ include('./admin/adminmain.php');
+ include('./admin/gms.php');
+ adminmain();
+ editgm();
+ break;
+ case 'events':
+ include('./other/othermain.php');
+ include('./other/events.php');
+ othermain();
+ listevents();
+ break;
+ case 'viewevent':
+ include('./other/othermain.php');
+ include('./other/events.php');
+ othermain();
+ viewevent();
+ break;
+ case 'cleanupchars':
+ include('./admin/adminmain.php');
+ include('./admin/unusedchars.php');
+ adminmain();
+ unusedchars();
+ break;
+ default:
+ echo '<p class="error">shouldn\'t reach this!</p>';
+}
+?>
\ No newline at end of file
Property changes on: www/webconsole-new/menu_actions.php
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: www/webconsole-new/menu_top.php
===================================================================
--- www/webconsole-new/menu_top.php (rev 0)
+++ www/webconsole-new/menu_top.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -0,0 +1,39 @@
+<?php
+ echo '<div class="menu">'."\n";
+ if (checkaccess('npcs', 'read')){
+ echo '<a href="./index.php?do=npcs">NPCs</a> -- '."\n";
+ echo '<a href="./index.php?do=tribes">Tribes</a> -- '."\n";
+ } else echo 'NPCs -- '."\n";
+ if (checkaccess('quests', 'read')){
+ echo '<a href="./index.php?do=listquests">Quests</a> -- '."\n";
+ } else echo 'Quests -- '."\n";
+ if (checkaccess('items', 'read')){
+ echo '<a href="./index.php?do=items">Items</a> -- '."\n";
+ } else echo 'Items -- '."\n";
+ if (checkaccess('als', 'read')){
+ echo '<a href="./index.php?do=als">Action Locations</a> -- '."\n";
+ } else echo 'Action Locations -- '."\n";
+ if (checkaccess('natres','read')){
+ echo '<a href="./index.php?do=rules">Rules</a> -- '."\n";
+ } else echo 'Rules -- '."\n";
+ if (checkaccess('crafting', 'read')){
+ echo '<a href="./index.php?do=crafting">Crafting</a> -- '."\n";
+ } else echo 'Crafting -- '."\n";
+ if (checkaccess('city', 'read')){
+ echo '<a href="./index.php?do=city">City</a> -- '."\n";
+ } else echo 'City -- '."\n";
+ if (checkaccess('other', 'read')){
+ echo '<a href="./index.php?do=other">Other</a> -- '."\n";
+ } else echo 'Other -- '."\n";
+ if (checkaccess('statistics', 'read')){
+ echo '<a href="./index.php?do=statistics">Statistics</a> -- '."\n";
+ } else echo 'Statistics -- '."\n";
+ if (checkaccess('assets', 'read')){
+ echo '<a href="./index.php?do=assets">Assets</a> -- '."\n";
+ } else echo 'Assets -- '."\n";
+ if (checkaccess('admin', 'read')){
+ echo '<a href="./index.php?do=admin">Admin</a> -- '."\n";
+ } else echo 'Admin -- '."\n";
+ echo '<a href="./index.php?logout">Logout</a> ('.gethostname().')'."\n";
+ echo '</div><hr/>'."\n";
+?>
\ No newline at end of file
Property changes on: www/webconsole-new/menu_top.php
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Modified: www/webconsole-new/npcs/npc_details.php
===================================================================
--- www/webconsole-new/npcs/npc_details.php 2025-06-30 17:10:55 UTC (rev 10026)
+++ www/webconsole-new/npcs/npc_details.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -718,7 +718,7 @@
$query = "UPDATE item_instances SET min_faction='$min_faction' WHERE id='$inst_id'";
}else if ($_POST['commit'] == 'Visual Equip')
{
- $slot_id = escapeSqlString($_POST['slot']);
+ $slot_id = escapeSqlString($_POST['formerslot']);
$visualslot = escapeSqlString($_POST['visualslot']);
// check if we have one already
$queryVisual0 = "SELECT * FROM character_visualequip WHERE character_id='$id' and slot_id='$slot_id'";
@@ -971,11 +971,11 @@
echo '</select>'."<br/>";
// Visual Equip
echo '<input type="submit" name="commit" value="Visual Equip" />'."\n";
- echo '<input type="hidden" name="slot" value="'.$row['location_in_parent'].'"/>'."\n";
+ echo '<input type="hidden" name="formerslot" value="'.$row['location_in_parent'].'"/>'."\n";
echo '<select name="visualslot">';
// is this item visually equipped?
$currentVisualSlot = 0;
- while ($rowVisual = fetchSqlAssoc($resultVisual)){
+ foreach ($resultVisual as $rowVisual){
if ($rowVisual['slot_id'] == $row['location_in_parent'])
{
$currentVisualSlot = $rowVisual['visualslot_id'];
Modified: www/webconsole-new/npcs/npcmain.php
===================================================================
--- www/webconsole-new/npcs/npcmain.php 2025-06-30 17:10:55 UTC (rev 10026)
+++ www/webconsole-new/npcs/npcmain.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -35,6 +35,7 @@
echo '<a href="./index.php?do=checknpcloaded">Check NPC Loaded</a> <br/>'."\n";
echo '<a href="./index.php?do=checktrainers">Check NPC Trainers</a> <br/>'."\n";
echo '<a href="./index.php?do=checkmerchants">Check NPC Merchants</a> <br/>'."\n";
+ echo '<a href="./index.php?do=checkdistribution">Check NPC Distribution</a> <br/>'."\n";
echo '<hr/><a href="./index.php">Return to main page.</a>'."\n";
echo '</div><div class="main">'."\n";
}
Added: www/webconsole-new/npcs/viewnpcdistribution.php
===================================================================
--- www/webconsole-new/npcs/viewnpcdistribution.php (rev 0)
+++ www/webconsole-new/npcs/viewnpcdistribution.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -0,0 +1,51 @@
+<?php
+function viewnpcdistribution()
+{
+
+ $report = 'rules/report.xml'; // where this script expects the report.xml file to be.
+
+ if (!checkAccess('npcs', 'read')) {
+ echo 'You do not have permission to use this page.';
+ return;
+ }
+
+ // Get sector from session
+ $sector = (isset($_SESSION['sector']) ? $_SESSION['sector'] : '');
+ // If sector changed in a post update the sector
+ $sector = (isset($_GET['sector']) ? $_GET['sector'] : $sector);
+ $_SESSION['sector'] = $sector;
+
+ if ($sector != null && $sector != '') {
+
+ echo "<h1>NPC Distribution in $sector</h1>";
+
+ echo "<div id=Layer2 style=\"position:relative; \">";
+
+ $data = getDataFromArea($sector);
+ $sectors = $data[0];
+
+
+ $query = "SELECT r.name,sex, count(r.id) cc FROM characters c, race_info r WHERE c.racegender_id=r.id and npc_master_id>0 AND " . $sectors . " and npc_spawn_rule>0 group by r.id order by cc desc";
+ $res = mysql_query2($query);
+
+ echo "<br/><table>";
+
+ $i = 0;
+ $result = '';
+ while ($line = fetchSqlRow($res)) {
+ echo "<tr><td>" . $line[0] . "</td><td>" . $line[1] . "</td><td>" . $line[2] . "</td></tr>";
+ }
+ echo "</table>";
+
+
+ $sectors_list = PrepSelect('sector');
+ echo ' <FORM action="index.php" METHOD="GET"><input type="hidden" name="do" value="checkdistribution">';
+ echo ' <b>Select one area:</b> <br><br> Area: ';
+ SelectAreas($sector, 'sector');
+ echo ' <br><input type="checkbox" name="live" value="yes">LIVE view <br><br><INPUT type="submit" value="view"><br><br>';
+ echo '</FORM>';
+ echo '</div>';
+
+ }
+}
+?>
\ No newline at end of file
Property changes on: www/webconsole-new/npcs/viewnpcdistribution.php
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Modified: www/webconsole-new/quests/validatequest.php
===================================================================
--- www/webconsole-new/quests/validatequest.php 2025-06-30 17:10:55 UTC (rev 10026)
+++ www/webconsole-new/quests/validatequest.php 2025-07-05 10:48:46 UTC (rev 10027)
@@ -532,7 +532,7 @@
{
if ($type == 'npc' || $type == 'menu') // currently there are no other types, there could be in the future though, so this can be easily extended.
{
- if ($word != '$playerrace' && $word != '$sir' && $word != '$playername' && $word != '$his' && $word != '$time' && $word != '$npc')
+ if ($word != '$playerrace' && $word != '$sir' && $word != '$playername' && $word != '$his' && $word != '$time' && $word != '$npc' && $word != '$preferredFaction')
{
append_log("Parse Error: misplaced variable ($word) on line $line_number");
}
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
