Idea Motion Group
လူၾကီးမင္းတြင္ Idea Motion Group မွမွတ္ပံုတင္ျပီးေသာ Member Account ရွိပါက Log In မွ တဆင့္ဝင္ေရာက္ပါ။
New Guest ျဖစ္ပါက Register ျပဳလုပ္၍ဝင္ေရာက္ေပးပို႔ႏိုင္ပါသည္။။
*********Idea Motion Group*********
Log in

I forgot my password

Latest topics
Country Codes

Timer

Total
  • >

/>

Test

Season 10 SQL Query

View previous topic View next topic Go down

default Season 10 SQL Query

Post  Desolater on Thu Jun 28, 2012 10:20 am

NOTICE:This is blizz-like wowhead leaked gear.
THIS IS 4.2.0+ COMPATIBLE ONLY (some exceptions may exist).


I used wowhead parser.
Here is the query for Season 10 set (Includes two versions, Elite and Normal):
Download - .TXT VERSION

Added .SQL version of the query download:
Download - .SQL VERSION
Here is the required query (you have to use it in order for the s10 query to run successfully), for item_template additional columns (Please be cautioned, the query includes columns: dmg_min1, fire_res and etc etc.):

ALTER TABLE `item_template` ADD COLUMN `StatsCount` tinyint(3) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `dmg_min1` float unsigned DEFAULT '0';
ALTER TABLE `item_template` ADD COLUMN `dmg_max1` float DEFAULT NULL;
ALTER TABLE `item_template` ADD COLUMN `dmg_type1` tinyint(3) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `dmg_min2` float NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `dmg_max2` float NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `dmg_type2` tinyint(4) NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `armor` smallint(5) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `holy_res` tinyint(3) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `fire_res` tinyint(3) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `nature_res` tinyint(3) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `frost_res` tinyint(3) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `shadow_res` tinyint(3) unsigned NOT NULL;
ALTER TABLE `item_template` ADD COLUMN `arcane_res` tinyint(3) unsigned NOT NULL;
/* ALTER TABLE `item_template` ADD COLUMN `delay` smallint(5) unsigned NOT NULL DEFAULT '1000'; -
Removed due to being already an existent column in original item_template. */
ALTER TABLE `item_template` ADD COLUMN `ammo_type` tinyint(3) unsigned NOT NULL;

____________________________________________________________/\_/\_/\_/\_/\_/\_/\_/\_/\_/\_/\_/\_/\/\_/\_/\_/\_/\_/\_/\_/\_/\______________________________________________________
[Only admins are allowed to see this image]

Desolater
Moderator
Moderator

Posts : 31
Join date : 2012-05-29
Age : 25

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum