Garry's Mod

Garry's Mod

149 个评价
SQLWorkbench - In-game SQLite & MySQL database viewer
3
   
奖励
收藏
已收藏
取消收藏
素材类型: 插件
插件类型: 工具
文件大小
发表于
更新日期
899.086 KB
2019 年 4 月 14 日 下午 2:04
2020 年 9 月 15 日 下午 3:41
7 项改动说明 ( 查看 )

订阅以下载
SQLWorkbench - In-game SQLite & MySQL database viewer

在 Methylenedioxymethamphetamine 的 2 个合集中
GAS
3 件物品
dev
28 件物品
描述
🖥️ SQLWorkbench 🖥️
This tool is an in-game SQLite & MySQL database interface for Garry's Mod.

Using this tool, you can manage your server's local SQLite database (garrysmod/sv.db) and any remote MySQL databases you desire to connect to.

───────────────────────────────────────────────────────────────

👉 Requirements 👈
Only super admins can use SQLWorkbench.

To connect to MySQL databases, your server must have the MySQLOO module[github.com] installed.

───────────────────────────────────────────────────────────────

⚙️ Usage ⚙️
To open the menu, first make sure you are a super admin, and then either:

  • Type !sqlworkbench in chat
  • Type sqlworkbench in your game's console

───────────────────────────────────────────────────────────────

⚡ Features ⚡
  • Interface with remote MySQL servers
  • Interface with server's local SQLite database
  • Execute SQL queries
  • SQL beautifier
  • SQL syntax highlighting
  • Basic live SQL autocompletion
  • Supports multiple simultaneous MySQL connections
  • Tabbed view of each connection
  • View results of SQL queries
  • All actions are logged to the server's console
  • Automatic presets for SELECT, UPDATE, DELETE and INSERT statements
  • MySQL passwords are Vernam-cipher encrypted before being sent to the server (better than nothing, right?)
  • MySQL password field is masked unless hovered
  • Shows query execution times
  • Menu can be minimized and opened in the same state later on
  • CREATE TABLE statement retrieval
  • Icon differentiation for empty tables and populated tables
  • Table row deletion
  • Table row updating
  • Table deletion
  • Table emptying
  • Internally uses prepared statements and appropriate escaping to prevent SQL injection
  • Discards net messages sent by non-super-admins to prevent exploitation
  • Discards net messages sent by players who do not have the SQLWorkbench menu open to prevent exploitation
  • Menu elements can be dragged and sized to your liking
  • Primary key columns are highlighted in yellow
  • Uses the Ace embedded code editor[ace.c9.io], and works offline without a need for JavaScript CDNs

───────────────────────────────────────────────────────────────

🤖 GitHub 🤖
https://github.com/WilliamVenner/SQLWorkbench
热门讨论 查看全部(1)
2
2021 年 5 月 20 日 下午 11:48
置顶: Bug Reporting
Methylenedioxymethamphetamine
15 条留言
Lameøn_ 2023 年 12 月 1 日 上午 10:53 
[SQLWorkbench] [ERROR] Error: Lost connection to server at 'handshake: reading initial communication packet', system error: 0 somebody help pls
sSxqGd 2022 年 7 月 23 日 下午 2:32 
Thank you!
-JakerZ 2021 年 1 月 3 日 上午 11:06 
Nice handy Tool!
DarkLore 2020 年 12 月 29 日 下午 4:18 
DarkLore 2020 年 12 月 29 日 下午 4:18 
MySQLOO module[ github.com ] installed. where u put the files like u need to find where to pick it
Potions 2020 年 9 月 28 日 上午 5:44 
How do i make the window bigger?
InsanePyro 2020 年 9 月 2 日 上午 7:52 
thank you so much that way i can experiment and edit so easy
rtkz_wasa19741 2020 年 6 月 21 日 上午 1:28 
Data --> MYSQL?
A1steaksa 2020 年 3 月 8 日 上午 8:30 
I am just so very thankful that you've gone through the effort here so I don't have to
Momofier 2019 年 4 月 22 日 下午 1:40 
Yo this is going to do mucho in lowering the filesize of the DB file it's soo bloated from old projects and users that will not come back