DNN Hosting Register Login
 
Latest Discussions Minimize
Furniture Showroom major crash by myearwood
Hi PengstenI sent you an email via service@bizmodules.net. It concerns the furni...
Top photos windows size restriction by OKCChopper
I have it so that i can restrict the size of the photos. However since some arn...
Users add photos by OKCChopper
Is there a way for users to add images to the correct album with out having acce...
Problem with locked folders/files by kimphamg
Hello, my DNN installation is under source control, and the scm software lock al...
An error has occurred. Error: is currently unavailable. by roocik
Hi,I'm trying to add several images to UMG 5 on my DNN 04.08.02. Some of them ca...
3d coursel problem by marbab
Hi,I just noticed that non-technical users are having problem in viewing picture...
UVG on sub portals? by coolvibe
I have UVG installed on my main portal (www.mywebsite.com) and on a sub portal (...
ShadowViewer doesnt load pictures/others do by mrhat
Hey there, we are running UMG 5.4 with the Generic Presentation Pack. Here is th...
How to change auto email texts? by jarra64
Hello,I would like to know how I can change the text of the auto-emails.Thanks
Added RSS album (Picasa) and cannot edit it. by rbarrow
I created a new album and added a Picasa RSS feed to it which works fine.  Howev...
Our Partnership Minimize
If you are looking for good DNN hosting, then PowerDNN is the best DNN host around!
Support Forum Minimize
Forums > Ultra Media Gallery > General Questions
Subject: Selling photo's via UMG 5
Prev Next
You are not authorized to post a reply.

Author Messages
Tony Harrison
Posts:26
Silver Member
01/25/2008 6:58 AM  
Can you please confirm the following:

It is only possible to setup 1 PayPal account for the module?

Therefore all sales go to that one account?

Is the sales information held in the database?
Could I produce a sales report showing which users had sold how many of which photo etc?

thanks
Pengtsen R
Posts:5177
01/25/2008 9:45 AM  
yes, only 1 paypal account.

sales info a stored in database. you can get such a report by a sql query.

thanks.
Pengtsen R
http://www.bizmodules.net
Mark Hollas
Posts:249
Site Administrator
01/26/2008 6:38 AM  

I also would like to report sales to users. If you have an SQL query to share, I would appreciate it very much.

Mark 
Pengtsen R
Posts:5177
01/26/2008 7:55 AM  
I wrote a sample query for you:


select II.InvoiceId, II.Price, I.UserId as BuyerID, I.PaymentDate , D.OriginalName as DownloadName, U.FirstName + ' ' + U.LastName as Creator from BizModules_UPG_InvoiceItem II inner join BizModules_UPG_Invoice I

on II.InvoiceId = I.Itemid

inner join BizModules_UPG_Download D

on II.DownloadId = D.ItemId

inner join Users U

on D.CreatedByUser = U.UserId

WHERE I.Finished = 1
Pengtsen R
http://www.bizmodules.net
You are not authorized to post a reply.
Forums > Ultra Media Gallery > General Questions > Selling photo's via UMG 5
Enterprise level DotNetNuke Solutions Copyright © 2005-2008 BizModules   |  Contact Us  |  Terms Of Use  |  Privacy Statement