* * @category Provisioning * @author S. Hamblett <*****@*****.**> * @copyright 2010 S. Hamblett * @license GPLv3 http://www.gnu.org/licenses/gpl.html * @link none * * @package provisioner * * */ $metatagArray = array(); /* Protection */ if (REVO_GATEWAY_OPEN != "true") { die("Revo Gateway API error - Invalid access"); } /* Get the resources from the database */ $db = connectToDb(); logImportEvent("Getting all metatags", $db); $sql = "SELECT * FROM " . $table_prefix . "site_metatags "; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid Resource query"); } while ($metatag = mysql_fetch_assoc($result)) { $metatagArray[] = $metatag; } $response = errorSuccess('', $metatagArray); logImportEvent("Got all metatags", $db); mysql_close($db); echo toJSON($response);
* @package provisioner * * */ $keywordArray = array(); $outputArray = array(); /* Protection */ if (REVO_GATEWAY_OPEN != "true") { die("Revo Gateway API error - Invalid access"); } /* Get the keywords from the database */ $db = connectToDb(); /* Get the keywords */ logImportEvent("Getting all keywords", $db); $sql = "SELECT keyword, content_id FROM " . $table_prefix . "site_keywords"; $sql .= " LEFT JOIN " . $table_prefix . "keyword_xref on id = keyword_id"; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid Keyword query"); } while ($keyword = mysql_fetch_assoc($result)) { $keywordArray[] = $keyword; } /* Assemble the output array, list of mapped resources indexed by keyword */ foreach ($keywordArray as $keyword) { $outputArray[$keyword['keyword']][] = $keyword['content_id']; } $response = errorSuccess('', $outputArray); logImportEvent("Got all keywords", $db); mysql_close($db); echo toJSON($response);
die("Revo Gateway API error - Invalid access"); } /* Get the TV access data from the database */ $db = connectToDb(); /* Get the plugin event data names */ logImportEvent("Getting all plugin events", $db); $sql = "SELECT id, name FROM " . $table_prefix . "system_eventnames"; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid TV access query"); } while ($eventname = mysql_fetch_assoc($result)) { $eventNameArray[] = $eventname; } /* Get the plugin event map data*/ $sql = "SELECT pluginid, evtid, priority FROM " . $table_prefix . "site_plugin_events, " . $table_prefix . "site_plugins "; $sql .= " WHERE id = pluginid"; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid plugin event query"); } while ($eventmap = mysql_fetch_assoc($result)) { $eventMapArray[] = $eventmap; } /* Assemble the output array */ $outputArray[0] = $eventNameArray; $outputArray[1] = $eventMapArray; $response = errorSuccess('', $outputArray); logImportEvent("Got all plugin events", $db); mysql_close($db); echo toJSON($response);
die("Revo Gateway API error - Invalid TV access query"); } while ($tvaccess = mysql_fetch_assoc($result)) { $accessArray[] = $tvaccess; } /* Get the template data */ $sql = "SELECT * FROM " . $table_prefix . "site_tmplvar_templates"; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid TV template query"); } while ($tvtemplate = mysql_fetch_assoc($result)) { $templateArray[] = $tvtemplate; } /* Get the content value data */ $sql = "SELECT * FROM " . $table_prefix . "site_tmplvar_contentvalues"; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid TV content value query"); } while ($tvcontent = mysql_fetch_assoc($result)) { $contentArray[] = $tvcontent; } /* Assemble the output array */ $outputArray[0] = $accessArray; $outputArray[1] = $templateArray; $outputArray[2] = $contentArray; $response = errorSuccess('', $outputArray); logImportEvent("Got all tv data", $db); mysql_close($db); echo toJSON($response);
* * @package provisioner * * */ $resourceArray = array(); /* Protection */ if (REVO_GATEWAY_OPEN != "true") { die("Revo Gateway API error - Invalid access"); } /* Get the resources from the database */ $db = connectToDb(); logImportEvent("Getting all resources", $db); $sql = "SELECT * FROM " . $table_prefix . "site_content "; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid Resource query"); } while ($resource = mysql_fetch_assoc($result)) { /* Set the class key for correct creation in Revolution */ if ($resource['type'] == 'reference') { $resource['class_key'] = 'modWebLink'; } else { $resource['class_key'] = 'modDocument'; } $resourceArray[] = $resource; } $response = errorSuccess('', $resourceArray); logImportEvent("Got all resources", $db); mysql_close($db); echo toJSON($response);
break; case 'tv': logImportEvent("Getting all TVs", $db); $sql = "SELECT * FROM " . $table_prefix . "site_tmplvars"; $result = mysql_query($sql, $db); while ($element = mysql_fetch_assoc($result)) { $elementArray[] = $element; } $response = errorSuccess('', $elementArray); logImportEvent("Got all TVs", $db); mysql_close($db); echo toJSON($response); break; case 'category': logImportEvent("Getting all categories", $db); $sql = "SELECT * FROM " . $table_prefix . "categories"; $result = mysql_query($sql, $db); while ($category = mysql_fetch_assoc($result)) { $category['parent'] = 0; $elementArray[] = $category; } $response = errorSuccess('', $elementArray); logImportEvent("Got all categories", $db); mysql_close($db); echo toJSON($response); break; default: $response = errorFailure("No such element type", array('type' => $type)); mysql_close($db); echo toJSON($response); }
*/ $docgroupArray = array(); $outputMapArray = array(); $outputArray = array(); /* Protection */ if (REVO_GATEWAY_OPEN != "true") { die("Revo Gateway API error - Invalid access"); } /* Get the docgroups from the database */ $db = connectToDb(); /* Get the keywords */ logImportEvent("Getting all docgroups", $db); $sql = "SELECT a.id, name, private_memgroup, private_webgroup, document FROM " . $table_prefix . "documentgroup_names as a"; $sql .= " LEFT JOIN " . $table_prefix . "document_groups on a.id = document_group"; $result = mysql_query($sql, $db); if (!$result) { die("Revo Gateway API error - Invalid Docgroup query"); } while ($docgroup = mysql_fetch_assoc($result)) { $docgroupArray[] = $docgroup; } /* Assemble the output array, list of mapped resources indexed by docgroup name */ foreach ($docgroupArray as $docgroup) { $outputMapArray[$docgroup['name']][] = $docgroup['document']; } $outputArray[] = $docgroupArray; $outputArray[] = $outputMapArray; $response = errorSuccess('', $outputArray); logImportEvent("Got all docgroups", $db); mysql_close($db); echo toJSON($response);