Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <br>
- <form action='' method='POST'>
- <center><div style="text-align: center;">Логин:<font color='red'></font></div><input type='text' name='id' class='editbox'><br></center>
- <center><input type='submit' value='Найти' name='test'></center>
- </form>
- <?php
- $myServer = "93.178.108.219";
- $myUser = "sa";
- $myPass = "ragezone";
- $myDB = "Account";
- //коннект к бд
- $dbhandle = mssql_connect($myServer, $myUser, $myPass)
- or die("Нет соединения с БД по IP: $myServer");
- //выбор бд
- $selected = mssql_select_db($myDB, $dbhandle)
- or die("Неверная база данных: $myDB");
- if(isset($_POST[test])){
- //Проверка пустных полей
- if(empty($_POST[id]) ){echo "<center><font color='red'><b>Есть пустые поля.</b></font> <br></center>"; $error='Yes';}
- //Регистрация если все хорошо
- if($error != 'Yes'){
- $query=("SELECT UserNum, ID, Login, AuthType, LastIP FROM dbo.cabal_auth_table where ID='$_POST[id]'");
- $result = mssql_query($query);
- echo'<table>';
- while ( $record = mssql_fetch_array($result) ){
- echo '<center><strong>UserNum:'.$record['UserNum'].'</strong><br>
- <strong>Логин:'.$record['ID'].'</strong><br>
- <strong>Онлайн:'. test1($record['Login']) .'</strong><br>
- <strong>Бан:'. test($record['AuthType']) . '</strong><br>
- <strong>IP:'.$record['LastIP'].'</strong><br></center>';
- };
- echo'</table>';
- echo "<form action='' method='POST'>
- <center><input type='submit' value='Забанить' name='ban'></center>
- </form>";
- echo "<form action='' method='POST'>
- <center><input type='submit' value='Разбанить' name='unban'></center>
- </form>";
- }
- }
- if(isset($_POST[ban])){
- mssql_query("UPDATE Account.dbo.cabal_auth_table SET AuthType='2' WHERE UserNum=".$record['UserNum']."");
- echo "<center><font color='green'><b>Забанен.</b></font><br></center>";
- }
- if(isset($_POST[unban])){
- mssql_query("UPDATE Account.dbo.cabal_auth_table SET AuthType='1' WHERE UserNum=".$record['UserNum']."");
- echo "<center><font color='green'><b>Разбанен.</b></font><br></center>";
- }
- function test($ban){
- switch($ban){
- case 1:
- $returnvar = 'Не забанен';
- break;
- case 2:
- $returnvar = 'Забанен';
- break;
- }
- return $returnvar;
- }
- function test1($online){
- switch($online){
- case 0:
- $returnvar = 'Оффлайн';
- break;
- case 1:
- $returnvar = 'Онлайн';
- break;
- }
- return $returnvar;
- }
- if(isset($_POST[send])){
- if($error != 'Yes'){
- mssql_query("Execute CabalCash.dbo.up_AddMyCashItemByItem '$_POST[UserNum]','0','1','$_POST[item]','$_POST[opt]','31'");
- echo "<center><font color='green'><b>Предмет отправлен.</b></font><br></center>";
- mssql_free_result($result);
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement