1299 db ye item ekleme

DB'ye Destek ITEM Eklemek - QA KODU

Öncelikle daha önceden eklenmişse siliyoruz

Qa kodu:

Kod:

[color=#000000][color=#0000bb]Delete from item where num [/color][color=#007700]= [/color][color=#dd0000]'999999990'  [/color][/color]

Daha sonra itemi ekleyelim

Kod:

insert into [ITEM] Values (999999990,'Destek Item',60,2,0,0,0,100,20,200,17000,84974,0,[color=darkorchid]1000[/color],0,0,0,1,99,0,0,100,0,0,0,0,0,4,0,0,[color=mediumturquoise]20,20,20,20,20,20[/color],[color=seagreen]100,100,100,100[/color],0,0,0,0,0,[color=blue]100,100,100,100,100,100,100[/color],[color=red]200,200,200,200,200,200[/color])

Bu ekledigimiz item ideal bir destek item sizler bunu istediginiz gibi degiştirebilirsiniz.

Kırmızı ile gösterilen : Resistans bonuslardır.(soldan 3 lr fr gr-Sag 3 magic posin curse)

Mavi ile gösterilen : Stats pointler (soldan itibaren 1. str 2. hp 3. dex 4.int 5.mp--6. Healt 7. mana)

Yeşil ile gösterilen : Vurdugu damageler (1.flame 2.Glacer 3. lighting 4.posion)

Açık mavi ile gösterilen : Defans abylity (1.dagger 2.sword 3. club 4.axe 5.spear 6. arrow)

Mor renkle yazılan: Verdigi defanstır.

Arkadaslar verdigi özellikleri istediginiz gibi degiştirebilirsiniz

Ekledigimiz İtemin özellikleri
Özellikleri

Kod:

[color=#000000][color=#0000bb]Attack Power [/color][color=#007700]: [/color][color=#0000bb]0
Weight [/color][color=#007700]: [/color][color=#0000bb]1
Max Durability [/color][color=#007700]: [/color][color=#0000bb]17000
Defense Ability [/color][color=#007700]: [/color][color=#0000bb]1000
[/color][color=#007700]+[/color][color=#0000bb]Defense Ability [/color][color=#007700]([/color][color=#0000bb]Dagger[/color][color=#007700]) : [/color][color=#0000bb]20
[/color][color=#007700]+[/color][color=#0000bb]Defense Ability [/color][color=#007700]([/color][color=#0000bb]Sword[/color][color=#007700]) : [/color][color=#0000bb]20
[/color][color=#007700]+[/color][color=#0000bb]Defense Ability [/color][color=#007700]([/color][color=#0000bb]Club[/color][color=#007700]) : [/color][color=#0000bb]20
[/color][color=#007700]+[/color][color=#0000bb]Defense Ability [/color][color=#007700]([/color][color=#0000bb]Axe[/color][color=#007700]) : [/color][color=#0000bb]20
[/color][color=#007700]+[/color][color=#0000bb]Defense Ability [/color][color=#007700]([/color][color=#0000bb]Spear[/color][color=#007700]) : [/color][color=#0000bb]20
[/color][color=#007700]+[/color][color=#0000bb]Defense Ability [/color][color=#007700]([/color][color=#0000bb]Arrow[/color][color=#007700]) : [/color][color=#0000bb]20
Flame Damage [/color][color=#007700]: [/color][color=#0000bb]100
Glacier Damage [/color][color=#007700]: [/color][color=#0000bb]100
Lightning Damage [/color][color=#007700]: [/color][color=#0000bb]100
Poison Damage [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]Strength Bonus [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]Health Bonus [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]HP Bonus [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]Dexterity Bonus [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]Intelligence Bonus [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]MP Bonus [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]Magic Power Bonus [/color][color=#007700]: [/color][color=#0000bb]100
[/color][color=#007700]+[/color][color=#0000bb]Resistance to Flame [/color][color=#007700]: [/color][color=#0000bb]200
[/color][color=#007700]+[/color][color=#0000bb]Resistance to Glacier [/color][color=#007700]: [/color][color=#0000bb]200
[/color][color=#007700]+[/color][color=#0000bb]Resistance to Lightning [/color][color=#007700]: [/color][color=#0000bb]200
[/color][color=#007700]+[/color][color=#0000bb]Resistance to Magic [/color][color=#007700]: [/color][color=#0000bb]200
[/color][color=#007700]+[/color][color=#0000bb]Resistance to Poison [/color][color=#007700]: [/color][color=#0000bb]200
[/color][color=#007700]+[/color][color=#0000bb]Resistance to Curse [/color][color=#007700]: [/color][color=#0000bb]200 
[/color][/color]

Not: İtem invertroyde gözükmez.

Ayrıca Konu Alıntıdır[/QUOTE]