Forums Index > Mewsoft > FAQ > How to reset or update Stats and Some Configuration Variables
mewsoft First Post Posted on: 01-08-11 03:22 PM
How to reset or update Stats and Some Configuration Variables

The products stat are and most configuration variables are kept in a sql table called:

Auction_Config for the auction software
Classified_Config for the classifieds software
DirConfig for the search engine software

This SQL table is 2 columns (Name, Value):

Name VARCHAR(250),
Value VARCHAR(250)

How to update variables, 2 steps
1)-Delete the Variable first, then,
2)-Insert it with its value.

Example, how to update the Total Listed Items:

Go to the admin center->Database & SQL Manager -> SQL Commander and issues these 2 commands:

DELETE FROM Auction_Config WHERE Name="Total_Listed_Count"

INSERT INTO Auction_Config VALUES("Total_Listed_Count", "34215"wink

Remember that, the sql commander only runs one command each time so the above 2 lines are 2 commands.


Mewsoft Support
www.mewsoft.com