https://www.icyphoenix.com/viewtopic.php?f=28&t=4978&p=36379#p36379
-----------------------------------
redrumm101
Thu 05 Feb, 2009 23:13

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 linenumbers=false]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');
[/code]


