Искам да попитам как да изваждам потребителите от които са във клана
<?php
if($_SESSION['name']) {
$name = $_SESSION['name'];
echo "<h2 class='stranicamenu'>Клан<hr></h2>";
$sql = "SELECT * FROM users WHERE name = '$name'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['firm'] == NULL && $_GET['d'] == NULL) {
echo "<img src='images/stats/addgang.gif''><a href=?a=union&d=own>Основи Клан</a><br /><br />"
."<img src='images/stats/gang.gif''><a href=?a=union&d=join>Кандидатствай във Клана</a><br /><br />"
."<img src='images/union-rank.gif''><a href=?a=rankingunion>Класация на бандите</a><br />"; }
if($_GET['d'] == 'own' && $my['firm'] == NULL && $my['lvl'] > 2) {
echo "<table align=center><form action=?a=union&d=own method=post>"
."<tr><td colspan=2>Основи Клан</td></tr>"
."<tr><td>Име на Клана:</td><td><input type=text name=name></td></tr>"
."<tr><td clospan=2><input type=submit name=submit value=Основи></td></tr></form></table>";
if($_POST['name']) {
$sql1 = "SELECT * FROM users WHERE name = '$name'";
$do1 = mysql_query($sql1);
$my1= mysql_fetch_array($do1);
$fname = htmlspecialchars($_POST['name']);
$edit = "INSERT INTO firms (`name` , `boss`) VALUES ('$fname', '$name')";
$edit2 = "UPDATE users SET firm = '$fname' WHERE name = '$name'";
if(mysql_query($edit) && mysql_query($edit2)) { echo "Успешно основа Клана $fname."; }}}
elseif($_GET['d'] == 'own' && $my['lvl'] < 3){
echo "Трябва да имаш 3 ниво за да създадеш Клан!";}
if($_GET['d'] == 'join' && $my['firm'] == NULL) {
echo "<table align=center><form action='#' method=post>"
."<tr><td colspan=2>Кандидаствай в Клана.</td></tr>"
."<tr><td>Име на Клана:</td><td><input type=text name='name'></td></tr>"
."<tr><td clospan=2><input type=submit name=submit value=Кандидатствай></td></tr></form></table>";
if($_POST['submit']){
$fname = htmlspecialchars($_POST['name']);
if($fname!=''){
$edit = "INSERT INTO `invs` VALUES ('', '$name', '$fname')";
echo "Ти успешно кандидатства в Клана $fname";}
if(mysql_query($edit) && mysql_query($edit2)) { echo "Ти кандидатсваше във Клана $fname и те приеха!"; }}}
if($my['firm'] != NULL) {
$fname = $my['firm'];
$sql = "SELECT * FROM firms WHERE name = '$fname'";
$do = mysql_query($sql);
$firm = mysql_fetch_array($do);
if($firm['boss'] == $name && $_GET['d'] == NULL) {
$obshtpower = mysql_query("SELECT SUM(power) as obshto FROM users WHERE firm = '$fname'");
$obshtiqpower = mysql_fetch_array($obshtpower);
$obshtbiznesmen = mysql_query("SELECT SUM(busy) as biznes FROM users WHERE firm = '$fname'");
$obshtiqbiznesmen = mysql_fetch_array($obshtbiznesmen);
echo "Точки на Клана: ";
echo $obshtiqpower['obshto'];
echo "<br>Ниво на Клана: ";
echo $obshtiqbiznesmen['biznes'];
echo "<br>Ти си шеф на Клана $fname .<br /><br />";
echo "<img width='60' height='60' src='images/avatar/1.gif' alt='' />"
."<a href=?a=union&d=view><u>Виж кандидатите които търсят Клан.<u></a><br /><br />"
."<a href=?a=union&d=kick>Изгони играч.</a><br /><br />"
."<a href=?a=union&d=delete>Закрии Клана.</a>";
} else {
$obshtpower = mysql_query("SELECT SUM(power) as obshto FROM users WHERE firm = '$fname'");
$obshtiqpower = mysql_fetch_array($obshtpower);
$obshtbiznesmen = mysql_query("SELECT SUM(busy) as biznes FROM users WHERE firm = '$fname'");
$obshtiqbiznesmen = mysql_fetch_array($obshtbiznesmen);
echo "Респект на Клана: ";
echo $obshtiqpower['obshto'];
echo "<br>Ниво на Клана: ";
echo $obshtiqbiznesmen['biznes'];
echo "<br>Ти си в Клана $fname .<br />";
echo "Шеф на Клана е: ".$firm['boss']." <br /><br />"
."<a href=?a=union&d=quit&n=$fname>Напусни Клана.</a>";
}
if($_GET['d'] == 'view' && $firm['boss'] == $name) {
$query = "SELECT * FROM invs WHERE fname = '$fname'";
$result = mysql_query($query);
echo '<table align=center><tr><td><font color="#FFFFFF" face="arial"><u>Потребител</u></td><td><font color="#FFFFFF" face="arial"><u>Приеми</u></td></tr>';
while ($list = mysql_fetch_array($result)) {
echo '<tr><td><font color="#FFFFFF" face="arial">'.$list['name'].'</td>'
."<td><a href=?a=union&get=".$list['name']."><b>Да</b></a> <a href=?a=union&del=".$list['name']."><b>Не</b></a></td></tr>"; }
echo "</table>";}
if($_GET['d'] == 'kick' && $firm['boss'] == $name) {
$query = "SELECT * FROM users WHERE firm = '$fname'";
$result = mysql_query($query);
echo "<table border=1 width=450 align=center>";
echo '<tr><td><center>Потребител</td><td><center>Изгони</td></tr>';
while($row = mysql_fetch_array($result))
{
echo '<tr><td><center>'.$row['name'].'</td><td><center><a href=?a=union&kick='.$row['name'].'>Изгони</a></td></tr>';}
echo"</table>";}
if($_GET['d'] == 'delete' && $firm['boss'] == $name){
$update = "UPDATE users SET firm = '' WHERE firm = '$fname'";
$update1 = mysql_query($update);
$update2 = "DELETE FROM firms WHERE name = '$fname'";
$update3 = mysql_query($update2);
if($update3 && $update1){
echo "Клана е закрита успешно.";}
else {
echo "Нещо се обърка и Клана не беше закрита.";
}}
if($_GET['d'] == 'quit' && $firm['boss'] != $name){
$mysql = mysql_query("SELECT * FROM users WHERE name = '$name'");
$mysql1 = mysql_fetch_array($mysql);
if($_GET['n'] == $mysql1['firm']){
$mysql2 = mysql_query("UPDATE users SET firm = '' WHERE name = '$name'");
echo "<br />Успешно напуснахте Клана";}
else {
echo "Не успяхте да напуснете Клана";}
}
if($_GET['get'] && $firm['boss'] == $name) {
$get = htmlspecialchars($_GET['get']);
$query = "UPDATE users SET firm = '$fname' WHERE name = '$get'";
$deleteinv = mysql_query("DELETE FROM `invs` WHERE name = '$get' AND fname = '$fname'");
if(mysql_query($query)) { echo "<br>Успешно прие $get във Клана ти.";}}
if($_GET['del'] && $firm['boss'] == $name) {
$get = htmlspecialchars($_GET['del']);
$query = "DELETE FROM `invs` WHERE name = '$get' AND fname = '$fname'";
if(mysql_query($query)) { echo "<br>Отказа поканата на $get защото според теб няма нужните изисквания.";}}
if($_GET['kick'] && $firm['boss'] == $name) {
$get = htmlspecialchars($_GET['kick']);
if($get!=$name){
$query = "UPDATE users SET firm = '' WHERE name = '$get'";
if(mysql_query($query)){ echo "Успешно изгони $get от Клана ти.";}}}}}
<?php
if($_SESSION['name']) {
$name = $_SESSION['name'];
echo "<h2 class='stranicamenu'>Клан<hr></h2>";
$sql = "SELECT * FROM users WHERE name = '$name'";
$do = mysql_query($sql);
$my = mysql_fetch_array($do);
if($my['firm'] == NULL && $_GET['d'] == NULL) {
echo "<img src='images/stats/addgang.gif''><a href=?a=union&d=own>Основи Клан</a><br /><br />"
."<img src='images/stats/gang.gif''><a href=?a=union&d=join>Кандидатствай във Клана</a><br /><br />"
."<img src='images/union-rank.gif''><a href=?a=rankingunion>Класация на бандите</a><br />"; }
if($_GET['d'] == 'own' && $my['firm'] == NULL && $my['lvl'] > 2) {
echo "<table align=center><form action=?a=union&d=own method=post>"
."<tr><td colspan=2>Основи Клан</td></tr>"
."<tr><td>Име на Клана:</td><td><input type=text name=name></td></tr>"
."<tr><td clospan=2><input type=submit name=submit value=Основи></td></tr></form></table>";
if($_POST['name']) {
$sql1 = "SELECT * FROM users WHERE name = '$name'";
$do1 = mysql_query($sql1);
$my1= mysql_fetch_array($do1);
$fname = htmlspecialchars($_POST['name']);
$edit = "INSERT INTO firms (`name` , `boss`) VALUES ('$fname', '$name')";
$edit2 = "UPDATE users SET firm = '$fname' WHERE name = '$name'";
if(mysql_query($edit) && mysql_query($edit2)) { echo "Успешно основа Клана $fname."; }}}
elseif($_GET['d'] == 'own' && $my['lvl'] < 3){
echo "Трябва да имаш 3 ниво за да създадеш Клан!";}
if($_GET['d'] == 'join' && $my['firm'] == NULL) {
echo "<table align=center><form action='#' method=post>"
."<tr><td colspan=2>Кандидаствай в Клана.</td></tr>"
."<tr><td>Име на Клана:</td><td><input type=text name='name'></td></tr>"
."<tr><td clospan=2><input type=submit name=submit value=Кандидатствай></td></tr></form></table>";
if($_POST['submit']){
$fname = htmlspecialchars($_POST['name']);
if($fname!=''){
$edit = "INSERT INTO `invs` VALUES ('', '$name', '$fname')";
echo "Ти успешно кандидатства в Клана $fname";}
if(mysql_query($edit) && mysql_query($edit2)) { echo "Ти кандидатсваше във Клана $fname и те приеха!"; }}}
if($my['firm'] != NULL) {
$fname = $my['firm'];
$sql = "SELECT * FROM firms WHERE name = '$fname'";
$do = mysql_query($sql);
$firm = mysql_fetch_array($do);
if($firm['boss'] == $name && $_GET['d'] == NULL) {
$obshtpower = mysql_query("SELECT SUM(power) as obshto FROM users WHERE firm = '$fname'");
$obshtiqpower = mysql_fetch_array($obshtpower);
$obshtbiznesmen = mysql_query("SELECT SUM(busy) as biznes FROM users WHERE firm = '$fname'");
$obshtiqbiznesmen = mysql_fetch_array($obshtbiznesmen);
echo "Точки на Клана: ";
echo $obshtiqpower['obshto'];
echo "<br>Ниво на Клана: ";
echo $obshtiqbiznesmen['biznes'];
echo "<br>Ти си шеф на Клана $fname .<br /><br />";
echo "<img width='60' height='60' src='images/avatar/1.gif' alt='' />"
."<a href=?a=union&d=view><u>Виж кандидатите които търсят Клан.<u></a><br /><br />"
."<a href=?a=union&d=kick>Изгони играч.</a><br /><br />"
."<a href=?a=union&d=delete>Закрии Клана.</a>";
} else {
$obshtpower = mysql_query("SELECT SUM(power) as obshto FROM users WHERE firm = '$fname'");
$obshtiqpower = mysql_fetch_array($obshtpower);
$obshtbiznesmen = mysql_query("SELECT SUM(busy) as biznes FROM users WHERE firm = '$fname'");
$obshtiqbiznesmen = mysql_fetch_array($obshtbiznesmen);
echo "Респект на Клана: ";
echo $obshtiqpower['obshto'];
echo "<br>Ниво на Клана: ";
echo $obshtiqbiznesmen['biznes'];
echo "<br>Ти си в Клана $fname .<br />";
echo "Шеф на Клана е: ".$firm['boss']." <br /><br />"
."<a href=?a=union&d=quit&n=$fname>Напусни Клана.</a>";
}
if($_GET['d'] == 'view' && $firm['boss'] == $name) {
$query = "SELECT * FROM invs WHERE fname = '$fname'";
$result = mysql_query($query);
echo '<table align=center><tr><td><font color="#FFFFFF" face="arial"><u>Потребител</u></td><td><font color="#FFFFFF" face="arial"><u>Приеми</u></td></tr>';
while ($list = mysql_fetch_array($result)) {
echo '<tr><td><font color="#FFFFFF" face="arial">'.$list['name'].'</td>'
."<td><a href=?a=union&get=".$list['name']."><b>Да</b></a> <a href=?a=union&del=".$list['name']."><b>Не</b></a></td></tr>"; }
echo "</table>";}
if($_GET['d'] == 'kick' && $firm['boss'] == $name) {
$query = "SELECT * FROM users WHERE firm = '$fname'";
$result = mysql_query($query);
echo "<table border=1 width=450 align=center>";
echo '<tr><td><center>Потребител</td><td><center>Изгони</td></tr>';
while($row = mysql_fetch_array($result))
{
echo '<tr><td><center>'.$row['name'].'</td><td><center><a href=?a=union&kick='.$row['name'].'>Изгони</a></td></tr>';}
echo"</table>";}
if($_GET['d'] == 'delete' && $firm['boss'] == $name){
$update = "UPDATE users SET firm = '' WHERE firm = '$fname'";
$update1 = mysql_query($update);
$update2 = "DELETE FROM firms WHERE name = '$fname'";
$update3 = mysql_query($update2);
if($update3 && $update1){
echo "Клана е закрита успешно.";}
else {
echo "Нещо се обърка и Клана не беше закрита.";
}}
if($_GET['d'] == 'quit' && $firm['boss'] != $name){
$mysql = mysql_query("SELECT * FROM users WHERE name = '$name'");
$mysql1 = mysql_fetch_array($mysql);
if($_GET['n'] == $mysql1['firm']){
$mysql2 = mysql_query("UPDATE users SET firm = '' WHERE name = '$name'");
echo "<br />Успешно напуснахте Клана";}
else {
echo "Не успяхте да напуснете Клана";}
}
if($_GET['get'] && $firm['boss'] == $name) {
$get = htmlspecialchars($_GET['get']);
$query = "UPDATE users SET firm = '$fname' WHERE name = '$get'";
$deleteinv = mysql_query("DELETE FROM `invs` WHERE name = '$get' AND fname = '$fname'");
if(mysql_query($query)) { echo "<br>Успешно прие $get във Клана ти.";}}
if($_GET['del'] && $firm['boss'] == $name) {
$get = htmlspecialchars($_GET['del']);
$query = "DELETE FROM `invs` WHERE name = '$get' AND fname = '$fname'";
if(mysql_query($query)) { echo "<br>Отказа поканата на $get защото според теб няма нужните изисквания.";}}
if($_GET['kick'] && $firm['boss'] == $name) {
$get = htmlspecialchars($_GET['kick']);
if($get!=$name){
$query = "UPDATE users SET firm = '' WHERE name = '$get'";
if(mysql_query($query)){ echo "Успешно изгони $get от Клана ти.";}}}}}
