public function listarResponsavel($id_aluno, $cod_situacao = 1)
{
$query = "\n SELECT\n pessoa.id_pessoa,\n pessoa.id_escola,\n pessoa.id_turma,\n pessoa.tipo,\n pessoa.data_inclusao,\n pessoa.ultima_alteracao,\n pessoa.nome,\n pessoa.data_nascimento,\n pessoa.genero,\n pessoa.cpf_cnpj,\n pessoa.valor_mensalidade,\n pessoa.telefone1,\n pessoa.telefone2,\n pessoa.telefone3,\n pessoa.telefone4,\n pessoa.email1,\n pessoa.email2,\n pessoa.email3,\n pessoa.email4,\n pessoa.endereco,\n pessoa.complemento,\n pessoa.bairro,\n pessoa.cidade,\n pessoa.uf,\n pessoa.cod_situacao\n FROM pessoa\n INNER JOIN aluno_responsavel ON aluno_responsavel.id_responsavel = pessoa.id_pessoa\n WHERE aluno_responsavel.id_aluno = '" . do_escape($id_aluno) . "'\n AND pessoa.cod_situacao = '" . do_escape($cod_situacao) . "'\n ";
$pessoas = array();
$result = get_result_db($query);
while ($pessoa = get_object($result)) {
$pessoas[] = $this->atualizar($pessoa);
}
free_result($result);
return $pessoas;
}
function populate_select($table, $fields_id, $fields_value, $selected)
{
$conn = db_connect(HOST, USER, PASS, DB, PORT);
$sql = "Select {$fields_id},{$fields_value} From {$table} Order By {$fields_value}";
$results = mkr_query($sql, $conn);
while ($row = fetch_object($results)) {
$SelectedCountry = $row->{$fields_id} == $selected ? " selected" : "";
echo "<option value=" . $row->{$fields_id} . $SelectedCountry . ">" . $row->{$fields_value} . "</option>";
//($row->$fields_id==$selected) ? 'selected' : '';
}
free_result($results);
}
public function listar($cod_situacao = null)
{
$query = $this->query() . "\n WHERE usuario.id_escola = '" . do_escape(ID_ESCOLA) . "'\n ";
if (!is_null($cod_situacao)) {
$query .= " AND usuario.cod_situacao = '" . do_escape($cod_situacao) . "' ";
}
$query .= " ORDER BY usuario.nome ";
$usuarios = array();
$result = get_result_db($query);
while ($usuario = get_object($result)) {
$usuarios[] = $this->atualizar($usuario);
}
free_result($result);
return $usuarios;
}
session_start();
error_reporting(E_ALL & ~E_NOTICE);
include_once "login_check.inc.php";
include_once "queryfunctions.php";
include_once "functions.php";
access("reservation");
//check if user is allowed to access this page
$conn = db_connect(HOST, USER, PASS, DB, PORT);
if (isset($_GET["search"]) && !empty($_GET["search"])) {
find($_GET["search"]);
}
if (isset($_POST['Navigate'])) {
//echo $_SESSION["strOffSet"];
$nRecords = num_rows(mkr_query("select * from guests", $conn), $conn);
paginate($nRecords);
free_result($results);
find($_SESSION["strOffSet"]);
}
$guestid = $_POST['guestid'];
if (isset($_POST['Submit'])) {
$action = $_POST['Submit'];
switch ($action) {
case 'Guest Reservation':
//if guest has not been selected exit
// instantiate form validator object
$fv = new formValidator();
//from functions.php
if (empty($_POST["guestid"])) {
//if no guest has been selected no point in displaying other errors
$fv->validateEmpty('guestid', 'No guest has been selected for reservation.');
} else {
echo "<tr><td><a href=\"admin.php\">Admin</a></td></tr>";
}
if ($access->guest == 1) {
echo "<tr><td><a href=\"guests.php\">Guests</a></td></tr>";
}
if ($access->reservation == 1) {
echo "<tr><td><a href=\"reservations.php\">Reservations</a></td></tr>";
}
if ($access->booking == 1) {
echo "<tr><td><a href=\"bookings.php\">Bookings</a></td></tr>";
}
if ($access->agents == 1) {
echo "<tr><td><a href=\"agents.php\">Agents</a></td></tr>";
}
if ($access->rooms == 1) {
echo "<tr><td><a href=\"rooms.php\">Rooms</a></td></tr>";
}
if ($access->billing == 1) {
echo "<tr><td><a href=\"billings.php\">Guest Bill</a></td></tr>";
}
if ($access->rates == 1) {
echo "<tr><td><a href=\"rates.php\">Rates</a></td></tr>";
}
if ($access->lookup == 1) {
echo "<tr><td><a href=\"lookup.php\">Lookups</a></td></tr>";
}
if ($access->reports == 1) {
echo "<tr><td><a href=\"reports.php\">Reports</a></td></tr>";
}
free_result($access);
<td><?php
echo $html['date'];
?>
</td>
<td><?php
echo $html['state'];
?>
</td>
<td><input type="checkbox" name="ids[]" value="<?php
echo $html['id'];
?>
"></td>
</tr>
<?php
}
free_result($result);
?>
<tr><td colspan="5" ><label for="all"><input id="all" name="checkall" type="checkbox" />全选</label><input type="submit" name="submit" value="删除选中私信"></td></tr>
</tbody>
</table>
</form>
<?php
//pager参数：t表示文本式分页，n表数字分页
pager('t');
?>
</div>
</div>
<script src="js/message.js"></script>
<?php
require ROOT_PATH . 'includes/footer.inc.php';
?>
function execute($sql)
{
global $db;
if (!$db->multi_query($sql)) {
echo "\nsql execute failure\n-----------------\n{$sql}\n------------\n";
printf("Error - SQLSTATE %d: %s.\n", $db->errno, $db->error);
echo "!!!!!!!!!!!!!!!!!!!\n";
die('error occur, exited.');
}
free_result();
}
/**
*This function is getting data from database<br>
*@note global variables <i>sql</i>,<i>con</i> to set the result.<br>
*display result to web page.<br>
*Generate HTML output directly for use in web page.<br>
*/
function getdata()
{
global $sql, $conn;
$results = mkr_query($sql, $conn);
/*$totRows = mysql_query("SELECT FOUND_ROWS()"); //get total number of records in the select query irrespective of the LIMIT clause
$totRows = mysql_result($totRows , 0);
$_SESSION["nRecords"]=$totRows;
$_SESSION["totPages"]=ceil($totRows/$strRows);
$_SESSION["RowsDisplayed"]=$strRows;*/
echo "<table align=\"center\">";
//get field names to create the column header
echo "<tr bgcolor=\"#009999\">\n\t\t<th>Action</th>";
while ($i < mysql_num_fields($results)) {
$meta = mysql_fetch_field($results, $i);
$field = $meta->name;
echo "<th>" . $field . "</th>";
$i++;
}
"</tr>";
//end of field header
if ((int) $results !== 0) {
//get data from selected table on the selected fields
while ($row = fetch_object($results)) {
//alternate row colour
$j++;
if ($j % 2 == 1) {
echo "<tr id=\"row{$j}\" onmouseover=\"javascript:setColor('{$j}')\" onmouseout=\"javascript:origColor('{$j}')\" bgcolor=\"#CCCCCC\">";
} else {
echo "<tr id=\"row{$j}\" onmouseover=\"javascript:setColor('{$j}')\" onmouseout=\"javascript:origColor('{$j}')\" bgcolor=\"#EEEEF8\">";
}
echo "<td><a href=\"reportqueries.php?search={$row->ID}\"><img src=\"images/button_view.png\" width=\"16\" height=\"16\" border=\"0\" title=\"view\"/></a></td>";
$i = 0;
while ($i < mysql_num_fields($results)) {
$meta = mysql_fetch_field($results, $i);
$field = $meta->name;
echo "<td>" . $row->{$field} . "</td>";
$i++;
}
//
echo "</tr>";
//end of - data rows
}
//end of while row
echo "</table>";
}
free_result($results);
}
public function listar($id_usuario, $cod_situacao = 1)
{
$query = $this->query();
$query .= " \n WHERE id_usuario = '" . do_escape($id_usuario) . "'\n AND cod_situacao = '" . do_escape($cod_situacao) . "'\n ";
$personagens = array();
$result = get_result_db($query);
while ($personagem = get_object($result)) {
$personagens[] = $this->atualizar($personagem);
}
free_result($result);
return $personagens;
}
public static function listarItem($id_jogador = null)
{
$query = static::query();
if (!is_null($id_jogador)) {
$query .= " WHERE id_jogador = " . do_escape($id_jogador) . " ";
}
$query .= " ORDER BY nome";
$itens = array();
$result = get_result_db($query);
while ($row = get_object($result)) {
$itens[] = static::carregarDB($row);
}
free_result($result);
return $itens;
}
public static function listar($limit = 0)
{
$query = static::query();
$query .= "\n WHERE (\n sessao.id_mestre = '" . do_escape(ID_JOGADOR) . "' OR\n " . do_escape(ID_JOGADOR) . " IN (\n SELECT personagem.id_jogador\n FROM personagem\n WHERE personagem.id_sessao = sessao.id_sessao\n )\n )\n AND sessao.cod_situacao IN (" . SESSAO_ATIVA . "," . SESSAO_PAUSA . ")\n ORDER BY sessao.ultimo_turno DESC\n ";
if ($limit > 0) {
$query .= " LIMIT " . do_escape($limit);
}
$sessoes = array();
$result = get_result_db($query);
while ($dados = get_object($result)) {
$sessao = new Sessao();
static::carregar($sessao, $dados);
$sessoes[] = $sessao;
}
free_result($result);
return $sessoes;
}
public function gerarXML()
{
$xml = new XMLWriter();
$xml->openMemory();
$xml->setIndent(true);
$xml->startDocument('1.0', 'UTF-8');
$xml->startElement("urlset");
$xml->writeAttribute('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9');
$url = "http://{$_SERVER['HTTP_HOST']}";
$xml->startElement("url");
$xml->writeElement('loc', 'http://bibliaemdebate.com.br');
//$xml->writeElement('lastmod', date('Y-m-d') );
$xml->writeElement('changefreq', 'daily');
$xml->writeElement('priority', '0.5');
$xml->endElement();
//url
$query = "\n SELECT DISTINCT\n livros.liv_tes_id AS 'id_testamento',\n versiculos.ver_liv_id AS 'id_livro',\n versiculos.ver_capitulo AS 'id_capitulo'\n FROM versiculos\n INNER JOIN livros ON livros.liv_id = versiculos.ver_liv_id\n AND versiculos.ver_vrs_id = 3\n ORDER BY\n livros.liv_tes_id,\n versiculos.ver_liv_id,\n versiculos.ver_capitulo\n ";
$result = get_result_db($query);
while ($versiculo = get_object($result)) {
$url = 'http://bibliaemdebate.com.br/nvi/';
if ($versiculo->id_testamento == NOVO_TESTAMENTO) {
$url .= 'nt';
} elseif ($versiculo->id_testamento == ANTIGO_TESTAMENTO) {
$url .= 'at';
}
$url .= "/{$versiculo->id_livro}/{$versiculo->id_capitulo}";
$xml->startElement("url");
$xml->writeElement('loc', $url);
//$xml->writeElement('lastmod', substr($imovel->ultima_alteracao, 0, 10) );
$xml->writeElement('changefreq', 'yearly');
$xml->writeElement('priority', '1.0');
$xml->endElement();
//url
}
free_result($result);
$xml->endElement();
//urlset
$xml->endDocument();
//echo $xml->outputMemory(TRUE);
return $xml;
}
echo $htmluser['email'];
?>
</a></li>
<li>网址：<a href="<?php
echo $htmluser['url'];
?>
" title=""><?php
echo $htmluser['url'];
?>
</a></li>
</ul>
</figcaption>
</figure>
<?php
}
free_result($result_newuser);
?>
</section>
</aside>
</div>
<div id="message" class="hide">
<h2 class="ddd"><span id="tips">发送消息给：</span><span id="friend"></span></h2>
<form class="form-horizontal" method="post" name="message" id="mform" action="blog.php?action=message">
<div class="form-groups">
<label class="form-labels" for="" >私信内容：</label>
<div class="controls">
<input type="hidden" name="touser">
<textarea name="content" id="" cols="30" rows="10" maxlength="200"></textarea>
</div>
</div>
public function listar($id_personagem)
{
$query = $this->query() . "\n WHERE id_personagem = '" . do_escape($id_personagem) . "'\n AND cod_situacao = '" . do_escape(QUEST_ATIVA) . "'\n ";
$quests = array();
$result = get_result_db($query);
while ($quest = get_object($result)) {
if (array_key_exists($quest->id_tipo, $GLOBALS['_quest'])) {
$this->carregar($quest);
$quests[] = $quest;
}
}
free_result($result);
return $quests;
}
