Sehr gutes Ranking Script

    • Sehr gutes Ranking Script

      Hallo ich ich release hier la ein gutes Ranking Script


      "Ranking Script Mit Gold Anzeige"
      <?php
      include "./config.php";
      ?>
      <table width="100%" border="0" cellpadding="1" cellspacing="1">
      <tr>
      <td height="23" colspan="6" background="sub.jpg"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
      <tr>
      <td><center><?php
      $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      $db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
      $b = '';
      $mail = '';
      $query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
      echo 'Total Accounts: ' . mssql_num_rows($query);
      ?></center></td>
      <td><center><?php
      $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Accout table is missing!");
      $b = '';
      $mail = '';
      $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
      echo 'Total Characters: ' . mssql_num_rows($query);
      ?></center></td>
      </tr>
      </table>
      <div align="center" class="style66">TOP 20 </div></td>
      </tr>
      <tr>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
      <div align="left" class="style72">No.</div> </td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
      <div align="left" class="style72">Name</div> </td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Level</div></td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Class</div></td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Penya</div></td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Location</div></td>
      </tr>

      <?
      $link = mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") ;
      $db = mssql_select_db("CHARACTER_01_DBF");
      // Job Funtion
      function quetrabajo($job){
      if ($job == '0'){
      echo "Vagrant";
      }
      if ($job == '1'){
      echo "Mercenary";
      }
      if ($job == '2'){
      echo "Acrobat";
      }
      if ($job == '3'){
      echo "Assist";
      }
      if ($job == '4'){
      echo "Magician";
      }
      if ($job == '5'){
      echo "Puppeter";
      }
      if ($job == '6'){
      echo "Knight";
      }
      if ($job == '7'){
      echo "Blade";
      }
      if ($job == '8'){
      echo "Jester";
      }
      if ($job == '9'){
      echo "Ranger";
      }
      if ($job == '10'){
      echo "Ringmaster";
      }
      if ($job == '11'){
      echo "billposter";
      }
      if ($job == '12'){
      echo "Psykeeper";
      }
      if ($job == '13'){
      echo "Elementor";
      }
      if ($job == '14'){
      echo "Gatekeeper";
      }
      if ($job == '15'){
      echo "Doppler";
      }
      if ($job == '16'){
      echo "M-Knight";
      }
      if ($job == '17'){
      echo "M-Blade";
      }
      if ($job == '18'){
      echo "M-Jester";
      }
      if ($job == '19'){
      echo "M-Ranger";
      }
      if ($job == '20'){
      echo "M-Ringmaster";
      }
      if ($job == '21'){
      echo "M-Billposter";
      }
      if ($job == '22'){
      echo "M-Psykeeper";
      }
      if ($job == '23'){
      echo "M-Elementor";
      }
      if ($job == '24'){
      echo "H-Knight";
      }
      if ($job == '25'){
      echo "H-Blade";
      }
      if ($job == '26'){
      echo "H-Jester";
      }
      if ($job == '27'){
      echo "H-Ranger";
      }
      if ($job == '28'){
      echo "H-Ringmaster";
      }
      if ($job == '29'){
      echo "H-Billposter";
      }
      if ($job == '30'){
      echo "H-Psykeeper";
      }
      if ($job == '31'){
      echo "H-Elementor";
      }
      }

      // Location Funtion
      function location($loca){
      if ($loca == '1'){
      echo "Madrigal";
      }
      if ($loca == '2'){
      echo "Azria";
      }
      if ($loca == '200'){
      echo "Mars Mine Dungeon";
      }
      if ($loca == '201'){
      echo "Dekane Mines";
      }
      if ($loca == '203'){
      echo "Volcano Entrance";
      }
      if ($loca == '202'){
      echo "Guild War Map";
      }
      if ($loca == '204'){
      echo "Ivillis Dungeon";
      }
      if ($loca == '205'){
      echo "Ivillis Dungeon (Boss)";
      }
      if ($loca == '208'){
      echo "Arena";
      }
      if ($loca == '21'){
      echo "Forsaken B1";
      }
      if ($loca == '22'){
      echo "Forsaken B2";
      }
      if ($loca == '23'){
      echo "Forsaken B3";
      }
      if ($loca == '24'){
      echo "Forsaken B4";
      }
      if ($loca == '25'){
      echo "Forsaken B5";
      }
      if ($loca == '121'){
      echo "OMINOUS";
      }
      if ($loca == '209'){
      echo "Mini Room";
      }
      if ($loca == '3'){
      echo "Coral Island";
      }
      }

      $resTop = mssql_query("SELECT TOP 20 P.m_szName, P.m_nLevel, P.m_nJob, P.m_dwGold, P.dwWorldID FROM CHARACTER_01_DBF.dbo.CHARACTER_TBL P ORDER BY P.m_nLevel DESC, P.m_nExp1 DESC ");
      $ctr = 1;
      while ($row3 = mssql_fetch_array($resTop)){
      $chNm = $row3["m_szName"];
      $chLv = $row3["m_nLevel"];
      $chCls = $row3["m_nJob"];
      $chSc= $row3["m_dwGold"];
      $chmap = $row3["dwWorldID"];

      ?>
      <tr>
      <td bgcolor="#FFFFFF" class="submit"><span class="style68">
      <?=$ctr++;?>
      </span></td>
      <td bgcolor="#FFFFFF" class="submit"><span class="style68">
      <?=$chNm;?>
      </span></td>
      <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      <?=$chLv;?>
      </span></div></td>
      <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      <?=quetrabajo($chCls);?>
      </span></div></td>
      <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      <?=$chSc;?>
      </span></div></td>
      <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      <?=location($chmap);?>
      </span></div></td>
      </tr>
      <?
      }

      ?>
      <tr>
      <td colspan="6" background="bg_tile.gif" bgcolor="#666666">&nbsp;</td>
      </tr>

      </table>


      "Ranking ohne Gold Anzeige"
      <?php
      include "./config.php";
      ?>
      <table width="100%" border="0" cellpadding="1" cellspacing="1">
      <tr>
      <td height="23" colspan="6" background="sub.jpg"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
      <tr>
      <td><center><?php
      $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      $db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
      $b = '';
      $mail = '';
      $query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
      echo 'Total Accounts: ' . mssql_num_rows($query);
      ?></center></td>
      <td><center><?php
      $link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
      $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Accout table is missing!");
      $b = '';
      $mail = '';
      $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
      echo 'Total Characters: ' . mssql_num_rows($query);
      ?></center></td>
      </tr>
      </table>
      <div align="center" class="style66">TOP 20 </div></td>
      </tr>
      <tr>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
      <div align="left" class="style72">No.</div> </td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
      <div align="left" class="style72">Name</div> </td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Level</div></td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Class</div></td>
      <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Location</div></td>
      </tr>

      <?
      $link = mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") ;
      $db = mssql_select_db("CHARACTER_01_DBF");
      // Job Funtion
      function quetrabajo($job){
      if ($job == '0'){
      echo "Vagrant";
      }
      if ($job == '1'){
      echo "Mercenary";
      }
      if ($job == '2'){
      echo "Acrobat";
      }
      if ($job == '3'){
      echo "Assist";
      }
      if ($job == '4'){
      echo "Magician";
      }
      if ($job == '5'){
      echo "Puppeter";
      }
      if ($job == '6'){
      echo "Knight";
      }
      if ($job == '7'){
      echo "Blade";
      }
      if ($job == '8'){
      echo "Jester";
      }
      if ($job == '9'){
      echo "Ranger";
      }
      if ($job == '10'){
      echo "Ringmaster";
      }
      if ($job == '11'){
      echo "billposter";
      }
      if ($job == '12'){
      echo "Psykeeper";
      }
      if ($job == '13'){
      echo "Elementor";
      }
      if ($job == '14'){
      echo "Gatekeeper";
      }
      if ($job == '15'){
      echo "Doppler";
      }
      if ($job == '16'){
      echo "M-Knight";
      }
      if ($job == '17'){
      echo "M-Blade";
      }
      if ($job == '18'){
      echo "M-Jester";
      }
      if ($job == '19'){
      echo "M-Ranger";
      }
      if ($job == '20'){
      echo "M-Ringmaster";
      }
      if ($job == '21'){
      echo "M-Billposter";
      }
      if ($job == '22'){
      echo "M-Psykeeper";
      }
      if ($job == '23'){
      echo "M-Elementor";
      }
      if ($job == '24'){
      echo "H-Knight";
      }
      if ($job == '25'){
      echo "H-Blade";
      }
      if ($job == '26'){
      echo "H-Jester";
      }
      if ($job == '27'){
      echo "H-Ranger";
      }
      if ($job == '28'){
      echo "H-Ringmaster";
      }
      if ($job == '29'){
      echo "H-Billposter";
      }
      if ($job == '30'){
      echo "H-Psykeeper";
      }
      if ($job == '31'){
      echo "H-Elementor";
      }
      }

      // Location Funtion
      function location($loca){
      if ($loca == '1'){
      echo "Madrigal";
      }
      if ($loca == '2'){
      echo "Azria";
      }
      if ($loca == '200'){
      echo "Mars Mine Dungeon";
      }
      if ($loca == '201'){
      echo "Dekane Mines";
      }
      if ($loca == '203'){
      echo "Volcano Entrance";
      }
      if ($loca == '202'){
      echo "Guild War Map";
      }
      if ($loca == '204'){
      echo "Ivillis Dungeon";
      }
      if ($loca == '205'){
      echo "Ivillis Dungeon (Boss)";
      }
      if ($loca == '208'){
      echo "Arena";
      }
      if ($loca == '21'){
      echo "Forsaken B1";
      }
      if ($loca == '22'){
      echo "Forsaken B2";
      }
      if ($loca == '23'){
      echo "Forsaken B3";
      }
      if ($loca == '24'){
      echo "Forsaken B4";
      }
      if ($loca == '25'){
      echo "Forsaken B5";
      }
      if ($loca == '121'){
      echo "OMINOUS";
      }
      if ($loca == '209'){
      echo "Mini Room";
      }
      if ($loca == '3'){
      echo "Coral Island";
      }
      }

      $resTop = mssql_query("SELECT TOP 20 P.m_szName, P.m_nLevel, P.m_nJob, , P.dwWorldID FROM CHARACTER_01_DBF.dbo.CHARACTER_TBL P ORDER BY P.m_nLevel DESC, P.m_nExp1 DESC ");
      $ctr = 1;
      while ($row3 = mssql_fetch_array($resTop)){
      $chNm = $row3["m_szName"];
      $chLv = $row3["m_nLevel"];
      $chCls = $row3["m_nJob"];
      $chmap = $row3["dwWorldID"];

      ?>
      <tr>
      <td bgcolor="#FFFFFF" class="submit"><span class="style68">
      <?=$ctr++;?>
      </span></td>
      <td bgcolor="#FFFFFF" class="submit"><span class="style68">
      <?=$chNm;?>
      </span></td>
      <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      <?=$chLv;?>
      </span></div></td>
      <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      <?=quetrabajo($chCls);?>
      </span></div></td>
      <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
      <?=location($chmap);?>
      </span></div></td>
      </tr>
      <?
      }

      ?>
      <tr>
      <td colspan="6" background="bg_tile.gif" bgcolor="#666666">&nbsp;</td>
      </tr>

      </table>



      Zuletzt auch noch die Config

      "Config für Ranking"
      <?php
      $mssqlcon = "Your Computer Name\SQLEXPRESS";
      $mssqluser = "sa";
      $mssqlpass = "Your mssql password";

      $sv_ip = "xxx.xxx.xxx.xx";
      ?>


      Credits : Imanso für Script
      Ich hab nur Gold Anzeige enfernt ;P


      MFG Luoo

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

    • Zer0;89618 schrieb:

      [COLOR="DarkRed"]Schreib ma localhost [bzw "127.0.0.1"] in die config.
      dann gehts bestimmt net mehr ...      [/COLOR]


      srsly, wenn die Datenbank nicht auf dem localhost ist ist das eigentlich logisch. Ansonsten
      ist deine Aussage einfach nur unüberlegt und zeigt das du weder von SQL, noch von
      irgenteiner Datenbankfähigen Sprache eine Ahnung hast.

      Zum Script, "sehr gut" liegt wohl in diesem Fall im Auge des Betrachters, den ein
      sehr gutes Script sieht anderst aus. Schon alleine das Code und Ausgabe zusammen -
      gewürfelt sind lässt das Script schon weniger als gut erscheinen. Das es nur bedingt
      funktioniert noch schlechter. Und wenn ich dan noch sehe wie das Job und Loaction
      Handling abläuft läufts mir kalt den Rücken runter. Das Script ist nichts besonderes,
      im Gegenteil. Es ist absolutes Mittelmaß wenn nicht sogar noch schlechter.

      Auserdem, ne Frage. Wieviele mssql Verbindungen baut das Script eigentlich auf?
      Ich sehe auf Anhieb 3?


      Schick ma link oder hast du localhost


      Macht nichts, man kann auch auf den localhost eines anderen zugreifen..

    • Warning: mssql_query() [function.mssql-query]: message: Falsche Syntax in der Nähe von ','. (severity 15) in C:\xampp\htdocs\spielerrangliste.php on line 197

      Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\spielerrangliste.php on line 197

      Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\spielerrangliste.php on line 199



      War nen Komma zu viel drin xD.