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

AlliedModders (https://forums.alliedmods.net/index.php)

- SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)

- - Release SourceBans++ (v1.6.4) [Updated: 2021-10-06] (https://forums.alliedmods.net/showthread.php?t=263735)

Re: The Future of SourceBans++

Quote:

Originally Posted by Groruk (Post 2480986)

-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.)?

Re: The Future of SourceBans++

Quote:

Originally Posted by pcmaster (Post 2481050)

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).

Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

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;

}

Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Quote:

Originally Posted by Fastmancz (Post 2481652)

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.

Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Oh sorry. Now it is OK.

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

L 01/02/2017 - 10:37:27: SourceMod error session started
L 01/02/2017 - 10:37:27: Info (map "de_nuke") (file "errors_20170102.log")
L 01/02/2017 - 10:37:27: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 01/02/2017 - 10:37:27: [SM] Blaming: sbpp_comms.smx
L 01/02/2017 - 10:37:27: [SM] Call stack trace:
L 01/02/2017 - 10:37:27: [SM] [0] SQL_TQuery
L 01/02/2017 - 10:37:27: [SM] [1] Line 264, *****\sourcemod-1.8.0-git5967-windows\addons\sourcemod\scripting\sbpp_comms .sp::OnMapEnd
L 01/02/2017 - 10:37:29: Error log file session closed.

L 01/02/2017 - 14:02:33: [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:37: [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:30: [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

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.

Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Quote:

Originally Posted by M4ketech (Post 2483897)

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

Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]

Quote:

Originally Posted by blackhawk74 (Post 2483905)

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 :D 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"

        }