function CreateSigBatch($lastGeneratedSigId, $sigCount) { global $db, $sigUpdatedCount; $queryString = 'SELECT * FROM ' . DB_TABLE_PREFIX . "data WHERE sigId > {$lastGeneratedSigId} ORDER BY sigId LIMIT {$sigCount}"; $queryResult = $db->Query($queryString); if ($queryResult->num_rows == 0) { exit; } $lastSigId = 0; $debugOutput = ''; while ($userSig = $queryResult->fetch_assoc()) { if (IsTimeEnough()) { $isSigCreated = Sig::Create($userSig['sigId'], $userSig['playerId'], $userSig['bnetServerNum'], $userSig['playerAccount'], $userSig['sigBackgroundIndex'], $userSig['playerStatsIndex'], $userSig['lang'], $userSig['region'], $userSig['characterCode']); $debugOutput .= $userSig['sigId'] . "\n"; $sigUpdatedCount++; $lastSigId = $userSig['sigId']; } else { break; } } SaveNextNum($lastGeneratedSigId, $lastSigId, $debugOutput); }
<?php exit; require_once 'config.php'; require_once 'utils.php'; require_once 'sig.php'; // http://eu.battle.net/sc2/en/profile/248533/1/KageyamA/ // http://eu.battle.net/sc2/ru/profile/222461/1/RAZERiNSo/ // http://eu.battle.net/sc2/en/profile/1951456/1/Mdfst/ladder/29186 // http://eu.battle.net/sc2/en/profile/151411/2/SCIIAntonio/ // http://eu.battle.net/sc2/ru/profile/215861/2/Aaron/ // http://eu.battle.net/sc2/ru/profile/74373/2/BVOne/ // http://eu.battle.net/sc2/ru/profile/2175278/1/BRuǂMakka/ // http://eu.battle.net/sc2/en/profile/3391476/1/IlIlIlIlIlIl/ // http://sc2ranks.com $isSigCreated = Sig::Create('1', 74373, 2, 'BVOne', 13, 2, 'ru', 'EU', 293); // http://us.battle.net/sc2/en/profile/1644048/1/IAmTheWalrus/ //$isSigCreated = $sig->Create( '1', 1644048, 1, 'IAmTheWalrus', 130, 0, 'ru', 'US', 777 ); var_dump($isSigCreated); if ($isSigCreated) { echo '<img src="../1.png">'; } else { echo 'err'; } echo date('H:i', time());
if (!$sigId) { $isPlayerNew = true; $queryString = 'SELECT MAX(sigId) as maxSigId FROM ' . DB_TABLE_PREFIX . 'data'; $queryResult = $db->Query($queryString); if ($queryResult) { $row = $queryResult->fetch_assoc(); $sigId = $row['maxSigId'] + 1; } else { exit; } } if (!($playerId && $bnetServerNum && $playerAccount && $sigBackgroundIndex && isset($playerStatsIndex))) { exit('err'); } require_once 'sig.php'; $isSigCreated = Sig::Create($sigId, $playerId, $bnetServerNum, $playerAccount, $sigBackgroundIndex, $playerStatsIndex, $lang, $region, $characterCode); if ($isSigCreated) { // сохраняем параметры в базу для sigCron.php if ($isPlayerNew) { $queryString = "INSERT INTO " . DB_TABLE_PREFIX . "data\r\n\t\t\t( sigId, playerId, bnetServerNum, playerAccount, sigBackgroundIndex,\r\n\t\t\tplayerStatsIndex, lang, region, characterCode )\r\n\t\t\tvalues(\t'{$sigId}', '{$playerId}', '{$bnetServerNum}', '{$playerAccount}',\r\n\t\t\t'{$sigBackgroundIndex}', '{$playerStatsIndex}', '{$lang}', '{$region}', '{$characterCode}' )"; } else { $queryString = "UPDATE " . DB_TABLE_PREFIX . "data SET\r\n\t\t\tbnetServerNum='{$bnetServerNum}', playerAccount='{$playerAccount}',\r\n\t\t\tsigBackgroundIndex='{$sigBackgroundIndex}', playerStatsIndex='{$playerStatsIndex}',\r\n\t\t\tlang='{$lang}', region='{$region}', characterCode='{$characterCode}'\r\n\t\t\tWHERE sigId='{$sigId}'"; } $result = $db->Query($queryString); if ($result) { echo 'ok;' . $sigId; } else { exit('err'); } } else { exit('err');