-
Grand Reset problem.
Hello i want to do gr on a site i use old SkyTeam STMP2 files and i have a problem i add grand reset and working perfectly but how to add gr to my ranking ?
Here is my script:
<?
/*-----------------------------------------------------*\
| SkyTeam MuPage file |
| this file is connected with module $page["ranking"] |
| File version 1.2 |
|>1.1 Now form saves itself, and no longer display banned|
|>1.2 display guild name and guild master status |
| by Amelek (szklarzewicz@wp.pl) |
| http://lorencia.com |
\*-----------------------------------------------------*/
if(!defined('SkyTeamPageRUNNING') OR !$page["ranking"])
{
die("Include error..");
}
if($page["use_overlib_in_ranking"])
{
echo '<div id="overDiv" style="position: absolute; visibility: hidden; z-index:1000;width:50;"></div><script src=grafika/overlib.js></script>';
?>
<script>
function do_overlib(name,lvl,res,str,dex,vit,enr)
{
text = "<?=$lang_level?>: "+lvl+"<br><?=$lang_Reset?>: "+res+"<br>";
text += "<?=$lang_Strength?>: "+str+"<br><?=$lang_Dexterity?>: "+dex+"<br>";
text += "<?=$lang_Vitality?>: "+vit+"<br><?=$lang_Energy?>: "+enr;
overlib(text, CAPTION, name);
}
</script>
<?
}
?>
<div style="text-align:center">
<form name=sortowanie method=post action="?strona=ranking">
<br>
<input type=hidden name=strona value=ranking>
<table style="margin:auto;">
<tr><td colspan=6><?= $lang_ranking_order_by ?></td></tr>
<tr>
<td><? echo $lang_Strength; ?></td><td><input type=radio value=str <? if($_POST['prim']== 'str') echo 'checked'; ?> name=prim></td>
<td><? echo $lang_Strength; ?></td><td><input type=radio value=str <? if($_POST['sec']== 'str') echo 'checked'; ?> name=sec checked></td>
<td><? echo $classes[0]; ?></td><td><input type=checkbox name=wizard value=1 <? if($_POST['wizard'] == 1 OR count($_POST) == 0) echo 'checked'; ?>></td>
</tr>
<tr>
<td><? echo $lang_Dexterity; ?></td><td><input type=radio value=agl <? if($_POST['prim']== 'agl') echo 'checked'; ?> name=prim></td>
<td><? echo $lang_Dexterity; ?></td><td><input type=radio value=agl <? if($_POST['sec']== 'agl') echo 'checked'; ?> name=sec></td>
<td><? echo $classes[16]; ?></td><td><input type=checkbox name=knight value=1 <? if($_POST['knight'] == 1 OR count($_POST) == 0) echo 'checked'; ?>></td>
</tr>
<tr>
<td><? echo $lang_Vitality; ?></td><td><input type=radio value=vit <? if($_POST['prim']== 'vit') echo 'checked'; ?> name=prim></td>
<td><? echo $lang_Vitality; ?></td><td><input type=radio value=vit <? if($_POST['sec']== 'vit') echo 'checked'; ?> name=sec></td>
<td><? echo $classes[32]; ?></td><td><input type=checkbox name=elf value=1 <? if($_POST['elf'] == 1 OR count($_POST) == 0) echo 'checked'; ?>></td>
</tr>
<tr>
<td><? echo $lang_Energy; ?></td><td><input type=radio value=enr <? if($_POST['prim']== 'enr') echo 'checked'; ?> name=prim></td>
<td><? echo $lang_Energy; ?></td><td><input type=radio value=enr <? if($_POST['sec']== 'enr') echo 'checked'; ?> name=sec></td>
<td><? echo $classes[48]; ?></td><td><input type=checkbox name=gladiator value=1 <? if($_POST['gladiator'] == 1 OR count($_POST) == 0) echo 'checked'; ?>></td>
</tr>
<tr>
<td><? echo $lang_level; ?></td><td><input type=radio value=lvl <? if($_POST['prim']== 'lvl') echo 'checked'; ?> name=prim></td>
<td><? echo $lang_level; ?></td><td><input type=radio value=lvl <? if($_POST['sec']== 'lvl') echo 'checked'; if(!isset($_POST['sec'])) echo 'checked'; ?> name=sec></td>
<td><? echo $classes[64]; ?></td><td><input type=checkbox name=lord value=1 <? if($_POST['lord'] == 1 OR count($_POST) == 0) echo 'checked'; ?>></td>
</tr>
<tr>
<td><? echo $lang_Reset; ?></td><td><input type=radio value=res <? if($_POST['prim']== 'res') echo 'checked'; if(!isset($_POST['prim'])) echo 'checked'; ?> name=prim></td>
<td><? echo $lang_Reset; ?></td><td><input type=radio value=res <? if($_POST['sec']== 'res') echo 'checked'; ?> name=sec></td>
<td>Start</td><td><input type=text name=start_from title='From witch field show results?' value=<? if(isset($_POST['start_from'])) echo $_POST['start_from']; else echo 0; ?> size=3></td>
</tr>
<tr>
<td>
<select name=sortdir_prim>
<option <? if($_POST['sortdir_prim'] == 'asc') echo 'selected'; ?> value=asc>Asc</option>
<option <? if($_POST['sortdir_prim'] != 'asc') echo 'selected'; ?> value=desc>Desc</option>
</select>
</td><td> </td><td>
<select name=sortdir_sec>
<option <? if($_POST['sortdir_sec'] == 'asc') echo 'selected'; ?> value=asc>Asc</option>
<option <? if($_POST['sortdir_sec'] != 'asc') echo 'selected'; ?> value=desc>Desc</option>
</select>
</td><td> </td>
<td>Show # players</td><td><input type=text name=count_result title='How many result should be shown?' value=<? if(isset($_POST['count_result'])) echo $_POST['count_result']; else echo 25; ?> size=3></td>
</tr>
</table>
<br>
<?
if($page["use_overlib_in_ranking"])
{
if($_POST['show_full_display'])
echo '<input type=checkbox value=1 checked name=show_full_display> '.$lang_show_full_information.'<br>';
else
echo '<input type=checkbox value=1 name=show_full_display> '.$lang_show_full_information.'<br>';
}
?>
<input type="submit" value="<? if(!$use_button_images) echo $lang_sort; ?>" class=rank_sort>
</form>
</div>
<table align=center style="margin:auto;">
<tr class=highlight>
<td align=left> Lp </td>
<td align=left> <? echo $lang_g2_guild; ?> </td>
<td> </td>
<td align=left> <? echo $lang_Name; ?> </td>
<td align=left> <? echo $lang_race; ?> </td>
<td align=left> <? echo $lang_level; ?> </td>
<?
if(!$page["use_overlib_in_ranking"] OR $_POST['show_full_display'])
{
?><td align=left> <? echo $lang_Strength; ?> </td>
<td align=left> <? echo $lang_Dexterity; ?> </td>
<td align=left> <? echo $lang_Vitality; ?> </td>
<td align=left> <? echo $lang_Energy; ?> </td>
<?
}
?>
<td align=left> <? echo $lang_Reset; ?> </td>
<br><tr></tr>
<?php
if(isset($_POST['prim']))
{
settype($_POST['start_from'],'int');
settype($_POST['count_result'],'int');
if($_POST['count_result'] > 300)
echo 'Too many requests';
else
{
$sql = array ('str' => 'Strength',
'agl' => 'Dexterity',
'vit' => 'Vitality',
'enr' => 'Energy',
'lvl' => 'cLevel',
'res' => $res_column_name);
$first = $sql[$_POST['prim']];
$second = $sql[$_POST['sec']];
if(empty($first)) echo 'sort error';
else
{
$first = 'Order By '.$first;
if($_POST['sortdir_prim'] == 'desc') $first .= ' Desc';
elseif($_POST['sortdir_prim'] == 'asc') $first .= ' Asc';
if(!empty($second) AND $second != $sql[$_POST['prim']])
{
$first .= ', '.$second;
if($_POST['sortdir_sec'] == 'desc') $first .= ' Desc';
elseif($_POST['sortdir_sec'] == 'desc') $first .= ' Asc';
}
$klasy = array (
'wizard' => ' Class = 0 OR Class = 1 ',
'knight' => ' Class = 16 OR Class = 17 ',
'elf' => ' Class = 32 OR Class = 33 ',
'gladiator' => ' Class = 48 ',
'lord' => ' Class = 64'
);
$class_add = null;
if(!empty($_POST['wizard']))
$class_add .= $klasy['wizard'];
if(!empty($_POST['knight']))
$class_add .= $klasy['knight'];
if(!empty($_POST['elf']))
$class_add .= $klasy['elf'];
if(!empty($_POST['gladiator']))
$class_add .= $klasy['gladiator'];
if(!empty($_POST['lord']))
$class_add .= $klasy['lord'];
$class_add = str_replace(' ',' OR ',$class_add);
if(empty($class_add))
echo 'Nie wybrano ¿adnej profesji!';
else
{
//echo "SELECT TOP ".($_POST['start_from']+$_POST['count_result'])." Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name FROM Character WHERE (".$class_add.") AND $isadmin_column_name != 1 $first;";
$result = mssql_query("SELECT TOP ".($_POST['start_from']+$_POST['count_result'])." Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name, (SELECT G_Name FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT G_Level FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT ConnectStat FROM MEMB_STAT Where memb___id = Character.AccountId) FROM Character WHERE (".$class_add.") AND $isadmin_column_name <> 1 AND (CtlCode != 1 OR CtlCode IS null) $first;") OR die('Query FAILED');
}
}
}
}
else
$result = mssql_query("SELECT TOP 25 Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name, (SELECT G_Name FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT G_Level FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT ConnectStat FROM MEMB_STAT Where memb___id = Character.AccountId) FROM Character WHERE $isadmin_column_name != 1 AND (CtlCode != 1 OR CtlCode IS null) Order By $res_column_name desc, CLevel desc") OR die('Query FAILED');
if(!empty($result))
{
$a = $_POST['start_from'];
for($i=0;$i<mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
if($i >= $_POST['start_from'])
{
$row[0] = htmlspecialchars ($row[0]);
$row[9] = htmlspecialchars($row[9]);
if ($row[8] != 1)
{
$a = $a+1;
echo '<tr>';
echo '<td align=left>'.$a;
if(!empty($row[9]))
{
if($row[10] == 1)
$row[9] = '<img src=grafika/guild_master_mark.PNG><span class=serw_on>['.$row[9].']</span>';
else
$row[9] = '['.$row[9].']';
echo '<td align=left width=15% style="white-space:nowrap;">'.$row[9].'</td>';
}
else
{
echo '<td align=left width=15% style="white-space:nowrap;"></td>';
}
if($row[11] == 1)
{
echo '<td><img src=grafika/pin_online.gif alt=online></td>';
}
else
{
echo '<td><img src=grafika/pin_offline.gif alt=offline></td>';
}
echo '<td align=left style="white-space:nowrap;"><b>'.$row[0].'</b></td>';
echo '<td align=left>' .$classes[$row[1]].'<b></td>';
echo '<td align=left> '.$row[2].'</td>';
if(!$page["use_overlib_in_ranking"] OR $_POST['show_full_display'])
{
echo '<td align=left> '.$row[3].'</td>';
echo '<td align=left> '.$row[4].'</td>';
echo '<td align=left> '.$row[5].'</td>';
echo '<td align=left> '.$row[6].'</td>';
echo '<td align=left> '.$row[7].'</td>';
}
else
{
echo '<td align=left> '.$row[7].'</td>';
echo '<td class=highlight><a class="forum_link highlight" href=# onClick="return false;" onMouseOver="do_overlib(\''.str_replace('\'','\\\'',$row[0]).'\','.$row[2].','.$row[7].','.$row[3].','.$row[4].','.$row[5].','.$row[6].');" onMouseOut="nd();" >'.$lang_more.'</a></td>';
}
echo '</tr>';
}
}
}
}
?>
</table>
Thanks for any help! :)
