accounts.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350
  1. <?php
  2. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/header.php");
  3. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/staff.php");
  4. if($adminlevel != 1337)
  5. {
  6. die("no access");
  7. }
  8. if(!isset($link))
  9. {
  10. $link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
  11. if($link === false)
  12. {
  13. die("ERROR: Could not connect. " . mysqli_connect_error());
  14. }
  15. }
  16. if(isset($_GET['app_id']))
  17. {
  18. ?>
  19. <app-index _nghost-tnh-c225="">
  20. <div _ngcontent-tnh-c225="" class="content-header">
  21. <h3 _ngcontent-tnh-c225=""> Master - <?php echo $_GET['app_id']; ?> </h3>
  22. </div>
  23. <div _ngcontent-tnh-c225="" class="content">
  24. <section _ngcontent-tnh-c144="" class="transparent grid-newline cs-1 form nopadding">
  25. <div id="look_up_results">
  26. </div>
  27. </section>
  28. </div>
  29. </app-index>
  30. <script>
  31. var ToggleGeo = 0;
  32. function ToggleGeolocation()
  33. {
  34. if(ToggleGeo)
  35. {
  36. ToggleGeo = 0;
  37. document.getElementById("geobutton").innerHTML = '<a href="javascript:void(0)" onclick="ToggleGeolocation()">Click to show</a>';
  38. document.getElementById("geolocation2").style.display = 'none';
  39. }
  40. else
  41. {
  42. ToggleGeo = 1;
  43. document.getElementById("geobutton").innerHTML = '<a href="javascript:void(0)" onclick="ToggleGeolocation()">Click to hide</a>';
  44. document.getElementById("geolocation2").style.display = 'block';
  45. }
  46. }
  47. var loadbar = document.getElementById('loadingbar');
  48. loadbar.classList.add("active");
  49. $("#look_up_results").load("./admin/search_results.php?search_type=2&search_input=" + "<?php echo $_GET['app_id']; ?>", function()
  50. {
  51. loadbar.classList.remove("active");
  52. });
  53. </script>
  54. <?php
  55. }
  56. else
  57. {
  58. ?>
  59. <router-outlet _ngcontent-tnh-c136="" class="router-outlet"></router-outlet>
  60. <app-settings _nghost-tnh-c144="">
  61. <div _ngcontent-tnh-c144="" class="content-header">
  62. <h3 _ngcontent-tnh-c144="" style="display: inline;">Registered Accounts</h3>
  63. </div>
  64. <div _ngcontent-tnh-c144="" class="content">
  65. <section _ngcontent-tnh-c144="" class="transparent grid-newline cs-1 form nopadding">
  66. <app-table _ngcontent-tnh-c170="" class="cs-1" _nghost-tnh-c167="">
  67. <div _ngcontent-tnh-c167="">
  68. <header _ngcontent-tnh-c167="">
  69. <div _ngcontent-tnh-c167="" class="pagination"><a _ngcontent-tnh-c167="" class="page" onclick="changePage_Backward()"><i _ngcontent-tnh-c167="" class="fa fa-fw fa-caret-square-left"></i></a>
  70. <!---->
  71. <!---->
  72. <!----><a _ngcontent-tnh-c167="" class="page current" id="current_page_1">1</a>
  73. <!---->
  74. <!---->
  75. <!----><a _ngcontent-tnh-c167="" class="page" onclick="changePage_Forward()"><i _ngcontent-tnh-c167="" class="fa fa-fw fa-caret-square-right"></i></a></div>
  76. </header>
  77. <!---->
  78. <table _ngcontent-tnh-c167="" cellspacing="0">
  79. <thead _ngcontent-tnh-c167="">
  80. <tr _ngcontent-tnh-c167="">
  81. <!---->
  82. <th _ngcontent-tnh-c167="">
  83. <!---->
  84. </th>
  85. <th _ngcontent-tnh-c167=""> User
  86. <!---->
  87. </th>
  88. <th _ngcontent-tnh-c167=""> Email
  89. <!---->
  90. </th>
  91. <th _ngcontent-tnh-c167=""> IP
  92. <!---->
  93. </th>
  94. <th _ngcontent-tnh-c167=""> Register Date
  95. <!---->
  96. </th>
  97. <!---->
  98. </tr>
  99. </thead>
  100. <!---->
  101. <tbody _ngcontent-tnh-c167="">
  102. <?php
  103. $user_check_query = "SELECT ID, Username, Email, IP, RegisterDate, LastIP FROM accounts ORDER BY ID DESC";
  104. $result = mysqli_query($link, $user_check_query);
  105. $rowcount = $result->num_rows;
  106. if($rowcount > 0)
  107. {
  108. while($result2 = mysqli_fetch_array($result, MYSQLI_ASSOC))
  109. {
  110. $ID = $result2['ID'];
  111. $Username = $result2['Username'];
  112. $Email = $result2['Email'];
  113. $IP = $result2['IP'];
  114. $RegisterDate = $result2['RegisterDate'];
  115. $LastIP = $result2['LastIP'];
  116. $user_check_query = "SELECT `id` FROM `bans` WHERE `name` = '$Username' ORDER BY id DESC LIMIT 1";
  117. $result_2 = mysqli_query($link, $user_check_query);
  118. $rowcount = $result_2->num_rows;
  119. mysqli_free_result($result_2);
  120. if($rowcount > 0)
  121. {
  122. $banned = true;
  123. }
  124. else $banned = false;
  125. ?>
  126. <tr _ngcontent-tnh-c167="" id="kari" <?php if($banned == true) { ?>class="color-red"<?php } ?>>
  127. <td _ngcontent-tnh-c167=""><span _ngcontent-tnh-c167=""><?php echo $ID; ?></span></td>
  128. <td _ngcontent-tnh-c167=""><span _ngcontent-tnh-c167=""><a href="./admin/accounts/<?php echo $Username; ?>" target="_blank"><?php echo $Username; ?></a></span></td>
  129. <td _ngcontent-tnh-c167=""><span _ngcontent-tnh-c167=""><?php echo $Email; ?></span></td>
  130. <td _ngcontent-tnh-c167=""><span _ngcontent-tnh-c167=""><?php echo $IP; ?></span></td>
  131. <td _ngcontent-tnh-c167=""><span _ngcontent-tnh-c167=""><?php echo $RegisterDate; ?></span></td>
  132. </tr>
  133. <?php
  134. }
  135. mysqli_free_result($result);
  136. }
  137. ?>
  138. <!---->
  139. </tbody>
  140. <!---->
  141. </table>
  142. <footer _ngcontent-tnh-c167="">
  143. <div _ngcontent-tnh-c167="" class="pagination"><a _ngcontent-tnh-c167="" class="page" onclick="changePage_Backward()"><i _ngcontent-tnh-c167="" class="fa fa-fw fa-caret-square-left"></i></a>
  144. <!---->
  145. <!---->
  146. <!----><a _ngcontent-tnh-c167="" class="page current" id="current_page_2">1</a>
  147. <!---->
  148. <!---->
  149. <!----><a _ngcontent-tnh-c167="" class="page" onclick="changePage_Forward()"><i _ngcontent-tnh-c167="" class="fa fa-fw fa-caret-square-right"></i></a></div><span _ngcontent-tnh-c167="" class="info" id="paginatorilol"><i _ngcontent-tnh-c167="" class="fa fa-fw fa-info-circle"></i> Showing 1 entries of 1</span></footer>
  150. <!---->
  151. </div>
  152. <!---->
  153. <!---->
  154. </app-table>
  155. </section>
  156. </div>
  157. </app-settings>
  158. <!---->
  159. <script>
  160. var count = 0;
  161. var perPage = 14;
  162. var index = -1;
  163. var current_page = 0;
  164. var last_count = 0;
  165. var tables = document.querySelectorAll("#kari");
  166. var currpage1 = document.getElementById("current_page_1");
  167. var currpage2 = document.getElementById("current_page_2");
  168. for(var i = 0; i < tables.length; i++)
  169. {
  170. if(count >= perPage)
  171. {
  172. tables[i].style.display = 'none';
  173. }
  174. else
  175. {
  176. index = i;
  177. last_count++;
  178. }
  179. count++;
  180. }
  181. if(count > 0)
  182. {
  183. current_page = 1;
  184. var pagess = maxPages();
  185. document.getElementById('paginatorilol').innerHTML = '<i _ngcontent-tnh-c167="" class="fa fa-fw fa-info-circle"></i> Showing ' + current_page + " entries of " + pagess;
  186. }
  187. else document.getElementById('paginatorilol').innerHTML = '<i _ngcontent-tnh-c167="" class="fa fa-fw fa-info-circle"></i> Showing entries 0 of 0';
  188. currpage1.innerHTML = "1";
  189. currpage2.innerHTML = "1";
  190. function changePage_Backward()
  191. {
  192. if(current_page == 1) return false;
  193. var tables = document.querySelectorAll("#kari");
  194. for(var i = 0; i < tables.length; i++)
  195. {
  196. tables[i].style.display = 'none';
  197. }
  198. count = 0;
  199. var idx = last_count;
  200. last_count = 0;
  201. for(var i = index - (idx - 1) - perPage; i < tables.length; i++)
  202. {
  203. if(count >= perPage)
  204. {
  205. tables[i].style.display = 'none';
  206. }
  207. else
  208. {
  209. index = i;
  210. tables[i].style.display = '';
  211. last_count++;
  212. }
  213. count++;
  214. }
  215. current_page--;
  216. currpage1.innerHTML = current_page;
  217. currpage2.innerHTML = current_page;
  218. var pagess = maxPages();
  219. document.getElementById('paginatorilol').innerHTML = '<i _ngcontent-tnh-c167="" class="fa fa-fw fa-info-circle"></i> Showing ' + current_page + " entries of " + pagess;
  220. }
  221. function changePage_Forward()
  222. {
  223. if(current_page + 1 > maxPages()) return false;
  224. var tables = document.querySelectorAll("#kari");
  225. for(var i = 0; i < tables.length; i++)
  226. {
  227. tables[i].style.display = 'none';
  228. }
  229. count = 0;
  230. var idx = last_count;
  231. last_count = 0;
  232. for(var i = index + 1; i < tables.length; i++)
  233. {
  234. if(count >= perPage)
  235. {
  236. tables[i].style.display = 'none';
  237. }
  238. else
  239. {
  240. index = i;
  241. tables[i].style.display = '';
  242. last_count++;
  243. }
  244. count++;
  245. }
  246. current_page++;
  247. currpage1.innerHTML = current_page;
  248. currpage2.innerHTML = current_page;
  249. var pagess = maxPages();
  250. document.getElementById('paginatorilol').innerHTML = '<i _ngcontent-tnh-c167="" class="fa fa-fw fa-info-circle"></i> Showing ' + current_page + " entries of " + pagess;
  251. }
  252. function maxPages()
  253. {
  254. var tables = document.querySelectorAll("#kari");
  255. var pages = 0;
  256. var rows = 0;
  257. for(var i = 0; i < tables.length; i++)
  258. {
  259. if(rows == perPage)
  260. {
  261. rows = 0;
  262. pages++;
  263. }
  264. rows++;
  265. }
  266. if(pages == 0 && rows > 0) pages = 1;
  267. if(rows < perPage && pages > 1) pages++;
  268. return pages;
  269. }
  270. </script>
  271. <?php } ?>