Change next affiliate ID

[ouwejan]

Hi,

 

We would like to change the affiliate ID that will be given to the next new affiliate. How to do this? I thought I could change this somewhere in the database but I can't find where.

 

Thanks.

[Dragonsys]

in your WHMCS DB, table tblaffiliates

Change the AUTO_INCREMENT for the id field to what you want the next number to be.

 

ALTER TABLE tblaffiliates AUTO_INCREMENT = value;

[ouwejan]

Thanks ;-) That did the trick

[dfb121]

in your WHMCS DB, table tblaffiliates

Change the AUTO_INCREMENT for the id field to what you want the next number to be.

 

If I change the next affiliate id number to 500 as advised here, will the following affiliate ID assigned after that be 501 or 1000?

 

I want to set it so the next number will be 500 and then from there it will assign 501, 502, 503 etc.

 

Thanks.

[vdswin.com]

If you change AUTO_INCREMENT to 500 the next ID will be 501, than 502 etc.

[Abe Niang]

Was having the same issue. There is a very easy way with phpmyadmin under the "operations" tab, you can set, in the table options, autoincrement to the number you want.