public function index()
{
$bDrop = $this->uri->segment(3);
$aTableNames = modelsToTableNames();
foreach ($aTableNames as $k => $sTableName) {
$oSqlBuilder = new SqlBuilder();
//** Build tables
$oTableName = new $k();
$sCreateSql = $oSqlBuilder->setTableName($sTableName)->getCreateTableString($oTableName->db);
$this->db->query('FLUSH TABLES;');
if ($bDrop) {
$this->db->query($oSqlBuilder->getDropTableString());
}
if (!tableExists($sTableName)) {
$this->db->query($sCreateSql);
}
//** Add in any default data
foreach ($oSqlBuilder->getDefaultDataArray($oTableName->data) as $v) {
//$oTableName->
$this->db->query($v);
}
}
foreach ($aTableNames as $k => $sTableName) {
$oTableName = new $k();
//** Make forms
if (!empty($oTableName->form)) {
$oFormBuilder = new FormBuilder();
$sForm = $oFormBuilder->setTableName($sTableName)->setFormName($sTableName)->setFormData($oTableName->form)->getFormString();
createFile('views/admin/includes/forms/' . $sTableName . '_form.php', $sForm);
}
}
}
function readCSV($archivoDestino)
{
$file = "files/csv/" . $archivoDestino;
if (($gestor = fopen($file, "r")) !== FALSE) {
$listaValores = array();
$listaFechas = array();
$anterior = 0;
$listaUnosCeros = array();
while (($datos = fgetcsv($gestor, 1000, ",")) !== FALSE) {
$numero = count($datos);
for ($c = 1; $c < $numero; $c++) {
if (is_numeric($datos[$c])) {
$listaValores[] = $datos[$c];
//Guardamos las fechas en un arreglo
$listaFechas[] = $datos[$c - 1];
$listaUnosCeros[] = dameBool($anterior, $datos[$c]);
$anterior = $datos[$c];
}
}
}
$fileName = createFile($listaValores, $archivoDestino);
//Creamos el archivo.dat o .txt que leera el python
fclose($gestor);
//$unos = implode(",",$listaUnosCeros);
$_SESSION['unosceros'] = implode(",", $listaUnosCeros);
return array($fileName, $listaValores, $listaFechas, $listaEscalada);
}
}
function main()
{
$archivo = 'csvDelitos.csv';
if ($_POST["action"] == "upload") {
if (copy($_FILES['archivo']['tmp_name'], "files/txt/" . $archivo)) {
$status = "Archivo subido: <b>" . $archivo . "</b>";
$bStatus = True;
} else {
$status = "Error al subir el archivo";
}
}
$listaValores = readCSV($archivo);
$_SESSION['fecha'] = $listaValores[0];
//array
$_SESSION['valores'] = $listaValores[1];
//array
$fileFechas = createFile('fechas', $listaValores[0]);
//creamos archivo de fechas
$fileValores = createFile('valores', $listaValores[1]);
//creamos archivo de valores
//echo '<br/>'.implodeFecha();
//echo '<br/>'.implodeValores();
//echo '<br/>'.countValores();
//echo '<br/>'.callPython($fileValores);
//echo '<br/>'.callNormalizar($fileValores);
$_SESSION['normalizar'] = callNormalizar($fileValores);
//String
unlink('files/txt/' . $archivo);
//eliminamos el archivo creado
createCSV($archivo, $listaValores[2]);
}
function Qiniu_PutFile($upToken, $key, $localFile, $putExtra)
{
global $QINIU_UP_HOST;
if ($putExtra === null) {
$putExtra = new Qiniu_PutExtra();
}
$fields = array('token' => $upToken, 'file' => createFile($localFile, $putExtra->MimeType));
if ($key !== null) {
$fields['key'] = $key;
}
if ($putExtra->CheckCrc) {
if ($putExtra->CheckCrc === 1) {
$hash = hash_file('crc32b', $localFile);
$array = unpack('N', pack('H*', $hash));
$putExtra->Crc32 = $array[1];
}
$fields['crc32'] = sprintf('%u', $putExtra->Crc32);
}
if ($putExtra->Params) {
foreach ($putExtra->Params as $k => $v) {
$fields[$k] = $v;
}
}
$client = new Qiniu_HttpClient();
return Qiniu_Client_CallWithForm($client, $QINIU_UP_HOST, $fields, 'multipart/form-data');
}
function getData($fields)
{
$apiKey = $fields['api'];
$jotform = new JotForm($apiKey);
$form = "";
$output = array();
$columns = array();
$includeForm = array_key_exists('includeForm', $fields);
if ($includeForm) {
array_push($columns, 'Form Name');
}
foreach ($fields as $field => $on) {
if (strpos($field, '_') === false) {
continue;
}
$question = explode('_', $field);
if ($question[0] != $form) {
$submissions = $jotform->getFormSubmissions($question[0]);
$form = $question[0];
if ($includeForm) {
$formInfo = $jotform->getForm($form);
$formName = $formInfo['title'];
}
}
foreach ($submissions as $key => $submission) {
$submission_id = $submission['id'];
if (array_key_exists('answers', $submission)) {
foreach ($submission['answers'] as $key => $answer) {
if (array_key_exists('text', $answer) && array_key_exists('answer', $answer)) {
$fieldTitle = $answer['text'];
$strippedTitle = preg_replace('/\\s+/', '', $fieldTitle);
if ($strippedTitle == $question[2]) {
$columnTitle = $fields['groupby'] == 'name' ? $fieldTitle : preg_replace('/control_/', '', $answer['type']);
if (!in_array($columnTitle, $columns)) {
array_push($columns, $columnTitle);
}
if (!array_key_exists($submission_id, $output)) {
$output[$submission_id] = array();
if ($includeForm) {
$output[$submission_id]['Form Name'] = $formName;
}
}
$text = is_array($answer['answer']) ? implode(' - ', $answer['answer']) : $answer['answer'];
if (array_key_exists($columnTitle, $output[$submission_id])) {
$output[$submission_id][$columnTitle] = $output[$submission_id][$columnTitle] . ' - ' . $text;
} else {
$output[$submission_id][$columnTitle] = $text;
}
}
}
}
}
}
}
createFile($output, $columns, $apiKey);
}
function restoreHtaccess() {
$start = "### SILVERSTRIPE START ###\n";
$end= "\n### SILVERSTRIPE END ###";
if(file_exists('.htaccess')) {
$htaccess = file_get_contents('.htaccess');
if(strpos($htaccess, '### SILVERSTRIPE START ###') === false && strpos($htaccess, '### SILVERSTRIPE END ###') === false) {
$htaccess .= "\n### SILVERSTRIPE START ###\n### SILVERSTRIPE END ###\n";
}
if(strpos($htaccess, '### SILVERSTRIPE START ###') !== false && strpos($htaccess, '### SILVERSTRIPE END ###') !== false) {
$start = substr($htaccess, 0, strpos($htaccess, '### SILVERSTRIPE START ###')) . "### SILVERSTRIPE START ###\n";
$end = "\n" . substr($htaccess, strpos($htaccess, '### SILVERSTRIPE END ###'));
}
}
createFile('.htaccess', $start . $end);
}
<?php
$string = "<!-- Main content -->\n <section class='content'>\n <div class='row'>\n <div class='col-xs-12'>\n <div class='box'>\n <div class='box-header'>\n \n <h3 class='box-title'>" . strtoupper($table_name) . "</h3>\n <div class='box box-primary'>";
$string .= "\n <form action=\"<?php echo \$action; ?>\" method=\"post\">";
$string .= "<table class='table table-bordered'>";
foreach ($non_pk as $row) {
if ($row["data_type"] == 'text') {
$string .= "\n\t <tr><td>" . label($row["column_name"]) . " <?php echo form_error('" . $row["column_name"] . "') ?></td>\n <td><textarea class=\"form-control\" rows=\"3\" name=\"" . $row["column_name"] . "\" id=\"" . $row["column_name"] . "\" placeholder=\"" . label($row["column_name"]) . "\"><?php echo \$" . $row["column_name"] . "; ?></textarea>\n </td></tr>";
} else {
$string .= "\n\t <tr><td>" . label($row["column_name"]) . " <?php echo form_error('" . $row["column_name"] . "') ?></td>\n <td><input type=\"text\" class=\"form-control\" name=\"" . $row["column_name"] . "\" id=\"" . $row["column_name"] . "\" placeholder=\"" . label($row["column_name"]) . "\" value=\"<?php echo \$" . $row["column_name"] . "; ?>\" />\n </td>";
}
}
$string .= "\n\t <input type=\"hidden\" name=\"" . $pk . "\" value=\"<?php echo \$" . $pk . "; ?>\" /> ";
$string .= "\n\t <tr><td colspan='2'><button type=\"submit\" class=\"btn btn-primary\"><?php echo \$button ?></button> ";
$string .= "\n\t <a href=\"<?php echo site_url('" . $c_url . "') ?>\" class=\"btn btn-default\">Cancel</a></td></tr>";
$string .= "\n\t\n </table></form>\n </div><!-- /.box-body -->\n </div><!-- /.box -->\n </div><!-- /.col -->\n </div><!-- /.row -->\n </section><!-- /.content -->";
$hasil_view_form = createFile($string, $target . "views/" . $v_form_file);
$oMsg = new message(true, $msg);
echo $oMsg;
} else {
// 文件夹创建出现异常
$oMsg = new message(false, $msg);
echo $oMsg;
}
} elseif ('mkdir_file' === $act) {
if ('' === $dir) {
$oMsg = new message(false, "file_dir_name操作参数错误。");
echo $oMsg;
exit;
}
$dir = ltrim($dir, HOME_FILE);
$dir = HOME_PRO . HOME_FILE . DS . $dir;
$msg = createFile($dir);
if ("文件创建成功" === $msg) {
// 文件夹创建成功
$oMsg = new message(true, $msg);
echo $oMsg;
} else {
// 文件夹创建出现异常
$oMsg = new message(false, $msg);
echo $oMsg;
}
} elseif ('upload' === $act) {
$uf = $_FILES['fileToUpload'];
if ("" == $uf && "" == $dir) {
$oMsg = new message(false, "file_dir_name操作参数错误。");
echo $oMsg;
exit;
}
$string .= "\n\t );\n\n \$this->" . $m . "->update(\$this->input->post('{$pk}', TRUE), \$data);\n \$this->session->set_flashdata('message', 'Update Record Success');\n redirect(site_url('{$c_url}'));\n }\n }\n \n public function delete(\$id) \n {\n \$row = \$this->" . $m . "->get_by_id(\$id);\n\n if (\$row) {\n \$this->" . $m . "->delete(\$id);\n \$this->session->set_flashdata('message', 'Delete Record Success');\n redirect(site_url('{$c_url}'));\n } else {\n \$this->session->set_flashdata('message', 'Record Not Found');\n redirect(site_url('{$c_url}'));\n }\n }\n\n public function _rules() \n {";
foreach ($non_pk as $row) {
$int = $row3['data_type'] == 'int' || $row['data_type'] == 'double' || $row['data_type'] == 'decimal' ? '|numeric' : '';
$string .= "\n\t\$this->form_validation->set_rules('" . $row['column_name'] . "', '" . strtolower(label($row['column_name'])) . "', 'trim|required{$int}');";
}
$string .= "\n\n\t\$this->form_validation->set_rules('{$pk}', '{$pk}', 'trim');";
$string .= "\n\t\$this->form_validation->set_error_delimiters('<span class=\"text-danger\">', '</span>');\n }";
if ($export_excel == '1') {
$string .= "\n\n public function excel()\n {\n \$this->load->helper('exportexcel');\n \$namaFile = \"{$table_name}.xls\";\n \$judul = \"{$table_name}\";\n \$tablehead = 0;\n \$tablebody = 1;\n \$nourut = 1;\n //penulisan header\n header(\"Pragma: public\");\n header(\"Expires: 0\");\n header(\"Cache-Control: must-revalidate, post-check=0,pre-check=0\");\n header(\"Content-Type: application/force-download\");\n header(\"Content-Type: application/octet-stream\");\n header(\"Content-Type: application/download\");\n header(\"Content-Disposition: attachment;filename=\" . \$namaFile . \"\");\n header(\"Content-Transfer-Encoding: binary \");\n\n xlsBOF();\n\n \$kolomhead = 0;\n xlsWriteLabel(\$tablehead, \$kolomhead++, \"No\");";
foreach ($non_pk as $row) {
$column_name = label($row['column_name']);
$string .= "\n\txlsWriteLabel(\$tablehead, \$kolomhead++, \"{$column_name}\");";
}
$string .= "\n\n\tforeach (\$this->" . $m . "->get_all() as \$data) {\n \$kolombody = 0;\n\n //ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric\n xlsWriteNumber(\$tablebody, \$kolombody++, \$nourut);";
foreach ($non_pk as $row) {
$column_name = $row['column_name'];
$xlsWrite = $row['data_type'] == 'int' || $row['data_type'] == 'double' || $row['data_type'] == 'decimal' ? 'xlsWriteNumber' : 'xlsWriteLabel';
$string .= "\n\t " . $xlsWrite . "(\$tablebody, \$kolombody++, \$data->{$column_name});";
}
$string .= "\n\n\t \$tablebody++;\n \$nourut++;\n }\n\n xlsEOF();\n exit();\n }";
}
if ($export_word == '1') {
$string .= "\n\n public function word()\n {\n header(\"Content-type: application/vnd.ms-word\");\n header(\"Content-Disposition: attachment;Filename={$table_name}.doc\");\n\n \$data = array(\n '" . $table_name . "_data' => \$this->" . $m . "->get_all(),\n 'start' => 0\n );\n \n \$this->load->view('" . $v_doc . "',\$data);\n }";
}
if ($export_pdf == '1') {
$string .= "\n\n function pdf()\n {\n \$data = array(\n '" . $table_name . "_data' => \$this->" . $m . "->get_all(),\n 'start' => 0\n );\n \n ini_set('memory_limit', '32M');\n \$html = \$this->load->view('" . $v_pdf . "', \$data, true);\n \$this->load->library('pdf');\n \$pdf = \$this->pdf->load();\n \$pdf->WriteHTML(\$html);\n \$pdf->Output('" . $table_name . ".pdf', 'D'); \n }";
}
$string .= "\n\n}\n\n/* End of file {$c_file} */\n/* Location: ./application/controllers/{$c_file} */\n/* Please DO NOT modify this information : */\n/* Generated by Harviacode Codeigniter CRUD Generator " . date('Y-m-d H:i:s') . " */\n/* http://harviacode.com */";
$hasil_controller = createFile($string, $target . "controllers/" . $c_file);
<?php
$string = "<!doctype html>\n<html>\n <head>\n <title>harviacode.com - codeigniter crud generator</title>\n <link rel=\"stylesheet\" href=\"<?php echo base_url('assets/bootstrap/css/bootstrap.min.css') ?>\"/>\n <style>\n .word-table {\n border:1px solid black !important; \n border-collapse: collapse !important;\n width: 100%;\n }\n .word-table tr th, .word-table tr td{\n border:1px solid black !important; \n padding: 5px 10px;\n }\n </style>\n </head>\n <body>\n <h2>" . ucfirst($table_name) . " List</h2>\n <table class=\"word-table\" style=\"margin-bottom: 10px\">\n <tr>\n <th>No</th>";
foreach ($non_pk as $row) {
$string .= "\n\t\t<th>" . label($row['column_name']) . "</th>";
}
$string .= "\n\t\t\n </tr>";
$string .= "<?php\n foreach (\$" . $c_url . "_data as \${$c_url})\n {\n ?>\n <tr>";
$string .= "\n\t\t <td><?php echo ++\$start ?></td>";
foreach ($non_pk as $row) {
$string .= "\n\t\t <td><?php echo \$" . $c_url . "->" . $row['column_name'] . " ?></td>";
}
$string .= "\t\n </tr>\n <?php\n }\n ?>\n </table>\n </body>\n</html>";
$hasil_view_pdf = createFile($string, $target . "views/" . $v_pdf_file);
$path = "file";
$path = $_REQUEST['path'] ? $_REQUEST['path'] : $path;
$act = $_REQUEST['act'];
$filename = $_REQUEST['filename'];
$dirname = $_REQUEST['dirname'];
$info = readDirectory($path);
if (!$info) {
echo "<script>alert('没有文件或目录！！！');location.href='index.php';</script>";
}
//print_r($info);
$redirect = "index.php?path={$path}";
if ($act == "创建文件") {
//创建文件
// echo $path,"--";
// echo $filename;
$mes = createFile($path . "/" . $filename);
alertMes($mes, $redirect);
} elseif ($act == "showContent") {
//查看文件内容
$content = file_get_contents($filename);
//echo "<textarea readonly='readonly' cols='100' rows='10'>{$content}</textarea>";
//高亮显示PHP代码
//高亮显示字符串中的PHP代码
if (strlen($content)) {
$newContent = highlight_string($content, true);
//高亮显示文件中的PHP代码
//highlight_file($filename);
$str = <<<EOF
\t\t<table width='100%' bgcolor='pink' cellpadding='5' cellspacing="0" >
\t\t\t<tr>
\t\t\t\t<td>{$newContent}</td>
function htaccessDisplay()
{
if (!isset($_SESSION['nb'])) {
$_SESSION['nb'] = 1;
}
if (!isset($_SESSION['path'])) {
$_SESSION['path'] = getcwd();
}
if (!isset($_SESSION['sentence'])) {
$_SESSION['sentence'] = 'Welcome';
}
$options = array('options' => array('default' => 1, 'min_range' => 1, 'max_range' => 100));
$USER_NUMBER = filter_var($_SESSION['nb'], FILTER_VALIDATE_INT, $options);
$PATH = filter_var($_SESSION['path'], FILTER_SANITIZE_URL);
$TEXT = filter_var($_SESSION['sentence'], FILTER_SANITIZE_STRING);
$htaccess = 'AuthName "' . $TEXT . '"
AuthType Basic
AuthUserFile "' . $PATH . '/.htpasswd"
Require valid-user';
$htpasswd = '';
$length = $USER_NUMBER + 1;
for ($i = 1; $i < $length; $i++) {
$pseudo = 'pseudo' . $i;
$mdp = 'mdp' . $i;
$USER = filter_input(INPUT_POST, $pseudo, FILTER_SANITIZE_STRING);
$PASS = filter_input(INPUT_POST, $mdp, FILTER_SANITIZE_STRING);
$crypto = '{SHA}' . base64_encode(sha1($PASS, true)) . "\r\n";
$htpasswd .= $USER . ':' . $crypto;
}
createFile(".htaccess", $htaccess);
createFile($PATH . '/.htpasswd', $htpasswd);
?>
<h1>.htaccess and .htpasswd generator</h1>
<h2>State 3/3</h2>
<em>.htaccess - content</em><br>
<pre><?php
echo $htaccess;
?>
</pre><br>
<hr>
<br>
<em>.htpasswd (<?php
echo $PATH;
?>
) - content</em><br>
<pre><?php
echo $htpasswd;
?>
</pre><br>
<hr>
<button onclick="location.reload();">Ok</button>
<?php
$path = $_SERVER['PHP_SELF'];
$file = basename($path);
unlink($file);
session_destroy();
}
function SaveVisitorListToFile()
{
setTimeLimit(300);
if ($this->CreateVisitorList) {
createFile($this->GetFilename(true, true), $this->GetUsersHTML(), true, false);
}
}
} else {
echo "Error creating database: " . mysql_error();
}
}
$accessMsg = mysql_select_db($dbname, $conn) ? "<font color='red'>数据库已经存在，系统将覆盖数据库</font>" : "<font color='green'>数据库不存在,系统将自动创建</font>";
$content = getftext('conn.php');
$s = StrCut($content, 'dbhost=', "';", true, true);
$content = str_replace($s, 'dbhost=\'' . $dbhost . '\';', $content);
$s = StrCut($content, 'dbuser='******';", true, true);
$content = str_replace($s, 'dbuser=\'' . $dbuser . '\';', $content);
$s = StrCut($content, 'dbpwd=', "';", true, true);
$content = str_replace($s, 'dbpwd=\'' . $dbpwd . '\';', $content);
$s = StrCut($content, 'dbname=', "';", true, true);
$content = str_replace($s, 'dbname=\'' . $dbname . '\';', $content);
if (is_writable('conn.php')) {
createFile('conn.php', $content);
} else {
echo "出错，没有权限操作文件，手动配置<hr>" . handlePath('conn.php') . '<hr>配置完成后再点下一步<hr>';
}
step2();
exit;
}
} else {
$dbmsg = "<font color='red'>数据库连接失败！</font>";
}
@mysql_close($conn);
}
//截取字符串,CutType为1包括截取值 2为不包括截取值
function StrCut($Content, $StartStr, $EndStr, $CutType)
{
//On Error Resume Next
function saveRobots()
{
$bodycontent = '';
$url = '';
handlePower('修改生成Robots');
//管理权限处理
$bodycontent = @$_REQUEST['bodycontent'];
createFile(ROOT_PATH . '/../robots.txt', $bodycontent);
$url = '?act=displayLayout&templateFile=layout_makeRobots.html&lableTitle=生成Robots';
Rw(getMsg1('保存Robots成功，正在进入Robots界面...', $url));
writeSystemLog('', '保存Robots.txt');
//系统日志
}
// Start the output and conversion here
startOutput();
$settingsFile = dirname(realpath(__FILE__)) . "/../includes/settings.php";
showInfoBox('We are attempting to open and reads your settings.php file.', 'Reading Settings');
if (!file_exists($settingsFile)) {
showInfoBox('<span style="color: #ff0000;font-weight: bold;">There was an error trying to read the settings.php file...\\nPlease make sure that you have created your settings.php file already...\\nAttempting to read file: $settingsFile</span>', 'ERROR');
die;
}
$contents = file_get_contents($settingsFile);
showInfoBox('Successfully opened and read the settings.php file, we are attempting to parse now....', 'Parsing');
if (!isConverted()) {
$keyval = parseSettings($contents);
showInfoBox('Populating database.....', 'Database');
//populateDatabase($keyval);
writeToDB($keyval);
if (createFile()) {
showInfoBox('All done.. Please replace settings.php with the settings-new.php file that was created.');
}
} else {
showInfoBox("You appear to already be converted. Congratulations.\nIf your settings are not working, please try to run the DB Fix tool.");
}
endOutput();
//-------------------------------------------------------------------------------------------//
/**
* writeToDb writes the OBJECT to the database
* @param Array $data
*/
function writeToDB($data)
{
// echo print_r(array_keys($data), true);
require_once dirname(realpath(__FILE__)) . '/../includes/classes/settings.class.php';
function _make($v, $arg)
{
echo ' make: ' . $v;
if (isset($arg[0])) {
$arg[0] = str_replace('\\', '/', $arg[0]);
}
if (strtolower($v) == 'controller') {
if (!isset($arg[0])) {
return "\n\n ERROR: indique o NOME do arquivo!\n";
}
return createFile($arg[0], 'controller');
} elseif (strtolower($v) == 'model') {
if (!isset($arg[0])) {
return "\n\n ERROR: indique o NOME do arquivo!\n";
}
return createFile($arg[0], 'model');
} elseif (strtolower($v) == 'lib') {
if (!isset($arg[0])) {
return "\n\n ERROR: indique o NOME do arquivo!\n";
}
return createFile($arg[0], 'lib');
} elseif (strtolower($v) == 'html') {
if (!isset($arg[0])) {
return "\n\n ERROR: indique o NOME do arquivo!\n";
}
$name = strtolower($arg[0]);
if (file_exists(APP_PATH . 'html/' . $name . '.html')) {
return "\n\n WARNNING: this file already exists!\n " . APP_PATH . 'html/' . $name . ".html\n\n";
}
if (!checkAndOrCreateDir(dirname(APP_PATH . 'html/' . $name . '.html'), true)) {
return "\n\n WARNNING: access denied in directory '" . dirname(APP_PATH . 'html/' . $name . '.html') . "'\n\n";
}
$ctrl = file_get_contents(CONFIG_PATH . 'templates/html.tpl');
$ctrl = str_replace('%name%', ucfirst($name), $ctrl);
file_put_contents(APP_PATH . 'html/' . $name . '.html', $ctrl);
return "\n\n HTML file '" . APP_PATH . 'html/' . $name . '.html' . "' criado com sucesso!\n\n";
} else {
return "\n\n ----- ERROR: Command 'make:{$v}' not found!\n" . _help();
}
}
/**
* routine to create the example directory and 3 files
*
* if the $example_name is "SomeThing" the following files will be created
* examples/some_thing
* examples/some_thing/some_thing.mustache
* examples/some_thing/some_thing.txt
* examples/some_thing/SomeThing.php
*
* @param mixed $example_name
* @access public
* @return void
*/
function main($example_name)
{
$lowercase = getLowerCaseName($example_name);
$uppercase = getUpperCaseName($example_name);
createDirectory($lowercase);
createFile($lowercase, $lowercase, "mustache");
createFile($lowercase, $lowercase, "txt");
createFile($lowercase, $uppercase, "php", <<<CONTENT
<?php
class {$uppercase} extends MustachePHP {
}
CONTENT
);
}
//---------------------------------------------------------------------------
//log before delete login
log_me();
//---------------------------------------------------------------------------
//
// TimeStamp
//
//---------------------------------------------------------------------------
// Write timestamp into user file to force update for signin
if (isset($_SESSION["ok"])) {
$cookie = $_SESSION["ok"];
} elseif (isset($_COOKIE["ok"])) {
$cookie = $_COOKIE["ok"];
}
if (isset($cookie)) {
createFile("../", $cookie);
}
//---------------------------------------------------------------------------
//
// Delete session and cookies
//
//---------------------------------------------------------------------------
// Delete session variables
foreach ($_SESSION as $k => $v) {
if (isset($_SESSION[$k])) {
unset($_SESSION[$k]);
}
}
// Delete cookie variables
foreach ($_COOKIE as $k => $v) {
if (isset($_COOKIE[$k])) {
function handleConfigFile($ConfigPath)
{
$c = '';
if (CheckFile($ConfigPath) == false) {
$c = '#Help帮助# start' . vbCrlf() . '默认帮助内容' . vbCrlf() . '#Help帮助# end';
createFile($ConfigPath, $c);
}
}
/**
* Функция отправляет письма
*/
function sendMail()
{
// Явное указание на использование глобальных переменных
global $localhostPath, $dbConnect, $prefix, $maxMailSend, $maxMailSendInDay, $log, $timeout;
// Устанавливаем значение "по умолчанию" переменной статуса завершения функции
$status = false;
// Формирвоание текста сообщения о наличии файла "stop.txt"
$stopFileExistlogMessage = date('d.m.Y H:i:s') . ": Выполнение предыдущей версии скрипта еще не завершено!";
// Формирвоание текста сообщения о наличии файла "gotLimit.txt"
$gotlimitFileExistlogMessage = date('d.m.Y H:i:s') . ": Достигнут суточный лимит отправляемых писем. Рассылку необходимо возобновить вручную через 24 часа!";
// Если файла "gotLimit.txt" на сервере нет
// Если файла "stop.txt" на сервере нет
// Если соединение с БД установлено
// И параметры скрипта переопределены
// И максимальное количество отправляемых за раз писем не равно 0
if (!checkFileExists('gotLimit.txt', $gotlimitFileExistlogMessage) && !checkFileExists('stop.txt', $stopFileExistlogMessage) && dbConnect() && setParams() && $maxMailSend !== 0) {
// Создаем файл "stop.txt"
createFile('stop.txt', 'stop');
// Если есть активные почтовые рассылки, получаем параметры первой активной рассылки
if ($mail = getMailingGroup()) {
// Добавляем сообщение о начале работы скрипта в массив лога
$log[] = date('d.m.Y H:i:s') . ": Начало работы скрипта!";
// Получение списка адресатов, кому были отправлены письма
$whoSent = $mail['whoSent'] ? explode(',', $mail['whoSent']) : array();
// Получаем массив категорий материалов рассылки
$categories = $mail['categories'] ? array_diff(explode(',', $mail['categories']), array('', ' ', null)) : array();
// Получаем количество отправленных писем из отчера за предыдущий день
$sendedYesterday = getYesterdayReportData();
// Определение количества отправленных писем
$sendedInAllTime = $mail['log'] > count($whoSent) ? $mail['log'] : count($whoSent);
// Подсчитываем, сколько еще можно отправить писем за этот день, не превышая лимитов хостинга
$needToSend = $maxMailSendInDay + $sendedYesterday - $sendedInAllTime;
// Переопределение максимального количества отправляемых за раз писем
$maxMailSend = $needToSend >= $maxMailSend ? $maxMailSend : $needToSend;
// Если не достигнут суточный лимит количества отправляемых писем
if ($needToSend > 0) {
// Получение списка подписчиков активной рассылки
$subscribers = getSubscribers($categories, $mail['log']);
// Если массив подписчиков не пуст
if (!empty($subscribers)) {
// Закрываем текущее соединение с БД, во избежание зазрыва соединения по таймауту
mysql_close($dbConnect);
// Обход массива подписчиков
foreach ($subscribers as $subscriber) {
// Если количество отправленных писем меньше максимального количества отправляемых писем за раз
// И подписчику еще не отправлялось письмо
if ($countMailSend < $maxMailSend && !in_array($subscriber['email'], $whoSent)) {
// Установка временного интервала между отправками писем в 10 секунд
sleep($timeout);
// Определение значения по умолчанию сгенерированной строки, добавляемой к телу письма
$generatorStr = '';
// Если параметр "Подключать словарь генерации случайного текста?" рассылки установлен в позицию "Да"
if ($mail['generator'] == 1) {
// Получение сгенерированной строки случайного текста
$generator = generator();
// Если строка не сгенерирована
if (!$generator) {
// Переход к следующей итерации цикла
continue;
}
// Добавляем сгенерированную строчку случайного текста
$generatorStr = $generator;
}
/* --------- Генерация письма -------- */
// Тема письма
$subject = $mail['subject'];
// Формируем тело письма для отправки
// Подставляем Имя пльзователя в тело в шаблон письма если есть маркер -{fio}-
$body = str_replace('-{fio}-', $subscriber['fio'], $mail['textemail']);
// Подставляем Email пльзователя в тело в шаблон письма если есть маркер -{fio}-
$body = str_replace('-{email}-', $subscriber['email'], $body);
// Добавление сгенерированной строки к телу письма
$body .= $generatorStr;
// Формируем заголовок письма
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=utf-8\r\n";
$headers .= "From: " . $mail['myemail'] . "\r\n";
$headers .= "Reply-To: " . $mail['myemail'] . "\r\n";
/* --------- Отправка письма -------- */
// Отправка письма адресату
$sendingMail = mail($subscriber['email'], $subject, $body, $headers);
/* --------- Проверка результата операции отправки -------- */
// Если письмо успешно отправлено
if ($sendingMail) {
// Добавляем E-mail адрес подписчика в массив адресатов, кому уже отправлены письма
$whoSent[] = $subscriber['email'];
// Формируем запрос на обновление списка отправленных у подписчика
$updateSubscriberInfo[] = "(" . $subscriber['id'] . ", '" . addslashes($subscriber['downloadedDocs'] . "\r\n" . $mail['id'] . ". " . $mail['subject'] . " (" . date('H:i:s d.m.y') . ")") . "')";
$log[] = 'Письмо c id=' . $mail['id'] . ' успешно отправлено адресату ' . $subscriber['email'];
} else {
// Добавляем сообщение об ошибке в массив лога ошибок
$log[] = 'Письмо c id=' . $mail['id'] . ' не отправлено на е-mail ' . $subscriber['email'];
}
// Удаление переменных
unset($body, $subject, $header);
// Увеличиваем общий счетчик отправленных писем на единицу
$countMailSend++;
} else {
// Переход к следующей итерации цикла
continue;
}
}
// Формируем запрос в БД на обновление информации о рассылке
$query = "UPDATE `" . $prefix . "subscribers_emails` SET `log`=" . ($mail['log'] + $countMailSend) . ", `whoSent`='" . implode(',', $whoSent) . "', `noteMail`='" . $mail['noteMail'] . "\r\n" . date('H:i:s d.m.Y') . ":Отправлено всего на " . count($whoSent) . " e-mail адресов' WHERE `id`=" . $mail['id'];
} else {
// Формируем запрос в БД на обновление информации о рассылке
$query = "UPDATE `" . $prefix . "subscribers_emails` SET `log`=0, `published`=-1, `send_date`='" . date('Y-m-d H:i:s') . "', `whoSent`='" . implode(',', $whoSent) . "', `noteMail`='" . $mail['noteMail'] . "\r\n" . date('H:i:s d.m.Y') . ":Отправлено всего на " . count($whoSent) . " e-mail адресов' WHERE `id`=" . $mail['id'];
}
// Восстанавливаем отключенное ранее соединение с БД
dbConnect();
// Отправка запроса в БД и получение результата
$resultToDb = mysql_query($query, $dbConnect);
// Если последняя операция MySQL вернула сообщение об ошибке (не пустую строку)
if (!$resultToDb) {
// Добавленеи сообщения об ошибках операции в MySQL в массив лога ошибок
$log[] = "MySQL query error: " . mysql_error() . ' (' . $query . ')';
}
// Если массив запросов на обновление списка отправленных материалов подписчику не пустой
if ($updateSubscriberInfo) {
// Преобразовываем массив в строку
$updateSubscriberInfo = implode(',', $updateSubscriberInfo);
// Формируем строку запроса в БД на внесение изменений в данные подписчиков в БД
$updateSubscriberInfo = 'INSERT INTO `' . $prefix . 'subscribers` (`id`, `downloadedDocs`) VALUES' . $updateSubscriberInfo . ' ON DUPLICATE KEY UPDATE `downloadedDocs` = VALUES(`downloadedDocs`)';
// Отправка запроса в БД и получение результата
$res = mysql_query($updateSubscriberInfo, $dbConnect);
if (!$res) {
// Добавленеи сообщения об ошибках операции в MySQL в массив лога ошибок
$log[] = "MySQL query error: " . mysql_error() . ' (' . $query . ')';
}
}
} else {
// Добавленеи сообщение о достижении суточного лимита в массив лога ошибок
$log[] = "Достигнут суточный лимит отправляемых писем. Рассылка будет возобновлена завтра!";
// Проверяем, существует ли файл "dayReport.txt" на сервере
if (file_exists($localhostPath . 'dayReport.txt')) {
// Удаление файла "dayReport.txt"
unlink($localhostPath . 'dayReport.txt');
}
// Вызываем функцию создания файла отчета об общем количестве отправленных писем по текущей рассылке
createFile('dayReport.txt', count($whoSent));
// Вызываем функцию создания файла
createFile('gotLimit.txt', 'true');
}
// Добавляем сообщение об окончании работы скрипта в массив лога
$log[] = date('d.m.Y H:i:s') . ": Завершение работы скрипта!";
} else {
// Добавляем сообщение об окончании работы скрипта в массив лога
$log[] = date('d.m.Y H:i:s') . ": Рассылка не ведется! Нет активных почтовых рассылок!";
}
// Удаление файла "stop"
unlink($localhostPath . 'stop.txt');
// Устанавливаем значение переменной статуса завершения функции
$status = true;
}
// Закрываем текущее соединение с БД
mysql_close($dbConnect);
// Записываем логи в файл
writeToLog();
// Завершаем выполнение работы скрипта. Выходим из функции
return $status;
}
$myfile = fopen("config.php", "w") or die("Unable to write config file. Make sure you have write permssions.!");
$encoded = '<?php $username ="******"; $password ="******"; $database ="' . $db . '"; $host ="' . $dbHost . '";?>';
$txt = $encoded;
if (fwrite($myfile, $txt)) {
return TRUE;
} else {
return False;
}
fclose($myfile);
}
if (isset($_POST['installDB'])) {
$dbUser = $_POST['dbUser'];
$dbPass = $_POST['dbPass'];
$db = "ahsan044";
$dbHost = $_POST['dbHost'];
createFile($dbUser, $dbPass, $db, $dbHost);
$error = 0;
$file = 'sqllab.sql';
$db = new mysqli($dbHost, $dbUser, $dbPass);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
die;
}
$tmp = '';
$lines = file($file);
foreach ($lines as $line) {
if (substr($line, 0, 2) == '--' || $line == '') {
continue;
}
$tmp .= $line;
if (substr(trim($line), -1, 1) == ';') {
function _getKeywords()
{
if (empty($_REQUEST['keywords_plural'])) {
return 'Не указано слово во множественном числе';
}
if (!($url = makeValidAddress($_REQUEST['url']))) {
return array('status' => 'warning', 'message' => "Некорректный адрес страницы {$_REQUEST['url']}");
}
if ($_REQUEST['start'] == 'true') {
if (!createFile($_REQUEST['path_created_files'], $_REQUEST['file_name'])) {
return "Ошибка создания файла {$_REQUEST['file_name']}";
}
createFile($_REQUEST['path_created_files'], "tmp_{$_REQUEST['keywords']}.data");
}
return getListURL($url, $_REQUEST['keywords'], $_REQUEST['keywords_plural'], $_REQUEST['keywords_name'], $_REQUEST['file_name'], $_REQUEST['path_created_files']);
}
<?php
require_once "../utils.php";
$state = check_connected();
// User is connected
if ($state) {
// User has bought the option
if (checkOptions("reload")) {
// Text header
header("Content-type:text/plain");
// Write timestamp into user file
createFile("../../", $_COOKIE["ok"]);
} else {
NeedOption();
}
// Not connected
} else {
ForbiddenAccess();
}
function createFiles($name)
{
$filePath = __DIR__ . '/../modules/v1/controllers/' . $name . 'Controller.php';
echo json_encode(createFile($filePath, $name));
die;
}
$conn = OpenConn();
$mydbcharset = 'utf8';
//编码 gbk
$DB_PREFIX = @$_REQUEST['db_PREFIX'];
//表前面的前缀
$char = ' ENGINE=MyISAM DEFAULT CHARSET=' . $mydbcharset;
$sqlTables = array("{$DB_PREFIX}admin" => "CREATE TABLE `{$DB_PREFIX}admin` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`username` varchar(255) NOT NULL default '',\n`pwd` varchar(255) NOT NULL default '',\n`pseudonym` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`regip` varchar(255) NOT NULL default '',\n`upip` varchar(255) NOT NULL default '',\n`quanxian` mediumtext,\n`verificationmode` int(8) NOT NULL default '0',\n`adminlevel` varchar(255) NOT NULL default '',\n`channel` varchar(255) NOT NULL default '',\n`mtest` tinyint(1) NOT NULL default '0',\n`flags` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}articledetail" => "CREATE TABLE `{$DB_PREFIX}articledetail` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`parentid` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`views` int(8) NOT NULL default '0',\n`adminid` int(8) NOT NULL default '0',\n`smallimage` varchar(255) NOT NULL default '',\n`bigimage` varchar(255) NOT NULL default '',\n`bannerimage` varchar(255) NOT NULL default '',\n`downloadfile` varchar(255) NOT NULL default '',\n`smallimagealt` varchar(255) NOT NULL default '',\n`bigimagealt` varchar(255) NOT NULL default '',\n`bannerimagealt` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`titlecolor` varchar(255) NOT NULL default '',\n`titlealt` varchar(255) NOT NULL default '',\n`labletitle` varchar(255) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`occasions` varchar(255) NOT NULL default '',\n`hotline` varchar(255) NOT NULL default '',\n`model` varchar(255) NOT NULL default '',\n`author` varchar(255) NOT NULL default '',\n`articlesource` varchar(255) NOT NULL default '',\n`price` float(8) NOT NULL default '0',\n`newprice` float(8) NOT NULL default '0',\n`memberprice` float(8) NOT NULL default '0',\n`sold` int(8) NOT NULL default '0',\n`membertype` varchar(255) NOT NULL default '',\n`memberuser` varchar(255) NOT NULL default '',\n`hits` int(8) NOT NULL default '0',\n`productabout` mediumtext,\n`articledescription` mediumtext,\n`httpurl` varchar(255) NOT NULL default '',\n`recordurl` varchar(255) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`fontcolor` varchar(255) NOT NULL default '',\n`nofollow` int(8) NOT NULL default '0',\n`flags` varchar(255) NOT NULL default '',\n`ishtml` tinyint(1) NOT NULL default '0',\n`isonhtml` tinyint(1) NOT NULL default '0',\n`articleinfostyle` varchar(255) NOT NULL default '',\n`articleinfophotowidth` varchar(255) NOT NULL default '',\n`articleinfophotoheight` varchar(255) NOT NULL default '',\n`relatedtags` varchar(255) NOT NULL default '',\n`weight` int(8) NOT NULL default '0',\n`notebody` mediumtext,\n`aboutcontent` mediumtext,\n`temptxt1` mediumtext,\n`temptxt2` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}bidding" => "CREATE TABLE `{$DB_PREFIX}bidding` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`searchwords` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`showreason` varchar(255) NOT NULL default '',\n`ncomputersearch` int(8) NOT NULL default '0',\n`nmobliesearch` int(8) NOT NULL default '0',\n`ncountsearch` int(8) NOT NULL default '0',\n`nwordprice` int(8) NOT NULL default '0',\n`ndegree` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}caiconfig" => "CREATE TABLE `{$DB_PREFIX}caiconfig` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`bigclassname` varchar(255) NOT NULL default '',\n`stype` varchar(255) NOT NULL default '',\n`saction` varchar(255) NOT NULL default '',\n`startstr` varchar(255) NOT NULL default '',\n`endstr` varchar(255) NOT NULL default '',\n`startaddstr` varchar(255) NOT NULL default '',\n`endaddstr` varchar(255) NOT NULL default '',\n`fieldname` varchar(255) NOT NULL default '',\n`fieldcheck` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}caidata" => "CREATE TABLE `{$DB_PREFIX}caidata` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`bigclassname` varchar(255) NOT NULL default '',\n`columnname` varchar(255) NOT NULL default '',\n`stype` varchar(255) NOT NULL default '',\n`value1` mediumtext,\n`value2` mediumtext,\n`value3` mediumtext,\n`value4` mediumtext,\n`value5` mediumtext,\n`value6` mediumtext,\n`fieldname1` varchar(255) NOT NULL default '',\n`fieldname2` varchar(255) NOT NULL default '',\n`fieldname3` varchar(255) NOT NULL default '',\n`fieldname4` varchar(255) NOT NULL default '',\n`fieldname5` varchar(255) NOT NULL default '',\n`fieldname6` varchar(255) NOT NULL default '',\n`fieldcheck1` varchar(255) NOT NULL default '',\n`fieldcheck2` varchar(255) NOT NULL default '',\n`fieldcheck3` varchar(255) NOT NULL default '',\n`fieldcheck4` varchar(255) NOT NULL default '',\n`fieldcheck5` varchar(255) NOT NULL default '',\n`fieldcheck6` varchar(255) NOT NULL default '',\n`sortrank` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}caiweb" => "CREATE TABLE `{$DB_PREFIX}caiweb` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`bigclassname` varchar(255) NOT NULL default '',\n`columnname` varchar(255) NOT NULL default '',\n`httpurl` varchar(255) NOT NULL default '',\n`morepageurl` varchar(255) NOT NULL default '',\n`charset` varchar(255) NOT NULL default '',\n`thispage` int(8) NOT NULL default '0',\n`countpage` int(8) NOT NULL default '0',\n`stype` varchar(255) NOT NULL default '',\n`sortrank` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}feedback" => "CREATE TABLE `{$DB_PREFIX}feedback` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`columnid` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`feedbacktype` varchar(255) NOT NULL default '',\n`guestname` varchar(255) NOT NULL default '',\n`tel` varchar(255) NOT NULL default '',\n`fax` varchar(255) NOT NULL default '',\n`email` varchar(255) NOT NULL default '',\n`mobile` varchar(255) NOT NULL default '',\n`qq` varchar(255) NOT NULL default '',\n`msn` varchar(255) NOT NULL default '',\n`company` varchar(255) NOT NULL default '',\n`address` varchar(255) NOT NULL default '',\n`postcode` varchar(255) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`fontcolor` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` int(8) NOT NULL default '0',\n`reply` mediumtext,\n`replyip` mediumtext,\n`replydatetime` mediumtext,\n`notebody` mediumtext,\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}friendlink" => "CREATE TABLE `{$DB_PREFIX}friendlink` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`adminid` int(8) NOT NULL default '0',\n`title` varchar(255) NOT NULL default '',\n`titlecolor` varchar(255) NOT NULL default '',\n`labletitle` varchar(255) NOT NULL default '',\n`httpurl` varchar(255) NOT NULL default '',\n`sortrank` int(8) NOT NULL default '0',\n`titlealt` varchar(255) NOT NULL default '',\n`smallimage` varchar(255) NOT NULL default '',\n`smallimagealt` varchar(255) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`fontcolor` varchar(255) NOT NULL default '',\n`nofollow` int(8) NOT NULL default '0',\n`flags` varchar(255) NOT NULL default '',\n`ishtml` tinyint(1) NOT NULL default '0',\n`isonhtml` tinyint(1) NOT NULL default '0',\n`weight` int(8) NOT NULL default '0',\n`notebody` mediumtext,\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}guestbook" => "CREATE TABLE `{$DB_PREFIX}guestbook` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`columnid` varchar(255) NOT NULL default '',\n`parentid` int(8) NOT NULL default '0',\n`title` varchar(255) NOT NULL default '',\n`guestname` varchar(255) NOT NULL default '',\n`tel` varchar(255) NOT NULL default '',\n`fax` varchar(255) NOT NULL default '',\n`email` varchar(255) NOT NULL default '',\n`mobile` varchar(255) NOT NULL default '',\n`qq` varchar(255) NOT NULL default '',\n`msn` varchar(255) NOT NULL default '',\n`company` varchar(255) NOT NULL default '',\n`address` varchar(255) NOT NULL default '',\n`postcode` varchar(255) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`fontcolor` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` int(8) NOT NULL default '0',\n`reply` mediumtext,\n`replyip` mediumtext,\n`replydatetime` mediumtext,\n`notebody` mediumtext,\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}job" => "CREATE TABLE `{$DB_PREFIX}job` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`title` varchar(255) NOT NULL default '',\n`sex` varchar(255) NOT NULL default '',\n`age` varchar(255) NOT NULL default '',\n`education` varchar(255) NOT NULL default '',\n`workarea` varchar(255) NOT NULL default '',\n`monthly` varchar(255) NOT NULL default '',\n`startdatetime` varchar(255) NOT NULL default '',\n`enddatetime` varchar(255) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`fontcolor` varchar(255) NOT NULL default '',\n`nofollow` int(8) NOT NULL default '0',\n`flags` varchar(255) NOT NULL default '',\n`sortrank` int(8) NOT NULL default '0',\n`titlealt` varchar(255) NOT NULL default '',\n`smallimage` varchar(255) NOT NULL default '',\n`smallimagealt` varchar(255) NOT NULL default '',\n`isthrough` int(8) NOT NULL default '0',\n`ishtml` tinyint(1) NOT NULL default '0',\n`isonhtml` tinyint(1) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`notebody` mediumtext,\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}lineqq" => "CREATE TABLE `{$DB_PREFIX}lineqq` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`bigclassname` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`qq` varchar(255) NOT NULL default '',\n`isonlinechat` tinyint(1) NOT NULL default '0',\n`isaddfriend` tinyint(1) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}linevote" => "CREATE TABLE `{$DB_PREFIX}linevote` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`title` varchar(255) NOT NULL default '',\n`option1` varchar(255) NOT NULL default '',\n`option2` varchar(255) NOT NULL default '',\n`option3` varchar(255) NOT NULL default '',\n`option4` varchar(255) NOT NULL default '',\n`option5` varchar(255) NOT NULL default '',\n`option6` varchar(255) NOT NULL default '',\n`num1` int(8) NOT NULL default '0',\n`num2` int(8) NOT NULL default '0',\n`num3` int(8) NOT NULL default '0',\n`num4` int(8) NOT NULL default '0',\n`num5` int(8) NOT NULL default '0',\n`num6` int(8) NOT NULL default '0',\n`isdisplay` tinyint(1) NOT NULL default '0',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`banner` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`fontcolor` varchar(255) NOT NULL default '',\n`fontb` tinyint(1) NOT NULL default '0',\n`onhtml` tinyint(1) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`votetype` tinyint(1) NOT NULL default '0',\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}listmenu" => "CREATE TABLE `{$DB_PREFIX}listmenu` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`title` varchar(255) NOT NULL default '',\n`parentid` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`lablename` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isdisplay` tinyint(1) NOT NULL default '0',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}member" => "CREATE TABLE `{$DB_PREFIX}member` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`usertype` varchar(255) NOT NULL default '',\n`username` varchar(255) NOT NULL default '',\n`pwd` varchar(255) NOT NULL default '',\n`yunpwd` varchar(255) NOT NULL default '',\n`sex` varchar(255) NOT NULL default '',\n`age` int(8) NOT NULL default '0',\n`tel` varchar(255) NOT NULL default '',\n`phone` varchar(255) NOT NULL default '',\n`fax` varchar(255) NOT NULL default '',\n`email` varchar(255) NOT NULL default '',\n`postcode` varchar(255) NOT NULL default '',\n`address` varchar(255) NOT NULL default '',\n`company` varchar(255) NOT NULL default '',\n`regip` varchar(255) NOT NULL default '',\n`loginip` varchar(255) NOT NULL default '',\n`logincount` int(8) NOT NULL default '0',\n`logintime` varchar(250) NOT NULL default '',\n`lastlogintime` varchar(250) NOT NULL default '',\n`openid` varchar(255) NOT NULL default '',\n`accesstoken` varchar(255) NOT NULL default '',\n`nickname` varchar(255) NOT NULL default '',\n`qqphoto` varchar(255) NOT NULL default '',\n`useryear` int(8) NOT NULL default '0',\n`province` varchar(255) NOT NULL default '',\n`city` varchar(255) NOT NULL default '',\n`area` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` int(8) NOT NULL default '0',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}onepage" => "CREATE TABLE `{$DB_PREFIX}onepage` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`title` varchar(255) NOT NULL default '',\n`displaytitle` varchar(255) NOT NULL default '',\n`adminid` int(8) NOT NULL default '0',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`fontcolor` varchar(255) NOT NULL default '',\n`fontb` tinyint(1) NOT NULL default '0',\n`nofollow` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`views` int(8) NOT NULL default '0',\n`isrecommend` tinyint(1) NOT NULL default '0',\n`labletitle` varchar(255) NOT NULL default '',\n`banner` varchar(255) NOT NULL default '',\n`ishtml` tinyint(1) NOT NULL default '0',\n`isonhtml` tinyint(1) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`notebody` mediumtext,\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}payment" => "CREATE TABLE `{$DB_PREFIX}payment` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`username` varchar(255) NOT NULL default '',\n`memberid` varchar(255) NOT NULL default '',\n`sex` varchar(255) NOT NULL default '',\n`age` int(8) NOT NULL default '0',\n`tel` varchar(255) NOT NULL default '',\n`phone` varchar(255) NOT NULL default '',\n`fax` varchar(255) NOT NULL default '',\n`email` varchar(255) NOT NULL default '',\n`postcode` varchar(255) NOT NULL default '',\n`address` varchar(255) NOT NULL default '',\n`company` varchar(255) NOT NULL default '',\n`qqmsn` varchar(255) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` int(8) NOT NULL default '0',\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}previeworder" => "CREATE TABLE `{$DB_PREFIX}previeworder` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`memberid` varchar(255) NOT NULL default '',\n`orderid` varchar(255) NOT NULL default '',\n`productid` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`total` varchar(255) NOT NULL default '',\n`price` int(8) NOT NULL default '0',\n`productsum` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}productcomment" => "CREATE TABLE `{$DB_PREFIX}productcomment` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`username` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`pid` int(8) NOT NULL default '0',\n`ptitle` varchar(255) NOT NULL default '',\n`bodycontent` mediumtext,\n`sort` int(8) NOT NULL default '0',\n`ip` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}searchstat" => "CREATE TABLE `{$DB_PREFIX}searchstat` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`title` varchar(255) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`ishtml` tinyint(1) NOT NULL default '0',\n`isonhtml` tinyint(1) NOT NULL default '0',\n`views` int(8) NOT NULL default '0',\n`author` varchar(255) NOT NULL default '',\n`sortrank` int(8) NOT NULL default '0',\n`fontcolor` varchar(255) NOT NULL default '',\n`nofollow` int(8) NOT NULL default '0',\n`flags` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}systemlog" => "CREATE TABLE `{$DB_PREFIX}systemlog` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`msgstr` mediumtext,\n`tablename` varchar(255) NOT NULL default '',\n`url` mediumtext,\n`adminid` int(8) NOT NULL default '0',\n`adminname` varchar(255) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}tablecomment" => "CREATE TABLE `{$DB_PREFIX}tablecomment` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`userid` int(8) NOT NULL default '0',\n`itemid` int(8) NOT NULL default '0',\n`tablename` varchar(255) NOT NULL default '',\n`username` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`email` varchar(255) NOT NULL default '',\n`tel` varchar(255) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`reply` mediumtext,\n`notebody` mediumtext,\n`isthrough` int(8) NOT NULL default '0',\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}webcolumn" => "CREATE TABLE `{$DB_PREFIX}webcolumn` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`columnname` varchar(255) NOT NULL default '',\n`columnenname` varchar(255) NOT NULL default '',\n`columntype` varchar(255) NOT NULL default '',\n`parentid` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`views` int(8) NOT NULL default '0',\n`adminid` int(8) NOT NULL default '0',\n`isdisplay` tinyint(1) NOT NULL default '0',\n`smallimage` varchar(255) NOT NULL default '',\n`bigimage` varchar(255) NOT NULL default '',\n`bannerimage` varchar(255) NOT NULL default '',\n`flags` varchar(255) NOT NULL default '',\n`displaytitle` varchar(255) NOT NULL default '',\n`labletitle` varchar(255) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`foldername` varchar(255) NOT NULL default '',\n`filename` varchar(255) NOT NULL default '',\n`customaurl` varchar(255) NOT NULL default '',\n`templatepath` varchar(255) NOT NULL default '',\n`target` varchar(255) NOT NULL default '',\n`nofollow` int(8) NOT NULL default '0',\n`fontcolor` varchar(255) NOT NULL default '',\n`fontb` tinyint(1) NOT NULL default '0',\n`ismakehtml` tinyint(1) NOT NULL default '0',\n`npagesize` int(8) NOT NULL default '0',\n`sortsql` varchar(255) NOT NULL default '',\n`ishtml` tinyint(1) NOT NULL default '0',\n`isonhtml` tinyint(1) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`notebody` mediumtext,\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}webdomain" => "CREATE TABLE `{$DB_PREFIX}webdomain` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`bigclassname` varchar(255) NOT NULL default '',\n`website` varchar(255) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`webstate` int(8) NOT NULL default '0',\n`openspeed` int(8) NOT NULL default '0',\n`charset` varchar(255) NOT NULL default '',\n`content_type` varchar(255) NOT NULL default '',\n`server_name` varchar(255) NOT NULL default '',\n`isasp` tinyint(1) NOT NULL default '0',\n`isaspx` tinyint(1) NOT NULL default '0',\n`isphp` tinyint(1) NOT NULL default '0',\n`isjsp` tinyint(1) NOT NULL default '0',\n`ishtm` tinyint(1) NOT NULL default '0',\n`ishtml` tinyint(1) NOT NULL default '0',\n`nlinks` int(8) NOT NULL default '0',\n`links` mediumtext,\n`homepagelist` varchar(255) NOT NULL default '',\n`flags` varchar(255) NOT NULL default '',\n`websize` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isdomain` tinyint(1) NOT NULL default '0',\n`isthrough` tinyint(1) NOT NULL default '0',\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}weblayout" => "CREATE TABLE `{$DB_PREFIX}weblayout` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`layoutname` varchar(255) NOT NULL default '',\n`layoutlist` varchar(255) NOT NULL default '',\n`sourcestr` varchar(255) NOT NULL default '',\n`replacestr` varchar(255) NOT NULL default '',\n`actioncontent` mediumtext,\n`sortrank` int(8) NOT NULL default '0',\n`isdisplay` tinyint(1) NOT NULL default '0',\n`author` varchar(255) NOT NULL default '',\n`views` int(8) NOT NULL default '0',\n`adminid` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}webmodule" => "CREATE TABLE `{$DB_PREFIX}webmodule` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`moduletype` varchar(255) NOT NULL default '',\n`modulename` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`sortrank` int(8) NOT NULL default '0',\n`isdisplay` tinyint(1) NOT NULL default '0',\n`author` varchar(255) NOT NULL default '',\n`views` int(8) NOT NULL default '0',\n`adminid` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`aboutcontent` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}website" => "CREATE TABLE `{$DB_PREFIX}website` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`websiteurl` varchar(255) NOT NULL default '',\n`websitebottom` mediumtext,\n`websiteflow` int(8) NOT NULL default '0',\n`websiteflowstyle` int(8) NOT NULL default '0',\n`websiteflowmedian` int(8) NOT NULL default '0',\n`productlist` varchar(255) NOT NULL default '',\n`newslist` varchar(255) NOT NULL default '',\n`newsdid` varchar(255) NOT NULL default '',\n`tz51la` varchar(255) NOT NULL default '',\n`useremail` varchar(255) NOT NULL default '',\n`productdid` varchar(255) NOT NULL default '',\n`templateindex` mediumtext,\n`templatehome` mediumtext,\n`templatemain` mediumtext,\n`templatemain2` mediumtext,\n`templatemain3` mediumtext,\n`usenumb` mediumtext,\n`webrecord` varchar(255) NOT NULL default '',\n`contentwebrecord` mediumtext,\n`usehttpurl` varchar(255) NOT NULL default '',\n`tempusehttpurl` mediumtext,\n`webdate` varchar(250) NOT NULL default '',\n`webtitle` varchar(255) NOT NULL default '',\n`webkeywords` varchar(255) NOT NULL default '',\n`webdescription` mediumtext,\n`webtemplate` varchar(255) NOT NULL default '',\n`webskins` varchar(255) NOT NULL default '',\n`webfoldername` varchar(255) NOT NULL default '',\n`webimages` varchar(255) NOT NULL default '',\n`webcss` varchar(255) NOT NULL default '',\n`webjs` varchar(255) NOT NULL default '',\n`addwebsite` tinyint(1) NOT NULL default '0',\n`updatehtml` tinyint(1) NOT NULL default '0',\n`ishtmlformatting` tinyint(1) NOT NULL default '0',\n`isweblabelclose` tinyint(1) NOT NULL default '0',\n`iscntoen` tinyint(1) NOT NULL default '0',\n`flags` varchar(255) NOT NULL default '',\n`moduleskins` varchar(255) NOT NULL default '',\n`findtpl` varchar(255) NOT NULL default '',\n`replacetpl` varchar(255) NOT NULL default '',\n`webcodefindtpl` varchar(255) NOT NULL default '',\n`webcodereplacetpl` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`webhtml` varchar(255) NOT NULL default '',\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}websitestat" => "CREATE TABLE `{$DB_PREFIX}websitestat` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`visiturl` mediumtext,\n`viewurl` mediumtext,\n`browser` varchar(255) NOT NULL default '',\n`operatingsystem` varchar(255) NOT NULL default '',\n`screenwh` varchar(255) NOT NULL default '',\n`moreinfo` mediumtext,\n`viewdatetime` varchar(250) NOT NULL default '',\n`ip` varchar(255) NOT NULL default '',\n`dateclass` varchar(255) NOT NULL default '',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` int(8) NOT NULL default '0',\n`noteinfo` mediumtext,\n`bodycontent` mediumtext,\nPRIMARY KEY (`Id`)\n){$char};", "{$DB_PREFIX}weburlscan" => "CREATE TABLE `{$DB_PREFIX}weburlscan` (\n`id` int(5) unsigned NOT NULL auto_increment,\n`bigclassname` varchar(255) NOT NULL default '',\n`linktype` varchar(255) NOT NULL default '',\n`website` varchar(255) NOT NULL default '',\n`title` varchar(255) NOT NULL default '',\n`httpurl` varchar(255) NOT NULL default '',\n`totitle` varchar(255) NOT NULL default '',\n`tohttpurl` varchar(255) NOT NULL default '',\n`webstate` int(8) NOT NULL default '0',\n`openspeed` int(8) NOT NULL default '0',\n`charset` varchar(255) NOT NULL default '',\n`content_type` varchar(255) NOT NULL default '',\n`link_count` int(8) NOT NULL default '0',\n`websize` int(8) NOT NULL default '0',\n`sortrank` int(8) NOT NULL default '0',\n`adddatetime` varchar(250) NOT NULL default '',\n`updatetime` varchar(250) NOT NULL default '',\n`isthrough` tinyint(1) NOT NULL default '0',\nPRIMARY KEY (`Id`)\n){$char};");
//表前缀不为空 则修改config.php配置文件
if ($DB_PREFIX != '') {
$configPath = handlePath("./config.php");
if (checkfile($configPath) == true) {
require_once './Cai.php';
$content = getFText($configPath);
$s = strCut($content, '; $db_PREFIX= \'', '\'', 1);
$content = replace($content, $s, '; $db_PREFIX= \'' . $DB_PREFIX . '\'');
createFile($configPath, $content);
echo '修改config.php配置文件完成<hr>';
}
}
foreach ($sqlTables as $tableName => $tableSql) {
$conn->query("DROP TABLE IF EXISTS {$tableName}");
//为删除表
$conn->query($tableSql);
//为创建表
echo "创建数据表 {$tableName} 成功>><br>";
}
echo '<a href="../admin/index.php" target="_blank">登录后台</a>';
echo ' | <a href="../admin/index.php?act=setAccess&webdataDir=/Templates2015/sharembweb/WebData&login=out" target="_blank">导入默认数据</a>';
if (@$_REQUEST['loginname'] != '' && @$_REQUEST['loginpwd'] != '') {
$conn->query('insert into ' . $DB_PREFIX . 'admin (pseudonym,username,pwd,flags) values(\'' . @$_REQUEST['loginname'] . '\',\'' . @$_REQUEST['loginname'] . '\',\'' . myMD5(@$_REQUEST['loginpwd']) . '\',\'|*|\')');
} else {
$row_cnt = mysqli_num_rows($result);
if ($row_cnt == 0) {
$limit = checkRateLim($connectionT);
//print_r($limit);
if ($limit > 0) {
$row_cnt = mysqli_num_rows($result);
if ($row_cnt == 0) {
$user = $connectionT->get("followers/ids", array("count" => '5000'));
//print_r($user);
$array = $user->ids;
$sql = "INSERT INTO registered (userID) VALUES({$currentUser})";
if ($conn->query($sql) === TRUE) {
//echo "NEW RECORD CREATED SUCCESSFULLY";
}
// print_r($array);
saveConnections($currentUser, $array, $conn, $connectionT);
deleteFile();
createFile();
MakeJson($currentUser, $conn);
}
} else {
echo "Due to limitations we cannot retrieve any more data at this time. Please try again soon.";
}
} else {
deleteFile();
createfile();
MakeJson($currentUser, $conn);
}
}
echo "We have the data that is currently available for your network.";
echo "<a href='visualisation.php'>Visualise!</a>";
function SetPasswordChangeNeeded($_needed)
{
if ($_needed) {
createFile($this->ChangePasswordFile, "", false);
} else {
if (@file_exists($this->ChangePasswordFile)) {
@unlink($this->ChangePasswordFile);
}
}
}
/**
* Create a new authentication presenter-model-view triplet.
* @param string $name e.g.: "hello"
*/
function newAuth($name)
{
// lowercase for variables
$lowercase = strtolower($name);
// determine the prefix of our model
$prefix = current(preg_split('/(?<=\\w)(?=[A-Z])/', $name));
$presenterCode = <<<CODE
<?php if (!defined('FARI')) die();
/**
* User login and signoff.
*
* @package Application\\Presenters
*/
final class {$name}Presenter extends Fari_ApplicationPresenter {
/**#@+ where to redirect on successful login? */
const ADMIN = 'admin';
/**#@-*/
\tpublic function actionIndex(\$p) {
\$this->actionLogin();
}
\t/**
\t * User sign-in/login
\t */
\tpublic function actionLogin() {
// authenticate user if form data POSTed
if (\$this->request->getPost('username')) {
\$username = Fari_Decode::accents(\$this->request->getPost('username'));
\$password = Fari_Decode::accents(\$this->request->getPost('password'));
try {
\$user = new {$name}Auth(\$username, \$password, \$this->request->getPost('token'));
\$this->redirectTo('/' . self::ADMIN);
} catch ({$prefix}UserNotAuthenticatedException \$e) {
\$this->flashFail = "Sorry, your username or password wasn't recognized";
}
}
\t\t// create token & display login form
\t\t\$this->bag->token = Fari_FormToken::create();
\t\t\$this->renderAction('login');
\t}
\t/**
\t * Destroy user session.
\t */
public function actionLogout() {
try {
\$user = new {$name}User();
\$user->signOut();
\$this->flashSuccess = "You have been logged out";
} catch (AuthUserNotAuthenticatedException \$e) {
\$this->flashSuccess = 'You are already logged out';
}
// create token & display login form
\$this->bag->token = Fari_FormToken::create();
\t\t\$this->renderAction('login');
\t}
}
CODE;
$authModelCode = <<<CODE
<?php if (!defined('FARI')) die();
/**
* User authentication.
*
* @package Application\\Models\\{$prefix}
*/
class {$name}Auth {
/**
* Authenticate credentials using Fari_AuthenticatorSimple
* @param string \$username
* @param string \$password
* @param string \$token (optional)
* @return TestUser on success or TestUserNotAuthenticatedException thrown
*/
function __construct(\$username, \$password, \$token=NULL) {
\$authenticator = new Fari_AuthenticatorSimple('{$lowercase}');
// authenticator authenticates...
if (\$authenticator->authenticate(\$username, \$password, \$token) != TRUE) {
throw new {$prefix}UserNotAuthenticatedException();
} else {
// return the sweet beans
return new {$prefix}User();
}
}
}
CODE;
$userModelCode = <<<CODE
<?php if (!defined('FARI')) die();
/**
* Authenticated user.
*
* @example This object will throw an exception if user is not authenticated, use in admin
* @package Application\\Models\\{{$prefix}}
*/
class {$prefix}User extends Fari_AuthenticatorSimple {
private \$table;
/**
* Check that user is authenticated.
* @throws {$prefix}UserNotAuthenticatedException
*/
public function __construct() {
// construct the db table
\$this->table = new Table('{$lowercase}');
// call the authenticator
parent::__construct(\$this->table);
// no entry, we are not logged in, fail the constructor
if (!\$this->isAuthenticated()) throw new {$prefix}UserNotAuthenticatedException();
}
/**
* Fetch row from '{$lowercase}' table.
* @return array
*/
public function getUser() {
return \$this->table->findFirst()->where(array('username' => \$this->getCredentials()));
}
}
CODE;
$exceptionCode = <<<CODE
<?php if (!defined('FARI')) die();
/**
* User has not been authenticated.
*
* @package Application\\Models\\{$prefix}
*/
class {$prefix}UserNotAuthenticatedException extends Exception {}
CODE;
$layoutCode = <<<CODE
<?php if (!defined('FARI')) die(); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Language" content="en" />
<title>{$name}</title>
<?php stylesheetLinkTag('style'); ?>
</head>
<body>
<?php echo \$template; ?>
</body>
</html>
CODE;
$viewCode = <<<CODE
<?php if (!defined('FARI')) die(); ?>
<?php foreach (\flash() as \$message): ?>
<pre class="<?php echo \$message['key']; ?>"><?php echo \$message['text']; ?></pre>
<?php endforeach; ?>
<form class="form" method="POST" action="<?php url('/{$lowercase}/login/'); ?>">
<div class="field">
<label>Username</label>
<input name="username" type="text" />
</div>
<div class="field">
<label>Password</label>
<input name="password" type="password" />
</div>
<input type="hidden" name="token" value="<?php echo \$token; ?>" />
<input type="submit" class="button" value="Sign in" />
</form>
CODE;
$presenterPath = 'application/presenters';
$modelsPath = 'application/models';
$viewsPath = 'application/views';
// is dir writable?
if (!is_writable(BASEPATH . "/{$presenterPath}")) {
echo message("Cannot write into {$presenterPath} directory!", 'red');
} else {
// check path to presenters exists, dir-wise
$path = '';
foreach (explode('/', $presenterPath) as $dir) {
$path .= $dir . '/';
createDirectory($path);
}
// does the presenter file exist?
createFile("{$presenterPath}/{$name}Presenter.php", $presenterCode);
// check/create views directory
createDirectory($viewsPath . '/');
// presenter layout
createFile("{$viewsPath}/@{$lowercase}.phtml", $layoutCode);
// create appropriate presenter-named views dir
createDirectory("{$viewsPath}/{$name}/");
// default index file
createFile("{$viewsPath}/{$name}/login.phtml", $viewCode);
// models are in prefix subdirectory
createDirectory("{$modelsPath}/{$prefix}/");
// models & exceptions
createFile("{$modelsPath}/{$prefix}/{$prefix}Auth.php", $authModelCode);
createFile("{$modelsPath}/{$prefix}/{$prefix}User.php", $userModelCode);
createFile("{$modelsPath}/{$prefix}/{$prefix}UserNotAuthenticatedException.php", $exceptionCode);
}
}
date_default_timezone_set('PRC');
$path = 'file';
$path = @$_REQUEST["path"] ? $_REQUEST["path"] : $path;
$action = @$_REQUEST["action"];
$filename = @$_REQUEST["filename"];
$dirname = @$_REQUEST["dirname"];
$redirect = "index.php?path={$path}";
$info = @readDirectory($path);
if (!$info) {
alertMessage("没有文件或目录", "index.php?path=file");
}
//创建文件
if ($action == "createFile") {
//echo $path;
//echo $filename;
$message = createFile($path . '/' . $filename);
alertMessage($message, $redirect);
} elseif ($action == "showContent") {
//查看文件内容
$content = file_get_contents($filename, FILE_USE_INCLUDE_PATH);
//echo "<textarea readonly='readonly' cols='100' rows='10'>{$content}</textarea>";
//高亮显示PHP代码
//高亮显示文本中的代码
//highlight_file($filename);
if (strlen($content)) {
//高亮显示字符串中的PHP代码
$HightLightContent = highlight_string($content, true);
$str = <<<EOF
<table width="100%" bgcolor="#FFC" cellpadding="5" cellspacing='0'>
<tr>
<td>{$HightLightContent}</td>