versuch mal damit, also komplett einfügen und sag obs klappt :D
Code:
<?php
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$accounts = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL]');
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
$characters = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL]');
$guilds = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [GUILD_TBL]');
$lordquery = odbc_exec($mssql, 'SELECT TOP 1 m_szName FROM [tblLord] a LEFT JOIN CHARACTER_TBL b ON RIGHT(\'0000000\' + CONVERT(VARCHAR(7),a.idLord),7)= b.m_idPlayer ORDER BY s_date DESC');
if(odbc_result($lordquery, 'm_szName') != '') {
$lord = odbc_result($lordquery, 'm_szName');
} else {
$lord = '-';
}
$mvpquery = odbc_exec($mssql, 'SELECT TOP 1 m_szName FROM [tblCombatJoinPlayer] JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = \'30\' ORDER BY JP.CombatID DESC, Point DESC');
if(odbc_result($mvpquery, 'm_szName') != '') {
$mvp = odbc_result($mvpquery, 'm_szName');
} else {
$mvp = '-';
}
$gswinquery = odbc_exec($mssql, 'SELECT TOP 1 m_szGuild FROM [tblCombatJoinGuild] JG LEFT JOIN tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = \'30\' ORDER BY JG.CombatID DESC, Point DESC');
if(odbc_result($gswinquery, 'm_szGuild') != '') {
$gswin = odbc_result($gswinquery, 'm_szGuild');
} else {
$gswin = '-';
}
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');
odbc_exec($mssql, 'USE [LOGGING_01_DBF]');
$peak = odbc_exec($mssql, 'SELECT TOP 1 number FROM [LOG_USER_CNT_TBL] ORDER BY [number] DESC');
odbc_exec($mssql, 'USE [LOGGING_01_DBF]');
?>
<h1>Server Information</h1>
<div class="panel">
<table>
<tr>
</tr>
<iframe src="//www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.facebook.com%2Fpages%2FOMEGA%2F210171415727402&send=false&layout=button_count&width=450&show_faces=true&action=like&colorscheme=light&font&height=21" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:450px; height:21px;" allowTransparency="true"></iframe>
<tr>
<td>Server Zeit:</td>
<td id="srvtime"></td>
</tr>
<tr>
<td>Server Datum:</td>
<td><?php echo date('d.m.Y'); ?></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>Server Status:</td>
<td><div id="srvworld"><img src="./img/load.gif" alt="" /></div></td>
</tr>
<tr>
<td>Server Peak:</td>
<td><?php echo odbc_result($peak, 'number'); ?></td>
</tr>
<tr>
<td>Online User:</td>
<td><?php echo odbc_result($online, 'count'); ?></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>Accounts:</td>
<td><?php echo odbc_result($accounts, 'count'); ?></td>
</tr>
<tr>
<td>Characters:</td>
<td><?php echo odbc_result($characters, 'count'); ?></td>
</tr>
<tr>
<td>Gilden:</td>
<td><?php echo odbc_result($guilds, 'count'); ?></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>EXP Rate:</td>
<td>8000x</td>
</tr>
<tr>
<td>Drop Rate:</td>
<td>8000x</td>
</tr>
<tr>
<td>Penya Rate:</td>
<td>8000x</td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td><img src="img/lord.png" alt=""></td>
<td><?php echo $lord; ?></td>
</tr>
<tr>
<td><img src="img/MVP.png" alt=""></td>
<td><?php echo $mvp; ?></td>
</tr>
<tr>
<td><img src="img/gswin.png" alt=""></td>
<td><?php echo $gswin; ?></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>Teamspeak IP:</td>
<td><li><a href="ts3server://176.28.41.122?port=8888">Klick Me!</a></li></td>
</tr>
</table>
</div>
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/de_DE/all.js#xfbml=1";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<h1>Facebook</h1>
<div class="panel">
<table>
<div class="fb-like" data-href="http://www.facebook.com/pages/Legends-of-Ardunia/345486642149926?sk=wall" data-send="false" data-width="20" data-show-faces="true" data-colorscheme="dark"></div>
</table>
</div>