aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorBlaymoira <none@none>2009-01-04 19:34:15 +0100
committerBlaymoira <none@none>2009-01-04 19:34:15 +0100
commit0389ed45281b65c39b034bf4cc899dbdaf5d04ce (patch)
tree9bea18ebd282461229cafb2f6075bfede3a9eab5 /sql/updates
parentb9f1a0fda1fee76b57ba1fcdaec82be18610bcc0 (diff)
* 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
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/780_characters.sql2
1 files changed, 2 insertions, 0 deletions
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