fapweb: showajax.php annotate

annotate showajax.php @ 511:6fe66ea0e954

Move most of the results code to site module, remove the support for HTML type output.

author	Matti Hamalainen <ccr@tnsp.org>
date	Sun, 08 Dec 2013 02:16:26 +0200
parents	e7566fafe9b1
children	8c1a53532be0

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 //
175 8df523e6326a User require_once instead of require. Matti Hamalainen <ccr@tnsp.org> parents: 163 diff changeset	7 require_once "mconfig.inc.php";
8df523e6326a User require_once instead of require. Matti Hamalainen <ccr@tnsp.org> parents: 163 diff changeset	8 require_once "msite.inc.php";
126 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
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	18 " <div class=\"entryTitle\">".$title."</div>\n";
139 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"])
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	25 {
3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	26 if ($title === false)
3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	27 echo " <div class=\"entryBy\">by</div>\n";
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	28 echo " <div class=\"entryAuthor\">".chentities($entry["author"])."</div>\n";
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	29 }
3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	30
3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	31 if ($title === false)
498 e7566fafe9b1 Use common formatting conversion for entry info texts. Matti Hamalainen <ccr@tnsp.org> parents: 497 diff changeset	32 echo " <div class=\"entryInfo\">".stConvertCommonDesc($entry["info"], TRUE)."</div>\n";
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>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	36 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	37
163 1386a7a8816c Whitespace cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 152 diff changeset	38
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	39 function stPrintCompoSlide($compo, $entry, $prev)
139 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 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	42 " <div class=\"compoHeader\">\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	43 " <img src=\"img/fapsm.png\" /><br />\n".
496 924eb55a98b6 Show "competition is starting" type text if no entries are set currently. Matti Hamalainen <ccr@tnsp.org> parents: 495 diff changeset	44 " <div class=\"compoTitle\">".chentities($compo["name"])." competition</div>\n";
924eb55a98b6 Show "competition is starting" type text if no entries are set currently. Matti Hamalainen <ccr@tnsp.org> parents: 495 diff changeset	45
924eb55a98b6 Show "competition is starting" type text if no entries are set currently. Matti Hamalainen <ccr@tnsp.org> parents: 495 diff changeset	46 if ($entry === false && $prev === false)
924eb55a98b6 Show "competition is starting" type text if no entries are set currently. Matti Hamalainen <ccr@tnsp.org> parents: 495 diff changeset	47 echo "<h1>... Is starting ...</h1>";
924eb55a98b6 Show "competition is starting" type text if no entries are set currently. Matti Hamalainen <ccr@tnsp.org> parents: 495 diff changeset	48
924eb55a98b6 Show "competition is starting" type text if no entries are set currently. Matti Hamalainen <ccr@tnsp.org> parents: 495 diff changeset	49 echo
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	50 " </div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	51
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	52 if ($entry !== false)
386 0693747fa7d3 Indent. Matti Hamalainen <ccr@tnsp.org> parents: 356 diff changeset	53 stPrintCompoEntry($entry, "compoNext", $compo, false);
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	54
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	55 if ($prev !== false)
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	56 stPrintCompoEntry($prev, "compoPrev", $compo, "Previous entry");
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
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	59
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	60 function stPrintRotationSlide($slide)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	61 {
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	62 echo
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	63 " <div class=\"showHeader\">\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	64 " <img src=\"img/fapsm.png\" /><br />\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	65 " </div>\n".
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	66 " <div class=\"showText\">\n".
140 20ca8edfb01a Rename some settings and variables. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	67 $slide["text"].
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	68 " </div>\n";
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	69 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	70
163 1386a7a8816c Whitespace cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 152 diff changeset	71
391 0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	72 function stGuruMeditation()
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	73 {
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	74 echo
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	75 "<div class=\"guru\">".
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	76 "Software Failure.   Press left mouse button to continue.<br />".
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	77 "Guru Meditation #00000004.0000AAC0".
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	78 "</div>\n";
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	79 }
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	80
0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	81
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	82 //
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	83 // Initialize
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	84 //
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	85 stSetupCacheControl();
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	86
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	87 if (!stConnectSQLDB())
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	88 die("Could not connect to SQL database.");
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	89
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	90 stReloadDisplayVars();
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	91
143 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 //
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	94 // 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	95 //
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	96 $updated = FALSE;
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	97
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	98 // Temporary slides are handled globally
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	99 if (stGetDisplayVar("tempDuration") > 0 &&
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	100 stGetDisplayVar("tempSlide") > 0 &&
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	101 stGetDisplayVar("tempSlideSet"))
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	102 {
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	103 $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	104 stGetDisplayVar("tempSlide"));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	105
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	106 if (($res = stFetchSQL($sql)) !== false)
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	107 {
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	108 stSetDisplayVar("tempSlideSet", FALSE);
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	109 stSetDisplayVar("activeSlideMode", SMODE_ROTATE);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	110 stSetDisplayVar("activeSlide", stGetDisplayVar("tempSlide"));
438 48903fd966cd Things are starting to work. Matti Hamalainen <ccr@tnsp.org> parents: 429 diff changeset	111 stSetDisplayVar("activeSlideExpire", time() + (stGetDisplayVar("tempDuration") * 60));
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	112 $updated = TRUE;
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	113 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	114 }
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	115 else
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	116 // 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	117 switch (stGetDisplayVar("showMode"))
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	118 {
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	119 case SMODE_ROTATE:
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	120 //
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	121 // Rotation / normal slide show mode
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	122 //
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	123 stSetDisplayVar("activeSlideMode", SMODE_ROTATE);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	124
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	125 if (stGetDisplayVar("rotateList") == 0)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	126 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	127 stSetDisplayVar("rotateList", 1);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	128 stSetDisplayVar("activeSlideExpire", 0);
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	129 $updated = TRUE;
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	130 }
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 if (time() >= stGetDisplayVar("activeSlideExpire") &&
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	133 stGetDisplayVar("rotateList") > 0)
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 // 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	136 $list = stGetDisplayVar("rotateList");
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	137 $sql = stPrepareSQL(
463 782866ee84e0 Jep. Matti Hamalainen <ccr@tnsp.org> parents: 438 diff changeset	138 "SELECT * FROM rotationListSlides WHERE list_id=%d ORDER BY order_num,id",
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	139 $list);
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 if (($slideList = stExecSQL($sql)) !== false)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	142 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	143 // Get slide at current index
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	144 $slides = array();
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	145 foreach ($slideList as $slide)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	146 $slides[] = $slide;
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 $index = stGetDisplayVar("rotateListIndex");
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	149 if (count($slides) > $index)
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	150 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	151 $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	152 if ($slide_id != stGetDisplayVar("activeSlide"))
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	153 {
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	154 stSetDisplayVar("activeSlide", $slide_id);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	155 stSetDisplayVar("activeSlideExpire", time() + stGetDisplayVar("rotateDuration"));
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	156 $updated = TRUE;
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	157 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	158 }
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	159
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	160 // Rotate to next slide
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	161 if (++$index >= count($slides))
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	162 $index = 0;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	163
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	164 stSetDisplayVar("rotateListIndex", $index);
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	165 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	166 }
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	167 break;
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	168
20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	169 case SMODE_COMPO:
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	170 //
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	171 // Competition mode, is controlled from admin UI, so we donẗ
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	172 // actually do anything here.
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	173 //
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	174 if (time() >= stGetDisplayVar("activeSlideExpire"))
497 570120074b3c Set updated flag in case the mode has changed and slide expires. Matti Hamalainen <ccr@tnsp.org> parents: 496 diff changeset	175 {
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	176 stSetDisplayVar("activeSlideMode", SMODE_COMPO);
497 570120074b3c Set updated flag in case the mode has changed and slide expires. Matti Hamalainen <ccr@tnsp.org> parents: 496 diff changeset	177 $updated = TRUE;
570120074b3c Set updated flag in case the mode has changed and slide expires. Matti Hamalainen <ccr@tnsp.org> parents: 496 diff changeset	178 }
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	179
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	180 break;
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	181 }
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	182
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	183 // 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	184 if ($updated)
407 eaea1ae2bc3d Moar work. Matti Hamalainen <ccr@tnsp.org> parents: 393 diff changeset	185 stDisplayUpdated();
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	186
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	187
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	188 //
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	189 // Serve the request
6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	190 //
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	191 $type = stGetRequestItem("type");
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	192 switch (stGetRequestItem("action"))
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	193 {
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	194 case "check":
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	195 // Check if there has been any change
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	196 $changed = stGetRequestItem("lastUpdate") != stGetDisplayVar("lastUpdate");
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	197 echo $changed ? "changed" : "nochange";
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	198 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	199
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	200 case "get":
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	201 switch ($type)
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	202 {
145 66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	203 case "update":
66b485431cac Change how slides are updated. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	204 echo stGetDisplayVar("lastUpdate");
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	205 break;
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	206
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	207 case "slide":
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	208 // Based on the currently active mode ...
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	209 switch (stGetDisplayVar("activeSlideMode"))
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	210 {
409 b320959477ef Yep. Matti Hamalainen <ccr@tnsp.org> parents: 407 diff changeset	211 case SMODE_DISABLED:
b320959477ef Yep. Matti Hamalainen <ccr@tnsp.org> parents: 407 diff changeset	212 stGuruMeditation();
b320959477ef Yep. Matti Hamalainen <ccr@tnsp.org> parents: 407 diff changeset	213 break;
b320959477ef Yep. Matti Hamalainen <ccr@tnsp.org> parents: 407 diff changeset	214
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	215 case SMODE_ROTATE:
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	216 // Slide rotation mode, display currently active slide
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	217 if (stGetDisplayVar("activeSlide") > 0)
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	218 {
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	219 $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d",
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	220 stGetDisplayVar("activeSlide"));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	221
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	222 if (($slide = stFetchSQL($sql)) !== false)
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	223 stPrintRotationSlide($slide);
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	224 }
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	225 else
391 0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	226 stGuruMeditation();
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	227 break;
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	228
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	229 case SMODE_COMPO:
152 6e6fba2da3d1 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	230 // Competition mode, show entry data
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	231 $compo_id = stGetDisplayVar("compoID");
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	232 $compo = stFetchSQL(stPrepareSQL(
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	233 "SELECT * FROM compos WHERE id=%d",
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	234 $compo_id));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	235
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	236 $prev = stFetchSQL(stPrepareSQL(
495 87d8f05fcf77 Don't show anything if show_id of entry is 0. Matti Hamalainen <ccr@tnsp.org> parents: 463 diff changeset	237 "SELECT * FROM entries WHERE compo_id=%d AND show_id=%d AND show_id<>0",
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	238 $compo_id, stGetDisplayVar("compoPrevEntry")));
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	239
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	240 $entry = stFetchSQL(stPrepareSQL(
495 87d8f05fcf77 Don't show anything if show_id of entry is 0. Matti Hamalainen <ccr@tnsp.org> parents: 463 diff changeset	241 "SELECT * FROM entries WHERE compo_id=%d AND show_id=%d AND show_id<>0",
387 3cc078b17260 Show backend work. Matti Hamalainen <ccr@tnsp.org> parents: 386 diff changeset	242 $compo_id, stGetDisplayVar("compoCurrEntry")));
144 c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	243
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	244 if ($compo !== false)
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	245 stPrintCompoSlide($compo, $entry, $prev);
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	246 break;
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	247 }
c030c3cf0d80 More work on display system. Matti Hamalainen <ccr@tnsp.org> parents: 143 diff changeset	248 break;
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	249 }
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	250 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	251
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	252 default:
391 0c1798c9d486 Add disabled mode. Matti Hamalainen <ccr@tnsp.org> parents: 387 diff changeset	253 stGuruMeditation();
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	254 break;
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	255 }
71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	256
139 75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	257
75cf14ee99a7 More work on party information system. Matti Hamalainen <ccr@tnsp.org> parents: 136 diff changeset	258 // Save changed variables
143 20893a5442b7 Move some functions to site module, and use them. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	259 stSaveDisplayVars();
211 5bae42020034 Factorize some code into msitegen. Matti Hamalainen <ccr@tnsp.org> parents: 175 diff changeset	260
417 d2ece5d0aaa4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 416 diff changeset	261 //stDumpAJAXStatusErrors();
126 71c35d5302c2 More work on cleanups, and AJAX modularization. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	262 ?>

Mercurial > hg > fapweb

annotate showajax.php @ 511:6fe66ea0e954