Mercurial > hg > fapweb
annotate dbdefs.inc.php @ 1034:8fecb417e6a9
Reintroduce per-entry preview_type.
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Fri, 20 Nov 2015 07:28:53 +0200 |
parents | e6e6be0218f8 |
children | f188caaedf0f |
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 |
981 | 3 $dbVersion = 30; |
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 | 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 | 12 "register" => array("Registration", "Visitor registration"), |
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 | 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 | 38 "requireEMail" => array(VT_BOOL, false, "Require e-mail address in registrations"), |
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 | 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 | 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 | 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 | 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"), |
f27dccdde8ef
Partially remove old filename stuff from entries. Still some vestiges
Matti Hamalainen <ccr@tnsp.org>
parents:
789
diff
changeset
|
291 array("owner_id" , "INT", "DEFAULT 0"), // 0 = admin, otherwise votekey id |
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 | 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) |
fc555d954b99
Add preview_id to entries and the new files table for stored files.
Matti Hamalainen <ccr@tnsp.org>
parents:
821
diff
changeset
|
302 array("uploader_id" , "INT", "DEFAULT 0"), // 0 = admin, otherwise votekey id |
872 | 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 | 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 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
320 "votekeys" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
321 array("id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
322 array("key" , "VARCHAR(".SET_LEN_VOTEKEY.")"), |
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"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
390 ); |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
391 |
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 // Some premade test data |
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 $siteTestData = array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
397 "news" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
398 "utime,title,text,author", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
399 time().",%s,%s,%s", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
400 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
|
401 array("Good news, everybody!", "...", "The Professor"), |
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 "votekeys" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
405 "key", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
406 "%s", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
407 array("test1"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
408 array("test2"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
409 array("7jjnqt5z"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
410 array("c7jcfk1G"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
411 ), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
412 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
413 "attendees" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
414 "regtime,name,groups,oneliner,email", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
415 "%d,%s,%s,%s,%s", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
416 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
|
417 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
|
418 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
|
419 ), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
420 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
421 "compos" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
422 "name,description,visible,voting", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
423 "%s,%s,1,1", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
424 array("Graphics", "Anything in standard resolutions."), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
425 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
|
426 array("4k intro", "4k intro competition"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
427 ), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
428 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
429 "entries" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
430 "name,author,compo_id,filename,info", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
431 "%s,%s,%d,%s,%s", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
432 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
|
433 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
|
434 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
|
435 array("jenkka", "aegis", 2, "jenkka.mod", ""), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
436 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
|
437 ), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
438 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
439 "display_slides" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
440 "title,text", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
441 "%s,%s", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
442 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
|
443 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
|
444 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
|
445 ), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
446 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
447 "rot_list_data" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
448 "name", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
449 "%s", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
450 array("Main rotation"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
451 array("Next Up"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
452 ), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
453 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
454 "rot_list_slides" => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
455 "list_id,slide_id", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
456 "%d,%d", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
457 array(1,2), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
458 array(1,3), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
459 array(2,1), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
460 ), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
461 ); |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
462 |
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 $upgradeMappings = array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
465 // "" => array("key" => "", value => ""), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
466 12 => array( |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
467 "show_authors" => array("key" => "showAuthors"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
468 "display_vars" => array("table" => "displayVars"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
469 "display_slides" => array("table" => "displaySlides"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
470 "rot_list_data" => array("table" => "rotationListData"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
471 "rot_list_slides" => array("table" => "rotationListSlides"), |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
472 ), |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
473 |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
474 14 => array( |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
475 "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
|
476 ), |
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
|
477 |
c78e11aa3162
Rename a database field, so that it does not conflict with AJAX request item
Matti Hamalainen <ccr@tnsp.org>
parents:
633
diff
changeset
|
478 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
|
479 "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
|
480 "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
|
481 ), |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
482 ); |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
483 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
484 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
485 ?> |