Mercurial > hg > fapweb

annotate dbdefs.inc.php @ 640:c78e11aa3162

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rename a database field, so that it does not conflict with AJAX request item name.
author Matti Hamalainen <ccr@tnsp.org>
date Mon, 03 Nov 2014 01:58:04 +0200
parents 8e11a86204a9
children 1702a5e0b9c3
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
1 <?
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
2
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
3 $dbVersion = 17;
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"),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
15 );
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
16
633
8e11a86204a9 Updated DB defs.
Matti Hamalainen <ccr@tnsp.org>
parents: 622
diff changeset
17
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
18 $siteDefaultSettings = array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
19
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 // General site settings
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
22 //
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
23 "general" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
24 "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
25 "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
26
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
27 "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
28 "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
29
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
30 "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
31 "showAttendees" => array(VT_BOOL, true, "Show attendees list"),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
32 "allowVoting" => array(VT_BOOL, false, "Enable voting (individual compos must be enabled as well)"),
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 "showResAuthors" => array(VT_BOOL, true, "Show entry authors on results page"),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
36
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
37 "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
38
633
8e11a86204a9 Updated DB defs.
Matti Hamalainen <ccr@tnsp.org>
parents: 622
diff changeset
39 "requireEMail" => array(VT_BOOL, false, "Require e-mail address in registrations"),
8e11a86204a9 Updated DB defs.
Matti Hamalainen <ccr@tnsp.org>
parents: 622
diff changeset
40 "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
41 ),
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 "html" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
44 "siteMenuHeader" => array(VT_TEXT, "<div>13.FAP:&gt; <span class=\"mblink\">&#9632;</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
45 "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
46 "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
47
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
48 "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
49 <a href=\"about\">
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
50 <img src=\"img/fapsm.png\" alt=\"Finnish Amiga Party 2013\" class=\"logo\" /></a>
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
51 <div id=\"date\">
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
52 5.-8.12.2013<br />
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
53 Helsinki, Finland<br />
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
54 @ old location<br />
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
55 <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
56 </div>", "Site header text"),
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
57
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
58 "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
59 <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
60 <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
61 <p>
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
62 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
63 <br />
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
64 <span class=\"notice\">
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
65 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
66 </span>
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
67 </p>
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
68 </div>",
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
69 "About page text"),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
70
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
71 "voteFinishedText" => array(VT_TEXT, "
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
72 <h1>Yay, you have voted!</h1>
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
73 <p>Now go FAP some more! And make a demo about it.</p>",
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
74 "Message shown after successful voting"),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
75
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
76 ),
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
77
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
78 //
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
79 // News related
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 "news" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
82 "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
83 "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
84 "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
85 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
86
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
87 //
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
88 // Attendee/visitor registration
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
89 //
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
90 "register" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
91 "registerInfoText" => array(VT_TEXT, "<p>
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
92 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
93 If you plan on joining the IRC channel
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
94 (<a href=\"irc://#fap2013@ircnet\">#fap2013 @ IRCNet</a>) or staying up to date by other means,
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
95 <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
96 </p>", "Registration page info text"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
97
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
98 "registerPostText" => array(VT_TEXT, "
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
99 <h1>Registration successful</h1>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
100 <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
101 "Successful post-registration note text"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
102
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
103 "registerLimitExceeded" => array(VT_TEXT, "
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
104 <h1>Sorry, registration disabled!</h1>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
105 <p>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
106 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
107 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
108 </p>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
109 ",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
110 "Registration attendee limit exceeded note text"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
111
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
112 "registerNotEnabled" => array(VT_TEXT, "
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
113 <h1>Sorry, registration disabled!</h1>
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 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
116 </p>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
117 ",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
118 "Registration not enabled note text"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
119
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
120 "registerPostNoEmail" => array(VT_TEXT, "
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
121 <h2>By the way ...</h2>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
122 <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
123 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
124 some other means (IRC, for example.)</p>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
125 ", "No e-mail address registration note"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
126
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
127 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
128
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
129 //
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
130 // Event / schedule information
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 "event" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
133 "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
134
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
135 "eventDescription" => array(VT_TEXT, "
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
136 <h1>Event program &amp; schedule</h1>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
137 <ul>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
138 <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
139 <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
140 </ul>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
141
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
142 <h2>Friday 30.11.</h2>
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>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
145 <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
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>Saturday 1.12.</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>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
151 <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
152 <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
153 </ul>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
154
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
155 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
156
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
157 <h2>Sunday 2.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
158 <ul>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
159 <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
160 </ul>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
161 ", "Event general description / timetables etc."),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
162
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
163 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
164
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
165 //
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
166 // Competitions
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 "compos" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
169 "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
170
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
171 "compoDescription" => array(VT_TEXT, "
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
172 <h1>General</h1>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
173 <p class=\"notice\">
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
174 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
175 </p>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
176
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
177 <p class=\"note\">
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
178 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
179 <br />
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
180 Remote entries are welcome!
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>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
184 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
185 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
186 prod is not AGA compatible.
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 <h1>Compos</h1>
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
190 ", "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
191 ),
555
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
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 //
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
196 // Database table definitions
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
197 //
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
198 $sqlTables = array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
199 // Site settings
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
200 "settings_groups" => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
201 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
202 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
203 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
204 ),
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
205
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
206 "settings" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
207 array("key" , "VARCHAR(32)", "PRIMARY KEY"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
208 array("vtype" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
209 array("vstr" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
210 array("vtext" , "TEXT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
211 array("vint" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
212 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
213 array("vgroup" , "INT"),
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
214 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
215
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
216 "news" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
217 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
218 array("utime" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
219 array("title" , "VARCHAR(".SET_LEN_NEWS_TITLE.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
220 array("text" , "VARCHAR(".SET_LEN_NEWS_TEXT.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
221 array("author" , "VARCHAR(".SET_LEN_NEWS_AUTHOR.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
222 array("persist" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
223 ),
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 "compos" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
226 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
227 array("name" , "VARCHAR(".SET_LEN_COMPO_NAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
228 array("description" , "VARCHAR(".SET_LEN_COMPO_DESC.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
229 array("visible" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
230 array("voting" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
231 array("show_authors" , "INT", "DEFAULT 0"),
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
232 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
233 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
234 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
235
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
236 "entries" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
237 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
238 array("show_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
239 array("name" , "VARCHAR(".SET_LEN_ENTRY_NAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
240 array("author" , "VARCHAR(".SET_LEN_ENTRY_AUTHOR.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
241 array("compo_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
242 array("filename" , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
243 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
244 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
245 array("preview_file" , "VARCHAR(".SET_LEN_ENTRY_PREVIEW_FILE.")", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
246 array("preview_type" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
247 array("flags" , "INT", "DEFAULT 0"),
622
b58495c2d01a Add new field in entries table.
Matti Hamalainen <ccr@tnsp.org>
parents: 620
diff changeset
248 array("evalue" , "INT", "DEFAULT 0"),
555
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
249 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
250
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
251 "attendees" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
252 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
253 array("regtime" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
254 array("name" , "VARCHAR(".SET_LEN_USERNAME.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
255 array("groups" , "VARCHAR(".SET_LEN_GROUPS.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
256 array("oneliner" , "VARCHAR(".SET_LEN_ONELINER.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
257 array("email" , "VARCHAR(".SET_LEN_EMAIL.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
258 array("key_id" , "INT", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
259 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
260
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
261 "votekeys" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
262 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
263 array("key" , "VARCHAR(".SET_LEN_VOTEKEY.")"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
264 array("active" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
265 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
266
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
267 "votes" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
268 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
269 array("entry_id" , "INT", "DEFAULT NULL"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
270 array("key_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
271 array("value" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
272 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
273
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
274
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
275 // Party information system tables
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
276 "display_vars" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
277 array("key" , "VARCHAR(32)", "PRIMARY KEY"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
278 array("vtype" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
279 array("vstr" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
280 array("vtext" , "TEXT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
281 array("vint" , "INT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
282 array("sdesc" , "VARCHAR(128)"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
283 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
284
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
285 "display_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
286 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
287 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
288 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
289 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
290
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
291 "rot_list_data" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
292 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
293 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
294 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
295
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
296 "rot_list_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
297 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
298 array("list_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
299 array("slide_id" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
300 array("order_num" , "INT", "DEFAULT 0"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
301 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
302 );
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
303
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
304
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 // Party information system settings / data
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 $siteDisplayVars = array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
309 "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
310 "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
311
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
312 "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
313 "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
314
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
315 "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
316 "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
317 "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
318
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
319 // Not user-manageable
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
320 "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
321
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
322 "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
323 "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
324 "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
325
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
326 "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
327 "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
328
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
329 "lastUpdate" => array(VT_INT, 0, "Timestamp of last slide update"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
330 );
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
331
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 // Some premade test data
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 $siteTestData = array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
337 "news" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
338 "utime,title,text,author",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
339 time().",%s,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
340 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
341 array("Good news, everybody!", "...", "The Professor"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
342 ),
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 "votekeys" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
345 "key",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
346 "%s",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
347 array("test1"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
348 array("test2"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
349 array("7jjnqt5z"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
350 array("c7jcfk1G"),
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
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
353 "attendees" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
354 "regtime,name,groups,oneliner,email",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
355 "%d,%s,%s,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
356 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
357 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
358 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
359 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
360
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
361 "compos" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
362 "name,description,visible,voting",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
363 "%s,%s,1,1",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
364 array("Graphics", "Anything in standard resolutions."),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
365 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
366 array("4k intro", "4k intro competition"),
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
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
369 "entries" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
370 "name,author,compo_id,filename,info",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
371 "%s,%s,%d,%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
372 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
373 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
374 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
375 array("jenkka", "aegis", 2, "jenkka.mod", ""),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
376 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
377 ),
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 "display_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
380 "title,text",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
381 "%s,%s",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
382 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
383 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
384 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
385 ),
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 "rot_list_data" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
388 "name",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
389 "%s",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
390 array("Main rotation"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
391 array("Next Up"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
392 ),
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 "rot_list_slides" => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
395 "list_id,slide_id",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
396 "%d,%d",
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
397 array(1,2),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
398 array(1,3),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
399 array(2,1),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
400 ),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
401 );
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
402
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
403
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
404 $upgradeMappings = array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
405 // "" => array("key" => "", value => ""),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
406 12 => array(
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
407 "show_authors" => array("key" => "showAuthors"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
408 "display_vars" => array("table" => "displayVars"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
409 "display_slides" => array("table" => "displaySlides"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
410 "rot_list_data" => array("table" => "rotationListData"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
411 "rot_list_slides" => array("table" => "rotationListSlides"),
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
412 ),
620
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
413
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
414 14 => array(
8444fe96120e Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents: 587
diff changeset
415 "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
416 ),
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
417
c78e11aa3162 Rename a database field, so that it does not conflict with AJAX request item
Matti Hamalainen <ccr@tnsp.org>
parents: 633
diff changeset
418 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
419 "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
420 "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
421 ),
555
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
206196b610fd Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
425 ?>