<?php
if(!defined("IN_MYBB"))
{
	die("Direct initialization of this file is not allowed.<br /><br />Please make sure IN_MYBB is defined.");
}

$page->add_breadcrumb_item("Inplaytracker - Administration", "index.php?module=tools-inplaytracker");

// Inaktive Szenen seit x Tagen finden
if(!$mybb->input['action'])
{
	// Zeit-Filter erstelen
	$time = TIME_NOW;
	$time = date("d.m.Y", $time);
	$days = $mybb->get_input('days');
	if(empty($days)) {
		$days = 30;
	}

	// Szenen auslesen
	$ipforum = $mybb->settings['inplaytracker_forum'];
	$filter = strtotime("$time - $days days");
	$query = $db->query("SELECT * FROM ".TABLE_PREFIX."threads
	LEFT JOIN ".TABLE_PREFIX."forums ON ".TABLE_PREFIX."threads.fid = ".TABLE_PREFIX."forums.fid
	WHERE parentlist LIKE '%$ipforum%'
	AND ".TABLE_PREFIX."threads.lastpost < '$filter'
	ORDER BY ".TABLE_PREFIX."threads.lastpost ASC");

	// Navigation erstellen
	$page->output_header("Inplaytracker Administration");

	$sub_tabs['inplaytracker'] = array(
		'title' => "Inaktive Szenen",
		'link' => "index.php?module=tools-inplaytracker",
		'description' => "Finde Szenen die seit $days Tagen inaktiv sind."
	);

	$sub_tabs['inplaytracker_deleted'] = array(
		'title' => "Szenen mit inaktiven Mitgliedern",
		'link' => "index.php?module=tools-inplaytracker&action=find-deleted",
		'description' => "Finde Szenen mit inaktiven Charakteren."
	);

	$sub_tabs['inplaytracker_update'] = array(
		'title' => "Plugin updaten",
		'link' => "index.php?module=tools-inplaytracker&action=update",
		'description' => "Inplaytracker auf die neueste Version updaten."
	);

	$page->output_nav_tabs($sub_tabs, 'inplaytracker');

	// Formular & Tabelle generieren
	$form = new Form("index.php?module=tools-inplaytracker", "post");
	$form_container = new FormContainer("Inaktive Szenen");

	$form_container->output_row_header("Filter");
	$form_container->output_row_header("Suchen");

	$html_filters = "
		<div align=\"center\">
			<label for='sdate'>Inaktiv seit wie vielen Tagen? </label><br />
			<input type='text' name='days' id='days' value='{$days}' style='text-align:center;'/>
		</div>
	";
	$form_container->output_cell($html_filters);
	$form_container->output_cell("<center>".$form->generate_submit_button("Szenen suchen", array("name" => "filter_scenes"))."</center>");

	$form_container->construct_row();
	$form_container->end();

	// Szenen auflisten
	$form_container = new FormContainer(Szenen);
	$i = 0;
	while($scenes = $db->fetch_array($query)) {
		$parentlist = ",".$scenes['parentlist'].",";
		if(preg_match("/,$ipforum,/i", $parentlist)) {
			$form_container->output_cell("<a href=\"{$mybb->settings['bburl']}/showthread.php?tid={$scenes['tid']}\" target=\"blank\">{$scenes['subject']}</a>");
			$form_container->construct_row();
			$i++;
		}
	}
	// Keine inaktiven Szenen?
	if($i == 0) {
		$form_container->output_cell("Keine inaktiven Szenen gefunden!");
		$form_container->construct_row();
	}
	$form_container->end();
	$form->end();
	$page->output_footer();
}

// Szenen mit inaktiven Charakteren finden
if($mybb->input['action'] == "find-deleted")
{

	// Navigation erstellen
	$page->output_header("Inplaytracker Administration");

	$sub_tabs['inplaytracker'] = array(
		'title' => "Inaktive Szenen",
		'link' => "index.php?module=tools-inplaytracker",
		'description' => "Finde Szenen die seit $days Tagen inaktiv sind."
	);

	$sub_tabs['inplaytracker_deleted'] = array(
		'title' => "Szenen mit inaktiven Mitgliedern",
		'link' => "index.php?module=tools-inplaytracker&action=find-deleted",
		'description' => "Finde Szenen mit inaktiven Charakteren."
	);

	$sub_tabs['inplaytracker_update'] = array(
		'title' => "Plugin updaten",
		'link' => "index.php?module=tools-inplaytracker&action=update",
		'description' => "Inplaytracker auf die neueste Version updaten."
	);

	$page->output_nav_tabs($sub_tabs, 'inplaytracker_deleted');

	// Formular & Tabelle generieren
	$form = new Form("index.php?module=tools-inplaytracker&action=find-deleted", "post");
	$form_container = new FormContainer("Szenen mit inaktiven Mitgliedern");

	$form_container = new FormContainer(Szenen);
	$i = 0;
	// Szenen auslesen
	$ipforum = $mybb->settings['inplaytracker_forum'];
	$query = $db->query("SELECT * FROM ".TABLE_PREFIX."threads
	LEFT JOIN ".TABLE_PREFIX."forums ON ".TABLE_PREFIX."threads.fid = ".TABLE_PREFIX."forums.fid
	WHERE parentlist LIKE '%$ipforum%'
	ORDER BY tid ASC");
	// Szenen auflisten
	while($scenes = $db->fetch_array($query)) {
		$parentlist = ",".$scenes['parentlist'].",";
		if(preg_match("/,$ipforum,/i", $parentlist)) {
			$partners = explode(",", $scenes['partners']);
			foreach($partners as $partner) {
				$user = get_user($partner);
				if(empty($user)) {
					$form_container->output_cell("<a href=\"{$mybb->settings['bburl']}/showthread.php?tid={$scenes['tid']}\" target=\"blank\">{$scenes['subject']}</a>");
					$form_container->construct_row();
					$i++;
				}
			}
		}
	}
	// Keine inaktiven Szenen?
	if($i == 0) {
		$form_container->output_cell("Keine Szenen gefunden!");
		$form_container->construct_row();
	}
	$form_container->end();
	$form->end();
	$page->output_footer();
}

// Inplaytracker updaten
if($mybb->input['action'] == "update")
{

	if($mybb->request_method == "post") {
		// Datenbank aktualisieren
		if(isset($mybb->input['update_database'])) {
			if(!$db->field_exists("iport", "threads"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."threads` ADD `iport` VARCHAR(155) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `ipdate`;");
			}
			if(!$db->field_exists("iport", "posts"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."posts` ADD `iport` VARCHAR(155) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `ipdate`;");
			}
			if(!$db->field_exists("ipdaytime", "threads"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."threads` ADD `ipdaytime` VARCHAR(155) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `iport`;");
			}
			if(!$db->field_exists("ipdaytime", "posts"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."posts` ADD `ipdaytime` VARCHAR(155) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `iport`;");
			}
			if(!$db->field_exists("openscene", "threads"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."threads` ADD `openscene` int(11) NOT NULL DEFAULT '-1';");
			}
			if(!$db->field_exists("openscene", "posts"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."posts` ADD `openscene` int(11) NOT NULL DEFAULT '-1';");
			}
			if(!$db->field_exists("postorder", "threads"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."threads` ADD `postorder` int(11) NOT NULL DEFAULT '1';");
			}
			if(!$db->field_exists("postorder", "posts"))
			{
				$db->query("ALTER TABLE `".TABLE_PREFIX."posts` ADD `postorder` int(11) NOT NULL DEFAULT '1';");
			}
		}

		// ACP Einstellungen aktualisieren
		if(isset($mybb->input['update_settings'])) {
			$gid = $db->fetch_field($db->query("SELECT gid FROM ".TABLE_PREFIX."settinggroups WHERE name = 'inplaytracker'"), "gid");
			$setting_array =
				array(
					'inplaytracker_location' => array(
					'title' => 'Ort-Feld hinzufügen?',
					'description' => 'Sollen User ein Feld ausfüllen können, in dem siie zusätzlich den Spielort angeben können?',
					'optionscode' => 'yesno',
					'value' => 1,
					'disporder' => 3
				),
					'inplaytracker_daytime' => array(
					'title' => 'Tageszeit-Feld hinzufügen?',
					'description' => 'Sollen User ein Feld ausfüllen können, in dem siie zusätzlich die Tageszeit angeben können?',
					'optionscode' => 'yesno',
					'value' => 0,
					'disporder' => 4
				),
					'inplaytracker_timeformat' => array(
					'title' => 'Eigene Zeitrechnung nutzen?',
					'description' => 'Soll das Plugin eine Zeitrechnung abseits vom gregorianischen Kalender nutzen (auch ankreuzen, wenn euer Forum vor 1970 oder nach 2038 spielt!)?',
					'optionscode' => 'yesno',
					'value' => 0,
					'disporder' => 5
				),
					'inplaytracker_months' => array(
						'title' => 'Monatsnamen',
						'description' => '<b>Nur bei eigener Zeitrechnung:</b> Welche Monate sollen in deinem Forum auswählbar sein? Besonders interessant für Fantasy- und/oder Fandomforen!',
						'optionscode' => 'text',
						'value' => 'Januar, Februar, März, April, Mai, Juni, Juli, August, September, Oktober, November, Dezember',
						'disporder' => 6
				),
			);

			foreach($setting_array as $name => $setting)
			{
				$setting['name'] = $name;
				$setting['gid'] = $gid;
				$db->insert_query('settings', $setting);
			}

			rebuild_settings();
		}

		// Datenbankspalte partners aktualisieren
		if(isset($mybb->input['update_partner'])) {
			// Szenen auslesen
			$ipforum = $mybb->settings['inplaytracker_forum'];
			$query = $db->query("SELECT * FROM ".TABLE_PREFIX."threads
			WHERE partners != ''");
			while($scenes = $db->fetch_array($query)) {
				$partners = explode(", ", $scenes['partners']);
				$partners_new = array();
				foreach($partners as $partner) {
					$partner = $db->escape_string($partner);
					$user_id = $db->fetch_field($db->query("SELECT uid FROM ".TABLE_PREFIX."users WHERE username = '$partner'"), "uid");
					$partners_new[] = $user_id;
				}
				$partners_new = implode(",", $partners_new);
				$new_record = array(
					"partners" => $partners_new
				);
				$db->update_query("threads", $new_record, "tid = '$scenes[tid]'");
			}
		}

		// Datenbankspalte ipdate aktualisieren
		if(isset($mybb->input['update_date'])) {
			$ipforum = $mybb->settings['inplaytracker_forum'];
			$query = $db->query("SELECT * FROM ".TABLE_PREFIX."threads
			WHERE ipdate != ''");
			while($scenes = $db->fetch_array($query)) {
				$ipdate = explode(" ", $scenes['ipdate']);
				$months = array(
					"january" => "Januar",
					"february" => "Februar",
					"march" => "März",
					"april" => "April",
					"may" => "Mai",
					"june" => "Juni",
					"july" => "Juli",
					"august" => "August",
					"september" => "September",
					"october" => "Oktober",
					"november" => "November",
					"december" => "Dezember"
				);
				$ipdate['1'] = array_search($ipdate['1'], $months);
				$ipdate = implode(" ", $ipdate);
				$ipdate = strtotime($ipdate);
				$new_record = array(
					"ipdate" => $ipdate
				);
				$db->update_query("threads", $new_record, "tid = '$scenes[tid]'");
			}
		}

		if(isset($mybb->input['update_alerts'])) {
			if(class_exists('MybbStuff_MyAlerts_AlertTypeManager')) {
				$alertTypeManager = MybbStuff_MyAlerts_AlertTypeManager::getInstance();

				if (!$alertTypeManager) {
					$alertTypeManager = MybbStuff_MyAlerts_AlertTypeManager::createInstance($db, $cache);
				}

				$alertType = new MybbStuff_MyAlerts_Entity_AlertType();
				$alertType->setCode('inplaytracker_newthread'); // The codename for your alert type. Can be any unique string.
				$alertType->setEnabled(true);
				$alertType->setCanBeUserDisabled(true);

				$alertTypeManager->add($alertType);

				$alertType = new MybbStuff_MyAlerts_Entity_AlertType();
				$alertType->setCode('inplaytracker_newreply'); // The codename for your alert type. Can be any unique string.
				$alertType->setEnabled(true);
				$alertType->setCanBeUserDisabled(true);

				$alertTypeManager->add($alertType);
			}
		}
	}

	// Navigation erstellen
	$page->output_header("Inplaytracker Administration");

	$sub_tabs['inplaytracker'] = array(
		'title' => "Inaktive Szenen",
		'link' => "index.php?module=tools-inplaytracker",
		'description' => "Finde Szenen die seit $days Tagen inaktiv sind."
	);

	$sub_tabs['inplaytracker_deleted'] = array(
		'title' => "Szenen mit inaktiven Mitgliedern",
		'link' => "index.php?module=tools-inplaytracker&action=find-deleted",
		'description' => "Finde Szenen mit inaktiven Charakteren."
	);

	$sub_tabs['inplaytracker_update'] = array(
		'title' => "Plugin updaten",
		'link' => "index.php?module=tools-inplaytracker&action=update",
		'description' => "Inplaytracker auf die neueste Version updaten."
	);

	$page->output_nav_tabs($sub_tabs, 'inplaytracker_update');

	// Optionen generieren
	$form = new Form("index.php?module=tools-inplaytracker&action=update", "post");
	$form_container = new FormContainer("Inplaytracker updaten");
	$form_container = new FormContainer("Plugin aktualisieren");
	$form_container->output_row_header("Status");
	$form_container->output_row_header("Update");
	// Datenbank aktualisieren
	$form_container->output_cell("<b>Datenbankmodifizierungen</b>");
	$form_container->output_cell("<center>".$form->generate_submit_button("Datenbank updaten", array("name" => "update_database"))."</center>");
	$form_container->construct_row();
	// Admin CP Settings hinzufügen
	$form_container->output_cell("<b>Admin CP Einstellungen aktualisieren</b>");
	$form_container->output_cell("<center>".$form->generate_submit_button("Einstellungen aktualisieren", array("name" => "update_settings"))."</center>");
	$form_container->construct_row();
	// Datenbankspalte "partners" aktualisieren
	$form_container->output_cell("<b>Charakternamen in User-ID umwandeln</b>");
	$form_container->output_cell("<center>".$form->generate_submit_button("Postingpartner aktualisieren", array("name" => "update_partner"))."</center>");
	$form_container->construct_row();
	// Datenbankspalte "ipdate" aktualisieren
	$form_container->output_cell("<b>Datum in Zeitstempel umwandeln</b><br />Voraussetzung ist die Formatierung <em>Tag Monat Jahr</em> für das ursprüngliche Datum!");
	$form_container->output_cell("<center>".$form->generate_submit_button("Datum aktualisieren", array("name" => "update_date"))."</center>");
	$form_container->construct_row();
	// MyAlerts-Integration anlegen
	$form_container->output_cell("<b>Alert-Types anlegen</b><br /> Nur, wenn MyAlerts <em>nach</em> dem Tracker installiert wurde!");
	$form_container->output_cell("<center>".$form->generate_submit_button("Alert Types anlegen", array("name" => "update_alerts"))."</center>");
	$form_container->construct_row();
	$form_container->end();
	$form->end();
	$page->output_footer();
}

?>