SQL Explorer
6 Attachment(s)
I present to you SQL Explorer, an in-game SQL database manager for Graal.
For those of you who aren't familiar, SQLite is a "software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine". Basically, it's a really fast and efficient way to store data into tables. Data can range from logs to bank accounts to sparring stats. SQL Explorer is a multipurpose tool that makes it easy to view and manage all of this data. Current Version: 2.2 Features:
Screenshots: Attachment 49542 Attachment 49543 Attachment 49544Attachment 49545 Attachment 49546 Attachment 49547 Instructions: Upload to your server into a weapon script, add it to yourself, and press "n". If you want the databases tab to be fully functional, add r databases/*.db to the rights of (npcserver). Note: Until a way is found/added to dynamically get a list of configured SQLite databases, you will have to put them into the script manually. The function, getDatabaseList(), is at the very top of the script. It should be pretty self-explanatory how to add them. Thanks to:
Disclaimer: This is a tool for developers. It's not something that is completely bulletproof with security. In other words, if you're trying to mess something up or cause some kind of error, you probably can. It doesn't necessarily protect against SQL injection in all cases, so just be careful with what you do. See also: SQLite Database Browser - an external tool for viewing the database; it can be used in any instance where my tool fails for whatever reason If you find any bugs/glitches, please report them; I use this tool on a daily basis, and any bugs you have will eventually effect me too. Comments, criticism, and suggestions are also welcome. The latest version of SQL Explorer can always be found here. |
awsome work chris! rep++!
(got to spread it first Z_z) |
Very nice work. ^^
|
Very nice, will definitely manipulate my own tables with it. :D
|
Woah that's awesome.. =O, I'll be using this a lot.
|
This is some real quality work! :)
|
Updated to version 1.1 (thanks Tig); it contains a rights system (which can be enabled or disabled). See the first post for a description of how to use it (or disable it -- it's enabled by default).
|
This probably deserves a sticky.
|
Quote:
|
Are auto-incrementing constraints not available in the GS2 wrapper for sqlite? Because this tool reports an error any time I try to create a column with auto-increment set.
Edit: This is just an observation due to the auto-increment option in the SQL Explorer, I don't actually need to make use of it since SQLite has an auto-incrementing ROWID set by default. |
Quote:
EDIT: See this page as well. |
Quote:
|
Quote:
|
Quote:
|
Although it could easily be done under the "Execute Query" tab, searching would be a nice thing to add for when users are viewing a table.
Also sorting by column wouldn't be that hard to do, either. If you click a column header, it will sort the rows by that column...click it again and it will sort them in the opposite direction. |
All times are GMT +2. The time now is 01:16 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Copyright (C) 1998-2019 Toonslab All Rights Reserved.