API tools faq
paste
Guest User

Untitled

a guest
Oct 19th, 2018
166
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.03 KB | None | 0 0
raw download clone embed print report
  1.  
  2. /** INDEXU 7.1 **/
  3.  
  4. update `lep_config` set `value`='7.1' where `name`='version';
  5.  
  6. ALTER TABLE `lep_resource` ADD `ar_number_votes` INT NOT NULL default 0 AFTER `user_id` ,
  7. ADD `ar_total_points` INT NOT NULL default 0 AFTER `ar_number_votes` ,
  8. ADD `ar_dec_avg` DOUBLE NOT NULL default 0 AFTER `ar_total_points` ,
  9. ADD `ar_whole_avg` INT NOT NULL default 0 AFTER `ar_dec_avg`;
  10.  
  11. CREATE TABLE `lep_ajax_rating` (`res_id` INT NOT NULL, `ip` CHAR(100) NOT NULL, `rating` INT NOT NULL, PRIMARY KEY (`res_id`, `ip`));
  12.  
  13. INSERT INTO `lep_amenu` (
  14. `amenu_id` ,
  15. `parent_id` ,
  16. `name` ,
  17. `title` ,
  18. `url` ,
  19. `order_num` ,
  20. `sp`
  21. )
  22. VALUES (
  23. NULL , '3', 'user_pending', 'Pending', 'user.php?act=pending', '30', '0'
  24. );
  25.  
  26. delete from lep_email_template where email_template_id = '14';
  27.  
  28. INSERT INTO `lep_email_template` (`email_template_id`, `name`, `type`, `subject`, `body`) VALUES(14, 'new_user_registration', 'user_notification', 'Your registration at {DIR_NAME}', 'Dear {USER_USERNAME},\r\n\r\nThank you for your registration at {DIR_NAME}. Your login details are as follows:\r\n\r\nUsername: {USER_USERNAME}\r\n\r\n{DIR_NAME}\r\n{DIR_URL}');
  29.  
  30. INSERT INTO `lep_amenu` (`amenu_id`, `parent_id`, `name`, `title`, `url`, `order_num`, `sp`) VALUES (NULL, '1', 'cat_search', 'Search', 'category.php?act=search', '15', '0');
  31.  
  32. INSERT INTO `lep_amenu` (`amenu_id`, `parent_id`, `name`, `title`, `url`, `order_num`, `sp`) VALUES (NULL, '2', 'link_search', 'Search', 'link.php?act=search', '15', '0');
  33.  
  34. INSERT INTO `lep_amenu` (`amenu_id`, `parent_id`, `name`, `title`, `url`, `order_num`, `sp`) VALUES (NULL, '3', 'user_search', 'Search', 'user.php?act=search', '15', '0');
  35.  
  36. ALTER TABLE `lep_widget_placement` ADD `status` CHAR( 1 ) NULL;
  37.  
  38. update `lep_widget_placement` set status = '1';
  39.  
  40. CREATE TABLE `lep_inquiry` (
  41. `inquiry_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  42. `res_id` int(11) DEFAULT NULL,
  43. `name` varchar(255) DEFAULT NULL,
  44. `email` varchar(255) DEFAULT NULL,
  45. `subject` varchar(255) DEFAULT NULL,
  46. `inquiry` varchar(255) DEFAULT NULL,
  47. `created_at` char(10) DEFAULT NULL,
  48. PRIMARY KEY (`inquiry_id`)
  49. );
  50.  
  51. INSERT INTO `lep_page` (`page_id`, `name`, `filename`, `position`, `order_num`, `option`, `page_title`, `meta_keywords`, `meta_description`) VALUES(NULL, 'Inquiry Page', 'inquiry.php', 'main', 100, 'show_title=1&title=Inquiry+form&html_class_suffix=', 'Inquiry', '', '');
  52. INSERT INTO `lep_page` (`page_id`, `name`, `filename`, `position`, `order_num`, `option`, `page_title`, `meta_keywords`, `meta_description`) VALUES(NULL, 'User Panel / Inquiry List', 'usercp/inquiry_list.php', 'main', 100, 'il_visible=1&il_show_title=1&il_title=Inquiry+List&il_nrows=10&il_template=inquiry_list.php&il_html_class_suffix=', 'Inquiries', '', '');
  53.  
  54. INSERT INTO `lep_amenu` (`amenu_id`, `parent_id`, `name`, `title`, `url`, `order_num`, `sp`) VALUES
  55. (NULL, 0, 'inquiry', 'Inquiries', 'inquiry.php', '45', '0');
  56.  
  57. ALTER TABLE `lep_resource_temp` ADD `address` VARCHAR( 255 ) NULL AFTER `user_id` ,
  58. ADD `city` VARCHAR( 255 ) NULL AFTER `address` ,
  59. ADD `state` VARCHAR( 255 ) NULL AFTER `city` ,
  60. ADD `zip` VARCHAR( 255 ) NULL AFTER `state` ,
  61. ADD `country` VARCHAR( 255 ) NULL AFTER `zip`;
  62.  
  63. ALTER TABLE `lep_resource_temp` ADD `submit_code` VARCHAR( 255 ) NULL AFTER `user_id`;
  64.  
  65. ALTER TABLE `lep_resource_temp` ADD `ar_number_votes` INT NULL AFTER `user_id` ,
  66. ADD `ar_total_points` INT NULL AFTER `ar_number_votes` ,
  67. ADD `ar_dec_avg` DOUBLE NULL AFTER `ar_total_points` ,
  68. ADD `ar_whole_avg` INT NULL AFTER `ar_dec_avg` ,
  69. ADD `ss_googlepr` VARCHAR( 255 ) NULL AFTER `ar_whole_avg` ,
  70. ADD `ss_alexarank` VARCHAR( 255 ) NULL AFTER `ss_googlepr` ,
  71. ADD `ss_google_indexed` VARCHAR( 255 ) NULL AFTER `ss_alexarank` ,
  72. ADD `ss_yahoo_indexed` VARCHAR( 255 ) NULL AFTER `ss_google_indexed` ,
  73. ADD `ss_msn_indexed` VARCHAR( 255 ) NULL AFTER `ss_yahoo_indexed` ,
  74. ADD `ss_google_linkback` VARCHAR( 255 ) NULL AFTER `ss_msn_indexed` ,
  75. ADD `ss_yahoo_linkback` VARCHAR( 255 ) NULL AFTER `ss_google_linkback` ,
  76. ADD `ss_last_update` CHAR( 10 ) NULL AFTER `ss_yahoo_linkback` ,
  77. ADD `vote` INT NULL AFTER `ss_last_update`;
  78.  
  79. ALTER TABLE `lep_resource_temp` ADD `reciprocal_url` VARCHAR( 255 ) NULL AFTER `vote` ,
  80. ADD `last_checked_online` CHAR( 10 ) NULL AFTER `reciprocal_url` ,
  81. ADD `last_checked_reciprocal` CHAR( 10 ) NULL AFTER `last_checked_online` ,
  82. ADD `online` CHAR( 1 ) NULL AFTER `last_checked_reciprocal` ,
  83. ADD `reciprocal` CHAR( 1 ) NULL AFTER `online`;
  84.  
  85. UPDATE `lep_widget_placement` SET `status` = '0' WHERE `lep_widget_placement`.`widget_placement_id` =43;
  86.  
  87. /** INDEXU 7.2 **/
  88.  
  89. update `lep_config` set `value`='7.2' where `name`='version';
  90.  
  91. INSERT INTO `lep_email_template` VALUES(null, 'new_inquiry', 'user_notification', 'New inquiry at {DIR_NAME}', 'We have receive a new inquiry for your listing at {DIR_NAME}.\r\n\r\n=====================================================\r\nListing ID: {RES_ID}\r\nListing Title: {RES_TITLE}\r\n\r\nInquiry Date: {DATE}\r\nFrom: {FROM}\r\nEmail: {EMAIL}\r\nSubject: {SUBJECT} \r\n\r\nInquiry detail:\r\n{INQUIRY}\r\n\r\n=====================================================\r\n\r\n\r\nThank you,\r\n\r\n{DIR_NAME}\r\n{DIR_URL}');
  92.  
  93. ALTER TABLE `lep_category_field` CHANGE `type` `type` ENUM( 'inputText', 'inputPassword', 'textarea', 'inputCheckbox', 'inputRadio', 'select', 'selectmulti', 'inputFile', 'richtext', 'date', 'inputCheckboxmulti', 'inputCheckboxDynamic' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'inputText';
  94.  
  95. ALTER TABLE `lep_resource_field` CHANGE `type` `type` ENUM( 'inputText', 'inputPassword', 'textarea', 'inputCheckbox', 'inputRadio', 'select', 'selectmulti', 'inputFile', 'richtext', 'date', 'inputCheckboxmulti', 'inputCheckboxDynamic' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'inputText';
  96.  
  97. ALTER TABLE `lep_user_field` CHANGE `type` `type` ENUM( 'inputText', 'inputPassword', 'textarea', 'inputCheckbox', 'inputRadio', 'select', 'selectmulti', 'inputFile', 'richtext', 'date', 'inputCheckboxmulti', 'inputCheckboxDynamic' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'inputText';
  98.  
  99. ALTER TABLE `lep_comment_field` CHANGE `type` `type` ENUM( 'inputText', 'inputPassword', 'textarea', 'inputCheckbox', 'inputRadio', 'select', 'selectmulti', 'inputFile', 'richtext', 'date', 'inputCheckboxmulti', 'inputCheckboxDynamic' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'inputText';
  100.  
  101. ALTER TABLE `lep_resource_field` ADD `num_column` INT NULL;
  102. ALTER TABLE `lep_category_field` ADD `num_column` INT NULL;
  103. ALTER TABLE `lep_user_field` ADD `num_column` INT NULL;
  104. ALTER TABLE `lep_comment_field` ADD `num_column` INT NULL;
  105.  
  106. INSERT INTO `lep_page` VALUES(45, 'Power Search', 'power_search.php', 'main', 0, 'fl_visible=1&fl_show_title=1&fl_title=Featured+listing&fl_nrows=5&fl_sort=rand%28%29&fl_sort_a_d=asc&fl_template=rows_featured.php&fl_html_class_suffix=&rl_visible=1&rl_show_title=1&rl_title=Search+Result&rl_nrows=10&rl_sort=created_at&rl_sort_a_d=desc&rl_template=rows.php&rl_html_class_suffix=', 'Power Search', '', '');
  107.  
  108. INSERT INTO `lep_widget` VALUES(NULL, 'Slider Static', 'slider_static.php', 'main', '', '0');
  109. INSERT INTO `lep_widget` VALUES(NULL, 'Slider Listing', 'slider_listing.php', 'main', '', '0');
  110.  
  111. INSERT INTO `lep_menu` VALUES(null, 6, 'url', 'power_search.php', 'Search', 40, '0', '', '1', '1', '1');
  112.  
  113.  
  114. /** INDEXU 7.3 **/
  115.  
  116. update `lep_config` set `value`='7.3' where `name`='version';
  117.  
  118. INSERT INTO `lep_amenu` (`amenu_id` ,`parent_id` ,`name` ,`title` ,`url` ,`order_num` ,`sp`) VALUES (NULL , '1', 'cat_quick_add', 'Category Quick Adder', 'category.php?act=quick_add', '70', '0');
  119.  
  120. INSERT INTO `lep_amenu` (`amenu_id` ,`parent_id` ,`name` ,`title` ,`url` ,`order_num` ,`sp`) VALUES (NULL , '2', 'link_duplicate_link', 'Find Duplicate Links', 'link.php?act=duplicate_link', '120', '0');
  121.  
  122. INSERT INTO `lep_amenu` (`amenu_id` ,`parent_id` ,`name` ,`title` ,`url` ,`order_num` ,`sp`) VALUES (NULL , '2', 'link_featured', 'Featured', 'link.php?act=featured', '40', '0');
  123.  
  124.  
  125. /** INDEXU 7.4 **/
  126.  
  127. update `lep_config` set `value`='7.4' where `name`='version';
  128.  
  129. INSERT INTO `lep_widget` VALUES(24, 'Social Traffic Pop', 'social_traffic_pop.php', 'main', '0', '0');
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!