Jump to content

ReFresh

Gold
  • Posts

    1796
  • Joined

  • Last visited

  • Days Won

    4
  • Feedback

    0%

ReFresh last won the day on July 22 2022

ReFresh had the most liked content!

3 Followers

About ReFresh

  • Birthday 05/29/1990

Informations

  • Gender
    Male

Recent Profile Visitors

5309 profile views

ReFresh's Achievements

Grand Master

Grand Master (14/16)

  • Problem Solver Rare
  • Very Important Person Rare
  • Reacting Well
  • Dedicated
  • Very Popular Rare

Recent Badges

2.2k

Reputation

  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
×
×
  • 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.