Thanks

Worff
http://www.tribalfury.org/eqroster
Code: Select all
// Retrieve all the maximum overview values of this overview
$nResult = mysql_query( $strSelectOverviewMaxQuery, $nLinkID );
// Store the values
if( $aResult = mysql_fetch_row( $nResult ) )
{
// Retrieve the variables out of the array
$nIndex = 0;
$this->nOverviewMaxHP = $aResult[$nIndex++];
$this->nOverviewMaxMana = $aResult[$nIndex++];
$this->nOverviewMaxEndurance = $aResult[$nIndex++];
$this->nOverviewMaxAC = $aResult[$nIndex++];
$this->nOverviewMaxFT = $aResult[$nIndex++];
$this->nOverviewMaxRegen = $aResult[$nIndex++];
$this->nOverviewMaxAtk = $aResult[$nIndex++];
$this->nOverviewMaxStr = $aResult[$nIndex++];
$this->nOverviewMaxSta = $aResult[$nIndex++];
$this->nOverviewMaxAgi = $aResult[$nIndex++];
$this->nOverviewMaxDex = $aResult[$nIndex++];
$this->nOverviewMaxWis = $aResult[$nIndex++];
$this->nOverviewMaxInt = $aResult[$nIndex++];
$this->nOverviewMaxCha = $aResult[$nIndex++];
$this->nOverviewMaxPR = $aResult[$nIndex++];
$this->nOverviewMaxMR = $aResult[$nIndex++];
$this->nOverviewMaxDR = $aResult[$nIndex++];
$this->nOverviewMaxFR = $aResult[$nIndex++];
$this->nOverviewMaxCR = $aResult[$nIndex++];
}
Code: Select all
print( $strSelectQuery );
// Retrieve all the records
$nResult = mysql_query( $strSelectQuery, $nLinkID );
// Show the records one by one
Code: Select all
SELECT CharName, NameMain, EQPlayersCharID, MageloNr, HP, Mana, Endurance, AC, FlowingThought, Regen, Atk, Str, Sta, Agi, Dex, Wis, `Int`, Cha, PR, MR, DR, FR, CR, OldMember FROM Characters WHERE ( HP > 0 OR Mana > 0 OR Endurance > 0 OR AC > 0 OR FlowingThought > 0 OR Regen > 0 OR Atk > 0 OR Str > 0 OR Sta > 0 OR Agi > 0 OR Dex > 0 OR Wis > 0 OR `Int` > 0 OR Cha > 0 OR PR > 0 OR MR > 0 OR DR > 0 OR FR > 0 OR CR > 0 ) AND ((GuildStatus != 'Alt' AND GuildStatus != 'Inactive') OR NameMain = '') ORDER BY 'CharName' , CharName
Code: Select all
SELECT CharName, NameMain, EQPlayersCharID, MageloNr, HP, Mana, Endurance, AC, FlowingThought, Regen, Atk, Str, Sta, Agi, Dex, Wis, `Int`, Cha, PR, MR, DR, FR, CR, OldMember FROM Characters WHERE ( HP > 0 OR Mana > 0 OR Endurance > 0 OR AC > 0 OR FlowingThought > 0 OR Regen > 0 OR Atk > 0 OR Str > 0 OR Sta > 0 OR Agi > 0 OR Dex > 0 OR Wis > 0 OR `Int` > 0 OR Cha > 0 OR PR > 0 OR MR > 0 OR DR > 0 OR FR > 0 OR CR > 0 ) AND ((GuildStatus != 'Alt' AND GuildStatus != 'Inactive') OR NameMain = '') ORDER BY 'HP' DESC, CharName
Code: Select all
SELECT CharName, NameMain, EQPlayersCharID, MageloNr, HP, Mana, Endurance, AC, FlowingThought, Regen, Atk, Str, Sta, Agi, Dex, Wis, `Int`, Cha, PR, MR, DR, FR, CR, OldMember FROM Characters WHERE ( HP > 0 OR Mana > 0 OR Endurance > 0 OR AC > 0 OR FlowingThought > 0 OR Regen > 0 OR Atk > 0 OR Str > 0 OR Sta > 0 OR Agi > 0 OR Dex > 0 OR Wis > 0 OR `Int` > 0 OR Cha > 0 OR PR > 0 OR MR > 0 OR DR > 0 OR FR > 0 OR CR > 0 ) AND ((GuildStatus != 'Alt' AND GuildStatus != 'Inactive') OR NameMain = '') ORDER BY 'HP' , CharName
Users browsing this forum: No registered users and 1 guest