|
You last visited: Today at 15:33
Advertisement
Bonus 1-4 Query
Discussion on Bonus 1-4 Query within the Metin2 Private Server forum part of the Metin2 category.
10/13/2013, 23:09
|
#1
|
elite*gold: 0 
Join Date: Sep 2013
Posts: 62
Received Thanks: 0
|
Bonus 1-4 Query
hello i need bonus 1-4 query because my server have a bug can anyone send it to me?i will give a thanks
|
|
|
|
10/13/2013, 23:45
|
#2
|
elite*gold: 40
Join Date: Nov 2009
Posts: 1,159
Received Thanks: 442
|
PHP Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `item_attr`
-- ----------------------------
DROP TABLE IF EXISTS `item_attr`;
CREATE TABLE `item_attr` (
`apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','NORMAL_HIT_DEFEND_BONUS','SKILL_DEFEND_BONUS','NOUSE1','NOUSE2''NOUSE3','NOUSE4','NOUSE5','NOUSE6','NOUSE7','NOUSE8','NOUSE9','NOUSE10','NOUSE11','NOUSE12','NOUSE13','NOUSE14','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN') NOT NULL default 'MAX_HP',
`prob` varchar(100) NOT NULL default '',
`lv1` varchar(100) NOT NULL default '',
`lv2` varchar(100) NOT NULL default '',
`lv3` varchar(100) NOT NULL default '',
`lv4` varchar(100) NOT NULL default '',
`lv5` varchar(100) NOT NULL default '',
`weapon` varchar(100) NOT NULL default '',
`body` varchar(100) NOT NULL default '',
`wrist` varchar(100) NOT NULL default '',
`foots` varchar(100) NOT NULL default '',
`neck` varchar(100) NOT NULL default '',
`head` varchar(100) NOT NULL default '',
`shield` varchar(100) NOT NULL default '',
`ear` varchar(100) NOT NULL default '',
PRIMARY KEY (`apply`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of item_attr
-- ----------------------------
INSERT INTO item_attr VALUES ('STR', '1', '6', '6', '10', '12', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO item_attr VALUES ('INT', '1', '6', '6', '10', '12', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO item_attr VALUES ('CON', '1', '6', '6', '10', '12', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO item_attr VALUES ('MAX_SP', '1', '200', '400', '800', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('MAX_HP', '1', '2000', '2000', '3000', '3500', '3500', '0', '5', '5', '5', '5', '0', '0', '0');
INSERT INTO item_attr VALUES ('DEX', '1', '6', '6', '10', '12', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO item_attr VALUES ('ATT_SPEED', '1', '5', '5', '5', '8', '8', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('MOV_SPEED', '1', '20', '20', '20', '20', '20', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('CAST_SPEED', '1', '10', '10', '15', '20', '20', '5', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('HP_REGEN', '1', '10', '10', '15', '20', '20', '0', '0', '0', '0', '5', '5', '0', '0');
INSERT INTO item_attr VALUES ('SP_REGEN', '1', '10', '10', '15', '20', '20', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('POISON_PCT', '1', '3', '3', '5', '5', '8', '5', '0', '0', '0', '0', '5', '0', '0');
INSERT INTO item_attr VALUES ('STUN_PCT', '1', '3', '3', '5', '5', '8', '5', '0', '0', '5', '5', '0', '0', '0');
INSERT INTO item_attr VALUES ('SLOW_PCT', '1', '3', '3', '5', '5', '8', '5', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('CRITICAL_PCT', '1', '5', '5', '5', '10', '10', '5', '0', '0', '5', '5', '0', '0', '0');
INSERT INTO item_attr VALUES ('PENETRATE_PCT', '1', '5', '5', '5', '10', '10', '5', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO item_attr VALUES ('ATTBONUS_HUMAN', '1', '5', '8', '8', '10', '10', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO item_attr VALUES ('ATTBONUS_ANIMAL', '1', '20', '20', '20', '20', '20', '5', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('ATTBONUS_ORC', '1', '20', '20', '20', '20', '20', '5', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('ATTBONUS_MILGYO', '1', '20', '20', '20', '20', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO item_attr VALUES ('ATTBONUS_UNDEAD', '1', '20', '20', '20', '20', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO item_attr VALUES ('ATTBONUS_DEVIL', '1', '20', '20', '20', '20', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO item_attr VALUES ('STEAL_HP', '1', '10', '10', '10', '10', '10', '0', '5', '5', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('STEAL_SP', '1', '5', '5', '10', '10', '10', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('MANA_BURN_PCT', '1', '5', '5', '10', '10', '10', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('BLOCK', '1', '5', '10', '10', '15', '15', '0', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO item_attr VALUES ('DODGE', '1', '5', '10', '10', '15', '15', '0', '0', '0', '5', '0', '5', '0', '0');
INSERT INTO item_attr VALUES ('RESIST_SWORD', '1', '8', '10', '10', '15', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO item_attr VALUES ('RESIST_TWOHAND', '1', '8', '10', '10', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO item_attr VALUES ('RESIST_DAGGER', '1', '8', '10', '10', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO item_attr VALUES ('RESIST_BELL', '1', '8', '10', '10', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO item_attr VALUES ('RESIST_FAN', '1', '8', '10', '10', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO item_attr VALUES ('RESIST_BOW', '1', '8', '10', '10', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO item_attr VALUES ('RESIST_FIRE', '1', '10', '15', '15', '15', '20', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('RESIST_ELEC', '1', '10', '15', '15', '15', '20', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('RESIST_MAGIC', '1', '10', '15', '15', '15', '20', '0', '5', '5', '0', '0', '5', '0', '0');
INSERT INTO item_attr VALUES ('RESIST_WIND', '1', '10', '15', '15', '15', '20', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('REFLECT_MELEE', '1', '5', '5', '5', '5', '10', '0', '5', '0', '0', '0', '0', '5', '0');
INSERT INTO item_attr VALUES ('POISON_REDUCE', '1', '10', '10', '10', '15', '15', '0', '0', '0', '0', '0', '0', '0', '5');
INSERT INTO item_attr VALUES ('EXP_DOUBLE_BONUS', '1', '20', '20', '20', '20', '20', '0', '0', '0', '5', '5', '0', '5', '0');
INSERT INTO item_attr VALUES ('GOLD_DOUBLE_BONUS', '1', '20', '20', '20', '20', '20', '0', '0', '0', '5', '5', '0', '5', '0');
INSERT INTO item_attr VALUES ('ITEM_DROP_BONUS', '1', '20', '20', '20', '20', '20', '0', '0', '5', '0', '0', '0', '0', '5');
INSERT INTO item_attr VALUES ('IMMUNE_STUN', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0');
INSERT INTO item_attr VALUES ('IMMUNE_SLOW', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO item_attr VALUES ('ATT_GRADE_BONUS', '1', '30', '30', '50', '50', '50', '0', '5', '0', '0', '0', '0', '0', '0');
You can change the bonus as you like.
|
|
|
|
|
10/14/2013, 12:53
|
#3
|
elite*gold: 0
Join Date: Sep 2013
Posts: 62
Received Thanks: 0
|
no not that i meant the item query which add 1-4 bonus :P
|
|
|
|
|
10/14/2013, 14:04
|
#4
|
elite*gold: 964
Join Date: Mar 2008
Posts: 2,634
Received Thanks: 1,637
|
There´s no querry ó.o..
it´s a game core function.. or did you mean the Item to add 1-4 bonus?
Greatz Benhero
|
|
|
|
|
10/14/2013, 14:27
|
#5
|
elite*gold: 0
Join Date: Sep 2013
Posts: 62
Received Thanks: 0
|
The item to add 1-4 bonus because my server has a bug which the 1-4 amount is 200 but when i buying them its only 1
|
|
|
|
|
10/14/2013, 17:27
|
#6
|
elite*gold: 71
Join Date: Dec 2011
Posts: 598
Received Thanks: 149
|
Code:
39028 Àç°æºñ¼* Gegenstand verzaubern 3 18 0 1 65920 8196 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
39029 Àç°¡ºñ¼* Gegenstand verstärken 3 19 0 1 65920 8196 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PHP Code:
INSERT INTO `item_proto` VALUES ('39028', 0xC0E7B0E6BAF1BCAD, 0x476567656E7374616E64207665727A61756265726E, '3', '18', '0', '1', '65920', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '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_proto` VALUES ('39029', 0xC0E7B0A1BAF1BCAD, 0x476567656E7374616E64207665727374E4726B656E, '3', '19', '0', '1', '65920', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
|
|
|
|
 |
Similar Threads
|
[Selling] Defiance Digital Deluxe + Pre-Order Bonus + Arkhunter Bonus
04/27/2013 - Trading - 8 Replies
Huhu zusammen,
ich habe mir das Spiel gekauft, war auch ganz begeistert davon, jedoch gab es einige Komplikationen und somit bin ich kaum noch imstande am PC Games zu Spielen, gezahlt habe ich 60€ für das Spiel, würde mich also Freuen wenn ich in etwa einen gleichwertigen Preis für den Verkauf bekommen würde.
Wenn ihr Interesse habt, meldet euch, macht mir ein Angebot!
Payment nur Paypal!
Screens:
http://www.qpic.ws/images/screenkwk.png
|
[Help - Helfen]Modify/Remove horse bonus - Ändern / Entfernen Pferd Bonus
12/12/2012 - Metin2 Private Server - 0 Replies
Sorry for no perfect english skills.
Hello community, i needed to know how to modify or remove the bonus the horse gives us when we mount them, you see? Vit, Int, Str and Des, like in official metins... When we mount the horse we gain addicional status and they are removed when we unmount them. However, this won't happen if we mount the new mounts like the Lion, the Wolf the Tiger and the Boar! We gain the status and they don't go away when we unmount them! This bug could be used by the...
|
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 Private Server - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's
für Alteklinge, Reichsklinge &' Strichdolche
Why?
Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab
... not more -.-
Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's
|
Free Items from Equipment Bonus Quests and Bonus Packs
01/31/2010 - Conquer Online 2 - 6 Replies
I know this might sound really stupid and I'm probably gonna get alot of people calling me a noob for asking this. But I was wondering about the (Free) equipment you get from the Equipment Bonus Quests and Bonus packs. Do they stay after you get reborn or do they disapear? I tried looking on the CO site but it isnt there and I checked this forum and couldnt find anything.
If anyone has gotten reborn with free items, it would be great to know because I would love to keep my necklace I got from...
|
All times are GMT +1. The time now is 15:33.
|
|
