Hiya all.
I have a question regarding FlyFF offi Mssql query, on where to find the thing to show Server Peak on my website.
I have managed to fix the ranking and the online user count total accounts and total characters, but i cannot find the thing to show Server Peak.
Query for Current Online Users.
PHP
<?php
$link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Account table is missing!");
$b = '';
$mail = '';
$query = mssql_query("SELECT * FROM [ACCOUNT_TBL_DETAIL] WHERE isuse = 'J'");
echo 'Current Online Users: ' . mssql_num_rows($query);
?>Query for Total Accounts and Characters.
PHP
<?php
$link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Account table is missing!");
$b = '';
$mail = '';
$query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
echo 'Total Accounts: ' . mssql_num_rows($query);
?>
<?php
$link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
$db = @mssql_select_db('CHARACTER_01_DBF') or die ("Account table is missing!");
$b = '';
$mail = '';
$query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
echo 'Total Characters: ' . mssql_num_rows($query);
?>Perfect Ranking Script by: lmanso editted by Me and Dha12oks for xampp usage.
PHP
<?php
$link = @mssql_connect("$mssqlcon", "$mssqluser", "$mssqlpass") or die ("Server is down!");
$db = @mssql_select_db('CHARACTER_01_DBF') or die ("Account table is missing!");
// Job Funtion
function currentjob($job){
if ($job == '0'){
echo "Vagrant";
}
if ($job == '1'){
echo "Mercenary";
}
if ($job == '2'){
echo "Acrobat";
}
if ($job == '3'){
echo "Assist";
}
if ($job == '4'){
echo "Magician";
}
if ($job == '5'){
echo "Puppeter";
}
if ($job == '6'){
echo "Knight";
}
if ($job == '7'){
echo "Blade";
}
if ($job == '8'){
echo "Jester";
}
if ($job == '9'){
echo "Ranger";
}
if ($job == '10'){
echo "Ringmaster";
}
if ($job == '11'){
echo "billposter";
}
if ($job == '12'){
echo "Psykeeper";
}
if ($job == '13'){
echo "Elementor";
}
if ($job == '14'){
echo "Gatekeeper";
}
if ($job == '15'){
echo "Doppler";
}
if ($job == '16'){
echo "M-Knight";
}
if ($job == '17'){
echo "M-Blade";
}
if ($job == '18'){
echo "M-Jester";
}
if ($job == '19'){
echo "M-Ranger";
}
if ($job == '20'){
echo "M-Ringmaster";
}
if ($job == '21'){
echo "M-Billposter";
}
if ($job == '22'){
echo "M-Psykeeper";
}
if ($job == '23'){
echo "M-Elementor";
}
if ($job == '24'){
echo "H-Knight";
}
if ($job == '25'){
echo "H-Blade";
}
if ($job == '26'){
echo "H-Jester";
}
if ($job == '27'){
echo "H-Ranger";
}
if ($job == '28'){
echo "H-Ringmaster";
}
if ($job == '29'){
echo "H-Billposter";
}
if ($job == '30'){
echo "H-Psykeeper";
}
if ($job == '31'){
echo "H-Elementor";
}
}
// Location Funtion
function location($loca){
if ($loca == '1'){
echo "Madrigal";
}
if ($loca == '2'){
echo "Azria";
}
if ($loca == '200'){
echo "Mars Mine Dungeon";
}
if ($loca == '201'){
echo "Dekane Mines";
}
if ($loca == '203'){
echo "Volcano Entrance";
}
if ($loca == '202'){
echo "Guild War Map";
}
if ($loca == '204'){
echo "Ivillis Dungeon";
}
if ($loca == '205'){
echo "Ivillis Dungeon (Boss)";
}
if ($loca == '208'){
echo "Arena";
}
if ($loca == '21'){
echo "Forsaken B1";
}
if ($loca == '22'){
echo "Forsaken B2";
}
if ($loca == '23'){
echo "Forsaken B3";
}
if ($loca == '24'){
echo "Forsaken B4";
}
if ($loca == '25'){
echo "Forsaken B5";
}
if ($loca == '121'){
echo "OMINOUS";
}
if ($loca == '209'){
echo "Mini Room";
}
if ($loca == '3'){
echo "Coral Island";
}
}
function no2str($number){
$number = number_format($number,0, ',', ',');
return $number;
}
$query = mssql_query("SELECT TOP 10 m_szName, m_nLevel, dwWorldID, m_nJob, m_dwGold FROM CHARACTER_TBL WHERE m_chAuthority = 'F' ORDER BY m_nLevel DESC, m_nExp1 DESC");
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
$ctr = 1;
while ($row = mssql_fetch_array($query)) {
$loca = $row["dwWorldID"];
$job = $row["m_nJob"];
$number = $row["m_dwGold"];
echo '<table width="100%">';
echo '<tr>';
echo '<td width="1%" style="background: yellow">';
echo '<b>No</b>:';
echo '<hr>';
echo $ctr++;
echo '<hr>';
echo '</td>';
echo '<td width="20%" style="background: yellow">';
echo '<b>Name</b>:';
echo '<hr>';
echo $row['m_szName'];
echo '<hr>';
echo '</td>';
echo '<td width="20%" style="background: yellow">';
echo '<b>Level</b>:';
echo '<hr>';
echo $row['m_nLevel'];
echo '<hr>';
echo '</td>';
echo '<td width="20%" style="background: yellow">';
echo '<b>Class</b>:';
echo '<hr>';
echo currentjob($job);
echo '<hr>';
echo '</td>';
echo '<td width="20%" style="background: yellow">';
echo '<b>Penya</b>:';
echo '<hr>';
echo no2str($number);
echo '<hr>';
echo '</td>';
echo '<td width="20%" style="background: yellow">';
echo '<b>Location</b>:';
echo '<hr>';
echo location($loca);
echo '<hr>';
echo '</td>';
echo '</tr>';
echo '</table>';
}
}
mssql_free_result($query);
?>So as you can see i have most of the query's but still need one more....
Server Peak ;)
If anyone can help me out with this one i would be very happy.
Sincere:
Asgarth aka Murdock29
PS: Credits go to those who made all of this, way to many names.
PPS: Already searched and scouted the whole flyff sections from top to bottom to find it myself first before asking :)