本文整理汇总了PHP中CmsDev\sql\db_Skt类的典型用法代码示例。如果您正苦于以下问题:PHP db_Skt类的具体用法?PHP db_Skt怎么用?PHP db_Skt使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了db_Skt类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: ValidateNameExistAndClean
public static function ValidateNameExistAndClean($string)
{
$UserName = new \CmsDev\util\CheckUserName();
$stringValid = $UserName->Fix($string);
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$user = $SKTDB->get_row("SELECT username FROM users WHERE username = " . \GetSQLValueString($stringValid, 'text') . "");
if ($user) {
return 'exist';
} else {
return $stringValid;
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:12,代码来源:UserName_ValidateName.php
示例2: Render
private function Render()
{
$SKTDB = SKT_DB\db_Skt::connect();
$Language = \THIS_LANG;
$query = $SKTDB->get_results("SELECT ID,LanguageName,Prefix,URL,SID,Hidden FROM language WHERE Hidden='0' ORDER BY LanguageName ASC");
$counter = $SKTDB->get_var("SELECT count(ID) FROM language");
self::connect($query, $counter);
self::set_Language($Language);
if ($this->counter > 1) {
$Render = $this->Nav_Sub_Items_Before;
foreach ($this->query as $Item) {
if ($this->Language == $Item->Prefix) {
$active = ' class="' . $this->Nav_Class_Item_Selected . '"';
} else {
$active = '';
}
$preitem = $this->item_model;
$item = str_replace('[LanguageName]', $Item->LanguageName, $preitem);
$item = str_replace('[URL]', SKT_URL_BASE . $Item->Prefix . '/', $item);
$item = str_replace('[Prefix]', $Item->Prefix, $item);
$item = str_replace('[activeLang]', $active, $item);
if ($Item->Hidden == 0) {
$Render .= $item;
}
}
$Render .= $this->Nav_Sub_Items_After;
}
return $Render;
}
开发者ID:neruruguay,项目名称:neru,代码行数:29,代码来源:LanguageMenu.php
示例3: __construct
private function __construct()
{
$SKT = SKTGLOBALS::getVar('SKT');
$SKTDB = SKTDB\db_Skt::connect();
$Request = new \CmsDev\Url\Request();
$URLName = $Request->byLevel(0);
$RequestReverse = new \CmsDev\Url\Request();
$RequestReverse->reverse(false);
$testLanguage = $RequestReverse->byLevel(0);
$LanguageArray = $SKT['LANGUAGE']['LIST'];
if (in_array($testLanguage, $LanguageArray)) {
$Language = $testLanguage;
} else {
$Language = \LANGUAGE_DEF;
}
if (\SKT_SECTION_PID != '') {
$ProductsValues = $SKTDB->query("SELECT * FROM " . \DB_PREFIX . "products WHERE ProductID = '" . \SKT_SECTION_PID . "'");
}
$SKTDB->query("SELECT * FROM " . \DB_PREFIX . "products WHERE UID != '0' LIMIT 1");
$query = $SKTDB->get_col_info();
if ($ProductsValues) {
foreach ($query as $name) {
$this->{$name} = $ProductsValues->{$name};
}
} else {
foreach ($query as $name) {
$this->{$name} = '';
}
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:30,代码来源:DataSet.php
示例4: getTableEdit
public static function getTableEdit()
{
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$Language = \CmsDev\Language\CheckLanguage::get();
$query = $SKTDB->get_row("SELECT AdminParams FROM language WHERE Prefix = '" . $Language . "'");
if ($query->AdminParams != '') {
$params = json_decode($query->AdminParams, true);
if (is_array($params)) {
$HTML = '<table><tr><td>Parametro</td><td>Valor</td></tr>';
foreach ($params as $variable => $value) {
if (!is_array($value)) {
$HTML .= '<tr><td>SKT_ADMIN_' . $variable . '</td><td>' . $value . '</td></tr>';
} else {
$NewvalueToArray = \json_encode($value);
$HTML .= '<tr><td>SKT_ADMIN_' . $variable . '</td><td>' . $NewvalueToArray . '</td></tr>';
}
}
$HTML .= '</table>';
return $HTML;
} else {
$ErrorMessageBox = "Error al cargar las variables de sistema en CmsDev\\Language\\getParams(). Puede existir un json mal formado. Verifique la tabla de lenguaje o consulte al Administrador.";
$MessageBox = SKT_INFO\Asistance::get();
$MessageBox->TipError($ErrorMessageBox, true);
//
//$AdminParams=substr($query->AdminParams,strrpos($query->AdminParams,"\"")-200,200);
//echo "<pre>".$AdminParams."</pre>";
}
} else {
self::setParamsFromFile();
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:31,代码来源:AdminGlosary.php
示例5: __construct
private function __construct()
{
if (!defined('DB_PREFIX')) {
define('DB_PREFIX', 'default_');
}
$SKT = SKTGLOBALS::getVar('SKT');
$SKTDB = SKTDB\db_Skt::connect();
$SectionValues = '';
$ParentSectionValues = '';
$Parent_2_SectionValues = '';
$Parent_3_SectionValues = '';
$Parent_4_SectionValues = '';
$Parent_5_SectionValues = '';
// new \_TemplateSite\clean\Config();
// sections // ID Title URLName SID RecycleBin SystemRequired Language Template Order
$SectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE URLName = '" . \SKTURL_Here . "'");
if (isset($SectionValues->SID) && $SectionValues->SID != '') {
$ParentSectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE ID = '{$SectionValues->SID}'");
if (isset($ParentSectionValues->SID) && $ParentSectionValues->SID != '') {
$Parent_2_SectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE ID = '{$ParentSectionValues->SID}'");
if (isset($Parent_2_SectionValues->SID) && $Parent_2_SectionValues->SID != '') {
$Parent_3_SectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE ID = '{$Parent_2_SectionValues->SID}'");
if (isset($Parent_3_SectionValues->SID) && $Parent_3_SectionValues->SID != '') {
$Parent_4_SectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE ID = '{$Parent_3_SectionValues->SID}'");
if (isset($Parent_4_SectionValues->SID) && $Parent_4_SectionValues->SID != '') {
$Parent_5_SectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE ID = '{$Parent_4_SectionValues->SID}'");
}
}
}
}
}
if (!$SectionValues) {
$SectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE Language = '" . \SKT_ThisLaguage . "' AND SID = '0' ");
if (!$SectionValues) {
$SectionValues = $SKTDB->get_row("SELECT * FROM " . \DB_PREFIX . "sections WHERE SID = '0' AND Language = '" . \SKT_ThisLaguage . "'");
}
if (\SKTURL_Here != '' && \SKTURL_Here != trim(\SKTURL_REQUEST_URI, '/') && !\in_array(\SKTURL_Here, $SKT['LANGUAGE']['LIST']) && !\in_array(\SKTURL_Here, $SKT['SITE']['RESTRICTED_URL'])) {
if (!defined("error")) {
define('error', 'error404');
}
}
}
$IDSections = $SectionValues->ID;
$_SESSION['SessionURLSection'] = $SKTDB->get_var("SELECT URLName FROM " . \DB_PREFIX . "sections WHERE ID = '{$IDSections}'");
if (!defined("SectionHidden")) {
define('SectionHidden', $SectionValues->RecycleBin);
}
$SKTDB->query("SELECT * FROM " . \DB_PREFIX . "sections WHERE SID = '0'");
$query = $SKTDB->get_col_info();
foreach ($query as $name) {
$this->{$name} = $SectionValues->{$name};
}
$this->ParentSectionValues = $ParentSectionValues;
$this->Parent_2_SectionValues = $Parent_2_SectionValues;
$this->Parent_3_SectionValues = $Parent_3_SectionValues;
$this->Parent_4_SectionValues = $Parent_4_SectionValues;
$this->Parent_5_SectionValues = $Parent_5_SectionValues;
}
开发者ID:neruruguay,项目名称:neru,代码行数:58,代码来源:Section.php
示例6: getQuery
public static function getQuery($param = null)
{
/* @var $param type */
if ($param) {
$SKTDB = \CmsDev\sql\db_Skt::connect();
$QUERY = "CREATE TABLE `lists` (`ID` int(11) NOT NULL, `ListName` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;\r\n TRUNCATE TABLE `lists`;\r\n INSERT INTO `lists` (`ID`, `ListName`) VALUES (29, 'Demo'),(28, 'Inmuebles');\r\n ALTER TABLE `lists` ADD PRIMARY KEY (`ID`);\r\n ALTER TABLE `lists` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;";
$insertLink = $SKTDB->query($QUERY);
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:9,代码来源:schema.php
示例7: foreach
function __construct()
{
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$categories = $SKTDB->get_results("SELECT * FROM " . \DB_PREFIX . "categories");
foreach ($categories as $Category) {
$ListNames[$Category->category_id] = $Category->category_name;
}
self::$names = $ListNames;
}
开发者ID:neruruguay,项目名称:neru,代码行数:9,代码来源:Categories.php
示例8: setParamsFromFile
private static function setParamsFromFile()
{
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$query = $SKTDB->get_results("SELECT * FROM language ORDER BY LanguageName ASC");
global $SKT;
foreach ($query as $language) {
include 'site/' . $language->Prefix . '.php';
$Setparams = $SKTDB->query(\sprintf("UPDATE language Set SiteParams = %s\r\n\t\tWHERE ID = %s", GetSQLValueString(json_encode($SKT), "text"), GetSQLValueString($language->ID, "int")));
//$MessageBox = SKT_INFO\Asistance::get();
//$MessageBox->TipOk('El archivo Language/site/' . $language->Prefix . '.php, fue cargado correctamente.', true);
}
//self::getParams();
}
开发者ID:neruruguay,项目名称:neru,代码行数:13,代码来源:SiteGlosary.php
示例9: isset
function __construct($user, $SERVER, $POST, $GET)
{
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$user = $user;
$url = !empty($SERVER['HTTPS']) ? "https://" . $SERVER['SERVER_NAME'] . $SERVER['REQUEST_URI'] : "http://" . $SERVER['SERVER_NAME'] . $SERVER['REQUEST_URI'];
$previousUrl = isset($SERVER['HTTP_REFERER']) ? $SERVER['HTTP_REFERER'] : '0';
$postData = json_encode($POST);
$now = date("Y-m-d H:i:s");
$product = isset($GET['DetailID']) ? $GET['DetailID'] : '';
$search = isset($GET['SearchQuery']) ? $GET['SearchQuery'] : '';
$query = "INSERT INTO userstep" . "(user, previous_page, url_query_string, post_param, date_time, product, search )" . "VALUES (" . GetSQLValueString($user, 'int') . "," . GetSQLValueString($previousUrl, 'text') . "," . GetSQLValueString($url, 'text') . "," . GetSQLValueString($postData, 'text') . "," . GetSQLValueString($now, 'text') . "," . GetSQLValueString($product, 'int') . "," . GetSQLValueString($search, 'text') . ")";
$insert = $SKTDB->query($query);
}
开发者ID:neruruguay,项目名称:neru,代码行数:13,代码来源:history.php
示例10: set
public function set($PositionSelect = null, $SID = null)
{
if ($PositionSelect !== null && $SID !== null) {
$randomID = 'Position' . \md5(\rand(1000, 99999));
$SID = \GetSQLValueString($SID, 'int');
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$total = $SKTDB->get_var("SELECT count(*) FROM " . \DB_PREFIX . "sections WHERE Language = '" . \THIS_LANG . "' AND SID = '{$SID}'");
if (!isset($PositionSelect) or $PositionSelect == null) {
$PositionSelect = 0;
} elseif ($PositionSelect === 'max') {
$PositionSelect = $total + 1;
}
$this->HTML .= '<input name="Position" id="' . $randomID . '" type="text" value="' . $PositionSelect . '" />';
$this->HTML .= '<script type="text/javascript">';
$this->HTML .= '$("#' . $randomID . '").spinner({step: 1,numberFormat: "n", min: 0, max: ' . ($total + 1) . '});';
//$this->HTML .= 'alert("$total =' . $total . ' y $SID =' . $SID . ' y $PositionSelect =' . $PositionSelect . '");';
$this->HTML .= '</script>';
return $this->HTML;
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:20,代码来源:List_Position_Section.php
示例11: level
private function level($IDPage, $SID)
{
$SKTDB = \CmsDev\sql\db_Skt::connect();
$Menu = $SKTDB->get_results("SELECT ID,Title,URLName,SID,Language FROM " . \DB_PREFIX . "sections WHERE SID = '" . $SID . "' ORDER BY Position ASC");
if ($Menu) {
$this->L++;
foreach ($Menu as $Section) {
if ($Section->ID === $IDPage) {
$selected = ' selected="selected"';
} else {
$selected = '';
}
$this->HTML .= '<option value="' . $Section->ID . '" ' . $selected . ' class="L' . $this->L . '"> ' . utf8_encode($Section->URLName) . '</option>';
if ($SKTDB->get_var("SELECT count(*) FROM " . DB_PREFIX . "sections WHERE SID = '" . $Section->ID . "'") > 0) {
$this->HTML .= self::level($IDPage, $Section->ID);
}
}
$this->L = $this->L - 1;
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:20,代码来源:ListParentPage.php
示例12: set
public static function set($PositionSelect = null, $IDPage = null, $Zone = 0)
{
if ($PositionSelect !== null && $IDPage !== null) {
$rand = rand(2, 654);
$Input = '<input name="Position" id="Position" class="Position' . $rand . ' form-control" type="text" value="[val]" />';
$IDPage = \GetSQLValueString($IDPage, 'int');
$Zone = \GetSQLValueString($Zone, 'int');
$HTML = '';
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$total = $SKTDB->get_var("SELECT count(*) FROM " . \DB_PREFIX . "content WHERE IDZone = '" . $Zone . "' AND IDPage = '{$IDPage}'");
if (!isset($PositionSelect) or $PositionSelect == null) {
$PositionSelect = 0;
} elseif ($PositionSelect === -1) {
$PositionSelect = $total + 1;
}
$HTML .= str_replace('[val]', $PositionSelect, $Input);
$HTML .= '<script type="text/javascript">';
$HTML .= '$(".Position' . $rand . '").spinner({step: 1,numberFormat: "n", min: 0, max: ' . ($total + 1) . '});';
$HTML .= '</script>';
return $HTML;
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:22,代码来源:List_Position_Zone.php
示例13: set
public function set($DisplayOnMenuSel = 1, $Encode = 0)
{
$SKTDB = \CmsDev\sql\db_Skt::connect();
$QueryDisplayOnMenu = $SKTDB->get_results("SELECT * FROM " . \DB_PREFIX . "menu");
$this->HTML = '<select name="DisplayOnMenu">';
foreach ($QueryDisplayOnMenu as $DisplayOnMenu) {
$theName = $DisplayOnMenu->Name;
if ($Encode !== 0) {
$theName = $theName;
}
if ($DisplayOnMenuSel == $DisplayOnMenu->ID) {
$this->HTML .= '<option value="' . $DisplayOnMenu->ID . '" selected="selected">' . \CmsDev\skt_Code::Charset($theName) . '</option>';
} else {
$this->HTML .= '<option value="' . $DisplayOnMenu->ID . '">' . \CmsDev\skt_Code::Charset($theName) . '</option>';
}
$CountTotalOnMenu = $SKTDB->get_var("SELECT count(*) FROM " . \DB_PREFIX . "sections WHERE DisplayOnMenu = '" . $DisplayOnMenu->ID . "' AND SID = '" . \SKT_SECTION_ID . "' AND Language = '" . \THIS_LANG . "'");
$this->ArrayCountOnMenu .= 'CountOnMenu[' . $DisplayOnMenu->ID . '] = ' . $CountTotalOnMenu . ';';
}
$this->HTML .= '</select><script type="text/javascript">';
$this->HTML .= $this->ArrayCountOnMenu;
$this->HTML .= '</script>';
return $this->HTML;
}
开发者ID:neruruguay,项目名称:neru,代码行数:23,代码来源:List_Menu.php
示例14: Render
protected static function Render($Type = 'All', $SearchTxt = 'Negocios', $limit = 100)
{
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$SearchTxt = self::DecodeValue(strtolower($SearchTxt));
$Resultssections = $SKTDB->get_results("SELECT * FROM " . DB_PREFIX . "sections AS sections WHERE \r\n\t( sections.RecycleBin = '0' AND sections.SectionType < '3' AND sections.Title like '%{$SearchTxt}%')\r\n\tOR \r\n\t( sections.RecycleBin = '0' AND sections.SectionType < '3' AND sections.Description like '%{$SearchTxt}%' )\r\n\tOR \r\n\t( sections.RecycleBin = '0' AND sections.SectionType < '3' AND sections.URLName like '%{$SearchTxt}%' )\r\n\tOR \r\n\t( sections.RecycleBin = '0' AND sections.SectionType < '3' AND sections.MetaDataTitle like '%{$SearchTxt}%' )\r\n\tOR \r\n\t( sections.RecycleBin = '0' AND sections.SectionType < '3' AND sections.MetaDataDescription like '%{$SearchTxt}%' )\r\n\tOR \r\n\t( sections.RecycleBin = '0' AND sections.SectionType < '3' AND sections.MetaDataKeywords like '%{$SearchTxt}%' )" . "LIMIT " . $limit . "");
$Resultscontent = $SKTDB->get_results("" . "SELECT content.*,sections.ID, sections.URLName " . "FROM " . DB_PREFIX . "content AS content," . DB_PREFIX . "sections AS sections \r\n WHERE \r\n\t( content.RecycleBin = '0' AND content.Content like '%{$SearchTxt}%' AND content.IDPage = sections.ID )\r\n\tOR \r\n\t( content.RecycleBin = '0' AND content.Description like '%{$SearchTxt}%' AND content.IDPage = sections.ID )" . "LIMIT " . $limit . "");
if (!$Resultssections && !$Resultsproducts && !$Resultscontent) {
//echo 'No se encontraron coincidencias en contenidos para "' . $SearchTxt . '"...';
}
if ($Resultssections) {
echo '<h4>Secciones</h4>';
foreach ($Resultssections as $ResultItem) {
if ($ResultItem->SectionType == 1) {
echo '<li id="listItem_' . $ResultItem->ID . '" class="ui-corner-all">
<a href="' . \SKTURL . $ResultItem->URLName . '" class="ui-corner-all" style="vertical-align:middle;">
<img src="_FileSystems/images/' . $ResultItem->SectionImage . '" alt="" style="vertical-align:middle;" />
' . $ResultItem->Title . '
<span>' . $ResultItem->Description . '</span>
</a>
</li>';
}
}
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:24,代码来源:SearchContentSection.php
示例15: GetHowUse
public static function GetHowUse($IDList = '')
{
global $SKT;
echo '<div class="container_16" style="max-width: none; width: 100%;">';
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$NameList = $SKTDB->get_var("SELECT ListName FROM lists WHERE ID = '{$IDList}'");
if ($NameList) {
$Query_Lists_Values_Count = $SKTDB->get_var("SELECT count(ID) FROM lists_values WHERE IDList = '{$IDList}'");
$Query_Lists_Fields = $SKTDB->get_row("SELECT * FROM lists_fields WHERE IDLists = '{$IDList}'");
echo '<div class="grid_4"><table class="table table-striped">
<caption>La Lista <b>"' . $NameList . '"</b> contiene <b>' . $Query_Lists_Values_Count . '</b> elementos ingresados con los siguientes campos:</caption>
<thead>
<tr>
<th scope="col">Nombre</th>
<th scope="col">Tipo</th>
</tr>
</thead>
<tbody>';
$even = true;
if ($Query_Lists_Fields) {
foreach ($Query_Lists_Fields as $Values) {
if (strstr($Values, '|')) {
$Params = explode("|", $Values);
switch ($Params[0]) {
case 0:
$Type = 'Int';
break;
case 1:
$Type = 'Varchar';
break;
case 2:
$Type = 'Text';
break;
case 3:
$Type = 'Link';
break;
case 4:
$Type = 'Enum';
break;
case 5:
$Type = 'HTML';
break;
case 6:
$Type = 'Date';
break;
case 7:
$Type = 'Basic HTML';
break;
default:
$Type = '';
break;
}
if ($even) {
$evenst = 'even';
} else {
$evenst = 'odd';
}
echo '<tr class="' . $evenst . '"><td>' . $Params[1] . '</td><td>(' . $Type . ')</td></tr>';
if ($even) {
$even = false;
} else {
$even = true;
}
}
}
}
echo '<tr><td colspan="2" style=" font-size: 14px; color: #FF1263;">+ Campos Auto-generados</td></tr>';
echo '<tr class="even"><td>ID</td><td>(int)</td></tr>';
echo '<tr class="odd"><td>IDLists</td><td>(int)</td></tr>';
echo '<tr class="even"><td>RecycleBin</td><td>(enum = \'0\',\'1\')</td></tr>';
echo '<tr class="odd"><td>Position</td><td>(int)</td></tr>';
echo '<tr class="odd"><td>datePost</td><td>(date) Patrón: <b>' . date('Y-m-d') . '</b></td></tr>';
echo '</tbody></table></div>';
echo '<div class="grid_12">';
echo '<h1 style="font-size: 14px; color: #FF1263; line-height: normal; margin: 0 0 10px;">Para obtener los resultados de esta lista cuenta con las siguientes opciones:</h1>';
echo '<h2 style="font-size: 16px; color: #06A7EA; line-height: normal; margin: 0 0 10px;">Mediante Servicio Web:</h2>
<h3 style="font-size: 14px; color: #06A7EA; line-height: normal; margin: 0 0 10px;">Template HTML (Ej.: List Servicios)</h3>';
echo '<pre><code class="php">
<?php
$json = \'_Service_/p/Lists/getJSON/Servicios|ASC|ID|3|null|null\';
$data = file_get_contents($json);
$array = json_decode($data);
?>
<div class="container">
<div class="row">
<?php
foreach ($array as $obj) {
$Titulo = $obj->Titulo;
$Descripcion = $obj->Descripcion;
$icono = $obj->icono;
$Link = $obj->Link;
echo \'<div class="col-md-4">
<span class="fa-stack fa-4x">
\' . $icono . \'
</span>
<h4 class="service-heading">\' . $Titulo . \'</h4>
<p class="text-muted">\' . $Descripcion . \'</p>
<a href="\' . $Link . \'">Ver m&aacute;s+</a>
</div>\';
//.........这里部分代码省略.........
开发者ID:neruruguay,项目名称:neru,代码行数:101,代码来源:List_Information.php
示例16: Remove
protected function Remove($ID = '')
{
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$DeleteQuery = $SKTDB->query("DELETE FROM " . \DB_PREFIX . "products WHERE UID = '" . \GetSQLValueString(\str_replace('ID', '', $ID), "int") . "' LIMIT 1");
if ($DeleteQuery) {
echo 'ok';
} else {
echo \SKT_ADMIN_Message_Update_Error;
}
}
开发者ID:neruruguay,项目名称:neru,代码行数:10,代码来源:_classes.php
示例17: Render
public function Render($ID = 0)
{
$CC = '';
$SKTDB = \CmsDev\Sql\db_Skt::connect();
if ($SKT_Controls = $SKTDB->get_row("SELECT Custom FROM " . \DB_PREFIX . "content WHERE ID = '{$ID}'")) {
$CC = $SKT_Controls->Custom;
}
$SelectedIni = '';
$Select = '<select name="Custom" id="Custom" class="text ui-corner-all" >';
/* ------------------------------------------------------------------------------------------------- */
/* ------------------------------ FROM TEMPLATE --------------------------------------------- */
$SKTDBTemplate = \LOCAL_DIR . \SKTURL_TemplateSite . '/SKT_Controls/';
if (file_exists($SKTDBTemplate)) {
$Select .= '<option value="" disabled="disabled" class="ui-widget-header">From Template</option>';
$directorio = $SKTDBTemplate;
if (file_exists($directorio)) {
$handle = opendir($directorio);
while ($file = readdir($handle)) {
if (!is_dir($file) && $file != ".." && $file != "." && $file != "CustomPropertyURI_for_Files.php") {
$Selected = '';
$thisCC = $CC;
if ($thisCC != 0 || $thisCC != '') {
if ($thisCC == $file) {
$Selected = 'selected="selected"';
} else {
$Selected = '';
}
}
$ControlType = '';
$find = strstr($file, 'File_');
if ($find == true) {
$ControlType = 'TypeFiles';
}
$find2 = strstr($file, 'Folder_');
if ($find2 == true) {
$ControlType = 'TypeFolder';
}
$find3 = strstr($file, 'Customized_');
if ($find3 == true) {
$ControlType = 'Customized';
}
$fileName = str_replace('File', '', $file);
$fileName = str_replace('Folder', '', $fileName);
$fileName = str_replace('Customized', '', $fileName);
$fileName = str_replace('_', ' ', $fileName);
$Select .= '<option class="' . $ControlType . '" ' . $Selected . ' title="' . \SKTURL_TemplateSite . '/SKT_Controls/" value="' . $file . '">' . $fileName . '</option>';
}
}
closedir($handle);
}
}
/* ------------------------------------------------------------------------------------------------- */
/* ------------------------------ FROM ROOT ------------------------------------------------- */
$directorio = \LOCAL_DIR . 'CmsDev/Modules/';
if (file_exists($directorio)) {
$Select .= '<option value="" disabled="disabled" class="ui-widget-header">General</option>';
$handle = opendir($directorio);
while ($file = readdir($handle)) {
if (!is_dir($file) && $file != ".." && $file != "." && $file != "CustomPropertyURI_for_Files.php") {
$Selected = '';
$thisCC = $CC;
if ($thisCC != 0 || $thisCC != '') {
if ($thisCC == $file) {
$Selected = 'selected="selected"';
} else {
$Selected = '';
}
}
$ControlType = '';
$find = strstr($file, 'File_');
if ($find == true) {
$ControlType = 'TypeFiles';
}
$find2 = strstr($file, 'Folder_');
if ($find2 == true) {
$ControlType = 'TypeFolder';
}
$find3 = strstr($file, 'Customized_');
if ($find3 == true) {
$ControlType = 'Customized';
}
$fileName = str_replace('File_', '', $file);
$fileName = str_replace('Folder_', '', $file);
$fileName = str_replace('Customized', '', $file);
$fileName = str_replace('_', ' ', $fileName);
$Select .= '<option class="' . $ControlType . '" ' . $Selected . ' title="" value="' . $file . '">' . $fileName . '</option>';
}
}
closedir($handle);
}
$Select .= '</select>';
return $Select;
}
开发者ID:neruruguay,项目名称:neru,代码行数:93,代码来源:List_SKT_Controls.php
示例18: MakeNewUser
private static function MakeNewUser($Client = false, $Info = array(), $LevelType = 'Customers')
{
$SKTDB = \CmsDev\Sql\db_Skt::connect();
$new_Google = false;
$new_Facebook = false;
$CheckUserName = new \CmsDev\util\CheckUserName();
$username = Code::Charset(isset($Info['username']) ? $Info['username'] : '');
$password = md5(isset($Info['password']) ? $Info['password'] : '');
$email = Code::Charset(isset($Info['email']) ? $Info['email'] : '');
$isactive = isset($Info['isactive']) ? $Info['isactive'] : 0;
$activekey = isset($Info['activekey']) ? $Info['activekey'] : 0;
$resetkey = isset($Info['resetkey']) ? $Info['resetkey'] : 0;
$cust_no = isset($Info['cust_no']) ? $Info['cust_no'] : 0;
$md5 = isset($Info['md5']) ? $Info['md5'] : md5($username) . $password;
$Description = isset($Info['Description']) ? $Info['Description'] : '';
$Lat = isset($Info['Lat']) ? $Info['Lat'] : '-35';
$Lon = isset($Info['Lon']) ? $Info['Lon'] : '-54';
$zoom = isset($Info['zoom']) ? $Info['zoom'] : '12';
$Type = isset($Info['Type']) ? $Info['Type'] : $LevelType;
$website = isset($Info['website']) ? $Info['website'] : '';
$ViewHelp = isset($Info['ViewHelp']) ? $Info['ViewHelp'] : 0;
$token = isset($Info['token']) ? $Info['token'] : '';
$Company = isset($Info['Company']) ? $Info['Company'] : $Info["username"];
$CompanyUrl = isset($Info['CompanyUrl']) ? $Info['CompanyUrl'] : $CheckUserName->Fix($username);
$Level = isset($Info['level']) ? $Info['level'] : $Type;
$RUT = isset($Info['RUT']) ? $Info['RUT'] : '';
$Position = isset($Info['Position']) ? $Info['Position'] : '';
$Name = isset($Info['Name']) ? $Info['Name'] : '';
$Surname = isset($Info['Surname']) ? $Info['Surname'] : '';
$Country = isset($Info['Country']) ? $Info['Country'] : '';
$City = isset($Info['City']) ? $Info['City'] : '';
$CP = isset($Info['CP']) ? $Info['CP'] : '';
$Address = isset($Info['Address']) ? $Info['Address'] : '';
$From = isset($Info['From']) ? $Info['From'] : '09';
$To = isset($Info['To']) ? $Info['To'] : '18';
$Phone = isset($Info['Phone']) ? $Info['Phone'] : '';
$payment_method = isset($Info['payment_method']) ? $Info['payment_method'] : '';
$ClientAuth = isset($Info['ClientAuth']) ? $Info['ClientAuth'] : '';
$ClientAuth_id = isset($Info['ClientAuth_id']) ? $Info['ClientAuth_id'] : '';
$ClientAuth_link = isset($Info['ClientAuth_link']) ? $Info['ClientAuth_link'] : '';
$ClientAuth_name = isset($Info['ClientAuth_name']) ? $Info['ClientAuth_name'] : '';
$ClientAuth_family_name = isset($Info['ClientAuth_family_name']) ? $Info['ClientAuth_family_name'] : '';
$ClientAuth_given_name = isset($Info['ClientAuth_given_name']) ? $Info['ClientAuth_given_name'] : '';
$ClientAuth_email = isset($Info['ClientAuth_email']) ? $Info['ClientAuth_email'] : '';
$ClientAuth_picture = isset($Info['ClientAuth_picture']) ? $Info['ClientAuth_picture'] : '';
$ClientAuth_locale = isset($Info['ClientAuth_locale']) ? $Info['ClientAuth_locale'] : '';
$ClientAuth_gender = isset($Info['ClientAuth_gender']) ? $Info['ClientAuth_gender'] : '';
$category1 = isset($Info['category1']) ? $Info['category1'] : '';
$category2 = isset($Info['category2']) ? $Info['category2'] : '';
$category3 = isset($Info['category3']) ? $Info['category3'] : '';
$category4 = isset($Info['category4']) ? $Info['category4'] : '';
$category5 = isset($Info['category5']) ? $Info['category5'] : '';
if ($Client == 'FromGoogle') {
/* ----------------------------------------------------------------------/// FromGoogle ///-------------- */
$Name = $Info['name'];
$Surname = $Info['family_name'];
$ClientAuth = $Info['ClientAuth'];
$ClientAuth_id = $Info['id'];
$ClientAuth_link = $Info['link'];
$ClientAuth_name = $Info['name'];
$ClientAuth_family_name = $Info['family_name'];
$ClientAuth_given_name = $Info['given_name'];
$ClientAuth_email = $Info['email'];
$ClientAuth_picture = $Info['picture'];
$ClientAuth_locale = $Info['locale'];
$ClientAuth_gender = $Info['gender'];
$username = Code::Encode($Info['given_name']);
$password = md5($Info['id']);
$email = $Info['email'];
$isactive = 1;
$md5 = md5($username . $password);
$Company = $Info['name'];
$CompanyUrl = $CheckUserName->Fix($Info['name']);
$Type = 'Customers';
$user_listQuery = "SELECT *\r\n FROM users as user, userprofile as profile\r\n WHERE user.id = profile.IDX AND profile.ClientAuth = 'Google' AND profile.ClientAuth_id = " . \GetSQLValueString($Info["id"], 'text') . "";
$user_list = $SKTDB->get_row($user_listQuery);
$MessageBox = SKT_INFO\Asistance::get();
$MessageBox->TipInfo('<b>' . $Name . '.</b><br><pre>' . $user_listQuery . '</pre><pre>' . $user_list->username . '</pre>', false);
if ($user_list) {
$_SESSION['UserName'] = $user_list->username;
$session = md5($user_list->username . $user_list->password);
$_SESSION['login'] = $session;
$_SESSION['UserIDU'] = $user_list->id;
$new_Google = false;
$header = \SERVER_DIR;
\CmsDev\Header\refresh::refreshNow(\SITE_SERVER);
exit;
} else {
$new_Google = true;
}
/* ------------------------------------------------------------------------------------------------------ */
} else {
if ($Client == 'FromFacebook') {
/* --------------------------------------------------------------------/// FromFacebook ///-------------- */
/* ------------------------------------------------------------------------------------------------------ */
} else {
}
}
if ($Client == 'FromSite' || $new_Google == true || $new_Facebook == true) {
if ($username != '' || !isset($_SESSION['login'])) {
//.........这里部分代码省略.........
开发者ID:neruruguay,项目名称:neru,代码行数:101,代码来源:UserRegister.php
示例19: section
private function section()
{
$SKT = \CmsDev\util\globals::getVar('SKT');
$SKTDB = SKTDB\db_Skt::connect();
$SectionValues = \CmsDev\Content\Section::get();
$ParentSectionValues = $SectionValues->ParentSectionValues;
$Parent_2_SectionValues = $SectionValues->Parent_2_SectionValues;
$Parent_3_SectionValues = $SectionValues->Parent_3_SectionValues;
$Parent_4_SectionValues = $SectionValues->Parent_4_SectionValues;
$Parent_5_SectionValues = $SectionValues->Parent_5_SectionValues;
$query = $SKTDB->query("SELECT * FROM " . \DB_PREFIX . "sections WHERE SID = '0'");
$query2 = $SKTDB->get_col_info($info_type = "name", $col_offset = -1);
$cols = array();
foreach ($query2 as $name) {
array_push($cols, $name);
}
foreach ($cols as $col) {
$val[$col] = $SectionValues->{$col};
\define($this->fixdef('SKT_SECTION_' . $col), $SectionValues->{$col});
}
if (\is_object($ParentSect
|
请发表评论