'Thanks' button
- thePWA
- Porter
- Posts: 2416
- Joined: Sun Aug 19, 2012 2:27 pm
- Custom Rank: JOSHAUAGES v2.0
- Location: Earth circa 1999
- Contact:
Re: 'Thanks' button
No problem man, just waiting to post my thanks to you and all your hard work
Stop! Waitaminute! Fill mah cup with some liquor in it!
- semory
- Site Admin
- Posts: 7755
- Joined: Sat Aug 04, 2012 7:38 pm
- Custom Rank: Kitty pu tu tu lay!
- Location: Torrance, CA
Re: 'Thanks' button
anyone want to help design the thanks button? blue is for mouse not over and red is for mouse over. from what I gather from Arty on the phpbb forums, the font used for these buttons is "Bauhaus Light CCT."
for 't'
for 'a'
for 'n'
for 'k'
for 's'
for 't'
for 'a'
for 'n'
for 'k'
for 's'
- thePWA
- Porter
- Posts: 2416
- Joined: Sun Aug 19, 2012 2:27 pm
- Custom Rank: JOSHAUAGES v2.0
- Location: Earth circa 1999
- Contact:
Re: 'Thanks' button
I can help you out there. Can you give me a few hours until I can get off work?semory wrote:anyone want to help design the thanks button? blue is for mouse not over and red is for mouse over. from what I gather from Arty on the phpbb forums, the font used for these buttons is "Bauhaus Light CCT."
for 't'
for 'a'
for 'n'
for 'k'
for 's'
Stop! Waitaminute! Fill mah cup with some liquor in it!
- semory
- Site Admin
- Posts: 7755
- Joined: Sat Aug 04, 2012 7:38 pm
- Custom Rank: Kitty pu tu tu lay!
- Location: Torrance, CA
Re: 'Thanks' button
few hours, few days... it's cool, no rush on anything!
- semory
- Site Admin
- Posts: 7755
- Joined: Sat Aug 04, 2012 7:38 pm
- Custom Rank: Kitty pu tu tu lay!
- Location: Torrance, CA
Re: 'Thanks' button
lol this is messed up or rather pretty amazing how forums work... this is the SQL query used to retrieve posts. he he he custom status messages are on the way ha ha ha.
Code: Select all
// note: user 54 is howfie
SELECT u.*, z.friend, z.foe, p.*
FROM (phpbb_users u CROSS JOIN phpbb_posts p) LEFT JOIN phpbb_zebra z ON (z.user_id = 54 AND z.zebra_id = p.poster_id)
WHERE p.post_id IN (1, 2, 3) AND u.user_id = p.poster_id;
- iheartibuki
- Moderator
- Posts: 6552
- Joined: Sun Aug 19, 2012 9:59 am
- Custom Rank: Fappy Bird
- Location: The Land of the Free
- Contact:
- semory
- Site Admin
- Posts: 7755
- Joined: Sat Aug 04, 2012 7:38 pm
- Custom Rank: Kitty pu tu tu lay!
- Location: Torrance, CA
Re: 'Thanks' button
yeah, i'm going to implement a custom thanks system, and all it needs is just one thanks button (it will be there if you haven't thanked this post already). so it's going to take some time to implement. it's going to be slightly different from xentax, in that the thank counts are going to be hard-numbered in the phpbb_users table. this way when someone deletes their account or if we delete it you don't lose your thanks.
i'm also wondering if you guys want the list of users who have thanked you? like on xentax:
is it important to know who thanked you?
i'm also wondering if you guys want the list of users who have thanked you? like on xentax:
Code: Select all
x, y, and z have thanked you for this post.
- iheartibuki
- Moderator
- Posts: 6552
- Joined: Sun Aug 19, 2012 9:59 am
- Custom Rank: Fappy Bird
- Location: The Land of the Free
- Contact:
Re: 'Thanks' button
Hehe well, it depends. There's only a few of us here so even if everyone thanks you it shouldn't that be that big of a hit to the database (although I dunno if you really wanna list them all, kinda like the fave or watch system on deviantArt). It might be an issue, of course, from a math standpoint if someone leaves and you have 55 thanks, while when you list the people who thanked you it only lists 45, for example. If you're also hardcoding the name of the person then that shouldn't be a problem.
Funny, I rarely use cross join and left join, the Oracle-specific syntax for that is p.poster_id = z.zebra_id (+), which to me is much easier to understand, hehe.
Funny, I rarely use cross join and left join, the Oracle-specific syntax for that is p.poster_id = z.zebra_id (+), which to me is much easier to understand, hehe.
- thePWA
- Porter
- Posts: 2416
- Joined: Sun Aug 19, 2012 2:27 pm
- Custom Rank: JOSHAUAGES v2.0
- Location: Earth circa 1999
- Contact:
Re: 'Thanks' button
Stop! Waitaminute! Fill mah cup with some liquor in it!
Re: 'Thanks' button
Oh, awesome, I can't wait!!