Ulysses
Ulysses Stuff => Releases => Topic started by: MKServers on August 14, 2012, 06:54:26 PM
-
UPDATED FOR GMOD 13
That's right, I went through and fixed it up. It also now updates its data when you change a user's access. This should help with possible issues with connections.
It will save names with the data, so do with it what you please. To configure it, open mysql.lua and edit the top variables. Make sure ULX_HOST uses an external ip(I haven't been able to work with localhost). Also, if you already have a table called ulx in the same database, change the name so it can create the table. Other then that, happy servering!
One small big difference is also any users defined prior installation of this will be moved to users as to avoid exploits.
If you can't find the download link, you are not logged in.
To install MySQLOO, go here: http://facepunch.com/showthread.php?t=1220537 (http://facepunch.com/showthread.php?t=1220537)
-
hey thanks for this, it's something I've wanted to put on my servers for quite a while
well I set it up properly, created a new db in mysql and put db/user/pass settings in the lua file but when someone joins I get this:
ERROR: Hook 'PlaceUserToTheirGroup' Failed: [addons\ulx\lua\ulx\modules\sh\mysql.lua:76] attempt to index local 'queryQ' (a nil value)
Removing Hook 'PlaceUserToTheirGroup'
well i checked your script a bit, and it should create the tables needed, but the db is empty, it didn't create anything, am I missing something?
ps. MySQLOO is in my addons and working properly because I'm already using sourcebans with it.
-
Nevermind about that, I figured out the problem. For some reason it didn't want to connect to the DB using "localhost" so I used directly the IP address of the server, however your script doesn't create the table "ulxmysql" in the database, I had to manually create it.
Other than that I works as expected :) thanks again
-
*SNIP*
-
*SNIP*
-
[ERROR] addons/ulx/lua/ulx/modules/sh/mysql.lua:9: Couldn't load module library!
1. require - [C]:-1
2. unknown - addons/ulx/lua/ulx/modules/sh/mysql.lua:9
3. include - [C]:-1
4. unknown - addons/ulx/lua/ulx/init.lua:33
5. include - [C]:-1
6. unknown - addons/ulx/lua/ulib/modules/ulx_init.lua:2
7. include - [C]:-1
8. unknown - addons/ulib/lua/ulib/init.lua:75
9. include - [C]:-1
10. unknown - addons/ulib/lua/autorun/ulib_init.lua:3
-
might be that it cant find the library ?
-
[ERROR] addons/ulx/lua/ulx/modules/sh/mysql.lua:9: Couldn't load module library!
1. require - [C]:-1
2. unknown - addons/ulx/lua/ulx/modules/sh/mysql.lua:9
3. include - [C]:-1
4. unknown - addons/ulx/lua/ulx/init.lua:33
5. include - [C]:-1
6. unknown - addons/ulx/lua/ulib/modules/ulx_init.lua:2
7. include - [C]:-1
8. unknown - addons/ulib/lua/ulib/init.lua:75
9. include - [C]:-1
10. unknown - addons/ulib/lua/autorun/ulib_init.lua:3
Did you actually install the MySQLOO module and make sure that it worked?
From your server console, type the following:
lua_run require("mysqloo")
If you get nothing then it is installed correctly. If it throws a bunch of errors, then it's not and you need to install the module correctly.
-
Usually "couldn't load module library" means the module itself is loading but libmysql was not installed correctly
-
[ERROR] lua_run:1: Couldn't load module library!
1. require - [C]:-1
2. unknown - lua_run:1
:/ Even though it is installed
-
What path is your mysqlloo.dll file?
-
Why are there two attachments of the same name on the first post? Is one newer than the other?
-
My mysqloo is in garrysmod/lua/bin.
Attempting to use other file.
-
Do you also have libmySQL.dll in your <accountname>/garrysmod folder?
The same folder that has hl2.exe
There are 2 files that HAVE to be in the right area in order for MySQLOO to work.
-
the ! in that statement represents not.
Garry added in some non-standard lua operators. !(ply:IsUserGroup("user")) is the same as writing not ply:IsUserGroup("user")
-
Whoever wrote this script probably didn't put in any redundancy checks for connection checking.
My script has throwback errors if it detects that it lost connection and then it retries the connection, after failing 3 times in a row it reports the failures and then authenticates all users as guests to stop any other errors.
Anything could be causing connection issues. Does your SQL server reside on the same physical server as your gmod server? If not, it could be a timeout issue.
-
You will find that maintaining a connection (which is persistent for MySQLOO) is nearly impossible for cross-server databases.
Are you ever able to get a connection? Does it just lose it after time? If you never get a solid connection, it might be that your web server has disabled access to mySQL from off-site. I know a web host I used to use didn't allow external connections to the databases.
-
I've been trying to get this to work for the past three days now. Sadly, I'm out of luck...
For your information I have placed libmySQL.dll in the same directory as hl2.exe.
Also, gmsv_mysqloo_win32.dll is in garrysmod/garrysmod/lua/bin/.
From the console I used lua_run require("mysqloo"). After that command I receive zero errors.
The only issue I have is actually getting this script to run.
Here's its error:
Couldn't include file 'includes\modules\mysqloo.lua' (File not found) (@addons/ulx/lua/ulx/modules/sh/mysql.lua (line 9))
[ERROR] addons/ulx/lua/ulx/modules/sh/mysql.lua:9: Module not found!
1. require - [C]:-1
2. unknown - addons/ulx/lua/ulx/modules/sh/mysql.lua:9
3. include - [C]:-1
4. unknown - addons/ulx/lua/ulx/cl_init.lua:17
5. include - [C]:-1
6. unknown - addons/ulx/lua/ulib/modules/ulx_init.lua:4
7. include - [C]:-1
8. unknown - addons/ulib/lua/ulib/cl_init.lua:23
9. include - [C]:-1
10. unknown - addons/ulib/lua/autorun/ulib_init.lua:5
-
I'm getting the exact same error message, and I know that libmySQL.dll and mySQLOO.lua are installed correctly as I need them for other cross-server content I have on my servers.
-
Yep, I also get that one.
-
Anyone know how to fix this issue yet?
-
Well, for one, mysqloo is not a lua file it is the dll that goes in lua/bin/. And when you say you did lua_run require('mysqloo') you did it on rcon or the server console directly, right? Running that in your client' console will not output anything. It doesn't make sense that it would not throw an error from console but say the module is missing when the addon tries to require it.
edit: now that I look at it, it's set up as a shared module when it should be server... so if you rename the "sh" folder to "sv" inside the addon it should work. I think the errors are just because it's trying to load mysqloo clientside.
-
Well, for one, mysqloo is not a lua file it is the dll that goes in lua/bin/. And when you say you did lua_run require('mysqloo') you did it on rcon or the server console directly, right? Running that in your client' console will not output anything. It doesn't make sense that it would not throw an error from console but say the module is missing when the addon tries to require it.
edit: now that I look at it, it's set up as a shared module when it should be server... so if you rename the "sh" folder to "sv" inside the addon it should work. I think the errors are just because it's trying to load mysqloo clientside.
Changing the folder to sv does not make a difference.
When I run require('mysqloo') I get the error
Couldn't include file 'includes\modules\ mysqloo .lua' (File not found) (@lua_run (line 1)) which is the same error I receive upon starting the server. (I forgot to mention that previously.)
I mentioned in a previous post that I had libMySQL.dll and mySQLOO.lua installed correctly as I use them for other cross-server content. What I meant to say was mySQLOO.dll, instead of .lua. So both files are installed in the correct place, libMySQL.dll in the same directory as srcds.exe and MySQLOO.dll (actually called gmsv_mysqloo_win32.dll) inside lua/bin.
-
Try this
rcon lua_run require( [[mysqloo]] )rcon tends to mangle up console input when it comes to quotes as you can see it added spaces. If that doesn't throw an error on the server then I have no idea why it's happening, I can look into it more if needed since I don't actually have this addon installed, but I don't see anything else in the code that would cause this to happen...
-
I'm not sure if you're misunderstanding me or not, but I'm not calling mysqloo through RCON, it is the first line of the script. (require('mysqloo')).
It doesn't really matter anyway, I don't need the script right now, I just wanted to prepare for server expansion. If and when I need it, I'll hopefully work it out myself. Thanks for the help thus far :D
-
I was talking about the error you got
When I run require('mysqloo') I get the error
Couldn't include file 'includes\modules\ mysqloo .lua' (File not found) (@lua_run (line 1))
since it has a space before and after 'mysqloo' (which is obviously not going to exist on disk) I figured it was because you were running that through rcon.
-
I think this has been approached wrong.
In my opinion, It would be much better if this didn't read the ranks from the external database, but rather synced the local data file with the remote database whenever a player's rank changes, or a player connects. This way, any connection problems can be overlooked quite easily, and cause minimal disruptions for the server in the event of a failed connection, as the remote database would simply become a backup, only with the added feature of being able to display a players rank in a loadingurl.
How one would go about doing this, is beyond me. I have ideas, I just can't make them.
Your welcome to whomever feels inspired by that.
-
I get an error in console occasionally when some people join:
addons/ulx mysql/lua/ulx/modules/sh/mysql.lua:54: attempt to call field 'adduserids' (a nil value)
I've tried changing it to "adduserid" instead but that just results in something along the lines of "bad argument" if I recall.
Could anyone tell me what's going on here?
EDIT: Here is the function around that line:
function LoadRank(ply)
local queryQ = ULXDB:query("SELECT * FROM `ulxmysql` WHERE steam = '" .. ply:SteamID() .. "'")
queryQ.onData = function(Q,D)
queryQ.onSuccess = function(q)
if checkQuery(q) then
print("You are already created!")
ulx.adduserids(nil,ply:SteamID(),D.groups)
end
end
end
queryQ.onError = function(Q,E) print("Q1") print(E) end
queryQ:start()
end
-
Sorry for the bump, could anyone shed some light on this issue possibly?
Thanks
-
I managed to get it mostly working but I still have one problem.
I got rid of all the errors by wrapping the code in an "if SERVER then" if statement. But I still had issues with the script adding the user to the correct usergroup when they joined (saving the groups works fine, but if the player joins the server with a usergroup that doesn't match the database, their usergroup would not change). I fixed this by changing:
"ulx.adduserids(nil,ply:SteamID(),D.groups)"
to
"ulx.adduserid(nil,ply:SteamID(),D.groups)"
Now the script works as I want it to but there is one issue.
My ulx menu seems to fail to load a lot of data. There are no maps in the maps list. There are no adverts in the adverts list (although adverts still display in chat). In the sandbox subtab of the settings tab, no sliders are appearing. In the group manager menu, group members are not appearing, and permissions are not appearing.
I've done some testing over the past few hours and the problems stated above seem to be from the fact I changed "ulx.adduserids(nil,ply:SteamID(),D.groups)" to "ulx.adduserid(nil,ply:SteamID(),D.groups)". If I change it back, all the information is displayed correctly, however the script doesn't change users usergroups.
Any help is appreciated.
Thanks
-
How do we install MySQLOO... I have the plugin installed here, but I can't find the MySQLOO that is required!
-
How do we install MySQLOO... I have the plugin installed here, but I can't find the MySQLOO that is required!
http://facepunch.com/showthread.php?t=1220537
-
I managed to get it mostly working but I still have one problem.
I got rid of all the errors by wrapping the code in an "if SERVER then" if statement. But I still had issues with the script adding the user to the correct usergroup when they joined (saving the groups works fine, but if the player joins the server with a usergroup that doesn't match the database, their usergroup would not change). I fixed this by changing:
"ulx.adduserids(nil,ply:SteamID(),D.groups)"
to
"ulx.adduserid(nil,ply:SteamID(),D.groups)"
Now the script works as I want it to but there is one issue.
My ulx menu seems to fail to load a lot of data. There are no maps in the maps list. There are no adverts in the adverts list (although adverts still display in chat). In the sandbox subtab of the settings tab, no sliders are appearing. In the group manager menu, group members are not appearing, and permissions are not appearing.
I've done some testing over the past few hours and the problems stated above seem to be from the fact I changed "ulx.adduserids(nil,ply:SteamID(),D.groups)" to "ulx.adduserid(nil,ply:SteamID(),D.groups)". If I change it back, all the information is displayed correctly, however the script doesn't change users usergroups.
Any help is appreciated.
Thanks
This is the exact same conclusion I've come to see as well. It would be nice if we can get one of the lua pro's on here to run through and update this script. Or maybe just shed some light on the issue at hand.
-
This is the exact same conclusion I've come to see as well. It would be nice if we can get one of the lua pro's on here to run through and update this script. Or maybe just shed some light on the issue at hand.
lua pro's on here to run through and update this script...
If only that would happen... I so desperately want need this for my PHP Forum Signature thing im making (which loves grayscaling )
-
Sorry all, I have been really busy recently but finally I am at a point where I can take a hour or so and update the code for GMod 13 correctly with create table abilities. Will edit this post as soon as I finish it. Will also be testing everything to make sure everything works because I shouldn't be screwing anyone over.
EDIT:
Also, I was really stupid and made a custom function outside of this file called ulx.adduserids(). I am making a new custom function WITHIN THIS FILE so it will avoid displaying chat and still update. I am still reading through other peoples errors and fixing them as I fix this script up.
I think this has been approached wrong.
In my opinion, It would be much better if this didn't read the ranks from the external database, but rather synced the local data file with the remote database whenever a player's rank changes, or a player connects. This way, any connection problems can be overlooked quite easily, and cause minimal disruptions for the server in the event of a failed connection, as the remote database would simply become a backup, only with the added feature of being able to display a players rank in a loadingurl.
How one would go about doing this, is beyond me. I have ideas, I just can't make them.
Your welcome to whomever feels inspired by that.
There is an issue this. Simply the fact that this is used to sync across servers. If I read off a local file, on another server the database would get a new rank and that user wouldn't get the correct rank.
HOWERVER I need to hook into when a player is given a new rank to update whenever ranks change. This would work as a much more effective way of handling the rankings.
Found the hooks that I needed and should be able to use them correctly to go about this better.
UPDATE
Most of the script is done. Once I figure out how I want to handle putting this on a server with already defined users, I will put up the new script.
Okay, I have decided that it will not accept users that were added before the MySQL was implemented. Sorry, but this is to avoid exploits that could be possible with other ways i thought of. I will upload the new GMod 13 version which I have tested. It will create a table and insert data as needed. It will also save the name in case you need it(loading screens or something?) If anyone has a better idea for avoiding exploits and loading predefined users, please shoot me a message. Other then that, happy servering.
To install MySQLOO, go here: http://facepunch.com/showthread.php?t=1220537 (http://facepunch.com/showthread.php?t=1220537)
-
The one issue I see with this is that, I can not edit the permission on the groups anymore.
-
Yeah, I am still missing a lot of information from my ulx menu.
-
Yeah, I am still missing a lot of information from my ulx menu.
Yikes, I don't really want to update this until that gets resolved. Any update to this MK?
Also, if I set the table to the old table made by this addon, will that cause any issues? Or should I let it create a brand new table and then migrate the data. Old table was called ulxmysql.
-
That is kinda awkward, my server has the exact same script and works fine, no edits form the upload except the database info. Any other things you might be able to tell me to help correct this error?
-
That is kinda awkward, my server has the exact same script and works fine, no edits form the upload except the database info. Any other things you might be able to tell me to help correct this error?
I'll give it a shot and report back in.
-
Okay, getting some issues overlooked before(still not sure about the group issues said above), working on updates now.
-
Okay, getting some issues overlooked before(still not sure about the group issues said above), working on updates now.
So, with your newest script, I get this error.
http://cl.ly/REQd
And it lists me as a "Newcomer" in the server instead of superadmin. Newcomer is my default rank.
EDIT: Also got this when playing around with my rank. http://cl.ly/RF6k
-
Hey Mk,
Sorry to bump this.. did you need any help with the testing of your updates? I'd be more than happy to help..
Add me on steam if you don't mind, http://steamcommunity.com/id/organik_
Thanks
-
I've installed this onto my server and it creates the table in my database. But, for some reason, it doesn't add any users into the table. I'm getting no errors either. Any ideas?
-
Just wanted to throw this out there, your file structure for the addon is "ulx_mysql/lua/ulx/modules/sh" which means its loading as a shared module. Downside of this is its sending the information to the client when they join the server. You may want to change the structure so ulx loads the addon in a different manor.
-
Have you done any further work on this MK? I would very much appreciate a version that I know will work 100% and preferably add old users to the database as well as new ones.
Thanks.
-
I would love to try this too but would like assurances from the community that it works as intended.
My 11 servers have collectively around 900 users if you include my 'Regular' and 'RegularPlus' ranks. I am happy to manually add them in using phpMyAdmin for the smallest server first to check it works but don't want to do ALL of them if it doesn't :P
-
Yeah... seems to be broke still. I'll see what I can do to see if I can fix it. He appears to not have time of care anymore. So let's see what we can do.
(http://i.imgur.com/Uz8TvHI.jpg)
-
Yeah... seems to be broke still. I'll see what I can do to see if I can fix it. He appears to not have time of care anymore. So let's see what we can do.
img
That would be great. I really need this for my second server.
-
Yeah... seems to be broke still. I'll see what I can do to see if I can fix it. He appears to not have time of care anymore. So let's see what we can do.
Sorry for bumping, but do you have any updates on this so far? I would love to use this on my server but I don't have any knowledge to fix this.
-
i have a error :/
(http://i.imgur.com/HteWIel.jpg)
-
Did you install the MySQLOO Module? It seems you're missing something.
-
Did you install the MySQLOO Module? It seems you're missing something.
Then lower the dll and place as stated in the post ....
Although I have many dll tmysql mysql and I mention ....
That affects?
=========
For another mysql down (for some reason there is more than one with the same name ..)
and this error is only ...
(http://i.imgur.com/y46ApnZ.png)
-
You're missing something.
Some script is trying to call functions that simply don't exist.
They could be missing, or the script that contains those functions may not have loaded due to an error somewhere in the script.
-
It's an error in the script, as far as I know. I have MySQLOO installed correctly as I use it for other functions, yet this script tells me it is missing.
I would be eternally grateful if you could fix this, or even better, post your own version! Feeling generous? ;)
-
Mine is posted as replies in a few threads. Look around. :)
-
The only thing I can find is you mentioning you have code and an attachment from 2008 xD
-
Here
I'm not going to bother explaining it. I hope you can make heads or tails of it. This is tailored for my server. You could modify it easily enough for yours.
It only handles user groups and bans.
I added the required functions to make this just work. Add it to an autorun file in your lua/autorun/server folder. Go in and change the console commands and messages to your liking, as well as the settings at the top.
There are some things in there that will need to be removed as they are gamemode specific for my Stranded server. Also SGS_SendMessage is just a fancy way of doing print(). You'll need to remove those or modify them too as that function isn't included in this script.
require("mysqloo")
G4PSQL = {}
local DATABASE_HOST = "127.0.0.1"
local DATABASE_PORT = 3306
local DATABASE_NAME = "g4padmin"
local DATABASE_USERNAME = "root"
local DATABASE_PASSWORD = ""
local DATABSE_TABLE = "userauth"
function G4PSQL_Init()
G4PSQL_ConnectToDatabase()
timer.Simple(60, G4PSQL_Init )
end
hook.Add( "Initialize", "G4PSQL_Init", G4PSQL_Init )
function G4PSQL_Format( str )
if not str then return "NULL" end
return string.format( "%q", str )
end
function Escape( str )
if not G4PSQL.db then
Msg( "Not connected to DB.\n" )
return
end
if not str then return end
local esc = G4PSQL.db:escape( str )
if not esc then
return nil
end
return esc
end
function G4PSQL_ConnectToDatabase()
G4PSQL.db = mysqloo.connect( "127.0.0.1", "root", "", "g4padmin", 3306 )
G4PSQL.db:connect()
end
function G4PSQL_PlayerAuthDB( ply )
if G4PSQL.db == nil then
G4PSQL_ConnectToDatabase()
end
if G4PSQL.db:status() == 0 then
local sid = ply:SteamID()
print("Checking for: " .. Escape( sid ) )
local q1 = G4PSQL.db:query("SELECT * FROM " ..DATABSE_TABLE.. " WHERE steamid = "..G4PSQL_Format( Escape( sid ) ).."")
function q1:onSuccess( data )
if data[1] then
--PrintTable(data)
ply.steamid = data[1]["steamid"]
ply.name = data[1]["pname"]
ply.group = data[1]["pgroup"]
ply.banned = data[1]["banned"]
ply.lastplayed = data[1]["lastplayed"]
--ServerLog("/////PLAYER DATA FOUND/////" .. "\n")
--ServerLog("Name: " .. ply.name .. "\n")
--ServerLog("SteamID: " .. ply.steamid .. "\n")
--ServerLog("Group: " .. ply.group .. "\n")
--ServerLog("Last Played: " .. ply.lastplayed .. "\n")
--ServerLog("Banned?: " .. ply.banned .. "\n")
--ServerLog("///////////////////////////" .. "\n")
if ply.name != ply:Nick() then
--ServerLog( "Updating name for player: " ..ply:Nick() .. "\n" )
local q2 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET pname="..G4PSQL_Format( Escape( ply:Nick() ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid ) ) )
function q2:onSuccess( data2 )
--ServerLog( "Name updated sucessfully!\n" )
end
function q2:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q2:start()
end
--ServerLog( "AUTHING PLAYER: " ..ply:Nick().. " in group (" ..ply.group..")." .. "\n" )
ULib.ucl.addUser( ply:SteamID(), _, _, ply.group )
local q4 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET lastplayed="..G4PSQL_Format( Escape( tostring(os.date("%y/%m/%d")) ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid ) ) )
function q4:onSuccess( data4 )
--ServerLog( "User Data (lastplayed) updated sucessfully!\n" )
end
function q4:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q4:start()
if string.upper(ply.banned) == "TRUE" then
ULib.kick( ply, "BANNED! Visit our website at [url=http://www.g4p.org]www.g4p.org[/url] to dispute this ban." )
end
ULib.tsay(ply, "Welcome back " ..ply:Nick().. ", you have been authenticated as: " ..ply.group..".", true)
ply:Spawn()
else
--print("No Entry Found")
--ServerLog("No Results Found ... Creating Entry\n")
local q3 = G4PSQL.db:query( "INSERT INTO " ..DATABSE_TABLE.. " ( steamid, pname, pgroup, lastplayed, banned ) VALUES( " ..G4PSQL_Format( Escape( sid ) ) .. ", " ..G4PSQL_Format( Escape( ply:Nick() ) ) .. ", " ..G4PSQL_Format( Escape( "user" ) ) .. ", " ..G4PSQL_Format( Escape( tostring(os.date("%y/%m/%d")) ) ) .. ", " ..G4PSQL_Format( Escape( "FALSE" ) ).. " )" )
function q3:onSuccess( data3 )
--ServerLog( "Entry added sucessfully!\n" )
end
function q3:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q3:start()
ply:Spawn()
end
end
q1:start()
else
G4PSQL_RetryAuth( ply )
return
end
end
hook.Add( "PlayerAuthed", "G4PSQL_PlayerAuthDB", G4PSQL_PlayerAuthDB )
function G4PSQL_RetryAuth( ply )
if not ply.retries then ply.retries = 3 end
if ply.retries > 0 then
ply.retries = ply.retries - 1
--ServerLog("DATABASE NOT CONNECTED - RETRYING (" .. tostring(ply.retries) .. " retries left)" .. "\n")
G4PSQL_ConnectToDatabase()
timer.Simple(2, function() G4PSQL_PlayerAuthDB( ply ) end)
else
ServerLog( "FALLBACK AUTHENTICATION... DATABASE CAN NOT BE CONNECTED TO\n" )
--ServerLog( "AUTHING PLAYER: " ..ply:Nick().. " in group (user)." .. "\n" )
ULib.ucl.addUser( ply:SteamID(), _, _, "user" )
ply:Spawn()
end
end
function G4PSQL_ChangeGroup( ply, cmd, args )
local sid = args[1]
local group = tostring(string.lower(args[2]))
local mut = nil
if #args == 3 then
mut = tostring(string.lower(args[3]))
end
if !IsValid( ply ) or ply:IsUserGroup("superadmin") then
if #args < 2 or #args > 3 then
SGS_SendMessage(ply, "Wrong number of arguements!")
return
end
if (string.sub(sid, 1, 5) == "STEAM") then
sid = sid
qtype = 1
else
if IsValid(ULib.getUser(sid)) then
sid = ULib.getUser(sid)
qtype = 2
if not sid then
SGS_SendMessage(ply, "User not found!")
return
end
else
SGS_SendMessage(ply, "User not found!")
return
end
end
local gcheck = false
for k, v in pairs(ULib.ucl.groups) do
if group == k then
SGS_SendMessage(ply, "Checking " ..group.. " against " .. k)
gcheck = true
break
end
end
if gcheck == false then
SGS_SendMessage(ply, "Group doesn't exist!")
return
end
if G4PSQL.db:status() == 0 then
if qtype == 1 then
local q1 = G4PSQL.db:query("SELECT * FROM " ..DATABSE_TABLE.. " WHERE steamid = "..G4PSQL_Format( Escape( sid ) ).."")
function q1:onSuccess( data )
if data[1] then
SGS_SendMessage(ply, "Updating group for steamID: (" ..sid .. ")")
local q2 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET pgroup="..G4PSQL_Format( Escape( group ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid ) ) )
function q2:onSuccess( data2 )
SGS_SendMessage(ply, "Player (" .. sid .. ") Group Changed!")
end
function q2:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q2:start()
else
SGS_SendMessage(ply, "No Entry Found")
SGS_SendMessage(ply, "No Results Found ... Creating Entry")
local q3 = G4PSQL.db:query( "INSERT INTO " ..DATABSE_TABLE.. " ( steamid, pname, pgroup, lastplayed, banned ) VALUES( " ..G4PSQL_Format( Escape( sid ) ) .. ", " ..G4PSQL_Format( Escape( "ADMIN ENTERED" ) ) .. ", " .. G4PSQL_Format( Escape( group ) ) .. ", " ..G4PSQL_Format( Escape( tostring("NEVER") ) ) .. ", " ..G4PSQL_Format( Escape( "FALSE" ) ).. " )" )
function q3:onSuccess( data3 )
SGS_SendMessage(ply, "Entry added sucessfully!")
end
function q3:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q3:start()
end
if mut and mut == "yes" then
local muttime = SGS_DateStep()
local q4 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET mutexpire="..G4PSQL_Format( Escape( muttime ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid ) ) )
function q4:onSuccess( data2 )
SGS_SendMessage(ply, "Player (" .. sid .. ") MUT Expiration Data Added!")
end
function q4:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q4:start()
end
end
q1:start()
else
local q1 = G4PSQL.db:query("SELECT * FROM " ..DATABSE_TABLE.. " WHERE steamid = "..G4PSQL_Format( Escape( sid:SteamID() ) ).."")
function q1:onSuccess( data )
if data[1] then
SGS_SendMessage(ply, "Updating group for player: " ..sid:Nick())
local q2 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET pgroup="..G4PSQL_Format( Escape( group ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid:SteamID() ) ) )
function q2:onSuccess( data2 )
SGS_SendMessage(ply, "Player Group Changed!")
ULib.ucl.addUser( sid:SteamID(), _, _, group )
end
function q2:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q2:start()
else
SGS_SendMessage(ply, "No Entry Found")
SGS_SendMessage(ply, "No Results Found ... Creating Entry")
local q3 = G4PSQL.db:query( "INSERT INTO " ..DATABSE_TABLE.. " ( steamid, pname, pgroup, lastplayed, banned ) VALUES( " ..G4PSQL_Format( Escape( sid:SteamID() ) ) .. ", " ..G4PSQL_Format( Escape( "ADMIN ENTERED" ) ) .. ", " .. G4PSQL_Format( Escape( group ) ) .. ", " ..G4PSQL_Format( Escape( tostring("NEVER") ) ) .. ", " ..G4PSQL_Format( Escape( "FALSE" ) ).. " )" )
function q3:onSuccess( data3 )
SGS_SendMessage(ply, "Entry added sucessfully!")
end
function q3:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q3:start()
end
end
q1:start()
end
else
SGS_SendMessage(ply, "DATABASE NOT CONNECTED PLEASE TRY AGAIN!")
G4PSQL_ConnectToDatabase()
end
else
SGS_SendMessage(ply, "This command is reserved for administrators only!")
end
end
concommand.Add( "g4p_setgroup", G4PSQL_ChangeGroup)
function G4PSQL_Ban( ply, cmd, args )
local sid = args[1]
local reason = args[2]
local badmin = "NONE"
local baid = "NONE"
if !IsValid( ply ) or ply:IsAdmin() then
if IsValid(ply) then
badmin = ply:Nick()
bacolor = team.GetColor(ply:Team())
baid = ply:SteamID()
else
badmin = "(Console)"
bacolor = Color(80,80,80,255)
baid = "(Console)"
end
if #args != 2 then
SGS_SendMessage(ply, "Wrong number of arguements! Be sure to include the name/steamID and a reason. Also be sure the reason is in QUOTES.")
return
end
if (string.sub(sid, 1, 5) == "STEAM") then
sid = sid
qtype = 1
else
if IsValid(ULib.getUser(sid)) then
sid = ULib.getUser(sid)
qtype = 2
if not sid then
SGS_SendMessage(ply, "User not found!")
return
end
else
SGS_SendMessage(ply, "User not found!")
return
end
end
if G4PSQL.db:status() == 0 then
if qtype == 2 then
local q1 = G4PSQL.db:query("SELECT * FROM " ..DATABSE_TABLE.. " WHERE steamid = "..G4PSQL_Format( Escape( sid:SteamID() ) ).."")
function q1:onSuccess( data )
if data[1] then
SGS_SendMessage(ply, "Banning player: " ..sid:Nick())
local q2 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET banned=" .. G4PSQL_Format( Escape( "TRUE" ) ) .. ", badmin=" .. G4PSQL_Format( Escape( baid ) ) .. ", breason=" .. G4PSQL_Format( Escape( reason ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid:SteamID() ) ) )
function q2:onSuccess( data2 )
SGS_SendMessage(ply, "Player Banned for " ..reason.."!")
ULib.tsayColor(_, 1, Color(0,0,0,255), "(", Color(255,0,0,255), sid:Nick(), Color(0,0,0,255), ") ", Color(255,255,255,255), "was globally banned by ", bacolor, badmin, Color(255,255,255,255), " for ", Color(0,0,0,255), reason, Color(255,255,255,255), ".")
ULib.kick( sid, "BANNED! Visit our website at [url=http://www.g4p.org]www.g4p.org[/url] to dispute this ban." )
end
function q2:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q2:start()
else
SGS_SendMessage(ply, "No Entry Found")
SGS_SendMessage(ply, "No Results Found ... Creating Entry")
local q3 = G4PSQL.db:query( "INSERT INTO " ..DATABSE_TABLE.. " ( steamid, pname, pgroup, lastplayed, banned, badmin, breason ) VALUES( " ..G4PSQL_Format( Escape( sid:SteamID() ) ) .. ", " ..G4PSQL_Format( Escape( "ADMIN ENTERED" ) ) .. ", " .. G4PSQL_Format( Escape( "user" ) ) .. ", " ..G4PSQL_Format( Escape( tostring("NEVER") ) ) .. ", " ..G4PSQL_Format( Escape( "TRUE" ) ).. ", " ..G4PSQL_Format( Escape( "NONE" ) ).. ", " ..G4PSQL_Format( Escape( reason ) ).." )" )
function q3:onSuccess( data3 )
SGS_SendMessage(ply, "Player Banned for " ..reason.."!")
ULib.tsayColor(_, 1, Color(0,0,0,255), "(", Color(255,0,0,255), sid:Nick(), Color(0,0,0,255), ") ", Color(255,255,255,255), "was globally banned by ", bacolor, badmin, Color(255,255,255,255), " for ", Color(0,0,0,255), reason, Color(255,255,255,255), ".")
ULib.kick( sid:SteamID(), "BANNED! Visit our website at [url=http://www.g4p.org]www.g4p.org[/url] to dispute this ban." )
end
function q3:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q3:start()
end
end
q1:start()
else
local q1 = G4PSQL.db:query("SELECT * FROM " ..DATABSE_TABLE.. " WHERE steamid = "..G4PSQL_Format( Escape( sid ) ).."")
function q1:onSuccess( data )
if data[1] then
SGS_SendMessage(ply, "Banning SteamID: " ..sid)
local q2 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET banned=" .. G4PSQL_Format( Escape( "TRUE" ) ) .. ", badmin=" .. G4PSQL_Format( Escape( baid ) ) .. ", breason=" .. G4PSQL_Format( Escape( reason ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid ) ) )
function q2:onSuccess( data2 )
SGS_SendMessage(ply, "SteamID (" .. sid .. ") Banned for " ..reason.."!")
ULib.tsayColor(_, 1, Color(0,0,0,255), "(", Color(255,0,0,255), sid, Color(0,0,0,255), ") ", Color(255,255,255,255), "was globally banned by ", bacolor, badmin, Color(255,255,255,255), " for ", Color(0,0,0,255), reason, Color(255,255,255,255), ".")
end
function q2:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q2:start()
else
SGS_SendMessage(ply, "No Entry Found")
SGS_SendMessage(ply, "No Results Found ... Creating Entry")
local q3 = G4PSQL.db:query( "INSERT INTO " ..DATABSE_TABLE.. " ( steamid, pname, pgroup, lastplayed, banned, badmin, breason ) VALUES( " ..G4PSQL_Format( Escape( sid ) ) .. ", " ..G4PSQL_Format( Escape( "ADMIN ENTERED" ) ) .. ", " .. G4PSQL_Format( Escape( "user" ) ) .. ", " ..G4PSQL_Format( Escape( tostring("NEVER") ) ) .. ", " ..G4PSQL_Format( Escape( "TRUE" ) ).. ", " ..G4PSQL_Format( Escape( "NONE" ) ).. ", " ..G4PSQL_Format( Escape( reason ) ).. " )" )
function q3:onSuccess( data3 )
SGS_SendMessage(ply, "SteamID (" .. sid .. ") Banned for " ..reason.."!")
ULib.tsayColor(_, 1, Color(0,0,0,255), "(", Color(255,0,0,255), sid, Color(0,0,0,255), ") ", Color(255,255,255,255), "was globally banned by ", bacolor, badmin, Color(255,255,255,255), " for ", Color(0,0,0,255), reason, Color(255,255,255,255), ".")
end
function q3:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q3:start()
end
end
q1:start()
end
else
SGS_SendMessage(ply, "DATABASE NOT CONNECTED PLEASE TRY AGAIN!")
G4PSQL_ConnectToDatabase()
end
else
SGS_SendMessage(ply, "This command is reserved for administrators only!")
end
end
concommand.Add( "g4p_ban", G4PSQL_Ban)
function G4PSQL_UnBan( ply, cmd, args )
local sid = args[1]
banmin = "NONE"
bacolor = Color(255,255,255,255)
if !IsValid( ply ) or ply:IsAdmin() then
if IsValid(ply) then
badmin = ply:Nick()
bacolor = team.GetColor(ply:Team())
else
badmin = "(Console)"
bacolor = Color(80,80,80,255)
end
if #args != 1 then
SGS_SendMessage(ply, "Wrong number of arguements!")
end
if G4PSQL.db:status() == 0 then
local q1 = G4PSQL.db:query("SELECT * FROM " ..DATABSE_TABLE.. " WHERE steamid = "..G4PSQL_Format( Escape( sid ) ).."")
function q1:onSuccess( data )
if data[1] then
if data[1]["banned"] == "TRUE" then
SGS_SendMessage(ply, "UnBanning SteamID: (" ..sid .. ")")
local q2 = G4PSQL.db:query("UPDATE " ..DATABSE_TABLE.. " SET banned="..G4PSQL_Format( Escape( "FALSE" ) ) .. " WHERE steamid=" ..G4PSQL_Format( Escape( sid ) ) )
function q2:onSuccess( data2 )
ULib.tsayColor(_, 1, Color(0,0,0,255), "(", Color(255,0,0,255), sid, Color(0,0,0,255), ") ", Color(255,255,255,255), "was unbanned by ", bacolor, badmin, Color(255,255,255,255), ".")
SGS_SendMessage(ply, "SteamID (" .. sid .. ") Unbanned!")
end
function q2:onError( Q, E )
ServerLog( "ERROR!!! " .. Q .. "\n" )
ServerLog( "ERROR!!! " .. E .. "\n" )
end
q2:start()
else
SGS_SendMessage(ply, "Player Found... but player isn't currently banned...")
end
else
SGS_SendMessage(ply, "No Entry Found")
SGS_SendMessage(ply, "Couldn't find SteamID: " .. sid)
end
end
q1:start()
else
SGS_SendMessage(ply, "DATABASE NOT CONNECTED PLEASE TRY AGAIN!")
G4PSQL_ConnectToDatabase()
end
else
SGS_SendMessage(ply, "This command is reserved for administrators only!")
end
end
concommand.Add( "g4p_unban", G4PSQL_UnBan)
function SGS_SendMessage(ply, message)
if IsValid(ply) then
ply:PrintMessage(HUD_PRINTCONSOLE, message)
else
ServerLog(message .. "\n")
end
end
function SGS_DateStep()
local d = os.date("%d")
local m = tonumber(os.date("%m"))
local y = tonumber(os.date("%Y"))
if m == 12 then
m = 1
y = y + 1
else
m = m + 1
end
if m < 10 then
m = tostring(m)
m = "0" .. m
end
local newdtg = tostring(m) .. "/" .. tostring(d) .. "/" .. tostring(y)
return newdtg
end
-
I changed it so now it should work without any code modification. All you need is to change things to your liking such as console commands and messages displayed as well as some of the settings at the top.
-
Thanks a bunch!
-
Sorry, 2 things.
1. It should be noted that this script doesn't set up the database table for you. You'll need to take a look at the code and create the table yourself using the fields that the script expects.
2. I didn't actually use the connection info from the settings up top apparently. Take a look down a few functions into the code and modify the connection info there. I don't remember why I didn't just use the variables. I think I might have been having some issues with it.
-
Hey guys i got this script working.
HOWEVER.
The fact that every time a player joins it rewrites users.txt causes a huge lag when the servers got a fair few players on it...
e.g. a player joins, it checks users.txt and rewrites the player to user if the player doesnt exist..
The end result is EVERY player that joins gets their rank written to users.txt and this causes lag while the server reads/writes the file...
Any workaround for this?
-
Which script are you using?
What I did to fix that problem... and this is NOT RECOMMENDED unless you know what you are doing...
Inside of the ULib.ucl.addUser function I modified it to NOT write to the text file.
If you don't feel comfortable doing that, you could also modify whichever MySQL script you are using not to use the addUser function on a player unless they aren't a user. Only setting their group if they are above guest.
When you run addUser (Even if they don't have a group) it creates an entry inside of the users.txt file. When this file gets big enough, the server will hitch when players join the server.
-
Mr President,
thanks for your script again, but one thing - could you possibly tell me which way to create the table entries? I know how to, I mean the structure for each field. Mine are as follows, but I don't know if it is correct.
(http://puu.sh/6u6WM.png)
Thanks.
Also, same as last script. It says MySQLOO cannot be found even though it is definitely installed - I use it for other things. Where exactly should I have put the file?
-
(https://dl.dropboxusercontent.com/u/5982978/ForumLinks/tables.png)
-
As for the installation..
Make sure you have:
libmySQL.dll --Garrysmod root. Same location as srcds.exe
gmsv_mysqloo_win32.dll -- in garrysmod/lua/bin
The script I gave you, just make it an addon, or place it in your garrysmod/lua/autorun/server folder.
edit:
If you aren't sure if it's loaded correctly. Try this.
From your server console with the server running type:
require("MySQLOO")
If nothing returns then it's good. If it's not loaded, you'll get [ERROR] lua_run:1: Module not found!
-
Which script are you using?
What I did to fix that problem... and this is NOT RECOMMENDED unless you know what you are doing...
Inside of the ULib.ucl.addUser function I modified it to NOT write to the text file.
If you don't feel comfortable doing that, you could also modify whichever MySQL script you are using not to use the addUser function on a player unless they aren't a user. Only setting their group if they are above guest.
When you run addUser (Even if they don't have a group) it creates an entry inside of the users.txt file. When this file gets big enough, the server will hitch when players join the server.
I am using MKservers latest script he posted in this thread, would you mind sharing how you got ulib to not write to users.txt? and why is this not recommended?
-
It's not recommended because it's never recommended to modify base ULIB/ULX files. It won't hurt anything. Just remember to undo this if you ever decide to stop using MySQL authentication.
In addons\ULIB\lua\ulib\server\ucl.lua find:
function ucl.saveUsers()
for _, userInfo in pairs( ucl.users ) do
table.sort( userInfo.allow )
table.sort( userInfo.deny )
end
ULib.fileWrite( ULib.UCL_USERS, ULib.makeKeyValues( ucl.users ) )
end
replace with:
function ucl.saveUsers()
for _, userInfo in pairs( ucl.users ) do
table.sort( userInfo.allow )
table.sort( userInfo.deny )
end
--ULib.fileWrite( ULib.UCL_USERS, ULib.makeKeyValues( ucl.users ) )
end
Then just delete your users.txt file. Your game will now stop using it entirely.
-
Thanks again Mr President, you've been a great help :)
One thing, is it normal that your script stops the ability to edit rank permissions through XGUI?
-
It shouldn't. My script doesn't do anything to groups.
-
It shouldn't. My script doesn't do anything to groups.
Unfortunately I have the same problem here. :(
-
Data line error.
System is Windows Server 2008.
-
is it possiblet that this isn't completely compatible with URS or did I do something wrong? URS itslef seems to be working but it doesn't show the restrictions in the menu...
-
Obviously this is quite old, but since i am not able to test it out i'm asking, would this still work on the current version of ULX?