[mazdarx8]

Can someone confirm if the mysql loading from 1.18b is better now?
(Everyone who have a big database...100MB or more)

It's very slowing if you type !rank, open your profile and refreshed it.

[sneaK]

Originally Posted by jonitaikaponi 3. Something went wrong with your installation, seems that changes weren't made into your database.

Interesting. I copied my current database to a new DB, changed my development server to that new DB, and fired it up with the new .smx, phrases, and custom titles txt file. Is there a step that I missed perhaps? No other servers were running on the new test database at the time.

I didn't use sm_insertmapzones or sm_insertmaptiers, because if memory servers that overwrites all current zones/tiers.

[mazdarx8]

Is the command sm_refreshprofile working correctly? Tried it now on some profiles and nothing changed.

[jonitaikaponi]

Originally Posted by SetTheRules After removing the prefix had a problem. The prefixes are no longer issued. Remove also impossible, the menu closes.

Should be fixed in the latest version.

Originally Posted by fluffys The push fix by Blaacky and others breaks very few boosts (surf_heaven bonus, surf_lullaby_ksf, surf_sluice) are a few examples that I can remember. Maybe only make it apply to trigger_push's that push the player in the z direction? (upwards/downwards) Also maybe adding a new misc zone that doesn't do anything, only visual, to display shortcuts would be handy. Edit: Would it be possible to reset all map filters on sm_restart/start zone? Maps like Parc_Colore, looks_modern are cheated because of how the filters work, would probably need a way to set filters as well for when you do !s x. Would also solve the issue of forcing people to use the fail trigger on surf_fast to reset the first boost on stage 1.

1. I noticed (and Blaacky informed me) that it breaks some boosts also, but your solution to only allow vertical boosts is a really good idea! I changed the code to that, and tested it a little. At least the boosts on surf_christmas bonus worked now.

2. Definately need to add something like that, but maybe a more simplistic marker feature, rather than implementing it to the !zones command.

3. I was also thinking about this, especially when I was doing surf_lolrevlis2 for the first time . I have to look into that a little more though..

Originally Posted by blackhawk74 Interesting. I copied my current database to a new DB, changed my development server to that new DB, and fired it up with the new .smx, phrases, and custom titles txt file. Is there a step that I missed perhaps? No other servers were running on the new test database at the time. I didn't use sm_insertmapzones or sm_insertmaptiers, because if memory servers that overwrites all current zones/tiers.

Try to check your error logs for when you first fired up the server with the test database, or just delete the testbase and recopy your development database and retry.

[Jaykrog]

Yep existing bonuses aren't being labeled as bonuses and bonus start zones are being considered the map start zones.

Just tried editing the zone via menus and it deleted all of my zones. O.o

There were two Start-0 zones.

It's also labeling the zones I'm creating for normal map zones as BONUS 1 in the database.

Seems like a major bug.

Here's the error logs:

L 11/25/2015 - 15:52:52: [SM] Plugin encountered error 15: Array index is out of bounds
L 11/25/2015 - 15:52:52: [SM] Displaying call stack trace for plugin "ckSurf.smx":
L 11/25/2015 - 15:52:52: [SM] [0] Line 4954, ckSurf/sql.sp::SQL_selectMapZonesCallback()
L 11/25/2015 - 15:52:52: [SM] Plugin encountered error 15: Array index is out of bounds
L 11/25/2015 - 15:52:52: [SM] Displaying call stack trace for plugin "ckSurf.smx":
L 11/25/2015 - 15:52:52: [SM] [0] Line 4954, ckSurf/sql.sp::SQL_selectMapZonesCallback()
L 11/25/2015 - 15:55:24: [SM] Plugin encountered error 15: Array index is out of bounds
L 11/25/2015 - 15:55:24: [SM] Displaying call stack trace for plugin "ckSurf.smx":

[LeeStrong]

Hi folks - Is anyone experiencing anything like this?
Note: 2 maps completed, 0 points. Database corresponds.

Clicky picture

Running 1.18b

[-BULL-]

Hi
I have 2 surf servers with different mapcycle and want them to share ranks, points and skillgroup.
Both servers are connected to the same SQL database, but the servers shows different things anyway.
Server 1: only Tier 1-2 maps
Server 2: only Tier 3-4 maps
Is that possible to make?

[jonitaikaponi]

Originally Posted by LeeStrong Hi folks - Is anyone experiencing anything like this? Note: 2 maps completed, 0 points. Database corresponds. Clicky picture Running 1.18b

Do you have your mesa and simpsons in your csgo/mapcycle.txt?

Originally Posted by -BULL- Hi I have 2 surf servers with different mapcycle and want them to share ranks, points and skillgroup. Both servers are connected to the same SQL database, but the servers shows different things anyway. Server 1: only Tier 1-2 maps Server 2: only Tier 3-4 maps Is that possible to make?

Yes it is possible.

You have to have the same exact csgo/mapcycle.txt on both servers, just set your mapchooser to use another file as a mapcycle. You also have to have all maps for both servers in their /csgo/maps folder, so have your T3-4 maps also on your T1-2 server.

[LeeStrong]

Hi Joni, thanks for getting in touch.
Yes I have those maps in the map cycle.
I've scoured the error logs to no avail, should I find the reason behind this I'll post a fix.

Note that there was no such issue before the upgrade from 1.17, I've ran the plugin on a fresh install and also have the same issue. As per above I'll update if I discover the reason.

It's affecting a small number of players, some are able to play and gain points normally. I'm unsure at this point how that could help identify the cause.

P. S. BULL
If you're running Linux, this is best achieved using a sym link rather than uploading multiple instances of maps. This assumes you're running a dedicated server.

[jonitaikaponi]

Originally Posted by Jaykrog Yep existing bonuses aren't being labeled as bonuses and bonus start zones are being considered the map start zones. Just tried editing the zone via menus and it deleted all of my zones. O.o There were two Start-0 zones. It's also labeling the zones I'm creating for normal map zones as BONUS 1 in the database. Seems like a major bug. Here's the error logs: L 11/25/2015 - 15:52:52: [SM] Plugin encountered error 15: Array index is out of bounds L 11/25/2015 - 15:52:52: [SM] Displaying call stack trace for plugin "ckSurf.smx": L 11/25/2015 - 15:52:52: [SM] [0] Line 4954, ckSurf/sql.sp::SQL_selectMapZonesCallback() L 11/25/2015 - 15:52:52: [SM] Plugin encountered error 15: Array index is out of bounds L 11/25/2015 - 15:52:52: [SM] Displaying call stack trace for plugin "ckSurf.smx": L 11/25/2015 - 15:52:52: [SM] [0] Line 4954, ckSurf/sql.sp::SQL_selectMapZonesCallback() L 11/25/2015 - 15:55:24: [SM] Plugin encountered error 15: Array index is out of bounds L 11/25/2015 - 15:55:24: [SM] Displaying call stack trace for plugin "ckSurf.smx":

I removed the labelling in one of the patches, because there just isnt enough space for the label on the timer. You can now see the name on the finishing texts.

Bonus start zones arent considered as bonus start zones anymore, they are just normal start zones, but they have a different zonegroup variable.

Creating bonuses and editing their names works fine for me:


Editing the zones might still have some bugs in it, I wouldn't touch that too much for now.