08-23-2018, 10:47 AM
I have an idea that @brandin might have an opinion on. What if you setup a cron job to insert and delete a blank user at midnight. Note that because of length issues, you can't do the full year, but you can do:
$db->insert('users',['id'=>'182308000');
$db->delete('users',array('id','=','182308000'));
Or I guess you could just have it do
$db->query("ALTER TABLE users AUTO_INCREMENT = 182308000");
Set that to happen every night at midnight and all the other ids should fall into place.
We would have to help flesh a little more of this out, but it could work.
$db->insert('users',['id'=>'182308000');
$db->delete('users',array('id','=','182308000'));
Or I guess you could just have it do
$db->query("ALTER TABLE users AUTO_INCREMENT = 182308000");
Set that to happen every night at midnight and all the other ids should fall into place.
We would have to help flesh a little more of this out, but it could work.