fapweb: dbdefs.inc.php annotate

annotate dbdefs.inc.php @ 1098:c731092a83b7

Add msgNewsHeader back to configurables.

author	Matti Hamalainen <ccr@tnsp.org>
date	Mon, 30 Jan 2017 10:34:48 +0200
parents	bbc0a3d0b51e
children	0a2117349f46

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

Mercurial > hg > fapweb

annotate dbdefs.inc.php @ 1098:c731092a83b7