Beiträge von The Sensei

<form class="form-horizontal" method='POST'>
<?
$sql = "SELECT * FROM `accounts` WHERE ( ip ) IN ( SELECT ip FROM `accounts` GROUP BY ip HAVING COUNT(ip) > 1 ) ORDER BY ip ASC" ;
$result = mysql_query($sql);
while( $row = mysql_fetch_assoc($result) )
{
if($row['banned'] == 0)
{
?><tr><td><? echo $row["name"]; ?></td><td><? echo $row["ip"]; ?></td><td><button type="submit" name="sbtban" id="sbtban" class="btn btn-link"><span class="glyphicon glyphicon-lock" aria-hidden="true"></span></button></td><td><? echo $row["login"]; ?></td></tr><? 
}
else
{
?><tr><td><? echo $row["name"]; ?></td><td><? echo $row["ip"]; ?></td><td>Gesperrt von <? echo $row['banadmin']; ?> Grund: <? echo $row['banreason']; ?></td><td><? echo $row["login"]; ?></td></tr><? 
}
} ?>
</form>

<?


	$sbtban = $_POST['sbtban'];
	$sbtip = $_POST['sbtip'];
	$admin = $_SESSION['name'];
	$ip = $row['ip'];
	$timestamp = time();
	$datum = date("d.m.Y - H:i:s", $timestamp);
	if($sbtban)
	{
		$sql = "UPDATE `accounts` SET `banned`='1',`banadmin`='$admin',`bangrund`='Multiaccount',`bandatum`='$datum' WHERE `ip`='$ip'";
		$result = mysql_query($sql) or die("Ungültige Abfrage: ".mysql_error());
		?><meta http-equiv="Refresh" content="1;http://www.cp.ryan-service.de/multiacc.php"><?
	}


?>

$rank = array(
		$_POST['rank0'],
		$_POST['rank1'],
		$_POST['rank2'],
		$_POST['rank3'],
		$_POST['rank4'],
		$_POST['rank5'],
		$_POST['rank6'],
		$_POST['rank7']
	);
	for($i=0; $i<sizeof($rank); $i++){
		$sql = "DELETE FROM `frank` WHERE `fid`='$fid'";
		$result = mysql_query($sql);
		$sql = "INSERT INTO `frank`(`fid`, `frank`, `frankname`) VALUES ('$fid',$i,'$rank[$i]')";
		$result = mysql_query($sql);
	}

<?php
	include("config.php");
	session_start();
	$fid = $_SESSION['fraktion'];
	$rank = $_SESSION['rank'];
	for($i=1; $i<8; $i++){
		$rankend = $rank.$i;
		$query = "SELECT * FROM `frank` WHERE `fid`='$fid' AND `$rankend`='$rank'";
	}
	$check = mysql_query($query) or die("Ungültige Abfrage: ".mysql_error());
	$row = mysql_fetch_assoc($check);
	$num_rows = mysql_num_rows($check);
	$frank = $row['frank'];
	$frankname = $row['$rankend'];

	if($num_rows > 0)
	{
		$_SESSION['frank'] = $frank;
		$_SESSION['frankname'] = $frankname;
	}
?>

<div class="col-md-4">
<div class="panel panel-default">
<div class="panel-heading"><span class="glyphicon glyphicon-wrench" aria-hidden="true"> Ranknamen bearbeiten</span></div>
<div class="panel-body">
<form class="form-inline" action="checkranksettings.php" method="POST">
<div class="form-group">
<label for="Rank1">Rank 1:</label>
<input type="text" class="form-control" name="rank1" id="rank1" placeholder="bsp. Rank1">
</div>
<div class="form-group">
<label for="Rank2">Rank 2:</label>
<input type="text" class="form-control" name="rank2" id="rank2" placeholder="bsp. Rank2">
</div>
<div class="form-group">
<label for="Rank1">Rank 3:</label>
<input type="text" class="form-control" name="rank3" id="rank3" placeholder="bsp. Rank3">
</div>
<div class="form-group">
<label for="Rank2">Rank 4:</label>
<input type="text" class="form-control" name="rank4" id="rank4" placeholder="bsp. Rank4">
</div>
<div class="form-group">
<label for="Rank1">Rank 5:</label>
<input type="text" class="form-control" name="rank5" id="rank5" placeholder="bsp. Rank5">
</div>
<div class="form-group">
<label for="Rank2">Rank 6:</label>
<input type="text" class="form-control" name="rank6" id="rank6" placeholder="bsp. Rank6">
</div>
<div class="form-group">
<label for="Rank1">Rank 7:</label>
<input type="text" class="form-control" name="rank7" id="rank7" placeholder="bsp. Rank7">
</div>
<br >
<button type="submit" id="Absenden" class="btn btn-default">Absenden</button>
</form>
</div>
</div>
</div>
<div class="col-md-4">
<div class="panel panel-default">
<div class="panel-heading"><span class="glyphicon glyphicon-list-alt" aria-hidden="true"> Aktuelle Ranknamen</span></div>
<div class="panel-body">
<table class="table">
<thead>
<tr>
<th>Rank</th>
<th>Rankname</th>
</tr>
</thead>
<?
$fraktion = $_SESSION['fraktion'];
$sql = "SELECT * FROM `frank` WHERE `fid`='$fraktion'" ;
$result = mysql_query($sql) ;
while( $row = mysql_fetch_assoc($result) )
{
?><tr><td><? echo $row["frank"]; ?></td><td><? echo $row["fname"]; ?></td><?
} ?>
</table>
</div>
</div>
</div>

<?php
	include("config.php");
	session_start();
	$rank1 = $_POST['rank1'];
	$rank2 = $_POST['rank2'];
	$rank3 = $_POST['rank3'];
	$rank4 = $_POST['rank4'];
	$rank5 = $_POST['rank5'];
	$rank6 = $_POST['rank6'];
	$rank7 = $_POST['rank7'];
	for($i=1; $i<8; $i++){
		$rankend = $rank.$i;
		$query = "UPDATE frank SET fname = '$rankend' WHERE frank = '$i'";
		mysql_query($query) or die("Fehler im Query.");
	}
?>

<?php
	include("config.php");
	session_start();
	$rank1 = $_POST['rank1'];
	$rank2 = $_POST['rank2'];
	$rank3 = $_POST['rank3'];
	$rank4 = $_POST['rank4'];
	$rank5 = $_POST['rank5'];
	$rank6 = $_POST['rank6'];
	$rank7 = $_POST['rank7'];
	$query = "UPDATE frank SET ";
	$check = mysql_query($query) or die("Ungültige Abfrage: ".mysql_error()); 
	$row = mysql_fetch_assoc($check);
?>