Пример #1
0
/**
 * Find clusters, in which a plugin-entry is used.
 * @param integer ID of the plugin-Key
 */
function findContentUsageClusterNodes($oid)
{
    global $db;
    // Initializing Array
    $clusters = array();
    // Determine cluster_templates using the object as static content...
    $sql = "SELECT CLT_ID FROM cluster_template_items WHERE FKID = {$oid}";
    $query = new query($db, $sql);
    while ($query->getrow()) {
        // Determine clusters using this template
        $sql = "SELECT CLNID FROM cluster_node WHERE CLT_ID = " . $query->field("CLT_ID");
        $subquery = new query($db, $sql);
        while ($subquery->getrow()) {
            array_push($clusters, $subquery->field("CLNID"));
        }
        $subquery->free();
    }
    $query->free();
    // determine clusters using this content as library link...
    $sql = "SELECT CLID FROM cluster_content WHERE FKID = {$oid} OR CLCID = {$oid}";
    $query = new query($db, $sql);
    while ($query->getrow()) {
        // Determine clusters using this template
        $sql = "SELECT CLNID FROM cluster_variations WHERE CLID=" . $query->field("CLID");
        $subquery = new query($db, $sql);
        while ($subquery->getrow()) {
            array_push($clusters, $subquery->field("CLNID"));
        }
        $subquery->free();
    }
    $query->free();
    $clusters = array_unique($clusters);
    return $clusters;
}
 /**
  * save the changes...
  */
 function process()
 {
     global $errors, $selected, $create, $sitepage_CLNID, $cluster_node_NAME, $db, $oid, $sid, $clt;
     $this->check();
     if ($selected != "0" && $sitepage_CLNID != "0" && $sitepage_CLNID != "") {
         $mid = getVar("mid");
         $sql = "UPDATE sitepage SET CLNID = {$sitepage_CLNID} WHERE SPID = {$oid}";
         $query = new query($db, $sql);
         $query->free();
         // reload page, now in editing mode...
         global $db;
         $db->close();
         header("Location: sitepagebrowser.php?sid={$sid}&mid={$mid}&action=editobject&go=update&oid={$oid}");
         exit;
     } else {
         if ($create != "0" && $errors == "") {
             $mid = getVar("mid");
             $nextId = nextGUID();
             $sql = "INSERT INTO cluster_node (CLNID, CLT_ID, NAME, DELETED) VALUES({$nextId}, {$clt}, '{$cluster_node_NAME}', 0)";
             $query = new query($db, $sql);
             $sql = "UPDATE sitepage SET CLNID = {$nextId} WHERE SPID = {$oid}";
             $query = new query($db, $sql);
             $query->free();
             $backup = $oid;
             $oid = $nextId;
             syncClusterVariations();
             $oid = $backup;
             global $db;
             $db->close();
             header("Location: sitepagebrowser.php?sid={$sid}&mid={$mid}&action=editobject&go=update&oid={$oid}");
             exit;
         }
     }
 }
Пример #3
0
/**
 * Create a image from a file. Do not add the file to the object library
 * @param string Path to the source file
 * @param string Description Text for ALT-Tag
 * @param string Copright text for the image
 * @param string Variation-ID of the image
 */
function createImageFromFile($sourceFile, $alt = "", $copyright = "", $variation = 1, $categoryId = 1)
{
    global $c, $db;
    $id = nextGUID();
    $info = pathinfo($sourceFile);
    $extension = $info["extension"];
    $extension2 = strtoupper($extension);
    $name = parseSQL($info["basename"]);
    if ($extension2 == "JPG" || $extension2 == "GIF" || $extension2 == "PNG") {
        $size = getimagesize($sourceFile);
        $width = $size[0];
        $height = $size[1];
        copy($sourceFile, $c["devfilespath"] . $id . "." . $extension);
        $thumb = new Img2Thumb($c["devfilespath"] . $id . "." . $extension, 120, 120, $c["devfilespath"] . "t" . $id);
        $sql = "INSERT INTO pgn_image (FKID, FILENAME, ALT, COPYRIGHT, WIDTH, HEIGHT) VALUES ";
        $sql .= "({$id}, '{$id}.{$extension}', '{$alt}', '{$copyright}', {$width}, {$height})";
        $query = new query($db, $sql);
        $query->free();
        // Create Library Entry for this image
        $cid = nextGUID();
        $imageModule = getDBCell("modules", "MODULE_ID", "MODULE_NAME='Image'");
        $sql = "INSERT INTO content (CID, MODULE_ID, NAME, CATEGORY_ID, MT_ID) VALUES ";
        $sql .= "({$cid}, {$imageModule}, '{$name}', {$categoryId}, 0)";
        $query = new query($db, $sql);
        $query->free();
        $sql = "INSERT INTO content_variations (CID, VARIATION_ID, FK_ID) VALUES ";
        $sql .= "({$cid}, {$variation}, {$id})";
        $query = new query($db, $sql);
        $query->free();
        return $cid;
    } else {
        return null;
    }
}
/**
 * Return the XML-Code for a Sitepage-Master
 * @param integer GUID of the sitepage-master
 */
function XmlExportSitepageMaster($spm)
{
    global $db, $xmlExchange, $c;
    $xmlOptions = array(XML_OPTION_CASE_FOLDING => TRUE, XML_OPTION_SKIP_WHITE => TRUE);
    $xml =& new XPath(FALSE, $xmlOptions);
    $sql = "SELECT * FROM sitepage_master WHERE SPM_ID = {$spm}";
    $query = new query($db, $sql);
    if ($query->getrow()) {
        $name = urlencode($query->field("NAME"));
        $description = urlencode($query->field("DESCRIPTION"));
        $templatePath = $query->field("TEMPLATE_PATH");
        $clt = $query->field("CLT_ID");
        $type = $query->field("SPMTYPE_ID");
        $template = "";
        $fp = @fopen($c["devpath"] . $templatePath, "r");
        if ($fp != "") {
            while (!feof($fp)) {
                $template .= fgets($fp, 128);
            }
            @fclose($fp);
        }
        $template = urlencode($template);
        $templatePath = urlencode($templatePath);
        $xml->appendChild('', '<NX:SITEPAGEMASTER ID="' . $spm . '" NAME="' . $name . '" DESCRIPTION="' . $description . '" TYPE="' . $type . '" FILENAME="' . $templatePath . '" CLUSTERTEMPLATE="' . $clt . '">' . $template . '</NX:SITEPAGEMASTER>');
        $query->free();
        $xmlExchange[] = array("clt" => $clt);
    }
    return $xml->exportAsXml('', '');
}
Пример #5
0
	/**
	 * Deletes a variable from the variable stack
	 * @param string name of the variable
	 */
	function delVar($name) {
		$back = "";

		global $auth, $db;
		$userId = $auth->userId;
		$sql = "DELETE FROM temp_vars WHERE USER_ID=$userId and NAME='$name'";

		$query = new query($db, $sql);
		$query->free();
	}
Пример #6
0
/**
 * Store a vote
 * @param integer Vote of user (1-8)
 * @param string comment of user
 */
function saveData($vote, $comment = "", $sourceId)
{
    if ($vote > 0 && $vote < 10) {
        global $db;
        $sql = "INSERT INTO pgn_rating (VOTE, COMMENT, SOURCEID) VALUES({$vote}, '" . addslashes($comment) . "', {$sourceId})";
        $query = new query($db, $sql);
        $query->free();
        return true;
    }
    return false;
}
/**
 * Return the XML-Code for a Cluster-Template
 * @param integer ID of the Cluster-Template
 * @param mixed data to export also as array. [][type] = "meta", [][guid] = .....
 */
function XmlExportClusterTemplate($clt)
{
    global $db, $xmlExchange;
    $xmlOptions = array(XML_OPTION_CASE_FOLDING => TRUE, XML_OPTION_SKIP_WHITE => TRUE);
    $xml =& new XPath(FALSE, $xmlOptions);
    $sql = "SELECT * FROM cluster_templates WHERE CLT_ID = {$clt}";
    $query = new query($db, $sql);
    if ($query->getrow()) {
        $name = urlencode($query->field("NAME"));
        $description = urlencode($query->field("DESCRIPTION"));
        $layout = urlencode($query->field("TEMPLATE"));
        $xmlExchange[] = array("mt" => $query->field("MT_ID"));
        $xml->appendChild('', "<nx:clustertemplate id=\"{$clt}\" name=\"{$name}\" description=\"{$description}\" metaTemplate=\"" . $query->field("MT_ID") . "\" />");
        $xml->appendChild('/nx:clustertemplate[@id="' . $clt . '"]', "<nx:layout>{$layout}</nx:layout>");
        $query->free();
    }
    $requiredPlugins = array();
    $sql = "SELECT * FROM cluster_template_items WHERE CLT_ID = {$clt}";
    $query = new query($db, $sql);
    while ($query->getrow()) {
        $name = urlencode($query->field("NAME"));
        $position = $query->field("POSITION");
        $type = $query->field("CLTITYPE_ID");
        $mincard = $query->field("MINCARD");
        $maxcard = $query->field("MAXCARD");
        $fkid = $query->field("FKID");
        $config = "";
        if ($type == 2 || $type == 5) {
            //dynamic content or library.
            $config = strtoupper(getDBCell("modules", "MODULE_NAME", "MODULE_ID = {$fkid}"));
            if (!in_array($config, $requiredPlugins)) {
                $requiredPlugins[] = $config;
            }
        } else {
            if ($type == 4) {
                $config = $fkid;
                $xmlExchange[] = array("clt" => $fkid);
            }
        }
        $xml->appendChild('/nx:clustertemplate[@id="' . $clt . '"]', "<nx:clustertemplateitem name=\"{$name}\" position=\"{$position}\" type=\"{$type}\" mincard=\"{$mincard}\" maxcard=\"{$maxcard}\" configuration=\"{$config}\"/>");
    }
    for ($i = 0; $i < count($requiredPlugins); $i++) {
        if (!in_array($requiredPlugins[$i], $xmlExchange["PLUGINS"])) {
            array_push($xmlExchange["PLUGINS"], $requiredPlugins[$i]);
        }
    }
    return $xml->exportAsXml('', '');
}
Пример #8
0
/**
 * Launch a plugin.
 * @param integer FKID of the plugin to launch.
 * @param integer Module-ID of the plugin.
 * @param integer ID of the level to launch to
 * @param integer ID of the Cluster-Content-Item
 * @returns integer Translated ID after launch.
 */
function launchPlugin($in, $plugin, $level, $clti = 0)
{
    global $db;
    $out = translateState($in, $level);
    // reference the Plugin.
    $sql = "SELECT CLASS FROM modules WHERE MODULE_ID = {$plugin}";
    $query = new query($db, $sql);
    $query->getrow();
    $classname = $query->field("CLASS");
    $ref = new $classname($in, $clti);
    $delSQL = "DELETE FROM {$ref->management_table} WHERE {$ref->pk_name} = {$out}";
    $query = new query($db, $delSQL);
    // *old* note: when versioning is being implemented, createVersion must be called with parameter $applyProperties=false if the original version level is higher than 0 !!!
    // *old* this is to make sure automatic modifications are only applied when first increasing the version level of a content.
    // note: the new concept is to apply automatic modifications immediately when uploading new plugin data while the original uploaded data will remain as an unchanged version.
    // this way the automatic changes can be updated if changed later on by issuing a corresponding command on the singleConfig page
    $sql = $ref->createVersion($out);
    $query = new query($db, $sql);
    $query->free();
    unset($ref);
    return $out;
}
Пример #9
0
/**
 * Return the XML-Code for a Meta-Template
 * @param integer ID of the Meta-Template
 */
function XmlExportMetaTemplate($mtId)
{
    global $db;
    $xmlOptions = array(XML_OPTION_CASE_FOLDING => TRUE, XML_OPTION_SKIP_WHITE => TRUE);
    $xml =& new XPath(FALSE, $xmlOptions);
    $sql = "SELECT * FROM meta_templates WHERE MT_ID = {$mtId}";
    $query = new query($db, $sql);
    if ($query->getrow()) {
        $name = urlencode($query->field("NAME"));
        $description = urlencode($query->field("DESCRIPTION"));
        $xml->appendChild('', "<nx:metatemplate id=\"{$mtId}\" name=\"{$name}\" description=\"{$description}\"/>");
        $query->free();
    }
    $sql = "SELECT * FROM meta_template_items WHERE MT_ID = {$mtId}";
    $query = new query($db, $sql);
    while ($query->getrow()) {
        $name = urlencode($query->field("NAME"));
        $position = $query->field("POSITION");
        $type = $query->field("MTYPE_ID");
        $xml->appendChild('/nx:metatemplate[@id="' . $mtId . '"]', "<nx:metatemplateitem name=\"{$name}\" position=\"{$position}\" type=\"{$type}\"/>");
    }
    return $xml->exportAsXml('', '');
}
Пример #10
0
/**
 * Translate an old into a new GUID
 * @param integer old GUID
 * @param boolean set AntiCycle
 */
function translateXmlGUID($oldId)
{
    global $db, $provider, $c;
    if ($oldId < 1000) {
        // System data.
        $out = $oldId;
    } else {
        if (strtoupper($provider) == strtoupper($c["provider"])) {
            // own data.
            $out = $oldId;
        } else {
            $provider = strtoupper(parseSQL($provider));
            resetDBCache();
            $out = getDBCell("syndication", "OUT_ID", "IN_ID = {$oldId} AND PROVIDER = '{$provider}'");
            if ($out == "") {
                $out = nextGUID();
                $sql = "INSERT INTO syndication (IN_ID, OUT_ID, PROVIDER) VALUES ({$oldId}, {$out}, '{$provider}')";
                $query = new query($db, $sql);
                $query->free();
            }
        }
    }
    return $out;
}
Пример #11
0
		/**
		 * Get recordset from pgnImage as associative array. Internally used only.
		 * @param integer id for new recordset.
		 * @returns 2d-array of name-value-pairs.
		 */
		function _getColumns($newid) {
			global $db;
			
			$querySQL = "SELECT * FROM $this->management_table WHERE $this->pk_name = $this->fkid";
			$query = new query($db, $querySQL);
			$query->getrow();
			$width = addslashes($query->field("WIDTH"));
			$height = addslashes($query->field("HEIGHT"));
			$alt = addslashes($query->field("ALT"));
			$copyright = addslashes($query->field("COPYRIGHT"));
			$filename = $query->field("FILENAME");
			$query->free();
			// copy image to new version
			$fileparts = explode(".", $filename);
			$suffix = strtolower($fileparts[(count($fileparts) - 1)]);
			$newfile = $newid . "." . $suffix;
			
			return array("newid" => $newid, "suffix" => $suffix, "filename" => $filename, "newfile" => $newfile, "alt" => $alt, "height" => $height, "width" => $width, "copyright" => $copyright);
		}
Пример #12
0
		/**
		   * This function is used for drawing the html-code out to the templates.
		   * It just returns the code
		   * @param 		string	Optional parameters for the draw-function. There are none supported.
		   * @return		string	HTML-CODE to be written into the template.
		   */
		function draw($param = "") {
			global $db;

			$result = null;
			$sql = "SELECT * FROM pgn_quote ORDER BY RAND() LIMIT 1";
			$query = new query($db, $sql);

			if ($query->getrow()) {
				$result["QUOTE"] = $query->field("QUOTE");

				$result["TITLE"] = $query->field("TITLE");
			}

			$query->free();
			return $result;
		}
		/**
		  * Used to create a  tree of the CLuster-Templates.
		  * Recursive function. 
		  * Create a global variable $isFolder if you are moving folders, because there are special rules then.
		  * @param array array with name-value pairs of the folders
		  */
		function createCLT(&$instances) {
			global $db, $lang;

			$sql = "SELECT NAME, CLNID FROM cluster_node WHERE CLT_ID = $this->clt AND DELETED=0  AND VERSION=0 ORDER BY NAME ASC";

			$instances[0][0] = $lang->get("empty");
			$instances[0][1] = 0;

			$myquery = new query($db, $sql);

			while ($myquery->getrow()) {
				$ni = count($instances);

				$instances[$ni][1] = $myquery->field("CLNID");
				$instances[$ni][0] = $myquery->field("NAME");
			}

			$myquery->free();
		}
	/**
	 * internally used only for creating a array for deleting a folder tree.
	 */
	function createDelArray(&$handler, $id) {
		global $db;

		$sql = "SELECT CATEGORY_ID FROM categories WHERE PARENT_CATEGORY_ID = $id";
		$query = new query($db, $sql);

		while ($query->getrow()) {
			$cid = $query->field("CATEGORY_ID");

			$dsql = "UPDATE categories SET DELETED = 1 WHERE CATEGORY_ID = $cid";
			$handler->addDBAction($dsql);
			createDelArray($handler, $cid);
		}

		$query->free();
		$dsql = "UPDATE categories SET DELETED = 1 WHERE CATEGORY_ID = $id";
		$handler->addDBAction($dsql);
	}
	$handled = false;
	if (value('resetfilter', 'NUMERIC', '0') == '1') 
	  delVar('linkset');
	if ($action != "0" || $view != "0") {
		
		
		//check if cluster exists in this variation
		if ($clnid != "0") {
			if ($action == "cr_cluster" && value("decision") == $lang->get("yes")) {
			  $oid = value("oid", "NUMERIC");
			  $crvar = value("crvar", "NUMERIC");	
  			  if ($oid != "0" && $crvar != "0") {
			    if (getDBCell("cluster_variations", "CLID", "CLNID = $oid AND VARIATION_ID = $crvar") != "") {
			      $sql = "UPDATE cluster_variations SET DELETED=0 WHERE CLNID = $oid AND VARIATION_ID = $crvar"; 	
			      $query = new query($db, $sql);
			      $query->free(); 
			    } else {
			      createCluster($oid, $crvar, $auth->userName);
			    }
			    $view = 1;			    
			  }		
			} else {

        			$clid = getDBCell("cluster_variations", "CLID", "CLNID = $clnid AND VARIATION_ID = $variation AND DELETED=0");
        			if ($clid == "") {
        				$form2 = new YesNoForm($lang->get("cr_vr", "Create variation"), $lang->get("crclv_mes", "The cluster does not exists in this variation. Do you want to create it?"));
        				$form2->add(new Hidden("action", "cr_cluster"));
        				$form2->add(new Hidden("oid", $oid));
        				$form2->add(new Hidden("crvar", $variation));
        				$page->add($form2);
        				$handled = true;
Пример #16
0
	/**
		 * Frees a position for inserting a new dataset.
		 *
		 * @param string $table Name of the table to free a row
	 	 * @param string $sortColumn Name of the Column where order is stored
		 * @param integer $position Value of the PK of the row to free
		 * @param string $cond Where-Clause, to select only some rows.
		 */
	function freeRowPosition($table, $sortColumn, $position, $cond = "1") {
		global $db;
		if (getDBCell($table, $sortColumn, "$cond AND $sortColumn = $position") != "") {
		  $sql = "UPDATE $table SET $sortColumn = ($sortColumn + 1) WHERE $cond AND $sortColumn >= $position";
		  $query = new query($db, $sql);
		  $query->free();
		}
	}
		/**
		 * Delete one item out of the list
		 */
		function deleteItem() {
			global $db;
			$deleted = false;
			for ($i = 0; $i < count($this->members); $i++) {
				if ($this->eid == $this->members[$i][1]) {
					$sql = "DELETE FROM cluster_content WHERE CLCID = $this->eid";
					$query = new query($db, $sql);
					$query->free();
					if ($this->membersCount > 1) sortTableRows("cluster_content", "CLCID", "POSITION", "CLTI_ID = $this->clti AND CLID = $this->cl");
					$deleted = true;
                    $this->deleteReferencedItem($this->eid);
				}
			}
			if ($deleted) {
				syncCluster ($this->cl);
				$this->members = $this->getItemData();					
			}
		}
Пример #18
0
		/**
		 * Copy this record and all its data to new id.
		 * @param integer id which is used as PK for new record.
		 */
		function copyRecord($newid) {
			// query for content
			global $db;

			$querySQL = "SELECT SNIPLET FROM $this->management_table WHERE $this->pk_name = $this->fkid";
			$query = new query($db, $querySQL);
			$query->getrow();
			$content = $query->field("SNIPLET");
			$content = addslashes($content);			
			$snt = $query->field("SNIPLETTYPE");
			$query->free();
			$sql = "INSERT INTO $this->management_table ($this->pk_name, SNIPLET, SNIPLETTYPE) VALUES ($newid, '$content', $snt)";
			return $sql;
		}
	/**
	 * Gets the available Variations of a cluster-Node
	 * @param 		integer		Cluster-Node-ID
	 * @returns	integer		Linear array with all available Variations.
	 */
	function getClusterVariations($clnid) {
		global $db, $splevel;

		if ($splevel == 10) { // checking for live-variations....
			$sql = "SELECT 
	  				DISTINCT cv.VARIATION_ID 
	  			FROM 
	  				cluster_variations cv, 
	  				cluster_node cn, 
	  				sitepage sp,
	  				sitepage_names sn,
	  				sitepage_variations sv RIGHT JOIN  
	  				state_translation st ON cv.CLID = st.OUT_ID AND st.EXPIRED = 0
	  			WHERE
	  				cn.CLNID = $clnid
	  			AND	cv.CLNID = cn.CLNID 
	  			AND cv.DELETED =  0
				AND cn.CLNID = sp.CLNID
				AND sp.SPID = sn.SPID
				AND sn.DELETED = 0
				AND sp.SPM_ID = sv.SPM_ID
				AND sv.VARIATION_ID = cv.VARIATION_ID";
		} else {
			$sql = "SELECT 
	  				DISTINCT cv.VARIATION_ID 
	  			FROM 
	  				cluster_variations cv, 
	  				cluster_node cn, 
	  				sitepage sp,
	  				sitepage_names sn,
	  				sitepage_variations sv 
	  			WHERE
	  				cn.CLNID = $clnid
	  			AND	cv.CLNID = cn.CLNID 
	  			AND cv.DELETED =  0
				AND cn.CLNID = sp.CLNID
				AND sp.SPID = sn.SPID
				AND sn.DELETED = 0
				AND sp.SPM_ID = sv.SPM_ID
				AND sv.VARIATION_ID = cv.VARIATION_ID";
		}

		$query = new query($db, $sql);
		$returns = array ();

		while ($query->getrow()) {
			array_push($returns, $query->field("VARIATION_ID"));
		}

		$query->free();
		return $returns;
	}
Пример #20
0
	/**
	 * Checks, whether the cluster already exists and creates it, if not.
	 */	 
	function checkIfCLNExists() {
	  global $db;
	  
	  // Check, if Clusternode exists.
	  if ($this->value == "0" || $this->value == "") {
	    // The Cluster in the variation will be created now.
	    $this->clnid = createClusterNode($this->clustername, $this->cltid);	  	
	    	// update the new clnid immediately to the database	  	
	  	$sql = "UPDATE $this->table SET $this->column=$this->clnid WHERE $this->row_identifier";	  	
	  	$query = new query($db, $sql);
	  	$query->free();
	  
	  }	else {
	  	// the cluster node already exists.
	  	$this->clnid = $this->value;
	  }
	  
	  // check, if clustervariation exists.
	  $clid = getDBCell("cluster_variations", "CLID", "CLNID=$this->clnid AND VARIATION_ID=$this->variation");
	  if ($clid == "") {
	  	// Cluster-Variation does not exists yet.
	  	$this->clid = createCluster($this->clnid, $this->variation);
	  } else {
	  	$this->clid = $clid;
	  }
	  
	  // sync the cluster variation
	  syncCluster($this->clid);	  
	  
	  // ensure correct CLT-ID
	  $this->cltid = getDBCell("cluster_node", "CLT_ID", "CLNID=".$this->clnid);	  
	}
Пример #21
0
	/**
	* Creates an Array from a table with following form:
	* array[i] = $name
	* The function queries the table for names that
	* match the given data_identifier and processes them into Array.
	* @param string Name of table you are working with
	* @param string Name of column, you want to take the Names for the Array form.
	* @param string $data_identifier Statement of your SQL-Where-Clause for selecting one or more records in the table for processing.
	* @param string $order Name of the column which shall be ordered by.
	* @param boolean Should the values be filtered for duplicates ("distinct")
	* @return Array
	*/
	function createDBCArray($table, $name, $data_identifier = "1", $order = "", $distinct=true) {
		global $db;
		
		$values = null;
		$counter = 0;
		
		if ($distinct) {
			$filter = "DISTINCT";
		} else {
			$filter = "";
		}
		
		$sql = "SELECT $filter $name FROM $table WHERE $data_identifier" . " $order";
		$query = new query($db, $sql);

		while ($query->getrow()) {
			$values[$counter] = $query->field($name);

			$counter++;
		}

		$query->free();

		return $values;
	}
Пример #22
0
		/**
		   * Create the sql-code for a version of the selected object
		   * @param integer ID of new Version.
		   * @returns string SQL Code for new Version.
		   */
		function createVersion($newid) {
			// query for content
			global $db;

			$querySQL = "SELECT NUMBER FROM $this->management_table WHERE $this->pk_name = $this->fkid";
			$query = new query($db, $querySQL);
			$query->getrow();
			$content = addslashes($query->field("CONTENT"));
			$query->free();

			$sql = "INSERT INTO $this->management_table ($this->pk_name, NUMBER) VALUES ($newid, $content)";
			return $sql;
		}
Пример #23
0
	/**
	 * Deletes a row with specified parameters
	 *
	 * @param string Name of the table to select the row from
	 * @param string Filter to select rows
	 */
	function deleteRow($table, $filter = "") {
		if ($filter != "1" && $filter != "" & $table != "") {
			global $db, $debug;

			$sql = "DELETE FROM $table WHERE $filter";
            if ($debug) echo "DELETE: ".$sql."<br>";
			$query = new query($db, $sql);
			$query->free();
		}
	}
	  /**
	   * Save all back to the database
	   */
	   function process() {
	       global $db, $oid;
	       deleteRow($this->table, $this->cond);	
	       $ids = explode(",", value($this->table."selection", "NOSPACES"));
	       for ($i=0; $i < count($ids); $i++) {
	         $sql = "INSERT INTO $this->table ($this->idcolumn, $this->fkidcolumn, POSITION) VALUES (".$ids[$i].", $oid, ".($i+1).")";
	         $query = new query($db, $sql);
	         $query->free();
	       }
	   }
Пример #25
0
        array_push($clusters, $subquery->field("CLNID"));
    }
    $subquery->free();
}
$query->free();
// determine clusters using this content as library link...
$sql = "SELECT CLID FROM cluster_content WHERE FKID = {$oid}";
$query = new query($db, $sql);
while ($query->getrow()) {
    // Determine clusters using this template
    $sql = "SELECT CLNID FROM cluster_variations WHERE CLID=" . $query->field("CLID");
    $subquery = new query($db, $sql);
    while ($subquery->getrow()) {
        array_push($clusters, $subquery->field("CLNID"));
    }
    $subquery->free();
}
$query->free();
$clusters = array_unique($clusters);
//echo "USED:".count($usedPageClusters)." UNUSED:".count($unusedPageClusters);
//echo " ALL CLUSTERS:".count($clusters);
// now find all clusters recursive that contain the unused values...
function parentClusters($clArray, $level = 0)
{
    $clnids = array();
    if ($level > 5) {
        return $clnids;
    }
    for ($i = 0; $i < count($clArray); $i++) {
        $cl = $clArray[$i];
        // find dynamic clusters....
Пример #26
0
		/**
		   * Create the sql-code for a version of the selected object
		   * @param integer ID of new Version.
		   * @returns string SQL Code for new Version.
		   */
		function createVersion($newid, $copy = false) {
			// query for content
			global $db, $c;

			$destinationPath = $c["livefilespath"];

			if ($copy)
				$destinationPath = $c["devfilespath"];

			$querySQL = "SELECT * FROM $this->management_table WHERE $this->pk_name = $this->fkid";
			$query = new query($db, $querySQL);
			$query->getrow();
			      
			$filename = $query->field("FILENAME");
			$description = addslashes($query->field("DESCRIPTION"));
			$filetype = $query->field("FILETYPE");
			$location = $query->field("LOCATION");
			$name     = $query->field("NAME");
			
			$query->free();
			// copy image to new version
			$fileparts = explode(".", $filename);
			$suffix = strtolower($fileparts[(count($fileparts) - 1)]);
			$newfile = $newid . "." . $suffix;

			if (!$copy) {
				nxDelete ($destinationPath , $newfile);
			}
			
			if ($suffix != "") {				
				nxCopy($c["devfilespath"] . $filename, $destinationPath , $newfile);
			}
		
			$sql = "INSERT INTO $this->management_table ($this->pk_name, NAME,FILENAME, FILETYPE, LOCATION, DESCRIPTION) VALUES ($newid, '$name', '$newfile', '$filetype', '$location', '$description')";
			return $sql;
		}
Пример #27
0
 public function fields_list($table)
 {
     $sql_s = "SELECT * FROM {$table} LIMIT 0";
     $select_fields = new query($this->connect, $sql_s, array(), array());
     $fields = $select_fields->fields->all;
     // Free Memory from select fields query resaults
     $select_fields->free();
     return $fields;
 }
		/**
		   * Create the sql-code for a version of the selected object
		   * @param integer ID of new Version.
		   * @returns string SQL Code for new Version.
		   */
		function createVersion($newid) {
			// query for content
			global $db, $c;

			$querySQL = "SELECT CONTENT FROM $this->management_table WHERE $this->pk_name = $this->fkid";
			$query = new query($db, $querySQL);
			$query->getrow();
			$content = addslashes($query->field("CONTENT"));
			$query->free();
			$this->createImage($c["livefilespath"] . $newid.".png");
			$sql = "INSERT INTO $this->management_table ($this->pk_name, CONTENT) VALUES ($newid, '$content')";
			return $sql;
		}
Пример #29
0
 /**
  * Check the login data of a user and return true if data is correct or false if incorrect.
  * @param string Username
  * @param string User's pasword.
  * @return boolean true if check was successful or false if not.
  */
 function checkLogin($login, $passwd)
 {
     global $db, $c;
     $sql = "SELECT USER_ID FROM users WHERE USER_NAME='{$login}' AND PASSWORD = '******'";
     $query = new query($db, $sql);
     if ($query->count() == 1) {
         // login successfull
         $query->getrow();
         $this->userId = $query->field("USER_ID");
         return true;
     } else {
         return false;
     }
     $query->free();
 }
Пример #30
0
	/**
	* Deletes the expired-Flag in the state-translations...
	* @param integer Translated-ID of an item (OUT-ID)
	*/
	function delExpired($out) {
		global $db;

		$sql = "UPDATE state_translation SET EXPIRED=0 WHERE OUT_ID = $out";
		$query = new query($db, $sql);
		$query->free();
	}