PlayerDatabase

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

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

5/5, 6 likes
  1. CaptainNebulous

    CaptainNebulous Shack Builder

    oxide/data

    it's the only file that it creates. I tried both methods of manually creating the playerdatabase folder and letting it create it itself (I noticed with last version it created it by itself)
     
  2. CaptainNebulous

    CaptainNebulous Shack Builder

    I was being a noob XD didn't totally understand how SQ works now I do. I feel like the default config used to be files mode though possibly. I don't recall ever having to change a setting to make it work in files mode. That being said now that I know about SQLite I will be using that format
     
  3. Reneb

    Reneb Grenade Master Plugin Developer

    aha good to know ^^
     
    CaptainNebulous likes this.
  4. Scarecrow

    Scarecrow Naked Wanderer

    Just ran across this error while running this in Rust (which may mean issues else where?)

    Code (Text):
    (19:12:15) | [Oxide] 02:12 [Error] MySql handle raised an exception (MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's Fleshlight"',`ip` = '"73.133.78.6"',`steamid` = '"76561198008861038"',`IPs` = ' at line 1)
    Basically the Users name was "PaPa's Fleshlight" the error was caught due to the mishandling of the _'_ comma, anyway to add something to work around that if it occurs?
     
  5. Reneb

    Reneb Grenade Master Plugin Developer

    ah ok i see.
     
  6. CaptainNebulous

    CaptainNebulous Shack Builder

    There didn't seem to be an identifier but I think this is an error related to this plugin since it's my only SQLite plugin. I get this after the most recent Hurtworld update and Oxide update.


    11:05 PM [Error] Sqlite handle raised an exception (SQLiteException: SQL logic error or missing database
    near "s": syntax error)
    11:05 PM [Debug] at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0
     
  7. Reneb

    Reneb Grenade Master Plugin Developer

  8. Scarecrow

    Scarecrow Naked Wanderer

  9. iiAmAko

    iiAmAko Wood Hoarder

    (19:16:23) | [Oxide] 7:13 PM [Error] Sqlite handle raised an exception (SQLiteException: SQL logic error or missing database

    near "ll": syntax error)

    (19:16:23) | [Oxide] 7:13 PM [Debug] at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0

    at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0

    (19:16:23) | [Oxide] 7:13 PM [Error] Sqlite handle raised an exception (SQLiteException: SQL logic error or missing database

    near "ll": syntax error)

    (19:16:23) | [Oxide] 7:13 PM [Debug] at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0

    at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0
     
  10. Reneb

    Reneb Grenade Master Plugin Developer

    hmmmi don't really understand why it would do that
    probably the name of the player that is making the data crash
    i'll try to find a fix.
    --- Double Post Merged, Oct 6, 2016 ---
    you used the latest version right?
     
  11. Reneb

    Reneb Grenade Master Plugin Developer

  12. sKilloWsky

    sKilloWsky Wood Hoarder

    where i must paste config about sql informations, i create file playerdatabase.db in /oxide/data, plugin create new clear files in playerdatabase folder ;c
    I dont have players informations in sql base
     
  13. Reneb

    Reneb Grenade Master Plugin Developer

    sql is a mysql database, you need it to use it.

    sqlite is the playerdatabase.db file. You dont need to create it as it creates itself
     
  14. sKilloWsky

    sKilloWsky Wood Hoarder

    ok, i use mysql in my server, where i must paste
    Code (Text):
    {
      "Data Type : 0 (Files) or 1 (SQLite) or 2 (MySQL)": 2,
      "MySQL - Database Name": "rust",
      "MySQL - Host": "localhost",
      "MySQL - Password": "toor",
      "MySQL - Port": 3306,
      "MySQL - Username": "root",
      "SQLite - Database Name": "playerdatabase.db"
    }
     
    with my settings? Where i must paste it
     
  15. Reneb

    Reneb Grenade Master Plugin Developer

    SQLite:
    "SQLite - Database Name": "playerdatabase.db"

    Mysql:
    "MySQL - Database Name": "rust",
    "MySQL - Host": "localhost",
    "MySQL - Password": "toor",
    "MySQL - Port": 3306,
    "MySQL - Username": "root",

    if you don't know how to set those mysql settings, don't use it
     
  16. sKilloWsky

    sKilloWsky Wood Hoarder

    I know how use it..
    I dont know where location i must paste this in hurtworld.
    For something config?
     
  17. Reneb

    Reneb Grenade Master Plugin Developer

    you always place the plugins inside oxide/plugins, and configs auto generate in oxide/configs
     
  18. sKilloWsky

    sKilloWsky Wood Hoarder

    i know, plugin work, but just plugin not auto generate config in oxide/configs
    So i must add playerdatabase.json manually?
     
  19. RSG

    RSG Naked Wanderer

    work perfect
     
    Last edited: Oct 9, 2016
  20. sKilloWsky

    sKilloWsky Wood Hoarder

    that same