php forum
php mysql forum
php mysql smarty
 
Topic Options
#269867 - 02/25/04 05:36 AM subtract from a users post count!
Magle Offline
Journeyman

Registered: 12/22/03
Posts: 109
Loc: Denmark
I would like to have the ability (as an admin) to edit a users post count.<br />On my forum I'm using the post count and title system as a "fun" incentive and kind of like a little competition (See this thread for a description).<br /><br />Most of the time it works very well, but sometimes peole try to (almost) spam or "flood" in order to drive up their post count. Of course I can change their titles manually but it would be much better if I could simply edit their post count (for example if I delete (or lock) a post, I can go subtract from the post count of that user)<br /><br />If anyone could come up with a solution I will appreciate it very much thanks!
_________________________
my forum: Magle International Music Forums

Top
#269868 - 02/25/04 12:45 PM Re: subtract from a users post count! [Re: ]
Medar Offline
Junior Member

Registered: 03/19/00
Posts: 571
First note the number of posts for a given user, and hit their profile for their User Number.<br /><br />UPDATE w3t_Users SET U_Totalposts='###' WHERE U_Number='###'<br /><br />The U_Totalposts should set to the number of posts you would like reflected for them, and the U_Number is the User Number you are changing.<br /><br />This will NOT change their title, so if they bumped themselves by spamming your boards, you can change that in a few other ways.

Top
#269869 - 02/25/04 01:35 PM Re: subtract from a users post count! [Re: Intel -*RW*-]
Magle Offline
Journeyman

Registered: 12/22/03
Posts: 109
Loc: Denmark
Thank you, thank you, thank you!!!!!!!!!<br /><br />This was exactly what I needed. It works perfectly!!!!<br />(there is an extra reason why this was so important for me: I run a hidden - work related for a secret project - forum on my site and I don't want other members asking questions about why this and that user has got so high post count, so this is VERY important for me!!!!)<br /><br />THANK YOU MEDAR !!!
_________________________
my forum: Magle International Music Forums

Top
#269870 - 02/25/04 02:03 PM Re: subtract from a users post count! [Re: ]
Zackary Offline
Member

Registered: 03/01/01
Posts: 652
Loc: West Fargo, ND USA
[]Magle said:<br />I run a hidden - work related for a secret project - forum on my site and I don't want other members asking questions about why this and that user has got so high post count, so this is VERY important for me!!!!)<br />[/]<br /><br />You could try the info in This Thread to disable the post counter for that "secret" forum. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Top
#269871 - 02/26/04 10:28 AM Re: subtract from a users post count! [Re: ]
lcantey Offline
Member

Registered: 05/20/99
Posts: 166
Loc: CA
[]Magle said:<br />...but sometimes peole try to (almost) spam or "flood" in order to drive up their post count.[/]<br /><br />I hear you. One of the "fun" things I did to combat that little race was take the worst offenders and make it so that every time they posted it would instead subtract one from their post count. Worked nicely and everyone had a good laugh.<br /><br />Lee

Top
#269872 - 02/26/04 10:40 AM Re: subtract from a users post count! [Re: Billy Bandit]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
Lmao..Ok I want to do that..I have three offenders on my board that need this..How did you do it?
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#269873 - 02/26/04 10:55 AM Re: subtract from a users post count! [Re: barbiro]
lcantey Offline
Member

Registered: 05/20/99
Posts: 166
Loc: CA
This was awhile back and it's long gone, but after a quick look at addpost.php I believe the only changes were checking against U_Username for the names at $Totalposts = $user['U_Totalposts'] + 1; and instead subtracting one. The query also needed to be updated to use $Totalpost instead of 'U_Totalposts + 1' again.<br /><br />Lee

Top
#269874 - 02/26/04 11:13 AM Re: subtract from a users post count! [Re: Billy Bandit]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
I think this query should be added to Frequently Used My SQL Queries. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#269875 - 02/27/04 01:24 AM Re: subtract from a users post count! [Re: barbiro]
DLWebmaestro Offline
Member

Registered: 08/08/00
Posts: 1753
Loc: California, MD
I like to have fun with ranks too, and I have gotten rather complex with my schemes. You can see somewhat of an explanation for how I run things at http://www.drumlines.org/threads/faq.php#titles<br /><br />I have more-or-less shied away from using solely post counts as a basis of rank. I instead combine that with the groups system that I described.<br /><br />The 'script' that I speak of on the page does not really exist - that is still in the making! <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /> But for now, we (my staff) compensate by reading posts and making mental notes of who's got a good head on their shoulders and who should be run over by a stampede of rabid water buffalo.<br /><br />I have made quite a lot of script alterations to automate the whole process, however. The only time we have to step in is when a member is up for promotion to the next group.
_________________________
Webmaster
Drumlines.org

Drumlines.org UBBThreads

Top
#269876 - 02/28/04 04:58 PM Re: subtract from a users post count! [Re: eslmix]
Magle Offline
Journeyman

Registered: 12/22/03
Posts: 109
Loc: Denmark
That's really sneaky DLWebmaestro, but I like it <img src="http://www.ubbdev.com/forum/images/graemlins/cool.gif" alt="" /><br /><br />When my forum starts to grow in members (anytime now, as I've been saying for the last...nevermind <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />) I think I'll try to expand the ranking system beyond "post-count".
_________________________
my forum: Magle International Music Forums

Top
#269877 - 02/28/04 05:00 PM Re: subtract from a users post count! [Re: eslmix]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
lmao Josh..I understood that bit of code
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#269878 - 02/28/04 05:39 PM Re: subtract from a users post count! [Re: barbiro]
Magle Offline
Journeyman

Registered: 12/22/03
Posts: 109
Loc: Denmark
he he..."clueless", so to speak <img src="http://www.ubbdev.com/forum/images/graemlins/grin.gif" alt="" />
_________________________
my forum: Magle International Music Forums

Top
#269879 - 03/03/04 03:00 PM Re: subtract from a users post count! [Re: ]
paradox_dup1 Offline
Lurker

Registered: 01/21/04
Posts: 7
could someone tell me how to filter out the content of a thread? a lot of people have on my board have the habit of posting just "+1" or just a smiley and they are just trying to boost their post count. is there a way i could stop them from entering the post if it contains any instance of "+1"?

Top
#269880 - 03/04/04 09:16 AM Re: subtract from a users post count! [Re: ]
slayer60 Offline
Junior Member

Registered: 06/14/03
Posts: 1185
Loc: New Boston, NH
Well, the thing is, that there is no way to catch it all. If you block +1, then they can simply use .... or ...... or ..... or :; or a or b or okay, I digress, but you get the point.

Top
#269881 - 03/04/04 11:07 AM Re: subtract from a users post count! [Re: ]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
For as many ways you come up with to filter things out someone will always have a workaround. I suggest making a Spam Policy announcement and inform users that your delete finger is getting tired and it just may slip onto "delete user" if the problem continues. Fact is Spam will always be problem at one time or another on any forum. The task is not letting it become contagious.
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#269882 - 03/04/04 11:17 AM Re: subtract from a users post count! [Re: barbiro]
slayer60 Offline
Junior Member

Registered: 06/14/03
Posts: 1185
Loc: New Boston, NH
<img src="http://www.ubbdev.com/forum/images/graemlins/yeahthat.gif" alt="" />

Top
#269883 - 03/04/04 05:51 PM Re: subtract from a users post count! [Re: BrokenToy]
paradox_dup1 Offline
Lurker

Registered: 01/21/04
Posts: 7
what about making a minimum character limit for posts?? so like any posts shorter then 10 char is denied.

Top


Who's Online
0 registered (), 25 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Forum 'Trader Ratings'.
by blaaskaak
11/20/08 08:27 AM
Problems reading a lot of old posts here
by Ruben Rocha
11/18/08 04:33 PM
PhotoPost BB Code Popup
by Iann128
11/15/08 01:24 PM
Customization needed
by Gizmo
11/12/08 12:28 PM
Team UBBDev Rides Again!
by AllenAyres
11/11/08 02:16 PM
Active Topics.
by AllenAyres
11/11/08 02:13 PM
Looking for a simple upload script
by AllenAyres
11/11/08 02:12 PM
New Mods
Forum 'Trader Ratings'.
by McLemore
11/19/08 02:14 PM
[7.4] Keep log of custom title changes
by blaaskaak
10/27/08 07:51 AM
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Newest Members
nick1, Begbie, cenk, MATTO, DougMMcts
13362 Registered Users
Top Posters
AllenAyres 25448
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks