\n";
fputs( $FH, "\n\n\n" );
fclose( $FH );
exec( "chmod 0777 ".$filename );
flush();
}
}
/// archive the sql files...
$filename = $mainfolder."sql_".$timestamp.".tar";
$msg = exec( "tar -cvf ".$filename." ".$subfolder."*.sql");
$msg = exec( "CHMOD 0777 ".$filename );
echo "COMPLETED WRITING CREATING TARBALL: ".$filename." ".$msg."
\n";
//$text = system("/usr/bin/gzip -c9 $filename > $filename".".gz");
$msg = exec( "/usr/bin/gzip -9 ".$filename );
echo "DONE! - gZipped as: ".$filename.".gz ".$msg."
\n";
flush();
/// when cleanup was requested...
if( $bCleanup ) {
$msg = system( "rm ".$subfolder."*.sql" );
$msg = system( "rmdir ".$subfolder );
}
/// all done...
AdminLinks();
return true;
} // MysqlDumper()
///-------------------------------------------------------------------------
function SystemForm() {
global $PHP_SELF, $CMD;
?>
";
system($CMD);
echo "";
SystemForm();
} // SystemRun()
///-------------------------------------------------------------------------
function ShowVarsInfo() {
global $g_oNDB, $tick;
/// all done...
AdminLinks();
/// PHP info...
if( $tick!="" ) echo "magic quotes are ".($tick=="'" ? "OFF" : "ON")."
\n";
echo "PHP Version: ".phpversion()."
\n";
echo "_SESSION (not HTTP_SESSION_VARS)
\n";
printArray( $_SESSION ); // _SESSION
echo "
\n";
/// server info...
echo "_SERVER (not HTTP_SERVER_VARS)
\n";
printArray( $_SERVER ); // $_SERVER
echo "
\n";
/// show all of the ini/gpc settings if possible...
echo "
INI settings...
";
$a = ini_get_all();
$i = 0;
$output="";
while( list($key, $value) = each($a) ) {
list($k, $v)= each( $a[$key] );
$output .= "| $key | $v | $k |
";
}
$output.="
"; //Finish up
echo $output; //Spit it all out
/// session # testing...
$sessionID = session_id();
$sessionNum = hexdec($sessionID);
//$sessionNum = hexdec(substr($sessionID,0,16));
//$sessionNum = sprintf( "%.32d", $sessionNum );
$sessionNum = number_format( $sessionNum, 32, "", "" );
echo "
$sessionID == $sessionNum
\n";
/// [NL:2018] (disabled) MySQL Informations...
//echo "
MySQL Version: " . $g_oNDB->getField("SELECT Version()") . "
\n";
//ShowTables();
//echo "
";
/// variables...
echo "GLOBALS\n";
print_r( $GLOBALS );
//var_dump( $GLOBALS );
echo "
\n";
/// random testing...
echo "TESTING...\n";
$temp = "memberID=1234:productID=4321";
eregi("memberID=(.*):productID=(.*)$",$temp,$regs);
$memberID = intval($regs[1]);
$productID = intval($regs[2]);
echo "
MEMBER / Product: '$memberID' : '$productID'
";
list( $a, $b, $c ) = array( "'AA", "B'B", "CC'" );
echo "ABC1 = $a:$b:$c
\n";
} // ShowVarsInfo()
///-------------------------------------------------------------------------
function CustomSelectForm2D( $bFocus=true ) {
global $PHP_SELF, $SQL, $SQL2, $SaveSQLs2;
?>
document.CustomSelectForm.SQL.focus();";
} // CustomSelectForm2D()
//-------------------------------------------------------------------------
// Execute2D: Execute a 2-Dimensional SQL querying.
// SQL: SELECT signup.ID as signupID, studentID, schoolName, school, username FROM customer LEFT JOIN signup ON customer.id=signup.studentID WHERE teacher='elmprep' AND school<>schoolName ORDER BY customer.ID desc
// SQL2: UPDATE signup SET school='$school' WHERE ID=$signupID
//-------------------------------------------------------------------------
function Execute2D( $SQL, $SQL2, $bRun ) {
/// initz; get the field names...
echo "Execute2D\n";
$hData = mysql_query($SQL);
$fields = array();
for( $i=0; $i
\n";
/// print out or save as a CMD each output row...
$counter = 0;
$inserted = 0;
while( $rData = mysql_fetch_array($hData) ) {
if( !$bRun && ++$counter > 25 ) {
echo "
";
return;
}
$CMD = $SQL2;
for( $i=0; $i\n";
}
}
echo "";
if( $inserted>0 ) {
echo "".$inserted." sql cmds inserted
\n";
printArray(getRow("SELECT * FROM sql ORDER BY ID DESC LIMIT 1"));
}
} // Execute2D
///-------------------------------------------------------------------------
function RegularLinks() {
/* NYI */
} // RegularLinks()
//-------------------------------------------------------------------------
// AdminLinks: Links for the the superadmin N user.
//-------------------------------------------------------------------------
function AdminLinks() {
?>
Show Tables ·
Custom Query |
All:
Optimize ·
Repair ·
Explain ·
Show Create
Change DB ·
MySQL Dumper ·
2D-CMD ·
SqlExecutor |
Show Vars ·
System Command