Delete All Players

Got an idea? Missing something? Post your feature request here.

Moderator: moderators

Delete All Players

Postby OlYeller21 » Tue Feb 01, 2011 4:57 am

It would be nice if there was a Delete All Players button. I like to clear out all the Players people have left and it would be nice if I didn't have to click the button 30-40 times when I do it.
OlYeller21
 
Posts: 86
Joined: Fri Aug 27, 2010 8:09 pm

Postby stozher » Tue Feb 01, 2011 11:41 am

View all players (http://localhost/db.view):
Code: Select all
select * from PLAYER

Remove players with username 'guest' (change 'guest' with other if necessary):
Code: Select all
delete from PLAYER where USERNAME='guest'

Remove all players:
Code: Select all
delete from PLAYER

SQL Tutorial: http://www.tizag.com/sqlTutorial/
MySQL Tutorial: http://www.tizag.com/mysqlTutorial/
Last edited by stozher on Tue Feb 01, 2011 8:09 pm, edited 1 time in total.
http://music.stozher.com:8080/login.view?user=guest&password=
User avatar
stozher
 
Posts: 313
Joined: Tue Nov 16, 2010 10:56 am
Location: Sofia, Bulgaria

Postby bushman4 » Tue Feb 01, 2011 6:41 pm

Very very cool. I did not realize that there was an exposed DB query screen. Thanks for sharing.

Glenn
User avatar
bushman4
 
Posts: 874
Joined: Thu Dec 02, 2010 1:47 pm
Location: Massachusetts, USA


Return to Feature Requests

Who is online

Users browsing this forum: No registered users and 12 guests