Fixing corrupted state data

[Axcess]

I am working on a previously installed zen cart. The installer has called on me to fix a database issue. I'm not sure how it happened, but the state data for all currently existing users is bogus data. This creates a problem when existing users log in and want to buy something. I need to update about 6000 users' state field in the database.

My question is this. Is there any way to run a simple script when a user logs in in order to force them to verify their state if the database contains bad information? I think this would fix the problem, however Ive never worked with zen cart before and I am not sure how to cleanly run a script on login. I would appreciate all suggestions, as well as information about looking a script to login.

Thanks

[kuroi]

This would be rather complex to integrate, and there's nothing out there currently that would help. Both the script you'd need to write and its integration would need to be custom.

Surely a better approach would be to regain as much of this data as possible from your client's database backups. Exposing this problem to all of his client's should be very much a last resort.

[kuroi]

Here's another though. The textual representation of state is grabbed with each order for the customer's, billing and shipping addresses.

This is a snapshot from the time of order, so should be resistant to the corruption that has occurred. You could map these back to the state codes and reload the state codes to the address book table.

[Axcess]

It sounds like you're telling me the state data is store twice in the database, once as master for each user, and once for every order they make. I'll look into this. it sounds like I might be able to write an sql maintenance script and run it on the database directly. I'll look into it.

Thanks