Change a user's post incrementation factor...
 

This hach was requested by nintendo: https://vborg.vbsupport.ru/showthrea...threadid=49637

This hack allows you to set the direction and the incrementation factor for user posts.
The default incrementation factor is 1. With this hack you can freeze a user's post
count by setting the incrementation factor to 0, or you can make it go backwards by
setting it to -1. Of course, you are not limitet to -1, 0, or 1. You can set it to
any positive or negative number and that users post caount will increment or decrement
by the specified number each time that user makes a post.

Tables affected by this hack: user, usertitle
Files affected by this hack: newthread.php, newreply.php, admin/user.php

To begin with this hack you must allow for negative post counts, and you need an
additional field in the user table.

Execute the following statements at the MySQL prompt:

alter table user add postdirection smallint(5) DEFAULT 1 NOT NULL;
alter table user modify posts int(6) default 0 NOT NULL;
alter table usertitle modify minposts int(6);

This could be fun :devious:

Look at my profile ;) My factor is set to -1. :D

I have a user whose post incrementation factor is set to -500... :D

lmao - that's cool

Nice avatar too

I thik your avatar is much better ;) :D

lol I meant the one in the link he's given -_-

But thanks - I like it too :lick: Rose McGowan rocks

haha.. Nice hack idea. I don't think i'll use this at my forums, but it's here if I wanted to. ;)

Hehe such a sadistic hack - i like it ;)

- miSt

Sounds like a good april fools joke ;)

im having major trouble installing this over the starhack.
any thoughts?

I am not familiar with the star hack.

What errors are you getting?

Can you Email me your newthread.php and newreply.php files?

My Email is edwink@seebeyond.com

I shot ya over an email yesterday..

hello zzed? :)

Sorry snyx, :( I will take a look tonight and get back to you.

no problem, thx mate

Zzed, I just installed this and I changed my incrementation to -1 but when I go into my user setting to look at it, for some reason it is showing 0 now. Any ideas what might be causing this?

You need to alter your user and usertitle tables. ;) Post counts are unsigned integers, the following code will make them signed integers. ;)


alter table user modify posts int(6) DEFAULT 0 NOT NULL;

alter table usertitle modify minposts int(6);


Also look at my post count in my profile. :D

http://www.ls1.com/forums/member.php...fo&userid=4112

Here are the queries I ran according to your install instructions.

I just executed this SQL query in your Admin CP:

alter table user modify postdirection smallint(5) default 1 not null;

Then went ahead and set your post incrementation factor to -1.

It worked. ;)

Hey buddy. ;)

I got this error this afternoon sometime.

and now the user is showing 23 of 22 messages.

Eureka. :D

Go to line 613 of your newrply.php and join the 2 lines and remove the backslash. ;) The variable $bbuserinfo[postdirection] has the $ and bbuserinfo separated. ;)

help all my new registered users dont have a post count?
they just sit at no number!! I want to remove the changes I made to mySQL in hopes it fixes this problem how would I do this?!

It seems you get a db error when a new user tries to activate also. Apparently, we need to change something in the register.php file, too.

yeah, shouldnt you have altered the posts column like this:

alter table user modify posts int(6) default 0 not null;

Zzed, you need to change the following in the text file attached to the first post, too. ;)

alter table user modify posts int(6) default 0 NOT NULL;

done. ;)

Thank you sir. :)

anyone know if this conflicts with bitsys's battle hack?


erm it does....sucks...


wouldve been nice :(