UNDY SC&3KBUF&400 AC EKLEME

ITEM Tablosuna Girilecekler ;


Kod:
820081000 Scroll of Armor 400 (+0) 255 15 0 0 0 0 0 1 30 2000 0 400 0 620001 0 70 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
820082000 HP Scroll 3000 (+0) 255 15 0 0 0 0 0 1 30 2000 0 0 0 620002 0 70 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
820083000 Undying Scroll 255 15 0 0 0 0 0 1 30 2000 0 0 0 620003 0 62 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MAGIC Tablosuna Girilecekler ;

Kod:
620001 Scroll of Armor 400(L) Aura Increase Defense by 400 0 0 0 1 702 1 0 0 0 0 9 820081000 0 180 100 4 0 0 1 0
620002 HP Scroll 3000(L) Aura Increase HP by 3000 0 0 0 1 702 1 0 0 0 0 9 820082000 0 180 100 4 0 25 1 0
620003 Undying Scroll Aura Increase party member's maximum HP by 60% 0 0 0 1 702 1 0 0 0 0 9 820083000 0 180 100 4 0 25 1 0
MAGIC_TYPE4 Tablosuna Girilecekler ;


Kod:
620001 Scroll of Armor 400(L) Increase Defense by 400 2 0 1800 100 100 400 100 100 100 0 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
620002 HP Scroll 3000(L) Increase HP by 3000 1 0 1800 100 100 0 100 100 100 3000 100 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
620003 Undying Scroll Increase party member's maximum HP by 60% 1 0 1800 100 100 0 100 100 100 0 160 0 100 100 100 0 0 0 0 0 0 0 0 0 0 0 0
SQL Query ;


Kod:
INSERT INTO ITEM VALUES (820081000, 'Scroll of Armor 400 (+0)', 255, 15, 0, 0 ,0 ,0 ,0 ,1 ,30, 2000, 0, 400, 0 ,620001, 0, 70, 99, 0, 0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO ITEM VALUES (820082000 ,'HP Scroll 3000 (+0)' ,255 ,15 ,0 ,0 ,0 ,0 ,0 ,1 ,30 ,2000 ,0 ,0 ,0 ,620002 ,0 ,70 ,99 ,0 ,0 ,0 ,0 ,0 ,0 ,0, 0 ,0 ,0, 0 ,0 ,0 ,0 ,0 ,0 ,0 ,0, 0, 0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0, 0 ,0);
INSERT INTO ITEM VALUES (820083000 ,'Undying Scroll' ,255, 15, 0 ,0 ,0 ,0 ,0 ,1 ,30 ,2000 ,0, 0, 0, 620003, 0 ,62 ,99 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO MAGIC VALUES (620001, '','Scroll of Armor 400(L)',' Aura Increase Defense by 400', 0, 0, 0, 1, 702, 1, 0, 0 ,0, 0, 9, 820081000, 0, 180, 100, 4 ,0 ,0 ,1 ,0);
INSERT INTO MAGIC VALUES (620002,'','HP Scroll 3000(L)',' Aura Increase HP by 3000', 0 ,0, 0 ,1 ,702, 1 ,0 ,0, 0, 0, 9, 820082000, 0 ,180 ,100 ,4 ,0, 25 ,1, 0);
INSERT INTO MAGIC VALUES (620003,'','Undying Scroll',' Aura Increase party member s maximum HP by 60%' ,0 ,0, 0, 1 ,702 ,1, 0, 0 ,0, 0 ,9 ,820083000 ,0 ,180 ,100 ,4 ,0 ,25, 1 ,0);
INSERT INTO MAGIC_TYPE4 VALUES (620001,' Scroll of Armor 400(L) ','Increase Defense by 400' ,2 ,0 ,1800, 100, 100, 400 ,100, 100, 100, 0 ,100, 0 ,100 ,100 ,100 ,0 ,0, 0, 0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO MAGIC_TYPE4 VALUES (620002 ,'HP Scroll 3000(L)',' Increase HP by 3000', 1 ,0, 1800, 100, 100, 0, 100 ,100, 100, 3000 ,100, 0, 100, 100 ,100, 0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);
INSERT INTO MAGIC_TYPE4 VALUES (620003 ,'Undying Scroll ','Increase party member s maximum HP by 60%', 1 ,0 ,1800 ,100 ,100 ,0, 100 ,100 ,100 ,0 ,160 ,0 ,100 ,100 ,100 ,0 ,0 ,0, 0, 0 ,0 ,0 ,0 ,0 ,0 ,0 ,0);

teşekürler