Change next affiliate ID

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.

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;

Thanks ;-) That did the trick

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.

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

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.