<?php
if(!check_login()) {
echo '<div class="blok">'.Fout("U bent nog niet ingelogd").'</div>';
}else{
?>
<? if ($data->mod != 2) { return; }?>
<?
$newspage = mysql_fetch_array(mysql_query("SELECT text_en, text_de, text_es, text_nl, text_pl FROM nieuws"));


if(isset($_POST['change'])){
	
	mysql_query("UPDATE nieuws SET text_en = '".$_POST['en']."', text_de = '".$_POST['de']."', text_es = '".$_POST['es']."', text_nl = '".$_POST['nl']."', text_pl = '".$_POST['pl']."'");
	
	echo '<div class="green"><img src="images/tick-circle.png" width="16" height="16" /> Succesvol nieuwspagina bewerkt!</div>';
	
	$newspage['text_en'] = $_POST['en'];
}


?>
<form method="post">
<center>
<br /><div class="titel" Colspan="4">Change Nieuws & Updates pagina</div><br /><br />
	<table width="600" cellpadding="0" cellspacing="0">
    	<tr>
            <td><textarea style="width:580px;" class="text_area" rows="15" name="en"><?php echo $newspage['text_en']; ?></textarea></td>
        </tr>
        <tr>
        	<td><div style="padding-top:10px;"><input type="submit" name="change" value="Change!" class="button" /></div></td>
        </tr>
    </table>        
</center>
</form>
<? 
}// CLOSE LOGIN CHECK
?>

<?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 */;