private function _GetSlotHours(&$bdata)
{
if ($bdata['placegap']) {
switch ($bdata['placegaptype']) {
case 1:
//minute
return MIN($bdata['placegap'] / 60, 24.0);
case 2:
//hour
return MIN((double) $bdata['placegap'], 24.0);
case 3:
//>= day
//>= day
case 4:
case 5:
case 6:
return 24.0;
default:
break;
}
}
//TODO if $bdata['startdate'] to $bdata['enddate'] short/< N days
// assume nominated values are hours, return appropriate value
return 0.0;
}
function page($total = 0, $everpage = 10, $query = array())
{
$this->total = $this->totalItems = $total;
$this->everpage = $everpage;
$this->pages = max(1, abs(ceil($total / $everpage)));
$this->currentPage = max((int) $_GET['pageID'], 1);
//2
$num = ceil(3 / 2);
$this->max = MIN(MAX($this->currentPage + $num, 3), $this->pages);
$this->min = MAX(MIN($this->currentPage - $num, $this->pages - 3), 1);
$this->limit_1 = ($this->currentPage - 1) * $this->everpage;
$this->limit_2 = $this->everpage;
$this->limit_3 = $this->currentPage * $this->everpage;
$this->num_1 = '';
$this->num_3 = ' LIMIT ' . $this->limit_1 . ',' . $this->limit_2;
}
public static function employee($D, $params)
{
$D['24'] = $params->def('field_53', 1);
$D['25'] = $params->def('field_54', 1);
$D['26'] = $params->def('field_55', 1);
$D['27'] = $params->def('field_56', 1);
$year = $params->def('field_67', 1);
$D['28'] = (int) (25569 + strtotime("{$year} 12:00:00") / 86400);
$D['29'] = $params->def('field_70', 1);
$D['30'] = $params->def('field_71', 1);
/*
* Set Parameters
*/
$D['5'] = $D['28'];
$resignation = $D['6'];
$intoservice = $D['7'];
$D['6_'] = $resignation;
$D['7_'] = $intoservice;
$D['6'] = (int) (25569 + strtotime("{$resignation} 12:00:00") / 86400);
$D['7'] = (int) (25569 + strtotime("{$intoservice} 12:00:00") / 86400);
$D['8'] = ($D['6'] - $D['7']) / 365;
/*
* Brutto loon
*/
$D['19'] = $D['24'] * $D['12'] + $D['13'] + $D['14'] * $D['25'] + $D['15'] * $D['25'] * $D['26'] + $D['26'] * ($D['16'] + $D['17']) + $D['27'] * $D['18'];
$D['21'] = $D['19'] + $D['20'];
if ($D['9'] != "0") {
$D['22'] = $D['17'] * $D['26'] + ($D['12'] * $D['24'] + $D['13'] + $D['20'] + $D['14'] * $D['25'] + $D['15'] * 12 * $D['25'] + $D['16'] * $D['26'] + $D['18'] * $D['27']) * $D['10'] / $D['9'];
} else {
$D['22'] = "0";
}
if ($D['22'] < $D['29']) {
$D['23'] = MIN(1.5 * ceil($D['8'] / 5), 3);
} else {
if ($D['22'] < $D['30']) {
$D['23'] = 'EMPLOYEE_MAX4';
} else {
$D['23'] = 'EMPLOYEE_MAX6';
}
}
return $D;
}
showsetting('qqgroup_usergroup_feed_list', '', '', '<select name="groupid[]" multiple="multiple" size="10">'.$groupselect.'</select>');
showsubmit('settingsubmit');
showtablefooter();
showformfooter();
}
} elseif($_GET['anchor'] == 'block') {
$perpage = 10;
$maxPage = 10;
$page = intval($_GET['page']);
$page = MAX($page, 1);
$page = MIN($page, $maxPage);
$prevPage = MAX($page - 1, 1);
$nextPage = MIN($page + 1, $maxPage);
if(submitcheck('setMiniportalThreadsSubmit')) {
$topic = $_GET['topic'];
$topic = processMiniportalTopicThread($topic);
if(!$topic) {
cpmsg('qqgroup_msg_deficiency', '', 'error');
}
$normal = $_GET['normal'];
$normal = processMiniportalNormalThreads($normal);
if(!$normal) {
cpmsg('qqgroup_msg_deficiency', '', 'error');
}
public function getCategoryImages($product_id, $module_setting)
{
if (!$this->installed()) {
return false;
}
$this->load->model('tool/image');
// OC 1.X old-style
if ($module_setting && is_array($module_setting) && isset($module_setting['image_width']) && isset($module_setting['image_height'])) {
$image_product_width = $module_setting['image_width'];
$image_product_height = $module_setting['image_height'];
// OC 2.0 new-style
} elseif ($module_setting && is_array($module_setting) && isset($module_setting['width']) && isset($module_setting['height'])) {
$image_product_width = $module_setting['width'];
$image_product_height = $module_setting['height'];
} elseif ($module_setting == "related_products") {
$image_product_width = $this->config->get('config_image_related_width');
$image_product_height = $this->config->get('config_image_related_height');
} else {
$image_product_width = $this->config->get('config_image_product_width');
$image_product_height = $this->config->get('config_image_product_height');
}
if ($this->config->get('config_template') == "eagency") {
$image_product_width = MIN($image_product_width, 200);
$image_product_height = MIN($image_product_height, 200);
}
// ориентир размер изображения 120 (с отступами будет 128), размер иконки 24 (с отступами будет 32)
// (120)/4-6=24
$icon_width = round($image_product_width / 4 - 6);
$icon_height = round($image_product_height / 4 - 6);
// pav fashion theme compatibility
if ($this->config->get('config_template') == "pav_fashion" && (!$module_setting || $module_setting == "related_products")) {
$icon_width = 43;
$icon_height = 43;
}
$images = $this->getProductOptionImages($product_id);
$settings = $this->getProductSettings($product_id);
$category_images = array();
foreach ($images as $product_option_id => $image_po) {
if (isset($settings[$product_option_id]) && $settings[$product_option_id]['img_category']) {
foreach ($image_po as $product_option_value_id => $image_pov) {
if (count($image_pov) > 0) {
if (!isset($category_images[$product_option_id])) {
$category_images[$product_option_id] = array();
}
$image_pov[0];
$category_images[$product_option_id][$product_option_value_id] = array('icon' => $this->model_tool_image->resize($image_pov[0]['thumb'], $icon_width, $icon_height), 'thumb' => $this->model_tool_image->resize($image_pov[0]['image'], $image_product_width, $image_product_height), 'image' => $image_pov[0]['image']);
if (isset($image_pov[0]['option_name']) && $image_pov[0]['option_name'] && isset($image_pov[0]['value_name']) && $image_pov[0]['value_name']) {
$category_images[$product_option_id][$product_option_value_id]['title'] = "" . $image_pov[0]['option_name'] . ": " . $image_pov[0]['value_name'];
}
}
}
}
}
return $category_images;
}
function EndStayEvent()
{
global $pricelist, $reslist;
$LNG = $this->getLanguage(NULL, $this->_fleet['fleet_owner']);
$expeditionPoints = array();
foreach ($reslist['fleet'] as $ID) {
$expeditionPoints[$ID] = ($pricelist[$ID]['cost'][901] + $pricelist[$ID]['cost'][902]) / 1000000;
}
$expeditionPoints[202] = 12;
$expeditionPoints[203] = 47;
$expeditionPoints[204] = 12;
$expeditionPoints[205] = 110;
$expeditionPoints[206] = 47;
$expeditionPoints[207] = 160;
$fleetRaw = explode(";", $this->_fleet['fleet_array']);
$fleetPoints = 0;
$fleetCapacity = 0;
$find_stardust = 5;
$fleetArray = array();
$stardustCount = $GLOBALS['DATABASE']->query("SELECT COUNT(planetarium) as planetarium FROM " . PLANETS . " WHERE id_owner = " . $this->_fleet['fleet_end_id'] . ";");
$stardustCount = $GLOBALS['DATABASE']->fetch_array($stardustCount);
$find_stardust = $find_stardust + $stardustCount['planetarium'];
foreach ($fleetRaw as $Group) {
if (empty($Group)) {
continue;
}
$Class = explode(",", $Group);
$fleetArray[$Class[0]] = $Class[1];
$fleetCapacity += $Class[1] * $pricelist[$Class[0]]['capacity'];
$fleetPoints += $Class[1] * $expeditionPoints[$Class[0]];
}
$fleetCapacity -= $this->_fleet['fleet_resource_metal'] + $this->_fleet['fleet_resource_crystal'] + $this->_fleet['fleet_resource_deuterium'] + $this->_fleet['fleet_resource_darkmatter'];
/*if($GLOBALS['CONFIG'][$this->_fleet['fleet_universe']]['purchase_bonus_timer'] > TIMESTAMP || $GLOBALS['CONFIG'][$this->_fleet['fleet_universe']]['cosmonaute'] == 1){
$GetEvent = mt_rand(1,7);
}else{
$GetEvent = mt_rand(1,6);
} */
$GetEvent = mt_rand(1, 7);
$combat_bonus = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . USERS . " WHERE id = " . $this->_fleet['fleet_owner'] . ";");
$Message = $LNG['sys_expe_nothing_' . mt_rand(1, 8)];
$chancetogetstar = mt_rand(0, 100);
if ($chancetogetstar < $find_stardust) {
$find_stardust = 1;
} else {
$find_stardust = 0;
}
switch ($GetEvent) {
case 1:
$WitchFound = mt_rand(1, 3);
$FindSize = mt_rand(0, 100);
$Factor = 0;
if (10 < $FindSize) {
$Factor = mt_rand(100, 500) / $WitchFound * $GLOBALS['CONFIG'][$this->_fleet['fleet_universe']]['resource_multiplier'];
$Factor = $Factor + $Factor / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_ress_1_' . mt_rand(1, 4)];
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Factor = mt_rand(520, 1000) / $WitchFound * $GLOBALS['CONFIG'][$this->_fleet['fleet_universe']]['resource_multiplier'];
$Factor = $Factor + $Factor / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_ress_2_' . mt_rand(1, 3)];
} elseif (0 == $FindSize) {
$Factor = mt_rand(1020, 2000) / $WitchFound * $GLOBALS['CONFIG'][$this->_fleet['fleet_universe']]['resource_multiplier'];
$Factor = $Factor + $Factor / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_ress_3_' . mt_rand(1, 2)];
}
$StatFactor = $GLOBALS['DATABASE']->getFirstRow("SELECT MAX(total_points) as total FROM `" . STATPOINTS . "` WHERE `stat_type` = 1 AND `universe` = '" . $this->_fleet['fleet_universe'] . "';");
$MaxPoints = $StatFactor['total'] < 5000000 ? 9000 : 12000;
$Size = min($Factor * MAX(MIN($fleetPoints / 1000, $MaxPoints), 200), $fleetCapacity);
switch ($WitchFound) {
case 1:
$this->UpdateFleet('fleet_resource_metal', $this->_fleet['fleet_resource_metal'] + $Size);
break;
case 2:
$this->UpdateFleet('fleet_resource_crystal', $this->_fleet['fleet_resource_crystal'] + $Size);
break;
case 3:
$this->UpdateFleet('fleet_resource_deuterium', $this->_fleet['fleet_resource_deuterium'] + $Size);
break;
}
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " set `achievements_expedition` = `achievements_expedition` + '1', `expedition_count` = `expedition_count` + '1' where `id` = '" . $this->_fleet['fleet_owner'] . "';");
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET stardust = stardust + '" . $find_stardust . "' where `id` = " . $this->_fleet['fleet_owner'] . ";");
$INFOR = $GLOBALS['DATABASE']->query("SELECT * FROM `uni1_users` WHERE id = " . $this->_fleet['fleet_owner'] . ";");
if ($GLOBALS['DATABASE']->numRows($INFOR) > 0) {
while ($xkf = mysqli_fetch_assoc($INFOR)) {
$ACTUA = $xkf['expedition_count'];
$ACTUAL = 10 * $xkf['achievements_misc_expe'] + 10;
$expe_lvl = $xkf['achievements_misc_expe'] + 1;
$expe_reward_points = 50;
$expe_reward_am = 50;
$expe_reward_points = $expe_reward_points + $xkf['achievements_misc_expe'] * $expe_reward_points;
$expe_reward_am = $expe_reward_am + $xkf['achievements_misc_expe'] * $expe_reward_am;
}
if ($ACTUA == $ACTUAL) {
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET achievements_misc_expe = achievements_misc_expe + '1', antimatter = antimatter + " . $expe_reward_am . " WHERE id = " . $this->_fleet['fleet_owner'] . ";");
$msg = '<img alt="" style="float:left; width:60px; margin-right:6px;" src="styles/images/achiev/ach_expedition.png">reached: <span class="achiev_mes_head">expeditions lvl. ' . $expe_lvl . '</span><br> received:<br> ' . $expe_reward_am . ' antimatter <br> ' . $expe_reward_points . ' achievement points';
SendSimpleMessage($this->_fleet['fleet_owner'], '', TIMESTAMP, 4, 'System', 'Achievements', $msg);
}
}
break;
case 2:
$FindSize = mt_rand(0, 100);
$Size = 0;
if (10 < $FindSize) {
$Size = mt_rand(1000, 3000);
$Size = $Size + $Size / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_dm_1_' . mt_rand(1, 5)];
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Size = mt_rand(3001, 6000);
$Size = $Size + $Size / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_dm_2_' . mt_rand(1, 3)];
} elseif (0 == $FindSize) {
$Size = mt_rand(6001, 30000);
$Size = $Size + $Size / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_dm_3_' . mt_rand(1, 2)];
}
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " set `achievements_expedition` = `achievements_expedition` + '1', `expedition_count` = `expedition_count` + '1' where `id` = '" . $this->_fleet['fleet_owner'] . "';");
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET stardust = stardust + '" . $find_stardust . "' where `id` = " . $this->_fleet['fleet_owner'] . ";");
$this->UpdateFleet('fleet_resource_darkmatter', $this->_fleet['fleet_resource_darkmatter'] + $Size);
break;
case 3:
$FindSize = mt_rand(0, 100);
$Size = 0;
$Message = "";
if (10 < $FindSize) {
$Size = mt_rand(100, 500);
$Size = $Size + $Size / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_ships_1_' . mt_rand(1, 4)];
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Size = mt_rand(520, 1000);
$Size = $Size + $Size / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_ships_2_' . mt_rand(1, 2)];
} elseif (0 == $FindSize) {
$Size = mt_rand(1020, 2000);
$Size = $Size + $Size / 100 * $combat_bonus['combat_reward_expe'];
$Message = $LNG['sys_expe_found_ships_3_' . mt_rand(1, 2)];
}
$StatFactor = $GLOBALS['DATABASE']->getFirstCell("SELECT MAX(total_points) FROM `" . STATPOINTS . "` WHERE `stat_type` = 1 AND `universe` = '" . $this->_fleet['fleet_universe'] . "';");
$MaxPoints = $StatFactor < 5000000 ? 4500 : 6000;
$FoundShips = max(round($Size * min($fleetPoints, $MaxPoints)), 10000);
$FoundShipMess = "";
$NewFleetArray = "";
$Found = array();
foreach ($reslist['fleet'] as $ID) {
if (!isset($fleetArray[$ID]) || $ID == 208 || $ID == 209 || $ID == 214) {
continue;
}
$MaxFound = floor($FoundShips / ($pricelist[$ID]['cost'][901] + $pricelist[$ID]['cost'][902]));
if ($MaxFound <= 0) {
continue;
}
$Count = mt_rand(0, $MaxFound);
if ($Count <= 0) {
continue;
}
$Found[$ID] = $Count;
$FoundShips -= $Count * ($pricelist[$ID]['cost'][901] + $pricelist[$ID]['cost'][902]);
$FoundShipMess .= '<br>' . $LNG['tech'][$ID] . ': ' . pretty_number($Count);
if ($FoundShips <= 0) {
break;
}
}
if (empty($Found)) {
$FoundShipMess .= '<br><br>' . $LNG['sys_expe_found_ships_nothing'];
}
foreach ($fleetArray as $ID => $Count) {
if (!empty($Found[$ID])) {
$Count += $Found[$ID];
}
$NewFleetArray .= $ID . "," . floattostring($Count) . ';';
}
$Message .= $FoundShipMess;
$this->UpdateFleet('fleet_array', $NewFleetArray);
$this->UpdateFleet('fleet_amount', array_sum($fleetArray));
break;
case 4:
$Chance = mt_rand(1, 2);
if ($Chance == 1) {
$Points = array(-6, -8, -10);
$Which = 1;
$Def = -3;
$Name = $LNG['sys_expe_attackname_1'];
$Add = 0;
$Rand = array(5, 3, 2);
$DefenderFleetArray = "204,5;206,3;207,2;";
} else {
$Points = array(-7, -9, -11);
$Which = 2;
$Def = 3;
$Name = $LNG['sys_expe_attackname_2'];
$Add = 0.1;
$Rand = array(4, 3, 2);
$DefenderFleetArray = "205,5;215,3;213,2;";
}
$messageHTML = <<<HTML
<div class="raportMessage">
<table>
<tr>
<td colspan="2"><a href="CombatReport.php?raport=%s" target="_blank"><span %s>%s %s (%s)</span></a></td>
</tr>
<tr>
<td>%s</td><td><span %s>%s: %s</span> <span %s>%s: %s</span></td>
</tr>
<tr>
\t\t\t<td>%s</td><td><span>%s: <span style="color:#a47d7a;">%s</span> </span><span>%s: <span style="color:#5ca6aa;">%s</span> </span><span>%s: <span style="color:#339966;">%s</span></span></td>
\t\t</tr>
<tr>
\t\t\t<td>%s</td><td><span>%s: <span style="color:#a47d7a;">%s</font> </span><span>%s: <span style="color:#5ca6aa;">%s</span></span></td>
\t\t</tr>
</table>
</div>
HTML;
//Minize HTML
$messageHTML = str_replace(array("\n", "\t", "\r"), "", $messageHTML);
$FindSize = mt_rand(0, 100);
$maxAttack = 0;
if (10 < $FindSize) {
$Message = $LNG['sys_expe_attack_' . $Which . '_1_' . $Rand[0]];
$maxAttack = 0.3 + $Add + mt_rand($Points[0], abs($Points[0])) * 0.01;
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Message = $LNG['sys_expe_attack_' . $Which . '_2_' . $Rand[1]];
$maxAttack = 0.3 + $Add + mt_rand($Points[1], abs($Points[1])) * 0.01;
} elseif (0 == $FindSize) {
$Message = $LNG['sys_expe_attack_' . $Which . '_3_' . $Rand[2]];
$maxAttack = 0.3 + $Add + mt_rand($Points[2], abs($Points[2])) * 0.01;
}
foreach ($fleetArray as $ID => $count) {
$DefenderFleetArray .= $ID . "," . round($count * $maxAttack) . ";";
}
$AttackerTechno = $GLOBALS['DATABASE']->getFirstRow("SELECT * FROM " . USERS . " WHERE id = " . $this->_fleet['fleet_owner'] . ";");
$DefenderTechno = array('id' => 0, 'username' => $Name, 'military_tech' => min($AttackerTechno['military_tech'] + $Def, 0), 'defence_tech' => min($AttackerTechno['defence_tech'] + $Def, 0), 'shield_tech' => min($AttackerTechno['shield_tech'] + $Def, 0), 'laser_tech' => 0, 'ion_tech' => 0, 'plasma_tech' => 0, 'gravity_tech' => 0, 'rpg_amiral' => 0, 'dm_defensive' => 0, 'dm_attack' => 0, 'experience_combat_level' => min($AttackerTechno['experience_combat_level'], 0), 'academy_1101' => 0, 'academy_1102' => 0, 'academy_1301' => 0, 'academy_1302' => 0, 'academy_1103' => 0, 'academy_1108' => 0, 'academy_1109' => 0, 'academy_1110' => 0, 'academy_1111' => 0, 'academy_1303' => 0, 'academy_1311' => 0);
$fleetID = $this->_fleet['fleet_id'];
$fleetAttack[$fleetID]['fleetDetail'] = $this->_fleet;
$fleetAttack[$fleetID]['player'] = $AttackerTechno;
$fleetAttack[$fleetID]['player']['factor'] = getFactors($fleetAttack[$this->_fleet['fleet_id']]['player'], 'attack', $this->_fleet['fleet_start_time']);
$fleetAttack[$fleetID]['unit'] = array();
$temp = explode(';', $this->_fleet['fleet_array']);
foreach ($temp as $temp2) {
$temp2 = explode(',', $temp2);
if ($temp2[0] < 100) {
continue;
}
if (!isset($fleetAttack[$fleetID]['unit'][$temp2[0]])) {
$fleetAttack[$fleetID]['unit'][$temp2[0]] = 0;
}
$fleetAttack[$fleetID]['unit'][$temp2[0]] += $temp2[1];
}
$fleetDefend = array();
$defRowDef = explode(';', $DefenderFleetArray);
foreach ($defRowDef as $Element) {
$Element = explode(',', $Element);
if ($Element[0] < 100) {
continue;
}
if (!isset($fleetDefend[0]['unit'][$Element[0]])) {
$fleetDefend[0]['unit'][$Element[0]] = 0;
}
$fleetDefend[0]['unit'][$Element[0]] += $Element[1];
}
$fleetDefend[0]['fleetDetail'] = array('fleet_start_galaxy' => $this->_fleet['fleet_end_galaxy'], 'fleet_start_system' => $this->_fleet['fleet_end_system'], 'fleet_start_planet' => $this->_fleet['fleet_end_planet'], 'fleet_start_type' => 1, 'fleet_end_galaxy' => $this->_fleet['fleet_end_galaxy'], 'fleet_end_system' => $this->_fleet['fleet_end_system'], 'fleet_end_planet' => $this->_fleet['fleet_end_planet'], 'fleet_end_type' => 1, 'fleet_resource_metal' => 0, 'fleet_resource_crystal' => 0, 'fleet_resource_deuterium' => 0);
$fleetDefend[0]['player'] = $DefenderTechno;
$fleetDefend[0]['player']['factor'] = 0;
require_once 'calculateAttack.php';
$fleetIntoDebris = $GLOBALS['CONFIG'][$this->_fleet['fleet_universe']]['Fleet_Cdr'];
$defIntoDebris = $GLOBALS['CONFIG'][$this->_fleet['fleet_universe']]['Defs_Cdr'];
$combatResult = calculateAttack($fleetAttack, $fleetDefend, $fleetIntoDebris, $defIntoDebris);
$fleetArray = '';
$totalCount = 0;
$fleetAttack[$fleetID]['unit'] = array_filter($fleetAttack[$fleetID]['unit']);
foreach ($fleetAttack[$fleetID]['unit'] as $element => $amount) {
$fleetArray .= $element . ',' . $amount . ';';
$totalCount += $amount;
}
if ($totalCount <= 0) {
$this->KillFleet();
} else {
$this->UpdateFleet('fleet_array', substr($fleetArray, 0, -1));
$this->UpdateFleet('fleet_amount', $totalCount);
}
require_once 'GenerateReport.php';
$debrisRessource = array(901, 902);
foreach ($debrisRessource as $elementID) {
$debris[$elementID] = 0;
}
$stealResource = array(901 => 0, 902 => 0, 903 => 0);
$raportInfo = array('thisFleet' => $this->_fleet, 'debris' => $debris, 'stealResource' => $stealResource, 'moonChance' => 0, 'moonDestroy' => false, 'moonName' => null, 'moonDestroyChance' => null, 'moonDestroySuccess' => null, 'fleetDestroyChance' => null, 'fleetDestroySuccess' => null);
$raportData = GenerateReport($combatResult, $raportInfo);
$raportID = md5(uniqid('', true) . TIMESTAMP);
$sqlQuery = "INSERT INTO " . RW . " SET rid = '" . $raportID . "', raport = '" . serialize($raportData) . "', time = '" . $this->_fleet['fleet_start_time'] . "', attacker = '" . $this->_fleet['fleet_owner'] . "';";
$GLOBALS['DATABASE']->query($sqlQuery);
switch ($combatResult['won']) {
case "a":
$attackClass = 'style="color:green;"';
$defendClass = 'style="color:red;"';
break;
case "w":
$attackClass = 'style="color:orange;"';
$defendClass = 'style="color:orange;"';
break;
case "r":
$attackClass = 'style="color:red;"';
$defendClass = 'style="color:green;"';
break;
}
$message = sprintf($messageHTML, $raportID, $attackClass, $LNG['sys_mess_attack_report'], sprintf($LNG['sys_adress_planet'], $this->_fleet['fleet_start_galaxy'], $this->_fleet['fleet_start_system'], $this->_fleet['fleet_start_planet'], $this->_fleet['fleet_end_galaxy'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet']), $LNG['type_planet_short'][$this->_fleet['fleet_end_type']], $LNG['sys_lost'], $attackClass, $LNG['sys_attack_attacker_pos'], pretty_number($combatResult['unitLost']['attacker']), $defendClass, $LNG['sys_attack_defender_pos'], pretty_number($combatResult['unitLost']['defender']), $LNG['sys_gain'], $LNG['tech'][901], pretty_number($stealResource[901]), $LNG['tech'][902], pretty_number($stealResource[902]), $LNG['tech'][903], pretty_number($stealResource[903]), $LNG['sys_debris'], $LNG['tech'][901], pretty_number($debris[901]), $LNG['tech'][902], pretty_number($debris[902]));
if ($combatResult['won'] == 'a') {
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " set `achievements_expedition` = `achievements_expedition` + '1', `expedition_count` = `expedition_count` + '1' where `id` = '" . $this->_fleet['fleet_owner'] . "';");
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " SET stardust = stardust + '" . $find_stardust . "' where `id` = " . $this->_fleet['fleet_owner'] . ";");
}
SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_end_stay'], 3, $LNG['sys_mess_tower'], $LNG['sys_mess_attack_report'], $message);
break;
case 5:
$this->KillFleet();
$Message = $LNG['sys_expe_lost_fleet_' . mt_rand(1, 4)];
break;
case 6:
# http://owiki.de/Expedition#Ver.C3.A4nderte_Flugzeit
$MoreTime = mt_rand(0, 100);
$Wrapper = array();
$Wrapper[] = 2;
$Wrapper[] = 2;
$Wrapper[] = 2;
$Wrapper[] = 2;
$Wrapper[] = 2;
$Wrapper[] = 2;
$Wrapper[] = 2;
$Wrapper[] = 3;
$Wrapper[] = 3;
$Wrapper[] = 5;
if ($MoreTime < 75) {
$this->UpdateFleet('fleet_end_time', $this->_fleet['fleet_end_stay'] + ($this->_fleet['fleet_end_time'] - $this->_fleet['fleet_end_stay'] + ($this->_fleet['fleet_end_stay'] - $this->_fleet['fleet_start_time']) * $Wrapper[mt_rand(0, 9)]));
$Message = $LNG['sys_expe_time_slow_' . mt_rand(1, 6)];
} else {
$this->UpdateFleet('fleet_end_time', $this->_fleet['fleet_end_stay'] + max(1, $this->_fleet['fleet_end_time'] - $this->_fleet['fleet_end_stay'] - ($this->_fleet['fleet_end_stay'] - $this->_fleet['fleet_start_time']) / 3 * $Wrapper[mt_rand(0, 9)]));
$Message = $LNG['sys_expe_time_fast_' . mt_rand(1, 3)];
}
break;
case 7:
$FindSize = mt_rand(0, 100);
if (30 < $FindSize) {
$Message = 'You found one frisbee';
$varis = 'frisbee';
} elseif (10 < $FindSize && 30 >= $FindSize) {
$Message = 'You found one alien';
$varis = 'alien';
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Message = 'You found one rocket';
$varis = 'rocket';
}
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " set `achievements_expedition` = `achievements_expedition` + '1', `expedition_count` = `expedition_count` + '1' where `id` = '" . $this->_fleet['fleet_owner'] . "';");
$GLOBALS['DATABASE']->query("UPDATE " . USERS . " set " . $varis . " = " . $varis . " + '1' where `id` = '" . $this->_fleet['fleet_owner'] . "';");
break;
}
SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_end_stay'], 15, $LNG['sys_mess_tower'], $LNG['sys_expe_report'], $Message);
$this->setState(FLEET_RETURN);
$this->SaveFleet();
}
function EndStayEvent()
{
global $pricelist, $CONF, $db, $reslist;
$LNG = $this->GetUserLang($this->_fleet['fleet_owner']);
foreach ($reslist['fleet'] as $ID) {
$Expowert[$ID] = ($pricelist[$ID]['metal'] + $pricelist[$ID]['crystal']) / 1000;
}
$Expowert[202] = 12;
$Expowert[203] = 47;
$Expowert[204] = 12;
$Expowert[205] = 110;
$Expowert[206] = 47;
$Expowert[207] = 160;
$farray = explode(";", $this->_fleet['fleet_array']);
$FleetPoints = 0;
$FleetCapacity = 0;
foreach ($farray as $Item => $Group) {
if (empty($Group)) {
continue;
}
$Class = explode(",", $Group);
$FleetCount[$Class[0]] = $Class[1];
$FleetCapacity += $Class[1] * $pricelist[$Class[0]]['capacity'];
$FleetPoints += $Class[1] * $Expowert[$Class[0]];
}
$FleetCapacity -= $this->_fleet['fleet_resource_metal'] + $this->_fleet['fleet_resource_crystal'] + $this->_fleet['fleet_resource_deuterium'] + $this->_fleet['fleet_resource_darkmatter'];
$GetEvent = mt_rand(0, 10);
switch ($GetEvent) {
case 1:
$WitchFound = mt_rand(1, 3);
$FindSize = mt_rand(0, 100);
if (10 < $FindSize) {
$WitchSize = 1;
$Factor = mt_rand(10, 50) / $WitchFound * $CONF['resource_multiplier'];
$Message = $LNG['sys_expe_found_ress_1_' . mt_rand(1, 4)];
} elseif (0 < $FindSize && 10 >= $FindSize) {
$WitchSize = 2;
$Factor = mt_rand(52, 100) / $WitchFound * $CONF['resource_multiplier'];
$Message = $LNG['sys_expe_found_ress_2_' . mt_rand(1, 3)];
} elseif (0 == $FindSize) {
$WitchSize = 3;
$Factor = mt_rand(102, 200) / $WitchFound * $CONF['resource_multiplier'];
$Message = $LNG['sys_expe_found_ress_3_' . mt_rand(1, 2)];
}
$StatFactor = $db->uniquequery("SELECT MAX(total_points) as total FROM `" . STATPOINTS . "` WHERE `stat_type` = 1;");
$MaxPoints = $StatFactor['total'] < 5000000 ? 9000 : 12000;
$Size = min($Factor * MAX(MIN($FleetPoints / 1000, $MaxPoints), 200), $FleetCapacity);
switch ($WitchFound) {
case 1:
$this->UpdateFleet('fleet_resource_metal', $this->_fleet['fleet_resource_metal'] + $Size);
break;
case 2:
$this->UpdateFleet('fleet_resource_crystal', $this->_fleet['fleet_resource_crystal'] + $Size);
break;
case 3:
$this->UpdateFleet('fleet_resource_deuterium', $this->_fleet['fleet_resource_deuterium'] + $Size);
break;
}
break;
case 2:
$FindSize = mt_rand(0, 100);
if (10 < $FindSize) {
$Size = mt_rand(100, 300);
$Message = $LNG['sys_expe_found_dm_1_' . mt_rand(1, 5)];
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Size = mt_rand(301, 600);
$Message = $LNG['sys_expe_found_dm_2_' . mt_rand(1, 4)];
} elseif (0 == $FindSize) {
$Size = mt_rand(601, 3000);
$Message = $LNG['sys_expe_found_dm_3_' . mt_rand(1, 2)];
}
$this->UpdateFleet('fleet_resource_darkmatter', $this->_fleet['fleet_resource_darkmatter'] + $Size);
break;
case 3:
default:
unset($FleetCount[208]);
unset($FleetCount[209]);
unset($FleetCount[214]);
$FindSize = mt_rand(0, 100);
if (10 < $FindSize) {
$Size = mt_rand(2, 50);
$Message = $LNG['sys_expe_found_ships_1_' . mt_rand(1, 4)];
$MaxFound = 300000;
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Size = mt_rand(51, 100);
$Message = $LNG['sys_expe_found_ships_2_' . mt_rand(1, 2)];
$MaxFound = 600000;
} elseif (0 == $FindSize) {
$Size = mt_rand(101, 200);
$Message = $LNG['sys_expe_found_ships_3_' . mt_rand(1, 2)];
$MaxFound = 1200000;
}
$StatFactor = $db->uniquequery("SELECT MAX(total_points) as total FROM `" . STATPOINTS . "` WHERE `stat_type` = 1;");
$MaxPoints = $StatFactor['total'] < 5000000 ? 4500 : 6000;
$FoundShips = max(min(round($Size * $FleetPoints), $MaxPoints), 10000);
$MinFound = mt_rand(7000, 10000);
$FoundShipMess = "";
$NewFleetArray = "";
$LNG += $this->GetUserLang($this->_fleet['fleet_owner'], 'TECH');
foreach ($reslist['fleet'] as $ID) {
if (!isset($FleetCount[$ID])) {
continue;
}
$Count = mt_rand(1, floor($FoundShips / ($pricelist[$ID]['metal'] + $pricelist[$ID]['crystal'])));
$FleetCount[$ID] = bcadd($Count, $FleetCount[$ID]);
$NewFleetArray .= $ID . "," . floattostring($Count + $FleetCount[$ID]) . ";";
$FoundShips -= $Count * ($pricelist[$ID]['metal'] + $pricelist[$ID]['crystal']);
$FoundShipMess .= '<br>' . $LNG['tech'][$ID] . ': ' . pretty_number($Count);
if ($FoundShips <= 0) {
break;
}
}
$Message .= $FoundShipMess;
foreach ($FleetCount as $ID => $Count) {
if (empty($Count)) {
continue;
}
}
$this->UpdateFleet('fleet_array', $NewFleetArray);
$this->UpdateFleet('fleet_amount', array_sum($FleetCount));
break;
case 4:
$Chance = mt_rand(1, 2);
if ($Chance == 1) {
$Points = array(-3, -5, -8);
$Which = 1;
$Def = -3;
$Name = $LNG['sys_expe_attackname_1'];
$Add = 0;
$Rand = array(5, 3, 2);
$DefenderFleetArray = "204,5;206,3;207,2;";
} else {
$Points = array(-4, -6, -9);
$Which = 2;
$Def = 3;
$Name = $LNG['sys_expe_attackname_2'];
$Add = 0.1;
$Rand = array(4, 3, 2);
$DefenderFleetArray = "205,5;215,3;213,2;";
}
$FindSize = mt_rand(0, 100);
if (10 < $FindSize) {
$Message = $LNG['sys_expe_attack_' . $Which . '_1_' . $Rand[0]];
$MaxAttackerPoints = 0.3 + $Add + mt_rand($Points[0], abs($Points[0])) * 0.01;
} elseif (0 < $FindSize && 10 >= $FindSize) {
$Message = $LNG['sys_expe_attack_' . $Which . '_2_' . $Rand[1]];
$MaxAttackerPoints = 0.3 + $Add + mt_rand($Points[1], abs($Points[1])) * 0.01;
} elseif (0 == $FindSize) {
$Message = $LNG['sys_expe_attack_' . $Which . '_3_' . $Rand[2]];
$MaxAttackerPoints = 0.3 + $Add + mt_rand($Points[2], abs($Points[2])) * 0.01;
}
foreach ($FleetCount as $ID => $count) {
$DefenderFleetArray .= $ID . "," . round($count * $MaxAttackerPoints) . ";";
}
$AttackerTechno = $db->uniquequery('SELECT id,username,military_tech,defence_tech,shield_tech,rpg_amiral,dm_defensive,dm_attack FROM ' . USERS . ' WHERE id=' . $this->_fleet['fleet_owner'] . ";");
$DefenderTechno = array('id' => 0, 'username' => $Name, 'military_tech' => min($AttackerTechno['military_tech'] + $Def, 0), 'defence_tech' => min($AttackerTechno['defence_tech'] + $Def, 0), 'shield_tech' => min($AttackerTechno['shield_tech'] + $Def, 0), 'rpg_amiral' => 0, 'dm_defensive' => 0, 'dm_attack' => 0);
$attackFleets[$this->_fleet['fleet_id']]['fleet'] = $this->_fleet;
$attackFleets[$this->_fleet['fleet_id']]['user'] = $AttackerTechno;
$attackFleets[$this->_fleet['fleet_id']]['detail'] = array();
$temp = explode(';', $this->_fleet['fleet_array']);
foreach ($temp as $temp2) {
$temp2 = explode(',', $temp2);
if ($temp2[0] < 100) {
continue;
}
if (!isset($attackFleets[$this->_fleet['fleet_id']]['detail'][$temp2[0]])) {
$attackFleets[$this->_fleet['fleet_id']]['detail'][$temp2[0]] = 0;
}
$attackFleets[$this->_fleet['fleet_id']]['detail'][$temp2[0]] += $temp2[1];
}
$defense = array();
$defRowDef = explode(';', $DefenderFleetArray);
foreach ($defRowDef as $Element) {
$Element = explode(',', $Element);
if ($Element[0] < 100) {
continue;
}
if (!isset($defense[$defRow['fleet_id']]['def'][$Element[0]])) {
$defense[0][$Element[0]] = 0;
}
$defense[0]['def'][$Element[0]] += $Element[1];
}
$defense[0]['user'] = $DefenderTechno;
require_once 'calculateAttack.' . PHP_EXT;
$start = microtime(true);
$result = calculateAttack($attackFleets, $defense);
$totaltime = microtime(true) - $start;
foreach ($attackFleets as $fleetID => $attacker) {
$fleetArray = '';
$totalCount = 0;
foreach ($attacker['detail'] as $element => $amount) {
if ($amount) {
$fleetArray .= $element . ',' . $amount . ';';
}
$totalCount += $amount;
}
if ($totalCount <= 0) {
$this->KillFleet();
} else {
$this->UpdateFleet('fleet_array', substr($fleetArray, 0, -1));
$this->UpdateFleet('fleet_amount', $totalCount);
}
}
require_once 'GenerateReport.' . PHP_EXT;
$raport = GenerateReport($result, $INFO);
$rid = md5(microtime(true) . mt_rand(1, 100));
file_put_contents(ROOT_PATH . 'raports/raport_' . $rid . '.php', '<?php' . "\n" . '$raport = ' . $raport . ';' . "\n" . '?>');
$SQLQuery = "INSERT INTO " . RW . " SET `time` = '" . TIMESTAMP . "', `owners` = '" . $this->_fleet['fleet_owner'] . ",0', `rid` = '" . $rid . "', `raport` = '';";
$db->query($SQLQuery);
switch ($result['won']) {
case "r":
$ColorAtt = "red";
$ColorDef = "green";
break;
case "w":
$ColorAtt = "orange";
$ColorDef = "orange";
case "a":
$ColorAtt = "green";
$ColorDef = "red";
break;
}
$MessageAtt = sprintf('<a href="CombatReport.php?raport=%s" onclick="OpenPopup(\'CombatReport.php?raport=%s\', \'combat\', screen.width, screen.height);return false" target="combat"><center><font color="%s">%s %s</font></a><br><br><font color="%s">%s: %s</font> <font color="%s">%s: %s</font><br>%s %s:<font color="#adaead">%s</font> %s:<font color="#ef51ef">%s</font> %s:<font color="#f77542">%s</font><br>%s %s:<font color="#adaead">%s</font> %s:<font color="#ef51ef">%s</font><br></center>', $rid, $rid, $ColorAtt, $LNG['sys_mess_attack_report'], sprintf($LNG['sys_adress_planet'], $this->_fleet['fleet_end_galaxy'], $this->_fleet['fleet_end_system'], $this->_fleet['fleet_end_planet']), $ColorAtt, $LNG['sys_perte_attaquant'], pretty_number($result['lost']['att']), $ColorDef, $LNG['sys_perte_defenseur'], pretty_number($result['lost']['def']), $LNG['sys_gain'], $LNG['Metal'], pretty_number($steal['metal']), $LNG['Crystal'], pretty_number($steal['crystal']), $LNG['Deuterium'], pretty_number($steal['deuterium']), $LNG['sys_debris'], $LNG['Metal'], pretty_number($result['debree']['att'][0] + $result['debree']['def'][0]), $LNG['Crystal'], pretty_number($result['debree']['att'][1] + $result['debree']['def'][1]));
SendSimpleMessage($this->_fleet['fleet_owner'], '', $this->_fleet['fleet_start_time'], 3, $LNG['sys_mess_tower'], $LNG['sys_mess_attack_report'], $MessageAtt);
break;
case 5:
$this->KillFleet();
$Message = $LNG['sys_expe_lost_fleet_' . mt_rand(1, 4)];
break;
case 6:
$MoreTime = mt_rand(0, 100);
if ($MoreTime < 75) {
$this->UpdateFleet('fleet_end_time', $this->_fleet['fleet_end_time'] - TIMESTAMP * mt_rand(1, 5) + TIMESTAMP);
$Message = $LNG['sys_expe_time_slow_' . mt_rand(1, 6)];
} else {
$this->UpdateFleet('fleet_end_time', round($this->_fleet['fleet_end_stay'] + ($this->_fleet['fleet_end_time'] - $this->_fleet['fleet_end_stay']) / 2));
$Message = $LNG['sys_expe_time_fast_' . mt_rand(1, 3)];
}
break;
default:
$Message = $LNG['sys_expe_nothing_' . mt_rand(1, 8)];
break;
}
SendSimpleMessage($this->_fleet['fleet_owner'], '', $this->_fleet['fleet_end_stay'], 15, $LNG['sys_mess_tower'], $LNG['sys_expe_report'], $Message);
$this->UpdateFleet('fleet_mess', 1);
$this->SaveFleet();
}
$category = get_category_by_sku($inventory->sku);
if ($category !== 0) {
$categories = $category["GetProductCategoriesForSKUResponse"]["GetProductCategoriesForSKUResult"]["Self"][1];
if (isset($categories)) {
$category = $categories;
$arrCategories = array();
while (true) {
if ($category["ProductCategoryName"] != "Subjects") {
array_unshift($arrCategories, $category["ProductCategoryName"]);
}
if (!isset($category['Parent'])) {
break;
}
$category = $category['Parent'];
}
for ($i = 0; $i < MIN(count($arrCategories), 3); $i++) {
$aminfo['category' . ($i + 1)] = $arrCategories[$i];
}
}
} else {
}
$aminfo->inventory_id = $inventory->id;
$aminfo->save();
//usleep(100);
}
$start += count($inventories);
}
}
/*
Process description...
*/
function get_week_info($tabrange, $week, $chapter = 0)
{
global $SESSION, $DB, $USER;
$c = $this->get_chapter($chapter);
// added by oncampus
$lections = $c['lections'];
// added by oncampus
//$fnmaxtab = $DB->get_field('course_config_fn', 'value', array('courseid' => $this->course->id, 'variable' => 'maxtabs'));
/* if ($fnmaxtab) {
$maximumtabs = $fnmaxtab;
} else {
$maximumtabs = 12;
} */
$maximumtabs = 6;
if ($lections < 6) {
$maximumtabs = $lections;
}
$last_lection = $this->get_last_lection();
// oncampus
if ($USER->username == 'rieger') {
//echo 'range: '.$tabrange.', week: '.$week.', chapter: '.$chapter.', last_section: '.$last_lection.'<br />';
}
if ($last_lection == $maximumtabs) {
// oncampus
//if ($USER->username == 'rieger') { echo '1<br />';}
$tablow = 1;
$tabhigh = $maximumtabs;
} else {
if ($maximumtabs < 6) {
//if ($USER->username == 'rieger') { echo '1.5<br />';}
$tablow = 1;
$tabhigh = $maximumtabs;
} else {
if ($tabrange > 1000) {
//if ($USER->username == 'rieger') { echo '2<br />';}
$tablow = (int) ($tabrange / 1000);
$tabhigh = (int) ($tablow + $maximumtabs - 1);
} else {
if ($tabrange == 0 && $week == 0) {
//if ($USER->username == 'rieger') { echo '3<br />';}
$tablow = (int) ((int) ($last_lection - 1) / (int) $maximumtabs) * $maximumtabs + 1;
$tabhigh = $tablow + $maximumtabs - 1;
} else {
if ($tabrange == 0) {
$tablow = $week;
//((int) ((int) $week / (int) $maximumtabs) * $maximumtabs) + 1;
$tabhigh = $tablow + $maximumtabs - 1;
//if ($USER->username == 'rieger') { echo 'nr. 4 ('.$tablow.' '.$tabhigh.')<br />';}
//echo '('.$tablow.' '.$tabhigh.')';
} else {
//if ($USER->username == 'rieger') { echo '5<br />';}
$tablow = 1;
$tabhigh = $maximumtabs;
}
}
}
}
}
$tabhigh = MIN($tabhigh, $last_lection);
/// Normalize the tabs to always display FNMAXTABS...
if ($tabhigh - $tablow + 1 < $maximumtabs) {
$tablow = $tabhigh - $maximumtabs + 1;
}
/// Save the low and high week in SESSION variables... If they already exist, and the selected
/// week is in their range, leave them as is.
if ($tabrange >= 1000 || !isset($SESSION->FN_tablow[$this->course->id]) || !isset($SESSION->FN_tabhigh[$this->course->id]) || $week < $SESSION->FN_tablow[$this->course->id] || $week > $SESSION->FN_tabhigh[$this->course->id]) {
$SESSION->FN_tablow[$this->course->id] = $tablow;
$SESSION->FN_tabhigh[$this->course->id] = $tabhigh;
} else {
$tablow = $SESSION->FN_tablow[$this->course->id];
$tabhigh = $SESSION->FN_tabhigh[$this->course->id];
}
$tablow = MAX($tablow, 1);
$tabhigh = MIN($tabhigh, $last_lection);
// oncampus
/* $low = $c['first_lection'] - ((int)(($maximumtabs - $lections) / 2));
if (($low + $maximumtabs - 1) > $last_lection) {
$low = $last_lection - $maximumtabs + 1;
}
$high = $low + $maximumtabs - 1;
if ($chapter != 0 and (($tabrange > $low and $tabrange <= $high) or $tabrange == 0 )) {
$tablow = $low;
$tabhigh = $high;
} */
// oncampus ende
unset($maximumtabs);
return array($tablow, $tabhigh, $week);
}
function processMergePlayers()
{
// This script will merge 2 player ID's, setting the first one as . Use with EXTREME cation!!
global $cfg;
$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));
@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());
// Get PlayerID's
$pids = array();
$pids[0] = $_POST['target_pid'] ? $_POST['target_pid'] : 0;
// Target PID
$pids[1] = $_POST['source_pid'] ? $_POST['source_pid'] : 0;
// Source PID
// Check PID Values
if ($pids[0] == 0 || $pids[1] == 0) {
showLog("<font color='red'>ERROR:</font> Data input missing!");
return;
}
if ($pids[0] == $pids[1]) {
showLog("<font color='red'>ERROR:</font> Target & Source are Identical!!");
return;
}
// Check Players Exist
foreach ($pids as $pid) {
if (!is_numeric($pid)) {
showLog("<font color='red'>ERROR:</font> PID ({$pid}) is not a valid player!");
return;
}
$query = "SELECT id FROM player WHERE id = {$pid}";
$result = mysql_query($query);
if (mysql_num_rows($result) == 1) {
$pids_exist = true;
} else {
showLog("<<font color='red'>ERROR:</font> PID ({$pid}) is not a valid player!");
return;
}
}
// We are still here, so everything must have checked out
showLog("Merging Player Data...");
// Note: PID1 -->> PID0. PID0 becomes the primary and PID1 is removed! Make sure you get this RIGHT!!!!
// Merge Single-line data tables
$DataTables = array('army', 'kits', 'vehicles', 'weapons', 'player');
foreach ($DataTables as $DataTable) {
showLog(" -> Merging {$DataTable} table...");
$query = "SELECT * FROM {$DataTable} WHERE id = {$pids[1]}";
$result = mysql_query($query);
if (mysql_num_rows($result) == 1) {
$fieldCount = mysql_num_fields($result);
$row = mysql_fetch_row($result);
// Build Update Query
$query = "UPDATE {$DataTable} SET ";
for ($i = 1; $i < $fieldCount; $i++) {
if (mysql_field_type($result, $i) == 'int') {
if ($DataTable == 'player' && mysql_field_name($result, $i) == 'joined') {
$query .= "`" . mysql_field_name($result, $i) . "` = " . $row[$i] . ",\n";
} elseif ($DataTable == 'player' && mysql_field_name($result, $i) == 'lastonline') {
$query .= "`" . mysql_field_name($result, $i) . "` = `" . mysql_field_name($result, $i) . "`,\n";
} elseif ($DataTable == 'player' && mysql_field_name($result, $i) == 'rndscore') {
$query .= "`" . mysql_field_name($result, $i) . "` = (SELECT IF(" . $row[$i] . " > `" . mysql_field_name($result, $i) . "`, " . $row[$i] . ", `" . mysql_field_name($result, $i) . "`)),\n";
} else {
$query .= "`" . mysql_field_name($result, $i) . "` = `" . mysql_field_name($result, $i) . "` + " . $row[$i] . ",\n";
}
}
}
$query = rtrim($query, ",\n") . "\nWHERE id = {$pids[0]};";
// Update Data
if (mysql_query($query)) {
showLog("\t\tSuccess!");
// Remove Old Data
$query = "DELETE FROM `{$DataTable}` WHERE id = {$pids[1]};";
if (mysql_query($query)) {
showLog(" -> Old Player Data ({$DataTable}) Removed.");
} else {
showLog("\t\t<font color='red'>ERROR:</font> " . mysql_error());
}
} else {
showLog("\t\t<font color='red'>ERROR:</font> " . mysql_error());
return;
}
} else {
showLog("\t\tNo Data");
}
}
// Reset Unlocks
showLog(" -> Reseting Unlocks for Player ({$pids[0]})...");
$query = "UPDATE unlocks SET state = 'n' WHERE (id = {$pids[0]})";
if (mysql_query($query)) {
$query = "UPDATE player SET availunlocks = 0, usedunlocks = 0 WHERE id = {$pids[0]}";
mysql_query($query) or die(mysql_error());
showLog("\t\tSuccess!");
// Remove Old Unlocks Data
showLog(" -> Removing Old Unlocks for Player ({$pids[1]})...");
$query = "DELETE FROM unlocks WHERE (id = {$pids[1]})";
if (mysql_query($query)) {
showLog("\t\tUnlocks Removed!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> Unlocks Removal Failed!" . mysql_error());
}
} else {
showLog("\t\t<font color='red'>ERROR:</font> " . mysql_error());
return;
}
// Merge Awards Data
showLog(" -> Merging Awards table...");
$query = "SELECT * FROM awards WHERE id = {$pids[1]};";
$result = mysql_query($query);
if (mysql_num_rows($result)) {
while ($rowsrc = mysql_fetch_array($result)) {
// Check Awards exist
if ($rowsrc['awd']) {
$query = "SELECT * FROM awards WHERE id = {$pids[0]} AND awd = " . $rowsrc['awd'] . ";";
$chkresult = mysql_query($query);
if (mysql_num_rows($chkresult)) {
// Update Award
$rowdest = mysql_fetch_array($chkresult);
$query = "UPDATE `awards` SET\n";
switch ($rowsrc['awd']) {
case 2051902:
// Gold
// Gold
case 2051907:
// Silver
// Silver
case 2051919:
// Bronze
$query .= "`level` = `level` + " . $rowsrc['level'] . ",\n";
break;
default:
$query .= "level = " . MAX($rowsrc['level'], $rowdest['level']) . ",\n";
}
$query .= "earned = " . MIN($rowsrc['earned'], $rowdest['earned']) . ",\n";
$query .= "first = " . MIN($rowsrc['first'], $rowdest['first']) . "\n";
$query .= "WHERE id = {$pids[0]} AND `awd` = " . $rowsrc['awd'] . ";";
if (mysql_query($query)) {
showLog("\t\tAward {$rowsrc[awd]} Update Success!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> Award {$rowsrc[awd]} Update Failed: " . mysql_error());
}
} else {
// Insert Award
$query = "INSERT INTO `awards` SET\n";
$query .= "`id` = {$pids[0]},\n";
$query .= "`awd` = " . $rowsrc['awd'] . ",\n";
$query .= "`level` = " . $rowsrc['level'] . ",\n";
$query .= "`earned` = " . $rowsrc['earned'] . ",\n";
$query .= "`first` = " . $rowsrc['first'] . ";";
if (mysql_query($query)) {
showLog("\t\tAward {$rowsrc[awd]} Insert Success!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> Award {$rowsrc[awd]} Insert Failed: " . mysql_error());
}
}
} else {
showLog("\t\t<font color='red'>ERROR:</font> Err, that shouldn't have happend! :(");
}
}
showLog("\t\tAwards Table Merged!");
// Remove Old Awards Data
showLog(" -> Removing Old Awards for Player ({$pids[1]})...");
$query = "DELETE FROM awards WHERE (id = {$pids[1]})";
if (mysql_query($query)) {
showLog("\t\tSuccess!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> " . mysql_error());
}
}
// Merge Maps Data
showLog(" -> Merging Maps table...");
$query = "SELECT * FROM `maps` WHERE `id` = {$pids[1]};";
$result = mysql_query($query);
if (mysql_num_rows($result)) {
while ($rowsrc = mysql_fetch_array($result)) {
// Check Map exist
if ($rowsrc['mapid'] >= 0) {
$query = "SELECT * FROM `maps` WHERE `id`= {$pids[0]} AND `mapid` = " . $rowsrc['mapid'] . ";";
$chkresult = mysql_query($query);
if (mysql_num_rows($chkresult)) {
// Update Map Data
$rowdest = mysql_fetch_array($chkresult);
$query = "UPDATE `maps` SET\n";
$query .= "`time` = `time` + " . $rowsrc['time'] . ",\n";
$query .= "`win` = `win` + " . $rowsrc['win'] . ",\n";
$query .= "`loss` = `loss` + " . $rowsrc['loss'] . ",\n";
if ($rowsrc['best'] > $rowdest['best']) {
$query .= "`best` = " . $rowsrc['best'] . ",\n";
}
if ($rowsrc['worst'] < $rowdest['worst']) {
$query .= "`worst` = `worst` + " . $rowsrc['worst'] . "\n";
}
$query .= "WHERE id = {$pids[0]} AND `mapid` = " . $rowsrc['mapid'] . ";";
if (mysql_query($query)) {
showLog("\t\tMap {$rowsrc[mapid]} Update Success!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> Map {$rowsrc[mapid]} Update Failed: " . mysql_error());
}
} else {
// Insert Map Data
$query = "INSERT INTO `maps` SET\n";
$query .= "`id` = {$pids[0]},\n";
$query .= "`mapid` = " . $rowsrc['mapid'] . ",\n";
$query .= "`time` = " . $rowsrc['time'] . ",\n";
$query .= "`win` = " . $rowsrc['win'] . ",\n";
$query .= "`loss` = " . $rowsrc['loss'] . ",\n";
$query .= "`best` = " . $rowsrc['best'] . ",\n";
$query .= "`worst` = " . $rowsrc['worst'] . ";";
if (mysql_query($query)) {
showLog("\t\tMap {$rowsrc[mapid]} Insert Success!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> Map {$rowsrc[mapid]} Insert Failed: " . mysql_error());
}
}
} else {
showLog("\t\t<font color='red'>ERROR:</font> MapID Invalid!");
}
}
showLog("\t\tDone!");
// Remove Old Maps Data
showLog(" -> Removing Old Maps for Player ({$pids[1]})...");
$query = "DELETE FROM maps WHERE (id = {$pids[1]})";
if (mysql_query($query)) {
showLog("\t\tSuccess!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> " . mysql_error());
}
}
// Update Kills Data
showLog(" -> Updating Kills Data...");
$query = "SELECT * FROM kills WHERE attacker = {$pids[1]};";
$result = mysql_query($query);
if (mysql_num_rows($result)) {
while ($rowsrc = mysql_fetch_array($result)) {
// Check Kills exist
if ($rowsrc['victim']) {
$query = "SELECT * FROM kills WHERE attacker = {$pids[0]} AND victim = " . $rowsrc['victim'] . ";";
$chkresult = mysql_query($query);
if (mysql_num_rows($chkresult)) {
// Update Existing record
$query = "UPDATE `kills` SET\n";
$query .= "`count` = `count` + " . $rowsrc['count'] . "\n";
$query .= "WHERE attacker = {$pids[0]} AND victim = " . $rowsrc['victim'] . ";";
if (mysql_query($query)) {
// Success
} else {
showLog("\t\t<font color='red'>ERROR:</font> Kills data not updated: " . mysql_error());
}
} else {
// Insert Kills
$query = "INSERT INTO `kills` SET\n";
$query .= "attacker = {$pids[0]},\n";
$query .= "victim = " . $rowsrc['victim'] . ",\n";
$query .= "`count` = " . $rowsrc['count'] . ";";
if (mysql_query($query)) {
// Success
} else {
showLog("\t\t<font color='red'>ERROR:</font> Kills data not inserted: " . mysql_error());
}
}
} else {
showLog("<font color='red'>#</font>");
}
}
showLog("\t\tKills Done!");
// Remove Old Kills Data
showLog(" -> Removing Old Kills for Player ({$pids[1]})...");
$query = "DELETE FROM kills WHERE (attacker = {$pids[1]})";
if (mysql_query($query)) {
showLog("\t\tSuccess!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> " . mysql_error());
}
}
// Update Deaths Data
showLog(" -> Updating Deaths Data...");
$query = "SELECT * FROM kills WHERE victim = {$pids[1]};";
$result = mysql_query($query);
if (mysql_num_rows($result)) {
while ($rowsrc = mysql_fetch_array($result)) {
// Check Deaths exist
if ($rowsrc['attacker']) {
$query = "SELECT * FROM kills WHERE attacker = " . $rowsrc['attacker'] . " AND victim = {$pids[0]};;";
$chkresult = mysql_query($query);
if (mysql_num_rows($chkresult)) {
// Update Existing record
$query = "UPDATE `kills` SET\n";
$query .= "`count` = `count` + " . $rowsrc['count'] . "\n";
$query .= "WHERE attacker = " . $rowsrc['attacker'] . " AND victim = {$pids[0]};";
if (mysql_query($query)) {
// Success
} else {
showLog("\t\t<font color='red'>ERROR:</font> Kills data not updated: " . mysql_error());
}
} else {
// Insert Deaths
$query = "INSERT INTO `kills` SET\n";
$query .= "attacker = " . $rowsrc['attacker'] . ",\n";
$query .= "victim = {$pids[0]},\n";
$query .= "`count` = " . $rowsrc['count'] . ";";
if (mysql_query($query)) {
// Success
} else {
showLog("\t\t<font color='red'>ERROR:</font> Kills data not inserted: " . mysql_error());
}
}
} else {
showLog("<font color='red'>#</font>");
}
}
showLog("\t\tDeaths Done!");
// Remove Old Deaths Data
showLog(" -> Removing Old Deaths for Player ({$pids[1]})...");
$query = "DELETE FROM kills WHERE (victim = {$pids[1]})";
if (mysql_query($query)) {
showLog("\t\tSuccess!");
} else {
showLog("\t\t<font color='red'>ERROR:</font> " . mysql_error());
}
}
showLog("Done! :)\n");
// Close database connection
@mysql_close($connection);
//Validating Rank
$_POST['selitems'] = array($pids[0]);
processValidateRanks();
// Ensure Old player does not exist
$_POST['selitems'] = array($pids[1]);
processDeletePlayers();
}
$progName = IO_MIDI_GM::getProgramName($prog);
echo " {$prog}({$progName})";
}
echo PHP_EOL;
if ($noteOnTable[$channel] === $noteOffTable[$channel]) {
echo " NoteOn/OffCount: " . $noteOnTable[$channel];
} else {
echo " NoteOnCount: " . $noteOnTable[$channel];
echo " NoteOffCount: " . $noteOffTable[$channel];
}
$noteKeyList = array_keys($noteKeyTable[$channel]);
echo " KeyRange: " . MIN($noteKeyList) . " <-> " . MAX($noteKeyList);
echo PHP_EOL;
if ($pitchbendTable[$channel] > 0) {
$pitchbendRangeList = array_keys($pitchbendRangeTable[$channel]);
echo " PitchBendCount: " . $pitchbendTable[$channel];
echo " PitchBendRange: " . MIN($pitchbendRangeList) . " <-> " . MAX($pitchbendRangeList);
} else {
echo " PitchBend: (none)";
}
echo PHP_EOL;
if (count($controllerTypeTable) > 0) {
$controllerTypeList = array_keys($controllerTypeTable[$channel]);
sort($controllerTypeList);
echo " ControllerType: " . implode(' ', $controllerTypeList);
} else {
echo " ControllerType: (none)";
}
echo PHP_EOL;
}
}
function get_week_info($tabrange, $week, $resubmission = false)
{
global $SESSION;
$fnmaxtab = $DB->get_field('course_config_fn', 'value', array('courseid' => $this->course->id, 'variable' => 'maxtabs'));
if ($fnmaxtab) {
$maximumtabs = $fnmaxtab;
} else {
$maximumtabs = 12;
}
if ($this->course->numsections == $maximumtabs) {
$tablow = 1;
$tabhigh = $maximumtabs;
} else {
if ($tabrange > 1000) {
$tablow = $tabrange / 1000;
$tabhigh = $tablow + $maximumtabs - 1;
} else {
if ($tabrange == 0 && $week == 0) {
$tablow = (int) ((int) ($this->course->numsections - 1) / (int) $maximumtabs) * $maximumtabs + 1;
$tabhigh = $tablow + $maximumtabs - 1;
} else {
if ($tabrange == 0) {
$tablow = (int) ((int) $week / (int) $maximumtabs) * $maximumtabs + 1;
$tabhigh = $tablow + $maximumtabs - 1;
} else {
$tablow = 1;
$tabhigh = $maximumtabs;
}
}
}
}
$tabhigh = MIN($tabhigh, $this->course->numsections);
/// Normalize the tabs to always display FNMAXTABS...
if ($tabhigh - $tablow + 1 < $maximumtabs) {
$tablow = $tabhigh - $maximumtabs + 1;
}
/// Save the low and high week in SESSION variables... If they already exist, and the selected
/// week is in their range, leave them as is.
if ($tabrange >= 1000 || !isset($SESSION->FN_tablow[$this->course->id]) || !isset($SESSION->FN_tabhigh[$this->course->id]) || $week < $SESSION->FN_tablow[$this->course->id] || $week > $SESSION->FN_tabhigh[$this->course->id]) {
$SESSION->FN_tablow[$this->course->id] = $tablow;
$SESSION->FN_tabhigh[$this->course->id] = $tabhigh;
} else {
$tablow = $SESSION->FN_tablow[$this->course->id];
$tabhigh = $SESSION->FN_tabhigh[$this->course->id];
}
$tablow = MAX($tablow, 1);
$tabhigh = MIN($tabhigh, $this->course->numsections);
/// If selected week in a different set of tabs, move it to the current set...
if ($week != 0 && $week < $tablow) {
$week = $SESSION->G8_selected_week[$this->course->id] = $tablow;
} else {
if ($week > $tabhigh) {
$week = $SESSION->G8_selected_week[$this->course->id] = $tabhigh;
}
}
return array($tablow, $tabhigh, $week);
}
/**
* Calculate account WN8
*
* @return Integer
*/
protected function getWN8()
{
// If WN8 was not calculated yet
if (is_null($this->wn8)) {
// Get account_id
$account_id = $this->account_id;
// Get summary values
$summary = $this->api->get('wot/account/info', array('fields' => 'statistics.all.battles,statistics.all.frags,statistics.all.damage_dealt,statistics.all.dropped_capture_points,statistics.all.spotted,statistics.all.wins', 'account_id' => $account_id))->{$account_id}->statistics->all;
// Get tanks values
$tanks = $this->api->get('wot/account/tanks', array('fields' => 'tank_id,statistics.battles', 'account_id' => $account_id))->{$account_id};
// If this account has no tanks data skip calculation and return 0
if (empty($tanks)) {
$this->wn8 = 0;
return $this->wn8;
}
// WN8 expected calculation
$expDAMAGE = $expFRAGS = $expSPOT = $expDEF = $expWIN = 0;
// Tanks missing in expected tank values but existing in account
$missing = array();
// Calculated account expected values
foreach ($tanks as $tank) {
// Tank exists in expected tank values
if (isset($this->expected_tank_values[$tank->tank_id])) {
// Expected values for current tank
$expected = $this->expected_tank_values[$tank->tank_id];
// Battles on current tank
$tank_battles = $tank->statistics->battles;
// Calculate expected values for current tank
$expDAMAGE += $expected->expDamage * $tank_battles;
$expSPOT += $expected->expSpot * $tank_battles;
$expFRAGS += $expected->expFrag * $tank_battles;
$expDEF += $expected->expDef * $tank_battles;
$expWIN += 0.01 * $expected->expWinRate * $tank_battles;
// Tank missing in expected tank values so add it to the list
} else {
$missing[] = $tank->tank_id;
}
}
// User want accurate calculation
if ($this->accurate_calculation and !empty($missing)) {
// Get missing tanks stats from API server
$missing_tanks = $this->api->get('wot/tanks/stats', array('tank_id' => implode(',', $missing), 'fields' => 'tank_id,all.battles,all.frags,all.damage_dealt,all.dropped_capture_points,all.spotted,all.wins', 'account_id' => $account_id))->{$account_id};
// Reduce account summary data
foreach ($missing_tanks as $tank) {
$summary->damage_dealt -= $tank->all->damage_dealt;
$summary->spotted -= $tank->all->spotted;
$summary->frags -= $tank->all->frags;
$summary->dropped_capture_points -= $tank->all->dropped_capture_points;
$summary->wins -= $tank->all->wins;
}
}
// If there are missing tanks and searching for info is set to TRUE, get those values
if (!empty($missing) and $this->search_missing_tanks) {
$this->missing_tanks = $this->api->get('wot/encyclopedia/tankinfo', array('tank_id' => implode(',', $missing), 'fields' => 'localized_name'));
}
// Calculate WN8
$rDAMAGE = $summary->damage_dealt / $expDAMAGE;
$rSPOT = $summary->spotted / $expSPOT;
$rFRAG = $summary->frags / $expFRAGS;
$rDEF = $summary->dropped_capture_points / $expDEF;
$rWIN = $summary->wins / $expWIN;
$rWINc = max(0, ($rWIN - 0.71) / (1 - 0.71));
$rDAMAGEc = max(0, ($rDAMAGE - 0.22) / (1 - 0.22));
$rFRAGc = max(0, min($rDAMAGEc + 0.2, ($rFRAG - 0.12) / (1 - 0.12)));
$rSPOTc = max(0, min($rDAMAGEc + 0.1, ($rSPOT - 0.38) / (1 - 0.38)));
$rDEFc = max(0, min($rDAMAGEc + 0.1, ($rDEF - 0.1) / (1 - 0.1)));
$wn8 = 980 * $rDAMAGEc + 210 * $rDAMAGEc * $rFRAGc + 155 * $rFRAGc * $rSPOTc + 75 * $rDEFc * $rFRAGc + 145 * MIN(1.8, $rWINc);
// Ok we have WN8, store it
$this->wn8 = round($wn8, 2);
}
// Return our mighty number
return $this->wn8;
}
$res1t['opacity'] = 0;
}
$res[] = $res1t;
}
$responseData = json_encode($res, FALSE);
echo $responseData;
exit;
}
if ($action_ajax == 'add_links') {
if (!API::Host()->isWritable(array($hostid))) {
rightsErrorAjax();
}
$shost = $hostid;
foreach ($thostid as $thost) {
if (API::Host()->isWritable(array($hostid))) {
$newlink = array('host1' => MIN($shost, $thost), 'host2' => MAX($shost, $thost));
$res = DBimap::insert('hosts_links', array($newlink));
}
}
$responseData = json_encode(array('result' => $res), FALSE);
echo $responseData;
exit;
}
if ($action_ajax == 'update_link') {
if (!rightsForLink($linkid)) {
rightsErrorAjax();
}
$link = $linkid;
$newlink = array('values' => array('name' => $linkoptions['linkname']), 'where' => array('id' => $link));
$res = DBimap::update('hosts_links', array($newlink));
$res = DBimap::delete('hosts_links_settings', array('ids' => array($link)));
function get_week_info($tabrange, $week)
{
global $SESSION;
if ($this->course->numsections == FNMAXTABS) {
$tablow = 1;
$tabhigh = FNMAXTABS;
} else {
if ($tabrange > 1000) {
$tablow = $tabrange / 1000;
$tabhigh = $tablow + FNMAXTABS - 1;
} else {
if ($tabrange == 0 && $week == 0) {
$tablow = (int) ((int) ($this->course->numsections - 1) / (int) FNMAXTABS) * FNMAXTABS + 1;
$tabhigh = $tablow + FNMAXTABS - 1;
} else {
if ($tabrange == 0) {
$tablow = (int) ((int) $week / (int) FNMAXTABS) * FNMAXTABS + 1;
$tabhigh = $tablow + FNMAXTABS - 1;
} else {
$tablow = 1;
$tabhigh = FNMAXTABS;
}
}
}
}
$tabhigh = MIN($tabhigh, $this->course->numsections);
/// Normalize the tabs to always display FNMAXTABS...
if ($tabhigh - $tablow + 1 < FNMAXTABS) {
$tablow = $tabhigh - FNMAXTABS + 1;
}
/// Save the low and high week in SESSION variables... If they already exist, and the selected
/// week is in their range, leave them as is.
if ($tabrange >= 1000 || !isset($SESSION->FN_tablow[$this->course->id]) || !isset($SESSION->FN_tabhigh[$this->course->id]) || $week < $SESSION->FN_tablow[$this->course->id] || $week > $SESSION->FN_tabhigh[$this->course->id]) {
$SESSION->FN_tablow[$this->course->id] = $tablow;
$SESSION->FN_tabhigh[$this->course->id] = $tabhigh;
} else {
$tablow = $SESSION->FN_tablow[$this->course->id];
$tabhigh = $SESSION->FN_tabhigh[$this->course->id];
}
$tablow = MAX($tablow, 1);
$tabhigh = MIN($tabhigh, $this->course->numsections);
/// If selected week in a different set of tabs, move it to the current set...
if ($week != 0 && $week < $tablow) {
$week = $SESSION->G8_selected_week[$this->course->id] = $tablow;
} else {
if ($week > $tabhigh) {
$week = $SESSION->G8_selected_week[$this->course->id] = $tabhigh;
}
}
return array($tablow, $tabhigh, $week);
}
function printdivbuffer() {
$p1 = $this->blk[$this->blklvl]['startpage'];
$p2 = $this->page;
$bottom[$p1] = $this->ktBlock[$p1]['bottom_margin'];
$bottom[$p2] = $this->y; // $this->ktBlock[$p2]['bottom_margin'];
$top[$p1] = $this->kt_y00;
$top2 = $this->h;
foreach($this->divbuffer AS $key=>$s) {
if ($s['page'] == $p2) {
$top2 = MIN($s['y'], $top2);
}
}
$top[$p2] = $top2;
$height[$p1] = ($bottom[$p1] - $top[$p1]);
$height[$p2] = ($bottom[$p2] - $top[$p2]);
$xadj[$p1] = $this->MarginCorrection;
$yadj[$p1] = -($top[$p1] - $top[$p2]);
$xadj[$p2] = 0;
$yadj[$p2] = $height[$p1];
// Output without any transformation
if ($this->ColActive || !$this->keep_block_together || $this->blk[$this->blklvl]['startpage'] == $this->page || ($this->page - $this->blk[$this->blklvl]['startpage']) > 1 || ($height[$p1]+$height[$p2]) > $this->h) {
foreach($this->divbuffer AS $s) { $this->pages[$s['page']] .= $s['s']."\n"; }
foreach($this->ktLinks AS $p => $l) {
foreach($l AS $v) {
$this->PageLinks[$p][] = $v;
}
}
foreach($this->ktForms AS $key => $f) {
$this->form->forms[$f['n']] = $f;
}
/*-- ANNOTATIONS --*/
foreach($this->ktAnnots AS $p => $l) {
foreach($l AS $v) {
$this->PageAnnots[$p][] = $v;
}
}
/*-- END ANNOTATIONS --*/
/*-- INDEX --*/
// Adjust Reference (index)
foreach($this->ktReference AS $v) {
$Present=0;
//Search the reference (AND Ref/PageNo) in the array
for ($i=0;$i<count($this->Reference);$i++){
if ($this->Reference[$i]['t']==$v['t']){
$Present=1;
if (!in_array($p2,$this->Reference[$i]['p'])) {
$this->Reference[$i]['p'][] = $p2;
}
}
}
//If not found, add it
if ($Present==0) {
$this->Reference[]=array('t'=>$v['t'],'p'=>array($p2));
}
}
/*-- END INDEX --*/
/*-- BOOKMARKS --*/
// Adjust Bookmarks
foreach($this->ktBMoutlines AS $v) {
$this->BMoutlines[]=array('t'=>$v['t'],'l'=>$v['l'],'y'=>$v['y'],'p'=>$v['p']);
}
/*-- END BOOKMARKS --*/
/*-- TOC --*/
// Adjust ToC
foreach($this->_kttoc AS $v) {
$this->tocontents->_toc[]=array('t'=>$v['t'],'l'=>$v['l'],'p'=>$v['p'],'link'=>$v['link'],'toc_id'=>$v['toc_id']);
}
/*-- END TOC --*/
$this->divbuffer = array();
$this->ktLinks = array();
$this->ktAnnots = array();
$this->ktForms = array();
$this->ktBlock = array();
$this->ktReference = array();
$this->ktBMoutlines = array();
$this->_kttoc = array();
$this->keep_block_together = 0;
return;
}
else {
// Output with transformation
// mPDF 5.6.17
$np = '';
$lastpage = -1;
foreach($this->divbuffer AS $key=>$s) {
// callback function
$t = $s['s'];
$p = $s['page'];
if ($p != $lastpage) {
$q = '';
if ($lastpage != -1) { $q = ' Q'."\n"; }
$t = $q . $this->StartTransform(true)."\n" . $this->transformTranslate($xadj[$p], $yadj[$p] , true)."\n" . $t;
$lastpage = $p;
}
$np .= $t."\n";
}
if ($lastpage != -1) { $np .= ' Q'."\n"; }
$this->pages[$this->page] .= $np;
// Adjust hyperLinks
foreach($this->ktLinks AS $p => $l) {
foreach($l AS $v) {
$v[0] += ($xadj[$p]*_MPDFK);
$v[1] -= ($yadj[$p]*_MPDFK);
$this->PageLinks[$p2][] = $v;
}
}
foreach($this->ktForms AS $key => $f) {
$p = $f['page'];
$f['x'] += ($xadj[$p]);
$f['y'] += ($yadj[$p]);
$f['page'] = $p2;
$this->form->forms[$f['n']] = $f;
}
foreach($this->internallink AS $key => $f) {
if (is_array($f) && isset($f['kt'])) {
$f['Y'] += ($yadj[$f['PAGE']]);
$f['PAGE'] = $p2;
unset($f['kt']);
$this->internallink[$key] = $f;
}
}
/*-- ANNOTATIONS --*/
foreach($this->ktAnnots AS $p => $l) {
foreach($l AS $v) {
if ($v['x']>0) { $v['x'] += $xadj[$p]; }
else if ($v['x']<0) { $v['x'] -= $xadj[$p]; }
$v['y'] += $yadj[$p];
$this->PageAnnots[$p2][] = $v;
}
}
/*-- END ANNOTATIONS --*/
/*-- BOOKMARKS --*/
// Adjust Bookmarks
foreach($this->ktBMoutlines AS $v) {
if ($v['y'] != 0) { $v['y'] += ($yadj[$v['p']]); }
$this->BMoutlines[]=array('t'=>$v['t'],'l'=>$v['l'],'y'=>$v['y'],'p'=>$p2);
}
/*-- END BOOKMARKS --*/
/*-- INDEX --*/
// Adjust Reference (index)
foreach($this->ktReference AS $v) {
$Present=0;
//Search the reference (AND Ref/PageNo) in the array
for ($i=0;$i<count($this->Reference);$i++){
if ($this->Reference[$i]['t']==$v['t']){
$Present=1;
if (!in_array($p2,$this->Reference[$i]['p'])) {
$this->Reference[$i]['p'][] = $p2;
}
}
}
//If not found, add it
if ($Present==0) {
$this->Reference[]=array('t'=>$v['t'],'p'=>array($p2));
}
}
/*-- END INDEX --*/
/*-- TOC --*/
// Adjust ToC
foreach($this->_kttoc AS $v) {
$this->tocontents->_toc[]=array('t'=>$v['t'],'l'=>$v['l'],'p'=>$p2,'link'=>$v['link'],'toc_id'=>$v['toc_id']);
$this->links[$v['link']][0] = $p2;
$this->links[$v['link']][1] += $yadj[$v['p']];
}
/*-- END TOC --*/
$this->y = $top[$p2] + $height[$p1] + $height[$p2];
$this->x = $this->lMargin;
$this->divbuffer = array();
$this->ktLinks = array();
$this->ktAnnots = array();
$this->ktForms = array();
$this->ktBlock = array();
$this->ktReference = array();
$this->ktBMoutlines = array();
$this->_kttoc = array();
$this->keep_block_together = 0;
}
}
case "textbox":
if ($fields[$i]->getVar('field_valuetype') == XOBJ_DTYPE_INT) {
$searchform->addElement(new XoopsFormText(sprintf(_PROFILE_MA_LARGERTHAN, $fields[$i]->getVar('field_title')), $fields[$i]->getVar('field_name') . "_larger", 35, 35));
$searchform->addElement(new XoopsFormText(sprintf(_PROFILE_MA_SMALLERTHAN, $fields[$i]->getVar('field_title')), $fields[$i]->getVar('field_name') . "_smaller", 35, 35));
} else {
$tray = new XoopsFormElementTray($fields[$i]->getVar('field_title'));
$tray->addElement(new XoopsFormSelectMatchOption('', $fields[$i]->getVar('field_name') . "_match"));
$tray->addElement(new XoopsFormText('', $fields[$i]->getVar('field_name'), 35, $fields[$i]->getVar('field_maxlength')));
$searchform->addElement($tray);
unset($tray);
}
break;
case "radio":
case "select":
$options = $fields[$i]->getVar('field_options');
$size = MIN(count($options), 10);
$element = new XoopsFormSelect($fields[$i]->getVar('field_title'), $fields[$i]->getVar('field_name'), null, $size, true);
asort($options);
$element->addOptionArray($options);
$searchform->addElement($element);
unset($element);
break;
case "yesno":
$element = new XoopsFormSelect($fields[$i]->getVar('field_title'), $fields[$i]->getVar('field_name'), null, 2, true);
$element->addOption(1, _YES);
$element->addOption(0, _NO);
$searchform->addElement($element);
unset($element);
break;
case "date":
case "datetime":
echo '<option value="6"' . ($ratio == 6 ? ' selected' : '') . '>>= 5.000</option>';
echo '</select></td>';
echo '</tr><tr><td colspan="4"><input name="submit" type="submit"></td></tr>';
end_table();
echo '</form>';
$query = 'WHERE enabled = 1 AND downloaded > 0 AND uploaded > 0';
//' AND cheat >= '.$min
if ($class > 2) {
$query .= ' AND class < ' . ($class - 1);
}
if ($ratio > 1) {
$query .= ' AND (uploaded / downloaded) > ' . ($ratio - 1);
}
$res = sql_query("SELECT COUNT(*),MIN(cheat),MAX(cheat) FROM users {$query}") or sqlerr();
$arr = mysql_fetch_row($res);
$top = MIN($top, $arr[0]);
$min = $arr[1];
$max = $arr[2];
$pages = ceil($top / 20);
if ($page < 1) {
$page = 1;
} elseif ($page > $pages) {
$page = $pages;
}
list($pagertop, $pagerbottom, $limit) = pager(20, $top, "cheaters.php?");
echo $pagertop;
begin_table();
print "<tr><th class=\"left\">User name</th><th>Registered</th><th>Uploaded</th><th>Downloaded</th><th>Ratio</th><th>Cheat Value</th><th>Cheat Spread</th></tr>\n";
$res = sql_query("SELECT * FROM users {$query} ORDER BY cheat DESC {$limit}") or sqlerr();
while ($arr = mysql_fetch_assoc($res)) {
if ($arr['added'] == "0000-00-00 00:00:00") {