[TEST] ToS

[Shin]

According to Ticket #400 I've developed a modification to include Term Of Service in the orderpanel. Each Hosting plan can have its own ToS.

SQL Table Modification

Code:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Struttura della tabella `hosting_plans`
--
CREATE TABLE IF NOT EXISTS `hosting_plans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `props` text COLLATE utf8_unicode_ci,
  `description` text COLLATE utf8_unicode_ci,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `setup_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(10) unsigned NOT NULL DEFAULT '0',
  `tos` blob NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Modified files

  tos.zip (Size: 17.5 KB / Downloads: 5)

OR

Patch

  termOfService.patch (Size: 10.61 KB / Downloads: 1)

You'll find ToS field in hosting plan add/edit page. It will be show in the order panel before purchase, under the security Code as you can see here


Since I've made a little tpl modification after the screenshot it can be different from the image

Please give me feedback/suggestion/etc...

Thanks

Shin

[RatS]

could you please create a patch against trunk? otherwise will it be problematic to integrate it into 1.0.5 if there are changes in the files you modified.

[FISA4]

i`ve tried it by the "modified files" way.

The SQL will not work because the table "hosting_plans" already exists.

PHP Code:

ALTER TABLE `hosting_plans` ADD `tos` BLOB NOT NULL ; 


is enough

Everything else is great work

Greets FISA4

[Shin]

on the trac there I've uploaded a proper patch (files+sql)