Task #948: TF2 ribbons for Demoman & Solider update - HLstatsX: CE - HLXCE Project Tracker

Task #948

TF2 ribbons for Demoman & Solider update

Added by Packhead over 2 years ago. Updated over 2 years ago.

Status:

Resolved

Start date:

12/18/2009

Priority:

Normal

Due date:

Assignee:

FernFerret

% Done:

100%

Category:

Web

Target version:

1.6.5

Blocking Target Version:

Description

We need TF2 ribbons for the Demoman and Solider update. The SQL is attached and just needs to be put into an updater script once the images are ready.

<pre>
for ($i = 1, $i<4, $i++) {
switch($i) {
case 1:
$level = "Bronze";
break;
case 2:
$level = "Silver";
break;
case 3:
$level = "Gold";
break;
}

$db-&gt;query(" 
                INSERT IGNORE INTO `hlstats_Ribbons` (`awardCode`, `game`, `image`, `ribbonName`) VALUES
                    ('rocketlauncher_directhit', '$game', '$i_rocketlauncher_directhit.png', '$level Direct Hit'),
                    ('pickaxe', '$game', '$i_pickaxe.png', '$level Equalizer'),
                    ('sword', '$game', '$i_sword.png', '$level Eyelander'),
                    ('sticky_resistance', '$game', '$i_sticky_resistance.png', '$level Scottish Resistance'),
                    ('taunt_demoman', '$game', '$i_taunt_demoman.png', '$level Demoman Taunt'),
                    ('taunt_soldier', '$game', '$i_taunt_soldier.png', '$level Soldier Taunt');
            ");        
        }
&lt;/pre&gt;

Associated revisions

Revision 178:e325902e8513
Added by Packhead over 2 years ago

[svn r1604] Rolling dbversion and version for install.sql for 1.6.4.
Exported ribbon changes from upgrade to install.sql (#967)
Adding updater/23.php which resolves missing TF2 awards and ribbons (#968) (Packhead)
Added support for additional demoshield weapon (#949) (Packhead)
Updating changelog with changes from 1.6.4.
Adding missing TF2 ribbon and award images (#949, #968, #948, #582) (FernFerret)
Fixed o_domination.png/v_domination.png daily and global award image typo.