On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

Support Forum : How to re-count topics and posts?

In preparation for the release of Simple:Press Version 4.0, the Support Forum has moved to a new site dedicated to the plugin. This will also be the future home for Simple:Press Forum.


Version 3.1.4 will still be available for download here in the short term.


For the support forum - and to visit our new site and to get details of version 4.0, click on the logo to take you to simplepressforum.com

This forum is currently locked - access is read only
Current User: Guest
Please consider registering

 
Search Forums:


 




Home Forums Simple:Press Forum Version 3.0 to 3.1.4 How to re-count topics and posts?

How to re-count topics and posts?
Page: 1
UserPost

9:33 am
28 Aug 2008


anung

Guest

1

How to re-count topics and posts in simple press?

9:39 am
28 Aug 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252
2

Could you please expand a little on what you mean and am asking? Is there something wrong or are you wanting to do something?

9:44 am
28 Aug 2008


anung

Guest

3

after manually inserting data from phpmyadmin, i want to recount all forum totals and statistics.

9:54 am
28 Aug 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252
4

I understand. Can you write php code?

10:12 am
28 Aug 2008


anung

Guest

5

a little Laughing

11:47 am
28 Aug 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252
6

So if I told you which files to include and functions to call, would you be able to construct a script to run once?

Can you tell me which table columns are not filled as well?

1:55 pm
28 Aug 2008


anung

Guest

7

i can do that. okay, in the table wp_sftopics.post_count and wp_sfforums.topic_count

6:34 pm
28 Aug 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252
8

Are these the ONLY two not filled manually?

Have you filled 'post_index' in sfposts for example? 'post_id' in sftopics? 'post_id' in sfforums? And all the 'slugs'?

2:45 am
29 Aug 2008


anung

Guest

9

yes, only two.

sfposts and sftopics is done, i think.i'm not sure

2:52 am
29 Aug 2008


anung

Guest

10

oh, except for the 'slugs' and 'post_index'

3:42 am
29 Aug 2008


Mr Papa

Moderator

Arizona, USA

posts 1602
11

you might want to wait for Andy, but I think you can do what is left via a couple of upgrade helper functions…  take a look in sf-upgradesupport.php in the install directory…

If you call sf_create_slugs(), it should create your slugs for you…

If you call sf_build_lastposts(), it should build your last post columns, topic post count and post index

like I said, you may want to wait for confirmation from Andy…

9:28 am
29 Aug 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252
12

These are the routines you need to run. So you need a script to include the wp-config.php feil from your WP rot AND include the sf-upgradesupport.php in the forums 'install' folder ands run those routnes above.

5:06 pm
30 Aug 2008


anung

Guest

13

thanks, it works

5:42 pm
30 Aug 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252
14

excellent news.

4:36 am
31 Aug 2008


Mr Papa

Moderator

Arizona, USA

posts 1602
15

sweet!  enjoy!
Page: 1


Reply to Topic: How to re-count topics and posts?

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 5 + 7        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

17 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 2068

Posts: 14091

Members:

There are 1003 members

There are 837 guests


Yellow Swordfish has made 5252 posts

Top Posters:

Mr Papa - 1602

-Radio- - 558

ovizii - 114

jfv - 82

angelic007 - 72

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)