vB3 Threads Started in Postbit v1.3

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

[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?