| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/limesurvey/application/commands/ |
Upload File : |
<?php
/*
* LimeSurvey (tm)
* Copyright (C) 2011-2026 The LimeSurvey Project Team
* All rights reserved.
* License: GNU/GPL License v2 or later, see LICENSE.php
* LimeSurvey is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
class WipeCommand extends CConsoleCommand
{
/**
* @return int
*/
public function run($args)
{
if (isset($args) && isset($args[0]) && $args[0] = 'yes') {
Yii::import('application.helpers.common_helper', true);
$actquery = "truncate table {{assessments}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{answers}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{answer_l10ns}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{asset_version}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{boxes}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{conditions}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{defaultvalues}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{defaultvalue_l10ns}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{labels}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{label_l10ns}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{labelsets}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table " . Yii::app()->db->quoteTableName('{{groups}}');
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{group_l10ns}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{notifications}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{questions}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{question_l10ns}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{surveys}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "delete from {{surveys_groups}} where gsid<>1";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{surveys_languagesettings}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "delete from {{permissions}} where id<>1";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{plugin_settings}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{permissiontemplates}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{quota}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{quota_members}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{quota_languagesettings}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{question_attributes}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{user_groups}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{user_in_groups}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{templates}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{template_configuration}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{participants}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{participant_attribute}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{participant_attribute_names}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{participant_attribute_names_lang}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{participant_attribute_values}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{participant_shares}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{failed_login_attempts}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{saved_control}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{sessions}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{survey_links}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "delete from {{users}} where uid<>1";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "delete from {{surveys_groups}} where gsid<>1";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "delete from {{surveys_groupsettings}} where gsid>1";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{survey_url_parameters}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "truncate table {{user_in_permissionrole}}";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{users}} set lang='en'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{users}} set lang='auto'";
Yii::app()->db->createCommand($actquery)->execute();
if (tableExists('{{auditlog_log}}')) {
$actquery = "truncate table {{auditlog_log}}";
Yii::app()->db->createCommand($actquery)->execute();
}
if (tableExists('{{user_mfa_settings}}')) {
$actquery = "truncate table {{user_mfa_settings}}";
Yii::app()->db->createCommand($actquery)->execute();
}
$actquery = "delete from {{settings_user}} where stg_name LIKE 'last_question'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "delete from {{settings_user}} where stg_name LIKE 'last_survey'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{users}} set email = 'test@domain.test', full_name='Administrator'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{settings_global}} set stg_value='' where stg_name='googleanalyticsapikey' or stg_name='googleMapsAPIKey' or stg_name='googletranslateapikey' or stg_name='ipInfoDbAPIKey' or stg_name='pdfheadertitle' or stg_name='pdfheaderstring'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{settings_global}} set stg_value='test@domain.test' where stg_name='siteadminbounce' or stg_name='siteadminemail'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{settings_global}} set stg_value='Administrator' where stg_name='siteadminname'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{settings_global}} set stg_value='Sea_Green' where stg_name='admintheme'";
Yii::app()->db->createCommand($actquery)->execute();
$actquery = "update {{plugins}} set active=0 where name='TwoFactorAdminLogin' OR name='AuditLog'";
Yii::app()->db->createCommand($actquery)->execute();
foreach (LsDefaultDataSets::getTemplatesData() as $template) {
Yii::app()->db->createCommand()->insert("{{templates}}", $template);
}
foreach (LsDefaultDataSets::getTemplateConfigurationData() as $templateConfiguration) {
Yii::app()->db->createCommand()->insert("{{template_configuration}}", $templateConfiguration);
}
foreach ($boxesData = LsDefaultDataSets::getBoxesData() as $box) {
Yii::app()->db->createCommand()->insert("{{boxes}}", $box);
}
$surveyidresult = dbGetTablesLike("tokens%");
foreach ($surveyidresult as $sv) {
Yii::app()->db->createCommand("drop table " . $sv)->execute();
}
$surveyidresult = dbGetTablesLike("old\_%");
foreach ($surveyidresult as $sv) {
Yii::app()->db->createCommand("drop table " . $sv)->execute();
}
$surveyidresult = dbGetTablesLike("survey\_%");
foreach ($surveyidresult as $sv) {
if (strpos((string) $sv, 'survey_links') === false && strpos((string) $sv, 'survey_url_parameters') === false) {
Yii::app()->db->createCommand("drop table " . $sv)->execute();
}
}
$sBaseUploadDir = dirname(dirname(dirname(__FILE__))) . DIRECTORY_SEPARATOR . 'upload';
SureRemoveDir($sBaseUploadDir . DIRECTORY_SEPARATOR . 'surveys', false);
SureRemoveDir($sBaseUploadDir . DIRECTORY_SEPARATOR . 'templates', false);
SureRemoveDir($sBaseUploadDir . DIRECTORY_SEPARATOR . 'themes' . DIRECTORY_SEPARATOR . 'survey', false);
SureRemoveDir($sBaseUploadDir . DIRECTORY_SEPARATOR . 'themes' . DIRECTORY_SEPARATOR . 'question', false);
} else {
// TODO: a valid error process
echo 'This CLI command wipes a LimeSurvey installation clean (including all user except for the user ID 1 and user-uploaded content). For security reasons this command can only started if you add the parameter \'yes\' to the command line.';
}
return 0;
}
}
function SureRemoveDir($dir, $DeleteMe)
{
if (!$dh = @opendir($dir)) {
return;
}
while (false !== ($obj = readdir($dh))) {
if ($obj == '.' || $obj == '..') {
continue;
}
if (!@unlink($dir . '/' . $obj)) {
SureRemoveDir($dir . '/' . $obj, true);
}
}
closedir($dh);
if ($DeleteMe) {
if (!@rmdir($dir)) {
echo "Error: could not delete " . $dir;
}
}
}