From 0389ed45281b65c39b034bf4cc899dbdaf5d04ce Mon Sep 17 00:00:00 2001 From: Blaymoira Date: Sun, 4 Jan 2009 19:34:15 +0100 Subject: * Fix reload tickets from database * Fix crash /exploit issue with improper pasing when '%' is in ticket message * Remove obsolete recv_data from tickets * Allow closing of a ticket inserting the guid of the GM or player that closed it into the database. * Allow assigning tickets to offline GMs. * Tighten up SQL escape strings, increased security against SQL injections * Fix issue where multiple tickets could have the same entry * --- by Machiavelli --- --HG-- branch : trunk --- sql/updates/780_characters.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/780_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/780_characters.sql b/sql/updates/780_characters.sql new file mode 100644 index 00000000000..cbcb193c276 --- /dev/null +++ b/sql/updates/780_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE `gm_tickets` CHANGE `guid` `guid` int(10) NOT NULL AUTO_INCREMENT; +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` int(10) NOT NULL; \ No newline at end of file -- cgit v1.2.3