ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: chris6 on April 14, 2005, 10:37:23 am

Title: changing the sequence in adminphp
Post by: chris6 on April 14, 2005, 10:37:23 am

can someone give me an idiots guide to changing everyone in my listmail sequence that is on follow up 11 to follow up 9 ie sequence 11 to sequence 9.
Dean always give me the code and says you will need to run a query in your database admin but where specifically?
thanks in advance
Gail
www.YourBusinessSuccess.com

Title: changing the sequence in adminphp
Post by: DW on April 14, 2005, 11:26:06 am

Gail,

The "Database" or "MySQL" section of your "Control Panel" (where you set up email accounts, etc. on your hosted accounts should have a link to "PhpMyAdmin", "Database Manager", or similar.  Here you can select your ListMail database and run a custom query.  Of course, the Web-based PHP->MySQL interface is a tad confusing..  If you'd rather avoid it keep reading..

I've got a secret for you.  Simply login to ListMail and go to the Config page.  Add the following variable to the Address URL &customcmd=1 and hit enter.  You'll be presented with a text box where you can enter a custom MySQL query.

If you want to do what you asked on list 5 with a delay of 0 here's the query:

update lm_users set cseq = '9', cdel = '0' where cseq = '11' and list = '5'

Regards

Title: changing the sequence in adminphp
Post by: chris6 on April 14, 2005, 02:46:15 pm

Full path (URL) to ListMail Files

do you mean add the &customcmd=1 to the http: address to be found in the the area above - in General config, as I tried this and nothing happened and i'm running the most current version of Listmail.

Title: changing the sequence in adminphp
Post by: DW on April 14, 2005, 03:34:40 pm

Log-in and browse to:

http://www.<site>.com/<listmail>/editconf.php?list=1&customcmd=1

Regards

Title: changing the sequence in adminphp
Post by: terriz on August 14, 2005, 01:47:52 pm

Quote from: "DW"

If you want to do what you asked on list 5 with a delay of 0 here's the query:

update lm_users set cseq = '9', cdel = '0' where cseq = '11' and list = '5'

I tried this but it didn't work. I put in
update lm_users set cseq = '11', cdel = '0' where cseq = '6' and list = '1'

since I want to change users on list one who are at sequence #6, to sequence #11 (I'm going to be inserting 5 new followups at the beginning...)

There is a box on that "secret" page after where you put the custom command, called Repeat. It's set to 1 -- am I supposed to change that?

Thanks,
Terri Z

Title: changing the sequence in adminphp
Post by: DW on August 14, 2005, 05:37:57 pm

No, you do not need to change the repeat option.  I believe I used it to insert thousands of users in previous testing. ;)

Your command looks ok - are you sure it didn't work?  :?

Regards

Title: changing the sequence in adminphp
Post by: terriz on August 14, 2005, 06:07:38 pm

yes I'm sure it didn't work -- would you like to try?  :D

Title: changing the sequence in adminphp
Post by: DW on August 15, 2005, 01:13:59 am

Sure, you can submit your info here (http://listmailpro.com/support?t=other). 8)

Regards

Title: changing the sequence in adminphp
Post by: terriz on August 16, 2005, 08:10:50 am

Never mind Dean--I got this to work through phpmyadmin (was feeling brave!)