Homepage|MSSQL Problem

<script language="JavaScript">;

function click (e) {
if (!e)
e = window.event;
if ((e.type && e.type == "contextmenu") || (e.button && e.button == 2) || (e.which && e.which == 3)) {
if (window.opera)
window.alert("Sorry: Diese Funktion ist deaktiviert.");
return false;
}
}
if (document.layers)
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown = click;
document.oncontextmenu = click;
</script>

<br>
<center>



<a href="http://****"><input value="Vote for ****" type="submit"><br></a>









</center><br>



<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>****</title>
<link rel="stylesheet" type="text/css" href="index.php-Dateien/default.css">



<br>

<center>
<img src="index.php-Dateien/logo.png">
</center>
<div class="main">
<a href="?page=register"><img src="index.php-Dateien/register.png" alt="register" style="float: left;"></a>
<a href="?page=downloads"><img src="index.php-Dateien/download.png" alt="Download" style="float: right;"></a>
<br clear="all">
<!-- Logo -->
<div class="logo">

</div>
<!-- Navigation -->

<div class="navigation">
<a href="?page=news"><img src="index.php-Dateien/news.png" alt="News"></a>
<a href="http://****/"><img src="index.php-Dateien/forum.png" alt="Forum"></a>
<a href="?page=events"><img src="index.php-Dateien/events.png" alt="Events"></a>
<a href="?page=chat"><img src="index.php-Dateien/chat1.png" alt="Chat"></a>
<a href="?page=team"><img src="index.php-Dateien/team.png" alt="Team"></a>
<a href="?page=ranking"><img src="index.php-Dateien/ranking.png" alt="Ranking" style="margin: 0pt;"></a>
</div>
<!-- Navigation Ende --> 


<!-- Left Side -->
<div class="left_content">




<!-- TS³ Viewer --><br>
<img src="index.php-Dateien/ts3viewer.png" alt="ServerStatus">
<div class="panel_content">

<div id="ts3viewer_975183" style="width:; background-color:;"> </div>

<script type="text/javascript" src="http://static.tsviewer.com/short_expire/js/ts3viewer_loader.js"></script>

<script type="text/javascript">
<!--

-->
</script>

</script>





</div>
<img src="index.php-Dateien/panel_bottom.png" alt="Bottom">
<!-- TS³ Viewer Ende -->

</div>
<!-- Left Side Ende -->

<!-- Right Side -->
<div class="right_content">
<br>
<!-- Server Rates -->
<img src="index.php-Dateien/serverrates1.png" alt="ServerRates">
<div class="panel_content">
<br><table align="center" border="0">
<b>
<tbody><tr><td><b><h1><font color="#FFF">Exp:</font></h1></b></td><td align="right"><b><h1><font color="#FFF">5000x</font></h1></b></td></tr>
<tr><td><b><h1><font color="#FFF">Drop:</font></h1></b></td><td align="right"><b><h1><font color="#FFF">5000x</font></h1></b></td></tr>
<tr><td><b><h1><font color="#FFF">Penya:</font></h1></b></td><td align="right"><b><h1><font color="#FFF">5000x</font></h1></b></td></tr> </b>
</tbody></table>






</div>
<img src="index.php-Dateien/panel_bottom.png" alt="Bottom">
<!-- Server Rates Ende -->
<a href="?page=donate" style="outline: medium none;"><img src="index.php-Dateien/donate.png" alt="Donate" style="margin-bottom: -10px;"></a>
<br>




<!-- Server Rates -->
<img src="index.php-Dateien/st.png" alt="ServerStatus">
<div class="panel_content">
<table width="160" border="0">

<tr>
<?php
$link = @mssql_connect("****", "****", "****") or die ("Error1!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Keine Accs Vorhanden");
$query = mssql_query("SELECT * FROM [ACCOUNT_TBL_DETAIL] WHERE isuse = 'J' ");
$usersOnline = mssql_num_rows($query);
echo '<td align="left"><h1><b><font color=#FFF0F5>Online:</font></td><td align="right"><h1><font color=#FFF0F5></font> ' . $usersOnline;
echo "</h1></td></b></table></table>";
?>
</tr>
<table width="160" border="0">
<?php
$link = @mssql_connect("****", "****", "****") or die ("Error2!");
$db = @mssql_select_db('LOGGING_01_DBF') or die ("Error!");
$query = mssql_fetch_array(mssql_query("SELECT TOP 1 number FROM LOG_USER_CNT_TBL ORDER BY number DESC"));
$peak = $query[0];
echo '<td align="left"><h1><b><font color=#FFF0F5>Server Peak:</font></td><td align="right"><h1><font color=#FFF0F5></font> ' . $peak;
echo "</h1></td></b></table></table>";
?>
<table width="160" border="0">
<?php
$link = @mssql_connect("****", "****", "****") or die ("Error3!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Keine Accounts vorhanden.");
$query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
echo '<td align="left"><h1><b><font color=#FFF0F5>Accounts:</font></td><td align="right"><h1><font color=#FFF0F5></font> ' . mssql_num_rows($query);
echo "</h1></td></b></table></table>";
?>
</tr>
<tr>
<table width="160" border="0">
<?php
$link = @mssql_connect("****", "****", "****") or die ("Error4!");
$db = @mssql_select_db('CHARACTER_01_DBF') or die ("Keine Chars Vorhanden");
$query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
echo '<td align="left"><h1><b><font color=#FFF0F5>Charakter:</font></td><td align="right"><h1><font color=#FFF0F5></font> ' . mssql_num_rows($query);
echo "</h1></td></b></table></table>";
?>
<table width="160" border="0">
<td align="left"><h1><b><font color=#FFF0F5>Lord:</font></td><td align="right"><h1><font color=#FFF0F5></font>
<?php
$link = @mssql_connect("****", "****", "****") or die ("Server is down!");
mssql_select_db("CHARACTER_01_DBF");
$lord = mssql_fetch_array(mssql_query("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 ($lord['m_szName'] != "")
echo $lord;
else
echo "-";
?>
</h1></td></b></table></table>

<table width="160" border="0">
<tr>
<td align="left"><h1><b><font color=#FFF0F5>Gk:</font></td><td align="right"><h1><font color=#FFF0F5></font>
<?php
$link = @mssql_connect("****", "****", "****") or die ("Server is down!");
mssql_select_db("CHARACTER_01_DBF");
$crown = mssql_fetch_array(mssql_query("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 ($crown['m_szGuild'] != "")
echo $crown[m_szGuild];
else
echo "-";
?> </h1></td></b></table></table>
<tr>
<table width="160" border="0">
<td align="left"><h1><b><font color=#FFF0F5>MvP:</font></td><td align="right"><h1><font color=#FFF0F5></font>
<?php
$link = @mssql_connect("****", "****", "****") or die ("Server is down!");
mssql_select_db("CHARACTER_01_DBF");
$mvp = mssql_fetch_array(mssql_query("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 ($mvp['m_szName'] != "")
echo $mvp[m_szName];
else
echo "-";
?></h1></td></b></table></table>

<br>


<link href="index.php-Dateien/default.css" rel="stylesheet" type="text/css" media="screen">
<b></b><center><b><br><font color="#FFF0F5">- Login Server -</font><br></b>
<img src="index.php-Dateien/online1.png"> <br>
<b></b><center><b><br><font color="#FFF0F5">- Char Server - </font><br></b>
<img src="index.php-Dateien/online1.png"> <br>
<b><br><font color="#FFF0F5">- World Server -</font><br></b>

<img src="index.php-Dateien/online1.png">

<br>
<br>


</center></center></div>
<img src="index.php-Dateien/panel_bottom.png" alt="Bottom">
<!-- Server Rates Ende -->







</div>
<!-- Right Side Ende -->
<!-- Main Content -->
<div class="main_content">
<img src="index.php-Dateien/main_top.png" alt="main_top">
<div class="content">
<div class="gradient">

<link href="http://favicons.de/fvde.ico" rel="SHORTCUT ICON">

<h1>****</h1>


<?php
if($_GET['page'] == "news"){ include("include/news.php"); }


elseif($_GET['page'] == "news"){ include("include/news.php"); }
elseif($_GET['page'] == "events"){ include("include/events.php"); }
elseif($_GET['page'] == "chat"){ include("include/chat.php"); }
elseif($_GET['page'] == "team"){ include("include/team.php"); }
elseif($_GET['page'] == "minigames"){ include("include/minigames.php"); }
elseif($_GET['page'] == "ranking"){ include("include/ranking.php"); }
elseif($_GET['page'] == "downloads"){ include("include/downloads.php"); }
elseif($_GET['page'] == "register"){ include("include/register.php"); }
elseif($_GET['page'] == "donate"){ include("include/donate.php"); }





else{ include("include/news.php"); }
?></font>


</div>
</div>
<img src="index.php-Dateien/main_bottom.png" alt="Bottom">
</div>
<!-- Main Content Ende -->
<!-- Footer -->
<div class="footer">
<h1></h1> <br>
</div>
<!-- Footer Ende -->
</div>






<link href="http://media.xfire.com/xfire/xf/images/icons/flyff.gif" rel="SHORTCUT ICON"></body></html>