Topic: Feature idea:
dreamworks4mayor '11 !xPoNIEsltA started this discussion 15 years ago #1,889
-Replies to your replies
also this should probably just be in history
also this should probably just be in history
dreamworks4mayor '11 !xPoNIEsltA (OP) double-posted this 15 years ago, 26 seconds later[^] [v] #34,797
after each reply one could see '(one new reply)'
Harleen Quinzel !jEsTERxAng joined in and replied with this 15 years ago, 9 seconds later, 35 seconds after the original post[^] [v] #34,798
Responce.
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 18 seconds later, 53 seconds after the original post[^] [v] #34,799
Anonymous C joined in and replied with this 15 years ago, 23 seconds later, 1 minute after the original post[^] [v] #34,801
We should have a mode that makes it more difficult to post!
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 40 seconds later, 1 minute after the original post[^] [v] #34,803
Anonymous D joined in and replied with this 15 years ago, 1 minute later, 3 minutes after the original post[^] [v] #34,806
Yeah, I'd code that if the administrators cared enough to implement it. How does AnonTalk's work?
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 2 minutes later, 5 minutes after the original post[^] [v] #34,811
Nega !34Kas0OdzM joined in and replied with this 15 years ago, 30 seconds later, 5 minutes after the original post[^] [v] #34,813
Every 10 posts, the user is required to answer a "Who wants to be a millionaire?" style question or beat The Board at 1 vs. 1 Battle Tetris.
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 47 seconds later, 6 minutes after the original post[^] [v] #34,815
dreamworks4mayor '11 !xPoNIEsltA (OP) double-posted this 15 years ago, 1 hour later, 1 hour after the original post[^] [v] #34,881
bump
Killer Lettuce !!iNo3FkiZx joined in and replied with this 15 years ago, 4 minutes later, 1 hour after the original post[^] [v] #34,891
That'd be a nice feature to have, I agree
r04r joined in and replied with this 15 years ago, 19 minutes later, 1 hour after the original post[^] [v] #34,903
This would only show cites? Interesting idea but it would be somewhat invasive to implement, and somewhat easy to annoy other users with (Random cites). Will look into it.
(Edited 39 seconds later.)
Fuchs !!4KU9PSdLG joined in and replied with this 15 years ago, 11 seconds later, 1 hour after the original post[^] [v] #34,904
Anonymous I joined in and replied with this 15 years ago, 31 minutes later, 2 hours after the original post[^] [v] #34,924
A seperare post button for shit posts that just bans you instead.
Anonymous J joined in and replied with this 15 years ago, 3 minutes later, 2 hours after the original post[^] [v] #34,926
@OP
Yes, just like Anontalk has.
Yes, just like Anontalk has.
TTEH !taZqHR8ods double-posted this 15 years ago, 17 seconds later, 2 hours after the original post[^] [v] #34,927
Also the ability to search your own history. :P
The Editor !0x5editovs joined in and replied with this 15 years ago, 34 seconds later, 2 hours after the original post[^] [v] #34,928
SELF-BAN BUTTON. Also, option to switch spoilers on/off on mobile.
Ryan !PArADOx9ZU joined in and replied with this 15 years ago, 4 minutes later, 2 hours after the original post[^] [v] #34,929
Wait, what are we talking about? Can someone link me to an example of this?
Killer Lettuce !!iNo3FkiZx replied with this 15 years ago, 2 minutes later, 2 hours after the original post[^] [v] #34,930
@34,927 (TTEH !taZqHR8ods)
Hey there TTEH
Haven't seen you around recently
Hey there TTEH
Haven't seen you around recently
(Edited 17 seconds later.)
Killer Lettuce !!iNo3FkiZx double-posted this 15 years ago, 1 minute later, 2 hours after the original post[^] [v] #34,931
Fuchs !!4KU9PSdLG replied with this 15 years ago, 40 seconds later, 2 hours after the original post[^] [v] #34,932
@34,929 (Ryan !PArADOx9ZU)
It's an AnT feature. Check the right column: http://www.anontalk.se/stuff
It's an AnT feature. Check the right column: http://www.anontalk.se/stuff
Fuchs !!4KU9PSdLG double-posted this 15 years ago, 17 seconds later, 2 hours after the original post[^] [v] #34,933
Pig Benis !VAgiNA0oKk joined in and replied with this 15 years ago, 3 minutes later, 2 hours after the original post[^] [v] #34,934
Well no new features will be added until you WORTHLESS PIECES OF SHIT SCUM TRAITOR TROLLS start SPREADING THE WORD! EAT MY SHIT FFS... ... ... ...
psychopath !PAHVpsycho joined in and replied with this 15 years ago, 21 minutes later, 2 hours after the original post[^] [v] #34,938
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 11 hours later, 14 hours after the original post[^] [v] #35,161
i dont want it the way at has it though
ill make a screen wait a sec...
ill make a screen wait a sec...
dreamworks4mayor '11 !xPoNIEsltA (OP) double-posted this 15 years ago, 5 minutes later, 14 hours after the original post[^] [v] #35,162
like thisAnonymous D replied with this 15 years ago, 8 minutes later, 14 hours after the original post[^] [v] #35,163
@previous (dreamworks4mayor '11 !xPoNIEsltA)
It would be clearer in the "Age" column. And I guess the "History" link in the menu should have an exclamation mark when there are replies to your replies, and maybe clicking that mark will show a page with just your newly-replied replies?
It would be clearer in the "Age" column. And I guess the "History" link in the menu should have an exclamation mark when there are replies to your replies, and maybe clicking that mark will show a page with just your newly-replied replies?
sim !.biSsjaMxA joined in and replied with this 15 years ago, 3 minutes later, 14 hours after the original post[^] [v] #35,164
This is potentially very heavy on the server. Also I don't give a fuck about dreamworks.Anonymous F replied with this 15 years ago, 11 minutes later, 15 hours after the original post[^] [v] #35,166
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 2 minutes later, 15 hours after the original post[^] [v] #35,167
sim !.biSsjaMxA replied with this 15 years ago, 7 minutes later, 15 hours after the original post[^] [v] #35,170
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 1 minute later, 15 hours after the original post[^] [v] #35,172
sim !.biSsjaMxA replied with this 15 years ago, 27 seconds later, 15 hours after the original post[^] [v] #35,173
Anonymous D replied with this 15 years ago, 32 seconds later, 15 hours after the original post[^] [v] #35,174
@35,164 (sim !.biSsjaMxA)
> This is potentially very heavy on the server.
- A maximum of 10 extra INSERTs when posting a reply, one for each citation (and there's rarely more than one, anyway)
- A single SELECT (where uid=%1 limit 1) on every page load, if there will be a ! or other notifier
- A single DELETE (where uid=%1 and parent=%2) on loading a topic page
- Another JOIN on the history page.
That would be trivial.
> This is potentially very heavy on the server.
- A maximum of 10 extra INSERTs when posting a reply, one for each citation (and there's rarely more than one, anyway)
- A single SELECT (where uid=%1 limit 1) on every page load, if there will be a ! or other notifier
- A single DELETE (where uid=%1 and parent=%2) on loading a topic page
- Another JOIN on the history page.
That would be trivial.
sim !.biSsjaMxA replied with this 15 years ago, 1 minute later, 15 hours after the original post[^] [v] #35,175
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 16 seconds later, 15 hours after the original post[^] [v] #35,176
sim !.biSsjaMxA replied with this 15 years ago, 5 minutes later, 15 hours after the original post[^] [v] #35,177
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 1 hour later, 16 hours after the original post[^] [v] #35,270
dreamworks4mayor '11 !xPoNIEsltA (OP) double-posted this 15 years ago, 31 minutes later, 17 hours after the original post[^] [v] #35,304
bump
dreamworks4mayor '11 !xPoNIEsltA (OP) triple-posted this 15 years ago, 1 day later, 2 days after the original post[^] [v] #36,637
bump
Anonymous P joined in and replied with this 15 years ago, 2 hours later, 2 days after the original post[^] [v] #36,660
noko
Anonymous F replied with this 15 years ago, 3 minutes later, 2 days after the original post[^] [v] #36,664
@previous (P)I'm not at all saying that you're mad, but I just wanted a chance to use this
(Edited 50 seconds later.)
Anonymous P replied with this 15 years ago, 53 seconds later, 2 days after the original post[^] [v] #36,666
dreamworks4mayor '11 !xPoNIEsltA (OP) replied with this 15 years ago, 19 minutes later, 2 days after the original post[^] [v] #36,673
Anonymous D replied with this 15 years ago, 3 days later, 5 days after the original post[^] [v] #40,769
Since foreign key constraints aren't available, how would deleted replies/topics be dealt with? I'm using:
...on the history page, with a notice that some or all replies-to-your-replies have since been deleted per the affected rows (to clear up the misleading ! notifier). Is there a better way/more efficient query?
Edit: Just realized that the query would need to be limited by UID for the affected rows to matter.
DELETE FROM reply_notifications
WHERE NOT EXISTS
(SELECT 1 FROM replies WHERE reply_notifications.reply = replies.id)
OR NOT EXISTS
(SELECT 1 FROM topics WHERE reply_notifications.topic = topics.id)
WHERE NOT EXISTS
(SELECT 1 FROM replies WHERE reply_notifications.reply = replies.id)
OR NOT EXISTS
(SELECT 1 FROM topics WHERE reply_notifications.topic = topics.id)
...on the history page, with a notice that some or all replies-to-your-replies have since been deleted per the affected rows (to clear up the misleading ! notifier). Is there a better way/more efficient query?
Edit: Just realized that the query would need to be limited by UID for the affected rows to matter.
(Edited 2 minutes later.)
Anonymous D double-posted this 15 years ago, 10 hours later, 6 days after the original post[^] [v] #41,322
I decided that a separate list would be cleaner and easier to use than OP's "(2 new)" suggestion.Has table locking been removed from post.php in the latest TinyBBS?
sim !PznzndQYds replied with this 15 years ago, 2 hours later, 6 days after the original post[^] [v] #41,362
Anonymous D replied with this 15 years ago, 4 hours later, 6 days after the original post[^] [v] #41,439
Ash Ketchup * !bbKEtchUp. joined in and replied with this 15 years ago, 19 minutes later, 6 days after the original post[^] [v] #41,461
Anonymous D replied with this 15 years ago, 4 hours later, 6 days after the original post[^] [v] #41,878
My version is now running at http://tiny.nfshost.com/ (it's impossible to test without two UIDs). I profiled all of the queries; they're fast even with an unreasonably large database.
MIT source code:
history.php
Small changes to .htaccess, post.php, topic.php, template.php and header.php are described here: http://pastebin.com/70m0ZKAZ
MIT source code:
CREATE TABLE `citations` (
`uid` varchar(23) NOT NULL,
`topic` int(11) unsigned NOT NULL,
`reply` int(11) unsigned NOT NULL,
KEY `uid` (`uid`),
KEY `topic` (`topic`)
)
history.php
Small changes to .htaccess, post.php, topic.php, template.php and header.php are described here: http://pastebin.com/70m0ZKAZ
Anonymous D double-posted this 15 years ago, 52 minutes later, 6 days after the original post[^] [v] #41,936
@previous (D)
I forgot to mention that this won't work properly if post.php still has table locking (but r04r took that out, IIRC).
I forgot to mention that this won't work properly if post.php still has table locking (but r04r took that out, IIRC).