I've been tipped a bunch of coral recently, and the only way I know is I visited the threads with the posts I got coral for at a later date. Maybe there should be a thing where the next time you log in the forum displays a message saying who tipped you and the amount!
This is a good idea, bump
i really like this idea
nicefish set ticket status to WONTFIX
Kate will be rewriting the forum.
the whole friggin forum? dang i woulda thought it'd be easier to get an open source package and modify it but what do i know!
Quote from: here cums the fuck truck on February 15, 2018, 02:08:58 PM
the whole friggin forum? dang i woulda thought it'd be easier to get an open source package and modify it but what do i know!
I personally agree.
Issa good idea tho
Hey there, still no notification system yet but yam just finished this recent tips page - https://wetfishonline.com/index.php?action=tips
Quote from: rachel on February 07, 2019, 11:25:48 AM
Hey there, still no notification system yet but yam just finished this recent tips page - https://wetfishonline.com/index.php?action=tips
Niiiiiiiiiiice!
It'd actually be kinda cool to make this feature, as much as I hate smf.
Quote from: Yam on February 09, 2019, 06:24:55 PM
It'd actually be kinda cool to make this feature, as much as I hate smf.
forum v2 forum v2 forum v2 forum v2 forum v2 forum v2 forum v2 forum v2 forum v2
it seems to show only the last three or so posts someone has been tipped on. the most i've seen is three, right now i can only see the last two tips
Quote from: here cums the fuck truck on December 01, 2019, 07:14:17 AM
it seems to show only the last three or so posts someone has been tipped on. the most i've seen is three, right now i can only see the last two tips
do you mean when viewing the recent tips page itself or when searching for a user?
right now I can see about 10-15 posts all with tips
when searching for who's tipped me, or who's tipped a specific user, i can see at most the last three tips
Quote from: here cums the fuck truck on December 01, 2019, 07:31:24 PM
when searching for who's tipped me, or who's tipped a specific user, i can see at most the last three tips
Because of the way the forum database is structured, it was really infeasible to achieve what you're asking for.
I hit a dead end when trying to implement it that way because there's no post->tip correlation, only a tip->post correlation and because of that I couldn't search a users posts for tipped posts. The way it current works is it just looks through the last X TIPS (in general) and can filter by user (there's also no timestamp for tips so you can't do all tips in last X time either).
I guess I could have made the user search a separate query so that it'd go through your posts and check the tips tables for a tip associated with the posts. But the search was just something I added quickly because it was easy (two lines) and it wasn't part of the initial plan for the tip page.
To search an user's posts for tipped posts, couldn't you just do some joins?
SELECT DISTINCT posts.post_id
FROM posts
INNER JOIN tips ON tips.post_id = posts.post_id
WHERE posts.user_id = YOU
ORDER BY posts.post_id DESC
LIMIT 10
(I haven't written SQL in like 5 years)
Quote from: nicefish on December 01, 2019, 10:27:32 PM
To search an user's posts for tipped posts, couldn't you just do some joins?
SELECT DISTINCT posts.post_id
FROM posts
INNER JOIN tips ON tips.post_id = posts.post_id
WHERE posts.user_id = YOU
ORDER BY posts.post_id DESC
LIMIT 10
(I haven't written SQL in like 5 years)
Ye u right, but I'm bad at SQL and didn't think of it at the time lol
If Rachel wants I could probably fix it.
and thank you for making the tip page :)
Quote from: Yam on December 02, 2019, 09:54:42 AM
Quote from: nicefish on December 01, 2019, 10:27:32 PM
To search an user's posts for tipped posts, couldn't you just do some joins?
SELECT DISTINCT posts.post_id
FROM posts
INNER JOIN tips ON tips.post_id = posts.post_id
WHERE posts.user_id = YOU
ORDER BY posts.post_id DESC
LIMIT 10
(I haven't written SQL in like 5 years)
Ye u right, but I'm bad at SQL and didn't think of it at the time lol
If Rachel wants I could probably fix it.
Yes please, you know I love it when you write code