[live4net]

When I try add zone i got error:

L 07/17/2015 - 17:29:48: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4) L 07/17/2015 - 17:29:48: [SM] Displaying call stack trace for plugin "shavit-zones.smx": L 07/17/2015 - 17:29:48: [SM] [0] Line 711, shavit-zones.sp::InsertZone() L 07/17/2015 - 17:29:48: [SM] [1] Line 673, shavit-zones.sp::CreateZoneConfirm_Handler() L 07/17/2015 - 17:29:57: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4) L 07/17/2015 - 17:29:57: [SM] Displaying call stack trace for plugin "shavit-zones.smx": L 07/17/2015 - 17:29:57: [SM] [0] Line 711, shavit-zones.sp::InsertZone() L 07/17/2015 - 17:29:57: [SM] [1] Line 673, shavit-zones.sp::CreateZoneConfirm_Handler()

Plugin create automaticly only "users" table. Plugin add users to table fine.

Plugin don't create 'mapzones' table. I try to create that table manualy (I copy from sourcecode sql_query to create table and paste it into phpmyadmin) but it still not working.

CS:GO
SourceMod Version: 1.7.2-dev+5202 and SourceMod Version: 1.7.2

I try version 1.1b from AM and 1.2b from GitHub

[shavit]

Originally Posted by live4net When I try add zone i got error: Plugin create automaticly only "users" table. Plugin add users to table fine. Plugin don't create 'mapzones' table. I try to create that table manualy (I copy from sourcecode sql_query to create table and paste it into phpmyadmin) but it still not working. CS:GO SourceMod Version: 1.7.2-dev+5202 and SourceMod Version: 1.7.2 I try version 1.1b from AM and 1.2b from GitHub

A MySQL database. Hosted at the same machine the CS server is hosted at. I won't help with any MySQL related errors if your MySQL server isn't local.

[live4net]

Yes, database is hosted on that same machine.

[shavit]

New version hype!

1.2b - 17/July/2015: ~ shavit-core: + create a github repo (https://github.com/Shavitush/bhoptimer) * make a better check of game engine instead of using a directory + sm_pause (ofir ily bby <3) + sm_resume + add natives/forwards for sm_pause/resume and polish code ~shavit-misc: + cvar "shavit_misc_godmode": 0 - nothing 1 - only world damage 2 - only player damage 3 - full godmode + 250 maxspeed for every pistol (requires DHooks) ~shavit-zones: + player slaying zone + cvar "shavit_zones_style" 0 - 3d (default) 1 - 2d

[shavit]

Originally Posted by live4net Yes, database is hosted on that same machine.

PM me your databases.cfg file or post it here with the password censored

[live4net]

"shavit"
{
"driver" "mysql"
"host" "localhost"
"database" "my_database"
"user" "root"
"pass" "............."
"timeout" "10"
"port" "3306"
}


//edit

Whe I reload plugins:

sm plugins reload shavit-zones
sm plugins reload shavit-wr

It works fine.

But is problematic to reloads plugins every time when server restart.


//edit2

How to use API? I want use function

forward void Shavit_OnFinish(int client, int style, float time, int jumps);

[ofir753]

Originally Posted by live4net "shavit" { "driver" "mysql" "host" "localhost" "database" "my_database" "user" "root" "pass" "............." "timeout" "10" "port" "3306" } //edit Whe I reload plugins: sm plugins reload shavit-zones sm plugins reload shavit-wr It works fine. But is problematic to reloads plugins every time when server restart. //edit2 How to use API? I want use function forward void Shavit_OnFinish(int client, int style, float time, int jumps);

The only problem i can think of its that you are restarting the mysql server everytime you are restarting the server then it cant reach the server

about edit2 you can check my plugin shavit-sounds i use there one of the natives

[live4net]

I don't restart mysql database.

I think there are some errors in shavit.inv

When I add: include <shavit>

I got errors:

/dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(66) : error 147: new-style declarations are required
/dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(217) : error 001: expected token: "(", but found "-identifier-"
/dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(217) : error 010: invalid function or declaration
/dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(293) : error 147: new-style declarations are required

I try shavit.inc from first post and from Github.

[Schpraaankiii]

Could you add a way to set a prefix for the tables? The table "users" are too common and already used in my db. Many hosts (inc mine) does not allow their users to create multiple dbs as well. And since I can't seam to compile the .sp files I can not rename/add a table prefix myself.
Btw, the column "usertimes" does not seam to be created while using sqlite.

[ofir753]

Originally Posted by live4net I don't restart mysql database. I think there are some errors in shavit.inv When I add: include <shavit> I got errors: /dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(66) : error 147: new-style declarations are required /dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(217) : error 001: expected token: "(", but found "-identifier-" /dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(217) : error 010: invalid function or declaration /dane/csgo-ds-fun/csgo/addons/sourcemod/scripting/include/shavit.inc(293) : error 147: new-style declarations are required I try shavit.inc from first post and from Github.

Wait from shavit to answer about the sql.
About the errors it seems you edited the include and i can't help you without see your include file