TopPlayer, TopGilden

<?php

// CONFIG
$odbc_host = 'DingsDa\SQLGERÄT';
$odbc_user = 'sa';
$odbc_pass = 'Dein Passwort';
// CONFIG END

echo '<h1>Top 100 Guilds</h1>';
$odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=w00_charact er;" , $odbc_user , $odbc_pass );

$sql = 'SELECT TOP 100 sName, nWarWinCount, nWarLoseCount, nWarDrawCount FROM tGuild WHERE nDismissStatus = 0 and nType = 1 ORDER BY nWarWinCount DESC';
$rs = odbc_exec ( $odbc_link , $sql );
if ( !$rs )
{
exit ( 'Error in SQL' );
}

$i = 1;

echo '<table width="100%">';
echo ' <tr>';
echo ' <td>';
echo ' #';
echo ' </td>';
echo ' <td>';
echo ' Name';
echo ' </td>';
echo ' <td>';
echo ' Wins';
echo ' </td>';
echo ' <td>';
echo ' Loses';
echo ' </td>';
echo ' <td>';
echo ' Draws';
echo ' </td>';
echo ' </tr>';
while ( odbc_fetch_row ( $rs ) )
{
$sName = odbc_result ( $rs , 'sName' );
$nWarWinCount = odbc_result ( $rs , 'nWarWinCount' );
$nWarLoseCount = odbc_result ( $rs , 'nWarLoseCount' );
$nWarDrawCount = odbc_result ( $rs , 'nWarDrawCount' );

$sID = str_replace ( 'ä' , 'ä' , str_replace ( 'Ä' , '&Auml;' , str_replace ( 'ö' , 'ö' , str_replace ( 'Ö' , '&Ouml;' , str_replace ( 'ü' , 'ü' , str_replace ( 'Ü' , '&Uuml;' , str_replace ( 'ß' , '&szlig;' , $sID ) ) ) ) ) ) );

echo ' <tr>';
echo ' <td>';
echo ' '.$i;
echo ' </td>';
echo ' <td>';
echo ' '.$sName;
echo ' </td>';
echo ' <td>';
echo ' '.$nWarWinCount;
echo ' </td>';
echo ' <td>';
echo ' '.$nWarLoseCount;
echo ' </td>';
echo ' <td>';
echo ' '.$nWarDrawCount;
echo ' </td>';
echo ' </tr>';

$i++;
}

odbc_close ( $odbc_link );

echo '</table>';

?>

<?php

// CONFIG
$odbc_host = 'SQLDingsda\DeinMSSQLServer';
$odbc_user = 'sa';
$odbc_pass = 'Dein Passwort';
// CONFIG END

echo '<h1>Top 100 Players</h1>';
$odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=w00_Charact er;" , $odbc_user , $odbc_pass );

$sql[1] = 'SELECT TOP 100 nCharNo, sID, nExp , nLevel FROM tCharacter WHERE nAdminLevel = 0 AND bDeleted = 0 ORDER BY nExp DESC';
$rs[1] = odbc_exec ( $odbc_link , $sql[1] );
if ( !$rs[1] )
{
exit ( 'Error in SQL' );
}

$i = 1;

echo '<table width="100%">';
echo ' <tr>';
echo ' <td>';
echo ' #';
echo ' </td>';
echo ' <td>';
echo ' Name';
echo ' </td>';
echo ' <td>';
echo ' Exp';
echo ' </td>';
echo ' <td>';
echo ' Level';
echo ' </td>';
echo ' <td>';
echo ' Class';
echo ' </td>';
echo ' <td>';
echo ' Guild';
echo ' </td>';
echo ' </tr>';
while ( odbc_fetch_row ( $rs[1] ) )
{
$sID = odbc_result ( $rs[1] , 'sID' );
$nExp = odbc_result ( $rs[1] , 'nExp' );
$nLevel = odbc_result ( $rs[1] , 'nLevel' );
$nName = 'No Guild';
$sID = str_replace ( '?', '&dagger;', str_replace ( '?' , 'ä' , str_replace ( '?' , '&Auml;' , str_replace ( '?' , 'ö' , str_replace ( '?' , '&Ouml;' , str_replace ( '?' , 'ü' , str_replace ( '?' , '&Uuml;' , str_replace ( '?' , '&szlig;' , $sID ) ) ) ) ) ) ) );

$nCharNo = odbc_result ( $rs[1] , 'nCharNo' );

$sql[2] = 'SELECT TOP 1 nNo FROM tGuildMember WHERE nCharNo = '.$nCharNo;
$rs[2] = odbc_exec ( $odbc_link , $sql[2] );
if ( !$rs[2] )
{
exit ( 'Error in SQL' );
}
while ( odbc_fetch_row ( $rs[2] ) )
{
$nNo = odbc_result ( $rs[2] , 'nNo' );
$sql[3] = 'SELECT TOP 1 sName FROM tGuild WHERE nNo = '.$nNo;
$rs[3] = odbc_exec ( $odbc_link , $sql[3] );
while ( odbc_fetch_row ( $rs[3] ) )
{
$nName = odbc_result ( $rs[3] , 'sName' );
}
}

$sql[4] = 'SELECT TOP 1 nClass FROM tCharacterShape WHERE nCharNo = '.$nCharNo;
$rs[4] = odbc_exec ( $odbc_link , $sql[4] );
if ( !$rs[4] )
{
exit ( 'Error in SQL' );
}
while ( odbc_fetch_row ( $rs[4] ) )
{
$nClass = odbc_result ( $rs[4] , 'nClass' );
}

switch ($nClass)
{
//Fighter
case 1:
$nClass = 'Fighter';
break;
case 2:
$nClass = 'Clever Fighter';
break;
case 3:
$nClass = 'Warrior';
break;
case 4:
$nClass = 'Gladiator';
break;
case 5:
$nClass = 'Knight';
break;

//Cleric
case 6:
$nClass = 'Cleric';
break;
case 7:
$nClass = 'High Cleric';
break;
case 8:
$nClass = 'Paladin';
break;
case 9:
$nClass = 'Holy Knight';
break;
case 10:
$nClass = 'Guardian';
break;

//Jäger
case 11:
$nClass = 'Archer';
break;
case 12:
$nClass = 'Hawk Archer';
break;
case 13:
$nClass = 'Scout';
break;
case 14:
$nClass = 'Sharpshooter';
break;
case 15:
$nClass = 'Ranger';
break;

//Mage
case 16:
$nClass = 'Mage';
break;
case 17:
$nClass = 'Wiz Mage';
break;
case 18:
$nClass = 'Enchanter';
break;
case 19:
$nClass = 'Warlock';
break;
case 20:
$nClass = 'Wizard';
break;

//Trickster
case 21:
$nClass = 'Trickster';
break;
case 22:
$nClass = 'Gambit';
break;
case 23:
$nClass = 'Renegade';
break;
case 24:
$nClass = 'Spectre';
break;
case 25:
$nClass = 'Reaper';
break;

//Standart
default:
$nClass = 'WeilBaum.';
break;
}

echo ' <tr>';
echo ' <td>';
echo ' '.$i;
echo ' </td>';
echo ' <td>';
echo ' '.$sID;
echo ' </td>';
echo ' <td>';
echo ' '.$nExp;
echo ' </td>';
echo ' <td>';
echo ' '.$nLevel;
echo ' </td>';
echo ' <td>';
echo ' '.$nClass;
echo ' </td>';
echo ' <td>';
echo ' '.$nName;
echo ' </td>';
echo ' </tr>';

$i++;
}

odbc_close ( $odbc_link );

echo '</table>';

?>

Top 100 Guilds


Warning: odbc_connect(): in C:\xampp\htdocs\module\rules.php on line 10

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\module\rules.php on line 13
Error in SQL

Top 100 Players


Fatal error: Call to undefined function odbc_connect() in /data/multiserv/users/1156677/projects/2549326/www/module/rules.php on line 10