Forumdaki paylaşımlardan yararlanmak için BURAYA TIKLAYARAK üye olmalısınız.

TUKETILEBILIR Item'leri Sınırlı ya da Sınırsız Yapma

'Prosedür Paylaşımları' forumunda Conqueror tarafından 4 Oca 2019 tarihinde açılan konu Yanıt: 0 | Gösterim: 18

  1. Conqueror

    Conqueror Üye

    Katılım:
    4 Oca 2019
    Mesaj:
    4
    Alınan Beğeniler:
    0
    Ödül Puanları:
    1
    Cinsiyet:
    Erkek
    Bazen sınırlı bir item'i sınırsız/kullandıkça tükenmez yapmak isteriz, bazen de sınırsız bir item'i sınırlı/kullandıkça tükenir yapmak isteriz. Konumuzda önce tükenir(sınırlı) yapma code'ları, sonra tükenmez/sınırsız yapma code'ları verilmiştir.





    1) Tüketilebilir Item'leri Sınırlı/Tükenir Yapma Code'ları :





    ------------------------------------------------------------------------------------------------------------------------------






    Weapon ve Armor Enchant Scroll'ları sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where Num = 389155000
    Delete from ITEM where Num = 389156000
    Delete from ITEM where Num = 800061000
    Delete from ITEM where Num = 800062000
    
    Delete from MAGIC where MagicNum = 500049
    Delete from MAGIC where MagicNum = 500050
    Delete from MAGIC where MagicNum = 500051
    Delete from MAGIC where MagicNum = 500052
    
    Delete from MAGIC_TYPE4 where iNum = 500049
    Delete from MAGIC_TYPE4 where iNum = 500050
    Delete from MAGIC_TYPE4 where iNum = 500051
    Delete from MAGIC_TYPE4 where iNum = 500052
    
    
    
    insert into [ITEM] values ('389155000','Weapon Enchant Scroll (+0)                        ','97','15','0','0','0','0','0','30','1','700000','0','0','1','500049','0','1','99','0','0','0','0','0','0','0','255','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 ('389156000','Armor Enchant Scroll (+0)                         ','97','15','0','0','0','0','0','30','1','300000','0','0','1','500050','0','1','99','0','0','0','0','0','0','0','255','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 ('800061000','Weapon Enchant Scroll(L) (+0)                     ','255','15','0','0','0','0','0','1','30','700000','10000','0','0','500051','0','1','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 ('800062000','Armor Enchant Scroll(L) (+0)                      ','255','15','0','0','0','0','0','1','30','300000','10000','0','0','500052','0','1','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 ('500049','Weapon Enchant Scroll','Weapon Enchant Scroll','Weapon Enchant Scroll','0','0','0','0','702','1','0','0','0','0','9','389155000','0','0','100','4','0','0','1','0');
    insert into [MAGIC] values ('500050','Armor Enchant Scroll','Armor Enchant Scroll','Armor Enchant Scroll','0','0','0','0','702','1','0','0','0','0','9','389156000','0','0','100','4','0','0','1','0');
    insert into [MAGIC] values ('500051','Weapon Enchant Scroll(L)','Weapon Enchant Scroll','Weapon Enchant Scroll','0','0','0','0','702','1','0','0','0','0','9','800061000','0','0','100','4','0','0','1','0');
    insert into [MAGIC] values ('500052','Armor Enchant Scroll(L)','Armor Enchant Scroll','Armor Enchant Scroll','0','0','0','0','702','1','0','0','0','0','9','800062000','0','0','100','4','0','0','1','0');
    
    
    insert into [MAGIC_TYPE4] values ('500049','Weapon Enchant Scroll','+5 Attack','13','0','1800','100','100','0','100','5','100','0','100','0','100','0','0','0','0','0','0','0','0','0','0','0','0','0','100');
    insert into [MAGIC_TYPE4] values ('500050','Armor Enchant Scroll','+30 AC','14','0','1800','100','100','30','100','100','100','0','100','0','100','0','0','0','0','0','0','0','0','0','0','0','0','0','100');
    insert into [MAGIC_TYPE4] values ('500051','Weapon Enchant Scroll(L)','+5 Attack','13','0','1800','100','100','0','100','5','100','0','100','0','100','0','0','0','0','0','0','0','0','0','0','0','0','0','100');
    insert into [MAGIC_TYPE4] values ('500052','Armor Enchant Scroll(L)','+30 AC','14','0','1800','100','100','30','100','100','100','0','100','0','100','0','0','0','0','0','0','0','0','0','0','0','0','0','100');
    
    --------
    
    


    Uyarı: Bu code'lar Weapon ve Armor Enchant Scroll'lar çalışmıyorsa çalışır duruma da getirir.








    ------------------------------------------------------------------------------------------------------------------------------







    Tüm potion ve water'ları sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    
    
    ---------------------------------
    
    
    
    
    Delete from ITEM where num = '389060000'
    Delete from ITEM where num = '389061000'
    Delete from ITEM where num = '389062000'
    Delete from ITEM where num = '389063000'
    Delete from ITEM where num = '389064000'
    
    insert into [ITEM] values ('389060000','Water of life(Store) (+0)                         ','97','17','0','0','0','0','0','60','1','160','0','0','1','490060','0','1','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 ('389061000','Water of love(Store) (+0)                         ','97','17','0','0','0','0','0','70','1','600','0','0','1','490061','0','1','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 ('389062000','Water of grace(Store) (+0)                        ','97','17','0','0','0','0','0','80','1','2000','0','0','1','490062','0','1','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 ('389063000','Water of favors(Store) (+0)                       ','97','17','0','0','0','0','0','90','1','7000','0','0','1','490063','0','1','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 ('389064000','Water of bless(Store) (+0)                        ','97','17','0','0','0','0','0','100','1','10000','0','0','1','490064','0','1','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');
    
    
    Delete from MAGIC where magicnum = '490060'
    Delete from MAGIC where magicnum = '490061'
    Delete from MAGIC where magicnum = '490062'
    Delete from MAGIC where magicnum = '490063'
    Delete from MAGIC where magicnum = '490064'
    
    insert into [MAGIC] values ('490060','»i¸íÀÇ ¼º¼ö(»óÁ¡¿ë)','Water of life(Store)','90HP recovering potion','0','0','0','1','601','1','0','0','0','0','9','389060000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490061','»ç¶ûÀÇ ¼º¼ö(»óÁ¡¿ë)','Water of love(Store)','180HP recovering potion','0','0','0','1','601','1','0','0','0','0','9','389061000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490062','ÀºÃÑÀÇ ¼º¼ö(»óÁ¡¿ë)','Water of grace(Store)','360HP recovering potion','0','0','0','1','602','1','0','0','0','0','9','389062000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490063','ÀºÇiÀÇ ¼º¼ö(»óÁ¡¿ë)','Water of favors(Store)','720HP recovering potion','0','0','0','1','602','1','0','0','0','0','9','389063000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490064','ÃູÀÇ ¼º¼ö(»óÁ¡¿ë)','Water of bless(Store)','1440HP recovering potion','0','0','0','1','602','1','0','0','0','0','9','389064000','5','1','100','3','0','25','1','0');
    
    
    Delete from MAGIC_TYPE3 where inum = '490060'
    Delete from MAGIC_TYPE3 where inum = '490061'
    Delete from MAGIC_TYPE3 where inum = '490062'
    Delete from MAGIC_TYPE3 where inum = '490063'
    Delete from MAGIC_TYPE3 where inum = '490064'
    
    insert into [MAGIC_TYPE3] values ('490060','Water of life(Store)                 ','Water +90 HP','20','1','1','90','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490061','Water of love(Store)                 ','Water +180 HP','20','1','1','180','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490062','Water of grace(Store)                ','Water +360 HP','20','1','1','360','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490063','Water of favors(Store)               ','Water +720 HP','20','1','1','720','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490064','Water of bless(Store)                ','Water +1440 HP','20','1','1','1440','0','0','0','0');
    
    
    ----
    
    
    Delete from ITEM where num = '389078000'
    Delete from ITEM where num = '389079000'
    Delete from ITEM where num = '389080000'
    Delete from ITEM where num = '389081000'
    Delete from ITEM where num = '389082000'
    
    insert into [ITEM] values ('389078000','Potion of spirit(Store) (+0)                      ','97','17','0','0','0','0','0','22','1','160','0','0','1','490078','0','1','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 ('389079000','Potion of intelligence(Store) (+0)                ','97','17','0','0','0','0','0','24','1','600','0','0','1','490079','0','1','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 ('389080000','Potion of sagacity(Store) (+0)                    ','97','17','0','0','0','0','0','26','1','2000','0','0','1','490080','0','1','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 ('389081000','Potion of wisdom(Store) (+0)                      ','97','17','0','0','0','0','0','28','1','7000','0','0','1','490081','0','1','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 ('389082000','Potion of soul(Store) (+0)                        ','97','17','0','0','0','0','0','30','1','15000','0','0','1','490082','0','1','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');
    
    
    Delete from MAGIC where magicnum = '490078'
    Delete from MAGIC where magicnum = '490079'
    Delete from MAGIC where magicnum = '490080'
    Delete from MAGIC where magicnum = '490081'
    Delete from MAGIC where magicnum = '490082'
    
    insert into [MAGIC] values ('490078','Á¤½ÅÀÇ ¹°¾à(»óÁ¡¿ë)','Potion of spirit(Store)','Recover 120MP','0','0','0','1','701','1','0','0','0','0','9','389078000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490079','Çö¸íÀÇ ¹°¾à(»óÁ¡¿ë)','Potion of intelligence(Store)','Recover 240MP','0','0','0','1','701','1','0','0','0','0','9','389079000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490080','½½±âÀÇ ¹°¾à(»óÁ¡¿ë)','Potion of sagacity(Store)','Recover 480MP','0','0','0','1','701','1','0','0','0','0','9','389080000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490081','ÁöÇiÀÇ ¹°¾à(»óÁ¡¿ë)','Potion of wisdom(Store)','Recover 960MP','0','0','0','1','702','1','0','0','0','0','9','389081000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490082','¿µÈ¥ÀÇ ¹°¾à(»óÁ¡¿ë)','Potion of soul(Store)','Recover 1920MP','0','0','0','1','702','1','0','0','0','0','9','389082000','5','1','100','3','0','25','1','0');
    
    
    Delete from MAGIC_TYPE3 where inum = '490078'
    Delete from MAGIC_TYPE3 where inum = '490079'
    Delete from MAGIC_TYPE3 where inum = '490080'
    Delete from MAGIC_TYPE3 where inum = '490081'
    Delete from MAGIC_TYPE3 where inum = '490082'
    
    insert into [MAGIC_TYPE3] values ('490078','Potion of spirit(Store)             ','Potion +120 MP','20','1','2','120','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490079','Potion of intelligence(Store)       ','Potion +240 MP','20','1','2','240','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490080','Potion of sagacity(Store)           ','Potion +480 MP','20','1','2','480','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490081','Potion of wisdom(Store)             ','Potion +960 MP','20','1','2','960','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490082','Potion of soul(Store)               ','Potion +1920 MP','20','1','2','1920','0','0','0','0');
    
    
    
    
    
    
    
    
    ---------------------
    ---------------------
    ---------------------
    
    
    
    
    
    
    
    
    Delete from ITEM where num = '389010000'
    Delete from ITEM where num = '389011000'
    Delete from ITEM where num = '389012000'
    Delete from ITEM where num = '389013000'
    Delete from ITEM where num = '389014000'
    Delete from ITEM where num = '389015000'
    
    insert into [ITEM] values ('389010000','Holy water (+0)                                   ','97','17','0','0','0','0','0','50','1','70','0','0','1','490010','0','1','99','0','0','0','0','0','0','0','253','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 ('389011000','Water of life (+0)                                ','97','17','0','0','0','0','0','60','1','160','0','0','1','490011','0','1','99','0','0','0','0','0','0','0','253','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 ('389012000','Water of love (+0)                                ','97','17','0','0','0','0','0','70','1','600','0','0','1','490012','0','1','99','0','0','0','0','0','0','0','253','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 ('389013000','Water of grace (+0)                               ','97','17','0','0','0','0','0','80','1','2000','0','0','1','490013','0','1','99','0','0','0','0','0','0','0','253','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 ('389014000','Water of favors (+0)                              ','97','17','0','0','0','0','0','90','1','7000','0','0','1','490014','0','1','99','0','0','0','0','0','0','0','253','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 ('389015000','Water of bless (+0)                               ','97','17','0','0','0','0','0','100','1','10000','0','0','1','490015','0','1','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');
    
    
    Delete from MAGIC where magicnum = '490010'
    Delete from MAGIC where magicnum = '490011'
    Delete from MAGIC where magicnum = '490012'
    Delete from MAGIC where magicnum = '490013'
    Delete from MAGIC where magicnum = '490014'
    Delete from MAGIC where magicnum = '490015'
    
    insert into [MAGIC] values ('490010','¼º¼öÀÇ ¼º¼ö','Holy water','45HP potion','0','0','0','1','601','1','0','0','0','0','9','389010000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490011','»i¸íÀÇ ¼º¼ö','Water of life','90HP potion','0','0','0','1','601','1','0','0','0','0','9','389011000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490012','»ç¶ûÀÇ ¼º¼ö','Water of love','180HP potion','0','0','0','1','601','1','0','0','0','0','9','389012000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490013','ÀºÃÑÀÇ ¼º¼ö','Water of grace','360HP potion','0','0','0','1','602','1','0','0','0','0','9','389013000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490014','ÀºÇiÀÇ ¼º¼ö','Water of favors','720HP potion','0','0','0','1','602','1','0','0','0','0','9','389014000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490015','ÃູÀÇ ¼º¼ö','Water of bless','1440HP potion','0','0','0','1','602','1','0','0','0','0','9','389015000','5','1','100','3','0','25','1','0');
    
    
    Delete from MAGIC_TYPE3 where inum = '490010'
    Delete from MAGIC_TYPE3 where inum = '490011'
    Delete from MAGIC_TYPE3 where inum = '490012'
    Delete from MAGIC_TYPE3 where inum = '490013'
    Delete from MAGIC_TYPE3 where inum = '490014'
    Delete from MAGIC_TYPE3 where inum = '490015'
    
    insert into [MAGIC_TYPE3] values ('490010','Holy water                    ','Water +45 HP','20','1','1','45','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490011','Water of life                 ','Water +90 HP','20','1','1','90','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490012','Water of love                 ','Water +180 HP','20','1','1','180','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490013','Water of grace                ','Water +360 HP','20','1','1','360','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490014','Water of favors               ','Water +720 HP','20','1','1','720','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490015','Water of bless                ','Water +1440 HP','20','1','1','1440','0','0','0','0');
    
    
    ----
    
    
    Delete from ITEM where num = '389016000'
    Delete from ITEM where num = '389017000'
    Delete from ITEM where num = '389018000'
    Delete from ITEM where num = '389019000'
    Delete from ITEM where num = '389020000'
    
    insert into [ITEM] values ('389016000','Potion of spirit (+0)                             ','97','17','0','0','0','0','0','22','1','160','0','0','1','490016','0','1','99','0','0','0','0','0','0','0','253','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 ('389017000','Potion of intelligence (+0)                       ','97','17','0','0','0','0','0','24','1','600','0','0','1','490017','0','1','99','0','0','0','0','0','0','0','253','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 ('389018000','Potion of sagacity (+0)                           ','97','17','0','0','0','0','0','26','1','2000','0','0','1','490018','0','1','99','0','0','0','0','0','0','0','253','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 ('389019000','Potion of wisdom (+0)                             ','97','17','0','0','0','0','0','28','1','7000','0','0','1','490019','0','1','99','0','0','0','0','0','0','0','253','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 ('389020000','Potion of soul (+0)                               ','97','17','0','0','0','0','0','30','1','15000','0','0','1','490020','0','1','99','0','0','0','0','0','0','0','253','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');
    
    
    Delete from MAGIC where magicnum = '490016'
    Delete from MAGIC where magicnum = '490017'
    Delete from MAGIC where magicnum = '490018'
    Delete from MAGIC where magicnum = '490019'
    Delete from MAGIC where magicnum = '490020'
    
    insert into [MAGIC] values ('490016','Á¤½ÅÀÇ ¹°¾à','Potion of spirit','Regain 120 MP','0','0','0','1','701','1','0','0','0','0','9','389016000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490017','Çö¸íÀÇ ¹°¾à','Potion of intelligence','Regain 240 MP','0','0','0','1','701','1','0','0','0','0','9','389017000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490018','½½±âÀÇ ¹°¾à','Potion of sagacity','Regain 480 MP','0','0','0','1','701','1','0','0','0','0','9','389018000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490019','ÁöÇiÀÇ ¹°¾à','Potion of wisdom','Regain 960 MP','0','0','0','1','702','1','0','0','0','0','9','389019000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490020','¿µÈ¥ÀÇ ¹°¾à','Potion of soul','Regain 1920 MP','0','0','0','1','702','1','0','0','0','0','9','389020000','5','1','100','3','0','25','1','0');
    
    
    Delete from MAGIC_TYPE3 where inum = '490016'
    Delete from MAGIC_TYPE3 where inum = '490017'
    Delete from MAGIC_TYPE3 where inum = '490018'
    Delete from MAGIC_TYPE3 where inum = '490019'
    Delete from MAGIC_TYPE3 where inum = '490020'
    
    insert into [MAGIC_TYPE3] values ('490016','Potion of spirit              ','Potion +120 MP','20','1','2','120','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490017','Potion of intelligence        ','Potion +240 MP','20','1','2','240','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490018','Potion of sagacity            ','Potion +480 MP','20','1','2','480','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490019','Potion of wisdom              ','Potion +960 MP','20','1','2','960','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490020','Potion of soul                ','Potion +1920 MP','20','1','2','1920','0','0','0','0');
    
    
    
    
    
    
    
    
    ---------------------
    ---------------------
    ---------------------
    
    
    
    
    
    
    
    
    Delete from ITEM where num = '910012000'
    Delete from ITEM where num = '910001000'
    Delete from ITEM where num = '910002000'
    Delete from ITEM where num = '910003000'
    Delete from ITEM where num = '910004000'
    Delete from ITEM where num = '910005000'
    
    insert into [ITEM] values ('910012000','Holy water(Coloseum Event) (+0)                   ','97','17','0','0','0','0','0','50','1','70','0','0','1','500012','0','1','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 ('910001000','Water of life(Coloseum Event) (+0)                ','97','17','0','0','0','0','0','60','1','200','0','0','1','500001','0','1','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 ('910002000','Water of love(Coloseum Event) (+0)                ','97','17','0','0','0','0','0','70','1','800','0','0','1','500002','0','1','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 ('910003000','Water of grace(Coloseum Event) (+0)               ','97','17','0','0','0','0','0','80','1','3000','0','0','1','500003','0','1','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 ('910004000','Water of favors(Coloseum Event) (+0)              ','97','17','0','0','0','0','0','90','1','4000','0','0','1','500004','0','1','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 ('910005000','Water of bless(Coloseum Event) (+0)               ','97','17','0','0','0','0','0','100','1','10000','0','0','1','500005','0','1','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');
    
    
    Delete from MAGIC where magicnum = '500012'
    Delete from MAGIC where magicnum = '500001'
    Delete from MAGIC where magicnum = '500002'
    Delete from MAGIC where magicnum = '500003'
    Delete from MAGIC where magicnum = '500004'
    Delete from MAGIC where magicnum = '500005'
    
    insert into [MAGIC] values ('500012','¼º¼öÀÇ ¼º¼ö(°æ±âÀåÀ̺¥Æ®)','Holy water(C.E.)','45 HP recovering potion','0','0','0','1','601','1','0','0','0','0','9','910012000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500001','»i¸íÀÇ ¼º¼ö(°æ±âÀåÀ̺¥Æ®)','Water of life(C.E.)','90HP recovering potion','0','0','0','1','601','1','0','0','0','0','9','910001000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500002','»ç¶ûÀÇ ¼º¼ö(°æ±âÀåÀ̺¥Æ®)','Water of love(C.E.)','180HP recovering potion','0','0','0','1','601','1','0','0','0','0','9','910002000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500003','ÀºÃÑÀÇ ¼º¼ö(°æ±âÀåÀ̺¥Æ®)','Water of grace(C.E.)','360HP recovering potion','0','0','0','1','602','1','0','0','0','0','9','910003000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500004','ÀºÇiÀÇ ¼º¼ö(°æ±âÀåÀ̺¥Æ®)','Water of favors(C.E.)','720HP recovering potion','0','0','0','1','602','1','0','0','0','0','9','910004000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500005','ÃູÀÇ ¼º¼ö(°æ±âÀåÀ̺¥Æ®)','Water of bless(C.E.)','1440HP recovering potion','0','0','0','1','602','1','0','0','0','0','9','910005000','5','1','100','3','0','25','1','0');
    
    
    Delete from MAGIC_TYPE3 where inum = '500012'
    Delete from MAGIC_TYPE3 where inum = '500001'
    Delete from MAGIC_TYPE3 where inum = '500002'
    Delete from MAGIC_TYPE3 where inum = '500003'
    Delete from MAGIC_TYPE3 where inum = '500004'
    Delete from MAGIC_TYPE3 where inum = '500005'
    
    insert into [MAGIC_TYPE3] values ('500012','Holy water(C.E.)              ','Water +45 HP','20','1','1','45','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500001','Water of life(C.E.)           ','Water +90 HP','20','1','1','90','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500002','Water of love(C.E.)           ','Water +180 HP','20','1','1','180','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500003','Water of grace(C.E.)          ','Water +360 HP','20','1','1','360','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500004','Water of favors(C.E.)         ','Water +720 HP','20','1','1','720','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500005','Water of bless(C.E.)          ','Water +1440 HP','20','1','1','1440','0','0','0','0');
    
    
    ----
    
    
    Delete from ITEM where num = '910006000'
    Delete from ITEM where num = '910007000'
    Delete from ITEM where num = '910008000'
    Delete from ITEM where num = '910009000'
    Delete from ITEM where num = '910010000'
    
    insert into [ITEM] values ('910006000','Potion of spirit(Coloseum Event) (+0)             ','97','17','0','0','0','0','0','22','1','100','0','0','1','500006','0','1','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 ('910007000','Potion of intelligence(Coloseum Event) (+0)       ','97','17','0','0','0','0','0','24','1','200','0','0','1','500007','0','1','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 ('910008000','Potion of sagacity(Coloseum Event) (+0)           ','97','17','0','0','0','0','0','26','1','300','0','0','1','500008','0','1','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 ('910009000','Potion of wisdom(Coloseum Event) (+0)             ','97','17','0','0','0','0','0','28','1','400','0','0','1','500009','0','1','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 ('910010000','Potion of soul(Coloseum Event) (+0)               ','97','17','0','0','0','0','0','30','1','500','0','0','1','500010','0','1','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');
    
    
    Delete from magic where magicnum = '500006'
    Delete from magic where magicnum = '500007'
    Delete from magic where magicnum = '500008'
    Delete from magic where magicnum = '500009'
    Delete from magic where magicnum = '500010'
    
    insert into [MAGIC] values ('500006','Á¤½ÅÀÇ ¹°¾à(°æ±âÀåÀ̺¥Æ®)','Potion of spirit(C.E.)','Recover 120MP','0','0','0','1','701','1','0','0','0','0','    9','910006000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500007','Çö¸íÀÇ ¹°¾à(°æ±âÀåÀ̺¥Æ®)','Potion of intelligence(C.E.)','Recover 240MP','0','0','0','1','701','1','0','0','0','0','9','910007000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500008','½½±âÀÇ ¹°¾à(°æ±âÀåÀ̺¥Æ®)','Potion of sagacity(C.E.)','Recover 480MP','0','0','0','1','701','1','0','0','0','0','9','910008000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500009','ÁöÇiÀÇ ¹°¾à(°æ±âÀåÀ̺¥Æ®)','Potion of wisdom(C.E.)','Recover 960MP','0','0','0','1','702','1','0','0','0','0','9','910009000','5','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('500010','¿µÈ¥ÀÇ ¹°¾à(°æ±âÀåÀ̺¥Æ®)','Potion of soul(C.E.)','Recover 1920MP','0','0','0','1','702','1','0','0','0','0','9','910010000','5','1','100','3','0','25','1','0');
    
    
    Delete from MAGIC_TYPE3 where inum = '500006'
    Delete from MAGIC_TYPE3 where inum = '500007'
    Delete from MAGIC_TYPE3 where inum = '500008'
    Delete from MAGIC_TYPE3 where inum = '500009'
    Delete from MAGIC_TYPE3 where inum = '500010'
    
    insert into [MAGIC_TYPE3] values ('500006','Potion of spirit(C.E.)             ','Potion +120 MP','20','1','2','120','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500007','Potion of intelligence(C.E.)       ','Potion +240 MP','20','1','2','240','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500008','Potion of sagacity(C.E.)           ','Potion +480 MP','20','1','2','480','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500009','Potion of wisdom(C.E.)             ','Potion +960 MP','20','1','2','960','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('500010','Potion of soul(C.E.)               ','Potion +1920 MP','20','1','2','1920','0','0','0','0');
    
    
    
    
    
    
    
    ----------------------------------------
    
    
    






    ------------------------------------------------------------------------------------------------------------------------------









    Pink ve Green Rice Cake'leri sınırlı yapma :


    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389001000'
    Delete from ITEM where num = '389002000'
    Delete from ITEM where num = '389003000'
    Delete from ITEM where num = '389004000'
    Delete from ITEM where num = '389005000'
    Delete from ITEM where num = '389006000'
    
    
    Delete from MAGIC where magicnum = '490001'
    Delete from MAGIC where magicnum = '490002'
    Delete from MAGIC where magicnum = '490003'
    Delete from MAGIC where magicnum = '490004'
    Delete from MAGIC where magicnum = '490005'
    Delete from MAGIC where magicnum = '490006'
    
    
    Delete from MAGIC_TYPE3 where inum = '490001'
    Delete from MAGIC_TYPE3 where inum = '490002'
    Delete from MAGIC_TYPE3 where inum = '490003'
    Delete from MAGIC_TYPE3 where inum = '490004'
    Delete from MAGIC_TYPE3 where inum = '490005'
    Delete from MAGIC_TYPE3 where inum = '490006'
    
    
    
    insert into [ITEM] values ('389001000','Pink Rice Cake (small) (+0)                       ','97','17','0','0','0','0','0','0','1','0','0','0','1','490001','0','1','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 ('389002000','Pink Rice Cake (medium) (+0)                      ','97','17','0','0','0','0','0','0','1','0','0','0','1','490002','0','1','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 ('389003000','Pink Rice Cake (large) (+0)                       ','97','17','0','0','0','0','0','0','1','0','0','0','1','490003','0','1','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 ('389004000','Green Rice Cake (small) (+0)                      ','97','17','0','0','0','0','0','0','1','0','0','0','1','490004','0','1','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 ('389005000','Green Rice Cake (medium) (+0)                     ','97','17','0','0','0','0','0','0','1','0','0','0','1','490005','0','1','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 ('389006000','Green Rice Cake (large) (+0)                      ','97','17','0','0','0','0','0','0','1','0','0','0','1','490006','0','1','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 ('490001','ºGÈ«»ö ¼ÛÆí(¼Ò)','Pink Rice Cake(S) ','200 HP Recovery','0','0','0','1','601','1','0','0','0','0','9','389001000','0','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490002','ºGÈ«»ö ¼ÛÆí(Áß)','Pink Rice Cake(M) ','400 HP Recovery','0','0','0','1','601','1','0','0','0','0','9','389002000','0','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490003','ºGÈ«»ö ¼ÛÆí(´ë)','Pink Rice Cake(L) ','800 HP Recovery','0','0','0','1','602','1','0','0','0','0','9','389003000','0','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490004','³ì»ö ¼ÛÆí(¼Ò)  ','Green Rice Cake(S)','Regain 200 MP  ','0','0','0','1','701','1','0','0','0','0','9','389004000','0','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490005','³ì»ö ¼ÛÆí(Áß)  ','Green Rice Cake(M)','Regain 400 MP  ','0','0','0','1','701','1','0','0','0','0','9','389005000','0','1','100','3','0','25','1','0');
    insert into [MAGIC] values ('490006','³ì»ö ¼ÛÆí(´ë)  ','Green Rice Cake(L)','Regain 800 MP  ','0','0','0','1','702','1','0','0','0','0','9','389006000','0','1','100','3','0','25','1','0');
    
    
    
    insert into [MAGIC_TYPE3] values ('490001','Pink Rice Cake(S)','Cake +200 HP','20','1','1','200','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490002','Pink Rice Cake(M)','Cake +400 HP','20','1','1','400','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490003','Pink Rice Cake(L)','Cake +800 HP','20','1','1','800','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490004','Green Rice Cake(S)','Cake +200 MP','20','1','2','200','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490005','Green Rice Cake(M)','Cake +400 MP','20','1','2','400','0','0','0','0');
    insert into [MAGIC_TYPE3] values ('490006','Green Rice Cake(L)','Cake +800 MP','20','1','2','800','0','0','0','0');
    
    --------
    
    

    Uyarı: Bu code'lar Pink ve Green Rice Cake'ler çalışmıyorsa çalışır duruma da getirir.








    ------------------------------------------------------------------------------------------------------------------------------








    Speed Up Rice Cake'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '800035000'
    
    insert into [ITEM] values ('800035000','Speed Up Rice Cake (+0)                           ','255','15','20','0','0','0','0','1','3','2000','0','0','0','501003','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '501003'
    
    insert into [MAGIC] values ('501003','¼ÓµµÁõ°¡ ¿ùº´','Speed Up Rice Cake','Increases running speed by 150% for 8 hours','0','0','0','1','702','1','0','0','0','0','9','800035000','0','1','100','4','0','0','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '501003'
    
    insert into [MAGIC_TYPE4] values ('501003','Speed Up Rice Cake','+%50 Speed','6','20','28800','100','150','0','100','100','100','0','100','1','1','100','100','0','0','0','0','0','0','0','0','0','0','0','1');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------







    HP Rice Cake'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '800033000'
    
    insert into [ITEM] values ('800033000','HP Rice Cake (+0)                                 ','255','15','20','0','0','0','0','1','3','2000','0','0','0','501001','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '501001'
    
    insert into [MAGIC] values ('501001','HP¿ùº´','HP Rice Cake','Increases HP by 1500 for 8 hours','0','0','0','1','702','1','0','0','0','0','9','800033000','0','1','100','4','0','0','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '501001'
    
    insert into [MAGIC_TYPE4] values ('501001','HP Rice Cake','+1500 MaxHP','1','20','28800','100','100','0','100','100','100','1500','100','1','1','100','100','0','0','0','0','0','0','0','0','0','0','0','1');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------







    MP Rice Cake'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '800034000'
    
    insert into [ITEM] values ('800034000','MP Rice Cake (+0)                                 ','255','15','20','0','0','0','0','1','3','2000','0','0','0','501002','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '501002'
    
    insert into [MAGIC] values ('501002','MP¿ùº´','MP Rice Cake','Increases MP by 1500 for 8 hours','0','0','0','1','702','1','0','0','0','0','9','800034000','0','1','100','4','0','0','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '501002'
    
    insert into [MAGIC_TYPE4] values ('501002','MP Rice Cake','+1500 MaxMP','1','20','28800','100','100','0','100','100','100','0','100','1500','1','100','100','0','0','0','0','0','0','0','0','0','0','0','1');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------







    Green Pearl'ü sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379108000'
    
    insert into [ITEM] values ('379108000','Green Pearl (+0)                                  ','97','15','0','0','0','0','0','1','1','400','0','0','1','490210','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490210'
    
    insert into [MAGIC] values ('490210','³ì»ö ÁøÁÖ','Green Pearl','Recover 750HP over 30 seconds period','0','0','0','1','602','1','0','0','0','0','9','379108000','5','1','100','3','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490210'
    
    insert into [MAGIC_TYPE3] values ('490210','Green Pearl','+750 HP/30 sec','20','1','1','0','0','750','30','0');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------







    Sweeping Potion'u sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379098000'
    
    insert into [ITEM] values ('379098000','Sweeping Potion (+0)                              ','97','15','0','0','0','0','0','1','1','2500','0','0','1','490201','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490201'
    
    insert into [MAGIC] values ('490201','½ºÀ§ÇÎ Æ÷¼Ç','Sweeping Potion','Increase Magic Attack Power by 30% for 30 seconds','0','0','0','1','602','1','0','0','0','0','9','379098000','10','1','100','4','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '490201'
    
    insert into [MAGIC_TYPE4] values ('490201','Sweeping Potion','+%30 MagicAttack','10','20','30','100','100','0','100','100','130','0','100','1','1','100','100','0','0','0','0','0','0','0','0','0','0','0','1');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------







    Magic Hammer'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379099000'
    
    insert into [ITEM] values ('379099000','Magic Hammer (+0)                                 ','97','15','0','0','0','0','0','1','1','1000','0','0','1','490202','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490202'
    
    insert into [MAGIC] values ('490202','¸¶¹iÀÇ ¸ÁÄ¡','Magic Hammer','Repairs the items that you are wearing','0','0','0','1','602','1','0','0','0','0','9','379099000','5','1','100','3','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490202'
    
    insert into [MAGIC_TYPE3] values ('490202','Magic Hammer','+%100 Durability','20','1','4','2000','0','0','0','0');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------








    Abyss Wing'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379113000'
    
    insert into [ITEM] values ('379113000','Abyss Wing (+0)                                   ','97','15','0','0','0','0','0','1','1','1500','0','0','1','490212','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490212'
    
    insert into [MAGIC] values ('490212','½É¿¬ÀÇ ³¯°³','Abyss Wing','Increase dodging rate by 20%','0','0','0','1','602','1','0','0','0','0','9','379113000','5','1','100','4','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '490212'
    
    insert into [MAGIC_TYPE4] values ('490212','Abyss Wing','+%20 AvoidRate','9','20','50','100','100','0','100','100','100','0','100','1','1','100','120','0','0','0','0','0','0','0','0','0','0','0','1');
    
    --------
    
    








    ------------------------------------------------------------------------------------------------------------------------------







    Abyss Eye'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379112000'
    
    insert into [ITEM] values ('379112000','Abyss Eye (+0)                                    ','97','15','0','0','0','0','0','1','1','2500','0','0','1','490211','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490211'
    
    insert into [MAGIC] values ('490211','½É¿¬ÀÇ ´«','Abyss Eye','Enables you to view invisible enemies for 30 seconds','0','0','0','1','0','1','0','0','0','0','9','379112000','18','1','100','9','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE9 where inum = '490211'
    
    insert into [MAGIC_TYPE9] values ('490211','Abyss Eye','Anti-invisibility','0','0','0','2','3','25','100','30','0','100','0');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------







    Abyss Lullaby'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379114000'
    
    insert into [ITEM] values ('379114000','Abyss Lullaby (+0)                                ','97','15','0','0','0','0','0','1','1','1500','0','0','1','490213','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490213'
    
    insert into [MAGIC] values ('490213','½É¿¬ÀÇ ¿ï¸²','Abyss Lullaby','Puts monster to sleep for 20 seconds','0','0','0','1','801','7','0','0','0','0','9','379114000','18','1','100','7','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE7 where nindex = '490213'
    
    insert into [MAGIC_TYPE7] values ('490213','Abyss Lullaby','Soporific','0','0','0','2','0','0','100','20','0','100','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------







    Abyss Fire'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379105000'
    
    insert into [ITEM] values ('379105000','Abyss Fire (+0)                                   ','97','15','0','0','0','0','0','1','1','1500','0','0','1','490214','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490214'
    
    insert into [MAGIC] values ('490214','½É¿¬ÀÇ ºÒ','Abyss Fire','Decrease monsters HP by 10%','0','0','0','1','801','5','0','0','0','0','9','379105000','18','1','100','3','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490214'
    
    insert into [MAGIC_TYPE3] values ('490214','Abyss Fire','%10 HP Damage','20','1','5','10','0','0','0','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------







    Abyss Blessing'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '379104000'
    
    insert into [ITEM] values ('379104000','Abyss Blessing (+0)                               ','97','15','0','0','0','0','0','50','1','950','0','0','1','490207','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490207'
    
    insert into [MAGIC] values ('490207','½É¿¬ÀÇ Ãàº','Abyss Blessing','Recover 3600HP and 3000HP more for the 60 seconds thereafter','0','0','0','1','602','1','0','0','0','0','9','379104000','5','1','100','3','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490207'
    
    insert into [MAGIC_TYPE3] values ('490207','Abyss Blessing','+3600 HP +3000 HP/60 sec','20','1','1','3600','0','3000','60','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------






    HP Scroll 500'ü sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500031'
    
    
    insert into [MAGIC] values ('500031','500 HP Áõ°¡ ÁÖ¹®¼*(´ë)','HP Scroll 500(L)','Increase HP by 500','0','0','0','1','702','1','0','0','0','0','9','800011000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    HP Scroll 1000'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500032'
    
    
    insert into [MAGIC] values ('500032','1000 HP Áõ°¡ ÁÖ¹®¼*(´ë)','HP Scroll 1000','Increase HP by 1000','0','0','0','1','702','1','0','0','0','0','9','800012000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    HP Scroll 1500'ü sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500033'
    
    
    insert into [MAGIC] values ('500033','1500 HP Áõ°¡ ÁÖ¹®¼*(´ë)','HP Scroll 1500','Increase HP by 1500','0','0','0','1','702','1','0','0','0','0','9','800013000','0','1','100','4','0','0','1','0');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------









    HP Scroll 2000'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '810081000'
    
    insert into [ITEM] values ('810081000','HP Scroll 2000(L) (+0)                                   ','255','15','0','0','0','0','0','1','30','2000','0','0','0','500068','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');
    
    
    
    Delete from magic where magicnum = '500068'
    
    insert into [MAGIC] values ('500068','2000 HP Áõ°¡ ÁÖ¹®¼','HP Scroll 2000(L)','Increase HP by 2000','0','0','0','1','702','1','0','0','0','0','9','810081000','0','1','100','4','0','25','1','0');
    
    
    
    Delete from magic_type4 where inum = '500068'
    
    insert into [MAGIC_TYPE4] values ('500068','HP Scroll 2000(L)','Increase HP by 2000','1','0','1800','100','100','0','100','100','100','2000','100','0','100','100','100','0','0','0','0','0','0','0','0','0','0','0','0');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------









    Scroll of Armor 150'yi sınırlı yapma :



    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500029'
    
    insert into [MAGIC] values ('500029','150¹æ¾î·Â »ó½Â ÁÖ¹®¼*(´ë)','Scroll of Armor 150(L)','Increase Defense by 150','0','0','0','1','702','1','0','0','0','0','9','800009000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Armor 300'ü sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500030'
    
    insert into [MAGIC] values ('500030','300 ¹æ¾î·Â »ó½Â ÁÖ¹®¼*(´ë)','Scroll of Armor 300','Increase Defense by 300','0','0','0','1','702','1','0','0','0','0','9','800010000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Armor 350'yi sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '810080000'
    
    insert into [ITEM] values ('810080000','Scroll of Armor 350(L) (+0)                              ','255','15','0','0','0','0','0','1','30','2000','0','350','0','500067','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');
    
    
    Delete from magic where magicnum = '500067'
    
    insert into [MAGIC] values ('500067','350 ¹æ¾î·Â »ó½Â ÁÖ¹®¼','Scroll of Armor 350(L)','Increase Defense by 350','0','0','0','1','702','1','0','0','0','0','9','810080000','0','1','100','4','0','0','1','0');
    
    
    Delete from magic_type4 where inum = '500067'
    
    insert into [MAGIC_TYPE4] values ('500067','Scroll of Armor 350(L)','Increase Defense by 350','2','0','1800','100','100','350','100','100','100','0','100','0','100','100','100','0','0','0','0','0','0','0','0','0','0','0','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Lion Strength'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500028'
    Delete from magic where magicnum = '500045'
    
    insert into [MAGIC] values ('500028','»çÀÚÀÇ Èû ÁÖ¹®¼*(´ë)','Scroll of Lion Strength(L)','Increase Strength, Health, Dexterity, Intelligence, and Magic Power by 10','0','0','0','1','702','1','0','0','0','0','9','800008000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500045','»çÀÚÀÇ Èû ÁÖ¹®¼*(¼Ò)','Scroll of Lion Strength   ','Increase Strength, Health, Dexterity, Intelligence, and Magic Power by 10','0','0','0','1','702','1','0','0','0','0','9','800028000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------







    Scroll of Attack'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500034'
    
    insert into [MAGIC] values ('500034','°ø°I·Â »ó½Â ÁÖ¹®¼*','Scroll of Attack','Increase Attack by 25%','0','0','0','1','702','1','0','0','0','0','9','800014000','0','1','100','4','0','0','1','0');
    
    --------
    
    





    ------------------------------------------------------------------------------------------------------------------------------







    Speed-Up Potion'u sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500035'
    Delete from magic where magicnum = '500057'
    Delete from magic where magicnum = '500063'
    Delete from magic where magicnum = '500064'
    Delete from magic where magicnum = '500105'
    
    insert into [MAGIC] values ('500035','À̵¿ ¼Óµµ Áõ°¡ ¹°¾à','Speed potion','Increase speed by 150%','0','0','0','1','601','1','0','0','0','0','9','800015000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500057','À̵¿ ¼Óµµ Áõ°¡ ¹°¾à','Speed potion','Increase speed by 150%','0','0','0','1','601','1','0','0','0','0','9','800015000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500063','À̵¿ ¼Óµµ Áõ°¡ ¹°¾à','Speed potion','Increase speed by 150%','0','0','0','1','601','1','0','0','0','0','9','800015000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500064','À̵¿ ¼Óµµ Áõ°¡ ¹°¾à','Speed potion','Increase speed by 150%','0','0','0','1','601','1','0','0','0','0','9','800015000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500105','À̵¿ ¼Óµµ Áõ°¡ ¹°¾à','Speed potion','Increase speed by 150%','0','0','0','1','601','1','0','0','0','0','9','800015000','0','1','100','4','0','0','1','0');
    
    --------
    
    





    ------------------------------------------------------------------------------------------------------------------------------







    Flame Resistance Potion'u sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389038000'
    
    insert into [ITEM] values ('389038000','Flame Resistance Potion (+0)                      ','97','17','0','1','0','0','0','200','1','2500','0','0','1','490038','0','45','99','0','0','136','0','0','0','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490038'
    
    insert into [MAGIC] values ('490038','È*¿° ÀúÇ× Æ÷¼Ç','Potion of fire resist','Increase resistance to fire by 80','0','0','0','1','702','1','0','0','0','0','9','389038000','5','1','100','4','0','30','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '490038'
    
    insert into [MAGIC_TYPE4] values ('490038','Flame Resistance Potion','+80 Fire Resistance','8','20','60','100','100','0','100','100','100','0','100','1','1','100','100','0','0','0','0','0','80','0','0','0','0','0','1');
    
    --------
    
    





    ------------------------------------------------------------------------------------------------------------------------------







    Glacier Resistance Potion'u sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389039000'
    
    insert into [ITEM] values ('389039000','Glacier Resistance Potion (+0)                    ','97','17','0','1','0','0','0','200','1','2500','0','0','1','490039','0','46','99','0','0','138','0','0','0','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490039'
    
    insert into [MAGIC] values ('490039','³Ã±â ÀúÇ× Æ÷¼Ç','Potion of Glacier resist','Increase resistance to fire by 80','0','0','0','1','702','1','0','0','0','0','9','389039000','5','1','100','4','0','30','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '490039'
    
    insert into [MAGIC_TYPE4] values ('490039','Glacier Resistance Potion','+80 Cold Resistance','8','20','60','100','100','0','100','100','100','0','100','1','1','100','100','0','0','0','0','0','0','80','0','0','0','0','1');
    
    --------
    
    





    ------------------------------------------------------------------------------------------------------------------------------







    Lightning Resistance Potion'u sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389040000'
    
    insert into [ITEM] values ('389040000','Lightning Resistance Potion (+0)                  ','97','17','0','1','0','0','0','200','1','2500','0','0','1','490040','0','47','99','0','0','140','0','0','0','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490040'
    
    insert into [MAGIC] values ('490040','Àü°I ÀúÇ× Æ÷¼Ç','Potion of lightning resist','Increase resistance to fire by 80','0','0','0','1','702','1','0','0','0','0','9','389040000','5','1','100','4','0','30','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '490040'
    
    insert into [MAGIC_TYPE4] values ('490040','Lightning Resistance Potion','+80 Lightning Resistance','8','20','60','100','100','0','100','100','100','0','100','1','1','100','100','0','0','0','0','0','0','0','80','0','0','0','1');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Prayer of God¯s Power'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389026000'
    
    insert into [ITEM] values ('389026000','Prayer of god¯s power (+0)                        ','97','17','0','4','0','0','0','150','1','2400','0','0','1','490026','0','45','99','0','0','85','0','0','0','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490026'
    
    insert into [MAGIC] values ('490026','½Å¼ºÇÑ Èû ±âµµ¹®','Prayer of God¯s Power','Supernatural power increases your attack power by 50%','0','0','0','1','601','1','0','0','0','0','9','389026000','5','1','100','4','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '490026'
    
    insert into [MAGIC_TYPE4] values ('490026','Prayer of God¯s Power','+%50 Attack','4','20','100','100','100','0','100','150','100','0','100','1','1','100','100','0','0','0','0','0','0','0','0','0','0','0','1');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Acid Potion'u sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389083000'
    
    insert into [ITEM] values ('389083000','Acid potion (+0)                                  ','95','15','0','0','0','0','0','1','1','120000','0','0','1','490083','0','1','99','0','0','0','0','0','0','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490083'
    
    insert into [MAGIC] values ('490083','¿¢½Ãµå Æ÷¼Ç','Acid Potion','Decrease Armors durability by 2000','0','0','0','1','10063','7','0','0','0','0','9','389083000','5','1','100','3','0','30','1','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490083'
    
    insert into [MAGIC_TYPE3] values ('490083','Acid Potion','-2000 Durability Damage','20','1','4','-2000','0','0','0','0');
    
    --------
    
    





    ------------------------------------------------------------------------------------------------------------------------------







    Styx'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389033000'
    
    insert into [ITEM] values ('389033000','Styx (+0)                                         ','97','17','0','2','0','0','0','250','1','8000','0','0','1','490033','0','45','99','0','0','0','0','136','0','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490033'
    
    insert into [MAGIC] values ('490033','Styx','???','????MP?????','0','0','0','1','101','7','0','0','0','0','7','389033000','20','55','100','3','0','30','0','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490033'
    
    insert into [MAGIC_TYPE3] values ('490033','Styx','-3000 MP Damage','20','1','2','-3000','0','0','0','0');
    
    --------
    
    





    ------------------------------------------------------------------------------------------------------------------------------







    Spell of life'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389023000'
    
    insert into [ITEM] values ('389023000','Spell of life (+0)                                ','97','17','0','3','0','0','0','100','1','3600','0','0','1','490023','0','45','99','0','0','0','0','0','120','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490023'
    
    insert into [MAGIC] values ('490023','ü·Â Áõ°¡ ÁÖ¹®¼*','Spell of life','Heal 480 HP','0','0','0','1','701','1','0','0','0','0','9','389023000','5','1','100','4','0','25','1','0');
    
    --------
    
    Delete from MAGIC_TYPE4 where inum = '490023'
    
    insert into [MAGIC_TYPE4] values ('490023','Spell of life','+480 MaxHP','1','20','300','100','100','0','100','100','100','480','100','1','1','100','100','0','0','0','0','0','0','0','0','0','0','0','1');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Snow Ball'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389077000'
    
    insert into [ITEM] values ('389077000','Snow ball (+0)                                    ','97','17','0','0','0','0','0','1','1','10','0','0','1','490077','0','1','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490077'
    
    insert into [MAGIC] values ('490077','´«µ¢ÀÌ','Snow Ball','Throw a snowball','0','0','0','1','10045','7','0','0','0','0','9','389077000','5','1','100','3','0','30','1','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490077'
    
    insert into [MAGIC_TYPE3] values ('490077','Snow Ball','-10 HP Damage','20','1','1','-10','0','0','0','0');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------








    Rock'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '389043000'
    
    insert into [ITEM] values ('389043000','Rock (+0)                                         ','97','17','0','0','0','0','0','1','1','100','0','0','1','490043','0','1','99','0','0','0','0','0','0','0','255','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');
    
    --------
    
    Delete from MAGIC where magicnum = '490043'
    
    insert into [MAGIC] values ('490043','¯µ¹','Rock','Throw a rock','0','0','0','1','10045','7','0','0','0','0','9','389043000','5','1','100','3','0','30','1','0');
    
    --------
    
    Delete from MAGIC_TYPE3 where inum = '490043'
    
    insert into [MAGIC_TYPE3] values ('490043','Rock','-10 HP Damage','20','1','1','-10','0','0','0','0');
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Strength'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500023'
    Delete from magic where magicnum = '500040'
    
    insert into [MAGIC] values ('500023','±Ù·Â Áõ°¡ ÁÖ¹®¼(´ë)','Scroll of Strength(L)','Increase Strength by 15','0','0','0','1','702','1','0','0','0','0','9','800003000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500040','±Ù·Â Áõ°¡ ÁÖ¹®¼(¼Ò)','Scroll of Strength   ','Increase Strength by 15','0','0','0','1','702','1','0','0','0','0','9','800023000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------









    Scroll of Health'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500024'
    Delete from magic where magicnum = '500041'
    
    insert into [MAGIC] values ('500024','ü·Â Áõ°¡ ÁÖ¹®¼(´ë)','Scroll of Health(L)','Increase Health by 15','0','0','0','1','702','1','0','0','0','0','9','800004000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500041','ü·Â Áõ°¡ ÁÖ¹®¼(¼Ò)','Scroll of Health   ','Increase Health by 15','0','0','0','1','702','1','0','0','0','0','9','800024000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Dexterity'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500025'
    Delete from magic where magicnum = '500042'
    
    insert into [MAGIC] values ('500025','¹Îø Áõ°¡ ÁÖ¹®¼(´ë)','Scroll of Dexterity(L)','Increase Dexterity by 15','0','0','0','1','702','1','0','0','0','0','9','800005000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500042','¹Îø Áõ°¡ ÁÖ¹®¼(¼Ò)','Scroll of Dexterity   ','Increase Dexterity by 15','0','0','0','1','702','1','0','0','0','0','9','800025000','0','1','100','4','0','0','1','0');
    
    --------
    
    






    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Intelligence'i sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500026'
    Delete from magic where magicnum = '500043'
    
    insert into [MAGIC] values ('500026','Áö´É Áõ°¡ ÁÖ¹®¼(´ë)','Scroll of Intelligence(L)','Increase Intelligence by 15','0','0','0','1','702','1','0','0','0','0','9','800006000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500043','Áö´É Áõ°¡ ÁÖ¹®¼(¼Ò)','Scroll of Intelligence   ','Increase Intelligence by 15','0','0','0','1','702','1','0','0','0','0','9','800026000','0','1','100','4','0','0','1','0');
    
    --------
    
    





    ------------------------------------------------------------------------------------------------------------------------------







    Scroll of Magic Power'ı sınırlı yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from magic where magicnum = '500027'
    Delete from magic where magicnum = '500044'
    
    insert into [MAGIC] values ('500027','¸¶·Â Áõ°¡ ÁÖ¹®¼(´ë)','Scroll of Magic Power(L)','Increase Magic Power by 15','0','0','0','1','702','1','0','0','0','0','9','800007000','0','1','100','4','0','0','1','0');
    insert into [MAGIC] values ('500044','¸¶·Â Áõ°¡ ÁÖ¹®¼(¼Ò)','Scroll of Magic Power   ','Increase Magic Power by 15','0','0','0','1','702','1','0','0','0','0','9','800027000','0','1','100','4','0','0','1','0');
    
    --------
    
    



    ____________________________________________________________________


    ____________________________________________________________________


    ____________________________________________________________________


    ____________________________________________________________________


    ____________________________________________________________________







    2) Tüketilebilir Item'leri Sınırsız/Tükenmez Yapma Code'ları :






    ------------------------------------------------------------------------------------------------------------------------------




    (720 HP)
    Water of favors'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389014000'
    
    --------
    
    
    Uyarı: Npc'lerde satılan 720 HP potu sınırsız yapar.








    ------------------------------------------------------------------------------------------------------------------------------








    (360 HP)
    Water of grace'i sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389013000'
    
    --------
    
    
    Uyarı: Npc'lerde satılan 360 HP potu sınırsız yapar.








    ------------------------------------------------------------------------------------------------------------------------------








    (1920 MP)
    Potion of soul'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389020000'
    
    --------
    
    
    Uyarı: Npc'lerde satılan 1920 MP potu sınırsız yapar.








    ------------------------------------------------------------------------------------------------------------------------------










    (960 MP)
    Potion of wisdom'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389019000'
    
    --------
    
    
    Uyarı: Npc'lerde satılan 960 MP potu sınırsız yapar.









    ------------------------------------------------------------------------------------------------------------------------------









    (480 MP)
    Potion of sagacity'i sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389018000'
    
    --------
    
    
    Uyarı: Npc'lerde satılan 480 MP potu sınırsız yapar.









    ------------------------------------------------------------------------------------------------------------------------------










    HP Scroll 2000'i sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '810081000'
    
    insert into [ITEM] values ('810081000','HP Scroll 2000(L) (+0)                                   ','255','15','0','0','0','0','0','1','30','2000','0','0','0','500068','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');
    
    
    Delete from magic where magicnum = '500068'
    
    insert into [MAGIC] values ('500068','2000 HP Áõ°¡ ÁÖ¹®¼','HP Scroll 2000(L)','Increase HP by 2000','0','0','0','1','702','1','0','0','0','0','9','810081000','0','1','100','4','0','25','1','0');
    
    
    Delete from magic_type4 where inum = '500068'
    
    insert into [MAGIC_TYPE4] values ('500068','HP Scroll 2000(L)','Increase HP by 2000','1','0','1800','100','100','0','100','100','100','2000','100','0','100','100','100','0','0','0','0','0','0','0','0','0','0','0','0');
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '810081000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------









    HP Scroll 1500'ü sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '800013000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Armor 350'yi sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Delete from ITEM where num = '810080000'
    
    insert into [ITEM] values ('810080000','Scroll of Armor 350(L) (+0)                              ','255','15','0','0','0','0','0','1','30','2000','0','350','0','500067','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');
    
    
    Delete from magic where magicnum = '500067'
    
    insert into [MAGIC] values ('500067','350 ¹æ¾î·Â »ó½Â ÁÖ¹®¼','Scroll of Armor 350(L)','Increase Defense by 350','0','0','0','1','702','1','0','0','0','0','9','810080000','0','1','100','4','0','0','1','0');
    
    
    Delete from magic_type4 where inum = '500067'
    
    insert into [MAGIC_TYPE4] values ('500067','Scroll of Armor 350(L)','Increase Defense by 350','2','0','1800','100','100','350','100','100','100','0','100','0','100','100','100','0','0','0','0','0','0','0','0','0','0','0','0');
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '810080000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------










    Scroll of Armor 300'ü sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '800010000'
    
    --------
    
    








    ------------------------------------------------------------------------------------------------------------------------------








    Scroll of Lion Strength'i sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '800008000'
    Update MAGIC set useitem = '0' where UseItem = '800028000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------










    Scroll of Attack'ı sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '800014000'
    
    --------
    
    








    ------------------------------------------------------------------------------------------------------------------------------









    Speed-Up Potion'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '800015000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------










    Weapon Enchant Scroll'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389155000'
    Update MAGIC set useitem = '0' where UseItem = '800061000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------









    Armor Enchant Scroll'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389156000'
    Update MAGIC set useitem = '0' where UseItem = '800062000'
    
    --------
    
    








    ------------------------------------------------------------------------------------------------------------------------------









    Flame Resistance Potion'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389038000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------









    Glacier Resistance Potion'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389039000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------








    Lightning Resistance Potion'u sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389040000'
    
    --------
    
    








    ------------------------------------------------------------------------------------------------------------------------------










    Styx'ı sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389033000'
    
    --------
    
    







    ------------------------------------------------------------------------------------------------------------------------------









    Prayer of God¯s Power'ı sınırsız yapma :

    Açılmış İçerik:


    Kod:
    
    --------
    
    Update MAGIC set useitem = '0' where UseItem = '389026000'
    
    --------
    
    
     

Bu Sayfayı Paylaş