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>