Using <BR> inside a quote

Discussions and Tech Support related to the iMacros Firefox Add-on, including the built-in Javascript scripting interface for playing .js files.
Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
Prom3th3an
Posts: 4
Joined: Wed Jan 07, 2009 9:45 am

Using <BR> inside a quote

Post by Prom3th3an » Wed Jan 07, 2009 10:47 am

Hi, Im making a script so that I can rename people of my multi database wiki farm. It uses phpmyadmin to do this. MY script so far is below.

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
Im using the <BR> statement so that every SQL Query is on a new line, but because the whole input for that field is in " " because the iMacro will crash without them the <br> does not get substituted with a new line, thus screwing up the querys.

How can i fix this?
dharmendra2000
Posts: 214
Joined: Fri Jul 04, 2008 1:28 pm
Location: Ahmedabad
Contact:

Re: Using <BR> inside a quote

Post by dharmendra2000 » Fri Jan 09, 2009 4:42 am

Is it not possible to execute each statement one by one, instead of all together?
You can do it using LOOP command! :)
Post Reply