Hier mal wieder ein paar sachen.
Scripts fuer eure HPs da ich Kb mehr hab auf soviele Kindas etc.
[FELD="Char Stats"]zeigt dir Name, Level, Slot, dex, sta, str, int, Gilde an.
xxx
$mssqlConnection = mssql_connect($MSSQL_NAME, $MSSQL_USER, $MSSQL_PW) or die("Konnte nicht mit MSSQL verbinden");
mssql_select_db("CHARACTER_01_DBF", $mssqlConnection) or die("DB nicht gefunden");
$result = mssql_query("SELECT * FROM CHARACTER_TBL WHERE account='".$_SESSION['user']."' ORDER BY m_nLevel ASC") or die("ERROR");
?>
<h1>Charstats</h1>
Hier kanst du ein paar Stastiken deines Chars einsehen.<br>
<center>
<br>
<TABLE CELLSPACING=0 COLS=8 BORDER=0.1 HEIGHT=-2>
<COLGROUP><COL WIDTH=105><COL WIDTH=40><COL WIDTH=50><COL WIDTH=50><COL WIDTH=50><COL WIDTH=50><COL WIDTH=50><COL WIDTH=90></COLGROUP>
<TBODY>
<TR>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Name</font></center></TD>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Slot</font></TD>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Level</font></TD>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Str</font></TD>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Sta</font></TD>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Dex</font></TD>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Int</font></TD>
<TD style="background-color: white;border-bottom: solid grey 1px; border-right: solid grey 1.2px;"><center><font face="Arial" size="-1.6" color="#000000">Gilde</font></TD>
</TR>
<?php
while($resultSet = mssql_fetch_array($result)) {
$result2 = "SELECT * FROM GUILD_MEMBER_TBL WHERE m_idPlayer = '".$resultSet['m_idPlayer']."'" or die ("-");
$resultSet2 = mssql_query($result2);
$findGuildId = mssql_fetch_array($resultSet2);
$guildid = $findGuildId['m_idGuild'];
$result3= "SELECT * FROM GUILD_TBL WHERE m_idGuild = '".$guildid."'" or die ("-");
$resultSet3 = mssql_query($result3);
$findGuild = mssql_fetch_array($resultSet3);
$guildName = $findGuild['m_szGuild'];
?>
<TR>
<TD><font face="Arial" size="-1.6"><?php echo $resultSet['m_szName']; ?></font></TD>
<TD><center><font face="Arial" size="-1.6"><?php echo $resultSet['playerslot']; ?></font></center></TD>
<TD><center><font face="Arial" size="-1.6"><?php echo $resultSet['m_nLevel']; ?></font></center></TD>
<TD><center><font face="Arial" size="-1.6"><?php echo $resultSet['m_nStr']; ?></font></center></TD>
<TD><center><font face="Arial" size="-1.6"><?php echo $resultSet['m_nSta']; ?></font></center></TD>
<TD><center><font face="Arial" size="-1.6"><?php echo $resultSet['m_nDex']; ?></font></center></TD>
<TD><center><font face="Arial" size="-1.6"><?php echo $resultSet['m_nInt']; ?></font></center></TD>
<TD><center><font face="Arial" size="-1.6"><?php echo $findGuild['m_szGuild']; ?></font></center></TD>
</TR>
<?php } ?>
</TBODY>
</TABLE>
</center>
<br>
<?php
echo "</table></center><br /><a href='panel.php'>Zurück</a>";
?>
Credits* 80% Ich 20% Moechte nicht genannt werden.[/FELD]