sucopowa

uooo!!! 3 hardcore masters answered to my question! im very glad to read you all! +_+ well, masters, ive just introduced with c++ im seeing that is one of the main programmig so i decided to start with it first of all [Hidden Content] thanks to anyone! hope you have all a nice day! maybe ai give some beers for free! hahahha and double thanks for vegas master for just write an explicit tutorial, yo have done an greta wok for the community and i read many of your how to's just wanted to say it directly, that kind of things make ud hobby noobs grow a bit more in this area! well, thansk again to all! PS: i readed the code you wrote and im trying to understand it all, and yes, i got the main logic, but im wondering why the hell you wrote so much just for help xDD thanks again a lot! than even shows me how much i have to learn, gonna keep on it! i will surpass you all.........! someday! XDD!! <3

uh shalala what a level of knowledge, well, masters of disasters, thanks for your advices! i have an new goal now! check out as mny courses as i can from basic prorgammit to get into it. in some years i want to study anyways informatics so it will be necessary anyways! @Syreldar; about your last comment, isnt it right that named variables have to be saved inside "", maybe its that the reason it doesnt recognize it... xDD! well i dont want to be a smatass, you two seem to know all better than me xDD gonna to stop my local metin2 project, im tired of copieng thinks, and trying to make their work, with just realing the half of what i wrote in a code xD! i think python and lua is very interesting, and c++ too, just needs english knowledge to understand it hahah, and time of course, well, gonna search some lessons for it xD! by the way... does anyone of you two, know some good lesson stuff, or website where it could be? thanks and, keep it going guys! take care! im gonna press that like button on you all hahaha my way to appreciate it +_+ signed in my first course on [Hidden Content] :3

thanks for your anwer, but, i dont could make it works... in your example; function GetDuration(item_id) return mysql.query(string.format("SELECT duration FROM %s.new_petsystem WHERE id = %d LIMIT 1;", player, item_id)); end yo use "item_id" as the argument you want to declare later right? so in the example it shopuld be when xxx.take begin local item_id = item.get_id() say("item duration: "..GetDuration(item_id)) end right? cause that doesnt wokr either... i dunno why :/ i have tryend to comment it with that argument and without... and one more questio! :3 when you say: WHERE id = %d that %d is the argument named "item_id" right? so i have to put later an "local item_id = item.get_id()" to get that "%d" or where is the mistake instead? im tired with this one hahah, thansk for your help! i will continue later on it, have a nice day!

hi master devs! i was trying to get an field from an mysql table, in the query builder from the mysql client it works, but when im gonan try it out on a quest, it doesnt works... here is what ive done: i put it into a function cause i took it from another reference... noob alert! xD function itemidputo(item_id) local item_id = item.get_id() return mysql.query(string.format("SELECT duration FROM %s.new_petsystem WHERE id = %.0f;", auction.PLAYER_DATABASE, item_id)).duration[1] end and im calling it for a test with just an local in a say fucntion, but when i call the function, nothin appears, and the error log doesnt says anything... compilling it works fine.. any idea? i try to select the field from the column DURATION from the row ID, im trying to get some new knowledge from this kind of lua using, but i doesnt find anything from mysql references with my requiriments... well if anybody has any idea, i appreciate it! gonna keep trying! thanks in advance!

same problem here :/

hi, is there someone who has the gr2 files wich could be uploaded again? i would appreciate it much, thanks :3

hey, i got the same 2 problemas, but, the secodn one, is withoout that syserr error 2 slots are used as rin_item and in cosntume window, and the second problem is that the sash modell doesnt appears :/ thanls in advance! edit: ok i solved the visual part bug,the solution was that i forgot to put in the sql database, the value3 as the index of the shooulder, for 85001 value3 = 1, and so on. but i have already to fix that with the twice slot used

is it posible to pack that modified soruce-places to an lib? (i imagine that it is, could someone shortly explain how that works? :x thanks :3 )

Hi dear mt2 comunity i just want to know if someone knows this issue: Input: no quest running for pc, cannot process input : It appears when i kill another char. After that, no quest functions works for that char. Here you have a bit more of the syserr.txt SYSERR: Dec 11 18:35:57 :: Input: no quest running for pc, cannot process input : 61543 SYSERR: Dec 11 18:36:28 :: Input: no quest running for pc, cannot process input : 60963 SYSERR: Dec 11 18:36:30 :: Input: no quest running for pc, cannot process input : 60963 SYSERR: Dec 11 18:36:51 :: Input: no quest running for pc, cannot process input : 60275 SYSERR: Dec 11 18:37:06 :: Input: no quest running for pc, cannot process input : 59709 SYSERR: Dec 11 18:37:06 :: Process: UNKNOWN HEADER: 156, LAST HEADER: 254(2), REMAIN BYTES: 8, fd: 40 SYSERR: Dec 11 18:37:08 :: Process: UNKNOWN HEADER: 159, LAST HEADER: 254(2), REMAIN BYTES: 8, fd: 41 SYSERR: Dec 11 18:37:13 :: GetUniqueHpPerc: Unknown Key : fake6 SYSERR: Dec 11 18:37:13 :: PurgeUnique: Unknown Key or Dead: fake6 SYSERR: Dec 11 18:37:21 :: Input: no quest running for pc, cannot process input : 61743 SYSERR: Dec 11 18:37:23 :: GetUniqueHpPerc: Unknown Key : fake2 SYSERR: Dec 11 18:37:23 :: PurgeUnique: Unknown Key or Dead: fake2 SYSERR: Dec 11 18:37:23 :: GetUniqueHpPerc: Unknown Key : fake3 SYSERR: Dec 11 18:37:23 :: PurgeUnique: Unknown Key or Dead: fake3 SYSERR: Dec 11 18:37:33 :: IsUniqueDead: Unknown Key or Dead : real SYSERR: Dec 11 18:37:53 :: Input: no quest running for pc, cannot process input : 60963 SYSERR: Dec 11 18:37:53 :: Input: no quest running for pc, cannot process input : 60963 The quest that im running for the player kill is something like this: if npc.is_pc() then if pc.getqf("muertes1"..npc.get_vid()) == 3 then pc.setqf("delay", get_time()+60*5) pc.setqf("muertes1"..npc.get_vid(), 0) chat("Has matado 3 veces al mismo personaje.") chat("Ahora has de esperar 5 minutos!") else pc.setqf("muertes1"..npc.get_vid(), pc.getqf("muertes1"..npc.get_vid())+1) tienda_pvp.give_kill_event_price() if pc.level >= 80 then pc.give_exp2(390271992) end if pc.get_empire() == npc.get_empire() then local Achievement = "Enhorabuena!" pc.setqf("muertes2", pc.getqf("muertes2")+5) pc.setqf("muertes_totales", pc.getqf("muertes_totales")+1) cmdchat("achievement ".. Achievement .."_+_".. pc.getqf("muertes_totales") .."%".. pc.getqf("muertes2") .."") end end end I did "/reload q" before test the quest fucntion again. If someone knows soemthing, i will be glad to listen to him/her <3 PD: The strange thing is that if i logout to the login window, and log in again, it doesnt work neither any quest function. but when i log out completly, closing the metin2 client, and i open a new connection, it works all again perfectly... I really doesnt know where the hell the issue is :/ PD²: Is it possible that the PID of the bugged char is killed and that way the server says "no quest running for pc"? cause only when i log completly again it works. When i kill somebody after that, it get bugged again :x

I have this problem too, but the mistake is, that the client shows me only sometimes the newobjects and old ones, sometimes only old ones and soemtimes no one xD Im trying to pack the Property file with 3 different packers, and no one seems to work... :/

Alright, thanks a lot for your reply Rumor, i will try just to use after "mysql_query" the mysql_real_escape_string() function! :3

I just wanted to know the right way to use mysql_escape() or mysql_escape_string(), i saw the message on the command line thait may be insecure, already readed in other topics and forums, and doesnt got any clear answer or view of it :x Thanks for reading!

HI Pain, i just wanted to say that the two-hand weapon in your unpacked eix/epk files, are bugged, his weight is 0KB. Do you can repload it? Thanks for share ^^ €: Sorry, my fault, its jusst if you unpack the eix/epk data files, if you include the eix/epk packed in your client, it works all fine, thanks again!

Hey m2dev, i just wanted to ask, in what should i rename this future file?

on world editor theres an bug if you use more than 4 different textures at same time (or that was what i heared say CryPrime in his video tutorial)

i have an error too what he has its the: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1) errno: 126 its a query that is executing, but how to disable that query?

try this: def SetInventoryPage(self, page): self.inventoryPageIndex = page self.inventoryTab[self.inventoryPageIndex].Down() self.inventoryTab[self.inventoryPageIndex].SetUp() self.RefreshBagSlotWindow() i had that issue to and solved it that way, you will not see that you press the keys, but finally you change it well

well i had that problem to, i just changed the the SetInventoryPage to this: def SetInventoryPage(self, page): self.inventoryPageIndex = page self.inventoryTab[self.inventoryPageIndex].Down() self.inventoryTab[self.inventoryPageIndex].SetUp() self.RefreshBagSlotWindow() means, just puted the "self.inventoryPageIndex = page" before it load another thing PS: sorry for double post, i thought i can copy the quote and edit in the other post, but i cant xD

Hi!! got a little problem... i think clientside is all working (no syserr and inventories changes right) but now i cant drag nothing on 3 and 4th inventory... i think its an server missing file, but........ im using the vanilla core with 4 inventories (game and db) someone has any idea why it doesnt work? i dont make an pic cause it will only show an empty inventory with 4 buttons xD and thank all for make it easier for us noob dev´s xP PS: damm, 6:17 AM .... sorry guys, i was wrong, i copied the wrong DB and GAME now it works all, thank you guys, you guys make proude the name "metin2 dev" xD

hey Deucalion, im at the first step right now and well, i have to say that this converts my xml ind an succesfully query, but sometimes he miss lines, and sometimes lines are double, im i doing soemthing wrong? i just renamed gb123name or w/e into "local_name" like my itemproto table is, and well, just removed that addontype=0 and 99. nothing else :/ an expample could be this: <Item vnum="1" name="돈꾸러미" locale_name="Yang" type="9" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="0" socket2="0" socket3="0" socket4="0" socket5="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" /> <Item vnum="2" name="한국무쌍버젼" locale_name="Versi? Espa?la" type="0" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="0" socket2="0" socket3="0" socket4="0" socket5="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" /> <Item vnum="10" name="도+0" locale_name="Espada +0" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="7" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="0" socket0="0" socket1="0" socket2="0" socket3="0" socket4="0" socket5="0" refine_vnum="11" refine_set="1" magic_pct="15" specular="0" socket_pct="1" /> <Item vnum="11" name="도+1" locale_name="Espada +1" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="100" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="7" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="7" socket0="0" socket1="0" socket2="0" socket3="0" socket4="0" socket5="0" refine_vnum="12" refine_set="2" magic_pct="15" specular="0" socket_pct="1" /> <Item vnum="12" name="도+2" locale_name="Espada +2" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="100" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="7" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="14" socket0="0" socket1="0" socket2="0" socket3="0" socket4="0" socket5="0" refine_vnum="13" refine_set="3" magic_pct="15" specular="0" socket_pct="1" /> <Item vnum="13" name="도+3" locale_name="Espada +3" type="1" subtype="0" weight="0" size="2" antiflag="32" flag="1" wearflag="16" immuneflag="0" gold="100" buy_price="150" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="7" applyvalue0="22" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="15" value2="19" value3="13" value4="15" value5="21" socket0="0" socket1="0" socket2="0" socket3="0" socket4="0" socket5="0" refine_vnum="14" refine_set="4" magic_pct="15" specular="0" socket_pct="1" /> and converted; INSERT INTO `item_proto` VALUES ('2', 'Versi? Espa?la', 'Versi? Espa?la', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '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 ('10', 'Espada +0', 'Espada +0', '1', '0', '0', '2', '32', '1', '16', '0', '0', '0', '11', '1', '0', '15', '1', '0', '0', '0', '7', '22', '0', '0', '0', '0', '0', '15', '19', '13', '15', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_proto` VALUES ('10', 'Espada +0', 'Espada +0', '1', '0', '0', '2', '32', '1', '16', '0', '0', '0', '11', '1', '0', '15', '1', '0', '0', '0', '7', '22', '0', '0', '0', '0', '0', '15', '19', '13', '15', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_proto` VALUES ('12', 'Espada +2', 'Espada +2', '1', '0', '0', '2', '32', '1', '16', '0', '100', '100', '13', '3', '0', '15', '1', '0', '0', '0', '7', '22', '0', '0', '0', '0', '0', '15', '19', '13', '15', '14', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_proto` VALUES ('12', 'Espada +2', 'Espada +2', '1', '0', '0', '2', '32', '1', '16', '0', '100', '100', '13', '3', '0', '15', '1', '0', '0', '0', '7', '22', '0', '0', '0', '0', '0', '15', '19', '13', '15', '14', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_proto` VALUES ('13', 'Espada +3', 'Espada +3', '1', '0', '0', '2', '32', '1', '16', '0', '100', '150', '14', '4', '0', '15', '1', '0', '0', '0', '7', '22', '0', '0', '0', '0', '0', '15', '19', '13', '15', '21', '0', '0', '0', '0', '0', '0', '1', '0', '0'); some lines missing, and other doubles as i said :/ thanks fro reading and for your work ^^

>SOLVED<* Hi Rumor, i got a problem, but in first place, thanks fo do that tutorial the issue i become is this one: root@ns3306138:~ # pwd_mkdb -p /etc/master.passwd root@ns3306138:~ # chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql root@ns3306138:~ # service mysql-server start Starting mysql. root@ns3306138:~ # /usr/local/bin/mysqladmin -uroot password 'passpasspass' /usr/local/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! maybe you or someother knows soemthing about it? im using freebsd 9.2, should i downgrade it to 9.0? i have tryed with mysql 5.1 and 5.5, same issue :/ thanks for reading! PS: after this error message, i make: root@ns3306138:~ # service mysql-server status mysql is not running. in rc.conf i got: sshd_enable="YES" ntpdate_enable="YES" ntpdate_hosts="IP.IP.IP.IP.IP" fsck_y_enable="YES" background_fsck="NO" named_enable="YES" firewall_enable="YES" firewall_script="/etc/ipfw.rules" # Set dumpdev to "AUTO" to enable crash dumps, "NO" to disable dumpdev="NO" ifconfig_em0="inet IP.IP.IP.IP.IP netmask 255.255.255.0 broadcast IP.IP.IP..255" defaultrouter="IP.IP.IP.IP.IP" # Fail2Ban fail2ban_enable="YES" # MySQL mysql_enable="YES" *after reading the error log of the mysql, i noticed that i puted into /var/db/mysql my old mysql files before that new installation, little fail ^^U Thanks again for your work, making this tutorial with that kind of commands, what we [with "we" i mean us, the hobbie metin2 developers(can i call myself a developer... i think no xD)] doesn´t know the great part of them.