[island55]

Originally Posted by nineteeneleven Those of you on 3.0 if you havent updated by the time of this post please do so. I fixed some major bugs

good to know, thanks

[nineteeneleven]

I added promo codes/cupon codes to donations control. right now its a separate branch which can be found here
https://bitbucket.org/brewskii187/do...nch/Promotions

The code is stable and live on my communitys website.

you will need to import this sql

PHP Code:

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 ;

-- --------------------------------------------------------

--
-- Table structure for table `promotions_redeemed`
--

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 ; 


I will eventually merge this into the master branch as version 3.1.0

[Chdata]

I'm having trouble with installation.

I'm installing 3.0.0 from scratch, as I've never tried this kind of stuff until now.

Once you have your SourceBans installation configured correctly, you should begin by importing install.sql (located in sql/install.sql) to your database. This will create all the tables needed. After you have completed that delete the whole install folder. Then head on to includes/config.php and fill it out.

So don't import update.sql? And by "install" folder, you mean to delete sql/ folder?

Anyway the steps I'm taking so far:
1. Upload all this stuff to my website.
2. Import sql/install.sql
3. Delete sql/ and its contents from website.
4. Edit includes/config.php
- Now the main donate/index.php shows up fine with the paypal button for the most part, except...

PHP Code:

Warning: Invalid argument supplied for foreach() in /usr/www/website/public/donate/index.php on line 113 


5. Delete .gitignore cause I'm sure those aren't necessary.
6. Where is "upgrade.sql"? Searching 3.0.0 folders says this doesn't exist. (I importated update.sql anyway - didn't help).
7. Create TESTDONOR with steamid: STEAM_0:1:111111, set him to my Server Donator Group with no Web admin permissions.
8. Go to https://YOURDOMAIN.com/donations/admin. (Yes, I filled in the blanks with my actual website and not YOURDOMAIN).
9. I can't login with my sourcebans login. Always wrong. I also tried the login for my database itself. I'm stuck here.

Note: I use separately named databases for sourcebans and for this thing. Should I just import that stuff to my sourceban database, or would that not make a difference?


Edit: My configs was set to the web-admin group and not server admin group in sourcebans. Fixed as soon as I corrected that.

Edit: And upon making a group, error in step 4 is fixed.

[nineteeneleven]

so are you having any more problems?

[island55]

nineteeneleven;

just installed a fresh copy and when i click the donate button i'm getting this error;

We ran into an unhandled exception. Exiting, SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dmt_donalytics.promotions' doesn't exist

edit: until i noticed you updated this thing a few hours after i installed the old version. DAMNIT

[Chdata]

Originally Posted by nineteeneleven so are you having any more problems?

I'm good... though I don't know how to edit the main index.php to add an <href> and fix the background not to be black in steam browser.

I tried

PHP Code:

print('<p>Acceptable formats:<br />STEAM_0:0:0000000<br />steamcommunity.com/profiles/1234567891011<br />steamcommunity.com/id/{name} or {name}<br /></p><a href="http://steamidfinder.com">'); 


But I don't really know anything about php but the link doesn't appear. The STEAM_0:0:000... and steamcommunity.com thing does like usual, but the link is invisible.

(I changed both lines that say "Acceptable formats").


Also, what does the "Perks Activated" option do when editing donor entries? Is it different than choosing what donor group (tier) the user is in? Which one affects whether or not adminflags apply to them?

Last problem: http://i.imgur.com/a5eCLp8.png

There's 3 groups (tiers) successfully registered, but only two show.

[nineteeneleven]

Thats a css issue I thought I fixed that already try resizing your browser smaller you should see the third group

Edit: looks like your not running 3.1.0 updating will probably fix that

[island55]

nineteeneleven; how would i go about upgrading from 3.0.2 to 3.1.0? i ran the update to 3.1.0 sql file and it added 2 tables to the database but it's still not working properly? any ideas? or should i do a fresh install? a fresh install would be difficult since i have analytics running with donation control.

[nineteeneleven]

You need to replace all the files too, except config.php. Then in config.php change define('VERSION', '3.0.2'); to define('VERSION', '3.1.0');

[island55]

Originally Posted by nineteeneleven You need to replace all the files too, except config.php. Then in config.php change define('VERSION', '3.0.2'); to define('VERSION', '3.1.0');

i wouldn't have to reload anything in the database? aside from loading the 2 new tables?

edit; i'm getting an error on the "Promos" page from the admin portion of the donate system, here's the error; http://puu.sh/aYgUh/53c2bffe60.jpg
edit2; also getting this error from the "Analytics" page; http://puu.sh/aYh8v/1d4c186354.png