[Release] Donation Control 3.1.0 [over 1000 donations served!] - Page 61

DEAD_HUNTER · 02-08-2016 , 01:15 Re: Donation Control 3.1.0 [over 1000 donations served!]

Yes i run a website on a wamp server and it works fine all the other stuff i have on the website.

config file:

Code:

<?php

/* Donations Control version 3.0.0 by NineteenEleven.
 * http://nineteeneleven.info
 * if you find this helpful please consider donating.
 */
if (!defined('NineteenEleven')) {
    die('Direct access not premitted');
}
//Fill in your preferences, and information


/*
 * PayPal Info
 */

define('PP_EMAIL', '[email protected]');              //The Paypal account's email address
define('PP_DESC', 'Donation to Gaming Mafia Multigame server');  //Paypal purchase description
define('PP_IPN', 'http://mysite.com/donation/scripts/ipn.php'); //Address to ipn.php included within the donations folder
define('PP_SUCCESS', 'http://mysite.com/');        //Address to send donor to after successful donation
define('PP_FAIL', 'http://mysite.com/');       //Address to send donor to after cancel while donating / other error
define('PP_CURRENCY', 'EUR'); //https://developer.paypal.com/webapps/developer/docs/classic/api/currency_codes/#id09A6G0U0GYK
/////////////////////////////////////////////////////////////////////////////////////////////////////////
define('PP_SANDBOX', true); //Use PayPal Sandbox for testing?
define('PP_SANDBOX_EMAIL', '[email protected]');




/*
 * Donations Database info
 */

define('DB_HOST', 'localhost');        //set MySQL host
define('DB_USER', 'root');             //MySQL username
define('DB_PASS', '');         //MySQL password
define('DONATIONS_DB', 'csgoserver');   //donations database




/*
 * Sourcebans info
 * Sourcebans is required as of 2.x.
 */

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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', 'dev');         //MySQL username ONLY NEEDED IF SOURCEBANS IS ON A DIFFERENT MYSQL SERVER
define('SB_SV_PASS', 'password2strong');       //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', 'Administrators'); //name of admin group in sourcebans which has access to the donor panel
///////////////////////////////////////////////////////////////////////////////////////////




/*
 * System Emails Settings
 */

define('sys_email', false);              //Turn on system emails?
$mail['name'] = 'Donations';                 //senders name
$mail['email'] = '[email protected]';    //senders e-mail adress
$mail['recipient'] = '[email protected]';   //recipient
$mail['useBCC'] = false;                         //add BCC
$mail['BCC'] = '[email protected]';           //BCC
$mail['donor'] = false; //Send confimation/ thankyou email to the donor?
$mail['donorSubject'] = 'Thank your for your donation';
$mail['donorMsg'] = 'Message to send to your donors';

define('reminder_email', false); //will send an email to donors every day for the last 5 days before their perks expire.
$reminder['subject'] = "%s, your donor perks are going to expire!"; //Subject of the email, %s is the username
$reminder['body'] = "Salutations %s \r\n, your donor perks are set to expire on %s. If you would like to continue to "
        . "recieve your donor benefits please visit http://YOURDOMAIN.com/donate and renew your perks.\r\n "
        . "See your around!\r\n"; //email body, \r\n is new line break the first %s is donors name the second is their expiration date

/*
 * Date formats
 * see http://php.net/manual/en/function.date.php
 */
$date_format['front_end'] = 'l F j Y';
$date_format['back_end'] = 'n/j/Y';
$date_format['log'] = 'm/j/Y g:i:s A';

/*
 * Miscellaneous
 */

define('FORCE_IPN', false); //This will force non-critical errors to keep the IPN script going when a donation is recieved. That includes unconfirmed steamids and other failures.
define('CCC', false); //https://forums.alliedmods.net/showpost.php?p=1738314&postcount=56#MySQLModule
date_default_timezone_set('America/New_York'); //http://php.net/manual/en/timezones.php
define('cache_time', '15'); //days to resolve cache for information from steam, mainly the avatar image, and display name.
define('PLAYER_TRACKER', false); //McKay Analytics plugin integration // https://forums.alliedmods.net/showthread.php?t=230832 tables must be in the donations database.
define('API_KEY', 'YOURAPIKEY'); //http://steamcommunity.com/dev/apikey
define("DEFAULT_LANGUAGE", "en-us"); // name of file in translation folder. dont add .json
$availableLanguages = array('en-us' => 'English', '1337' => '1337 5pEek', 'pt-br' => 'Portuguese (Brazil)', 'es-mx' => 'Spanish (Mexico)'); //set friendly display names here http://msdn.microsoft.com/en-us/library/ms533052(vs.85).aspx
define("STATS", true); //enable stats reporting




/*
 * dont edit this stuff
 */
if (SB_DB) {
    define('SB_HOST', SB_SV_HOST);
    define('SB_USER', SB_SV_USER);
    define('SB_PASS', SB_SV_PASS);
} else {
    define('SB_HOST', DB_HOST);
    define('SB_USER', DB_USER);
    define('SB_PASS', DB_PASS);
}
define('VERSION', '3.1.0'); //unused
define('ABSDIR', substr(__DIR__, 0, stripos(__DIR__, 'includes')));
define('DEBUG', false);
set_exception_handler('exception_handler');

require_once ABSDIR . 'includes/version.php';

function exception_handler($ex) {
    require_once ABSDIR . "includes/LoggerClass.php";
    $log = new log;
    $log->logError($ex->getMessage(), $ex->getFile(), $ex->getLine());
    echo "<div class='alert alert-danger' role='alert'>We ran into an unhandled exception. Exiting, " . $ex->getMessage() . "</div>";
    die();
}

That is my whole config. Please note that sourceban is installed on the same website and database as the donations are.

jpwanabe · 02-08-2016 , 01:24 Re: Donation Control 3.1.0 [over 1000 donations served!]

Did you run the instal.sql on the csgoservers database? As in does csgoservers look like this?
http://puu.sh/n03iN/77982d3c65.png

Also, if you do what I do and make a different account for each login that uses the databases, make sure they are set correctly.

DEAD_HUNTER · *Last edited by DEAD_HUNTER; 02-08-2016 at 09:38.*

https://gyazo.com/15c870e938d427a4f892a33489f1dcf5

I seem to be missing the player_analytics and servers

DEAD_HUNTER · 02-08-2016 , 09:40 Re: Donation Control 3.1.0 [over 1000 donations served!]

But in the install.sql itself there isnt even a player_analytics and servers db

Code:

 
CREATE TABLE IF NOT EXISTS `cache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `steamid` varchar(30) DEFAULT NULL,
  `avatar` varchar(256) DEFAULT NULL,
  `avatarmedium` varchar(256) DEFAULT NULL,
  `avatarfull` varchar(256) DEFAULT NULL,
  `personaname` varchar(128) DEFAULT NULL,
  `timestamp` varchar(32) DEFAULT NULL,
  `steamid64` varchar(64) DEFAULT NULL,
  `steam_link` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `custom_chatcolors` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `identity` varchar(32) CHARACTER SET latin1 NOT NULL,
  `flag` char(1) CHARACTER SET latin1 DEFAULT NULL,
  `tag` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `tagcolor` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
  `namecolor` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
  `textcolor` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`index`),
  UNIQUE KEY `identity` (`identity`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE IF NOT EXISTS `donations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `steamId` varchar(24) NOT NULL,
  `itemId` int(10) unsigned NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `processed` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `steamId` (`steamId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;


CREATE TABLE IF NOT EXISTS `donors` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `steam_id` varchar(30) NOT NULL,
  `sign_up_date` varchar(10) NOT NULL,
  `email` varchar(60) DEFAULT NULL,
  `renewal_date` varchar(10) DEFAULT '0',
  `current_amount` varchar(10) NOT NULL,
  `total_amount` float DEFAULT NULL,
  `expiration_date` varchar(10) NOT NULL,
  `steam_link` varchar(200) DEFAULT NULL,
  `notes` varchar(200) DEFAULT NULL,
  `activated` varchar(1) DEFAULT '0',
  `txn_id` varchar(128) DEFAULT NULL,
  `tier` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `group_id` varchar(8) NOT NULL,
  `srv_group_id` varchar(8) NOT NULL,
  `server_id` varchar(8) NOT NULL,
  `multiplier` varchar(8) NOT NULL,
  `ccc_enabled` int(1) NOT NULL DEFAULT '0',
  `minimum` int(8) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `group_id` (`group_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `promotions` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `type` int(1) NOT NULL,
  `amount` int(8) NOT NULL,
  `days` int(8) NOT NULL DEFAULT '0',
  `number` int(8) NOT NULL DEFAULT '0',
  `code` varchar(32) NOT NULL,
  `descript` varchar(128) NOT NULL,
  `timestamp` int(64) NOT NULL,
  `active` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `promotions_redeemed` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `promo_id` int(8) NOT NULL,
  `promo_code` varchar(32) NOT NULL,
  `steam_id` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DEAD_HUNTER · 02-08-2016 , 09:48 Re: Donation Control 3.1.0 [over 1000 donations served!]

I have made a database for donations itself now. So sourcebans and donations are on seperate databases. I configurated the config.cfg and set SB_DB to true. Now i get this error:
https://gyazo.com/2d2da0b4b9a5b4b556a8a0f95f1d89f4