Updateeeeeeee!
This is mostly just an "update-to-put-me-where-I-should-have-been-the-first-time" update. But, it's an update nonetheless.
I've fixed the bug where browsing to a group with no menu items in it would bug out the system. Now it just shows a link back to the previous group. I've cleaned up the code a bit and gave made the whole thing follow a naming convention:
- Functions to query data now all begin with Get_
- Functions to change/update begin with Set_
- Functions to Add data end with _Add, and
- Functions that delete data end with _Del.
I've added a new table Config for holding system configuration variables. It's pretty self-explanatory, so you can just check out the two variables that I'm already using if you're curious.
And, I've set up a History pruning system to keep the History table from getting out of control. When a new user is created, their Quick Picks list size and the History pruning age are configured by "defaults" set in the Config table. You can change these values at any time, although there's still no Forms set up for managing the Users or Switchboard.
Anyway, give it a try!
P.S.
I was also able to shrink the DB size significantly