[pcmaster]

Regarding the crashes with the bot:
For me, SetClientName (as found here https://github.com/shavitush/bhoptim...replay.sp#L226) was the problem, as the crash dump suggests:

Program terminated with signal 11, Segmentation fault.
#0  0xf60b0bcf in CBaseServer::GetClient(int) () from /gameserver/csgo/setup_surf/bin/engine.so
#0  0xf60b0bcf in CBaseServer::GetClient(int) () from /gameserver/csgo/setup_surf/bin/engine.so
#1  0xeca6c64a in SetClientName(SourcePawn::IPluginContext*, int const*) () from ..

Changing that code so it writes to gS_BotName (instead of changing the name directly) and waiting for the timer to update the bot's name worked for me.

[shavit]

Originally Posted by pcmaster Regarding the crashes with the bot: For me, SetClientName (as found here https://github.com/shavitush/bhoptim...replay.sp#L226) was the problem, as the crash dump suggests: Program terminated with signal 11, Segmentation fault. #0 0xf60b0bcf in CBaseServer::GetClient(int) () from /gameserver/csgo/setup_surf/bin/engine.so #0 0xf60b0bcf in CBaseServer::GetClient(int) () from /gameserver/csgo/setup_surf/bin/engine.so #1 0xeca6c64a in SetClientName(SourcePawn::IPluginContext*, int const*) () from .. Changing that code so it writes to gS_BotName (instead of changing the name directly) and waiting for the timer to update the bot's name worked for me.

Thanks for the information!
I updated the repository: https://github.com/shavitush/bhoptim...9bd50c01828ec7

Some information:
This crash does not happen on Windows, only on Linux.

[Qes]

How to block respawn terrorists in this zone?

[pcmaster]

Np, now the only problem is that the bot is quite laggy (due to fully teleporting it).
This isn't really a problem on BHOP I presume, but on Surf, it's quite annoying.

Nothing for you to fix here (unless you want to), just wanted to point it out.

[shavit]

Originally Posted by Qes How to block respawn terrorists in this zone?

I have no idea what you're trying to do

Originally Posted by pcmaster Np, now the only problem is that the bot is quite laggy (due to fully teleporting it). This isn't really a problem on BHOP I presume, but on Surf, it's quite annoying. Nothing for you to fix here (unless you want to), just wanted to point it out.

I also noticed it but I can't find a fix sadly

[Qes]

If you want to block respawn for the TT, you have to change these functions in shavit-zones.sp

public void Shavit_OnRestart(int client) { if(!IsFakeClient(client) && !EmptyZone(gV_MapZones[0][0]) && !EmptyZone(gV_MapZones[0][1]) && GetClientTeam(client) == 3) { float vCenter[3]; MakeVectorFromPoints(gV_MapZones[0][0], gV_MapZones[0][1], vCenter); vCenter[0] /= 2; vCenter[1] /= 2; vCenter[2] /= 2; vCenter[2] -= 20; AddVectors(gV_MapZones[0][0], vCenter, vCenter); TeleportEntity(client, vCenter, NULL_VECTOR, view_as<float>({0.0, 0.0, 0.0})); } }

Anyone know how to remove the bot from the game, or simply move it to the team instead of CT or TT preferably spect?

[schwarz]

well at first you do good job for this plugin ,

I tired transfer sql programm from ofir753 , but this don t work , i think .

At first i click it and new file sql wrote only :

CREATE DATABASE IF NOT EXISTS shavit;

USE shavit;

CREATE TABLE IF NOT EXISTS `users` (`auth` VARCHAR(32) NOT NULL, `name` VARCHAR(32), `country` VARCHAR(45), `ip` VARCHAR(32), PRIMARY KEY (`auth`));

CREATE TABLE IF NOT EXISTS `mapzones` (`id` INT AUTO_INCREMENT, `map` VARCHAR(12, `type` INT, `corner1_x` FLOAT, `corner1_y` FLOAT, `corner1_z` FLOAT, `corner2_x` FLOAT, `corner2_y` FLOAT, `corner2_z` FLOAT, PRIMARY KEY (`id`));

CREATE TABLE IF NOT EXISTS `playertimes` (`id` INT NOT NULL AUTO_INCREMENT, `auth` VARCHAR(32), `map` VARCHAR(12, `time` FLOAT, `jumps` VARCHAR(32), `style` VARCHAR(32), `date` DATE, PRIMARY KEY (`id`));


INSERT INTO `users` (`auth`,`name`,`country`,`ip`) VALUES;

that is all . where are maps , zone etc? thanks !

[shavit]

Originally Posted by Qes If you want to block respawn for the TT, you have to change these functions in shavit-zones.sp Anyone know how to remove the bot from the game, or simply move it to the team instead of CT or TT preferably spect?

unload shavit-replay

[ybgr111]

Help pls
L 10/01/2015 - 16:05:04: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'map' in 'field list'
L 10/01/2015 - 16:05:13: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'r.map' in 'where clause'
L 10/01/2015 - 16:06:13: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'map' in 'field list'
L 10/01/2015 - 16:06:14: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'map' in 'field list'
L 10/01/2015 - 16:07:48: [shavit-wr.smx] Timer (WR forwards cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list'
L 10/01/2015 - 16:07:48: [shavit-wr.smx] Timer (WR sideways cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list'
L 10/01/2015 - 16:07:48: [shavit-wr.smx] Timer (WR OnFinish) SQL query failed. Reason: Unknown column 'auth' in 'field list'
L 10/01/2015 - 16:08:14: [shavit-wr.smx] Timer (WR forwards cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list'
L 10/01/2015 - 16:08:14: [shavit-wr.smx] Timer (WR sideways cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list'
L 10/01/2015 - 16:08:14: [shavit-wr.smx] Timer (WR OnFinish) SQL query failed. Reason: Unknown column 'auth' in 'field list'

[shavit]

Originally Posted by ybgr111 Help pls L 10/01/2015 - 16:05:04: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'map' in 'field list' L 10/01/2015 - 16:05:13: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'r.map' in 'where clause' L 10/01/2015 - 16:06:13: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'map' in 'field list' L 10/01/2015 - 16:06:14: [shavit-stats.smx] Timer (ShowMaps SELECT) SQL query failed. Reason: Unknown column 'map' in 'field list' L 10/01/2015 - 16:07:48: [shavit-wr.smx] Timer (WR forwards cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list' L 10/01/2015 - 16:07:48: [shavit-wr.smx] Timer (WR sideways cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list' L 10/01/2015 - 16:07:48: [shavit-wr.smx] Timer (WR OnFinish) SQL query failed. Reason: Unknown column 'auth' in 'field list' L 10/01/2015 - 16:08:14: [shavit-wr.smx] Timer (WR forwards cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list' L 10/01/2015 - 16:08:14: [shavit-wr.smx] Timer (WR sideways cache update) SQL query failed. Reason: Unknown column 'p.time' in 'field list' L 10/01/2015 - 16:08:14: [shavit-wr.smx] Timer (WR OnFinish) SQL query failed. Reason: Unknown column 'auth' in 'field list'

Execute this query on your MySQL server

CREATE TABLE IF NOT EXISTS `playertimes` (`id` INT NOT NULL AUTO_INCREMENT, `auth` VARCHAR(32), `map` VARCHAR(128), `time` FLOAT, `jumps` VARCHAR(32), `style` VARCHAR(32), `date` DATE, PRIMARY KEY (`id`));