Icy Phoenix

Old Customizations - Donation MOD 1.0.4

KugeLSichA [ Thu 30 Oct, 2008 12:33 ]
Post subject: Donation MOD 1.0.4

Spoiler: [ Show ]

##############################################################

## MOD Title: Donations MOD Icy Phoenix Edition

## MOD Author: KugeLSichA < kugelsicha@gmx.net > (Holger Eisold) http://www.caromonline.de

## MOD Author: sandodo < zouxiong@loewen.com.sg > (Xiong Zou) http://bbs.loewen.com.sg & http://forum.loewen.com.sg 

## MOD Description: - Admin can set PayPal accounts to receive donations,

##                  - Donors can choose to be anonymous when donation,

##                  - Admin can set how many points to give to donor when donation,(Must have points MOD installed, otherwise, set it to 0 )

##                  - Admin can also set how many posts count to give to donor when donation,

##                  - Admin can set current donation goal, description and duration,

##                  - Admin can set to display top donors or last donors,

##                  - Admin can manually inset donation information

##                  - Admin can set which group the donor can join after donation, currently support different two groups

##                  - Admin can set which special rank the donor will be set to after donation, anonymous donor will not be set for this special rank

##                  - Support Payment Plugins. Admin can add plugins to have more way to collect donations, which can be found at Donation MOD Plugins section

##                  - Admin can enable and disable plugins.

##                  - support 10 more currency types.

##                  - support recurring donations. 

## MOD Version: 1.0.4

##

## Installation Level: Intermediate

## Installation Time: 45 min

## Files To Edit: 13

##                adm/admin_users.php

##                cms_auth.php

##                forum.php

##                includes/constants.php

##                includes/functions_dbmtnc.php

##                includes/functions_mg_online.php

##                includes/page_header.php

##                language/lang_english/lang_admin.php

##                templates/common/acp/user_edit_body.tpl

##                templates/mg_themes/cms_pages_auth_body.tpl

##                templates/mg_themes/index_body.tpl

##                templates/mg_themes/nav_quick_links.tpl

##                templates/mg_themes/overall_header.tpl

## Included Files:  donate.php

##                  donateconfirm.php

##                  donateresult.php

##                  donateshowresult.php

##                  donors.php

##                  adm/admin_donate_currency.php

##                  adm/admin_donors.php

##                  images/help_to_donate.gif

##                  images/paypal_donate.gif

##                  images/PayPal_mark_37x23.gif

##                  images/sponsor.gif

##                  includes/donate_functions_V3.php

##                  includes/donate_paypal_functions.php

##                  language/lang_english/email/html/thanku_donation.tpl

##                  language/lang_english/email/txt/thanku_donation.tpl

##                  language/lang_english/lang_donations.php

##                  language/lang_german/email/html/thanku_donation.tpl

##                  language/lang_german/email/txt/thanku_donation.tpl

##                  language/lang_german/lang_donations.php

##                  templates/common/acp/donate_currency_config_body.tpl

##                  templates/common/acp/donors_config_body.tpl

##                  templates/mg_themes/donate_body.tpl

##                  templates/mg_themes/donate_topupconfirm_body.tpl

##                  templates/mg_themes/donors_body.tpl

##############################################################

## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD

##############################################################

DEMO: -> http://www.caromonline.de/donate.php

DOWNLOAD: -> http://www.caromonline.de/downloads.php?cat=14

Chaotic [ Thu 30 Oct, 2008 15:09 ]
Post subject: Re: Donation MOD 1.0.4

Wow! Awesome work Kuge. :)

I'll install this MOD this afternoon.

DWho [ Thu 30 Oct, 2008 15:41 ]
Post subject: Re: Donation MOD 1.0.4

looks really good.. thanks...

Off Topic
KugeLSichA: [View Post]
Where can I get the advertisment feature in the top right of your website

MrWizard [ Thu 30 Oct, 2008 16:08 ]
Post subject: Getting And Error After Install In ACP

I am getting the following error in my ACP after I installed the mod.

Quote:
Parse error: syntax error, unexpected T_STRING in /homepages/13/d253270135/htdocs/ip_root/adm/admin_users.php on line 744

Here is what my file looks like please see attached file.

Problem solved please disregard post.

Instead of doing the following:

#-----[ IN-LINE FIND ]------------------------------------------
#
"'" . $avatar_sql . "

#
#-----[ IN-LINE REPLACE ]------------------------------------------
#
"', user_extra = '" . $user_extra . "'" . $avatar_sql . "

I just added part of the REPLACE line instead of replacing the whole line and this fixed the problem.

"', user_extra = '" . $user_extra .

Now I have a new problem. Everytime I try to setup the mod in the acp the settings aren't being saved.

KugeLSichA [ Thu 30 Oct, 2008 17:40 ]
Post subject: Re: Donation MOD 1.0.4

hi MrWizard,

i´ve fixed your admin_users.php

i dont wonder why you dont get this mod working... i this file you didn´t add all install instructions... please review your other files...

---

@DWho

DWho wrote: [View Post]
looks really good.. thanks...
Off Topic
KugeLSichA: [View Post]
Where can I get the advertisment feature in the top right of your website

i got many questions about this from time to time...

i hope i found the time today or until weekend to pack this MOD and upload it to my site and share it here...

DWho [ Sat 01 Nov, 2008 12:13 ]
Post subject: Re: Donation MOD 1.0.4

KugeLSichA wrote: [View Post]

@DWho

DWho wrote: [View Post]
looks really good.. thanks...
Off Topic
KugeLSichA: [View Post]
Where can I get the advertisment feature in the top right of your website

i got many questions about this from time to time...

i hope i found the time today or until weekend to pack this MOD and upload it to my site and share it here...

Thanks for taking the time to have a look for us..

TheSteffen [ Sun 02 Nov, 2008 19:56 ]
Post subject: Re: Donation MOD 1.0.4

Thanks KugeLSichA,

hope I found the time to test it.

Xusqui [ Fri 21 Nov, 2008 16:58 ]
Post subject: Re: Donation MOD 1.0.4

It's quite a good mod. Thank you very much for your time.

I've just finished installing it, first in my test forum and afterwards in the live website, it works as suposed. Very good contribution.

But I don't know how to change the ACP links to get them displayed in spanish, not in english. Can you tell me how to fix that?

Also translated the whole mod into spanish and created a block to work in IP, if you are interested in.

Thank you very much again

Xusqui [ Thu 27 Nov, 2008 08:29 ]
Post subject: Re: Donation MOD 1.0.4

Error...

When I try to load contact_us.php I get an error about a function (colorize_username) not defined, although it works fine on your website (http://www.caromonline.de/contact_us.php). That's because I use a Global Block for displaying the donators in every page.

I did this:

Open includes/donate_functions_V3.php

Find

Code: [Hide]

			$last_donors .= colorize_username($row['user_id']) . '(' . sprintf("%.2f", $row['lw_money']) . '&nbsp;' . $row['MNY_CURRENCY'] . '), '; 

Replace with

Code: [Hide]

			if (function_exists ('colorize_username'))
 
			{
 
				$last_donors .= colorize_username($row['user_id']) . '(' . sprintf("%.2f", $row['lw_money']) . '&nbsp;' . $row['MNY_CURRENCY'] . '), ';
 
			}
 
			else
 
			{
 
				$last_donors .= $row['user_id'] . '(' . sprintf("%.2f", $row['lw_money']) . '&nbsp;' . $row['MNY_CURRENCY'] . '), ';
 
			}

Now, it works fine!!

Greets!

redrumm101 [ Thu 05 Feb, 2009 23:13 ]
Post subject: Re: Donation MOD 1.0.4

Im getting this error message when i go to the forums

DEBUG MODE

SQL Error : 1146 Table 'cisclan_pheonix.ACCT_HIST_TABLE' doesn't exist

SELECT COUNT(*) FROM ACCT_HIST_TABLE WHERE comment LIKE 'donate from%' GROUP BY user_id

Line : 513
File : donate_functions_V3.php

Should i change the phpbb to something else or am i just missing something Thank you for your help
phpbb_account_hist 0 MyISAM latin1_swedish_ci 1.0

I think i got it to work this is the code i used

Code: [Hide] [Select]

CREATE TABLE `ACCT_HIST_TABLE` (

  `user_id` mediumint(8) default '0',

  `lw_post_id` mediumint(8) default '0',

  `lw_money` float default '0',

  `lw_plus_minus` smallint(5) default '0',

  `MNY_CURRENCY` varchar(8) default '',

  `lw_date` int(11) default '0',

  `comment` varchar(255) default '',

  `status` varchar(64) default '',

  `txn_id` varchar(64) default '',

  `lw_site` varchar(10) default ''

) TYPE=MyISAM;

INSERT INTO ip_config(config_name, config_value) VALUES('dislay_x_donors', '10');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_start_time', '');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_end_time', '');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_cur_goal', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_description', '');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_to_points', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('paypal_p_acct', '');

INSERT INTO ip_config(config_name, config_value) VALUES('paypal_b_acct', '');

INSERT INTO ip_config(config_name, config_value) VALUES('paypal_currency_code', 'USD');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_to_posts', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('list_top_donors', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_to_grp_one', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('to_grp_one_amount', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_to_grp_two', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('to_grp_two_amount', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('donor_rank_id', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('donate_currencies', '');

INSERT INTO ip_config(config_name, config_value) VALUES('usd_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('eur_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('gbp_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('cad_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('jpy_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('aud_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('czk_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('dkk_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('hkd_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('huf_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('nzd_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('nok_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('pln_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('sgd_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('sek_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('chf_to_primary', '0');

INSERT INTO ip_config(config_name, config_value) VALUES('paypal_support_currency', 'EUR;USD;');

INSERT INTO ip_config(config_name, config_value) VALUES('lw_dm_enable_paypal', '1');

ALTER TABLE `ip_users` ADD `user_extra` tinyint(2) NOT NULL default '0' AFTER `user_last_login_try`;

INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('auth_view_donations', '0');

INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('wide_blocks_donations', '1');

KugeLSichA [ Fri 06 Feb, 2009 16:20 ]
Post subject: Re: Donation MOD 1.0.4

Xusqui,

thanks i take a look into this and change it

@redrumm101

redrumm101 wrote: [View Post]
Im getting this error message when i go to the forums

DEBUG MODE

SQL Error : 1146 Table 'cisclan_pheonix.ACCT_HIST_TABLE' doesn't exist

SELECT COUNT(*) FROM ACCT_HIST_TABLE WHERE comment LIKE 'donate from%' GROUP BY user_id

Line : 513
File : donate_functions_V3.php

Should i change the phpbb to something else or am i just missing something Thank you for your help
phpbb_account_hist 0 MyISAM latin1_swedish_ci 1.0

I think i got it to work this is the code i used

you need to change the phpbb to your table prefix "cisclan_phoenix"

redrumm101 [ Sun 08 Feb, 2009 14:42 ]
Post subject: Re: Donation MOD 1.0.4

Thank you for the quick reply

spydie [ Sun 08 Feb, 2009 15:12 ]
Post subject: Re: Donation MOD 1.0.4

Xusqui wrote: [View Post]
It's quite a good mod. Thank you very much for your time.

I've just finished installing it, first in my test forum and afterwards in the live website, it works as suposed. Very good contribution.

But I don't know how to change the ACP links to get them displayed in spanish, not in english. Can you tell me how to fix that?

Also translated the whole mod into spanish and created a block to work in IP, if you are interested in.

Thank you very much again

could you place the spanish mod for download here xusqui ???

i´m quiet interrested in it

tbird412 [ Thu 14 May, 2009 06:26 ]
Post subject: Re: Donation MOD 1.0.4

Well I assume that this does not work with 1.2.22.49 since it crashed out on me at the begining of the install about 3 lines from completing all the SQL (which sucks, that means I just put a ton of things into my DB that I don't need)....

Code: [Hide] [Select]

INSERT INTO phpbb_config(config_name, config_value) VALUES('paypal_support_currency', 'EUR;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''EUR' at line 1

SQL Query # 36

USD;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USD' at line 1

SQL Query # 37

');

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1

SQL Query # 38

INSERT INTO phpbb_config(config_name, config_value) VALUES('lw_dm_enable_paypal', '1');

Successfully Completed. Affected Rows: 1

SQL Query # 39

ALTER TABLE `phpbb_users` ADD `user_extra` tinyint(2) NOT NULL default '0' AFTER `user_last_login_try`;

Unknown column 'user_last_login_try' in 'phpbb_users'

I gotta learn to quit thinking things will work with this RC version LOL.

DWho [ Fri 15 May, 2009 13:53 ]
Post subject: Re: Donation MOD 1.0.4

Off Topic
tbird412: [View Post]
Well I assume that this does not work with 1.2.22.49 since it crashed out on me at the begining of the install about 3 lines from completing all the SQL (which sucks, that means I just put a ton of things into my DB that I don't need)....

Code: [Hide] [Select]
Code: [Show]
INSERT INTO phpbb_config(config_name, config_value) VALUES('paypal_support_currency', 'EUR;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''EUR' at line 1

SQL Query # 36
USD;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USD' at line 1

SQL Query # 37
');
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1

SQL Query # 38

INSERT INTO phpbb_config(config_name, config_value) VALUES('lw_dm_enable_paypal', '1');
Successfully Completed. Affected Rows: 1

SQL Query # 39

ALTER TABLE `phpbb_users` ADD `user_extra` tinyint(2) NOT NULL default '0' AFTER `user_last_login_try`;
Unknown column 'user_last_login_try' in 'phpbb_users'

I gotta learn to quit thinking things will work with this RC version LOL.

my apologise for recommending Rc1 as I believed it was the best solution for you as the upgrade from version .27c is quite complicated...

if I had realised you wanted to add mods etc I would never have recommended it (my bad) :(

lets hope the new release is not far off and then all mods can be upgraded

:mrgreen: :mrgreen:

tbird412 [ Fri 15 May, 2009 14:02 ]
Post subject: Re: Donation MOD 1.0.4

Oh man, no apologies needed. It's fine. My confusion is the only set back here. And I'm sure a release is right around the corner. Let's just hope I can get the next release installed correctly or I'm gonna go pick up Chaotic against his will and bring him to my house to fix things for me ;)

DWho [ Fri 15 May, 2009 19:55 ]
Post subject: Re: Donation MOD 1.0.4

tbird412 wrote: [View Post]
Let's just hope I can get the next release installed correctly or I'm gonna go pick up Chaotic against his will and bring him to my house to fix things for me ;)

lol I am sure he will appreciate that...

tbird412 wrote: [View Post]
Oh man, no apologies needed. It's fine. My confusion is the only set back here. And I'm sure a release is right around the corner.

thanks.. hate it if i get it wrong and a member ends up feeling like they have wasted their time

:mrgreen: :mrgreen:

sorry for going off topic :oops:

OneWHoShanks [ Tue 19 May, 2009 09:14 ]
Post subject: Re: Donation MOD 1.0.4

does this mod work with rc2 ?

DWho [ Tue 19 May, 2009 10:21 ]
Post subject: Re: Donation MOD 1.0.4

Not at the moment it needs to be upgraded to work with rc2..

:mrgreen: :mrgreen:

KugeLSichA [ Sat 23 May, 2009 10:17 ]
Post subject: Re: Donation MOD 1.0.4

hey guys...

this mod is not working with latest RC2...

i work on updating this mod... please give me some time...

thx