From 4f192318c6ce14dc231dba81426161cb7d450738 Mon Sep 17 00:00:00 2001 From: Lupus Date: Thu, 17 Feb 2005 17:19:26 +0000 Subject: added +2 drops slots into MOBS DBs brushed up srcs for 10 drops fixed some mobs... fixed TXT logs fixed 1 guardian spawn changed 2 SQL files. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1126 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/db_tables.sql | 8 +++++--- sql-files/logs.sql | 2 ++ 2 files changed, 7 insertions(+), 3 deletions(-) (limited to 'sql-files') diff --git a/sql-files/db_tables.sql b/sql-files/db_tables.sql index 2d202f49a..aedc28995 100644 --- a/sql-files/db_tables.sql +++ b/sql-files/db_tables.sql @@ -332,12 +332,14 @@ CREATE TABLE `mob_db2` ( `Drop5per` mediumint(9) NOT NULL default '0', `Drop6id` mediumint(9) NOT NULL default '0', `Drop6per` mediumint(9) NOT NULL default '0', - `Drop7d` mediumint(9) NOT NULL default '0', + `Drop7id` mediumint(9) NOT NULL default '0', `Drop7per` mediumint(9) NOT NULL default '0', `Drop8id` mediumint(9) NOT NULL default '0', `Drop8per` mediumint(9) NOT NULL default '0', - `Item1` tinyint(4) NOT NULL default '0', - `Item2` tinyint(4) NOT NULL default '0', + `Drop9id` mediumint(9) NOT NULL default '0', + `Drop9per` mediumint(9) NOT NULL default '0', + `DropCardid` mediumint(9) NOT NULL default '0', + `DropCardper` mediumint(9) NOT NULL default '0', `MEXP` mediumint(9) NOT NULL default '0', `ExpPer` mediumint(9) NOT NULL default '0', `MVP1id` mediumint(9) NOT NULL default '0', diff --git a/sql-files/logs.sql b/sql-files/logs.sql index 25a52443b..8dc764ec5 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -25,6 +25,8 @@ CREATE TABLE `droplog` ( `item6` int(11) NOT NULL default '0', `item7` int(11) NOT NULL default '0', `item8` int(11) NOT NULL default '0', + `item9` int(11) NOT NULL default '0', + `itemCard` int(11) NOT NULL default '0', `map` varchar(20) NOT NULL default '', PRIMARY KEY (`drop_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- cgit v1.2.3-70-g09d2