#
# Table structure for table 'idx_email_template'
#
DROP TABLE IF EXISTS `idx_email_template`;
CREATE TABLE `idx_email_template` (
`email_template_id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) default NULL,
`subject` varchar(255) default NULL,
`body` text,
`altbody` text,
PRIMARY KEY (`email_template_id`)
);
#
# Dumping data for table 'idx_email_template'
#
insert into `idx_email_template`(`email_template_id`,`name`,`subject`,`body`,`altbody`) values (1,'add_ok','Resource Added','
Thank you for your submission to <%$site_name%>
\r\n
\r\n
Resource ID
\r\n
:
\r\n
<%$link_id%>
\r\n
Title
\r\n
:
\r\n
<%$title%>
\r\n
Url
\r\n
:
\r\n
<%$url%>
\r\n
Description
\r\n
:
\r\n
<%$description%>
\r\n
Category
\r\n
:
\r\n
<%$category%>
\r\n
Contact name
\r\n
:
\r\n
<%$contact_name%>
\r\n
Email
\r\n
:
\r\n
<%$email%>
\r\n
Password
\r\n
:
\r\n
<%$password%>
\r\n
\r\nYour link has been added.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n','Thank you for your submission to <%$site_name%>\r\nResource ID : <%$link_id%>\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nPassword : <%$password%>\r\nYour link has been added.\r\nRegards,\r\n<%$site_name%> Team'),(2,'add_ok_editor','Resource Added','
\r\nThere\'s a new submission to <%$site_name%>.\r\n
\r\n
\r\n
\r\n
Resource ID
:
<%$link_id%>
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email/td>
:
<%$email%>
\r\n
\r\n
\r\nThe category permissions allow webmasters to add/modify links without needing approval.\r\nThe link has been added.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','There\'s a new submission to <%$site_name%>.\r\nResource ID : <%$link_id%>\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without needing approval.\r\nThe link has beed added.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(3,'add_ok_subscriber','Resource Added','
\r\nYou are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\n
\r\nThere\'s a new submission to <%$site_name%>.\r\n
\r\n
\r\n
Resource ID
:
<%$link_id%>
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThere\'s a new submission to <%$site_name%>.\r\nResource ID : <%$link_id%>\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(4,'add_pending','Pending Resource','
\r\nThank you for your submission to <%$site_name%>.\r\n
\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email
:
<%$email%>
\r\n
\r\n
\r\n
\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Thank you for your submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(5,'add_pending_editor','Pending Resource','
\r\nThere\'s a new submission to <%$site_name%>.\r\n
\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email
:
<%$email%>
\r\n
\r\n
\r\n
\r\nYou need to review this link here: \r\n\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
\r\n','There\'s a new submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nYou need to review this link here:\r\n<%$site_url%>/cp/editor_link_validate.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(6,'approved','Editor Approved.','
\r\nYour submission at <%$site_name%> has been approved.\r\n
\r\n
\r\n
Resource ID
:
<%$link_id%>
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email
:
<%$email%>
\r\n
Password
:
<%$password%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Your submission at <%$site_name%> has been approved.\r\nResource ID : <%$link_id%>\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nPassword : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(7,'approved_editor','Link approved','
\r\nThe following submission has been approved.\r\n
\r\n
\r\n
Resource ID
:
<%$link_id%>
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email
:
<%$email%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','The following submission has been approved.\r\nResource ID : <%$link_id%>\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(8,'approved_subscriber','link_approved','
\r\nYou are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\n
\r\nThe following submission has been approved.\r\n
\r\n
\r\n
Resource ID
:
<%$link_id%>
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThe following submission has been approved.\r\nResource ID : <%$link_id%>\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(9,'bad_link_editor','Broken link report','
\r\nThere\'s a new bad link report submission to <%$site_name%>.\r\n
','There\'s a new bad link report submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nName : <%$r_name%>\r\nEmail : <%$r_email%>\r\nError type : <%$type_val%>\r\nThis report has been added in your administrator area.\r\nPlease review this report here:\r\n<%$site_url%>/admin/link_bad.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(10,'become_editor_approved','Editor Approved.','
\r\nYour request to become an editor at <%$site_name%> has been approved.\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Name
:
<%$name%>
\r\n
Email
:
<%$email%>
\r\n
Category
:
<%$category%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Your request to become an editor at <%$site_name%> has been approved.\r\nUsername : <%$username%>\r\nName : <%$name%>\r\nEmail : <%$email%>\r\nCategory : <%$category%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(11,'become_editor_pending','Request to become an editor','
\r\nThank you for your request to become an editor at <%$site_name%>.\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Name
:
<%$name%>
\r\n
Email
:
<%$email%>
\r\n
Category
:
<%$category%>
\r\n
\r\n
\r\nYour request will be processed soon.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Thank you for your request to become an editor at <%$site_name%>.\r\nUsername : <%$username%>\r\nName : <%$name%>\r\nEmail : <%$email%>\r\nCategory : <%$category%>\r\nYour request will be processed soon.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(12,'become_editor_pending_admin','Request to become an editor','
\r\nThere\'s a new request to become an editor at <%$site_name%>.\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Name
:
<%$name%>
\r\n
Email
:
<%$email%>
\r\n
Category
:
<%$category%>
\r\n
\r\n
\r\nPlease review editor request here:\r\n \r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','There\'s a new request to become an editor at <%$site_name%>.\r\nUsername : <%$username%>\r\nName : <%$name%>\r\nEmail : <%$email%>\r\nCategory : <%$category%>\r\nPlease review editor requests here:\r\n<%$site_url%>/admin/index.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(13,'become_editor_rejected','Editor Rejected.','
\r\nYour request to become an editor at <%$site_name%> has been rejected.\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Name
:
<%$name%>
\r\n
Email
:
<%$email%>
\r\n
Category
:
<%$category%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Your request to become an editor at <%$site_name%> has been rejected.\r\nUsername : <%$username%>\r\nName : <%$name%>\r\nEmail : <%$email%>\r\nCategory : <%$category%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(14,'inv_ask_payment','<%$company%>, Invoice #<%$invoice_id%>','
\r\nAn invoice has been created, and is available for viewing at the following URL: \r\n\r\n
\r\nIf you should have any questions, please do not hesitate to contact us. \r\nThank you for your business.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','An invoice has been created, and is available for viewing at the following URL:\r\n<%$site_url%>/invoice.php?id=<%$invoice_id%>\r\nIf you should have any questions, please do not hesitate to contact us.\r\nThank you for your business.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(15,'mailing_list_sub','Mailing list subscription','
\r\nThank you. Your email address, <%$email%> has been added to our mailing list.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Thank you. Your email address, <%$email%> has been added to our mailing list.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(16,'mailing_list_sub_confirm','Mailing list validation code','
\r\nWe received your subscription request onto our mailing list. \r\nPlease confirm your subscription here: \r\n\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','We received your subscription request onto our mailing list.\r\nPlease confirm your subscription here:\r\n<%$confirm_url%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(17,'modify_ok','Resource Modified','
\r\nThank you for your submission to <%$site_name%>.\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email/td>
:
<%$email%>
\r\n
\r\n
\r\nYour link has been changed.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Thank you for your submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nYour link has been changed.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(18,'modify_ok_editor','Resource Modified','
\r\nThere\'s a new submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without approval.\r\nThe link has been modified.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','There\'s a new submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nThe category permissions allow webmasters to add/modify links without approval.\r\nThe link has been modified.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(19,'modify_ok_subscriber','Resource Modified','
\r\nYou are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\n
\r\nThere\'s a new submission to <%$site_name%>.\r\n
\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','You are receiving this email because you have a subscription for update notifications in <%$category%> category.\r\nThere\'s a new submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(20,'modify_pending','Resource Modified','
\r\nThank you for your submission to <%$site_name%>.\r\n
\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email
:
<%$email%>
\r\n
\r\n
\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Thank you for your submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nYour link will be reviewed by our team. We will contact you as soon \r\nas we have reviewed your link.\r\nRegards,\r\n<%$site_name%> Team\r\n'),(21,'modify_pending_editor','Resource Modified','
\r\nThere\'s a new submission to <%$site_name%>.\r\n
\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email
:
<%$email%>
\r\n
\r\n
\r\n
\r\nYou need to review this link here: \r\n\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
\r\n','There\'s a new submission to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nYou need to review this link here:\r\n<%$site_url%>/cp/editor_link_validate.php\r\nRegards,\r\n<%$site_name%> Team\r\n'),(22,'register_confirm','Registration','
\r\nThanks for joining <%$site_name%>.\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Password
:
<%$password%>
\r\n
\r\n
\r\n
\r\nPlease confirm your registration here: \r\n\r\n
\r\n
\r\nSincerely,\r\n
\r\n<%$site_name%> Team\r\n
','Thanks for joining <%$site_name%>.\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nPlease confirm your registration here:\r\n<%$site_url%>/register.php?u=<%$username%>&v=<%$vcode%>&pflag=cf\r\nSincerely,\r\n<%$site_name%> Team\r\n'),(23,'register_ok','Registration','
\r\nThanks for joining <%$site_name%>.\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Password
:
<%$password%>
\r\n
\r\n
\r\nSincerely,\r\n
\r\n
\r\n<%$site_name%> Team\r\n
','Thanks for joining <%$site_name%>.\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nSincerely,\r\n<%$site_name%> Team\r\n'),(24,'rejected','Your submission has been rejected','
\r\nYour submission has been rejected. \r\nThis may be caused by one of the following reason:\r\n
\r\n
\r\n
adult material
\r\n
the site is under construction
\r\n
the topic is not related with our directory
\r\n
\r\n\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email/td>
:
<%$email%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Your submission has been rejected.\r\nThis may caused by one of the following reasons:\r\n- adult material\r\n- the site is under construction\r\n- the topic is not related with our directory\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(25,'rejected_editor','Link rejected','
\r\nThe following submission has been rejected.\r\n
\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
Contact name
:
<%$contact_name%>
\r\n
Email
:
<%$email%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
\r\n','The following submission has been rejected.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nContact name : <%$contact_name%>\r\nEmail : <%$email%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(26,'review_pending_editor','Pending Review','
\r\nThere\'s a new review to <%$site_name%>.\r\n
\r\n
\r\n
Title
:
<%$title%>
\r\n
Url
:
<%$url%>
\r\n
Description
:
<%$description%>
\r\n
Category
:
<%$category%>
\r\n
\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Subject
:
<%$rev_subject%>
\r\n
Rating
:
<%$rev_rating%>
\r\n
Review
:
<%$rev_review%>
\r\n
\r\n
\r\n
\r\nPlease review it here: \r\n\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
\r\n','There\'s new review to <%$site_name%>.\r\nTitle : <%$title%>\r\nUrl : <%$url%>\r\nDescription : <%$description%>\r\nCategory : <%$category%>\r\nUsername : <%$username%>\r\nSubject : <%$rev_subject%>\r\nRating : <%$rev_rating%>\r\nReview : <%$rev_review%>\r\nPlease review it here:\r\n<%$site_url%>/cp/\r\nRegards,\r\n<%$site_name%> Team\r\n'),(27,'send_pwd_link','Your resource password','
\r\nHere is your password for <%$title%> (\"><%$url%>)\r\n
\r\nPassword : <%$password%>\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Here is your password for <%$title%> (<%$url%>)\r\nPassword : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(28,'send_pwd_login','Your login password','
\r\nHere is your username and password:\r\n
\r\n
\r\n
Username
:
<%$username%>
\r\n
Password
:
<%$password%>
\r\n
\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Here is your username and password:\r\nUsername : <%$username%>\r\nPassword : <%$password%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(29,'send_pwd_reset','Password reset request','
\r\nWe received a request to reset your password. \r\nPlease visit this URL to proceed: \r\n\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','We received a request to reset your password.\r\nPlease visit this URL to proceed:\r\n<%$site_url%>/reset_pwd.php?u=<%$username%>&hash=<%$hash%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(30,'suggest_category','Category suggestion','
\r\nCategory suggestion for <%$site_name%>.\r\n
\r\nParent : <%$parent%>\r\nCategory Name : <%$cat_name%>\r\nCategory Description : <%$cat_desc%>\r\n
\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
','Category suggestion for <%$site_name%>.\r\nParent : <%$parent%>\r\nCategory Name : <%$cat_name%>\r\nCategory Description : <%$cat_desc%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),(31,'tell_friend_favorite','Your friend has shared his/her favorite listing','
\r\nHi <%$friend_name%>,\r\n
\r\nI\'d like to share my favorite listing at <%$site_name%> (\"><%$site_url%>). \r\nI hope you like them and find them useful.\r\n
\r\n
\r\n<%$fav_item%>\r\n
\r\n
\r\nSincerely,\r\n
\r\n
\r\n<%$my_name%> <<%$my_email%>>\r\n
','Hi <%$friend_name%>,\r\nI\'d like to share my favorite listings at <%$site_name%> (<%$site_url%>).\r\nI hope you like them and find them useful.\r\n<%$fav_item%>\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(32,'tell_friend_favorite_rows',NULL,'
\r\nI found a good website that you may find interesting.\r\n
\r\n
\r\n\r\n
\r\n
\r\n\r\n
\r\n
\r\nI found this website from <%$site_name%> (\"><%$site_url%>).\r\n
\r\n
\r\nSincerely,\r\n
\r\n<%$my_name%> <<%$my_email%>>\r\n
\r\n','Hi <%$friend_name%>,\r\nI found a good website that you may find interesting.\r\nWebsite : <%$title%>\r\nUrl : <%$url%>\r\nI found this website from <%$site_name%> (<%$site_url%>).\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n'),(34,'tell_friend_website','hi <%$friend_name%>, I found a good website that you may find interesting','
\r\nHi <%$friend_name%>,\r\n
\r\nI found good website that you may find interesting. The website is <%$site_name%> (\"><%$site_url%>).\r\n
\r\n
\r\nSincerely,\r\n
\r\n<%$my_name%> <<%$my_email%>>\r\n
','Hi <%$friend_name%>,\r\nI found a good website that you may find interesting. The website is <%$site_name%> (<%$site_url%>).\r\nSincerely,\r\n<%$my_name%> <<%$my_email%>>\r\n');
alter table `idx_payment_history` change `username` `contact_name` varchar(255) default NULL;
alter table `idx_payment_history` add `email` varchar(255) default NULL after `contact_name`;
alter table `idx_payment_history` add `invoice_id` varchar(10) default NULL after `time`;
#
# Table structure for table 'idx_discount_coupon'
#
DROP TABLE IF EXISTS idx_discount_coupon;
CREATE TABLE `idx_discount_coupon` (
`coupon_id` int(11) NOT NULL auto_increment,
`coupon_code` varchar(255) default NULL,
`coupon_value` varchar(50) default NULL,
`link_type` varchar(255) default NULL,
`start_date` date default NULL,
`expired_date` date default NULL,
`expired_usage` int(11) default NULL,
`usage_count` int(11) default NULL,
PRIMARY KEY (`coupon_id`)
);
DROP TABLE IF EXISTS idx_category_suggession;
CREATE TABLE `idx_category_suggession` (
`id_cat_suggession` int(11) NOT NULL auto_increment,
`parent_id` int(11) default NULL,
`name` varchar(255) default NULL,
`category_description` text ,
`date` datetime default NULL,
PRIMARY KEY (`id_cat_suggession`)
);
CREATE TABLE `idx_plugin` (
`plugin_id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`plugin_file` varchar(255) default NULL,
`status` enum('0','1') default NULL,
`option_plugin` text,
PRIMARY KEY (`plugin_id`)
);
alter table `idx_link` change `hits` `hits` mediumint(9) NOT NULL default '0';
CREATE TABLE IF NOT EXISTS `idx_default_field` (
`field_name` varchar(64) NOT NULL,
`required` char(1) NOT NULL,
`visible` char(1) NOT NULL default '1',
`searchable` char(1) NOT NULL default '1'
);
INSERT INTO `idx_default_field` (`field_name`, `required`, `visible`, `searchable`) VALUES
('title', '1', '1', '1'),
('url', '1', '1', '1'),
('description', '1', '1', '1'),
('keywords', '1', '1', '0'),
('contact_name', '1', '1', '1'),
('email', '1', '1', '1'),
('reciprocal_url', '0', '1', '1');
CREATE TABLE IF NOT EXISTS `idx_cronjobs` (
`cronjobs_id` int(11) NOT NULL auto_increment,
`cronjobs_name` varchar(255) default NULL,
`filename` varchar(255) NOT NULL,
`schedule` varchar(255) NOT NULL,
`time` datetime NOT NULL,
`execution` varchar(1) NOT NULL,
PRIMARY KEY (`cronjobs_id`)
);
INSERT INTO `idx_cronjobs` (`cronjobs_id`, `cronjobs_name`, `filename`, `schedule`, `time`, `execution`) VALUES
(1, NULL, 'clear_templates_c.php', '1,*,*,*,*', '0000-00-00 00:00:00', ''),
(2, NULL, 'update_tag_cloud.php', '*,24,*,*,*', '0000-00-00 00:00:00', ''),
(3, NULL, 'clear_rss_cache.php', '*,24,*,*,*', '0000-00-00 00:00:00', '');
INSERT INTO `idx_email_template` (`email_template_id`, `name`, `subject`, `body`, `altbody`) VALUES
(35, 'send_activation_link', 'Your activation link', '
', 'Here is your activation link\r\nActivation Link : <%$activation_link%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),
(36, 'send_activated_account', 'Your account had been activated', '
\r\nYour account had been activated. Now you can login.\r\n
\r\nRegards,\r\n
\r\n<%$site_name%> Team\r\n
', 'Your account had been activated. Now you can login.\r\n\r\nRegards,\r\n<%$site_name%> Team\r\n');
ALTER TABLE `idx_custom_field` CHANGE `field_type` `field_type` ENUM( 'TEXT', 'TEXTAREA', 'SELECT', 'MULTISELECT', 'CHECKBOX', 'RADIO', 'FILE', 'IMAGE', 'DATE', 'DATETIME', 'RICHEDITOR' ) NOT NULL DEFAULT 'TEXT';