Increase the starting affiliate number

[Convergence]

Greetings,

 

Looking to start the first affiliate number to be greater than 1 (would like 4 digits) -

 

Any ideas?

 

Thanks!

[plusplushosting]

not sure but you can probably modify it directly at the mysql dbase

 

good luck!

[Convergence]

not sure but you can probably modify it directly at the mysql dbase

 

good luck!

 

Ah yes, but how and where?

[plusplushosting]

heh...just load your dbase in phpmyadmin and use a bit of logic...is not that hard

 

check the tblaffiliates table...note this is a quick look i just took, do it at your own risk.

[m00]

You can use the following SQL query:

ALTER TABLE tblaffiliates AUTO_INCREMENT = 123;

Where 123 is the desired value.

[Convergence]

heh...just load your dbase in phpmyadmin and use a bit of logic...is not that hard

 

check the tblaffiliates table...note this is a quick look i just took, do it at your own risk.

 

heh - asking for advice, because we do not want to mess anything up. The more replies / suggestions, the better our odds of success.

 

Thanks for taking a quick look.

[Convergence]

You can use the following SQL query:

ALTER TABLE tblaffiliates AUTO_INCREMENT = 123;

Where 123 is the desired value.

 

Will this create a starting number or just increase each new affiliate account by that number?

[m00]

Will this create a starting number or just increase each new affiliate account by that number?

It will set the starting number to 123. If a client registers for an affiliate account, it gets the number 123, next one 124, etc.

[Convergence]

It will set the starting number to 123. If a client registers for an affiliate account, it gets the number 123, next one 124, etc.

 

Thank you! That's exactly what we want.