sql/updates/8115_01_mangos_playercreateinfo_action.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_8112_01_mangos_spell_proc_event required_8115_01_mangos_playercreateinfo_action bit;
   2
   3 TRUNCATE TABLE `playercreateinfo_action`;
   4 INSERT INTO `playercreateinfo_action` VALUES
   5 (1,1,1,78,0),
   6 (1,1,0,6603,0),
   7 (1,1,11,117,128),
   8 (1,2,2,635,0),
   9 (1,2,0,6603,0),
  10 (1,2,1,21084,0),
  11 (1,2,10,159,128),
  12 (1,2,11,2070,128),
  13 (1,4,1,1752,0),
  14 (1,4,2,2098,0),
  15 (1,4,3,2764,0),
  16 (1,4,0,6603,0),
  17 (1,4,11,2070,128),
  18 (1,5,1,585,0),
  19 (1,5,2,2050,0),
  20 (1,5,0,6603,0),
  21 (1,5,10,159,128),
  22 (1,5,11,2070,128),
  23 (1,6,0,6603,0),
  24 (1,6,1,49576,0),
  25 (1,6,2,45477,0),
  26 (1,6,3,45462,0),
  27 (1,6,4,45902,0),
  28 (1,6,5,47541,0),
  29 (1,6,11,59752,0),
  30 (1,8,1,133,0),
  31 (1,8,2,168,0),
  32 (1,8,0,6603,0),
  33 (1,8,10,159,128),
  34 (1,8,11,2070,128),
  35 (1,9,1,686,0),
  36 (1,9,2,687,0),
  37 (1,9,0,6603,0),
  38 (1,9,10,159,128),
  39 (1,9,11,4604,128),
  40 (2,1,1,78,0),
  41 (2,1,0,6603,0),
  42 (2,1,11,117,128),
  43 (2,3,2,75,0),
  44 (2,3,1,2973,0),
  45 (2,3,0,6603,0),
  46 (2,3,11,117,128),
  47 (2,3,10,159,128),
  48 (2,4,10,0,128),
  49 (2,4,1,1752,0),
  50 (2,4,2,2098,0),
  51 (2,4,0,6603,0),
  52 (2,4,11,117,128),
  53 (2,6,0,6603,0),
  54 (2,6,1,49576,0),
  55 (2,6,2,45477,0),
  56 (2,6,3,45462,0),
  57 (2,6,4,45902,0),
  58 (2,6,5,47541,0),
  59 (2,6,10,20572,0),
  60 (2,7,2,331,0),
  61 (2,7,1,403,0),
  62 (2,7,0,6603,0),
  63 (2,7,11,117,128),
  64 (2,7,10,159,128),
  65 (2,9,1,686,0),
  66 (2,9,2,687,0),
  67 (2,9,0,6603,0),
  68 (2,9,11,117,128),
  69 (2,9,10,159,128),
  70 (3,1,1,78,0),
  71 (3,1,0,6603,0),
  72 (3,1,11,117,128),
  73 (3,2,2,635,0),
  74 (3,2,0,6603,0),
  75 (3,2,1,21084,0),
  76 (3,2,10,159,128),
  77 (3,2,11,4540,128),
  78 (3,3,2,75,0),
  79 (3,3,1,2973,0),
  80 (3,3,0,6603,0),
  81 (3,3,11,117,128),
  82 (3,3,10,159,128),
  83 (3,4,1,1752,0),
  84 (3,4,2,2098,0),
  85 (3,4,3,2764,0),
  86 (3,4,0,6603,0),
  87 (3,4,11,4540,128),
  88 (3,5,1,585,0),
  89 (3,5,2,2050,0),
  90 (3,5,0,6603,0),
  91 (3,5,10,159,128),
  92 (3,5,11,4540,128),
  93 (3,6,0,6603,0),
  94 (3,6,1,49576,0),
  95 (3,6,2,45477,0),
  96 (3,6,3,45462,0),
  97 (3,6,4,45902,0),
  98 (3,6,5,47541,0),
  99 (3,6,10,2481,0),
 100 (4,1,1,78,0),
 101 (4,1,0,6603,0),
 102 (4,1,11,117,128),
 103 (4,3,2,75,0),
 104 (4,3,1,2973,0),
 105 (4,3,0,6603,0),
 106 (4,3,11,117,128),
 107 (4,3,10,159,128),
 108 (4,4,1,1752,0),
 109 (4,4,2,2098,0),
 110 (4,4,3,2764,0),
 111 (4,4,0,6603,0),
 112 (4,4,11,4540,128),
 113 (4,5,1,585,0),
 114 (4,5,2,2050,0),
 115 (4,5,0,6603,0),
 116 (4,5,10,159,128),
 117 (4,5,11,2070,128),
 118 (4,6,0,6603,0),
 119 (4,6,1,49576,0),
 120 (4,6,2,45477,0),
 121 (4,6,3,45462,0),
 122 (4,6,4,45902,0),
 123 (4,6,5,47541,0),
 124 (4,6,10,58984,0),
 125 (4,6,83,58984,0),
 126 (4,11,1,5176,0),
 127 (4,11,2,5185,0),
 128 (4,11,0,6603,0),
 129 (4,11,10,159,128),
 130 (4,11,11,4536,128),
 131 (5,1,11,4604,128),
 132 (5,1,0,6603,0),
 133 (5,1,1,78,0),
 134 (5,4,11,4604,128),
 135 (5,4,3,2764,0),
 136 (5,4,2,2098,0),
 137 (5,4,1,1752,0),
 138 (5,4,0,6603,0),
 139 (5,5,10,159,128),
 140 (5,5,2,2050,0),
 141 (5,5,1,585,0),
 142 (5,5,11,4604,128),
 143 (5,5,0,6603,0),
 144 (5,6,0,6603,0),
 145 (5,6,1,49576,0),
 146 (5,6,2,45477,0),
 147 (5,6,3,45462,0),
 148 (5,6,4,45902,0),
 149 (5,6,5,47541,0),
 150 (5,6,10,20577,0),
 151 (5,8,11,4604,128),
 152 (5,8,10,159,128),
 153 (5,8,2,168,0),
 154 (5,8,1,133,0),
 155 (5,8,0,6603,0),
 156 (5,9,1,686,0),
 157 (5,9,10,159,128),
 158 (5,9,2,687,0),
 159 (5,9,11,4604,128),
 160 (5,9,0,6603,0),
 161 (6,1,1,78,0),
 162 (6,1,2,20549,0),
 163 (6,1,11,4540,128),
 164 (6,1,0,6603,0),
 165 (6,3,1,2973,0),
 166 (6,3,10,159,128),
 167 (6,3,2,75,0),
 168 (6,3,3,20549,0),
 169 (6,3,11,117,128),
 170 (6,3,0,6603,0),
 171 (6,6,0,6603,0),
 172 (6,6,1,49576,0),
 173 (6,6,2,45477,0),
 174 (6,6,3,45462,0),
 175 (6,6,4,45902,0),
 176 (6,6,5,47541,0),
 177 (6,6,10,20549,0),
 178 (6,6,75,20549,0),
 179 (6,7,1,403,0),
 180 (6,7,10,159,128),
 181 (6,7,2,331,0),
 182 (6,7,3,20549,0),
 183 (6,7,11,4604,128),
 184 (6,7,0,6603,0),
 185 (6,11,1,5176,0),
 186 (6,11,10,159,128),
 187 (6,11,2,5185,0),
 188 (6,11,3,20549,0),
 189 (6,11,11,4536,128),
 190 (6,11,0,6603,0),
 191 (7,1,11,117,128),
 192 (7,1,1,78,0),
 193 (7,1,0,6603,0),
 194 (7,4,11,117,128),
 195 (7,4,3,2764,0),
 196 (7,4,1,1752,0),
 197 (7,4,2,2098,0),
 198 (7,4,0,6603,0),
 199 (7,6,0,6603,0),
 200 (7,6,1,49576,0),
 201 (7,6,2,45477,0),
 202 (7,6,3,45462,0),
 203 (7,6,4,45902,0),
 204 (7,6,5,47541,0),
 205 (7,6,10,20589,0),
 206 (7,6,72,6603,0),
 207 (7,6,83,117,128),
 208 (7,6,84,6603,0),
 209 (7,6,96,6603,0),
 210 (7,6,108,6603,0),
 211 (7,8,11,4536,128),
 212 (7,8,1,133,0),
 213 (7,8,2,168,0),
 214 (7,8,10,159,128),
 215 (7,8,0,6603,0),
 216 (7,9,11,4604,128),
 217 (7,9,1,686,0),
 218 (7,9,2,687,0),
 219 (7,9,10,159,128),
 220 (7,9,0,6603,0),
 221 (8,1,11,117,128),
 222 (8,1,1,78,0),
 223 (8,1,3,2764,0),
 224 (8,1,0,6603,0),
 225 (8,3,10,159,128),
 226 (8,3,11,4604,128),
 227 (8,3,1,2973,0),
 228 (8,3,2,75,0),
 229 (8,3,0,6603,0),
 230 (8,4,1,1752,0),
 231 (8,4,3,2764,0),
 232 (8,4,2,2098,0),
 233 (8,4,11,117,128),
 234 (8,4,0,6603,0),
 235 (8,5,1,585,0),
 236 (8,5,10,159,128),
 237 (8,5,2,2050,0),
 238 (8,5,11,4540,128),
 239 (8,5,0,6603,0),
 240 (8,6,0,6603,0),
 241 (8,6,1,49576,0),
 242 (8,6,2,45477,0),
 243 (8,6,3,45462,0),
 244 (8,6,4,45902,0),
 245 (8,6,5,47541,0),
 246 (8,6,10,50621,0),
 247 (8,7,1,403,0),
 248 (8,7,10,159,128),
 249 (8,7,2,331,0),
 250 (8,7,11,117,128),
 251 (8,7,0,6603,0),
 252 (8,8,1,133,0),
 253 (8,8,10,159,128),
 254 (8,8,2,168,0),
 255 (8,8,11,117,128),
 256 (8,8,0,6603,0),
 257 (10,2,0,6603,0),
 258 (10,2,1,21084,0),
 259 (10,2,2,635,0),
 260 (10,2,3,28734,0),
 261 (10,2,4,28730,0),
 262 (10,2,10,159,128),
 263 (10,2,11,20857,128),
 264 (10,3,0,6603,0),
 265 (10,3,1,2973,0),
 266 (10,3,2,75,0),
 267 (10,3,3,28734,0),
 268 (10,3,4,28730,0),
 269 (10,3,10,159,128),
 270 (10,3,11,20857,128),
 271 (10,4,0,6603,0),
 272 (10,4,1,1752,0),
 273 (10,4,2,2098,0),
 274 (10,4,3,2764,0),
 275 (10,4,4,28734,0),
 276 (10,4,5,25046,0),
 277 (10,4,11,20857,128),
 278 (10,5,0,6603,0),
 279 (10,5,1,585,0),
 280 (10,5,2,2050,0),
 281 (10,5,3,28734,0),
 282 (10,5,4,28730,0),
 283 (10,5,10,159,128),
 284 (10,5,11,20857,128),
 285 (10,6,0,6603,0),
 286 (10,6,1,49576,0),
 287 (10,6,2,45477,0),
 288 (10,6,3,45462,0),
 289 (10,6,4,45902,0),
 290 (10,6,5,47541,0),
 291 (10,6,6,50613,0),
 292 (10,8,0,6603,0),
 293 (10,8,1,133,0),
 294 (10,8,2,168,0),
 295 (10,8,3,28734,0),
 296 (10,8,4,28730,0),
 297 (10,8,10,159,128),
 298 (10,8,11,20857,128),
 299 (10,9,11,20857,128),
 300 (10,9,10,159,128),
 301 (10,9,4,28730,0),
 302 (10,9,3,28734,0),
 303 (10,9,2,687,0),
 304 (10,9,1,686,0),
 305 (10,9,0,6603,0),
 306 (11,1,0,6603,0),
 307 (11,1,72,6603,0),
 308 (11,1,73,78,0),
 309 (11,1,74,28880,0),
 310 (11,1,83,4540,128),
 311 (11,1,84,6603,0),
 312 (11,1,96,6603,0),
 313 (11,1,108,6603,0),
 314 (11,2,0,6603,0),
 315 (11,2,1,21084,0),
 316 (11,2,2,635,0),
 317 (11,2,3,59542,0),
 318 (11,2,10,159,128),
 319 (11,2,11,4540,128),
 320 (11,2,83,4540,128),
 321 (11,3,0,6603,0),
 322 (11,3,1,2973,0),
 323 (11,3,2,75,0),
 324 (11,3,3,59543,0),
 325 (11,3,10,159,128),
 326 (11,3,11,4540,128),
 327 (11,3,72,6603,0),
 328 (11,3,73,2973,0),
 329 (11,3,74,75,0),
 330 (11,3,82,159,128),
 331 (11,3,83,4540,128),
 332 (11,5,0,6603,0),
 333 (11,5,1,585,0),
 334 (11,5,2,2050,0),
 335 (11,5,3,59544,0),
 336 (11,5,10,159,128),
 337 (11,5,11,4540,128),
 338 (11,5,83,4540,128),
 339 (11,6,0,6603,0),
 340 (11,6,1,49576,0),
 341 (11,6,2,45477,0),
 342 (11,6,3,45462,0),
 343 (11,6,4,45902,0),
 344 (11,6,5,47541,0),
 345 (11,6,6,59545,0),
 346 (11,7,0,6603,0),
 347 (11,7,1,403,0),
 348 (11,7,2,331,0),
 349 (11,7,3,59547,0),
 350 (11,7,10,159,128),
 351 (11,7,11,4540,128),
 352 (11,8,0,6603,0),
 353 (11,8,1,133,0),
 354 (11,8,2,168,0),
 355 (11,8,3,59548,0),
 356 (11,8,10,159,128),
 357 (11,8,11,4540,128),
 358 (11,8,83,4540,128);