From 075bc5af11d62a9c4265942501836422194cbb6e Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Wed, 5 Apr 2006 00:23:18 +0000
Subject: - Added inter config connection_ping_interval which specifies
 interval in hours at which mysql_ping's must be done on all connection
 handles to keep the mysql connection alive. Defaults to 0 (disabled) -
 Removed login sql handle from the map server as it isn't used for anything. -
 Made the login sql handle on the char-sql server be used only when
 gm_read_method 1 is enabled. - Small fixes to npc_enable, added BL_NPC
 handling on status_get_sc. - Added a path_search check in map_random_dir, so
 that the random direction picked up doesn't goes through walls and all that.
 - Some changes to close-confine, status start will fail when the source is
 not found or it doesn't has sc-data. - pc_setoption no longer changes the
 character's class when mounting/dismounting, it only changes the view-class.
 - The peco-crash-fix from the char servers is still needed. This packet must
 be wrong! We likely need to sniff it. - Modified the char-txt server to
 modify the class of mounted characters to their non-mounted version. Added an
 upgrade_svn file to handle the class update on the sql tables.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5902 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/upgrade_svn5902.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql-files/upgrade_svn5902.sql

(limited to 'sql-files/upgrade_svn5902.sql')

diff --git a/sql-files/upgrade_svn5902.sql b/sql-files/upgrade_svn5902.sql
new file mode 100644
index 000000000..f9783ef00
--- /dev/null
+++ b/sql-files/upgrade_svn5902.sql
@@ -0,0 +1,14 @@
+update `char` set `class`='7' where `class`='13';
+update `char` set `class`='21' where `class`='14';
+update `char` set `class`='4008' where `class`='4014';
+update `char` set `class`='4015' where `class`='4022';
+update `char` set `class`='4030' where `class`='4036';
+update `char` set `class`='4037' where `class`='4044';
+update `char` set `class`='4047' where `class`='4048';
+update `guild_member` set `class`='7' where `class`='13';
+update `guild_member` set `class`='21' where `class`='14';
+update `guild_member` set `class`='4008' where `class`='4014';
+update `guild_member` set `class`='4015' where `class`='4022';
+update `guild_member` set `class`='4030' where `class`='4036';
+update `guild_member` set `class`='4037' where `class`='4044';
+update `guild_member` set `class`='4047' where `class`='4048';
-- 
cgit v1.2.3-70-g09d2

