Ulysses
General => Developers Corner => Topic started by: Proendreeper on February 06, 2013, 07:15:37 PM
-
I was a bit bored so I decided to try making so UCL uses a MySQL backend instead of a KeyValues backend.
Let me just say it turned out well.
I would attach more photos but I am too tired at the moment to do so.
-
Could you explain for me what a ULC is? o:
-
It's ULib's user management system
-
ULC? No idea? :P
UCL - Ulysses Control List. (aka User Control List)
Table of groups and users, with allow/deny permissions, and any other flag as set using ULib library group/user control code.
-
I was a bit bored so I decided to try making so UCL uses a MySQL backend instead of a KeyValues backend.
Let me just say it turned out well.
I would attach more photos but I am too tired at the moment to do so.
Really, neat and interesting script you have here. You thinking of releasing it to the world of ulx, or is it just a private little script you've been making?
Also, does your script just do the groups so far, or does it do users as well?
-
ULC? No idea? :P
UCL - Ulysses Control List. (aka User Control List)
Table of groups and users, with allow/deny permissions, and any other flag as set using ULib library group/user control code.
That would make sense, I just always misinterpret it as ulc not ucl
-
Really, neat and interesting script you have here. You thinking of releasing it to the world of ulx, or is it just a private little script you've been making?
Also, does your script just do the groups so far, or does it do users as well?
It has a ton of bugs and isn't very optimized, and yes it does both, I just was keeping the users steamids private more.
-
You think maybe I can see a little of it :) ?
-
You think maybe I can see a little of it :) ?
Sure, but you won't be getting much:P
local function Msg(text)
_G.Msg("[Global UCL] "..text)
end
local function getQuery(q,...)
if querys[q]~=nil then
return string.format(querys[q],...)
end
end
db = mysqloo.connect(MYSQL_HOST,MYSQL_USERNAME,MYSQL_PASSWORD,MYSQL_DATABASE,MYSQL_PORT)
local connected = false -- No idea why I am not using this.
function db:onConnected()
connected=true
end
function db:onConnectionFailed( err )
Msg( "Connection to database failed!\n" )
Msg( "Error:"..err.."\n" )
end
db:connect()
db:wait()
if db:status()==mysqloo.DATABASE_CONNECTED or db:status()==mysqloo.DATABASE_CONNECTING then
Msg("Connected successfully!\n")
else
Msg("Connected unsucessfully!\n")
end
-
Yeah looks like some pretty basic MySQL, it's nice. You should develop this into a addon that others can download because I would sure like this.
-
Yeah looks like some pretty basic MySQL, it's nice. You should develop this into a addon that others can download because I would sure like this.
I still need to fix a few things, such as it having to be loaded manually atm, I haven't gotten around to it yet but anyways in other news I've made a pointshop leaderboard
You can find it here (http://sv.proendreeperclan.com/pointshop.php)