From: Luca P. <lpa...@us...> - 2007-10-01 20:16:35
|
Update of /cvsroot/planeshift/planeshift/src/server/database/mysql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16234 Modified Files: deletechar.sql Log Message: delete char also for single id Index: deletechar.sql =================================================================== RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/deletechar.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** deletechar.sql 24 Dec 2004 11:09:48 -0000 1.2 --- deletechar.sql 1 Oct 2007 20:16:38 -0000 1.3 *************** *** 21,25 **** ! # perform deletion set @player_id_min=9000074; set @player_id_max=9000077; --- 21,25 ---- ! # perform deletion for a range of IDS set @player_id_min=9000074; set @player_id_max=9000077; *************** *** 31,32 **** --- 31,44 ---- delete from character_glyphs where player_id>=@player_id_min and player_id<=@player_id_max; delete from characters where id>=@player_id_min and id<=@player_id_max; + + + + # perform deletion for one char only + set @player_id=9242522; + delete from player_spells where player_id=@player_id; + delete from item_instances where char_id_owner=@player_id; + delete from character_traits where character_id=@player_id; + delete from character_skills where character_id=@player_id; + delete from character_quests where player_id=@player_id; + delete from character_glyphs where player_id=@player_id; + delete from characters where id=@player_id; |