New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_myquizpoll_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] [French] [German] Fields Overview
Name
Title
Type
Exclude?
Details
title Title String input name Question Text area with RTE Transform like "Bodytext" qtype Question type Selectorbox 7 options category Category of this question Database relation tx_myquizpoll_category answer1 Answer 1 String input correct1 Is answer 1 correct? Checkbox, single points1 Scores for answer 1 Integer, 10-1000 joker1_1 Answer 1 checked at 50:50 joker? Checkbox, single joker2_1 Answer 1: percentage at audience joker Integer, 10-1000 category1 Category of the next question Database relation tx_myquizpoll_category answer2 Answer 2 String input correct2 Is answer 2 correct? Checkbox, single points2 Scores for answer 2 Integer, 10-1000 joker1_2 Answer 2 checked at 50:50 joker? Checkbox, single joker2_2 Answer 2: percentage at audience joker Integer, 10-1000 category2 Category of the next question Database relation tx_myquizpoll_category answer3 Answer 3 String input correct3 Is answer 3 correct? Checkbox, single points3 Scores for answer 3 Integer, 10-1000 joker1_3 Answer 3 checked at 50:50 joker? Checkbox, single joker2_3 Answer 3: percentage at audience joker Integer, 10-1000 category3 Category of the next question Database relation tx_myquizpoll_category answer4 Answer 4 String input correct4 Is answer 4 correct? Checkbox, single points4 Scores for answer 4 Integer, 10-1000 joker1_4 Answer 4 checked at 50:50 joker? Checkbox, single joker2_4 Answer 4: percentage at audience joker Integer, 10-1000 category4 Category of the next question Database relation tx_myquizpoll_category answer5 Answer 5 String input correct5 Is answer 5 correct? Checkbox, single points5 Scores for answer 5 Integer, 10-1000 joker1_5 Answer 5 checked at 50:50 joker? Checkbox, single joker2_5 Answer 5: percentage at audience joker Integer, 10-1000 category5 Category of the next question Database relation tx_myquizpoll_category explanation Explanation Text area with RTE Transform like "Bodytext" joker3 Answer of the telephone joker String input points Scores (for each correct answer) Integer, 10-1000 category_next Category of the next question Database relation tx_myquizpoll_category image Image Files webimages, 1 files, 500 kB alt_text Alternative text String input
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] title: Title name: Question qtype: Question type category: Category of this question answer1: Answer 1 correct1: Is answer 1 correct? points1: Scores for answer 1 joker1_1: Answer 1 checked at 50:50 joker? joker2_1: Answer 1: percentage at audience joker category1: Category of the next question answer2: Answer 2 correct2: Is answer 2 correct? points2: Scores for answer 2 joker1_2: Answer 2 checked at 50:50 joker? joker2_2: Answer 2: percentage at audience joker category2: Category of the next question answer3: Answer 3 correct3: Is answer 3 correct? points3: Scores for answer 3 joker1_3: Answer 3 checked at 50:50 joker? joker2_3: Answer 3: percentage at audience joker category3: Category of the next question answer4: Answer 4 correct4: Is answer 4 correct? points4: Scores for answer 4 joker1_4: Answer 4 checked at 50:50 joker? joker2_4: Answer 4: percentage at audience joker category4: Category of the next question answer5: Answer 5 correct5: Is answer 5 correct? points5: Scores for answer 5 joker1_5: Answer 5 checked at 50:50 joker? joker2_5: Answer 5: percentage at audience joker category5: Category of the next question explanation: Explanation joker3: Answer of the telephone joker points: Scores (for each correct answer) category_next: Category of the next question image: Image alt_text: Alternative text Descending "Type-field", if any: [none] title: Title name: Question qtype: Question type category: Category of this question answer1: Answer 1 correct1: Is answer 1 correct? points1: Scores for answer 1 joker1_1: Answer 1 checked at 50:50 joker? joker2_1: Answer 1: percentage at audience joker category1: Category of the next question answer2: Answer 2 correct2: Is answer 2 correct? points2: Scores for answer 2 joker1_2: Answer 2 checked at 50:50 joker? joker2_2: Answer 2: percentage at audience joker category2: Category of the next question answer3: Answer 3 correct3: Is answer 3 correct? points3: Scores for answer 3 joker1_3: Answer 3 checked at 50:50 joker? joker2_3: Answer 3: percentage at audience joker category3: Category of the next question answer4: Answer 4 correct4: Is answer 4 correct? points4: Scores for answer 4 joker1_4: Answer 4 checked at 50:50 joker? joker2_4: Answer 4: percentage at audience joker category4: Category of the next question answer5: Answer 5 correct5: Is answer 5 correct? points5: Scores for answer 5 joker1_5: Answer 5 checked at 50:50 joker? joker2_5: Answer 5: percentage at audience joker category5: Category of the next question explanation: Explanation joker3: Answer of the telephone joker points: Scores (for each correct answer) category_next: Category of the next question image: Image alt_text: Alternative text (What is this?) Label-field: [none] title: Title name: Question qtype: Question type category: Category of this question answer1: Answer 1 correct1: Is answer 1 correct? points1: Scores for answer 1 joker1_1: Answer 1 checked at 50:50 joker? joker2_1: Answer 1: percentage at audience joker category1: Category of the next question answer2: Answer 2 correct2: Is answer 2 correct? points2: Scores for answer 2 joker1_2: Answer 2 checked at 50:50 joker? joker2_2: Answer 2: percentage at audience joker category2: Category of the next question answer3: Answer 3 correct3: Is answer 3 correct? points3: Scores for answer 3 joker1_3: Answer 3 checked at 50:50 joker? joker2_3: Answer 3: percentage at audience joker category3: Category of the next question answer4: Answer 4 correct4: Is answer 4 correct? points4: Scores for answer 4 joker1_4: Answer 4 checked at 50:50 joker? joker2_4: Answer 4: percentage at audience joker category4: Category of the next question answer5: Answer 5 correct5: Is answer 5 correct? points5: Scores for answer 5 joker1_5: Answer 5 checked at 50:50 joker? joker2_5: Answer 5: percentage at audience joker category5: Category of the next question explanation: Explanation joker3: Answer of the telephone joker points: Scores (for each correct answer) category_next: Category of the next question image: Image alt_text: Alternative text (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc, all, and, asensitive, bigint, both, cascade, char, character, collate, column, connection, convert, current_date, current_user, databases, day_minute, decimal, default, delayed, describe, distinctrow, drop, else, escaped, explain, float, for, from, group, hour_microsecond, if, index, inout, int, int3, integer, is, leading, like, load, lock, longtext, match, mediumtext, minute_second, natural, null, optimize, or, outer, primary, raid0, real, release, replace, return, rlike, second_microsecond, separator, smallint, specific, sqlstate, sql_cal_found_rows, starting, terminated, tinyint, trailing, undo, unlock, usage, utc_date, values, varcharacter, where, write, year_month, call, condition, continue, cursor, declare, deterministic, each, elseif, exit, fetch, goto, insensitive, iterate, label, leave, loop, modifies, out, reads, repeat, schema, schemas, sensitive, sql, sqlexception, sqlwarning, trigger, upgrade, while FIELD: title FIELD: name FIELD: qtype FIELD: category
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: answer1 FIELD: correct1 FIELD: points1 FIELD: joker1_1 FIELD: joker2_1 FIELD: category1
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: answer2 FIELD: correct2 FIELD: points2 FIELD: joker1_2 FIELD: joker2_2 FIELD: category2
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: answer3 FIELD: correct3 FIELD: points3 FIELD: joker1_3 FIELD: joker2_3 FIELD: category3
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: answer4 FIELD: correct4 FIELD: points4 FIELD: joker1_4 FIELD: joker2_4 FIELD: category4
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: answer5 FIELD: correct5 FIELD: points5 FIELD: joker1_5 FIELD: joker2_5 FIELD: category5
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: explanation FIELD: joker3 FIELD: points FIELD: category_next
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: image
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Extensions:Imagefiles Web-imagefiles (gif,jpg,png) All files, except php/php3 extensions Max number of files Max filesize allowed (kb) Size of selector box Show thumbnails
FIELD: alt_text NEW FIELD: Load preset fields: __Fields picked up in this session__: myquizpoll-tables-4: Name (name, type: input) myquizpoll-tables-4: Internal notes (notes, type: textarea) myquizpoll-tables-2: Name (name, type: input) myquizpoll-tables-2: eMail (email, type: input) myquizpoll-tables-2: Homepage (homepage, type: input) myquizpoll-tables-2: IP-Address (ip, type: input) myquizpoll-tables-2: Scores or selected answer (p_or_a, type: integer) myquizpoll-tables-2: Maximum scores (p_max, type: integer) myquizpoll-tables-2: Percent (percent, type: integer) myquizpoll-tables-2: Overall maximum scores (o_max, type: integer) myquizpoll-tables-2: Overall percent (o_percent, type: integer) myquizpoll-tables-2: Answered question(s) (qids, type: rel) myquizpoll-tables-2: Correct answered questions (cids, type: rel) myquizpoll-tables-2: False answered questions (fids, type: rel) myquizpoll-tables-2: Skipped questions (sids, type: rel) myquizpoll-tables-2: 50:50 joker used? (joker1, type: check) myquizpoll-tables-2: Audience joker used? (joker2, type: check) myquizpoll-tables-2: Telephone joker used? (joker3, type: check) myquizpoll-tables-2: Starttime of the quiz (firsttime, type: datetime) myquizpoll-tables-2: Endtime of the Quiz (lasttime, type: datetime) myquizpoll-tables-2: Last category (lastcat, type: rel) myquizpoll-tables-2: Next category (nextcat, type: rel) myquizpoll-tables-2: Front end user id (fe_uid, type: rel) myquizpoll-tables-1: Title (title, type: input) myquizpoll-tables-1: Question (name, type: textarea_rte) myquizpoll-tables-1: Question type (qtype, type: select) myquizpoll-tables-1: Category of this question (category, type: rel) myquizpoll-tables-1: Answer 1 (answer1, type: input) myquizpoll-tables-1: Is answer 1 correct? (correct1, type: check) myquizpoll-tables-1: Scores for answer 1 (points1, type: integer) myquizpoll-tables-1: Answer 1 checked at 50:50 joker? (joker1_1, type: check) myquizpoll-tables-1: Answer 1: percentage at audience joker (joker2_1, type: integer) myquizpoll-tables-1: Category of the next question (category1, type: rel) myquizpoll-tables-1: Answer 2 (answer2, type: input) myquizpoll-tables-1: Is answer 2 correct? (correct2, type: check) myquizpoll-tables-1: Scores for answer 2 (points2, type: integer) myquizpoll-tables-1: Answer 2 checked at 50:50 joker? (joker1_2, type: check) myquizpoll-tables-1: Answer 2: percentage at audience joker (joker2_2, type: integer) myquizpoll-tables-1: Category of the next question (category2, type: rel) myquizpoll-tables-1: Answer 3 (answer3, type: input) myquizpoll-tables-1: Is answer 3 correct? (correct3, type: check) myquizpoll-tables-1: Scores for answer 3 (points3, type: integer) myquizpoll-tables-1: Answer 3 checked at 50:50 joker? (joker1_3, type: check) myquizpoll-tables-1: Answer 3: percentage at audience joker (joker2_3, type: integer) myquizpoll-tables-1: Category of the next question (category3, type: rel) myquizpoll-tables-1: Answer 4 (answer4, type: input) myquizpoll-tables-1: Is answer 4 correct? (correct4, type: check) myquizpoll-tables-1: Scores for answer 4 (points4, type: integer) myquizpoll-tables-1: Answer 4 checked at 50:50 joker? (joker1_4, type: check) myquizpoll-tables-1: Answer 4: percentage at audience joker (joker2_4, type: integer) myquizpoll-tables-1: Category of the next question (category4, type: rel) myquizpoll-tables-1: Answer 5 (answer5, type: input) myquizpoll-tables-1: Is answer 5 correct? (correct5, type: check) myquizpoll-tables-1: Scores for answer 5 (points5, type: integer) myquizpoll-tables-1: Answer 5 checked at 50:50 joker? (joker1_5, type: check) myquizpoll-tables-1: Answer 5: percentage at audience joker (joker2_5, type: integer) myquizpoll-tables-1: Category of the next question (category5, type: rel) myquizpoll-tables-1: Explanation (explanation, type: textarea_rte) myquizpoll-tables-1: Answer of the telephone joker (joker3, type: input) myquizpoll-tables-1: Scores (for each correct answer) (points, type: integer) myquizpoll-tables-1: Category of the next question (category_next, type: rel) myquizpoll-tables-1: Image (image, type: files) myquizpoll-tables-1: Alternative text (alt_text, type: input) myquizpoll-tables-3: User (user_id, type: rel) myquizpoll-tables-3: Question (question_id, type: rel) myquizpoll-tables-3: Text input (textinput, type: textarea) myquizpoll-tables-3: Answer 1 checked? (checked1, type: check) myquizpoll-tables-3: Answer 2 checked? (checked2, type: check) myquizpoll-tables-3: Answer 3 checked? (checked3, type: check) myquizpoll-tables-3: Answer 4 checked? (checked4, type: check) myquizpoll-tables-3: Answer 5 checked? (checked5, type: check) myquizpoll-tables-3: Scores (points, type: integer)
New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_myquizpoll_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] [French] [German] Fields Overview
Name
Title
Type
Exclude?
Details
name Name String input email eMail String input homepage Homepage String input ip IP-Address String input p_or_a Scores or selected answer Integer, 10-1000 p_max Maximum scores Integer, 10-1000 percent Percent Integer, 10-1000 o_max Overall maximum scores Integer, 10-1000 o_percent Overall percent Integer, 10-1000 qids Answered question(s) Database relation tx_myquizpoll_question cids Correct answered questions Database relation tx_myquizpoll_question fids False answered questions Database relation tx_myquizpoll_question sids Skipped questions Database relation tx_myquizpoll_question joker1 50:50 joker used? Checkbox, single joker2 Audience joker used? Checkbox, single joker3 Telephone joker used? Checkbox, single firsttime Starttime of the quiz Date and time lasttime Endtime of the Quiz Date and time lastcat Last category Database relation tx_myquizpoll_category nextcat Next category Database relation tx_myquizpoll_category fe_uid Front end user id Database relation fe_users
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] name: Name email: eMail homepage: Homepage ip: IP-Address p_or_a: Scores or selected answer p_max: Maximum scores percent: Percent o_max: Overall maximum scores o_percent: Overall percent qids: Answered question(s) cids: Correct answered questions fids: False answered questions sids: Skipped questions joker1: 50:50 joker used? joker2: Audience joker used? joker3: Telephone joker used? firsttime: Starttime of the quiz lasttime: Endtime of the Quiz lastcat: Last category nextcat: Next category fe_uid: Front end user id Descending "Type-field", if any: [none] name: Name email: eMail homepage: Homepage ip: IP-Address p_or_a: Scores or selected answer p_max: Maximum scores percent: Percent o_max: Overall maximum scores o_percent: Overall percent qids: Answered question(s) cids: Correct answered questions fids: False answered questions sids: Skipped questions joker1: 50:50 joker used? joker2: Audience joker used? joker3: Telephone joker used? firsttime: Starttime of the quiz lasttime: Endtime of the Quiz lastcat: Last category nextcat: Next category fe_uid: Front end user id (What is this?) Label-field: [none] name: Name email: eMail homepage: Homepage ip: IP-Address p_or_a: Scores or selected answer p_max: Maximum scores percent: Percent o_max: Overall maximum scores o_percent: Overall percent qids: Answered question(s) cids: Correct answered questions fids: False answered questions sids: Skipped questions joker1: 50:50 joker used? joker2: Audience joker used? joker3: Telephone joker used? firsttime: Starttime of the quiz lasttime: Endtime of the Quiz lastcat: Last category nextcat: Next category fe_uid: Front end user id (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc, all, and, asensitive, bigint, both, cascade, char, character, collate, column, connection, convert, current_date, current_user, databases, day_minute, decimal, default, delayed, describe, distinctrow, drop, else, escaped, explain, float, for, from, group, hour_microsecond, if, index, inout, int, int3, integer, is, leading, like, load, lock, longtext, match, mediumtext, minute_second, natural, null, optimize, or, outer, primary, raid0, real, release, replace, return, rlike, second_microsecond, separator, smallint, specific, sqlstate, sql_cal_found_rows, starting, terminated, tinyint, trailing, undo, unlock, usage, utc_date, values, varcharacter, where, write, year_month, call, condition, continue, cursor, declare, deterministic, each, elseif, exit, fetch, goto, insensitive, iterate, label, leave, loop, modifies, out, reads, repeat, schema, schemas, sensitive, sql, sqlexception, sqlwarning, trigger, upgrade, while FIELD: name FIELD: email FIELD: homepage FIELD: ip FIELD: p_or_a FIELD: p_max FIELD: percent FIELD: o_max FIELD: o_percent FIELD: qids
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
FIELD: cids
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
FIELD: fids
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
FIELD: sids
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
FIELD: joker1 FIELD: joker2 FIELD: joker3 FIELD: firsttime FIELD: lasttime FIELD: lastcat
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: nextcat
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: fe_uid
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) All tables allowed! Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Max number of relations Size of selector box True M-M relations (otherwise commalist of values)
NEW FIELD: Load preset fields: __Fields picked up in this session__: myquizpoll-tables-4: Name (name, type: input) myquizpoll-tables-4: Internal notes (notes, type: textarea) myquizpoll-tables-2: Name (name, type: input) myquizpoll-tables-2: eMail (email, type: input) myquizpoll-tables-2: Homepage (homepage, type: input) myquizpoll-tables-2: IP-Address (ip, type: input) myquizpoll-tables-2: Scores or selected answer (p_or_a, type: integer) myquizpoll-tables-2: Maximum scores (p_max, type: integer) myquizpoll-tables-2: Percent (percent, type: integer) myquizpoll-tables-2: Overall maximum scores (o_max, type: integer) myquizpoll-tables-2: Overall percent (o_percent, type: integer) myquizpoll-tables-2: Answered question(s) (qids, type: rel) myquizpoll-tables-2: Correct answered questions (cids, type: rel) myquizpoll-tables-2: False answered questions (fids, type: rel) myquizpoll-tables-2: Skipped questions (sids, type: rel) myquizpoll-tables-2: 50:50 joker used? (joker1, type: check) myquizpoll-tables-2: Audience joker used? (joker2, type: check) myquizpoll-tables-2: Telephone joker used? (joker3, type: check) myquizpoll-tables-2: Starttime of the quiz (firsttime, type: datetime) myquizpoll-tables-2: Endtime of the Quiz (lasttime, type: datetime) myquizpoll-tables-2: Last category (lastcat, type: rel) myquizpoll-tables-2: Next category (nextcat, type: rel) myquizpoll-tables-2: Front end user id (fe_uid, type: rel) myquizpoll-tables-1: Title (title, type: input) myquizpoll-tables-1: Question (name, type: textarea_rte) myquizpoll-tables-1: Question type (qtype, type: select) myquizpoll-tables-1: Category of this question (category, type: rel) myquizpoll-tables-1: Answer 1 (answer1, type: input) myquizpoll-tables-1: Is answer 1 correct? (correct1, type: check) myquizpoll-tables-1: Scores for answer 1 (points1, type: integer) myquizpoll-tables-1: Answer 1 checked at 50:50 joker? (joker1_1, type: check) myquizpoll-tables-1: Answer 1: percentage at audience joker (joker2_1, type: integer) myquizpoll-tables-1: Category of the next question (category1, type: rel) myquizpoll-tables-1: Answer 2 (answer2, type: input) myquizpoll-tables-1: Is answer 2 correct? (correct2, type: check) myquizpoll-tables-1: Scores for answer 2 (points2, type: integer) myquizpoll-tables-1: Answer 2 checked at 50:50 joker? (joker1_2, type: check) myquizpoll-tables-1: Answer 2: percentage at audience joker (joker2_2, type: integer) myquizpoll-tables-1: Category of the next question (category2, type: rel) myquizpoll-tables-1: Answer 3 (answer3, type: input) myquizpoll-tables-1: Is answer 3 correct? (correct3, type: check) myquizpoll-tables-1: Scores for answer 3 (points3, type: integer) myquizpoll-tables-1: Answer 3 checked at 50:50 joker? (joker1_3, type: check) myquizpoll-tables-1: Answer 3: percentage at audience joker (joker2_3, type: integer) myquizpoll-tables-1: Category of the next question (category3, type: rel) myquizpoll-tables-1: Answer 4 (answer4, type: input) myquizpoll-tables-1: Is answer 4 correct? (correct4, type: check) myquizpoll-tables-1: Scores for answer 4 (points4, type: integer) myquizpoll-tables-1: Answer 4 checked at 50:50 joker? (joker1_4, type: check) myquizpoll-tables-1: Answer 4: percentage at audience joker (joker2_4, type: integer) myquizpoll-tables-1: Category of the next question (category4, type: rel) myquizpoll-tables-1: Answer 5 (answer5, type: input) myquizpoll-tables-1: Is answer 5 correct? (correct5, type: check) myquizpoll-tables-1: Scores for answer 5 (points5, type: integer) myquizpoll-tables-1: Answer 5 checked at 50:50 joker? (joker1_5, type: check) myquizpoll-tables-1: Answer 5: percentage at audience joker (joker2_5, type: integer) myquizpoll-tables-1: Category of the next question (category5, type: rel) myquizpoll-tables-1: Explanation (explanation, type: textarea_rte) myquizpoll-tables-1: Answer of the telephone joker (joker3, type: input) myquizpoll-tables-1: Scores (for each correct answer) (points, type: integer) myquizpoll-tables-1: Category of the next question (category_next, type: rel) myquizpoll-tables-1: Image (image, type: files) myquizpoll-tables-1: Alternative text (alt_text, type: input) myquizpoll-tables-3: User (user_id, type: rel) myquizpoll-tables-3: Question (question_id, type: rel) myquizpoll-tables-3: Text input (textinput, type: textarea) myquizpoll-tables-3: Answer 1 checked? (checked1, type: check) myquizpoll-tables-3: Answer 2 checked? (checked2, type: check) myquizpoll-tables-3: Answer 3 checked? (checked3, type: check) myquizpoll-tables-3: Answer 4 checked? (checked4, type: check) myquizpoll-tables-3: Answer 5 checked? (checked5, type: check) myquizpoll-tables-3: Scores (points, type: integer)
New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_myquizpoll_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] [French] [German] Fields Overview
Name
Title
Type
Exclude?
Details
user_id User Database relation tx_myquizpoll_result question_id Question Database relation tx_myquizpoll_question textinput Text input Text area checked1 Answer 1 checked? Checkbox, single checked2 Answer 2 checked? Checkbox, single checked3 Answer 3 checked? Checkbox, single checked4 Answer 4 checked? Checkbox, single checked5 Answer 5 checked? Checkbox, single points Scores Integer, 10-1000
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] user_id: User question_id: Question textinput: Text input checked1: Answer 1 checked? checked2: Answer 2 checked? checked3: Answer 3 checked? checked4: Answer 4 checked? checked5: Answer 5 checked? points: Scores Descending "Type-field", if any: [none] user_id: User question_id: Question textinput: Text input checked1: Answer 1 checked? checked2: Answer 2 checked? checked3: Answer 3 checked? checked4: Answer 4 checked? checked5: Answer 5 checked? points: Scores (What is this?) Label-field: [none] user_id: User question_id: Question textinput: Text input checked1: Answer 1 checked? checked2: Answer 2 checked? checked3: Answer 3 checked? checked4: Answer 4 checked? checked5: Answer 5 checked? points: Scores (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc, all, and, asensitive, bigint, both, cascade, char, character, collate, column, connection, convert, current_date, current_user, databases, day_minute, decimal, default, delayed, describe, distinctrow, drop, else, escaped, explain, float, for, from, group, hour_microsecond, if, index, inout, int, int3, integer, is, leading, like, load, lock, longtext, match, mediumtext, minute_second, natural, null, optimize, or, outer, primary, raid0, real, release, replace, return, rlike, second_microsecond, separator, smallint, specific, sqlstate, sql_cal_found_rows, starting, terminated, tinyint, trailing, undo, unlock, usage, utc_date, values, varcharacter, where, write, year_month, call, condition, continue, cursor, declare, deterministic, each, elseif, exit, fetch, goto, insensitive, iterate, label, leave, loop, modifies, out, reads, repeat, schema, schemas, sensitive, sql, sqlexception, sqlwarning, trigger, upgrade, while FIELD: user_id
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: question_id
Field name: (Remove: )
Field title: [English] [French] [German]
Field type: String input String input, advanced Text area Text area with RTE Text area, No wrapping Checkbox, single Checkbox, 4 boxes in a row Checkbox, 10 boxes in two rows (max) Link Date Date and time Integer, 10-1000 Selectorbox Radio buttons Database relation Files Flex Not editable, only displayed [Passthrough] Is Exclude-field (What is this?) Create relation to table:Pages table, (pages) Frontend Users, (fe_users) Frontend Usergroups, (fe_groups) Content elements, (tt_content) Custom table (enter name below) Extension table: Quiz/Poll Question (tx_myquizpoll_question) Extension table: Quiz/Poll Result (tx_myquizpoll_result) Extension table: Quiz/Poll Relation (tx_myquizpoll_relation) Extension table: Quiz/Poll Category (tx_myquizpoll_category) Type:Field with Element Browser Selectorbox, select global Selectorbox, select from current page Selectorbox, select from root page Selectorbox, select from storage page Add a blank item to the selector Max number of relations Size of selector box True M-M relations (otherwise commalist of values) Add "Add record" link Add "List records" link Add "Edit record" link
FIELD: textinput FIELD: checked1 FIELD: checked2 FIELD: checked3 FIELD: checked4 FIELD: checked5 FIELD: points NEW FIELD: Load preset fields: __Fields picked up in this session__: myquizpoll-tables-4: Name (name, type: input) myquizpoll-tables-4: Internal notes (notes, type: textarea) myquizpoll-tables-2: Name (name, type: input) myquizpoll-tables-2: eMail (email, type: input) myquizpoll-tables-2: Homepage (homepage, type: input) myquizpoll-tables-2: IP-Address (ip, type: input) myquizpoll-tables-2: Scores or selected answer (p_or_a, type: integer) myquizpoll-tables-2: Maximum scores (p_max, type: integer) myquizpoll-tables-2: Percent (percent, type: integer) myquizpoll-tables-2: Overall maximum scores (o_max, type: integer) myquizpoll-tables-2: Overall percent (o_percent, type: integer) myquizpoll-tables-2: Answered question(s) (qids, type: rel) myquizpoll-tables-2: Correct answered questions (cids, type: rel) myquizpoll-tables-2: False answered questions (fids, type: rel) myquizpoll-tables-2: Skipped questions (sids, type: rel) myquizpoll-tables-2: 50:50 joker used? (joker1, type: check) myquizpoll-tables-2: Audience joker used? (joker2, type: check) myquizpoll-tables-2: Telephone joker used? (joker3, type: check) myquizpoll-tables-2: Starttime of the quiz (firsttime, type: datetime) myquizpoll-tables-2: Endtime of the Quiz (lasttime, type: datetime) myquizpoll-tables-2: Last category (lastcat, type: rel) myquizpoll-tables-2: Next category (nextcat, type: rel) myquizpoll-tables-2: Front end user id (fe_uid, type: rel) myquizpoll-tables-1: Title (title, type: input) myquizpoll-tables-1: Question (name, type: textarea_rte) myquizpoll-tables-1: Question type (qtype, type: select) myquizpoll-tables-1: Category of this question (category, type: rel) myquizpoll-tables-1: Answer 1 (answer1, type: input) myquizpoll-tables-1: Is answer 1 correct? (correct1, type: check) myquizpoll-tables-1: Scores for answer 1 (points1, type: integer) myquizpoll-tables-1: Answer 1 checked at 50:50 joker? (joker1_1, type: check) myquizpoll-tables-1: Answer 1: percentage at audience joker (joker2_1, type: integer) myquizpoll-tables-1: Category of the next question (category1, type: rel) myquizpoll-tables-1: Answer 2 (answer2, type: input) myquizpoll-tables-1: Is answer 2 correct? (correct2, type: check) myquizpoll-tables-1: Scores for answer 2 (points2, type: integer) myquizpoll-tables-1: Answer 2 checked at 50:50 joker? (joker1_2, type: check) myquizpoll-tables-1: Answer 2: percentage at audience joker (joker2_2, type: integer) myquizpoll-tables-1: Category of the next question (category2, type: rel) myquizpoll-tables-1: Answer 3 (answer3, type: input) myquizpoll-tables-1: Is answer 3 correct? (correct3, type: check) myquizpoll-tables-1: Scores for answer 3 (points3, type: integer) myquizpoll-tables-1: Answer 3 checked at 50:50 joker? (joker1_3, type: check) myquizpoll-tables-1: Answer 3: percentage at audience joker (joker2_3, type: integer) myquizpoll-tables-1: Category of the next question (category3, type: rel) myquizpoll-tables-1: Answer 4 (answer4, type: input) myquizpoll-tables-1: Is answer 4 correct? (correct4, type: check) myquizpoll-tables-1: Scores for answer 4 (points4, type: integer) myquizpoll-tables-1: Answer 4 checked at 50:50 joker? (joker1_4, type: check) myquizpoll-tables-1: Answer 4: percentage at audience joker (joker2_4, type: integer) myquizpoll-tables-1: Category of the next question (category4, type: rel) myquizpoll-tables-1: Answer 5 (answer5, type: input) myquizpoll-tables-1: Is answer 5 correct? (correct5, type: check) myquizpoll-tables-1: Scores for answer 5 (points5, type: integer) myquizpoll-tables-1: Answer 5 checked at 50:50 joker? (joker1_5, type: check) myquizpoll-tables-1: Answer 5: percentage at audience joker (joker2_5, type: integer) myquizpoll-tables-1: Category of the next question (category5, type: rel) myquizpoll-tables-1: Explanation (explanation, type: textarea_rte) myquizpoll-tables-1: Answer of the telephone joker (joker3, type: input) myquizpoll-tables-1: Scores (for each correct answer) (points, type: integer) myquizpoll-tables-1: Category of the next question (category_next, type: rel) myquizpoll-tables-1: Image (image, type: files) myquizpoll-tables-1: Alternative text (alt_text, type: input) myquizpoll-tables-3: User (user_id, type: rel) myquizpoll-tables-3: Question (question_id, type: rel) myquizpoll-tables-3: Text input (textinput, type: textarea) myquizpoll-tables-3: Answer 1 checked? (checked1, type: check) myquizpoll-tables-3: Answer 2 checked? (checked2, type: check) myquizpoll-tables-3: Answer 3 checked? (checked3, type: check) myquizpoll-tables-3: Answer 4 checked? (checked4, type: check) myquizpoll-tables-3: Answer 5 checked? (checked5, type: check) myquizpoll-tables-3: Scores (points, type: integer)
New Database Tables Add database tables which can be edited inside the backend. These tables will be added to the global TCA array in TYPO3. Tablename: tx_myquizpoll_Notice: Use characters a-z0-9 only. Only lowercase, no spaces.
This becomes the table name in the database. Title of the table: [English] [French] [German] Fields Overview
Name
Title
Type
Exclude?
Details
name Name String input notes Internal notes Text area
Edit Fields Add "Deleted" field (What is this?) Add "Hidden" flag (What is this?) Add "Starttime" (What is this?) Add "Endtime" (What is this?) Add "Access group" (What is this?) Enabled localization features (What is this?) Enable versioning (What is this?) Manual ordering of records (What is this?) If "Manual ordering" is not set, order the table by this field:[crdate] [cruser_id] [tstamp] name: Name notes: Internal notes Descending "Type-field", if any: [none] name: Name notes: Internal notes (What is this?) Label-field: [none] name: Name notes: Internal notes (What is this?) Default (white) Black Gray Blue Green Red Yellow Purple Default icon (What is this?) Allowed on pages: Allow records from this table to be created on regular pages.Allowed in "Insert Records" field in content elements: Allow records from this table to be linked to by content elements.Add "Save and new" button in forms: Will add an additional save-button to forms by which you can save the item and instantly create the next.Notice on fieldnames: Don't use fieldnames from this list of reserved names/words:
uid, pid, endtime, starttime, sorting, fe_group, hidden, deleted, cruser_id, crdate, tstamp, data, table, field, key, desc, all, and, asensitive, bigint, both, cascade, char, character, collate, column, connection, convert, current_date, current_user, databases, day_minute, decimal, default, delayed, describe, distinctrow, drop, else, escaped, explain, float, for, from, group, hour_microsecond, if, index, inout, int, int3, integer, is, leading, like, load, lock, longtext, match, mediumtext, minute_second, natural, null, optimize, or, outer, primary, raid0, real, release, replace, return, rlike, second_microsecond, separator, smallint, specific, sqlstate, sql_cal_found_rows, starting, terminated, tinyint, trailing, undo, unlock, usage, utc_date, values, varcharacter, where, write, year_month, call, condition, continue, cursor, declare, deterministic, each, elseif, exit, fetch, goto, insensitive, iterate, label, leave, loop, modifies, out, reads, repeat, schema, schemas, sensitive, sql, sqlexception, sqlwarning, trigger, upgrade, while FIELD: name FIELD: notes NEW FIELD: Load preset fields: __Fields picked up in this session__: myquizpoll-tables-4: Name (name, type: input) myquizpoll-tables-4: Internal notes (notes, type: textarea) myquizpoll-tables-2: Name (name, type: input) myquizpoll-tables-2: eMail (email, type: input) myquizpoll-tables-2: Homepage (homepage, type: input) myquizpoll-tables-2: IP-Address (ip, type: input) myquizpoll-tables-2: Scores or selected answer (p_or_a, type: integer) myquizpoll-tables-2: Maximum scores (p_max, type: integer) myquizpoll-tables-2: Percent (percent, type: integer) myquizpoll-tables-2: Overall maximum scores (o_max, type: integer) myquizpoll-tables-2: Overall percent (o_percent, type: integer) myquizpoll-tables-2: Answered question(s) (qids, type: rel) myquizpoll-tables-2: Correct answered questions (cids, type: rel) myquizpoll-tables-2: False answered questions (fids, type: rel) myquizpoll-tables-2: Skipped questions (sids, type: rel) myquizpoll-tables-2: 50:50 joker used? (joker1, type: check) myquizpoll-tables-2: Audience joker used? (joker2, type: check) myquizpoll-tables-2: Telephone joker used? (joker3, type: check) myquizpoll-tables-2: Starttime of the quiz (firsttime, type: datetime) myquizpoll-tables-2: Endtime of the Quiz (lasttime, type: datetime) myquizpoll-tables-2: Last category (lastcat, type: rel) myquizpoll-tables-2: Next category (nextcat, type: rel) myquizpoll-tables-2: Front end user id (fe_uid, type: rel) myquizpoll-tables-1: Title (title, type: input) myquizpoll-tables-1: Question (name, type: textarea_rte) myquizpoll-tables-1: Question type (qtype, type: select) myquizpoll-tables-1: Category of this question (category, type: rel) myquizpoll-tables-1: Answer 1 (answer1, type: input) myquizpoll-tables-1: Is answer 1 correct? (correct1, type: check) myquizpoll-tables-1: Scores for answer 1 (points1, type: integer) myquizpoll-tables-1: Answer 1 checked at 50:50 joker? (joker1_1, type: check) myquizpoll-tables-1: Answer 1: percentage at audience joker (joker2_1, type: integer) myquizpoll-tables-1: Category of the next question (category1, type: rel) myquizpoll-tables-1: Answer 2 (answer2, type: input) myquizpoll-tables-1: Is answer 2 correct? (correct2, type: check) myquizpoll-tables-1: Scores for answer 2 (points2, type: integer) myquizpoll-tables-1: Answer 2 checked at 50:50 joker? (joker1_2, type: check) myquizpoll-tables-1: Answer 2: percentage at audience joker (joker2_2, type: integer) myquizpoll-tables-1: Category of the next question (category2, type: rel) myquizpoll-tables-1: Answer 3 (answer3, type: input) myquizpoll-tables-1: Is answer 3 correct? (correct3, type: check) myquizpoll-tables-1: Scores for answer 3 (points3, type: integer) myquizpoll-tables-1: Answer 3 checked at 50:50 joker? (joker1_3, type: check) myquizpoll-tables-1: Answer 3: percentage at audience joker (joker2_3, type: integer) myquizpoll-tables-1: Category of the next question (category3, type: rel) myquizpoll-tables-1: Answer 4 (answer4, type: input) myquizpoll-tables-1: Is answer 4 correct? (correct4, type: check) myquizpoll-tables-1: Scores for answer 4 (points4, type: integer) myquizpoll-tables-1: Answer 4 checked at 50:50 joker? (joker1_4, type: check) myquizpoll-tables-1: Answer 4: percentage at audience joker (joker2_4, type: integer) myquizpoll-tables-1: Category of the next question (category4, type: rel) myquizpoll-tables-1: Answer 5 (answer5, type: input) myquizpoll-tables-1: Is answer 5 correct? (correct5, type: check) myquizpoll-tables-1: Scores for answer 5 (points5, type: integer) myquizpoll-tables-1: Answer 5 checked at 50:50 joker? (joker1_5, type: check) myquizpoll-tables-1: Answer 5: percentage at audience joker (joker2_5, type: integer) myquizpoll-tables-1: Category of the next question (category5, type: rel) myquizpoll-tables-1: Explanation (explanation, type: textarea_rte) myquizpoll-tables-1: Answer of the telephone joker (joker3, type: input) myquizpoll-tables-1: Scores (for each correct answer) (points, type: integer) myquizpoll-tables-1: Category of the next question (category_next, type: rel) myquizpoll-tables-1: Image (image, type: files) myquizpoll-tables-1: Alternative text (alt_text, type: input) myquizpoll-tables-3: User (user_id, type: rel) myquizpoll-tables-3: Question (question_id, type: rel) myquizpoll-tables-3: Text input (textinput, type: textarea) myquizpoll-tables-3: Answer 1 checked? (checked1, type: check) myquizpoll-tables-3: Answer 2 checked? (checked2, type: check) myquizpoll-tables-3: Answer 3 checked? (checked3, type: check) myquizpoll-tables-3: Answer 4 checked? (checked4, type: check) myquizpoll-tables-3: Answer 5 checked? (checked5, type: check) myquizpoll-tables-3: Scores (points, type: integer)