API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 28th, 2016
68
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.86 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. if(basename($_SERVER["PHP_SELF"]) == "rankings.php"){
  3. die("403 - Access Forbidden");
  4. }
  5. ?>
  6. <h2 class="text-left">Rankings</h2>
  7. <hr/>
  8. <?php
  9. error_reporting(-1);
  10. if(isset($_GET['job'])) {
  11. $egetjob = $mysqli->real_escape_string(@$_GET['job']);
  12. $getjob = preg_replace("/[^A-Za-z0-9 ]/", '', $egetjob); # Escape and Strip
  13. }
  14. $dir = "/";
  15. if(isset($getjob) && $getjob != NULL) {
  16. if($getjob == "beginner"){
  17. $show = "AND (c.job = 000) AND (c.level < 11) AND (c.map > 4) OR (c.job = 000) AND (c.level > 10) AND (c.map > 2000002)";
  18. }
  19. elseif($getjob == "warrior"){
  20. $show = "AND (c.job = 100 OR c.job = 110 OR c.job = 111 OR c.job = 112 OR c.job = 120 OR c.job = 121 OR c.job = 122 OR c.job = 130 OR c.job = 131 OR c.job = 132)";
  21. }
  22. elseif($getjob == "magician"){
  23. $show = "AND (c.job = 200 OR c.job = 210 OR c.job = 211 OR c.job = 212 OR c.job = 220 OR c.job = 221 OR c.job = 222 OR c.job = 230 OR c.job = 231 OR c.job = 232)";
  24. }
  25. elseif($getjob == "bowman"){
  26. $show = "AND (c.job = 300 OR c.job = 310 OR c.job = 311 OR c.job = 312 OR c.job = 320 OR c.job = 321 OR c.job = 322)";
  27. }
  28. elseif($getjob == "thief"){
  29. $show = "AND (c.job = 400 OR c.job = 410 OR c.job = 411 OR c.job = 412 OR c.job = 420 OR c.job = 421 OR c.job = 422)";
  30. }
  31. elseif($getjob == "pirate"){
  32. $show = "AND (c.job = 500 OR c.job = 510 OR c.job = 511 OR c.job = 512 OR c.job = 520 OR c.job = 521 OR c.job = 522)";
  33. }
  34. elseif($getjob == "cygnus"){
  35. $show = "AND (c.job = 1000 OR c.job = 1100 OR c.job = 1110 OR c.job = 1111 OR c.job = 1112 OR c.job = 1200 OR c.job = 1210 OR c.job = 1211 OR c.job = 1212 OR c.job = 1300 OR c.job = 1310 OR c.job = 1311 OR c.job = 1312 OR c.job = 1400 OR c.job = 1410 OR c.job = 4111 OR c.job = 1412 OR c.job = 1500 OR c.job = 1511 OR c.job = 1512)";
  36. }
  37. elseif($getjob == "aran"){
  38. $show = "AND (c.job = 2000 OR c.job = 2100 OR c.job = 2110 OR c.job = 2111 OR c.job = 2112)";
  39. }
  40. elseif($getjob == "islander"){
  41. $show = "AND (c.job = 000) AND (c.level > 10) AND (c.map > 4) AND (c.map < 2000002)";
  42. }
  43. elseif($getjob == "camper"){
  44. $show = "AND (c.job = 000) AND (c.level > 1) AND (c.map > 0) AND (c.map < 3)";
  45. }
  46. elseif($getjob == "all"){
  47. $show = "";
  48. }
  49. } else {
  50. $show = "";
  51. $getjob = "all";
  52. }
  53. $estart = $mysqli->real_escape_string(@$_GET['start']);
  54. $start = intval(+preg_replace("/[^A-Za-z0-9 ]/", '', $estart)); # Escape and Strip and ensure it's a number
  55. $esearch = $mysqli->real_escape_string(@$_GET['search']);
  56. $search = preg_replace("/[^A-Za-z0-9 ]/", '', $esearch); # Escape and Strip
  57. if(isset($search)) {
  58. $esearch = $mysqli->real_escape_string(@$_POST['search']);
  59. $search = preg_replace("/[^A-Za-z0-9 ]/", '', $esearch); # Escape and Strip
  60. $csearch = " AND c.name LIKE '".$search."%'";
  61. } else {
  62. $csearch = "";
  63. }
  64. if(isset($search)){
  65. if($servertype == 1) {
  66. $result2 = $mysqli->query("SELECT c.name , c.gm, c.job , c.level, c.reborns, g.guildid, g.name AS gname, g.logo AS logo, g.logoColor AS logoColor, g.logoBGColor AS logoBGColor, g.logoBG AS logoBG FROM characters c LEFT JOIN guilds g ON c.guildid = g.guildid WHERE c.gm < $gmlevel ".$show."".$csearch." GROUP BY c.id DESC ORDER BY reborns DESC, level DESC LIMIT $start, 15") or die("IT IS LINE ". __LINE__ . "<br />" . $mysqli->error);
  67. } else {
  68. $result2 = $mysqli->query("SELECT c.name , c.gm, c.job , c.level, c.map, c.exp, g.guildid, g.name AS gname, g.logo AS logo, g.logoColor AS logoColor, g.logoBGColor AS logoBGColor, g.logoBG AS logoBG FROM characters c LEFT JOIN guilds g ON c.guildid = g.guildid WHERE c.gm < $gmlevel ".$show."".$csearch." GROUP BY c.id DESC ORDER BY level DESC, exp DESC LIMIT $start, 15") or die("IT IS LINE ". __LINE__ . "<br />" . $mysqli->error);
  69. }
  70. $row_number = 0;
  71. $int = 0;
  72. while(($row = $result2->fetch_assoc()) && !$row_number){
  73. if(strtolower($row['name']) == strtolower($search)){
  74. $row_number = $int;
  75. }
  76. $int++;
  77. }
  78. if($row_number){
  79. $start = $row_number - ($row_number % 5);
  80. }
  81. }
  82. if($servertype == 1) {
  83. $result = $mysqli->query("SELECT c.name , c.gm, c.job, c.level, c.reborns, g.guildid, g.name AS gname, g.logo AS logo, g.logoColor AS logoColor, g.logoBGColor AS logoBGColor, g.logoBG AS logoBG FROM characters c LEFT JOIN guilds g ON c.guildid = g.guildid WHERE (c.gm < '$gmlevel') ".$show."".$csearch." GROUP BY c.id DESC ORDER BY reborns DESC, level DESC LIMIT 10 OFFSET $start") or die("IT IS LINE ". __LINE__ . "<br />" . $mysqli->error);
  84. } else {
  85. $result = $mysqli->query("SELECT c.name , c.gm, c.job, c.level, c.map, c.exp, g.guildid, g.name AS gname, g.logo AS logo, g.logoColor AS logoColor, g.logoBGColor AS logoBGColor, g.logoBG AS logoBG FROM characters c LEFT JOIN guilds g ON c.guildid = g.guildid WHERE (c.gm < '$gmlevel') ".$show."".$csearch." GROUP BY c.id DESC ORDER BY level DESC, exp DESC LIMIT 10 OFFSET $start") or die("IT IS LINE ". __LINE__ . "<br />" . $mysqli->error);
  86. }
  87. echo "
  88. <div class=\"row\">
  89. <div class=\"col-md-6\">
  90. <div class=\"well well2\" style=\"margin: 0 auto; display: inline-block;margin-bottom:0px;\">
  91. <a href=\"?base=main&page=rankings&job=camper\"><img src=\"".$siteurl."assets/img/rank/camper.png\" data-toggle=\"tooltip\" title=\"Camper\"/></a>
  92. <a href=\"?base=main&page=rankings&job=islander\"><img src=\"".$siteurl."assets/img/rank/islander.png\" data-toggle=\"tooltip\" title=\"Islander\"/></a>
  93. <a href=\"?base=main&page=rankings&job=beginner\"><img src=\"".$siteurl."assets/img/rank/beginner.png\" data-toggle=\"tooltip\" title=\"Beginner\"/></a>
  94. </div>
  95. </div>
  96. <div class=\"col-md-5 col-md-offset-1\">
  97. <form id='search_form' method='post' action='?base=main&page=rankings'>
  98. <div style=\"float:right;\">
  99. <div class=\"well well2\" style=\"margin-bottom:0px;\">
  100. <div class=\"input-group\">
  101. <input type='text' name='search' id='s' class='form-control' placeholder='Character Name' required value='".$search."'/>
  102. <span class=\"input-group-btn\">
  103. <button class=\"btn btn-primary\" type=\"submit\"><i class=\"icon-search\"></i> Search</button>
  104. </span>
  105. </div>
  106. </div>
  107. </div>
  108. </form>
  109. </div>
  110. </div><hr/>";
  111. echo "
  112. <div class=\"table-responsive\">
  113. <table class=\"table table-striped table-hover center-table table-bordered\">
  114. <thead>
  115. <tr>
  116. <th>Rank</th>
  117. <th class=\"hidden-sm hidden-xs\">Picture</th>
  118. <th>Name</th>
  119. <th>Job</th>";
  120. if($servertype == 1){
  121. echo "<th>Rebirths</th>";
  122. }
  123. echo " <th>Level</th>
  124. </tr>
  125. </thead>
  126. <tbody>";
  127.  
  128. $ranking=$start;
  129. while($row = $result->fetch_assoc()) {
  130. $ranking++;
  131. $name = $row['name'];
  132. echo "
  133. <tr>
  134. <td><span class=\"badge\">$ranking</span></td>
  135. <td class=\"hidden-sm hidden-xs\"><img src=\"".$siteurl."assets/img/GD/create.php?name=".$name."\" alt=\"".$name."\" class=\"avatar img-responsive\" style=\"margin: 0 auto;\"></td>
  136. <td><a href=\"?base=main&page=character&n=".$row['name']."\">".$row['name']."</a></td>
  137. <td>";
  138. if ($row['job']=="000" && $row['level']<11 && $row['map']>4 || $row['job']=="000" && $row['level']>10 && $row['map']>2000002)
  139. echo "Beginner";
  140. if ($row['job']=="000" && $row['level']>10 && $row['map']>4 && $row['map']<2000002)
  141. echo "Islander";
  142. if ($row['job']=="000" && $row['level']>0 && $row['map']>1 && $row['map']<3)
  143. echo "Camper";
  144. if ($row['job']=="100")
  145. echo "Warrior";
  146. if ($row['job']=="110")
  147. echo "Fighter";
  148. if ($row['job']=="120")
  149. echo "Page";
  150. if ($row['job']=="130")
  151. echo "Spearman";
  152. if ($row['job']=="111")
  153. echo "Crusader";
  154. if ($row['job']=="121")
  155. echo "White Knight";
  156. if ($row['job']=="131")
  157. echo "Dragon Knight";
  158. if ($row['job']=="112")
  159. echo "Hero";
  160. if ($row['job']=="122")
  161. echo "Paladin";
  162. if ($row['job']=="132")
  163. echo "Dark Knight";
  164. if ($row['job']=="200")
  165. echo "Magician";
  166. if ($row['job']=="210")
  167. echo "Wizard";
  168. if ($row['job']=="220")
  169. echo "Wizard";
  170. if ($row['job']=="230")
  171. echo "Cleric";
  172. if ($row['job']=="211")
  173. echo "Mage";
  174. if ($row['job']=="221")
  175. echo "Mage";
  176. if ($row['job']=="231")
  177. echo "Priest";
  178. if ($row['job']=="212")
  179. echo "Arch Mage";
  180. if ($row['job']=="222")
  181. echo "Arch Mage";
  182. if ($row['job']=="232")
  183. echo "Bishop";
  184. if ($row['job']=="300")
  185. echo "Bowman";
  186. if ($row['job']=="310")
  187. echo "Hunter";
  188. if ($row['job']=="320")
  189. echo "Crossbowman";
  190. if ($row['job']=="311")
  191. echo "Ranger";
  192. if ($row['job']=="321")
  193. echo "Sniper";
  194. if ($row['job']=="312")
  195. echo "Bow Master";
  196. if ($row['job']=="322")
  197. echo "Crossbow Master";
  198. if ($row['job']=="400")
  199. echo "Thief";
  200. if ($row['job']=="410")
  201. echo "Assassin";
  202. if ($row['job']=="420")
  203. echo "Bandit";
  204. if ($row['job']=="411")
  205. echo "Hermit";
  206. if ($row['job']=="421")
  207. echo "Chief Bandit";
  208. if ($row['job']=="412")
  209. echo "Night Lord";
  210. if ($row['job']=="422")
  211. echo "Shadower";
  212. if ($row['job']=="500")
  213. echo "Pirate";
  214. if ($row['job']=="510")
  215. echo "Brawler";
  216. if ($row['job']=="520")
  217. echo "Gunslinger";
  218. if ($row['job']=="511")
  219. echo "Marauder";
  220. if ($row['job']=="521")
  221. echo "Buccaneer";
  222. if ($row['job']=="512")
  223. echo "Outlaw";
  224. if ($row['job']=="522")
  225. echo "Corsair";
  226. if ($row['job']=="900")
  227. echo "GMs";
  228. if ($row['job']=="910")
  229. echo "SuperGM";
  230. if ($row['job']=="1000")
  231. echo "Noblesse";
  232. if ($row['job']=="1100")
  233. echo "Dawn Warrior";
  234. if ($row['job']=="1110")
  235. echo "Dawn Warrior 2";
  236. if ($row['job']=="1111")
  237. echo "Dawn Warrior 3";
  238. if ($row['job']=="1112")
  239. echo "Dawn Warrior 4";
  240. if ($row['job']=="1200")
  241. echo "Flame Wizard";
  242. if ($row['job']=="1210")
  243. echo "Flame Wizard 2";
  244. if ($row['job']=="1211")
  245. echo "Flame Wizard 3";
  246. if ($row['job']=="1212")
  247. echo "Flame Wizard 4";
  248. if ($row['job']=="1300")
  249. echo "Wind Archer";
  250. if ($row['job']=="1310")
  251. echo "Wind Archer 2";
  252. if ($row['job']=="1311")
  253. echo "Wind Archer 3";
  254. if ($row['job']=="1312")
  255. echo "Wind Archer 4";
  256. if ($row['job']=="1400")
  257. echo "Night Walker";
  258. if ($row['job']=="1410")
  259. echo "Night Walker 2";
  260. if ($row['job']=="1411")
  261. echo "Night Walker 3";
  262. if ($row['job']=="1412")
  263. echo "Night Walker 4";
  264. if ($row['job']=="1500")
  265. echo "Thunder Breaker";
  266. if ($row['job']=="1510")
  267. echo "Thunder Breaker 2";
  268. if ($row['job']=="1511")
  269. echo "Thunder Breaker 3";
  270. if ($row['job']=="1512")
  271. echo "Thunder Breaker 4";
  272. if ($row['job']=="2000")
  273. echo "Legend";
  274. if ($row['job']=="2100")
  275. echo "Aran";
  276. if ($row['job']=="2111")
  277. echo "Aran 2";
  278. if ($row['job']=="2112")
  279. echo "Aran 3";
  280.  
  281. if($servertype == 1){
  282. echo "</td>
  283. <td>".$row['reborns']."</td>";
  284. }
  285. echo "
  286. <td>".$row['level']."</td>
  287. </tr>";
  288. }
  289. echo "
  290. </tbody>
  291. </table>
  292. </div>
  293. <ul class=\"pager\">
  294. ";
  295.  
  296. if($start == 0 || $start<=10) {
  297. echo " <li class=\"previous\"><a href=\"?base=main&page=rankings&job=".$getjob."/\"><i class=\"icon-arrow-left\"></i> Previous</a></li>";
  298. }
  299. else{
  300. echo "<li class=\"previous\"><a href=\"?base=main&page=rankings&job=".$getjob."&start=". abs($start - 10) ."\"><i class=\"icon-arrow-left\"></i> Previous</a></li>";
  301. }
  302. echo"
  303. <li class=\"next\"><a href=\"?base=main&page=rankings&job=".$getjob."&start=". abs($start + 10) ."\">Next<i class=\"icon-arrow-right\"></i></a></li>";
  304. ?>
  305.  
  306. </ul>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!