[Phaiz]

Originally Posted by nineteeneleven Ur updating from which version? 3.0.x - current: update-3.1.0.sql 2.1.X - current: update-3.1.0.sql and update.sql Fresh install: install.sql

Not sure which version I have. Where can I tell?

[Sarabveer]

Originally Posted by nineteeneleven I can add it if there is an API/IPN for some sort of bitcoin payment system. (I guess coin base). I havent looked into it at all though.

Here you go!

https://coinbase.com/docs/api/overview

[Chdata]

Is there a way to set what group a person is set to once their donation has expired?

For example, I want to make an admin group that applies to Ex-Donators so they have a sort of 'permanent perk' that's not as good as donor status, but is still there because they donated at least once.


Also some questions:

What version of the webpanel is this link?
http://nineteeneleven.info/index.php...ns-control.zip

Is that different from the bitbucket?

The instructions for updating...

sql/update-3.1.0.sql into your donations database. Upload 3.1.x Clear your browsers cache. If you get wierd CSS issues like overlapping panels

So I import that SQL file, and then I copy and paste ALL of the files from 'download repository' in the bitbucket on top of my existing ones?

Is that correct? I'd like confirmation because I once tried doing that to update a different web panel (SM store) and ended up breaking up my configs and having to just set everything up from scratch.

Should I back up my database or anything? ( not that I know how to do that ;o; )

[ShinyRazu]

Hi, when I log into {domain}.com/donations/admin it says: Unable to open connection to MySQL server.

What can I do to fix this? thx!

[nineteeneleven]

Chdata. The download link on my site automatically updates its self from the bitbucket commit so its up to date.

And yes import the sql file and overwrite all the files except your config. If your updating from 2.x you need to redo your config.

[nineteeneleven]

Originally Posted by ShinyRazu Hi, when I log into {domain}.com/donations/admin it says: Unable to open connection to MySQL server. What can I do to fix this? thx!

Your config probably has some mistakes or wrong passwords

[Chdata]

Alright, I updated.

But my groups page still gets that table stretch where one doesn't appear =/

Also the default value on the donate page is always $5, while my 3 donor groups are $3, $6, $12.

How can I make the value in the box reflect the selected group? ouo

[nineteeneleven]

Originally Posted by Chdata Alright, I updated. But my groups page still gets that table stretch where one doesn't appear =/

I dont know im not getting that on my installs, can you give me some sort of access to your panel so I can see whats going on?

Originally Posted by Chdata Also the default value on the donate page is always $5, while my 3 donor groups are $3, $6, $12. How can I make the value in the box reflect the selected group? ouo

Um actually that was not implemented. I updated index.php to do that, you can get it here

[darkboy245]

Getting this error message when clicking on "Donate" button.
"
Unable verify player with Steam."
?

[Chdata]

Thanks very much, I also edited the default value from 5 to 3 so it works.

I tried making my "donators are set to a special group instead of losing all of their perks thing". Does the following look okay?

PHP Code:

    public function removeDonor($steam_id) { //snaggle code
        $userGroup = $this->getUserGroup($steam_id);

        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;
    } 


I could probably make it get the group_id by going off of how you got the admin_id but I have no PHP knowledge and it was faster for me to just copy the values from my database.

I have a feeling that since normally we're deleting a row, affected rows will return false and this code won't update properly.