Ranking code.and beta script rebirth

Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. 10-11-09 #1
    lmanso
    Account Upgraded | Title Enabled! lmanso is offline
    MemberRank
    Jun 2008 Join Date
    ThailandLocation
    241Posts

    Ranking code.and beta script rebirth

    Files
    - config.php
    - ranking.php

    Screen : http://www.uppicweb.com/i/it/oyaha.jpg

    First (config.php)
    PHP Code:
    <?php
    // MSSQL Database Setting
    $host = "COMPUTERNAME\SQLEXPRESS"; // You MSSQL Host name
    $user = "sa"; // You user of mssql example : sa
    $pass = "yourpassword"; // You password of mssql
    $dbad = "CHARACTER_01_DBF"; // You character database
    ?>

    You gotna take this code to somewhere on you page.
    PHP Code:
    <?php
            include "./config.php";
    ?>

    Then Try out with this all code


    - Character Count , User Count , Player Ranking code
    PHP Code:
    <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("$host", "$user", "$pass") 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("$host", "$user", "$pass") 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">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("$host", "$user", "$pass") ;
                $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");

    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">
                <?=$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>
    - Top Rich Player
    PHP Code:
    <table width="100%" border="0" cellpadding="1" cellspacing="1">
                      <tr>
                        <td height="23" colspan="6" background="sub.jpg"><div align="center" class="style66">TOP 20 Rich Man </div></td>
                      </tr>
                      <tr>
                        <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("$host", "$user", "$pass") ;
                $db = mssql_select_db("CHARACTER_01_DBF");
    $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_dwGold DESC");

    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">
                          <?=$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>
    - Guild Ranking
    PHP Code:
    <table width="100%" border="0" cellpadding="1" cellspacing="1">
                      <tr>
                        <td height="23" colspan="6" background="sub.jpg"><div align="center" class="style66">TOP 5 Guild Ranking </div></td>
                      </tr>
                      <tr>
                        <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="left" class="style72">Guild 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">Win</div></td>
                        <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Lose</div></td>
                        <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Give Up</div></td>
                      </tr>
                      <?
            $link     = mssql_connect("$host", "$user", "$pass") ;
                $db = mssql_select_db("CHARACTER_01_DBF");
    $resTop = mssql_query("SELECT TOP 5 P.m_szGuild, P.m_nLevel, P.m_nWin, P.m_nLose, P.m_nSurrender FROM CHARACTER_01_DBF.dbo.GUILD_TBL P ORDER BY P.m_nWin DESC, P.m_nLose DESC, m_nLevel");

    while (    $row3 = mssql_fetch_array($resTop)) {
            $chNm = $row3["m_szGuild"];
            $chLv = $row3["m_nLevel"];
            $chCls = $row3["m_nWin"];
            $chSc= $row3["m_nLose"];
            $chmap = $row3["m_nSurrender"];

    ?>
                      <tr>
                        <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">
                            <?=$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">
                            <?=$chmap;?>
                        </span></div></td>
                      </tr>
                      <?
    }

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

    TIP : for who want to change top count just search SELECT TOP 20 line Change 20 to what ever you want it


    CREDIT
    - rakter [for account , user count]


    ________________________________________________________________________________________________
    Beta Auto Rebirh script
    Code:
    CREATE TRIGGER [dbo].[Auto_Reborn] ON [dbo].[CHARACTER_TBL]
after update
as
BEGIN

Update [CHARACTER_TBL] set [CHARACTER_TBL].ChaReborn = 0

Update [CHARACTER_TBL] set [CHARACTER_TBL].m_nLevel=60, -- Level that you get after reborn
[CHARACTER_TBL].ChaReborn=[CHARACTER_TBL].ChaReborn + 1, -- Reborn counter
[CHARACTER_TBL].m_nExp1=0, -- Set Exp back to 0
[CHARACTER_TBL].m_aCompleteQuest = NULL -- Delete all quest
From Inserted
Where Inserted.m_nLevel = 121 -- Level to reborn
and [CHARACTER_TBL].ChaReborn < 10 -- Max Reborn number
and [CHARACTER_TBL].m_szName=inserted.m_szName 
and [CHARACTER_TBL].account =inserted.account
and [CHARACTER_TBL].m_dwGold >= 2000000 -- Optional : Require 2m gold for reborn

End
    How to :
    1.Open SQL Server Management Studio Express and than go to CHARACTER_01_DBF and left and select Modify on CHARACTER_TBL
    2.On under line insert ChaReborn on Column Name and than int on Data type and alow null and than save it.
    3.Left click on CHARACTER_01_DBF and click New Query and copy this code and Execute it

    ps. I'm not sure this code is working all.

    Heaven ^^
    Last edited by lmanso; 10-11-09 at 11:18 PM.
  2. Check out our sponsor
    Ranking code.and beta script rebirth
  3. 10-11-09 #2
    Luxury
    Mr.Luxury :D, DeadlyD Wuz Here. Luxury is offline
    MemberRank
    Jan 2009 Join Date
    LuxuryFlyffLocation
    355Posts

    Re: Ranking code.and other

    Very helpful thanks.
  4. 10-11-09 #3
    rakter
    Account Upgraded | Title Enabled! rakter is offline
    MemberRank
    Oct 2008 Join Date
    200Posts

    Re: Ranking code.and beta script rebirth

    Nice, Good Job, thanks to take credits to me ;)
  5. 11-11-09 #4
    jason145
    Account Upgraded | Title Enabled! jason145 is offline
    MemberRank
    Sep 2008 Join Date
    My Computer, AULocation
    350Posts

    Re: Ranking code.and beta script rebirth

    Very nice. Well done. :D
  6. 11-11-09 #5
    AccountDeleted
    Account Upgraded | Title Enabled! AccountDeleted is offline
    MemberRank
    Jul 2008 Join Date
    296Posts

    Re: Ranking code.and beta script rebirth

    1. Your PHP code is wayyyyy too sloppy, learn what an array is.

    2. Re-birth most likely will not work without the server restarting first after the values are modified, not to mention the fact the server will start to bug out if not crash when you attempt to add stats higher then they should be when the player is a certain level.
  7. 11-11-09 #6
    jason145
    Account Upgraded | Title Enabled! jason145 is offline
    MemberRank
    Sep 2008 Join Date
    My Computer, AULocation
    350Posts

    Re: Ranking code.and beta script rebirth

    Quote Originally Posted by DeadlyData View Post
    1. Your PHP code is wayyyyy too sloppy, learn what an array is.

    2. Re-birth most likely will not work without the server restarting first after the values are modified, not to mention the fact the server will start to bug out if not crash when you attempt to add stats higher then they should be when the player is a certain level.
    Would that explain the reason my GM's are always bugging them selves. Stats to high
  8. 11-11-09 #7
    Caith1991
    Apprentice Caith1991 is offline
    MemberRank
    Mar 2008 Join Date
    14Posts

    Re: Ranking code.and beta script rebirth

    Okay I show you how to make your script easier with arrays an less rows
    Code:
    <?php
/*
Here comes your config.php include
*/

$class=array(
"0"=>"Vagrant",
"1"=>"Mercenary",
"2"=>"Acrobat",
"3"=>"Assist",
"4"=>"Magican",
"6"=>"Knight",
"7"=>"Blade",
"8"=>"Jester",
"9"=>"Ranger",
"10"=>"Ringmaster",
"11"=>"Billposster",
"12"=>"Psykeeper",
"13"=>"Elementor",
"16"=>"M-Knight",
"17"=>"M-Blade",
"18"=>"M-Jester",
"19"=>"M-Ranger",
"20"=>"M-Ringmaster",
"21"=>"M-Billposter",
"22"=>"M-Psykeeper",
"23"=>"M-Elementor",
"24"=>"H-Knight",
"25"=>"H-Blade",
"26"=>"H-Jester",
"27"=>"H-Ranger",
"28"=>"H-Ringmaster",
"29"=>"H-Billposter",
"30"=>"H-Psykeeper",
"31"=>"H-Elementor"
);

$loca=array(
"1"=>"Madrigal",
"2"=>"Azria",
"3"=>"coral Island",
"21"=>"Forsaken B1",
"23"=>"Forsaken B2",
"23"=>"Forsaken B3",
"24"=>"Forsaken B4",
"25"=>"Forsaken B5",
"121"=>"OMINOUS",
"200"=>"Mars Mine Dungeon",
"201"=>"Dekane Mines",
"202"=>"Guild War Map",
"203"=>"Volcano Entrance",
"204"=>"Ivillis Dungeon",
"205"=>"Ivillis Dungeon (Boss)",
"208"=>"Arena",
"209"=>"Mini Room"
);

$link = @mssql_connect("$host", "$user", "$pass") or die ("Server is down!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Tables are missing!");
$query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
$aaccounts = mssql_num_rows($query);
$db = mssql_select_db("CHARACTER_01_DBF") or die ("Tables are missing!");
$query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
$acharacters = mssql_num_rows($query);

echo'
<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>Total Accounts:'.$aaccounts.'</center>
					</td>
					<td>
					<td>
						<center>Total Characters:'.$acharacters.'</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">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>';
$query = mssql_query("SELECT TOP 20 * FROM CHARACTER_01_DBF WHERE m_chAuthority = 'F' ORDER by m_nLevel DESC, m_nExp1 DESC");
while ($row = mssql_fetch_array($query)) {
	echo'
	<tr>
		<td bgcolor="#FFFFFF" class="submit"><span class="style68">'.$row['m_szName'].'</td>
		<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">'.$row['m_nLevel'].'</span></div></td>
		<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">'.$class['m_nJob'].'</span></div></td>
		<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">'.$row['m_dwGold'].'</span></div></td>
		<td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">'.$loca['dwWorldID'].'</span></div></td>
        </tr>';
}
mssql_close();
?>
	<tr>
		<td colspan="6" background="bg_tile.gif" bgcolor="#666666">&nbsp;</td>
	</tr>
</table>
    You see I made it from 227 rows, down to just 107 rows.
    over 50% less code

    Please post any ideas
    Last edited by Caith1991; 11-11-09 at 06:11 AM.
  9. 11-11-09 #8
    rakter
    Account Upgraded | Title Enabled! rakter is offline
    MemberRank
    Oct 2008 Join Date
    200Posts

    Re: Ranking code.and beta script rebirth

    I fix the rich ranking :
    PHP Code:
    <table width="100%" border="0" cellpadding="1" cellspacing="1">
                      <tr>
                        <td height="23" colspan="6" background="sub.jpg"><div align="center" class="style66">TOP 20 Rich Man </div></td>
                      </tr>
                      <tr>
                        <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("$host", "$user", "$pass") ;
                $db = mssql_select_db("CHARACTER_01_DBF");
    $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_dwGold DESC");

    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">
                          <?=$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">
                            <?=$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">
                            <?=$chmap;?>
                        </span></div></td>
                      </tr>
                      <?
    }

    ?>
                      <tr>
                        <td colspan="6" background="bg_tile.gif" bgcolor="#666666">&nbsp;</td>
                      </tr>
                    </table>
    Last edited by rakter; 11-11-09 at 08:12 AM.
  10. 11-11-09 #9
    Baffis
    Apprentice Baffis is offline
    MemberRank
    May 2009 Join Date
    15Posts

    Re: Ranking code.and beta script rebirth

    Hello,
    I have test Rich page but i have no ranking.

    PHP Code:
    <?php
            require('./config.php');
    ?> 
    <table width="100%" border="0" cellpadding="1" cellspacing="1">
                      <tr>
                        <td height="23" colspan="6" background="sub.jpg"><div align="center" class="style66">TOP 20 Rich Man </div></td>
                      </tr>
                      <tr>
                        <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("$host", "$user", "$pass") ;
                $db = mssql_select_db("CHARACTER_01_DBF");
    $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_dwGold DESC");

    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">
                          <?=$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">
                            <?=$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">
                            <?=$chmap;?>
                        </span></div></td>
                      </tr>
                      <?
    }

    ?>
                      <tr>
                        <td colspan="6" background="bg_tile.gif" bgcolor="#666666">&nbsp;</td>
                      </tr>
                    </table>
  11. 11-11-09 #10
    rakter
    Account Upgraded | Title Enabled! rakter is offline
    MemberRank
    Oct 2008 Join Date
    200Posts

    Re: Ranking code.and beta script rebirth

    You take good configuration in config.php ?
  12. 11-11-09 #11
    BBim
    Account Upgraded | Title Enabled! BBim is offline
    MemberRank
    Sep 2008 Join Date
    127.0.0.1Location
    1,110Posts

    Re: Ranking code.and beta script rebirth

    A ranking that shows player's penya? I wouldnt bother to play on a server like that, its enough "penya pl0x" just by looking at your equips, looking at your actual penya would be even worse.
  13. 14-11-09 #12
    Mootie
    Not working on UnitedFlyf Mootie is offline
    MemberRank
    Apr 2009 Join Date
    1,589Posts

    Re: Ranking code.and beta script rebirth

    [QUOTE=Caith1991;5361486]
    $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
    ?>

    Most common php mistake...Selecting ALL from a large table will always make your website extremely slow, especially on bigger servers. Not to mention that the mssql_query is a pretty slow data retrieval method. For large queries you probably want to use ADOdb, which is a php library that is pretty simple to install and use. Link: http://adodb.sourceforge.net/
  14. 14-11-09 #13
    Mohanddo
    Valued Member Mohanddo is offline
    MemberRank
    Dec 2008 Join Date
    114Posts

    Re: Ranking code.and beta script rebirth

    [quote=mootie;5367336]
    Quote Originally Posted by Caith1991 View Post
    $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
    ?>

    Most common php mistake...Selecting ALL from a large table will always make your website extremely slow, especially on bigger servers. Not to mention that the mssql_query is a pretty slow data retrieval method. For large queries you probably want to use ADOdb, which is a php library that is pretty simple to install and use. Link: http://adodb.sourceforge.net/
    Mootie do you know any MSSQL libraries for C++ except SQLAPI++ which you have to buy?
  15. 15-11-09 #14
    rocwar
    Apprentice rocwar is offline
    MemberRank
    Oct 2009 Join Date
    9Posts

    Re: Ranking code.and beta script rebirth

    Hello everybody, I wanted to know how to lock in the ranking, only appear to the players and take adm and gm's!

    Thanks
  16. 15-11-09 #15
    russhimi
    Account Upgraded | Title Enabled! russhimi is offline
    MemberRank
    Sep 2008 Join Date
    somewhereLocation
    587Posts

    Re: Ranking code.and beta script rebirth

    thx mate


Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Advertisement