[SEC/MECH/FUN] PreciousStones - Block Area Proteciton System [BukkitDev]

Discussion in 'Archived: Plugin Releases' started by phaed, Jan 18, 2011.

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

    phaed

  2. Offline

    phaed

    Read this section: Read before upgrading to 5.0.3 or higher

    Their own. Well that's not that bad. A server restart or /ps clean will clean up the orphan fields. and if the unprotected pstones get stolen its their own fault.

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

    lukehib

    Code:
    09.07 02:33:48 [Server] INFO [PreciousStones] world unbreakables: 0
    09.07 02:33:48 [Server] INFO [PreciousStones] world fields: 0
    09.07 02:33:48 [Server] INFO [PreciousStones] Creating table: pstone_grief_undo
    09.07 02:33:48 [Server] INFO [PreciousStones] Creating table: pstone_unbreakables
    09.07 02:33:48 [Server] INFO [PreciousStones] Creating table: pstone_fields
    09.07 02:33:47 [Server] INFO [PreciousStones] MySQL Connection successful
    09.07 02:33:46 [Server] INFO [PreciousStones] world orphan fields: 0
    09.07 02:33:46 [Server] INFO [PreciousStones] configured fields: {1}
    09.07 02:33:46 [Server] INFO [PreciousStones] version 5.0.4 loaded
    It's made new tables. When I go into PHPMyAdmin there is the table ps_fields with around 2000 entries. But now it has made pstone_fields with 0 entries.
     
  4. Offline

    phaed

    Read section: Read before upgrading from 4.x
     
  5. Offline

    lukehib

    Hi. Sorry, about that. I never knew it would be so out of date. Anyway all of the fields got loaded now and when I do /ps list they all show.
     
  6. Offline

    thefoxygranpa

    Yep I came to that conclusion. Oh well :p
     
  7. Offline

    staniboy

    can anyone help me make one or share lwc config for a wooden door. I want anyone to be able to destroy protected doors unless it on protected area...

    Thank You
     
  8. Offline

    Keegan

    Agggh, keeping up with all the changing is so hard, I dont want to have to go through mysql and then install a bunch of stuff, then have a new version come out where all that stuff is useless? How am I supposed to do install the config thing on a bought domain?

    I liked preciousstones when it was just drop this into your plugin folder, then your done.
     
  9. Offline

    phaed

    That's how it is now. It now defaults to SQLite, so you can just drop it in. Also now we are using a direct interface to MySQL and SQLite, so i can make any sql changes from the code now. So this will be the last of the "run these queries" hassle.

    Trust me it was worth it, PS now runs smooth as silk.
     
  10. Offline

    Bronski

    I'm not sure if something changed but we're getting the field info when we right-click the ground inside a field with nearly anything (torch, hand, etc.). Are the "tool-items" in the config supposed to be the only ones to perform that function?
     
  11. Offline

    phaed

    Yes this was a glitch that went up momentarily. Re-download 5.0.4.
     
  12. Offline

    Bronski

    I did just now. The file compares identical (sorry) :/
     
  13. Offline

    phaed

    Try now
     
  14. Offline

    Bronski

    That's just cheating :p


    Thanks!

    EDIT: The file size is different but it's still doing it for me (and it reports itself to be 5.0.4 when I do /ps). Hmmm. Also, the stand-alone jar seems to be different than the one in the .zip file for me at this moment. But I think both versions were still doing it.
     
  15. Offline

    phaed

    Lord, long night. Didn't put the jar in the zip. Re-download.
     
  16. Offline

    Bronski

    It's working now :)

    I'm just glad we got it resolved. Thanks for staying on it. The plugin is otherwise working smooth indeed for me.
     
  17. Offline

    mrgreaper

    ah thats annoying, but understandable is there anyway it can only stop ones pointed at the ps block? or have it disableable in the config ?

    must admit i reinstalled it 4 times, deleted and redid the config file twice trying to fix this bug lol
     
  18. Offline

    phaed

    '
    Ill add add a setting to disable that for next version.
     
    mrgreaper likes this.
  19. Offline

    mrgreaper

    much appreciated
     
  20. Offline

    Kaosvf

  21. Offline

    lukehib

    When players try and place a block, it says they cant as there is a PS placed from a player. Now, when I do ps info and go to the co ords of the PS there is none there. It says no fields found also. But when placing blocks it says there is?
     
  22. Offline

    Guvnors

    I get a bug where it says there is a protection block in a certain area. However I go to that area but there is no block there any more.

    Any fix on this?
     
  23. Offline

    thefoxygranpa


    /ps clean

    It will clean the "orphaned" fields in the world. aka remove ps fields for blocks that no longer exist.
     
  24. Offline

    Niff

    Hey, love the plugin so far, but I have a few questions, I don't manage the sql related things of our server, and the guy who does is going to be out of town for a month, so I am hoping you can help me out.

    I had a PS version 4 something before, so in accordance with your suggestion, I ran it once, saw it make some new entries, but I cannot seem to migrate things over. Here is the gist of my server config and what I tried to run:

    old bukkit.yml
    Code:
    database:
        username: bukkit
        isolation: SERIALIZABLE
        driver: com.mysql.jdbc.Driver
        password: mypassword
        url: jdbc:mysql://localhost/precious
    
    Here is the snippit from that new cfg file:
    Code:
    mysql:
        enable: true
        username: bukkit
        host: localhost
        password: mypassword
        database: precious
    
    And here is what happens when I try to run the sql commands

    Code:
    $ mysql -u bukkit -p precious
    Enter password:
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2392
    Server version: 5.0.77 Source distribution
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    mysql>  INSERT INTO `pstone_fields` (`id`, `x`, `y`, `z`, `world`, `radius`, `height`, `velocity`, `type_id`, `owner`, `name`, `packed_allowed`, `packed_snitch_list`);
    ERROR 1064 (42000): 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 '' at line 1
    mysql> Aborted
    
    Like I said, I have never used sql before to any extent, so I am not sure what I am doing wrong any help you can give me would be awesome!
     
  25. Offline

    phaed

    Could be you ha
    Could be you have orphaned blocks from removing them with the worldedit super pickaxe?

    Sure thats cause you are running half the query, the full query is:

    INSERT INTO `pstone_fields` (`id`, `x`, `y`, `z`, `world`, `radius`, `height`, `velocity`, `type_id`, `owner`, `name`, `packed_allowed`, `packed_snitch_list`) SELECT `id`, `x`, `y`, `z`, `world`, `radius`, `height`, `velocity`, `type_id`, `owner`, `name`, '' as one, '' as two FROM `ps_fields`

    And the second one is:

    INSERT INTO `pstone_unbreakables` SELECT * FROM `ps_unbreakables`

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

    Guvnors

    Yes, should I still use /ps clean?
     
  27. Offline

    phaed

    Yes /ps clean, plugin reload, or server restart will clean those up.

    Thanks, will be fixed on next version

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

    Keegan

    Since you can make it so forcefields are protected from creepers, can they be protected by ghasts?
     
  29. Offline

    phaed

    They should be already with the prevent-explosions field flag.
     
  30. Offline

    staniboy

    Hello sir, I have an request...can something like prevent-use be added to block player interaction with levers/doors etc... something like prevent-use: wooden_door,69
     
  31. Offline

    phaed

    Will be on next version
     
Thread Status:
Not open for further replies.

Share This Page