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: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

Quote:

Originally Posted by leeter (Post 2516317)

I still got 1 Error, i have used the latest version of PRs.

I fixed it. All good

I just needed to change the ServerID in the sourcemod.cfg from -1 to 1. :wink:

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

-EDIT- Resolved, Chrome wasn't redirected to https

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

Anyone know solution for this error: https://gyazo.com/8ec88d24aed23594d7a8897661a8fa91
sbpp_sleuth looks like this: https://pastebin.com/XHb0QLUd

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

Quote:

Originally Posted by DaRk56 (Post 2515906)

Delete old version (All files ! Includes /plugins/scripting)

No it doesn't. Unless you're actively compiling plugins in the same SourceMod folder that you use for your server (which I find silly, I have 4 different SourceMod directories on the go where I compile and test things) you shouldn't be uploading scripting files to your server anyway. The server itself doesn't read the .SP/.INC files, it reads the compiled .SMX files.

tl;dr: Updating a .INC or .SP file won't fix shit unless you're compiling your own local copy, basically.

If you compile your own copies, then yes, update the .SP and .INC files, obviously. This way when you compile your own copy, you'll know you've got up-to-date .SP/.INC files for SB++.

If not, don't bother updating the .SP/.INC files, only update the compiled plugin. Since you aren't compiling your own copy, you don't need the source code/INC file(s)

Sorry if I've confused anyone, not my intent. I was just a tad confused by people advising to update .INC files to fix compiled plugin issues (because that makes no fuckin' sense)

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

The latest security addition that salts the passwords breaks the donation addon - it is impossible to login on the admin page.
I've tried looking into it, but I have absolutely no idea how to fix it.
I was hoping that one of the sourcebans developers with some insight into the added security mechanisms would be able to fix the donations addon:
https://github.com/nineteeneleven/Donations-Control

I don't know if it's an easy fix, but I figured that there's no harm in asking.

Thanks.

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

Quote:

Originally Posted by LeetDonkey (Post 2517582)

I have the same problem. No idea also can be the part "Salt"

- "Config"

PHP Code:


		
			
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

define('SB_DB', true); //ONLY SET TRUE IF SOURCEBANS IS ON A DIFFERENT MYSQL SERVER

define('SB_SV_HOST', 'localhost');      //set MySQL host ONLY NEEDED IF SOURCEBANS IS ON A DIFFERENT MYSQL SERVER

define('SB_SV_USER', 'sourcebans');         //MySQL username ONLY NEEDED IF SOURCEBANS IS ON A DIFFERENT MYSQL SERVER

define('SB_SV_PASS', 'xxxXXxx');       //MySQL password ONLY NEEDED IF SOURCEBANS IS ON A DIFFERENT MYSQL SERVER

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

define('SOURCEBANS_DB', 'sourcebans'); // sourcebans database, this is needed.

define('SB_PREFIX', 'sb'); //Sourcebans database prefix. Only change this value if you changed your database prefix when setting up SourceBans.

define('SB_SALT', 'SourceBans'); //dont change this unless you changed your salt in sourcebans (if you dont know what salt is, you didnt change it)

define('SB_ADMINS', 'Leader'); //name of admin group in sourcebans which has access to the donor panel

///////////////////////////////////////////////////////////////////////////////////////////

"Index"

PHP Code:


		
			
<?php

if (isset($_POST['loginSubmit'])) {

    define('NineteenEleven', TRUE);

    require_once '../includes/config.php';

    require_once ABSDIR . 'includes/LoggerClass.php';

    $log = new log;

    $user_name = $_POST['user_name'];

    $password = sha1(sha1(SB_SALT . $_POST['password']));



    try {

        $db = new PDO('mysql:host=' . DB_HOST . ';dbname=' . SOURCEBANS_DB . ';charset=utf8mb4', SB_USER, SB_PASS);

        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

    } catch (Exception $e) {

        die('Unable to open connection to MySQL server.');

    }



    try {

        $stmt = $db->prepare("SELECT * FROM " . SB_PREFIX . "_admins WHERE user=? and password=? and srv_group = '" . SB_ADMINS . "';");

        $stmt->execute(array($user_name, $password));

        $row = $stmt->fetchAll(PDO::FETCH_ASSOC);

    } catch (Exception $e) {

        echo "<h3>Something went wrong with our system.</h3>";

        $log->logError($ex->getMessage(), $ex->getFile(), $ex->getLine());

    }

    $count = count($row);

    if ($count === 1) {

        $email = $row[0]['email'];

        session_start();

        $_SESSION['username'] = $user_name;

        $_SESSION['email'] = $email;

        $_SESSION['table'] = false;

        ini_set('default_socket_timeout', 10);

        $json = @json_decode(@file_get_contents('http://1911.expert/dc-version/version.php'));



        if (!empty($json) && VERSION_NEW != $json->version) {



            $_SESSION['message'] = "<div class='alert alert-warning' role='alert'>There is an update available. ";



            if (isset($json->msg)) {

                $_SESSION['message'] .= $json->msg;

            }

            $_SESSION['message'] .= "</div>";

        }

        print("<center><h1 class = 'success'> Welcome back $user_name </h1></center>");

        $log->logAction("$user_name logged in from " . $_SERVER['REMOTE_ADDR']);

        print("<script type = 'text/javascript'> setTimeout('reload()', 1000)

                function reload(){

                window.location = 'show_donations.php'

                }</script>");

        exit();

    } else {

        print "<center><h1 class='error'>Wrong Username or Password</h1></center>";

        $log->logAction("Failed login attempt for user name: $user_name from " . $_SERVER['REMOTE_ADDR']);

    }

}

?>

<div id='login'>

    <table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">

        <tr>

        <form id="loginSubmit" method="POST" action="index.php">

            <td>

                <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">

                    <tr>

                        <td colspan="3"><strong>Admin Login </strong></td>

                    </tr>

                    <tr>

                        <td width="78">Username</td>

                        <td width="6">:</td>

                        <td width="294"><input name="user_name" type="text" id="user_name"></td>

                    </tr>

                    <tr>

                        <td>Password</td>

                        <td>:</td>

                        <td><input name="password" type="password" id="password"></td>

                    </tr>

                    <tr>

                        <td>&nbsp;</td>

                        <td>&nbsp;</td>

                        <td><input type="submit" name="loginSubmit" value="Login" form='loginSubmit' /><input type='button' id='hideLogin' value='Cancel' /></td>



                    </tr>

                </table>

            </td>

        </form>

        </tr>

    </table>

</div>

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

Quote:

L 05/04/2017 - 03:19:54: [SM] Exception reported: Fatal error creating dynamic native!
L 05/04/2017 - 03:19:54: [SM] Blaming: sourcebans.smx
L 05/04/2017 - 03:19:54: [SM] Call stack trace:
L 05/04/2017 - 03:19:54: [SM] [0] CreateNative
L 05/04/2017 - 03:19:54: [SM] [1] Line 148, sourcebans.sp::AskPluginLoad2
L 05/04/2017 - 03:19:54: [SM] Failed to load plugin "sourcebans.smx": unexpected error 23 in AskPluginLoad callback.

Help?? Happens on 1 server but not the other

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

Quote:

Originally Posted by chc (Post 2518112)

Help?? Happens on 1 server but not the other

Check that you have these plugins disabled:

SourceSleuth.smx
sb_admcfg.smx
sbchecker.smx
sourcebans.smx
sourcecomms.smx

Those are the old plugins from version 1.5

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]

Hi. Can somebody help me? I dont know how to fix this :cry:

Quote:

Error: the XML response that was returned from the server is invalid. Received:
Fatal error: mysqli error: [1048: Column 'host' cannot be null] in EXECUTE("INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('e','PHP Error','[256] mysqli error: [1048: Column \'host\' cannot be null] in EXECUTE(\"INSERT INTO sb_log(type,title,message, function, query, aid, host, created)\n VALUES (\'m\',\'Server Added\',\'Server (185.38.0.123:27998) has been added\',\'/home/jonnekah/public_html/sourcebans/includes/xajax.inc.php - 1095
/home/jonnekah/public_html/sourcebans/includes/xajax.inc.php - 744
/home/jonnekah/public_html/sourcebans/index.php - 33
\',\'N/A\',\'1\',NULL,1493924506)\")\n
\nFatal error on line 79 in file /home/jonnekah/public_html/sourcebans/includes/adodb/adodb-errorhandler.inc.php','/home/jonnekah/public_html/sourcebans/includes/adodb/adodb-errorhandler.inc.php - 79
/home/jonnekah/public_html/sourcebans/includes/adodb/adodb.inc.php - 1250
/home/jonnekah/public_html/sourcebans/includes/adodb/adodb.inc.php - 1190
/home/jon in /home/jonnekah/public_html/sourcebans/includes/adodb/adodb-errorhandler.inc.php on line 79
You have whitespace in your response.

Re: [RELEASE] SourceBans++ (v1.6.0) [Updated: 2017-04-23]