Windows Storage in gesior acc

[marcelao777]

Hi guys, I need to show in my highscores.php ( Gesior acc ) resets the player, just that I store in the storage resets the 36857 in my table (mysql) I need to know how to get this data storage and display in Gesior. in .lua i made function ​​getResets ().

My hightscore.php

<?PHP$list = $_REQUEST['list'];
$page = $_REQUEST['page'];


switch($list){
  case "fist":
   $id = 0;
   $list_name = 'Fist Fighting';
   break;
  case "club":
   $id = 1;
   $list_name = 'Club Fighting';
   break;
  case "sword":
   $id = 2;
   $list_name = 'Sword Fighting';
   break;
  case "axe":
   $id = 3;
   $list_name = 'Axe Fighting';
   break;
  case "distance":
   $id = 4;
   $list_name = 'Distance Fighting';
   break;
  case "shield":
   $id = 5;
   $list_name = 'Shielding';
   break;
  case "fishing":
   $id = 6;
   $list_name = 'Fishing';
   break;
case "reset":
   $id = 6;
   $list_name = 'resets';
   break;
}
if(!isset($id))
    if($list == "magic")
        $list_name = "Magic Level";
    elseif($list == "resets")
        $list_name = "Resets";
    else
    {
        $list_name = 'Experience';
        $list = 'experience';
    
}
$offset = $page * 100;
//jesli chodzi o skilla
if(isset($id)) {
$skills = $SQL->query('SELECT name,value FROM players,player_skills WHERE group_id < '.$config['site']['players_group_id_block'].' AND players.id = player_skills.player_id AND player_skills.skillid = '.$id.' ORDER BY value DESC, count DESC LIMIT 101 OFFSET '.$offset);


}
else
{
//jesli chodzi o level lub mlvl
if($list == "magic") {
$list_name = 'Magic Level';
$skills = $SQL->query('SELECT name,maglevel,experience,resets FROM players WHERE group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY maglevel DESC, manaspent DESC LIMIT 101 OFFSET '.$offset);
}


else
{
$skills = $SQL->query('SELECT name,level,experience,resets FROM players WHERE group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 101 OFFSET '.$offset);
$list_name = 'Experience';
$list = 'experience';
}


}






//wyswietlanie wszystkiego
$main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD><TD><CENTER><H2>TopBr - '.$list_name.' </H2></CENTER><BR><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%></TABLE><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD WIDTH=10% CLASS=whites><B>Rank</B></TD><TD WIDTH=75% CLASS=whites><B>Nome</B></TD><TD WIDTH=15% CLASS=whites><b><center>Skill</center></B></TD>';
if($list == "experience") {
$main_content .= '<TD CLASS=whites><b><center>Pontos</center></B></TD>';
}
if($list == "resets") {
$main_content .= '<TD CLASS=whites><b><center>Resets</center></B></TD>';
}
$main_content .= '</TR><TR>';
foreach($skills as $skill)  {
if($number_of_rows < 100) {
if($list == "magic") {
$skill['value'] = $skill['maglevel'];
}
if($list == "experience") {
$skill['value'] = $skill['level'];
}


if($list == "resets") {
$skill['value'] = $skill['resets'];
}
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td>'.($offset + $number_of_rows).'.</td><td><a href="index.php?subtopic=characters&name='.$skill['name'].'">'.$skill['name'].'</a></td><td><center>'.$skill['value'].'</center></td>';
if($list == "experience") {
$main_content .= '<td><center>'.$skill['experience'].'</center></td>';
}
if($list == "resets") {
$main_content .= '<td><center>'.$skill['resets'].'</center></td>';
}
$main_content .= '</tr>';
}
else
{
$show_link_to_next_page = TRUE;
}
}
$main_content .= '</TABLE><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%>';
//link to previous page if actual page isn't first
if($page > 0) {
$main_content .= '<TR><TD WIDTH=100% ALIGN=right VALIGN=bottom><A HREF="index.php?subtopic=highscores&list='.$list.'&page='.($page - 1).'" CLASS="size_xxs">Previous Page</A></TD></TR>';
}
//link to next page if any result will be on next page
if($show_link_to_next_page) {
$main_content .= '<TR><TD WIDTH=100% ALIGN=right VALIGN=bottom><A HREF="index.php?subtopic=highscores&list='.$list.'&page='.($page + 1).'" CLASS="size_xxs">Next Page</A></TD></TR>';
}
//end of page
$main_content .= '</TABLE></TD><TD WIDTH=5%><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=1 HEIGHT=1 BORDER=0></TD><TD WIDTH=15% VALIGN=top ALIGN=right><TABLE BORDER=0 CELLPADDING=5 CELLSPACING=1><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><a href="?subtopic=highscores&list=reset"><img src="/skills/reset.gif" alt="Reset" style="border-style: none"/><BR><a href="?subtopic=highscores&list=experience"><img src="/skills/level.gif" alt="" style="border-style: none"/><BR><a href="?subtopic=highscores&list=magic"><img src="/skills/ml.gif" alt="" style="border-style: none"/><BR><a href="?subtopic=highscores&list=shield"><img src="/skills/def.gif" alt="" style="border-style: none"/><BR><a href="?subtopic=highscores&list=distance"><img src="/skills/dist.gif" alt="" style="border-style: none"/><BR><a href="?subtopic=highscores&list=club"><img src="/skills/club.gif" alt="" style="border-style: none"/></td><BR><a href="?subtopic=highscores&list=sword"><img src="/skills/sword.gif" alt="" style="border-style: none"/><BR><a href="?subtopic=highscores&list=axe"><img src="/skills/axe.gif" alt="Axe" style="border-style: none"/><br><a href="?subtopic=highscores&list=fist"><img src="/skills/fist.gif" alt="Fist fighting" style="border-style: none"/><BR><a href="?subtopic=highscores&list=fishing"><img src="/skills/fish.gif" alt="" style="border-style: none"/><BR></TD></TR></TABLE></TD><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD></TR></TABLE>';




?>

 

[marcelao777]

bump please!

 

[TGYoshi]

SELECT a.name,b.value.... FROM players a,player_storage b WHERE a.id = b.player_id AND b.`key` = 36857 ...

 

[marcelao777]

where i put this in my hightscores.php ?help me