Jump to content

ReFresh

Gold
  • Posts

    1796
  • Joined

  • Last visited

  • Days Won

    4
  • Feedback

    0%

Everything posted by ReFresh

  1. @ Tatsumaru I think he is doing that, because there's maybe some automatization, which will upload the github release directly to m2download.
  2. Thanks, but, would be better, if you can share the .psd file instead of sharing some "random" .tga titles, so that everyone can customize them.
  3. Where I'll find the MySQL includes for example for 64 bit machine? And can I compile db and game on 32 bit machine and then run the server on 64 bit machine? And the makefile need to be edited too right? That's the last thing I need to know.
  4. So all I need to do is what Asikoo said in the topic, which he mentioned? 1. You must compile your "db" and your "game" with the MySQL 8.0 includes. - That means I need to replace some MySQL includes in server source and then compile game and db again? And surely I'll need to edit makefile too right? And where I'll find the includes for example for 64 bit machine? Or can I compile it on 32 bit and then run the server on 64 bit? 2. Change the password encryption method or imitate the PASSWORD() function (it has been removed) 3. Some columns must be wrapped (in the cpp file) ("window", "rank" for example...) - window, rank are all columns, which I need to edit or there're more? And that's all? It's that simple?
  5. Ah, you didn't update the github repo since now. Didn't see it was already metioned.
  6. Thanks guys, but your answers aren't clear. It won't help me with anything. There are tons of things, which I need to know to do the "simple" database version change and that's a big problem for me. Firstly, I'll need to know this: 1. How to export databases with data to make it much compatible as possible? Is possible to export databases from MySQL 5.6.51 and then import them to MySQL 8.0 without errors? What I tried: 1. I downloaded some last .vdi file with preinstalled MySQL 5.6.51 to successfully run the queries to the database without errors. 2. What now? I tried to export account, common, hotbackup, log, player databases to .sql files one by one containing data + structure. Then I went to server where I had MySQL 8.0 installed and tried to import those .sql files. What happened? Tons of errors appeared and tons of tables were empty. 3. I tried to use Navicat function named Reverse Database to Model, then I clicked on File --> Convert Model to --> Model type -->Physical --> Target Database --> Database --> MySQL --> Version 8.0 --> Export SQL or synchronize to database (I tried both). Again what happened? Only structure of the database without data was exported. Second thing, which as I can see, it'll be needed to change some things in server source code. But I'll ask later for that. As first I need to successfully import the tables to MySQL 8.0 without errors and with all the data. Hm... Just managed to fix the error with mob proto: 1265 - Data truncated for column 'size' at row 1 by replacing INSERT INTO to INSERT IGNORE INTO in mob_proto query. Is that simple to solve these errors or should I take a care of them?
  7. Hey guys, I want to ask, if it's possible to upgrade MySQL database from 5.6.51 to MySQL 8.0 or to MariaDB, depends on what would be easier, if possible. I want to keep all my data + structure. I saw some tutorials here on the forum, but I'm confused from them. They're not clear for me. I was trying to manage the upgrade whole day, but I wasn't successful and that's really heart breaking for me, because now it's not possible to download an old packages from FreeBSD trees, they're all removed and forever gone So I cannot do my hobby in my free time. I would be really glad, if someone can help me with that. Thanks for possible answers! Sincerely, ReFresh
  8. Thanks guys, I just realized, it would be better to change to another hosting where the FreeBSD is still supported.
  9. Hey guys, I just bought OVH VPS server and I'm struggling with FreeBSD installation all night and I wasn't successful. I wanna ask, if it's still possible, because I tried almost all methods found on the whole internet and nothing worked. Thanks for answers! Sincerely, ReFresh
  10. So that function will look like this? And CStateManager::SetDefaultState function will be set to default? So that means I won't do changes, which @Trial did? Correct me please, if I'm mistaken somewhere. Thanks
  11. I tried to rename to minning. It had no effect. No mines were found in npclist.txt Exist some way how to debug it, to find why it's not working?
  12. Check the spoiler, it's directly copied from the files, which I edited. Already tried and still 0 output when the mine event starts.
  13. I followed the github tutorial again to check for possible mistakes and no mistakes were found. The mine event still doesn't work. I can't see any reason why it doesn't work. No errors, syssers, syslogs... Everything is added correctly and I still can't get the notice output when I start the mine event. It's only the mine event, so it's really weird. Looks like I'm the only one who added and completely tested these events. Here I can prove that everything is added correctly: Do you have some ideas why it doesn't work? Is there another person who tested the notice output when you start the mine event? Thanks for possible suggestions, corrections.
  14. And one more thing. I don't get notice when I start mining with pickaxe. I'm 100% sure that I didn't do mistake in my files. Can you check it?
  15. First of all, thank you for this release! There are few details, which I have to say: 1. You can get error when compiling: File: questmanager.cpp: LC_STRING("Äù½ºÆ®¸¦ ·ÎµåÇÏ´Â ÁßÀÔ´Ï´Ù. Àá½Ã¸¸ ±â´Ù·Á ÁֽʽÿÀ.") Should be like this by default: LC_TEXT("Äù½ºÆ®¸¦ ·ÎµåÇÏ´Â ÁßÀÔ´Ï´Ù. Àá½Ã¸¸ ±â´Ù·Á ÁֽʽÿÀ.") And what does it mean? I couldn't find any translation in my locale_string.txt. It's something like: Quests aren't loaded? 2. You probably won't find this line: File: shop_manager.cpp: // search DBManager::instance().SendMoneyLog(MONEY_LOG_SHOP, item->GetVnum(), iPrice); Should be like this by default: // search DBManager::instance().SendMoneyLog(MONEY_LOG_SHOP, item->GetVnum(), dwPrice); Because iPrice is by default dwPrice, if I'm not mistaken.
  16. So could it be placed at the end of the 'CStateManager::SetDefaultState' function? Or it should be placed somewhere else in 'CStateManager::SetDefaultState' function? So it will look like this?
  17. You can get this error: 'c_rstrMapFileName': redefinition; multiple initialization' Just remove const std::string c_rstrMapFileName = CPythonBackground::Instance().GetWarpMapName(); in @ martysama0134 code it's defined twice. [Hidden Content]
  18. Hey guys, I'm trying to color the text variable, but there's a problem. When I try to send a message to player, I'll get an erorr: item prism needed, also if I have item prism in my inventory, error will be same and the message won't be send. I know why it's happening, it's because in server input_main.cpp exist a function, which is checking for the characters like | etc. But I cannot get rid out of it. Someone got some idea how it could be solved? PS: I don't want to remove item prism requirement for highlighting items in chat. net.SendWhisperPacket(self.targetName, player.GetName() + " (" + str(player.GetStatus(player.LEVEL)) +") " + "|cFF8000FF" + text) Thanks for possible answers! Sincerely, ReFresh
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.