function SiteCreatorAdm(&$smarty, $form = false) { $tabela = $smarty->cfg['prefix'] . 'bilder_site'; $smarty->assign($smarty->actualpage); $page = new PageBilder($smarty, $form); $file = new SiteCreator(); if ($_POST['action'] && !$form['action']) { $form['action'] = $_POST['action']; } if ($_POST['idde'] && !$form['idde']) { $form['idde'] = $_POST['idde']; } switch ($form['action']) { case 'save': $request = $page->SqlSelect("SELECT * FROM {$tabela} WHERE ID_SITE = {$form['idde']}"); $itens = mysql_fetch_array($request, MYSQL_ASSOC); $file->SaveSiteEditor($smarty, $form); if ($file->SaveSiteEditor($smarty, $form)) { return $smarty->getFinishError('sitecreator_erro_03'); } ################## ### criar LOG #### ################## ################## ### criar LOG #### ################## case 'edit': $smarty->assign($form); $request = $page->SqlSelect("SELECT * FROM {$tabela} WHERE ID_SITE = '{$form['idde']}'"); $itens = mysql_fetch_array($request, MYSQL_ASSOC); $file->LoadSiteEditor($smarty, $form); return $smarty->fetch($smarty->modulo_dir . "sitecreator_adm_editor.tpl"); break; case 'del': if (is_numeric($page->uri['idde'])) { $file->RemoveSite($smarty, $form); $sql = $page->SqlDelete($tabela, "ID_SITE ='{$page->uri[idde]}'"); $page->SqlSelect($sql); ## remover grupo } $cfg = array("SetTable" => $tabela, "SetCaption" => array("ID_SITE", "site_name", "site_dominio")); if (isset($page->uri['busca']) && $page->uri['busca'] != "") { $cfg["SetSearch"] = $page->uri['busca']; } $cfg["SetOrdenar"] = $page->uri['por']; $cfg["SetOrder"] = $page->uri["ord"]; $page->CreateSelectSQL($cfg, $smarty); $form['tabela'] = $cfg['SetTable']; $form['coluna'] = $cfg['ID_SITE']; $smarty->register_object("listagem", $page); return $smarty->fetch($smarty->modulo_dir . "sitecreator_adm.tpl"); break; case 'view': case 'redit': default: $cfg = array("SetTable" => $tabela, "SetCaption" => array("ID_SITE", "site_name", "site_dominio")); if (isset($page->uri['busca']) && $page->uri['busca'] != "") { $cfg["SetSearch"] = $page->uri['busca']; } $cfg["SetOrdenar"] = $page->uri['por']; $cfg["SetOrder"] = $page->uri["ord"]; $page->CreateSelectSQL($cfg, $smarty); $form['tabela'] = $cfg['SetTable']; $form['coluna'] = $cfg['ID_SITE']; $smarty->register_object("listagem", $page); return $smarty->fetch($smarty->modulo_dir . "sitecreator_adm.tpl"); } }
function smarty_function_sqldropdown($params, &$smarty) { if (!$params["id"] || $params["id"] == "") { return $smarty->getFinishError("ERROR_008", array("", '(id)')); } if (!$params["SetLabel"] || $params["SetLabel"] == "") { return $smarty->getFinishError("ERROR_008", array("", '(SetLabel)')); } if (!$params["SetValue"] || $params["SetValue"] == "") { return $smarty->getFinishError("ERROR_008", array("", '(SetValue)')); } $params["SetCaption"] = array_merge($params["SetValue"], $params["SetLabel"]); $page = new PageBilder($smarty); $sql = $page->CreateSelectSQL($params, $smarty); $result = $page->SqlSelect($sql); if (mysql_affected_rows() > 0) { while ($item = mysql_fetch_array($result, MYSQL_ASSOC)) { if (isset($params["SetGroup"])) { $vec = $item[$params["SetGroup"]]; $vec[] = array('value' => $item[$params["SetValue"]], 'label' => $item[$params["SetLabel"]], 'selected' => $params["SetSelectd"] == $item[$params["SetValue"]] ? 'selected' : null); } else { $vec[] = array('value' => $item[$params["SetValue"]], 'label' => $item[$params["SetLabel"]], 'selected' => $params["SetSelectd"] == $item[$params["SetValue"]] ? 'selected' : $params["SetSelectd"] == $item[$params["SetLabel"]] ? 'selected' : null); } } } else { $vec[] = array('value' => '0', 'label' => $smarty->get_config_vars('ERROR_010')); } ##### Traduzir conteudos ##### if (isset($params["SetTranslation"])) { foreach ($vec as $valor) { $val = $params["SetTranslation"] . strtr($valor['value'], "-", "_"); $valor['label'] = $smarty->get_config_vars($val) ? $smarty->get_config_vars($val) : $valor['label']; $novo[] = $valor; } } else { $novo = $vec; } usort($novo, "cmp"); reset($novo); ######################## $optionSelect = '<select id="' . $params["id"] . '" name="' . $params["id"] . '"'; if (isset($params["size"]) && $params["size"] != "") { $optionSelect .= 'size="' . $params["size"] . '"'; } if (isset($params["height"]) && $params["height"] != "") { $optionSelect .= 'height="' . $params["height"] . '"'; } if (isset($params["onChange"]) && $params["onChange"] != "") { $optionSelect .= 'onchange="' . $params["onChange"] . '"'; } if (isset($params["onFocus"]) && $params["onFocus"] != "") { $optionSelect .= 'onfocus="' . $params["onFocus"] . '"'; } if (isset($params["onBlur"]) && $params["onBlur"] != "") { $optionSelect .= 'onblur="' . $params["onBlur"] . '"'; } $optionSelect .= ' >'; if (isset($params["SetInicial"])) { $optionSelect .= '<option value="0">' . $params["SetInicial"] . '</option>' . "\r\n"; } if (isset($params["SetGroup"])) { ##asdasd } else { foreach ($novo as $itemcat) { $check = $itemcat['selected'] == null ? null : " selected=\"{$itemcat['selected']}\""; $optionSelect .= '<option value="' . $itemcat['value'] . '"' . $check . '>' . $itemcat['label'] . '</option>'; } } $optionSelect .= '</select>'; return $optionSelect; }
function UsuarioAdm(&$smarty, $form = false) { $tabela = $smarty->cfg['prefix'] . 'members'; $smarty->assign($smarty->actualpage); $page = new PageBilder($smarty, $form); $cfg = array("SetTable" => $tabela, "SetOrdenar" => $page->uri['por'], "SetOrder" => $page->uri["ord"], "SetCaption" => array("ID_MEMBER", "member_name", "member_real")); if (isset($page->uri['busca']) && $page->uri['busca'] != "") { $cfg["SetSearch"] = $page->uri['busca']; } $page->CreateSelectSQL($cfg, $smarty); $smarty->register_object("listagem", $page); $page->uri['tabela'] = $tabela; $page->uri['coluna'] = 'ID_MEMBER'; $user = $smarty->getVars('ID_MEMBER'); switch ($page->uri['action']) { case 'view': $page->uri['prefix'] = 'member'; $page->uri['prefixch'] = 'registro'; $page->uri['select'] = '*, ID_MEMBER as registro_id'; $item = $page->exibeRegistro($page->uri, $smarty); $smarty->assign($item); $p = $smarty->fetch($smarty->modulo_dir . "usuario_adm_view.tpl"); $smarty->clear_assign($item); return $p; break; case 'edit': $page->uri['prefix'] = 'member'; $page->uri['prefixch'] = 'registro'; $page->uri['select'] = '*, ID_MEMBER as registro_id'; $item = $page->exibeRegistro($page->uri, $smarty); $smarty->assign($item); $p = $smarty->fetch($smarty->modulo_dir . "usuario_adm_edit.tpl"); $smarty->clear_assign($item); $smarty->assign('ID_MEMBER', $user); return $p; break; case 'del': if (is_numeric($page->uri['idde'])) { $sql = $page->SqlDelete($tabela, "ID_MEMBER ='{$page->uri[idde]}'"); $page->SqlSelect($sql); ## remover grupo } return $smarty->fetch($smarty->modulo_dir . "usuario_adm.tpl"); break; case 'redit': if ($page->uri['action'] == 'redit') { if (!(trim($form['member_password']) == null || trim($form['member_password']) == "")) { $form['member_password'] = Registro::md5_hmac($form['member_password'], strtolower($form['member_name'])); } else { unset($form['member_password']); } $form['member_ip'] = $_SERVER['REMOTE_ADDR']; if (is_numeric($form[idde])) { $idde = $form[idde]; unset($form[idde]); $sql = $page->SqlUpdate($page->uri['tabela'], $form, "ID_MEMBER = '{$idde}'"); $request = $page->SqlSelect($sql); } return $smarty->fetch($smarty->modulo_dir . "usuario_adm.tpl"); } break; default: return $smarty->fetch($smarty->modulo_dir . "usuario_adm.tpl"); } }
function smarty_function_sqlradiobox($params, &$smarty) { if (!$params["id"] || $params["id"] == "") { return $smarty->getFinishError("ERROR_008", array("", '(id)')); } if (!$params["SetLabel"] || $params["SetLabel"] == "") { return $smarty->getFinishError("ERROR_008", array("", '(SetLabel)')); } if (!$params["SetValue"] || $params["SetValue"] == "") { return $smarty->getFinishError("ERROR_008", array("", '(SetValue)')); } $params["SetCaption"] = array_merge($params["SetValue"], $params["SetLabel"]); $page = new PageBilder($smarty); $sql = $page->CreateSelectSQL($params, $smarty); $result = $page->SqlSelect($sql); if (mysql_affected_rows() > 0) { while ($item = mysql_fetch_array($result, MYSQL_ASSOC)) { $vec[] = array('value' => $item[$params["SetValue"]], 'label' => $item[$params["SetLabel"]], 'selected' => $params["SetSelectd"] == $item[$params["SetValue"]] ? 'checked' : $params["SetSelectd"] == $item[$params["SetLabel"]] ? 'checked' : null); } } else { return $smarty->getFinishError("ERROR_011"); } ##### Traduzir conteudos ##### if (isset($params["SetTranslation"])) { foreach ($vec as $valor) { $val = $params["SetTranslation"] . $valor['value']; $valor['label'] = $smarty->get_config_vars($val) ? $smarty->get_config_vars($val) : $val; $novo[] = $valor; } } else { $novo = $vec; } usort($novo, "cmp"); reset($novo); ######################## $optionSelect = ''; foreach ($novo as $itemcat) { $optionSelect .= '<label for="' . $params["id"] . "_" . $itemcat['value'] . '">'; if ($params["SetDisplay"] == "img") { $optionSelect .= "<img src=\"{$itemcat['label']}\" "; if (isset($params["SetDisplayheight"])) { $optionSelect .= 'height="' . $params["SetDisplayheight"] . '" '; } if (isset($params["SetDisplaywidth"])) { $optionSelect .= 'width="' . $params["SetDisplaywidth"] . '" '; } $optionSelect .= "/><br />"; } else { $optionSelect .= $itemcat['label']; } $check = $itemcat['selected'] == null ? null : " checked=\"{$itemcat['selected']}\""; $optionSelect .= '<input type="radio" id="' . $params["id"] . "_" . $itemcat['value'] . '" name="' . $params["id"] . '" value="' . $itemcat['value'] . '" '; if ($params["onSelect"]) { $optionSelect .= 'onselect="' . $params["onSelect"] . '" '; } if ($params["onFocus"]) { $optionSelect .= 'onfocus="' . $params["onFocus"] . '" '; } if ($params["onBlur"]) { $optionSelect .= 'onblur="' . $params["onBlur"] . '" '; } if ($params["onClick"]) { $optionSelect .= 'onclick="' . $params["onClick"] . '" '; } $optionSelect .= $check . ' />'; $optionSelect .= '</label>'; } return $optionSelect; }