| Server IP : 103.119.228.120 / Your IP : 18.226.248.88 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/softaculous/phpld/ |
Upload File : |
--
-- Database: `phpld`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]CATEGORY`
--
CREATE TABLE `[[dbprefix]]CATEGORY` (
`ID` int(11) NOT NULL auto_increment,
`TITLE` varchar(255) NOT NULL default '',
`TITLE_URL` varchar(255) default NULL,
`DESCRIPTION` longtext,
`PARENT_ID` int(11) NOT NULL default '0',
`STATUS` int(11) NOT NULL default '1',
`DATE_ADDED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`HITS` int(11) NOT NULL default '0',
`SYMBOLIC` int(11) NOT NULL default '0',
`SYMBOLIC_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `[[dbprefix]]CATEGORY_TITLE_IDX` (`TITLE`),
KEY `[[dbprefix]]CATEGORY_TITLE_URL_IDX` (`TITLE_URL`),
KEY `[[dbprefix]]CATEGORY_PARENT_ID_IDX` (`PARENT_ID`),
KEY `[[dbprefix]]CATEGORY_STATUS_IDX` (`STATUS`),
KEY `[[dbprefix]]CATEGORY_HITS_IDX` (`HITS`),
FULLTEXT KEY `[[dbprefix]]CATEGORY_DESCRIPTION_IDX` (`DESCRIPTION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]CATEGORY`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]CONFIG`
--
CREATE TABLE `[[dbprefix]]CONFIG` (
`ID` varchar(255) NOT NULL default '',
`VALUE` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]CONFIG`
--
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SITE_NAME', '[[site_name]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SITE_URL', 'http://[[domhost]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SITE_DESC', '[[site_desc]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('LINKS_PER_PAGE', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('MAILS_PER_PAGE', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('VISUAL_CONFIRM', '[[gd]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('REQUIRE_RECIPROCAL', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ALLOW_MULTIPLE', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('CATS_PER_ROW', '2');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_REWRITE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('VERSION', 'CURRENT_VERSION');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('RECPR_NOFOLLOW', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_METHOD', 'mail');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_SERVER', 'localhost');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_USER', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_PASS', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_SENDMAIL', '/usr/bin/sendmail');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('CATS_PREVIEW', '3');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('CATS_COUNT', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('DIRECTORY_TITLE', '[[site_name]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_RSS', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_PAGERANK', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('DEBUG', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SHOW_PAGERANK', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('DEFAULT_SORT', 'P');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_NEWS', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ADMIN_LANG', 'en');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('FRONTEND_LANG', 'en');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('LINKS_TOP', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_SUBMIT_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_APPROVE_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_REJECT_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_PAYMENT_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('FTR_ENABLE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('FTR_MAX_LINKS', '5');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_ENABLE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_UM', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_NORMAL', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_FEATURED', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_RECPR', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_AUTO_ACCEPT', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_ENABLE_FREE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAYPAL_ENABLE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAYPAL_ACCOUNT', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAGER_LPP', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAGER_GROUPINGS', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_BLANK', '0');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]EMAIL`
--
CREATE TABLE `[[dbprefix]]EMAIL` (
`ID` int(11) NOT NULL auto_increment,
`EMAIL` varchar(255) NOT NULL default '',
`TITLE` varchar(255) NOT NULL default '',
`NAME` varchar(255) default NULL,
`URL` varchar(255) NOT NULL default '',
`DATE_SENT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]EMAIL`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]EMAIL_TPL`
--
CREATE TABLE `[[dbprefix]]EMAIL_TPL` (
`ID` int(11) NOT NULL auto_increment,
`TPL_TYPE` int(11) default '1',
`TITLE` varchar(255) NOT NULL default '',
`SUBJECT` varchar(255) NOT NULL default '',
`BODY` longblob,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]EMAIL_TPL`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]LINK`
--
CREATE TABLE `[[dbprefix]]LINK` (
`ID` int(11) NOT NULL auto_increment,
`TITLE` varchar(255) NOT NULL default '',
`DESCRIPTION` longtext,
`URL` varchar(255) NOT NULL default '',
`CATEGORY_ID` int(11) NOT NULL default '0',
`RECPR_URL` varchar(255) default NULL,
`RECPR_REQUIRED` tinyint(4) NOT NULL default '0',
`STATUS` int(11) NOT NULL default '0',
`VALID` tinyint(4) NOT NULL default '0',
`RECPR_VALID` tinyint(4) NOT NULL default '0',
`OWNER_ID` int(11) default NULL,
`OWNER_NAME` varchar(255) default NULL,
`OWNER_EMAIL` varchar(255) default NULL,
`OWNER_NOTIF` int(11) NOT NULL default '0',
`DATE_MODIFIED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`DATE_ADDED` timestamp NOT NULL default '0000-00-00 00:00:00',
`HITS` int(11) NOT NULL default '0',
`LAST_CHECKED` datetime default NULL,
`RECPR_LAST_CHECKED` datetime default NULL,
`PAGERANK` int(11) NOT NULL default '-1',
`RECPR_PAGERANK` int(11) NOT NULL default '-1',
`FEATURED_MAIN` int(11) NOT NULL default '0',
`FEATURED` int(11) NOT NULL default '0',
`EXPIRY_DATE` datetime default NULL,
`NOFOLLOW` tinyint(4) NOT NULL default '0',
`PAYED` int(11) NOT NULL default '-1',
`LINK_TYPE` int(11) NOT NULL default '0',
`IPADDRESS` varchar(15) default NULL,
PRIMARY KEY (`ID`),
KEY `[[dbprefix]]LINK_TITLE_IDX` (`TITLE`),
KEY `[[dbprefix]]LINK_URL_IDX` (`URL`),
KEY `[[dbprefix]]LINK_CATEGORY_ID_IDX` (`CATEGORY_ID`),
KEY `[[dbprefix]]LINK_STATUS_CATEGORY_ID_IDX` (`STATUS`,`CATEGORY_ID`),
KEY `[[dbprefix]]LINK_HITS_IDX` (`HITS`),
KEY `[[dbprefix]]LINK_FEATURED_IDX` (`FEATURED`),
KEY `[[dbprefix]]LINK_EXPIRY_DATE_IDX` (`EXPIRY_DATE`),
FULLTEXT KEY `[[dbprefix]]LINK_DESCRIPTION_IDX` (`DESCRIPTION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]LINK`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]PAYMENT`
--
CREATE TABLE `[[dbprefix]]PAYMENT` (
`ID` int(11) NOT NULL auto_increment,
`LINK_ID` varchar(15) NOT NULL default '',
`NAME` varchar(255) default NULL,
`EMAIL` varchar(255) default NULL,
`IPADDRESS` varchar(15) NOT NULL default '',
`AMOUNT` decimal(8,2) NOT NULL default '0.00',
`QUANTITY` int(11) NOT NULL default '0',
`TOTAL` decimal(8,2) NOT NULL default '0.00',
`PAYED_TOTAL` decimal(8,2) NOT NULL default '0.00',
`PAYED_QUANTITY` int(11) NOT NULL default '0',
`UM` int(11) NOT NULL default '0',
`CONFIRMED` int(11) NOT NULL default '0',
`PAY_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`CONFIRM_DATE` datetime default NULL,
`RAW_LOG` longtext,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]PAYMENT`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]USER`
--
CREATE TABLE `[[dbprefix]]USER` (
`ID` int(11) NOT NULL auto_increment,
`LOGIN` varchar(100) NOT NULL default '',
`NAME` varchar(255) NOT NULL default '',
`PASSWORD` varchar(46) NOT NULL default '',
`EMAIL` varchar(255) NOT NULL default '',
`ADMIN` tinyint(4) NOT NULL default '0',
`SUBMIT_NOTIF` tinyint(4) NOT NULL default '1',
`PAYMENT_NOTIF` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]USER`
--
INSERT INTO `[[dbprefix]]USER` VALUES (1, '[[admin_username]]', '[[admin_realname]]', '{sha1}[[admin_pass]]', '[[admin_email]]', 1, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]USER_PERMISSION`
--
CREATE TABLE `[[dbprefix]]USER_PERMISSION` (
`ID` int(11) NOT NULL auto_increment,
`USER_ID` int(11) NOT NULL default '0',
`CATEGORY_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]USER_PERMISSION`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]USER_SEQ`
--
CREATE TABLE `[[dbprefix]]USER_SEQ` (
`id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `[[dbprefix]]USER_SEQ`
--
INSERT INTO `[[dbprefix]]USER_SEQ` VALUES (1);