DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • April 19, 2019, 07:17:36 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

Pages: [1]   Go Down
  Print  
Author Topic: paylog table  (Read 4136 times)
0 Members and 1 Guest are viewing this topic.
ADM
Guest
« on: January 29, 2005, 01:42:19 AM »

I get this error when I'm trying to view which members have donated.. one of my members did but never got any points or anything.

Quote
SELECT info,txnid FROM logd_paylog WHERE processdate='0000-00-00'

Table 'leafyis_logd.logd_paylog' doesn't exist

Now my installer never installed any paylog table in my database.  Would you be able to post the SQL code for the paylog table?

Also how many points would US$5 give?  So I can manually give that member that correct amount.
Logged
Kendaer
Guest
« Reply #1 on: January 29, 2005, 01:47:46 AM »

Indeed it's not and it should have been.
It will be in the next pre-release.

If you look at the top of paylog.php, it describes the table, so you should be able to use that to create the SQL.
Logged
Kendaer
Guest
« Reply #2 on: January 29, 2005, 02:04:30 AM »

actually, that wasn't quite right

here are the statements from the old .sql files which will create the table as needed.   The next release will have this handled by the installer correctly.

Code:
CREATE TABLE paylog (
    payid int(11) not null auto_increment,
    info text not null,
    PRIMARY KEY (payid)
) TYPE=InnoDB;
ALTER TABLE paylog ADD response text not null;
ALTER TABLE paylog ADD txnid varchar(32) not null;
ALTER TABLE paylog ADD INDEX(txnid);
ALTER TABLE paylog ADD amount float(9,2) not null default 0.00;
ALTER TABLE paylog ADD name varchar(50) not null;
ALTER TABLE paylog ADD acctid int(11) unsigned not null;
ALTER TABLE paylog ADD processed tinyint(4) unsigned not null default 0;
ALTER TABLE paylog ADD filed tinyint(4) unsigned not null default 0;
ALTER TABLE paylog ADD txfee float(9,2) not null default 0.00;
ALTER TABLE paylog ADD processdate datetime default '0000-00-00';
Logged
ADM
Guest
« Reply #3 on: January 29, 2005, 04:26:30 AM »

Thanks for that, works great now.

Another thing.. with the next release would I be able to upgrade to it from pr.13 with no problems? I've only installed modules that came with the current release.
Logged
Kendaer
Guest
« Reply #4 on: January 29, 2005, 12:02:40 PM »

You *should* be able to, yes.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Welcome to DragonPrime - The LoGD Resource Community!

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
74 Guests, 1 User
tnyguy
Home Forums News Downloads Login Register Advanced Search