Hats

5 years ago by Dan

Are to be worn.

Tags: hats, clothing, wearingclothes, oldmen, golf, golfhats, hatsinwhichyougolf, hatsingeneral, largehats, smallhats

5 years ago by Dan

No captcha for replies? Oh my.

Also, why not just do captchas for registration?

&& Your OneLobby image on the bottom is broken.

5 years ago by k4st

For the time being I don't care about that small image on bottom.. I will probably make it text in the end, and I souped up the register form to look more like the thread create form and to also have captcha support. Adding captcha's everywhere is now sooooo easy

I don't think I will actually add a captcha to the comments just because it removed the quickness of them.

5 years ago by AngusThermopile

You could have comment captchas just for guest posting. Well if you allow the choice of guest posting at all. Hope you do.

5 years ago by Aka Tolken

Ja, me too.

5 years ago by k4st

That's a permissions thing

Also, do you guys like all 6 characters, or would you prefer less?

Query	Query Time	Affected Rows
SELECT o.object_name,o.object_perms,p.perm_grant,p.perm_deny FROM k4_objects o, k4_perms p, k4_roles r, k4_user_roles u WHERE u.user_id=1 AND u.role_id=r.role_id AND p.role_id=r.role_id AND o.object_id=p.object_id ORDER BY r.perm_level ASC	0.6842	3
SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.thread_id=39 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id LIMIT 1	0.6875	1
UPDATE `k4_threads` SET views=308 WHERE thread_id=39	0.0009	1
SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=39 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC	0.6977	1
SELECT c.*, u.name AS user_name FROM k4_comments c JOIN k4_users u USING( user_id ) WHERE c.thread_id=39 GROUP BY c.comment_id	0.7043	5

Query

Query Time

Affected Rows

SELECT o.object_name,o.object_perms,p.perm_grant,p.perm_deny FROM k4_objects o, k4_perms p, k4_roles r, k4_user_roles u WHERE u.user_id=1  AND u.role_id=r.role_id  AND p.role_id=r.role_id  AND o.object_id=p.object_id ORDER BY r.perm_level ASC

0.6842

3

SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.thread_id=39 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id LIMIT 1

0.6875

1

UPDATE `k4_threads` SET views=308 WHERE thread_id=39

0.0009

1

SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=39 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC

0.6977

1

SELECT c.*, u.name AS user_name FROM k4_comments c JOIN k4_users u USING( user_id ) WHERE c.thread_id=39 GROUP BY c.comment_id

Hats

0.6842

3

0.6875

1

0.0009

1

0.6977

1

0.7043

5