next »

[Plastikman]

Hello,  I would like to clear my ban list,  there are many id's banned and I cannot unban each one.  Do I need to modify the database to accomplish this ?

[xlr8or]

yes, easiest way is to flush the penalties table

[Plastikman]

thx,

dumb question but how do i jus drop the data without dropping the table ?  I right click penalties and goto edit table data.  It shows me all the id's that were banned and all but when right clicking or highlighting the data the delete row(s) option is greyed out

[xlr8or]

execute this sql command on the desired database:

Code:

TRUNCATE `penalties`;

[Plastikman]

thank you