Captcha Server
Door Martijn Wieringa, 21 jaar geleden, 4.666x bekeken
Voor een project ben ik bezig met het opzetten van een 'Captcha Server'.
Deze server moet random vragen en afbeeldingen outputten die in formulieren d.m.v. bijv. PHP kunnen worden toegepast.
Voorbeeld:
- server.php
- client.php
Voorbeeld: http://www.pholeron.com/projects/captcha/server.php
Gesponsorde koppelingen
PHP script bestanden
Er zijn 21 reacties op 'Captcha server'
Gesponsorde koppelingen
En hoofdstad werkt ook niet altijd...
In ELK land is de hoofdstad de stad waar de regering gevestigd is... Behalve in nederland... leg dat maar is uit aan een buitenlander, waaróm dat zo is ;)
En afkorting van nederland werkt ook niet, sommige zeggen NL sommige NE...
Misschien dat het klassieke "schrijf het over" toch het beste werkt.
Maar vind dit wil heel netjes geprogrammeerd, en orgineel bedacht!
In ELK land is de hoofdstad de stad waar de regering gevestigd is... Behalve in nederland... leg dat maar is uit aan een buitenlander, waaróm dat zo is ;)
En afkorting van nederland werkt ook niet, sommige zeggen NL sommige NE...
Misschien dat het klassieke "schrijf het over" toch het beste werkt.
Maar vind dit wil heel netjes geprogrammeerd, en orgineel bedacht!
De plaatjes envragen zijn als voornbeeld toegevoegd, en je kunt het je bezoekers zo makkelijk en moeilijk maken als je zelf wilt lijkt me.
Doel is dat het heel moeilijk (nnagenoeg onmogelijk) is om een bot te prgrammeren die de vragen weet te beantwoorden, en daar gaat het om.
Ik wil de tool straks uitbreiden met tal van thema's zodat je voor elke site je eigen genre kunt kiezen. Hoef ik maar op 1 server de captcha's te beheren om 100den/1000den sites te kunnen bedienen. Ideaal :)
Doel is dat het heel moeilijk (nnagenoeg onmogelijk) is om een bot te prgrammeren die de vragen weet te beantwoorden, en daar gaat het om.
Ik wil de tool straks uitbreiden met tal van thema's zodat je voor elke site je eigen genre kunt kiezen. Hoef ik maar op 1 server de captcha's te beheren om 100den/1000den sites te kunnen bedienen. Ideaal :)
De 'client' werkt zo dat deze steeds 'random' bepaald hoeveel afbeeldingen er worden gevraagd, en hoeveel van deze afbeeldingen moet worden aangevinkt (number_of_images en number_of_answers).
Als een vraag niet lijkt te kloppen heb ik mogelijk de antwoorden verkeerd ingevuld in de database. De huidige gegevens in de database zijn:
Als een vraag niet lijkt te kloppen heb ik mogelijk de antwoorden verkeerd ingevuld in de database. De huidige gegevens in de database zijn:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
CREATE TABLE `captcha_answers` (
`id` int(10) unsigned NOT NULL auto_increment,
`question` int(10) unsigned NOT NULL default '0',
`image` int(10) unsigned NOT NULL default '0',
`value` varchar(5) NOT NULL default 'false',
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_answers` VALUES (1, 1, 1, 'false');
INSERT INTO `captcha_answers` VALUES (2, 1, 2, 'false');
INSERT INTO `captcha_answers` VALUES (3, 1, 3, 'false');
INSERT INTO `captcha_answers` VALUES (4, 1, 4, 'false');
INSERT INTO `captcha_answers` VALUES (5, 1, 5, 'false');
INSERT INTO `captcha_answers` VALUES (6, 1, 6, 'true');
INSERT INTO `captcha_answers` VALUES (7, 1, 7, 'false');
INSERT INTO `captcha_answers` VALUES (8, 1, 8, 'false');
INSERT INTO `captcha_answers` VALUES (9, 1, 9, 'true');
INSERT INTO `captcha_answers` VALUES (10, 1, 10, 'false');
INSERT INTO `captcha_answers` VALUES (11, 1, 11, 'false');
INSERT INTO `captcha_answers` VALUES (12, 1, 12, 'false');
INSERT INTO `captcha_answers` VALUES (13, 1, 13, 'true');
INSERT INTO `captcha_answers` VALUES (14, 1, 14, 'false');
INSERT INTO `captcha_answers` VALUES (15, 1, 15, 'false');
INSERT INTO `captcha_answers` VALUES (16, 1, 16, 'false');
INSERT INTO `captcha_answers` VALUES (17, 1, 17, 'false');
INSERT INTO `captcha_answers` VALUES (18, 1, 19, 'false');
INSERT INTO `captcha_answers` VALUES (19, 1, 20, 'false');
INSERT INTO `captcha_answers` VALUES (20, 1, 21, 'false');
INSERT INTO `captcha_answers` VALUES (21, 1, 22, 'false');
INSERT INTO `captcha_answers` VALUES (254, 1, 31, 'false');
INSERT INTO `captcha_answers` VALUES (23, 1, 24, 'false');
INSERT INTO `captcha_answers` VALUES (24, 1, 25, 'false');
INSERT INTO `captcha_answers` VALUES (25, 1, 26, 'false');
INSERT INTO `captcha_answers` VALUES (26, 1, 27, 'false');
INSERT INTO `captcha_answers` VALUES (27, 1, 28, 'false');
INSERT INTO `captcha_answers` VALUES (28, 1, 29, 'false');
INSERT INTO `captcha_answers` VALUES (29, 1, 30, 'false');
INSERT INTO `captcha_answers` VALUES (30, 2, 1, 'true');
INSERT INTO `captcha_answers` VALUES (31, 2, 2, 'false');
INSERT INTO `captcha_answers` VALUES (32, 2, 3, 'true');
INSERT INTO `captcha_answers` VALUES (33, 2, 4, 'false');
INSERT INTO `captcha_answers` VALUES (34, 2, 5, 'false');
INSERT INTO `captcha_answers` VALUES (35, 2, 6, 'false');
INSERT INTO `captcha_answers` VALUES (36, 2, 7, 'false');
INSERT INTO `captcha_answers` VALUES (37, 2, 8, 'false');
INSERT INTO `captcha_answers` VALUES (38, 2, 9, 'false');
INSERT INTO `captcha_answers` VALUES (39, 2, 11, 'false');
INSERT INTO `captcha_answers` VALUES (40, 2, 12, 'false');
INSERT INTO `captcha_answers` VALUES (41, 2, 13, 'false');
INSERT INTO `captcha_answers` VALUES (42, 2, 14, 'true');
INSERT INTO `captcha_answers` VALUES (43, 2, 15, 'true');
INSERT INTO `captcha_answers` VALUES (44, 2, 16, 'false');
INSERT INTO `captcha_answers` VALUES (45, 2, 17, 'true');
INSERT INTO `captcha_answers` VALUES (46, 2, 18, 'false');
INSERT INTO `captcha_answers` VALUES (47, 2, 19, 'false');
INSERT INTO `captcha_answers` VALUES (48, 2, 20, 'false');
INSERT INTO `captcha_answers` VALUES (49, 2, 21, 'false');
INSERT INTO `captcha_answers` VALUES (50, 2, 22, 'false');
INSERT INTO `captcha_answers` VALUES (51, 2, 23, 'false');
INSERT INTO `captcha_answers` VALUES (52, 2, 24, 'true');
INSERT INTO `captcha_answers` VALUES (53, 2, 25, 'false');
INSERT INTO `captcha_answers` VALUES (54, 2, 26, 'false');
INSERT INTO `captcha_answers` VALUES (55, 2, 27, 'false');
INSERT INTO `captcha_answers` VALUES (56, 2, 28, 'false');
INSERT INTO `captcha_answers` VALUES (57, 2, 29, 'false');
INSERT INTO `captcha_answers` VALUES (58, 2, 30, 'true');
INSERT INTO `captcha_answers` VALUES (59, 3, 1, 'false');
INSERT INTO `captcha_answers` VALUES (60, 3, 2, 'false');
INSERT INTO `captcha_answers` VALUES (61, 3, 4, 'false');
INSERT INTO `captcha_answers` VALUES (62, 3, 5, 'false');
INSERT INTO `captcha_answers` VALUES (63, 3, 7, 'false');
INSERT INTO `captcha_answers` VALUES (64, 3, 8, 'false');
INSERT INTO `captcha_answers` VALUES (65, 3, 10, 'false');
INSERT INTO `captcha_answers` VALUES (66, 3, 11, 'false');
INSERT INTO `captcha_answers` VALUES (67, 3, 12, 'true');
INSERT INTO `captcha_answers` VALUES (68, 3, 14, 'false');
INSERT INTO `captcha_answers` VALUES (69, 3, 15, 'false');
INSERT INTO `captcha_answers` VALUES (70, 3, 16, 'false');
INSERT INTO `captcha_answers` VALUES (71, 3, 17, 'false');
INSERT INTO `captcha_answers` VALUES (72, 3, 19, 'false');
INSERT INTO `captcha_answers` VALUES (73, 3, 20, 'false');
INSERT INTO `captcha_answers` VALUES (74, 3, 21, 'true');
INSERT INTO `captcha_answers` VALUES (75, 3, 22, 'false');
INSERT INTO `captcha_answers` VALUES (76, 3, 23, 'false');
INSERT INTO `captcha_answers` VALUES (77, 3, 24, 'false');
INSERT INTO `captcha_answers` VALUES (78, 3, 25, 'false');
INSERT INTO `captcha_answers` VALUES (79, 3, 26, 'false');
INSERT INTO `captcha_answers` VALUES (80, 3, 27, 'false');
INSERT INTO `captcha_answers` VALUES (81, 3, 28, 'true');
INSERT INTO `captcha_answers` VALUES (82, 3, 29, 'false');
INSERT INTO `captcha_answers` VALUES (83, 3, 30, 'false');
INSERT INTO `captcha_answers` VALUES (84, 4, 1, 'false');
INSERT INTO `captcha_answers` VALUES (85, 4, 2, 'false');
INSERT INTO `captcha_answers` VALUES (86, 4, 3, 'false');
INSERT INTO `captcha_answers` VALUES (87, 4, 4, 'false');
INSERT INTO `captcha_answers` VALUES (88, 4, 5, 'false');
INSERT INTO `captcha_answers` VALUES (89, 4, 6, 'false');
INSERT INTO `captcha_answers` VALUES (90, 4, 7, 'false');
INSERT INTO `captcha_answers` VALUES (91, 4, 8, 'false');
INSERT INTO `captcha_answers` VALUES (92, 4, 9, 'false');
INSERT INTO `captcha_answers` VALUES (93, 4, 10, 'false');
INSERT INTO `captcha_answers` VALUES (94, 4, 11, 'false');
INSERT INTO `captcha_answers` VALUES (95, 4, 12, 'false');
INSERT INTO `captcha_answers` VALUES (96, 4, 13, 'false');
INSERT INTO `captcha_answers` VALUES (97, 4, 14, 'false');
INSERT INTO `captcha_answers` VALUES (98, 4, 15, 'false');
INSERT INTO `captcha_answers` VALUES (99, 4, 16, 'false');
INSERT INTO `captcha_answers` VALUES (100, 4, 17, 'false');
INSERT INTO `captcha_answers` VALUES (101, 4, 18, 'false');
INSERT INTO `captcha_answers` VALUES (102, 4, 19, 'false');
INSERT INTO `captcha_answers` VALUES (103, 4, 20, 'false');
INSERT INTO `captcha_answers` VALUES (104, 4, 21, 'false');
INSERT INTO `captcha_answers` VALUES (105, 4, 22, 'false');
INSERT INTO `captcha_answers` VALUES (106, 4, 23, 'false');
INSERT INTO `captcha_answers` VALUES (107, 4, 24, 'false');
INSERT INTO `captcha_answers` VALUES (108, 4, 25, 'false');
INSERT INTO `captcha_answers` VALUES (109, 4, 26, 'false');
INSERT INTO `captcha_answers` VALUES (110, 4, 27, 'false');
INSERT INTO `captcha_answers` VALUES (111, 4, 28, 'false');
INSERT INTO `captcha_answers` VALUES (112, 4, 29, 'false');
INSERT INTO `captcha_answers` VALUES (113, 4, 30, 'false');
INSERT INTO `captcha_answers` VALUES (114, 5, 1, 'false');
INSERT INTO `captcha_answers` VALUES (115, 5, 2, 'false');
INSERT INTO `captcha_answers` VALUES (116, 5, 3, 'false');
INSERT INTO `captcha_answers` VALUES (117, 5, 4, 'true');
INSERT INTO `captcha_answers` VALUES (118, 5, 5, 'true');
INSERT INTO `captcha_answers` VALUES (119, 5, 6, 'true');
INSERT INTO `captcha_answers` VALUES (120, 5, 7, 'true');
INSERT INTO `captcha_answers` VALUES (121, 5, 8, 'false');
INSERT INTO `captcha_answers` VALUES (122, 5, 9, 'true');
INSERT INTO `captcha_answers` VALUES (123, 5, 10, 'false');
INSERT INTO `captcha_answers` VALUES (124, 5, 12, 'true');
INSERT INTO `captcha_answers` VALUES (125, 5, 13, 'true');
INSERT INTO `captcha_answers` VALUES (126, 5, 14, 'false');
INSERT INTO `captcha_answers` VALUES (127, 5, 15, 'false');
INSERT INTO `captcha_answers` VALUES (128, 5, 17, 'false');
INSERT INTO `captcha_answers` VALUES (129, 5, 18, 'true');
INSERT INTO `captcha_answers` VALUES (130, 5, 19, 'true');
INSERT INTO `captcha_answers` VALUES (131, 5, 20, 'true');
INSERT INTO `captcha_answers` VALUES (132, 5, 21, 'true');
INSERT INTO `captcha_answers` VALUES (133, 5, 22, 'false');
INSERT INTO `captcha_answers` VALUES (134, 5, 23, 'true');
INSERT INTO `captcha_answers` VALUES (135, 5, 24, 'false');
INSERT INTO `captcha_answers` VALUES (136, 5, 25, 'false');
INSERT INTO `captcha_answers` VALUES (137, 5, 27, 'false');
INSERT INTO `captcha_answers` VALUES (138, 5, 28, 'true');
INSERT INTO `captcha_answers` VALUES (139, 5, 29, 'true');
INSERT INTO `captcha_answers` VALUES (140, 5, 30, 'false');
INSERT INTO `captcha_answers` VALUES (141, 6, 1, 'false');
INSERT INTO `captcha_answers` VALUES (142, 6, 2, 'true');
INSERT INTO `captcha_answers` VALUES (143, 6, 3, 'false');
INSERT INTO `captcha_answers` VALUES (144, 6, 4, 'false');
INSERT INTO `captcha_answers` VALUES (145, 6, 5, 'false');
INSERT INTO `captcha_answers` VALUES (146, 6, 6, 'false');
INSERT INTO `captcha_answers` VALUES (147, 6, 7, 'false');
INSERT INTO `captcha_answers` VALUES (148, 6, 8, 'false');
INSERT INTO `captcha_answers` VALUES (149, 6, 9, 'false');
INSERT INTO `captcha_answers` VALUES (150, 6, 10, 'false');
INSERT INTO `captcha_answers` VALUES (151, 6, 11, 'false');
INSERT INTO `captcha_answers` VALUES (152, 6, 12, 'false');
INSERT INTO `captcha_answers` VALUES (153, 6, 13, 'false');
INSERT INTO `captcha_answers` VALUES (154, 6, 14, 'false');
INSERT INTO `captcha_answers` VALUES (155, 6, 15, 'false');
INSERT INTO `captcha_answers` VALUES (156, 6, 16, 'true');
INSERT INTO `captcha_answers` VALUES (157, 6, 17, 'false');
INSERT INTO `captcha_answers` VALUES (158, 6, 18, 'false');
INSERT INTO `captcha_answers` VALUES (159, 6, 19, 'false');
INSERT INTO `captcha_answers` VALUES (160, 6, 20, 'false');
INSERT INTO `captcha_answers` VALUES (161, 6, 21, 'false');
INSERT INTO `captcha_answers` VALUES (162, 6, 22, 'true');
INSERT INTO `captcha_answers` VALUES (163, 6, 23, 'false');
INSERT INTO `captcha_answers` VALUES (164, 6, 24, 'false');
INSERT INTO `captcha_answers` VALUES (165, 6, 25, 'false');
INSERT INTO `captcha_answers` VALUES (166, 6, 26, 'false');
INSERT INTO `captcha_answers` VALUES (167, 6, 27, 'false');
INSERT INTO `captcha_answers` VALUES (168, 6, 28, 'false');
INSERT INTO `captcha_answers` VALUES (169, 6, 29, 'false');
INSERT INTO `captcha_answers` VALUES (170, 6, 30, 'true');
INSERT INTO `captcha_answers` VALUES (171, 7, 1, 'false');
INSERT INTO `captcha_answers` VALUES (172, 7, 2, 'false');
INSERT INTO `captcha_answers` VALUES (173, 7, 3, 'false');
INSERT INTO `captcha_answers` VALUES (174, 7, 4, 'true');
INSERT INTO `captcha_answers` VALUES (175, 7, 5, 'false');
INSERT INTO `captcha_answers` VALUES (176, 7, 6, 'false');
INSERT INTO `captcha_answers` VALUES (177, 7, 7, 'false');
INSERT INTO `captcha_answers` VALUES (178, 7, 8, 'false');
INSERT INTO `captcha_answers` VALUES (179, 7, 9, 'false');
INSERT INTO `captcha_answers` VALUES (180, 7, 10, 'false');
INSERT INTO `captcha_answers` VALUES (181, 7, 11, 'false');
INSERT INTO `captcha_answers` VALUES (182, 7, 12, 'false');
INSERT INTO `captcha_answers` VALUES (183, 7, 13, 'false');
INSERT INTO `captcha_answers` VALUES (184, 7, 14, 'false');
INSERT INTO `captcha_answers` VALUES (185, 7, 15, 'false');
INSERT INTO `captcha_answers` VALUES (186, 7, 16, 'false');
INSERT INTO `captcha_answers` VALUES (187, 7, 17, 'false');
INSERT INTO `captcha_answers` VALUES (188, 7, 18, 'false');
INSERT INTO `captcha_answers` VALUES (189, 7, 19, 'true');
INSERT INTO `captcha_answers` VALUES (190, 7, 20, 'true');
INSERT INTO `captcha_answers` VALUES (191, 7, 21, 'false');
INSERT INTO `captcha_answers` VALUES (192, 7, 22, 'false');
INSERT INTO `captcha_answers` VALUES (193, 7, 23, 'false');
INSERT INTO `captcha_answers` VALUES (194, 7, 24, 'false');
INSERT INTO `captcha_answers` VALUES (195, 7, 25, 'false');
INSERT INTO `captcha_answers` VALUES (196, 7, 28, 'false');
INSERT INTO `captcha_answers` VALUES (197, 7, 29, 'true');
INSERT INTO `captcha_answers` VALUES (198, 7, 30, 'false');
INSERT INTO `captcha_answers` VALUES (199, 8, 3, 'false');
INSERT INTO `captcha_answers` VALUES (200, 8, 4, 'false');
INSERT INTO `captcha_answers` VALUES (201, 8, 5, 'false');
INSERT INTO `captcha_answers` VALUES (202, 8, 6, 'false');
INSERT INTO `captcha_answers` VALUES (203, 8, 7, 'false');
INSERT INTO `captcha_answers` VALUES (204, 8, 8, 'true');
INSERT INTO `captcha_answers` VALUES (205, 8, 9, 'false');
INSERT INTO `captcha_answers` VALUES (206, 8, 10, 'false');
INSERT INTO `captcha_answers` VALUES (207, 8, 11, 'true');
INSERT INTO `captcha_answers` VALUES (208, 8, 12, 'false');
INSERT INTO `captcha_answers` VALUES (209, 8, 13, 'false');
INSERT INTO `captcha_answers` VALUES (210, 8, 14, 'false');
INSERT INTO `captcha_answers` VALUES (211, 8, 15, 'false');
INSERT INTO `captcha_answers` VALUES (212, 8, 16, 'true');
INSERT INTO `captcha_answers` VALUES (213, 8, 17, 'false');
INSERT INTO `captcha_answers` VALUES (214, 8, 18, 'false');
INSERT INTO `captcha_answers` VALUES (215, 8, 19, 'false');
INSERT INTO `captcha_answers` VALUES (216, 8, 20, 'false');
INSERT INTO `captcha_answers` VALUES (217, 8, 21, 'false');
INSERT INTO `captcha_answers` VALUES (218, 8, 22, 'false');
INSERT INTO `captcha_answers` VALUES (219, 8, 23, 'false');
INSERT INTO `captcha_answers` VALUES (220, 8, 24, 'false');
INSERT INTO `captcha_answers` VALUES (221, 8, 25, 'false');
INSERT INTO `captcha_answers` VALUES (222, 8, 26, 'false');
INSERT INTO `captcha_answers` VALUES (223, 8, 27, 'false');
INSERT INTO `captcha_answers` VALUES (224, 8, 28, 'false');
INSERT INTO `captcha_answers` VALUES (225, 8, 29, 'false');
INSERT INTO `captcha_answers` VALUES (226, 8, 30, 'false');
INSERT INTO `captcha_answers` VALUES (227, 9, 1, 'false');
INSERT INTO `captcha_answers` VALUES (228, 9, 2, 'true');
INSERT INTO `captcha_answers` VALUES (229, 9, 3, 'false');
INSERT INTO `captcha_answers` VALUES (230, 9, 4, 'true');
INSERT INTO `captcha_answers` VALUES (231, 9, 5, 'true');
INSERT INTO `captcha_answers` VALUES (232, 9, 6, 'true');
INSERT INTO `captcha_answers` VALUES (233, 9, 7, 'true');
INSERT INTO `captcha_answers` VALUES (234, 9, 8, 'true');
INSERT INTO `captcha_answers` VALUES (235, 9, 9, 'true');
INSERT INTO `captcha_answers` VALUES (236, 9, 11, 'true');
INSERT INTO `captcha_answers` VALUES (237, 9, 12, 'true');
INSERT INTO `captcha_answers` VALUES (238, 9, 13, 'true');
INSERT INTO `captcha_answers` VALUES (239, 9, 14, 'false');
INSERT INTO `captcha_answers` VALUES (240, 9, 15, 'false');
INSERT INTO `captcha_answers` VALUES (241, 9, 16, 'true');
INSERT INTO `captcha_answers` VALUES (242, 9, 17, 'false');
INSERT INTO `captcha_answers` VALUES (243, 9, 18, 'true');
INSERT INTO `captcha_answers` VALUES (244, 9, 19, 'true');
INSERT INTO `captcha_answers` VALUES (245, 9, 20, 'true');
INSERT INTO `captcha_answers` VALUES (246, 9, 21, 'true');
INSERT INTO `captcha_answers` VALUES (247, 9, 23, 'false');
INSERT INTO `captcha_answers` VALUES (248, 9, 24, 'true');
INSERT INTO `captcha_answers` VALUES (249, 9, 25, 'true');
INSERT INTO `captcha_answers` VALUES (250, 9, 26, 'true');
INSERT INTO `captcha_answers` VALUES (251, 9, 28, 'true');
INSERT INTO `captcha_answers` VALUES (252, 9, 29, 'true');
INSERT INTO `captcha_answers` VALUES (253, 9, 30, 'false');
INSERT INTO `captcha_answers` VALUES (255, 2, 31, 'false');
INSERT INTO `captcha_answers` VALUES (256, 3, 31, 'false');
INSERT INTO `captcha_answers` VALUES (257, 4, 31, 'true');
INSERT INTO `captcha_answers` VALUES (258, 6, 31, 'false');
INSERT INTO `captcha_answers` VALUES (259, 7, 31, 'false');
INSERT INTO `captcha_answers` VALUES (260, 8, 31, 'false');
INSERT INTO `captcha_answers` VALUES (261, 9, 31, 'true');
INSERT INTO `captcha_answers` VALUES (262, 1, 32, 'false');
INSERT INTO `captcha_answers` VALUES (263, 2, 32, 'false');
INSERT INTO `captcha_answers` VALUES (264, 3, 32, 'false');
INSERT INTO `captcha_answers` VALUES (265, 4, 32, 'true');
INSERT INTO `captcha_answers` VALUES (266, 5, 32, 'true');
INSERT INTO `captcha_answers` VALUES (267, 6, 32, 'false');
INSERT INTO `captcha_answers` VALUES (268, 8, 32, 'false');
INSERT INTO `captcha_answers` VALUES (269, 9, 32, 'true');
INSERT INTO `captcha_answers` VALUES (270, 1, 33, 'false');
INSERT INTO `captcha_answers` VALUES (271, 2, 33, 'true');
INSERT INTO `captcha_answers` VALUES (272, 3, 33, 'false');
INSERT INTO `captcha_answers` VALUES (273, 4, 33, 'true');
INSERT INTO `captcha_answers` VALUES (274, 5, 33, 'false');
INSERT INTO `captcha_answers` VALUES (275, 6, 33, 'false');
INSERT INTO `captcha_answers` VALUES (276, 7, 33, 'false');
INSERT INTO `captcha_answers` VALUES (277, 8, 33, 'false');
INSERT INTO `captcha_answers` VALUES (278, 9, 33, 'false');
INSERT INTO `captcha_answers` VALUES (279, 1, 34, 'false');
INSERT INTO `captcha_answers` VALUES (280, 2, 34, 'true');
INSERT INTO `captcha_answers` VALUES (281, 3, 34, 'false');
INSERT INTO `captcha_answers` VALUES (282, 4, 34, 'true');
INSERT INTO `captcha_answers` VALUES (283, 5, 34, 'true');
INSERT INTO `captcha_answers` VALUES (284, 6, 34, 'false');
INSERT INTO `captcha_answers` VALUES (285, 8, 34, 'false');
INSERT INTO `captcha_answers` VALUES (286, 9, 34, 'true');
CREATE TABLE `captcha_images` (
`id` int(10) unsigned NOT NULL auto_increment,
`file` varchar(255) NOT NULL default '',
`description` text,
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_images` VALUES (1, 'arend.png', 'Arend');
INSERT INTO `captcha_images` VALUES (2, 'dolfijn.png', 'Dolfijn');
INSERT INTO `captcha_images` VALUES (3, 'duif.png', 'Duif');
INSERT INTO `captcha_images` VALUES (4, 'giraffe.png', 'Giraffe');
INSERT INTO `captcha_images` VALUES (5, 'hert.png', 'Hert');
INSERT INTO `captcha_images` VALUES (6, 'hond.png', 'Hond');
INSERT INTO `captcha_images` VALUES (7, 'kameel.png', 'Kameel');
INSERT INTO `captcha_images` VALUES (8, 'kangeroo.png', 'Kangeroo');
INSERT INTO `captcha_images` VALUES (9, 'kat.png', 'Kat');
INSERT INTO `captcha_images` VALUES (10, 'kip.png', 'Kip');
INSERT INTO `captcha_images` VALUES (11, 'koala.png', 'Koala');
INSERT INTO `captcha_images` VALUES (12, 'koe.png', 'Koe');
INSERT INTO `captcha_images` VALUES (13, 'konijn.png', 'Konijn');
INSERT INTO `captcha_images` VALUES (14, 'koolmees.png', 'Koolmees');
INSERT INTO `captcha_images` VALUES (15, 'kraai.png', 'Kraai');
INSERT INTO `captcha_images` VALUES (16, 'krokodil.png', 'Krokodil');
INSERT INTO `captcha_images` VALUES (17, 'merel.png', 'Merel');
INSERT INTO `captcha_images` VALUES (18, 'muis.png', 'Muis');
INSERT INTO `captcha_images` VALUES (19, 'neushoorn.png', 'Neushoorn');
INSERT INTO `captcha_images` VALUES (20, 'olifant.png', 'Olifant');
INSERT INTO `captcha_images` VALUES (21, 'paard.png', 'Paard');
INSERT INTO `captcha_images` VALUES (22, 'pinguin.png', 'Pinguin');
INSERT INTO `captcha_images` VALUES (23, 'rat.png', 'Rat');
INSERT INTO `captcha_images` VALUES (24, 'roodborstje.png', 'Roodborstje');
INSERT INTO `captcha_images` VALUES (25, 'scarabee.png', 'Scarabee');
INSERT INTO `captcha_images` VALUES (26, 'stokstaartje.png', 'Stokstaartje');
INSERT INTO `captcha_images` VALUES (27, 'struisvogel.png', 'Struisvogel');
INSERT INTO `captcha_images` VALUES (28, 'varken.png', 'Varken');
INSERT INTO `captcha_images` VALUES (29, 'zebra.png', 'Zebra');
INSERT INTO `captcha_images` VALUES (30, 'zwaan.png', 'Zwaan');
INSERT INTO `captcha_images` VALUES (31, 'aap.png', 'Aap');
INSERT INTO `captcha_images` VALUES (32, 'panter.png', 'Panter');
INSERT INTO `captcha_images` VALUES (33, 'papegaai.png', 'Papegaai');
INSERT INTO `captcha_images` VALUES (34, 'tijger.png', 'Tijger');
CREATE TABLE `captcha_questions` (
`id` int(10) unsigned NOT NULL auto_increment,
`theme` int(10) unsigned NOT NULL default '0',
`lable` text NOT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_questions` VALUES (1, 1, 'Welke dieren worden in nederland als vaak als huisdier gehouden.');
INSERT INTO `captcha_questions` VALUES (2, 1, 'Welke dieren kunnen vliegen?');
INSERT INTO `captcha_questions` VALUES (3, 1, 'Welke dieren vind je vaak op de boerderij.');
INSERT INTO `captcha_questions` VALUES (4, 1, 'Welke dieren leven in het oerwoud?');
INSERT INTO `captcha_questions` VALUES (5, 1, 'Welke dieren lopen op 4 poten/benen?');
INSERT INTO `captcha_questions` VALUES (6, 1, 'Welke dieren leven op of in het water?');
INSERT INTO `captcha_questions` VALUES (7, 1, 'Welke dieren leven op de savanne in Afrika?');
INSERT INTO `captcha_questions` VALUES (8, 1, 'Welke dieren leven (met nadruk) in Australie?');
INSERT INTO `captcha_questions` VALUES (9, 1, 'Welke dieren kunnen niet vliegen?');
CREATE TABLE `captcha_themes` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_themes` VALUES (1, 'Dieren');
`id` int(10) unsigned NOT NULL auto_increment,
`question` int(10) unsigned NOT NULL default '0',
`image` int(10) unsigned NOT NULL default '0',
`value` varchar(5) NOT NULL default 'false',
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_answers` VALUES (1, 1, 1, 'false');
INSERT INTO `captcha_answers` VALUES (2, 1, 2, 'false');
INSERT INTO `captcha_answers` VALUES (3, 1, 3, 'false');
INSERT INTO `captcha_answers` VALUES (4, 1, 4, 'false');
INSERT INTO `captcha_answers` VALUES (5, 1, 5, 'false');
INSERT INTO `captcha_answers` VALUES (6, 1, 6, 'true');
INSERT INTO `captcha_answers` VALUES (7, 1, 7, 'false');
INSERT INTO `captcha_answers` VALUES (8, 1, 8, 'false');
INSERT INTO `captcha_answers` VALUES (9, 1, 9, 'true');
INSERT INTO `captcha_answers` VALUES (10, 1, 10, 'false');
INSERT INTO `captcha_answers` VALUES (11, 1, 11, 'false');
INSERT INTO `captcha_answers` VALUES (12, 1, 12, 'false');
INSERT INTO `captcha_answers` VALUES (13, 1, 13, 'true');
INSERT INTO `captcha_answers` VALUES (14, 1, 14, 'false');
INSERT INTO `captcha_answers` VALUES (15, 1, 15, 'false');
INSERT INTO `captcha_answers` VALUES (16, 1, 16, 'false');
INSERT INTO `captcha_answers` VALUES (17, 1, 17, 'false');
INSERT INTO `captcha_answers` VALUES (18, 1, 19, 'false');
INSERT INTO `captcha_answers` VALUES (19, 1, 20, 'false');
INSERT INTO `captcha_answers` VALUES (20, 1, 21, 'false');
INSERT INTO `captcha_answers` VALUES (21, 1, 22, 'false');
INSERT INTO `captcha_answers` VALUES (254, 1, 31, 'false');
INSERT INTO `captcha_answers` VALUES (23, 1, 24, 'false');
INSERT INTO `captcha_answers` VALUES (24, 1, 25, 'false');
INSERT INTO `captcha_answers` VALUES (25, 1, 26, 'false');
INSERT INTO `captcha_answers` VALUES (26, 1, 27, 'false');
INSERT INTO `captcha_answers` VALUES (27, 1, 28, 'false');
INSERT INTO `captcha_answers` VALUES (28, 1, 29, 'false');
INSERT INTO `captcha_answers` VALUES (29, 1, 30, 'false');
INSERT INTO `captcha_answers` VALUES (30, 2, 1, 'true');
INSERT INTO `captcha_answers` VALUES (31, 2, 2, 'false');
INSERT INTO `captcha_answers` VALUES (32, 2, 3, 'true');
INSERT INTO `captcha_answers` VALUES (33, 2, 4, 'false');
INSERT INTO `captcha_answers` VALUES (34, 2, 5, 'false');
INSERT INTO `captcha_answers` VALUES (35, 2, 6, 'false');
INSERT INTO `captcha_answers` VALUES (36, 2, 7, 'false');
INSERT INTO `captcha_answers` VALUES (37, 2, 8, 'false');
INSERT INTO `captcha_answers` VALUES (38, 2, 9, 'false');
INSERT INTO `captcha_answers` VALUES (39, 2, 11, 'false');
INSERT INTO `captcha_answers` VALUES (40, 2, 12, 'false');
INSERT INTO `captcha_answers` VALUES (41, 2, 13, 'false');
INSERT INTO `captcha_answers` VALUES (42, 2, 14, 'true');
INSERT INTO `captcha_answers` VALUES (43, 2, 15, 'true');
INSERT INTO `captcha_answers` VALUES (44, 2, 16, 'false');
INSERT INTO `captcha_answers` VALUES (45, 2, 17, 'true');
INSERT INTO `captcha_answers` VALUES (46, 2, 18, 'false');
INSERT INTO `captcha_answers` VALUES (47, 2, 19, 'false');
INSERT INTO `captcha_answers` VALUES (48, 2, 20, 'false');
INSERT INTO `captcha_answers` VALUES (49, 2, 21, 'false');
INSERT INTO `captcha_answers` VALUES (50, 2, 22, 'false');
INSERT INTO `captcha_answers` VALUES (51, 2, 23, 'false');
INSERT INTO `captcha_answers` VALUES (52, 2, 24, 'true');
INSERT INTO `captcha_answers` VALUES (53, 2, 25, 'false');
INSERT INTO `captcha_answers` VALUES (54, 2, 26, 'false');
INSERT INTO `captcha_answers` VALUES (55, 2, 27, 'false');
INSERT INTO `captcha_answers` VALUES (56, 2, 28, 'false');
INSERT INTO `captcha_answers` VALUES (57, 2, 29, 'false');
INSERT INTO `captcha_answers` VALUES (58, 2, 30, 'true');
INSERT INTO `captcha_answers` VALUES (59, 3, 1, 'false');
INSERT INTO `captcha_answers` VALUES (60, 3, 2, 'false');
INSERT INTO `captcha_answers` VALUES (61, 3, 4, 'false');
INSERT INTO `captcha_answers` VALUES (62, 3, 5, 'false');
INSERT INTO `captcha_answers` VALUES (63, 3, 7, 'false');
INSERT INTO `captcha_answers` VALUES (64, 3, 8, 'false');
INSERT INTO `captcha_answers` VALUES (65, 3, 10, 'false');
INSERT INTO `captcha_answers` VALUES (66, 3, 11, 'false');
INSERT INTO `captcha_answers` VALUES (67, 3, 12, 'true');
INSERT INTO `captcha_answers` VALUES (68, 3, 14, 'false');
INSERT INTO `captcha_answers` VALUES (69, 3, 15, 'false');
INSERT INTO `captcha_answers` VALUES (70, 3, 16, 'false');
INSERT INTO `captcha_answers` VALUES (71, 3, 17, 'false');
INSERT INTO `captcha_answers` VALUES (72, 3, 19, 'false');
INSERT INTO `captcha_answers` VALUES (73, 3, 20, 'false');
INSERT INTO `captcha_answers` VALUES (74, 3, 21, 'true');
INSERT INTO `captcha_answers` VALUES (75, 3, 22, 'false');
INSERT INTO `captcha_answers` VALUES (76, 3, 23, 'false');
INSERT INTO `captcha_answers` VALUES (77, 3, 24, 'false');
INSERT INTO `captcha_answers` VALUES (78, 3, 25, 'false');
INSERT INTO `captcha_answers` VALUES (79, 3, 26, 'false');
INSERT INTO `captcha_answers` VALUES (80, 3, 27, 'false');
INSERT INTO `captcha_answers` VALUES (81, 3, 28, 'true');
INSERT INTO `captcha_answers` VALUES (82, 3, 29, 'false');
INSERT INTO `captcha_answers` VALUES (83, 3, 30, 'false');
INSERT INTO `captcha_answers` VALUES (84, 4, 1, 'false');
INSERT INTO `captcha_answers` VALUES (85, 4, 2, 'false');
INSERT INTO `captcha_answers` VALUES (86, 4, 3, 'false');
INSERT INTO `captcha_answers` VALUES (87, 4, 4, 'false');
INSERT INTO `captcha_answers` VALUES (88, 4, 5, 'false');
INSERT INTO `captcha_answers` VALUES (89, 4, 6, 'false');
INSERT INTO `captcha_answers` VALUES (90, 4, 7, 'false');
INSERT INTO `captcha_answers` VALUES (91, 4, 8, 'false');
INSERT INTO `captcha_answers` VALUES (92, 4, 9, 'false');
INSERT INTO `captcha_answers` VALUES (93, 4, 10, 'false');
INSERT INTO `captcha_answers` VALUES (94, 4, 11, 'false');
INSERT INTO `captcha_answers` VALUES (95, 4, 12, 'false');
INSERT INTO `captcha_answers` VALUES (96, 4, 13, 'false');
INSERT INTO `captcha_answers` VALUES (97, 4, 14, 'false');
INSERT INTO `captcha_answers` VALUES (98, 4, 15, 'false');
INSERT INTO `captcha_answers` VALUES (99, 4, 16, 'false');
INSERT INTO `captcha_answers` VALUES (100, 4, 17, 'false');
INSERT INTO `captcha_answers` VALUES (101, 4, 18, 'false');
INSERT INTO `captcha_answers` VALUES (102, 4, 19, 'false');
INSERT INTO `captcha_answers` VALUES (103, 4, 20, 'false');
INSERT INTO `captcha_answers` VALUES (104, 4, 21, 'false');
INSERT INTO `captcha_answers` VALUES (105, 4, 22, 'false');
INSERT INTO `captcha_answers` VALUES (106, 4, 23, 'false');
INSERT INTO `captcha_answers` VALUES (107, 4, 24, 'false');
INSERT INTO `captcha_answers` VALUES (108, 4, 25, 'false');
INSERT INTO `captcha_answers` VALUES (109, 4, 26, 'false');
INSERT INTO `captcha_answers` VALUES (110, 4, 27, 'false');
INSERT INTO `captcha_answers` VALUES (111, 4, 28, 'false');
INSERT INTO `captcha_answers` VALUES (112, 4, 29, 'false');
INSERT INTO `captcha_answers` VALUES (113, 4, 30, 'false');
INSERT INTO `captcha_answers` VALUES (114, 5, 1, 'false');
INSERT INTO `captcha_answers` VALUES (115, 5, 2, 'false');
INSERT INTO `captcha_answers` VALUES (116, 5, 3, 'false');
INSERT INTO `captcha_answers` VALUES (117, 5, 4, 'true');
INSERT INTO `captcha_answers` VALUES (118, 5, 5, 'true');
INSERT INTO `captcha_answers` VALUES (119, 5, 6, 'true');
INSERT INTO `captcha_answers` VALUES (120, 5, 7, 'true');
INSERT INTO `captcha_answers` VALUES (121, 5, 8, 'false');
INSERT INTO `captcha_answers` VALUES (122, 5, 9, 'true');
INSERT INTO `captcha_answers` VALUES (123, 5, 10, 'false');
INSERT INTO `captcha_answers` VALUES (124, 5, 12, 'true');
INSERT INTO `captcha_answers` VALUES (125, 5, 13, 'true');
INSERT INTO `captcha_answers` VALUES (126, 5, 14, 'false');
INSERT INTO `captcha_answers` VALUES (127, 5, 15, 'false');
INSERT INTO `captcha_answers` VALUES (128, 5, 17, 'false');
INSERT INTO `captcha_answers` VALUES (129, 5, 18, 'true');
INSERT INTO `captcha_answers` VALUES (130, 5, 19, 'true');
INSERT INTO `captcha_answers` VALUES (131, 5, 20, 'true');
INSERT INTO `captcha_answers` VALUES (132, 5, 21, 'true');
INSERT INTO `captcha_answers` VALUES (133, 5, 22, 'false');
INSERT INTO `captcha_answers` VALUES (134, 5, 23, 'true');
INSERT INTO `captcha_answers` VALUES (135, 5, 24, 'false');
INSERT INTO `captcha_answers` VALUES (136, 5, 25, 'false');
INSERT INTO `captcha_answers` VALUES (137, 5, 27, 'false');
INSERT INTO `captcha_answers` VALUES (138, 5, 28, 'true');
INSERT INTO `captcha_answers` VALUES (139, 5, 29, 'true');
INSERT INTO `captcha_answers` VALUES (140, 5, 30, 'false');
INSERT INTO `captcha_answers` VALUES (141, 6, 1, 'false');
INSERT INTO `captcha_answers` VALUES (142, 6, 2, 'true');
INSERT INTO `captcha_answers` VALUES (143, 6, 3, 'false');
INSERT INTO `captcha_answers` VALUES (144, 6, 4, 'false');
INSERT INTO `captcha_answers` VALUES (145, 6, 5, 'false');
INSERT INTO `captcha_answers` VALUES (146, 6, 6, 'false');
INSERT INTO `captcha_answers` VALUES (147, 6, 7, 'false');
INSERT INTO `captcha_answers` VALUES (148, 6, 8, 'false');
INSERT INTO `captcha_answers` VALUES (149, 6, 9, 'false');
INSERT INTO `captcha_answers` VALUES (150, 6, 10, 'false');
INSERT INTO `captcha_answers` VALUES (151, 6, 11, 'false');
INSERT INTO `captcha_answers` VALUES (152, 6, 12, 'false');
INSERT INTO `captcha_answers` VALUES (153, 6, 13, 'false');
INSERT INTO `captcha_answers` VALUES (154, 6, 14, 'false');
INSERT INTO `captcha_answers` VALUES (155, 6, 15, 'false');
INSERT INTO `captcha_answers` VALUES (156, 6, 16, 'true');
INSERT INTO `captcha_answers` VALUES (157, 6, 17, 'false');
INSERT INTO `captcha_answers` VALUES (158, 6, 18, 'false');
INSERT INTO `captcha_answers` VALUES (159, 6, 19, 'false');
INSERT INTO `captcha_answers` VALUES (160, 6, 20, 'false');
INSERT INTO `captcha_answers` VALUES (161, 6, 21, 'false');
INSERT INTO `captcha_answers` VALUES (162, 6, 22, 'true');
INSERT INTO `captcha_answers` VALUES (163, 6, 23, 'false');
INSERT INTO `captcha_answers` VALUES (164, 6, 24, 'false');
INSERT INTO `captcha_answers` VALUES (165, 6, 25, 'false');
INSERT INTO `captcha_answers` VALUES (166, 6, 26, 'false');
INSERT INTO `captcha_answers` VALUES (167, 6, 27, 'false');
INSERT INTO `captcha_answers` VALUES (168, 6, 28, 'false');
INSERT INTO `captcha_answers` VALUES (169, 6, 29, 'false');
INSERT INTO `captcha_answers` VALUES (170, 6, 30, 'true');
INSERT INTO `captcha_answers` VALUES (171, 7, 1, 'false');
INSERT INTO `captcha_answers` VALUES (172, 7, 2, 'false');
INSERT INTO `captcha_answers` VALUES (173, 7, 3, 'false');
INSERT INTO `captcha_answers` VALUES (174, 7, 4, 'true');
INSERT INTO `captcha_answers` VALUES (175, 7, 5, 'false');
INSERT INTO `captcha_answers` VALUES (176, 7, 6, 'false');
INSERT INTO `captcha_answers` VALUES (177, 7, 7, 'false');
INSERT INTO `captcha_answers` VALUES (178, 7, 8, 'false');
INSERT INTO `captcha_answers` VALUES (179, 7, 9, 'false');
INSERT INTO `captcha_answers` VALUES (180, 7, 10, 'false');
INSERT INTO `captcha_answers` VALUES (181, 7, 11, 'false');
INSERT INTO `captcha_answers` VALUES (182, 7, 12, 'false');
INSERT INTO `captcha_answers` VALUES (183, 7, 13, 'false');
INSERT INTO `captcha_answers` VALUES (184, 7, 14, 'false');
INSERT INTO `captcha_answers` VALUES (185, 7, 15, 'false');
INSERT INTO `captcha_answers` VALUES (186, 7, 16, 'false');
INSERT INTO `captcha_answers` VALUES (187, 7, 17, 'false');
INSERT INTO `captcha_answers` VALUES (188, 7, 18, 'false');
INSERT INTO `captcha_answers` VALUES (189, 7, 19, 'true');
INSERT INTO `captcha_answers` VALUES (190, 7, 20, 'true');
INSERT INTO `captcha_answers` VALUES (191, 7, 21, 'false');
INSERT INTO `captcha_answers` VALUES (192, 7, 22, 'false');
INSERT INTO `captcha_answers` VALUES (193, 7, 23, 'false');
INSERT INTO `captcha_answers` VALUES (194, 7, 24, 'false');
INSERT INTO `captcha_answers` VALUES (195, 7, 25, 'false');
INSERT INTO `captcha_answers` VALUES (196, 7, 28, 'false');
INSERT INTO `captcha_answers` VALUES (197, 7, 29, 'true');
INSERT INTO `captcha_answers` VALUES (198, 7, 30, 'false');
INSERT INTO `captcha_answers` VALUES (199, 8, 3, 'false');
INSERT INTO `captcha_answers` VALUES (200, 8, 4, 'false');
INSERT INTO `captcha_answers` VALUES (201, 8, 5, 'false');
INSERT INTO `captcha_answers` VALUES (202, 8, 6, 'false');
INSERT INTO `captcha_answers` VALUES (203, 8, 7, 'false');
INSERT INTO `captcha_answers` VALUES (204, 8, 8, 'true');
INSERT INTO `captcha_answers` VALUES (205, 8, 9, 'false');
INSERT INTO `captcha_answers` VALUES (206, 8, 10, 'false');
INSERT INTO `captcha_answers` VALUES (207, 8, 11, 'true');
INSERT INTO `captcha_answers` VALUES (208, 8, 12, 'false');
INSERT INTO `captcha_answers` VALUES (209, 8, 13, 'false');
INSERT INTO `captcha_answers` VALUES (210, 8, 14, 'false');
INSERT INTO `captcha_answers` VALUES (211, 8, 15, 'false');
INSERT INTO `captcha_answers` VALUES (212, 8, 16, 'true');
INSERT INTO `captcha_answers` VALUES (213, 8, 17, 'false');
INSERT INTO `captcha_answers` VALUES (214, 8, 18, 'false');
INSERT INTO `captcha_answers` VALUES (215, 8, 19, 'false');
INSERT INTO `captcha_answers` VALUES (216, 8, 20, 'false');
INSERT INTO `captcha_answers` VALUES (217, 8, 21, 'false');
INSERT INTO `captcha_answers` VALUES (218, 8, 22, 'false');
INSERT INTO `captcha_answers` VALUES (219, 8, 23, 'false');
INSERT INTO `captcha_answers` VALUES (220, 8, 24, 'false');
INSERT INTO `captcha_answers` VALUES (221, 8, 25, 'false');
INSERT INTO `captcha_answers` VALUES (222, 8, 26, 'false');
INSERT INTO `captcha_answers` VALUES (223, 8, 27, 'false');
INSERT INTO `captcha_answers` VALUES (224, 8, 28, 'false');
INSERT INTO `captcha_answers` VALUES (225, 8, 29, 'false');
INSERT INTO `captcha_answers` VALUES (226, 8, 30, 'false');
INSERT INTO `captcha_answers` VALUES (227, 9, 1, 'false');
INSERT INTO `captcha_answers` VALUES (228, 9, 2, 'true');
INSERT INTO `captcha_answers` VALUES (229, 9, 3, 'false');
INSERT INTO `captcha_answers` VALUES (230, 9, 4, 'true');
INSERT INTO `captcha_answers` VALUES (231, 9, 5, 'true');
INSERT INTO `captcha_answers` VALUES (232, 9, 6, 'true');
INSERT INTO `captcha_answers` VALUES (233, 9, 7, 'true');
INSERT INTO `captcha_answers` VALUES (234, 9, 8, 'true');
INSERT INTO `captcha_answers` VALUES (235, 9, 9, 'true');
INSERT INTO `captcha_answers` VALUES (236, 9, 11, 'true');
INSERT INTO `captcha_answers` VALUES (237, 9, 12, 'true');
INSERT INTO `captcha_answers` VALUES (238, 9, 13, 'true');
INSERT INTO `captcha_answers` VALUES (239, 9, 14, 'false');
INSERT INTO `captcha_answers` VALUES (240, 9, 15, 'false');
INSERT INTO `captcha_answers` VALUES (241, 9, 16, 'true');
INSERT INTO `captcha_answers` VALUES (242, 9, 17, 'false');
INSERT INTO `captcha_answers` VALUES (243, 9, 18, 'true');
INSERT INTO `captcha_answers` VALUES (244, 9, 19, 'true');
INSERT INTO `captcha_answers` VALUES (245, 9, 20, 'true');
INSERT INTO `captcha_answers` VALUES (246, 9, 21, 'true');
INSERT INTO `captcha_answers` VALUES (247, 9, 23, 'false');
INSERT INTO `captcha_answers` VALUES (248, 9, 24, 'true');
INSERT INTO `captcha_answers` VALUES (249, 9, 25, 'true');
INSERT INTO `captcha_answers` VALUES (250, 9, 26, 'true');
INSERT INTO `captcha_answers` VALUES (251, 9, 28, 'true');
INSERT INTO `captcha_answers` VALUES (252, 9, 29, 'true');
INSERT INTO `captcha_answers` VALUES (253, 9, 30, 'false');
INSERT INTO `captcha_answers` VALUES (255, 2, 31, 'false');
INSERT INTO `captcha_answers` VALUES (256, 3, 31, 'false');
INSERT INTO `captcha_answers` VALUES (257, 4, 31, 'true');
INSERT INTO `captcha_answers` VALUES (258, 6, 31, 'false');
INSERT INTO `captcha_answers` VALUES (259, 7, 31, 'false');
INSERT INTO `captcha_answers` VALUES (260, 8, 31, 'false');
INSERT INTO `captcha_answers` VALUES (261, 9, 31, 'true');
INSERT INTO `captcha_answers` VALUES (262, 1, 32, 'false');
INSERT INTO `captcha_answers` VALUES (263, 2, 32, 'false');
INSERT INTO `captcha_answers` VALUES (264, 3, 32, 'false');
INSERT INTO `captcha_answers` VALUES (265, 4, 32, 'true');
INSERT INTO `captcha_answers` VALUES (266, 5, 32, 'true');
INSERT INTO `captcha_answers` VALUES (267, 6, 32, 'false');
INSERT INTO `captcha_answers` VALUES (268, 8, 32, 'false');
INSERT INTO `captcha_answers` VALUES (269, 9, 32, 'true');
INSERT INTO `captcha_answers` VALUES (270, 1, 33, 'false');
INSERT INTO `captcha_answers` VALUES (271, 2, 33, 'true');
INSERT INTO `captcha_answers` VALUES (272, 3, 33, 'false');
INSERT INTO `captcha_answers` VALUES (273, 4, 33, 'true');
INSERT INTO `captcha_answers` VALUES (274, 5, 33, 'false');
INSERT INTO `captcha_answers` VALUES (275, 6, 33, 'false');
INSERT INTO `captcha_answers` VALUES (276, 7, 33, 'false');
INSERT INTO `captcha_answers` VALUES (277, 8, 33, 'false');
INSERT INTO `captcha_answers` VALUES (278, 9, 33, 'false');
INSERT INTO `captcha_answers` VALUES (279, 1, 34, 'false');
INSERT INTO `captcha_answers` VALUES (280, 2, 34, 'true');
INSERT INTO `captcha_answers` VALUES (281, 3, 34, 'false');
INSERT INTO `captcha_answers` VALUES (282, 4, 34, 'true');
INSERT INTO `captcha_answers` VALUES (283, 5, 34, 'true');
INSERT INTO `captcha_answers` VALUES (284, 6, 34, 'false');
INSERT INTO `captcha_answers` VALUES (285, 8, 34, 'false');
INSERT INTO `captcha_answers` VALUES (286, 9, 34, 'true');
CREATE TABLE `captcha_images` (
`id` int(10) unsigned NOT NULL auto_increment,
`file` varchar(255) NOT NULL default '',
`description` text,
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_images` VALUES (1, 'arend.png', 'Arend');
INSERT INTO `captcha_images` VALUES (2, 'dolfijn.png', 'Dolfijn');
INSERT INTO `captcha_images` VALUES (3, 'duif.png', 'Duif');
INSERT INTO `captcha_images` VALUES (4, 'giraffe.png', 'Giraffe');
INSERT INTO `captcha_images` VALUES (5, 'hert.png', 'Hert');
INSERT INTO `captcha_images` VALUES (6, 'hond.png', 'Hond');
INSERT INTO `captcha_images` VALUES (7, 'kameel.png', 'Kameel');
INSERT INTO `captcha_images` VALUES (8, 'kangeroo.png', 'Kangeroo');
INSERT INTO `captcha_images` VALUES (9, 'kat.png', 'Kat');
INSERT INTO `captcha_images` VALUES (10, 'kip.png', 'Kip');
INSERT INTO `captcha_images` VALUES (11, 'koala.png', 'Koala');
INSERT INTO `captcha_images` VALUES (12, 'koe.png', 'Koe');
INSERT INTO `captcha_images` VALUES (13, 'konijn.png', 'Konijn');
INSERT INTO `captcha_images` VALUES (14, 'koolmees.png', 'Koolmees');
INSERT INTO `captcha_images` VALUES (15, 'kraai.png', 'Kraai');
INSERT INTO `captcha_images` VALUES (16, 'krokodil.png', 'Krokodil');
INSERT INTO `captcha_images` VALUES (17, 'merel.png', 'Merel');
INSERT INTO `captcha_images` VALUES (18, 'muis.png', 'Muis');
INSERT INTO `captcha_images` VALUES (19, 'neushoorn.png', 'Neushoorn');
INSERT INTO `captcha_images` VALUES (20, 'olifant.png', 'Olifant');
INSERT INTO `captcha_images` VALUES (21, 'paard.png', 'Paard');
INSERT INTO `captcha_images` VALUES (22, 'pinguin.png', 'Pinguin');
INSERT INTO `captcha_images` VALUES (23, 'rat.png', 'Rat');
INSERT INTO `captcha_images` VALUES (24, 'roodborstje.png', 'Roodborstje');
INSERT INTO `captcha_images` VALUES (25, 'scarabee.png', 'Scarabee');
INSERT INTO `captcha_images` VALUES (26, 'stokstaartje.png', 'Stokstaartje');
INSERT INTO `captcha_images` VALUES (27, 'struisvogel.png', 'Struisvogel');
INSERT INTO `captcha_images` VALUES (28, 'varken.png', 'Varken');
INSERT INTO `captcha_images` VALUES (29, 'zebra.png', 'Zebra');
INSERT INTO `captcha_images` VALUES (30, 'zwaan.png', 'Zwaan');
INSERT INTO `captcha_images` VALUES (31, 'aap.png', 'Aap');
INSERT INTO `captcha_images` VALUES (32, 'panter.png', 'Panter');
INSERT INTO `captcha_images` VALUES (33, 'papegaai.png', 'Papegaai');
INSERT INTO `captcha_images` VALUES (34, 'tijger.png', 'Tijger');
CREATE TABLE `captcha_questions` (
`id` int(10) unsigned NOT NULL auto_increment,
`theme` int(10) unsigned NOT NULL default '0',
`lable` text NOT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_questions` VALUES (1, 1, 'Welke dieren worden in nederland als vaak als huisdier gehouden.');
INSERT INTO `captcha_questions` VALUES (2, 1, 'Welke dieren kunnen vliegen?');
INSERT INTO `captcha_questions` VALUES (3, 1, 'Welke dieren vind je vaak op de boerderij.');
INSERT INTO `captcha_questions` VALUES (4, 1, 'Welke dieren leven in het oerwoud?');
INSERT INTO `captcha_questions` VALUES (5, 1, 'Welke dieren lopen op 4 poten/benen?');
INSERT INTO `captcha_questions` VALUES (6, 1, 'Welke dieren leven op of in het water?');
INSERT INTO `captcha_questions` VALUES (7, 1, 'Welke dieren leven op de savanne in Afrika?');
INSERT INTO `captcha_questions` VALUES (8, 1, 'Welke dieren leven (met nadruk) in Australie?');
INSERT INTO `captcha_questions` VALUES (9, 1, 'Welke dieren kunnen niet vliegen?');
CREATE TABLE `captcha_themes` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);
INSERT INTO `captcha_themes` VALUES (1, 'Dieren');
Je kijkt naar de data die de server uitspuugt. Op basis van deze 'random' data kan de client een nieuwe vraag stellen aan de bezoeker.
Doordat je de output in HTML bekijkt worden de enters niet goed meegekopieerd, maar in de 'ruwe bron' ziet de output er zo uit:
"Dieren", "1"
"http://www.pholeron.com/projects/captcha/images/"
"Welke dieren kunnen niet vliegen?", "9"
"zebra.png", "Zebra", "true"
"papegaai.png", "Papegaai", "false"
De 1e regel geeft aan uit welk thema een vraag is geladen.. In dit geval:
thema: 'dieren', id: 1;
De 2e regel geeft aan op welke URL de afbeeldingen gevonden kunnen worden. Momenteel is deze statisch, maar in de toekomst zou ik op deze manier de traffic voor het laden van afbeeldingen kunnen verdelen over verschillende servers.
De 3e regel geeft aan welke vraag is geladen.. In dit geval:
vraag: Welke dieren kunnen niet vliegen?, id: 9
Tot slot vormen de overige regels de afbeeldingen die geladen moeten worden. Per afbeelding ontvang je een bestandsnaam, een omschrijving (alt text) en een FLAG (true|false) die aangeeft of, bij het juist beantwoord van de vraag, de afbeelding wel of niet geselecteerd zou moeten zijn.
In het bestand "captcha.cls.php", wordt op regel 20 de data van de server geladen en ge-sliced in bruikbare stukken.
Doordat je de output in HTML bekijkt worden de enters niet goed meegekopieerd, maar in de 'ruwe bron' ziet de output er zo uit:
"Dieren", "1"
"http://www.pholeron.com/projects/captcha/images/"
"Welke dieren kunnen niet vliegen?", "9"
"zebra.png", "Zebra", "true"
"papegaai.png", "Papegaai", "false"
De 1e regel geeft aan uit welk thema een vraag is geladen.. In dit geval:
thema: 'dieren', id: 1;
De 2e regel geeft aan op welke URL de afbeeldingen gevonden kunnen worden. Momenteel is deze statisch, maar in de toekomst zou ik op deze manier de traffic voor het laden van afbeeldingen kunnen verdelen over verschillende servers.
De 3e regel geeft aan welke vraag is geladen.. In dit geval:
vraag: Welke dieren kunnen niet vliegen?, id: 9
Tot slot vormen de overige regels de afbeeldingen die geladen moeten worden. Per afbeelding ontvang je een bestandsnaam, een omschrijving (alt text) en een FLAG (true|false) die aangeeft of, bij het juist beantwoord van de vraag, de afbeelding wel of niet geselecteerd zou moeten zijn.
In het bestand "captcha.cls.php", wordt op regel 20 de data van de server geladen en ge-sliced in bruikbare stukken.
Voor m'n 'captcha server' project heb ik de volgende URLs geregistreerd:
www.captchaserver.nl
www.captcha-server.nl
(Waarbij de 1e url doorverwijst naar de 2e)
Een captcha-request kan gedaan worden op:
www.captcha-server.nl/request.php
Nu vroeg ik mij af of hier mensen zijn die leuke afbeeldingen willen/kunnen aanleveren van verschillende voorwerpen, gebouwen, dieren, planten, enz die ik kan gebruiken voor m'n captcha server. Denk er om dat deze afbeeldingen niet beschermd worden door copyright e.d.
Liefst gesliced in 100 x 100 pixels, PNG of JPG (niet deels transparant).
wie wil me helpen? (:
www.captchaserver.nl
www.captcha-server.nl
(Waarbij de 1e url doorverwijst naar de 2e)
Een captcha-request kan gedaan worden op:
www.captcha-server.nl/request.php
Nu vroeg ik mij af of hier mensen zijn die leuke afbeeldingen willen/kunnen aanleveren van verschillende voorwerpen, gebouwen, dieren, planten, enz die ik kan gebruiken voor m'n captcha server. Denk er om dat deze afbeeldingen niet beschermd worden door copyright e.d.
Liefst gesliced in 100 x 100 pixels, PNG of JPG (niet deels transparant).
wie wil me helpen? (:
Om te reageren heb je een account nodig en je moet ingelogd zijn.
Inhoudsopgave
Labels
- Geen tags toegevoegd.
PHP hulp
0 seconden vanaf nu