From: <lpa...@us...> - 2013-03-27 21:39:14
|
Revision: 8644 http://planeshift.svn.sourceforge.net/planeshift/?rev=8644&view=rev Author: lpancallo Date: 2013-03-27 21:39:07 +0000 (Wed, 27 Mar 2013) Log Message: ----------- added display of additional fields on natural resources Modified Paths: -------------- www/webconsole-new/crafting/resources.php Modified: www/webconsole-new/crafting/resources.php =================================================================== --- www/webconsole-new/crafting/resources.php 2013-03-27 21:28:15 UTC (rev 8643) +++ www/webconsole-new/crafting/resources.php 2013-03-27 21:39:07 UTC (rev 8644) @@ -122,7 +122,7 @@ echo '<p class="error">Unknown Action - Returning to List</p>'; } }else{ - $query = "SELECT r.id, r.loc_sector_id, s.name AS sector, r.loc_x, r.loc_y, r.loc_z, r.radius, r.visible_radius, r.probability, r.skill, sk.name AS skill_name, r.skill_level, r.item_cat_id, c.name AS category, r.item_quality, r.animation, r.anim_duration_seconds, r.item_id_reward, i.name AS item, r.reward_nickname, r.action FROM natural_resources AS r LEFT JOIN sectors AS s ON r.loc_sector_id=s.id LEFT JOIN item_stats AS i on i.id=r.item_id_reward LEFT JOIN item_categories AS c ON r.item_cat_id=c.category_id LEFT JOIN skills AS sk on sk.skill_id=r.skill"; + $query = "SELECT r.id, r.loc_sector_id, s.name AS sector, r.loc_x, r.loc_y, r.loc_z, r.radius, r.visible_radius, r.probability, r.skill, sk.name AS skill_name, r.skill_level, r.item_cat_id, c.name AS category, r.item_quality, r.animation, r.anim_duration_seconds, r.item_id_reward, i.name AS item, r.reward_nickname, r.action, r.amount, r.interval, r.max_random FROM natural_resources AS r LEFT JOIN sectors AS s ON r.loc_sector_id=s.id LEFT JOIN item_stats AS i on i.id=r.item_id_reward LEFT JOIN item_categories AS c ON r.item_cat_id=c.category_id LEFT JOIN skills AS sk on sk.skill_id=r.skill"; if (isset($_GET['id'])) { $id = mysql_real_escape_string($_GET['id']); @@ -142,7 +142,7 @@ } } $result = mysql_query2($query); - echo '<table border="1"><tr><th><a href="./index.php?do=resource&sort=loc">Location</a></th><th>Radius</th><th>Visible Radius</th><th>Probability</th><th><a href="./index.php?do=resource&sort=skill">Skill</a></th><th>Skill Level</th><th><a href="./index.php?do=resource&sort=tool">Tool Category</a></th><th>Item Quality</th><th>Animation</th><th>Animation Duration</th><th><a href="./index.php?do=resource&sort=item">Item</a></th><th>Resource "Nickname"</th>'; + echo '<table border="1"><tr><th><a href="./index.php?do=resource&sort=loc">Location</a></th><th>Radius</th><th>Visible Radius</th><th>Probability</th><th><a href="./index.php?do=resource&sort=skill">Skill</a></th><th>Skill Level</th><th><a href="./index.php?do=resource&sort=tool">Tool Category</a></th><th>Item Quality</th><th>Animation</th><th>Animation Duration</th><th><a href="./index.php?do=resource&sort=item">Item</a></th><th>Resource "Nickname"</th><th>Amount (1)</th><th>Interval (2)</th><th>Max Random (3)</th>'; if (checkaccess('natres', 'edit')){ echo '<th>Actions</th>'; } @@ -161,6 +161,9 @@ echo '<td>'.$row['anim_duration_seconds'].'</td>'; echo '<td>'.$row['item'].'</td>'; echo '<td>'.$row['reward_nickname'].'</td>'; + echo '<td>'.$row['amount'].'</td>'; + echo '<td>'.$row['interval'].'</td>'; + echo '<td>'.$row['max_random'].'</td>'; if (checkaccess('natres', 'edit')){ echo '<td><form action="./index.php?do=resource" method="post">'; echo '<input type="hidden" name="id" value="'.$row['id'].'" />'; @@ -172,7 +175,7 @@ } echo '</tr>'; } - echo '</table>'; + echo '</table>(1) if not null, indicates how many items will be spawned (same as hunt_location)<br/>(2) if amount not null, msec interval for spawning item when picked up<br/>(3) if amount not null, maximum random interval modifier in msecs'; if (checkaccess('natres', 'create')){ echo '<form action="./index.php?do=resource" method="post">'; echo '<input type="submit" name="action" value="Create New" /></form>'; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2014-02-07 23:49:58
|
Revision: 9252 http://sourceforge.net/p/planeshift/code/9252 Author: lpancallo Date: 2014-02-07 23:49:56 +0000 (Fri, 07 Feb 2014) Log Message: ----------- Updated edit natural resources page to have also new hunt location fields. Modified Paths: -------------- www/webconsole-new/crafting/resources.php Modified: www/webconsole-new/crafting/resources.php =================================================================== --- www/webconsole-new/crafting/resources.php 2014-02-07 00:28:47 UTC (rev 9251) +++ www/webconsole-new/crafting/resources.php 2014-02-07 23:49:56 UTC (rev 9252) @@ -20,7 +20,10 @@ $anim_duration_seconds = mysql_real_escape_string($_POST['anim_duration_seconds']); $action = mysql_real_escape_string($_POST['action']); $reward_nickname = mysql_real_escape_string($_POST['reward_nickname']); - $query = "UPDATE natural_resources SET loc_sector_id='$loc_sector_id', loc_x='$loc_x', loc_y='$loc_y', loc_z='$loc_z', radius='$radius', visible_radius='$visible_radius', probability='$probability', skill='$skill', skill_level='$skill_level', item_cat_id='$item_cat_id', item_quality='$item_quality', item_id_reward='$item_id_reward', animation='$animation', anim_duration_seconds='$anim_duration_seconds', action='$action', reward_nickname='$reward_nickname' WHERE id='$id'"; + $amount = mysql_real_escape_string($_POST['amount']); + $interval = mysql_real_escape_string($_POST['interval']); + $max_random = mysql_real_escape_string($_POST['max_random']); + $query = "UPDATE natural_resources SET loc_sector_id='$loc_sector_id', loc_x='$loc_x', loc_y='$loc_y', loc_z='$loc_z', radius='$radius', visible_radius='$visible_radius', probability='$probability', skill='$skill', skill_level='$skill_level', item_cat_id='$item_cat_id', item_quality='$item_quality', item_id_reward='$item_id_reward', animation='$animation', anim_duration_seconds='$anim_duration_seconds', action='$action', reward_nickname='$reward_nickname', amount='$amount', `interval`=$interval, max_random=$max_random WHERE id='$id'"; $result = mysql_query2($query); echo '<p class="error">Update Successful</p>'; unset($_POST); @@ -61,7 +64,7 @@ }else if (isset($_POST['action']) && (checkaccess('natres', 'edit'))){ if ($_POST['action'] == 'Edit'){ $id = mysql_real_escape_string($_POST['id']); - $query = "SELECT id, loc_sector_id, loc_x, loc_y, loc_z, radius, visible_radius, probability, skill, skill_level, item_cat_id, item_quality, animation, anim_duration_seconds, item_id_reward, reward_nickname, action FROM natural_resources WHERE id='$id'"; + $query = "SELECT id, loc_sector_id, loc_x, loc_y, loc_z, radius, visible_radius, probability, skill, skill_level, item_cat_id, item_quality, animation, anim_duration_seconds, item_id_reward, reward_nickname, action, amount, `interval`, max_random FROM natural_resources WHERE id='$id'"; $result = mysql_query2($query); $Sectors = PrepSelect('sectorid'); $Category = PrepSelect('category'); @@ -84,6 +87,9 @@ echo '<td>Animation Duration:</td><td><input type="text" name="anim_duration_seconds" value="'.$row['anim_duration_seconds'].'" size="5"/></td></tr>'; echo '<tr><td>Action:</td><td><input type="text" name="action" value="'.$row['action'].'" /></td>'; echo '<td>Reward Nickname:<br/>(Used by players after /dig)</td><td><input type="text" name="reward_nickname" value="'.$row['reward_nickname'].'"/></td></tr>'; + echo '<tr><td>Amount:<br/>(if not null it spawns items)</td><td><input type="text" name="amount" value="'.$row['amount'].'"/></td></tr>'; + echo '<tr><td>Interval:<br/>(if amount not null, <br/>msec interval for spawning item when picked up</td><td><input type="text" name="interval" value="'.$row['interval'].'"/></td></tr>'; + echo '<tr><td>Max Random:<br/>(if amount not null, <br/>maximum random interval modifier in msecs</td><td><input type="text" name="max_random" value="'.$row['max_random'].'"/></td></tr>'; echo '</table><input type="hidden" name="id" value="'.$row['id'].'"><input type="submit" name="commit" value="Commit Edit" />'; echo '</form>'; }else if ($_POST['action'] == 'Create New' && checkaccess('natres', 'create')){ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rav...@us...> - 2014-05-02 22:23:40
|
Revision: 9492 http://sourceforge.net/p/planeshift/code/9492 Author: ravna-ps Date: 2014-05-02 22:23:37 +0000 (Fri, 02 May 2014) Log Message: ----------- Changed "reward item" to be a 2 tier item select instead of single. Fixed a few html bugs. Modified Paths: -------------- www/webconsole-new/crafting/resources.php Modified: www/webconsole-new/crafting/resources.php =================================================================== --- www/webconsole-new/crafting/resources.php 2014-05-02 21:54:53 UTC (rev 9491) +++ www/webconsole-new/crafting/resources.php 2014-05-02 22:23:37 UTC (rev 9492) @@ -70,52 +70,50 @@ $result = mysql_query2($query); $Sectors = PrepSelect('sectorid'); $Category = PrepSelect('category'); - $Items = PrepSelect('items_resource'); $Skills = PrepSelect('skill'); $row = mysql_fetch_array($result, MYSQL_ASSOC); echo '<form action="./index.php?do=resource" method="post">'; echo '<table border="1">'; echo '<tr><td>Sector:</td><td>'.DrawSelectBox('sectorid', $Sectors, 'loc_sector_id', $row['loc_sector_id']).'</td>'; - echo '<td>Coordinates (X/Y/Z):</td><td><input type="text" name="loc_x" value="'.$row['loc_x'].'" size="5"/>/<input type="text" name="loc_y" value="'.$row['loc_y'].'" size="5"/>/<input type="text" name="loc_z" value="'.$row['loc_z'].'" size="5"/></td></tr>'; + echo '<td>Coordinates (X/Y/Z):</td><td><input type="text" name="loc_x" value="'.$row['loc_x'].'" size="5" />/<input type="text" name="loc_y" value="'.$row['loc_y'].'" size="5" />/<input type="text" name="loc_z" value="'.$row['loc_z'].'" size="5" /></td></tr>'; echo '<tr><td>Radius:</td><td><input type="text" name="radius" value="'.$row['radius'].'" size="10" /></td>'; echo '<td>Visible Radius:</td><td><input type="text" name="visible_radius" value="'.$row['visible_radius'].'" size="10" /></td></tr>'; - echo '<tr><td>Probability:</td><td><input type="text" name="probability" value="'.$row['probability'].'" size="10"/></td>'; + echo '<tr><td>Probability:</td><td><input type="text" name="probability" value="'.$row['probability'].'" size="10" /></td>'; echo '<td>Tool Category</td><td>'.DrawSelectBox('category', $Category, 'item_cat_id', $row['item_cat_id']).'</td></tr>'; echo '<tr><td>Skill:</td><td>'.DrawSelectBox('skill', $Skills, 'skill', $row['skill']).'</td>'; - echo '<td>Skill Level:</td><td><input type="text" name="skill_level" value="'.$row['skill_level'].'" size="10"/></td></tr>'; - echo '<tr><td>Reward Item:</td><td>'.DrawSelectBox('items', $Items, 'item_id_reward', $row['item_id_reward']).'</td>'; - echo '<td>Item Quality:</td><td><input type="text" name="item_quality" value="'.$row['item_quality'].'" size="10"/></td></tr>'; + echo '<td>Skill Level:</td><td><input type="text" name="skill_level" value="'.$row['skill_level'].'" size="10" /></td></tr>'; + echo '<tr><td>Reward Item:</td><td>'.DrawItemSelectBox('item_id_reward', $row['item_id_reward'], true, true).'</td>'; + echo '<td>Item Quality:</td><td><input type="text" name="item_quality" value="'.$row['item_quality'].'" size="10" /></td></tr>'; echo '<tr><td>Animation:</td><td><input type="text" name="animation" value="'.$row['animation'].'" /></td>'; - echo '<td>Animation Duration:</td><td><input type="text" name="anim_duration_seconds" value="'.$row['anim_duration_seconds'].'" size="5"/></td></tr>'; + echo '<td>Animation Duration:</td><td><input type="text" name="anim_duration_seconds" value="'.$row['anim_duration_seconds'].'" size="5" /></td></tr>'; echo '<tr><td>Action:</td><td><input type="text" name="action" value="'.$row['action'].'" /></td>'; - echo '<td>Reward Nickname:<br/>(Used by players after /dig)</td><td><input type="text" name="reward_nickname" value="'.$row['reward_nickname'].'"/></td></tr>'; - echo '<tr><td>Amount:<br/>(if not null it spawns items)</td><td><input type="text" name="amount" value="'.$row['amount'].'"/></td></tr>'; - echo '<tr><td>Interval:<br/>(if amount not null, <br/>msec interval for spawning item when picked up</td><td><input type="text" name="interval" value="'.$row['interval'].'"/></td></tr>'; - echo '<tr><td>Max Random:<br/>(if amount not null, <br/>maximum random interval modifier in msecs</td><td><input type="text" name="max_random" value="'.$row['max_random'].'"/></td></tr>'; - echo '</table><input type="hidden" name="id" value="'.$row['id'].'"><input type="submit" name="commit" value="Commit Edit" />'; + echo '<td>Reward Nickname:<br/>(Used by players after /dig)</td><td><input type="text" name="reward_nickname" value="'.$row['reward_nickname'].'" /></td></tr>'; + echo '<tr><td>Amount:<br/>(if not null it spawns items)</td><td><input type="text" name="amount" value="'.$row['amount'].'" /></td></tr>'; + echo '<tr><td>Interval:<br/>(if amount not null, <br/>msec interval for spawning item when picked up</td><td><input type="text" name="interval" value="'.$row['interval'].'" /></td></tr>'; + echo '<tr><td>Max Random:<br/>(if amount not null, <br/>maximum random interval modifier in msecs</td><td><input type="text" name="max_random" value="'.$row['max_random'].'" /></td></tr>'; + echo '</table><div><input type="hidden" name="id" value="'.$row['id'].'" /><input type="submit" name="commit" value="Commit Edit" /></div>'; echo '</form>'; }else if ($_POST['action'] == 'Create New' && checkaccess('natres', 'create')){ $Sectors = PrepSelect('sectorid'); $Category = PrepSelect('category'); - $Items = PrepSelect('items_resource'); $Skills = PrepSelect('skill'); echo '<form action="./index.php?do=resource" method="post">'; echo '<table border="1">'; echo '<tr><td>Sector:</td><td>'.DrawSelectBox('sectorid', $Sectors, 'loc_sector_id', '').'</td>'; - echo '<td>Coordinates (X/Y/Z):</td><td><input type="text" name="loc_x" size="5"/>/<input type="text" name="loc_y" size="5"/>/<input type="text" name="loc_z" size="5"/></td></tr>'; + echo '<td>Coordinates (X/Y/Z):</td><td><input type="text" name="loc_x" size="5" />/<input type="text" name="loc_y" size="5" />/<input type="text" name="loc_z" size="5" /></td></tr>'; echo '<tr><td>Radius:</td><td><input type="text" name="radius" size="10" /></td>'; echo '<td>Visible Radius:</td><td><input type="text" name="visible_radius" size="10" /></td></tr>'; - echo '<tr><td>Probability:</td><td><input type="text" name="probability" size="10"/></td>'; + echo '<tr><td>Probability:</td><td><input type="text" name="probability" size="10" /></td>'; echo '<td>Tool Category</td><td>'.DrawSelectBox('category', $Category, 'item_cat_id', '').'</td></tr>'; echo '<tr><td>Skill:</td><td>'.DrawSelectBox('skill', $Skills, 'skill', '').'</td>'; - echo '<td>Skill Level:</td><td><input type="text" name="skill_level" size="10"/></td></tr>'; - echo '<tr><td>Reward Item:</td><td>'.DrawSelectBox('items', $Items, 'item_id_reward', '').'</td>'; - echo '<td>Item Quality:</td><td><input type="text" name="item_quality" size="10"/></td></tr>'; + echo '<td>Skill Level:</td><td><input type="text" name="skill_level" size="10" /></td></tr>'; + echo '<tr><td>Reward Item:</td><td>'.DrawItemSelectBox('item_id_reward', '', true, true).'</td>'; + echo '<td>Item Quality:</td><td><input type="text" name="item_quality" size="10" /></td></tr>'; echo '<tr><td>Animation:</td><td><input type="text" name="animation" /></td>'; - echo '<td>Animation Duration:</td><td><input type="text" name="anim_duration_seconds" size="5"/></td></tr>'; + echo '<td>Animation Duration:</td><td><input type="text" name="anim_duration_seconds" size="5" /></td></tr>'; echo '<tr><td>Action:</td><td><input type="text" name="action" /></td>'; echo '<td>Reward Nickname:<br/>(Name used after action)</td><td><input type="text" name="reward_nickname" /></td></tr>'; - echo '</table><input type="submit" name="commit" value="Commit New" />'; + echo '</table><div><input type="submit" name="commit" value="Commit New" /></div>'; echo '</form>'; }else if ($_POST['action'] == 'Delete' && checkaccess('natres', 'delete')){ $id = mysql_real_escape_string($_POST['id']); @@ -174,19 +172,19 @@ echo '<td>'.$row['max_random'].'</td>'; if (checkaccess('natres', 'edit')){ echo '<td><form action="./index.php?do=resource" method="post">'; - echo '<input type="hidden" name="id" value="'.$row['id'].'" />'; + echo '<div><input type="hidden" name="id" value="'.$row['id'].'" />'; echo '<input type="submit" name="action" value="Edit" />'; if (checkaccess('natres', 'delete')){ echo '<br/><input type="submit" name="action" value="Delete" />'; } - echo '</form></td>'; + echo '</div></form></td>'; } echo '</tr>'; } echo '</table>(1) if not null, indicates how many items will be spawned (same as hunt_location)<br/>(2) if amount not null, msec interval for spawning item when picked up<br/>(3) if amount not null, maximum random interval modifier in msecs'; if (checkaccess('natres', 'create')){ echo '<form action="./index.php?do=resource" method="post">'; - echo '<input type="submit" name="action" value="Create New" /></form>'; + echo '<div><input type="submit" name="action" value="Create New" /></div></form>'; } } }else{ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rav...@us...> - 2020-05-30 20:03:52
|
Revision: 10006 http://sourceforge.net/p/planeshift/code/10006 Author: ravna-ps Date: 2020-05-30 20:03:50 +0000 (Sat, 30 May 2020) Log Message: ----------- Added ID to resource overview. Modified Paths: -------------- www/webconsole-new/crafting/resources.php Modified: www/webconsole-new/crafting/resources.php =================================================================== --- www/webconsole-new/crafting/resources.php 2020-03-07 15:40:17 UTC (rev 10005) +++ www/webconsole-new/crafting/resources.php 2020-05-30 20:03:50 UTC (rev 10006) @@ -148,7 +148,7 @@ } } $result = mysql_query2($query); - echo '<table border="1"><tr><th><a href="./index.php?do=resource&sort=loc">Location</a></th><th>Radius</th><th>Visible Radius</th><th>Probability</th><th><a href="./index.php?do=resource&sort=skill">Skill</a></th><th>Skill Level</th><th><a href="./index.php?do=resource&sort=tool">Tool Category</a></th><th>Item Quality</th><th>Animation</th><th>Animation Duration</th><th><a href="./index.php?do=resource&sort=item">Item</a></th><th>Resource "Nickname"</th><th>Amount (1)</th><th>Interval (2)</th><th>Max Random (3)</th>'; + echo '<table border="1"><tr><th>ID</th><th><a href="./index.php?do=resource&sort=loc">Location</a></th><th>Radius</th><th>Visible Radius</th><th>Probability</th><th><a href="./index.php?do=resource&sort=skill">Skill</a></th><th>Skill Level</th><th><a href="./index.php?do=resource&sort=tool">Tool Category</a></th><th>Item Quality</th><th>Animation</th><th>Animation Duration</th><th><a href="./index.php?do=resource&sort=item">Item</a></th><th>Resource "Nickname"</th><th>Amount (1)</th><th>Interval (2)</th><th>Max Random (3)</th>'; if (checkaccess('natres', 'edit')){ echo '<th>Actions</th>'; } @@ -155,6 +155,7 @@ echo '</tr>'; while ($row = fetchSqlAssoc($result)){ echo '<tr>'; + echo '<td>'.$row['id'].'</td>'; echo '<td>'.$row['sector'].'/'.$row['loc_x'].'/'.$row['loc_y'].'/'.$row['loc_z'].'</td>'; echo '<td>'.$row['radius'].'</td>'; echo '<td>'.$row['visible_radius'].'</td>'; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |