CodeIgniter Forums
Captcha Help - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Captcha Help (/showthread.php?tid=27153)



Captcha Help - El Forum - 02-02-2010

[eluser]BentMC[/eluser]
I'm attempting to use the code found Here to create a captcha for a website I am working on. I am new to codeigniter and I am still learning the hierarchy of files and things of that nature, basically tracing the calls to different files in the local and system directory. My question has to do with the database section in that wiki page:
Quote:For us ethe librarie (put it in the application librarie) create a db table as this code
Code:
CREATE TABLE captcha (
     captcha_id bigint(13) unsigned NOT NULL auto_increment,
     captcha_time int(10) unsigned NOT NULL,
     ip_address varchar(16) default '0' NOT NULL,
     word varchar(20) NOT NULL,
     PRIMARY KEY (captcha_id),
     KEY (word)
    )

I am uncertain where I need to insert this in my system files. I can answer any questions regarding our setup as needed.


Captcha Help - El Forum - 02-02-2010

[eluser]danmontgomery[/eluser]
You don't insert that in your system files, it's a MySQL query that creates the table used by the captcha. You would run it in the mysql console, phpmyadmin or whatever database management app you're using.


Captcha Help - El Forum - 02-03-2010

[eluser]BentMC[/eluser]
Thank you, databases are not my area of expertise to say the least.