Kod:
Delete from ITEM where num = '389082000'
Delete from ITEM where num = '389081000'
Delete from ITEM where num = '389080000'
Delete from ITEM where num = '389079000'
Delete from ITEM where num = '389078000'
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');
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 ('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 ('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 ('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');
Kod:
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'
Delete from magic where magicnum = '490082'
Delete from magic where magicnum = '490081'
Delete from magic where magicnum = '490080'
Delete from magic where magicnum = '490079'
Delete from magic where magicnum = '490078'
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' );
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' );
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 ('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 ('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 ('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') ;
Kod:
Delete from magic where magicnum = '490020'
Delete from magic where magicnum = '490019'
Delete from magic where magicnum = '490018'
Delete from magic where magicnum = '490017'
Delete from magic where magicnum = '490016'
Delete from magic where magicnum = '490015'
Delete from magic where magicnum = '490014'
Delete from magic where magicnum = '490013'
Delete from magic where magicnum = '490012'
Delete from magic where magicnum = '490011'
Delete from magic where magicnum = '490010'
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');
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 ('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 ('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 ('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 ('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' );
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 ('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 ('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 ('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 ('490010','¼º¼ö','Holy water','HP recovery potion sold in stores','0','0','0','1','601','1','0','0','0','0', '9','389010000','5','1','100','3','0','25','1','0' );
Kod:
Delete from magic where magicnum = '500012'
Delete from magic where magicnum = '500010'
Delete from magic where magicnum = '500009'
Delete from magic where magicnum = '500008'
Delete from magic where magicnum = '500007'
Delete from magic where magicnum = '500006'
Delete from magic where magicnum = '500005'
Delete from magic where magicnum = '500004'
Delete from magic where magicnum = '500003'
Delete from magic where magicnum = '500002'
Delete from magic where magicnum = '500001'
insert into [MAGIC] values ('500012','¼º¼ö(°æ±âÀåÀ̺¥Æ®)','Holy water','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 ('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' );
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 ('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 ('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 ('500006','Á¤½ÅÀÇ ¹°¾à(°æ±âÀåÀ̺¥Æ®)','Portion 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 ('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' );
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 ('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 ('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 ('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' );