[Help] Mssql Query show Server Peak.

    • [Help] Mssql Query show Server Peak.

      Hiya all.

      I have a question regarding FlyFF offi Mssql query, on where to find the thing to show Server Peak on my website.

      I have managed to fix the ranking and the online user count total accounts and total characters, but i cannot find the thing to show Server Peak.

      Query for Current Online Users.

      PHP-Quellcode

      1. <?php
      2. $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      3. $db = @mssql_select_db('ACCOUNT_DBF') or die ("Account table is missing!");
      4. $b = '';
      5. $mail = '';
      6. $query = mssql_query("SELECT * FROM [ACCOUNT_TBL_DETAIL] WHERE isuse = 'J'");
      7. echo 'Current Online Users: ' . mssql_num_rows($query);
      8. ?>


      Query for Total Accounts and Characters.

      PHP-Quellcode

      1. <?php
      2. $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      3. $db = @mssql_select_db('ACCOUNT_DBF') or die ("Account table is missing!");
      4. $b = '';
      5. $mail = '';
      6. $query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
      7. echo 'Total Accounts: ' . mssql_num_rows($query);
      8. ?>
      9. <?php
      10. $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      11. $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Account table is missing!");
      12. $b = '';
      13. $mail = '';
      14. $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
      15. echo 'Total Characters: ' . mssql_num_rows($query);
      16. ?>
      Alles anzeigen


      Perfect Ranking Script by: lmanso editted by Me and Dha12oks for xampp usage.

      PHP-Quellcode

      1. <?php
      2. $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      3. $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Account table is missing!");
      4. // Job Funtion
      5. function currentjob($job){
      6. if ($job == '0'){
      7. echo "Vagrant";
      8. }
      9. if ($job == '1'){
      10. echo "Mercenary";
      11. }
      12. if ($job == '2'){
      13. echo "Acrobat";
      14. }
      15. if ($job == '3'){
      16. echo "Assist";
      17. }
      18. if ($job == '4'){
      19. echo "Magician";
      20. }
      21. if ($job == '5'){
      22. echo "Puppeter";
      23. }
      24. if ($job == '6'){
      25. echo "Knight";
      26. }
      27. if ($job == '7'){
      28. echo "Blade";
      29. }
      30. if ($job == '8'){
      31. echo "Jester";
      32. }
      33. if ($job == '9'){
      34. echo "Ranger";
      35. }
      36. if ($job == '10'){
      37. echo "Ringmaster";
      38. }
      39. if ($job == '11'){
      40. echo "billposter";
      41. }
      42. if ($job == '12'){
      43. echo "Psykeeper";
      44. }
      45. if ($job == '13'){
      46. echo "Elementor";
      47. }
      48. if ($job == '14'){
      49. echo "Gatekeeper";
      50. }
      51. if ($job == '15'){
      52. echo "Doppler";
      53. }
      54. if ($job == '16'){
      55. echo "M-Knight";
      56. }
      57. if ($job == '17'){
      58. echo "M-Blade";
      59. }
      60. if ($job == '18'){
      61. echo "M-Jester";
      62. }
      63. if ($job == '19'){
      64. echo "M-Ranger";
      65. }
      66. if ($job == '20'){
      67. echo "M-Ringmaster";
      68. }
      69. if ($job == '21'){
      70. echo "M-Billposter";
      71. }
      72. if ($job == '22'){
      73. echo "M-Psykeeper";
      74. }
      75. if ($job == '23'){
      76. echo "M-Elementor";
      77. }
      78. if ($job == '24'){
      79. echo "H-Knight";
      80. }
      81. if ($job == '25'){
      82. echo "H-Blade";
      83. }
      84. if ($job == '26'){
      85. echo "H-Jester";
      86. }
      87. if ($job == '27'){
      88. echo "H-Ranger";
      89. }
      90. if ($job == '28'){
      91. echo "H-Ringmaster";
      92. }
      93. if ($job == '29'){
      94. echo "H-Billposter";
      95. }
      96. if ($job == '30'){
      97. echo "H-Psykeeper";
      98. }
      99. if ($job == '31'){
      100. echo "H-Elementor";
      101. }
      102. }
      104. // Location Funtion
      105. function location($loca){
      106. if ($loca == '1'){
      107. echo "Madrigal";
      108. }
      109. if ($loca == '2'){
      110. echo "Azria";
      111. }
      112. if ($loca == '200'){
      113. echo "Mars Mine Dungeon";
      114. }
      115. if ($loca == '201'){
      116. echo "Dekane Mines";
      117. }
      118. if ($loca == '203'){
      119. echo "Volcano Entrance";
      120. }
      121. if ($loca == '202'){
      122. echo "Guild War Map";
      123. }
      124. if ($loca == '204'){
      125. echo "Ivillis Dungeon";
      126. }
      127. if ($loca == '205'){
      128. echo "Ivillis Dungeon (Boss)";
      129. }
      130. if ($loca == '208'){
      131. echo "Arena";
      132. }
      133. if ($loca == '21'){
      134. echo "Forsaken B1";
      135. }
      136. if ($loca == '22'){
      137. echo "Forsaken B2";
      138. }
      139. if ($loca == '23'){
      140. echo "Forsaken B3";
      141. }
      142. if ($loca == '24'){
      143. echo "Forsaken B4";
      144. }
      145. if ($loca == '25'){
      146. echo "Forsaken B5";
      147. }
      148. if ($loca == '121'){
      149. echo "OMINOUS";
      150. }
      151. if ($loca == '209'){
      152. echo "Mini Room";
      153. }
      154. if ($loca == '3'){
      155. echo "Coral Island";
      156. }
      157. }
      158. function no2str($number){
      159. $number = number_format($number,0, ',', ',');
      160. return $number;
      161. }
      162. $query = mssql_query("SELECT TOP 10 m_szName, m_nLevel, dwWorldID, m_nJob, m_dwGold FROM CHARACTER_TBL WHERE m_chAuthority = 'F' ORDER BY m_nLevel DESC, m_nExp1 DESC");
      163. if (!mssql_num_rows($query)) {
      164. echo 'No records found';
      165. } else {
      166. $ctr = 1;
      167. while ($row = mssql_fetch_array($query)) {
      168. $loca = $row["dwWorldID"];
      169. $job = $row["m_nJob"];
      170. $number = $row["m_dwGold"];
      171. echo '<table width="100%">';
      172. echo '<tr>';
      173. echo '<td width="1%" style="background: yellow">';
      174. echo '<b>No</b>:';
      175. echo '<hr>';
      176. echo $ctr++;
      177. echo '<hr>';
      178. echo '</td>';
      179. echo '<td width="20%" style="background: yellow">';
      180. echo '<b>Name</b>:';
      181. echo '<hr>';
      182. echo $row['m_szName'];
      183. echo '<hr>';
      184. echo '</td>';
      185. echo '<td width="20%" style="background: yellow">';
      186. echo '<b>Level</b>:';
      187. echo '<hr>';
      188. echo $row['m_nLevel'];
      189. echo '<hr>';
      190. echo '</td>';
      191. echo '<td width="20%" style="background: yellow">';
      192. echo '<b>Class</b>:';
      193. echo '<hr>';
      194. echo currentjob($job);
      195. echo '<hr>';
      196. echo '</td>';
      197. echo '<td width="20%" style="background: yellow">';
      198. echo '<b>Penya</b>:';
      199. echo '<hr>';
      200. echo no2str($number);
      201. echo '<hr>';
      202. echo '</td>';
      203. echo '<td width="20%" style="background: yellow">';
      204. echo '<b>Location</b>:';
      205. echo '<hr>';
      206. echo location($loca);
      207. echo '<hr>';
      208. echo '</td>';
      209. echo '</tr>';
      210. echo '</table>';
      212. }
      213. }
      214. mssql_free_result($query);
      215. ?>
      Alles anzeigen


      So as you can see i have most of the query's but still need one more....
      Server Peak ;)
      If anyone can help me out with this one i would be very happy.

      Sincere:
      Asgarth aka Murdock29

      PS: Credits go to those who made all of this, way to many names.
      PPS: Already searched and scouted the whole flyff sections from top to bottom to find it myself first before asking :)

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )