Thread counter for Users

[Infamouz Nex]

a Thread counter for Users, like i assign to just count the threads users have made in assign forums... any idea guys? it would show up in their member profile and in their show threads...

[ShavedApe]

create another field in user table
eg.
threadsbyuser int(10) unsigned NOT NULL default '0',
then in functions_newpost.php

find

You must first be a registered member to view any code.

alter that or copy and modify
Assuming your new field is called threadsbyuser

You must first be a registered member to view any code.

This is untested but i dont see any reason why it would not work

Try it on a test board and then check in phpmyadmin to see if the count went up

[Infamouz Nex]

=/ dont really undersatnd man...

[ShavedApe]

what dont you understand ?
the code you need is there
All you have to do is run an sql query
then test by creating a thread in the forum you set
then check your dbase using phpmyadmin
look at usertable find the nwely created feild and see if the count has increased by 1
most server hosts have phpmyadmin installed if not I suggest you get it and put it on your self its a very usefull tool especially if your going to hack up your vbulletin

Or you can use the sql query option in vbulletin i guess. Though I gotta say i have never tried that and I guarantee it wont be as easy to see whats happened that way.

[Infamouz Nex]

well you saying go to phpmyadmin (yes i have it, and i tried that) and punch this in:

threadsbyuser int(10) unsigned NOT NULL default '0',

?

in the user table of course, so it can create another field in there right?

[ShavedApe]

Originally Posted by Infamouz Nex

well you saying go to phpmyadmin (yes i have it, and i tried that) and punch this in:

threadsbyuser int(10) unsigned NOT NULL default '0',

?

in the user table of course, so it can create another field in there right?

no they are the settings

on left side click user

on right side scroll down till you find something that looks like

Add new field : 1 At End of Table GO

click that then use the settings above

then once you added the code and tested with a post come back to user table click user again
click browse on right side
find the user who made the post
scroll to the right and the last field will be the new one and for the user who posted it should of gone up by one

[Infamouz Nex]

ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh ok.... you see.... thanx for your patiences, Nex has learned something new today. *wink*

[Infamouz Nex]

now editing that, aint that easy dude... quick run up on it... :xeye: :blush:

[Ken Iovino]

Here what i did.
I ran this query
[sql]ALTER TABLE `user` ADD `threadsbyuser` INT(10) UNSIGNED DEFAULT "0" NOT NULL;[/sql]

then In 'includes/functions_newpost.php'
I found :

You must first be a registered member to view any code.

And replaced with:

You must first be a registered member to view any code.

I made a new post in forumid 2 and then went and looked at the 'threadsbyuser' feild in table 'user' and the count did not go up. Anything i did wrong?

[Infamouz Nex]

bump