bom venho pedir a quem intend desse sistema para verificar ser esta certo o jeito que fiz para zerar o rank mr !
lembrando que esse sistema e do renatin apenas troquei as colunas ..


quero saber ser vai zerar todo mes o rank


global $TABLES_CONFIGS;

$findCharactersQ1 = $this->queryStatement("Select TOP 1 AccountID,Name from ".DATABASE_CHARACTERS.".dbo.Character where CtlCode=0 order by MResets desc, resets desc, cLevel desc");
while($findCharacters1 = mssql_fetch_object($findCharactersQ1))
{
$login1 = $findCharacters1->AccountID;
$char1 = $findCharacters1->Name;
$this->queryStatement("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." = ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." + ".MR_AWARDS1." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']." = '".$login1."'");
$this->queryStatement("UPDATE ". DATABASE_CHARACTERS .".dbo.Character SET MResets = 0 WHERE ". DATABASE_CHARACTERS .".dbo.Character.Name='".$char1."'");
}
$findCharactersQ2 = $this->queryStatement("Select TOP 1 AccountID,Name from ".DATABASE_CHARACTERS.".dbo.Character where CtlCode=0 order by MResets desc, resets desc, cLevel desc");
while($findCharacters2 = mssql_fetch_object($findCharactersQ2))
{
$login2 = $findCharacters2->AccountID;
$char2 = $findCharacters2->Name;
$this->queryStatement("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." = ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." + ".MR_AWARDS2." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']." = '".$login2."'");
$this->queryStatement("UPDATE ". DATABASE_CHARACTERS .".dbo.Character SET MResets = 0 WHERE ". DATABASE_CHARACTERS .".dbo.Character.Name='".$char2."'");
}
$findCharactersQ3 = $this->queryStatement("Select TOP 1 AccountID,Name from ".DATABASE_CHARACTERS.".dbo.Character where CtlCode=0 order by MResets desc, resets desc, cLevel desc");
while($findCharacters3 = mssql_fetch_object($findCharactersQ3))
{
$login3 = $findCharacters3->AccountID;
$char3 = $findCharacters3->Name;
$this->queryStatement("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." = ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." + ".MR_AWARDS3." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']." = '".$login3."'");
$this->queryStatement("UPDATE ". DATABASE_CHARACTERS .".dbo.Character SET MResets = 0 WHERE ". DATABASE_CHARACTERS .".dbo.Character.Name='".$char3."'");
}
$this->queryStatement("UPDATE ". DATABASE_CHARACTERS .".dbo.Character SET MResets = 0");
$this->addSymbol(42, $this->colors['black'], $this->colors['lightgreen']);
$this->addStringImg(50, "Execução bem sucedida.", $this->colors['black']);


settings

define('MR_AWARDS1',150); // Define a premiação para o TOP 1 do MR
define('MR_AWARDS2',75); // Define a premiação para o TOP 2 do MR
define('MR_AWARDS3',35); // Define a premiação para o TOP 3 do MR

desde ja agradeço a quem responder ...

---------- Post added at 08:15 PM ---------- Previous post was at 08:10 PM ----------

tambem queria ve ser essa esta certa para zerar o RESET DIARIO

declare @AccountID varchar(10)
Select top 1 @AccountID=AccountID from character order by ResetsDay desc
Update memb_info set gold=gold+10 where memb___id=@AccountID
update Character set ResetsDay = 0

DESCULPE O floode mas nao tou vendo opção de editar ...