Mercurial > hg > fapweb
annotate dbdefs.inc.php @ 1104:0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Tue, 14 May 2019 14:45:36 +0300 |
parents | c731092a83b7 |
children | 51f24cb35fc8 |
rev | line source |
---|---|
1074 | 1 <?php |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
2 |
1092
95b74632cfe2
Rename votekeys table to userkeys, and all related variables and settings.
Matti Hamalainen <ccr@tnsp.org>
parents:
1074
diff
changeset
|
3 $dbVersion = 31; |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
4 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
5 // |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
6 // Site settings and defaults we put in |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
7 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
8 $siteSettingsGroups = [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
9 "general" => ["General", "General settings"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
10 "news" => ["News", "News related settings"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
11 "event" => ["Event / Schedule", "Event and schedule related settings"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
12 "compos" => ["Compos", "Compo related settings"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
13 ]; |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
14 |
633 | 15 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
16 $siteDefaultSettings = [ |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
17 |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
18 // |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
19 // General site settings |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
20 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
21 "general" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
22 "maxAttendeesHard" => [VT_INT, 60, "Maximum attendees (HARD limit, <= 0 means no limit)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
23 "maxAttendeesSoft" => [VT_INT, 50, "Maximum attendees (soft limit, <= 0 means no limit)"], |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
24 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
25 "userTimeout" => [VT_INT, 120, "User pages (voting) timeout in minutes"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
26 "admTimeout" => [VT_INT, 15, "Administration interface timeout in minutes"], |
1094
563fc90de965
Move 'voting enabled' global setting back to general settings.
Matti Hamalainen <ccr@tnsp.org>
parents:
1092
diff
changeset
|
27 |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
28 "showAdmin" => [VT_BOOL, FALSE, "Always show administration interface link on the menu"], |
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
29 "showAttendees" => [VT_BOOL, TRUE, "Show attendees list"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
30 |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
31 "showResults" => [VT_BOOL, FALSE, "Enable results page"], |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
32 |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
33 "showInfoTextOnAbout" => [VT_BOOL, FALSE, "Show site info HTML on About page"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
34 |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
35 "requireEMail" => [VT_BOOL, FALSE, "Require e-mail address in registrations"], |
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
36 "allowRegister" => [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
|
37 |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
38 "allowVoting" => [VT_BOOL, FALSE, "Enable voting (individual compos must be enabled as well)"], |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
39 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
40 |
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 // News related |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
43 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
44 "news" => [ |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
45 "showNews" => [VT_BOOL, TRUE, "Enable News link on main menu + News page"], |
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
46 "showNewsOnAbout" => [VT_BOOL, TRUE, "Show latest news item on About page"], |
1098
c731092a83b7
Add msgNewsHeader back to configurables.
Matti Hamalainen <ccr@tnsp.org>
parents:
1096
diff
changeset
|
47 |
c731092a83b7
Add msgNewsHeader back to configurables.
Matti Hamalainen <ccr@tnsp.org>
parents:
1096
diff
changeset
|
48 "msgNewsHeader" => [VT_TEXT, " |
c731092a83b7
Add msgNewsHeader back to configurables.
Matti Hamalainen <ccr@tnsp.org>
parents:
1096
diff
changeset
|
49 <h1>The FAPper's news outlet</h1> |
c731092a83b7
Add msgNewsHeader back to configurables.
Matti Hamalainen <ccr@tnsp.org>
parents:
1096
diff
changeset
|
50 ", "News page header blob"], |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
51 ], |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
52 |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
53 // |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
54 // Event / schedule information |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
55 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
56 "event" => [ |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
57 "showSchedule" => [VT_BOOL, TRUE, "Enable Schedule link on main menu + Schedule page"], |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
58 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
59 "msgEventDescription" => [VT_TEXT, " |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
60 <h1>Event program & schedule</h1> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
61 <ul> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
62 <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
|
63 <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
|
64 </ul> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
65 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
66 <h2>Friday 30.11.</h2> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
67 <ul> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
68 <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
|
69 <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
|
70 </ul> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
71 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
72 <h2>Saturday 1.12.</h2> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
73 <ul> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
74 <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
|
75 <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
|
76 <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
|
77 </ul> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
78 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
79 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
|
80 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
81 <h2>Sunday 2.12.</h2> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
82 <ul> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
83 <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
|
84 </ul> |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
85 ", "Event general description / timetables etc."], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
86 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
87 ], |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
88 |
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 // Competitions |
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
91 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
92 "compos" => [ |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
93 "showCompos" => [VT_BOOL, TRUE, "Enable Compos link on main menu + Compos page"], |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
94 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
95 "msgCompoDescription" => [VT_TEXT, " |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
96 <h1>General</h1> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
97 <p class=\"notice\"> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
98 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
|
99 </p> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
100 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
101 <p class=\"note\"> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
102 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
|
103 <br /> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
104 Remote entries are welcome! |
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 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
107 <p> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
108 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
|
109 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
|
110 prod is not AGA compatible. |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
111 </p> |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
112 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
113 <h1>Compos</h1> |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
114 ", "Compo general description"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
115 ], |
710
27f7f437d7d1
Add new class of settings, etc.
Matti Hamalainen <ccr@tnsp.org>
parents:
705
diff
changeset
|
116 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
117 ]; |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
118 |
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 // |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
121 // Database table definitions |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
122 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
123 $sqlTables = [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
124 // Site settings |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
125 "settings_groups" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
126 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
127 ["name" , "VARCHAR(64)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
128 ["description" , "VARCHAR(128)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
129 ], |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
130 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
131 "settings" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
132 ["key" , "VARCHAR(32)", "PRIMARY KEY"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
133 ["vtype" , "INT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
134 ["vstr" , "VARCHAR(128)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
135 ["vtext" , "TEXT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
136 ["vint" , "INT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
137 ["sdesc" , "VARCHAR(128)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
138 ["vgroup" , "INT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
139 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
140 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
141 "news" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
142 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
143 ["utime" , "INT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
144 ["title" , "VARCHAR(".SET_LEN_NEWS_TITLE.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
145 ["text" , "VARCHAR(".SET_LEN_NEWS_TEXT.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
146 ["author" , "VARCHAR(".SET_LEN_NEWS_AUTHOR.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
147 ["persist" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
148 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
149 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
150 "compos" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
151 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
152 ["name" , "VARCHAR(".SET_LEN_COMPO_NAME.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
153 ["description" , "VARCHAR(".SET_LEN_COMPO_DESC.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
154 ["notes" , "VARCHAR(".SET_LEN_COMPO_NOTES.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
155 ["visible" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
156 ["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
|
157 |
1034
8fecb417e6a9
Reintroduce per-entry preview_type.
Matti Hamalainen <ccr@tnsp.org>
parents:
981
diff
changeset
|
158 // 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
|
159 // Global for the compo (entry-specific overrides if it is != EFILE_NONE) |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
160 ["preview_type" , "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
|
161 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
162 ["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
|
163 // 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
|
164 // 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
|
165 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
166 ["ctype" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
167 ["cpath" , "VARCHAR(".SET_LEN_COMPO_PATH.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
168 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
169 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
170 "entries" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
171 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
172 ["show_id" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
173 ["name" , "VARCHAR(".SET_LEN_ENTRY_NAME.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
174 ["author" , "VARCHAR(".SET_LEN_ENTRY_AUTHOR.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
175 ["compo_id" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
176 ["info" , "VARCHAR(".SET_LEN_ENTRY_INFO.")", "DEFAULT NULL"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
177 ["notes" , "VARCHAR(".SET_LEN_ENTRY_NOTES.")", "DEFAULT NULL"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
178 ["flags" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
179 ["evalue" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
180 ["file_id" , "INT", "DEFAULT 0"], // uploaded file id from "files" table |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
181 ["preview_id" , "INT", "DEFAULT 0"], // uploaded preview file id from "files" table |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
182 ["preview_type" , "INT", "DEFAULT 0"], // see EFILE_*, overrides compo's general type if != 0 |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
183 ["utime" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
184 ["owner_id" , "INT", "DEFAULT 0"], // 0 = admin, otherwise userkey id |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
185 ], |
822
fc555d954b99
Add preview_id to entries and the new files table for stored files.
Matti Hamalainen <ccr@tnsp.org>
parents:
821
diff
changeset
|
186 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
187 "files" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
188 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
189 ["filename" , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"], // stored filename |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
190 ["origname" , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"], // original uploaded filename |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
191 ["filetype" , "VARCHAR(32)", "DEFAULT NULL"], // type of the file, if any, as key from $fileTypeData |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
192 ["uploadtype" , "VARCHAR(32)", "DEFAULT NULL"], // "preview", "entry" |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
193 ["filesize" , "INT", "DEFAULT 0"], // uploaded size |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
194 ["entry_id" , "INT", "DEFAULT 0"], // belongs to this entry (0 = none) |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
195 ["uploader_id" , "INT", "DEFAULT 0"], // 0 = admin, otherwise userkey id |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
196 ["deleted" , "INT", "DEFAULT 0"], // 1 = to be deleted |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
197 ["utime" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
198 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
199 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
200 "attendees" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
201 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
202 ["regtime" , "INT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
203 ["name" , "VARCHAR(".SET_LEN_USERNAME.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
204 ["groups" , "VARCHAR(".SET_LEN_GROUPS.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
205 ["oneliner" , "VARCHAR(".SET_LEN_ONELINER.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
206 ["email" , "VARCHAR(".SET_LEN_EMAIL.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
207 ["reghost" , "VARCHAR(".SET_LEN_REGHOST.")", "DEFAULT NULL"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
208 ["key_id" , "INT", "DEFAULT NULL"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
209 ["usr_flags" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
210 ["adm_flags" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
211 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
212 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
213 "userkeys" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
214 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
215 ["key" , "VARCHAR(".SET_LEN_USERKEY.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
216 ["active" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
217 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
218 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
219 "votes" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
220 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
221 ["entry_id" , "INT", "DEFAULT NULL"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
222 ["key_id" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
223 ["value" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
224 ["utime" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
225 ], |
555
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 // Party information system tables |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
229 "display_vars" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
230 ["key" , "VARCHAR(32)", "PRIMARY KEY"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
231 ["vtype" , "INT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
232 ["vstr" , "VARCHAR(128)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
233 ["vtext" , "TEXT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
234 ["vint" , "INT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
235 ["sdesc" , "VARCHAR(128)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
236 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
237 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
238 "display_slides" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
239 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
240 ["title" , "VARCHAR(".SET_LEN_DISP_SLIDE_TITLE.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
241 ["text" , "VARCHAR(".SET_LEN_DISP_SLIDE_TEXT.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
242 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
243 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
244 "rot_list_data" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
245 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
246 ["name" , "VARCHAR(".SET_LEN_ROT_LIST_NAME.")"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
247 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
248 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
249 "rot_list_slides" => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
250 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
251 ["list_id" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
252 ["slide_id" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
253 ["order_num" , "INT", "DEFAULT 0"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
254 ], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
255 ]; |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
256 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
257 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
258 // |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
259 // Party information system settings / data |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
260 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
261 $siteDisplayVars = [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
262 "showMode" => [VT_INT, 0, "Currently active display mode"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
263 "rotateDuration" => [VT_INT, 15, "Slide rotation time per slide (seconds)"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
264 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
265 "tempDuration" => [VT_INT, 5, "Temporary slide display time (minutes)"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
266 "tempSlide" => [VT_INT, 0, "Temporary slide ID"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
267 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
268 "compoID" => [VT_INT, 0, "Compo ID of current compo"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
269 "compoPrevEntry" => [VT_INT, 0, "Previously shown compo entry"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
270 "compoCurrEntry" => [VT_INT, 0, "Current / next compo entry to be shown"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
271 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
272 // Not user-manageable |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
273 "tempSlideSet" => [VT_BOOL, FALSE, "Temporary slide set"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
274 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
275 "activeSlideMode" => [VT_INT, 0, "Current active slide display mode"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
276 "activeSlide" => [VT_INT, 0, "Current active slide"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
277 "activeSlideExpire" => [VT_INT, 0, "Expiration timestamp of current slide"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
278 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
279 "rotateList" => [VT_INT, 0, "Current rotation list ID"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
280 "rotateListIndex" => [VT_INT, 0, "Current index in rotation list"], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
281 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
282 "lastUpdate" => [VT_INT, 0, "Timestamp of last slide update"], |
1041
f188caaedf0f
Implement force reloading of show screen web-page.
Matti Hamalainen <ccr@tnsp.org>
parents:
1034
diff
changeset
|
283 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
284 "screenCmd" => [VT_STR, "", "Off-channel showscreen command"], |
1104
0a2117349f46
s/true/TRUE/g; s/false/FALSE/g;
Matti Hamalainen <ccr@tnsp.org>
parents:
1098
diff
changeset
|
285 "screenCmdSet" => [VT_BOOL, FALSE, "Off-channel showscreen command has been set"], |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
286 ]; |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
287 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
288 |
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 // Some premade test data |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
291 // |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
292 $siteTestData = [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
293 "news" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
294 "utime,title,text,author", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
295 time().",%s,%s,%s", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
296 ["Today's news", "We. Are. Back.", "orgaz"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
297 ["Good news, everybody!", "...", "The Professor"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
298 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
299 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
300 "userkeys" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
301 "key", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
302 "%s", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
303 ["test1"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
304 ["test2"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
305 ["test1"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
306 ["test2"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
307 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
308 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
309 "attendees" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
310 "regtime,name,groups,oneliner,email", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
311 "%d,%s,%s,%s,%s", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
312 [time()-0, "man with no alias", "supergroup", "foo-bar", "c@supergroup.com"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
313 [time()-15, "man with alias", "supergroup", "hi!", "c@supergroup.com"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
314 [time()-30, "alias with a man", "supergroup", "mega super kewl rulets", "x@microsoft.com"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
315 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
316 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
317 "compos" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
318 "name,description,visible,voting", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
319 "%s,%s,1,1", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
320 ["Graphics", "Anything in standard resolutions."], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
321 ["Protracker music", "Standard 4-channel Protracker MOD music."], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
322 ["4k intro", "4k intro competition"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
323 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
324 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
325 "entries" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
326 "name,author,compo_id,filename,info", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
327 "%s,%s,%d,%s,%s", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
328 ["Donkey Dong", "electric/extend", 1, "donkey.lbm", "amigaaaah!"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
329 ["Your kondom", "ccr/TNSP", 1, "kondom.lbm", "oh my god, it's full of cocks!"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
330 ["Penis song", "reed/flt", 2, "penis.mod", "laulu rakkaudelle"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
331 ["jenkka", "aegis", 2, "jenkka.mod", ""], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
332 ["Fungiform 2", "mfx", 3, "mfx-fungiform2.lzh", "OCS-only"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
333 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
334 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
335 "display_slides" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
336 "title,text", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
337 "%s,%s", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
338 ["Next Up 4k", "<h1>Next up: 4k intro</h1><h2>4k intro compo is about to begin</h2>... in about 10 minutes."], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
339 ["Astu to infodesk", "<b>Astu</b> - please come to info desk!"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
340 ["Gentle Eye mainos", "<b>Buy Amiga stuff!</b><br />Gentle Eye Oy is selling Amiga-related stuff near organizer desk!"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
341 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
342 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
343 "rot_list_data" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
344 "name", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
345 "%s", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
346 ["Main rotation"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
347 ["Next Up"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
348 ], |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
349 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
350 "rot_list_slides" => [ |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
351 "list_id,slide_id", |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
352 "%d,%d", |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
353 [1,2], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
354 [1,3], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
355 [2,1], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
356 ], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
357 ]; |
555
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
358 |
206196b610fd
Move site specific things to dbdefs.inc.php
Matti Hamalainen <ccr@tnsp.org>
parents:
diff
changeset
|
359 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
360 $upgradeMappings = [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
361 // "" => ["key" => "", value => ""], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
362 12 => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
363 "show_authors" => ["key" => "showAuthors"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
364 "display_vars" => ["table" => "displayVars"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
365 "display_slides" => ["table" => "displaySlides"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
366 "rot_list_data" => ["table" => "rotationListData"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
367 "rot_list_slides" => ["table" => "rotationListSlides"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
368 ], |
620
8444fe96120e
Implement setting groups for admin interface settings. This is just the
Matti Hamalainen <ccr@tnsp.org>
parents:
587
diff
changeset
|
369 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
370 14 => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
371 "settings_groups" => ["table" => FALSE], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
372 ], |
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
|
373 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
374 17 => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
375 "ctype" => ["key" => "type"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
376 "cpath" => ["key" => "path"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
377 ], |
1092
95b74632cfe2
Rename votekeys table to userkeys, and all related variables and settings.
Matti Hamalainen <ccr@tnsp.org>
parents:
1074
diff
changeset
|
378 |
1096
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
379 31 => [ |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
380 "userkeys" => ["table" => "votekeys"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
381 "msgEventDescription" => ["key" => "eventDescription"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
382 "msgCompoDescription" => ["key" => "compoDescription"], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
383 ], |
bbc0a3d0b51e
Major renaming / refactor of site messages. Some that were previously
Matti Hamalainen <ccr@tnsp.org>
parents:
1094
diff
changeset
|
384 ]; |
555
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 ?> |