[Req] Resets Stats Script

[ReSpEc7]

Здравейте.
Трябва ми Querry scrypt който да нагласи ресет стаца на геройте смисъл искам да се получи следното:

Когато BK и SM реснат да получават 630x точки на рес 2-ри 1260 и т.н.

А DL,ELF & MG по 700 но незнам как точно да го направя моля ако има някой който да сподели подобен код да удари тук един коментар :

function reset_character()
{
$character = secure($_POST['character']);
$account = secure($_SESSION['user']);

check_inject();

global $resetlevel;
global $resettype;
global $resetpoints;
global $resetmoney;
global $maxresets;

$charq = mssql_query("Select clevel,leveluppoint,money,Resets from Character where name='$character'");
$char = mssql_fetch_row($charq);

$statusaq = mssql_query("select * from MEMB_STAT where memb___id='$account' and connectstat='1'");
$statusa = mssql_num_rows($statusaq);
if($statusa != 0) { $statusq = mssql_query("select GameIDC From AccountCharacter where Id='$account'"); $statusr = mssql_fetch_row($statusq); }

$newresets = $char[3] + 1;
$newmoney = $char[2] - $resetmoney * $char[3];
$newpoints = $newresets * $resetpoints;
$moneyforres = $resetmoney * $newresets;

if(empty($character)) { echo"<tr><td align='center' class='modules'><b>Error:</b> Please select Character !</td></tr>"; $error=1; }
else{
if($statusr[0] == $character) { echo"<tr><td align='center' class='modules'><b>Error:</b> Character $character Is Online ! Please Log Off !</td></tr>"; $error=1; }
if($char[0] < $resetlevel) { echo"<tr><td align='center' class='modules'><b>Error:</b> Character $character haven't got $resetlevel to reset !</td></tr>"; $error=1; }
if($char[2] < $moneyforres) { echo"<tr><td align='center' class='modules'><b>Error:</b> Character $character haven't god enought money to reset !</td></tr>"; $error=1; }
if($newresets > $maxresets) { echo"<tr><td align='center' class='modules'><b>Error:</b> Character $character have reached the maximum resets !</td></tr>"; $error=1; }

if($error != 1) {
echo"<tr><td align='center' class='modules'><span class='online'>Character $character has successfuly reset !</span></td></tr>";
if($resettype == keep) {$mssql = mssql_query("Update Character Set Money='$newmoney',clevel='1',Experience='0',Resets='$newresets' where name='$character'");}
elseif($resettype == bonus) {$mssql = mssql_query("Update Character Set Money='$newmoney',clevel='1',Experience='0',Resets='$newresets',LevelUpPoint='$newpoints' where name='$character'");}
elseif($resettype == reset){$mssql = mssql_query("Update Character Set Strength='25',Dexterity='25',Vitality='25',Energy='25',Money='$newmoney',clevel='1',Experience='0',LevelUpPoint='$newpoints', Resets='$newresets' where name='$character'");}
}}}

 

[DarkMaster]

Пример:

$charq = mssql_query("SELECT cLevel,LevelUpPoint,Money,Resets,Class FROM Character WHERE Name='$character'");
$char = mssql_fetch_row($charq);
// ---
if($char[4] == 0 || $char[4] == 1 || $char[4] == 16 || $char[4] == 17)
{
$newpoints = $newresets * 630;
}
else
{
$newpoints = $newresets * 700;
}
// ---
if($resettype == reset)
{
$mssql = mssql_query("UPDATE Character SET Strength='25',Dexterity='25',Vitality='25',Energy='25',Money='$newmoney',cLevel='1',Experience='0',LevelUpPoint='$newpoints', Resets='$newresets' where name='$character'");
}

 

[ReSpEc7]

Всичко е оправено благодаря на Darko (star) :

Lock