[nineteeneleven]

Originally Posted by StayOx lol the gods do not want me to use your Donor Control Sorry we were unable to get your Steam ID. Either you entered an invalid Steam ID, or the Steam community is down. Please check and make sure you entered a valid Steam ID and try again. Click here to go back and tables cache donors player_tracker should be in a database named "donations" correct? EDIT: Ok steam online again: I m use the script and the result is this after adding this a User via "Manual Entry" group_id: 0 srv_group_id: 0 server_id: 0 I go check the page "Donor List" and sourcebans Group and the user was added correctly. Now I m try check the information of my steamid and the result is: group_id: 1 srv_group_id: 7 server_id: -1

The test donor in sourcebans need to be in a servers group, and an admin group. you need to do those steps in sourcebans first. I should be releasing version 2.0 this week, and I plan on adding an installer to hopefully make this a little more simple.


http://nineteeneleven.info/screensho...ation-control/


edit: yes those tables are correct.

[Dr_Knuckles]

Hang in the StayOx youll get it. Thanks to nineteens patience and a lot of messing around my noob ass was able to finally get this glorious thing working right.

[StayOx]

Originally Posted by nineteeneleven The test donor in sourcebans need to be in a servers group, and an admin group. you need to do those steps in sourcebans first. I should be releasing version 2.0 this week, and I plan on adding an installer to hopefully make this a little more simple. http://nineteeneleven.info/screensho...ation-control/ edit: yes those tables are correct.

Thanks guy for the support and patience that script helped and facilitated all .... Now I will try to simulate a donation, I think I need to create another paypal account to test ... then give my feedback


EDIT:

I made another donation simulation and definitely did not work, the donations is usually performed but the information of the User are not inserted automatically in the database SourceBans only "Manual Entry" work


Version 2.0 I hope everything goes well and I will surely test

[nineteeneleven]

The current version works fine. Make sure you are doing what I said in the previous post.

Anyway 2.0 is basically done. I just need to do a lot of testing and make sure everything is working properly. Then write a script to update the database to version 2.0. If anyone wants to help test hit me up I'll send u a download link (don't even think about using it for production)

Oh and write the installer for new installs

[StayOx]

Originally Posted by nineteeneleven The current version works fine. Make sure you are doing what I said in the previous post. Anyway 2.0 is basically done. I just need to do a lot of testing and make sure everything is working properly. Then write a script to update the database to version 2.0. If anyone wants to help test hit me up I'll send u a download link (don't even think about using it for production) Oh and write the installer for new installs

ok. send a dowload link via PM

Thanks.

[nineteeneleven]

Here it is, it should be pretty stable, there are some instruction in the readme let me know if you find any bugs.

Also u log into the admin panel with your SourceBans user name and password

Also CCC support it tied to tier 2 donor.

Disclaimer : this is a beta version while it seemed stable during testing there are no guarantees. If you are updating back up your database prior to running the update script. Also delete the update script after your done.

[StayOx]

Originally Posted by nineteeneleven Here it is, it should be pretty stable, there are some instruction in the readme let me know if you find any bugs. Also u log into the admin panel with your SourceBans user name and password Also CCC support it tied to tier 2 donor. Disclaimer : this is a beta version while it seemed stable during testing there are no guarantees. If you are updating back up your database prior to running the update script. Also delete the update script after your done.

Hey guy, the new features are really cool good job and was simple to install and with the tips in config.php file was simpler to configure... followed all the steps.

I'm testing with paypal-sanbox (really useful) and created another SourceBans only for testing however the problem still occurs. The "Manual Entry" works perfectly.

However the details of donations made from "http://mysite.com/donations" are not automatically inserted in SourceBans and Donor List

I think this can only be caused by some script I must be missing the .zip file

[nineteeneleven]

Originally Posted by StayOx Hey guy, the new features are really cool good job and was simple to install and with the tips in config.php file was simpler to configure... followed all the steps. I'm testing with paypal-sanbox (really useful) and created another SourceBans only for testing however the problem still occurs. The "Manual Entry" works perfectly. However the details of donations made from "http://mysite.com/donations" are not automatically inserted in SourceBans and Donor List I think this can only be caused by some script I must be missing the .zip file

There was a syntax error in the update_database.php roll back your database to the backup you took and run this one.

PHP Code:

<?php
define('NineteenEleven', TRUE);
require_once '../../includes/config.php';
$mysqliD = new mysqli(DB_HOST,DB_USER,DB_PASS,DONATIONS_DB)or die($mysqliD->error . " " . $mysqliD->errno);


if (isset($_GET['delete_me'])) {
    if (unlink(__FILE__)) {
        echo "Poof!\r\n update_database.php has been removed successfully<br />";
    }else{
        "Failed to remove update_database.php please do it manually.";
    }
    exit('Good Bye...');
}


echo"<a href='update_database.php?delete_me' style='padding: 10px; background-color: rgba(15, 17, 14, 0.8);border: 1px solid white;border-radius: 5px;margin: 10px;text-decoration: none;color: white;text-decoration: none;'> Click here to Delete this file</a><br /><br /><br /><br />";
//check for CCC database, if exist add auto incremenet, if not add table.
if ($mysqliD->query("DESCRIBE `custom_chatcolors`")) {
    echo "Found CCC table.\r\n";
    if($mysqliD->query("ALTER TABLE `custom_chatcolors` ADD index INT PRIMARY KEY AUTO_INCREMENT;")){
        echo "CCC table modified successfully to work with Donations Control.\r\n";
    }else{
        echo "Failed to update CCC table.\r\n";
    }
}else{
    $ccc_create = "CREATE TABLE IF NOT EXISTS `custom_chatcolors` (
                  `index` int(11) NOT NULL AUTO_INCREMENT,
                  `identity` varchar(32) NOT NULL,
                  `flag` char(1) DEFAULT NULL,
                  `tag` varchar(32) DEFAULT NULL,
                  `tagcolor` varchar(8) DEFAULT NULL,
                  `namecolor` varchar(8) DEFAULT NULL,
                  `textcolor` varchar(8) DEFAULT NULL,
                  PRIMARY KEY (`index`),
                  UNIQUE KEY `identity` (`identity`)
                ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;";
    if($mysqliD->query($ccc_create)){
        echo "CCC table created.\r\n";
    }else{
        echo "Failed to created CCC table.\r\n";
    }
}



// add column tier to the donations database
if($mysqliD->query("ALTER TABLE `donors` ADD COLUMN `tier` varchar(10);")){
    echo "Added column 'tier' to the donor table successfully.<br />";
}else{
    echo "failed to add 'tier' column to database.<br />";
}



// convert dates in database to epioch, populate tier column.
$result = $mysqliD->query("SELECT * FROM `donors` WHERE 1");

while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
    $user_id = $row['user_id'];
    $sDate=strtotime($row['sign_up_date']);
    if($row['renewal_date']=='N/A' || $row['renewal_date']=='n/a' || empty($row['renewal_date'])){
        $rdate = 0;
    }else{
        $rDate=strtotime($row['renewal_date']);
    }
        $eDate=strtotime($row['expiration_date']);

    if($mysqliD->query("UPDATE `donors` SET `sign_up_date`= '{$sDate}', `renewal_date` = '{$rDate}', `expiration_date` = '{$eDate}', `tier` ='1' WHERE user_id = {$user_id};"))
    {
        echo 'Updated: ' . $row['username'] . '<br />';
    }else{
        echo '<h3>FAILED TO UPDATE: ' . $row['username'] . '</h3><br />';
    }
}
$mysqliD->close();

?>

[StayOx]

Originally Posted by nineteeneleven There was a syntax error in the update_database.php roll back your database to the backup you took and run this one. PHP Code: <?php define('NineteenEleven', TRUE); require_once '../../includes/config.php'; $mysqliD = new mysqli(DB_HOST,DB_USER,DB_PASS,DONATIONS_DB)or die($mysqliD->error . " " . $mysqliD->errno);     if (isset($_GET['delete_me'])) {     if (unlink(__FILE__)) {         echo "Poof!\r\n update_database.php has been removed successfully<br />";     }else{         "Failed to remove update_database.php please do it manually."     }     exit('Good Bye...'); }     echo"<a href='update_database.php?delete_me' style='padding: 10px; background-color: rgba(15, 17, 14, 0.8);border: 1px solid white;border-radius: 5px;margin: 10px;text-decoration: none;color: white;text-decoration: none;'> Click here to Delete this file</a><br /><br /><br /><br />"; //check for CCC database, if exist add auto incremenet, if not add table. if ($mysqliD->query("DESCRIBE `custom_chatcolors`")) {     echo "Found CCC table.\r\n";     if($mysqliD->query("ALTER TABLE `custom_chatcolors` ADD index INT PRIMARY KEY AUTO_INCREMENT;")){         echo "CCC table modified successfully to work with Donations Control.\r\n";     }else{         echo "Failed to update CCC table.\r\n";     } }else{     $ccc_create = "CREATE TABLE IF NOT EXISTS `custom_chatcolors` (                   `index` int(11) NOT NULL AUTO_INCREMENT,                   `identity` varchar(32) NOT NULL,                   `flag` char(1) DEFAULT NULL,                   `tag` varchar(32) DEFAULT NULL,                   `tagcolor` varchar(8) DEFAULT NULL,                   `namecolor` varchar(8) DEFAULT NULL,                   `textcolor` varchar(8) DEFAULT NULL,                   PRIMARY KEY (`index`),                   UNIQUE KEY `identity` (`identity`)                 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;";     if($mysqliD->query($ccc_create)){         echo "CCC table created.\r\n";     }else{         echo "Failed to created CCC table.\r\n";     } }       // add column tier to the donations database if($mysqliD->query("ALTER TABLE `donors` ADD COLUMN `tier` varchar(10);")){     echo "Added column 'tier' to the donor table successfully.<br />"; }else{     echo "failed to add 'tier' column to database.<br />"; }       // convert dates in database to epioch, populate tier column. $result = $mysqliD->query("SELECT * FROM `donors` WHERE 1");   while ($row = $result->fetch_array(MYSQLI_ASSOC)) {     $user_id = $row['user_id'];     $sDate=strtotime($row['sign_up_date']);     if($row['renewal_date']=='N/A' || $row['renewal_date']=='n/a' || empty($row['renewal_date'])){         $rdate = 0;     }else{         $rDate=strtotime($row['renewal_date']);     }         $eDate=strtotime($row['expiration_date']);       if($mysqliD->query("UPDATE `donors` SET `sign_up_date`= '{$sDate}', `renewal_date` = '{$rDate}', `expiration_date` = '{$eDate}', `tier` ='1' WHERE user_id = {$user_id};"))     {         echo 'Updated: ' . $row['username'] . '<br />';     }else{         echo '<h3>FAILED TO UPDATE: ' . $row['username'] . '</h3><br />';     } } $mysqliD->close();   ?>

PHP Code:

Parse error:  syntax error, unexpected '}' in ...donations/admin/install/update_database.php on line 12 


Just replace this:

PHP Code:

if (isset($_GET['delete_me'])) {
    if (unlink(__FILE__)) {
        echo "Poof!\r\n update_database.php has been removed successfully<br />";
    }else{
        "Failed to remove update_database.php please do it manually."
    }
    exit('Good Bye...');
} 


with this:

PHP Code:

if (isset($_GET['delete_me'])) { 
    if (unlink(__FILE__)) { 
        echo "Poof!\r\n update_database.php has been removed successfully<br />";
     }else{ 
        echo "Failed to remove update_database.php please do it manually<br />";
    } 
    exit('Good Bye...'); 
} 


Right?

[nineteeneleven]

Yes that's right. I updated the post above before.