while ($row = $db->sql_fetchrow($result)) { $txt .= str_pad($row[0], 50); for ($j = 1; $j < $numfields; $j++) { $txt .= str_pad($row[$j], 30); } $txt .= "\n"; } file_put_contents(BASEDIR . 'cache/sql_result.txt', $txt); } switch ($mode) { case 'BackupDB': if (empty($tablelist)) { cpg_error('No tables found'); } require_once CORE_PATH . 'classes/sqlctrl.php'; SQLCtrl::backup($dbname, $tablelist, $filename, isset($_POST['dbstruct']), isset($_POST['dbdata']), isset($_POST['drop']), isset($_POST['gzip']), $full); break; case 'OptimizeDB': if (DB_TYPE == 'postgresql') { $db->sql_query('VACUUM ANALYZE'); $query = 'SELECT cl.relname as tablename, st.* FROM pg_class AS cl, pg_statistic AS st WHERE st.starelid=cl.relfilenode AND cl.relkind IN(\'r\') AND cl.relname NOT LIKE \'pg_%\' AND cl.relname NOT LIKE \'sql_%\' ORDER by cl.relname'; } else { $query = "{$type} TABLE " . implode(", ", $tablelist); } // register_shutdown_function('run_sql_in_background', $dbname, $type, $db, $query); show($mode, $dbname, $tablelist, $query); break; case 'CheckDB': if (DB_TYPE == 'postgresql') { show($mode, $tablelist, null); break;
define('ADMIN_MOD_INSTALL', 1); include 'modules/' . $class . '/sql/cpg_inst.php'; } else { if (file_exists(BASEDIR . 'modules/' . $class . '/cpg_inst.php')) { define('ADMIN_MOD_INSTALL', 1); include 'modules/' . $class . '/cpg_inst.php'; } } if (defined('ADMIN_MOD_INSTALL') && class_exists($class)) { $module = new $class(); $tables = array(); require_once CORE_PATH . 'classes/sqlctrl.php'; foreach ($module->dbtables as $table) { $tables[] = $prefix . '_' . $table; } SQLCtrl::backup($dbname, $tables, str_replace(' ', '_', $module->modname) . '.sql'); } } else { if (isset($_POST['save'])) { if ($CPG_SESS['admin']['page'] != 'modules') { cpg_error(_ERROR_BAD_LINK, _SEC_ERROR); } $mid = intval($_POST['save']); $custom_title = Fix_Quotes($_POST['custom_title'], true); $view = intval($_POST['view']); $inmenu = intval($_POST['inmenu']); $blocks = intval($_POST['blocks']); $result = $db->sql_query('SELECT title FROM ' . $prefix . "_modules WHERE mid={$mid}"); if ($db->sql_numrows($result) > 0) { list($title) = $db->sql_fetchrow($result); if ($title == 'Your_Account') {