YEA CALL me a stupid *^^%&*$&% i know :-X
but..i was testing somthing with a second acount on the forum
and gived that acount a ban.....but i think it was IP ban :frusty:
so....i cant login anymore and other admins are sleeping :D
so.....who can help me out? 8)
you should be able to delete the banned id thru phpmyadmin
smf_banned
hmm... if I banned myself, I'd go into my SMF database (phpmyadmin) and drop the rows that affect me from the table called smf_banned but let's hear it from those who would know better. ;)
edit: haha... diplomat's post wasn't there when i was replying and checking my db
hmm i think.
go into phpmyadmin..
smf_members
browse.. find your username..
and change :ID_GROUP: to a "1" then u should be an admin..
and i think u can do the same thing dip said..
try that.. may be wrong.. but i one time banned my self :P (testing) and had to do that.. but it was with an test account... soo yeahh..
ok ok i going to try that......
im a n00b with php hope the forum will work after that ;)
thnx guys!
damn im 2 stupid i think
but where/witch file must i open :-[
Okeej! my ban is gone but i f****d up the forum
so who can help me out !
This is what i get when i want 2 check the Banlist
Unknown column 'ID_BAN' in 'field list'
Bestand: /data/members/paid/p/p/ppexx.com/htdocs/www/forum/Sources/ManageMembers.php
Regel: 1360
thnx!
edit: removed vulgarity.
Lainaus käyttäjältä: ppexx - helmikuu 26, 2005, 02:27:15 AP
Okeej! my ban is gone but i f****d up the forum
so who can help me out !
This is what i get when i want 2 check the Banlist
Unknown column 'ID_BAN' in 'field list'
Bestand: /data/members/paid/p/p/ppexx.com/htdocs/www/forum/Sources/ManageMembers.php
Regel: 1360
Ack! You deleted/changed the table!!
Anyway, what happens is the forum caching banning information.
Regardless, you seem to have messed up the entire table! Eek. To restore it:
DROP TABLE smf_banned;
CREATE TABLE smf_banned (
ID_BAN mediumint(8) unsigned NOT NULL auto_increment,
ban_type varchar(30) NOT NULL default '',
ip_low1 tinyint(3) unsigned NOT NULL default '0',
ip_high1 tinyint(3) unsigned NOT NULL default '0',
ip_low2 tinyint(3) unsigned NOT NULL default '0',
ip_high2 tinyint(3) unsigned NOT NULL default '0',
ip_low3 tinyint(3) unsigned NOT NULL default '0',
ip_high3 tinyint(3) unsigned NOT NULL default '0',
ip_low4 tinyint(3) unsigned NOT NULL default '0',
ip_high4 tinyint(3) unsigned NOT NULL default '0',
hostname tinytext NOT NULL default '',
email_address tinytext NOT NULL default '',
ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
ban_time int(10) unsigned NOT NULL default '0',
expire_time int(10) unsigned,
restriction_type varchar(30) NOT NULL default '',
reason tinytext NOT NULL default '',
notes text NOT NULL default '',
PRIMARY KEY (ID_BAN)
) TYPE=MyISAM;What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
-[Unknown]
yea i know its a stupid action.... :(
but now.....i really dont have an idee what i must do
maby i can give you my lycos acount name and pas and you or someone can fix that for me.. ::)
I'm afraid I don't understand; did you try what I said? Did you click the link I posted?
-[Unknown]
oeps i did't
i going to read that thanx !