Say my name SCREAM my name hack

[zajako]

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 :}

[zajako]

here is a screen shot of it.

[Admin]

I wouldn't install this on a large forum, as it scans the whole post table every time. Nice idea, though.

[Sparkz]

I guess using the word and searchindex tables to determine what posts the username is mentioned in, and then go from there to actually scanning the posts.

I haven't looked at the actual hack yet, so I don't know if you already to it like this, but Firefly's post suggests that you don't...

[zajako]

it is a db serach very very similar to that of the how many threads while you were away as well as posts. Almost the same so if you had a problem with that then there will be a problem wiht this. If you had no problem with that one this should be fine :}

[Sparkz]

Well, those queries don't actually scan the contents of the posts, they just check dates.

And your code doesn't actually count how many times a name was said, but in how many posts/titles it was said...

[Chris M]

Lol...

I like it!

*Installs*

Satan

[Sparkz]

Just keep an eye on your serverload if you have a bit of traffic :)

[zajako]

ahh, you are correct sparkz, but it is close enough....maybe a 2.0 release might do a better job, but for now this works :}

[filburt1]

A lot of people call me filburt, furby, Arien (my real name), etc...it would be cool if we could define what name to search for ;)

[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