fapweb: dbdefs.inc.php annotate

annotate dbdefs.inc.php @ 1096:bbc0a3d0b51e

Major renaming / refactor of site messages. Some that were previously modifiable from admin interface are now "hardcoded" in the configuration file. Having these settings made modifiable from there made no sense and just took space in the UI.

author	Matti Hamalainen <ccr@tnsp.org>
date	Fri, 27 Jan 2017 22:15:06 +0200
parents	563fc90de965
children	c731092a83b7

rev	line source
1074 48e16e856646 Use long tags. Matti Hamalainen <ccr@tnsp.org> parents: 1041 diff changeset	1 <?php
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	2
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	3 $dbVersion = 31;
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	4
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	5 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	6 // Site settings and defaults we put in
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	7 //
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 8e11a86204a9 Updated DB defs. Matti Hamalainen <ccr@tnsp.org> parents: 622 diff changeset	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
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	28 "showAdmin" => [VT_BOOL, false, "Always show administration interface link on the menu"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 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
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	31 "showResults" => [VT_BOOL, false, "Enable results page"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	32
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 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
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	35 "requireEMail" => [VT_BOOL, false, "Require e-mail address in registrations"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 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
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	38 "allowVoting" => [VT_BOOL, false, "Enable voting (individual compos must be enabled as well)"],
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" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	45 "showNews" => [VT_BOOL, true, "Enable News link on main menu + News page"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	46 "showNewsOnAbout" => [VT_BOOL, true, "Show latest news item on About page"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	47 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	48
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	49 //
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	50 // Event / schedule information
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	51 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	52 "event" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	53 "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	54
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	55 "msgEventDescription" => [VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	56 <h1>Event program & schedule</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	57 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	58 <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	59 <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	60 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	61
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	62 <h2>Friday 30.11.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	63 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	64 <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	65 <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	66 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	67
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	68 <h2>Saturday 1.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	69 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	70 <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	71 <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	72 <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	73 </ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	74
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	75 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	76
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	77 <h2>Sunday 2.12.</h2>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	78 <ul>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	79 <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	80 </ul>
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	81 ", "Event general description / timetables etc."],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	82
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	83 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	84
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 // Competitions
8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	87 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	88 "compos" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	89 "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	90
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	91 "msgCompoDescription" => [VT_TEXT, "
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	92 <h1>General</h1>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	93 <p class=\"notice\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	94 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	95 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	96
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	97 <p class=\"note\">
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	98 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	99 <br />
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	100 Remote entries are welcome!
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	101 </p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	102
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	103 <p>
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	104 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	105 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	106 prod is not AGA compatible.
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
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	109 <h1>Compos</h1>
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	110 ", "Compo general description"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	111 ],
710 27f7f437d7d1 Add new class of settings, etc. Matti Hamalainen <ccr@tnsp.org> parents: 705 diff changeset	112
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	113 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	114
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	115
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	116 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	117 // Database table definitions
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	118 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	119 $sqlTables = [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	120 // Site settings
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	121 "settings_groups" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	122 ["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	123 ["name" , "VARCHAR(64)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	124 ["description" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	125 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	126
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	127 "settings" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	128 ["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	129 ["vtype" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	130 ["vstr" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	131 ["vtext" , "TEXT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	132 ["vint" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	133 ["sdesc" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	134 ["vgroup" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	135 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	136
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	137 "news" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	138 ["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	139 ["utime" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	140 ["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	141 ["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	142 ["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	143 ["persist" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	144 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	145
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	146 "compos" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	147 ["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	148 ["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	149 ["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	150 ["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	151 ["visible" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	152 ["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	153
1034 8fecb417e6a9 Reintroduce per-entry preview_type. Matti Hamalainen <ccr@tnsp.org> parents: 981 diff changeset	154 // 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	155 // 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	156 ["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	157
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	158 ["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	159 // 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	160 // 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	161
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	162 ["ctype" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	163 ["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	164 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: 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 "entries" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	167 ["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	168 ["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	169 ["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	170 ["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	171 ["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	172 ["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	173 ["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	174 ["flags" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	175 ["evalue" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	176 ["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	177 ["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	178 ["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	179 ["utime" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	180 ["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	181 ],
822 fc555d954b99 Add preview_id to entries and the new files table for stored files. Matti Hamalainen <ccr@tnsp.org> parents: 821 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 "files" => [
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"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	185 ["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	186 ["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	187 ["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	188 ["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	189 ["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	190 ["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	191 ["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	192 ["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	193 ["utime" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	194 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	195
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	196 "attendees" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	197 ["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	198 ["regtime" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	199 ["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	200 ["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	201 ["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	202 ["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	203 ["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	204 ["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	205 ["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	206 ["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	207 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	208
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	209 "userkeys" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	210 ["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	211 ["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	212 ["active" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	213 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	214
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	215 "votes" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	216 ["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	217 ["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	218 ["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	219 ["value" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	220 ["utime" , "INT", "DEFAULT 0"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	221 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	222
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	223
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	224 // 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	225 "display_vars" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	226 ["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	227 ["vtype" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	228 ["vstr" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	229 ["vtext" , "TEXT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	230 ["vint" , "INT"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	231 ["sdesc" , "VARCHAR(128)"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	232 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	233
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	234 "display_slides" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	235 ["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	236 ["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	237 ["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	238 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	239
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	240 "rot_list_data" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	241 ["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	242 ["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	243 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	244
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	245 "rot_list_slides" => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	246 ["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	247 ["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	248 ["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	249 ["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	250 ],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	251 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	252
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	253
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	254 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	255 // Party information system settings / data
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	256 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	257 $siteDisplayVars = [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	258 "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	259 "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	260
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	261 "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	262 "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	263
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	264 "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	265 "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	266 "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	267
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	268 // Not user-manageable
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	269 "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	270
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	271 "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	272 "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	273 "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	274
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	275 "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	276 "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	277
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	278 "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	279
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	280 "screenCmd" => [VT_STR, "", "Off-channel showscreen command"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	281 "screenCmdSet" => [VT_BOOL, false, "Off-channel showscreen command has been set"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	282 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	283
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	284
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	285 //
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	286 // Some premade test data
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	287 //
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	288 $siteTestData = [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	289 "news" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	290 "utime,title,text,author",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	291 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	292 ["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	293 ["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	294 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	295
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	296 "userkeys" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	297 "key",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	298 "%s",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	299 ["test1"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	300 ["test2"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	301 ["test1"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	302 ["test2"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	303 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	304
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	305 "attendees" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	306 "regtime,name,groups,oneliner,email",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	307 "%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	308 [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	309 [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	310 [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	311 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	312
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	313 "compos" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	314 "name,description,visible,voting",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	315 "%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	316 ["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	317 ["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	318 ["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	319 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	320
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	321 "entries" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	322 "name,author,compo_id,filename,info",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	323 "%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	324 ["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	325 ["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	326 ["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	327 ["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	328 ["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	329 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	330
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	331 "display_slides" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	332 "title,text",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	333 "%s,%s",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	334 ["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	335 ["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	336 ["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	337 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	338
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	339 "rot_list_data" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	340 "name",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	341 "%s",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	342 ["Main rotation"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	343 ["Next Up"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	344 ],
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	345
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	346 "rot_list_slides" => [
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	347 "list_id,slide_id",
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	348 "%d,%d",
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	349 [1,2],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	350 [1,3],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	351 [2,1],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	352 ],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	353 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	354
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	355
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	356 $upgradeMappings = [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	357 // "" => ["key" => "", value => ""],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	358 12 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	359 "show_authors" => ["key" => "showAuthors"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	360 "display_vars" => ["table" => "displayVars"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	361 "display_slides" => ["table" => "displaySlides"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	362 "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	363 "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	364 ],
620 8444fe96120e Implement setting groups for admin interface settings. This is just the Matti Hamalainen <ccr@tnsp.org> parents: 587 diff changeset	365
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	366 14 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	367 "settings_groups" => ["table" => FALSE],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	368 ],
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	369
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	370 17 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	371 "ctype" => ["key" => "type"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	372 "cpath" => ["key" => "path"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	373 ],
1092 95b74632cfe2 Rename votekeys table to userkeys, and all related variables and settings. Matti Hamalainen <ccr@tnsp.org> parents: 1074 diff changeset	374
1096 bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	375 31 => [
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	376 "userkeys" => ["table" => "votekeys"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	377 "msgEventDescription" => ["key" => "eventDescription"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	378 "msgCompoDescription" => ["key" => "compoDescription"],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	379 ],
bbc0a3d0b51e Major renaming / refactor of site messages. Some that were previously Matti Hamalainen <ccr@tnsp.org> parents: 1094 diff changeset	380 ];
555 206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	381
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	382
206196b610fd Move site specific things to dbdefs.inc.php Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	383 ?>

Mercurial > hg > fapweb

annotate dbdefs.inc.php @ 1096:bbc0a3d0b51e