[Jmills]

Just to clarify, I am getting the following error:

L 11/17/2014 - 22:026: [multi1v1.smx] Could not connect: [1045]: Access denied for user 'xxxxxxxx'@'localhost' (using password: YES)

I have tried using localhost, 127.0.0.1 and the IP address of the database which is hosted on the same box as the server.

I also tried using an external database which gave me this error:

L 11/17/2014 - 22:52:26: [multi1v1.smx] Could not connect: [2003]: Can't connect to MySQL server on '199.124.x.x' (10061)

[splewis]

Not much I can tell you, there's nothing plugin-specific about the MySQL connection.

I can suggest making sure the access is granted (i.e. run the GRANT ALL PRIVILEGES ... command)

For the external one, MySQL by default only listens for connections on the local machine, so you have to change that. Something like editing bind-address in /etc/mysql/my.cnf (I forget the exact names, should be easy to google)

[Jmills]

Thanks for the response. The user definitely has permissions because the web side of it is working as expected, I'll keep trying. Thanks for this great plugin, our community is really enjoying it.

[Jmills]

Alright, got that issue resolved, however now I've run into a new one. On the stats page, if you click a player's name to access their individual stats page, you get the following error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /index.php on line 53 User not found.

Any ideas?

[splewis]

Originally Posted by Jmills Alright, got that issue resolved, however now I've run into a new one. On the stats page, if you click a player's name to access their individual stats page, you get the following error: Any ideas?

What version of everything are you using?

If you've just randomly pulled the web interface from the github repo you'd need to be using a development version of the plugin (e.g. compiled the plugin in the repo yourself) as well.

[Jmills]

Thanks for the tip, compiled the latest version from GitHub and everything is gravy now.

[jad3z]

Hey, not sure if this post belongs here but Splewis always has a good answer :p

I'm using your plugin on my private server for LAN parties to warm up, and we love it!

What we are trying to do is to swap to a mini game map to take a break ( surf, obstacle ) or even a simple death match or bomb plant.

Is there a way to unload the multi1v1 plugin on a specific map in the cycle and load a custom cfg or something for that map?
( Spawn together, no friendly fire for example )
Sorry if this sounds stupid, I'm new to all this server hosting and scripting.

Thank you so much for all the support you have given to the community, people love it

PS : I tried to change the mp_time limit to 5 minutes instead of 10 per map but didn't work, is this setting included in one of your files?

[splewis]

Originally Posted by jad3z Hey, not sure if this post belongs here but Splewis always has a good answer :p I'm using your plugin on my private server for LAN parties to warm up, and we love it! What we are trying to do is to swap to a mini game map to take a break ( surf, obstacle ) or even a simple death match or bomb plant. Is there a way to unload the multi1v1 plugin on a specific map in the cycle and load a custom cfg or something for that map? ( Spawn together, no friendly fire for example ) Sorry if this sounds stupid, I'm new to all this server hosting and scripting. Thank you so much for all the support you have given to the community, people love it

It's possible to unload/load plugins based on the current map - I don't know of any plugins that do that, however.

There are plugins that set specific cvars per map, so you could set enabled cvars depending on the map. Unfortunately, I never got around to adding an enabled cvar for multi1v1: https://github.com/splewis/csgo-multi-1v1/issues/9

For now, you could use another plugin that adds plugin enable/disable commands (that just moves the plugins to the disabled directory) and do it before map changes. See what I wrote at the end of this post: https://forums.alliedmods.net/showpo...5&postcount=24

Originally Posted by jad3z PS : I tried to change the mp_time limit to 5 minutes instead of 10 per map but didn't work, is this setting included in one of your files?

cfg/sourcemod/multi1v1/game_cvars.cfg

[jad3z]

Thanks for the fast response!

So :
https://forums.alliedmods.net/showthread.php?t=182086
+
https://forums.alliedmods.net/showthread.php?p=607079
should theoretically work ?

[splewis]

The problem I see with doing that is that berni's map config plugin executes things at the start of maps, while doing a plugin load/unload often requires a map change. (multi1v1 does at least)

For example: playing deathmatch on d2, then the next map is am_grass2

Map changes to am_grass2, berni's plugin read's config for am_grass2, runs command "plugins load multi1v1", but the plugin doesn't load until next map change, so multi1v1 isn't loaded when playing on am_grass2.