fapweb: showajax.php annotate

annotate showajax.php @ 163:1386a7a8816c

Whitespace cosmetics.

author	Matti Hamalainen <ccr@tnsp.org>
date	Sun, 27 Oct 2013 03:27:02 +0200
parents	6e6fba2da3d1
children	8df523e6326a

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
163 1386a7a8816c Whitespace cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 152 diff changeset	32
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	33 function stPrintCompoSlide($compo, $entry, $prev)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	34 {
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	35 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	36 " <div class=\"compoHeader\">\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	37 " <img src=\"img/fapsm.png\" /><br />\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	38 " <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	39 " </div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	40
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	41 if ($entry !== false)
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	42 stPrintCompoEntry($entry, "compoNext", $compo, false);
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	43
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	44 if ($prev !== false)
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	45 stPrintCompoEntry($prev, "compoPrev", $compo, "Previous entry");
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
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	48
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	49 function stPrintRotationSlide($slide)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	50 {
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	51 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	52 " <div class=\"showHeader\">\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	53 " <img src=\"img/fapsm.png\" /><br />\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	54 " </div>\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	55 " <div class=\"showText\">\n".
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	56 $slide["text"].
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	57 " </div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	58 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	59
163 1386a7a8816c Whitespace cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 152 diff changeset	60
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	61 //
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	62 // Initialize
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	63 //
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	64 stSetupCacheControl();
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	65
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	66 if (!stConnectSQLDB())
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	67 die("Could not connect to SQL database.");
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	68
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	69 stReloadDisplayVars();
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	70
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	71
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 // 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	74 //
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	75 $updated = FALSE;
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	76
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	77
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	78 // Temporary slides are handled globally
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	79 if (stGetDisplayVar("tempDuration") > 0 &&
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	80 stGetDisplayVar("tempSlide") > 0 &&
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	81 stGetDisplayVar("tempSlideSet"))
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	82 {
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	83 $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	84 stGetDisplayVar("tempSlide"));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	85
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	86 if (($res = stFetchSQL($sql)) !== false)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	87 {
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	88 stSetDisplayVar("tempSlideSet", FALSE);
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	89 stSetDisplayVar("activeSlideMode", SMODE_ROTATE);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	90 stSetDisplayVar("activeSlide", stGetDisplayVar("tempSlide"));
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	91 stSetDisplayVar("activeSlideExpire", time() + stGetDisplayVar("tempDuration"));
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	92 $updated = TRUE;
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	93 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	94 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	95 else
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	96 // Otherwise we act according to global show mode
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	97 switch (stGetDisplayVar("showMode"))
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	98 {
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	99 case SMODE_ROTATE:
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	100 default:
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	101 //
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	102 // Rotation / normal slide show mode
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	103 //
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	104 stSetDisplayVar("activeSlideMode", SMODE_ROTATE);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	105
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	106 if (stGetDisplayVar("rotateList") == 0)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	107 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	108 stSetDisplayVar("rotateList", 1);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	109 stSetDisplayVar("activeSlideExpire", 0);
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	110 $updated = TRUE;
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	111 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	112
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	113 if (time() >= stGetDisplayVar("activeSlideExpire") &&
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	114 stGetDisplayVar("rotateList") > 0)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	115 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	116 // 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	117 $list = stGetDisplayVar("rotateList");
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	118 $sql = stPrepareSQL(
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	119 "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	120 $list);
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	121
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	122 if (($slideList = stExecSQL($sql)) !== false)
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 // Get slide at current index
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	125 $slides = array();
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	126 foreach ($slideList as $slide)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	127 $slides[] = $slide;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	128
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	129 $index = stGetDisplayVar("rotateListIndex");
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	130 if (count($slides) > $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 $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	133 if ($slide_id != stGetDisplayVar("activeSlide"))
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 stSetDisplayVar("activeSlide", $slide_id);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	136 stSetDisplayVar("activeSlideExpire", time() + stGetDisplayVar("rotateDuration"));
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	137 $updated = TRUE;
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	138 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	139 }
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	140
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	141 // Rotate to next slide
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	142 if (++$index >= count($slides))
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	143 $index = 0;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	144
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	145 stSetDisplayVar("rotateListIndex", $index);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	146 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	147 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	148 break;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	149
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	150 case SMODE_COMPO:
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	151 //
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	152 // Competition mode, is controlled from admin UI, so we donẗ
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	153 // actually do anything here.
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	154 //
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	155 break;
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	156 }
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	157
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	158 // Check if we need to update the "last updated" timestamp
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	159 if ($updated)
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	160 stSetDisplayVar("lastUpdate", time());
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	161
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	162
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	163 //
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	164 // Serve the request
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	165 //
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	166 $type = stGetRequestItem("type");
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	167 switch (stGetRequestItem("action"))
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	168 {
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	169 case "check":
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	170 // Check if there has been any change
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	171 $changed = stGetRequestItem("lastUpdate") != stGetDisplayVar("lastUpdate");
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	172 echo $changed ? "changed" : "nochange";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	173 stSetStatus(200, "OK");
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	174 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	175
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	176 case "get":
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	177 switch ($type)
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	178 {
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	179 case "update":
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	180 echo stGetDisplayVar("lastUpdate");
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	181 break;
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	182
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	183 case "slide":
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	184 // Based on the currently active mode ...
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	185 switch (stGetDisplayVar("activeSlideMode"))
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	186 {
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	187 case SMODE_ROTATE:
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	188 // Slide rotation mode, display currently active slide
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	189 if (stGetDisplayVar("activeSlide") > 0)
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	190 {
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	191 $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d",
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	192 stGetDisplayVar("activeSlide"));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	193
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	194 if (($slide = stFetchSQL($sql)) !== false)
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	195 stPrintRotationSlide($slide);
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	196 }
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	197 else
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	198 {
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	199 echo "<div>ERROR!</div>\n";
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	200 }
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	201 break;
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	202
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	203 case SMODE_COMPO:
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	204 // Competition mode, show entry data
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	205 $compo = stFetchSQL(stPrepareSQL(
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	206 "SELECT * FROM compos WHERE id=%d",
148 6d4325451570 And some more work on the info system. Matti Hamalainen <ccr@tnsp.org> parents: 145 diff changeset	207 stGetDisplayVar("compoID")));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	208
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	209 $prev = stFetchSQL(stPrepareSQL(
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	210 "SELECT * FROM entries WHERE id=%d",
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	211 stGetDisplayVar("compoPrevEntry")));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	212
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	213 $entry = stFetchSQL(stPrepareSQL(
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	214 "SELECT * FROM entries WHERE id=%d",
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	215 stGetDisplayVar("compoCurrEntry")));
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	216
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	217 if ($compo !== false)
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	218 stPrintCompoSlide($compo, $entry, $prev);
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	219 break;
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	220 }
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	221 break;
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	222 }
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	223 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	224
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	225 default:
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	226 stSetStatus(404, "Not Found");
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	227 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	228 }
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	229
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	230
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	231 // Save changed variables
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	232 stSaveDisplayVars();
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	233 ?>

Mercurial > hg > fapweb

annotate showajax.php @ 163:1386a7a8816c