createDatabase¶

clean¶

LS¶

LS Library autoloader

scanFile¶

setSeed¶

Set seed for this response If there is no seed, create a new one Also inits the twister.

shuffle¶

Shuffle an array using MersenneTwister Argument NOT called by reference!

App¶

Helper function to replace calls to Yii::app() and enable correct code completion.

traceVar¶

If debug = 2 in application/config.php this will produce output in the console / firebug similar to var_dump. It will also include the filename and line that called this method.

ldap_getCnx¶

ldap_bindCnx¶

ldap_readattr¶

ldap_search_withScope¶

ldap_doTokenSearch¶

prepareLDAPQuery¶

cmpErrorTokens¶

Used by usort() to order Error tokens by their position within the string This must be outside of the class in order to work in PHP 5.2

exprmgr_count¶

Count the number of answered questions (non-empty)

exprmgr_countif¶

Count the number of answered questions (non-empty) which match the first argument

exprmgr_countifop¶

Count the number of answered questions (non-empty) which meet the criteria (arg op value)

exprmgr_stripos¶

Find position of first occurrence of unicode string in a unicode string, case insensitive

exprmgr_stristr¶

Finds first occurrence of a unicode string within another, case-insensitive

exprmgr_strlen¶

Get unicode string length

exprmgr_strpos¶

Find position of first occurrence of unicode string in a unicode string

exprmgr_strstr¶

Finds first occurrence of a unicode string within another

exprmgr_strtolower¶

Make an unicode string lowercase

exprmgr_strtoupper¶

Make an unicode string uppercase

exprmgr_substr¶

Get part of unicode string

exprmgr_sumifop¶

Sum of values of answered questions which meet the criteria (arg op value)

exprmgr_convert_value¶

Find the closest matching numerical input values in a list an replace it by the corresponding value within another list

exprmgr_date¶

Return format a local time/date Need to test if timestamp is numeric (else E_WARNING with debug>0)

exprmgr_if¶

If $test is true, return $iftrue, else return $iffalse

exprmgr_int¶

Return true if the variable is an integer for LimeSurvey Can not really use is_int due to SQL DECIMAL system. This function can surely be improved

exprmgr_list¶

Join together $args[0-N] with ', '

exprmgr_log¶

return log($arg[0],$arg[1]=e)

exprmgr_mktime¶

Get Unix timestamp for a date : false if parameters is invalid.

exprmgr_join¶

Join together $args[N]

exprmgr_implode¶

Join together $args[1-N] with $arg[0]

exprmgr_empty¶

Return true if the variable is NULL or blank.

exprmgr_stddev¶

Compute the Sample Standard Deviation of a set of numbers ($args[0-N])

expr_mgr_htmlspecialchars¶

Javascript equivalent does not cope well with ENT_QUOTES and related PHP constants, so set default to ENT_QUOTES

expr_mgr_htmlspecialchars_decode¶

Javascript equivalent does not cope well with ENT_QUOTES and related PHP constants, so set default to ENT_QUOTES

exprmgr_regexMatch¶

Return true if $input matches the regular expression $pattern

geterrors_exprmgr_regexMatch¶

Return error information from pattern of regular expression $pattern

exprmgr_fixnum¶

Display number with comma as radix separator, if needed

exprmgr_unique¶

Returns true if all non-empty values are unique

cmpQuestionSeq¶

Used by usort() to order $this->questionSeq2relevance in proper order

setNoAnswerMode¶

setNoAnswerMode

retrieveAnswers¶

This function returns an array containing the "question/answer" html display and a list of the question/answer fieldnames associated. It is called from question.php, group.php, survey.php or preview.php

mandatory_message¶

validation_message¶

file_validation_message¶

mandatory_popup¶

validation_popup¶

file_validation_popup¶

return_timer_script¶

currentRelevecanceClass¶

Return class of a specific row (hidden by relevance)

return_display_style¶

return_array_filter_strings¶

testKeypad¶

do_boilerplate¶

do_equation¶

do_5pointchoice¶

do_date¶

do_language¶

do_list_dropdown¶

do_list_radio¶

do_listwithcomment¶

do_ranking¶

do_multiplechoice¶

do_multiplechoice_withcomments¶

do_file_upload¶

do_multipleshorttext¶

do_multiplenumeric¶

do_numerical¶

do_shortfreetext¶

getLatLongFromIp¶

do_longfreetext¶

do_hugefreetext¶

do_yesno¶

do_gender¶

do_array_5point¶

Construct answer part array_5point

do_array_10point¶

do_array_yesnouncertain¶

do_array_increasesamedecrease¶

do_array¶

do_array_texts¶

do_array_multiflexi¶

do_arraycolumns¶

do_array_dual¶

getLabelInputWidth¶

Find the label / input width

fillDate¶

Take a date string and fill out missing parts, like day, hour, minutes (not seconds).

doRender¶

Render the question view.

injectglobalsettings¶

getGlobalSetting¶

Returns a global setting

setGlobalSetting¶

gT¶

Translation helper function

eT¶

Translation helper function which outputs right away.

ngT¶

Translation helper function for plural forms

neT¶

Translation helper function for plural forms which outputs right away

quoteText¶

Quotes a translation according to purpose if sEscapeMode is null, we use HTML method because probably we had to specify null as sEscapeMode upstream

getQuestionTypeList¶

getQuestionTypeList() Returns list of question types available in LimeSurvey. Edit this if you are adding a new question type

isStandardTemplate¶

isStandardTemplate returns true if a template is a standard template This function does not check if a template actually exists

getSurveyList¶

getSurveyList() Queries the database (survey table) for a list of existing surveys

getTemplateList¶

getGidPrevious¶

getGidPrevious() returns the Gid of the group prior to the current active group

getGidNext¶

getGidNext() returns the Gid of the group next to the current active group

convertGETtoPOST¶

calculateTotalFileUploadUsage¶

This function calculates how much space is actually used by all files uploaded using the File Upload question type

getDirectorySize¶

getMaxGroupOrder¶

Queries the database for the maximum sortorder of a group and returns the next higher one.

getGroupOrder¶

getGroupOrder($surveyid,$gid) queries the database for the sortorder of a group.

getMaxQuestionOrder¶

Queries the database for the maximum sort order of a question.

getQuestionClass¶

getQuestionClass() returns a class name for a given question type to allow custom styling for each question type.

setupColumns¶

setupColumns() defines all the html tags to be wrapped around various list type answers.

alternation¶

longestString¶

longestString() returns the length of the longest string past to it.

getGroupList¶

getGroupList() queries the database for a list of all groups matching the current survey sid

getGroupList3¶

getGroupListLang¶

put your comment there.

getUserList¶

getSurveyInfo¶

Gets all survey infos in one big array including the language specific settings

templateDefaultTexts¶

Returns the default email template texts as array

groupOrderThenQuestionOrder¶

Compares two elements from an array (passed by the usort function) and returns -1, 0 or 1 depending on the result of the comparison of the sort order of the group_order and question_order field

shiftOrderQuestions¶

fixSortOrderGroups¶

fixMovedQuestionConditions¶

returnGlobal¶

This function returns POST/REQUEST vars, for some vars like SID and others they are also sanitized TODO: extends Yii:getParam

sendCacheHeaders¶

getExtendedAnswer¶

validateEmailAddress¶

Validate an email address - also supports IDN email addresses

validateEmailAddresses¶

Validate an list of email addresses - either as array or as semicolon-limited text

createCompleteSGQA¶

This functions generates a a summary containing the SGQA for questions of a survey, enriched with options per question It can be used for the generation of statistics. Derived from Statistics_userController

createFieldMap¶

This function generates an array containing the fieldcode, and matching data in the same order as the activate script

hasFileUploadQuestion¶

Returns true if the given survey has a File Upload Question Type

createTimingsFieldMap¶

This function generates an array containing the fieldcode, and matching data in the same order as the activate script

arraySearchByKey¶

getSavedCount¶

This function returns a count of the number of saved responses to a survey

buildLabelSetCheckSumArray¶

getQuestionAttributeValue¶

Returns the questionAttribtue value set or '' if not set

categorySort¶

HTMLEscape¶

stripCtrlChars¶

This function strips UTF-8 control characters from strings, except tabs, CR and LF - it is intended to be used before any response data is saved to the response table

javascriptEscape¶

SendEmailMessage¶

This function mails a text $body to the recipient $to.

flattenText¶

This functions removes all HTML tags, Javascript, CRs, linefeeds and other strange chars from a given text

getArrayFilterExcludesCascadesForGroup¶

getArrayFilterExcludesCascadesForGroup() queries the database and produces a list of array_filter_exclude questions and targets with in the same group

createPassword¶

languageDropdown¶

languageDropdownClean¶

Creates a <select> HTML element for language selection for this survey

rmdirr¶

This function removes a directory recursively

CSVUnquote¶

This function removes surrounding and masking quotes from the CSV field

incompleteAnsFilterState¶

This function return actual completion state

isCaptchaEnabled¶

isCaptchaEnabled($screen, $usecaptchamode)

tableExists¶

Check if a table does exist in the database

isTokenCompletedDatestamped¶

dateShift¶

example usage $date = "2006-12-31 21:00"; $shift "+6 hours"; // could be days, weeks.

getBounceEmail¶

getEmailFormat¶

hasTemplateManageRights¶

translateLinks¶

Translate links which are in any answer/question/survey/email template/label set to their new counterpart

reverseTranslateFieldNames¶

This function creates the old fieldnames for survey import

hasResources¶

put your comment there.

randomChars¶

Creates a random sequence of characters

conditionalNewlineToBreak¶

used to translate simple text to html (replacing \n with <br />

breakToNewline¶

safeDie¶

Provides a safe way to end the application

fixCKeditorText¶

filterForAttributes¶

This is a helper function for getAttributeFieldNames

getAttributeFieldNames¶

Retrieves the attribute field names from the related survey participants table

getParticipantAttributes¶

Returns the full list of attribute token fields including the properties for each field Use this instead of plain Survey::model()->findByPk($iSurveyID)->tokenAttributes calls because Survey::model()->findByPk($iSurveyID)->tokenAttributes may contain old descriptions where the fields does not physically exist

getTokenFieldsAndNames¶

Retrieves the attribute names from the related survey participants table

stripJavaScript¶

This function strips any content between and including <javascript> tags

showJavaScript¶

This function converts emebedded Javascript to Text

cleanTempDirectory¶

This function cleans files from the temporary directory being older than 1 day

useFirebug¶

convertDateTimeFormat¶

This is a convenience function for the coversion of datetime values

convertToGlobalSettingFormat¶

This is a convenience function to convert any date, in any date format, to the global setting date format Check if the time shoul be rendered also

removeBOM¶

This function removes the UTF-8 Byte Order Mark from a string

getTemplatePath¶

This function returns the complete directory path to a given template name

getTemplateURL¶

This function returns the complete URL path to a given template name

getSubQuestions¶

Return an array of subquestions for a given sid/qid

getXMLWriter¶

Wrapper function to retrieve an xmlwriter object and do error handling if it is not compiled into PHP

SSLRedirect¶

SSLRedirect() generates a redirect URL for the appropriate SSL mode then applies it.

enforceSSLMode¶

enforceSSLMode() $force_ssl is on or off, it checks if the current request is to HTTPS (or not). If $force_ssl is on, and the request is not to HTTPS, it redirects the request to the HTTPS version of the URL, if the request is to HTTPS, it rewrites all the URL variables so they also point to HTTPS.

getFullResponseTable¶

Creates an array with details on a particular response for display purposes Used in Print answers, Detailed response view and Detailed admin notification email

isNumericInt¶

Check if $str is an integer, or string representation of an integer

short_implode¶

Implode and sort content array for very long arrays

includeKeypad¶

Include Keypad headers

translateInsertansTags¶

This function replaces the old insertans tags with new ones across a survey

replaceExpressionCodes¶

Replaces EM variable codes in a current survey with a new one

cleanLanguagesFromSurvey¶

cleanLanguagesFromSurvey() removes any languages from survey tables that are not in the passed list

fixLanguageConsistency¶

fixLanguageConsistency() fixes missing groups, questions, answers, quotas & assessments for languages on a survey

switchMSSQLIdentityInsert¶

This function switches identity insert on/off for the MSSQL database

getLastInsertID¶

Retrieves the last Insert ID realiable for cross-DB applications

getGroupDepsForConditions¶

getGroupDepsForConditions() get Dependencies between groups caused by conditions

getQuestDepsForConditions¶

getQuestDepsForConditions() get Dependencies between groups caused by conditions

checkMoveQuestionConstraintsForConditions¶

checkMoveQuestionConstraintsForConditions()

getUserGroupList¶

Get a list of all user groups

getGroupUserList¶

modifyDatabase¶

Run an arbitrary sequence of semicolon-delimited SQL commands

getLabelSets¶

Returns labelsets for given language(s), or for all if null

getHeader¶

get the header

doHeader¶

getPrintableHeader¶

This function returns the header for the printable survey

getFooter¶

This function returns the Footer as result string If you want to echo the Footer use doFooter()!

doFooter¶

getSurveyUserList¶

Retrieve a HTML <OPTION> list of survey admin users

getSurveyUserGroupList¶

Return HTML <option> list of user groups

fixSubquestions¶

This function fixes the group ID and type on all subquestions Optimized for minimum memory usage even on huge databases

ls_json_encode¶

Must use ls_json_encode to json_encode content, otherwise LimeExpressionManager will think that the associative arrays are expressions and try to parse them.

json_decode_ls¶

Decode a json string, sometimes needs stripslashes

aEncodingsArray¶

Return accepted codingsArray for importing files

ellipsize¶

Ellipsize String

getIPAddress¶

This function tries to returns the 'real' IP address under all configurations Do not rely security-wise on the detected IP address as except for REMOTE_ADDR all fields could be manipulated by the web client

getBrowserLanguage¶

This function tries to find out a valid language code for the language of the browser used If it cannot find it it will return the default language from global settings

array_diff_assoc_recursive¶

folderSize¶

Calculate folder size NB: If this function is changed, please notify LimeSurvey GmbH.

humanFilesize¶

Format size in human readable format.

convertPHPSizeToBytes¶

This function transforms the php.ini notation for numbers (like '2M') to an integer (2*1024*1024 in this case)

getMaximumFileUploadSize¶

decodeTokenAttributes¶

Decodes token attribute data because due to bugs in the past it can be written in JSON or be serialized - future format should be JSON as serialized data can be exploited

getSerialClass¶

regenerateCSRFToken¶

Force Yii to create a new CSRF token by removing the old one

get_absolute_path¶

A function to remove .

getDateFormatData¶

Returns all available dateformats in a structured aray If $iDateFormat is given only the particual dateformat will be returned

getLanguageData¶

getRadixPointData¶

Returns avaliable formats for Radix Points (Decimal Separators) or returns radix point info about a specific format.

getPHPDateFromDateFormat¶

Convert a 'dateformat' format string to a 'phpdate' format.

getJSDateFromDateFormat¶

Convert a 'dateformat' format string to a 'jsdate' format.

getDateFormatDataForQID¶

Get the date format details for a specific question.

getDateFormatForSID¶

Get the date format for a specified survey

canShowDatePicker¶

Check whether we can show the JS date picker with the current format

getLanguageCodefromLanguage¶

getLanguageNameFromCode¶

Returns a language name from the code

getLanguageRTL¶

getLanguageDetails¶

Returns the locale settings for a certain language code

convertLStoDateTimePickerLocale¶

This functions translates LimeSurvey specific locale code to a matching datetimepicker locale

getLanguageDataRestricted¶

userSort¶

userSortNative¶

UTF8Strrev¶

This function support the ability NOT to reverse numbers (for example when you output a phrase as a parameter for a SWF file that can't handle RTL languages itself, but obviously any numbers should remain the same as in the original phrase).

templatereplace¶

This function replaces keywords in a text and is mainly intended for templates If you use this functions put your replacement strings into the $replacements variable instead of using global variables NOTE - Don't do any embedded replacements in this function. Create the array of replacement values and they will be done in batch at the end

getStandardsReplacementFields¶

ReplaceFields¶

PassthruReplace¶

passthruReplace() takes a string and looks for {PASSTHRU:myarg} variables which it then substitutes for parameter data sent in the initial URL and stored in the session array containing responses

dbExecuteAssoc¶

dbRandom¶

Return the random function to use in ORDER BY sql statements

dbSelectTablesLike¶

Return a sql statement for finding LIKE named tables Be aware that you have to escape underscore chars by using a backslash otherwise you might get table names returned you don't want

dbGetTablesLike¶

Gets the table names. Do not prefix.

loadanswers¶

getLanguageChangerDatas¶

This function creates the language selector for a particular survey

getLanguageChangerDatasPublicList¶

This function creates the language selector for the public survey index page

checkUploadedFileValidity¶

checkUploadedFileValidity used in SurveyRuntimeHelper

addtoarray_single¶

Takes two single element arrays and adds second to end of first if value exists Why not use array_merge($array1,array_filter($array2);

submittokens¶

Marks a tokens as completed and sends a confirmation email to the participiant.

sendSubmitNotifications¶

Send a submit notification to the email address specified in the notifications tab in the survey settings

submitfailed¶

submitfailed : used in em_manager_helper.php

buildsurveysession¶

This function builds all the required session variables when a survey is first started and it loads any answer defaults from command line or from the table defaultvalues It is called from the related format script (group.php, question.php, survey.php) if the survey has just started.

checkPassthruLabel¶

Check if a passthru label and value have been included in the query url

prefillFromCommandLine¶

Prefill startvalues from command line param

initFieldArray¶

randomizationGroupsAndQuestions¶

Apply randomizationGroup and randomizationQuestion to session fieldmap

randomizationGroup¶

Randomization group for groups

randomizationQuestion¶

Randomization group for questions

finalizeRandomization¶

Stuff?

testIfTokenIsValid¶

Test if token is valid

getRenderWay¶

Returns which way should be rendered

renderRenderWayForm¶

Render token, captcha or register form

resetAllSessionVariables¶

Resets all session variables for this survey

setTotalSteps¶

The number of "pages" that will be presented in this survey The number of pages to be presented will differ depending on the survey format Set totalsteps in session

breakOutAndCrash¶

renderError¶

getNavigatorDatas¶

TODO: call this function from surveyRuntimeHelper TODO: remove surveymover()

doAssessment¶

Caculate assessement scores

UpdateGroupList¶

Update SESSION VARIABLE: grouplist A list of groups in this survey, ordered by group name.

updateFieldArray¶

FieldArray contains all necessary information regarding the questions This function is needed to update it in case the survey is switched to another language

checkCompletedQuota¶

checkCompletedQuota() returns matched quotas information for the current response

encodeEmail¶

encodeEmail : encode admin email in public part

getReferringUrl¶

GetReferringUrl() returns the referring URL

display_first_page¶

Shows the welcome page, used in group by group and question by question mode

killSurveySession¶

killSurveySession : reset $_SESSION part for the survey

resetTimers¶

Resets all question timers by expiring the related cookie - this needs to be called before any output is done

SetSurveyLanguage¶

Set the public survey language Control if language exist in this survey, else set to survey default language if $surveyid <= 0 : set the language to default site language

getMove¶

getMove get move button clicked

getSideBodyClass¶

Get the margin class for side-body div depending on side-menu behaviour config and page (edit or not etc).

cookieConsentLocalization¶

For later use, don't remove.

stripTagsFull¶

Strips html tags and replaces new lines

isNumericExtended¶

Returns true if passed $value is numeric

strSplitUnicode¶

Returns splitted unicode string correctly source: http://www.php.net/manual/en/function.str-split.php#107658

SPSSExportData¶

Exports CSV response data for SPSS and R

SPSSGetValues¶

Check it the gives field has a labelset and return it as an array if true

SPSSFieldMap¶

Creates a fieldmap with all information necessary to output the fields

SPSSGetQuery¶

Creates a query string with all fields for the export

buildXMLFromQuery¶

buildXMLFromQuery() creates a datadump of a table in XML using XMLWriter

surveyGetXMLStructure¶

from export_structure_xml.php

surveyGetXMLData¶

from export_structure_xml.php

getXMLDataSingleTable¶

Exports a single table to XML

QueXMLCleanup¶

from export_structure_quexml.php

QueXMLCreateFree¶

from export_structure_quexml.php

QueXMLFixedArray¶

from export_structure_quexml.php

QueXMLSkipTo¶

Calculate if this item should have a QueXMLSkipTo element attached to it

QueXMLCreateFixed¶

from export_structure_quexml.php

quexml_get_lengthth¶

from export_structure_quexml.php

quexml_create_multi¶

from export_structure_quexml.php

quexml_create_subQuestions¶

from export_structure_quexml.php

quexml_set_default_value¶

Set defaultValue attribute of provided element from response table

quexml_create_question¶

Create a queXML question element

quexml_export¶

Export quexml survey.

group_export¶

groupGetXMLStructure¶

questionExport¶

questionGetXMLStructure¶

tokensExport¶

CPDBExport¶

stringSize¶

Find the string size according DB size for existing question Column name must be SGQA currently

numericSize¶

Find the numeric size according DB size for existing question for SPSS export Column name must be SGQA currently

nice_addslashes¶

sanitize_filename¶

Function: sanitize_filename Returns a sanitized string, typically for URLs.

beautify_filename¶

sanitize_dirname¶

Function: sanitize_dirname sanitizes a string that will be used as a directory name

sanitize_paranoid_string¶

sanitize_cquestions¶

sanitize_system_string¶

sanitize_xss_string¶

sanitize_sql_db_tablename¶

sanitize_ldap_string¶

sanitize_html_string¶

sanitize_int¶

sanitize_user¶

sanitize_userfullname¶

sanitize_labelname¶

sanitize_float¶

sanitize¶

check_paranoid_string¶

check_int¶

check_float¶

check_html_string¶

check_ldap_string¶

check_system_string¶

check¶

sanitize_languagecode¶

sanitize_languagecodeS¶

sanitize_signedint¶

emailTokens¶

Sends email to tokens - invitations, reminders, registers, and confirmations

getSurveyDefaultSettings¶

fixNumbering¶

fixes the numbering of questions This can happen if question 1 have subquestion code 1 and have question 11 in same survey and group (then same SGQA)

checkGroup¶

checks consistency of groups

checkQuestions¶

checks questions in a survey for consistency

activateSurvey¶

Function to activate a survey

mssql_drop_constraint¶

mssql_drop_primary_index¶

XMLImportGroup¶

This function imports a LimeSurvey .lsg question group XML file

XMLImportQuestion¶

This function imports a LimeSurvey .lsq question XML file

XMLImportLabelsets¶

XMLImportLabelsets() Function resp[onsible to import a labelset from XML format.

importSurveyFile¶

XMLImportSurvey¶

This function imports a LimeSurvey .lss survey XML file

GetNewSurveyID¶

This function returns a new random sid if the existing one is taken, otherwise it returns the old one.

XMLImportTokens¶

XMLImportResponses¶

CSVImportResponses¶

This function imports a CSV file into the response table

XMLImportTimings¶

XSSFilterArray¶

TSVImportSurvey¶

Import survey from an TSV file template that does not require or allow assigning of GID or QID values.

updateset¶

deletelabelset¶

Deletes a label set alog with its labels

insertlabelset¶

modlabelsetanswers¶

fixorder¶

Function rewrites the sortorder for a label set

initKcfinder¶

sTranslateLangCode2CK¶

PrepareEditorScript¶

getEditor¶

getPopupEditor¶

getInlineEditor¶

createChart¶

Generate a chart for a question

getQuestionMapData¶

Return data to populate a Google Map

buildSelects¶

Builds the list of addon SQL select statements that builds the query result set

square¶

Simple function to square a value

doreplacement¶

getListOfFiles¶

mkdir_p¶

themeoptions¶

multiarray_search¶

recursive_in_array¶

is_template_editable¶

This function checks if a certain template may be by modified, copied, deleted according to the settings in config.php

templateExtractFilter¶

This is a PCLZip callback function that ensures only files are extracted that have a valid extension

outputDatabase¶

Outputs a full dump of the current LimeSurvey database

_outputDBDescription¶

_outputDBData¶

_outputTableDescription¶

Outputs the table structure in sql format

_outputTableData¶

Outputs the table data in sql format

_outputRecords¶

_countNumberOfEntries¶

_getMaxNbRecords¶

_getDbName¶

Get the database name

createChart¶

Generate a chart for a question

getQuestionMapData¶

Return data to populate a Google Map

buildSelects¶

Builds the list of addon SQL select statements that builds the query result set

square¶

Simple function to square a value

db_upgrade_all¶

resetTutorials337¶

upgrade333¶

upgrade331¶

upgrade330¶

upgrade328¶

upgrade327¶

transferPasswordFieldToText¶

createSurveyMenuTable¶

createSurveyGroupTables306¶

upgradeTemplateTables304¶

upgradeTemplateTables298¶

upgradeTokenTables256¶

upgradeSurveyTables255¶

upgradeSurveyTables254¶

upgradeSurveyTables253¶

upgradeBoxesTable251¶

createBoxes250¶

Create boxes table

fixKCFinder184¶

upgradeSurveyTables183¶

upgradeSurveyTables181¶

upgradeTokenTables181¶

upgradeTokenTables179¶

upgradeSurveys177¶

upgradeTokens176¶

This function removes the old CPDB fields in token tables replaces them with standard attribute fields and records the mapping information in the attributedescription field in the survey table instead

upgradeCPDBAttributeDefaultNames173¶

upgradePermissions166¶

Converts global permissions from users table to the new permission system, and converts template permissions from template_rights to new permission table

upgradeSurveyTables164¶

Make sure all active tables have the right sized token field

upgradeSurveys156¶

upgradeTokens148¶

upgradeQuestionAttributes148¶

upgradeSurveyTimings146¶

upgradeTokens145¶

upgradeSurveys145¶

upgradeSurveyPermissions145¶

upgradeTables143¶

upgradeQuestionAttributes142¶

upgradeSurveyTables139¶

upgradeTokenTables134¶

alterColumn¶

addColumn¶

setTransactionBookmark¶

Set a transaction bookmark - this is critical for Postgres because a transaction in Postgres cannot be continued unless you roll back to the transaction bookmark first

rollBackToTransactionBookmark¶

Roll back to a transaction bookmark

dropDefaultValueMSSQL¶

Drop a default value in MSSQL

dropUniqueKeyMSSQL¶

This function drops a unique Key of an MSSQL database field by using the field name and the table name

dropSecondaryKeyMSSQL¶

This function drops a secondary key of an MSSQL database field by using the field name and the table name

dropPrimaryKey¶

Drops the primary key of a table

addPrimaryKey¶

modifyPrimaryKey¶

Modifies a primary key in one command - this is only tested on MySQL

fixMySQLCollations¶

dropColumn¶

Drops a column, automatically removes blocking default value on MSSQL

alterLanguageCode¶

Renames a language code in the whole LimeSurvey database

fixLanguageConsistencyAllSurveys¶

CheckForDBUpgrades¶

This functions checks if the databaseversion in the settings table is the same one as required If not then the necessary upgrade procedures are run

ShowDBUpgradeNotice¶

getDBConnectionStringProperty¶

SureRemoveDir¶

SureRemoveDir¶

ignore¶

iterateList¶

checkFile¶

checkStatic¶

pr¶

subval_sort¶