Bütün HP & MP Potları SINIRLI Yapmak

Bütün Potion ve Water'ları SINIRLI Yapmak[/B]

Bütün HP ve MP potları sınırlı yapmak isteyenler için aşağıdaki code'ları paylaşıyorum. Kullanıcılar hiçbir şekilde sınırsız pot ele geçiremezler. Özellikle MYKO server'larda bazı kullanıcıların bazı yöntemlerle sınırsız olan bazı pot'ları ele geçirdiklerini görüyoruz.

Code gruplarını ayrı ayrı , grup grup giriniz.



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'











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') ;



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' );




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' );

 

Ben bugün korkuyorum

 

eyvallah başkan sağol

 

teşekkür sağol

 

tesekkurler saol