+
+
+
+
+
+ {foreach from=$menOptions item=menname}
+
+ {/foreach}
+
+
+
+
+
+
+
+
+ {@SID_INPUT_TAG}
+
+ {if $gwsID|isset}{/if}
+
+
+
+{include file='footer'}
Index: /trunk/de.inside.wcf.Gewinnspiel/acptemplates/gewinnspielList.tpl
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/acptemplates/gewinnspielList.tpl (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/acptemplates/gewinnspielList.tpl (revision 516)
@@ -0,0 +1,67 @@
+{include file='header'}
+
+
+
+
+
+
{lang}wcf.acp.gewinnspiel.list{/lang}
+
+
+
+
+{if $gewinnspiele|count}
+
+
+
+
{lang}wcf.acp.gewinnspiel.games.count{/lang}
+
+
+
+
+ |
+ |
+
+ |
+
+ |
+
+ |
+
+
+
+ {foreach from=$gewinnspiele item=gewinnspiel}
+
+ | {@$gewinnspiel.gwsID} |
+
+ 
+ 
+ {if $gewinnspiel.usercount}
+ 
+ {else}
+
+ {/if}
+ {lang}{$gewinnspiel.gwsTitel}{/lang} ({@$gewinnspiel.usercount})
+ |
+
+ {@$gewinnspiel.starttime|shorttime}
+ |
+
+ {@$gewinnspiel.timeout|shorttime}
+ |
+
+ {/foreach}
+
+
+
+
+{/if}
+
+{include file='footer'}
Index: /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/form/GewinnspielEditForm.class.php
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/form/GewinnspielEditForm.class.php (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/form/GewinnspielEditForm.class.php (revision 516)
@@ -0,0 +1,176 @@
+gwsID = intval($_REQUEST['gwsID']);
+ if(isset($_POST['gwsOptions'])) $this->gwsOptionsText = StringUtil::unifyNewlines(StringUtil::trim($_POST['gwsOptions']));
+ }
+
+ /**
+ * @see Page::readData()
+ */
+ public function readData() {
+ parent::readData();
+ if (!count($_POST)) {
+ // get game
+ $sql = "SELECT *
+ FROM wcf".WCF_N."_gws_game
+ WHERE gwsID = '".$this->gwsID."'";
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $games =array('gwsID' => $row['gwsID'],
+ 'gwsTitel' => $row['gwsTitel'],
+ 'start' => $row['starttime'],
+ 'timeout' => $row['timeout'] ,
+ 'email' => $row['recipient'],
+ 'regeln' => $row['regeln'],
+ 'datenschutz' => $row['discl'],
+ 'beschreibung' => $row['beschreib'],
+ 'groupIDs' => $row['groupIDs'],
+ 'money' => $row['money']);
+ $this->games[] = $games;
+ }
+ $this->groupIDs = explode(",",$games['groupIDs']);
+
+ // get game options
+ $sql = "SELECT *
+ FROM wcf".WCF_N."_gws_options
+ WHERE gwsID = ".$this->gwsID."
+ ORDER BY showOrder";
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $this->gwsOptionsArray[] .= "$row[gwsOption]";
+ }
+
+ $this->gwsOldOptionsArray = $this->gwsOptionsArray;
+ $this->gwsTitel = $games['gwsTitel'];
+ $this->start = $games['start'];
+ $this->timeout = $games['timeout'];
+ $this->email = $this->confirmEmail = $games['email'];
+ $this->regeln = $games['regeln'];
+ $this->discl = $games['datenschutz'];
+ $this->beschreibung = $games['beschreibung'];
+ $this->money = $games['money'];
+
+ // Zeit in einzele Werte zerlegen
+ if (!count($_POST) && $this->start) {
+ $this->startDay = intval(DateUtil::formatDate('%e', $this->start, false, true));
+ $this->startMonth = intval(DateUtil::formatDate('%m', $this->start, false, true));
+ $this->startYear = DateUtil::formatDate('%Y', $this->start, false, true);
+ $this->startHour = DateUtil::formatDate('%H', $this->start, false, true);
+ $this->startMinutes = DateUtil::formatDate('%M', $this->start, false, true);
+ }
+ if (!count($_POST) && $this->timeout) {
+ $this->timeoutDay = intval(DateUtil::formatDate('%e', $this->timeout, false, true));
+ $this->timeoutMonth = intval(DateUtil::formatDate('%m', $this->timeout, false, true));
+ $this->timeoutYear = DateUtil::formatDate('%Y', $this->timeout, false, true);
+ $this->timeoutHour = DateUtil::formatDate('%H', $this->timeout, false, true);
+ $this->timeoutMinutes = DateUtil::formatDate('%M', $this->timeout, false, true);
+ }
+ }
+ }
+
+ /**
+ * @see Page::assignVariables()
+ */
+ public function assignVariables() {
+ parent::assignVariables();
+
+ WCF::getTPL()->assign(array(
+ 'gwsID' => $this->gwsID,
+ 'action' => 'edit',
+ 'starttime' => $this->start,
+ ));
+ }
+
+ /**
+ * @see Form::validate()
+ */
+ public function validate() {
+ parent::validate();
+ $this->valid = true;
+ }
+
+ /**
+ * Updates the data of an existing game.
+ */
+ public function save() {
+ $this->gwsOptionsArray = array_unique(ArrayUtil::trim(explode("\n", $this->gwsOptionsText)));
+ // get game options
+ $sql = "SELECT *
+ FROM wcf".WCF_N."_gws_options
+ WHERE gwsID = ".$this->gwsID."
+ ORDER BY showOrder";
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $this->gwsOldOptionsArray[] .= "$row[gwsOption]";
+ }
+ // search for renamed, deleted or added options
+ for($showOrder=0;!empty($this->gwsOptionsArray[$showOrder]) || !empty($this->gwsOldOptionsArray[$showOrder]);++$showOrder) {
+ // wenn keine alten Optionen mehr vorhanden, die neuen INSERTen
+ if(empty($this->gwsOldOptionsArray[$showOrder]) && $this->gwsOptionsArray[$showOrder]) {
+ $sql = "INSERT INTO wcf".WCF_N."_gws_options
+ (gwsID, gwsOption, showOrder)
+ VALUES (".$this->gwsID.",
+ '".escapeString($this->gwsOptionsArray[$showOrder])."',
+ ".$showOrder.")";
+ WCF::getDB()->registerShutdownUpdate($sql);
+ // wenn noch alt Optionen vorhanden sind dann lschen
+ } elseif(empty($this->gwsOptionsArray[$showOrder]) && $this->gwsOldOptionsArray[$showOrder]) {
+ $sql = "DELETE FROM wcf".WCF_N."_gws_options
+ WHERE gwsID = ".$this->gwsID." AND showOrder = ".$showOrder;
+ WCF::getDB()->registerShutdownUpdate($sql);
+ // wenn alte Optione nicht gleich der neuen dann UPDATE
+ } elseif ($this->gwsOptionsArray[$showOrder] != $this->gwsOldOptionsArray[$showOrder]){
+ $sql = "UPDATE wcf".WCF_N."_gws_options
+ SET gwsOption = '".escapeString($this->gwsOptionsArray[$showOrder])."'
+ WHERE gwsID = ".$this->gwsID." AND showOrder = ".$showOrder;
+ WCF::getDB()->registerShutdownUpdate($sql);
+ }
+ }
+ if ($this->valid && $this->gwsID) {
+ $sql = "UPDATE wcf".WCF_N."_gws_game
+ SET gwsTitel = '".escapeString($this->gwsTitel)."',
+ starttime = ".$this->start.",
+ timeout = ".$this->timeout.",
+ recipient = '".escapeString($this->email)."',
+ regeln = '".$this->regeln."',
+ discl = '".$this->discl."',
+ beschreib = '".$this->beschreibung."',
+ groupIDs = '".implode(",",$this->groupIDs)."',
+ money = '".intval($this->money)."'
+ WHERE gwsID = " .$this->gwsID;
+ WCF::getDB()->registerShutdownUpdate($sql);
+ // forward to list page
+ header('Location: index.php?page=GewinnspielList&packageID='.PACKAGE_ID.SID_ARG_2ND_NOT_ENCODED);
+ exit;
+ }
+ }
+}
+?>
Index: /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/form/GewinnspielAddForm.class.php
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/form/GewinnspielAddForm.class.php (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/form/GewinnspielAddForm.class.php (revision 516)
@@ -0,0 +1,305 @@
+setActiveMenuItem('wcf.acp.menu.link.content.games');
+
+ // check permission
+ WCF::getUser()->checkPermission(array('admin.gewinnspiel.canChangeOptions'));
+ parent::show();
+ }
+
+ /**
+ * @see Page::readParameters()
+ */
+ public function readParameters() {
+ parent::readParameters();
+ }
+
+ /**
+ * @see Form::readFormParameters()
+ */
+ public function readFormParameters() {
+ parent::readFormParameters();
+
+ if (isset($_POST['gwsTitel'])) $this->gwsTitel = escapeString($_REQUEST['gwsTitel']);
+ if (isset($_POST['gwsOptions'])) $this->gwsOptionsText = StringUtil::unifyNewlines(StringUtil::trim($_POST['gwsOptions']));
+ if (isset($_POST['starttime'])) $this->start = intval($_POST['starttime']);
+ if (isset($_POST['startDay'])) $this->startDay = intval($_POST['startDay']);
+ if (isset($_POST['startMonth'])) $this->startMonth = intval($_POST['startMonth']);
+ if (isset($_POST['startYear'])) $this->startYear = intval($_POST['startYear']);
+ if (isset($_POST['startHour'])) $this->startHour = intval($_POST['startHour']);
+ if (isset($_POST['startMinutes'])) $this->startMinutes = intval($_POST['startMinutes']);
+ if (isset($_POST['timeoutDay'])) $this->timeoutDay = intval($_POST['timeoutDay']);
+ if (isset($_POST['timeoutMonth'])) $this->timeoutMonth = intval($_POST['timeoutMonth']);
+ if (isset($_POST['timeoutYear'])) $this->timeoutYear = intval($_POST['timeoutYear']);
+ if (isset($_POST['timeoutHour'])) $this->timeoutHour = intval($_POST['timeoutHour']);
+ if (isset($_POST['timeoutMinutes']))$this->timeoutMinutes = intval($_POST['timeoutMinutes']);
+ if (isset($_POST['email'])) $this->email = StringUtil::trim($_POST['email']);
+ if (isset($_POST['confirmEmail'])) $this->confirmEmail = StringUtil::trim($_POST['confirmEmail']);
+ if (isset($_POST['regeln'])) $this->regeln = escapeString(StringUtil::trim($_POST['regeln']));
+ if (isset($_POST['datenschutz'])) $this->discl = escapeString(StringUtil::trim($_POST['datenschutz']));
+ if (isset($_POST['beschreibung'])) $this->beschreibung = escapeString(StringUtil::trim($_POST['beschreibung']));
+ if (isset($_POST['money'])) $this->money = intval($_POST['money']);
+ if (isset($_POST['groupIDs'])) $this->groupIDs = ArrayUtil::toIntegerArray($_POST['groupIDs']);
+ if (isset($_POST['action'])) $this->action = escapeString($_POST['action']);
+
+ $this->gwsOptionsArray = array_unique(ArrayUtil::trim(explode("\n", $this->gwsOptionsText)));
+ }
+
+ /**
+ * @see Form::validate()
+ */
+ public function validate() {
+ // Startdatum/zeit prfen und wandeln
+ if ($this->action != 'edit') {
+ $this->start = $this->convertDateTime($this->startDay, $this->startMonth, $this->startYear, $this->startHour, $this->startMinutes, $this->action, 'start');
+ }
+ $this->timeout = $this->convertDateTime($this->timeoutDay, $this->timeoutMonth, $this->timeoutYear, $this->timeoutHour, $this->timeoutMinutes, $this->action, 'timeout');
+ // start VOR ende ?
+ if ($this->timeout <= $this->start) {
+ throw new UserInputException('timeout', 'invalid');
+ }
+
+ // Fragen angegeben ?
+ if (empty($this->gwsOptionsArray)) {
+ throw new UserInputException('gwsOptions', 'empty');
+ }
+ // E-Mail prfen
+ // email angegeben ?
+ if (empty($this->email)) {
+ throw new UserInputException('email', 'empty');
+ }
+ // validateEmail angegeben ?
+ if (empty($this->confirmEmail)) {
+ throw new UserInputException('confirmEmail', 'empty');
+ }
+ // check for valid email (one @ etc.)
+ if (!UserUtil::isValidEmail($this->email)) {
+ throw new UserInputException('email', 'notValid');
+ }
+ // prfen ob ein Titel eingegeben wurde
+ if (empty($this->gwsTitel)) {
+ throw new UserInputException('gwsTitel', 'empty');
+ }
+ // check confirm input
+ if (StringUtil::toLowerCase($this->email) != StringUtil::toLowerCase($this->confirmEmail)) {
+ throw new UserInputException('confirmEmail', 'notEqual');
+ }
+ // user gruppen prfen und array anpassen
+ if (count($this->groupIDs) > 0) {
+ require_once(WCF_DIR.'lib/data/user/group/Group.class.php');
+ $sql = "SELECT groupID
+ FROM wcf".WCF_N."_group
+ WHERE groupID IN (".implode(',', $this->groupIDs).")";
+ $result = WCF::getDB()->sendQuery($sql);
+ $this->groupIDs = array();
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ if (Group::isAccessibleGroup($row['groupID'])) {
+ $this->groupIDs[] = $row['groupID'];
+ }
+ }
+ }
+ $this->valid = true;
+
+ }
+
+ /**
+ * Create the data of an new game.
+ */
+ public function save() {
+ //Create new Game
+ if ($this->valid && !$this->gwsID && $this->action == 'add'){
+ // Gewinnspiel speichern
+ $sql = "INSERT INTO wcf".WCF_N."_gws_game
+ (gwsTitel, starttime, timeout, recipient, regeln, discl, beschreib, groupIDs, money)
+ VALUES ('".$this->gwsTitel."',
+ ".intval($this->start).",
+ ".intval($this->timeout).",
+ '".escapeString($this->email)."',
+ '".$this->regeln."',
+ '".$this->discl."',
+ '".$this->beschreibung."',
+ '".implode(",",$this->groupIDs)."',
+ ".intval($this->money).")";
+ WCF::getDB()->sendQuery($sql);
+
+ // Gewinnspiel ID holen
+ $this->gwsID = WCF::getDB()->getInsertID();
+
+ // Fragen speichern
+ $showOrder = 0;
+ $inserts = '';
+ foreach ($this->gwsOptionsArray as $option) {
+ if (!empty($inserts)) $inserts .= ',';
+ $inserts .= "(".$this->gwsID.", '".escapeString($option)."', ".$showOrder.")";
+ $showOrder++;
+ }
+ if (!empty($inserts)) {
+ $sql = "INSERT INTO wcf".WCF_N."_gws_options
+ (gwsID, gwsOption, showOrder)
+ VALUES ".$inserts;
+ WCF::getDB()->registerShutdownUpdate($sql);
+ }
+ }
+ // forward to list page
+ header('Location: index.php?page=GewinnspielList&packageID='.PACKAGE_ID.SID_ARG_2ND_NOT_ENCODED);
+ exit;
+
+ }
+
+ /**
+ * @see Page::readData()
+ */
+ public function readData() {
+ parent::readData();
+ }
+
+ /**
+ * @see Page::assignVariables()
+ */
+ public function assignVariables() {
+ // create calendar data
+ $dayOptions = array(0 => '');
+ $monthList = $weekdayList = '';
+ $weekdays = $monthOptions = array();
+
+ // days
+ for ($i = 1; $i <= 31; $i++) $dayOptions[$i] = $i;
+ // months
+ $monthFormat = (Language::$dateFormatLocalized ? '%B' : '%m');
+ for ($i = 1; $i <= 12; $i++) $monthOptions[$i] = DateUtil::formatDate($monthFormat, gmmktime(0, 0, 0, $i, 15, 2000), false, true);
+ $monthList = implode(',', $monthOptions);
+ $monthOptions[0] = '';
+ ksort($monthOptions);
+
+ // weekdays
+ for ($i = 1; $i <= 7; $i++) {
+ $weekdayNumber = intval(DateUtil::formatDate('%w', gmmktime(0, 0, 0, 1, $i, 2000), false, true));
+ $weekdays[$weekdayNumber] = DateUtil::formatDate('%a', gmmktime(0, 0, 0, 1, $i, 2000), false, true);
+ }
+ ksort($weekdays);
+ $weekdayList = implode(',', $weekdays);
+
+ parent::assignVariables();
+
+ if (!defined ('GUTHABEN_ENABLE_GLOBAL')){
+ $this->GUTHABEN_ENABLE_GLOBAL = false;
+ }else{
+ $this->GUTHABEN_ENABLE_GLOBAL = GUTHABEN_ENABLE_GLOBAL;
+ }
+
+ WCF::getTPL()->assign(array(
+ 'gwsID' => $this->gwsID,
+ 'gwsTitel' => $this->gwsTitel,
+ 'gwsOptions' => implode("\n", $this->gwsOptionsArray),
+ 'startDay' => $this->startDay,
+ 'startMonth' => $this->startMonth,
+ 'startYear' => $this->startYear,
+ 'startHour' => $this->startHour,
+ 'startMinutes' => $this->startMinutes,
+ 'timeoutDay' => $this->timeoutDay,
+ 'timeoutMonth' => $this->timeoutMonth,
+ 'timeoutYear' => $this->timeoutYear,
+ 'timeoutHour' => $this->timeoutHour,
+ 'timeoutMinutes'=> $this->timeoutMinutes,
+ 'email' => $this->email,
+ 'confirmEmail' => $this->confirmEmail,
+ 'regeln' => $this->regeln,
+ 'datenschutz' => $this->discl,
+ 'beschreibung' => $this->beschreibung,
+ 'money' => $this->money,
+ 'groupIDs' => $this->groupIDs,
+ 'availableGroups' => $this->getGroups(),
+ 'monthOptions' => $monthOptions,
+ 'monthList' => $monthList,
+ 'dayOptions' => $dayOptions,
+ 'weekdayList' => $weekdayList,
+ 'startOfWeek' => 0,
+ 'menOptions' => $this->menOptions,
+ 'GUTHABEN_ENABLE_GLOBAL' => $this->GUTHABEN_ENABLE_GLOBAL,
+ 'action' => 'add'
+ ));
+ }
+
+ /**
+ * Returns a list of all available user groups.
+ *
+ * @return array
+ */
+ private function getGroups() {
+ require_once(WCF_DIR.'lib/data/user/group/Group.class.php');
+ return Group::getAccessibleGroups(array(), array());
+ }
+
+ private function convertDateTime($day, $month, $year, $hour, $minutes, $action, $startend) {
+ // Datum/zeit prfen und wandeln
+ if ($day || $month || $year || $hour || $minutes) {
+ $time = @gmmktime($hour, $minutes, 0, $month, $day, $year);
+ // since php5.1.0 mktime returns false on failure
+ if ($action == 'add' || ($action == 'edit' && $startend == 'start')){
+ if ($time === false || $time === -1 || $time <= TIME_NOW) {
+ throw new UserInputException($startend, 'invalid');
+ }
+ }
+ if ($action == 'edit' && $startend == 'timeout'){
+ if ($time === false || $time === -1 || $time <= TIME_NOW) {
+ throw new UserInputException($startend, 'invalid');
+ }
+ }
+ return DateUtil::getUTC($time);
+ }
+ }
+}
+?>
Index: /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/page/GewinnspielListPage.class.php
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/page/GewinnspielListPage.class.php (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/page/GewinnspielListPage.class.php (revision 516)
@@ -0,0 +1,102 @@
+gwsID = intval($_REQUEST['gwsID']);
+ if (isset($_REQUEST['action'])) $this->action = $_REQUEST['action'];
+ }
+
+ public function validateSortField() {
+ parent::validateSortField();
+
+ switch ($this->sortField) {
+ case 'gwsID':
+ case 'gwsTitel':
+ case 'starttime':
+ case 'timeout': break;
+ default: $this->sortField = $this->defaultSortField;
+ }
+ }
+
+ public function readData() {
+ parent::readData();
+ $this->readGewinnspiele();
+ }
+
+ public function assignVariables() {
+ parent::assignVariables();
+
+ WCF::getTPL()->assign(array(
+ 'gewinnspiele' => $this->gewinnspiele,
+ 'gamescount' => $this->countItems()
+ ));
+ }
+
+ public function show() {
+ // enable menu item
+ WCFACP::getMenu()->setActiveMenuItem('wcf.acp.menu.link.content.games');
+
+ // check permission
+ WCF::getUser()->checkPermission(array('admin.gewinnspiel.canChangeOptions'));
+
+ parent::show();
+ }
+
+ public function countItems() {
+ $sql = "SELECT COUNT(gwsID) AS gwsIDs
+ FROM wcf".WCF_N."_gws_game";
+ $row = WCF::getDB()->getFirstRow($sql);
+
+ return $row['gwsIDs'];
+ }
+
+ public function countUsers($ID) {
+ $sql = "SELECT COUNT(userID) AS userIDs
+ FROM wcf".WCF_N."_gws_spiel
+ WHERE gwsID = $ID";
+ $row = WCF::getDB()->getFirstRow($sql);
+ if (empty($row['userIDs'])) $row['userIDs'] = '';
+ return $row['userIDs'];
+ }
+
+ protected function readGewinnspiele() {
+ $sql = "SELECT `gwsID`, `gwsTitel`, `starttime`, `timeout`
+ FROM wcf".WCF_N."_gws_game gewinnspiele
+ ORDER BY gewinnspiele.".$this->sortField." ".$this->sortOrder."
+ LIMIT ".$this->itemsPerPage."
+ OFFSET ".(($this->pageNo - 1) * $this->itemsPerPage);
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $gewinnspiele =array(
+ 'usercount' => '',
+ );
+ $row['usercount'] = $this->countUsers($row['gwsID']);
+ $this->gewinnspiele[] = $row;
+ }
+ }
+}
+?>
Index: /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/page/GewinnspielUserPage.class.php
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/page/GewinnspielUserPage.class.php (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/page/GewinnspielUserPage.class.php (revision 516)
@@ -0,0 +1,91 @@
+gwsID = intval($_REQUEST['gwsID']);
+ }
+
+ public function validateSortField() {
+ parent::validateSortField();
+
+ switch ($this->sortField) {
+ case 'userID':
+ case 'ipaddress':
+ case 'email':
+ case 'realName':break;
+ default: $this->sortField = $this->defaultSortField;
+ }
+ }
+
+ public function readData() {
+ parent::readData();
+ //Liste der User
+ $sql = "SELECT `userID`, `ipaddress`, `email`, `realName`
+ FROM wcf".WCF_N."_gws_spiel spieler
+ WHERE gwsID = ".$this->gwsID."
+ ORDER BY spieler.".$this->sortField." ".$this->sortOrder."
+ LIMIT ".$this->itemsPerPage."
+ OFFSET ".(($this->pageNo - 1) * $this->itemsPerPage);
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $this->spieler[] = $row;
+ }
+ //Gewinnspiel Name holen
+ $sql = "SELECT `gwsTitel`
+ FROM wcf".WCF_N."_gws_game
+ WHERE gwsID = ".$this->gwsID;
+ $result = WCF::getDB()->sendQuery($sql);
+ $row = WCF::getDB()->getFirstRow($sql);
+ $this->gwsTitel = $row['gwsTitel'];
+ }
+
+ public function countItems() {
+ $sql = "SELECT COUNT(gwsID) AS gwsIDs
+ FROM wcf".WCF_N."_gws_spiel";
+ $row = WCF::getDB()->getFirstRow($sql);
+
+ return $row['gwsIDs'];
+ }
+
+ public function assignVariables() {
+ parent::assignVariables();
+
+ WCF::getTPL()->assign(array(
+ 'spieler' => $this->spieler,
+ 'gwsID' => $this->gwsID,
+ 'gwsTitel' => $this->gwsTitel,
+ ));
+ }
+
+ public function show() {
+ // enable menu item
+ WCFACP::getMenu()->setActiveMenuItem('wcf.acp.menu.link.content.games');
+
+ // check permission
+ WCF::getUser()->checkPermission(array('admin.gewinnspiel.canChangeOptions'));
+
+ parent::show();
+ }
+}
+?>
Index: /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/action/GewinnspielDeleteAction.class.php
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/action/GewinnspielDeleteAction.class.php (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/files/lib/acp/action/GewinnspielDeleteAction.class.php (revision 516)
@@ -0,0 +1,46 @@
+gwsID = intval($_REQUEST['gwsID']);
+ }
+
+ /**
+ * @see Action::execute()
+ */
+ public function execute() {
+ parent::execute();
+
+ // delete game
+ $sql = "DELETE FROM wcf".WCF_N."_gws_game
+ WHERE gwsID = ".$this->gwsID;
+ WCF::getDB()->sendQuery($sql);
+ $sql = "DELETE FROM wcf".WCF_N."_gws_options
+ WHERE gwsID = ".$this->gwsID;
+ WCF::getDB()->sendQuery($sql);
+ $sql = "DELETE FROM wcf".WCF_N."_gws_spiel
+ WHERE gwsID = ".$this->gwsID;
+ WCF::getDB()->sendQuery($sql);
+ // forward to list page
+ header('Location: index.php?page=GewinnspielList&deletedgwsID='.$this->gwsID.'&packageID='.PACKAGE_ID.SID_ARG_2ND_NOT_ENCODED);
+ exit;
+ }
+}
+?>
Index: /trunk/de.inside.wcf.Gewinnspiel/files/lib/form/GewinnspielForm.class.php
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/files/lib/form/GewinnspielForm.class.php (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/files/lib/form/GewinnspielForm.class.php (revision 516)
@@ -0,0 +1,409 @@
+gwsID = intval($_REQUEST['gwsID']);
+ // Sicherheitsabfrage ob ID bergeben wurde
+ if (!$this->gwsID){
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.wrongid'));
+ exit;
+ }
+ // Teilnahmeberechtigung prfen
+ $this->checkPermissions();
+
+ }
+
+ /**
+ * @see Form::readFormParameters()
+ */
+ public function readFormParameters() {
+ parent::readFormParameters();
+
+ if (isset($_POST['gwsID'])) $this->gwsID = intval($_REQUEST['gwsID']);
+ if (isset($_POST['gwsTitel'])) $this->gwsTitel = escapeString($_REQUEST['gwsTitel']);
+ if (isset($_POST['useremail'])) $this->useremail = StringUtil::trim($_POST['useremail']);
+ if (isset($_POST['useremailconfirm'])) $this->useremailconfirm = StringUtil::trim($_POST['useremailconfirm']);
+ if (isset($_POST['username'])) $this->username = escapeString($_POST['username']);
+ if (isset($_POST['userreal'])) $this->userreal = escapeString($_POST['userreal']);
+ if (isset($_POST['useraddr'])) $this->useraddr = escapeString($_POST['useraddr']);
+ if (isset($_POST['akzept'])) $this->akzept = escapeString($_POST['akzept']);
+ if (isset($_POST['answer'])) $this->answer = ArrayUtil::trim($_POST['answer'], $removeEmptyElements = false);
+ // Gast oder User ? Bei Usern entfllt die E-Mail berprfung
+ if ($this->username) $this->useremailconfirm = $this->useremail;
+ }
+
+ /**
+ * @see Form::validate()
+ */
+ public function validate() {
+
+ // E-Mail prfen
+ // email angegeben ?
+ if (empty($this->useremail)) {
+ throw new UserInputException('useremail', 'empty');
+ }
+ // validateEmail angegeben ?
+ if (empty($this->useremailconfirm)) {
+ throw new UserInputException('useremailconfirm', 'empty');
+ }
+ // check for valid email (one @ etc.)
+ if (!UserRegistrationUtil::isValidEmail($this->useremail)) {
+ throw new UserInputException('useremail', 'notValid');
+ }
+ // check confirm input
+ if (StringUtil::toLowerCase($this->useremail) != StringUtil::toLowerCase($this->useremailconfirm)) {
+ throw new UserInputException('useremailconfirm', 'notEqual');
+ }
+ // Realname angegeben ?
+ if (empty($this->userreal)) {
+ throw new UserInputException('userreal', 'empty');
+ }
+ // Adresse angegeben ?
+ if (empty($this->useraddr)) {
+ throw new UserInputException('useraddr', 'empty');
+ }
+ // Sind alle Fragen beantwortet worden?
+ foreach ($this->answer as $key => $nummer){
+ if (empty($nummer)){
+ $fehler = "answer[".$key."]";
+ throw new UserInputException($fehler, 'empty');
+ }
+ }
+ // Regeln Akzeptiert ?
+ if (empty($this->akzept) || $this->akzept != 'AKZEPTIERT') {
+ throw new UserInputException('akzept', 'empty');
+ }
+ // parent::validate();
+ // Kontrolle ob Gast schon teilgenommen hat
+ $id = WCF::getUser()->userID;
+ if (!$id){
+ $sql = "SELECT `ipaddress`, `email`, `realName`
+ FROM wcf".WCF_N."_gws_spiel
+ WHERE `gwsID` = $this->gwsID AND `userID` = 0";
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $ipArray[] .= "$row[ipaddress]";
+ $mailArray[] .= "$row[email]";
+ $rnArray[] .= "$row[realName]";
+ }
+ if (!empty($ipArray)){
+ foreach ($ipArray as $key =>$option){
+ if (StringUtil::toLowerCase($mailArray[$key]) == StringUtil::toLowerCase($this->useremail) || StringUtil::toLowerCase($rnArray[$key]) == StringUtil::toLowerCase($this->userreal)){
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.alreadyplayed'));
+ exit;
+ }
+ }
+ }
+ }
+ $this->valid = true;
+ }
+
+ /**
+ * @see Form::save()
+ */
+ public function save() {
+ parent::save();
+ // Teilnahme Erfolgreich dann Gewinnspiel speichern
+ if ($this->valid){
+ // Userdaten speichern
+ $sql = "INSERT INTO wcf".WCF_N."_gws_spiel
+ (gwsID, userID, ipaddress, email, realName)
+ VALUES (".intval($this->gwsID).",
+ ".intval(WCF::getUser()->userID).",
+ '".escapeString(WCF::getSession()->ipAddress)."',
+ '".$this->useremail."',
+ '".$this->userreal."')";
+ WCF::getDB()->sendQuery($sql);
+
+ // E-Mail des Empfngers holen.
+ $sql = "SELECT `recipient`
+ FROM wcf".WCF_N."_gws_game
+ WHERE gwsID = $this->gwsID";
+ $result = WCF::getDB()->getFirstRow($sql);
+ $this->empfnger = $result['recipient'];
+ // E-Mail vorbeiten und senden
+ if (!$this->username) $this->username = 'Gast';
+ // Frage/Antwort Variable vorbereiten
+ $sql = "SELECT *
+ FROM wcf".WCF_N."_gws_options
+ WHERE gwsID = ".$this->gwsID."
+ ORDER BY showOrder";
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $this->gwsOptionsArray[] .= "$row[gwsOption]";
+ }
+ $frage = WCF::getLanguage()->get('wcf.gewinnspiel.frage');
+ $antwort = WCF::getLanguage()->get('wcf.gewinnspiel.antwort');
+ foreach ($this->gwsOptionsArray as $key =>$option){
+ $this->frageantwort .= $frage.": "."$option"."\n".$antwort.": ".$this->answer[$key]."\n"."\n";
+ }
+ $languages = array(0 => WCF::getLanguage(), WCF::getLanguage()->getLanguageID() => WCF::getLanguage());
+ require_once(WCF_DIR.'lib/data/mail/Mail.class.php');
+ require_once(WCF_DIR.'lib/data/user/User.class.php');
+ // get language
+ // enable language
+ $languages[WCF::getLanguage()->getLanguageID()]->setLocale();
+
+ $subjectData = array('PAGE_TITLE' => PAGE_TITLE);
+ $messageData = array(
+ 'PAGE_TITLE' => PAGE_TITLE,
+ '$username' => $this->username,
+ '$userreal' => $this->userreal,
+ '$useremail' => $this->useremail,
+ '$useraddr' => $this->useraddr,
+ '$recipient' => $this->empfnger,
+ '$FrageAntwort' => $this->frageantwort,
+ '$datetime' => $this->getTimeDate()
+ );
+ // Mail an den User
+ $mail = new Mail( array($this->userreal => $this->useremail),
+ $languages[WCF::getLanguage()->getLanguageID()]->get('wcf.gewinnspiel.mail.subject', $subjectData),
+ $languages[WCF::getLanguage()->getLanguageID()]->get('wcf.gewinnspiel.mail.message', $messageData));
+ $mail->send();
+ // Mail an den Veranstalter
+ $mail = new Mail( $this->empfnger,
+ $languages[WCF::getLanguage()->getLanguageID()]->get('wcf.gewinnspiel.mail.subject.recipient', $subjectData),
+ $languages[WCF::getLanguage()->getLanguageID()]->get('wcf.gewinnspiel.mail.message.recipient', $messageData));
+ $mail->send();
+
+ // enable user language
+ WCF::getLanguage()->setLocale();
+
+ // forward to index page
+ WCF::getTPL()->assign(array(
+ 'url' => 'index.php?page=Gewinnspiel'.SID_ARG_1ST,
+ 'message' => WCF::getLanguage()->get(WCF::getLanguage()->get('wcf.gewinnspiel.ok_redirect'), array('$userreal' => $this->username, '$uemail' => $this->useremail))
+ ));
+ WCF::getTPL()->display('redirect');
+ exit;
+ }
+ }
+
+ /**
+ * @see Page::readData()
+ */
+ public function readData() {
+ parent::readData();
+ if ((WCF::getUser()->userID) > 0){
+ $this->username = WCF::getUser()->username;
+ $this->useremail = $this->useremailconfirm = WCF::getUser()->email;
+ }else{
+ if (!count($_POST)) {
+ $this->username = WCF::getLanguage()->get('wcf.gewinnspiel.username.gast');
+ $this->useremail = $this->useremailconfirm = '';
+ }
+ }
+ // Gewinnspiel Daten auslesen
+ $this->readGewinnspiel();
+ }
+
+ /**
+ * @see Page::assignVariables();
+ */
+ public function assignVariables() {
+ parent::assignVariables();
+
+ WBBCore::getTPL()->assign(array(
+ 'gwsID' => $this->gwsID,
+ 'gwsTitel' => $this->gwsTitel,
+ 'regeln' => $this->regeln,
+ 'beschreibung' => $this->beschreibung,
+ 'datenschutz' => $this->datenschutz,
+ 'username' => $this->username,
+ 'useremail' => $this->useremail,
+ 'useremailconfirm' => $this->useremailconfirm,
+ 'userreal' => $this->userreal,
+ 'useraddr' => $this->useraddr,
+ 'usercount' => $this->usercount,
+ 'gwsOptionsArray' => $this->gwsOptionsArray,
+ 'answer' => $this->answer,
+ 'akzept' => $this->akzept,
+ ));
+ }
+
+ /**
+ * @see Page::show()
+ */
+ public function show() {
+ // get the default langauge id
+ $this->languageID = WCF::getLanguage()->getLanguageID();
+ // show form
+ parent::show();
+ }
+
+ protected function checkPermissions() {
+ // Kontrolle ob User schon teilgenommen hat (nicht bei Gsten)
+ $id = WCF::getUser()->userID;
+ if ($id){
+ $sql = "SELECT COUNT(`userID`) AS users
+ FROM wcf".WCF_N."_gws_spiel
+ WHERE `gwsID` = $this->gwsID AND `userID`=$id";
+ $row = WCF::getDB()->getFirstRow($sql);
+ if ($row['users']) {
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.alreadyplayed'));
+ exit;
+ }
+ }
+ // Kontrolle ob Teilnehmer in einer berechtigten Gruppe ist
+ $sql = "SELECT `groupIDs`
+ FROM wcf".WCF_N."_gws_game
+ WHERE gwsID = $this->gwsID";
+ $result = WCF::getDB()->sendQuery($sql);
+ $row = WCF::getDB()->fetchArray($result);
+ // Keine gltige GameID angegeben ?
+ if(empty($row)){
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.wrongid'));
+ exit;
+ }
+ $this->gwsGroupIDs = explode(',',$row['groupIDs']);
+ require_once(WCF_DIR.'lib/data/user/group/Group.class.php');
+ $canplay = false;
+ foreach ($this->gwsGroupIDs as $groupID){
+ if (Group::isMember($groupID)) $canplay = true;
+ }
+ // Fehlermeldung wenn Teilnemer keiner Berechtigten Gruppe angehrt
+ if (!$canplay) {
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.nogroupe'));
+ }
+ }
+
+ protected function readGewinnspiel() {
+ // get game
+ $sql = "SELECT *
+ FROM wcf".WCF_N."_gws_game gewinnspiel
+ WHERE gwsID = ".$this->gwsID;
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $this->gwsID = $row['gwsID'];
+ $this->gwsTitel = $row['gwsTitel'];
+ $this->gwsStart = $row['starttime'];
+ $this->gwsEnde = $row['timeout'];
+ $this->recipient = $row['recipient'];
+ $this->regeln = $this->getFormattedMessage($row['regeln'], false);
+ $this->datenschutz = $this->getFormattedMessage($row['discl'], false);
+ $this->beschreibung = $this->getFormattedMessage($row['beschreib'], false);
+ $this->groupIDs = $row['groupIDs'];
+ $this->money = $row['money'];
+ }
+ if (defined('GUTHABEN_ENABLE_GLOBAL')){
+ if(WCF::getUser()->userID && $this->money >= 1) {
+ require_once(WCF_DIR.'lib/data/user/UserGuthaben.class.php');
+ $um = new UserGuthaben(WCF::getUser()->userID);
+ if (!$um->subGuthaben($this->money,'wcf.gewinnspiel.kosten')) {
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.errormoney'));
+ }
+ }
+ }
+ // Kontrolle ob das Gewinnspiel schon gestartet ist
+ if ($this->gwsStart > TIME_NOW) {
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.statustocome'));
+ exit;
+ }
+ // Kontrolle ob das Gewinnspiel schon beendet ist
+ if ($this->gwsEnde < TIME_NOW) {
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.statusended'));
+ exit;
+ }
+ // get game options
+ $sql = "SELECT *
+ FROM wcf".WCF_N."_gws_options
+ WHERE gwsID = ".$this->gwsID."
+ ORDER BY showOrder";
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $titel = $this->getFormattedMessage($row['gwsOption'], $enableHtml = true);
+ $this->gwsOptionsArray[] .= "$titel";
+ }
+ if (empty($this->answer)){
+ foreach ($this->gwsOptionsArray as $key => $nummer){
+ $this->answer[$key] = '';
+ }
+ }
+ // Anzahl der User die schon Teilgenommen haben
+ $sql = "SELECT COUNT(userID) AS userID
+ FROM wcf".WCF_N."_gws_spiel
+ WHERE gwsID = ".$this->gwsID;
+ $row = WCF::getDB()->getFirstRow($sql);
+ $this->usercount = $row['userID'];
+ }
+
+ /**
+ * @see ViewablePost::getFormattedMessage()
+ */
+ protected function getFormattedMessage($text, $enableHtml) {
+ // parse message
+ require_once(WCF_DIR.'lib/data/message/bbcode/MessageParser.class.php');
+ $parser = MessageParser::getInstance();
+ $parser->setOutputType('text/html');
+ return $parser->parse($text, $this->enableSmilies, $enableHtml, $this->enableBBCodes, false);
+ }
+
+ protected function getTimeDate() {
+ $datumzeit = DateUtil::formatTime(null,null,null,true);
+ return $datumzeit;
+ }
+}
+
+?>
Index: /trunk/de.inside.wcf.Gewinnspiel/files/lib/page/GewinnspielPage.class.php
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/files/lib/page/GewinnspielPage.class.php (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/files/lib/page/GewinnspielPage.class.php (revision 516)
@@ -0,0 +1,161 @@
+userID = WCF::getUser()->userID;
+ $this->username = WCF::getUser()->username;
+ $this->email = WCF::getUser()->email;
+ // get game id and action
+ if (isset($_REQUEST['gwsID'])) $this->gwsID = intval($_REQUEST['gwsID']);
+ if (isset($_REQUEST['action'])) $this->action = $_REQUEST['action'];
+
+ // Hier Code fr Action !!!!
+ if ($this->action == 'go' && $this->gwsID) {
+ $sql = "SELECT `groupIDs`
+ FROM wcf".WCF_N."_gws_game
+ WHERE gwsID = $this->gwsID";
+ $result = WCF::getDB()->sendQuery($sql);
+ $row = WCF::getDB()->fetchArray($result);
+ $this->gwsGroupIDs = explode(',',$row['groupIDs']);
+ require_once(WCF_DIR.'lib/data/user/group/Group.class.php');
+ $canplay = false;
+ foreach ($this->gwsGroupIDs as $groupID){
+ if (Group::isMember($groupID)) $canplay = true;
+ }
+ if (!$canplay) {
+ require_once(WCF_DIR.'lib/system/exception/NamedUserException.class.php');
+ throw new NamedUserException(WCF::getLanguage()->get('wcf.gewinnspiel.nogroupe'));
+ }
+
+ }
+ }
+
+ public function readData() {
+ parent::readData();
+ $this->readGewinnspiele();
+ }
+
+ /**
+ * @see Page::assignVariables();
+ */
+ public function assignVariables() {
+ parent::assignVariables();
+ $this->userID = WCF::getUser()->userID;
+ if (GEWINNSPIEL_OFFLINE) {
+ $this->templateName = 'gewinnspiel_offline';
+ WCF::getTPL()->assign('offlinemessage', GEWINNSPIEL_OFFLINE_MESSAGE);
+ } else {
+ WCF::getTPL()->assign('selfLink', 'GewinnspielPage.php?'.SID_ARG_2ND);
+ WCF::getTPL()->assign(array(
+ 'gewinnspiele' => $this->gewinnspiele,
+ 'gamescount' => $this->countItems(),
+ ));
+ }
+ }
+
+ /**
+ * @see Page::show()
+ */
+ public function show() {
+ require_once(WCF_DIR.'lib/page/util/menu/HeaderMenu.class.php');
+ HeaderMenu::setActiveMenuItem('wcf.header.menu.gamemenue');
+
+ // check permission
+ WCF::getUser()->checkPermission('user.gewinnspiel.canViewGewinnspiel');
+
+ parent::show();
+ }
+
+ public function countItems() {
+ parent::countItems();
+
+ $sql = "SELECT COUNT(gwsID)
+ AS gwsID
+ FROM wcf".WCF_N."_gws_game";
+ $row = WCF::getDB()->getFirstRow($sql);
+
+ return $row['gwsID'];
+ }
+
+ protected function readGewinnspiele() {
+ $sql = "SELECT `gwsID`, `gwsTitel`, `starttime`, `timeout`, `groupIDs`, `money`
+ FROM wcf".WCF_N."_gws_game gewinnspiele
+ ORDER BY timeout ASC
+ LIMIT ".$this->itemsPerPage."
+ OFFSET ".(($this->pageNo - 1) * $this->itemsPerPage);
+ $result = WCF::getDB()->sendQuery($sql);
+ while ($row = WCF::getDB()->fetchArray($result)) {
+ $gewinnspiele =array(
+ 'gwsID' => $row['gwsID'],
+ 'groupIDs' => $row['groupIDs'],
+ 'permission' => '',
+ 'done' => '',
+ );
+ if (!defined('GUTHABEN_ENABLE_GLOBAL')){
+ $row['money'] = 0;
+ }
+ // Kontrolle ob Gruppe berechtigt ist
+ $row['permission'] = 'nein';
+ $IDs = explode(',',$row['groupIDs']);
+ require_once(WCF_DIR.'lib/data/user/group/Group.class.php');
+ foreach ($IDs as $gruppe) {
+ if (Group::isMember($gruppe)) $row['permission'] = 'ok';
+ }
+ // Kontrolle ob User schon teilgenommen hat (nicht bei Gsten)
+ $id = WCF::getUser()->userID;
+ $row['done'] = 'notdone';
+ if ($id){
+ $sql1 = "SELECT COUNT(`userID`) AS users
+ FROM wcf".WCF_N."_gws_spiel
+ WHERE `gwsID` = $row[gwsID] AND `userID`=$id";
+ $row1 = WCF::getDB()->getFirstRow($sql1);
+ if ($row1['users']) {
+ $row['done'] = 'done';
+ }
+ }
+ $this->gewinnspiele[] = $row;
+ }
+ }
+
+ protected function getTimeDate() {
+ $datumzeit = DateUtil::formatDate(null,null,true,true);
+ return $datumzeit;
+ }
+}
+
+?>
Index: /trunk/de.inside.wcf.Gewinnspiel/install.sql
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/install.sql (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/install.sql (revision 516)
@@ -0,0 +1,40 @@
+DROP TABLE IF EXISTS wcf1_gws_game;
+CREATE TABLE `wcf1_gws_game` (
+ `gwsID` int(11) unsigned NOT NULL auto_increment,
+ `gwsTitel` varchar(255) NOT NULL,
+ `starttime` int(11) unsigned NOT NULL default '0',
+ `timeout` int(11) unsigned NOT NULL default '0',
+ `recipient` varchar(150) NOT NULL default '',
+ `regeln` mediumtext,
+ `discl` mediumtext,
+ `beschreib` mediumtext,
+ `groupIDs` varchar(255) NOT NULL default '0',
+ `money` int(11) unsigned NOT NULL default '0',
+ PRIMARY KEY (`gwsID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS wcf1_gws_options;
+CREATE TABLE `wcf1_gws_options` (
+ `gwsOptionID` int(15) unsigned NOT NULL auto_increment,
+ `gwsID` int(11) unsigned NOT NULL default '0',
+ `gwsOption` mediumtext,
+ `showOrder` tinyint(3) unsigned NOT NULL default '0',
+ PRIMARY KEY (`gwsOptionID`,`gwsID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `wcf1_gws_spiel`;
+CREATE TABLE `wcf1_gws_spiel` (
+ `gwsID` int(11) NOT NULL default '0',
+ `userID` int(11) NOT NULL default '0',
+ `ipaddress` varchar(16) NOT NULL default '0',
+ `email` varchar(255) NOT NULL default '0',
+ `realName` varchar(255) NOT NULL default '',
+ KEY `gwsID` (`gwsID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `wcf1_gamemenue` ( `position` , `name` , `text` , `link` , `bild` , `active` , `post` , `showhit` , `hit` , `target` , `extend` , `height` , `width` , `enableSmilies` , `enableHtml` , `enableBBCodes` , `permission` )
+VALUES (
+'0', 'Gewinnspiel(e)', '[align=center]Hier kann man nur Gewinnen!
+Und tolle Preise gibt es auÃerdem ;)
+[/align]', 'index.php?page=Gewinnspiel', '0', '1', '0', '1', '0', '0', '0', '600', '800', '1', '0', '1', '0'
+);
Index: /trunk/de.inside.wcf.Gewinnspiel/pagelocation.xml
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/pagelocation.xml (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/pagelocation.xml (revision 516)
@@ -0,0 +1,12 @@
+
+
+
+
+
+
+
+
+
+
+
+
Index: /trunk/de.inside.wcf.Gewinnspiel/acpmenu.xml
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/acpmenu.xml (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/acpmenu.xml (revision 516)
@@ -0,0 +1,18 @@
+
+
+
+
+
+
+ wcf.acp.menu.link.content
+ 8
+
+
+ wcf.acp.menu.link.content.games
+ 2
+ admin.gewinnspiel.canChangeOptions
+ index.php?page=GewinnspielList
+ icon/gewinnspielM.png
+
+
+
Index: /trunk/de.inside.wcf.Gewinnspiel/de.xml
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/de.xml (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/de.xml (revision 516)
@@ -0,0 +1,150 @@
+
+
+
+
+
+ - Sieht sich deieGewinnspiele an]]>
+ - Nimmt an einem Gewinnspiel teil]]>
+
+
+ - INSIDE das Hörspiel]]>
+
Index: /trunk/de.inside.wcf.Gewinnspiel/groupoptions.xml
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/groupoptions.xml (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/groupoptions.xml (revision 516)
@@ -0,0 +1,43 @@
+
+
+
+
+
+
+
+ user
+
+
+ user.games
+
+
+ user.gewinnspiel.options
+
+
+
+ admin.content
+
+
+ admin.content.gewinnspiel
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: /trunk/de.inside.wcf.Gewinnspiel/options.xml
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/options.xml (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/options.xml (revision 516)
@@ -0,0 +1,24 @@
+
+
+
+
+
+
+
+
+ gewinnspiel
+
+
+
+
+
+
+
+
Index: /trunk/de.inside.wcf.Gewinnspiel/package.xml
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/package.xml (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/package.xml (revision 516)
@@ -0,0 +1,40 @@
+
+
+
+
+
+ Gewinnspiel WCF
+ Competition WCF
+ Gewinnspiel WCF
+ Liste und Verwaltung fÃŒr Gewinnspiele im Frage/Antwort Format.
+
+ 1
+ 0
+ 1.0.0
+ DATE
+ com.woltlab.wcf
+
+
+
+ Robert "Tatelwurm" Hempel
+ http://www.inside-das-hoerspiel.de
+
+
+
+ de.inside.wcf.gamemenue
+
+
+
+ files.tar
+ de.xml
+ de-informal.xml
+ en.xml
+ templates.tar
+ acptemplates.tar
+ install.sql
+ acpmenu.xml
+ options.xml
+ groupoptions.xml
+ pagelocation.xml
+
+
Index: /trunk/de.inside.wcf.Gewinnspiel/de-informal.xml
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/de-informal.xml (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/de-informal.xml (revision 516)
@@ -0,0 +1,145 @@
+
+
+
+
+
+ - Sieht sich deieGewinnspiele an]]>
+ - Nimmt an einem Gewinnspiel teil]]>
+
+
+ - INSIDE das Hörspiel]]>
+
Index: /trunk/de.inside.wcf.Gewinnspiel/templates/gewinnspiel.tpl
===================================================================
--- /trunk/de.inside.wcf.Gewinnspiel/templates/gewinnspiel.tpl (revision 516)
+++ /trunk/de.inside.wcf.Gewinnspiel/templates/gewinnspiel.tpl (revision 516)
@@ -0,0 +1,191 @@
+{include file="documentHeader"}
+
+
{@$gwsTitel} - {lang}wcf.gewinnspiel.title{/lang} - {PAGE_TITLE}
+ {include file='headInclude' sandbox=false}
+
+
+
+{include file='header' sandbox=false}
+
+
+
+
+
+
+
{PAGE_TITLE} {lang}wcf.gewinnspiel.title{/lang}
+
{lang}wcf.gewinnspiel.usercount{/lang}
+
+
+ {if $errorField}
+
{lang}wcf.global.form.error{/lang}
+ {/if}
+
+
+
+ {foreach from=$gwsOptionsArray item=option key=order}
+
+
+
{@$order+1}. {lang}wcf.gewinnspiel.frage{/lang}: {@$option}
+
+
+
+
+
+
+
+
+ {/foreach}
+
+ {if $regeln}
+
+
{lang}wcf.gewinnspiel.regeln{/lang}
+
+
+ {/if}
+ {if $datenschutz}
+
+
{lang}wcf.gewinnspiel.datenschutz{/lang}
+
+
+ {/if}
+
+
+
+
+
+
+ {@SID_INPUT_TAG}
+
+
+{include file='footer' sandbox=false}
+
+
+ 
{/if}