Say my name SCREAM my name hack

A very simple hack.

This hack displays the total amount of times your name has been said in a post(say) and how many times you name has been said in a title(scream). It is very simple yet a nice conforting feeling for some people to see that there name is said often :}

[Chris M]

Yeh...

Have sort of like a Multiple search string...

Satan

[Sparkz]

If you want to count the words, and don't want to search all posts, here's a start for ya:
SELECT word.title, searchindex.postid FROM word INNER JOIN searchindex ON word.wordid = searchindex.wordid WHERE word.title like '%something%'

This one will return all the post id's where the search term is found.

[SaintDog]

Not a bad hack, not something I would personally use myself, but a good hack nonetheless.

Good job!

- SaintDog

[Spleasure]

SELECT DISTINCT t.title FROM thread t, post p,searchindex s, word w WHERE s.wordid=w.wordid AND w.title='YOURNAME' AND p.postid=s.postid AND t.threadid=p.threadid

alle the titles of the threads with the word YOURNAME in it. Simply count them ...

(2.2.6)

[proxyMX]

Zajako, i dig your hacks but i diss your avatar ::P
i would install this hack as its a great idea, however i dont want to drain my badnwith or lag my forums up :P I definately think this is collio though, If there was a magically way to preserve bandwith i definately would

[GaleForce]

This is cool, and I installed it, however I get a DB error if someone has a ' in their name.

[Vivi Ornitier]

is there anyway to point out where the name said and named screamed occured? like which forum and such