Change User's Post Count

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
Extensions Robot
Extensions Robot
Extensions Robot
Posts: 27639
Joined: Sat Aug 16, 2003 7:36 am

Change User's Post Count

Post by Extensions Robot » Tue Nov 20, 2007 8:42 am

Modification name: Change User's Post Count
Author: prothought
Modification description: Allows an administrator to change a user's post count.
Modification version: 2.0.3
Tested on phpBB version: 3.0.0

Download file: ChangeUsersPostCount.zip
File size: 29560 Bytes

Modification overview page: View

The phpBB Team is not responsible nor required to provide support for this modification. By installing this MOD, you acknowledge that the phpBB Support Team or phpBB Modifications Team may not be able to provide support.

-->Modification support<--
Last edited by Extensions Robot on Tue Feb 08, 2011 4:50 am, edited 6 times in total.
(this is a non-active account manager for the phpBB Extension Customisations Team)

User avatar
Highway of Life
Former Team Member
Posts: 6048
Joined: Wed Feb 02, 2005 5:41 pm
Location: Spokane, WA
Name: David Lewis
Contact:

Change User's Post Count

Post by Highway of Life » Tue Nov 20, 2007 8:42 am

Modification validated/released

Notes:
Effectively allows you to change a user's post count from User Administration.
You can also one-click to see the users actual current post count.
The phpBB Weekly Podcast - Discussing the developments of phpBB4 and beyond.

New to phpBB3? Want to learn about programing?
Visit phpBB Academy at StarTrekGuide to learn how.

User avatar
prothought
Registered User
Posts: 55
Joined: Thu Dec 28, 2006 3:44 pm
Contact:

Re: Change User's Post Count

Post by prothought » Tue Nov 20, 2007 1:47 pm

Thanks go to Tom Levins for the original and Highway of Life for the tweaks! ;)
Image www.phoenixforums.net Image
We won't go all Dmoto on you!

AustinSBR
Registered User
Posts: 4
Joined: Tue Nov 20, 2007 5:17 pm

Re: Change User's Post Count

Post by AustinSBR » Tue Nov 20, 2007 5:20 pm

Is there anything like this that will work with 2.0 versions?
Last edited by AustinSBR on Tue Nov 20, 2007 9:02 pm, edited 1 time in total.

User avatar
prothought
Registered User
Posts: 55
Joined: Thu Dec 28, 2006 3:44 pm
Contact:

Re: Change User's Post Count

Post by prothought » Tue Nov 20, 2007 5:29 pm

AustinSBR wrote:Is there anything like this that will work with 2.0 versions?
Yes.
Mine is based off of Tom's.
Image www.phoenixforums.net Image
We won't go all Dmoto on you!

User avatar
Jaymie1989
Registered User
Posts: 1991
Joined: Thu Aug 02, 2007 5:21 pm
Name: Jaymie

Re: Change User's Post Count

Post by Jaymie1989 » Tue Nov 20, 2007 8:55 pm

Is this a bug???
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'user_posts' at row 1 [1264]

SQL

UPDATE official_users SET user_posts = 50000000 WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_users.php
LINE: 805
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Dear creators of Sesame Street,
Kids are still fat. Can I come back now?
Sincerely, Cookie Monster.

View my MODs - Need phpBB help with MODs and Styles? Take a look at my phpBB3 services

User avatar
Highway of Life
Former Team Member
Posts: 6048
Joined: Wed Feb 02, 2005 5:41 pm
Location: Spokane, WA
Name: David Lewis
Contact:

Re: Change User's Post Count

Post by Highway of Life » Tue Nov 20, 2007 9:26 pm

Jaymie1989 wrote:Is this a bug???
You’re kidding right?
You set the user’s posts to 50 million. -- The user_posts column is a mediumint 8. :roll:
The phpBB Weekly Podcast - Discussing the developments of phpBB4 and beyond.

New to phpBB3? Want to learn about programing?
Visit phpBB Academy at StarTrekGuide to learn how.

User avatar
Jaymie1989
Registered User
Posts: 1991
Joined: Thu Aug 02, 2007 5:21 pm
Name: Jaymie

Re: Change User's Post Count

Post by Jaymie1989 » Wed Nov 21, 2007 1:09 pm

Highway of Life wrote:
Jaymie1989 wrote:Is this a bug???
You’re kidding right?
You set the user’s posts to 50 million. -- The user_posts column is a mediumint 8. :roll:
What :? Doesnt say a limit any where.

So what is the most it can go up to?
Dear creators of Sesame Street,
Kids are still fat. Can I come back now?
Sincerely, Cookie Monster.

View my MODs - Need phpBB help with MODs and Styles? Take a look at my phpBB3 services

User avatar
Highway of Life
Former Team Member
Posts: 6048
Joined: Wed Feb 02, 2005 5:41 pm
Location: Spokane, WA
Name: David Lewis
Contact:

Re: Change User's Post Count

Post by Highway of Life » Wed Nov 21, 2007 2:13 pm

Jaymie1989 wrote:
Highway of Life wrote:
Jaymie1989 wrote:Is this a bug???
You’re kidding right?
You set the user’s posts to 50 million. -- The user_posts column is a mediumint 8. :roll:
What :? Doesnt say a limit any where.

So what is the most it can go up to?
Medium int has a limit of 3 bytes, unsigned it’s a limit of some 16 million.
The phpBB Weekly Podcast - Discussing the developments of phpBB4 and beyond.

New to phpBB3? Want to learn about programing?
Visit phpBB Academy at StarTrekGuide to learn how.

NZorak
Registered User
Posts: 9
Joined: Sun Jan 28, 2007 2:36 am

Re: Change User's Post Count

Post by NZorak » Sat Nov 24, 2007 8:58 am

OK, I'm lost. I changed the files, but there's still the XML file. I went into the style pages and replaced the prosilver style with the stuff from the XLS stylesheet that was included, but nothing has happened (I backed up the entire theme, just in case things crash and burn). I go to the user overview page and I still cannot modify postcounts. I followed the instructions to the letter, but I get the feeling I'm missing some important part of the installation process.

NZorak
Registered User
Posts: 9
Joined: Sun Jan 28, 2007 2:36 am

Re: Change User's Post Count

Post by NZorak » Sat Nov 24, 2007 9:23 am

Nevermind, I got it figured out.

User avatar
Jaymie1989
Registered User
Posts: 1991
Joined: Thu Aug 02, 2007 5:21 pm
Name: Jaymie

Re: Change User's Post Count

Post by Jaymie1989 » Sun Dec 02, 2007 1:28 am

Does it work with RC8?
Dear creators of Sesame Street,
Kids are still fat. Can I come back now?
Sincerely, Cookie Monster.

View my MODs - Need phpBB help with MODs and Styles? Take a look at my phpBB3 services

Bmxdudde1100
Registered User
Posts: 7
Joined: Sun Dec 02, 2007 12:02 am
Contact:

Re: Change User's Post Count

Post by Bmxdudde1100 » Sun Dec 02, 2007 3:25 am

Just what I was looking for, thanks!

User avatar
prothought
Registered User
Posts: 55
Joined: Thu Dec 28, 2006 3:44 pm
Contact:

Re: Change User's Post Count

Post by prothought » Wed Dec 05, 2007 3:35 am

Jaymie1989 wrote:Does it work with RC8?
The only change for RC8 is to use a different Find in the file language/en/acp/common.php.

The update will be:
Find:

Code: Select all

'LOG_USER_UPDATE_NAME'	=> '<strong>Changed username</strong><br />» from “%1$s” to “%2$s”',
Add after:

Code: Select all

	'LOG_USER_UPDATE_POSTCOUNT'	=> '<strong>Changed post count</strong><br />» from “%1$s” to “%2$s”',

I will be resubmitting shortly.
Image www.phoenixforums.net Image
We won't go all Dmoto on you!

LagRealm
Registered User
Posts: 9
Joined: Wed Dec 05, 2007 11:23 pm

Re: Change User's Post Count

Post by LagRealm » Wed Dec 05, 2007 11:29 pm

Nice mod, altho I cant seemed to understand what do I do with the XSL file. Where do I put it?

I managed to edit all the other files without any problem. And uploaded them too.

Locked

Return to “[3.0.x] MOD Database Releases”

Who is online

Users browsing this forum: No registered users and 12 guests