Code: Select all
VERSION BUILD=6111213 RECORDER=FX
TAB T=1
SET !DATASOURCE wiki_list.csv
SET !DATASOURCE_COLUMNS 1
SET !DATASOURCE_LINE {{!LOOP}}
PROMPT Please<SP>enter<SP>current<SP>username !VAR1
PROMPT Please<SP>enter<SP>desired<SP>username !VAR2
SET !ENCRYPTION NO
ONLOGIN USER=(BLANKED) PASSWORD=(BLANKED)
URL GOTO=(BLANKED)
FRAME F=2
TAG POS=1 TYPE=A ATTR=TXT:SQL
TAG POS=1 TYPE=TEXTAREA FORM=NAME:sqlform ATTR=ID:sqlquery CONTENT= "UPDATE `{{!COL1}}_wiki`.`revision` SET `rev_user_text` = '{{!VAR2}}' WHERE `revision`.`rev_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`recentchanges` SET `rc_user_text` = '{{!VAR2}}' WHERE `recentchanges`.`rc_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`cu_changes` SET `cuc_user_text` = '{{!VAR2}}' WHERE `cu_changes`.`cuc_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`cu_log` SET `cul_user_text` = '{{!VAR2}}' WHERE `cu_log`.`cul_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`archive` SET `ar_user_text` = '{{!VAR2}}' WHERE `archive`.`ar_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`editings` SET `editings_user` = '{{!VAR2}}' WHERE `editings`.`editings_user` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`filearchive` SET `fa_user_text` = '{{!VAR2}}' WHERE `filearchive`.`fa_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`global_block_whitelist` SET `gbw_by_text` = '{{!VAR2}}' WHERE `global_block_whitelist`.`gbw_by_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`hidden` SET `hidden_user_text` = '{{!VAR2}}' WHERE `hidden`.`hidden_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`hidden` SET `hidden_by_user` = '{{!VAR2}}' WHERE `hidden`.`hidden_by_user` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`image` SET `img_user_text` = '{{!VAR2}}' WHERE `image`.`img_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`ipblocks` SET `ipb_by_user` = '{{!VAR2}}' WHERE `ipblocks`.`ipb_by_user` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`logging` SET `log_title` = '{{!VAR2}}' WHERE `logging`.`log_title` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`oldimage` SET `oi_user_text` = '{{!VAR2}}' WHERE `oldimage`.`oi_user_text` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`online` SET `username` = '{{!VAR2}}' WHERE `online`.`username` = '{{!VAR1}}' ; <BR> UPDATE `{{!COL1}}_wiki`.`page_restrictions` SET `pr_user` = '{{!VAR2}}' WHERE `page_restrictions`.`pr_user` = '{{!VAR1}}' ;"
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:sqlqueryform ATTR=NAME:SQL&&VALUE:Go
How can i fix this?