-
Posts
76 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Forums
Store
Third Party - Providers Directory
Feature Plan
Release Notes
Docs
Events
Everything posted by Deucalion
-
[Hidden Content] with this tool ;p
-
Converte Item_Proto.txt to item_proto
Deucalion replied to Claudia's topic in Community Support - Questions & Answers
[Hidden Content] this should help you -
Problem with MySQL 5.6 select query
Deucalion replied to Deucalion's topic in Community Support - Questions & Answers
Now everything working, thank you -
You put script e.g. To /convert ,then you go to this directory and run it by python name_script.py . Soon I will write a full converter in python and i''ll release it :-P Sent from my ST25i using Tapatalk
-
Problem with MySQL 5.6 select query
Deucalion replied to Deucalion's topic in Community Support - Questions & Answers
I have still problem with that, so can anybody help me with this? Sent from my ST25i using Tapatalk -
M2 Download Center Download Here ( Internal ) Hi. I wanna to show you how can you convert item_proto to sql and later to txt files. XML -> SQL First we need this program: [Hidden Content] scan: [Hidden Content] Ther is something, but i haven't better program so you download it for your own responsibility With it, we can convert our xml proto to sql But first, from our xml file, we need to delete all <!--AddonType="0"--> and <!--AddonType="99"--> easy with notepad++ and ctrl+h and now we run our program and select file to convert. After moment we'll have a sql file, but if we have a locale_name column in item_proto we need to change also with ctr+h all gb2312name to locale_name, and now we can upload file with "execute sql file" or simpy with query to our database SQL -> TXT To convert item_proto sql to txt files, you need this script in python [Hidden Content] Configuration: You need MySQLdb on your freebsd If you haven't it, just install it - it's a mysql library to python cd /usr/ports/databases/py-MySQLdb/ && make install clean You need also change the connection properties in script default it's: host_mysql = 'localhost' user_mysql = 'mt2' passwd_mysql = 'mt2!@#' And if you want convert also mob_proto in this way, you need onlu change from #print mob_proto() to print mob_proto() in the end of file. Now script should generate our protos in his directory . These programs are not mine. The python script i found somewhere and just modified it to 40k version I think that it's all, if you have any better program or any better way or idea you can show it Maybe in the future I will write to that one big script, but now I have no time for this ;/ If there are any problems, I'll try to help #Updated python script Regards Deucalion
- 17 replies
-
- 232
-
Item_proto convert xml to txt ?
Deucalion replied to Mercury's topic in Community Support - Questions & Answers
Sure, I'll do it when i go back to home, because now in school I haven't all files -
Item_proto convert xml to txt ?
Deucalion replied to Mercury's topic in Community Support - Questions & Answers
I haven't english item_proto.xml, but when you send me it, i can simply convert it -
Item_proto convert xml to txt ?
Deucalion replied to Mercury's topic in Community Support - Questions & Answers
I convert xml to sql, i think that then edit item_proto is easier and next i convert from sql to txt with python converter on freebsd -
Problem with MySQL 5.6 select query
Deucalion replied to Deucalion's topic in Community Support - Questions & Answers
Yes I'm sure, i tried another query to another mysql table and still the same ;/ I've tried this query in navicat and it's work perfectly -
Problem with MySQL 5.6 select query
Deucalion replied to Deucalion's topic in Community Support - Questions & Answers
Now quest return empty chat -
Problem with MySQL 5.6 select query
Deucalion replied to Deucalion's topic in Community Support - Questions & Answers
Still the same error, when i use only chat(tostring(query)), on chat i have "table: 0x44f09f20". It's looks like my query give me back a table ;o -
Problem with MySQL 5.6 select query
Deucalion replied to Deucalion's topic in Community Support - Questions & Answers
now error is a little bit different SYSERR: Apr 26 12:38:37 :: RunState: LUA_ERROR: [string "test_quest"]:3: attempt to index field `name' (a string value) SYSERR: Apr 26 12:38:37 :: WriteRunningStateToSyserr: LUA_ERROR: quest test_quest.start click -
[PROBLEM]40k database error
Deucalion replied to .Devil.'s topic in Community Support - Questions & Answers
Show us the start script -
Hi. Maybe it's easy but, i have problem with that ;/ I have a MySQL 5.6 and Vanilla core 2.3 with db. When I use a game.mysql_query in quest with "SELECT", and put it into chat I have a empty chat, and nothing in sysser, but when I put query into e.g "chat("something"..query.." ") i have this error in sysser: SYSERR: Apr 26 11:31:02 :: RunState: LUA_ERROR: [string "test_quest"]:3: attempt to concatenate local `query' (a table value) SYSERR: Apr 26 11:31:02 :: WriteRunningStateToSyserr: LUA_ERROR: quest test_quest.start click Part of e.g quest local query = game.mysql_query('SELECT name FROM player.player WHERE id = 70984') chat("something"..query.." ") But when I use this query in navicat everything is ok. I'll be grateful for the help