Have a good time being a mod BDA. Don't fuck up like [del]Rusty[/del] Ventilated.
congrats
Congrats BDA.
[QUOTE=garry;30134250]To use pagination it has to sort the thread. It takes longer to sort 5,000 posts than 1,000 posts.[/QUOTE]
I've tested on a large database of mine and that appears to be the case, although another idea you might want to look into is having a 'pages' table with a column for thread id, page number and the post id of the first post on that page.
To fetch a page of posts, you'd do something like the following:
[code]
$first_post = query("SELECT post_id FROM pages WHERE thread_id = ? AND page = ?", $thread_id, $page_number);
$posts = query("SELECT * FROM posts WHERE thread_id = ? AND id >= ? ORDER BY post_id LIMIT 50", $thread_id, $first_post);
[/code]
I've done some testing and with this method, there's no noticeable difference in query times when loading early posts compared to later posts.
Fuck yeah, congrats BDA
I knew it would happen sooner or later.
Congrats BDA!
Do you think we could some options for the ticker? Being able to filter posts to only show posts you where mentioned in or only showing posts in certain sections and stuff like that would be cool.
BDA :golfclap:
Now we wait for him to visit Facepunch.
Try this
[url]http://www.facepunch.com/chat/[/url]
i like to party yeaaaa
Congratulations BDM
[QUOTE=garry;30135025]Try this
[url]http://www.facepunch.com/chat/[/url][/QUOTE]
Cool, might be even cooler if it was linked to the IRC or something. :v:
oh god so many replies about me.
[QUOTE=garry;30135025]Try this
[url]http://www.facepunch.com/chat/[/url][/QUOTE]
Make channels and some neat system for the forum such as [chat]room_name[/chat] and it could be useful.
[QUOTE=343N;30135175]oh god so many replies about me.[/QUOTE]
HAPPY 10TH BIRTHDAY
[QUOTE=343N;30135175]oh god so many replies about me.[/QUOTE]
Happy Birthday :v:
Can I suggest PM abilities, a better interface and filters.
+ The lag is unbearable.
ITS MY BIRTHDAY IN TWO MONTHS AND I'M TURNING 13 FFF.
[QUOTE=343N;30135227]ITS MY BIRTHDAY IN TWO MONTHS AND I'M TURNING 13 FFF.[/QUOTE]
You made your facepunch account when you were 8-9 years old? Nice.
[QUOTE=postal;30135103]i like to party yeaaaa[/QUOTE]
[11:30:49] postal:oh great stizzles is here
:raise:
[QUOTE=fruxodaily;30135248]You made your facepunch account when you were 8-9 years old? Nice.[/QUOTE]
10 actually.
[QUOTE=Marlamin;30135164]Cool, might be even cooler if it was linked to the IRC or something. :v:[/QUOTE]
What he says
Congrat to all of you for being on Facepunch
:downs:
[QUOTE=garry;30135025]Try this
[url]http://www.facepunch.com/chat/[/url][/QUOTE]
nice idea garry
[img]http://dl.dropbox.com/u/12217899/niece.png[/img]
Seriously channels would be so nice..
[QUOTE=fruxodaily;30135299]Seriously channels would be so nice..[/QUOTE]
IMHO existing groups should be the channels
[QUOTE=angelangel;30135280]nice idea garry
[img]http://dl.dropbox.com/u/12217899/niece.png[/img][/QUOTE]
It [i]is[/i] a nice idea, there's just a lot of spam the first few minutes because it's new and all, people get excited but they'll get over it in a while, then it'll be a nice chat room.
People who spam are stupid anyway, they get banned for a long time, seeing as garry is in there right now.
[editline]30th May 2011[/editline]
that thumb image
[QUOTE=Pretiacruento;30135366]IMHO existing groups should be the channels[/QUOTE]
Well I was more thinking for different shit
"Video games"
"Garry's mod"
"General Bullshit"
"News and other bulletins"
Sorry, you need to Log In to post a reply to this thread.