Welcome Visitor, Please Login or Register Now Saturday, December 21, 2024 05:13 PM 
Forums Index > Mewsoft > FAQ > How to reset or update Stats and Some Configuration Variables
New Topic   New Reply
Search for:
Author Message
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-21-24 05:13 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
How to reset or update Stats and Some Configuration Variables Edit Delete Reply with quote Quote
First Post Posted on: 01-08-11 03:22 PM last post first post

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

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print