Wetfish Online
Discussion Forums => Suggestions & Feedback => Topic started by: Anomaly on December 22, 2017, 09:09:27 pm
-
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!
-
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/forum/index.php?action=tips
-
Hey there, still no notification system yet but yam just finished this recent tips page - https://wetfishonline.com/forum/index.php?action=tips
Niiiiiiiiiiice!
-
It'd actually be kinda cool to make this feature, as much as I hate smf.
-
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
-
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
-
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)
-
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 :)
-
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