What's new

Top 10 exp player

Status
Not open for further replies.

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Prosze o przerobienie skryptu zeby pokazywal top 10 exp na stronie glownej po prawej. Chyba wiadomo o co chodzi?
<!--//koment//-->
<div class="mod-tab">
<div class="module">
<div class="module-2">
<div class="module-3">
<div class="module-4">
<div class="module-5 deepest">
<div class="header-container-1">
<div class="header-container-2">
<div class="header-l"></div>
<div class="header-r"></div>
<h3 class="module"><span class="color">Top 5</span> Players</h3>
</div>
</div>
<div style="overflow: hidden;">
<div>
<div>
<?php
$limitt = 5;
$skills = $SQL->query('SELECT name,level,experience FROM players WHERE group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT '.$limitt)->fetchAll();
$number_of_rows = 0;
foreach($skills as $skillss)
{
$number_of_rows++;
echo '+ <b></b><a href="index.php?subtopic=characters&name='.urlencode($skillss['name']).'" class="menu">'.$skillss['name'].'</a><br>';
echo '<em class="style2">Level: <b>'.urlencode($skillss['level']).'</b></em></li><br />';
}
?> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
Cos takiego jak na:

Dam+
 

vBio

Advanced User
Joined
Sep 9, 2010
Messages
418
Reaction score
67
Odp: Top 10 exp player

?ap:

<!--//koment//-->
<div class="mod-tab">
<div class="module">
<div class="module-2">
<div class="module-3">
<div class="module-4">
<div class="module-5 deepest">
<div class="header-container-1">
<div class="header-container-2">
<div class="header-l"></div>
<div class="header-r"></div>
<h3 class="module"><span class="color">Top 10</span> Players</h3>
</div>
</div>
<div style="overflow: hidden;">
<div>
<div>
<?php
$limitt = 10;
$skills = $SQL->query('SELECT name,level,experience FROM players WHERE group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT '.$limitt)->fetchAll();
$number_of_rows = 0;
foreach($skills as $skillss)
{
$number_of_rows++;
echo '+ <b></b><a href="index.php?subtopic=characters&name='.urlenco de($skillss['name']).'" class="menu">'.$skillss['name'].'</a><br>';
echo '<em class="style2">Level: <b>'.urlencode($skillss['level']).'</b></em></li><br />';
}
?> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

Nieco przerobi?em i gotowe :)

Pozdrawiam,
vBio.
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

Sorki nie chodzilo mi o lvl tylko o expa.
Wchodzisz tam na:

i tam ostatnia tabelka po prawej.
Top 10 Exp
gostek xxxx wbil
+35.551.875 pkt (exp)
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

Help! Bardzo mi to potrzebne!
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

Help! Bardzo mi to potrzebne!
Chyba wiem zeby zmienic top lvl na top exp zmienic cos tu:
echo '<em class="style2">Level: <b>'.urlencode($skillss['level']).'</b></em></li><br />';

Ale co tu mam wpisac zeby pokazywalo expa a od save sie zeruje.
 

vBio

Advanced User
Joined
Sep 9, 2010
Messages
418
Reaction score
67
Odp: Top 10 exp player

Help! Bardzo mi to potrzebne!
Chyba wiem zeby zmienic top lvl na top exp zmienic cos tu:
Ale co tu mam wpisac zeby pokazywalo expa a od save sie zeruje.

To chyba oczywiste, ?e masz tam wpisa? "exp" albo "experience" . Wypr?buj i daj zna? :) Je?eli nie pomo?e to b?d? si? zastanawia? co dalej.
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

@up
Exp nie dziala a experience pokazuje caly exp wbity przez postac czyli
Np na 50 lvl potrzeba 1000000 expa to tam taki pokazuje.
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

@up
Ja juz mam top lvl ale chce pod tym zrobic top exp
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

Refresh! Bardzo mi to potrzebne!
 

Xart Irok

Senior User
Joined
Sep 7, 2008
Messages
2,925
Reaction score
419
Age
32
Odp: Top 10 exp player

PHP:
<!--//koment//-->
<div class="mod-tab">
<div class="module">
<div class="module-2">
<div class="module-3">
<div class="module-4">
<div class="module-5 deepest">
<div class="header-container-1">
<div class="header-container-2">
<div class="header-l"></div>
<div class="header-r"></div>
<h3 class="module"><span class="color">Top 10</span> Players</h3>
</div>
</div>
<div style="overflow: hidden;">
<div>
<div> 
<?php
$limitt = 10;
$skills = $SQL->query('SELECT name,level,experience FROM players WHERE group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1 ORDER BY experience DESC, level DESC LIMIT '.$limitt)->fetchAll();
$number_of_rows = 0;
foreach($skills as $skillss)
{
$number_of_rows++;
echo '+ <b></b><a href="index.php?subtopic=characters&name='.urlenco de($skillss['name']).'" class="menu">'.$skillss['name'].'</a><br>';
echo '<em class="style2">Experience: <b>'.urlencode($skillss['experience']).'</b></em></li><br />';
}
?> </div>
</div> 
</div> 
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
Na szybko zrobione.
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

@up
Nie dziala pokazuje tylko calego expa wbitego przez postac.
 

Xart Irok

Senior User
Joined
Sep 7, 2008
Messages
2,925
Reaction score
419
Age
32
Odp: Top 10 exp player

To o jaki exp ci chodzi, o taki co zosta? nabity w ci?gu dnia czy co.
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

@up
Tak np wciagu 2-4 godzin moze byc i dzien
 

Xart Irok

Senior User
Joined
Sep 7, 2008
Messages
2,925
Reaction score
419
Age
32
Odp: Top 10 exp player

Do tego by? musia? posiada? dodatkowe obci??enie bazy danych, ale je?li chcesz tak nie ma problemu.

Dodajesz to do bazy SQL:
PHP:
ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0';
Potem w GlobalEvents musisz doda? to:
PHP:
function onThink(interval, lastExecution)
    if (tonumber(os.date("%d")) ~= getGlobalStorageValue(23456)) then
        setGlobalStorageValue(23456, (tonumber(os.date("%d"))))
        db.executeQuery("UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience;")
	end
	return TRUE
end
Nast?pnie sw?j plik z top exp musi wygl?da? tak.
PHP:
<!--//koment//--> 
<div class="mod-tab"> 
<div class="module"> 
<div class="module-2"> 
<div class="module-3"> 
<div class="module-4"> 
<div class="module-5 deepest"> 
<div class="header-container-1"> 
<div class="header-container-2"> 
<div class="header-l"></div> 
<div class="header-r"></div> 
<h3 class="module"><span class="color">Top 10</span> Players</h3> 
</div> 
</div> 
<div style="overflow: hidden;"> 
<div> 
<div>  
<?php 
$limitt = 10; 
$skills = $SQL->query('SELECT name,level,experience,exphist1 FROM players WHERE group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1 ORDER BY exphist1 DESC, level DESC LIMIT '.$limitt)->fetchAll(); 
$number_of_rows = 0; 
foreach($skills as $skillss) 
{ 
$number_of_rows++; 
echo '+ <b></b><a href="index.php?subtopic=characters&name='.urlenco de($skillss['name']).'" class="menu">'.$skillss['name'].'</a><br>'; 
echo '<em class="style2">Experience: <b>'.$skillss['exphist1'].'</b></em></li><br />'; 
} 
?> </div> 
</div>  
</div>  
</div> 
</div> 
</div> 
</div> 
</div> 
</div> 
</div> 
</div>
 

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

@up
Co ile bd sie zerowa??
Dam + jak bd wszystko dzia?a? :)
Yy 1 problem
Mam tabelko Power Gamres to tam dobrze pokazuje expa
Ale jak mam ten twoj skrypt to pokazuje
Experience: 0
jak wbilem expa to w power gamers aktulalizuje sie i pokazuje tyle expa ile wbilem a w twoim skrypcie nie,nawet jak zapisalem server i reloglem to tak samo.
 
Last edited:

Oskar1415

Advanced User
Joined
Feb 25, 2009
Messages
381
Reaction score
22
Odp: Top 10 exp player

Refresh!
Caly czas pokazuje:
Experience: 0
Nawet gdy (po expie) relognelem zapisalem serva tez pokazuje
Experience: 0
Dodalem wszystko do bazy SQL.
 
Status
Not open for further replies.
Top