vB3 Threads Started in Postbit v1.3

[Boofo]

vB3 Threads Started in postbit, pm, usernotes, showpost and profile Version 1.3
(By Boofo and Kirby)

What does this hack do?
This hack will add how many threads (like how many posts) the member started in the postbit, pm, usernotes, showpost and profile.

Credits:
A big thanks goes out to Kirby for helping me find my mistakes (which were many) and supplying the core code for this hack. And to Mike Gaidin for the original idea and request for this. ;)

Version Information:
Version 1.0 --Initial release
Version 1.1 --Fixed bug where you would get a db error if a guest viewed a thread in linear mode.
Version 1.2 --Fixed bug where it would show the threads started variable instead of n/a (like the posts variable does) for guests posts.
Version 1.3 --Fixed last known bug where you would get a db error if a guest viewed a thread in threaded display mode.

Installation overview:
Files to edit: (6)
--showthread.php
--usernote.php
--showpost.php
--announcement.php
--member.php
--private.php
Templates to edit: (3)
--postbit
--postbit_legacy
--memberinfo

[SaN-DeeP]

any screenies please :)

[Chris M]

Use your imagination...

Stare at the above post, and picture the word "Posts:" as "Threads:" and then picture the number as a number between 0 and 1,000,000 :)

Satan

[Mr. HillBilly]

* Mr. HillBilly installs


Thanks for this great hack bofoo

[Mike Gaidin]

Nice to see it released. :)

[Logik]

pretty nice, i dont know why it isnt in vb3 as default.

[Mr. HillBilly]

Boofo, this might be a bug, when viewing a thread it just shows : 2

[Boofo]

Boofo, this might be a bug, when viewing a thread it just shows : 2

Screenshot?

[Mr. HillBilly]

Screenshot?

here

[Boofo]

Check my forums...

Link, then? And if it only shows 2, then that is all the threads that user has started. Check my forums, this is the excact code I use there.

[Mr. HillBilly]

Link, then? And if it only shows 2, then that is all the threads that user has started. Check my forums, this is the excact code I use there.

Sorry attached Screenshot.

[Boofo]

here

Do the phrases at the bottom of the file. :rolleyes:

By the way, check your Spear Toss scores. :surprised:

[Mr. HillBilly]

Do the phrases at the bottom of the file. :rolleyes:

By the way, check your Spear Toss scores. :surprised:

I did everything instructed in the file. :rolleyes:

[Boofo]

I did everything instructed in the file. :rolleyes:

I forgot a phrase. My bad. :(

I'm fixing it now and will upload the corrected instructions shortly.

EDIT: The corrected install file has been uploaded to the first post. Just do the phrases again and the template edits. Sorry for the delay. ;)

[Gio Takahashi]

I NEEDED THIS HACK!

Thanks Boof.

[Vivi Ornitier]

good ++++ man, very useful to any forum.

now next step, mod apps! lol

good job.

[pjdaley]

what if you just wanted it counting threads in certain forums? not all of them?

[sabret00the]

nice work boofo :D

[Boofo]

I NEEDED THIS HACK!

Thanks Boof.

Don't forget the install button then. ;)

[Boofo]

what if you just wanted it counting threads in certain forums? not all of them?

Then, unfortunately, you would have to use another hack. Sorry. :(

[pjdaley]

lol i installed it already, and click *install* but lol is there any other hack? no right?

[Boofo]

lol i installed it already, and click *install* but lol is there any other hack? no right?

No other hack here but that one. You must have clicked uninstall already then. ;)

[JagFan]

Thanks for this!! My users like it :) so when they are happy - I can be happy ;)

[Majik?]

Nice one! :up:

[pjdaley]

ohh man, can someone please make it so forumsid can be inserted? i just want each user to count but only from 5 forums... or the forums id's i give it

[pjdaley]

anyone?

[turbidblue]

thanks boofo, as always simple to install but very handy :)

* turbidblue clicks install :)

[Natch]

Damn fine hack Boofo - good instructions == smooth as silk :)

Cheers! *clink*

[SnowBot]

I installed this but now when viewing a profile the post count is wrong.

[Boofo]

I installed this but now when viewing a profile the post count is wrong.
Then you have something else going on. This hack doesn't touch the postcount.

[vbIce]

This is a GREAT Hack :)

A few questions though.

How can I create a search the TOP Thread Starters like TOP POSTERS in Admincp?

Second how hard would it be to ADD a THANK YOU counter like this too?



clicks install :)

[mfk_1868]

can you help me on building a hack? i want to set up promotions related to threads started how can i do this?

[Snatch]

A view users get this error


Datenbankfehler in vBulletin 3.0.5:

Ungueltige SQL-Abfrage:
SELECT COUNT(threadid) AS threads, postuserid AS userid
FROM thread
WHERE postuserid IN ()
GROUP BY postuserid

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY postuserid' at line 3

mysql error number: 1064

Datum: 16.02.2005 22:25:32
Skript: http://www.celebritymarkt.de/showthread.php?mode=hybrid&t=10739
Referer: http://www.celebritymarkt.de/showthread.php?t=10739
Benutzername: Nicht registriert
IP-Adresse: 172.183.38.81


this is the Code in this line


$struserids = implode(",", array_values($userids));
$sthreads = $DB_site->query("
SELECT COUNT(threadid) AS threads, postuserid AS userid
FROM " . TABLE_PREFIX . "thread
WHERE postuserid IN ($struserids)
GROUP BY postuserid
");
while ($threadcount = $DB_site->fetch_array($sthreads))
{
$search[] = "{threadsstarted[$threadcount[userid]]}";
$replace[] = vb_number_format($threadcount[threads]);
unset($userids[$threadcount[userid]]);
}
foreach ($userids as $userid)
{
$search[] = "{threadsstarted[$userid]}";
$replace[] = 0;
}
$postbits = str_replace($search, $replace, $postbits);



Can you help me ?

[Snatch]

I got this error


Datenbankfehler in vBulletin 3.0.5:

Ungueltige SQL-Abfrage:
SELECT COUNT(threadid) AS threads, postuserid AS userid
FROM thread
WHERE postuserid IN ()
GROUP BY postuserid

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY postuserid' at line 3

mysql error number: 1064

Datum: 17.03.2005 07:28:55
Skript: http://www.celebritymarkt.de/showthread.php?t=14744
/> Referer: http://www.celebritymarkt.de/forumdisplay.php?f=5
/> Benutzername: fanta



in line 1699:

$struserids = implode(",", array_values($userids));


Can u help me ?

[Snake]

That's a great hack, thanks.

[Snake]

Boofo I am currently running on 3.5 RC2 so how about an upgrade? :P I am really looking forward to this hack.

[Snake]

<font size="5">Bump!</font>

[Snake]

Bump!

I really need this.

[Alphawolf83]

Great hack though the forumsid selection isn't inserted yet ;)

[Snake]

v3.5.0 please? :)