Gecko [ ifk.uw.edu.pl ]

Name	Size	Permission
classes	[ DIR ]	drwxr-x---
cmsimg	[ DIR ]	drwxr-x---
cmsimg2	[ DIR ]	drwxr-x---
css	[ DIR ]	drwxr-x---
dewplayer	[ DIR ]	drwxr-x---
foto	[ DIR ]	drwxr-x---
images	[ DIR ]	drwxr-x---
mambots	[ DIR ]	drwxr-x---
mediaplayer	[ DIR ]	drwxr-x---
movies	[ DIR ]	drwxr-x---
pdfs	[ DIR ]	drwxr-x---
resources	[ DIR ]	drwxr-x---
sounds	[ DIR ]	drwxr-x---
sounds2	[ DIR ]	drwxr-x---
static	[ DIR ]	drwxr-x---
templates	[ DIR ]	drwxr-x---
tools	[ DIR ]	drwxr-x---
trash	[ DIR ]	drwxr-x---
video	[ DIR ]	drwxr-x---
00_ZRCola.eot	1.22 MB	-rw-r-----
00_ZRCola.ttf	1.22 MB	-rw-r-----
00_zrcola.woff	30.3 KB	-rw-r-----
00szukarka.php	600 B	-rw-r-----
Ksz084.jpg	150.97 KB	-rw-r-----
Ksz084_t.jpg	6.16 KB	-rw-r-----
auth.php	231 B	-rw-r-----
commonheader.php	2.23 KB	-rw-r-----
commonheaderProd.php	1018 B	-rw-r-----
d8e34b1cc8847a57a825ed381c0fc8...	9 B	-rw-r-----
db2.sql	27.05 MB	-rw-r-----
dbbackup.php	703 B	-rw-r-----
dewplayer.swf	8.74 KB	-rw-r-----
dymki.css	781 B	-rw-r-----
fckeditor_php4.php	6.04 KB	-rw-r-----
fckeditor_php5.php	6.01 KB	-rw-r-----
galeryjki.txt	16.61 KB	-rw-r-----
googlefbf7e2ca9f0f4509.html	53 B	-rw-r-----
including.html	71 B	-rw-r-----
index.html	185 B	-rw-r-----
index.old	11.54 KB	-rw-r-----
index.php	11.56 KB	-rw-r-----
index2.php_	10.97 KB	-rw-r-----
indexORIGTEST.php	84 B	-rw-r-----
info.php	227 B	-rw-r-----
leksykon.php	164 B	-rw-r-----
leksykonkaszubski.php	92 B	-rw-r-----
literatura.php	128 B	-rw-r-----
logout.php	100 B	-rw-r-----
mapaSerwisuStatic.php	337.71 KB	-rw-r-----
mapaserwisu.php	141 B	-rw-r-----
migration_helpers.txt	289 B	-rw-r-----
mysqlbackup.php	4.73 KB	-rw-r-----
nn.gif	807 B	-rw-r-----
phpinfo.php	25 B	-rw-r-----
player_flv_maxi.swf	12.67 KB	-rw-r-----
r0.jpg	547 B	-rw-r-----
r2.gif	821 B	-rw-r-----
r4.gif	821 B	-rw-r-----
r5.gif	821 B	-rw-r-----
r6.gif	821 B	-rw-r-----
r7.gif	821 B	-rw-r-----
servertypeNOUPLOAD.php	83 B	-rw-r-----
showthread.php_	3.95 KB	-rw-r-----
style.css	3.84 KB	-rw-r-----
stylecms.css	2.51 KB	-rw-r-----

Code Editor : mysqlbackup.php

<?php /*defined in your exampleconfig.php*/
define('DBUSER','dialektologia');
define('DBPASS','Despyith');
define('SERVERHOST','db1');
?>

<?php /*defined in examplemyclass.php*/
    class MySql{
        private $dbc;
        private $user;
        private $pass;
        private $dbname;
        private $host;

public function backup_tables($tables = '*'){  /* backup the db OR just a table */
            $host=$this->host;
            $user=$this->user;
            $pass=$this->pass;
            $dbname=$this->dbname;
            $data = "";
            //get all of the tables
            if($tables == '*')
            {
                $tables = array();
                $result = $this->dbc->prepare('SHOW TABLES'); 
                $result->execute();                         
                while($row = $result->fetch(PDO::FETCH_NUM)) 
                { 
                    $tables[] = $row[0]; 
                }
            }
            else
            {
                $tables = is_array($tables) ? $tables : explode(',',$tables);
            }
            //cycle through
            foreach($tables as $table)
            {
                $resultcount = $this->dbc->prepare('SELECT count(*) FROM '.$table);
                $resultcount->execute();
                $num_fields = $resultcount->fetch(PDO::FETCH_NUM);
                $num_fields = $num_fields[0];

$result = $this->dbc->prepare('SELECT * FROM '.$table);
                $result->execute();
                $data.= 'DROP TABLE '.$table.';';

$result2 = $this->dbc->prepare('SHOW CREATE TABLE '.$table);    
                $result2->execute();                            
                $row2 = $result2->fetch(PDO::FETCH_NUM);
                $data.= "\n\n".$row2[1].";\n\n";

for ($i = 0; $i < $num_fields; $i++) 
                {
                    while($row = $result->fetch(PDO::FETCH_NUM))
                    { 
                        $data.= 'INSERT INTO '.$table.' VALUES(';
                        for($j=0; $j<$num_fields; $j++) 
                        {
                            $row[$j] = addslashes($row[$j]); 
                            $row[$j] = str_replace("\n","\\n",$row[$j]);
                            if (isset($row[$j])) { $data.= '"'.$row[$j].'"' ; } else { $data.= '""'; }
                            if ($j<($num_fields-1)) { $data.= ','; }
                        }
                        $data.= ");\n";
                    }
                }
                $data.="\n\n\n";
            }
            //save filename
            $filename = 'db-backup-'.time().'-'.(implode(",",$tables)).'.sql';
            $this->writeUTF8filename($filename,$data);
        /*USE EXAMPLE
           $connection = new MySql(SERVERHOST,"your_db_name",DBUSER, DBPASS);
           $connection->backup_tables(); //OR backup_tables("posts");
           $connection->closeConnection();
        */
        } /*end function*/

private function writeUTF8filename($filenamename,$content){  /* save as utf8 encoding */
            $f=fopen($filenamename,"w+"); 
            # Now UTF-8 - Add byte order mark 
            fwrite($f, pack("CCC",0xef,0xbb,0xbf)); 
            fwrite($f,$content); 
            fclose($f); 
        /*USE EXAMPLE this is only used by public function above...
            $this->writeUTF8filename($filename,$data);
        */
        } /*end function*/

public function recoverDB($file_to_load){
            echo "write some code to load and proccedd .sql file in here ...";
        /*USE EXAMPLE this is only used by public function above...
            recoverDB("some_buck_up_file.sql");
        */
        } /*end function*/

public function closeConnection(){
            $this->dbc = null;
        //EXAMPLE OF USE 
        /*$connection->closeConnection();*/
        }/*end function*/

} /*END OF CLASS*/
    ?>

${this.title}

Code Editor : mysqlbackup.php