<div class="h1">Просмотр пользователей</div>
<?
if($_POST["likes"]){
$uid = intval($_POST["id"]);
$likes = intval($_POST["likes"]);
$money = intval($_POST["money"]);
$refs = intval($_POST["refs"]);
$num = mysql_num_rows(mysql_query("SELECT id FROM tb_members WHERE uid = '".$uid."'"));
if($num>0){
mysql_query("UPDATE tb_members SET likes = '$likes', money = '$money', refs = '$refs', ban = '".$_POST["ban"]."' WHERE uid = '".$uid."'");
?>
<div class='w_ok'><div class='wmsg'>Готово</div></div>
<?
}
}
if($_POST["uid"]){
$uid = intval($_POST["uid"]);
$likes = intval($_POST["likes"]);
$money = intval($_POST["money"]);
$refs= intval($_POST["refs"]);
$num = mysql_num_rows(mysql_query("SELECT id FROM tb_members WHERE uid = '".$uid."'"));
if($num>0){
$row = mysql_fetch_array(mysql_query("SELECT * FROM tb_members WHERE uid = '".$uid."'"));
?>
<form method="post" action="">
<strong>Данные:</strong> <?=$row['name'];?> <?=$row['lastname'];?><br>
<strong>UID:</strong> <?=$row['uid'];?><input type="hidden" name="id" value="<?=$row['uid'];?>"><br>
<strong>Лайки:</strong> <input type="text" name="likes" value="<?=$row['likes'];?>"><br>
<strong>Деньги:</strong> <input type="text" name="money" value="<?=$row['money'];?>"><br>
<strong>Рефералов:</strong> <input type="text" name="refs" value="<?=$row['refs'];?>"><br>
<strong>Бан:</strong><select name="ban"><option value="0" <? if($row["ban"]==0){?>selected="selected"<? }?> >Не забанен</option><option value="1" <? if($row["ban"]==1){?>selected="selected"<? }?> >Забанен</option></select><br>
<input type="submit" value="Сохранить">
</form>
<?
}else{
?>
<div class='w_warning'><div class='wmsg'>Юзер не найден</div></div>
<?
}
}?>
<form method="post" action="">
Введите числовой VKontakte ID: <input type="text" name="uid" class="inpu">
<input type="submit" value="Поиск" class="inp"><br>
</form>

<?
if(isset($_POST["id"]))
{
	$id=$_POST["lastname"];
	$data=$_POST["name"];
	$newstext=$_POST["newstext"];

	mysql_query("UPDATE tb_members SET name='$name', lastname='$lastname', uid='$uid', refs='$refs', likes='$likes', likes='$money' where id='$id'");

	echo "";
}

if(isset($_GET["id"]))
{
	$id=$_GET["id"];
	if ($_GET["option"]=="edit")
	{
		$tablae = mysql_query("SELECT * FROM tb_members likes='$likes, name='$name, lastname='$lastname, where id='$id'"); 
		while ($registroe = mysql_fetch_array($tablae))
		{ 
			?>
<?= $registroe["name"] ?> <?= $registroe["lastname"] ?></br>
			<form method="post">
				Дата новости: <input type="text" name="likes" value="<?= $registroe["likes"] ?>"<br>
				Текст новости:<br><textarea rows="20" cols="100" name="newstext"><?= $registroe["newstext"] ?></textarea><br>
				<input type="hidden" value="<?=$id ?>" name="id">
				<input type="submit" value="сохранить" class="button">
			</form>
			<?
		}
	}
	if ($_GET["option"]=="delete")
	{
		$id=$_GET["id"];
		mysql_query("DELETE FROM tb_news WHERE id='$id'");

		echo "<div class='w_ok'><div class='wmsg'>Новость удалена.</div></div>";
	}
}
?>
<table class="table" width="100%" cellspacing="0" cellpadding="0"><tbody>
	<tr class="tab">
		<td>№</td>
		<td>Пользователь</td>
		<td>Лайков</td>
		<td>Рефералов</td>
		<td>Денег</td>
	</tr>
	<?

	$sql="SELECT * FROM tb_members order by id desc";

	$tabla = mysql_query($sql); 
	while ($registro = mysql_fetch_array($tabla))
	{
		?>
		<tr>
			<td><?=$registro["id"] ?></td>
			<td><a href="http://vk.com/id<?=$registro["uid"] ?>" target="_blank"><?=$registro["name"] ?> <?=$registro["lastname"] ?></a> (<?=$registro["uid"] ?>)</td>
			<td><?=$registro["likes"] ?></td>
                        <td><?=$registro["refs"] ?></td>
                         <td><?=$registro["money"] ?></td>
			
		</tr>
		<?
	} 
	?></tbody>
</table>