SourcePlugins

[sn4k3]

[Gud]

Yes, this need is php. script to write steamid, using my ftp server (source server)


there i found the .php script ...


i don't think can create it by my self

[sn4k3]

[TanaToS]

hey update your su_rand to

[flanders]

i need the previous version, 1.5 VSP.
Have anybody a DL Link ?

thx !

[sn4k3]

[krugonN]

Has anyone used the MySQL function in Source Utils? I was trying to make an UPDATE query using a server_var on the WHERE clause but I don't know how to do it. I was trying something like this:

su_MySQL localhost 3306 admin admin "cssid" "UPDATE cssid_main SET playing='0' WHERE currentip=server_var(ipdisconn)"

If I use the previous query I get "SU: MYSQL ERROR: Query failed (FUNCTION cssid.server_var does not exist). So I tried the following one, but it won't work because it checks if currentip=server_var(ipdisconn) (I mean, it doesn't compare two IPs, it compares the current IP with the string "server_var(ipdisconn)": su_MySQL localhost 3306 admin admin "cssid" "UPDATE cssid_main SET playing='0' WHERE currentip='server_var(ipdisconn)'"

If I try the following, it works, but I need to make the query based on the variable ipdisconn:
su_MySQL localhost 3306 admin admin "cssid" "UPDATE cssid_main SET playing='0' WHERE currentip='192.168.1.15'"

Anyway, the question would be: how do I make an UPDATE query using a variable in the WHERE clause?

What would be the right way to do it? Thanks in advance.

[sn4k3]

[krugonN]

Yeah, I know the syntax, the problem (I think) is that SU doesn't recognize that server_var(myvar) isn't a common string and that it should replace that with the value of myvar. For example in PHP you can make it like this:

$sql="UPDATE cssid_main SET loggedin='0' WHERE currentip='$ipdisconn'"

I tried using es_format before and store the full query in a variable and then using it in the su_MySQL but it didn't work. I tried this:

es_format queryupdate "UPDATE cssid_main SET loggedin=0 WHERE currentip=%1" server_var(ipdisconn)
su_MySQL localhost 3306 admin admin "cssid" server_var(queryupdate)

and

su_MySQL localhost 3306 admin admin "cssid" "server_var(queryupdate)"

But neither of them worked

PS: I didn't understand what you meant with the last link
PS2: Should I make this post in the mattie's forum thread too? I don't know if more people visit this or that forum

[sn4k3]

[Didrole]

try
es su_MySQL localhost 3306 admin admin "cssid" server_var(queryupdate)
&
es su_MySQL localhost 3306 admin admin "cssid" "server_var(queryupdate)"

[Gud]

[dark hunter]

hi, i installed this scipt on my server, but i dont know how to add new people who will can use that bans...
i cant find where sholud i add steam id;/

[sn4k3]

[dark hunter]

i thought about it as dog_bans...author gave it on forum mattie's.
But i dont know how to activate users;/

[sn4k3]