Snp login 1.3
Hoe maak ik een admin aan ?
Want ik heb geen admin user en pass (werkt niet)
en ik weet ook niet hoe ik bijv (als het kan) het in de db kan zetten.
Als iemand me kan helpen. graag
P.S.
Script is zelfde gebleven
pomp dan ff handmatig een user de DB in met admin rechten ;-)
dit is sql code miss dat jij er iets mee kan.
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
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
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", "admino", "1234o");
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");
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", "admino", "1234o");
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");