+ Neuer Patcher , Update System , Datenbank , Exen , UserCp , Homepage und vieles mehr ^^
Also da bei ist auch joker Server Exen Fixed und none joker Server Exen Fixed usw ^^ stand os 2013
Liegt an euch und eurem Verhalten ^.^
Hier mal Gem Bug Fix und aka Fix ( Db) und Odinaccounts dbo.taccounts das er die EMID selber macht
Char:
Odinaccount:
Game Exe:
xTrap:
zum CashShop :
Top 100 Spieler Ranking:Quote:
Man kann eig den Athens Cash Shop nehmen man muss nur tchargeItem anpassen , weil es muss in tPurchases gespeichert werden. Wenn ich genug Zeit habe Release ich die Fertige Php! Aber Achtung Cash Shop Bugt auf den Home Servern aber auf Root Servern klappt es perfekt.
PHP Code:
<?php
// CONFIG
$odbc_host = '.\AishiteruGames';
$odbc_user = 'sa';
$odbc_pass = 'sa pw';
// CONFIG END
echo '<h1>Top 100 Player</h1>';
$odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=w00_Character;" , $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 = 'Keine Gilde';
$sID = str_replace ( '?', '†', str_replace ( '?' , 'ä' , str_replace ( '?' , 'Ä' , str_replace ( '?' , 'ö' , str_replace ( '?' , 'Ö' , str_replace ( '?' , 'ü' , str_replace ( '?' , 'Ü' , str_replace ( '?' , 'ß' , $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)
{
//Krieger
case 1:
$nClass = 'Fighter';
break;
case 2:
$nClass = 'CleverFighter';
break;
case 3:
$nClass = 'Warrior';
break;
case 4:
$nClass = 'Gladiator';
break;
case 5:
$nClass = 'Knight';
break;
//Priester
case 6:
$nClass = 'Cleric';
break;
case 7:
$nClass = 'HighCleric';
break;
case 8:
$nClass = 'Paladin';
break;
case 9:
$nClass = 'HolyKnight';
break;
case 10:
$nClass = 'Guardian';
break;
//Jäger
case 11:
$nClass = 'Archer';
break;
case 12:
$nClass = 'HawkArcher';
break;
case 13:
$nClass = 'Scout';
break;
case 14:
$nClass = 'SharpShooter';
break;
case 15:
$nClass = 'Ranger';
break;
//Magier
case 16:
$nClass = 'Mage';
break;
case 17:
$nClass = 'WizMage';
break;
case 18:
$nClass = 'Enchanter';
break;
case 19:
$nClass = 'Warlock';
break;
case 20:
$nClass = 'Wizard';
break;
//Joker
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 = 'Unbekannte Klasse';
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>';
?>
