PreciousStones - Back under the development of phaed

Discussion in 'Inactive/Unsupported Plugins' started by aPunch, Apr 20, 2011.

Thread Status:
Not open for further replies.
  1. Offline


    Ryannober, Avous and kahlilnc like this.
  2. Offline


    Yea no I didn't mean create a mysql.db file. lol. This isn't sqlite it doesn't run off a file. Since you know nothing of databases, getting MySQL to work is not gonna happen without a lot of research in your part.
  3. Offline

    Zane B.

    true dat lol
  4. Offline


    Just wanted to say your github link isn't working and is there ever hopes of this going back to flatline? I was going to search the github for an older version that might be compatible with build 740.

    Thanks :)
  5. Offline


    I don't plan on ever going back to flatfile. I'm not sure if phaed wants to, but I'm sure he wouldn't go back to flatfile either.
  6. Offline


    Pretty much.
  7. Offline


    It works! Having them delete all the databases and reinstalling 4.12 fixed it.

    Thanks for the help troubleshooting and for both you and aPunch for keeping it going!
  8. Hello, I have older version, with proper config... We are using this with cb#740... iConomyChestShop is using sqlite settings from bukkit.yml and we have so many shops there... I wont convert them to mysql, when I can use this :)

    Thanks for repaired link, I think you should repair that in first post too... :)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 13, 2016
  9. Offline


    An option would be to extract the data from the sqlite db, change bukkit.yml to mysql, then repopulate the tables with said data. At one point the older versions of PS will stop working with the current bukkit and you will have to make a choice of keeping only one of the plugins' data.
  10. Offline


    The Database is confliciting with EconomyChestShop meh i want to use it so bad cant you just go back to flat filles?
  11. Offline


    +1 for flat files. It's just more easier for me to manage.
  12. Offline


    @ FlatFilers
    The reason flat files were abandoned is because on servers that put a lot of strain on precious stones by having large files causes severe lag whenever precious stones started up or attempted to process anything

    Don't get me wrong, I want to go back to Flat Files as well as I have 2 or 3 plugins that use SQLite so I can't use PreciousStones because of it's MySQL dependancy (AFAIK anyway) but at the same time I understand the constraints of the software because I program PHP, benchmarking my flatfile databases against MySQL shows that MySQL scripts will complete several times faster that flat file and that grows exponentially the bigger the database gets, there is no real way to compensate for this, at the end of the day MySQL is the better option

    Unless SQLite gains the functionality that phaed and aPunch need (table join) then MySQL is truly the only option they have besides having complaint after complaint that PS causes problems that can't be fixed in flat file

    Now you guys can either respect the fact that they will go one way or the other and that MySQL is always going to be the better option or you can go looking for someone to fork PreciousStones and write it flat-file but if you go that way then you will have no right to complain about the lag it can cause because flat file will do that

    @phaed @aPunch
    I just looked in to permissions v3 and either I'm reading this wrong or they don't use the bukkit yml to define their connection details
    Can you look in to this as it would solve the MySQL or SQLite problem if I'm not mistaken

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 13, 2016
  13. Offline


    @phaed: granted have not upgraded to 4.1.2 yet (waiting for players to be off server), but noticed that if I right click on my Protector Stone (iron block; prevent-mob-spawn;prevent-mob-damage) that i do not get the text that shows the function flags.
  14. Offline


    @phaed @aPunch
    would it be possible to add permissions support for cave control so like you could only build inside forcefields but you could destroy outside them? i cant launch my server until i have some plugin that only allows you to build inside "Cities" but destroy anywhere else.

    Ah nvm he didnt add the source and i figure it would be a lot of work to disable building outside forcefields as a config option from scratch. thanks anyways
  15. Offline


    Ahh thanks for catching that.

    Yea they are starting up a separate MySQL instance just for their plugin and hand writing all the SQL themselves. This is not object persistence, this is the old method of adding MySQL support. This *could* be done with PS but its a ton of work as it would involve the creation of the tables and constraints to match the current structure, then hand writing all the SQL that handles all of the inserts, deletes, and updates for each table. Then doing it all over again for SQLite. It's not pretty and its not the preferred method of doing things. Maybe if aPunch wants to give a crack at it, but I'm sure not about to take this on.

    Change log
    Version 4.1.3 - by phaed
    • Fixed mob damage/spawn, animal spawn not showing on right click details
    • Added preciousstones.blacklist permission

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 13, 2016
  16. Offline


    I wasn't aware it would be so much work, aPunch if you do consider taking this on then make it a LOW priority please, I don't want you tied up handling this
  17. Offline

    Don Redhorse

    well it will become an issue if more developers start using persistance.. fields is a too common word..

    but other developers make the same mistake..
  18. Offline


    Late to the party, the tables have been prefixed with ps_ since 4.1
  19. Offline


    @phaed: Ran into problems upgrading to 4.1.3 - did all the SQL just fine and even did some db pruning. Been using MySQL since you supported it. Definitely not first time use. Seems unusual that it is trying to create the old tables. Notice the bold - are you sure you got the right jar in the 4.1.3 zip?

    The jar file in the 4.1.3 zip file is listed as modified 5/12. Note the version below in the console. message. I checked three times to be sure.

  20. Offline


    Damn I sent aPunch the wrong link. Use this one for now:
  21. Offline


    Just redownloaded and checked the plugin.yml:

  22. Offline


  23. Offline


    Looks good - Thanks!
  24. Offline


    Ok so, if you're admin and have "*" permission then you will inherit the new blacklist permission and will be blacklisted.

    Download fixed version here

    aPunch will update OP when he comes back online.
  25. Offline


    What do you do if you already have a bukkit.yml?
  26. Offline


    If its set for MySQL then you're all good. If its SQLite then you have to change it to MySQL. Whatever plugin that was using it will now use MySQL and its data will be reset :/
  27. Offline



    username: bukkit
    isolation: SERIALIZABLE
    driver: org.sqlite.JDBC
    password: walrus
    url: jdbc:sqlite:{DIR}{NAME}.db

    Ok so its lite, do i just rename this to mysql or when i copy and paste your yml, i overwrite what i have?
  28. Offline


    Yes switch it for the one in the OP. But it's not just switching the bukkit.yml. You actually have to create the MySQL database. And plug in the DB name, username, and pass. If you don't know how to do this, I cant help you, you will have to research on your own.
  29. Offline


        username: root
        isolation: SERIALIZABLE
        driver: com.mysql.jdbc.Driver
        password: yourDBpassword
        url: jdbc:mysql://localhost/minecraft
    I use brohoster and do not have access to my database. This is my info, how would I change it?


    Host: mysqlhost
    User: MICH****
    Pass: *delete*
    Database: TC64615875372210512388343

  30. Offline


    I try to update all my mods.... I have trouble with Preciousstones....

    I have test with a new fresh install...Only Preciousstones, Permissions and Help... Nothing else...
    CraftBukkit : 766...

    The database is ok, tables are created without any problems.

    Here is the start log :

    15:29:52 [INFO] Starting minecraft server version Beta 1.5_02
    15:29:52 [INFO] Loading properties
    15:29:52 [INFO] Starting Minecraft server on *:25000
    15:29:52 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-729-g5ee3f0f-b766jnks (MC: 1.5_02)
    15:29:52 [INFO] Preparing level "world"
    15:29:52 [INFO] Preparing start region
    15:29:53 [SEVERE] not found
    15:29:53 [INFO] DataSourcePool [PreciousStones] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    15:29:54 [INFO] DatabasePlatform name:preciousStones platform:mysql
    15:29:54 [INFO] SubClassFactory parent ClassLoader []
    15:29:54 [INFO] Entities enhanced[0] subclassed[6]
    15:29:54 [INFO] [Permissions] (Phoenix) was Initialized.
    15:29:54 [INFO] [PreciousStones] version 4.2 loaded
    15:29:55 [INFO] [PreciousStones] Help plugin support enabled
    15:29:55 [INFO] [Permissions] version [2.7.3] (Phoenix) loaded
    15:29:55 [INFO] [PreciousStones] world fields: 0
    15:29:55 [INFO] [PreciousStones] world unbreakables: 0
    15:29:55 [SEVERE] null loading PreciousStones v4.2 (Is it up to date?)
    at net.sacredlabyrinth.Phaed.PreciousStones.managers.TagManager.tagWorld(
    at net.sacredlabyrinth.Phaed.PreciousStones.managers.TagManager.checkTaggedWorlds(
    at net.sacredlabyrinth.Phaed.PreciousStones.managers.TagManager.<init>(
    at net.sacredlabyrinth.Phaed.PreciousStones.PreciousStones.onEnable(
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(
    at net.minecraft.server.MinecraftServer.e(
    at net.minecraft.server.MinecraftServer.a(
    at net.minecraft.server.MinecraftServer.init(
    15:29:55 [INFO] [HELP] 44 extra help entries loaded
    15:29:55 [INFO] [HELP] Permissions enabled using: Permissions v2.7.3
    15:29:55 [INFO] [HELP] Help 0.2 enabled
    15:29:55 [INFO] Done (0,247s)! For help, type "help" or "?"

    Thanks for your help.


    it's ok with this version.... I will use this for the moment.


    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 13, 2016
  31. Offline

    Don Redhorse

    thanks.. now I need to check which version I have.

    2 comments though...:

    a) I would have thought that the persistance module would handle the unique tables itself or that it would be a requirement to have unique tables... which would than require a central repository as there could be a plugin Pimp My Server which could also use ps_ :)
    b) I REALLLY love PreciousStones... even when I'm only using it with wool and as the original Anti Grief system.. NO admin necessary... user self protection.. way better than worldguard and other manual protection tools.
Thread Status:
Not open for further replies.

Share This Page