Re: 'Thanks' button
Posted: Tue Nov 13, 2012 3:22 pm
No problem man, just waiting to post my thanks to you and all your hard work 
for 't'
for 'a'
for 'n'
for 'k'
for 's'
Page 2 of 3
Re: 'Thanks' button
Posted: Tue Nov 13, 2012 3:50 pm
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'
Re: 'Thanks' button
Posted: Tue Nov 13, 2012 4:20 pm
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'
Re: 'Thanks' button
Posted: Tue Nov 13, 2012 4:33 pm
few hours, few days... it's cool, no rush on anything!
Re: 'Thanks' button
Posted: Tue Nov 13, 2012 5:22 pm
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;
Re: 'Thanks' button
Posted: Tue Nov 13, 2012 5:51 pm
Do you just need one? If not then I'll sign up. Got scenarios?
Re: 'Thanks' button
Posted: Tue Nov 13, 2012 7:29 pm
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.
Re: 'Thanks' button
Posted: Tue Nov 13, 2012 8:18 pm
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.
Re: 'Thanks' button
Posted: Thu Nov 15, 2012 4:38 am
Re: 'Thanks' button
Posted: Thu Nov 15, 2012 7:30 am
Oh, awesome, I can't wait!! 