banned myself!! HELP

[ppexx]

YEA CALL me a stupid *^^%&*$&%  i know 

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

so.....who can help me out?

[diplomat.]

you should be able to delete the banned id thru phpmyadmin
smf_banned

[MrWoof]

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

[_complex]

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 (testing) and had to do that.. but it was with an test account... soo yeahh..

[ppexx]

ok ok  i going to try that......

im a n00b with php  hope the forum will work after that 


thnx guys!

[ppexx]

damn im 2 stupid i think

but where/witch file must i open       

[ppexx]

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.

[[Unknown]]

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:

Koodi [Valitse] Laajenna

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?

-[Unknown]

[ppexx]

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.. 

[[Unknown]]

I'm afraid I don't understand; did you try what I said?  Did you click the link I posted?

-[Unknown]

[ppexx]

oeps i did't


i going to read that thanx !