MissKalunji |
01-10-2006 03:57 AM |
Quote:
Originally Posted by Trana
Miss,
Is there a post which shows how to do this?
|
no just open the product
remove
Code:
<code>
<code version="2.0.2">
<installcode><![CDATA[$db->hide_errors();
$db->query_write("CREATE TABLE ".TABLE_PREFIX."donation_buttons (
id int(255) NOT NULL auto_increment,
goalid int(255) NOT NULL default '0',
amount decimal(10,2) default NULL,
item_name varchar(127) NOT NULL default '',
cn varchar(40) NOT NULL default 'Additional Instructions',
cpp_header_image varchar(255) default NULL,
cpp_headerback_color varchar(255) default NULL,
cpp_headerborder_color varchar(255) default NULL,
cbt varchar(255) NOT NULL default 'Continue Transaction',
active int(1) NOT NULL default '1',
description text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
");
$db->query_write("CREATE TABLE ".TABLE_PREFIX."donation_currency_exchange (
server varchar(255) NOT NULL default 'xe',
base varchar(255) NOT NULL default 'USD',
USD varchar(255) NOT NULL default '',
AUD varchar(255) NOT NULL default '',
CAD varchar(255) NOT NULL default '',
EUR varchar(255) NOT NULL default '',
GBP varchar(255) NOT NULL default '',
JPY varchar(255) NOT NULL default ''
) TYPE=MyISAM
");
$db->query_write("INSERT INTO ".TABLE_PREFIX."donation_currency_exchange (`USD`, `AUD`, `CAD`, `EUR`, `GBP`, `JPY`) VALUES ('1', '1', '1', '1', '1', '1')");
$db->query_write("CREATE TABLE ".TABLE_PREFIX."donation_donors (
id int(100) NOT NULL auto_increment,
userid int(255) NOT NULL default '0',
ip varchar(255) NOT NULL default '',
total decimal(10,2) NOT NULL default '0.00',
PRIMARY KEY (id)
) TYPE=MyISAM;
");
$db->query_write("CREATE TABLE ".TABLE_PREFIX."donation_goals (
id int(255) NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
description text NOT NULL,
amount decimal(10,2) NOT NULL default '0.00',
total_donated decimal(10,2) NOT NULL default '0.00',
active tinyint(1) NOT NULL default '1',
PRIMARY KEY (id)
) TYPE=MyISAM;
");
$db->query_write("CREATE TABLE ".TABLE_PREFIX."donation_paypalipn (
txn_id varchar(255) NOT NULL default '',
userid int(255) default NULL,
test_ipn tinyint(1) default NULL,
notify_version decimal(10,1) default NULL,
verify_sign varchar(255) default NULL,
first_name varchar(255) default NULL,
last_name varchar(255) default NULL,
payer_business_name varchar(255) default NULL,
address_name varchar(255) default NULL,
address_street varchar(255) default NULL,
address_city varchar(255) default NULL,
address_state varchar(255) default NULL,
address_zip varchar(255) default NULL,
address_country varchar(255) default NULL,
address_status varchar(255) default NULL,
payer_email varchar(255) default NULL,
payer_id varchar(255) default NULL,
payer_status varchar(255) default NULL,
business varchar(255) default NULL,
receiver_email varchar(255) default NULL,
receiver_id varchar(255) default NULL,
item_name varchar(255) default NULL,
ip_address varchar(255) default NULL,
quantity int(255) default NULL,
invoice varchar(255) default NULL,
memo varchar(255) default NULL,
tax decimal(10,2) default NULL,
option_name1 varchar(255) default NULL,
option_selection1 varchar(255) default NULL,
option_name2 varchar(255) default NULL,
option_selection2 varchar(255) default NULL,
payment_date varchar(255) default NULL,
parent_txn_id varchar(255) default NULL,
txn_type varchar(255) default NULL,
payment_type varchar(255) default NULL,
payment_status varchar(255) default NULL,
pending_reason varchar(255) default NULL,
reason_code varchar(255) default NULL,
mc_gross decimal(10,2) default NULL,
mc_fee decimal(10,2) default NULL,
mc_currency char(3) default NULL,
mc_handling decimal(10,2) default NULL,
mc_shipping decimal(10,2) default NULL,
settle_amount decimal(10,2) default NULL,
settle_currency char(3) default NULL,
exchange_rate decimal(10,4) default NULL,
case_id varchar(255) default NULL,
case_type varchar(255) default NULL,
case_creation_date varchar(255) default NULL,
valid tinyint(1) NOT NULL default '0',
PRIMARY KEY (txn_id)
) TYPE=MyISAM;
");
$db->query_write("ALTER TABLE ".TABLE_PREFIX."user ADD donor TINYINT(1) DEFAULT '0' NOT NULL");
$db->query_write("ALTER TABLE ".TABLE_PREFIX."user ADD showdonor TINYINT(1) DEFAULT '1' NOT NULL");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "cron (`cronid`, `nextrun`, `weekday`, `day`, `hour`, `minute`, `filename`, `loglevel`, `title`) VALUES ('', '', '-1', '-1', '0', '15', './includes/cron/donation_currency_exchange.php', '1', 'Donations Currency Exchange Quotes')");
$db->show_errors();]]></installcode>
<uninstallcode><![CDATA[$db->hide_errors();
$db->query_write("DROP TABLE " . TABLE_PREFIX . "donation_buttons");
$db->query_write("DROP TABLE " . TABLE_PREFIX . "donation_currency_exchange");
$db->query_write("DROP TABLE " . TABLE_PREFIX . "donation_donors");
$db->query_write("DROP TABLE " . TABLE_PREFIX . "donation_goals");
$db->query_write("DROP TABLE " . TABLE_PREFIX . "donation_paypalipn");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user DROP donor, DROP showdonor");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "cron WHERE title = 'Donations Currency Exchange Quotes'");
$db->show_errors();]]></uninstallcode>
</code>
</codes>
next time it will only reinstall templates perhaps permissions
but wont touch your tables
|