AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)
-   -   Release SourceBans++ (v1.6.3) [Updated: 2018-04-09] (https://forums.alliedmods.net/showthread.php?t=263735)

pcmaster 12-27-2016 17:31

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

Groruk 12-27-2016 19:36

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

Fastmancz 12-29-2016 12:38

Re: [RELEASE] SourceBans++ (v1.5.4.7) [Updated: 2016-04-28]
 
4 Attachment(s)
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 (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.

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

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 (Post 2483897)
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 (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"
        }



All times are GMT -4. The time now is 21:22.

Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.