Posts by yahwho

  • Setting up MySQL server - help needed!

    Haha fixed it.


    Anyone else using the latest MySQL server build you will need to set the password as native via the shell.


    Code
    \sql ALTER USER 'rwadmin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'thisissillypassword';

    \sql FLUSH PRIVELEGES;

  • Setting up MySQL server - help needed!

    Has anyone setup a MySQL server recently? I've not done this in a few years and I'm stuck! :wat:


    I thought I would rebuilt my local test server on my workstation - clean OS install.


    I've installed the latest MySQL Community (v8) including the shell. Last one I used was version 6!


    Opened the MySQL Shell up and created a database called `risingworld` also creating a user called `rwadmin` and assigned the user all privileges to the new database. Reopened the shell and connected with new credentials to database to check working. Sure was!





    I have then installed a local copy of the RW standalone server via the SteamCMD tool. I won't bore you with screenshots...


    I've then gone and changed the server.properties file to reflect the MySQL server.




    I run the win_startscript.bat but the server fails to start. :dizzy:




    Clearly the Access denied for user 'rwadmin'@'localhost' (using password: NO) is to blame - but I don't get why the password I've supplied in the server.properties file is not being used:?:


    I'm a little lost.



  • Allocating more RAM

    Only Red can answer this, in order for a 32 bit program to access more that 4GB ram the program itself needs to manage the memory. But this is bad practice imho.


    Having said this, there is a very simple way you can find out. . . ;)

  • MRPrecision - a GUI for setr setl setp commands (version 0.0.2 now ready)

    Quote from Groovaholic

    Hi I've just reinstalled this (been away from the game) and for some reason the skin now isn't working for me all I'm getting is a plain white skin "I'm guessing iv got the jpg in the wrong place" where exactly dose this go again?

    Inside the plugin folder, there should be a nested folder called "img" and inside that there should be a single jpg file called background.jpg



    plugins/MRPrecision/img/background.jpg

  • Ore Detector and other configs

    1. As far as I am aware coal is not an ore so the Ore Detector not being able to find coal makes sense. Coal is neither a mineral or rock comprised of minerals. Coal is actually composed of macerals which is the organic equivalent of minerals.


    2. Okay you have done it! :P


    3. The main files you want to edit are the database files and some JAR files. There are a lot of topics on this very subject on the forums. The Plugin Discussion forum would be my go to place.


    4. Limitations are only to your imagination - and of course the API - https://javadoc.rising-world.net/


    5. Yes, you could probably do this via the API. I would suggest you look at the PlayerDestroyTerrainEvent there is a method in there called getTerrainID


    Java
    public int getTerrainID()

    //Gets the terrain id the player is going to destroy.

    //Returns:

    //the old terrain id.


    You could then work out if the terrain was an ore and then add extra ore to the players inventory (if they have space!).