XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / How do I reset the post count for individual members?
Register
1
ibanez
How do I reset the post count for individual members?

  • 2003/11/16 20:07

  • ibanez

  • Just popping in

  • Posts: 33

  • Since: 2003/1/28


How do I reset the post count for individual members?

Is there away I can override the physical post count to put in any number?
2
mvandam
Re: How do I reset the post count for individual members?

  • 2003/11/16 23:56

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


You can do it directly from MySQL in the users table (the 'posts' column). However, if you ever 'synchronize' the number of posts, then this will be reset to its true value.
3
ibanez
Re: How do I reset the post count for individual members?

  • 2003/12/8 16:05

  • ibanez

  • Just popping in

  • Posts: 33

  • Since: 2003/1/28


Oh thanks that worked. Only now I can't find where to re-synchronise the post count.
4
CBlue
Re: How do I reset the post count for individual members?

Click on your forum icon in the system admin and you will see:

Sync forum/topic index - This link will allow you to sync up the forum and topic indexes to fix any discrepancies that might arise
5
chapi
Re: How do I reset the post count for individual members?

  • 2003/12/8 16:37

  • chapi

  • Theme Designer

  • Posts: 611

  • Since: 2002/1/22


Oh I think he is searching for something different.

If you want to update/synchronize the posts of a single user, after you setted it to a custom value directly in the database, you have to do the following.

Go to administration > system admin > edit user, select the user and choose "modify user".

Now you get all the data for this user. At the end of this page, there is the function for synchronizing the user posts. Simply click on that button and the user count should be up to date!
6
CBlue
Re: How do I reset the post count for individual members?

Thanks Chapi! I didn't know about that function yet! I'm glad you posted this.
7
jfebus
Re: How do I reset the post count for individual members?

  • 2004/9/14 15:09

  • jfebus

  • Just popping in

  • Posts: 97

  • Since: 2004/9/1 1


Is there a way I can synchronize data for ALL users?

I noticed this code in /modules/system/admin/users/users.php
case 'all users':
           $sql = "SELECT uid FROM ".$xoopsDB->prefix("users")."";
           if ( !$result = $xoopsDB->query($sql) ) {
               exit(_AM_CNGUSERID);
           }
           while ($row = $xoopsDB->fetchArray($result)) {
               $id = $row['uid'];
               synchronize($id, "user");
           }
           break;


Is there a button to run this code?

Best Regards,

8
jfebus
Re: How do I reset the post count for individual members?

  • 2004/9/14 15:45

  • jfebus

  • Just popping in

  • Posts: 97

  • Since: 2004/9/1 1


echo "<form action="admin.php" method="post">n";
echo "<input type="hidden" name="id" value="".$user->getVar("uid")."">";
echo "<input type="hidden" name="type" value="all users">n";
echo "<input type="hidden" name="fct" value="users">n";
echo "<input type="hidden" name="op" value="synchronize">n";
echo "<input type="submit" value=""._AM_SYNCHRONIZE."">n";
echo "</form>n";


I changed the type vlaue to "all users" and it didn;t synch all users...

any idea?

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

165 user(s) are online (92 user(s) are browsing Support Forums)

Members: 0

Guests: 165

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits