MFGG Forums
  • Home
  • Members
  • Help
  • Search
MFGG Main Site MFGG Forums MFGG Suggestions Resolved Suggestions v
« Previous 1 2 3 4 5 … 10 Next »
DONE  Ability to like Main Site submissions (Now in Main site!)
MFGG Forums MFGG Suggestions Resolved Suggestions v
« Previous 1 2 3 4 5 … 10 Next »
DONE  Ability to like Main Site submissions (Now in Main site!)
MFGG Forums MFGG Suggestions Resolved Suggestions v
« Previous 1 2 3 4 5 … 10 Next »
DONE  Ability to like Main Site submissions (Now in Main site!)
Mark All Posts Read Today's Posts

[Done] Ability to like Main Site submissions (Now in Main site!)
HylianDev
Hammer Bro
Members
Site Developer/Webmasters Submitter NCFC Contributor Secret Santa Popeyes Badge MFGG 17th Anniversary MFGG Awards 2017 Winner
#6
03-24-2020, 04:33 PM (This post was last modified: 03-24-2020, 04:35 PM by HylianDev.)
im not sure how the comment liking ability was programmed, but heres my assumptions & suggestion:

ill assume that a table was created: `comment_likes` which contains `user_id` and `comment_id`. if this is the case, you could create a second table, `resource_likes` and give it `user_id` and `resource_id` (or in keeping with TCSMS tradition, `uid` and `rid`)

the better solution is: a table called `likes` with `user_id`, `content_type` and `content_id`. then probably another table called `likes_content_types` or similar with `id` and a description ("Resources", "Comments", etc). then lets say `likes_content_types` has a row `ID: 3, description: "Resources"`. then when youre on a sprite sheet with then ID `123`, youll get likes from `likes` where it has `content_type` 3 and `content_id` 123

there are other things in the TCSMS database that work like this (for instance, resources is a table with all resource types, then there are tables that hold type-specific meta info for sprites, games, etc) so it should fit in without breaking any conventions, if you name the columns accordingly
Vimimin Wrote:Hylian's day job, little did we know, was saying controversial things on the internet.
Mors Wrote:you fool!!!! you fixed it wrong!!!!

[Image: GGyaUXO.png]

[Image: ggc0JQ0.png] [Image: d7OJc4b.png]
Bibby Team
[-] The following 1 user Likes HylianDev's post:1 user Likes HylianDev's post
  ↳ Mariofan230
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Messages In This Thread
Ability to like Main Site submissions (Now in Main site!) - by Mariofan230 - 03-22-2020, 09:52 PM
RE: Ability to like/favorite/1-UP/Thumbs up Main Site submissions - by Hyper - 03-22-2020, 10:35 PM
RE: Ability to like/favorite/1-UP/Thumbs up Main Site submissions - by GeneralGuy - 03-22-2020, 11:33 PM
RE: Ability to like/favorite/1-UP/Thumbs up Main Site submissions - by Mors - 03-23-2020, 10:52 PM
RE: Ability to like/favorite/1-UP/Thumbs up Main Site submissions - by Evil Yoshi Toes - 03-23-2020, 11:18 PM
RE: Ability to like/favorite/1-UP/Thumbs up Main Site submissions - by HylianDev - 03-24-2020, 04:33 PM
RE: Ability to like Main Site submissions (Now in Main site!) - by Mariofan230 - 07-17-2020, 09:25 PM
RE: Ability to like Main Site submissions (Now in Main site!) - by Hyper - 07-17-2020, 09:37 PM

  • View a Printable Version
Forum Jump:

Mario Fan Games Galaxy - Powered by MyBB | MFGG Staff | Contact Us

Linear Mode
Threaded Mode