+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Contributions Area (/forum-40.html)
+--- Forum: Enhancements (/forum-43.html)
+--- Thread: [TEST] ToS (/thread-9643.html)
[TEST] ToS - Shin - 02-17-2010 02:47 AM
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
[attachment=1153]
OR
Patch
[attachment=1155]
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
![[Image: screenshot006n.png]](http://img715.imageshack.us/img715/7529/screenshot006n.png)
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
RE: [TEST] ToS - RatS - 02-17-2010 03:01 AM
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.
RE: [TEST] ToS - FISA4 - 02-19-2010 10:00 AM
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
RE: [TEST] ToS - Shin - 02-19-2010 05:45 PM
on the trac there I've uploaded a proper patch (files+sql)