Task #1439

Add Victory Pack items

Added by bug 10 months ago. Updated 7 months ago.

Status:Resolved Start date:09/07/2011
Priority:Normal Due date:09/09/2011
Assignee:Packhead % Done:

100%

Category:GameSupport
Target version:1.6.15
Blocking Target Version:No

Description

New weapons codes are cow_mangler and righteous_bison. Pictures are in the zip.

Probably more new items to come in the next two days?

victory_pack_images.zip - imgs for global/daily awards, ribbons, weapons (99.1 kB) bug, 07/20/2011 11:56 pm

victory-pack.sql (1.8 kB) Bluthund, 09/07/2011 04:42 pm


Subtasks

Task #1449: Create image for new weapon in TF2Resolved

Associated revisions

Revision 714:ad42f5df9e76
Added by Packhead 8 months ago

GameSupport: Initial commit for upgrade SQL for TF2 Victory Pack (#1439) (Packhead)

Revision 715:d9de6a157e95
Added by Packhead 8 months ago

Web: Added images for three new TF2 weapons (#1439) (bug)

Revision 726:9c3f1f456f9f
Added by Packhead 7 months ago

GameSupport: Added six new weapons for TF2. (#1447, #1439) (Packhead)

History

#1 Updated by Munra 10 months ago

Nice job and ya they will probably be another update by the end of the week as they already announced an update that will change server mechanics. Don't know if they will add any more weapons with that update.

#2 Updated by Munra 8 months ago

  • Target version set to 1.6.15

Needs SQL

#3 Updated by Bluthund 8 months ago

Here you go:

 1INSERT INTO `hlstats_Weapons` (`game`, `code`, `name`, `modifier`) VALUES
 2('tf', 'cow_mangler', 'Cow Mangler 5000', 1.00),
 3('tf', 'righteous_bison', 'Righteous Bison', 1.00);
 4
 5INSERT INTO `hlstats_Ribbons` (`awardCode`, `awardCount`, `special`, `game`, `image`, `ribbonName`) VALUES
 6('cow_mangler',1,0,'tf','1_cow_mangler.png','Bronze Cow Mangler'),
 7('cow_mangler',5,0,'tf','2_cow_mangler.png','Silver Cow Mangler'),
 8('cow_mangler',10,0,'tf','3_cow_mangler.png','Gold Cow Mangler'),
 9('righteous_bison',1,0,'tf','1_righteous_bison.png','Bronze Righteous Bison'),
10('righteous_bison',5,0,'tf','2_righteous_bison.png','Silver Righteous Bison'),
11('righteous_bison',10,0,'tf','3_righteous_bison.png','Gold Righteous Bison');
12
13INSERT INTO `hlstats_Awards` (`awardType`, `game`, `code`, `name`, `verb`) VALUES
14('W','tf','cow_mangler','Cattle Wrecker','cow mangler kills'),
15('W','tf','righteous_bison', 'Spaceman Spiff', 'righteous bison kills');

There also is an additional action that came with the Victory Pack Update, the Deflected Cow Mangler Shot (no image for that one in this pack):

 1INSERT INTO `hlstats_Weapons` (`game`, `code`, `name`, `modifier`) VALUES
 2('tf', 'tf_projectile_energy_ball', 'Deflected Cow Mangler Shot', 2.00);
 3
 4INSERT INTO `hlstats_Ribbons` (`awardCode`, `awardCount`, `special`, `game`, `image`, `ribbonName`) VALUES
 5('tf_projectile_energy_ball',1,0,'tf','1_tf_projectile_energy_ball.png','Bronze Deflected Cow Mangler Shot'),
 6('tf_projectile_energy_ball',5,0,'tf','2_tf_projectile_energy_ball.png','Silver Deflected Cow Mangler Shot'),
 7('tf_projectile_energy_ball',10,0,'tf','3_tf_projectile_energy_ball.png','Gold Deflected Cow Mangler Shot');
 8
 9INSERT INTO `hlstats_Awards` (`awardType`, `game`, `code`, `name`, `verb`) VALUES
10('W','tf','tf_projectile_energy_ball', 'Space-ray Deflector', 'kills with deflected cow mangler shot');

The award names are chosen arbitrarily, so feel free to change them if you want or need to (as Spaceman Spiff is a reference to Calvin and Hobbes).

#4 Updated by Bluthund 8 months ago

Adding the above sql statements as an sql-script.

#5 Updated by Packhead 8 months ago

  • Status changed from New to Assigned

#6 Updated by Packhead 8 months ago

  • Assignee set to Packhead

#7 Updated by Packhead 8 months ago

Bluthund, thanks for the submission. We have a php updater process that has to run against new sites, so the exact format was not usable. However I was able to use your list to verify my sanity. Thanks for the submission.

#8 Updated by Packhead 8 months ago

Added upgrader in hlx-16:ad42f5df9e76.

#9 Updated by Packhead 8 months ago

Added images in hlx-16:d9de6a157e95.

#10 Updated by Packhead 7 months ago

  • Status changed from Assigned to Resolved

Also available in: Atom PDF