<div id="container">
    <div id="content">
		<div id="column1" class="column">
			<div class="habblet-container ">
				<div class="cbb clearfix darkred ">
<div id="contentTitleredSmall">Random Groups</div>
					<?php
						$color = 'E6E6E6';
						$q = mysql_query("SELECT * FROM groups WHERE badge != '' ORDER BY RAND()")or die(mysql_error());
						while($r = mysql_fetch_assoc($q)) {
							$color = $color != 'E6E6E6' ? 'E6E6E6' : 'FFFFFF';
							echo "<div style='padding:6px;background-color:#{$color}'>";
								echo "<table><tr>";
									echo "<td style='width:50px'><img src='{$_CONFIG['hotel']['url']}/habbo-imaging/badge/{$r["badge"]}.gif'></td>";
									echo "<td><a href='{url}/group/{$r['id']}'>" . $r['name'] . "</a><br/>" . $r['desc'] . "<td>";
								echo "</tr></table>";
							echo "</div>";

						}

					?>
				</div>
			</div>
		</div>

  		<div id="column2" class="column">

                        <div class="content">
			<div class="habblet-container ">
                                <div class="cbb settings">
                                    <div id="contentBoxaccountsettings">Group Badge Code Details</div>
                                    <div class="box-content">
                                        <div id="settingsNavigation">
										<b>Details about what badges can be added</b><br>
										Any normal badge from habbo works. Just enter the badge code, without the .gif at the end. If you want a custom badge added, contact Joe.</br><br>




                                            </ul>
                                        </div>
                                    </div>
									                                    </div>
																	                                    </div>


		<div id="column2" class="column">
			<div class="habblet-container ">
				<div class="cbb clearfix blue ">
<div id="contentTitleblueSmall">Create A Group</div>
					<div style='padding:5px;'>
						<?php
if(isset($_POST['submit']))
				{
   ##->Inserting values in database

   $cost = '2500'; // How much each group will cost

    // Grabbing the POST'ed figures
   $id = mysql_real_escape_string(stripslashes($_POST['id']));
   $name = mysql_real_escape_string(stripslashes($_POST['name']));
   $desc = mysql_real_escape_string(stripslashes($_POST['desc']));
   $badge = mysql_real_escape_string(stripslashes($_POST['badge']));
   $ownerid = $_SESSION['user']['id'];
   $created = mysql_real_escape_string(stripslashes($_POST['created']));
   $roomid = mysql_real_escape_string(stripslashes($_POST['roomid']));
   $group_id = mysql_num_rows(mysql_query("SELECT NULL FROM groups")) + 15;
   $group_memberships = mysql_num_rows(mysql_query("SELECT NULL FROM groupid")) + 15;
   $userCoins = "" . $_SESSION['user']['credits'] . "";

    // If users coins are below the group cost, we'll send the header as an error
    if($userCoins < $cost)
        {
            echo "<div class=\"rounded rounded-red\">Oh, snap! You do not have enough credits to create a group!</div>";
        }
        else {

        // Taking away the cost of group to the users account
        $coins = mysql_query("UPDATE `users` SET `credits` = credits - ". $cost ." WHERE username = '" . $_SESSION['user']['username'] . "'");

        // Inserting the values into database, we'll send the header as successful
		if (empty($_POST['name']) || empty($_POST['desc']) || empty($_POST['badge']))
					{
						echo "<div class=\"rounded rounded-red\">No way, something was missing. Please fill in all fields!</div>";
					}
					else
					{
         mysql_query("INSERT INTO groups (id,name,`desc`,badge,ownerid,created,roomid) VALUES ('".$group_id."', '".$name."', '".$desc."', '".$badge."', '".$ownerid."', '".$created."', '".$roomid."')") or die(mysql_error());
         mysql_query("INSERT INTO group_memberships (groupid,userid) VALUES ('".$group_id."', '".$ownerid."')") or die(mysql_error());
         $updateGroup = mysql_query("UPDATE user_stats SET groupid = '".$group_id."' WHERE id = '".$_SESSION['user']['id']."' LIMIT 1");
		 echo "<div class=\"rounded rounded-green\">You have successfully created a group!</div>";

            }
			}
				}
?>
				<form name="submit" method='post'>

							Name Of Your Group
							<input type="text" name="name" style="width: 95%" /><br/>

							Description Of Your Group
							<input type="text" name="desc" style="width: 95%" /><br/>


							Badge Code
							<input type="text" name="badge"style="width: 95%" /><br/>

          <input type="hidden" name="ownerid" value="{id}" style="width: 95%" />
						<input type="hidden" name="created" value="{username}" style="width: 95%" />
						Room
						<br/><select name="roomid">
															<?php
																$query = mysql_query("SELECT id, caption FROM rooms WHERE owner = '".$_SESSION['user']['username']."'");
																echo '<option selected="selected" value="0">Pick A Room:</option>';
																while($row = mysql_fetch_array($query)){
																	echo '<option value="' . $row['id'] . '">' . $row['caption'] . '</option>';
																}
															?>
														</select><br/>


							<input type="submit"  name="submit" class="submit" value="Submit">

						</form>
					</div>
				</div>
			</div>
			<div class="habblet-container ">
				<div class="cbb clearfix blue ">
<div id="contentTitlegreenSmall">My Groups</div>
					<div style='padding:5px;' align = "center">
					Click one of your groups to edit it!<br><br>
						<?php
							/*
								Simple My Groups script by Lewis
								htps://hostsavor.com/
							*/
							$mygroups = mysql_query("SELECT * FROM groups WHERE ownerid = '{$_SESSION['user']['id']}'");
							if (mysql_num_rows($mygroups) <= 0){
								echo 'You have no groups.';
							}
							else{
								while($mygroupq = mysql_fetch_array($mygroups)){
									echo '<a href = "' . $_CONFIG['hotel']['url'] . '/group/' . $mygroupq['id'] .'">' . $mygroupq['name'] . '</a><br><img src="' . $_CONFIG['hotel']['url'] . '/habbo-imaging/badge/' . $mygroupq["badge"] . '.gif"><br>';
								}
							}
						?>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>