[MOD] Rapid fire editor of DB (v1.8, v2.0)

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • [MOD] Rapid fire editor of DB (v1.8, v2.0)

      Hi~
      There may be errors in translation. :D :D

      Modified to operate in 2.0 by referring to the 1.7 version of the library.

      Produced by referring to the link below.
      [MOD](Edit Rapidfire) Корректировка скорострела %D0%B8%D1%80%D0%BE%D0%B2%D0%BA%D0%B0-%D1%81%D0%BA%D0%BE%D1%80%D0%BE%D1%81% D1%82%D1%80%D0%B5%D0%BB%D0%B0/

      It has been perfectly implemented so that anyone can use it, and i made it very easy to use.

      A screenshot is attached.
      I hope this helps a lot.

      Function:
      1. You can delete the current row or modify the amount of Rapid fire.
      2. When saving a new rapid fire, it is displayed in order.
      3. Automatically stop on further saves with the same row incorrectly.

      1. Create a php file.
      includes/game/ShowRapidfirePage.class.php


      PHP Source Code

      1. <?php
      2. # 1st by aurum79
      3. # 2nd by noonn
      4. /*
      5. Rapid fire editor of DB
      6. */
      7. class ShowRapidfirePage extends AbstractGamePage
      8. {
      9. public static $requireModule = 0;
      11. function __construct()
      12. {
      13. parent::__construct();
      14. }
      17. function show()
      18. {
      19. global $USER, $LNG;
      21. $db = Database::get();
      22. if($USER['authlevel'] != 3){
      23. $this->printMessage("Page not found.<br>", array(array(
      24. 'label' => "Move",
      25. 'url' => 'game.php'
      26. )));
      27. }
      29. $sql = "SELECT * FROM %%VARS_RAPIDFIRE%% ORDER BY elementID, rapidfireID;";
      30. $rapidResult = $db->select($sql, array());
      32. $fleet_i = array();
      34. foreach ($rapidResult as $row)
      35. {
      36. $fleet_i[] = array(
      37. 'elementID' => $row['elementID'],
      38. 'rapidfireID' => $row['rapidfireID'],
      39. 'shoots' => $row['shoots'],
      40. );
      41. }
      43. $this->assign(array(
      44. 'fleet_i' => $fleet_i,
      45. 'short' => $LNG['shortNames'],
      46. ));
      47. $this->display('page.rapidfire.tpl');
      48. }
      51. function del()
      52. {
      53. global $USER;
      55. if($USER['authlevel'] != 3){
      56. $this->printMessage("Page not found.<br>", array(array(
      57. 'label' => "Move",
      58. 'url' => 'game.php'
      59. )));
      60. }
      62. $db = Database::get();
      64. $elemID = HTTP::_GP('elemID', '');
      65. $rapID = HTTP::_GP('rapID', '');
      67. $sql = 'DELETE FROM %%VARS_RAPIDFIRE%% WHERE elementID = :elemID AND rapidfireID = :rapID ;';
      68. $db->delete($sql, array(
      69. ':elemID' => $elemID,
      70. ':rapID' => $rapID,
      71. ));
      73. $this->redirectTo('game.php?page=rapidfire');
      74. }
      77. function edits()
      78. {
      79. global $USER;
      81. if($USER['authlevel'] != 3){
      82. $this->printMessage("Page not found.<br>", array(array(
      83. 'label' => "Move",
      84. 'url' => 'game.php'
      85. )));
      86. }
      88. $db = Database::get();
      90. $elemID = HTTP::_GP('elemID', '');
      91. $rapID = HTTP::_GP('rapID', '');
      92. $shoots = HTTP::_GP('newshoots', '');
      95. // Check no same elemID and rapidfireID
      96. $sql = "SELECT COUNT(*) as count FROM %%VARS_RAPIDFIRE%% WHERE elementID = :elemID AND rapidfireID = :rapID ;";
      97. $checkID = $db->selectSingle($sql, array(
      98. ':elemID' => $elemID,
      99. ':rapID' => $rapID,
      100. ), 'count');
      102. if(empty($checkID) || $checkID > 1){
      103. $this->printMessage("<span style=font-size:1.3em;color:#EE00E6><br>Error: Item does not exist, or an identical row exists. !!<br><br></span>", array(array(
      104. 'label' => "Move",
      105. 'url' => '?page=rapidfire'
      106. )));
      107. }
      110. $sql = "UPDATE %%VARS_RAPIDFIRE%% SET shoots = :shoots WHERE elementID = :elemID AND rapidfireID = :rapID ;";
      111. $db->update($sql, array(
      112. ':shoots' => $shoots,
      113. ':elemID' => $elemID,
      114. ':rapID' => $rapID,
      115. ));
      117. $this->redirectTo('game.php?page=rapidfire');
      118. }
      121. function add()
      122. {
      123. global $USER;
      125. if($USER['authlevel'] != 3){
      126. $this->printMessage("Page not found.<br>", array(array(
      127. 'label' => "Move",
      128. 'url' => 'game.php'
      129. )));
      130. }
      132. $db = Database::get();
      134. $elemID = HTTP::_GP('elemID', '');
      135. $rapID = HTTP::_GP('rapID', '');
      136. $shoots = HTTP::_GP('shoots', '');
      138. // Check same elemID and rapidfireID
      139. $sql = "SELECT COUNT(*) as count FROM %%VARS_RAPIDFIRE%% WHERE elementID = :elemID AND rapidfireID = :rapID ;";
      140. $checkID = $db->selectSingle($sql, array(
      141. ':elemID' => $elemID,
      142. ':rapID' => $rapID,
      143. ), 'count');
      145. if($checkID == 1){
      146. $this->printMessage("<span style=font-size:1.3em;color:#EE00E6><br>ERROR: Same item exists. !!<br><br></span>", array(array(
      147. 'label' => "Move",
      148. 'url' => '?page=rapidfire'
      149. )));
      150. }
      151. // INSERT data
      152. $sql = 'INSERT INTO %%VARS_RAPIDFIRE%% SET elementID = :elemID, rapidfireID = :rapID, shoots = :shoots ;';
      153. $db->insert($sql, array(
      154. ':elemID' => $elemID,
      155. ':rapID' => $rapID,
      156. ':shoots' => $shoots,
      157. ));
      159. $this->redirectTo('game.php?page=rapidfire');
      160. }
      163. function ClearCache()
      164. {
      165. global $USER, $LNG;
      167. if($USER['authlevel'] != 3){
      168. $this->printMessage("Page not found.<br>", array(array(
      169. 'label' => "Move",
      170. 'url' => 'game.php'
      171. )));
      172. }
      174. ClearCache();
      175. $this->redirectTo('game.php?page=rapidfire');
      176. }
      177. }
      178. ?>
      Display All




      2. Create a tpl file.
      templates/game/page.rapidfire.tpl

      HTML Source Code

      1. {block name="title" prepend}Rapid fire editor{/block}
      2. {block name="content"}
      3. <style>
      4. td{
      5. font-size:1.2em;
      6. }
      7. .bgco{
      8. background-color:#003851;
      9. }
      10. </style>
      13. <div class="content_page">
      14. <div class="title" style="font-size:1.2em">
      15. Rapid fire editor
      16. </div>
      18. <table border='1' width="100%">
      19. <tr>
      20. <th colspan="2"><font color="red" style="font-size:1.3em;color:#9BC800;">
      21. <pre>
      22. caution!
      23. 1. You can delete the current row or modify the amount of Rapid fire.
      24. 2. When saving a new rapid fire, it is displayed in order.
      25. 3. Automatically stop on further saves with the same row incorrectly.
      26. </pre>
      27. </font>
      28. </th>
      29. </tr>
      30. <tr>
      31. <td><form action="?page=rapidfire&mode=ClearCache" method="post">
      32. After all operations are complete, please clear the cache.
      33. </td>
      34. <td><input type="submit" value="Clear Cache" style="display:block;float:right;background-color: #003F5B;width:120px;color:#fff;height:30px"></td>
      35. </form>
      36. </tr>
      37. </table>
      38. <table border='1' width="100%">
      39. <tr>
      40. <td class="bgco" height="30px">Fleet/Defense</td>
      41. <td class="bgco">Rapid fire item</td>
      42. <td class="bgco">Rapid fire</td>
      43. <td class="bgco">Save</td>
      44. </tr>
      45. <form action="?page=rapidfire&mode=add" method="post">
      46. <tr>
      47. <td>
      48. {html_options name=elemID options=$short style='font-size:1.0em;color:#58FA58'}
      49. </td>
      50. <td>
      51. {html_options name=rapID options=$short style='font-size:1.0em;color:#EE00E6'}
      52. </td>
      53. <td>
      54. <input style="width:60px; color:#FC6;font-size:1.3em" name="shoots" type="number" min="1" onchange="KeyUpBuy('');" onkeyup="KeyUpBuy('');" value="1">
      55. </td>
      56. <td>
      57. <input style="background-color: #48A34B;width:120px;color:#fff;font-size:1.1em;display:block; margin:0 auto; padding:3px 15px;" type="submit" value="Add Save">
      58. </td>
      59. </tr>
      60. </form>
      61. </table>
      63. <table border='1' width="100%">
      64. <tr>
      65. <td colspan="6" height="30px">Rapid Fire in the database</td>
      66. </tr>
      67. <tr>
      68. <td class="bgco">No.</td>
      69. <td class="bgco">Delete</td>
      70. <td class="bgco" height="30px">Fleet/Defense</td>
      71. <td class="bgco">Rapid fire item</td>
      72. <td class="bgco">Rapid fire</td>
      73. <td class="bgco">Edit Rapid fire</td>
      74. </tr>
      75. {foreach $fleet_i as $row}
      76. <tr>
      77. <td width="30px">#{$row@iteration}</td>
      78. <td>
      79. <form action="?page=rapidfire&mode=del&elemID={$row.elementID}&rapID={$row.rapidfireID}" method="post">
      80. <input onclick="return confirm('Delete the rows of items {$row.elementID} and {$row.rapidfireID}?');" type="submit" value="Delete" style="font-size:0.9em;color:red">
      81. </form>
      82. </td>
      83. <td>({$row.elementID})
      84. <a href="#" style="color:#58FA58;padding-left: 3px;" onclick="return Dialog.info({$row.elementID})">{$LNG.tech.{$row.elementID}}</a></td>
      85. <td>({$row.rapidfireID})
      86. <a href="#" style="color:#EE00E6;padding-left: 3px;" onclick="return Dialog.info({$row.rapidfireID})">{$LNG.tech.{$row.rapidfireID}}</a></td>
      87. <td><span style="color:#FC6;">{$row.shoots}</span></td>
      88. <td>
      89. <form action="?page=rapidfire&mode=edits&elemID={$row.elementID}&rapID={$row.rapidfireID}" method="post">
      90. <input style="font-size:1.3em;width:50px;height:20px" name="newshoots" type="number" min="1" onchange="KeyUpBuy('');" onkeyup="KeyUpBuy('');" value="{$row.shoots}">
      91. <input onclick="return confirm('Modify the rows of items {$row.elementID} and {$row.rapidfireID}?');" style="font-size:1.0em;background-color: #003F5B;width:120px;color:#fff;" type="submit" value="Modify">
      92. </form>
      93. </td>
      94. </tr>
      95. {/foreach}
      96. </table>
      97. <br><br><br><br><br><br><br>
      98. </div>
      99. {/block}
      Display All




      3. Add link.

      HTML Source Code

      1. {if $authlevel > 0} <a href="game.php?page=rapidfire">RapidFire Editor</a> {/if}


      End.....
      Thanks.
      ^^ ^^
      Images

      • rapidfireEditor.JPG

        181.29 kB, 949×963, viewed 942 times

      • popupRF.jpg

        261.92 kB, 911×1,026, viewed 384 times

      • 003.JPG

        74.51 kB, 898×446, viewed 405 times
      --------------------------------------------------------------------------------------

      The post was edited 1 time, last by noonn ().

    • Zeus wrote:

      hello, there is integration for newstar, this code you gave works in newstar

      thank you for your sharing
      It works well for New Stars too.

      have a nice day ^^
      --------------------------------------------------------------------------------------

    • noonn wrote:

      3. Add link.
      <a href="game.php?page=rapidfire">RapidFire Editor</a>
      Agrega la verificación a la vista, así los usuario comunes no lo ven

      HTML Source Code

      1. {if $authlevel > 0}<a href="game.php?page=rapidfire">RapidFire Editor</a>{/if}
      VERY SAD :/ :/ :/ :/

    • Very well done noon
      Ive done a bit similar for the game i am working on it as i truncated the rapidfire and requirements table to scratch from 0.

      if i might give you one little advice, add filtering option/pagination. The page might became very long at the end, but its just extra improvements,
      Try the new Deployment module: More info
      V1.1.9 has been rolled out <3

    • Well I'm doing it again but directly in the administration with a more optimized code. As soon as it's finished I'll put it here.
      Jbaukens to mention filtering and paging so I will do those as well.


      The post was edited 1 time, last by Danter14 ().

    • Danter14 wrote:

      Well I'm doing it again but directly in the administration with a more optimized code. As soon as it's finished I'll put it here.
      Jbaukens to mention filtering and paging so I will do those as well.



      Can you make it compatible in newstar because 2moons 2.0 versions are compatible

    • Zeus wrote:

      Can you make it compatible in newstar because 2moons 2.0 versions are compatible
      It will be compatible because new star goes through version 1.8 of 2moons. knowing that the code is made with version 2.0.

      search good

      The post was edited 2 times, last by Danter14 ().

    • As promised here is a version for the admin panel with the code redone and optimized as much as possible
      • The code is fully documented
      • Adding a pagination
      • Added a search bar by IDs
      • Works under versions 1.8, 1.9, 2.0, new star
      A like and a return is always a pleasure ^^
      Files

    • Danter14 wrote:

      As promised here is a version for the admin panel with the code redone and optimized as much as possible
      • The code is fully documented
      • Adding a pagination
      • Added a search bar by IDs
      • Works under versions 1.8, 1.9, 2.0, new star
      A like and a return is always a pleasure ^^
      Thank you Danter14
      Nice works.
      Thanks for sharing the mod.
      :thumbsup: :thumbsup:
      --------------------------------------------------------------------------------------