[danielmyst777]

I am trying to compile the donation control plug-in but am getting the following error with the web compiler

SourcePawn Compiler 1.6.0
Copyright (c) 1997-2006, ITB CompuPhase, (C)2004-2008 AlliedModders, LLC

/home/groups/sourcemod/upload_tmp/phpN48wsL.sp(112) : error 017: undefined symbol "newValue"
/home/groups/sourcemod/upload_tmp/phpN48wsL.sp(142) : error 017: undefined symbol "hMenu"
/home/groups/sourcemod/upload_tmp/phpN48wsL.sp(160) : error 017: undefined symbol "g_cvUrl"

3 Errors.

[Phaiz]

Strangely enough I had issues when trying to upgrade from 2.x and now that I'm just trying a fresh install with 3.1.0 it just errors out when trying to login to the admin page

Unable to open connection to MySQL server.

Yes the database info is correct in config.php - tried with multiple databases.

edit-
Nevermind, was an mistake on my end.

[johnnyking997]

@Phaiz

i have the same problem you had...

Unable to open connection to MySQL server.

maybe u can explain what was ur "mistake"

[Phaiz]

Originally Posted by johnnyking997 @Phaiz i have the same problem you had... Unable to open connection to MySQL server. maybe u can explain what was ur "mistake"

I skipped over the sourcebans info in the cfg.

[johnnyking997]

still dont get it.. have i missed anything?

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
define('SB_DB', false); //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', 'strike_sb');         //MySQL username ONLY NEEDED IF SOURCEBANS IS ON A DIFFERENT MYSQL SERVER
define('SB_SV_PASS', 'database_password');       //MySQL password ONLY NEEDED IF SOURCEBANS IS ON A DIFFERENT MYSQL SERVER
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
define('SOURCEBANS_DB', 'strike_sb'); // 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', 'FULL-Owner'); //name of admin group in sourcebans which has access to the donor panel
///////////////////////////////////////////////////////////////////////////////////////////

//Edit

fixed it.. i tried using it on a separate database then i saw

$db = new PDO('mysql:host=' . DB_HOST . ';dbname=' . SOURCEBANS_DB . ';charset=utf8', DB_USER, DB_PASS);

and realised that it's too complicated so i merged the databases

[Chdata]

Alright, so I found that the change I made allows people already in the database to donate and be updated in the database, but if an existing donator tries to upgrade or someone donating for the first time (who also isn't in the sourceban database at all yet), then it won't add/update them.

Spoiler

PHP Code:

<?php

if (!defined('NineteenEleven')) {
    die('Direct access not premitted');
}
require_once ABSDIR . "includes/GroupsClass.php";
require_once ABSDIR . 'scripts/rcon_code.php';

class sb extends groups {

    public $sdb;
    public $ddb;

    public function __construct() {

        try {
            $this->sdb = new PDO('mysql:host=' . SB_HOST . ';dbname=' . SOURCEBANS_DB . ';charset=utf8', SB_USER, SB_PASS);
            $this->sdb->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $this->sdb->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
        } catch (Exception $ex) {
            throw new Exception("Unable to connect to Sourcebans " . $ex->getMessage());
        }

        try {
            $this->ddb = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DONATIONS_DB . ';charset=utf8', DB_USER, DB_PASS);
            $this->ddb->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            //$this->ddb->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
            $this->ddb->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
        } catch (Exception $ex) {
            throw new Exception("Unable to connect to database " . $ex->getMessage());
        }
    }

    public function queryServers($query) {
        if (DEBUG) {
            return true;
        }
        $result = $this->sdb->query("SELECT * FROM sb_servers");
        while ($server = $result->fetch(PDO::FETCH_ASSOC)) {
            $srcds_rcon = new srcds_rcon();
            $OUTPUT = $srcds_rcon->rcon_command($server['ip'], $server['port'], $server['rcon'], $query);
        }
        return true;
    }

    /**
     *
     * @param type $steam_id
     * @return type
     * @throws Exception
     */
    public function getUserGroup($steam_id) {// code works good
        try {
            $stmt = $this->sdb->prepare("SELECT * FROM " . SB_PREFIX . "_admins WHERE `authid` =?;");
            $stmt->bindParam(1, $steam_id, PDO::PARAM_STR);
            $stmt->execute();
            $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
            if (empty($rows)) {
                throw new Exception(sprintf("%s, is not in any valid groups.", $steam_id));
            }
            $aid = $rows[0]['aid'];
            $srv_group = $rows[0]['srv_group'];
        } catch (Exception $ex) {
            throw new Exception(sprintf('There was a problem fetching infomation from MySQL server: %s', $ex->getMessage()));
        }

        unset($stmt);
        unset($rows);
        try {
            $stmt = $this->sdb->prepare("SELECT * FROM " . SB_PREFIX . "_admins_servers_groups WHERE `admin_id` =?;");
            $stmt->bindParam(1, $aid, PDO::PARAM_STR);
            $stmt->execute();
            $rows = $stmt->fetch(PDO::FETCH_ASSOC);
            $group_id = $rows['group_id'];
            $srv_group_id = $rows['srv_group_id'];
            $server_id = $rows['server_id'];
        } catch (Exception $ex) {
            throw new Exception(printf('There was a problem fetching infomation from MySQL server: %s', $ex->getMessage()));
        }
        $this->userGroup = array('srv_group' => $srv_group, 'group_id' => $group_id, 'srv_group_id' => $srv_group_id, 'server_id' => $server_id, 'aid' => $aid);
        return $this->userGroup;
    }

    /**
     *
     * @param type $steam_id
     * @param type $username
     * @param type $tier
     * @return boolean
     * @throws Exception
     */
    public function addDonor($steam_id, $username, $tier) {
//check sourcebans database to see if user is already in there

        //$steam_id = str_replace(array("/", "'"), "", $steam_id);

        /*try {
            $stmt = $this->sdb->prepare("SELECT `aid` FROM " . SB_PREFIX . "_admins WHERE authid=?;");
            $stmt->bindParam(1, $steam_id, PDO::PARAM_STR);
            $stmt->execute();
            $rows = $stmt->fetch(PDO::FETCH_ASSOC);
        } catch (Exception $ex) {
            throw new Exception(printf('There was a problem fetching infomation from MySQL server: %s', $ex->getMessage()));
        }
        unset($stmt);*/

        $userGroup = $this->getUserGroup($steam_id);
        if (isset($userGroup['aid']) && !empty($userGroup['aid']) && $userGroup['srv_group'] != "Regular")
        {
            //if (isset($rows['aid']) && !empty($rows['aid']))
            throw new Exception("user is already in the Sourcebans database, Aborting.");
        }
        else
        {
            if ($userGroup['srv_group'] == "Regular")
            {
                $this->removeDonorEx($steam_id);
            }

//if not, PUT EM IN!
            $group = $this->getGroupInfo($tier);
            try {
                $stmt = $this->sdb->prepare("INSERT INTO `" . SOURCEBANS_DB . "` . `" . SB_PREFIX . "_admins` (user,authid,password,gid,extraflags,immunity,srv_group) VALUES (:username, :steam_id, :sb_pw , '-1' , '0' , '0', :group);");
                $vals = array(':username' => $username, ':steam_id' => $steam_id, ':sb_pw' => 'e', ':group' => $group['name']);
                $stmt->execute($vals);
                $admin_id = $this->sdb->lastInsertId();
            } catch (Exception $ex) {
                throw new Exception(printf("<div class='alert alert-danger' role='alert'>There was a problem inserting into the Sourcebans admins database: %s</div>", $ex->getMessage()));
            }

            try {
                $stmt = $this->sdb->prepare("INSERT INTO `" . SOURCEBANS_DB . "` . `" . SB_PREFIX . "_admins_servers_groups` (admin_id,group_id,srv_group_id,server_id) VALUES(:admin_id,:group_id,:srv_group_id,:server_id);");
                $stmt->execute(array(':admin_id' => $admin_id, ':group_id' => $group['group_id'], ':srv_group_id' => $group['srv_group_id'], ':server_id' => $group['server_id']));
            } catch (Exception $ex) {
                throw new Exception(printf("<div class='alert alert-danger' role='alert'>There was a problem inserting into the Sourcebans admins server groups database: %s</div>", $ex->getMessage()));
            }
        }

        $this->queryServers('sm_reloadadmins');

        return TRUE;
    }

    /**
     *
     * @param type $steam_id
     * @param type $tier
     * @return boolean
     * @throws Exception
     */
    public function removeDonor($steam_id) { //snaggle code
        $userGroup = $this->getUserGroup($steam_id);

        // $groupList = $this->listGroups();
        // $grpLen = count($groupList);
        // $i = 1;
        // foreach ($groupList as $groups) {
        //     if ($userGroup['group_id'] == $groups['group_id']) {
        //         $i++;
        //     }
        // }
        // if ($i != $grpLen) {
        //     throw new Exception($steam_id . " is in a different sourcebans group.");
        // }

        try {
            $stmt = $this->sdb->prepare("UPDATE `" . SOURCEBANS_DB . "`.`" . SB_PREFIX . "_admins` SET srv_group = 'Regular' WHERE authid =:steam_id");
            // $stmt = $this->sdb->prepare("DELETE FROM `" . SOURCEBANS_DB . "`.`" . SB_PREFIX . "_admins` WHERE authid =:steam_id");
            $stmt->bindValue(':steam_id', $steam_id, PDO::PARAM_STR);
            $stmt->execute();
            $affected_rows = $stmt->rowCount();

            if ($affected_rows == 1) {
                unset($affected_rows);

                $stmt = $this->ddb->prepare("UPDATE `" . SOURCEBANS_DB . "`.`" . SB_PREFIX . "_admins_servers_groups` SET group_id = '4' WHERE admin_id =:aid");
                //$stmt = $this->ddb->prepare("DELETE FROM `" . SOURCEBANS_DB . "`.`" . SB_PREFIX . "_admins_servers_groups` WHERE admin_id =:aid");
                $stmt->bindValue(':aid', $userGroup['aid'], PDO::PARAM_STR);
                $stmt->execute();
                $affected_rows = $stmt->rowCount();
            } else {
                throw new Exception('Failed deleting from donor from database. ');
            }
        } catch (Exception $ex) {
            throw new Exception($ex->getMessage());
        }

        $this->queryServers('sm_reloadadmins');

        return TRUE;
    }


    /**
     * This is the old unmodified version of removeDonor, that actually fully removes them.
     *
     * @param type $steam_id
     * @param type $tier
     * @return boolean
     * @throws Exception
     */
    public function removeDonorEx($steam_id) { //snaggle code
        $userGroup = $this->getUserGroup($steam_id);

        // $groupList = $this->listGroups();
        // $grpLen = count($groupList);
        // $i = 1;
        // foreach ($groupList as $groups) {
        //     if ($userGroup['group_id'] == $groups['group_id']) {
        //         $i++;
        //     }
        // }
        // if ($i != $grpLen) {
        //     throw new Exception($steam_id . " is in a different sourcebans group.");
        // }
        try {
            $stmt = $this->sdb->prepare("DELETE FROM `" . SOURCEBANS_DB . "`.`" . SB_PREFIX . "_admins` WHERE authid =:steam_id");
            $stmt->bindValue(':steam_id', $steam_id, PDO::PARAM_STR);
            $stmt->execute();
            $affected_rows = $stmt->rowCount();

            if ($affected_rows == 1) {
                unset($affected_rows);

                $stmt = $this->ddb->prepare("DELETE FROM `" . SOURCEBANS_DB . "`.`" . SB_PREFIX . "_admins_servers_groups` WHERE admin_id =:aid");
                $stmt->bindValue(':aid', $userGroup['aid'], PDO::PARAM_STR);
                $stmt->execute();
                $affected_rows = $stmt->rowCount();
            } else {
                throw new Exception('Failed deleting from donor from database. ');
            }
        } catch (Exception $ex) {
            throw new Exception($ex->getMessage());
        }

        $this->queryServers('sm_reloadadmins');

        return TRUE;
    }
}

Not sure what's wrong.

No errors.

[SurrealRock]

Hello im getting this error "Unable verify player with Steam." what im doin wrong? please help me.

http://www.spclans.com/donation/

[Creampuffyness]

Nineteeneleven,

Thanks for the great plugin and donation system, it is a great help. I have a feature request though. Currently if a user is already in sourcebans such as a mod or admin or anything, and they donate via this system, they get put into the donators group in the donation control system. I have made it clear to my mods and admins not to donate via this method, but you know, things happen. What ends up happening is when the cron job runs, they get completely removed from sourcebans.

I'd like to request a way to either check to see if the member is part of a group other than donators, and stop them from being removed. if this is not possible, maybe a feature that puts expired donors into another group instead of removing them completely? I think this was requested in the past and I feel would be very helpful.

thanks.

[Chdata]

Funny... it's supposed to already do that o.O

(not change status of people who are already in sb database JUST LIVING IN THE DATABASE DATABASE WHOA OA)

[Phaiz]

Originally Posted by Creampuffyness Nineteeneleven, Thanks for the great plugin and donation system, it is a great help. I have a feature request though. Currently if a user is already in sourcebans such as a mod or admin or anything, and they donate via this system, they get put into the donators group in the donation control system. I have made it clear to my mods and admins not to donate via this method, but you know, things happen. What ends up happening is when the cron job runs, they get completely removed from sourcebans. I'd like to request a way to either check to see if the member is part of a group other than donators, and stop them from being removed. if this is not possible, maybe a feature that puts expired donors into another group instead of removing them completely? I think this was requested in the past and I feel would be very helpful. thanks.

If one of your admins donate just switch their group back in SB