mysql

[bumxd 16]

hi, can anybody help  with sql command, how i can find in base quest all linea with word "biolog" and delete it?

[ondry 332]

DELETE FROM player.quest WHERE szName LIKE "%biolog%"

[bumxd 16]

#

[Lazarus1988 8]

Yes. I suggest to use in quests with biolog additional flags like pc.setqf("BiologDone", 1) (wich means the quest is done) at the end of mission so you could use query like this:

DELETE FROM `player`.`quest` WHERE `szName` LIKE "%Biolog%" OR  `szName` LIKE "%biolog%" AND `szState` = "BiologDone" AND `szValue` = 1;

There is also another way, probably you're using navicat, so running custom query like this one:

SELECT * FROM `player`.`quest`  WHERE `szName` LIKE "%Biolog%" OR  `szName` LIKE "%biolog%";

will show all quests related to "biolog" and you can simply select with your mouse records wich you want to delete and do it with simple DEL key stroke (preferable way)

Another think, any third party modifications on database should be done on killed "game" and "db" processes.

PS witam kolegę z Polski