function sql_connect_maintenance() { global $tpl, $db, $opt; sql_connect($opt['db']['maintenance_user'], $opt['db']['maintenance_password'], false); if ($db['dblink'] === false) { sql_disconnect(); sql_connect(); if ($db['connected'] == false) { $tpl->error(ERROR_DB_COULD_NOT_RECONNECT); } return false; } return true; }
function db_update($table, $fields, $pk = '', $show_query = 0) { // ej: $err=db_update('users',array('pass','user_name'),('id','id2'),1); // include("conexion.php"); if ($pk != '') { $query = 'update ' . $table . ' set '; $total_fields_pk = count($pk); $cant_fields_pk = 1; } else { $query = 'insert ignore into ' . $table . ' set '; } $total_fields = count($fields); $cant_fields = 1; foreach ($fields as $field => $field_value) { if ($field == 'pass' || $field == 'password') { $query .= $field . " = '" . md5(cleanQuery($field_value)) . "' "; } else { $query .= $field . " = '" . cleanQuery($field_value) . "' "; } if ($total_fields != $cant_fields) { $query .= ' , '; } $cant_fields++; } if ($pk != '') { $query .= ' where '; foreach ($pk as $field => $field_value) { $query .= $field . " = '" . cleanQuery($field_value) . "' "; if ($total_fields_pk != $cant_fields_pk) { $query .= ' and '; } $cant_fields_pk++; } } if ($show_query != 0) { echo $query . '<br />'; } //file_put_contents('request.txt', $query, FILE_APPEND); sql_connect(); if (mysql_query($query)) { return mysql_insert_id(); sql_disconnect(); } else { return mysql_insert_id(); sql_disconnect(); } }
function showInstallForm() { // 0. pre check if all necessary files exist doCheckFiles(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8" /> <title><?php echo _TITLE; ?> </title> <style type="text/css"><!-- @import url('../nucleus/documentation/styles/manual.css'); --></style> <script type="text/javascript"><!-- var submitcount = 0; // function to make sure the submit button only gets pressed once function checkSubmit() { if (submitcount == 0) { submitcount++; return true; } else { return false; } } --></script> </head> <body> <div style="text-align:center"><img src="../nucleus/styles/logo.gif" alt="<?php echo _ALT_NUCLEUS_CMS_LOGO; ?> " /></div> <!-- Nucleus logo --> <form method="post" action="index.php"> <h1><?php echo _HEADER1; ?> </h1> <?php echo _TEXT1; ?> <h1><?php echo _HEADER1_2; ?> </h1> <?php echo _TEXT1_2; ?> <fieldset> <legend><?php echo _TEXT1_2_TAB_HEAD; ?> </legend> <table> <tr> <td><?php echo _TEXT1_2_TAB_FIELD1; ?> </td> <td> <select name="charset" tabindex="10000"> <option value="utf8" selected="selected">UTF-8</option> <option value="ujis" >EUC-JP</option> </select> </td> </tr> </table> </fieldset> <h1><?php echo _HEADER2; ?> </h1> <?php echo _TEXT2; ?> <ul> <li>PHP: <?php echo phpversion(); ?> </li> <li>MySQL: <?php // Turn on output buffer // Needed to repress the output of the sql function that are // not part of php (in this case the @ operator doesn't work) ob_start(); // note: this piece of code is taken from phpMyAdmin $conn = sql_connect_args('localhost', '', ''); $result = @sql_query('SELECT VERSION() AS version', $conn); if ($result != FALSE && sql_num_rows($result) > 0) { $row = sql_fetch_array($result); $match = explode('.', $row['version']); } else { $result = @sql_query('SHOW VARIABLES LIKE \'version\'', $conn); if ($result != FALSE && @sql_num_rows($result) > 0) { $row = sql_fetch_row($result); $match = explode('.', $row[1]); } else { $output = function_exists('shell_exec') ? @shell_exec('mysql -V') : '0.0.0'; preg_match('#[0-9]+\\.[0-9]+\\.[0-9]+#', $output, $version); $match = explode('.', $version[0]); if ($match[0] == '') { $match[0] = '0'; $match[1] = '0'; $match[2] = '0'; } } } @sql_disconnect($conn); //End and clean output buffer ob_end_clean(); $mySqlVersion = implode($match, '.'); $minVersion = '3.23'; if (version_compare($mySqlVersion, '0.0.0', '==')) { echo _NOTIFICATION1; } else { echo $mySqlVersion; } if (version_compare($mySqlVersion, $minVersion, '<')) { echo ' <span class="warning" style="display:block">' . sprintf(_TEXT2_WARN1, $minVersion) . '</span>'; } ?> </li> </ul> <?php if (phpversion() < '5.0.0') { echo ' <p class="deprecated">' . _TEXT2_WARN2 . '</p>'; ?> </form> </body> </html> <?php exit; } // tell people how they can have their config file filled out automatically if (@file_exists('../config.php') && @(!is_writable('../config.php'))) { ?> <h1><?php echo _HEADER3; ?> </h1> <?php echo _TEXT3; } ?> <h1><?php echo _HEADER4; ?> </h1> <?php echo _TEXT4; ?> <fieldset> <legend><?php echo _TEXT4_TAB_HEAD; ?> </legend> <table> <tr> <td><label for="if_mySQL_host"><?php echo _TEXT4_TAB_FIELD1; ?> :</label></td> <td><input id="if_mySQL_host" name="mySQL_host" value="DUMMY_DB_HOST" tabindex="10010" /></td> </tr> <tr> <td><label for="if_mySQL_user"><?php echo _TEXT4_TAB_FIELD2; ?> :</label></td> <td><input id="if_mySQL_user" name="mySQL_user" value="DUMMY_PROJECT_NAME" tabindex="10020" /></td> </tr> <tr> <td><label for="if_mySQL_password"><?php echo _TEXT4_TAB_FIELD3; ?> :</label></td> <td><input id="if_mySQL_password" name="mySQL_password" value="DUMMY_DB_PASSWORD" type="password" tabindex="10030" /></td> </tr> <tr> <td><label for="if_mySQL_database"><?php echo _TEXT4_TAB_FIELD4; ?> :</label></td> <td><input id="if_mySQL_database" name="mySQL_database" value="DUMMY_PROJECT_NAME" tabindex="10040" /> (<input name="mySQL_create" value="1" type="checkbox" id="mySQL_create" tabindex="10050" /><label for="mySQL_create"><?php echo _TEXT4_TAB_FIELD4_ADD; ?> </label>)</td> </tr> </table> </fieldset> <fieldset> <legend><?php echo _TEXT4_TAB2_HEAD; ?> </legend> <table> <tr> <td><input name="mySQL_usePrefix" value="1" type="checkbox" id="mySQL_usePrefix" tabindex="10060" /><label for="mySQL_usePrefix"><?php echo _TEXT4_TAB2_FIELD; ?> :</label></td> <td><input name="mySQL_tablePrefix" value="" tabindex="10070" /></td> </tr> </table> <?php echo _TEXT4_TAB2_ADD; ?> </fieldset> <h1><?php echo _HEADER5; ?> </h1> <?php echo _TEXT5; ?> <?php // no need to this all! dirname(__FILE__) is all we need -- moraes /* // discover full path $fullPath = serverVar('PATH_TRANSLATED'); if ($fullPath == '') { $fullPath = serverVar('SCRIPT_FILENAME'); } $basePath = str_replace('install.php', '', $fullPath); $basePath = replaceDoubleBackslash($basePath); $basePath = replaceDoubleBackslash($basePath); // add slash at end if necessary if (!endsWithSlash($basePath) ) { $basePath .= '/'; } */ $basePath = str_replace('install', '', dirname(__FILE__)); ?> <fieldset> <legend><?php echo _TEXT5_TAB_HEAD; ?> </legend> <table> <tr> <td><label for="if_IndexURL"><?php echo _TEXT5_TAB_FIELD1; ?> :</label></td> <td><input id="if_IndexURL" name="IndexURL" size="60" value="<?php $url = 'http://' . serverVar('HTTP_HOST') . serverVar('PHP_SELF'); $url = str_replace('install/index.php', '', $url); $url = replaceDoubleBackslash($url); // add slash at end if necessary if (!endsWithSlash($url)) { $url .= '/'; } echo $url; ?> " tabindex="10080" /></td> </tr> <tr> <td><label for="if_AdminURL"><?php echo _TEXT5_TAB_FIELD2; ?> :</label></td> <td><input id="if_AdminURL" name="AdminURL" size="60" value="<?php if ($url) { echo $url . 'nucleus/'; } ?> " tabindex="10090" /></td> </tr> <tr> <td><label for="if_AdminPath"><?php echo _TEXT5_TAB_FIELD3; ?> :</label></td> <td><input id="if_AdminPath" name="AdminPath" size="60" value="<?php if ($basePath) { echo $basePath . 'nucleus/'; } ?> " tabindex="10100" /></td> </tr> <tr> <td><label for="if_MediaURL"><?php echo _TEXT5_TAB_FIELD4; ?> :</label></td> <td><input id="if_MediaURL" name="MediaURL" size="60" value="<?php if ($url) { echo $url . 'media/'; } ?> " tabindex="10110" /></td> </tr> <tr> <td><label for="if_MediaPath"><?php echo _TEXT5_TAB_FIELD5; ?> :</label></td> <td><input id="if_MediaPath" name="MediaPath" size="60" value="<?php if ($basePath) { echo $basePath . 'media/'; } ?> " tabindex="10120" /></td> </tr> <tr> <td><label for="if_SkinsURL"><?php echo _TEXT5_TAB_FIELD6; ?> :</label></td> <td><input id="if_SkinsURL" name="SkinsURL" size="60" value="<?php if ($url) { echo $url . 'skins/'; } ?> " tabindex="10130" /> <br />(<?php echo _TEXT5_TAB_FIELD7_2; ?> ) </td> </tr> <tr> <td><label for="if_SkinsPath"><?php echo _TEXT5_TAB_FIELD7; ?> :</label></td> <td><input id="if_SkinsPath" name="SkinsPath" size="60" value="<?php if ($basePath) { echo $basePath . 'skins/'; } ?> " tabindex="10140" /> <br />(<?php echo _TEXT5_TAB_FIELD7_2; ?> ) </td> </tr> <tr> <td><label for="if_PluginURL"><?php echo _TEXT5_TAB_FIELD8; ?> :</label></td> <td><input id="if_PluginURL" name="PluginURL" size="60" value="<?php if ($url) { echo $url . 'nucleus/plugins/'; } ?> " tabindex="10150" /></td> </tr> <tr> <td><label for="if_ActionURL"><?php echo _TEXT5_TAB_FIELD9; ?> :</label></td> <td><input id="if_ActionURL" name="ActionURL" size="60" value="<?php if ($url) { echo $url . 'action.php'; } ?> " tabindex="10160" /> <br />(<?php echo _TEXT5_TAB_FIELD9_2; ?> ) </td> </tr> </table> </fieldset> <?php echo _TEXT5_2; ?> <h1><?php echo _HEADER6; ?> </h1> <?php echo _TEXT6; ?> <fieldset> <legend><?php echo _TEXT6_TAB_HEAD; ?> </legend> <table> <tr> <td><label for="if_User_name"><?php echo _TEXT6_TAB_FIELD1; ?> :</label></td> <td><input id="if_User_name" name="User_name" value="" tabindex="10170" /> <small>(<?php echo _TEXT6_TAB_FIELD1_2; ?> )</small></td> </tr> <tr> <td><label for="if_User_realname"><?php echo _TEXT6_TAB_FIELD2; ?> :</label></td> <td><input id="if_User_realname" name="User_realname" value="" tabindex="10180" /></td> </tr> <tr> <td><label for="if_User_password"><?php echo _TEXT6_TAB_FIELD3; ?> :</label></td> <td><input id="if_User_password" name="User_password" type="password" value="" tabindex="10190" /></td> </tr> <tr> <td><label for="if_User_password2"><?php echo _TEXT6_TAB_FIELD4; ?> :</label></td> <td><input id="if_User_password2" name="User_password2" type="password" value="" tabindex="10200" /></td> </tr> <tr> <td><label for="if_User_email"><?php echo _TEXT6_TAB_FIELD5; ?> :</label></td> <td><input id="if_User_email" name="User_email" value="" tabindex="10210" /> <small>(<?php echo _TEXT6_TAB_FIELD5_2; ?> )</small></td> </tr> </table> </fieldset> <h1><?php echo _HEADER7; ?> </h1> <?php echo _TEXT7; ?> <fieldset> <legend><?php echo _TEXT7_TAB_HEAD; ?> </legend> <table> <tr> <td><label for="if_Blog_name"><?php echo _TEXT7_TAB_FIELD1; ?> :</label></td> <td><input id="if_Blog_name" name="Blog_name" size="60" value="My Nucleus CMS" tabindex="10220" /></td> </tr> <tr> <td><label for="if_Blog_shortname"><?php echo _TEXT7_TAB_FIELD2; ?> :</label></td> <td><input id="if_Blog_shortname" name="Blog_shortname" value="mynucleuscms" tabindex="10230" /> <small>(<?php echo _TEXT7_TAB_FIELD2_2; ?> )</small></td> </tr> </table> </fieldset> <h1><?php echo _HEADER8; ?> </h1> <fieldset> <legend><?php echo _TEXT8_TAB_HEADER; ?> </legend> <table> <tr> <td><input name="Weblog_ping" value="1" type="checkbox" id="Weblog_ping" tabindex="10240" /><label for="Weblog_ping"><?php echo _TEXT8_TAB_FIELD1; ?> </label></td> </tr> </table> </fieldset> <h1><?php echo _HEADER9; ?> </h1> <?php echo _TEXT9; ?> <p> <input name="action" value="go" type="hidden" /> <input type="submit" value="<?php echo _BUTTON1; ?> " onclick="return checkSubmit();" tabindex="10250" /> </p> </form> </body> </html> <?php }
function redirect($page) { global $cookie, $opt; $cookie->close(); // close db-connection sql_disconnect(); $this->header(); if (strpos($page, "\n") !== false) { $page = substr($page, 0, strpos($page, "\n")); } // redirect if (substr($page, 0, 7) != 'http://') { if (substr($page, 0, 1) == '/') { $page = substr($page, 1); } $page = $opt['page']['absolute_url'] . $page; } if ($opt['session']['mode'] == SAVE_SESSION) { if (defined('SID') && SID != '' && session_id() != '') { if (strpos($page, '?') === false) { header("Location: " . $page . '?' . urlencode(session_name()) . '=' . urlencode(session_id())); } else { header("Location: " . $page . '&' . urlencode(session_name()) . '=' . urlencode(session_id())); } } else { header("Location: " . $page); } } else { header("Location: " . $page); } exit; }
function sql_connect_root() { global $tpl, $db, $opt; if (file_exists($opt['rootpath'] . 'config2/sqlroot.inc.php')) { require $opt['rootpath'] . 'config2/sqlroot.inc.php'; } else { return false; } sql_disconnect(); sql_connect($opt['sqlroot']['username'], $opt['sqlroot']['password'], false); if ($db['dblink'] === false) { sql_disconnect(); sql_connect(); if ($db['connected'] == false) { $tpl->error(ERROR_DB_COULD_NOT_RECONNECT); } return false; } return true; }