SourcePlugins

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

Stupid hosting company taking forever to provide the logs, also tried 1.3 mm and it still crashed the server, tried to get 1.4vsp but its really the mm version?

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

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

Here are some mdmps with meta and the 1.5 mm

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

is not sourceutils is doing this

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

Don't see how only happens when this util is loaded

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

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

I thought that at first too, but both meta and css dll is server.dll, had to open with notepad2 and change one to a capital S to see which one it was and it was metamod and therefore most likely your plugin

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

I've tried 1.3, 1.4, 1.5 vsps and mms and all crash the server

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

Also mind you this is under quite high usage, 3/4 players being checked a minute on average, if it does crash when everyone is joining and being checked it can crash constantly

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

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

The server doesnt crash when the script isnt loaded because then nothing is using the plugin, but I just tried hand writing the query with the script not loaded and the server crashed.

I also tried a simple Select CURTIME() and that worked but seriously lagged the gameserver, seems that queries are not being threaded and therfore crash the server

Mind you i have tested this on CSS and DODS servers, the dods is 32 players and full 24/7 and this is the rapid usage one.

The css one however crashes with even just 5 people, this is not due to any script and you can fell the lag when multiple people join and the queries are executed.

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

mysql is threaded, the lag is normal because mysql is heavy under usage.

but use only a query by a player_activate will be good

and not use that in map change when all players activate!!!

The-Killer · New User Joined: 18 Jun 2007 Posts: 10

I wrote my own script last night that would only allow one query to be run at a time and after it checked 10 or 15 people it crashed the server, then when the server restarted and my script was loaded at startup with all the people joning it crashed about 3 times in a row before i could unload the script

ShadoX · New User Joined: 12 Jun 2006 Posts: 8

Do you know how to get SU v1.5 working with the latest version of the Warcraft 3 mod for CSS?

It works fine on v1.1 but lags presumably because that versions isn't multi-threaded.

I tried putting 1.5 on but the server won't retrieve data.

As far as i can tell the WC3 mod grabs returned data in the [Var] bit of the su_MySQL

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

but 1.5 doesn't seem to return data to that anymore? Does it only return data via the custom event you made?

I tried adding the event and saving the su_mysql_data event_var() to the variable the script uses but it seems the event returns each field of data individually rather as 1 long string (ie the WC3 mod wants 2 or 3 fields at once i think and the variable just keeps getting over written with the next fields data thus the WC3 mod can't retrieve data)

Is the <[Var]> bit on the su_MySQL command not sposed to return now (and if so why is it still there?) or is it broken (and if so when can we expect it to be fixed?) or how can i get around it so 1.5 works?

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

IN v1.5

var = get mysql userid for use with event_var(su_mysql_userid)

event su_mysql is fired 1 time per data

if reteruns is more than 1 event will fire more times

ShadoX · New User Joined: 12 Jun 2006 Posts: 8

Hmm ok damn, i tried userid and it returns alot of times, but the sql query used is a SELECT * statement

I think it'll be too hard to edit WC3 mod to work aswell, guess i'll wait for a new version that suits SU v1.5

Thanks anyway

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

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

New Version !!

v1.6 [26/7/07]

- added SourceUtils FreeLib can run without SourceUtils bin files (only mysql functions)
- added 'su_thread' event for threaded functions like geoip http
- added 'su_file' event for debug/print a file
- added file open/endwrite/list/remove/event commands
- added su_echo command
- added su_getexists mapent (allow know if exists an entity in map eg. buy_zone)
- added su_for command
- added su_FileCreate command (allow you create your own files!)
- added su_dumpclassprops command
- added su_dumpmapentitys command
- added su_dumpsclean command
- added a new folder 'addons/sourceutils/dumps' for dumps

- added 'su_nextmap' cvar to know nextmap
- added 'su_backmap' cvar to know backmap

- updated GeoIp.dat
- updated sourceutils_security.cfg with Files Options

- Improved su_compile command!
- Improved su_cvarforceset command!

- fixed all userid problems (crashs, not found userid)
- fixed "su_getnetinfo timeout" no setvalue to 0
- fixed all "su_getexists" no setvalue to 0

Gud · New User Joined: 05 Aug 2007 Posts: 18

I have a homepage,

In my homepage i have a pay botten, and then peapels buy V.I.P. via paypal, then they have pay the go back to my site.

http://clanroyal.dk/success.php

okay, i have a mysql database, then they get to this site, www.clanroyal.dk/donate.php , ther i get the steamid, are it possible to send steamid via a command from http://clanroyal.dk/success.php so they be writet to reserve.txt etc