theacastus 0 Posted October 15, 2017 Share Posted October 15, 2017 On 9. 10. 2017 at 4:27 PM, M3talHack said: I tried to download the "Source" pack, and when i finished downloading it, it appears a window saying " can't open the rar file 'cause it can be in wrong format or damaged." How can i fix that? In another way, could you gimme the working link for these files? Thank you a lot. Hey there, I am having the same issue. Please can anyone help w/ it. My Macintosh and Win have same problem btw EDIT: fixed by using different extractor which finds out it is locked with password and show the prompt. I used 'Keka' on Macintosh to do so. Link to comment Share on other sites More sharing options...
theacastus 0 Posted October 16, 2017 Share Posted October 16, 2017 Ok, I got home, docompressed the source and import it too VS2017. I didnt work with M2 source for some time so if I will be talking about basic stuff I am sorry. VS created UpdateLog.htm (as usual) and I got few errors) First I moved the Internal stuff into vanilla (Internal/* -> ../vanilla/ ) But still got few files missing, e.g. ServerKeyGenerator, libseverkey, qc (qc.2008) and few warnings that something has been deprecated... I want to setup dev server and see if my ideas can do something usefull, in code, quests, etc. I want to try a server but it is long way to go and it is more like that I like M2 that I want to have server RIGHT NOW... (grew up from that). So if you can give me some advises, I would apriciate it. Please contact me via PM, so we dont spam this thread. I also want to install FreeBSD on my old PC to have local dev server, but it is probably toooooo old (it wont start by now) Thanks guys Link to comment Share on other sites More sharing options...
Aliano 1 Posted October 30, 2017 Share Posted October 30, 2017 we are still wating Vanilla Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 4, 2017 Author Share Posted November 4, 2017 Vanilla Core r71480 is released! A few words about this release: This release brings a lot of unifying and more security options. I'm sorry that the development wasn't as fast as I wanted it to be. RL and stuff. And with that little time it's hard to test and as you may know I've had no options to debug or even test the code I was writing. But this is now gone since I have a working compile station. Also I have great news for those who really want to work with Windows. I'm working on a windows-working port for the source. Of course this won't be another branch or something. It'll be part of the main source. But please, don't expect it to be done ASAP since I have other things in my mind which I consider more important. As you may have noted most changes are about security. I want server-owners to have the option to add as much security as possible. It was the main goal in the earlierst revisions and will still be. This time we'll have a few things thanks to contributors from all over the world. I tried to mention them when it's fitting, if I missed someone, please immediately send me a pm and I'll add it! This release should help to reduce the problems that could occur when leaking databases and other stuff. I hope you enjoy it! Oh, and additionally I returned to include the qc-program into my bundled pre-built package. This way people without compiling vanilla core from source are able to use it at it's full extent. Note that this release still uses boost. Next release will drop boost entirely and declares it's implementation as deprecated. We don't need a library if everything we need is already supplied by newer c++ revisions. CHANGES from 70220 -> 71480 ~general stuff~ * fixed a bug with cancelling servertimers (thanks to Socialized and Yiv) * fixed crashes due to wrong Compiler flags under release mode (thanks to Damn) * cleaned a few code lines and rewrote some stuff + added unifying stuff to the core Unify-mode is a new mode which forces the encoding to be utf8. Note that this does NOT break backwards-compatibility and your locale is still set to the region you chose to have. So if you're running on locale/euckr (example) before, the core will still fetch it's files from that place like it did before. It only changes how the server core processes data internally and sends it to client/db. The advantages of utf-8 can be looked up, it'd be obvious. But since it affects the core in one way or another, I moved it to a CONFIG flag. ~Database changes (optional for you)~ + If you want to use utf-8 mode it's recommended to convert your whole database to utf-8 (you can use the utf_general_ci collate) + If you want to use the /su command with a customized passphrase per player you'll have to add a new column called 'passphrase' as varchar(45) and add the passphrase of the user as a mysql-Password (just like you'd add a Password to an account). ~CONFIG options~ + elevation_enable (bool, default false) Enables the elevation mode. This way you have to use the /su command along with the passphrase in order to get superuser access. The session ends with teleporting or relogging. Note that using the master-passphrase is only allowed in testserver unless elevation_use_key (see below) is enabled. + elevation_key (string, default 'vanilla') Sets the default passphrase if you want to use it. It's like a master-password for the su-system and works only + elevation_use_key (bool, default false) If enabled, it allows you to use the masterkey even without testserver being enabled. + interrupt_interval (int, max 32767) sets the time how long the player must wait until he can execute another command. This way you can prevent command spamming since all players/gms have to wait until the timer is over. Note that this does not count for admins, so GM_IMPLEMENTOR will not be affected by this! + pepper_key (string, default "peppertest12345") If you set this to anything else than "peppertest12345" it'll automaticall enable the pepper system. This way all passwords will be hashed with an additional phrase appended. This further enhances security. Note that all passwords should be encoded with the new pepper phrase. It works just like this: Instead of calling PASSWORD(userpass) it appends the pepper-phrase which results in this: PASSWORD(userpass + pepper_phrase). So be careful if you change this since your database must have valid entries, otherwise users will fail to log in. + MYSQL_PASSWORD_FUNCTION (string, default 'PASSWORD') this variable sets the name of the password-function that will be called when dealing with passwords. You can further enhance security this way if you define your own function to your database. You can for example first encode the passwords and then hash it. Note that if you change this value, your database must have a proper function that returns the encoded/hashed/whatever password out from plain text. If the function doesn't exist or your passwords aren't adapted to work with your custom function, login will fail! + unify_enable (bool, default false) Enables the unify-mode. This way the server forces utf-8 as it's encoding standard. Note: If you enable this, you'd change your database etc. to use utf-8 too! ~commands~ + su passphrase(string) Tries to elevate the player and grants him the permissions stored in gmlist after successfully elevating. Minimum rank: GM_PLAYER + promote user(string) gm_level(string, optional) First the command elevates the player. So if no gm_level is given, the player will receive the permissions he'd have if he elevates normally. If a gm_level is given (just type it like it's labeled, so if you want to give him high-wizard, type GM_HIGH_WIZARD) it'll overwrite the gm level for the current session (relog/teleport will remove it). Download Download (prebuilt): This is the hidden content, please Sign In or Sign Up Download (source): This is the hidden content, please Sign In or Sign Up pass (for both): vanilla 5 1 4 8 We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Janoso 1 Posted November 5, 2017 Share Posted November 5, 2017 i have this error ( GAME ) db compiles okey In file included from input_udp.cpp:7: ./item_manager.h:117:4: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? itertype(m_vecProbs) it = lower_bound(m_vecProbs... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:118:45: error: use of undeclared identifier 'it' return std::distance(m_vecProbs.begin(), it); ^ ./item_manager.h:152:9: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? for (itertype(m_vecItems) it = m_vecItems.begin(... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:152:55: error: use of undeclared identifier 'it' ...for (itertype(m_vecItems) it = m_vecItems.begin(); it != m_vecItems.end(... ^ ./item_manager.h:152:79: error: use of undeclared identifier 'it' ...it = m_vecItems.begin(); it != m_vecItems.end(); it++) ^ ./item_manager.h:154:9: error: use of undeclared identifier 'it' if (it->vnum == dwVnum) ^ ./item_manager.h:156:13: error: use of undeclared identifier 'it' return it->count; ^ ./item_manager.h:214:4: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? itertype(m_vecProbs) it = lower_bound(m_vecProbs... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:215:45: error: use of undeclared identifier 'it' return std::distance(m_vecProbs.begin(), it); ^ ./item_manager.h:399:55: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? ...GetSpecialGroupFromItem(DWORD dwVnum) const { itertype(m_ItemToSpecialGr... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:399:134: error: use of undeclared identifier 'it' ...it = m_ItemToSpecialGroup.find(dwVnum); return (it == m_ItemToSpecialGro... ^ ./item_manager.h:399:174: error: use of undeclared identifier 'it' ...return (it == m_ItemToSpecialGroup.end()) ? 0 : it->second; } ^ 12 errors generated. gmake: *** [Makefile:78: debug/input_udp.o] Error 1 same on gcc7 and gcc8 @EDIT SOO I've made it ... 1st error I change this in stdafx.h #define __typeof typeof to this #define __typeof __typeof__ and then I had an error about undefined "VOID" in "SetWindow(VOID);" LINE 1962 in item.cpp so I've changed it to "SetWindow(VOID2);" and it's okay... 1 Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 6, 2017 Author Share Posted November 6, 2017 vor 18 Stunden schrieb Janoso: i have this error ( GAME ) db compiles okey In file included from input_udp.cpp:7: ./item_manager.h:117:4: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? itertype(m_vecProbs) it = lower_bound(m_vecProbs... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:118:45: error: use of undeclared identifier 'it' return std::distance(m_vecProbs.begin(), it); ^ ./item_manager.h:152:9: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? for (itertype(m_vecItems) it = m_vecItems.begin(... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:152:55: error: use of undeclared identifier 'it' ...for (itertype(m_vecItems) it = m_vecItems.begin(); it != m_vecItems.end(... ^ ./item_manager.h:152:79: error: use of undeclared identifier 'it' ...it = m_vecItems.begin(); it != m_vecItems.end(); it++) ^ ./item_manager.h:154:9: error: use of undeclared identifier 'it' if (it->vnum == dwVnum) ^ ./item_manager.h:156:13: error: use of undeclared identifier 'it' return it->count; ^ ./item_manager.h:214:4: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? itertype(m_vecProbs) it = lower_bound(m_vecProbs... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:215:45: error: use of undeclared identifier 'it' return std::distance(m_vecProbs.begin(), it); ^ ./item_manager.h:399:55: error: use of undeclared identifier 'typeof'; did you mean 'typeid'? ...GetSpecialGroupFromItem(DWORD dwVnum) const { itertype(m_ItemToSpecialGr... ^ ./typedef.h:112:21: note: expanded from macro 'itertype' #define itertype(v) __typeof((v).begin()) ^ ./stdafx.h:37:18: note: expanded from macro '__typeof' #define __typeof typeof ^ In file included from input_udp.cpp:7: ./item_manager.h:399:134: error: use of undeclared identifier 'it' ...it = m_ItemToSpecialGroup.find(dwVnum); return (it == m_ItemToSpecialGro... ^ ./item_manager.h:399:174: error: use of undeclared identifier 'it' ...return (it == m_ItemToSpecialGroup.end()) ? 0 : it->second; } ^ 12 errors generated. gmake: *** [Makefile:78: debug/input_udp.o] Error 1 same on gcc7 and gcc8 @EDIT SOO I've made it ... 1st error I change this in stdafx.h #define __typeof typeof to this #define __typeof __typeof__ and then I had an error about undefined "VOID" in "SetWindow(VOID);" LINE 1962 in item.cpp so I've changed it to "SetWindow(VOID2);" and it's okay... Vanilla core is coded with clang as our toolset in mind. There's literally no testing or adapting to gcc, so it's no reason why you had to change some lines. Thanks for stating it here so people who wish to use gcc can use it. Everyone compiling with clang won't need those changes. We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Aliano 1 Posted November 6, 2017 Share Posted November 6, 2017 (edited) can someone help? and this Process: UNKNOWN HEADER: 200, LAST HEADER: 11(5), REMAIN BYTES: 3, fd: 21 Edited August 20, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 6, 2017 Author Share Posted November 6, 2017 first one is just a warning. The new unified mode should be used. This is not an error. The second one: Yes, I'm on it. dbcache is doing weird stuff and I already located the problem. Fix will be uploaded very soon. 1 We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
scrabbyyy 20 Posted November 6, 2017 Share Posted November 6, 2017 55 minutes ago, Vanilla said: first one is just a warning. The new unified mode should be used. This is not an error. The second one: Yes, I'm on it. dbcache is doing weird stuff and I already located the problem. Fix will be uploaded very soon. anymore working buidable server on vs for windows server files and where client side? Link to comment Share on other sites More sharing options...
Aliano 1 Posted November 7, 2017 Share Posted November 7, 2017 SYSERR: Nov 7 18:26:01 :: Process: UNKNOWN HEADER: 108, LAST HEADER: 254(2), REMAIN BYTES: 13, fd: 21 SYSERR: Nov 7 18:26:12 :: Process: UNKNOWN HEADER: 23, LAST HEADER: 254(2), REMAIN BYTES: 8, fd: 20 SYSERR: Nov 7 18:29:01 :: Process: UNKNOWN HEADER: 97, LAST HEADER: 0(0), REMAIN BYTES: 28, fd: 21 SYSERR: Nov 7 18:29:12 :: Process: UNKNOWN HEADER: 23, LAST HEADER: 0(0), REMAIN BYTES: 9, fd: 20 SYSERR: Nov 7 18:29:12 :: Process: UNKNOWN HEADER: 23, LAST HEADER: 0(0), REMAIN BYTES: 18, fd: 20 SYSERR: Nov 7 18:30:48 :: Process: UNKNOWN HEADER: 245, LAST HEADER: 0(0), REMAIN BYTES: 39, fd: 21 SYSERR: Nov 7 18:30:49 :: Process: UNKNOWN HEADER: 245, LAST HEADER: 0(0), REMAIN BYTES: 56, fd: 21 SYSERR: Nov 7 18:30:49 :: Process: UNKNOWN HEADER: 25, LAST HEADER: 0(0), REMAIN BYTES: 73, fd: 21 SYSERR: Nov 7 18:30:50 :: Process: UNKNOWN HEADER: 187, LAST HEADER: 0(0), REMAIN BYTES: 90, fd: 21 SYSERR: Nov 7 18:30:50 :: Process: UNKNOWN HEADER: 156, LAST HEADER: 0(0), REMAIN BYTES: 107, fd: 21 SYSERR: Nov 7 18:30:50 :: Process: UNKNOWN HEADER: 129, LAST HEADER: 12(9), REMAIN BYTES: 80, fd: 21 SYSERR: Nov 7 18:30:51 :: Process: UNKNOWN HEADER: 89, LAST HEADER: 0(0), REMAIN BYTES: 97, fd: 21 SYSERR: Nov 7 18:30:51 :: Process: UNKNOWN HEADER: 103, LAST HEADER: 0(0), REMAIN BYTES: 131, fd: 21 SYSERR: Nov 7 18:30:51 :: Process: UNKNOWN HEADER: 228, LAST HEADER: 0(0), REMAIN BYTES: 148, fd: 21 SYSERR: Nov 7 18:30:51 :: Process: UNKNOWN HEADER: 200, LAST HEADER: 0(0), REMAIN BYTES: 165, fd: 21 SYSERR: Nov 7 18:30:51 :: Process: UNKNOWN HEADER: 152, LAST HEADER: 0(0), REMAIN BYTES: 182, fd: 21 SYSERR: Nov 7 18:30:52 :: Process: UNKNOWN HEADER: 201, LAST HEADER: 53(14), REMAIN BYTES: 185, fd: 21 SYSERR: Nov 7 18:30:52 :: Process: UNKNOWN HEADER: 130, LAST HEADER: 0(0), REMAIN BYTES: 219, fd: 21 SYSERR: Nov 7 18:30:53 :: Process: UNKNOWN HEADER: 126, LAST HEADER: 0(0), REMAIN BYTES: 236, fd: 21 SYSERR: Nov 7 18:30:53 :: Process: UNKNOWN HEADER: 151, LAST HEADER: 0(0), REMAIN BYTES: 253, fd: 21 SYSERR: Nov 7 18:30:53 :: PartyInvite: PARTY Cannot find invited character SYSERR: Nov 7 18:30:53 :: Process: UNKNOWN HEADER: 177, LAST HEADER: 72(6), REMAIN BYTES: 264, fd: 21 SYSERR: Nov 7 18:30:54 :: Process: UNKNOWN HEADER: 217, LAST HEADER: 0(0), REMAIN BYTES: 281, fd: 21 SYSERR: Nov 7 18:30:54 :: Process: UNKNOWN HEADER: 93, LAST HEADER: 0(0), REMAIN BYTES: 298, fd: 21 SYSERR: Nov 7 18:30:54 :: Process: UNKNOWN HEADER: 37, LAST HEADER: 113(13), REMAIN BYTES: 302, fd: 21 SYSERR: Nov 7 18:30:55 :: Process: UNKNOWN HEADER: 165, LAST HEADER: 0(0), REMAIN BYTES: 319, fd: 21 SYSERR: Nov 7 18:30:55 :: Process: UNKNOWN HEADER: 95, LAST HEADER: 61(6), REMAIN BYTES: 330, fd: 21 SYSERR: Nov 7 18:30:55 :: Process: UNKNOWN HEADER: 195, LAST HEADER: 0(0), REMAIN BYTES: 347, fd: 21 SYSERR: Nov 7 18:30:56 :: Process: UNKNOWN HEADER: 22, LAST HEADER: 0(0), REMAIN BYTES: 364, fd: 21 SYSERR: Nov 7 18:30:56 :: Process: UNKNOWN HEADER: 148, LAST HEADER: 0(0), REMAIN BYTES: 381, fd: 21 SYSERR: Nov 7 18:30:56 :: Process: UNKNOWN HEADER: 91, LAST HEADER: 77(9), REMAIN BYTES: 387, fd: 21 SYSERR: Nov 7 18:30:56 :: Process: UNKNOWN HEADER: 110, LAST HEADER: 0(0), REMAIN BYTES: 404, fd: 21 SYSERR: Nov 7 18:30:57 :: Process: UNKNOWN HEADER: 127, LAST HEADER: 0(0), REMAIN BYTES: 421, fd: 21 SYSERR: Nov 7 18:30:57 :: Handshake: Invalid Handshake on 21 SYSERR: Nov 7 18:30:57 :: Process: UNKNOWN HEADER: 122, LAST HEADER: 0(0), REMAIN BYTES: 424, fd: 21 is it possible to get the rev67210 Source ? i am ready to pay for. Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 7, 2017 Author Share Posted November 7, 2017 New source and prebuild package online! I updated the links. They'd work now. same pass. This is the hidden content, please Sign In or Sign Up This is the hidden content, please Sign In or Sign Up 1 4 3 We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Aliano 1 Posted November 7, 2017 Share Posted November 7, 2017 dont load the Game after choose the character Vanilla i am very very happy with the rev67210 but my hands are tied without the source. I hope you can help me Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 7, 2017 Author Share Posted November 7, 2017 can you provide logs? Without them I can't see what's going wrong. This is the most recent source, there's no reason to downgrade to lower revs We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Aliano 1 Posted November 7, 2017 Share Posted November 7, 2017 ps: i created a new character this in channel: SYSERR: Nov 7 21:25:08 :: GetServerLocation: location error name mapindex 0 0 x 0 empire 3 and this in db syserr: SYSERR: Nov 7 21:25:08 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=1' at line 1 (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name` FROM player WHERE account_id`=1 errno: 1064) SYSERR: Nov 7 21:25:30 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1=22 WHERE `id`=1' at line 1 query: UPDATE player_index SET `pid`1=22 WHERE `id`=1 SYSERR: Nov 7 21:25:36 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=1' at line 1 (query: SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name` FROM player WHERE account_id`=1 errno: 1064) Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 7, 2017 Author Share Posted November 7, 2017 Okay, everybody. I found the problem and it's related to a change I tried when moving to higher mysql libraries. Therefore the dbcache is marked as probably unstable. I fixed it, but it's not sure if anything else may cause a crash. Please use the new dbcache only for debugging purposes. The new revision is backwards-compatible with earlier revs of our dbcache, so you don't need to worry about that. It could be that everything works now but I can't make a clear statement about this since more testing needs to be done. I reverted all the changes for character login, creation and fetching. New download links: This is the hidden content, please Sign In or Sign Up This is the hidden content, please Sign In or Sign Up I tested the login and char creation, it'd work now. Sorry for the inconvenience. Gamecore should work without any flaws since I didn't merge the test changes there. Only db is affected. 4 1 7 We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Aliano 1 Posted November 7, 2017 Share Posted November 7, 2017 still this error in db syserr with your new prebuilt files: SYSERR: Nov 7 22:31:52 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1=24 WHERE `id`=13' at line 1 query: UPDATE player_index SET `pid`1=24 WHERE `id`=13 and the same problem Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 7, 2017 Author Share Posted November 7, 2017 does this work? This is the hidden content, please Sign In or Sign Up 1 1 1 1 We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Premium tierrilopes 453 Posted November 7, 2017 Premium Share Posted November 7, 2017 17 minutes ago, Aliano said: still this error in db syserr with your new prebuilt files: SYSERR: Nov 7 22:31:52 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1=24 WHERE `id`=13' at line 1 query: UPDATE player_index SET `pid`1=24 WHERE `id`=13 and the same problem db/ClientManagerLogin.cpp You got unmatched ` probably Edit Downloaded and checked. db/ClientManagerLogin.cpp search for: "SELECT id, `name`, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player%s WHERE account_id=%u", Replace with: (2 times) "SELECT id, name, job, level, playtime, st, ht, dx, iq, part_main, part_hair, x, y, skill_group, change_name FROM player%s WHERE account_id=%u", search for: "SELECT COUNT(*) as count FROM player%s WHERE `name`='%s' AND id <> %u", GetTablePostfix(), p->name, p->pid); replace with: "SELECT COUNT(*) as count FROM player%s WHERE name='%s' AND id <> %u", GetTablePostfix(), p->name, p->pid); search for: "UPDATE player%s SET `name`='%s',change_name=0 WHERE id=%u", GetTablePostfix(), p->name, p->pid); replace with: "UPDATE player%s SET name='%s',change_name=0 WHERE id=%u", GetTablePostfix(), p->name, p->pid); look for: snprintf(szQuery, sizeof(szQuery), "SELECT pid1, pid2, pid3, pid4, empire` FROM player_index%s WHERE id`=%u", GetTablePostfix(), replace with: snprintf(szQuery, sizeof(szQuery), "SELECT pid1, pid2, pid3, pid4, empire FROM player_index%s WHERE id=%u", GetTablePostfix(), 1 Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 7, 2017 Author Share Posted November 7, 2017 Gerade eben schrieb tierrilopes: db/ClientManagerLogin.cpp You got unmatched ` yes, that was my bad. I implemented a 'fix' for mysql libraries >= 20. With more recent libraries I got some strange errors telling me that column names are ambiguous. So I went on and encapsulated every column name. Obviously, this turned out to be not working. The changes are still in db and somewhat causing trouble. As I said, this is only on the most recent version of the dbcache, every older rev should work and do it's job even with the more recent gamecore. I'll still support this new rev db and fix those errors if you keep feeding me with reports 1 We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Aliano 1 Posted November 7, 2017 Share Posted November 7, 2017 vor 5 Minuten schrieb Vanilla: does this work? This is the hidden content, please Sign In or Sign Up with this db the game is loading and the db syserr is empty. BUT i cant see me dressed equipment (no problem with 70220) and in the channel syserr: SYSERR: Nov 7 22:46:09 :: locale_find: LOCALE_ERROR: "로그인 화면으로 돌아 갑니다. 잠시만 기다리세요."; SYSERR: Nov 7 22:46:09 :: locale_find: LOCALE_ERROR: "%d초 남았습니다."; SYSERR: Nov 7 22:46:10 :: locale_find: LOCALE_ERROR: "%d초 남았습니다."; SYSERR: Nov 7 22:46:11 :: locale_find: LOCALE_ERROR: "%d초 남았습니다."; SYSERR: Nov 7 22:46:42 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:46:44 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:47:00 :: locale_find: LOCALE_ERROR: "아이템 획득: %s"; SYSERR: Nov 7 22:49:42 :: CharacterSelect: no account table Link to comment Share on other sites More sharing options...
Vanilla 1458 Posted November 7, 2017 Author Share Posted November 7, 2017 Try using the older rev. I'll drop dbcache and revert back to an older version. I'll also reimplement the changes I've made asap and bump a new rev. Expect some small treatments as my apologize, I didn't notice the changes until you started reporting them which I truely thank you for For the moment, please continue using the old rev for dbcache, you can still use the new game. We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. Link to comment Share on other sites More sharing options...
Aliano 1 Posted November 7, 2017 Share Posted November 7, 2017 Thank you very much Vanilla. i really would love to have the rev67210 source too. Es würde mich wirklich freuen. Link to comment Share on other sites More sharing options...
scrabbyyy 20 Posted November 9, 2017 Share Posted November 9, 2017 how compile game+db with visual studio for windows server files and which client compitably? lol Link to comment Share on other sites More sharing options...
pelimpolem 9 Posted November 9, 2017 Share Posted November 9, 2017 En 5/10/2017 a las 23:49, Vanilla dijo: Perdón por el retraso. La nueva construcción está lista. Estoy buscando voluntarios que quieran probar el nuevo núcleo. Solo déjenme una PM, solo necesito que alguien pruebe algunas cosas y estamos listos para la siguiente revisión. Shared object "libssl.so.8" not found, required by "gamefile" error plis solution? Link to comment Share on other sites More sharing options...
Janoso 1 Posted November 10, 2017 Share Posted November 10, 2017 you have to have libssl.so.8 in your lib32 folder (if FREEBSD 64bit) Link to comment Share on other sites More sharing options...
Recommended Posts