Voucher Script / News: Recent posts

Recreate view: vwbrowse, vwcategoriesmerchantscodcounts
ALTER TABLE merchants ADD COLUMN cbtype ENUM('fixed','percentage') NOT NULL DEFAULT 'fixed' AFTER modified , ADD COLUMN cbvalue DECIMAL(10,2) NOT NULL DEFAULT 0.0 AFTER cbtype ;
ALTER TABLE cods ADD COLUMN cbtype ENUM('fixed','percentage') NOT NULL DEFAULT 'fixed' AFTER tag , ADD COLUMN cbvalue DECIMAL(10,2) NOT NULL DEFAULT 0.0 AFTER cbtype ;ALTER TABLE sysconfigurations ADD COLUMN editable TINYINT NOT NULL DEFAULT 0 AFTER dataval ;Recreate view Vwbrowse;
ALTER TABLE sites ADD COLUMN emailnoreply VARCHAR(255) NULL AFTER ctr , ADD COLUMN emailinfo VARCHAR(255) NULL AFTER emailnoreply , ADD COLUMN emailcontact VARCHAR(255) NULL AFTER emailinfo ;
ALTER TABLE pages ADD COLUMN layout VARCHAR(512) NOT NULL DEFAULT 'default' AFTER pagecontent , ADD COLUMN modified DATETIME NULL AFTER created ;
UPDATE pages SET modified = created;
ALTER TABLE pages ADD UNIQUE INDEX unique_page_site (site_id ASC, linkname(255) ASC) ;... read more

recreate view Vwbrowse;

• [CE] Optimization: Segregated Coupons and Vouchers as was earlier.
• [CE] Bug Fix: Vwbrowse::getTopCODsDataForIndexPage grouped by CODID to eliminate duplicate rows.
• [CE] Bug Fix: Vwbrowse::afterFind - added handling for count queries, singular results.
• [CE] Bug Fix: Vwbrowse - corrected joins.
• [CE] Optimization: Backoffice login.
• [CE] Added: Masked affiliate urls for codes, offers etc with intimation to user they are being redirected..
• [CE] Removed: Facebook authentication, will be added again in future in a better way..
• [CE] Optimizations: View counts now posted on page load asynchronously.
• [CE] Optimizations: Page render times (DOM Content loaded), improved by 500% (from 16+ seconds to 3-4 seconds) - non page content related requests now take < 1s.
• [CE] Added: View caching.

ALTER TABLE cods_locations CHANGE COLUMN cod_id cod_id INT(11) NOT NULL AFTER id;
ALTER TABLE cods ADD COLUMN tag VARCHAR(255) NULL AFTER generic_print_3, ADD INDEX index_tag (tag ASC) ;
INSERT INTO sysconfigurations (datakey,dataval,created) VALUES('CODS-TAGS','UNAVAILABLE','2012-05-24 16:34:00');
Recreate views vwcodssitesmerchants and vwlocaloffers

affiliate_url
MERAFFILIATEURL... read more

• revised query sytnax for linking of categories/merchants/cods to sites. It now uses replace to avoid inserting duplicate rows.

ALTER TABLE cods_sites ADD UNIQUE (
cod_id ,
site_id
)

ALTER TABLE categories_sites ADD UNIQUE (
category_id ,
site_id
)

ALTER TABLE merchants_sites ADD UNIQUE (
merchant_id ,
site_id
)

• Removed: linkcategorysite procedure and added the script to category model
• Bug Fix: categories, merchants and vouchers are now ordered alphabetically in back office.
• Bug Fix: Removed duplication of categories arising due to merging when creating merchants in back office.
• Removed: Routine deleteVoucher, merged into code.
• Removed: Routine deleteLocation, merged into code.
• Removed: Routine deleteMerchant, merged into code.
• Removed: Routine deleteUser, merged into code.
• Bug Fix: When adding merchants, removed merged categories.
• Bug Fix: When editing merchants, valid categories are now listed.
• Added: Multiple Languages now supported.

-- Added: generic text fields 1,2 and 3 for print voucher templates to cods
ALTER TABLE cods ADD COLUMN generic_print_1 TEXT NULL AFTER custom_cod_img_url , ADD COLUMN generic_print_2 TEXT NULL AFTER generic_print_1 , ADD COLUMN generic_print_3 TEXT NULL AFTER generic_print_2 ;

-- Added: generic merchant address1, address2, phone number1, phone number2, phone number3 fields
ALTER TABLE merchants ADD COLUMN address1 TEXT NULL AFTER metatitle , ADD COLUMN address2 TEXT NULL AFTER address1 , ADD COLUMN phone1 VARCHAR(45) NULL AFTER address2 , ADD COLUMN phone2 VARCHAR(45) NULL AFTER phone1 , ADD COLUMN phone3 VARCHAR(45) NULL AFTER phone2 ;... read more

+ Bug Fix - Registration window did not accept email addresses with a period.
+ Tweet support added in controller and model for vouchers (for future use),
"tweetcount" column added in "cods" table, tweetcount column added to queries
of mysql views.
+ Log error message on 0 (zero) import items for IcodesUK and IcodesUS.
+ Added cods_custom_image_url column to cods for specification of custom images next to vouchers,
if no image url is provided then merchant's logo is used
+ Numerous other fixes here and there.

DVS 4.0 beta has been released and comes with exciting new enhancements including support for multiple sites/affilinet/adility offers db/icodesUS & US and much more.

Someone reported today that changing password in admin for release 3.0.1 gives an error saying "This feature is not supported in demo version"

We are sorry about this as this has erroneously found it's way into the general public and is not meant to be.

We will be releasing a patch in 12 hours to address this issue.

This release contains minor bug fixes and major French translation update (Thanks to Thierry Paulme)

- Date format fixed according language change.
- Product Image in Product is fixed
- Fixed the problem of Categories page.
- Many Thanks to Thierry Paulme for sending in the French Translation.

We know it took too long as opposed to the release date we promised earlier but we promise you won't be disappointed with this new release!
DVS now supports multiple languages through a click of a button as well as support for affilinet and many bug fixes.

Details in forum https://sourceforge.net/projects/voucherscript/forums/forum/1141235/topic/3746029

Plugin now available for download. Allows multiple wordpress sites to link to the primary DVS site providing an excellent back link building.

http://www.voucherscript.com/wardrobe.html

(With many thanks to bazzais for his contribution)

With the integration of V2 API, v1 has been obsoleted in DVS.

DVS now supports iCodes USA service. For more information on iCodes please visit http://www.icodes-us.com/

We are in the process of adding multi language support to DVS which will make it so easy a baby would change the site's language!!

HELP NEEDEDFOR TRANSLATIONS, please email us at translate@voucherscript.com if you are willing to help.

Checkout the release dates thread for details.

Stay up to date with what's coming your way via the release dates forum thread https://sourceforge.net/projects/voucherscript/forums/forum/1141235