Jump to content

Putting Guilds in my game

xNeox

By xNeox
in PHP Coding Help

 Share

Recommended Posts

xNeox Newbie

xNeox

Posted
Posted

OK so i am having a little trouble putting guilds in my game, everything shows up but when you go to create a new guild it say can not update player stats, but it shows up that the guild has been created in the top guild list, it just doesnt let you use it here is the script could someone tell me if they see a problem

 

<?php
require 'connect.php';
include 'header.php';
include 'headin.php';
?>
<script type="text/javascript">
function stats()
{
  var no=document.getElementById("Name")
  var option=no.options[no.selectedIndex].value
  var y="guild.php?stats=1&&guild="+option
  window.open(y,"_blank","toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width=400, height=500")
}

function redirect()
{
  window.location="./guild.php"
}
</script>
<?php
if(!isset($_COOKIE['member_id']))
  die('Not logged in, please <a href=login.php>login</a>');
$Player=$_COOKIE['member_id'];
$Option=$_POST['option'];
$Create=$_POST['create'];
$Join=$_POST['join'];
$Submit=$_POST['submit'];
$Tax=$_POST['tax'];
$Guild=$_GET['guild'];
$Deny=$_GET['deny'];
$Add=$_GET['add'];
$Stats=$_GET['stats'];
$Kick=$_GET['kick'];
$Kickname=$_GET['kickname'];
$Addname=$_GET['addname'];
$Abandon=$_POST['abandon'];
$Coleader=$_GET['coleader'];
if(isset($Abandon))
  $Option="Abandon";
if($Option=="")
  $Option=$_GET['option'];
if(isset($Option))
{
  if($Option=='Create a guild')
  {
  ?>
<p>It costs 1,000,000 gold to create a Guild.<br /><br /></p>
<form method="post" action="guild.php">
Name:<input class="text" type="text" name="name" />
<input class="button" name="create" type="submit" value="submit" />
</form>
  <?php
  }
  elseif($Option=='Join a guild')
  {
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "<select class=\"select\" name='Name' id='Name' length='20' id='blah'>";
    $Guild="SELECT * from Guilds order by ID asc";
    $Guild2=mysql_query($Guild) or die("Could not select Guilds");
    while ($Guild3=mysql_fetch_array($Guild2))
    {
      $Name=str_replace(" ","%20",$Guild3['Name']);
      print "<option value=\"$Name\">$Guild3[Name]</option>";
    }
    print "</select><br />";
    print "<input class=\"button\" type='Submit' name='join' value='Join' /> ";
    ?><input class=button type="button" onclick="stats()" value="Stats" /></form> <?php
  }
elseif($Option=='Raise your guilds tax')
  {
        $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    if($Guild['Tax']>90){
    mysql_query("UPDATE Guilds SET Tax='90' WHERE Name='$Name'");
    }
    if($Guild['Owner']==$User['Playername'] || $Guild['Coleader']==$User['Playername']){
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "Amount: <input type=text class=\"select\" name='tax' id='tax' length='3' id='tax'>";
    print "<br /><br>";
    print "<input class=\"button\" type='Submit' name='submit' value='Raise' /></form> ";
    
}else{
echo"You may not edit your Guild Tax, since you are not a leader or co-leader.";
exit;
}
  }
  elseif($Option=='Guild stats')
  {

    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Guild1="SELECT * from Guilds where Name='$User[Guild]'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    $Query="SELECT * from Users where Guild='$Guild[Name]' order by Level desc";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    if($Guild['Name']!="")
    {
      print "<table class=\"table\" align=\"center\"><tr><td>";
      $AttackPower=number_format(pow($Guild['AttackPower']+10, 5));
      $DefenceStance=number_format(pow($Guild['DefenceStance']+10, 5));
      $Agility=number_format(pow($Guild['Agility']+10, 5));
      $Gold=pow($Guild['Gold']+12,3)*4;
      $Gold=number_format($Gold);
      $Exp=pow($Guild['Exp']+9, 4)+500;
      $Exp=number_format($Exp);
      $Itemfind=number_format(pow($Guild['Itemfind']+10, 5));
      $Itemquality=number_format(pow($Guild['Itemquality']+10, 5));
      print "Guild Name: $Guild[Name]<br />Guild Owner: $Guild[Owner]<br />Guild Co-Owner: $Guild[Coleader]<br />Guild Bank: $Guild[bank]<br />Guild Tax: $Guild[Tax]%<br />Last Guild Battle: $Guild[LastFight]<br />Battles won: $Guild[Won]<br />Battles Lost: $Guild[Lost]<br />";
      
if($Guild['Owner']==$User['Playername'] || $Guild['Coleader']==$User['Playername'] || $User['Admin']==1){
echo "<form class=\"form\" method=\"post\" action=\"guildbonus.php\">";
      echo "Attack Power:".$Guild['AttackPower']."% <input class=\"button\" type='Submit' name='AttackPower' value='Increase' /> $AttackPower gold<br />";
      echo "Defence Stance:".$Guild['DefenceStance']."% <input class=\"button\" type='Submit' name='DefenceStance' value='Increase' /> $DefenceStance gold<br />";
      echo "Agility:".$Guild['Agility']."% <input class=\"button\" type='Submit' name='Agility' value='Increase' /> $Agility gold<br />";
      echo"Exp:".$Guild['Exp']."% <input class=\"button\" type='Submit' name='Exp' value='Increase' /> $Exp gold<br />";
      echo "Gold:".$Guild['Gold']."% <input class=\"button\" type='Submit' name='Gold' value='Increase' /> $Gold gold<br />";
      echo "Item Find:".$Guild['Itemfind']."% <input class=\"button\" type='Submit' name='Itemfind' value='Increase' /> $Itemfind gold<br />";      
      echo "Item Quality:".$Guild['Itemquality']."% <input class=\"button\" type='Submit' name='Itemquality' value='Increase' /> $Itemquality gold<br />";
}else{
echo "<form class=\"form\" method=\"post\" action=\"guildbonus.php\">";
      echo "Attack Power:".$Guild['AttackPower']."% <br />";
      echo "Defence Stance:".$Guild['DefenceStance']."% <br />";
      echo "Agility:".$Guild['Agility']."% <br />";
      echo "Experience".$Guild['Exp']."% <br />";
      echo "Gold:".$Guild['Gold']."% <br />";
      echo "Item Find:".$Guild['Itemfind']."% <br />";      
      echo "Item Quality:".$Guild['Itemquality']."% <br />";
}
      print "Donate:<input class=\"text\" type=\"text\" name=\"Amount\" value=\"$User[Gold]\" /><input class=\"button\" type='Submit' name='Donate' value='Donate' /></form><br />";
      if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
    print"<a href=\"attackguild.php\">Attack Other Guilds</a><br><br>";
    }
      if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1")
      {
        $Name=str_replace(" ","%20",$Guild['Name']);
        echo "<a href=\"guild.php?coleader=1&&Guild=$Name\">Assign coleader</a><br />";
      }
      print "</td></tr></table>";
    }
    else
      echo "You are not in a guild, below is a listing of all people not in a guild.";
    print "<table class=\"table\" align=\"right\"><tr><td>";
    print "<form class=\"form\" action='guild.php' method='post'>";
    print "<table><tr><td>";
    print "Members:<br />To kick a member out the guild must pay half of what the User has donated.<br><br><table id=\"table\"><tr><td>Player</td><td>Level</td><td>Donated</td>";
     if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
      print "<td>Kick</td>";
     }
    print "</tr>";
    while($topplayer3=mysql_fetch_array($Query2))
    {
      print "<tr><td>$topplayer3[Playername]</td><td>$topplayer3[Level]</td><td>$topplayer3[GuildDonate]</td>";
       if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1"){
      print "<td><a href=\"guild.php?kick=$topplayer3[iD]&&kickname=$Guild[iD]\">Kick</a></td>";
     }
      print "</tr>";
    }
    print "</table></form></td><td></td><td>";
    if($User['Playername']==$Guild['Owner']||$User['Playername']==$Guild['Coleader']||$Player=="1")
    {
      $Name = $Guild['Name'];
      $Guild['Name' ]= str_replace(" ","%20",$Guild['Name']);
      $Query = mysql_query("select * from Users where Applied='$Name'");
      print "Requests:<br /><table id=\"table\"><tr><td>Name</td><td>Level</td><td>Accept?</td><td>Deny?</td></tr>";
      while($joinee = mysql_fetch_array($Query))
      {
        echo "<tr><td>$joinee[Playername]</td>";
        echo "<td>$joinee[Level]</td>";
        echo "<td><a href=\"guild.php?add=$joinee[iD]&&addname=$Guild[Name]\">Accept</a></td><td><a href=\"guild.php?deny=$joinee[iD]\">Deny</a></td></tr>";
      }
      print "</table>";
      print "</td></tr></table>";
    }
    print "</td></tr></table><br />";
    
  }
  elseif($Option=='Leave guild')
  {
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    if($Guild['Owner']==$User['Playername'])
    {
      echo "Are you sure you want to abandon and delete your guild?";
      echo "<form action=\"guild.php\" method=\"post\"><input type=\"hidden\" value=\"$Guild[Name]\" name=\"Guild\" /><input class=\"button\" type=\"submit\" name=\"abandon\" value=\"yes\" /><input class=\"button\" type=\"button\" value=\"no\" onclick=\"redirect()\" /></form>";
    }
    else
    {
      mysql_query("UPDATE Users SET GuildDonate='0' WHERE ID='$Player'");
      mysql_query("Update Users set Guild='' where ID='$Player'") or die("Could not update player stats");
      mysql_query("update Guilds set Members=Members-'1' where Name='$Guild[Name]'") or die("Could not decrease number of members");
      print "You have left the guild.";
    }
  }
  elseif($Option=="Abandon")
  {
    $Guild=$_POST['Guild'];
    $Query="Select * from Users where Guild='$Guild'";
    $Query2=mysql_query($Query) or die("Zomg");
    while($User=mysql_fetch_array($Query2))
    {
      $ID=$User['ID'];
      $Update="Update Users set Guild='' where ID='$ID'";
      mysql_query($Update) or die("No clan update.");
    }
    $Query="Delete from Guilds where Name='$Guild'";
    mysql_query($Query) or die("Can't delete guild.");
    echo "Clan deleted.";
  }
}
elseif(isset($Kick))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Querty="SELECT * from Users where ID='$Kick'";
    $Querty2=mysql_query($Querty) or die("Could not get user stats");
    $Kicking=mysql_fetch_array($Querty2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    $KickAmount=$Kicking['GuildDonate']/2;
    
   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot kick users because you are not the leader or coleader of this guild!";
   exit;
   }
   elseif($Kicking['Playername']==$Guild['Owner']){
   echo"You may not kick out the creator of this guild!";
   exit;
   }
   elseif($KickAmount>$Guild['Bank']){
   echo"You do not have enough gold to kick this player out. To kick out a member you must be able to pay half of what they have donated.";
   exit;
   }
   else{
mysql_query("UPDATE Guilds SET Bank=Bank-'$KickAmount' WHERE ID='$Kickname'");
mysql_query("UPDATE Guilds SET Members=Members-'1' WHERE Name='$Guild[Name]'");
mysql_query("UPDATE Users SET Gold=Gold'$KickAmount' WHERE ID='$Kick'");
mysql_query("UPDATE Users SET GuildDonate='0' WHERE ID='$Kick'");
mysql_query("UPDATE Users SET Guild='' WHERE ID='$Kick'");
echo"Player kicked from your guild! <a href='guild.php'>Back</a>";
   }
}
elseif(isset($Submit))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

if($Tax<0 || $Tax>90){
echo"Do you want people leaving your guild?";
exit;
}else{
mysql_query("Update Guilds set Tax='$Tax' where Name='$Name'");
echo "Tax set to $Tax!";
}
}
elseif(isset($Create))
{
  if(isset($_POST['name']))
  {
    $Name=$_POST['name'];
    $Player=$_COOKIE['member_id'];
    $Query=mysql_query("select * from Users where ID='$Player'") or die("Could not query Users");
    $User=mysql_fetch_array($Query);
    $check="SELECT * from Guilds where Name='$Name'";
    $check2=mysql_query($check) or die("Could not query guilds");
    while($check3=mysql_fetch_array($check2))
    {
      $Clan=$check3['Name'];
    }
    if($Clan)
       print "Sorry there is already a guild of that name.";
    elseif($User['Guild'] != "")
      echo "You have to leave your clan before you can create your own.";
    elseif($User['Gold']>=1000000)
    {
      $Query="INSERT into Guilds(Name, Owner) VALUES ('$Name', '$User[Playername]')";
      mysql_query($Query) or die("could not create clan");
      $Update="Update Users set Guild='$Name', Applied='', Gold=Gold-'1000000' where ID='$Player'";
      mysql_query($Update) or die("Could not update player stats");
      print "Clan created.";
    }
    else
      print "You do not have enough gold.";
  }
}



elseif(isset($Join))
{
  if(isset($_POST['Name']))
  {
    $Name=$_POST['Name'];
    $Player=$_COOKIE['member_id'];
    $Name=str_replace("%20"," ",$Name);
    $Query=mysql_query("SELECT * FROM Guilds where Name='$Name'") or die("Could not fetch guild stats");
    $Guild=mysql_fetch_array($Query);
    $Query=mysql_query("Select * from Users where ID='$Player'");
    $User=mysql_fetch_array($Query);
    if($User['Guild'] != "")
      echo "Leave your other guild first before you join a new one.<br /><a href=\"guild.php\">Go back</a>";
    elseif($Guild[Members]==15){
    echo "Guild is full, sorry, go pick another. <a href=fight.php>Go</a>";
    }else
    {
      mysql_query("update Users set Applied='$Name' where ID='$Player'");
      if($Guild['Members'] >= 15)
        echo "You are accepted, but the guild is currently full. you may have to wait an extended amount of time before you are accepted.";
      else
        echo "You applied for the clan. Now wait until either the owner or the coleader accepts you.";
    }
  }
}
elseif(isset($Deny)){
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    
   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot deny users because you are not the leader or coleader of this guild!";
   exit;
   }else{
    $Update="Update Users set Applied='' where ID='$Deny'";
    mysql_query($Update) or die("Could not update player stats");
    print "Player denied.<br /><a href=\"guild.php\">Go back</a>";
   }

}
elseif(isset($Add))
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Name=$User['Guild'];
    $Guild1="SELECT * from Guilds where Name='$Name'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);
    
   if($User['Playername']!=$Guild['Owner'] AND $User['Playername']!=$Guild['Coleader'] AND $User['Admin']!=1){
   echo"You cannot add users because you are not the leader or coleader of this guild!";
   exit;
   }else{

  $Addname=str_replace("%20"," ",$Addname);
  $Query=mysql_query("SELECT * from Guilds where Name='$Addname'") or die("Could not get guild stats");
  $Guild=mysql_fetch_array($Query);
  if($Guild['Members'] <= 15)
  {
    $Query2=mysql_query("SELECT * FROM Users where ID='$Add'") or die("Could not get player stats");
    $User=mysql_fetch_array($Query2);
    mysql_query("Update Guilds set Members=Members+'1' where Name='$Addname'") or die("Could not update guilds");
    $Update="Update Users set Guild='$Addname', Applied='' where ID='$Add'";
    mysql_query($Update) or die("Could not update player stats");
    print "Player accepted.<br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
  }
  else
    print "Clan is full, cannot accept player.<br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
  }
}
elseif(isset($Guild))
{
  $Query="SELECT * from Guilds where Name='$Guild'";
  $Query2=mysql_query($Query) or die("Could not get guild stats");
  $Guild=mysql_fetch_array($Query2);
  $Query3="SELECT * from Users where Guild='$Guild[Name]'";
  $Query4=mysql_query($Query3) or die("Could not get user stats");
  print "Guild name: $Guild[Name]<br />Guild Owner: $Guild[Owner]<br />Clan bank: $Guild[bank]<br />";
  echo "Exp:".number_format($Guild['Exp'])."%<br />";
  echo "Gold:".number_format($Guild['Gold'])."%<br />";
  print "Members:<br /><table id=\"table\"><tr><td>Player</td><td>Level</td></tr>";
  while($topplayer3=mysql_fetch_array($Query4))
  {
    print "<tr><td>$topplayer3[Playername]</td><td>$topplayer3[Level]</td></tr>";
  }
  print "</table>";
}
elseif($Coleader==1)
{
  $Guild=str_replace("%20"," ",$_GET['Guild']);
  $Query="SELECT * from Users where Guild='$Guild' order by Level desc";
  $Query2=mysql_query($Query) or die("Could not get user stats");
  $Guild1="SELECT * from Guilds where Name='$Guild'";
  $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
  $Guild=mysql_fetch_array($Guild2);
  print "<table><tr><td>";
  print "Members:<br /><table id=\"table\"><tr><td>Player</td><td>Level</td></tr>";
  while($Member=mysql_fetch_array($Query2))
  {
    if($Member['Playername']!=$Guild['Owner'])
    {
      $Name=str_replace(" ","%20",$Member['Playername']);
      $Guild=str_replace(" ","%20",$_GET['Guild']);
      print "<tr><td><a href=\"guild.php?coleader=$Name&&Guild=$Guild\">$Member[Playername]<a></td><td>$Member[Level]</td></tr>";
    }
  }
  print "</table><br /><a href=\"guild.php?option=Guild%20stats\">Go back</a>";
}
elseif($Coleader)
{
  $Name=str_replace("%20"," ",$Coleader);
  $Guild=$_GET['Guild'];
  $Query="Update Guilds set Coleader='$Name' where Name='$Guild'";
  mysql_query($Query) or die("Could not set coleader.");
  echo "Coleader assigned. <a href=\"guild.php?option=Guild%20stats\">Go back</a>";
}
else
{
    $Query="SELECT * from Users where ID='$Player'";
    $Query2=mysql_query($Query) or die("Could not get user stats");
    $User=mysql_fetch_array($Query2);
    $Guild1="SELECT * from Guilds where Name='$User[Guild]'";
    $Guild2=mysql_query($Guild1) or die("Could not select Guilds");
    $Guild=mysql_fetch_array($Guild2);

print"<form method=\"post\" action=\"guild.php\">";
print"<select class=\"select\" name=\"option\">";

if($Guild['Name']!=""){

print"<option>Guild stats</option>";
print"<option>Raise your guilds tax</option>";
print"<option>Leave guild</option>";

}else{

print"<option>Create a guild</option>";
print"<option>Join a guild</option>";

}

print"</select>";
print"<input class=\"button\" type=\"submit\" value=\"submit\" name=\"guild\">";
print"</form>";
print"</body>";
}
?>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.