<?php
begintabel("Familie Mail");
  if(! ($data->clanlevel >= 8))
    exit;
  if ($data->clanmail == 0 && $data->clanconsig != 1 && $data->clanlevel != 9)
  	exit;
?>


<table width=100%>
<?php /* ------------------------- */{
    if(isset($_POST['message'])) {
      $dbres				= mysql_query("SELECT * FROM `[temp]` WHERE `id`='{$_POST['id']}' AND `code`='{$_POST['code']}' AND `area`='message'");
      if(($check = mysql_fetch_object($dbres)) && $check->IP == $clientIP) {
        $dbres				= mysql_query("SELECT `login` FROM `[users]` WHERE `Mobieltje`=1 AND `clan`='{$data->clan}'");
        while($member = mysql_fetch_object($dbres)) {
          $_POST['subject']		= preg_replace('/</','<',$_POST['subject']);
          $_POST['message']		= preg_replace('/</','<',$_POST['message']);


          mysql_query("INSERT INTO `[messages]`(`time`,`IP`,`from`,`to`,`subject`,`message`) values(NOW(),'{$_SERVER['REMOTE_ADDR']}','[CLAN]{$data->clan}','{$member->login}','{$_POST['subject']}','{$_POST['message']}')");
          mysql_query("DELETE FROM `[temp]` WHERE `id`='{$_POST['id']}' AND `code`='{$_POST['code']}' AND `area`='message'");
        }
      }
      print "  <tr><td class=\"mainTxt\">Familie Bericht verzonden</td></tr>\n";
    }


    $code				= rand(100000,999999);
    mysql_query("INSERT INTO `[temp]`(login,IP,code,area,time) values('{$data->login}','$clientIP','$code','message',NOW())");
    $id					= mysql_insert_id();


    print <<<ENDHTML
  <tr><td class="mainTxt">
	<form name="form1" method="POST" action="clan-mail.cg"><table>
	<input type="hidden" name="id" value="$id">
	<input type="hidden" name="code" value="$code">
	<tr><td width=100>Van:</td>		<td>[CLAN]{$data->clan}</td></tr>
	<tr><td width=100>Onderwerp:</td>	<td><input type="text" name="subject" value="{$_REQUEST['subject']}" maxlength=25></td></tr>
	<tr><td width=100 valign="top">Bericht:</td>
						<td><textarea name="message" cols=40 rows=10>{$_REQUEST['message']}</textarea></td></tr>
	<tr><td width=100></td>			<td align="right"><input type="submit" name="submit" value="Verzenden"></td></tr>
  </td></tr>
</table>
ENDHTML;
  }
   
/* ------------------------- */ ?>
</table>
<?php
eindetabel();
?>

-- phpMyAdmin SQL Dump
-- version 3.5.0
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 23 apr 2012 om 21:35
-- Serverversie: 5.1.60-log
-- PHP-Versie: 5.2.17


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";




/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


--
-- Databank: `stijnqg59_pkmo`
--


-- --------------------------------------------------------


--
-- Tabelstructuur voor tabel `clans`
--


CREATE TABLE IF NOT EXISTS `clans` (
  `clan_id` int(3) NOT NULL,
  `clan_naam` varchar(255) NOT NULL,
  `clan_owner` varchar(255) NOT NULL,
  `clan_ownerid` int(10) NOT NULL,
  `clan_spelersaantal` varchar(255) NOT NULL,
  `clan_members` varchar(255) NOT NULL,
  `clan_beschrijving` varchar(255) NOT NULL,
  `clan_type` varchar(255) NOT NULL,
  `clan_level` int(2) NOT NULL,
  `clan_gold` bigint(10) NOT NULL,
  `clan_silver` bigint(10) NOT NULL,
  `clan_winkel` bigint(10) NOT NULL,
  PRIMARY KEY (`clan_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;


--
-- Gegevens worden uitgevoerd voor tabel `clans`
--


INSERT INTO `clans` (`clan_id`, `clan_naam`, `clan_owner`, `clan_ownerid`, `clan_spelersaantal`, `clan_members`, `clan_beschrijving`, `clan_type`, `clan_level`, `clan_gold`, `clan_silver`, `clan_winkel`) VALUES
(1, 'AreaLegendZz', 'Goldworthy', 10653, '1', '159633', 'Scripters Clan', 'flying', 1, 200, 2750, 0),
(9, 'Victory', 'Skyress', 10667, '1', '21324', 'De Victory van Victini', 'dragon', 1, 0, 0, 0),
(3, 'superdarkkyurem', 'dragonm', 10635, '2', '53414', 'iedereen mag zich aan melden', 'dragon', 2, 0, 1000, 0),
(5, 'AreaCrew', 'Jarik7', 11723, '4', '44879', 'Iedereen is welkom, join!', 'fire', 1, 20, 0, 0),
(6, 'Pokemon0Legendes', 'jrm1998', 10658, '14', '398782', 'Voor echte area spelers', 'metal', 3, 5, 212207, 0),
(8, 'water', 'bayar14', 10775, '5', '54497', 'voor de coolste leden', 'water', 2, 115, 7185, 0),
(7, 'Admins', 'Admin', 10637, '1', '10637', 'Dit is een clan enkel voor de admins!', 'dragon', 1, 0, 0, 0);


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;