Lord,Mvp,Gwwinner

Zitat

Lord:
<?php
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 "-";
?>

Alles anzeigen

Zitat

MVP:
<?php
$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 "-";
?>

Alles anzeigen

Zitat

GW Gewinner:
<?php
$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 "-";
?>

Alles anzeigen

Credtis gehen an Jusikid für den Release und an Sedrika :>

Ich würde sagen du musst das in ein Script packen wo schon eine Verbindung zu deinem SQL Server gestartet wurde.