Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

PaymentLogs

Aug 21, 2005, 7:15 PM
rascal
User (346 posts)
rascal's avatar
Aug 21, 2005, 7:15 PM
Post #1 of 6
Views: 2389
Shortcut
Quote Reply
PaymentLogs
Good Evening,

I would like to run a sql query to obtain Total Amounts and Total Fees
from the lsql_PaymentLogs from Jan 1,2005 to present.

Have tryed, but no success.


Help with this would be appreciated.
Aug 22, 2005, 8:38 PM
rascal
User (346 posts)
rascal's avatar
Aug 22, 2005, 8:38 PM
Post #2 of 6
Views: 2321
Shortcut
Quote Reply
Re: [rascal] PaymentLogs In reply to
Nobody knows how?
Aug 24, 2005, 9:45 AM
rascal
User (346 posts)
rascal's avatar
Aug 24, 2005, 9:45 AM
Post #3 of 6
Views: 2294
Shortcut
Quote Reply
Re: [rascal] PaymentLogs In reply to
Anyone from Gossamer know how?

Last edited by:

rascal: Aug 24, 2005, 9:46 AM
Aug 24, 2005, 12:45 PM
brewt
Staff (4101 posts)
brewt's avatar
Aug 24, 2005, 12:45 PM
Post #4 of 6
Views: 2277
Shortcut
Quote Reply
Re: [rascal] PaymentLogs In reply to
The PaymentLogs table doesn't have all the information you need, so you probably want to use the Payments table. This should do it:
Code:
SELECT SUM(payments_amount) FROM lsql_Payments WHERE payments_status = 1 AND payments_start > 1104566400

Adrian
Aug 24, 2005, 11:37 PM
rascal
User (346 posts)
rascal's avatar
Aug 24, 2005, 11:37 PM
Post #5 of 6
Views: 2244
Shortcut
Quote Reply
Re: [brewt] PaymentLogs In reply to
Adrian ,

Thanks alot for helping me out, worked like a charm.

Is there a way to get the paypal transaction fees from Jan 01-05?
Aug 26, 2005, 9:45 AM
rascal
User (346 posts)
rascal's avatar
Aug 26, 2005, 9:45 AM
Post #6 of 6
Views: 2148
Shortcut
Quote Reply
Re: [rascal] PaymentLogs In reply to
Just bringing to the top.