Tech25
11-29-2006, 02:16 PM
Hi all!
I'm requesting a quote for custom work because I am tired of having my project(s)on hold while I wait for replies from support.
I am willing to pay because I have this error ( below) with Sponsored.php and I need it fixed:
Error: Unknown column 'link.sponsored_notif_sent' in 'where clause'
SELECT `link`.*, `cat`.`path`, `cat`.`id` `id_category`, `plan`.`cost` `plan_cost`, `link`.`sponsored_start` + INTERVAL `plan`.`period` DAY `sponsored_end` FROM `dir_links` `link` LEFT JOIN `dir_plans` `plan` ON `link`.`sponsored_plan_id` = `plan`.`id` LEFT JOIN `dir_link_categories` `l_c` ON `link`.`id` = `l_c`.`id_link` LEFT JOIN `dir_categories` `cat` ON `l_c`.`id_category` = `cat`.`id` WHERE `link`.`sponsored` = '1' AND `link`.`sponsored_start` + INTERVAL `plan`.`period` DAY - INTERVAL 1 DAY < NOW() AND `link`.`sponsored_notif_sent` = '0' AND `l_c`.`crossed` = '0'
what would it cost me to:
Have this error fixed and/or
have a mod developed that :
logs submission dates and expiry dates of paid links to the database
checks the dates on paid links
locates the ones that have met or passed their expiry date for paid features ( eg a 30 day sponsored listing)
flags these listings and sets the link status to "expired" in the manage listings page so that I can tell which ones need to be renewed. and which are fresh paid submissions. ( expired = needs/pending renewal, suspended = new paid link waiting for approval)
sets display attributes of expired links to those of a regular unpaid, featureless, boring old listing instead of hiding or removing the listing from displaying in the link display page (which is what suspended currently seems to do). IF a link's sponsor status expires I do NOT want it removed from displaying but DO wish for the pretty colors and thumbnail previews to be disabled until the link is renewed.I would also like someone to verify that the crons are actually doing what they are supposed to as things do NOT seem to be updating properly, known broken link aren't being flagged as broken, known bad recip links aren't being flagged as bad etc etc
A quote on this would be greatly appreciated because I have a couple projects that are tied in with this directory plan and everything is on hold until this is working proper and as I require. I am SOOOOO close!
thanks much!
Roy H.
I'm requesting a quote for custom work because I am tired of having my project(s)on hold while I wait for replies from support.
I am willing to pay because I have this error ( below) with Sponsored.php and I need it fixed:
Error: Unknown column 'link.sponsored_notif_sent' in 'where clause'
SELECT `link`.*, `cat`.`path`, `cat`.`id` `id_category`, `plan`.`cost` `plan_cost`, `link`.`sponsored_start` + INTERVAL `plan`.`period` DAY `sponsored_end` FROM `dir_links` `link` LEFT JOIN `dir_plans` `plan` ON `link`.`sponsored_plan_id` = `plan`.`id` LEFT JOIN `dir_link_categories` `l_c` ON `link`.`id` = `l_c`.`id_link` LEFT JOIN `dir_categories` `cat` ON `l_c`.`id_category` = `cat`.`id` WHERE `link`.`sponsored` = '1' AND `link`.`sponsored_start` + INTERVAL `plan`.`period` DAY - INTERVAL 1 DAY < NOW() AND `link`.`sponsored_notif_sent` = '0' AND `l_c`.`crossed` = '0'
what would it cost me to:
Have this error fixed and/or
have a mod developed that :
logs submission dates and expiry dates of paid links to the database
checks the dates on paid links
locates the ones that have met or passed their expiry date for paid features ( eg a 30 day sponsored listing)
flags these listings and sets the link status to "expired" in the manage listings page so that I can tell which ones need to be renewed. and which are fresh paid submissions. ( expired = needs/pending renewal, suspended = new paid link waiting for approval)
sets display attributes of expired links to those of a regular unpaid, featureless, boring old listing instead of hiding or removing the listing from displaying in the link display page (which is what suspended currently seems to do). IF a link's sponsor status expires I do NOT want it removed from displaying but DO wish for the pretty colors and thumbnail previews to be disabled until the link is renewed.I would also like someone to verify that the crons are actually doing what they are supposed to as things do NOT seem to be updating properly, known broken link aren't being flagged as broken, known bad recip links aren't being flagged as bad etc etc
A quote on this would be greatly appreciated because I have a couple projects that are tied in with this directory plan and everything is on hold until this is working proper and as I require. I am SOOOOO close!
thanks much!
Roy H.