";
if (isset($f)){
//echo "you seem to have pushed $f
";
switch ($f){
//SETTINGS
case "about":
include ('./settings/setting_about.php');
break;
case "help":
include ('./settings/setting_help.php');
break;
//TOOLS
case "search":
include ('./tools/tool_search.php');
break;
case "colorextract":
include ('./tools/tool_colorextract.php');
break;
case "itemwizard":
include ('./tools/tool_itemwizard.php');
break;
case "backupdb":
include ('./tools/tool_backupdb.php');
break;
case "upload":
include ('./tools/tool_upload.php');
break;
case "linkcheck":
include ('./tools/tool_linkcheck.php');
break;
case "rssfeeds":
include ('./tools/tool_rssfeeds.php');
break;
case "itemqueue":
include ('./tools/tool_itemqueue.php');
break;
case "tools":
include ('./tools/tool_tools.php');
break;
case "fillshelf":
include ('./tools/tool_fillshelf.php');
break;
case "groupwizard":
include ('./tools/tool_groupwizard.php');
break;
case "folderscan":
include ('./tools/tool_folderscan.php');
break;
case "optimize":
include ('./tools/tool_optimize.php');
break;
case "bindview":
include ('./tools/tool_bindview.php');
break;
case "clean":
include ('./tools/tool_clean.php');
break;
case "reset":
include ('./tools/tool_reset.php');
break;
case "seed":
include ('./tools/tool_seed.php');
break;
case "statscount":
include ('./tools/tool_statscount.php');
break;
case "keywordwizard":
include ('./tools/tool_keywordwizard.php');
break;
case "newswizard":
include ('./tools/tool_newswizard.php');
break;
case "filegrab":
include ('./tools/tool_filegrab.php');
break;
case "thumbnails":
include ('./tools/tool_thumbnails.php');
break;
case "bindcount":
include ('./tools/tool_bindcount.php');
break;
case "openinghours":
include ('./tools/tool_openinghours.php');
break;
//TABLES
default:
switch ($a){
/*
case "show_change":
$f=$_POST['f'];
$thisid=$_POST['id'];
$show=$_POST['show'];
//connect to db
require ("./include/connect_db.php");
mysql_select_db($globalConfig['dbname'], $link) or die("couldn't select database");
mysql_query("UPDATE $f SET show=$show WHERE id='$thisid'");
echo "
Item $thisid from table $f has been changed
";
break;
*/
case "delete":
$thisid=$_GET['id'];
echo "
Item $thisid from table $f has been deleted
";
echo "
| message |
|---|
";
//connect to db
require ("./include/connect_db.php");
mysql_select_db($globalConfig['dbname'], $link) or die("couldn't select database");
if ($f=="files"){
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."files WHERE id='$thisid'");
$resultrow=mysql_fetch_array($result);
$folderid=$resultrow[folderid];
$file="$resultrow[file]";
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."folders WHERE id='$folderid'");
$resultrow=mysql_fetch_array($result);
$mydir="$foliodomain/files/$resultrow[folder]";
unlink($mydir."/".$file);
echo "| # | actual file $file from $mydir deleted from harddisk |
";
//update the folderinfo
folderscan($mydir);
echo "| # | folder information for $resultrow[folder] updated |
";
}
if ($f=="folders"){
//remove corresponding files from binder
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."files WHERE folderid='$thisid'");
while($resultrow=mysql_fetch_array($result)){
$fileid=$resultrow[id];
mysql_query("DELETE FROM ".$globalConfig['dbprefix']."binder WHERE table1='files' AND record1='$fileid'");
mysql_query("DELETE FROM ".$globalConfig['dbprefix']."binder WHERE table2='files' AND record2='$fileid'");
}
echo "| # | all files out of this folder removed from binder |
";
//remove all files for folderid
mysql_query("DELETE FROM ".$globalConfig['dbprefix']."files WHERE folderid=$thisid");
echo "| # | all file entries out of this folder removed |
";
//get folder location
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."folders WHERE id='$thisid'");
$resultrow=mysql_fetch_array($result);
$mydir="$resultrow[folder]";
//remove folder and its contents physically
RemoveDirectory($mydir);
echo "| # | actual folder and all its files removed from harddisk |
";
//echo "| # | $removeaction |
";
//optimize table
mysql_query("OPTIMIZE TABLE files");
echo "| # | table files optimized |
";
}
//delete folder
mysql_query("DELETE FROM ".$globalConfig['dbprefix']."folders WHERE folder='$mydir'");
mysql_query("OPTIMIZE TABLE folders");
//delete db entry
mysql_query("DELETE FROM ".$globalConfig['dbprefix']."$f WHERE id=$thisid");
echo "| # | item $thisid deleted from table $f |
";
//optimize table
mysql_query("OPTIMIZE TABLE $f");
echo "| # | table ".$globalConfig['dbprefix']."$f optimized |
";
//remove all links in the binder
mysql_query("DELETE FROM ".$globalConfig['dbprefix']."binder WHERE table1='$f' AND record1='$thisid'");
echo "| # | item $thisid from table $f removed from binder masters |
";
mysql_query("DELETE FROM ".$globalConfig['dbprefix']."binder WHERE table2='$f' AND record2='$thisid'");
echo "| # | item $thisid from table $f removed from binder slaves |
";
//optimize table
mysql_query("OPTIMIZE TABLE ".$globalConfig['dbprefix']."binder");
echo "| # | table binder optimized |
";
echo "
";
echo "
click here to go back to $f";
break;
case "comment":
global $dblang, $lang, $cat, $page, $mode, $news, $dbname, $ezdb, $globalConfig, $userid, $sessionid, $admin, $f, $Fname, $Fvalue;
$posttable=$_POST['posttable'];
$postrecord=$_POST['postrecord'];
$postcom=$_POST['postcom'];
$postvote=$_POST['postvote'];
$ezdb->query("INSERT INTO ".$globalConfig['dbprefix']."comments VALUES (NULL, NOW(), '0', '1', '$postcom', '$postvote', '$sessionid', '$userid')");
$varid=$ezdb->get_var("SELECT id FROM ".$globalConfig['dbprefix']."comments WHERE comment='$postcom' AND vote='$postvote' AND sessionid='$sessionid' AND userid='$userid' ");
$ezdb->query("INSERT INTO ".$globalConfig['dbprefix']."binder VALUES (NULL, NOW(), '0', '1', '$posttable', '$postrecord', 'comments', '$varid', '', '', '$userid')");
echo "
Comment
";
echo "
Your comment has been added.
";
echo "
![](\"./ic/tools/start.png\")
return";
break;
case "edit":
echo "
We will edit record $id from table $f
";
echo "
![](\"./ic/tools/cancel.png\")
cancel";
//connect to database
require ("./include/connect_db.php");
mysql_select_db($globalConfig['dbname'], $link) or die("couldn't select database");
$jobs=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."$f WHERE id='$id' LIMIT 1");
//make form to submit changes
echo "
";
break;
case "update":
require ("./include/connect_db.php");
mysql_select_db($globalConfig['dbname'], $link) or die("couldn't select database");
$total=$_POST['total'];
$thisid=$_POST['update'][0];
$f=$_POST['f'];
$a=$_POST['a'];
echo "
Updated $thisid in $f
";
/*
$realtotal1=count($_POST['fieldname']);
$realtotal2=count($_POST['update']);
echo "$realtotal1 | $realtotal2";
*/
$updatequery="UPDATE ".$globalConfig['dbprefix']."$f SET id=id";
echo "
| fieldname | value |
|---|
";
$j=2; //we use $j for fieldvalues since unchecking the checkbox leaves a void
for( $i=2;$i<$total;$i++) {
$fieldname=$_POST['fieldname'][$i];
$fieldvalue=$_POST['update'][$j];
$fieldvalue=trim($fieldvalue);
$fieldvalue=preg_replace('//i', '', $fieldvalue);
$fieldvalue=nl2br($fieldvalue); //keep line breaks
//$fieldvalue=addslashes($fieldvalue);
//$fieldvalue=nl2br($fieldvalue); //keep line breaks
if ($fieldname=="public"){
if ($fieldvalue=="on"){
$fieldname="public";
$fieldvalue=1;
}else{
$fieldname="public";
$fieldvalue=0;
$j=$j-1;
}
}
if ($fieldname=="file"){
//get old file name
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."files WHERE id='$thisid'");
$resultrow=mysql_fetch_array($result);
$file="$resultrow[file]";
$folderid=$resultrow[folderid];
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."folders WHERE id='$folderid'");
$resultrow=mysql_fetch_array($result);
$folder=$resultrow[folder];
$mydir="$foliodomain/files/$folder/";
$newfile="$fieldvalue";
$oldfile="$file";
rename ($mydir.$oldfile,$mydir.$newfile);
}
//if (($fieldname=="text_uk") || ($fieldname=="text_jp")){
//}
if ($fieldname=="updated"){
$fieldvalue = date("Y-m-d H:i:s", Time());
echo $datemodified;
//$updatequery.=", $fieldname='$datemodified' ";
}
if ($fieldname=="folder"){
$newfolder="$foliodomain/files/$fieldvalue";
//get old folder name
//get folder id
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."folders WHERE id='$thisid'");
$resultrow=mysql_fetch_array($result);
$oldfolder=$resultrow[folder];
$oldfolder="$foliodomain/files/$oldfolder";
//rename folder
rename ($oldfolder,$newfolder);
}
//$mysqlstring = "UPDATE $f SET posted=NULL";
echo "| $fieldname | $fieldvalue |
";
$updatequery.=", $fieldname='$fieldvalue' ";
$j++;
}
echo "
";
//updating one by one since it's the only thing that seems to work for now
$updatequery.=" WHERE id='$thisid'";
mysql_query($updatequery);
//echo $updatequery."
";
echo "
![](\"./ic/tools/back.png\")
click here to go back to $f";
echo "
click here to edit $thisid in $f";
break;
case "new":
echo "
Post a new item for $f
";
$colorpicker=0; //color picker has not been printed yet, only print one time
echo "
cancel";
//connect to database
// requires the class
require "./classes/datepicker/class.datepicker.php";
require "./classes/folio_color_picker/color_picker.php";
require ("./include/connect_db.php");
mysql_select_db($globalConfig['dbname'], $link) or die("couldn't select database");
$jobs=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."$f LIMIT 1");
//make form to submit changes
echo "
";
break;
case "insert":
echo "
New item added in $f.
";
$total=$_POST['total']-1;
$userid=GetUserId($curUser);
$mysqlstring = "";
echo "
| fieldname | value |
|---|
";
for( $i=3;$i<$total;$i++) {
//$fieldvalue=isUTF8($_POST['insert'][$i]);
//$fieldvalue=utf8_decode($_POST['insert'][$i]);
$fieldvalue=$_POST['insert'][$i];
if (($fieldname=="text_uk") || ($fieldname=="text_jp")){
//keep line breaks
$fieldvalue = nl2br ( $fieldvalue );
}
echo "| ".$_POST['fieldname'][$i]." | ".$fieldvalue." |
";
$mysqlstring.=",'".$fieldvalue."'";
//if it's a folder, also create the actual folder
if (($f=="folders") AND ($_POST['fieldname'][$i]=="folder")){
$folderpath="$foliodomain/files/$fieldvalue";
mkdir($folderpath);
chmod($folderpath,0777);
}
}
echo "
";
echo "
click here to go back to $f";
echo "
![](\"./ic/tools/add.png\")
post a new item in $f";
//echo "
$mysqlstring";
//connect to database
global $globalConfig;
$dbname=$globalConfig['dbname'];
$dbprefix=$globalConfig['dbprefix'];
require ("./include/connect_db.php");
mysql_select_db($dbname, $link) or die("couldn't select database");
mysql_query("INSERT INTO ".$dbprefix."$f VALUES(NULL,NOW(),'' $mysqlstring ,'$userid')");
//echo "
DB UPDATED";
$lastid=$ezdb->get_var("SELECT id FROM ".$globalConfig['dbprefix']."$f ORDER BY id DESC LIMIT 1");
echo "
click here to edit $lastid in $f";
break;
default:
echo "
Overview of $f
";
//CountBindingsTable($f);
if( ($f<>"files") AND ($f<>"sessions") AND ($f<>"stats") AND ($f<>"log") ){
echo "
post a new item in $f";
}
$db=new mysql_dialog("1");
$db->connect($globalConfig['dbhost'],$globalConfig['dbuser'], $globalConfig['dbpass'], $globalConfig['dbname']);
//FILTER
$Fname=$_GET['Fname'];
$Fvalue=$_GET['Fvalue'];
if ((isset($Fname)) AND (isset($Fvalue)) AND ($Fname<>NULL) AND ($Fvalue<>NULL)){
$condition="WHERE $Fname='$Fvalue'";
} else {
$condition="";
}
//PAGINATION
$page=$_GET['page'];
$perpage=$globalConfig['adminperpage'];
//pagination buttons
$result=mysql_query("SELECT * FROM ".$globalConfig['dbprefix']."$f $condition");
$totalrows=mysql_num_rows($result);
$pages=ceil($totalrows/$perpage);
echo "items: $totalrows | ";
for( $i=1;$i<=$pages;$i++) {
echo "
page $i | ";
}
//pagination filter
if (isset($page)){
$offset=($page*$perpage)-$perpage;
$pagination="LIMIT $perpage OFFSET $offset";
}else{
$pagination="LIMIT $perpage";
}
//SORT
$Sname=$_GET['Sname'];
$Svalue=$_GET['Svalue'];
if ((isset($Sname)) AND (isset($Svalue)) AND ($Sname<>NULL) AND ($Svalue<>NULL)){
$sorting="ORDER BY $Sname $Svalue";
} else {
$sorting="ORDER BY id DESC";
}
//CountBindings($f, $Fvalue);
$SQL="SELECT * FROM ".$globalConfig['dbprefix']."$f $condition $sorting $pagination";
$db->speak($SQL);
$db->onscreen($SQL);
if(isset($f) AND ($Fname=="id")){
echo "
";
//bind wizard block
$bindsingle=AdminBindSingle($f, $Fvalue);
echo "
";
//related block
$related=AdminGetRelated($f, $Fvalue);
echo "
";
//detail block
$details=AdminGetDetails($f, $Fvalue);
echo "
";
/*
//comment block
$comment=AdminAllowComments($f, $Fvalue);
echo "";
*/
/*
//value block
$value=AdminAllowValues($f, $Fvalue);
echo "
";
echo "
![](\"./img/spacer.gif\")
"; //end recorddetailview
*/
}
break;
}//ending the switch a
} //ending the switch f
echo "
![](\"./ic/tables/".$item.".png\")
![](\"./ic/tools/".$item.".png\")