Prime Shop (Fissban)

[Swarlog]

CORE:

Código [Seleccionar] Expandir

diff --git a/L2J_Server/dist/libs/._L2J_GeoDriver.jar3291838113424536152.tmp b/L2J_Server/dist/libs/._L2J_GeoDriver.jar3291838113424536152.tmp
new file mode 100644
index 0000000..ae15f5e
--- /dev/null
+++ b/L2J_Server/dist/libs/._L2J_GeoDriver.jar3291838113424536152.tmp
Binary files differ
diff --git a/L2J_Server/java/com/l2jserver/gameserver/GameServer.java b/L2J_Server/java/com/l2jserver/gameserver/GameServer.java
index 25de90c..ff23b33 100644
--- a/L2J_Server/java/com/l2jserver/gameserver/GameServer.java
+++ b/L2J_Server/java/com/l2jserver/gameserver/GameServer.java
@@ -83,6 +83,7 @@
 import com.l2jserver.gameserver.datatables.EventDroplist;
 import com.l2jserver.gameserver.datatables.ItemTable;
 import com.l2jserver.gameserver.datatables.MerchantPriceConfigTable;
+import com.l2jserver.gameserver.datatables.PrimeShopTable;
 import com.l2jserver.gameserver.datatables.SkillData;
 import com.l2jserver.gameserver.datatables.SpawnTable;
 import com.l2jserver.gameserver.handler.EffectHandler;
@@ -229,6 +230,9 @@
  FishingRodsData.getInstance();
  HennaData.getInstance();
 
+ // PrimeShop
+ PrimeShopTable.getInstance();
+
  printSection("Characters");
  ClassListData.getInstance();
  InitialEquipmentData.getInstance();
diff --git a/L2J_Server/java/com/l2jserver/gameserver/datatables/PrimeShopTable.java b/L2J_Server/java/com/l2jserver/gameserver/datatables/PrimeShopTable.java
new file mode 100644
index 0000000..d89dbb2
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/datatables/PrimeShopTable.java
@@ -0,0 +1,492 @@
+package com.l2jserver.gameserver.datatables;
+
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.text.DateFormat;
+import java.text.SimpleDateFormat;
+import java.util.Calendar;
+import java.util.Date;
+import java.util.HashMap;
+import java.util.Map;
+import java.util.logging.Level;
+import java.util.logging.Logger;
+
+import org.w3c.dom.Document;
+import org.w3c.dom.NamedNodeMap;
+import org.w3c.dom.Node;
+
+import com.l2jserver.Config;
+import com.l2jserver.L2DatabaseFactory;
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+import com.l2jserver.gameserver.model.items.L2Item;
+import com.l2jserver.gameserver.network.serverpackets.ExBrBuyProduct;
+import com.l2jserver.gameserver.network.serverpackets.ExBrProductInfo;
+import com.l2jserver.gameserver.util.Util;
+import com.l2jserver.util.data.xml.IXmlReader;
+
+/**
+ * @author fissban
+ */
+public class PrimeShopTable implements IXmlReader
+{
+ private static final Logger _log = Logger.getLogger(PrimeShopTable.class.getName());
+
+ private final Map<Integer, PrimeShopItem> _primeItems = new HashMap<>();
+
+ public final int BR_BUY_SUCCESS = 1;
+ public final int BR_BUY_LACK_OF_POINT = -1;
+ public final int BR_BUY_INVALID_PRODUCT = -2;
+ public final int BR_BUY_USER_CANCEL = -3;
+ public final int BR_BUY_INVENTROY_OVERFLOW = -4;
+ public final int BR_BUY_CLOSED_PRODUCT = -5;
+ public final int BR_BUY_SERVER_ERROR = -6;
+ public final int BR_BUY_BEFORE_SALE_DATE = -7;
+ public final int BR_BUY_AFTER_SALE_DATE = -8;
+ public final int BR_BUY_INVALID_USER = -9;
+ public final int BR_BUY_INVALID_ITEM = -10;
+ public final int BR_BUY_INVALID_USER_STATE = -11;
+ public final int BR_BUY_NOT_DAY_OF_WEEK = -12;
+ public final int BR_BUY_NOT_TIME_OF_DAY = -13;
+ public final int BR_BUY_SOLD_OUT = -14;
+
+ public PrimeShopTable()
+ {
+ load();
+ }
+
+ @Override
+ public void load()
+ {
+ _primeItems.clear();
+ parseDatapackFile("data/PrimeShop.xml");
+ }
+
+ public final void reload()
+ {
+ _primeItems.clear();
+ load();
+ }
+
+ @Override
+ public void parseDocument(Document doc)
+ {
+ for (Node a = doc.getFirstChild(); a != null; a = a.getNextSibling())
+ {
+ if (!"list".equalsIgnoreCase(a.getNodeName()))
+ {
+ continue;
+ }
+ for (Node b = a.getFirstChild(); b != null; b = b.getNextSibling())
+ {
+ if (!"item".equalsIgnoreCase(b.getNodeName()))
+ {
+ continue;
+ }
+ NamedNodeMap attrs = b.getAttributes();
+
+ int type = 0;
+
+ Node att = attrs.getNamedItem("brId");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing brId, skipping");
+ continue;
+ }
+ final int brId = Integer.parseInt(att.getNodeValue());
+
+ att = attrs.getNamedItem("itemId");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing itemId, skipping");
+ continue;
+ }
+ final int itemId = Integer.parseInt(att.getNodeValue());
+
+ att = attrs.getNamedItem("cat");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing category, skipping");
+ continue;
+ }
+ final int cat = Integer.parseInt(att.getNodeValue());
+
+ att = attrs.getNamedItem("price");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing price, skipping");
+ continue;
+ }
+ final int price = Integer.parseInt(att.getNodeValue());
+
+ att = attrs.getNamedItem("count");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing count, skipping");
+ continue;
+ }
+ final int count = Integer.parseInt(att.getNodeValue());
+
+ att = attrs.getNamedItem("event");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing event, skipping");
+ continue;
+ }
+ final boolean event = Boolean.parseBoolean(att.getNodeValue());
+
+ att = attrs.getNamedItem("best");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing best, skipping");
+ continue;
+ }
+ final boolean best = Boolean.parseBoolean(att.getNodeValue());
+
+ if (event)
+ {
+ type++;
+ }
+ if (best)
+ {
+ type += 2;
+ }
+ L2Item item = ItemTable.getInstance().getTemplate(itemId);
+ if (item == null)
+ {
+ _log.severe("[PrimeShop] Item template null");
+ }
+ else
+ {
+ att = attrs.getNamedItem("sale_start_date");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing brId, skipping");
+ continue;
+ }
+ final String sale_start_date = att.getNodeValue();
+
+ att = attrs.getNamedItem("sale_end_date");
+ if (att == null)
+ {
+ _log.severe("[PrimeShop] Missing brId, skipping");
+ continue;
+ }
+ final String sale_end_date = att.getNodeValue();
+
+ _primeItems.put(Integer.valueOf(brId), new PrimeShopItem(itemId, cat, price, count, item.getWeight(), item.isTradeable(), type, sale_start_date, sale_end_date));
+ }
+ }
+ }
+
+ if (_primeItems.size() > 0)
+ {
+ _log.info("[PrimeShop] Loaded: " + _primeItems.size() + " items");
+ }
+ }
+
+ public int getMaxStock(int brId)
+ {
+ int maxStock = 0;
+
+ try (Connection con = L2DatabaseFactory.getInstance().getConnection();
+ PreparedStatement statement = con.prepareStatement("SELECT maxStock FROM primeshop WHERE brId=" + brId))
+ {
+ try (ResultSet rset = statement.executeQuery())
+ {
+ while (rset.next())
+ {
+ return maxStock = rset.getInt("maxStock");
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ _log.log(Level.WARNING, "Exception: error while loading get stock for product: " + brId + e, e);
+ }
+ return maxStock;
+ }
+
+ public int getActualStock(int brId)
+ {
+ int getActualStock = 0;
+
+ try (Connection con = L2DatabaseFactory.getInstance().getConnection();
+ PreparedStatement statement = con.prepareStatement("SELECT getStock FROM primeshop WHERE brId=?"))
+ {
+ statement.setInt(1, brId);
+ try (ResultSet rset = statement.executeQuery())
+ {
+ while (rset.next())
+ {
+ return getActualStock = rset.getInt("getStock");
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ _log.log(Level.WARNING, "Exception: error while loading actual stock for product: " + brId + e, e);
+ }
+ return getActualStock;
+ }
+
+ public void discountStock(int brId, int Stock, int count)
+ {
+ Stock += count;
+
+ try (Connection con = L2DatabaseFactory.getInstance().getConnection();
+ PreparedStatement statement = con.prepareStatement("UPDATE primeshop SET getStock=? WHERE brId=?"))
+ {
+ statement.setInt(1, Stock);
+ statement.setInt(2, brId);
+ statement.execute();
+ }
+ catch (Exception e)
+ {
+ e.printStackTrace();
+ }
+ }
+
+ public void buyItem(L2PcInstance player, int brId, int count)
+ {
+ if ((count < 1) && (count > 99))
+ {
+ Util.handleIllegalPlayerAction(player, "Player " + player.getName() + " tried to buy invalid itemcount [" + count + "] from Prime", Config.DEFAULT_PUNISH);
+ return;
+ }
+
+ int Stock = getActualStock(brId);
+ int MaxStock = getMaxStock(brId);
+
+ if (MaxStock != 0) // TODO solo sale 0 cuando no tienen maximo de stock
+ {
+ if ((MaxStock - Stock) < count)
+ {
+ player.sendPacket(new ExBrBuyProduct(-14)); // TODO no puede comprar tantos items
+ return;
+ }
+ }
+
+ if (_primeItems.containsKey(Integer.valueOf(brId)))
+ {
+ PrimeShopItem item = _primeItems.get(Integer.valueOf(brId));
+
+ long points = player.getGamePoints();
+
+ // TODO hace falta poner las 2 condiciones? quizas solo con la segunda y sin el && ultimo deberia funcionar
+ if (points >= (item.getPrimeItemPrice() * count))
+ {
+ L2Item dummy = ItemTable.getInstance().getTemplate(item.getPrimeItemId());
+ if (dummy != null)
+ {
+ int weight = item.getPrimeItemCount() * item.getPrimeWeight() * count;
+
+ if (player.getInventory().validateWeight(weight))
+ {
+ int slots = 0;
+ if (dummy.isStackable())
+ {
+ slots = 1;
+ }
+ else
+ {
+ slots = item.getPrimeItemCount() * count;
+ }
+ if (player.getInventory().validateCapacity(slots))
+ {
+ if (player.addItem("PrimeShop", item.getPrimeItemId(), count * item.getPrimeItemCount(), player, true) != null)
+ {
+ player.sendPacket(new ExBrBuyProduct(1));
+
+ player.setGamePoints(player.getGamePoints() - (item.getPrimeItemPrice() * count));
+
+ if (MaxStock != 0)
+ {
+ discountStock(brId, Stock, count);
+ }
+ }
+ else
+ {
+ player.sendPacket(new ExBrBuyProduct(-6));
+ }
+ }
+ else
+ {
+ player.sendPacket(new ExBrBuyProduct(-4));
+ }
+ }
+ else
+ {
+ player.sendPacket(new ExBrBuyProduct(-4));
+ }
+ }
+ else
+ {
+ player.sendPacket(new ExBrBuyProduct(-6));
+ }
+ }
+ else
+ {
+ player.sendPacket(new ExBrBuyProduct(-1));
+ }
+ }
+ else
+ {
+ player.sendPacket(new ExBrBuyProduct(-2));
+ Util.handleIllegalPlayerAction(player, "Player " + player.getName() + " tried to buy invalid brId from Prime", Config.DEFAULT_PUNISH);
+ }
+ }
+
+ public void showProductInfo(L2PcInstance player, int itemId)
+ {
+ if ((player == null) || (itemId == 0))
+ {
+ return;
+ }
+ if (_primeItems.containsKey(itemId))
+ {
+ PrimeShopItem item = _primeItems.get(itemId);
+
+ player.sendPacket(new ExBrProductInfo(itemId, item));
+ }
+ }
+
+ public Map<Integer, PrimeShopItem> getPrimeItems()
+ {
+ return _primeItems;
+ }
+
+ public class PrimeShopItem
+ {
+ int _itemId;
+ int _category;
+ int _price;
+ int _count;
+ int _weight;
+ int _tradable;
+ int _type;
+
+ long _sale_start_date;
+ long _sale_end_date;
+
+ int _startHour;
+ int _endHour;
+ int _startMin;
+ int _endMin;
+
+ public PrimeShopItem(int itemId, int category, int price, int count, int weight, boolean tradable, int type, String sale_start_date, String sale_end_date)
+ {
+ new Date().getTime();
+
+ _itemId = itemId;
+ _category = category;
+ _price = price;
+ _weight = weight;
+ _count = count;
+ _tradable = (tradable ? 1 : 0);
+ _type = type;
+
+ DateFormat df = new SimpleDateFormat("yyyy.MM.dd HH:mm");
+ try
+ {
+ Date time_start = df.parse(sale_start_date);
+ Date time_end = df.parse(sale_end_date);
+ Calendar calendar = Calendar.getInstance();
+
+ calendar.setTime(time_start);
+ _sale_start_date = time_start.getTime();
+ _startHour = calendar.get(Calendar.HOUR_OF_DAY);
+ _startMin = calendar.get(Calendar.MINUTE);
+
+ calendar.setTime(time_end);
+ _sale_end_date = time_end.getTime();
+ _endHour = calendar.get(Calendar.HOUR_OF_DAY);
+ _endMin = calendar.get(Calendar.MINUTE);
+ }
+ catch (Exception e)
+ {
+ e.printStackTrace();
+ }
+ }
+
+ public int getPrimeItemId()
+ {
+ return _itemId;
+ }
+
+ public int getPrimeItemCat()
+ {
+ return _category;
+ }
+
+ public int getPrimeItemPrice()
+ {
+ return _price;
+ }
+
+ public int getPrimeItemCount()
+ {
+ return _count;
+ }
+
+ public int getPrimeWeight()
+ {
+ return _weight;
+ }
+
+ public int getPrimeTradable()
+ {
+ return _tradable;
+ }
+
+ public long sale_start_date()
+ {
+ return _sale_start_date;
+ }
+
+ public long sale_end_date()
+ {
+ return _sale_end_date;
+ }
+
+ public int getStartHour()
+ {
+ return _startHour;
+ }
+
+ public int getStartMin()
+ {
+ return _startMin;
+ }
+
+ public int getEndHour()
+ {
+ return _endHour;
+ }
+
+ public int getEndMin()
+ {
+ return _endMin;
+ }
+
+ public int getPrimeType()
+ {
+ return _type;
+ }
+ }
+
+ public PrimeShopItem getProduct(int id)
+ {
+ return _primeItems.get(id);
+ }
+
+ public static PrimeShopTable getInstance()
+ {
+ return SingletonHolder._instance;
+ }
+
+ private static class SingletonHolder
+ {
+ protected static final PrimeShopTable _instance = new PrimeShopTable();
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java b/L2J_Server/java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java
index ebe0026..3e2aaf0 100644
--- a/L2J_Server/java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java
+++ b/L2J_Server/java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java
@@ -354,7 +354,7 @@
 
  // Character Character SQL String Definitions:
  private static final String INSERT_CHARACTER = "INSERT INTO characters (account_name,charId,char_name,level,maxHp,curHp,maxCp,curCp,maxMp,curMp,face,hairStyle,hairColor,sex,exp,sp,karma,fame,pvpkills,pkkills,clanid,race,classid,deletetime,cancraft,title,title_color,accesslevel,online,isin7sdungeon,clan_privs,wantspeace,base_class,newbie,nobless,power_grade,createDate) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
- private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,sex=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,fame=?,pvpkills=?,pkkills=?,clanid=?,race=?,classid=?,deletetime=?,title=?,title_color=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,newbie=?,nobless=?,power_grade=?,subpledge=?,lvl_joined_academy=?,apprentice=?,sponsor=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=?,bookmarkslot=?,vitality_points=?,language=? WHERE charId=?";
+ private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,sex=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,fame=?,pvpkills=?,pkkills=?,clanid=?,race=?,classid=?,deletetime=?,title=?,title_color=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,newbie=?,nobless=?,power_grade=?,subpledge=?,lvl_joined_academy=?,apprentice=?,sponsor=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=?,bookmarkslot=?,vitality_points=?,language=?,game_points=? WHERE charId=?";
  private static final String RESTORE_CHARACTER = "SELECT * FROM characters WHERE charId=?";
 
  // Character Teleport Bookmark:
@@ -6928,6 +6928,9 @@
  // Language
  player.setLang(rset.getString("language"));
 
+ // PrimeShop
+ player.setGamePoints(rset.getLong("game_points"));
+
  // Retrieve the name and ID of the other characters assigned to this account.
  try (PreparedStatement stmt = con.prepareStatement("SELECT charId, char_name FROM characters WHERE account_name=? AND charId<>?"))
  {
@@ -7365,6 +7368,7 @@
  statement.setInt(48, getVitalityPoints());
  statement.setString(49, getLang());
  statement.setInt(50, getObjectId());
+ statement.setLong(51, getGamePoints()); // PrimeShop
 
  statement.execute();
  }
@@ -14407,4 +14411,19 @@
  {
  return (getSiegeState() > 0) && isInsideZone(ZoneId.SIEGE) && (getSiegeState() == target.getSiegeState()) && (getSiegeSide() == target.getSiegeSide());
  }
+
+ // PrimeShop
+ private long _gamePoints;
+
+ // PrimeShop
+ public long getGamePoints()
+ {
+ return _gamePoints;
+ }
+
+ // PrimeShop
+ public void setGamePoints(long gamePoints)
+ {
+ _gamePoints = gamePoints;
+ }
 }
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrBuyProduct.java b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrBuyProduct.java
new file mode 100644
index 0000000..a75c6d6
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrBuyProduct.java
@@ -0,0 +1,38 @@
+package com.l2jserver.gameserver.network.clientpackets;
+
+import com.l2jserver.gameserver.datatables.PrimeShopTable;
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+
+/**
+ * @author fissban
+ */
+public class RequestBrBuyProduct extends L2GameClientPacket
+{
+ private static final String TYPE = "[C] D0:8C RequestBrBuyProduct";
+
+ private int _product_id;
+ private int _count;
+
+ @Override
+ protected void readImpl()
+ {
+ _product_id = readD();
+ _count = readD();
+ }
+
+ @Override
+ protected void runImpl()
+ {
+ L2PcInstance player = getClient().getActiveChar();
+ if (player != null)
+ {
+ PrimeShopTable.getInstance().buyItem(player, _product_id, _count);
+ }
+ }
+
+ @Override
+ public String getType()
+ {
+ return TYPE;
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrGamePoint.java b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrGamePoint.java
new file mode 100644
index 0000000..7b9ce42
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrGamePoint.java
@@ -0,0 +1,33 @@
+package com.l2jserver.gameserver.network.clientpackets;
+
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+import com.l2jserver.gameserver.network.serverpackets.ExBrGamePoint;
+
+/**
+ * @author fissban
+ */
+public class RequestBrGamePoint extends L2GameClientPacket
+{
+ private static final String TYPE = "[C] D0:89 RequestBrGamePoint";
+
+ @Override
+ protected void readImpl()
+ {
+ }
+
+ @Override
+ protected void runImpl()
+ {
+ L2PcInstance player = getClient().getActiveChar();
+ if (player != null)
+ {
+ player.sendPacket(new ExBrGamePoint(player));
+ }
+ }
+
+ @Override
+ public String getType()
+ {
+ return TYPE;
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrProductInfo.java b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrProductInfo.java
new file mode 100644
index 0000000..67b4bcf
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrProductInfo.java
@@ -0,0 +1,36 @@
+package com.l2jserver.gameserver.network.clientpackets;
+
+import com.l2jserver.gameserver.datatables.PrimeShopTable;
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+
+/**
+ * @author fissban
+ */
+public class RequestBrProductInfo extends L2GameClientPacket
+{
+ private static final String TYPE = "[C] D0:8B RequestBrProductInfo";
+
+ private int _brId;
+
+ @Override
+ protected void readImpl()
+ {
+ _brId = readD();
+ }
+
+ @Override
+ protected void runImpl()
+ {
+ L2PcInstance player = getClient().getActiveChar();
+ if (player != null)
+ {
+ PrimeShopTable.getInstance().showProductInfo(player, _brId);
+ }
+ }
+
+ @Override
+ public String getType()
+ {
+ return TYPE;
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrProductList.java b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrProductList.java
new file mode 100644
index 0000000..d806c44
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/clientpackets/RequestBrProductList.java
@@ -0,0 +1,33 @@
+package com.l2jserver.gameserver.network.clientpackets;
+
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+import com.l2jserver.gameserver.network.serverpackets.ExBrProductList;
+
+/**
+ * @author fissban
+ */
+public class RequestBrProductList extends L2GameClientPacket
+{
+ private static final String TYPE = "[C] D0:89 RequestBrProductList";
+
+ @Override
+ protected void readImpl()
+ {
+ }
+
+ @Override
+ protected void runImpl()
+ {
+ L2PcInstance player = getClient().getActiveChar();
+ if (player != null)
+ {
+ player.sendPacket(new ExBrProductList());
+ }
+ }
+
+ @Override
+ public String getType()
+ {
+ return TYPE;
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrBuyProduct.java b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrBuyProduct.java
new file mode 100644
index 0000000..1b24261
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrBuyProduct.java
@@ -0,0 +1,22 @@
+package com.l2jserver.gameserver.network.serverpackets;
+
+/**
+ * @author fissban
+ */
+public class ExBrBuyProduct extends L2GameServerPacket
+{
+ private final int _result;
+
+ public ExBrBuyProduct(int result)
+ {
+ _result = result;
+ }
+
+ @Override
+ protected void writeImpl()
+ {
+ writeC(0xFE);
+ writeH(0xD8);
+ writeD(_result);
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrGamePoint.java b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrGamePoint.java
new file mode 100644
index 0000000..1c87422
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrGamePoint.java
@@ -0,0 +1,28 @@
+package com.l2jserver.gameserver.network.serverpackets;
+
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+
+/**
+ * @author fissban
+ */
+public class ExBrGamePoint extends L2GameServerPacket
+{
+ private final int _objId;
+ private final long _points;
+
+ public ExBrGamePoint(L2PcInstance player)
+ {
+ _objId = player.getObjectId();
+ _points = player.getGamePoints();
+ }
+
+ @Override
+ public void writeImpl()
+ {
+ writeC(0xFE);
+ writeH(0xD5);
+ writeD(_objId);
+ writeQ(_points);
+ writeD(0x00); // ??
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrProductInfo.java b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrProductInfo.java
new file mode 100644
index 0000000..df346c7
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrProductInfo.java
@@ -0,0 +1,44 @@
+package com.l2jserver.gameserver.network.serverpackets;
+
+import com.l2jserver.gameserver.datatables.PrimeShopTable.PrimeShopItem;
+
+/**
+ * @author fissban
+ */
+public class ExBrProductInfo extends L2GameServerPacket
+{
+ private final int _brId;
+ private final int _price;
+ private final int _cat;
+ private final int _itemId;
+ private final int _count;
+ private final int _weight;
+ private final int _tradable;
+
+ public ExBrProductInfo(int brId, PrimeShopItem item)
+ {
+ _brId = brId;
+ _price = item.getPrimeItemPrice();
+ _cat = item.getPrimeItemCat();
+ _itemId = item.getPrimeItemId();
+ _count = item.getPrimeItemCount();
+ _weight = item.getPrimeWeight();
+ _tradable = item.getPrimeTradable();
+ }
+
+ @Override
+ protected void writeImpl()
+ {
+
+ writeC(0xFE);
+ writeH(0xD7);
+
+ writeD(_brId); // product id
+ writeD(_price); // points
+ writeD(_cat); // cat
+ writeD(_itemId); // item id
+ writeD(_count); // quality
+ writeD(_weight); // weight
+ writeD(_tradable); // 0 - dont drop/trade
+ }
+}
\ No newline at end of file
diff --git a/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrProductList.java b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrProductList.java
new file mode 100644
index 0000000..9c8e6ee
--- /dev/null
+++ b/L2J_Server/java/com/l2jserver/gameserver/network/serverpackets/ExBrProductList.java
@@ -0,0 +1,53 @@
+package com.l2jserver.gameserver.network.serverpackets;
+
+import java.util.Map;
+import java.util.Map.Entry;
+
+import com.l2jserver.gameserver.datatables.PrimeShopTable;
+import com.l2jserver.gameserver.datatables.PrimeShopTable.PrimeShopItem;
+
+/**
+ * @author fissban
+ */
+public class ExBrProductList extends L2GameServerPacket
+{
+ private final Map<Integer, PrimeShopItem> primeList;
+
+ public ExBrProductList()
+ {
+ primeList = PrimeShopTable.getInstance().getPrimeItems();
+
+ }
+
+ @Override
+ protected void writeImpl()
+ {
+ writeC(0xFE);
+ writeH(0xD6);
+ writeD(primeList.size());
+
+ for (Entry<Integer, PrimeShopItem> entrySet : primeList.entrySet())
+ {
+ PrimeShopItem item = entrySet.getValue();
+ if ((System.currentTimeMillis() >= item.sale_start_date()) && (System.currentTimeMillis() <= item.sale_end_date()))
+ {
+ int brId = entrySet.getKey().intValue();
+
+ writeD(brId); // product id
+ writeH(item.getPrimeItemCat()); // category 1 - enchant 2 - supplies 3 - decoration 4 - package 5 - other
+ writeD(item.getPrimeItemPrice()); // points
+ writeD(item.getPrimeType());// show tab 2-th group - 1 ?????????? ?????? ??? ???? 1 - event 2 - best 3 - event & best
+ writeD((int) (item.sale_start_date() / 1000)); // start sale
+ writeD((int) (item.sale_end_date() / 1000)); // end sale
+ writeC(1); // day week... necesita revisarse (0x00)
+ writeC(item.getStartHour()); // start hour
+ writeC(item.getStartMin()); // start min
+ writeC(item.getEndHour()); // end hour
+ writeC(item.getEndMin()); // end min
+
+ writeD(PrimeShopTable.getInstance().getActualStock(brId)); // current stock
+ writeD(PrimeShopTable.getInstance().getMaxStock(brId)); // max stock
+ }
+ }
+ }
+}
\ No newline at end of file

DATA:

Código [Seleccionar] Expandir

diff --git a/L2J_DataPack/dist/game/data/PrimeShop.xml b/L2J_DataPack/dist/game/data/PrimeShop.xml
new file mode 100644
index 0000000..5306292
--- /dev/null
+++ b/L2J_DataPack/dist/game/data/PrimeShop.xml
@@ -0,0 +1,188 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--    Categories :    -->
+<!-- 1 - enchant -->
+<!-- 2 - supplies -->
+<!-- 3 - decorating -->
+<!-- 4 - package -->
+<!-- 5 - others -->
+
+<!-- brId = ProductName-e.dat -->
+<!-- itemId = ItemName.dat -->
+<list xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="xsd/primeShop.xsd">
+
+ <!-- OTHERS -->
+ <!-- Small fortuna box -->
+ <item brId="1080001" itemId="22000" count="1" cat="5" price="1" event="false" best="true" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Middle fortuna box -->
+ <item brId="1080002" itemId="22001" count="1" cat="5" price="1" event="false" best="true" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Large fortuna box -->
+ <item brId="1080003" itemId="22002" count="1" cat="5" price="1" event="false" best="true" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Small fortuna cube -->
+ <item brId="1080004" itemId="22003" count="1" cat="5" price="1" event="false" best="true" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Middle fortuna cube -->
+ <item brId="1080005" itemId="22004" count="1" cat="5" price="1" event="false" best="true" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Large fortuna cube -->
+ <item brId="1080006" itemId="22005" count="1" cat="5" price="1" event="false" best="true" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+
+
+ <!-- SUPPLIES -->
+ <!-- Powerful Healing Potion -->
+ <item brId="1080007" itemId="22025" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- High-grade Healing Potion -->
+ <item brId="1080008" itemId="22026" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Will - D grade -->
+ <item brId="1080009" itemId="22027" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Will - C grade -->
+ <item brId="1080010" itemId="22028" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Will - B grade -->
+ <item brId="1080011" itemId="22029" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Will - A grade -->
+ <item brId="1080012" itemId="22030" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Will - S grade -->
+ <item brId="1080013" itemId="22031" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Life - D grade -->
+ <item brId="1080014" itemId="22032" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Life - C grade -->
+ <item brId="1080015" itemId="22033" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Life - B grade -->
+ <item brId="1080016" itemId="22034" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Life - A grade -->
+ <item brId="1080017" itemId="22035" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Secret medicine of Life - S grade -->
+ <item brId="1080018" itemId="22036" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Potion of Will -->
+ <item brId="1080019" itemId="22037" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Healing medicine for Mana -->
+ <item brId="1080020" itemId="22038" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Sweet Fruit Cocktail -->
+ <item brId="1080199" itemId="20393" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Fresh Fruit Cocktail -->
+ <item brId="1080200" itemId="20394" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+
+
+ <!-- SUPPLIES -->
+ <!-- Wind Walk Scroll -->
+ <item brId="1080021" itemId="22039" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Haste Scroll -->
+ <item brId="1080022" itemId="22040" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Might Scroll -->
+ <item brId="1080023" itemId="22041" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Shield Scroll -->
+ <item brId="1080024" itemId="22042" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Death Whisper Scroll -->
+ <item brId="1080025" itemId="22043" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Guidance Scroll -->
+ <item brId="1080026" itemId="22044" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Empower Scrol -->
+ <item brId="1080027" itemId="22045" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Grater Acumen Scroll -->
+ <item brId="1080028" itemId="22046" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Vampiric Rage Scroll -->
+ <item brId="1080029" itemId="22047" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Bless the Body Scroll -->
+ <item brId="1080030" itemId="22048" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Berserker Spirit Scroll -->
+ <item brId="1080031" itemId="22049" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Magic Barrier Scroll -->
+ <item brId="1080032" itemId="22050" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Bless the Soul Scrol -->
+ <item brId="1080033" itemId="22051" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Clarity Scroll -->
+ <item brId="1080034" itemId="22052" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Wild Magic Scroll -->
+ <item brId="1080035" itemId="22053" count="1" cat="2" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+
+
+ <!-- EVENT -->
+ <!-- Rune of Experience Points 24hs -->
+ <item brId="1080036" itemId="22054" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Rune of Experience Points 168hs -->
+ <item brId="1080037" itemId="22055" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Rune of Experience Points 336hs -->
+ <item brId="1080038" itemId="22056" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Rune of Experience Points 720hs -->
+ <item brId="1080039" itemId="22057" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Rune of SP 24hs -->
+ <item brId="1080040" itemId="22058" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Rune of SP 168hs -->
+ <item brId="1080041" itemId="22059" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Rune of SP 336hs -->
+ <item brId="1080042" itemId="22060" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Rune of SP 720hs -->
+ <item brId="1080043" itemId="22061" count="1" cat="5" price="1" event="true" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+
+
+ <!-- PACKAGE -->
+ <!-- Bone Bolt Container -->
+ <item brId="1080056" itemId="22149" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Steel Bolt Container -->
+ <item brId="1080057" itemId="22150" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Silver Bolt Container -->
+ <item brId="1080058" itemId="22151" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Mithril Bolt Containe -->
+ <item brId="1080059" itemId="22152" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Bolt Container of Light -->
+ <item brId="1080060" itemId="22153" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Blessed Spiritshot Pack - D grade -->
+ <item brId="1080061" itemId="22094" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Blessed Spiritshot Pack - C grade -->
+ <item brId="1080062" itemId="22095" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Blessed Spiritshot Pack - B grade -->
+ <item brId="1080063" itemId="22096" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Blessed Spiritshot Pack - A grade -->
+ <item brId="1080063" itemId="22097" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Blessed Spiritshot Pack - S grade -->
+ <item brId="1080063" itemId="22098" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Soulshot Pack - D grade -->
+ <item brId="1080071" itemId="22104" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Soulshot Pack - C grade -->
+ <item brId="1080072" itemId="22105" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Soulshot Pack - B grade -->
+ <item brId="1080073" itemId="22106" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Soulshot Pack - A grade -->
+ <item brId="1080074" itemId="22107" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Soulshot Pack - S grade -->
+ <item brId="1080075" itemId="22108" count="1" cat="4" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+
+
+ <!-- ENCHANT -->
+ <!-- Weapon-type Enhance Backup Stone (D-Grade) -->
+ <item brId="1080130" itemId="12362" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Weapon-type Enhance Backup Stone (C-Grade) -->
+ <item brId="1080131" itemId="12363" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Weapon-type Enhance Backup Stone (B-Grade) -->
+ <item brId="1080132" itemId="12364" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Weapon-type Enhance Backup Stone (A-Grade) -->
+ <item brId="1080133" itemId="12365" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Weapon-type Enhance Backup Stone (S-Grade) -->
+ <item brId="1080134" itemId="12366" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Armor-type Enhance Backup Stone (D-Grade) -->
+ <item brId="1080135" itemId="12367" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Armor-type Enhance Backup Stone (C-Grade) -->
+ <item brId="1080136" itemId="12368" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Armor-type Enhance Backup Stone (B-Grade) -->
+ <item brId="1080137" itemId="12369" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Armor-type Enhance Backup Stone (A-Grade) -->
+ <item brId="1080138" itemId="12370" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Armor-type Enhance Backup Stone (S-Grade) -->
+ <item brId="1080139" itemId="12380" count="1" cat="1" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+
+
+ <!-- DECORATING -->
+ <!-- Color Name -->
+ <item brId="1030032" itemId="13021" count="1" cat="3" price="1" event="false" best="true" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Uniform Hat -->
+ <item brId="1030068" itemId="20020" count="1" cat="3" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Napoleon Hat -->
+ <item brId="1030069" itemId="20322" count="1" cat="3" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Popped-Out Eye -->
+ <item brId="1030070" itemId="13491" count="1" cat="3" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Halloween Hat -->
+ <item brId="1030076" itemId="13489" count="1" cat="3" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Kai the Cat Hat -->
+ <item brId="1030080" itemId="20501" count="1" cat="3" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Afro Hair Pack - Gold -->
+ <item brId="1030038" itemId="20278" count="1" cat="3" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+ <!-- Afro Hair Pack - Pink -->
+ <item brId="1030039" itemId="20279" count="1" cat="3" price="1" event="false" best="false" sale_start_date="2000.10.07 12:00" sale_end_date="2014.11.08 18:00" />
+</list>
\ No newline at end of file
diff --git a/L2J_DataPack/dist/game/data/scripts/custom/prueba/Prueba.java b/L2J_DataPack/dist/game/data/scripts/custom/prueba/Prueba.java
new file mode 100644
index 0000000..3e2ac7d
--- /dev/null
+++ b/L2J_DataPack/dist/game/data/scripts/custom/prueba/Prueba.java
@@ -0,0 +1,146 @@
+/*
+ * Copyright (C) 2004-2015 L2J DataPack
+ *
+ * This file is part of L2J DataPack.
+ *
+ * L2J DataPack 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.
+ *
+ * L2J DataPack 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 custom.prueba;
+
+import java.util.List;
+import java.util.concurrent.CopyOnWriteArrayList;
+
+import com.l2jserver.gameserver.ai.CtrlIntention;
+import com.l2jserver.gameserver.model.Location;
+import com.l2jserver.gameserver.model.actor.L2Attackable;
+import com.l2jserver.gameserver.model.actor.L2Npc;
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+import com.l2jserver.gameserver.model.quest.Quest;
+
+/**
+ * @author fissban
+ */
+public class Prueba extends Quest
+{
+ // mob custom
+ private static final int MOB = 22840;
+ private static final int MOB_COUNT = 5;
+ // loc A
+ private static final Location LOC_A = new Location(82852, 149346, -3467);
+ // loc B
+ private static final Location LOC_B = new Location(82782, 147808, -3470);
+ // rango de ataque
+ private static final int RANGE = 300;
+ // instance npc
+ private final List<L2Npc> _mobList = new CopyOnWriteArrayList<>();
+
+ public Prueba()
+ {
+ super(-1, Prueba.class.getSimpleName(), "custom");
+
+ addStartNpc(MOB);
+ addTalkId(MOB);
+ addAttackId(MOB);
+
+ startQuestTimer("spawn_mobs", 20000, null, null, true); // 20 seg de spawn
+ }
+
+ @Override
+ public String onAdvEvent(String event, L2Npc npc, L2PcInstance player)
+ {
+ switch (event)
+ {
+ case "spawn_mobs":
+ for (int cont = 0; cont < MOB_COUNT; cont++)
+ {
+ L2Npc mobs = addSpawn(MOB, LOC_A);
+
+ _mobList.add(mobs);
+
+ mobs.setIsNoRndWalk(true);
+ mobs.setIsRunning(false);
+ }
+
+ startQuestTimer("mobs_ai", 100, null, null, true);
+ startQuestTimer("delete_npc", 100, null, null, true);
+ break;
+
+ case "mobs_ai":
+ for (L2Npc mob : _mobList)
+ {
+ // si ya tiene target...lo dejamos q termine
+ if (mob.getTarget() != null)
+ {
+ continue;
+ }
+
+ for (L2PcInstance victim : mob.getKnownList().getKnownPlayersInRadius(RANGE))
+ {
+ // si ya tiene target...lo dejamos con el q tiene.
+ if (mob.getTarget() != null)
+ {
+ continue;
+ }
+
+ npc.getAI().stopAITask();
+ npc.setTarget(player);
+ npc.setIsRunning(true);
+ ((L2Attackable) npc).addDamageHate(victim, 0, 99999);
+ npc.getAI().setIntention(CtrlIntention.AI_INTENTION_ATTACK, victim);
+ }
+
+ // si el mobs aun continua sin target lo hacemos caminar
+ if (mob.getTarget() == null)
+ {
+ mob.setIsRunning(false);
+ mob.getAI().stopAITask();
+ mob.getAI().setIntention(CtrlIntention.AI_INTENTION_MOVE_TO, LOC_B);
+ }
+ }
+
+ break;
+
+ case "delete_npc":
+ for (L2Npc mobsAttack : _mobList)
+ {
+ if (mobsAttack.isAttackingNow())
+ {
+ _mobList.remove(mobsAttack);
+ // delete npc
+ mobsAttack.getSpawn().stopRespawn();
+ mobsAttack.deleteMe();
+ }
+ }
+
+ break;
+
+ }
+
+ return null;
+ }
+
+ @Override
+ public String onAttack(L2Npc npc, L2PcInstance attacker, int damage, boolean isSummon)
+ {
+ _mobList.remove(npc);
+ npc.getSpawn().stopRespawn();
+ npc.deleteMe();
+ return null;
+ }
+
+ public static void main(String[] args)
+ {
+ new Prueba();
+ }
+}
diff --git a/L2J_DataPack/dist/game/data/xsd/primeShop.xsd b/L2J_DataPack/dist/game/data/xsd/primeShop.xsd
new file mode 100644
index 0000000..86a6f0f
--- /dev/null
+++ b/L2J_DataPack/dist/game/data/xsd/primeShop.xsd
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
+ <xs:element name="list">
+ <xs:complexType>
+ <xs:sequence minOccurs="1" maxOccurs="1" >
+ <xs:element name="item" minOccurs="1" maxOccurs="unbounded">
+ <xs:complexType>
+ <xs:attribute name="brId" type="xs:long" use="required" />
+ <xs:attribute name="itemId" type="xs:integer" use="required" />
+ <xs:attribute name="count" type="xs:integer" use="required" />
+ <xs:attribute name="cat" type="xs:integer" use="required" />
+ <xs:attribute name="price" type="xs:integer" use="required" />
+ <xs:attribute name="event" type="xs:boolean" use="required" />
+ <xs:attribute name="best" type="xs:boolean" use="required" />
+ <xs:attribute name="sale_start_date" type="xs:string" />
+ <xs:attribute name="sale_end_date" type="xs:string" />
+ </xs:complexType>
+ </xs:element>
+ </xs:sequence>
+ </xs:complexType>
+ </xs:element>
+</xs:schema>
+
\ No newline at end of file
diff --git a/L2J_DataPack/dist/sql/game/characters.sql b/L2J_DataPack/dist/sql/game/characters.sql
index 86ab28d..e341fd8 100644
--- a/L2J_DataPack/dist/sql/game/characters.sql
+++ b/L2J_DataPack/dist/sql/game/characters.sql
@@ -55,6 +55,7 @@
   `vitality_points` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
   `createDate` date NOT NULL DEFAULT '0000-00-00',
   `language` VARCHAR(2) DEFAULT NULL,
+  `game_points` bigint(13) NOT NULL DEFAULT 0,
   PRIMARY KEY (`charId`),
   KEY `account_name` (`account_name`),
   KEY `char_name` (`char_name`),