DNN Hosting Register Login
 
Latest Discussions Minimize
How Could I Insert a Custom Swap Image for Non-Flash Browsers? by RegGFX
I have a situation where some (because of security concerns)do not allow ActiveX...
what is mean by Online video conversion ? by marbab
I have read the home page. Its written under UVG that we can do 'Online video co...
How to Simplify Personal Gallery? by blob150
I am using UMG 5.3 intergated with Smart-Thinker User Profile.  I have a page se...
Video Size Problem by arshad786
Hi,     I am Arshad , i am trying to play video in my dnn site, but the problem ...
Configuration Error by koolexposure
I received this error on the last step of the Configuration Wizard. I have came ...
Serial Number by abudist
Hi, I have sent you emails regarding serial number for UVG. I'm stil waiting ...
Screenshot Capture Not Working by chadw3
Hello,I am using UVG 2.0 and am trying to use the Capture control in Edit Video ...
User uploads by OKCChopper
I have it set up so that regestered users can upload photos. I do not have a di...
Applying Watermark picture to existing images by Simone
I have recently upgraded to UMG 5.3 and after uploading some photos, I discovere...
Player auto plays select video? Not working by mg3hockey
Hello All,I am trying to get my player to  auto play a select video of several I...
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 > Suggestions and Ideas
Subject: Default price
Prev Next
You are not authorized to post a reply.

Author Messages
John Endean
Posts:13
Silver Member
01/30/2008 4:19 AM  
Hi,

I think it would be really useful to have a default price for items added to an album, so that when multiple items are synchronized or uploaded, they are automatically available for sale at this default price.  At the moment, if you upload 200 pix you have to go through and edit the price manually - takes too long!

Thanks,
John
Pengtsen R
Posts:5433
01/30/2008 7:08 AM  
you can write a sql trigger to do this job. if the price is zero then the trigger applys a default price.
Pengtsen R
http://www.bizmodules.net
John Endean
Posts:13
Silver Member
01/30/2008 7:17 AM  

Thanks for that, any chance of an example script?

John
Pengtsen R
Posts:5433
01/30/2008 7:39 AM  
I remember some one have an example, if anybody have this script please post it here.

if you didn't get it I'll write it for you when I get back - I'm going for a short travel 8 hours later.

thanks.
Pengtsen R
http://www.bizmodules.net
John Endean
Posts:13
Silver Member
02/05/2008 4:12 AM  
Hi,

Could you please post the SQL script for this trigger?

Many thanks,
John
Pengtsen R
Posts:5433
02/06/2008 7:18 PM  
I didn't write trigger for years, I use sql server help to write this simple trigger:

CREATE trigger UMG_ApplyDefaultPrice
on BizModules_UPG_Download
after insert
as

declare @price money
declare @itemid int
select @itemid=i.Itemid, @price = isnull(i.Price, 0) from inserted i inner join BizModules_UPG_Download D on I.ItemId=D.ItemId
if @price = 0
update BizModules_UPG_Download set price = YOUR_DEFAULT_PRICE_GOES_HERE where itemid=@itemid
Pengtsen R
http://www.bizmodules.net
John Endean
Posts:13
Silver Member
02/07/2008 12:51 PM  
That worked a treat, thanks!
Pengtsen R
Posts:5433
02/07/2008 6:23 PM  
great.
Pengtsen R
http://www.bizmodules.net
You are not authorized to post a reply.
Forums > Ultra Media Gallery > Suggestions and Ideas > Default price
Enterprise level DotNetNuke Solutions Copyright © 2005-2008 BizModules   |  Contact Us  |  Terms Of Use  |  Privacy Statement