fapweb: dbdefs.inc.php annotate

annotate dbdefs.inc.php @ 1094:563fc90de965

Move 'voting enabled' global setting back to general settings.

author	Matti Hamalainen <ccr@tnsp.org>
date	Thu, 26 Jan 2017 14:03:38 +0200
parents	95b74632cfe2
children	bbc0a3d0b51e

rev	line source
1074 48e16e856646 Use long tags. Matti Hamalainen <ccr@tnsp.org> parents: 1041 diff changeset	1 <?php
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	2
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	3 $dbVersion = 31;
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	4
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	5 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	6 // Site settings and defaults we put in
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	7 //
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	8 $siteSettingsGroups = array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	9 "general" => array("General", "General settings"),
633 8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	10 "html" => array("Site HTML", "Global HTML blurbs"),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	11 "news" => array("News", "News related settings"),
633 8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	12 "register" => array("Registration", "Visitor registration"),
8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	13 "event" => array("Event / Schedule", "Event and schedule related settings"),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	14 "compos" => array("Compos", "Compo related settings"),
710 27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	15 "voting" => array("Voting", "Voting related settings"),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	16 );
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	17
633 8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	18
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	19 $siteDefaultSettings = array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	20
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	21 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	22 // General site settings
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	23 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	24 "general" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	25 "maxAttendeesHard" => array(VT_INT, 60, "Maximum attendees (HARD limit, <= 0 means no limit)"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	26 "maxAttendeesSoft" => array(VT_INT, 50, "Maximum attendees (soft limit, <= 0 means no limit)"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	27
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	28 "userTimeout" => array(VT_INT, 120, "User pages (voting) timeout in minutes"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	29 "admTimeout" => array(VT_INT, 15, "Administration interface timeout in minutes"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	30
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	31 "showAdmin" => array(VT_BOOL, false, "Always show administration interface link on the menu"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	32 "showAttendees" => array(VT_BOOL, true, "Show attendees list"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	33
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	34 "showResults" => array(VT_BOOL, false, "Enable results page"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	35
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	36 "showInfoTextOnAbout" => array(VT_BOOL, false, "Show site info HTML on About page"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	37
633 8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	38 "requireEMail" => array(VT_BOOL, false, "Require e-mail address in registrations"),
8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	39 "allowRegister" => array(VT_BOOL, false, "Enable event registration"),
1094 563fc90de965 Move 'voting enabled' global setting back to general settings. Matti Hamalainen <ccr@tnsp.org> parents: 1092 diff changeset	40
563fc90de965 Move 'voting enabled' global setting back to general settings. Matti Hamalainen <ccr@tnsp.org> parents: 1092 diff changeset	41 "allowVoting" => array(VT_BOOL, false, "Enable voting (individual compos must be enabled as well)"),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	42 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	43
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	44 "html" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	45 "siteMenuHeader" => array(VT_TEXT, "<div>13.FAP:> <span class=\"mblink\">■</span></div>", "Site menu header text"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	46 "siteMenuFooter" => array(VT_TEXT, "", "Site menu footer text"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	47 "siteExtraHTML" => array(VT_TEXT, "<div id=\"sponsors\">Gentle Eye</div>", "Extra global HTML code (f.e. sponsors box)"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	48
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	49 "siteInfoText" => array(VT_TEXT, "
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	50 <a href=\"about\">
788 da0ddfe1b704 s/2013/2014/ Matti Hamalainen <ccr@tnsp.org> parents: 762 diff changeset	51 <img src=\"img/fapsm.png\" alt=\"Finnish Amiga Party 2014\" class=\"logo\" /></a>
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	52 <div id=\"date\">
788 da0ddfe1b704 s/2013/2014/ Matti Hamalainen <ccr@tnsp.org> parents: 762 diff changeset	53 5.-8.12.2014<br />
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	54 Helsinki, Finland<br />
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	55 @ old location<br />
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	56 <span class=\"notice\">Entry 15 EUR + prod</span>
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	57 </div>", "Site header text"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	58
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	59 "aboutDescription" => array(VT_TEXT, "
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	60 <div style=\"text-align: center;\">
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	61 <img src=\"img/fap.png\" alt=\"FAP\" />
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	62 <p>
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	63 Pure Amiga demoscene party, all traditional Amiga compos and purely Amiga-oriented program.
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	64 <br />
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	65 <span class=\"notice\">
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	66 YOU <b>MUST</b> HAVE AT LEAST ONE ENTRY TO COMPETITIONS IF YOU COME TO THE PARTY.
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	67 </span>
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	68 </p>
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	69 </div>",
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	70 "About page text"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	71
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	72 ),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	73
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	74 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	75 // News related
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	76 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	77 "news" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	78 "showNews" => array(VT_BOOL, true, "Enable News link on main menu + News page"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	79 "showNewsOnAbout" => array(VT_BOOL, true, "Show latest news item on About page"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	80 "newsHeader" => array(VT_TEXT, "", "News page header text"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	81 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	82
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	83 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	84 // Attendee/visitor registration
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	85 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	86 "register" => array(
659 1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	87 "visitorsPageRegLink" => array(VT_TEXT, "
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	88 <div class=\"reglink\">
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	89 To register, use <a href=\"register\">this form</a>.
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	90 </div>
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	91 ", "Visitors page registration link blurb"),
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	92
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	93 "registerPageBlurb" => array(VT_TEXT, "
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	94 <h1>Registration</h1>
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	95 ", "Registration page header"),
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	96
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	97 "registerInfoText" => array(VT_TEXT, "<p>
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	98 Only your <b>handle</b> and the answer to the botcheck are strictly required.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	99 If you plan on joining the IRC channel
788 da0ddfe1b704 s/2013/2014/ Matti Hamalainen <ccr@tnsp.org> parents: 762 diff changeset	100 (<a href=\"irc://#fap2014@ircnet\">#fap2014 @ IRCNet</a>) or staying up to date by other means,
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	101 <b>e-mail</b> is not required either.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	102 </p>", "Registration page info text"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	103
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	104 "registerPostText" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	105 <h1>Registration successful</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	106 <p>Now go make a demo about it!</p>",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	107 "Successful post-registration note text"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	108
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	109 "registerLimitExceeded" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	110 <h1>Sorry, registration disabled!</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	111 <p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	112 Registration to the event is not available at this time due to
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	113 number of attendees limit having been reached. <b>:(</b>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	114 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	115 ",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	116 "Registration attendee limit exceeded note text"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	117
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	118 "registerNotEnabled" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	119 <h1>Sorry, registration disabled!</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	120 <p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	121 Registration to the event is not enabled at this time.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	122 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	123 ",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	124 "Registration not enabled note text"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	125
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	126 "registerPostNoEmail" => array(VT_TEXT, "
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	127 <h2>By the way ...</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	128 <p>As you did not specify an e-mail contact address, you'll have to get updates
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	129 and information about the location (if you don't already know it) by
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	130 some other means (IRC, for example.)</p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	131 ", "No e-mail address registration note"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	132
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	133 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	134
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	135 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	136 // Event / schedule information
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	137 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	138 "event" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	139 "showSchedule" => array(VT_BOOL, true, "Enable Schedule link on main menu + Schedule page"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	140
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	141 "eventDescription" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	142 <h1>Event program & schedule</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	143 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	144 <li><b>Aegis</b> of DSS and FAG will be performing a DJ gig.</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	145 <li>.. and possible additional live acts. More info to come.</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	146 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	147
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	148 <h2>Friday 30.11.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	149 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	150 <li><b>18:00</b> - <i>Doors open</i>.</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	151 <li><b>22:00</b> - DJ set by Aegis.</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	152 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	153
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	154 <h2>Saturday 1.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	155 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	156 <li><b>14:00</b> - Deadline for remote entries.</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	157 <li><b>18:00</b> - Deadline for the entries delivered on location.</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	158 <li><b>20:00</b> - Competitions start.</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	159 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	160
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	161 Competition schedule and voting deadline will depend on number of entries.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	162
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	163 <h2>Sunday 2.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	164 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	165 <li><b>12:00</b> - Party over?</li>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	166 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	167 ", "Event general description / timetables etc."),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	168
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	169 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	170
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	171 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	172 // Competitions
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	173 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	174 "compos" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	175 "showCompos" => array(VT_BOOL, true, "Enable Compos link on main menu + Compos page"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	176
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	177 "compoDescription" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	178 <h1>General</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	179 <p class=\"notice\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	180 YOU <b>MUST</b> HAVE AT LEAST ONE ENTRY TO COMPETITIONS IF YOU COME TO THE PARTY.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	181 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	182
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	183 <p class=\"note\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	184 If there are enough entries, then AGA/OCS/ECS demos will be run in separate compos.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	185 <br />
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	186 Remote entries are welcome!
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	187 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	188
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	189 <p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	190 The compo machine will be an <b>A1200 with an 060/50 and lots of
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	191 RAM</b>. An <b>A500 1.3 512k/512k</b> will also be available if your
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	192 prod is not AGA compatible.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	193 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	194
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	195 <h1>Compos</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	196 ", "Compo general description"),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	197 ),
710 27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	198
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	199 //
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	200 // Voting
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	201 //
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	202 "voting" => array(
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	203
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	204 "voteFinishedText" => array(VT_TEXT, "
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	205 <h1>Yay, you have voted!</h1>
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	206 <p>Now go FAP some more! And make a demo about it.</p>
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	207 <p>Or perhaps <a href=\"vote\">vote again!</a></p>
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	208 ",
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	209 "Message shown after successful voting"),
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	210
789 24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	211 "votingDisabled" => array(VT_TEXT, "
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	212 <h1>Sorry, voting disabled!</h1>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	213 <p>Voting functionality not available at this time.</p>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	214 ",
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	215 "Error message for voting disabled"),
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	216
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	217 "voteAuthError" => array(VT_TEXT, "
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	218 <h1>Not authenticated to vote</h1>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	219 <p>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	220 You are not authenticated currently. <a href=\"vote\">Try to login again.</a>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	221 </p>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	222 ",
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	223 "Error message for vote auth failure"),
710 27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	224 ),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	225 );
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	226
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	227
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	228 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	229 // Database table definitions
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	230 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	231 $sqlTables = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	232 // Site settings
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	233 "settings_groups" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	234 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	235 array("name" , "VARCHAR(64)"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	236 array("description" , "VARCHAR(128)"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	237 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	238
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	239 "settings" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	240 array("key" , "VARCHAR(32)", "PRIMARY KEY"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	241 array("vtype" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	242 array("vstr" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	243 array("vtext" , "TEXT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	244 array("vint" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	245 array("sdesc" , "VARCHAR(128)"),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	246 array("vgroup" , "INT"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	247 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	248
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	249 "news" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	250 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	251 array("utime" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	252 array("title" , "VARCHAR(".SET_LEN_NEWS_TITLE.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	253 array("text" , "VARCHAR(".SET_LEN_NEWS_TEXT.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	254 array("author" , "VARCHAR(".SET_LEN_NEWS_AUTHOR.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	255 array("persist" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	256 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	257
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	258 "compos" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	259 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	260 array("name" , "VARCHAR(".SET_LEN_COMPO_NAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	261 array("description" , "VARCHAR(".SET_LEN_COMPO_DESC.")"),
977 a1da651a2e45 Add compo notes field. Matti Hamalainen <ccr@tnsp.org> parents: 883 diff changeset	262 array("notes" , "VARCHAR(".SET_LEN_COMPO_NOTES.")"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	263 array("visible" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	264 array("voting" , "INT", "DEFAULT 0"),
705 45750a346f3e Add default preview_type for compos, and remove preview_file element from Matti Hamalainen <ccr@tnsp.org> parents: 696 diff changeset	265
1034 8fecb417e6a9 Reintroduce per-entry preview_type. Matti Hamalainen <ccr@tnsp.org> parents: 981 diff changeset	266 // Default preview type (see EFILE_* in msite.inc.php) for this compo.
8fecb417e6a9 Reintroduce per-entry preview_type. Matti Hamalainen <ccr@tnsp.org> parents: 981 diff changeset	267 // Global for the compo (entry-specific overrides if it is != EFILE_NONE)
705 45750a346f3e Add default preview_type for compos, and remove preview_file element from Matti Hamalainen <ccr@tnsp.org> parents: 696 diff changeset	268 array("preview_type" , "INT", "DEFAULT 0"),
45750a346f3e Add default preview_type for compos, and remove preview_file element from Matti Hamalainen <ccr@tnsp.org> parents: 696 diff changeset	269
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	270 array("show_authors" , "INT", "DEFAULT 0"),
695 dff9b125f774 Work on results printing and remove "show authors" option as it is rather Matti Hamalainen <ccr@tnsp.org> parents: 659 diff changeset	271 // Show author(s) on compo main screen/voting page for COMPO_NORMAL compos
dff9b125f774 Work on results printing and remove "show authors" option as it is rather Matti Hamalainen <ccr@tnsp.org> parents: 659 diff changeset	272 // For COMPO_POINTS and COMPO_ASSIGN, show on results page or not
705 45750a346f3e Add default preview_type for compos, and remove preview_file element from Matti Hamalainen <ccr@tnsp.org> parents: 696 diff changeset	273
640 c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item Matti Hamalainen <ccr@tnsp.org> parents: 633 diff changeset	274 array("ctype" , "INT", "DEFAULT 0"),
c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item Matti Hamalainen <ccr@tnsp.org> parents: 633 diff changeset	275 array("cpath" , "VARCHAR(".SET_LEN_COMPO_PATH.")"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	276 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	277
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	278 "entries" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	279 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	280 array("show_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	281 array("name" , "VARCHAR(".SET_LEN_ENTRY_NAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	282 array("author" , "VARCHAR(".SET_LEN_ENTRY_AUTHOR.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	283 array("compo_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	284 array("info" , "VARCHAR(".SET_LEN_ENTRY_INFO.")", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	285 array("notes" , "VARCHAR(".SET_LEN_ENTRY_NOTES.")", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	286 array("flags" , "INT", "DEFAULT 0"),
622 b58495c2d01a Add new field in entries table. Matti Hamalainen <ccr@tnsp.org> parents: 620 diff changeset	287 array("evalue" , "INT", "DEFAULT 0"),
846 e0c9bf182bb7 More work, another database change :S Matti Hamalainen <ccr@tnsp.org> parents: 825 diff changeset	288 array("file_id" , "INT", "DEFAULT 0"), // uploaded file id from "files" table
e0c9bf182bb7 More work, another database change :S Matti Hamalainen <ccr@tnsp.org> parents: 825 diff changeset	289 array("preview_id" , "INT", "DEFAULT 0"), // uploaded preview file id from "files" table
1034 8fecb417e6a9 Reintroduce per-entry preview_type. Matti Hamalainen <ccr@tnsp.org> parents: 981 diff changeset	290 array("preview_type" , "INT", "DEFAULT 0"), // see EFILE_*, overrides compo's general type if != 0
821 f27dccdde8ef Partially remove old filename stuff from entries. Still some vestiges Matti Hamalainen <ccr@tnsp.org> parents: 789 diff changeset	291 array("utime" , "INT", "DEFAULT 0"),
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	292 array("owner_id" , "INT", "DEFAULT 0"), // 0 = admin, otherwise userkey id
821 f27dccdde8ef Partially remove old filename stuff from entries. Still some vestiges Matti Hamalainen <ccr@tnsp.org> parents: 789 diff changeset	293 ),
822 fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	294
fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	295 "files" => array(
fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	296 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	297 array("filename" , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"), // stored filename
846 e0c9bf182bb7 More work, another database change :S Matti Hamalainen <ccr@tnsp.org> parents: 825 diff changeset	298 array("origname" , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"), // original uploaded filename
822 fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	299 array("filetype" , "VARCHAR(32)", "DEFAULT NULL"), // type of the file, if any, as key from $fileTypeData
872 5e9958f78b16 More work. Matti Hamalainen <ccr@tnsp.org> parents: 849 diff changeset	300 array("uploadtype" , "VARCHAR(32)", "DEFAULT NULL"), // "preview", "entry"
822 fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	301 array("filesize" , "INT", "DEFAULT 0"), // uploaded size
fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	302 array("entry_id" , "INT", "DEFAULT 0"), // belongs to this entry (0 = none)
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	303 array("uploader_id" , "INT", "DEFAULT 0"), // 0 = admin, otherwise userkey id
872 5e9958f78b16 More work. Matti Hamalainen <ccr@tnsp.org> parents: 849 diff changeset	304 array("deleted" , "INT", "DEFAULT 0"), // 1 = to be deleted
822 fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	305 array("utime" , "INT", "DEFAULT 0"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	306 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	307
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	308 "attendees" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	309 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	310 array("regtime" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	311 array("name" , "VARCHAR(".SET_LEN_USERNAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	312 array("groups" , "VARCHAR(".SET_LEN_GROUPS.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	313 array("oneliner" , "VARCHAR(".SET_LEN_ONELINER.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	314 array("email" , "VARCHAR(".SET_LEN_EMAIL.")"),
716 e7fbcf4190e6 Add registration host. Matti Hamalainen <ccr@tnsp.org> parents: 710 diff changeset	315 array("reghost" , "VARCHAR(".SET_LEN_REGHOST.")", "DEFAULT NULL"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	316 array("key_id" , "INT", "DEFAULT NULL"),
883 782c42dfc465 Add usr and adm flag fields to users. Matti Hamalainen <ccr@tnsp.org> parents: 872 diff changeset	317 array("usr_flags" , "INT", "DEFAULT 0"),
782c42dfc465 Add usr and adm flag fields to users. Matti Hamalainen <ccr@tnsp.org> parents: 872 diff changeset	318 array("adm_flags" , "INT", "DEFAULT 0"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	319 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	320
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	321 "userkeys" => array(
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	322 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	323 array("key" , "VARCHAR(".SET_LEN_USERKEY.")"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	324 array("active" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	325 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	326
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	327 "votes" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	328 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	329 array("entry_id" , "INT", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	330 array("key_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	331 array("value" , "INT", "DEFAULT 0"),
762 539bfbdd43ec Add timestamps to votes, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 716 diff changeset	332 array("utime" , "INT", "DEFAULT 0"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	333 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	334
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	335
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	336 // Party information system tables
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	337 "display_vars" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	338 array("key" , "VARCHAR(32)", "PRIMARY KEY"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	339 array("vtype" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	340 array("vstr" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	341 array("vtext" , "TEXT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	342 array("vint" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	343 array("sdesc" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	344 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	345
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	346 "display_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	347 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	348 array("title" , "VARCHAR(".SET_LEN_DISP_SLIDE_TITLE.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	349 array("text" , "VARCHAR(".SET_LEN_DISP_SLIDE_TEXT.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	350 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	351
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	352 "rot_list_data" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	353 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	354 array("name" , "VARCHAR(".SET_LEN_ROT_LIST_NAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	355 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	356
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	357 "rot_list_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	358 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	359 array("list_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	360 array("slide_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	361 array("order_num" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	362 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	363 );
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	364
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	365
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	366 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	367 // Party information system settings / data
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	368 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	369 $siteDisplayVars = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	370 "showMode" => array(VT_INT, 0, "Currently active display mode"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	371 "rotateDuration" => array(VT_INT, 15, "Slide rotation time per slide (seconds)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	372
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	373 "tempDuration" => array(VT_INT, 5, "Temporary slide display time (minutes)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	374 "tempSlide" => array(VT_INT, 0, "Temporary slide ID"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	375
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	376 "compoID" => array(VT_INT, 0, "Compo ID of current compo"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	377 "compoPrevEntry" => array(VT_INT, 0, "Previously shown compo entry"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	378 "compoCurrEntry" => array(VT_INT, 0, "Current / next compo entry to be shown"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	379
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	380 // Not user-manageable
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	381 "tempSlideSet" => array(VT_BOOL, false, "Temporary slide set"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	382
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	383 "activeSlideMode" => array(VT_INT, 0, "Current active slide display mode"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	384 "activeSlide" => array(VT_INT, 0, "Current active slide"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	385 "activeSlideExpire" => array(VT_INT, 0, "Expiration timestamp of current slide"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	386
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	387 "rotateList" => array(VT_INT, 0, "Current rotation list ID"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	388 "rotateListIndex" => array(VT_INT, 0, "Current index in rotation list"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	389
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	390 "lastUpdate" => array(VT_INT, 0, "Timestamp of last slide update"),
1041 f188caaedf0f Implement force reloading of show screen web-page. Matti Hamalainen <ccr@tnsp.org> parents: 1034 diff changeset	391
f188caaedf0f Implement force reloading of show screen web-page. Matti Hamalainen <ccr@tnsp.org> parents: 1034 diff changeset	392 "screenCmd" => array(VT_STR, "", "Off-channel showscreen command"),
f188caaedf0f Implement force reloading of show screen web-page. Matti Hamalainen <ccr@tnsp.org> parents: 1034 diff changeset	393 "screenCmdSet" => array(VT_BOOL, false, "Off-channel showscreen command has been set"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	394 );
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	395
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	396
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	397 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	398 // Some premade test data
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	399 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	400 $siteTestData = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	401 "news" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	402 "utime,title,text,author",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	403 time().",%s,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	404 array("Today's news", "We. Are. Back.", "orgaz"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	405 array("Good news, everybody!", "...", "The Professor"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	406 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	407
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	408 "userkeys" => array(
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	409 "key",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	410 "%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	411 array("test1"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	412 array("test2"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	413 array("7jjnqt5z"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	414 array("c7jcfk1G"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	415 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	416
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	417 "attendees" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	418 "regtime,name,groups,oneliner,email",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	419 "%d,%s,%s,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	420 array(time()-0, "man with no alias", "supergroup", "foo-bar", "c@supergroup.com"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	421 array(time()-15, "man with alias", "supergroup", "hi!", "c@supergroup.com"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	422 array(time()-30, "alias with a man", "supergroup", "mega super kewl rulets", "x@microsoft.com"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	423 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	424
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	425 "compos" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	426 "name,description,visible,voting",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	427 "%s,%s,1,1",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	428 array("Graphics", "Anything in standard resolutions."),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	429 array("Protracker music", "Standard 4-channel Protracker MOD music."),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	430 array("4k intro", "4k intro competition"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	431 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	432
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	433 "entries" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	434 "name,author,compo_id,filename,info",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	435 "%s,%s,%d,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	436 array("Donkey Dong", "electric/extend", 1, "donkey.lbm", "amigaaaah!"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	437 array("Your kondom", "ccr/TNSP", 1, "kondom.lbm", "oh my god, it's full of cocks!"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	438 array("Penis song", "reed/flt", 2, "penis.mod", "laulu rakkaudelle"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	439 array("jenkka", "aegis", 2, "jenkka.mod", ""),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	440 array("Fungiform 2", "mfx", 3, "mfx-fungiform2.lzh", "OCS-only"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	441 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	442
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	443 "display_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	444 "title,text",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	445 "%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	446 array("Next Up 4k", "<h1>Next up: 4k intro</h1><h2>4k intro compo is about to begin</h2>... in about 10 minutes."),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	447 array("Astu to infodesk", "<b>Astu</b> - please come to info desk!"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	448 array("Gentle Eye mainos", "<b>Buy Amiga stuff!</b><br />Gentle Eye Oy is selling Amiga-related stuff near organizer desk!"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	449 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	450
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	451 "rot_list_data" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	452 "name",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	453 "%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	454 array("Main rotation"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	455 array("Next Up"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	456 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	457
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	458 "rot_list_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	459 "list_id,slide_id",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	460 "%d,%d",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	461 array(1,2),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	462 array(1,3),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	463 array(2,1),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	464 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	465 );
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	466
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	467
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	468 $upgradeMappings = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	469 // "" => array("key" => "", value => ""),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	470 12 => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	471 "show_authors" => array("key" => "showAuthors"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	472 "display_vars" => array("table" => "displayVars"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	473 "display_slides" => array("table" => "displaySlides"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	474 "rot_list_data" => array("table" => "rotationListData"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	475 "rot_list_slides" => array("table" => "rotationListSlides"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	476 ),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	477
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	478 14 => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	479 "settings_groups" => array("table" => FALSE),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	480 ),
640 c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item Matti Hamalainen <ccr@tnsp.org> parents: 633 diff changeset	481
c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item Matti Hamalainen <ccr@tnsp.org> parents: 633 diff changeset	482 17 => array(
c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item Matti Hamalainen <ccr@tnsp.org> parents: 633 diff changeset	483 "ctype" => array("key" => "type"),
c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item Matti Hamalainen <ccr@tnsp.org> parents: 633 diff changeset	484 "cpath" => array("key" => "path"),
c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item Matti Hamalainen <ccr@tnsp.org> parents: 633 diff changeset	485 ),
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	486
95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	487 31 => array(
95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	488 "userkeys" => array("table" => "votekeys"),
95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	489 ),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	490 );
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	491
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	492
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	493 ?>

Mercurial > hg > fapweb

annotate dbdefs.inc.php @ 1094:563fc90de965