how bout a count of how many threads someone hijacks?
select count(*)
from ttf_thread
where ttf_thread.author_id=(select ttf_post.author_id
from ttf_post
where ttf_post.thread_id=ttf_thread.thread_id
order by date asc
limit 0,1)it should be something like that.. except it's counting all the threads. and i can't really figure it out.
DUH
see the difference?
the answer is...
god i love the power of sql
select count(*)
from ttf_thread
where ttf_thread.author_id!=(select ttf_post.author_id
from ttf_post
where ttf_post.thread_id=ttf_thread.thread_id
order by date asc
limit 0,1)see the difference?
the answer is...
count(*) 10
god i love the power of sql
haha thats sweet
lr: see the difference?
!
!
pirate icon next to hijacked threads? :o
haha.. nah
because i'm gonna redo the thread creation script
because i'm gonna redo the thread creation script
ahhhhhhh im gonna miss hijacking threads
we could make it a competition. . . see who can hijack the most threads. maybe have a page somewhere with everyone's totals.
go ahead.
i plan to rewrite newthread.php which makes you enter a post as well before the thread is inserted.
i plan to rewrite newthread.php which makes you enter a post as well before the thread is inserted.
that has a few benefits, in my mind:
1. you need to enter a first post, because only entering a thread title leaves too much room for ambiguity.
2. people who wanted to search will realize what they did, will not enter a post, and will not create a thread.
3. people won't be able to hijack threads.
i think i had more.. :/
1. you need to enter a first post, because only entering a thread title leaves too much room for ambiguity.
2. people who wanted to search will realize what they did, will not enter a post, and will not create a thread.
3. people won't be able to hijack threads.
i think i had more.. :/
yeah lr, i suggested that you should do that a while a go after i hijacked one of nny's threads i think.
and im pretty sure i would be schooling everyone in hijacked threads :)
and im pretty sure i would be schooling everyone in hijacked threads :)
Yeah, I think I suggested this too. If someone were to use ttf on a larger scale, hijacked threads would be much more common.
___
\_/
|._
|'."-._.-""--.-"-.__.-'/
| \ .-. (
| | (@.@) )
| | '=.|m|.=' /
jgs | / .='`"``=. /
|.' (
|.-"-.__.-""-.__.-"-.)
|
|
|
haha that rules oz
who wants to ride bikes?