[Sever khác] Hướng dẫn Add Lv & Skill 120

by **Ruby** Wed Jul 04, 2012 12:29 pm

Ruby: User's Founder; Bài viết : 460
Ryo : 4839
Cảm ơn : 3022
Date : 09/04/2012
Tuổi : 25
Đến từ : Việt Nam

Post n°1

[Sever khác] Hướng dẫn Add Lv & Skill 120

by Ruby Wed Jul 04, 2012 12:29 pm

Không nói nhiều vào thằng luôn

[Sever khác] Hướng dẫn Add Lv & Skill 120 A41cc492963ab41ebad32ee074fc7d7a_37946238.sro2011111321520074

[Sever khác] Hướng dẫn Add Lv & Skill 120 019e50d3051fa6e5ccff3653f55cb52a_37946248.sro2011111321514862

[Sever khác] Hướng dẫn Add Lv & Skill 120 F3352cb7392c944b0be95b3ae667aa84_37946256.sro2011111321515545

Fix up Lv 111-120
Fix lv skill 360
Fix lv pet 120
vv....

Download:

Pass:

Đã có video hướng dẩn trong Link downlaod các bạn down về mà cheến thôi ! Sắp tới mình sả share add đồ D12 ^^

Dưới đây là fix hoàn toàn lv120 skill không bị lỗi đánh 1 2 phát là đứng cho db. Chạy query theo đúng thứ tự với SRO_VT_SHARD
Chúc các bạn thành công.

2 cái query trên mình lấy ngay trong topic [DEV] add level 120 skills trên ragezone cho nhanh.

Còn dưới là fix lỗi skill đánh 1 - 2 phát là thôi với các kiểu combo. Blade đánh combo đẹp lắm nha. Làm thủ công nên viết ra query chỉnh dễ hơn là chỉnh trực tiếp trong db

UPDATE dbo._RefSkill SET Basic_ChainCode = 7169
WHERE ID = 7159

UPDATE dbo._RefSkill SET Basic_ChainCode = 7170
WHERE ID = 7160

UPDATE dbo._RefSkill SET Basic_ChainCode = 7171
WHERE ID = 7161

UPDATE dbo._RefSkill SET Basic_ChainCode = 7179
WHERE ID = 7169

UPDATE dbo._RefSkill SET Basic_ChainCode = 7180
WHERE ID = 7170

UPDATE dbo._RefSkill SET Basic_ChainCode = 7181
WHERE ID = 7171

UPDATE dbo._RefSkill SET Basic_ChainCode = 30154
WHERE ID = 30151

UPDATE dbo._RefSkill SET Basic_ChainCode = 30155
WHERE ID = 30152

UPDATE dbo._RefSkill SET Basic_ChainCode = 30156
WHERE ID = 30153

UPDATE dbo._RefSkill SET Basic_ChainCode = 30157
WHERE ID = 30154

UPDATE dbo._RefSkill SET Basic_ChainCode = 30158
WHERE ID = 30155

UPDATE dbo._RefSkill SET Basic_ChainCode = 30159
WHERE ID = 30156

UPDATE dbo._RefSkill SET Basic_ChainCode = 33381
WHERE ID = 21203

UPDATE dbo._RefSkill SET Basic_ChainCode = 33382
WHERE ID = 33381

UPDATE dbo._RefSkill SET Basic_ChainCode = 7226
WHERE ID = 7204

UPDATE dbo._RefSkill SET Basic_ChainCode = 7227
WHERE ID = 7205

UPDATE dbo._RefSkill SET Basic_ChainCode = 7228
WHERE ID = 7206

UPDATE dbo._RefSkill SET Basic_ChainCode = 7248
WHERE ID = 7226

UPDATE dbo._RefSkill SET Basic_ChainCode = 7249
WHERE ID = 7227

UPDATE dbo._RefSkill SET Basic_ChainCode = 7250
WHERE ID = 7228

UPDATE dbo._RefSkill SET Basic_ChainCode = 7270
WHERE ID = 7248

UPDATE dbo._RefSkill SET Basic_ChainCode = 7271
WHERE ID = 7249

UPDATE dbo._RefSkill SET Basic_ChainCode = 7272
WHERE ID = 7250

UPDATE dbo._RefSkill SET Basic_ChainCode = 7292
WHERE ID = 7270

UPDATE dbo._RefSkill SET Basic_ChainCode = 7293
WHERE ID = 7271

UPDATE dbo._RefSkill SET Basic_ChainCode = 7294
WHERE ID = 7272

UPDATE dbo._RefSkill SET Basic_ChainCode = 7314
WHERE ID = 7292

UPDATE dbo._RefSkill SET Basic_ChainCode = 7315
WHERE ID = 7293

UPDATE dbo._RefSkill SET Basic_ChainCode = 7316
WHERE ID = 7294

UPDATE dbo._RefSkill SET Basic_ChainCode = 7332
WHERE ID = 7323

UPDATE dbo._RefSkill SET Basic_ChainCode = 7333
WHERE ID = 7324

UPDATE dbo._RefSkill SET Basic_ChainCode = 7334
WHERE ID = 7325

UPDATE dbo._RefSkill SET Basic_ChainCode = 7341
WHERE ID = 7332

UPDATE dbo._RefSkill SET Basic_ChainCode = 7342
WHERE ID = 7333

UPDATE dbo._RefSkill SET Basic_ChainCode = 7343
WHERE ID = 7334

UPDATE dbo._RefSkill SET Basic_ChainCode = 7350
WHERE ID = 7341

UPDATE dbo._RefSkill SET Basic_ChainCode = 7351
WHERE ID = 7342

UPDATE dbo._RefSkill SET Basic_ChainCode = 7352
WHERE ID = 7343

UPDATE dbo._RefSkill SET Basic_ChainCode = 7359
WHERE ID = 7350

UPDATE dbo._RefSkill SET Basic_ChainCode = 7360
WHERE ID = 7351

UPDATE dbo._RefSkill SET Basic_ChainCode = 7361
WHERE ID = 7352

UPDATE dbo._RefSkill SET Basic_ChainCode = 7368
WHERE ID = 7359

UPDATE dbo._RefSkill SET Basic_ChainCode = 7369
WHERE ID = 7360

UPDATE dbo._RefSkill SET Basic_ChainCode = 7370
WHERE ID = 7361

UPDATE dbo._RefSkill SET Basic_ChainCode = 7372
WHERE ID = 7371

UPDATE dbo._RefSkill SET Basic_ChainCode = 7373
WHERE ID = 7372

UPDATE dbo._RefSkill SET Basic_ChainCode = 7374
WHERE ID = 7373

UPDATE dbo._RefSkill SET Basic_ChainCode = 7375
WHERE ID = 7374

UPDATE dbo._RefSkill SET Basic_ChainCode = 7376
WHERE ID = 7375

UPDATE dbo._RefSkill SET Basic_ChainCode = 7377
WHERE ID = 7376

UPDATE dbo._RefSkill SET Basic_ChainCode = 7426
WHERE ID = 7419

UPDATE dbo._RefSkill SET Basic_ChainCode = 7427
WHERE ID = 7420

UPDATE dbo._RefSkill SET Basic_ChainCode = 7433
WHERE ID = 7426

UPDATE dbo._RefSkill SET Basic_ChainCode = 7434
WHERE ID = 7427

UPDATE dbo._RefSkill SET Basic_ChainCode = 7436
WHERE ID = 7435

UPDATE dbo._RefSkill SET Basic_ChainCode = 7437
WHERE ID = 7436

UPDATE dbo._RefSkill SET Basic_ChainCode = 7461
WHERE ID = 7456

UPDATE dbo._RefSkill SET Basic_ChainCode = 7462
WHERE ID = 7457

UPDATE dbo._RefSkill SET Basic_ChainCode = 7463
WHERE ID = 7458

UPDATE dbo._RefSkill SET Basic_ChainCode = 7464
WHERE ID = 7459

UPDATE dbo._RefSkill SET Basic_ChainCode = 7465
WHERE ID = 7460

UPDATE dbo._RefSkill SET Basic_ChainCode = 7489
WHERE ID = 7484

UPDATE dbo._RefSkill SET Basic_ChainCode = 7490
WHERE ID = 7485

UPDATE dbo._RefSkill SET Basic_ChainCode = 7491
WHERE ID = 7486

UPDATE dbo._RefSkill SET Basic_ChainCode = 7492
WHERE ID = 7487

UPDATE dbo._RefSkill SET Basic_ChainCode = 7493
WHERE ID = 7488

UPDATE dbo._RefSkill SET Basic_ChainCode = 7495
WHERE ID = 7494

UPDATE dbo._RefSkill SET Basic_ChainCode = 7527
WHERE ID = 7526

UPDATE dbo._RefSkill SET Basic_ChainCode = 7567
WHERE ID = 7564

UPDATE dbo._RefSkill SET Basic_ChainCode = 7568
WHERE ID = 7565

UPDATE dbo._RefSkill SET Basic_ChainCode = 7569
WHERE ID = 7566

UPDATE dbo._RefSkill SET Basic_ChainCode = 7704
WHERE ID = 7689

UPDATE dbo._RefSkill SET Basic_ChainCode = 7705
WHERE ID = 7690

UPDATE dbo._RefSkill SET Basic_ChainCode = 7706
WHERE ID = 7691

UPDATE dbo._RefSkill SET Basic_ChainCode = 7707
WHERE ID = 7692

UPDATE dbo._RefSkill SET Basic_ChainCode = 7708
WHERE ID = 7693

UPDATE dbo._RefSkill SET Basic_ChainCode = 7719
WHERE ID = 7704

UPDATE dbo._RefSkill SET Basic_ChainCode = 7720
WHERE ID = 7705

UPDATE dbo._RefSkill SET Basic_ChainCode = 7721
WHERE ID = 7706

UPDATE dbo._RefSkill SET Basic_ChainCode = 7722
WHERE ID = 7707

UPDATE dbo._RefSkill SET Basic_ChainCode = 7723
WHERE ID = 7708

UPDATE dbo._RefSkill SET Basic_ChainCode = 7734
WHERE ID = 7719

UPDATE dbo._RefSkill SET Basic_ChainCode = 7735
WHERE ID = 7720

UPDATE dbo._RefSkill SET Basic_ChainCode = 7736
WHERE ID = 7721

UPDATE dbo._RefSkill SET Basic_ChainCode = 7737
WHERE ID = 7722

UPDATE dbo._RefSkill SET Basic_ChainCode = 7738
WHERE ID = 7723

UPDATE dbo._RefSkill SET Basic_ChainCode = 7749
WHERE ID = 7734

UPDATE dbo._RefSkill SET Basic_ChainCode = 7750
WHERE ID = 7735

UPDATE dbo._RefSkill SET Basic_ChainCode = 7751
WHERE ID = 7736

UPDATE dbo._RefSkill SET Basic_ChainCode = 7752
WHERE ID = 7737

UPDATE dbo._RefSkill SET Basic_ChainCode = 7753
WHERE ID = 7738

UPDATE dbo._RefSkill SET Basic_ChainCode = 7764
WHERE ID = 7749

UPDATE dbo._RefSkill SET Basic_ChainCode = 7765
WHERE ID = 7750

UPDATE dbo._RefSkill SET Basic_ChainCode = 7766
WHERE ID = 7751

UPDATE dbo._RefSkill SET Basic_ChainCode = 7767
WHERE ID = 7752

UPDATE dbo._RefSkill SET Basic_ChainCode = 7768
WHERE ID = 7753

UPDATE dbo._RefSkill SET Basic_ChainCode = 7772
WHERE ID = 7769

UPDATE dbo._RefSkill SET Basic_ChainCode = 7773
WHERE ID = 7770

UPDATE dbo._RefSkill SET Basic_ChainCode = 7774
WHERE ID = 7771

UPDATE dbo._RefSkill SET Basic_ChainCode = 7775
WHERE ID = 7772

UPDATE dbo._RefSkill SET Basic_ChainCode = 7776
WHERE ID = 7773

UPDATE dbo._RefSkill SET Basic_ChainCode = 7777
WHERE ID = 7774

UPDATE dbo._RefSkill SET Basic_ChainCode = 7778
WHERE ID = 7775

UPDATE dbo._RefSkill SET Basic_ChainCode = 7779
WHERE ID = 7776

UPDATE dbo._RefSkill SET Basic_ChainCode = 7780
WHERE ID = 7777

UPDATE dbo._RefSkill SET Basic_ChainCode = 7781
WHERE ID = 7778

UPDATE dbo._RefSkill SET Basic_ChainCode = 7782
WHERE ID = 7779

UPDATE dbo._RefSkill SET Basic_ChainCode = 7783
WHERE ID = 7780

UPDATE dbo._RefSkill SET Basic_ChainCode = 7784
WHERE ID = 7781

UPDATE dbo._RefSkill SET Basic_ChainCode = 7785
WHERE ID = 7782

UPDATE dbo._RefSkill SET Basic_ChainCode = 7786
WHERE ID = 7783

UPDATE dbo._RefSkill SET Basic_ChainCode = 7787
WHERE ID = 7784

UPDATE dbo._RefSkill SET Basic_ChainCode = 7788
WHERE ID = 7785

UPDATE dbo._RefSkill SET Basic_ChainCode = 7789
WHERE ID = 7786

UPDATE dbo._RefSkill SET Basic_ChainCode = 7658
WHERE ID = 7651

UPDATE dbo._RefSkill SET Basic_ChainCode = 7659
WHERE ID = 7652

UPDATE dbo._RefSkill SET Basic_ChainCode = 7660
WHERE ID = 7653

UPDATE dbo._RefSkill SET Basic_ChainCode = 20466
WHERE ID = 7658

UPDATE dbo._RefSkill SET Basic_ChainCode = 20467
WHERE ID = 7659

UPDATE dbo._RefSkill SET Basic_ChainCode = 20468
WHERE ID = 7660

UPDATE dbo._RefSkill SET Basic_ChainCode = 7662
WHERE ID = 7661

UPDATE dbo._RefSkill SET Basic_ChainCode = 7663
WHERE ID = 7662

UPDATE dbo._RefSkill SET Basic_ChainCode = 7816
WHERE ID = 7806

UPDATE dbo._RefSkill SET Basic_ChainCode = 7817
WHERE ID = 7807

UPDATE dbo._RefSkill SET Basic_ChainCode = 7818
WHERE ID = 7808

UPDATE dbo._RefSkill SET Basic_ChainCode = 7820
WHERE ID = 7819

UPDATE dbo._RefSkill SET Basic_ChainCode = 7623
WHERE ID = 7620

UPDATE dbo._RefSkill SET Basic_ChainCode = 7624
WHERE ID = 7621

UPDATE dbo._RefSkill SET Basic_ChainCode = 7625
WHERE ID = 7622

UPDATE dbo._RefSkill SET Basic_ChainCode = 7626
WHERE ID = 7623

UPDATE dbo._RefSkill SET Basic_ChainCode = 7627
WHERE ID = 7624

UPDATE dbo._RefSkill SET Basic_ChainCode = 7628
WHERE ID = 7625

UPDATE dbo._RefSkill SET Basic_ChainCode = 20486
WHERE ID = 7863

UPDATE dbo._RefSkill SET Basic_ChainCode = 20487
WHERE ID = 7864

UPDATE dbo._RefSkill SET Basic_ChainCode = 20488
WHERE ID = 7865

UPDATE dbo._RefSkill SET Basic_ChainCode = 20489
WHERE ID = 20486

UPDATE dbo._RefSkill SET Basic_ChainCode = 20490
WHERE ID = 20487

UPDATE dbo._RefSkill SET Basic_ChainCode = 20491
WHERE ID = 20488

UPDATE dbo._RefSkill SET Basic_ChainCode = 8739
WHERE ID = 8724

UPDATE dbo._RefSkill SET Basic_ChainCode = 8740
WHERE ID = 8725

UPDATE dbo._RefSkill SET Basic_ChainCode = 8789
WHERE ID = 8776

UPDATE dbo._RefSkill SET Basic_ChainCode = 8790
WHERE ID = 8777

UPDATE dbo._RefSkill SET Basic_ChainCode = 8802
WHERE ID = 8789

UPDATE dbo._RefSkill SET Basic_ChainCode = 8803
WHERE ID = 8790

UPDATE dbo._RefSkill SET Basic_ChainCode = 8841
WHERE ID = 8830

UPDATE dbo._RefSkill SET Basic_ChainCode = 8842
WHERE ID = 8831

UPDATE dbo._RefSkill SET Basic_ChainCode = 8843
WHERE ID = 8832

UPDATE dbo._RefSkill SET Basic_ChainCode = 8852
WHERE ID = 8841

UPDATE dbo._RefSkill SET Basic_ChainCode = 8853
WHERE ID = 8842

UPDATE dbo._RefSkill SET Basic_ChainCode = 8854
WHERE ID = 8843

UPDATE dbo._RefSkill SET Basic_ChainCode = 9011
WHERE ID = 8998

UPDATE dbo._RefSkill SET Basic_ChainCode = 9012
WHERE ID = 8999

UPDATE dbo._RefSkill SET Basic_ChainCode = 9024
WHERE ID = 9011

UPDATE dbo._RefSkill SET Basic_ChainCode = 9025
WHERE ID = 9012

UPDATE dbo._RefSkill SET Basic_ChainCode = 9228
WHERE ID = 9213

UPDATE dbo._RefSkill SET Basic_ChainCode = 9929
WHERE ID = 9214

UPDATE dbo._RefSkill SET Basic_ChainCode = 9243
WHERE ID = 9228

UPDATE dbo._RefSkill SET Basic_ChainCode = 9244
WHERE ID = 9229

UPDATE dbo._RefSkill SET Basic_ChainCode = 9299
WHERE ID = 9286

UPDATE dbo._RefSkill SET Basic_ChainCode = 9300
WHERE ID = 9287

UPDATE dbo._RefSkill SET Basic_ChainCode = 9312
WHERE ID = 9299

UPDATE dbo._RefSkill SET Basic_ChainCode = 9313
WHERE ID = 9300

UPDATE dbo._RefSkill SET Basic_ChainCode = 9351
WHERE ID = 9340

UPDATE dbo._RefSkill SET Basic_ChainCode = 9352
WHERE ID = 9341

UPDATE dbo._RefSkill SET Basic_ChainCode = 9353
WHERE ID = 9342

UPDATE dbo._RefSkill SET Basic_ChainCode = 9562
WHERE ID = 9545

UPDATE dbo._RefSkill SET Basic_ChainCode = 9643
WHERE ID = 9632

UPDATE dbo._RefSkill SET Basic_ChainCode = 9644
WHERE ID = 9633

UPDATE dbo._RefSkill SET Basic_ChainCode = 9645
WHERE ID = 9634

UPDATE dbo._RefSkill SET Basic_ChainCode = 9815
WHERE ID = 9799

UPDATE dbo._RefSkill SET Basic_ChainCode = 9816
WHERE ID = 9800

UPDATE dbo._RefSkill SET Basic_ChainCode = 9817
WHERE ID = 9801

UPDATE dbo._RefSkill SET Basic_ChainCode = 9831
WHERE ID = 9815

UPDATE dbo._RefSkill SET Basic_ChainCode = 9832
WHERE ID = 9816

UPDATE dbo._RefSkill SET Basic_ChainCode = 9833
WHERE ID = 9817

UPDATE dbo._RefSkill SET Basic_ChainCode = 9909
WHERE ID = 9898

UPDATE dbo._RefSkill SET Basic_ChainCode = 9910
WHERE ID = 9899

UPDATE dbo._RefSkill SET Basic_ChainCode = 9911
WHERE ID = 9900

UPDATE dbo._RefSkill SET Basic_ChainCode = 9920
WHERE ID = 9909

UPDATE dbo._RefSkill SET Basic_ChainCode = 9921
WHERE ID = 9910

UPDATE dbo._RefSkill SET Basic_ChainCode = 9922
WHERE ID = 9911

UPDATE dbo._RefSkill SET Basic_ChainCode = 10151
WHERE ID = 10136

UPDATE dbo._RefSkill SET Basic_ChainCode = 10152
WHERE ID = 10137

UPDATE dbo._RefSkill SET Basic_ChainCode = 10427
WHERE ID = 10416

UPDATE dbo._RefSkill SET Basic_ChainCode = 10428
WHERE ID = 10417

UPDATE dbo._RefSkill SET Basic_ChainCode = 10429
WHERE ID = 10418

UPDATE dbo._RefSkill SET Basic_ChainCode = 10438
WHERE ID = 10427

UPDATE dbo._RefSkill SET Basic_ChainCode = 10439
WHERE ID = 10428

UPDATE dbo._RefSkill SET Basic_ChainCode = 10440
WHERE ID = 10429

UPDATE dbo._RefSkill SET Basic_ChainCode = 10449
WHERE ID = 10438

UPDATE dbo._RefSkill SET Basic_ChainCode = 10450
WHERE ID = 10439

UPDATE dbo._RefSkill SET Basic_ChainCode = 10451
WHERE ID = 10440

UPDATE dbo._RefSkill SET Basic_ChainCode = 10460
WHERE ID = 10449

UPDATE dbo._RefSkill SET Basic_ChainCode = 10461
WHERE ID = 10450

UPDATE dbo._RefSkill SET Basic_ChainCode = 10462
WHERE ID = 10451

UPDATE dbo._RefSkill SET Basic_ChainCode = 10471
WHERE ID = 10460

UPDATE dbo._RefSkill SET Basic_ChainCode = 10472
WHERE ID = 10461

UPDATE dbo._RefSkill SET Basic_ChainCode = 10473
WHERE ID = 10462

UPDATE dbo._RefSkill SET Basic_ChainCode = 10482
WHERE ID = 10471

UPDATE dbo._RefSkill SET Basic_ChainCode = 10483
WHERE ID = 10472

UPDATE dbo._RefSkill SET Basic_ChainCode = 10484
WHERE ID = 10473

UPDATE dbo._RefSkill SET Basic_ChainCode = 10616
WHERE ID = 10605

UPDATE dbo._RefSkill SET Basic_ChainCode = 10617
WHERE ID = 10606

UPDATE dbo._RefSkill SET Basic_ChainCode = 10618