[Release] SourceBans++ (v1.6.4) [Updated: 2021-10-06] - Page 94

pcmaster · 12-27-2016 , 17:31 Re: The Future of SourceBans++

Quote:

Originally Posted by Groruk

-stuff-

Out of curiosity, will you be using a web framework (e.g. Laravel) or be writing absolutely everything from scratch (including authentification, templating, etc.)?

Groruk · 12-27-2016 , 19:36 Re: The Future of SourceBans++

Quote:

Originally Posted by pcmaster

Out of curiosity, will you be using a web framework (e.g. Laravel) or be writing absolutely everything from scratch (including authentification, templating, etc.)?

Personally I have a dislike against PHP-Frameworks (most of them are slow or unreliable), so we are writing our own "Framework" containing a MVC solution, PDO Class for databases, 'more secure' sessions, custom error / exception handler, etc (we try to keep it as simple as we can and also want to provide a whole documentation so you can easily customize SourceBans++ if you have knowledge of HTML, CSS, JS and PHP).

Fastmancz · *Last edited by Fastmancz; 12-29-2016 at 13:11.*

Hello, who have problem with error "[sbpp_main.smx] Query Failed: Query was empty" then, there is fix. The problem was in code at line 997.

I changed this code:

Code:

SQL_SetCharset(DB, "utf8");

at:

Code:

FormatEx(query, sizeof(query), "SET NAMES \"UTF8\"");

Edit - I find next problem with:

Code:

[SM] Exception reported: Invalid database Handle 0 (error: 4)
[SM] Blaming: sbpp_comms.smx
[SM] Call stack trace:
[SM]   [0] SQL_TQuery
[SM]   [1] Line 264, C:\....

Solution is here. I removed following code in sbpp_comms:

Code:

public OnMapEnd()
{
	decl String:Query[2048];
	Format(Query, sizeof(Query),
		"UPDATE	%s_comms \
		SET		RemovedBy = 0, \
				RemoveType = 'E', \
				RemovedOn = UNIX_TIMESTAMP() \
		WHERE	sid = %d \
		AND		RemovedOn IS NULL \
		AND		length = -1",
		DatabasePrefix, serverID);
	#if defined LOG_QUERIES
	LogToFile(logQuery, "OnMapEnd for: %s. QUERY: %s", clientAuth, Query);
	#endif
	SQL_TQuery(g_hDatabase, Query_ErrorCheck, Query);

	// Clean up on map end just so we can start a fresh connection when we need it later.
	// Also it is necessary for using SQL_SetCharset
	if (g_hDatabase)
		CloseHandle(g_hDatabase);

	g_hDatabase = INVALID_HANDLE;
}

and I changed the code to:

Code:

public OnMapEnd()
{
	// Clean up on map end just so we can start a fresh connection when we need it later.
	// Also it is necessary for using SQL_SetCharset
	if (g_hDatabase)
		CloseHandle(g_hDatabase);

	g_hDatabase = INVALID_HANDLE;
}

**DarkDeviL** · 12-29-2016 , 12:51 Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Quote:

Originally Posted by Fastmancz

I changed this code:

Code:

SQL_SetCharset(DB, "utf8");

at:

Code:

FormatEx(query, sizeof(query), "SET NAMES \"UTF8\"");

You are also required to share the source code (.sp file), no matter if you only changed a single character or a million lines.

Please edit your post to include it.

Fastmancz · 12-29-2016 , 13:08 Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Oh sorry. Now it is OK.

LolzzDude · 12-29-2016 , 18:41 Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

I cant install this on my vps server , when i type the database info and klick ok i get a white page.
But i can install sourceban 2.0 and also 1.5.4 but none is working for csgo.
I have been trying to fix this for 2 days now but im stuck.

does someone have this problem to?

Screenshot
https://i.gyazo.com/207b44c934a8a51d...7a2d21830a.png

coolmans · 01-02-2017 , 06:24

L 01/02/2017 - 10

7:27: SourceMod error session started
L 01/02/2017 - 10

7:27: Info (map "de_nuke") (file "errors_20170102.log")
L 01/02/2017 - 10

7:27: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 01/02/2017 - 10

7:27: [SM] Blaming: sbpp_comms.smx
L 01/02/2017 - 10

7:27: [SM] Call stack trace:
L 01/02/2017 - 10

7:27: [SM] [0] SQL_TQuery
L 01/02/2017 - 10

7:27: [SM] [1] Line 264, *****\sourcemod-1.8.0-git5967-windows\addons\sourcemod\scripting\sbpp_comms .sp::OnMapEnd
L 01/02/2017 - 10

7:29: Error log file session closed.

L 01/02/2017 - 14:02

3: [sbpp_main.smx] Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VER' OR authid REGEXP '^STEAM_[0-9]:_SERVER$'), '0.0.0.0', 1)' at line 1
L 01/02/2017 - 14:43

7: [sbpp_main.smx] Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VER' OR authid REGEXP '^STEAM_[0-9]:_SERVER$'), '0.0.0.0', 1)' at line 1
L 01/02/2017 - 15:24

0: [sbpp_main.smx] Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VER' OR authid REGEXP '^STEAM_[0-9]:_SERVER$'), '0.0.0.0', 1)' at line 1
L 01/02/2017 - 16:05:59: [sbpp_main.smx] Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'day' at line 1

нашел ответ здесь (<- Google translates to: I found the answer here):
https://forums.alliedmods.net/showpo...&postcount=933

M4ketech · 01-05-2017 , 18:11 Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Im still stuck and this is like pain in the ass... I did get admins from sourcebans++ once, when i push all buttons in website panel. Now we are again missing all admins and groups, so if the website says "refreshing admins" its doing nothing.

Plugins list:

Code:

[SM] Listing 21 plugins:
  01 "Nextmap" (1.8.0.5967) by AlliedModders LLC
  02 "Basic Info Triggers" (1.8.0.5967) by AlliedModders LLC
  03 "Basic Commands" (1.8.0.5967) by AlliedModders LLC
  04 "Admin Menu" (1.8.0.5967) by AlliedModders LLC
  05 "Map Nominations" (1.8.0.5967) by AlliedModders LLC
  06 "Web Shortcuts CS:GO version" (2.5) by Franc1sco franug and James "sslice" Gray
  07 "Sound Commands" (1.8.0.5967) by AlliedModders LLC
  08 "Rock The Vote" (1.8.0.5967) by AlliedModders LLC
  09 "Basic Ban Commands" (1.8.0.5967) by AlliedModders LLC
  10 "MapChooser" (1.8.0.5967) by AlliedModders LLC
  11 "Basic Votes" (1.8.0.5967) by AlliedModders LLC
  12 "Player Commands" (1.8.0.5967) by AlliedModders LLC
  13 "Hunger Games" (1.0) by .#Zipcore
  14 "Basic Comm Control" (1.8.0.5967) by AlliedModders LLC
  15 "Basic Chat" (1.8.0.5967) by AlliedModders LLC
  16 "Fun Commands" (1.8.0.5967) by AlliedModders LLC
  17 "Anti-Flood" (1.8.0.5967) by AlliedModders LLC
  18 "Client Preferences" (1.8.0.5967) by AlliedModders LLC
  19 "Reserved Slots" (1.8.0.5967) by AlliedModders LLC
  20 "Admin Help" (1.8.0.5967) by AlliedModders LLC
  21 "Fun Votes" (1.8.0.5967) by AlliedModders LLC

No errors. My friend told me to delete "admins_simple.ini" and disable "admin-flatfile.smx" and i did, still no help. Also deleted admins.cfg admin_groups.cfg in sourcemod/config/ folder.
Server id is ok, database is ok (atleast i thinks so, since no errors), website is correct in sourcebans.cfg.

**sneaK** · 01-05-2017 , 18:36 Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Quote:

Originally Posted by M4ketech

Im still stuck and this is like pain in the ass... I did get admins from sourcebans++ once, when i push all buttons in website panel. Now we are again missing all admins and groups, so if the website says "refreshing admins" its doing nothing.

Well, I'm seeing absolutely nothing related to sourcebans in your plugins list, it's probably because of that.

M4ketech · 01-05-2017 , 19:02 Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Quote:

Originally Posted by blackhawk74

Well, I'm seeing absolutely nothing related to sourcebans in your plugins list, it's probably because of that.

Eeerm, now its weird. Plugin run away itself

reuploaded all. Now its showing

Code:

L 01/06/2017 - 00:42:58: [sourcebans.smx] Database failure: Could not find Database conf "sourcebans". See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/

I followed link and setup database, name was "SourceBans" and now no errors or anything

Code:

[SM] Listing 27 plugins:
  01 "Nextmap" (1.8.0.5967) by AlliedModders LLC
  02 "Basic Info Triggers" (1.8.0.5967) by AlliedModders LLC
  03 "Basic Commands" (1.8.0.5967) by AlliedModders LLC
  04 "Admin Menu" (1.8.0.5967) by AlliedModders LLC
  05 "Map Nominations" (1.8.0.5967) by AlliedModders LLC
  06 "Web Shortcuts CS:GO version" (2.5) by Franc1sco franug and James "sslice" Gray
  07 "SourceSleuth" ((SB++) 1.5.4.6) by ecca, Sarabveer(VEER™)
  08 "Sound Commands" (1.8.0.5967) by AlliedModders LLC
  09 "SourceComms" ((SB++) 1.5.4.6) by Alex, Sarabveer(VEER™)
  10 "Rock The Vote" (1.8.0.5967) by AlliedModders LLC
  11 "Basic Ban Commands" (1.8.0.5967) by AlliedModders LLC
  12 "MapChooser" (1.8.0.5967) by AlliedModders LLC
  13 "Basic Votes" (1.8.0.5967) by AlliedModders LLC
  14 "Player Commands" (1.8.0.5967) by AlliedModders LLC
  15 "Hunger Games" (1.0) by .#Zipcore
  16 "Basic Comm Control" (1.8.0.5967) by AlliedModders LLC
  17 "Basic Chat" (1.8.0.5967) by AlliedModders LLC
  18 "Fun Commands" (1.8.0.5967) by AlliedModders LLC
  19 "Advertisements" (2.0.2) by Tsunami
  20 "SourceBans: Admin Config Loader" ((SB++) 1.5.4.6) by AlliedModders LLC, Sarabveer(VEER™)
  21 "Anti-Flood" (1.8.0.5967) by AlliedModders LLC
  22 "Client Preferences" (1.8.0.5967) by AlliedModders LLC
  23 "Reserved Slots" (1.8.0.5967) by AlliedModders LLC
  24 "Admin Help" (1.8.0.5967) by AlliedModders LLC
  25 "Fun Votes" (1.8.0.5967) by AlliedModders LLC
  26 "SourceBans Checker" ((SB++) 1.5.4.6) by psychonic, Ca$h Munny, Sarabveer(VEER™)
  27 "SourceBans++" (1.5.4.6) by SourceBans Development Team, Sarabveer(VEER™)

BUT no admins coming to sb_admins.cfg file.

Code:

"sourcebans"
	{
		"driver"			"mysql"
		"host"				"peliydin.net"
		"database"			"peliydin_bans"
		"user"				"peliydin_admin"
		"pass"				"********"
		//"timeout"			"0"
		"port"			"3306"
	}