Support Forum

sp_Search Search
Advanced Search
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
general-topic
Resetting for fresh start
Avatar
SPQC
Member
Free Members
sp_UserOfflineSmall Offline
Go to Top
Feb 18, 2012 - 3:42 pm

I made many "Test" post and have viewed many post many times.  Was wondering if I could reset each post view times to 1 and my post count to what is actually on the forum and belongs to me?

 

My idea was to delete all post and create them again with cut&paste then go in DB change my post count.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
sp_UserWebsite sp_Twitter sp_Facebook sp_GooglePlus
Go to Top
Feb 18, 2012 - 3:44 pm

its all in the db... would have to do manually...

your post count is in sfmembers, posts column for your user...

topic view count is sftopics, topic_opened column...

Avatar
SPQC
Member
Free Members
sp_UserOfflineSmall Offline
Go to Top
Feb 18, 2012 - 4:02 pm

Great, thanks a lot.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
sp_UserWebsite sp_Twitter sp_Facebook sp_GooglePlus
Go to Top
Feb 18, 2012 - 4:03 pm

np.

sp_Feed All RSS
Go to top
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620