[Help] Devil Square

128ve980

128ve980

Active Member
Joined
Dec 11, 2008
Messages
236
Reaction score
99
This is my Devil Square Ranking... but I have a problem with it. Everything is fine, but classes of characters are not real ... Please help me ..

PHP: 
<?php
require 'config.php';
$msconnect=mssql_connect("$dbhost","$dbuser","$dbpasswd");
$msdb=mssql_select_db("ranking",$msconnect);
$query = "select CharacterName,Class,point from EVENT_INFO  order by point desc";
$result = mssql_query( $query );
echo '<table class=ms border="0" width="480" cellpadding="0" cellspacing="1" align="center">
<tr>
	<td class=mem width=17><center><b>#</center></b></td>
	<td class=mem><center><font size=2><b>Character</center></b></td>
	<td class=mem><center><font size=2><b>Class</center></b></td>
	<td class=mem><center><font size=2><b>Score</center></b></td>';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$rank = $i + 1;

if ($row[1] == 0) { $class = "Dark Wizard"; }
if ($row[1] == 1) { $class = "Soul Master"; }
if ($row[1] == 2) { $class = "Grand Master"; }
if ($row[1] == 16) { $class = "Dark Knight"; }
if ($row[1] == 17) { $class = "Blade Knight"; }
if ($row[1] == 18) { $class = "Blade Master"; }
if ($row[1] == 32) { $class = "Elf"; }
if ($row[1] == 33) { $class = "Muse Elf"; }
if ($row[1] == 34) { $class = "High Elf"; }
if ($row[1] == 48) { $class = "Magic Gladiator"; }
if ($row[1] == 50) { $class = "Duel Master"; }
if ($row[1] == 64) { $class = "Dark Lord"; }
if ($row[1] == 66) { $class = "Lord Emperor"; }

echo"
<tr>
		<td class=mem align='center'>$rank</td>
		<td class=mem align='center'>$row[0]</td>
		<td class=mem align='center'>$class</td>
		<td class=mem align='center'>$row[2]</td>
		</tr>
";
}
?></table>
 
тъй поиграх си малко и ги видях как са, на мястото на твойте класове сложи тва
if ($row[1] == 0) { $class = "Dark Wizard"; }
if ($row[1] == 1) { $class = "Blade Knight"; }
if ($row[1] == 2) { $class = "Muse Elf"; }
if ($row[1] == 3) { $class = "Magic Gladiator"; }

а вече, ако искаш още по подробно трябва да си го направиш по тоя начин
$query = mssql_query("Select * from Character where Name='$row[0]'");
$query = mssql_fetch_assoc($query);
и за $query['Class'] да си словиш там променливи и т.н..
 
Last edited:
Опитай така :)
PHP: 
<?php
require 'config.php';
$msconnect=mssql_connect("$dbhost","$dbuser","$dbpasswd");
$msdb=mssql_select_db("ranking",$msconnect);
$query = "select CharacterName,Class,point from EVENT_INFO  order by point desc";
$result = mssql_query( $query );
$row = mssql_fetch_row($result);
$class = mssql_query(mssql_fetch_array("SELECT * FROM Character WHERE Name='$row[0]'"));
echo '<table class=ms border="0" width="480" cellpadding="0" cellspacing="1" align="center">
<tr>
    <td class=mem width=17><center><b>#</center></b></td>
    <td class=mem><center><font size=2><b>Character</center></b></td>
    <td class=mem><center><font size=2><b>Class</center></b></td>
    <td class=mem><center><font size=2><b>Score</center></b></td>';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$rank = $i + 1;

if ($class[Class] == 0) { $class = "Dark Wizard"; }
if ($class[Class] == 1) { $class = "Soul Master"; }
if ($class[Class] == 2) { $class = "Grand Master"; }
if ($class[Class] == 16) { $class = "Dark Knight"; }
if ($class[Class] == 17) { $class = "Blade Knight"; }
if ($class[Class] == 18) { $class = "Blade Master"; }
if ($class[Class] == 32) { $class = "Elf"; }
if ($class[Class] == 33) { $class = "Muse Elf"; }
if ($class[Class] == 34) { $class = "High Elf"; }
if ($class[Class] == 48) { $class = "Magic Gladiator"; }
if ($class[Class] == 50) { $class = "Duel Master"; }
if ($class[Class] == 64) { $class = "Dark Lord"; }
if ($class[Class] == 66) { $class = "Lord Emperor"; }

echo"
<tr>
        <td class=mem align='center'>$rank</td>
        <td class=mem align='center'>$row[0]</td>
        <td class=mem align='center'>$class</td>
        <td class=mem align='center'>$row[2]</td>
        </tr>
";
}
?></table>
 
Last edited:
Code: 
<?php
require 'config.php';
$msconnect=mssql_connect("$dbhost","$dbuser","$dbpasswd");
$msdb=mssql_select_db("ranking",$msconnect);
$query = "select CharacterName,Class,point from EVENT_INFO  order by point desc";
$result = mssql_query( $query );
echo '<table class=ms border="0" width="480" cellpadding="0" cellspacing="1" align="center">
<tr>
    <td class=mem width=17><center><b>#</center></b></td>
    <td class=mem><center><font size=2><b>Character</center></b></td>
    <td class=mem><center><font size=2><b>Class</center></b></td>
    <td class=mem><center><font size=2><b>Score</center></b></td>';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$rank = $i + 1;

if ($row[1] == 0) { $class = "Dark Wizard"; }
if ($row[1] == 1) { $class = "Soul Master"; }
if ($row[1] == [COLOR="Red"][SIZE="6"]3[/SIZE][/COLOR]) { $class = "Grand Master"; }
if ($row[1] == 16) { $class = "Dark Knight"; }
if ($row[1] == 17) { $class = "Blade Knight"; }
if ($row[1] == [COLOR="Red"][SIZE="6"]19[/SIZE][/COLOR]) { $class = "Blade Master"; }
if ($row[1] == 32) { $class = "Elf"; }
if ($row[1] == 33) { $class = "Muse Elf"; }
if ($row[1] == [COLOR="Red"][SIZE="6"]35[/SIZE][/COLOR]) { $class = "High Elf"; }
if ($row[1] == 48) { $class = "Magic Gladiator"; }
if ($row[1] == 50) { $class = "Duel Master"; }
if ($row[1] == 64) { $class = "Dark Lord"; }
if ($row[1] == 66) { $class = "Lord Emperor"; }

echo"
<tr>
        <td class=mem align='center'>$rank</td>
        <td class=mem align='center'>$row[0]</td>
        <td class=mem align='center'>$class</td>
        <td class=mem align='center'>$row[2]</td>
        </tr>
";
}
?></table>

Това са стандартните кодове. на геройте
 
ivowe3 said:
Code: 
<?php
require 'config.php';
$msconnect=mssql_connect("$dbhost","$dbuser","$dbpasswd");
$msdb=mssql_select_db("ranking",$msconnect);
$query = "select CharacterName,Class,point from EVENT_INFO  order by point desc";
$result = mssql_query( $query );
echo '<table class=ms border="0" width="480" cellpadding="0" cellspacing="1" align="center">
<tr>
    <td class=mem width=17><center><b>#</center></b></td>
    <td class=mem><center><font size=2><b>Character</center></b></td>
    <td class=mem><center><font size=2><b>Class</center></b></td>
    <td class=mem><center><font size=2><b>Score</center></b></td>';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$rank = $i + 1;

if ($row[1] == 0) { $class = "Dark Wizard"; }
if ($row[1] == 1) { $class = "Soul Master"; }
if ($row[1] == [COLOR="Red"][SIZE="6"]3[/SIZE][/COLOR]) { $class = "Grand Master"; }
if ($row[1] == 16) { $class = "Dark Knight"; }
if ($row[1] == 17) { $class = "Blade Knight"; }
if ($row[1] == [COLOR="Red"][SIZE="6"]19[/SIZE][/COLOR]) { $class = "Blade Master"; }
if ($row[1] == 32) { $class = "Elf"; }
if ($row[1] == 33) { $class = "Muse Elf"; }
if ($row[1] == [COLOR="Red"][SIZE="6"]35[/SIZE][/COLOR]) { $class = "High Elf"; }
if ($row[1] == 48) { $class = "Magic Gladiator"; }
if ($row[1] == 50) { $class = "Duel Master"; }
if ($row[1] == 64) { $class = "Dark Lord"; }
if ($row[1] == 66) { $class = "Lord Emperor"; }

echo"
<tr>
        <td class=mem align='center'>$rank</td>
        <td class=mem align='center'>$row[0]</td>
        <td class=mem align='center'>$class</td>
        <td class=mem align='center'>$row[2]</td>
        </tr>
";
}
?></table>

Това са стандартните кодове. на геройте
Click to expand...

Всъщност са на героите от 3-ти сезон (yawn) (wasntme)
 
You must log in or register to reply here.
Top Bottom
Back