Saick

/*

* This program is free software: you can redistribute it and/or modify it under

* the terms of the GNU General Public License as published by the Free Software

* Foundation, either version 3 of the License, or (at your option) any later

* version.

*

* This program is distributed in the hope that it will be useful, but WITHOUT

* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS

* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more

* details.

*

* You should have received a copy of the GNU General Public License along with

* this program. If not, see <http://www.gnu.org/licenses/>.

*/

package com.l2jfrozen.gameserver.datatables;

 

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.logging.Logger;

 

import javolution.util.FastList;

import javolution.util.FastMap;

 

import com.l2jfrozen.Config;

import com.l2jfrozen.gameserver.model.L2Skill;

import com.l2jfrozen.gameserver.powerpak.PowerPakConfig;

import com.l2jfrozen.util.CloseUtil;

import com.l2jfrozen.util.database.L2DatabaseFactory;

 

/**

* This class stores players' buff schemes into FastMap. On player login, his scheme is loaded and on server shutdown all modified schemes are saved to DataBase. This avoids too many unnecessary DataBase connections and queries. If server crashes, nothing important is lost

*

* @author

*/

public class CharSchemesTable

{

private static FastMap<Integer, FastMap<String, FastList<L2Skill>>> _schemesTable;

private static CharSchemesTable _instance = null;

private static Logger _log = Logger.getLogger(CharSchemesTable.class.getName());

private static final String SQL_LOAD_SCHEME = "SELECT * FROM mods_buffer_schemes WHERE ownerId=?";

private static final String SQL_DELETE_SCHEME = "DELETE FROM mods_buffer_schemes WHERE ownerId=?";

private static final String SQL_INSERT_SCHEME = "INSERT INTO mods_buffer_schemes (ownerId, id, level, scheme) VALUES (?,?,?,?)";

 

public CharSchemesTable()

{

_schemesTable = new FastMap<Integer, FastMap<String, FastList<L2Skill>>>();

}

 

/**

* This method loads player scheme and put into _schemesTable map.

*

* @param objectId

* : player's objectId

*/

public void loadScheme(int objectId)

{

Connection con = null;

try

{

con = L2DatabaseFactory.getInstance().getConnection(false);

PreparedStatement statement = con.prepareStatement(SQL_LOAD_SCHEME);

statement.setInt(1, objectId);

ResultSet rs = statement.executeQuery();

FastMap<String, FastList<L2Skill>> map = new FastMap<String, FastList<L2Skill>>();

while (rs.next())

{

int skillId = rs.getInt("id");

int skillLevel = rs.getInt("level");

String scheme = rs.getString("scheme");

if (!map.containsKey(scheme) && map.size() <= PowerPakConfig.NPCBUFFER_MAX_SCHEMES)

map.put(scheme, new FastList<L2Skill>());

if (map.get(scheme) != null && map.get(scheme).size() < PowerPakConfig.NPCBUFFER_MAX_SKILLS)

map.get(scheme).add(SkillTable.getInstance().getInfo(skillId, skillLevel));

}

if (!map.isEmpty())

_schemesTable.put(objectId, map);

statement.close();

rs.close();

}

catch (Exception e)

{

if(Config.ENABLE_ALL_EXCEPTIONS)

e.printStackTrace();

 

_log.warning("Error trying to load buff scheme from object id: " + objectId);

}

finally

{

CloseUtil.close(con);

 

}

}

 

public void onPlayerLogin(int playerId)

{

if (_schemesTable.get(playerId) == null)

loadScheme(playerId);

}

 

/**

* Do necessary task when server is shutting down or restarting:<br>

* <li>Clears DataBase</li> <li>Saves new info</li>

*/

public void onServerShutdown()

{

if (PowerPakConfig.NPCBUFFER_STORE_SCHEMES)

{

clearDB();

saveDataToDB();

}

}

 

public void clearDB()

{

if (_schemesTable.isEmpty())

return;

Connection con = null;

try

{

con = L2DatabaseFactory.getInstance().getConnection(false);

for (FastMap.Entry<Integer, FastMap<String, FastList<L2Skill>>> e = _schemesTable.head(), end = _schemesTable.tail(); (e = e.getNext()) != end;)

{

PreparedStatement statement = con.prepareStatement(SQL_DELETE_SCHEME);

statement.setInt(1, e.getKey());

statement.execute();

}

}

catch (Exception e)

{

if(Config.ENABLE_ALL_EXCEPTIONS)

e.printStackTrace();

 

_log.warning("CharSchemesTable: Error while trying to delete schemes");

}

finally

{

CloseUtil.close(con);

 

}

}

 

public void saveDataToDB()

{

if (_schemesTable.isEmpty())

return;

Connection con = null;

int count = 0;

try

{

con = L2DatabaseFactory.getInstance().getConnection(false);

// _schemesTable

for (FastMap.Entry<Integer, FastMap<String, FastList<L2Skill>>> e = _schemesTable.head(), end = _schemesTable.tail(); (e = e.getNext()) != end;)

{

// each profile

if (e.getValue() == null || e.getValue().isEmpty())

continue;

for (FastMap.Entry<String, FastList<L2Skill>> a = e.getValue().head(), enda = e.getValue().tail(); (a = a.getNext()) != enda;)

{

if (a.getValue() == null || a.getValue().isEmpty())

continue;

// each skill

for (L2Skill sk : a.getValue())

{

PreparedStatement statement = con.prepareStatement(SQL_INSERT_SCHEME);

statement.setInt(1, e.getKey());

statement.setInt(2, sk.getId());

statement.setInt(3, sk.getLevel());

statement.setString(4, a.getKey());

statement.execute();

}

}

count++;

}

}

catch (Exception e)

{

if(Config.ENABLE_ALL_EXCEPTIONS)

e.printStackTrace();

 

_log.warning("CharSchemesTable: Error while trying to delete schemes");

}

finally

{

CloseUtil.close(con);

 

System.out.println("CharSchemeTable: Saved " + String.valueOf(count + " scheme(s)"));

}

}

 

public FastList<L2Skill> getScheme(int playerid, String scheme_key)

{

if (_schemesTable.get(playerid) == null)

return null;

return _schemesTable.get(playerid).get(scheme_key);

}

 

public boolean getSchemeContainsSkill(int playerId, String scheme_key, int skillId)

{

for (L2Skill sk : getScheme(playerId, scheme_key))

if (sk.getId() == skillId)

return true;

return false;

}

 

public void setScheme(int playerId, String schemeKey, FastList<L2Skill> list)

{

_schemesTable.get(playerId).put(schemeKey, list);

}

 

public FastMap<String, FastList<L2Skill>> getAllSchemes(int playerId)

{

return _schemesTable.get(playerId);

}

 

public FastMap<Integer, FastMap<String, FastList<L2Skill>>> getSchemesTable()

{

return _schemesTable;

}

 

public static CharSchemesTable getInstance()

{

if (_instance == null)

_instance = new CharSchemesTable();

return _instance;

}

}

--

-- Dumping data for table `npc`

--

INSERT ignore INTO custom_npc (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`)

VALUES

(50007, 31324, 'Andromeda', '1', 'Wedding Manager', '1', 'NPC.a_casino_FDarkElf', '8.00', '23.00', '70', 'female', 'L2WeddingManager', '40', '3862', '1493', '500', '500', '40', '43', '30', '21', '20', '10', '0', '0', '9999', '9999', '999', '999', '278', '0', '333', '316', '0', '0', '55', '132', null, '0', '1', '0', 'LAST_HIT'),

(50017, 31854, 'Protector', '1', 'PVP/PK Manager', '1', 'NPC.a_maidA_FHuman', '8.00', '20.50', '80', 'female', 'L2Protector', '40', '99999', '9999', null, null, '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '10000', '382', '278', '0', '3000', '0', '0', '0', '55', '132', null, '0', '0', '0', 'LAST_HIT'),

('50018',30499,'Balin',1,'Engraver',1,'NPC.e_smith_master_MDwarf','8.00','20.50','80','male','L2Npc',40,'8888','8888',NULL,NULL,'40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','10','132',NULL,'0',0,'0','LAST_HIT'),

(55555, 22124, 'Totor', '1', 'Rebirth Manager', '1', 'NPC.a_fighterguild_master_FHuman', '11.00', '27.00', '83', 'male', 'L2Merchant', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', null, '0', '0', '0', 'LAST_HIT'),

(70010, 31606, 'Catrina', '1', 'TvT Event Manager', '1', 'Monster2.queen_of_cat', '8.00', '15.00', '70', 'female', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '28', '132', null, '0', '0', '0', 'LAST_HIT'),

(70011, 31606, 'Catretta', '1', 'CTF Event Manager', '1', 'Monster2.queen_of_cat', '8.00', '15.00', '70', 'female', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '28', '132', null, '0', '0', '0', 'LAST_HIT'),

(70012, 31606, 'Catrosa', '1', 'VIP Join Manager', '1', 'Monster2.queen_of_cat', '8.00', '15.00', '70', 'female', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '28', '132', null, '0', '0', '0', 'LAST_HIT'),

(70013, 31606, 'Catrigna', '1', 'VIP End Manager', '1', 'Monster2.queen_of_cat', '8.00', '15.00', '70', 'female', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '28', '132', null, '0', '0', '0', 'LAST_HIT'),

(70014, 31606, 'Catrieta', '1', 'DM Event Manager', '1', 'Monster2.queen_of_cat', '8.00', '15.00', '70', 'female', 'L2Npc', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '28', '132', null, '0', '0', '0', 'LAST_HIT');

 

insert ignore into `custom_npc` (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`)

values

('66666',32130, 'Looney the Cat', 1, 'Nobless Trader', 1, 'Monster3.king_of_cat', 6.00, 16.01, 70, 'male', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 333, 0, 0, 0, 88, 132, '', 0, 0, 0);

 

insert ignore into `custom_npc` (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`)

values

('66667',32130, 'Fragola the Cat', 1, 'Clan Manager', 1, 'Monster3.king_of_cat', 6.00, 16.01, 70, 'male', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 333, 0, 0, 0, 88, 132, '', 0, 0, 0);

 

INSERT ignore INTO custom_npc

values

(53, 20830, 'Angelic Shop', 1, 'L2 Frozen', 1, 'Monster.angel', 13.50, 36.50, 72, 'male', 'L2Merchant', 40, 4013, 1565, 53.72, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 1710, 406, 849, 399, 278, 500, 333, 148, 0, 0, 33, 187, 'tower_guard_clan', 400, 0, 10, 'LAST_HIT'),

(7077, 31862, 'Vortex Gatekeeper', 1, 'L2 Frozen', 1, 'NPC.broadcasting_tower', 7.00, 35.00, 70, 'etc', 'L2Teleporter', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 490, 10, 1314, 470, 780, 382, 278, 0, 333, 0, 0, 0, 55, 132, '', 0, 1, 0, 'LAST_HIT'),

(50019, 27214, 'Guardian Buffer', 1, 'L2 Frozen', 1, 'Monster2.apostle_warrior', 8.00, 30.00, 76, 'female', 'L2Npc', 40, 4297, 1710, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 2242, 534, 994, 433, 200, 0, 333, 80, 0, 0, 55, 198, 'guard_of_secrets_clan', 300, 0, 0, 'LAST_HIT'),

('31228', '31228', 'Roy the Cat', '1', 'Classes Trader', '1', 'Monster.cat_the_cat', '9.00', '16.00', '70', 'male', 'L2ClassMaster', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '490', '10', '1335', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', null, '0', '0', '0', 'LAST_HIT');

 

INSERT INTO `custom_npc` VALUES

(93000, 30705, 'Boss Manager', 1, 'Raid Info', 1, 'NPC.e_fighterguild_teacher_MOrc', 8.00, 28.50, 70, 'male', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 333, 0, 0, 0, 55, 132, '', 0, 1, 0, 'LAST_HIT');

 

INSERT INTO `custom_npc` VALUES

(54, 21654, 'Necromancer of Destruction', 1, 'Equip Manager', 1, 'Monster.vale_master_20_bi', 14.50, 48.00, 80, 'male', 'L2Merchant', 40, 4608, 1896, 67.15, 3.09, 40, 43, 30, 21, 20, 10, 8042, 913, 1863, 587, 1182, 477, 278, 150, 333, 0, 0, 0, 77, 154, 'fire_clan', 300, 0, 0, 'LAST_HIT');

 

insert into custom_npc values

(50020, 30298, 'Augmenter', 1, 'L2Frozen', 1, 'NPC.a_smith_MDwarf', 7.00, 16.50, 70, 'male', 'L2Trainer', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 333, 89, 0, 0, 55, 132, '', 0, 1, 0, 'LAST_HIT');