PlayerDatabase

Big database with light weight way to save it to prevent lag

Total Downloads: 874 - First Release: May 30, 2016 - Last Update: Jan 11, 2017

5/5, 6 likes
  1. Riddle

    Riddle Wood Hoarder

    Nice, MySql support!

    It would be nice to have an option in the config to select the table yourself, since some people have multiple servers and don't want a new database for everything :p
    --- Double Post Merged, Oct 10, 2016 ---
    And a "first join" and "last connect" entry in the db would also be nice for future reference on a website or such :p
     
  2. Reneb

    Reneb Grenade Master Plugin Developer

    player informations should give you the entries for "first join" and "last connect"
    --- Double Post Merged, Oct 10, 2016 ---
    Player Informations | Oxide
     
  3. Riddle

    Riddle Wood Hoarder

    Yeah but as far as I know it's not pushed to MySql....?
     
  4. Reneb

    Reneb Grenade Master Plugin Developer

    yes it should if you use mysql on this plugin
     
  5. Riddle

    Riddle Wood Hoarder

    Hmmmm, didn't say anything then. Let me check that ;) Thanks
     
  6. Freaky

    Freaky Shack Builder

    Hi can you add ResourceId? for the updater plugin! Thanks!
     
  7. SNOWGUM

    SNOWGUM Naked Wanderer

    I am in love with this plugin, it is so helpful! But I have some ideas, I am not that knowable with coding or any of that but I have it connected with My SQL and I was wondering if it would be possible to show the users Auth Level on the server, XP for rust and if you have plugins like Economics it could show their money and things like that! It would make life so easy?
     
  8. Reneb

    Reneb Grenade Master Plugin Developer

    it would be very easy to do that.
    Economics could easily implement that inside itself.
    As for auth level and xp i don't see in what plugin it could go, and would probably need to be a private plugin unless i make a complementary plugins for rust or add it inside players informations.
     
  9. SNOWGUM

    SNOWGUM Naked Wanderer

    Oh ok, how would I do the Economics?
     
  10. LISDA

    LISDA Wood Hoarder

    rust and oxide update, bug repot:
    Code (Text):
    [11/11/2016 06:03:00] [Oxide] 06:02 [Error] Error while compiling PlayerDatabase.cs(501,9): error CS0246: The type or namespace name `Ext' could not be found. Are you missing an assembly reference?
     
  11. Wulf

    Wulf Community Admin Community Admin Oxide Developer

    @Reneb: Namespace changed, Oxide.Core instead of Oxide.Ext for the database extensions. You shouldn't need to reference them directly though, Oxide.Core.Database should be all that is necessary. Quickfix, untested beyond compiling:
     
    Last edited: Nov 10, 2016
    NightShaman likes this.
  12. Reneb

    Reneb Grenade Master Plugin Developer

    NightShaman likes this.
  13. STANNIS BARATHEON

    STANNIS BARATHEON Wood Hoarder

    (16:34:25) | [Oxide] 16:32 [Error] MySql command callback raised an exception (InvalidCastException: Cannot cast from source type to destination type.)
    (16:34:25) | [Oxide] 16:32 [Debug] at Oxide.Plugins.PlayerDatabase+<LoadPlayerSQL>c__AnonStorey1.<>m__0 (System.Collections.Generic.List`1 list) [0x00000] in <filename unknown>:0
    at Oxide.Core.MySql.Libraries.MySql+MySqlQuery+<Handle>c__AnonStorey0.<>m__0 () [0x00000] in <filename unknown>:0

    Is this resulting from PlayerDatabase? The plugin was compiled correctly.
     
  14. Reneb

    Reneb Grenade Master Plugin Developer

    this is resulting from the mysql
    most likely it's not a correct mysql database (wrong address, user, pass, etc)
    If you didnt want to use mysql, just deactivate it in the configs.
     
  15. STANNIS BARATHEON

    STANNIS BARATHEON Wood Hoarder

    I definitely want to use MySQL, it was working properly without errors before the update/patch, is there someway I could fix it?

    Enhanced Ban System's Kicks/Bans seem to be working okay (and stored properly in MySQL).
    I just checked, new players are being stored properly in the MySQL database as well: within PlayerDatabase.

    I don't quite understand what the error message is a result from.
     
  16. Reneb

    Reneb Grenade Master Plugin Developer

    maybe one of the player is corrupted
     
  17. STANNIS BARATHEON

    STANNIS BARATHEON Wood Hoarder

    Is that error message negligible, could I just simply choose to ignore it? It's not incredibly frequent, only about every ~20 minutes or so.
    Can there also be a way somehow I could track down which data entry is causing the error or corruption?
     
  18. Reneb

    Reneb Grenade Master Plugin Developer

    Reneb updated PlayerDatabase with a new update entry:

    1.5.5

    Read the rest of this update entry...
    --- Double Post Merged, Nov 18, 2016 ---
    this should help you show you what user has a corrupted data
     
    STANNIS BARATHEON likes this.
  19. XswaggaboyX

    XswaggaboyX Scavenger

    [Oxide] 4:58 PM [Error] PlayerDatabase plugin failed to compile!
    [Oxide] 4:58 PM [Error] PlayerDatabase.cs(235,126): error CS1501: No overload for method `Query' takes `2' arguments
    Current Time: 15.03779
     
  20. Resistance

    Resistance Grenade Master

    You are running a old version please use the latest