Testing CAPTCHA support

5 years ago by k4st

Just implemented a captcha.

It's quite clever how I made it, let's hope people find it readable.

Tags: feature, captcha

5 years ago by Aka Tolken

Mmmmm, CAPTCHA. It looks okay to me, but not so easy to distinguish that a 1 is a 1 and not an l.

5 years ago by k4st

Well, I wrote that all letters are uppercase, to a 1 shaped thing will always be a 1, whereas l will always be L. My main concern is sometimes the 4's look like 9's, and D's look like O's and 0's

5 years ago by XisZ

. . .

you know I swear I said that EXACT same thing to you last night.

1 = I = L
4 = 9

and

D = O = 0

5 years ago by Takesinn

Yeah man, wtf. I tried registering at a buddies house and it was impossible. Forgett about it! I mean I tried to verify like 6 times and it still didn't work. I tried two times today and got lucky on the second one. Robots can't pick em up but the point is humanoids are supposed to

5 years ago by k4st

I will tone it down then

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.2354	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=38 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.2387	1
UPDATE `k4_threads` SET views=355 WHERE thread_id=38	0.0011	1
SELECT tu.*, u.name AS user_name FROM k4_thread_users tu, k4_users u WHERE tu.thread_id=38 AND tu.user_id = u.user_id GROUP BY tu.user_id ORDER BY u.name ASC	0.2482	1
SELECT c.*, u.name AS user_name FROM k4_comments c JOIN k4_users u USING( user_id ) WHERE c.thread_id=38 GROUP BY c.comment_id	0.2527	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.2354

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=38 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.2387

1

UPDATE `k4_threads` SET views=355 WHERE thread_id=38

0.0011

1

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

0.2482

1

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

Testing CAPTCHA support

0.2354

3

0.2387

1

0.0011

1

0.2482

1

0.2527

5