+ Reply to Thread
Results 1 to 4 of 4

Thread: Is there a listing ID and/or category ID counter stored somewhere?

  1. #1
    Senior Member
    Join Date
    Dec 2023
    Posts
    161

    Is there a listing ID and/or category ID counter stored somewhere?

    Does flynax store a counter that it uses to pick the next listing ID # or the next category ID # when creating either a new listing or a new category?

  2. #2
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,174
    By default, listing and category ids are generated automatically according to the "UNIQUE index" in mysql tables

  3. #3
    Senior Member
    Join Date
    Dec 2023
    Posts
    161
    Thanks!

    In setting up, I've deleted all but one category and run the category import multiple times, and now my category ID is up to 712 with a total of 176 categories.

    If I run it a few more times before my final setup is done, I may want to reset the UNIQUE index so my final category IDs stay three digits instead of rolling over to four digits...

  4. #4
    Senior Member
    Join Date
    Dec 2023
    Posts
    161
    I also might want to create a new stat.
    We have stat for total number of listings currently on the site.
    I may also want a stat counter for total number of listings posted on the site (current and deleted) which would be the ID# of the latest listing.

+ Reply to Thread