fapweb: dbdefs.inc.php annotate

annotate dbdefs.inc.php @ 1092:95b74632cfe2

Rename votekeys table to userkeys, and all related variables and settings.

author	Matti Hamalainen <ccr@tnsp.org>
date	Thu, 26 Jan 2017 13:38:19 +0200
parents	48e16e856646
children	563fc90de965

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"),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	40 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	41
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	42 "html" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	43 "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	44 "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	45 "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	46
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	47 "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	48 <a href=\"about\">
788 da0ddfe1b704 s/2013/2014/ Matti Hamalainen <ccr@tnsp.org> parents: 762 diff changeset	49 <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	50 <div id=\"date\">
788 da0ddfe1b704 s/2013/2014/ Matti Hamalainen <ccr@tnsp.org> parents: 762 diff changeset	51 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	52 Helsinki, Finland<br />
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	53 @ old location<br />
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	54 <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	55 </div>", "Site header text"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	56
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	57 "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	58 <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	59 <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	60 <p>
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	61 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	62 <br />
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	63 <span class=\"notice\">
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	64 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	65 </span>
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	66 </p>
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	67 </div>",
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	68 "About page text"),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	69
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	70 ),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	71
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	72 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	73 // News related
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" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	76 "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	77 "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	78 "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	79 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	80
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 // Attendee/visitor registration
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 "register" => array(
659 1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	85 "visitorsPageRegLink" => array(VT_TEXT, "
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	86 <div class=\"reglink\">
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	87 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	88 </div>
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	89 ", "Visitors page registration link blurb"),
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	90
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	91 "registerPageBlurb" => array(VT_TEXT, "
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	92 <h1>Registration</h1>
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	93 ", "Registration page header"),
1702a5e0b9c3 Add new settings for certain HTML pieces. Matti Hamalainen <ccr@tnsp.org> parents: 640 diff changeset	94
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	95 "registerInfoText" => array(VT_TEXT, "<p>
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	96 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	97 If you plan on joining the IRC channel
788 da0ddfe1b704 s/2013/2014/ Matti Hamalainen <ccr@tnsp.org> parents: 762 diff changeset	98 (<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	99 <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	100 </p>", "Registration page info text"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	101
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	102 "registerPostText" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	103 <h1>Registration successful</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	104 <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	105 "Successful post-registration note text"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	106
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	107 "registerLimitExceeded" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	108 <h1>Sorry, registration disabled!</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	109 <p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	110 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	111 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	112 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	113 ",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	114 "Registration attendee limit exceeded note text"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	115
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	116 "registerNotEnabled" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	117 <h1>Sorry, registration disabled!</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	118 <p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	119 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	120 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	121 ",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	122 "Registration not enabled note text"),
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 "registerPostNoEmail" => array(VT_TEXT, "
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	125 <h2>By the way ...</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	126 <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	127 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	128 some other means (IRC, for example.)</p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	129 ", "No e-mail address registration note"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	130
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	131 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	132
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 // Event / schedule information
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" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	137 "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	138
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	139 "eventDescription" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	140 <h1>Event program & schedule</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	141 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	142 <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	143 <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	144 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	145
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	146 <h2>Friday 30.11.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	147 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	148 <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	149 <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	150 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	151
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	152 <h2>Saturday 1.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	153 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	154 <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	155 <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	156 <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	157 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	158
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	159 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	160
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	161 <h2>Sunday 2.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	162 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	163 <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	164 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	165 ", "Event general description / timetables etc."),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	166
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	167 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	168
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 // Competitions
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 "compos" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	173 "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	174
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	175 "compoDescription" => array(VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	176 <h1>General</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	177 <p class=\"notice\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	178 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	179 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	180
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	181 <p class=\"note\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	182 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	183 <br />
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	184 Remote entries are welcome!
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	185 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	186
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 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	189 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	190 prod is not AGA compatible.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	191 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	192
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	193 <h1>Compos</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	194 ", "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	195 ),
710 27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	196
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	197 //
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	198 // Voting
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" => array(
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	201 "allowVoting" => array(VT_BOOL, false, "Enable voting (individual compos must be enabled as well)"),
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	202
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	203 "voteFinishedText" => array(VT_TEXT, "
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	204 <h1>Yay, you have voted!</h1>
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	205 <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	206 <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	207 ",
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	208 "Message shown after successful voting"),
27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	209
789 24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	210 "votingDisabled" => array(VT_TEXT, "
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	211 <h1>Sorry, voting disabled!</h1>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	212 <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	213 ",
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	214 "Error message for voting disabled"),
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	215
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	216 "voteAuthError" => array(VT_TEXT, "
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	217 <h1>Not authenticated to vote</h1>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	218 <p>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	219 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	220 </p>
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	221 ",
24bbd1f89794 Add few new settings, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 788 diff changeset	222 "Error message for vote auth failure"),
710 27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	223 ),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	224 );
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 // Database table definitions
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	229 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	230 $sqlTables = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	231 // Site settings
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	232 "settings_groups" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	233 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	234 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	235 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	236 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	237
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	238 "settings" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	239 array("key" , "VARCHAR(32)", "PRIMARY KEY"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	240 array("vtype" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	241 array("vstr" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	242 array("vtext" , "TEXT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	243 array("vint" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	244 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	245 array("vgroup" , "INT"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	246 ),
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 "news" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	249 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	250 array("utime" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	251 array("title" , "VARCHAR(".SET_LEN_NEWS_TITLE.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	252 array("text" , "VARCHAR(".SET_LEN_NEWS_TEXT.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	253 array("author" , "VARCHAR(".SET_LEN_NEWS_AUTHOR.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	254 array("persist" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	255 ),
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 "compos" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	258 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	259 array("name" , "VARCHAR(".SET_LEN_COMPO_NAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	260 array("description" , "VARCHAR(".SET_LEN_COMPO_DESC.")"),
977 a1da651a2e45 Add compo notes field. Matti Hamalainen <ccr@tnsp.org> parents: 883 diff changeset	261 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	262 array("visible" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	263 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	264
1034 8fecb417e6a9 Reintroduce per-entry preview_type. Matti Hamalainen <ccr@tnsp.org> parents: 981 diff changeset	265 // 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	266 // 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	267 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	268
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	269 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	270 // 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	271 // 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	272
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	273 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	274 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	275 ),
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 "entries" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	278 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	279 array("show_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	280 array("name" , "VARCHAR(".SET_LEN_ENTRY_NAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	281 array("author" , "VARCHAR(".SET_LEN_ENTRY_AUTHOR.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	282 array("compo_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	283 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	284 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	285 array("flags" , "INT", "DEFAULT 0"),
622 b58495c2d01a Add new field in entries table. Matti Hamalainen <ccr@tnsp.org> parents: 620 diff changeset	286 array("evalue" , "INT", "DEFAULT 0"),
846 e0c9bf182bb7 More work, another database change :S Matti Hamalainen <ccr@tnsp.org> parents: 825 diff changeset	287 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	288 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	289 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	290 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	291 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	292 ),
822 fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	293
fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	294 "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	295 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	296 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	297 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	298 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	299 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	300 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	301 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	302 array("uploader_id" , "INT", "DEFAULT 0"), // 0 = admin, otherwise userkey id
872 5e9958f78b16 More work. Matti Hamalainen <ccr@tnsp.org> parents: 849 diff changeset	303 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	304 array("utime" , "INT", "DEFAULT 0"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	305 ),
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 "attendees" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	308 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	309 array("regtime" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	310 array("name" , "VARCHAR(".SET_LEN_USERNAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	311 array("groups" , "VARCHAR(".SET_LEN_GROUPS.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	312 array("oneliner" , "VARCHAR(".SET_LEN_ONELINER.")"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	313 array("email" , "VARCHAR(".SET_LEN_EMAIL.")"),
716 e7fbcf4190e6 Add registration host. Matti Hamalainen <ccr@tnsp.org> parents: 710 diff changeset	314 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	315 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	316 array("usr_flags" , "INT", "DEFAULT 0"),
782c42dfc465 Add usr and adm flag fields to users. Matti Hamalainen <ccr@tnsp.org> parents: 872 diff changeset	317 array("adm_flags" , "INT", "DEFAULT 0"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	318 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	319
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	320 "userkeys" => array(
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	321 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	322 array("key" , "VARCHAR(".SET_LEN_USERKEY.")"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	323 array("active" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	324 ),
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 "votes" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	327 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	328 array("entry_id" , "INT", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	329 array("key_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	330 array("value" , "INT", "DEFAULT 0"),
762 539bfbdd43ec Add timestamps to votes, bump database version. Matti Hamalainen <ccr@tnsp.org> parents: 716 diff changeset	331 array("utime" , "INT", "DEFAULT 0"),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	332 ),
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 // Party information system tables
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	336 "display_vars" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	337 array("key" , "VARCHAR(32)", "PRIMARY KEY"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	338 array("vtype" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	339 array("vstr" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	340 array("vtext" , "TEXT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	341 array("vint" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	342 array("sdesc" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	343 ),
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 "display_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	346 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	347 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	348 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	349 ),
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 "rot_list_data" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	352 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	353 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	354 ),
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 "rot_list_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	357 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	358 array("list_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	359 array("slide_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	360 array("order_num" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	361 ),
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 // Party information system settings / data
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	367 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	368 $siteDisplayVars = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	369 "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	370 "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	371
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	372 "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	373 "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	374
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	375 "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	376 "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	377 "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	378
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	379 // Not user-manageable
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	380 "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	381
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	382 "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	383 "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	384 "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	385
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	386 "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	387 "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	388
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	389 "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	390
f188caaedf0f Implement force reloading of show screen web-page. Matti Hamalainen <ccr@tnsp.org> parents: 1034 diff changeset	391 "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	392 "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	393 );
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 // Some premade test data
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	398 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	399 $siteTestData = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	400 "news" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	401 "utime,title,text,author",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	402 time().",%s,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	403 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	404 array("Good news, everybody!", "...", "The Professor"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	405 ),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	406
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	407 "userkeys" => array(
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	408 "key",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	409 "%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	410 array("test1"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	411 array("test2"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	412 array("7jjnqt5z"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	413 array("c7jcfk1G"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	414 ),
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 "attendees" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	417 "regtime,name,groups,oneliner,email",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	418 "%d,%s,%s,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	419 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	420 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	421 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	422 ),
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 "compos" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	425 "name,description,visible,voting",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	426 "%s,%s,1,1",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	427 array("Graphics", "Anything in standard resolutions."),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	428 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	429 array("4k intro", "4k intro competition"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	430 ),
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 "entries" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	433 "name,author,compo_id,filename,info",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	434 "%s,%s,%d,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	435 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	436 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	437 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	438 array("jenkka", "aegis", 2, "jenkka.mod", ""),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	439 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	440 ),
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 "display_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	443 "title,text",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	444 "%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	445 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	446 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	447 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	448 ),
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 "rot_list_data" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	451 "name",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	452 "%s",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	453 array("Main rotation"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	454 array("Next Up"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	455 ),
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 "rot_list_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	458 "list_id,slide_id",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	459 "%d,%d",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	460 array(1,2),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	461 array(1,3),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	462 array(2,1),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	463 ),
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 $upgradeMappings = array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	468 // "" => array("key" => "", value => ""),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	469 12 => array(
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	470 "show_authors" => array("key" => "showAuthors"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	471 "display_vars" => array("table" => "displayVars"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	472 "display_slides" => array("table" => "displaySlides"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	473 "rot_list_data" => array("table" => "rotationListData"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	474 "rot_list_slides" => array("table" => "rotationListSlides"),
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	475 ),
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	476
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	477 14 => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	478 "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	479 ),
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	480
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 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	482 "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	483 "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	484 ),
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	485
95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	486 31 => array(
95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	487 "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	488 ),
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	489 );
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 ?>

Mercurial > hg > fapweb

annotate dbdefs.inc.php @ 1092:95b74632cfe2