Файл: users/select.php
Строк: 127
<?php
/**
* @package JohnCMS
* @link http://johncms.com
* @copyright Copyright (C) 2008-2011 JohnCMS Community
* @license LICENSE.txt (see attached file)
* @version VERSION.txt (see attached file)
* @author http://johncms.com/about
*/
define('_IN_JOHNCMS', 1);
require('../incfiles/core.php');
require('../incfiles/head.php');
switch($act){
case 'country':
$total = db::result(db::query("SELECT * FROM `country`"), 0);
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('?act=country&', $start, $total, $kmess) . '</div>';
$sql = db::query("SELECT * FROM `country` LIMIT $start, $kmess");
while($country = mysqli_fetch_assoc($sql)) {
echo'<div class="menu1"><a href="?act=region&id='.$country['id'].'"><img src="/images/country/'.$country['id'].'.png" alt="*">'.functions::checkin($country['name']).'</a></div>';
}
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('?act=country&', $start, $total, $kmess) . '</div>';
echo '<div class="list1"><a href="/users/profile.php?act=edit">Редактировать анкету</a></div>';
break;
case 'region':
if($id!=NULL && db::result(db::query("SELECT * FROM `region` WHERE `id_country`=$id"), 0)!='0') {
$_SESSION['region']=$id;
$total = mysqli_num_rows(db::query("SELECT * FROM `region` WHERE `id_country`='$id'"));
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('?act=region&id='.$id.'&', $start, $total, $kmess) . '</div>';
$sql = db::query("SELECT * FROM `region` WHERE `id_country`=$id LIMIT $start, $kmess");
while($region = mysqli_fetch_assoc($sql)) {
echo'<div class="menu1"><a href="?act=city&id='.$region['id'].'">'.functions::checkin($region['name']).'</a></div>';
}
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('?act=region&id='.$id.'&', $start, $total, $kmess) . '</div>';
echo '<div class="list1"><a href="?act=country">Выбор страны</a><br /></div>';
}else{
header("Location: /users/profile.php?act=edit");
}
break;
case 'city':
if($id !=NULL && db::result(db::query("SELECT * FROM `city` WHERE `id_region`='$id'"),0)!='0') {
$_SESSION['city']=$id;
$total = mysqli_num_rows(db::query("SELECT * FROM `city` WHERE `id_region`=$id "));
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('?act=city&id='.$id.'&', $start, $total, $kmess) . '</div>';
$sql = db::query("SELECT * FROM `city` WHERE `id_region`='$id' LIMIT $start, $kmess ");
while($city = mysqli_fetch_assoc($sql)){
echo '<div class="menu1"><a href="?act=select&id='.$city['id'].'">'.functions::checkout($city['name']).'</a></div>';
}
if ($total > $kmess) echo '<div class="topmenu">' . functions::display_pagination('?act=city&id='.$id.'&', $start, $total, $kmess) . '</div>';
echo '<div class="list1">';
echo '<a href="?act=country">Выбор страны</a><br />';
echo '<a href="?act=region&id='.$_SESSION['region'].'">Выбор региона</a><br />';
echo '</div>';
}else{
header("Location: /users/profile.php?act=edit");
}
break;
case 'select':
if($id !=NULL && db::result(db::query("SELECT * FROM `city` WHERE `id`=$id "),0!=0)) {
$city = mysqli_fetch_assoc(db::query("SELECT * FROM `city` WHERE `id`=$id LIMIT 1"));
$country = mysqli_fetch_array(db::query("SELECT * FROM `country` WHERE `id`='".$city['id_country']."' LIMIT 1"));
$region = mysqli_fetch_array(db::query("SELECT * FROM `region` WHERE `id`= ".$city['id_region']." LIMIT 1"));
$city = mysqli_fetch_array(db::query("SELECT * FROM `city` WHERE `id`=".$city['id']." LIMIT 1"));
if(isset($_POST['save']) && isset($user_id)){
db::query("UPDATE `users` SET `city` = '".$city['name']."', `country` = '".$country['name']."', `region` = '".$region['name']."' WHERE `id` = '".$user_id ."'");
header("Location: /users/profile.php?act=edit");
}
echo '<div class="menu">
<form method="post" action="?act=select&id='.$id.'">
<font color="green">Ваша страна :</font> <b>'.$country['name'].'</b><br />
<font color="green">Ваш регион:</font> <b>'.$region['name'].'</b> <br />
<font color="green">Ваш город : </font><b>'.$city['name'].'</b><br />
<br /><input type="submit" name="save" value="Принять изменения" />
</form></div>';
}
break;
default:
header("Location: /users/profile.php?act=edit");
break;
}
require('../incfiles/end.php');