Ik heb Ron z`n script gedownload, een database aangemaakt en de config.php aangepast, maar nu vraag ik me wat af. Ik moet deze tabelen aanmaken, maar wat houd de info die je krijgt bij
insert into, moet ik dan in plaats van '0' bijvoorbeeld '60' invoeren?
CREATE TABLE tbl_config (
cfg_antiflood int(10) unsigned default '0',
cfg_maxmsg int(5) unsigned default '0',
cfg_register int(1) unsigned default '0',
cfg_smiles int(1) unsigned default '0',
cfg_ubbcode int(1) unsigned default '0',
cfg_perpage int(5) unsigned default '0',
cfg_perpageinbox int(5) unsigned default '0',
cfg_wlcmtitle varchar(50) default '0',
cfg_wlcmmsg blob,
cfg_admindate varchar(20) default '0',
cfg_adminuser varchar(15) default '0',
cfg_adminpass varchar(32) default '0'
) TYPE=MyISAM;
INSERT INTO tbl_config VALUES("60", "50", "1", "1", "1", "25", "25", "Thanks for registering your account on our website", "Thanks for registering your account on our website...\r\n\r\nHave fun !\r\n\r\nGreetz,\r\nAdministrator", "D d F g:i A", "admin", "1234");
CREATE TABLE tbl_msg (
msg_id int(10) unsigned NOT NULL auto_increment,
msg_title varchar(50) default '0',
msg_time datetime default NULL,
msg_message blob,
msg_from int(10) unsigned default '0',
msg_to int(10) unsigned default '0',
msg_read int(1) default '0',
msg_ip varchar(20) default '0',
PRIMARY KEY (msg_id)
) TYPE=MyISAM;
CREATE TABLE tbl_smiles (
smile_id int(10) unsigned NOT NULL auto_increment,
smile_name char(25) default '0',
smile_tag char(10) default '0',
smile_file char(50) default '0',
PRIMARY KEY (smile_id)
) TYPE=MyISAM;
INSERT INTO tbl_smiles VALUES("1", "Amazed", ":o", "amazed.gif");
INSERT INTO tbl_smiles VALUES("2", "Amuse", "^_^", "amuse.gif");
INSERT INTO tbl_smiles VALUES("3", "Big Smile", ":D", "bigsmile.gif");
INSERT INTO tbl_smiles VALUES("4", "Blink", "o_O", "blink.gif");
INSERT INTO tbl_smiles VALUES("5", "Cheesy", ":P", "cheesy.gif");
INSERT INTO tbl_smiles VALUES("6", "Confused", ":S", "confused.gif");
INSERT INTO tbl_smiles VALUES("7", "Cool", "8)", "cool.gif");
INSERT INTO tbl_smiles VALUES("8", "Cry", ":\'(", "cry.gif");
INSERT INTO tbl_smiles VALUES("9", "Evil", ">8(", "evil.gif");
INSERT INTO tbl_smiles VALUES("10", "Laugh", "=D", "laugh.gif");
INSERT INTO tbl_smiles VALUES("11", "Mad", ":@", "mad.gif");
INSERT INTO tbl_smiles VALUES("12", "No Trust", "=/", "notrust.gif");
INSERT INTO tbl_smiles VALUES("13", "No Worry", "v_v", "noworry.gif");
INSERT INTO tbl_smiles VALUES("14", "Nuts", "8D", "nuts.gif");
INSERT INTO tbl_smiles VALUES("15", "Oh", "\'_\'", "oh.gif");
INSERT INTO tbl_smiles VALUES("16", "Push", ">_<", "push.gif");
INSERT INTO tbl_smiles VALUES("17", "Rolleyes", ":roll:", "sick.gif");
INSERT INTO tbl_smiles VALUES("18", "Sad", ":(", "sad.gif");
INSERT INTO tbl_smiles VALUES("19", "Shy", ":$", "shy.gif");
INSERT INTO tbl_smiles VALUES("20", "Sick", ":x", "sick.gif");
INSERT INTO tbl_smiles VALUES("21", "Smile", ":)", "smile.gif");
INSERT INTO tbl_smiles VALUES("22", "Suspicious", "¬_¬", "suspicious.gif");
INSERT INTO tbl_smiles VALUES("23", "Unsure", "ó_ò", "unsure.gif");
INSERT INTO tbl_smiles VALUES("24", "Wink", ";)", "wink.gif");
CREATE TABLE tbl_users (
user_id int(10) unsigned NOT NULL auto_increment,
user_name varchar(50) default '0',
user_email varchar(125) default '0',
user_url varchar(150) default '0',
user_pass varchar(32) default '0',
user_regdate datetime default NULL,
user_lastactive datetime default NULL,
user_dateformat varchar(20) default '0',
user_showmail int(1) unsigned default '0',
user_public int(1) unsigned default '1',
user_activated varchar(10) default '0',
user_admcom blob,
user_pm int(1) unsigned default '0',
user_block blob,
user_ip varchar(20) default '0.0.0.0',
PRIMARY KEY (user_id)
) TYPE=MyISAM;
INSERT INTO tbl_users VALUES("127", "test", "
[email protected]", NULL, "0efffc51d5e228e69bec75545457b977", "2004-02-16 18:52:08", "2004-02-16 18:52:29", "d-m-Y H:i:s", "1", "1", "1", NULL, "1", NULL, "127.0.0.1");
