fapweb: showajax.php annotate

annotate showajax.php @ 143:20893a5442b7

Move some functions to site module, and use them.

author	Matti Hamalainen <ccr@tnsp.org>
date	Wed, 23 Oct 2013 01:21:12 +0300
parents	d2e9285b69ad
children	c030c3cf0d80

rev	line source
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1 <?
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	2 //
136 aeebfedb5709 Add some copyright headers. Matti Hamalainen <ccr@tnsp.org> parents: 126 diff changeset	3 // FAPWeb Simple Demoparty System
aeebfedb5709 Add some copyright headers. Matti Hamalainen <ccr@tnsp.org> parents: 126 diff changeset	4 // Party information display system AJAX backend module
aeebfedb5709 Add some copyright headers. Matti Hamalainen <ccr@tnsp.org> parents: 126 diff changeset	5 // (C) Copyright 2012-2013 Tecnic Software productions (TNSP)
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	6 //
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	7 require "mconfig.inc.php";
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	8 require "msite.inc.php";
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	9
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	10
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	11 function stPrintCompoEntry($entry, $class, $compo, $title = false)
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	12 {
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	13 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	14 " <div class=\"".$class."\">\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	15
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	16 if ($title !== false)
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	17 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	18 " <div class=\"title\">".$title."</div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	19
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	20 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	21 " <div class=\"entryIndex\">#".$entry["show_id"]."</div>\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	22 " <div class=\"entryName\">".chentities($entry["name"])."</div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	23
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	24 if ($compo["showAuthors"])
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	25 echo " <div class=\"entryAuthor\">".chentities($entry["author"])."</div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	26
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	27 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	28 " <div class=\"entryInfo\">".chentities($entry["info"])."</div>\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	29 " </div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	30 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	31
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	32 function stPrintCompoSlide($compo, $entry, $prev)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	33 {
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	34 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	35 " <div class=\"compoHeader\">\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	36 " <img src=\"img/fapsm.png\" /><br />\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	37 " <div class=\"title\">".chentities($compo["name"])." competition</div>\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	38 " </div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	39
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	40 if ($entry !== false)
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	41 stPrintCompoEntry($entry, "compoNext", $compo, false);
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	42
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	43 if ($prev !== false)
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	44 stPrintCompoEntry($prev, "compoPrev", $compo, "Previous entry");
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	45 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	46
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	47
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	48 function stPrintRotationSlide($slide)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	49 {
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	50 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	51 " <div class=\"showHeader\">\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	52 " <img src=\"img/fapsm.png\" /><br />\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	53 " </div>\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	54 " <div class=\"showText\">\n".
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	55 $slide["text"].
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	56 " </div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	57 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	58
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	59 //
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	60 // Initialize
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	61 //
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	62 stSetupCacheControl();
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	63
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	64 if (!stConnectSQLDB())
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	65 die("Could not connect to SQL database.");
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	66
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	67 stReloadDisplayVars();
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	68
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	69
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	70 //
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	71 // Check if the slide needs updating?
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	72 //
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	73 if (stGetDisplayVar("tempDuration") > 0 && stGetDisplayVar("tempSlide") > 0)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	74 {
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	75 $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d",
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	76 stGetDisplayVar("tempSlide"));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	77
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	78 if (($res = stFetchSQL($sql)) !== false)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	79 {
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	80 stSetDisplayVar("tempDuration", 0);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	81 stSetDisplayVar("activeSlideMode", SMODE_ROTATE);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	82 stSetDisplayVar("activeSlide", stGetDisplayVar("tempSlide"));
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	83 stSetDisplayVar("activeSlideExpire", time() + stGetDisplayVar("tempDuration"));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	84 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	85 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	86 else
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	87 switch (stGetDisplayVar("showMode"))
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	88 {
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	89 case SMODE_ROTATE:
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	90 default:
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	91 stSetDisplayVar("activeSlideMode", SMODE_ROTATE);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	92
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	93 if (stGetDisplayVar("rotateList") == 0)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	94 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	95 stSetDisplayVar("rotateList", 1);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	96 stSetDisplayVar("activeSlideExpire", 0);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	97 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	98
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	99 if (time() >= stGetDisplayVar("activeSlideExpire") &&
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	100 stGetDisplayVar("rotateList") > 0)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	101 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	102 // Get list of slides from active rotation list
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	103 $list = stGetDisplayVar("rotateList");
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	104 $sql = stPrepareSQL(
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	105 "SELECT * FROM displayListSlides WHERE list_id=%d ORDER BY id",
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	106 $list);
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	107
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	108 if (($slideList = stExecSQL($sql)) !== false)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	109 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	110 // Get slide at current index
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	111 $slides = array();
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	112 foreach ($slideList as $slide)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	113 $slides[] = $slide;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	114
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	115 $index = stGetDisplayVar("rotateListIndex");
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	116 if (count($slides) > $index)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	117 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	118 $slide_id = $slides[$index]["slide_id"];
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	119 if ($slide_id != stGetDisplayVar("activeSlide"))
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	120 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	121 stSetDisplayVar("activeSlide", $slide_id);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	122 stSetDisplayVar("activeSlideExpire", time() + stGetDisplayVar("rotateDuration"));
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	123 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	124 }
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	125
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	126 // Rotate to next slide
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	127 if (++$index >= count($slides))
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	128 $index = 0;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	129
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	130 stSetDisplayVar("rotateListIndex", $index);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	131 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	132 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	133 break;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	134
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	135 case SMODE_COMPO:
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	136 break;
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	137 }
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	138
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	139
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	140 $action = stChkRequestItem("action") ? $_REQUEST["action"] : "";
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	141 switch ($action)
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	142 {
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	143 case "check":
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	144 // Check if there has been any change
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	145 $changed =
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	146 stGetRequestItem("activeSlide") != stGetDisplayVar("activeSlide") \|\|
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	147 stGetRequestItem("activeSlide") != stGetDisplayVar("activeSlide");
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	148
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	149 echo $changed ? "changed" : "nochange";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	150 stSetStatus(200, "OK");
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	151 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	152
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	153 case "get":
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	154 // Based on the currently active mode ...
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	155 switch (stGetDisplayVar("activeSlideMode"))
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	156 {
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	157 case SMODE_ROTATE:
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	158 // Slide rotation mode, display currently active slide
20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	159 if (stGetDisplayVar("activeSlide") > 0)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	160 {
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	161 $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d",
20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	162 stGetDisplayVar("activeSlide"));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	163
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	164 if (($slide = stFetchSQL($sql)) !== false)
20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	165 stPrintRotationSlide($slide);
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	166 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	167 else
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	168 {
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	169 echo "<div>ERROR!</div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	170 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	171 break;
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	172
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	173 case SMODE_COMPO:
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	174 // Competition mode
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	175 $compo = stFetchSQL(stPrepareSQL(
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	176 "SELECT * FROM compos WHERE id=%d",
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	177 stGetDisplayVar("compoCompo")));
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	178
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	179 $prev = stFetchSQL(stPrepareSQL(
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	180 "SELECT * FROM entries WHERE id=%d",
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	181 stGetDisplayVar("compoPrevEntry")));
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	182
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	183 $entry = stFetchSQL(stPrepareSQL(
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	184 "SELECT * FROM entries WHERE id=%d",
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	185 stGetDisplayVar("compoCurrEntry")));
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	186
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	187 if ($compo !== false)
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	188 stPrintCompoSlide($compo, $entry, $prev);
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	189 break;
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	190 }
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	191 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	192
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	193 default:
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	194 stSetStatus(404, "Not Found");
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	195 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	196 }
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	197
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	198
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	199 // Save changed variables
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	200 stSaveDisplayVars();
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	201 ?>

Mercurial > hg > fapweb

annotate showajax.php @ 143:20893a5442b7