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');
