This is how it's showing up on my index...
[Only registered and activated users can see links. Click Here To Register...]
Heres my code.
PHP Code:
<?php
include("odbc.conf.php");
$odbc_char_con = odbc_connect($odbc['data_cha'],$odbc['user'],$odbc['pass']) or die("Verbinndung zum ODBC Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren.");
$odbc_acc_con = odbc_connect($odbc['data_acc'],$odbc['user'],$odbc['pass']) or die("Verbinndung zum ODBC Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren.");
echo "<center>Player Online List<br>";
echo "<table border='1'>
<tr>
<td align='center'>Char.Name</td>
<td align='center'>Level</td>
<td align='center'>Class</td>
</tr>";
$result1 = odbc_exec($odbc_acc_con,"SELECT user_no FROM account.dbo.USER_PROFILE WHERE login_flag = '1100'");
$classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior");
while(odbc_fetch_row($result1)) {
$user_no = odbc_result($result1,1);
$result2 = odbc_exec($odbc_char_con,"SELECT character_name,wLevel,byPCClass FROM character.dbo.user_character WHERE user_no = '".$user_no."' ORDER by login_time DESC");
$name = odbc_result($result2,1);
$level = odbc_result($result2,2);
$class = odbc_result($result2,3);
if(!preg_match("/[[GM]]/i",$name)) {
echo "<tr>
<td align='center'>".$name."</td>
<td align='center'>".$level."</td>
<td align='center'>".$classes[$class]."</td>
</tr>";
}
}
odbc_close($odbc_char_con);
odbc_close($odbc_acc_con);
echo "</table></center>";
?>
EDIT: Messed with my config. Also now I get this on the page.
Verbinndung zum ODBC Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren