Gilden Ranking!

    Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

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

    • PHP-Quellcode

      1. <?php
      2. include "./conf.php";
      3. $link = @mssql_connect($mssqlcon, $mssqluser, $mssqlpass) or die ("Server is down!");
      4. //No dual connection is needed because the original connection was never closed!!!!, Which is bad for memory and security.
      5. $db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
      6. class job {
      7. function jname($job) {
      9. if ($job == 0) $jname = 'N/A';
      10. else if ($job == 1) $jname = '<img src="img/Icon_CloakSLogo01.jpg">';
      11. else if ($job == 2) $jname = '<img src="img/Icon_CloakSLogo02.jpg">';
      12. else if ($job == 3) $jname = '<img src="img/Icon_CloakSLogo03.jpg">';
      13. else if ($job == 4) $jname = '<img src="img/Icon_CloakSLogo04.jpg">';
      14. else if ($job == 5) $jname = '<img src="img/Icon_CloakSLogo05.jpg">';
      15. else if ($job == 6) $jname = '<img src="img/Icon_CloakSLogo06.jpg">';
      16. else if ($job == 7) $jname = '<img src="img/Icon_CloakSLogo07.jpg">';
      17. else if ($job == 8) $jname = '<img src="img/Icon_CloakSLogo08.jpg">';
      18. else if ($job == 9) $jname = '<img src="img/Icon_CloakSLogo09.jpg">';
      19. else if ($job == 10) $jname = '<img src="img/Icon_CloakSLogo10.jpg">';
      20. else if ($job == 11) $jname = '<img src="img/Icon_CloakSLogo11.jpg">';
      21. else if ($job == 12) $jname = '<img src="img/Icon_CloakSLogo12.jpg">';
      22. else if ($job == 13) $jname = '<img src="img/Icon_CloakSLogo13.jpg">';
      23. else if ($job == 14) $jname = '<img src="img/Icon_CloakSLogo14.jpg">';
      24. else if ($job == 15) $jname = '<img src="img/Icon_CloakSLogo15.jpg">';
      25. else if ($job == 16) $jname = '<img src="img/Icon_CloakSLogo16.jpg">';
      26. else if ($job == 17) $jname = '<img src="img/Icon_CloakSLogo17.jpg">';
      27. else if ($job == 18) $jname = '<img src="img/Icon_CloakSLogo18.jpg">';
      28. else if ($job == 19) $jname = '<img src="img/Icon_CloakSLogo19.jpg">';
      29. else if ($job == 20) $jname = '<img src="img/Icon_CloakSLogo20.jpg">';
      30. else if ($job == 21) $jname = '<img src="img/Icon_CloakSLogo21.jpg">';
      31. else if ($job == 22) $jname = '<img src="img/Icon_CloakSLogo22.jpg">';
      32. else if ($job == 23) $jname = '<img src="img/Icon_CloakSLogo23.jpg">';
      33. else if ($job == 24) $jname = '<img src="img/Icon_CloakSLogo24.jpg">';
      34. else if ($job == 25) $jname = '<img src="img/Icon_CloakSLogo25.jpg">';
      35. else if ($job == 26) $jname = '<img src="img/Icon_CloakSLogo26.jpg">';
      36. else if ($job == 27) $jname = '<img src="img/Icon_CloakSLogo27.jpg">';
      37. else $jname = 'An applicable job name could not be found in our records.';
      38. return $jname;
      40. }
      41. }
      42. $job = new job;
      43. ?>
      45. <table width="100%" border="0" cellpadding="1" cellspacing="1">
      46. <tr>
      47. <td height="23" colspan="6" background="sub.jpg"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
      48. <tr>
      49. <td><center>
      50. <?php
      51. $query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
      52. echo 'Total Accounts: ' . mssql_num_rows($query);
      53. ?>
      54. </center></td>
      55. <td><center>
      56. <?php
      57. $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Accout table is missing!");
      58. $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
      59. echo 'Total Characters: ' . mssql_num_rows($query);
      60. ?>
      61. </center></td>
      62. </tr>
      63. </table>
      64. <div align="center" class="style66">TOP 20 </div></td>
      65. </tr>
      66. <tr>
      67. <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
      68. <div align="left" class="style72">No.</div> </td>
      69. <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
      70. <div align="left" class="style72">Name</div> </td>
      71. <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Gilden Level</div></td>
      72. <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Logo</div></td>
      73. <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Verloren</div></td>
      74. <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Gewonnen</div></td>
      75. </tr>
      77. <?php
      78. $db = mssql_select_db("CHARACTER_01_DBF");
      79. $resTop = mssql_query("SELECT TOP 50 P.m_szGuild, P.m_nLevel, P.m_nLose, P.m_nWin, P.m_dwLogo FROM CHARACTER_01_DBF.dbo.GUILD_TBL P ORDER BY P.m_nLevel DESC");
      80. $ctr = 1;
      81. while ($row3 = mssql_fetch_array($resTop)) {
      82. $chNm = $row3["m_szGuild"];
      83. $chLv = $row3["m_nLevel"];
      84. $chLogo = $row3["m_dwLogo"];
      85. $chCls = $row3["m_nLose"];
      86. $chmap = $row3["m_nWin"];
      87. ?>
      88. <tr>
      89. <td bgcolor="#FFFFFF" class="submit"><span class="style68">
      90. <?php echo $ctr++; ?>
      91. </span></td>
      92. <td bgcolor="#FFFFFF" class="submit"><span class="style68">
      93. <?php echo $chNm; ?>
      94. </span></td>
      95. <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      96. <?php echo $chLv; ?>
      97. </span></div></td>
      98. <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      99. <?php echo $job->jname($chLogo); ?>
      100. </span></div></td>
      101. <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      102. <?php echo $chCls; ?>
      103. </span></div></td>
      104. <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      105. <?php echo $chmap; ?>
      106. </span></div></td>
      107. </tr>
      108. <?php
      109. }
      110. mssql_close($link);
      111. ?>
      112. <tr>
      113. <td colspan="6" background="bg_tile.gif" bgcolor="#666666">&nbsp;</td>
      114. </tr>
      116. </table>
      Alles anzeigen


      Hier der Script vom Root