O Massaki.. valeu.. segue o código da pag. <?php session_start(); ob_start(); ?> <?php header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1 header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); // HTTP/1.0 ?> <?php include ("ewconfig.php") ?> <?php include ("db.php") ?> <?php include ("estoqueinfo.php") ?> <?php include ("advsecu.php") ?> <?php include ("phpmkrfn.php") ?> <?php include ("ewupload.php") ?> <?php if (!IsLoggedIn()) { ob_end_clean(); header("Location: login.php"); exit(); } ?> <?php // Initialize common variables $x_Tipo = NULL; $ox_Tipo = NULL; $z_Tipo = NULL; $ar_x_Tipo = NULL; $ari_x_Tipo = NULL; $x_TipoList = NULL; $x_TipoChk = NULL; $cbo_x_Tipo_js = NULL; $x_anuncio = NULL; $ox_anuncio = NULL; $z_anuncio = NULL; $ar_x_anuncio = NULL; $ari_x_anuncio = NULL; $x_anuncioList = NULL; $x_anuncioChk = NULL; $cbo_x_anuncio_js = NULL; $x_Id_estoque = NULL; $ox_Id_estoque = NULL; $z_Id_estoque = NULL; $ar_x_Id_estoque = NULL; $ari_x_Id_estoque = NULL; $x_Id_estoqueList = NULL; $x_Id_estoqueChk = NULL; $cbo_x_Id_estoque_js = NULL; $x_id_plano = NULL; $ox_id_plano = NULL; $z_id_plano = NULL; $ar_x_id_plano = NULL; $ari_x_id_plano = NULL; $x_id_planoList = NULL; $x_id_planoChk = NULL; $cbo_x_id_plano_js = NULL; $x_data_cadastro = NULL; $ox_data_cadastro = NULL; $z_data_cadastro = NULL; $ar_x_data_cadastro = NULL; $ari_x_data_cadastro = NULL; $x_data_cadastroList = NULL; $x_data_cadastroChk = NULL; $cbo_x_data_cadastro_js = NULL; $x_data = NULL; $ox_data = NULL; $z_data = NULL; $ar_x_data = NULL; $ari_x_data = NULL; $x_dataList = NULL; $x_dataChk = NULL; $cbo_x_data_js = NULL; $x_id_membro = NULL; $ox_id_membro = NULL; $z_id_membro = NULL; $ar_x_id_membro = NULL; $ari_x_id_membro = NULL; $x_id_membroList = NULL; $x_id_membroChk = NULL; $cbo_x_id_membro_js = NULL; $x_categoria = NULL; $ox_categoria = NULL; $z_categoria = NULL; $ar_x_categoria = NULL; $ari_x_categoria = NULL; $x_categoriaList = NULL; $x_categoriaChk = NULL; $cbo_x_categoria_js = NULL; $x_marcas = NULL; $ox_marcas = NULL; $z_marcas = NULL; $ar_x_marcas = NULL; $ari_x_marcas = NULL; $x_marcasList = NULL; $x_marcasChk = NULL; $cbo_x_marcas_js = NULL; $x_marca = NULL; $ox_marca = NULL; $z_marca = NULL; $ar_x_marca = NULL; $ari_x_marca = NULL; $x_marcaList = NULL; $x_marcaChk = NULL; $cbo_x_marca_js = NULL; $x_ano = NULL; $ox_ano = NULL; $z_ano = NULL; $ar_x_ano = NULL; $ari_x_ano = NULL; $x_anoList = NULL; $x_anoChk = NULL; $cbo_x_ano_js = NULL; $x_ano2 = NULL; $ox_ano2 = NULL; $z_ano2 = NULL; $ar_x_ano2 = NULL; $ari_x_ano2 = NULL; $x_ano2List = NULL; $x_ano2Chk = NULL; $cbo_x_ano2_js = NULL; $x_cor = NULL; $ox_cor = NULL; $z_cor = NULL; $ar_x_cor = NULL; $ari_x_cor = NULL; $x_corList = NULL; $x_corChk = NULL; $cbo_x_cor_js = NULL; $x_preco = NULL; $ox_preco = NULL; $z_preco = NULL; $ar_x_preco = NULL; $ari_x_preco = NULL; $x_precoList = NULL; $x_precoChk = NULL; $cbo_x_preco_js = NULL; $x_cidade = NULL; $ox_cidade = NULL; $z_cidade = NULL; $ar_x_cidade = NULL; $ari_x_cidade = NULL; $x_cidadeList = NULL; $x_cidadeChk = NULL; $cbo_x_cidade_js = NULL; $x_km = NULL; $ox_km = NULL; $z_km = NULL; $ar_x_km = NULL; $ari_x_km = NULL; $x_kmList = NULL; $x_kmChk = NULL; $cbo_x_km_js = NULL; $x_placa = NULL; $ox_placa = NULL; $z_placa = NULL; $ar_x_placa = NULL; $ari_x_placa = NULL; $x_placaList = NULL; $x_placaChk = NULL; $cbo_x_placa_js = NULL; $x_condicoes = NULL; $ox_condicoes = NULL; $z_condicoes = NULL; $ar_x_condicoes = NULL; $ari_x_condicoes = NULL; $x_condicoesList = NULL; $x_condicoesChk = NULL; $cbo_x_condicoes_js = NULL; $x_portas = NULL; $ox_portas = NULL; $z_portas = NULL; $ar_x_portas = NULL; $ari_x_portas = NULL; $x_portasList = NULL; $x_portasChk = NULL; $cbo_x_portas_js = NULL; $x_combustivel = NULL; $ox_combustivel = NULL; $z_combustivel = NULL; $ar_x_combustivel = NULL; $ari_x_combustivel = NULL; $x_combustivelList = NULL; $x_combustivelChk = NULL; $cbo_x_combustivel_js = NULL; $x_transmissao = NULL; $ox_transmissao = NULL; $z_transmissao = NULL; $ar_x_transmissao = NULL; $ari_x_transmissao = NULL; $x_transmissaoList = NULL; $x_transmissaoChk = NULL; $cbo_x_transmissao_js = NULL; $x_descricao = NULL; $ox_descricao = NULL; $z_descricao = NULL; $ar_x_descricao = NULL; $ari_x_descricao = NULL; $x_descricaoList = NULL; $x_descricaoChk = NULL; $cbo_x_descricao_js = NULL; $x_oferta = NULL; $ox_oferta = NULL; $z_oferta = NULL; $ar_x_oferta = NULL; $ari_x_oferta = NULL; $x_ofertaList = NULL; $x_ofertaChk = NULL; $cbo_x_oferta_js = NULL; $x_exibir = NULL; $ox_exibir = NULL; $z_exibir = NULL; $ar_x_exibir = NULL; $ari_x_exibir = NULL; $x_exibirList = NULL; $x_exibirChk = NULL; $cbo_x_exibir_js = NULL; $x_avisado = NULL; $ox_avisado = NULL; $z_avisado = NULL; $ar_x_avisado = NULL; $ari_x_avisado = NULL; $x_avisadoList = NULL; $x_avisadoChk = NULL; $cbo_x_avisado_js = NULL; $x_entrada = NULL; $ox_entrada = NULL; $z_entrada = NULL; $ar_x_entrada = NULL; $ari_x_entrada = NULL; $x_entradaList = NULL; $x_entradaChk = NULL; $cbo_x_entrada_js = NULL; $x_qtd_parcelas = NULL; $ox_qtd_parcelas = NULL; $z_qtd_parcelas = NULL; $ar_x_qtd_parcelas = NULL; $ari_x_qtd_parcelas = NULL; $x_qtd_parcelasList = NULL; $x_qtd_parcelasChk = NULL; $cbo_x_qtd_parcelas_js = NULL; $x_valor_parcelas = NULL; $ox_valor_parcelas = NULL; $z_valor_parcelas = NULL; $ar_x_valor_parcelas = NULL; $ari_x_valor_parcelas = NULL; $x_valor_parcelasList = NULL; $x_valor_parcelasChk = NULL; $cbo_x_valor_parcelas_js = NULL; $x_contato = NULL; $ox_contato = NULL; $z_contato = NULL; $ar_x_contato = NULL; $ari_x_contato = NULL; $x_contatoList = NULL; $x_contatoChk = NULL; $cbo_x_contato_js = NULL; $x_acessos = NULL; $ox_acessos = NULL; $z_acessos = NULL; $ar_x_acessos = NULL; $ari_x_acessos = NULL; $x_acessosList = NULL; $x_acessosChk = NULL; $cbo_x_acessos_js = NULL; ?> <?php $nStartRec = 0; $nStopRec = 0; $nTotalRecs = 0; $nRecCount = 0; $nRecActual = 0; $sKeyMaster = ""; $sDbWhereMaster = ""; $sSrchAdvanced = ""; $psearch = ""; $psearchtype = ""; $sDbWhereDetail = ""; $sSrchBasic = ""; $sSrchWhere = ""; $sDbWhere = ""; $sOrderBy = ""; $sSqlMaster = ""; $sListTrJs = ""; $bEditRow = ""; $nEditRowCnt = ""; $sDeleteConfirmMsg = ""; $bMasterRecordExist = false; $x_id = NULL; $ox_id = NULL; $x_id_marca = NULL; $ox_id_marca = NULL; $x_modelo = NULL; $ox_modelo = NULL; $nDisplayRecs = "400050"; $nRecRange = 10; // Open connection to the database $conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT); // Handle reset command ResetCmd(); // Set up master detail parameters SetUpMasterDetail(); // Get search criteria for Basic (Quick) Search $psearch = (!get_magic_quotes_gpc()) ? addslashes(@$_GET[ewTblBasicSrch]) : @$_GET[ewTblBasicSrch]; $psearchtype = @$_GET[ewTblBasicSrchType]; SetUpBasicSearch(); // Build search criteria if ($sSrchAdvanced != "") { if ($sSrchWhere <> "") $sSrchWhere .= " AND "; $sSrchWhere .= "(" . $sSrchAdvanced . ")"; // Advanced Search } if ($sSrchBasic != "") { if ($sSrchWhere <> "") $sSrchWhere .= " AND "; $sSrchWhere .= "(" . $sSrchBasic . ")"; // Basic Search } // Save search criteria if ($sSrchWhere != "") { $_SESSION[ewSessionTblSearchWhere] = $sSrchWhere; // Reset start record counter (new search) $nStartRec = 1; $_SESSION[ewSessionTblStartRec] = $nStartRec; } else { $sSrchWhere = @$_SESSION[ewSessionTblSearchWhere]; RestoreSearch(); } // Build filter condition $sDbWhere = ""; if ($sDbWhereDetail <> "") { if ($sDbWhere <> "") $sDbWhere .= " AND "; $sDbWhere .= "(" . $sDbWhereDetail . ")"; } if ($sSrchWhere <> "") { if ($sDbWhere <> "") $sDbWhere .= " AND "; $sDbWhere .= "(" . $sSrchWhere . ")"; } // Set up sorting order $sOrderBy = ""; SetUpSortOrder(); $sSql = ewBuildSql(ewSqlSelect, ewSqlWhere, ewSqlGroupBy, ewSqlHaving, ewSqlOrderBy, $sDbWhere, $sOrderBy); // echo $sSql . "<br>"; // Uncomment to show SQL for debugging // Build master record SQL if ($sDbWhereMaster <> "") { $sSqlMaster = ewBuildSql(ewSqlMasterSelect, ewSqlMasterWhere, ewSqlMasterGroupBy, ewSqlMasterHaving, ewSqlMasterOrderBy, $sDbWhereMaster, ""); $rs = phpmkr_query($sSqlMaster, $conn) or die("Falha ao executar consulta." . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSqlMaster); $bMasterRecordExist = (phpmkr_num_rows($rs) > 0); if (!$bMasterRecordExist) { $_SESSION[ewSessionTblMasterWhere] = ""; $_SESSION[ewSessionTblDetailWhere] = ""; $_SESSION[ewSessionMessage] = "Nenhum registro encontrado"; phpmkr_free_result($rs); phpmkr_db_close($conn); header("Location: modelolist.php"); exit(); } } ?> <?php include ("header.php") ?> <script type="text/javascript"> <!-- EW_LookupFn = "ewlookup.php"; // ewlookup file name EW_AddOptFn = "ewaddopt.php"; // ewaddopt.php file name //--> </script> <script type="text/javascript" src="ewp.js"></script> <script type="text/javascript"> <!-- EW_dateSep = "/"; // set date separator EW_UploadAllowedFileExt = "gif,jpg,jpeg,bmp,png,doc,xls,pdf,zip"; // allowed upload file extension //--> </script> <script type="text/javascript"> <!-- var firstrowoffset = 1; // first data row start at var tablename = 'ewlistmain'; // table name var lastrowoffset = 0; // footer row var usecss = true; // use css var rowclass = 'ewTableRow'; // row class var rowaltclass = 'ewTableAltRow'; // row alternate class var rowmoverclass = 'ewTableHighlightRow'; // row mouse over class var rowselectedclass = 'ewTableSelectRow'; // row selected class var roweditclass = 'ewTableEditRow'; // row edit class var rowcolor = '#FFFFFF'; // row color var rowaltcolor = '#F5F5F5'; // row alternate color var rowmovercolor = '#FFCCFF'; // row mouse over color var rowselectedcolor = '#CCFFFF'; // row selected color var roweditcolor = '#FFFF99'; // row edit color //--> </script> <script type="text/javascript"> <!-- var EW_DHTMLEditors = []; //--> </script> <?php if ($sDbWhereMaster <> "") { if ($bMasterRecordExist) { ?> <p><span class="phpmaker">Registro principal: MODELOS <br><a href="modelolist.php">Voltar à lista principal</a></span> </p> <table class="ewTable"> <tr class="ewTableHeader"> <td valign="top"><span>marca</span></td> <td valign="top"><span>modelo</span></td> </tr> <tr class="ewTableSelectRow"> <?php $row = phpmkr_fetch_array($rs); $x_id = $row["id"]; $x_id_marca = $row["id_marca"]; $x_modelo = $row["modelo"]; ?> <td><span> <?php if ((!is_null($x_id_marca)) && ($x_id_marca <> "")) { $sSqlWrk = "SELECT `marca` FROM `marca`"; $sTmp = $x_id_marca; $sTmp = addslashes($sTmp); $sSqlWrk .= " WHERE `Id_marca` = " . $sTmp . ""; $rswrk = phpmkr_query($sSqlWrk,$conn) or die("Falha ao executar consulta." . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL:' . $sSqlWrk); if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) { $sTmp = $rowwrk["marca"]; } @phpmkr_free_result($rswrk); } else { $sTmp = ""; } $ox_id_marca = $x_id_marca; // Backup original value $x_id_marca = $sTmp; ?> <?php echo $x_id_marca; ?> <?php $x_id_marca = $ox_id_marca; // Restore original value ?> </span></td> <td><span> <?php echo $x_modelo; ?> </span></td> </tr> </table> <br> <?php } phpmkr_free_result($rs); } ?> <?php // Set up recordset $rs = phpmkr_query($sSql, $conn) or die("Falha ao executar consulta." . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql); $nTotalRecs = phpmkr_num_rows($rs); if ($nDisplayRecs <= 0) { // Display all records $nDisplayRecs = $nTotalRecs; } $nStartRec = 1; SetUpStartRec(); // Set up start record position ?> <p><span class="phpmaker">Sessão: LISTAGEM DE ANÚNCIOS</span></p> <form id="festoquelistsrch" name="festoquelistsrch" action="estoquelist.php" > <table class="ewBasicSearch"> <tr> <td><span class="phpmaker"> <input type="text" name="<?php echo ewTblBasicSrch; ?>" size="20" value="<?php echo $psearch;?>"> <input type="Submit" name="Submit" value="Busca (*)"> <input type="Button" name="Reset" value="Limpar" onclick="EW_clearForm(this.form);this.form.<?php echo ewTblBasicSrchType;?>[0].checked = true;"> <a href="estoquelist.php?cmd=reset">Mostrar todas</a> </span></td> </tr> <tr> <td><span class="phpmaker"><input type="radio" name="<?php echo ewTblBasicSrchType;?>" value="" <?php if ($psearchtype == "") { ?>checked<?php } ?>>frase exata <input type="radio" name="<?php echo ewTblBasicSrchType; ?>" value="AND" <?php if ($psearchtype == "AND") { ?>checked<?php } ?>>todas as palavras <input type="radio" name="<?php echo ewTblBasicSrchType; ?>" value="OR" <?php if ($psearchtype == "OR") { ?>checked<?php } ?>>qualquer palavra</span></td> </tr> </table> </form> <table class="ewListAdd"> <tr> <td><span class="phpmaker"><a href="estoqueadd.php"><img src='images/add.gif' alt='Adicionar' border='0'></a></span></td> </tr> </table> <p> <?php if (@$_SESSION[ewSessionMessage] <> "") { ?> <p><span class="ewmsg"><?php echo $_SESSION[ewSessionMessage]; ?></span></p> <?php $_SESSION[ewSessionMessage] = ""; // Clear message } ?> <?php if ($nTotalRecs > 0) { ?> <form method="post"> <table id="ewlistmain" class="ewTable"> <!-- Table header --> <tr class="ewTableHeader"> <td colspan="8" valign="top">cLIQUE NO TITULO DA COLUNA - PARA LISTAR EM ORDEM CRESCENTE OU DECRESCENTE ***CADA COLUNA***.</td> <td> </td> </tr> <tr class="ewTableHeader"> <td valign="top"><span> <a href="estoquelist.php?order=<?php echo urlencode("Id_estoque"); ?>"> Id<?php if (@$_SESSION[ewSessionTblSort . "_x_Id_estoque"] == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif (@$_SESSION[ewSessionTblSort . "_x_Id_estoque"] == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?> </a> </span></td> <td valign="top"><span> <a href="estoquelist.php?order=<?php echo urlencode("categoria"); ?>"> categoria<?php if (@$_SESSION[ewSessionTblSort . "_x_categoria"] == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif (@$_SESSION[ewSessionTblSort . "_x_categoria"] == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?> </a> </span></td> <td valign="top"><span> <a href="estoquelist.php?order=<?php echo urlencode("marcas"); ?>"> marcas<?php if (@$_SESSION[ewSessionTblSort . "_x_marcas"] == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif (@$_SESSION[ewSessionTblSort . "_x_marcas"] == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?> </a> </span></td> <td valign="top"><span> <a href="estoquelist.php?order=<?php echo urlencode("marca"); ?>"> modelo<?php if (@$_SESSION[ewSessionTblSort . "_x_marca"] == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif (@$_SESSION[ewSessionTblSort . "_x_marca"] == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?> </a> </span></td> <td valign="top"><span> <a href="estoquelist.php?order=<?php echo urlencode("exibir"); ?>"> exibir<?php if (@$_SESSION[ewSessionTblSort . "_x_exibir"] == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif (@$_SESSION[ewSessionTblSort . "_x_exibir"] == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?> </a> </span></td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <?php // Set the last record to display $nStopRec = $nStartRec + $nDisplayRecs - 1; // Move to the first record $nRecCount = $nStartRec - 1; if (phpmkr_num_rows($rs) > 0) { phpmkr_data_seek($rs, $nStartRec -1); } $nRecActual = 0; while (($row = @phpmkr_fetch_array($rs)) && ($nRecCount < $nStopRec)) { $nRecCount = $nRecCount + 1; if ($nRecCount >= $nStartRec) { $nRecActual++; // Set row color $sItemRowClass = " class=\"ewTableRow\""; $sListTrJs = " onmouseover='ew_mouseover(this);' onmouseout='ew_mouseout(this);' onclick='ew_click(this);'"; // Display alternate color for rows if ($nRecCount % 2 <> 1) { $sItemRowClass = " class=\"ewTableAltRow\""; } $x_Tipo = $row["Tipo"]; $x_anuncio = $row["anuncio"]; $x_Id_estoque = $row["Id_estoque"]; $x_id_plano = $row["id_plano"]; $x_data_cadastro = $row["data_cadastro"]; $x_data = $row["data"]; $x_id_membro = $row["id_membro"]; $x_categoria = $row["categoria"]; $x_marcas = $row["marcas"]; $x_marca = $row["marca"]; $x_ano = $row["ano"]; $x_ano2 = $row["ano2"]; $x_cor = $row["cor"]; $x_preco = $row["preço"]; $x_cidade = $row["cidade"]; $x_km = $row["km"]; $x_placa = $row["placa"]; $x_condicoes = $row["condicoes"]; $x_portas = $row["portas"]; $x_combustivel = $row["combustivel"]; $x_transmissao = $row["transmissao"]; $x_descricao = $row["descricao"]; $x_oferta = $row["oferta"]; $x_exibir = $row["exibir"]; $x_avisado = $row["avisado"]; $x_entrada = $row["entrada"]; $x_qtd_parcelas = $row["qtd_parcelas"]; $x_valor_parcelas = $row["valor_parcelas"]; $x_contato = $row["contato"]; $x_acessos = $row["acessos"]; ?> <!-- Table body --> <tr<?php echo $sItemRowClass; ?><?php echo $sListTrJs; ?>> <!-- anuncio --> <!-- Id_estoque --> <td><span> <?php echo $x_Id_estoque; ?> </span></td> <!-- id_plano --> <!-- data_cadastro --> <!-- data --> <!-- categoria --> <td><span> <?php if ((!is_null($x_categoria)) && ($x_categoria <> "")) { $sSqlWrk = "SELECT `categoria` FROM `categorias`"; $sTmp = $x_categoria; $sTmp = addslashes($sTmp); $sSqlWrk .= " WHERE `id` = " . $sTmp . ""; $rswrk = phpmkr_query($sSqlWrk,$conn) or die("Falha ao executar consulta." . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL:' . $sSqlWrk); if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) { $sTmp = $rowwrk["categoria"]; } @phpmkr_free_result($rswrk); } else { $sTmp = ""; } $ox_categoria = $x_categoria; // Backup original value $x_categoria = $sTmp; ?> <?php echo $x_categoria; ?> <?php $x_categoria = $ox_categoria; // Restore original value ?> </span></td> <!-- marcas --> <td><span> <?php if ((!is_null($x_marcas)) && ($x_marcas <> "")) { $sSqlWrk = "SELECT `marca` FROM `marca`"; $sTmp = $x_marcas; $sTmp = addslashes($sTmp); $sSqlWrk .= " WHERE `Id_marca` = " . $sTmp . ""; $rswrk = phpmkr_query($sSqlWrk,$conn) or die("Falha ao executar consulta." . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL:' . $sSqlWrk); if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) { $sTmp = $rowwrk["marca"]; } @phpmkr_free_result($rswrk); } else { $sTmp = ""; } $ox_marcas = $x_marcas; // Backup original value $x_marcas = $sTmp; ?> <?php echo $x_marcas; ?> <?php $x_marcas = $ox_marcas; // Restore original value ?> </span></td> <!-- marca --> <td><span> <?php if ((!is_null($x_marca)) && ($x_marca <> "")) { $sSqlWrk = "SELECT `modelo` FROM `modelo`"; $sTmp = $x_marca; $sTmp = addslashes($sTmp); $sSqlWrk .= " WHERE `id` = " . $sTmp . ""; $rswrk = phpmkr_query($sSqlWrk,$conn) or die("Falha ao executar consulta." . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL:' . $sSqlWrk); if ($rswrk && $rowwrk = phpmkr_fetch_array($rswrk)) { $sTmp = $rowwrk["modelo"]; } @phpmkr_free_result($rswrk); } else { $sTmp = ""; } $ox_marca = $x_marca; // Backup original value $x_marca = $sTmp; ?> <?php echo $x_marca; ?> <?php $x_marca = $ox_marca; // Restore original value ?> </span></td> <!-- exibir --> <td><span> <?php switch ($x_exibir) { case "Sim": $sTmp = "Sim"; break; case "Não": $sTmp = "Não"; break; default: $sTmp = ""; } $ox_exibir = $x_exibir; // Backup original value $x_exibir = $sTmp; ?> <?php echo $x_exibir; ?> <?php $x_exibir = $ox_exibir; // Restore original value ?> </span></td> <td><span class="phpmaker"><a href="<?php if ($x_Id_estoque <> "") {echo "estoqueedit.php?Id_estoque=" . urlencode($x_Id_estoque); } else { echo "java script:alert('Registro inválido! Chave nula');";} ?>"><img src='images/edit.gif' alt='Editar' border='0'></a></span></td> <td><span class="phpmaker"><a href="<?php if ($x_Id_estoque <> "") {echo "estoquedelete.php?Id_estoque=" . urlencode($x_Id_estoque); } else { echo "java script:alert('Registro inválido! Chave nula');";} ?>"><img src='images/excluir.gif' alt='Delete' border='0'></a></span></td> <td><span class="phpmaker"><a href="fotoslist.php?showmaster=1&id_estoque=<?php echo urlencode($x_Id_estoque); ?>">FOTOS </a></span></td> <td><span class="phpmaker"><a href="acessorios_carroslist.php?showmaster=1&id_estoque=<?php echo urlencode($x_Id_estoque); ?>">ACESS. </a></span></td> </tr> <?php } } ?> </table> </form> <?php } // Close recordset and connection phpmkr_free_result($rs); phpmkr_db_close($conn); ?> <form action="estoquelist.php" name="ewpagerform" id="ewpagerform"> <table> <tr> <td nowrap> <?php if ($nTotalRecs > 0) { $rsEof = ($nTotalRecs < ($nStartRec + $nDisplayRecs)); $PrevStart = $nStartRec - $nDisplayRecs; if ($PrevStart < 1) { $PrevStart = 1; } $NextStart = $nStartRec + $nDisplayRecs; if ($NextStart > $nTotalRecs) { $NextStart = $nStartRec ; } $LastStart = intval(($nTotalRecs-1)/$nDisplayRecs)*$nDisplayRecs+1; ?> <table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpmaker">Página </span></td> <!--first page button--> <?php if ($nStartRec == 1) { ?> <td><img src="images/firstdisab.gif" alt="Primeiro" width="16" height="16" border="0"></td> <?php } else { ?> <td><a href="estoquelist.php?start=1"><img src="images/first.gif" alt="Primeiro" width="16" height="16" border="0"></a></td> <?php } ?> <!--previous page button--> <?php if ($PrevStart == $nStartRec) { ?> <td><img src="images/prevdisab.gif" alt="Anterior" width="16" height="16" border="0"></td> <?php } else { ?> <td><a href="estoquelist.php?start=<?php echo $PrevStart; ?>"><img src="images/prev.gif" alt="Anterior" width="16" height="16" border="0"></a></td> <?php } ?> <!--current page number--> <td><input type="text" name="pageno" value="<?php echo intval(($nStartRec-1)/$nDisplayRecs+1); ?>" size="4"></td> <!--next page button--> <?php if ($NextStart == $nStartRec) { ?> <td><img src="images/nextdisab.gif" alt="Próximo" width="16" height="16" border="0"></td> <?php } else { ?> <td><a href="estoquelist.php?start=<?php echo $NextStart; ?>"><img src="images/next.gif" alt="Próximo" width="16" height="16" border="0"></a></td> <?php } ?> <!--last page button--> <?php if ($LastStart == $nStartRec) { ?> <td><img src="images/lastdisab.gif" alt="Último" width="16" height="16" border="0"></td> <?php } else { ?> <td><a href="estoquelist.php?start=<?php echo $LastStart; ?>"><img src="images/last.gif" alt="Último" width="16" height="16" border="0"></a></td> <?php } ?> <td><span class="phpmaker"> de <?php echo intval(($nTotalRecs-1)/$nDisplayRecs+1);?></span></td> </tr></table> <?php if ($nStartRec > $nTotalRecs) { $nStartRec = $nTotalRecs; } $nStopRec = $nStartRec + $nDisplayRecs - 1; $nRecCount = $nTotalRecs - 1; if ($rsEof) { $nRecCount = $nTotalRecs; } if ($nStopRec > $nRecCount) { $nStopRec = $nRecCount; } ?> <span class="phpmaker">Registros <?php echo $nStartRec; ?> a <?php echo $nStopRec; ?> de <?php echo $nTotalRecs; ?></span> <?php } else { ?> <?php if ($sSrchWhere == "0=101") { ?> <span class="phpmaker"></span> <?php } else { ?> <span class="phpmaker">Nenhum registro encontrado</span> <?php } ?> <?php } ?> </td> </tr> </table> </form> <?php include ("footer.php") ?> <?php //------------------------------------------------------------------------------- // Function SetUpMasterDetail // - Set up Master Detail criteria based on querystring parameter key_m // - Variables setup: sDbWhereMaster, Session("TblMasterkey"), sDbWhereDetail, Session(TblDetailWhere) function SetUpMasterDetail() { global $sDbWhereMaster; global $sDbWhereDetail; global $sKeyMaster; global $nStartRec; global $x_marca; // Get the keys for master table if (strlen(@$_GET[ewTblShowMaster]) > 0) { // Reset start record counter (new master key) $nStartRec = 1; $_SESSION[ewSessionTblStartRec] = $nStartRec; $sDbWhereMaster = ewSqlMasterFilter; $sDbWhereDetail = ewSqlDetailFilter; $x_marca = (get_magic_quotes_gpc()) ? stripslashes(@$_GET["marca"]) : @$_GET["marca"]; // Load parameter from QueryString if (is_numeric($x_marca)) { $sDbWhereMaster = str_replace("@marca", AdjustSql($x_marca), $sDbWhereMaster); // Replace key value $sDbWhereDetail = str_replace("@marca", AdjustSql($x_marca), $sDbWhereDetail); // Replace key value $_SESSION[ewSessionTblMasterKey . "_marca"] = $x_marca; // Save master key Value } else { $sDbWhereMaster = "0=1"; $sDbWhereDetail = "0=1"; } $_SESSION[ewSessionTblMasterWhere] = $sDbWhereMaster; $_SESSION[ewSessionTblDetailWhere] = $sDbWhereDetail; } else { $sDbWhereMaster = @$_SESSION[ewSessionTblMasterWhere]; $sDbWhereDetail = @$_SESSION[ewSessionTblDetailWhere]; } } //------------------------------------------------------------------------------- // Function BasicSearchSQL // - Build WHERE clause for a keyword function BasicSearchSQL($Keyword) { $sKeyword = (!get_magic_quotes_gpc()) ? addslashes($Keyword) : $Keyword; $BasicSearchSQL = ""; $BasicSearchSQL.= "`Tipo` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`anuncio` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`cor` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`preço` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`km` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`placa` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`condicoes` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`combustivel` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`transmissao` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`descricao` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`oferta` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`exibir` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`avisado` LIKE '%" . $sKeyword . "%' OR "; $BasicSearchSQL.= "`contato` LIKE '%" . $sKeyword . "%' OR "; if (substr($BasicSearchSQL, -4) == " OR ") { $BasicSearchSQL = substr($BasicSearchSQL, 0, strlen($BasicSearchSQL)-4); } return $BasicSearchSQL; } //------------------------------------------------------------------------------- // Function SetUpBasicSearch // - Set up Basic Search parameter based on form elements pSearch & pSearchType // - Variables setup: sSrchBasic function SetUpBasicSearch() { global $sSrchBasic, $psearch, $psearchtype; if ($psearch <> "") { if ($psearchtype <> "") { while (strpos($psearch, " ") != false) { $psearch = str_replace(" ", " ",$psearch); } $arKeyword = split(" ", trim($psearch)); foreach ($arKeyword as $sKeyword) { $sSrchBasic .= "(" . BasicSearchSQL($sKeyword) . ") " . $psearchtype . " "; } } else { $sSrchBasic = BasicSearchSQL($psearch); } } if (substr($sSrchBasic, -4) == " OR ") { $sSrchBasic = substr($sSrchBasic, 0, strlen($sSrchBasic)-4); } if (substr($sSrchBasic, -5) == " AND ") { $sSrchBasic = substr($sSrchBasic, 0, strlen($sSrchBasic)-5); } if ($psearch <> "") { $_SESSION[ewSessionTblBasicSrch] = $psearch; $_SESSION[ewSessionTblBasicSrchType] = $psearchtype; } } //------------------------------------------------------------------------------- // Function ResetSearch // - Clear all search parameters function ResetSearch() { // Clear search where $sSrchWhere = ""; $_SESSION[ewSessionTblSearchWhere] = $sSrchWhere; // Clear advanced search parameters $_SESSION[ewSessionTblAdvSrch . "_x_Tipo"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_anuncio"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_Id_estoque"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_id_plano"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_data_cadastro"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_data"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_id_membro"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_categoria"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_marcas"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_marca"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_ano"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_ano2"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_cor"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_preco"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_cidade"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_km"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_placa"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_condicoes"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_portas"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_combustivel"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_transmissao"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_descricao"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_oferta"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_exibir"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_avisado"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_entrada"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_qtd_parcelas"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_valor_parcelas"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_contato"] = ""; $_SESSION[ewSessionTblAdvSrch . "_x_acessos"] = ""; $_SESSION[ewSessionTblBasicSrch] = ""; $_SESSION[ewSessionTblBasicSrchType] = ""; } //------------------------------------------------------------------------------- // Function RestoreSearch // - Restore all search parameters // function RestoreSearch() { // Restore advanced search settings $GLOBALS["x_Tipo"] = @$_SESSION[ewSessionTblAdvSrch . "_x_Tipo"]; $GLOBALS["x_anuncio"] = @$_SESSION[ewSessionTblAdvSrch . "_x_anuncio"]; $GLOBALS["x_Id_estoque"] = @$_SESSION[ewSessionTblAdvSrch . "_x_Id_estoque"]; $GLOBALS["x_id_plano"] = @$_SESSION[ewSessionTblAdvSrch . "_x_id_plano"]; $GLOBALS["x_data_cadastro"] = @$_SESSION[ewSessionTblAdvSrch . "_x_data_cadastro"]; $GLOBALS["x_data"] = @$_SESSION[ewSessionTblAdvSrch . "_x_data"]; $GLOBALS["x_id_membro"] = @$_SESSION[ewSessionTblAdvSrch . "_x_id_membro"]; $GLOBALS["x_categoria"] = @$_SESSION[ewSessionTblAdvSrch . "_x_categoria"]; $GLOBALS["x_marcas"] = @$_SESSION[ewSessionTblAdvSrch . "_x_marcas"]; $GLOBALS["x_marca"] = @$_SESSION[ewSessionTblAdvSrch . "_x_marca"]; $GLOBALS["x_ano"] = @$_SESSION[ewSessionTblAdvSrch . "_x_ano"]; $GLOBALS["x_ano2"] = @$_SESSION[ewSessionTblAdvSrch . "_x_ano2"]; $GLOBALS["x_cor"] = @$_SESSION[ewSessionTblAdvSrch . "_x_cor"]; $GLOBALS["x_preco"] = @$_SESSION[ewSessionTblAdvSrch . "_x_preco"]; $GLOBALS["x_cidade"] = @$_SESSION[ewSessionTblAdvSrch . "_x_cidade"]; $GLOBALS["x_km"] = @$_SESSION[ewSessionTblAdvSrch . "_x_km"]; $GLOBALS["x_placa"] = @$_SESSION[ewSessionTblAdvSrch . "_x_placa"]; $GLOBALS["x_condicoes"] = @$_SESSION[ewSessionTblAdvSrch . "_x_condicoes"]; $GLOBALS["x_portas"] = @$_SESSION[ewSessionTblAdvSrch . "_x_portas"]; $GLOBALS["x_combustivel"] = @$_SESSION[ewSessionTblAdvSrch . "_x_combustivel"]; $GLOBALS["x_transmissao"] = @$_SESSION[ewSessionTblAdvSrch . "_x_transmissao"]; $GLOBALS["x_descricao"] = @$_SESSION[ewSessionTblAdvSrch . "_x_descricao"]; $GLOBALS["x_oferta"] = @$_SESSION[ewSessionTblAdvSrch . "_x_oferta"]; $GLOBALS["x_exibir"] = @$_SESSION[ewSessionTblAdvSrch . "_x_exibir"]; $GLOBALS["x_avisado"] = @$_SESSION[ewSessionTblAdvSrch . "_x_avisado"]; $GLOBALS["x_entrada"] = @$_SESSION[ewSessionTblAdvSrch . "_x_entrada"]; $GLOBALS["x_qtd_parcelas"] = @$_SESSION[ewSessionTblAdvSrch . "_x_qtd_parcelas"]; $GLOBALS["x_valor_parcelas"] = @$_SESSION[ewSessionTblAdvSrch . "_x_valor_parcelas"]; $GLOBALS["x_contato"] = @$_SESSION[ewSessionTblAdvSrch . "_x_contato"]; $GLOBALS["x_acessos"] = @$_SESSION[ewSessionTblAdvSrch . "_x_acessos"]; $GLOBALS["psearch"] = @$_SESSION[ewSessionTblBasicSrch]; $GLOBALS["psearchtype"] = @$_SESSION[ewSessionTblBasicSrchType]; } //------------------------------------------------------------------------------- // Function SetUpSortOrder // - Set up Sort parameters based on Sort Links clicked // - Variables setup: sOrderBy, Session(TblOrderBy), Session(Tbl_Field_Sort) function SetUpSortOrder() { global $sOrderBy; global $sDefaultOrderBy; // Check for an Order parameter if (strlen(@$_GET["order"]) > 0) { $sOrder = @$_GET["order"]; // Field `anuncio` if ($sOrder == "anuncio") { $sSortField = "`anuncio`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_anuncio"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_anuncio"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_anuncio"] <> "") { @$_SESSION[ewSessionTblSort . "_x_anuncio"] = ""; } } // Field `Id_estoque` if ($sOrder == "Id_estoque") { $sSortField = "`Id_estoque`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_Id_estoque"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_Id_estoque"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_Id_estoque"] <> "") { @$_SESSION[ewSessionTblSort . "_x_Id_estoque"] = ""; } } // Field `id_plano` if ($sOrder == "id_plano") { $sSortField = "`id_plano`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_id_plano"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_id_plano"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_id_plano"] <> "") { @$_SESSION[ewSessionTblSort . "_x_id_plano"] = ""; } } // Field `data_cadastro` if ($sOrder == "data_cadastro") { $sSortField = "`data_cadastro`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_data_cadastro"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_data_cadastro"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_data_cadastro"] <> "") { @$_SESSION[ewSessionTblSort . "_x_data_cadastro"] = ""; } } // Field `data` if ($sOrder == "data") { $sSortField = "`data`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_data"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_data"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_data"] <> "") { @$_SESSION[ewSessionTblSort . "_x_data"] = ""; } } // Field `categoria` if ($sOrder == "categoria") { $sSortField = "`categoria`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_categoria"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_categoria"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_categoria"] <> "") { @$_SESSION[ewSessionTblSort . "_x_categoria"] = ""; } } // Field `marcas` if ($sOrder == "marcas") { $sSortField = "`marcas`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_marcas"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_marcas"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_marcas"] <> "") { @$_SESSION[ewSessionTblSort . "_x_marcas"] = ""; } } // Field `marca` if ($sOrder == "marca") { $sSortField = "`marca`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_marca"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_marca"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_marca"] <> "") { @$_SESSION[ewSessionTblSort . "_x_marca"] = ""; } } // Field `exibir` if ($sOrder == "exibir") { $sSortField = "`exibir`"; $sLastSort = @$_SESSION[ewSessionTblSort . "_x_exibir"]; $sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC"; $_SESSION[ewSessionTblSort . "_x_exibir"] = $sThisSort; } else { if (@$_SESSION[ewSessionTblSort . "_x_exibir"] <> "") { @$_SESSION[ewSessionTblSort . "_x_exibir"] = ""; } } $_SESSION[ewSessionTblOrderBy] = $sSortField . " " . $sThisSort; $_SESSION[ewSessionTblStartRec] = 1; } $sOrderBy = @$_SESSION[ewSessionTblOrderBy]; if ($sOrderBy == "") { if (ewSqlOrderBy <> "" && ewSqlOrderBySessions <> "") { $sOrderBy = ewSqlOrderBy; @$_SESSION[ewSessionTblOrderBy] = $sOrderBy; $arOrderBy = explode(",", ewSqlOrderBySessions); for($i=0; $i<count($arOrderBy); $i+=2) { @$_SESSION[ewSessionTblSort . "_" . $arOrderBy[$i]] = $arOrderBy[$i+1]; } } } } //------------------------------------------------------------------------------- // Function SetUpStartRec //- Set up Starting Record parameters based on Pager Navigation // - Variables setup: nStartRec function SetUpStartRec() { // Check for a START parameter global $nStartRec; global $nDisplayRecs; global $nTotalRecs; if (strlen(@$_GET[ewTblStartRec]) > 0) { $nStartRec = @$_GET[ewTblStartRec]; $_SESSION[ewSessionTblStartRec] = $nStartRec; } elseif (strlen(@$_GET["pageno"]) > 0) { $nPageNo = @$_GET["pageno"]; if (is_numeric($nPageNo)) { $nStartRec = ($nPageNo-1)*$nDisplayRecs+1; if ($nStartRec <= 0) { $nStartRec = 1; } elseif ($nStartRec >= intval(($nTotalRecs-1)/$nDisplayRecs)*$nDisplayRecs+1) { $nStartRec = intval(($nTotalRecs-1)/$nDisplayRecs)*$nDisplayRecs+1; } $_SESSION[ewSessionTblStartRec] = $nStartRec; } else { $nStartRec = @$_SESSION[ewSessionTblStartRec]; } } else { $nStartRec = @$_SESSION[ewSessionTblStartRec]; } // Check if correct start record counter if (!(is_numeric($nStartRec)) || ($nStartRec == "")) { // Avoid invalid start record counter $nStartRec = 1; // Reset start record counter $_SESSION[ewSessionTblStartRec] = $nStartRec; } elseif ($nStartRec > $nTotalRecs) { // Avoid starting record > total records $nStartRec = intval(($nTotalRecs-1)/$nDisplayRecs)*$nDisplayRecs+1; // Point to last page first record $_SESSION[ewSessionTblStartRec] = $nStartRec; } } //------------------------------------------------------------------------------- // Function ResetCmd // - Clear list page parameters // - RESET: reset search parameters // - RESETALL: reset search & master/detail parameters // - RESETSORT: reset sort parameters function ResetCmd() { // Get Reset command if (strlen(@$_GET["cmd"]) > 0) { $sCmd = @$_GET["cmd"]; if (strtolower($sCmd) == "reset") { // Reset search criteria ResetSearch(); } elseif (strtolower($sCmd) == "resetall") { // Reset search criteria and session vars ResetSearch(); $_SESSION[ewSessionTblMasterWhere] = ""; // Clear master criteria $sDbWhereMaster = ""; $_SESSION[ewSessionTblDetailWhere] = ""; // Clear detail criteria $sDbWhereDetail = ""; $_SESSION[ewSessionTblMasterKey . "_marca"] = ""; // Clear master key value } elseif (strtolower($sCmd) == "resetsort") { // Reset sort criteria $sOrderBy = ""; $_SESSION[ewSessionTblOrderBy] = $sOrderBy; if (@$_SESSION[ewSessionTblSort . "_x_anuncio"] <> "") { $_SESSION[ewSessionTblSort . "_x_anuncio"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_Id_estoque"] <> "") { $_SESSION[ewSessionTblSort . "_x_Id_estoque"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_id_plano"] <> "") { $_SESSION[ewSessionTblSort . "_x_id_plano"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_data_cadastro"] <> "") { $_SESSION[ewSessionTblSort . "_x_data_cadastro"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_data"] <> "") { $_SESSION[ewSessionTblSort . "_x_data"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_categoria"] <> "") { $_SESSION[ewSessionTblSort . "_x_categoria"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_marcas"] <> "") { $_SESSION[ewSessionTblSort . "_x_marcas"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_marca"] <> "") { $_SESSION[ewSessionTblSort . "_x_marca"] = ""; } if (@$_SESSION[ewSessionTblSort . "_x_exibir"] <> "") { $_SESSION[ewSessionTblSort . "_x_exibir"] = ""; } } // Reset start position (Reset command) $nStartRec = 1; $_SESSION[ewSessionTblStartRec] = $nStartRec; } } ?>[/codebox]
