florinrevine

a guide ? Thank you. If you're using Apache install & configure mod_qos, mod_evasive and mod_spamhaus, when you're using nginx configure limit_req. Possibly you can install xtables module to iptables and block countries from which the attacks are getting or use proxy (ex. CloudFlare). I have webserver the same with game server (FreeBSD). You need to manually compile modules to web server on FreeBSD. I think a better solution would be a proxy. I'm sorry, thank for your help but i'm too newbie to can complete your request.

a guide ? Thank you. If you're using Apache install & configure mod_qos, mod_evasive and mod_spamhaus, when you're using nginx configure limit_req. Possibly you can install xtables module to iptables and block countries from which the attacks are getting or use proxy (ex. CloudFlare). I have webserver the same with game server (FreeBSD).

a guide ? Thank you.

Hi ! Theoretical, OVH dedicated servers are protected with Anti-DDoS. I have a type of flood which didn't affect the network. Then my server it's under attack in statistics appear 17 MB/s write speed and 3.3 Mb/s read speed. Do you have any idea ?

Hi ! Theoretical, OVH dedicated servers are protected with Anti-DDoS. I have a type of flood which didn't affect the network. Then my server it's under attack in statistics appear 17 MB/s write speed and 3.3 Mb/s read speed. Do you have any idea ?

Hi, I have a big problem. My server is under attack. Firewall used: + sysctl net.inet.tcp.syncookies=1 net.inet.ip.forwarding=1 net.inet.ip.fastforwarding=1 net.inet.tcp.nolocaltimewait=1 net.inet.tcp.syncache.rexmtlimit=1 net.inet.ip.check_interface=1 net.inet.ip.portrange.randomized=1 net.inet.ip.process_options=0 net.inet.ip.random_id=1 net.inet.ip.redirect=0 net.inet.ip.accept_sourceroute=0 net.inet.ip.sourceroute=0 net.inet.icmp.bmcastecho=0 net.inet.icmp.maskfake=0 net.inet.icmp.maskrepl=0 net.inet.icmp.log_redirect=0 net.inet.icmp.drop_redirect=1 net.inet.tcp.drop_synfin=1 net.inet.tcp.ecn.enable=1 net.inet.tcp.fast_finwait2_recycle=1 net.inet.tcp.icmp_may_rst=0 net.inet.tcp.maxtcptw=15000 net.inet.tcp.msl=5000 net.inet.tcp.path_mtu_discovery=0 net.inet.tcp.rfc3042=0 net.inet.udp.blackhole=1 net.inet.tcp.blackhole=2 net.inet.ip.rtexpire=60 net.inet.ip.rtminexpire=2 net.inet.ip.rtmaxcache=1024 kern.ipc.shmmax=134217728 + pf.conf ext_if="xn0" service_ports="{ 3306, 3004 }" game_ports="{ 40000, 41110, 41200, 41300, 49100, 49200, 42110, 42200, 53, 80 }" table <trusted_hosts> const { 92.87.16.1 } table <abusive_hosts> persist file "/usr/home/game/BANIP.txt" # options set block-policy drop set loginterface $ext_if set skip on lo scrub on $ext_if reassemble tcp no-df random-id antispoof quick for { lo0 $ext_if } block in pass out all keep state pass out on $ext_if all modulate state pass in quick from <trusted_hosts> block in quick from <abusive_hosts> pass in inet proto icmp all icmp-type echoreq pass in on $ext_if proto tcp to <trused_hosts> port $service_ports flags S/SA keep state (max-src-conn-rate 15/1, overload <abusive_hosts> flush) pass in on $ext_if proto {tcp,udp} to any port $game_ports flags S/SA keep state (max-src-conn-rate 15/5, overload <abusive_hosts> flush) + ipfw.rules IPF="ipfw -q add" ipfw -q -f flush ##Custom-Rules #P2P Ports $IPF 1 allow all from me to any 30000 $IPF 2 allow all from 127.0.0.0/8 to any 30000 $IPF 3 deny all from any to me 30000 $IPF 4 allow all from me to any 30011 $IPF 5 allow all from 127.0.0.0/8 to any 30011 $IPF 6 deny all from any to me 30011 $IPF 7 allow all from me to any 30012 $IPF 8 allow all from 127.0.0.0/8 to any 30012 $IPF 9 deny all from any to me 30012 $IPF 10 allow all from me to any 30013 $IPF 11 allow all from 127.0.0.0/8 to any 30013 $IPF 12 deny all from any to me 30013 $IPF 13 allow all from me to any 30091 $IPF 14 allow all from 127.0.0.0/8 to any 30091 $IPF 15 deny all from any to me 30091 $IPF 16 allow all from me to any 30092 $IPF 17 allow all from 127.0.0.0/8 to any 30092 $IPF 18 deny all from any to me 30092 $IPF 19 allow all from me to any 30021 $IPF 20 allow all from 127.0.0.0/8 to any 30021 $IPF 21 deny all from any to me 30021 $IPF 22 allow all from me to any 30022 $IPF 23 allow all from 127.0.0.0/8 to any 30022 $IPF 24 deny all from any to me 30022 #Game Ports ipfw add 25 allow tcp from any to any dst-port 40000 in via xn0 setup limit src-addr 2 ipfw add 26 allow tcp from any to any dst-port 41110 in via xn0 setup limit src-addr 2 ipfw add 27 allow tcp from any to any dst-port 41200 in via xn0 setup limit src-addr 2 ipfw add 28 allow tcp from any to any dst-port 41300 in via xn0 setup limit src-addr 2 ipfw add 29 allow tcp from any to any dst-port 49100 in via xn0 setup limit src-addr 2 ipfw add 30 allow tcp from any to any dst-port 49200 in via xn0 setup limit src-addr 2 ipfw add 31 allow tcp from any to any dst-port 42110 in via xn0 setup limit src-addr 2 ipfw add 32 allow tcp from any to any dst-port 42200 in via xn0 setup limit src-addr 2 ipfw add 32 allow tcp from any to any dst-port 53 in via xn0 setup limit src-addr 2 ipfw add 32 allow tcp from any to any dst-port 80 in via xn0 setup limit src-addr 2 ################################################# # Allow Loopback and Deny Loopback Spoofing ################################################# $IPF allow all from any to any via lo0 $IPF deny all from any to 127.0.0.0/8 $IPF deny all from 127.0.0.0/8 to any $IPF deny tcp from any to any frag ##Standart Regeln $IPF check-state $IPF deny tcp from any to any established $IPF allow all from any to any out keep-state $IPF deny icmp from any to any When i am under attack pf.conf and firewall.rules give much rows of errors (can not drop, too much sockets or something like this). I used pfctl -si and I saw there in just 2 seconds 25 000 connections. Any idea to solve it ?

Hi there ! Can you help me to remove required experience to read books ? Thanks.

How it's working ? If you are writing in a PM two or more texts without pause 3 secounds you get kick.

Hi there ! Can you give me official halloween packs from 22 nov 2014 ? Thanks.

It's a PVP server , nothing happen if I will delete it.

Hello, How can I disable logs from game source? I want remove logs from tables: - log.sql - quest.sql - moneylog.quest - fishlog.quest

It's safe. MYSQL files have effect only if is in /var/db/mysql. Rumor, there is from a mistake.

what type of GAME are you using? (2089M/34083/40250)

Sorry for 3 x Post. Problem solved with skill_proto (db) from r34083 untouched. Who will have this bug only need to run this SQL in Navicat --> player /* Navicat MySQL Data Transfer Source Server : 5.154.240.56 Source Server Version : 50540 Source Host : 5.154.240.56:3306 Source Database : player Target Server Type : MYSQL Target Server Version : 50540 File Encoding : 65001 Date: 2014-11-19 13:43:56 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for skill_proto -- ---------------------------- DROP TABLE IF EXISTS `skill_proto`; CREATE TABLE `skill_proto` ( `dwVnum` int(11) NOT NULL DEFAULT '0', `szName` varchar(32) NOT NULL DEFAULT '', `bType` tinyint(4) NOT NULL DEFAULT '0', `bLevelStep` tinyint(4) NOT NULL DEFAULT '0', `bMaxLevel` tinyint(4) NOT NULL DEFAULT '0', `bLevelLimit` tinyint(3) unsigned NOT NULL DEFAULT '0', `szPointOn` varchar(100) NOT NULL DEFAULT '0', `szPointPoly` varchar(100) NOT NULL DEFAULT '', `szSPCostPoly` varchar(100) NOT NULL DEFAULT '', `szDurationPoly` varchar(100) NOT NULL DEFAULT '', `szDurationSPCostPoly` varchar(100) NOT NULL DEFAULT '', `szCooldownPoly` varchar(100) NOT NULL DEFAULT '', `szMasterBonusPoly` varchar(100) NOT NULL DEFAULT '', `szAttackGradePoly` varchar(100) NOT NULL DEFAULT '', `setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') DEFAULT NULL, `setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK') NOT NULL DEFAULT 'YMIR', `szPointOn2` varchar(100) NOT NULL DEFAULT 'NONE', `szPointPoly2` varchar(100) NOT NULL DEFAULT '', `szDurationPoly2` varchar(100) NOT NULL DEFAULT '', `setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD') NOT NULL DEFAULT 'YMIR', `szPointOn3` varchar(100) NOT NULL DEFAULT 'NONE', `szPointPoly3` varchar(100) NOT NULL DEFAULT '', `szDurationPoly3` varchar(100) NOT NULL DEFAULT '', `szGrandMasterAddSPCostPoly` varchar(100) NOT NULL DEFAULT '', `prerequisiteSkillVnum` int(11) NOT NULL DEFAULT '0', `prerequisiteSkillLevel` int(11) NOT NULL DEFAULT '0', `eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC') NOT NULL DEFAULT 'NORMAL', `iMaxHit` tinyint(4) NOT NULL DEFAULT '0', `szSplashAroundDamageAdjustPoly` varchar(100) NOT NULL DEFAULT '1', `dwTargetRange` int(11) NOT NULL DEFAULT '1000', `dwSplashRange` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`dwVnum`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of skill_proto -- ---------------------------- INSERT INTO `skill_proto` VALUES ('1', '»ï¿¬Âü', '1', '1', '1', '0', 'HP', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '40+100*k', '', '', '12', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+100*k', '0', '0', 'MELEE', '5', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('2', 'Æȹædz¿ì', '1', '1', '1', '0', 'HP', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '50+130*k', '', '', '15', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'MELEE', '12', '1', '0', '200'); INSERT INTO `skill_proto` VALUES ('3', 'Àü±ÍÈ¥', '1', '1', '1', '0', 'ATT_SPEED', '50*k', '50+140*k', '60+90*k', '', '63+10*k', '50*k', '', 'SELFONLY', 'JEONGWIHON', 'MOV_SPEED', '20*k', '60+90*k', '', '', '', '', '50+140*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('4', '°Ë°æ', '1', '1', '1', '0', 'ATT_GRADE', '(100 + str + lv * 3)*k', '100+200*k', '30+50*k', '', '30+10*k', '(100 + str + lv * 3)*k', '', 'SELFONLY', 'GEOMGYEONG', 'NONE', '', '', '', '', '', '', '100+200*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('5', 'źȯ°Ý', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '60+120*k', '', '', '12', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'MOV_SPEED', '150', '3', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '200'); INSERT INTO `skill_proto` VALUES ('16', '±â°øÂü', '1', '1', '1', '0', 'HP', '-(2.3*atk + (4*atk + str*4 + con)*k)', '60+120*k', '', '', '15', '-(2.3*atk + (4*atk + str*4 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '100'); INSERT INTO `skill_proto` VALUES ('17', '°Ý»êŸ¿ì', '1', '1', '1', '0', 'HP', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '60+150*k', '', '', '15', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+150*k', '0', '0', 'MELEE', '8', '1', '0', '200'); INSERT INTO `skill_proto` VALUES ('18', '´ëÁø°¢', '1', '1', '1', '0', 'HP', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '50+140*k', '', '', '25', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,ATTACK_STUN', '', 'NONE', '100+k*1000/6', '2', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '10', '1', '0', '400'); INSERT INTO `skill_proto` VALUES ('19', 'õ±ÙÃß', '1', '1', '1', '0', 'DEF_GRADE', '(200 + str*0.2 + con*0.5 ) *k', '80+220*k', '60+90*k', '', '63+10*k', '(200 + str*0.2 + con*0.5 ) *k', '', 'SELFONLY', 'CHEONGEUN', 'MOV_SPEED', '-(1+9*k)', '60+90*k', '', '', '', '', '80+220*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('20', '°Ëdz', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '40+120*k', '', '', '20', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '40+120*k', '0', '0', 'MELEE', '10', '0.5', '1200', '200'); INSERT INTO `skill_proto` VALUES ('31', '¾Ï½À', '2', '1', '1', '0', 'HP', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '40+160*k', '', '', '15', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('32', '±Ã½Åź¿µ', '2', '1', '1', '0', 'HP', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '40+160*k', '', '', '20', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '800', '0'); INSERT INTO `skill_proto` VALUES ('33', 'Â÷·û»ì', '2', '1', '1', '0', 'HP', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '50+140*k', '', '', '25', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,ATTACK_POISON', '', 'NONE', '40*k', '', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '12', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('34', 'ÀºÇü¹ý', '2', '1', '1', '0', 'NONE', '', '30+60*k', '15+30*k', '', '60', '', '', 'SELFONLY', 'EUNHYUNG', 'NONE', '', '', '', '', '', '', '30+60*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('35', '»ê°øºÐ', '2', '1', '1', '0', 'HP', '-(lv*2+(atk + str*3 + dex*18)*k)', '40+130*k', '', '', '25', '-(lv*2+(atk + str*3 + dex*18)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '60*k', '5+25*k', '', '', '', '', '40+130*k', '0', '0', 'MAGIC', '0', '0.5', '800', '200'); INSERT INTO `skill_proto` VALUES ('46', '¿¬»ç', '2', '1', '1', '0', 'HP', '-(atk + 0.3*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '40+130*k', '', '', '15', '-(atk + 0.2*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+130*k', '0', '0', 'RANGE', '1', '1', '2500', '0'); INSERT INTO `skill_proto` VALUES ('47', '°ü°Ý¼ú', '2', '1', '1', '0', 'HP', '-(atk + (1.9*atk + dex*2+ str*2)*k)', '30+130*k', '', '', '12', '-(atk + (1.7*atk + dex*2+ str*2)*k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '30+130*k', '0', '0', 'RANGE', '8', '1', '2500', '0'); INSERT INTO `skill_proto` VALUES ('48', 'È­Á¶ÆÄ', '2', '1', '1', '0', 'HP', '-(1.5*atk + (2.8*atk + number(100, 300))*k)', '50+130*k', '', '', '25', '-(1.5*atk + (2.6*atk + number(100, 300))*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'RANGE', '12', '0.6', '2500', '300'); INSERT INTO `skill_proto` VALUES ('49', '°æ°ø¼ú', '2', '1', '1', '0', 'MOV_SPEED', '60*k', '30+40*k', '15+30*k', '', '30+30*k', '60*k', '', 'SELFONLY', 'GYEONGGONG', 'NONE', '', '', '', '', '', '', '30+40*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('50', 'µ¶±â±Ã', '2', '1', '1', '0', 'HP', '-(atk + (1.5*atk + number(100, 200)+dex*6+str*2)*k)', '40+160*k', '', '', '25', '-(atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE,CRUSH,ATTACK_POISON', '', 'NONE', '80*k', '15+30*k', '', '', '', '', '40+160*k', '0', '0', 'RANGE', '12', '0.5', '2500', '300'); INSERT INTO `skill_proto` VALUES ('61', '¼â·ÉÁö', '3', '1', '1', '0', 'HP', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '30+140*k', '', '', '10', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,PENETRATE', '', 'NONE', '1+k*9', '', '', '', '', '', '30+140*k', '0', '0', 'MELEE', '4', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('62', '¿ë±ÇÆÄ', '3', '1', '1', '0', 'HP', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '50+150*k', '', '', '15', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,IGNORE_TARGET_RATING', '', 'NONE', '1+k*9', '', '', '', '', '', '50+150*k', '0', '0', 'MELEE', '12', '1', '0', '500'); INSERT INTO `skill_proto` VALUES ('63', '±Í°Ë', '3', '1', '1', '0', 'ATT_GRADE', '(3 * iq + 2 * lv)*k', '20+240*k', '50+100*k', '2+23*k', '0', '(3 * iq + 2 * lv)*k', '', 'SELFONLY,TOGGLE', 'GWIGUM', 'HIT_HP_RECOVER', '10*k', '50+80*k', '', '', '', '', '20+240*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('64', '°øÆ÷', '3', '1', '1', '0', 'DODGE', '1 + 29 * k', '60+120*k', '60+100*k', '', '100', '1 + 29 * k', '', 'SELFONLY', 'TERROR', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('65', 'ÁÖ¸¶°©', '3', '1', '1', '0', 'DEF_GRADE', '(iq+30)*k', '70+170*k', '30+120*k', '', '33+140*k', '(iq+30)*k', '', 'SELFONLY', 'JUMAGAP', 'REFLECT_MELEE', '(iq/4+10)*k', '30+120*k', '', '', '', '', '70+170*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('66', 'ÆĹý¼ú', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '30+120*k', '', '', '12', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,REMOVE_GOOD_AFFECT', '', 'NONE', '10+40*k', '7+23*k', '', '', '', '', '30+120*k', '0', '0', 'NORMAL', '5', '0.6', '1800', '200'); INSERT INTO `skill_proto` VALUES ('76', '¸¶·É', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '30+140*k', '', '', '7', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+140*k', '0', '0', 'MAGIC', '5', '0.6', '1500', '200'); INSERT INTO `skill_proto` VALUES ('77', 'È­¿°Æø', '3', '1', '1', '0', 'HP', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '60+140*k', '', '', '12', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '', 'ATTACK,SELFONLY,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '60+140*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500'); INSERT INTO `skill_proto` VALUES ('78', '¹«¿µÁø', '3', '1', '1', '0', 'HP', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '20+30*k', '40+30*k', '5+40*k', '43+30*k', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,TOGGLE', '', 'NONE', '', '', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '1', '800', '0'); INSERT INTO `skill_proto` VALUES ('79', 'Èæ½Å¼öÈ£', '3', '1', '1', '0', 'DEF_GRADE', '(0.5*iq+15)*k', '20+30*k', '60+120*k', '5+10*k', '63+10*k', '(0.5*iq+15)*k', '', 'SELFONLY,TOGGLE', 'MANASHIELD', 'MANASHIELD', '100-((iq*0.84)*k)', '60+10*k', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('80', 'Åõ¼Ó¸¶·É', '3', '1', '1', '0', 'HP', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '40+120*k', '', '', '12', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,ATTACK_SLOW', '', 'NONE', '333+300*k', '10+10*k', '', '', '', '', '40+120*k', '0', '0', 'MAGIC', '9', '0.8', '1200', '400'); INSERT INTO `skill_proto` VALUES ('81', '¸¶È¯°Ý', '3', '1', '1', '0', 'HP', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '80+220*k', '', '', '24', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '80+220*k', '0', '0', 'MAGIC', '9', '0.4', '1500', '200'); INSERT INTO `skill_proto` VALUES ('91', 'ºñÆĺÎ', '4', '1', '1', '0', 'HP', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '30+160*k', '', '', '7', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+160*k', '0', '0', 'MAGIC', '5', '0.5', '1800', '201'); INSERT INTO `skill_proto` VALUES ('92', '¿ëÆÄ»ê', '4', '1', '1', '0', 'HP', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '50+160*k', '', '', '8', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '', 'ATTACK,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '10', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('93', 'ÆзæÆø', '4', '1', '1', '0', 'HP', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '50+160*k', '', '', '20', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '', 'ATTACK,SELFONLY,SPLASH,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500'); INSERT INTO `skill_proto` VALUES ('94', 'È£½Å', '4', '1', '1', '0', 'RESIST_NORMAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+200*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'HOSIN', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '800', '0'); INSERT INTO `skill_proto` VALUES ('95', '¹Ý»ç', '4', '1', '1', '0', 'REFLECT_MELEE', '5+(iq*0.3 + 5)*k', '40+160*k', '60+200*k', '', '10', '5+(iq*0.3 + 5)*k', '', '', 'BOHO', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('96', '±âõ´ë°ø', '4', '1', '1', '0', 'CRITICAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+100*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'GICHEON', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('106', '³úÀü·É', '4', '1', '1', '0', 'HP', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '30+150*k', '', '', '7', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '', 'ATTACK,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+150*k', '0', '0', 'MAGIC', '5', '0.6', '1800', '200'); INSERT INTO `skill_proto` VALUES ('107', 'º­¶ô', '4', '1', '1', '0', 'HP', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '50+150*k', '', '', '15', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '', 'ATTACK,SPLASH,ATTACK_STUN', '', 'NONE', '50+1000*k/6', '5', '', '', '', '', '50+150*k', '0', '0', 'MAGIC', '15', '0.8', '1500', '400'); INSERT INTO `skill_proto` VALUES ('108', 'Æø·Ú°Ý', '4', '1', '1', '0', 'HP', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '40+180*k', '', '', '10', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '', 'ATTACK', '', 'NONE', '', '', '', '', '', '', '40+180*k', '0', '0', 'MAGIC', '7', '0.8', '2500', '0'); INSERT INTO `skill_proto` VALUES ('109', 'Á¤¾÷ÀÎ', '4', '1', '1', '0', 'HP', '200+7*lv+(30*iq+6*mwep+600)*k', '40+200*k', '', '', '10', '200+7*lv+(30*iq+6*mwep+600)*k', '', 'REMOVE_BAD_AFFECT', '', 'NONE', '20+80*k', '0', '', '', '', '', '40+200*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('110', 'Äè¼Ó', '4', '1', '1', '0', 'MOV_SPEED', '5 + 35*k', '60+120*k', '60+100*k', '', '10', '5 + 35*k', '', '', 'KWAESOK', 'CASTING_SPEED', '3+33*k', '60+100*k', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('111', 'Áõ·Â¼ú', '4', '1', '1', '0', 'ATT_GRADE', '10+(iq*0.4 +20)*k', '60+120*k', '60+100*k', '', '10', '10+(iq*0.4 +30)*k', '', '', 'JEUNGRYEOK', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('121', 'Åë¼Ö·Â', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('122', '¿¬°è±â', '0', '1', '2', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('124', '䱤¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('125', 'º¯½Å', '0', '1', '40', '0', 'NONE', '', '', '10+1000*k', '', '', '', '', 'DISABLE_BY_POINT_UP', 'YMIR', 'NONE', '', '', 'YMIR', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('126', '½Å¼ö¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('127', 'õÁ¶¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('128', 'Áø³ë¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('129', 'µÐ°©¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', 'NONE', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('130', '½Â¸¶', '0', '1', '1', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('131', '¸»¼Òȯ', '0', '1', '10', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('137', '³­¹«', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '5-(4*k)', '', '', 'ATTACK,USE_MELEE_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '10', '1', '300', '0'); INSERT INTO `skill_proto` VALUES ('138', 'µ¹°Ý', '5', '1', '1', '52', 'HP', '-(2.4*(200+1.5*lv)+(3*200*k))', '60+120*k', '', '', '15', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH_LONG', '', 'MOV_SPEED', '50', '5', '', '', '', '', '', '0', '0', 'MELEE', '6', '1', '400', '100'); INSERT INTO `skill_proto` VALUES ('139', 'Å»Ãâ', '5', '1', '1', '55', 'HP', '-(2*(200+1.5*lv)+(3*200*k))', '60+160*k', '', '', '20', '', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '12', '1', '400', '250'); INSERT INTO `skill_proto` VALUES ('140', '³­¹«(È°)', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '10', '', '', 'ATTACK,USE_ARROW_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', '', '5', '1', '2500', '0'); INSERT INTO `skill_proto` VALUES ('151', '¿ë¾È', '0', '1', '7', '0', 'NONE', '', '', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('152', '¿ë½ÅÀÇÇÇ', '0', '1', '7', '0', 'MAX_HP', 'maxhp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('153', '¿ë½ÅÀÇÃູ', '0', '1', '7', '0', 'MAX_SP', 'maxsp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('154', '¼ºÈÖ°©', '0', '1', '7', '0', 'DEF_GRADE', 'odef*0.1*k', '150+150*k', '180', '', '480', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('155', '°¡¼ÓÈ­', '0', '1', '7', '0', 'MOV_SPEED', '15*k', '150+150*k', '180', '', '480', '', '', '', '', 'ATT_SPEED', '15*k', '180', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('156', '¿ë½ÅÀǺгë', '0', '1', '7', '0', 'CRITICAL', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('157', 'ÁÖ¹®¼ú', '0', '1', '7', '0', 'CASTING_SPEED', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('158', '±æµåÀ̵¿', '0', '1', '3', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('159', '°ø°£Àǹ®', '0', '1', '5', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('160', '°¡¼ÓÈ­', '0', '1', '5', '0', 'NONE', '3*k', '80-12*k', '300', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('161', '°ø°£Àǹ®', '0', '1', '2', '0', 'NONE', '', '50', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('162', '°ø°£À̵¿', '0', '1', '2', '0', 'NONE', '', '20', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('256', 'CRUSH200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '4', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300'); INSERT INTO `skill_proto` VALUES ('257', 'ÀϹݹüÀ§350½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '6', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '525'); INSERT INTO `skill_proto` VALUES ('258', 'CRUSH300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '8', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450'); INSERT INTO `skill_proto` VALUES ('259', 'ÀϹݹüÀ§200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300'); INSERT INTO `skill_proto` VALUES ('260', 'CURSH400½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '12', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '600'); INSERT INTO `skill_proto` VALUES ('261', 'µ¶250½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '80', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '375'); INSERT INTO `skill_proto` VALUES ('262', 'SLOW300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '14', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'MOV_SPEED', '-20', '10', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450');

New info: This bug is available and at item 70037 (Forgetfulness Book).

I checked there but that numbers didn't exist there, I'm using questlib.lua & locale.lua from GF 40250.

Why do you have user.MYI, user.MYD, and user.frm in that archive? It's a mistake, it's from database. It's not my own libs, i finded on www.caconnect.ro/resursemetin (no ad)

In PuTTy: cd /usr/lib32 fetch [Hidden Content] tar -xzvf lib.tar.gz rm lib.tar.gz ~ TRY TO START SERVER if error persist cd /usr/lib fetch [Hidden Content] tar -xzvf lib.tar.gz rm lib.tar.gz START SERVER

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'cehostro' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'm2user'@'localhost' IDENTIFIED BY 'm2pass@#' WITH GRANT OPTION; quit On your syntax you have 'root@, so need use 'root'@

I changed skill_proto.sql, nothing happened. I made a video to understand more better the bug. [Hidden Content]

Already exist 50300 Cartea competentei

Hello, I'm using mainline_released client/game/db. I have a problem. Some skill books do not have name (this bug was much time ago on official server). How can I solve the problem? Item_proto.txt 50300 ±â¼ú ¼ö·Ã¼­ ITEM_SKILLBOOK 0 1 NONE ITEM_STACKABLE NONE NONE 1000 1000 0 0 0 LIMIT_NONE 0 LIMIT_NONE 0 APPLY_NONE 0 APPLY_NONE 0 APPLY_NONE 0 0 0 0 0 0 0 0 0 0

where can I change that True ? It's launcher compiled by me from novaline_Released.

Hy there. I use mainline_released GAME & DB & Launcher (my own compilation). I have this problem with client when I use my own client: I think is from root but with another launcher 40K works perfectly the same client.

When I used MySQL 56 with Metin2 my server never saved the data. After reboot always accounts was the same without modifications before start. More safe is install with ports portsnap fetch extract cd /usr/ports/databases/mysql56-server make install WITH_XCHARSET=all clean