";
if (isset($_POST['save'])) {
$data = array("",$_POST['username'],md5($_POST['password']), $_POST['name'], $_POST['email'], null, null, null, null);
$obj = new userObj($data);
UserServices::addUser($obj);
}
$users = UserServices::getAllUsers();
$header = array("Full name","Username","Email","Group","Created","","","","");
printTableOpen();
printRowHeader($header);
foreach ($users as $userObj) {
printTr();
printRow($userObj->getFullname());
printRow($userObj->getUsername());
printRow($userObj->getEmail());
printRow($userObj->getRoleName());
printRow(date("d.m.Y",strtotime($userObj->getDateCreated())));
printCustomRow($userObj->getUserID(),$CURRENT_PAGE,"icon_user_purple","Change user role","changeRole");
printCustomRow($userObj->getUserID(),$CURRENT_PAGE,"icon_change_pass","Reset password","changePassword");
printCustomRow($userObj->getUserID(),$CURRENT_PAGE,"icon_del","Delete user","deleteUser");
printCustomRow($userObj->getUserID(),$CURRENT_PAGE,"icon_xml","Export user data","exportUser");
printTr(false);
}
printTableClose();
echo "
";
}
/*
Languages
*/
if ($CURRENT_PAGE == "languages") {
$langSelectionUpdate = false;
if (isset($_POST['langupdate'])) {
if (!isset($_POST['languages'])) {
VCDException::display('At least one language must be selected.');
print "";
exit();
} else {
// Update the language restrictions
$newLangArr = $_POST['languages'];
$l = new VCDLanguage();
$l->setRestrictions($newLangArr);
$langSelectionUpdate = true;
}
}
$ClassLanguage = new VCDLanguage();
$arrFiles = $ClassLanguage->getTranslationFiles();
$arrAvailableLangs = array();
if ($ClassLanguage->isRestricted()) {
foreach ($ClassLanguage->getAllLanguages() as $langObj) {
array_push($arrAvailableLangs, $langObj->getID());
}
}
print "";
echo "";
}
/*
Case Web Settings
*/
if ($CURRENT_PAGE == "settings") {
require("forms/addSettings.php");
/****************/
/* Add Settings */
if (isset($_POST['save'])) {
if (!isset($_POST['protect']))
$protected = false;
else
$protected = true;
$data = array("",$_POST['key'],$_POST['value'],$_POST['description'],$protected, "");
$obj = new settingsObj($data);
SettingsServices::addSettings($obj);
}
/****************/
/* Update Settings */
elseif (isset($_POST['update'])) {
$obj = SettingsServices::getSettingsByID($_POST['id']);
if (!$obj->isProtected()) {
if (isset($_POST['protect'])) {
$obj->setProtected(true);
}
}
$obj->setValue($_POST['value']);
$obj->setDescription($_POST['description']);
SettingsServices::updateSettings($obj);
print "";
exit();
}
/*****************/
echo "";
$settings = SettingsServices::getAllSettings();
$header = array("Description","Value","Locked","","");
printTableOpen();
printRowHeader($header);
foreach ($settings as $settingsObj) {
printTr();
//printRow($settingsObj->getKey());
printRow($settingsObj->getDescription());
if (strcmp($settingsObj->getType(), 'bool') ==0) {
printRow((bool)$settingsObj->getValue());
} else {
printRow($settingsObj->getValue());
}
printRow((bool)$settingsObj->isProtected());
printEditRow($settingsObj->getID(), $CURRENT_PAGE);
printDeleteRow($settingsObj->getID(), $CURRENT_PAGE, "Delete settings ?");
printTr(false);
}
printTableClose();
echo "
";
}
/*
Case USER Roles
*/
if ($CURRENT_PAGE == "roles") {
require("forms/addRole.php");
/* Add Settings */
if (isset($_POST['save'])) {
$data = array("",$_POST['key'],$_POST['value'],$_POST['description'],$protected);
}
/*****************/
echo "";
$roles = UserServices::getAllUserRoles();
$defaultRoleObj = UserServices::getDefaultRole();
$header = array("Role name","Description"," "," ");
printTableOpen();
printRowHeader($header);
foreach ($roles as $userRolesObj) {
printTr();
printRow($userRolesObj->getRoleName());
printRow($userRolesObj->getRoleDescription());
if ($userRolesObj === $defaultRoleObj) {
printCustomRow($userRolesObj->getRoleID(), $CURRENT_PAGE, "../rssuser", "This is the default role", "void");
} else {
printCustomRow($userRolesObj->getRoleID(), $CURRENT_PAGE, "icon_user_purple", "Set as default role", "setDefaultRole");
}
printDeleteRow($userRolesObj->getRoleID(), $CURRENT_PAGE, "Delete role ?");
printTr(false);
}
printTableClose();
echo "
";
}
/*
Case Source Sites
*/
if ($CURRENT_PAGE == "sites") {
require("forms/addSite.php");
/* Add Settings */
if (isset($_POST['save'])) {
$fetchable = 0;
if (isset($_POST['isFetchable']))
$fetchable = 1;
$data = array("",$_POST['name'],$_POST['alias'],$_POST['homepage'],$_POST['command'],$fetchable,$_POST['classname'], $_POST['imagename']);
$sObj = new sourceSiteObj($data);
SettingsServices::addSourceSite($sObj);
print "";
exit();
}
/* Update Source site */
elseif (isset($_POST['update'])) {
$fetchable = 0;
if (isset($_POST['isFetchable']))
$fetchable = 1;
$data = array($_POST['id'],$_POST['name'],$_POST['alias'],$_POST['homepage'],$_POST['command'],$fetchable,$_POST['classname'], $_POST['imagename']);
$obj = new sourceSiteObj($data);
SettingsServices::updateSourceSite($obj);
print "";
exit();
}
/****************/
echo "";
$sites = SettingsServices::getSourceSites();
$header = array("Site name","Alias", "Fetchable", "","");
printTableOpen();
printRowHeader($header);
foreach ($sites as $sourceSiteObj) {
printTr();
$name = "getHomepage()."\" target=\"_new\">".$sourceSiteObj->getName()."";
printRow($name);
printRow($sourceSiteObj->getAlias());
printRow((bool)$sourceSiteObj->isFetchable());
printEditRow($sourceSiteObj->getsiteID(), $CURRENT_PAGE);
printDeleteRow($sourceSiteObj->getsiteID(), $CURRENT_PAGE, "Delete site?");
printTr(false);
}
printTableClose();
unset($sites);
echo "
";
}
/*
Case Media Types
*/
if ($CURRENT_PAGE == "media_types") {
$mtypes = SettingsServices::getAllMediatypes();
require("forms/addMediaType.php");
/* Add Media Type */
if (isset($_POST['save'])) {
// Get the default DB NULL value
$parent = "NULL";
if (strcmp($_POST['parent'],"null") != 0) {
$parent = $_POST['parent'];
}
$data = array("",$_POST['name'], $parent, $_POST['description']);
$obj = new mediaTypeObj($data);
SettingsServices::addMediaType($obj);
// Update the new RecordSet
$mtypes = SettingsServices::getAllMediatypes();
unset($data);
}
/*****************/
/* Update Media Type */
elseif (isset($_POST['update'])) {
$obj = SettingsServices::getMediaTypeByID($_POST['id']);
$obj->setDescription($_POST['description']);
$obj->setParentID($_POST['parent']);
SettingsServices::updateMediaType($obj);
print "";
exit();
}
/*****************/
echo "";
if (is_array($mtypes) && sizeof($mtypes) > 0) {
$header = array("Type name", "Description", "");
printTableOpen();
printRowHeader($header);
foreach ($mtypes as $mediaTypeObj) {
printTr();
printRow($mediaTypeObj->getName());
printRow($mediaTypeObj->getDescription());
printEditRow($mediaTypeObj->getmediaTypeID(), $CURRENT_PAGE);
printDeleteRow($mediaTypeObj->getmediaTypeID(), $CURRENT_PAGE, "Delete mediatype?");
printTr(false);
// Printout each child
if ($mediaTypeObj->getChildrenCount() > 0) {
foreach ($mediaTypeObj->getChildren() as $childObj) {
printTr();
printRow($childObj->getName(), "child");
printRow($childObj->getDescription(),"child");
printEditRow($childObj->getmediaTypeID(), $CURRENT_PAGE);
printDeleteRow($childObj->getmediaTypeID(), $CURRENT_PAGE, "Delete mediatype?");
printTr(false);
}
}
}
printTableClose();
} else {
print "No media types available.";
}
echo "
";
}
/*
Case Metadata Types
*/
if ($CURRENT_PAGE == "metadata_types") {
$mdtypes = SettingsServices::getMetadataTypes(null);
$users = UserServices::getAllUsers();
require("forms/addMetadataType.php");
/* Add Media Type */
if (isset($_POST['save'])) {
$obj = new metadataTypeObj(-1, $_POST['name'], $_POST['description'], (int)$_POST['owner_id'], isset($_POST['public']) && $_POST['public'] == "on");
SettingsServices::addMetadataType($obj);
// Update the new RecordSet
$mdtypes = SettingsServices::getMetadataTypes(null);
unset($obj);
}
/* Update Metadata Type */
if (isset($_POST['update'])) {
$obj = SettingsServices::getMetadataType(null, $_POST['id']);
if(!$obj->isSystemObj()) {
$obj->setMetadataTypeName($_POST['name']);
$obj->setMetadataTypeDescription($_POST['description']);
$obj->setMetadataTypeOwner($_POST['owner_id']);
}
$obj->setMetadataTypePublic(isset($_POST['public']) && $_POST['public'] == "on");
SettingsServices::updateMetadataType($obj);
print "";
exit();
}
/*****************/
echo "";
if (is_array($mdtypes) && sizeof($mdtypes) > 0) {
$header = array("Type name", "Description", "Owner", "Status", "");
printTableOpen();
printRowHeader($header);
foreach ($mdtypes as $metaDataTypeObj) {
printTr();
printRow($metaDataTypeObj->getMetadataTypeName());
printRow($metaDataTypeObj->getMetadataDescription());
if($metaDataTypeObj->isSystemObj()) {
printRow("System");
printRow($metaDataTypeObj->getMetadataTypePublic()?"Public":"Private");
printEditRow($metaDataTypeObj->getMetadataTypeID(), $CURRENT_PAGE);
printRow();
} else {
printRow(UserServices::getUserByID($metaDataTypeObj->getMetadataTypeLevel())->getFullname());
printRow($metaDataTypeObj->getMetadataTypePublic()?"Public":"Private");
printEditRow($metaDataTypeObj->getMetadataTypeID(), $CURRENT_PAGE);
printDeleteRow($metaDataTypeObj->getMetadataTypeID(), $CURRENT_PAGE, "Delete metadata?");
}
printTr(false);
}
printTableClose();
} else {
print "No metadata types available.";
}
echo "
";
}
/*
Case Movie Categorie
*/
if ($CURRENT_PAGE == "categories") {
require("forms/addMovieCategorie.php");
/* Add Movie Categorie */
if (isset($_POST['save'])) {
$data = array("",$_POST['name']);
$obj = new movieCategoryObj($data);
SettingsServices::addMovieCategory($obj);
print "";
exit();
}
/*****************/
echo "";
$categories = SettingsServices::getAllMovieCategories();
$header = array("Category name", "");
printTableOpen();
printRowHeader($header);
foreach ($categories as $obj) {
printTr();
printRow($obj->getName());
printDeleteRow($obj->getID(), $CURRENT_PAGE, "Delete category?");
printTr(false);
}
printTableClose();
echo "
";
}
/*
Allowed Cover types
*/
if ($CURRENT_PAGE == "allowed_types") {
require("forms/addCoverToMedia.php");
/* Add Allowed Cover types */
if (isset($_POST['save'])) {
$coverTypeArr = split("#",$_POST['id_list']);
if (sizeof($coverTypeArr) == 1 && strcmp($coverTypeArr[0],"") == 0)
$coverTypeArr = array();
CoverServices::addCoverTypesToMedia($_POST['media_id'], $coverTypeArr);
print "";
exit();
}
/*****************/
echo "";
$mtypes = SettingsServices::getAllMediatypes();
$header = array("Media Type", "Covers used","Cover description","");
printTableOpen();
printRowHeader($header);
foreach ($mtypes as $obj) {
printTr();
printRow($obj->getName());
printRow("");
printRow("");
printEditRow($obj->getmediaTypeID(), $CURRENT_PAGE);
printTr(false);
// Get allowed covers for this Media type
$covertypes = CoverServices::getCDcoverTypesOnMediaType($obj->getmediaTypeID());
foreach ($covertypes as $coverTypeObj) {
printTr();
printRow("");
printRow($coverTypeObj->getCoverTypeName(),"child");
printRow($coverTypeObj->getCoverTypeDescription(),"child");
printRow("");
printTr(false);
}
}
printTableClose();
echo "
";
}
/*
Case User Properties
*/
if ($CURRENT_PAGE == "properties") {
require("forms/addProperty.php");
/* Add User Properties */
if (isset($_POST['save'])) {
$data = array("",$_POST['name'], $_POST['description']);
$obj = new userPropertiesObj($data);
UserServices::addProperty($obj);
print "";
exit();
}
/* Update Properties */
elseif (isset($_POST['update'])) {
$obj = UserServices::getPropertyById($_POST['id']);
$obj->setPropertyDescription($_POST['description']);
UserServices::updateProperty($obj);
print "";
exit();
}
/*****************/
echo "";
$properties = UserServices::getAllProperties();
$header = array("Property name", "Description", "", "");
printTableOpen();
printRowHeader($header);
foreach ($properties as $obj) {
printTr();
printRow($obj->getpropertyName());
printRow($obj->getpropertyDescription());
printEditRow($obj->getpropertyID(), $CURRENT_PAGE);
printDeleteRow($obj->getpropertyID(), $CURRENT_PAGE, "Delete property?");
printTr(false);
}
printTableClose();
echo "
";
}
/*
Case Backup
*/
if ($CURRENT_PAGE == "backup") {
$header = array("Backup Type", "Download");
printTableOpen();
printRowHeader($header);
printTr();
printRow("Get SQL Dump (Tables and Data)",'','','90%');
printRow("Here");
printTr(false);
printTr();
printRow("Get SQL Dump (Data only)");
printRow("Here");
printTr(false);
printTableClose();
}
/*
Case Log
*/
if ($CURRENT_PAGE == "log") {
$updated = false;
if (isset($_POST['update'])) {
$logTypes = "";
if (isset($_POST['logoptions'])) {
$logTypes = implode("#", $_POST['logoptions']);
}
$metaObj = new metadataObj(array('',0,0,metadataTypeObj::SYS_LOGTYPES , $logTypes));
SettingsServices::addMetadata($metaObj);
$updated = true;
}
if (defined('VCDDB_USEPROXY') && VCDDB_USEPROXY == 1) {
print "VCD-db log options
"; print "Log options are not available when using webservices as a backend."; print "The log can however be viewed at the webservice backend > ".VCDDB_SOAPPROXY.""; } else { require_once('forms/log.php'); } } /* Case View Log */ if ($CURRENT_PAGE == "viewlog") { $numrows = 40; $offset = 0; if (isset($_GET['offset']) && is_numeric($_GET['offset'])) { $offset = $_GET['offset']; } $logfilter = null; if (isset($_GET['filter_id']) && is_numeric($_GET['filter_id']) && $_GET['filter_id'] > 0) { $logfilter = $_GET['filter_id']; } drawLogBar($numrows, $offset, $logfilter); $arrLog = VCDLog::getLogEntries($numrows, $offset, $logfilter); $arrAllUsers = UserServices::getAllUsers(); $header = array("Event", "Message", "User", "Date", "Remote IP"); printTableOpen(); printRowHeader($header); foreach ($arrLog as $obj) { $strUserName = "anonymous"; foreach ($arrAllUsers as $userObj) { if ($userObj->getUserID() == $obj->getUserID()) { $strUserName = $userObj->getUsername(); break; } } printTr(); printRow(VCDLog::getLogTypeDescription($obj->getType())) ; if ($obj->getType() == VCDLog::EVENT_TASKS ) { $data = explode("|", $obj->getMessage()); if (isset($data[1])) { printRow($data[1]); } } else { printRow($obj->getMessage()); } printRow($strUserName); printRow(date("d/m/Y h:i:s", strtotime($obj->getDate())), "", true); print "
";
$adultCats = PornstarServices::getSubCategories();
$header = array("Name", "");
printTableOpen('96%');
printRowHeader($header);
foreach ($adultCats as $obj) {
printTr();
printRow($obj->getName());
printDeleteRow($obj->getID(), $CURRENT_PAGE, "Delete category?");
printTr(false);
}
printTableClose();
echo "
";
}
/*
Case Porn Studios
*/
if ($CURRENT_PAGE == "pornstudios") {
require("forms/addPornStudio.php");
/* Add Porn studio */
if (isset($_POST['save'])) {
$data = array("",$_POST['name']);
$obj = new studioObj($data);
PornstarServices::addStudio($obj);
print "";
exit();
}
/*****************/
echo "";
$studios = PornstarServices::getAllStudios();
$header = array("Name", "");
printTableOpen('96%');
printRowHeader($header);
foreach ($studios as $obj) {
printTr();
printRow($obj->getName());
printDeleteRow($obj->getID(), $CURRENT_PAGE, "Delete studio?");
printTr(false);
}
printTableClose();
echo "
";
}
if ($CURRENT_PAGE == "versioncheck") {
checkVersion();
}
if ($CURRENT_PAGE == "statistics") {
print "Statistics
"; $arrFolders = array( '../upload/', '../upload/cache/', '../upload/covers/', '../upload/pornstars/', '../upload/screenshots/', '../upload/screenshots/albums/', '../upload/screenshots/generated/', '../upload/thumbnails/', '../upload/nfo/', ); $arrTotals = array('files' => 0, 'size' => 0, 'folders' => 0); $header = array("Folder", "Files", "Size", "Sub-folders", ""); printTableOpen(); printRowHeader($header); foreach ($arrFolders as $folder) { printTr(); $folderInfo = getFolderContent($folder); printRow($folderInfo['folder']); printRow($folderInfo['files']); printRow(human_file_size($folderInfo['size'])); printRow($folderInfo['subfolders']); if (substr_count($folder, 'cache') > 0) { printDeleteRow("'0'", $CURRENT_PAGE, "Clean up the cache folder?"); } else { printRow(); } printTr(false); if (strcmp($folder, '../upload/screenshots/') != 0) { $arrTotals['files'] += $folderInfo['files']; $arrTotals['size'] += $folderInfo['size']; $arrTotals['folders'] += $folderInfo['subfolders']; } } // Print the totals printTr(); printRow('Total:', 'header'); printRow($arrTotals['files']); printRow(human_file_size($arrTotals['size'])); printRow($arrTotals['folders']); printRow(); printTr(false); printTableClose(); } if ($CURRENT_PAGE == 'pornstarsync') { //require_once(VCDDB_BASE.DIRECTORY_SEPARATOR.'classes/pornstar/pornstarUpdater.php'); require_once('forms/pornstarsync.php'); } if ($CURRENT_PAGE == 'deletemovies') { require_once('forms/deleteMovies.php'); } if ($CURRENT_PAGE == 'tools') { require_once('forms/tools.php'); } /* XML Feeds */ if ($CURRENT_PAGE == "xmlfeeds") { require("forms/addFeed.php"); /* Add XML feed */ if (isset($_POST['save'])) { if (isset($_POST['name']) && strlen($_POST['name']) > 0 && isset($_POST['url']) && strlen($_POST['url']) > 0) { $rssObj = new rssObj(); $rssObj->setName($_POST['name']); $rssObj->setFeedUrl($_POST['url']); if (isset($_POST['isxrated'])) { $rssObj->setAdult(true); } $rssObj->setOwnerId(0); SettingsServices::addRssfeed($rssObj); } print ""; exit(); } /* Update XML feed */ elseif (isset($_POST['update'])) { $rssObj = SettingsServices::getRssfeed($_POST['id']); $rssObj->setName($_POST['name']); $rssObj->setFeedUrl($_POST['url']); $isadult = false; if (isset($_POST['isxrated'])) { $isadult = true; } $rssObj->setAdult($isadult); SettingsServices::updateRssfeed($rssObj); print ""; exit(); } /*****************/ if (isset($_GET['view'])) { $fid = $_GET['view']; $RSSClass = new lastRSS(); // setup transparent cache $RSSClass->cache_dir = '../upload'; $RSSClass->cache_time = 3600; // one hour $rssObj = SettingsServices::getRssfeed($fid); ShowOneRSS($rssObj->getFeedUrl(), $RSSClass); } echo "";
$arrFeeds = SettingsServices::getRssFeedsByUserId(0);
$adultimg = "![\"Adult](\"../images/admin/icon_tits.gif\" "\\"Adult")
";
$header = array("Feed name", "", "", "","");
printTableOpen();
printRowHeader($header);
foreach ($arrFeeds as $rssObj) {
printTr();
printRow($rssObj->getName());
if ($rssObj->isAdultFeed()) {
printRow($adultimg, "", false, 5);
} else {
printRow("", "", false, 5);
}
printEditRow($rssObj->getId(), $CURRENT_PAGE);
printDeleteRow($rssObj->getId(), $CURRENT_PAGE, "Delete XML feed?");
printCustomRow($rssObj->getId(),$CURRENT_PAGE,"icon_xml","View feed","viewFeed");
printTr(false);
}
printTableClose();
echo "
";
}
elseif ($CURRENT_PAGE == '') {
$serverInfo = VCDConnection::getServerInfo();
print "VCD-db v." . VCDDB_VERSION . " admin console.";
$header = array("Feed name", "", "", "","");
printTableOpen();
printRowHeader($header);
foreach ($arrFeeds as $rssObj) {
printTr();
printRow($rssObj->getName());
if ($rssObj->isAdultFeed()) {
printRow($adultimg, "", false, 5);
} else {
printRow("", "", false, 5);
}
printEditRow($rssObj->getId(), $CURRENT_PAGE);
printDeleteRow($rssObj->getId(), $CURRENT_PAGE, "Delete XML feed?");
printCustomRow($rssObj->getId(),$CURRENT_PAGE,"icon_xml","View feed","viewFeed");
printTr(false);
}
printTableClose();
echo ""; print "Running on " . DB_TYPE . " " . $serverInfo['version'] . " (" .$serverInfo['description'].")"; ?>
Here you can edit the settings for the VCD-db.
Beware that some of the core settings for VCD-db can be changed
and doing so without
knowing what you are doing can cause the application to function improperly.
If you plan to connect to this VCD-db instance from another VCD-db web or program using
the webservice interface the password is: