Author Topic: changing the sequence in adminphp (Read 2224 times)

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

DW · « **Reply #1 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

chris6 · « **Reply #2 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.

DW · « **Reply #3 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

terriz · « **Reply #4 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

DW · « **Reply #5 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

terriz · « **Reply #6 on:** August 14, 2005, 06:07:38 pm »

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

DW · « **Reply #7 on:** August 15, 2005, 01:13:59 am »

Sure, you can submit your info here.

Regards

terriz · « **Reply #8 on:** August 16, 2005, 08:10:50 am »

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