SourcePlugins

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

SouceUtils:

This is my 1º plugin (c++), is small for now but i have some plans for the future.
SourceUtils work in all Source games win32/linux.
This is ONLY Utils.

############################################################################
########################Source Utils Commands###############################
############################################################################

su_Mysql

su_MySQL <ServerIP> <Port | 3306 = Default Port> <UserName> <Password | "" = No Password> <"DataBase | "" = No db Command"> <"Cmd"> [Var]

eg. su_mysql localhost 3306 root mypass "" "SELECT CURTIME()" time

NOTE: 'Var' is only for store a stat from one db using "SELECT" String

su_MySQLCreate

su_MySQLCreate <Connection Name> <Access Password> <ServerIP> <Port | 3306 = Default Port> <UserName> <Password | "" = No Password>

eg. su_mysqlcreate myconn myconnpass localhost 3306 root ""

NOTE: <Access Password> Is used for Edit|Delete|Use|Debug Yours Fast Connections

su_MySQLDelete

su_MySQLDelete <Connection Name> <Access Password>

eg. su_mysqldelete myconn myconnpass = Will Delete Your Connection
eg. su_mysqldelete myconn myfalseconnpass = "SU: Incorrect Access Password 'myfalseconnpass' For Connection 'myconn'!."
eg. su_mysqldelete myfalseconn myfalseconnpass = "SU: Connection 'myfalseconn' No Exists!. Use 'su_MySQLCreate"

su_MySQLEdit

su_MySQLEdit <Connection Name> <Actual Access Password> <New Access Password> <ServerIP> <Port | 3306 = Default Port> <UserName> <Password | "" = No Password>
Use 'NULL' To Stay The Old Param

eg. su_mysqledit myconn myconnpass mynewconnpass NULL NULL NULL NULL
eg. su_mysqledit myconn myconnpass NULL NULL NULL newuser userpass

su_MySQLInfo

su_MySQLInfo <Connection Name> <Access Password> [Var]

eg. su_mysqlinfo myconn myconnpass
eg. su_mysqlinfo myconn myconnpass su_temp_get

Mattie · Posted: Tue Jan 23, 2007 5:25 pm Post subject:

Congrats, sn4k3!

Is the MySql access multi-threaded? So it doesn't stop the server while it waits for the SQL response?

Or should people only use it during times when they can afford to wait for a response?

Congrats on your plugin,
-Mattie

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

Mattie · Posted: Wed Jan 24, 2007 1:19 pm Post subject:

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

New Version of SU!

v1.1 [13/3/07]

- add 'su_temp_get' cvar to get things also they can use others cvars
- add 'su_currentmap' cvar to see current map
- add 'su_os' cvar to see Operating System (Windows | Linux)
- add 'su_maxplayers' cvar to see maxplayers/slots
- add 'su_gamemod' cvar to see Current Running DLL Game Mod
- add 'su_lastcompile' cvar to see last compile date of Source Utils

- add GetExists
- add AddDownload
- add Precache Model/Sound
- add Rand (Rand Numbers)
- add Version Check
- add Changelevel
- add CvarForceset
- add Force EndRound
- add GetTime
- add Replace (allow repace text)

- add Suport For MetaMod Source

- fixed 'su_version' cvar cant be Msg/Get Say Protected

bl1nk · New User Joined: 22 Oct 2005 Posts: 2

I cant seem to get this mod to work with a windows server. Any ideas? Its not even loading.

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

New Version!!

v1.2 [5/4/07]

- add MySQL compatible binnary querys!
- add MySQL Multi-Theard ( Now dont stop the server )
- add MySQL Suport "LOAD DATA INFILE"
- add MySQL Suport Multi Statments Separated by A ";"
- add MySQL Suport Multi Results
- add MySQL Fast Connections
- add MySQL Fast Create|Delete|Edit|Info Connections
- fixed Not need SQL.dll for work!

Mattie · Posted: Sun Apr 08, 2007 8:03 pm Post subject:

Wow, very cool update, Snake. I'll have to look at this some.

-Mattie

[NATO]Hunter · Posted: Sat Apr 14, 2007 5:23 pm Post subject:

Great work again, sn4k3, I am starting to like you Wink

Ethryx · New User Joined: 14 Apr 2007 Posts: 2

I have a quick question about the latest release. I'm going to show my example along with EventScripts. Since this release introduces multi-threading, how would something like this work:

es_xsetinfo sqlresult 0
es su_mysql <host> <port> <usr> <pass> <db> "SELECT * FROM exampletable WHERE userid = 1" sqlresult
es es_xmsg result is: server_var(sqlresult)

This would normally work fine, and it did before the latest release. But now, the sqlresult variable is not filled with the results instantly (probably because of how sql uses a different thread now). How would I fix this coding to allow me to "wait" for the results to arrive then use the variable after that.

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

Ethryx · New User Joined: 14 Apr 2007 Posts: 2

if I do it right into rcon/server console, it works exactly as it should. This is because there is a pause between running the query and printing the results (the time it takes to put each command in). if I run them in a script though, the time between each command being run by eventscripts is like 0.0000000001, and results aren't stored into the variable yet. So I was wondering if an event could be raised or something when sql results come back. Otherwise, you have to make a loop waiting for the results to come back which totally defeats the purpose of multithreading to stop server lag.

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

you can post here full bug and decription

when i have my pc good again i will repair that

post console Error Msg too

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

new Version!

v1.3 [6/5/07]

- added su_getexists mysqlfastconn
- added su_getexists externalsrc
- added su_getexists cmdtarget
- added su_getexists mute
- added su_getexists profile
- added su_externalsrc (like system command)
- added su_profile (get a precision profile)
- added su_compile (allow compile (ONLY) linux makefiles)
- added su_log (can print mensages to current log file)
- added su_precache now suport get file index
- added su_load (allow load source utils extras)
- added su_unload (allow unload loaded scripts)
- added su_load_print (allow print loaded scripts)
- added su_sconsole get/set (allow get/set parms in server console cmd target)
- added su_sound (sound utils like get duration)
- added su_sqlite (allow make sqlite3 querys) (UNTESTED)
- added a Plugin load mensage (successfull load)

- added Source Utils Events! (addons/source_utils/source_utils.res)
- added event su_mysql
- added auto load for EventScripts Source Utils Events

- added 'su_tickrate' cvar to see server tickrate
- added 'su_externalsrc_folder' cvar to see ExternalSrc folder source utils is using
- added 'su_avaliable_parms' cvar know what parms can use in begin 'su_sconsole set create' (# ! $ | » >)
- added 'su_servergamedll' cvar to see what GameServerDll Source Utils is using
- added cvars callback (disallow source utils cvars change)

- added update metamod source library to v1.4

- fixed su_getexists userid can crash server if no player in server
- fixed MySQL Fast Connections dont use selected db

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

New Version

v1.4 [14/5/07]

- added 'su_mysql_userid' to su_mysql event
- added 'addons/source_utils/source_utils_security.cfg' file
- added ExternalSRC security (root access, deny programs, master password)
- added 'su_load' <[MasterPass]> Parm
- changed su_mysql* <[Var]> = gets su_mysql_userid
- fixed linux binnary dont work

3jorn · New User Joined: 14 Nov 2005 Posts: 23

any plans to reveal some sourcecode? Wink

sn4k3 · Regular Joined: 10 Sep 2005 Posts: 178 Location: Portugal

HnyBear · New User Joined: 11 Jan 2006 Posts: 8 Location: Miami, Fl

I can't seem to get the standalone version to load on a Windows server. Yes it is a css server. I have it setup just like all other addons but yet when I try to do su_version via rcon it gives me know info.

Only thing I noticed is when I try to load it, it kill mani's quake sounds for some reason. Like I said it doesn't load none of the commands work but it messes with mani mod. ???