Php Fill Db6cib

From Fxp Wiki

Jump to: navigation, search
 
<html>
<body>
<?php
/*
Reads a JSPWiki data file directory
Loop through all files
Applies Regular expression changes
Saves the result in DB
*/
$replace = false;
$target = "db"; // file oder db
$filePathIn = "./out2/";
$dh = opendir($filePathIn) or die("couldn't open directory");
 
#test reading file 
/*
DELETE FROM `tiki_pages` WHERE hits IS NULL;
 
SELECT `pageName`, `data` FROM `tiki_pages` WHERE pageName = 'CinemaGattaca' OR pageName='Bilcorp' OR pageName='CookingGingerSauce' OR pageName='ArgumentationDtd' OR pageName='CinemaBlackPearl'
 
$file = "C:/p/web/www-data/jspwiki/Accessibility.txt";
$baseName = basename($file);
$fp = fopen($file, "r");
$strFile = file_get_contents($file);
$strFile = mysql_escape_string($strFile);
*/
$version = 1;
 
    while (!(($file = readdir($dh)) === false)) {
        if (is_dir("$filePathIn/$file")) {
        }
        else {
         $fileName = "$file";
         $filePathIn = "./out2/";
         //$filePathIn = "C:/p/web/www-data/Copiedejspwiki/";
         //$filePathIn = "C:/out1/";
         $file = "$filePathIn$file";
            if ($fp = fopen($file, "r")) {
            $count++;
            $baseName = basename($file);
            $baseName = str_replace(".txt","", $baseName);
            $strFile = file_get_contents($file);
            //$strFile = preg_replace("/<!--([\s|\S|\r]+)({{3})([\s|\S|\r]+)}{3}([\s|\S|\r]+)-->/","",$strFile,1);
            //$strFile = preg_replace("/<!--([\s|\S|\r]+)(StephenDonaldson|Higelin)([\s|\S|\r]+)-->/","",$strFile,1);
            //$strFile = preg_replace("/\(\((\w+)\|(\w+)(\){2})/","(($2|$1))",$strFile);
            //$strFile = preg_replace("/\(\(([^\|]+?)\|(\w+)(\){2})/","(($2|$1))",$strFile);
            $strFile = mysql_escape_string($strFile);
 
if (($target == "db")|($target == "both")){
    // process form
    $db = mysql_connect("localhost", "user", "pwd");
 
    $creator = "admin";
    mysql_select_db("cib1_1",$db);
    if ($replace){
    $sql = "DELETE FROM tiki_pages WHERE pageName = '$baseName'";
    $result = mysql_query($sql);
    $err = mysql_error();
    printf("Erased: $baseName -- $err<br />\n");
    }
    $sql = "INSERT INTO tiki_pages (pageName,hits,data,description,lastModif,comment,version,user,ip,creator) VALUES('$baseName','1','$strFile','','1094083448','','$version','admin','127.0.0.1','$creator')";
    //echo = "Query: 
    $result = mysql_query($sql);
    //$result = mysql_query($sql)or die(mysql_error());
    $err = mysql_error();
    printf("$count: $baseName...$err<br />\n");
    }
    
    elseif(($target == "db")|($target == "both")){
    $outputDir = "/out2/";
    $outputFile = ($outputDir . $baseName.".txt");
    $out = fopen($outputFile, "w");
    fwrite($out,$strFile);
    printf("$count: $baseName ...$err<br />\n");
    }
    /*
    echo "Result: $result $err<br/>";
    echo "Thank you! Information entered.<br />\n";
    echo "File: $file<br />";
    echo "BaseName: $baseName<br />";
*/
/*
    $result = mysql_query("SELECT pageName,lastModif FROM tiki_pages",$db);
    while ($myrow = mysql_fetch_row($result)) {
    printf("$count : %s<br />\n", $myrow[1]);
        }
        */
    }
    
}
}?>
</body>
</html>
TikiWiki
Retrieved from "http://www.fxparlant.net/Php_Fill_Db6cib"
Personal tools