fapweb: dbdefs.inc.php annotate

annotate dbdefs.inc.php @ 1115:24e6915fc0fb

Move database field length definitions from msite.inc.php to dbdefs.inc.php

author	Matti Hamalainen <ccr@tnsp.org>
date	Mon, 14 Oct 2019 10:33:39 +0300
parents	51f24cb35fc8
children	b2bca5f6d0ff

rev	line source
1074 48e16e856646 Use long tags. Matti Hamalainen <ccr@tnsp.org> parents: 1041 diff changeset	1 <?php
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	2
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	3 $dbVersion = 31;
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	4
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	5 //
1115 24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	6 // Define sizes of database fields, see createdb.php
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	7 // and also the places where input is validated.
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	8 //
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	9 define("SQL_LEN_USERNAME", 32);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	10 define("SQL_LEN_GROUPS", 64);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	11 define("SQL_LEN_ONELINER", 64);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	12 define("SQL_LEN_EMAIL", 80);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	13 define("SQL_LEN_REGHOST", 128);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	14
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	15 define("SQL_LEN_NEWS_TITLE", 128);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	16 define("SQL_LEN_NEWS_TEXT", 4096);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	17 define("SQL_LEN_NEWS_AUTHOR", 64);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	18
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	19 define("SQL_LEN_COMPO_NAME", 128);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	20 define("SQL_LEN_COMPO_DESC", 4096);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	21 define("SQL_LEN_COMPO_NOTES", 4096);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	22 define("SQL_LEN_COMPO_PATH", 128);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	23
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	24 define("SQL_LEN_ENTRY_NAME", 64);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	25 define("SQL_LEN_ENTRY_AUTHOR", 64);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	26 define("SQL_LEN_ENTRY_FILENAME", 128);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	27 define("SQL_LEN_ENTRY_INFO", 50*4);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	28 define("SQL_LEN_ENTRY_NOTES", 1024);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	29 define("SQL_LEN_ENTRY_PREVIEW_FILE", 128);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	30
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	31 define("SQL_LEN_DISP_SLIDE_TITLE", 64);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	32 define("SQL_LEN_DISP_SLIDE_TEXT", 4096);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	33 define("SQL_LEN_ROT_LIST_NAME", 128);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	34
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	35 define("SQL_LEN_USERKEY", 64);
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	36
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	37
24e6915fc0fb Move database field length definitions from msite.inc.php to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 1114 diff changeset	38 //
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	39 // Site settings and defaults we put in
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	40 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	41 $siteSettingsGroups = [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	42 "general" => ["General", "General settings"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	43 "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	44 "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	45 "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	46 ];
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	47
633 8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	48
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	49 $siteDefaultSettings = [
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	50
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	51 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	52 // General site settings
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	53 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	54 "general" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	55 "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	56 "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	57
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	58 "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	59 "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	60
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	61 "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	62 "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	63
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	64 "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	65
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	66 "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	67
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	68 "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	69 "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	70
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	71 "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	72 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	73
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	74 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	75 // News related
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	76 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	77 "news" => [
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	78 "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	79 "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	80
c731092a83b7 Add msgNewsHeader back to configurables. Matti Hamalainen <ccr@tnsp.org> parents: 1096 diff changeset	81 "msgNewsHeader" => [VT_TEXT, "
c731092a83b7 Add msgNewsHeader back to configurables. Matti Hamalainen <ccr@tnsp.org> parents: 1096 diff changeset	82 <h1>The FAPper's news outlet</h1>
c731092a83b7 Add msgNewsHeader back to configurables. Matti Hamalainen <ccr@tnsp.org> parents: 1096 diff changeset	83 ", "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	84 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	85
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	86 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	87 // Event / schedule information
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	88 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	89 "event" => [
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	90 "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	91
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	92 "msgEventDescription" => [VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	93 <h1>Event program & schedule</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	94 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	95 <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	96 <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	97 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	98
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	99 <h2>Friday 30.11.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	100 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	101 <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	102 <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	103 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	104
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	105 <h2>Saturday 1.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	106 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	107 <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	108 <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	109 <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	110 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	111
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	112 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	113
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	114 <h2>Sunday 2.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	115 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	116 <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	117 </ul>
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	118 ", "Event general description / timetables etc."],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	119
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	120 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	121
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	122 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	123 // Competitions
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	124 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	125 "compos" => [
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	126 "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	127
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	128 "msgCompoDescription" => [VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	129 <h1>General</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	130 <p class=\"notice\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	131 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	132 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	133
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	134 <p class=\"note\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	135 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	136 <br />
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	137 Remote entries are welcome!
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	138 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	139
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	140 <p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	141 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	142 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	143 prod is not AGA compatible.
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	144 </p>
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 <h1>Compos</h1>
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	147 ", "Compo general description"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	148 ],
710 27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 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 ];
555 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
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	153 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	154 // Database table definitions
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	155 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	156 $sqlTables = [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	157 // Site settings
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	158 "settings_groups" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	159 ["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	160 ["name" , "VARCHAR(64)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	161 ["description" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	162 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	163
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	164 "settings" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	165 ["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	166 ["vtype" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	167 ["vstr" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	168 ["vtext" , "TEXT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	169 ["vint" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	170 ["sdesc" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	171 ["vgroup" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	172 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	173
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	174 "news" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	175 ["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	176 ["utime" , "INT"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	177 ["title" , "VARCHAR(".SQL_LEN_NEWS_TITLE.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	178 ["text" , "VARCHAR(".SQL_LEN_NEWS_TEXT.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	179 ["author" , "VARCHAR(".SQL_LEN_NEWS_AUTHOR.")"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	180 ["persist" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	181 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	182
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	183 "compos" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	184 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	185 ["name" , "VARCHAR(".SQL_LEN_COMPO_NAME.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	186 ["description" , "VARCHAR(".SQL_LEN_COMPO_DESC.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	187 ["notes" , "VARCHAR(".SQL_LEN_COMPO_NOTES.")"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	188 ["visible" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	189 ["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	190
1034 8fecb417e6a9 Reintroduce per-entry preview_type. Matti Hamalainen <ccr@tnsp.org> parents: 981 diff changeset	191 // 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	192 // 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	193 ["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	194
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	195 ["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	196 // 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	197 // 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	198
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	199 ["ctype" , "INT", "DEFAULT 0"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	200 ["cpath" , "VARCHAR(".SQL_LEN_COMPO_PATH.")"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	201 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	202
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	203 "entries" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	204 ["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	205 ["show_id" , "INT", "DEFAULT 0"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	206 ["name" , "VARCHAR(".SQL_LEN_ENTRY_NAME.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	207 ["author" , "VARCHAR(".SQL_LEN_ENTRY_AUTHOR.")"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	208 ["compo_id" , "INT", "DEFAULT 0"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	209 ["info" , "VARCHAR(".SQL_LEN_ENTRY_INFO.")", "DEFAULT NULL"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	210 ["notes" , "VARCHAR(".SQL_LEN_ENTRY_NOTES.")", "DEFAULT NULL"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	211 ["flags" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	212 ["evalue" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	213 ["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	214 ["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	215 ["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	216 ["utime" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	217 ["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	218 ],
822 fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 diff changeset	219
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	220 "files" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	221 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	222 ["filename" , "VARCHAR(".SQL_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"], // stored filename
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	223 ["origname" , "VARCHAR(".SQL_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"], // original uploaded filename
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	224 ["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	225 ["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	226 ["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	227 ["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	228 ["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	229 ["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	230 ["utime" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	231 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	232
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	233 "attendees" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	234 ["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	235 ["regtime" , "INT"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	236 ["name" , "VARCHAR(".SQL_LEN_USERNAME.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	237 ["groups" , "VARCHAR(".SQL_LEN_GROUPS.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	238 ["oneliner" , "VARCHAR(".SQL_LEN_ONELINER.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	239 ["email" , "VARCHAR(".SQL_LEN_EMAIL.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	240 ["reghost" , "VARCHAR(".SQL_LEN_REGHOST.")", "DEFAULT NULL"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	241 ["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	242 ["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	243 ["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	244 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	245
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	246 "userkeys" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	247 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	248 ["key" , "VARCHAR(".SQL_LEN_USERKEY.")"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	249 ["active" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	250 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	251
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	252 "votes" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	253 ["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	254 ["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	255 ["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	256 ["value" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	257 ["utime" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	258 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	259
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	260
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	261 // 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	262 "display_vars" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	263 ["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	264 ["vtype" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	265 ["vstr" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	266 ["vtext" , "TEXT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	267 ["vint" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	268 ["sdesc" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	269 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	270
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	271 "display_slides" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	272 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	273 ["title" , "VARCHAR(".SQL_LEN_DISP_SLIDE_TITLE.")"],
51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	274 ["text" , "VARCHAR(".SQL_LEN_DISP_SLIDE_TEXT.")"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	275 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	276
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	277 "rot_list_data" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	278 ["id" , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"],
1114 51f24cb35fc8 s/SET_LEN_/SQL_LEN_/g Matti Hamalainen <ccr@tnsp.org> parents: 1104 diff changeset	279 ["name" , "VARCHAR(".SQL_LEN_ROT_LIST_NAME.")"],
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	280 ],
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 "rot_list_slides" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	283 ["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	284 ["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	285 ["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	286 ["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	287 ],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	288 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	289
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	290
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	291 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	292 // Party information system settings / data
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	293 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	294 $siteDisplayVars = [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	295 "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	296 "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	297
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	298 "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	299 "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	300
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	301 "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	302 "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	303 "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	304
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	305 // Not user-manageable
1104 0a2117349f46 s/true/TRUE/g; s/false/FALSE/g; Matti Hamalainen <ccr@tnsp.org> parents: 1098 diff changeset	306 "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	307
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	308 "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	309 "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	310 "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	311
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	312 "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	313 "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	314
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	315 "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	316
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	317 "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	318 "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	319 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	320
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	321
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	322 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	323 // Some premade test data
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 $siteTestData = [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	326 "news" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	327 "utime,title,text,author",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	328 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	329 ["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	330 ["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	331 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	332
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	333 "userkeys" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	334 "key",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	335 "%s",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	336 ["test1"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	337 ["test2"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	338 ["test1"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	339 ["test2"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	340 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	341
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	342 "attendees" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	343 "regtime,name,groups,oneliner,email",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	344 "%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	345 [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	346 [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	347 [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	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 "compos" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	351 "name,description,visible,voting",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	352 "%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	353 ["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	354 ["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	355 ["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	356 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	357
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	358 "entries" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	359 "name,author,compo_id,filename,info",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	360 "%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	361 ["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	362 ["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	363 ["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	364 ["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	365 ["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	366 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	367
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	368 "display_slides" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	369 "title,text",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	370 "%s,%s",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	371 ["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	372 ["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	373 ["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	374 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	375
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	376 "rot_list_data" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	377 "name",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	378 "%s",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	379 ["Main rotation"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	380 ["Next Up"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	381 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	382
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	383 "rot_list_slides" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	384 "list_id,slide_id",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	385 "%d,%d",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	386 [1,2],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	387 [1,3],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	388 [2,1],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	389 ],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	390 ];
555 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
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	393 $upgradeMappings = [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	394 // "" => ["key" => "", value => ""],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	395 12 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	396 "show_authors" => ["key" => "showAuthors"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	397 "display_vars" => ["table" => "displayVars"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	398 "display_slides" => ["table" => "displaySlides"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	399 "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	400 "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	401 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	402
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	403 14 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	404 "settings_groups" => ["table" => FALSE],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	405 ],
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	406
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	407 17 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	408 "ctype" => ["key" => "type"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	409 "cpath" => ["key" => "path"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	410 ],
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	411
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	412 31 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	413 "userkeys" => ["table" => "votekeys"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	414 "msgEventDescription" => ["key" => "eventDescription"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	415 "msgCompoDescription" => ["key" => "compoDescription"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	416 ],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	417 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	418
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 ?>

Mercurial > hg > fapweb

annotate dbdefs.inc.php @ 1115:24e6915fc0fb