hlstatsx/web/updater/38.php

55 lines
1.8 KiB
PHP

<?php
if ( !defined('IN_UPDATER') )
{
die('Do not access this file directly.');
}
$ntsgames = array();
$result = $db->query("SELECT code FROM hlstats_Games WHERE realgame = 'nts'");
while ($rowdata = $db->fetch_row($result))
{
array_push($ntsgames, $db->escape($rowdata[0]));
}
foreach($ntsgames as $game)
{
$db->query("UPDATE hlstats_Weapons SET `name` = 'Detpack' WHERE game='$game' AND `code` = 'grenade_detapack'");
$db->query("UPDATE hlstats_Awards SET `name` = 'Detpack', `verb`='kills with Detpack' WHERE game='$game' AND awardType='W' AND `code` = 'grenade_detapack'");
$db->query("UPDATE hlstats_Ribbons SET `awardCode` = 'supa7' WHERE game='$game' AND `image` LIKE '%supa7%'");
for ($h = 1; $h<4; $h++) {
switch ($h) {
case 1:
$level = "Bronze";
$awardCount = 1;
break;
case 2:
$level = "Silver";
$awardCount = 5;
break;
case 3:
$level = "Gold";
$awardCount = 10;
break;
}
$db->query("
INSERT IGNORE INTO `hlstats_Ribbons` (`awardCode`, `awardCount`, `special`, `game`, `image`, `ribbonName`) VALUES
('grenade_detapack', $awardCount, 0, '$game', '{$h}_rdp.png', '$level Detpack'),
('aa13', $awardCount, 0, '$game', '{$h}_aa13.png', '$level AA13'),
('pz', $awardCount, 0, '$game', '{$h}_pz252.png', '$level PZ252'),
('srm', $awardCount, 0, '$game', '{$h}_srm7.png', '$level SRM'),
('srm_s', $awardCount, 0, '$game', '{$h}_srms7.png', '$level SRM-S'),
('srs', $awardCount, 0, '$game', '{$h}_srs.png', '$level SRS'),
('jitte', $awardCount, 0, '$game', '{$h}_np-721.png', '$level Jitte'),
('jittescoped', $awardCount, 0, '$game', '{$h}_np-721s.png', '$level Jitte (Scoped)');
");
}
}
$db->query("UPDATE hlstats_Options SET `value` = '38' WHERE `keyname` = 'dbversion'");
?>