Homepage Problem

[™Daywalker]

Hey,

wie schon im Titel steht haben wir ein Problem mit der Homepage unzwar wir haben ein Character Wipe gemacht also die Character_01_DBF gelöscht.
Und jetzt zeigt der auf Online User 0 an weiss jemand woran das liegen ?

Mfg.: Nightr0ad

[Sticky.]

Lösch die Website_DBF und füg sie nochmal ein dann müsste es gehen

[BattleTale]

sind denn wieder User Online gewesen?

Lösch die Website_DBF und füg sie nochmal ein dann müsste es gehen

wtf? was soll das mit der WEBSITE_DBF zu tun haben?!

[™Daywalker]

Wie meinst du das meinste nach dem Wipe?

[BattleTale]

jo, ob nach dem wipe wieder user drauf waren ?

Aber überlege grade woran das lag, bei mir war das auch mal

[Sticky.]

das war bei mir auch so..

musst website löcshen und wider reinmachen WEBSITE_DBF

[BattleTale]

Alter aber sag mir mal was das mit der WEBSITE_DBF zu tun haben soll?!

Schonmal was von denken gehört?

[™Daywalker]

Ja danach waren weider User drauf server peak funktioniert komischer weise..

[BattleTale]

poste mal bitte deine funktion mit Online User:

[™Daywalker]

 odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
	   $select = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE MultiServer != \'0\'');
	
	   <tr>
           <td>Online User:</td>
           <td><?php echo odbc_num_rows($select);?></td>
           </tr>

[BattleTale]

Zeig mir mal pls die ganze info.panel.php ( benutz ja ne Pfeifer ), weil das auch was mit der anordnung so war, hatte das Problem auch mal.

[™Daywalker]

 Spoiler

<?php
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
$select = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE MultiServer != \'0\'');


odbc_exec($mssql, 'USE [LOGGING_01_DBF]');
$peak = odbc_exec($mssql, 'SELECT TOP 1 number FROM [LOG_USER_CNT_TBL] ORDER BY [number] DESC');
?>
<?php
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$accounts = odbc_exec($mssql, 'SELECT * FROM [ACCOUNT_TBL]');
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');

$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 = '-';
}
?>
<h1>Server Information</h1>
<div class="panel">
<table>
<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 colspan="2"><br /></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_num_rows($select);?></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>EXP Rate:</td>
<td>300x</td>
</tr>
<tr>
<td>Drop Rate:</td>
<td>200x</td>
</tr>
<tr>
<td>Penya Rate:</td>
<td>800x</td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>Teamspeak:</td>
<td><li><a href="ts3server://176.28.41.122?port=8888">Klick Me!</a></li></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>Lord:</td>
<td><?php echo $lord; ?></td>
</tr>
<tr>
<td>MVP:</td>
<td><?php echo $mvp; ?></td>
</tr>
<tr>
<td>GS Winner:</td>
<td><?php echo $gswin; ?></td>
</tr>
<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>

[BattleTale]

versuch mal damit, also komplett einfügen und sag obs klappt

<?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>

[™Daywalker]

Nö, das geht auch nicht

[BattleTale]

hm, dann liegt das vllt an der CHARACTER_01_DBF ?

habt ihr danach nochmal geguckt wegen den ODBC? vllt mal die alter character_01 in ODBC löschen und neu machen?