'Thanks' button

General information about this site, including rules and announcements.

Moderators: Dazzy, Love2Raid

User avatar
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

Post by thePWA »

No problem man, just waiting to post my thanks to you and all your hard work :D
Stop! Waitaminute! Fill mah cup with some liquor in it!
User avatar
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

Post by semory »

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'
Image

for 'a'
Image

for 'n'
Image

for 'k'
Image

for 's'
Image
User avatar
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

Post by thePWA »

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'
Image

for 'a'
Image

for 'n'
Image

for 'k'
Image

for 's'
Image
I can help you out there. Can you give me a few hours until I can get off work?
Stop! Waitaminute! Fill mah cup with some liquor in it!
User avatar
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

Post by semory »

few hours, few days... it's cool, no rush on anything!
User avatar
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

Post by semory »

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; 
User avatar
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

Post by iheartibuki »

Do you just need one? If not then I'll sign up. Got scenarios?
"TheyÔÇÖre not only moron but also Galapagosian Lolita Complexed Chicken."

User avatar
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

Post by semory »

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:

Code: Select all

x, y, and z have thanked you for this post.
is it important to know who thanked you?
User avatar
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

Post by iheartibuki »

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.
"TheyÔÇÖre not only moron but also Galapagosian Lolita Complexed Chicken."

User avatar
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

Post by thePWA »

semory wrote:few hours, few days... it's cool, no rush on anything!

http://sta.sh/025k8ws5twn0
Stop! Waitaminute! Fill mah cup with some liquor in it!
User avatar
Love2Raid
Moderator
Posts: 6103
Joined: Sat Aug 18, 2012 6:10 am
Custom Rank: w

Re: 'Thanks' button

Post by Love2Raid »

Oh, awesome, I can't wait!! :evillaugh:
Post Reply