| Misho |
31-08-2009 11:24 PM |
pay estou comecando a entender melhor isso, porem minha duvida agora ficou na seguinte parte, ele avisa que nao acha a buylist,porem no navicat ela esta la, ok,entao pela sua reposta pode ser erro no java, verificando o java (pelo erro) aparentemnte ele falo algo sobre a parte do :
TradeController.java
Olhando aqui no java esta assim:
Código:
/*
* 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 2, 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, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
* 02111-1307, USA.
*
* http://www.gnu.org/copyleft/gpl.html
*/
package net.sf.l2j.gameserver;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.LineNumberReader;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Map;
import java.util.StringTokenizer;
import java.util.logging.Level;
import java.util.logging.Logger;
import javolution.util.FastMap;
import net.sf.l2j.Config;
import net.sf.l2j.L2DatabaseFactory;
import net.sf.l2j.gameserver.model.L2ItemInstance;
import net.sf.l2j.gameserver.model.L2TradeList;
/**
* This class ...
*
* @version $Revision: 1.5.4.13 $ $Date: 2005/04/06 16:13:38 $
*/
public class TradeController
{
private static Logger _log = Logger.getLogger(TradeController.class.getName());
private static TradeController _instance;
private int _nextListId;
private Map<Integer, L2TradeList> _lists;
public static TradeController getInstance()
{
if (_instance == null)
{
_instance = new TradeController();
}
return _instance;
}
private TradeController()
{
_lists = new FastMap<Integer, L2TradeList>();
File buylistData = new File(Config.DATAPACK_ROOT, "data/buylists.csv");
if(buylistData.exists())
{
_log.warning("Do, please, remove buylists from data folder and use SQL buylist instead");
String line = null;
LineNumberReader lnr = null;
int dummyItemCount = 0;
try
{
lnr = new LineNumberReader(new BufferedReader( new FileReader(buylistData)));
while ( (line=lnr.readLine()) != null)
{
if (line.trim().length() == 0 || line.startsWith("#"))
{
continue;
}
dummyItemCount += parseList(line);
}
if (Config.DEBUG) _log.fine("created " + dummyItemCount + " Dummy-Items for buylists");
_log.config("TradeController: Loaded " + _lists.size() + " Buylists.");
}
catch (Exception e)
{
_log.log(Level.WARNING, "error while creating trade controller in linenr: " +lnr.getLineNumber(), e);
}
}
else
{
_log.finer("No buylists were found in data folder, using SQL buylist instead");
java.sql.Connection con = null;
int dummyItemCount = 0;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement1 = con.prepareStatement("SELECT " + L2DatabaseFactory.getInstance().safetyString(new String[] {"shop_id", "npc_id"}) + " FROM merchant_shopids");
ResultSet rset1 = statement1.executeQuery();
while(rset1.next())
{
PreparedStatement statement = con.prepareStatement("SELECT " + L2DatabaseFactory.getInstance().safetyString(new String[] {"item_id", "price", "shop_id", "order"}) + " FROM merchant_buylists WHERE shop_id=? ORDER BY " + L2DatabaseFactory.getInstance().safetyString(new String[] {"order"}) + " ASC");
statement.setString(1,String.valueOf(rset1.getInt("shop_id")));
ResultSet rset = statement.executeQuery();
if(rset.next())
{
dummyItemCount++;
L2TradeList buy1 = new L2TradeList(rset1.getInt("shop_id"));
int itemId = rset.getInt("item_id");
int price = rset.getInt("price");
L2ItemInstance item = ItemTable.getInstance().createDummyItem(itemId);
item.setPriceToSell(price);
buy1.addItem(item);
buy1.setNpcId(rset1.getString("npc_id"));
try
{
while (rset.next())
{
dummyItemCount++;
itemId = rset.getInt("item_id");
price = rset.getInt("price");
L2ItemInstance item2 = ItemTable.getInstance().createDummyItem(itemId);
item2.setPriceToSell(price);
buy1.addItem(item2);
}
}
catch(Exception e)
{
_log.warning("TradeController: Problem with buylist "+buy1.getListId()+" item "+itemId);
}
_lists.put(new Integer(buy1.getListId()), buy1);
_nextListId = Math.max(_nextListId, buy1.getListId()+1);
}
rset.close();
statement.close();
}
rset1.close();
statement1.close();
if (Config.DEBUG) _log.fine("created " + dummyItemCount + " Dummy-Items for buylists");
_log.config("TradeController: Loaded " + _lists.size() + " Buylists.");
}
catch (Exception e)
{
// problem with initializing spawn, go to next one
_log.warning("TradeController: Buylists could not be initialized.");
e.printStackTrace();
}
finally
{
try { con.close(); } catch (Exception e) {}
}
}
}
private int parseList(String line)
{
int itemCreated = 0;
StringTokenizer st = new StringTokenizer(line,";");
int listId = Integer.parseInt(st.nextToken());
L2TradeList buy1 = new L2TradeList(listId);
while (st.hasMoreTokens())
{
int itemId = Integer.parseInt(st.nextToken());
int price = Integer.parseInt(st.nextToken());
L2ItemInstance item = ItemTable.getInstance().createDummyItem(itemId);
item.setPriceToSell(price);
buy1.addItem(item);
itemCreated++;
}
_lists.put(new Integer(buy1.getListId()), buy1);
return itemCreated;
}
public L2TradeList getBuyList(int listId)
{
return _lists.get(new Integer(listId));
}
/**
* @return
*/
public synchronized int getNextId()
{
return _nextListId++;
}
}
Olhando por isso,estou pelo caminho certo?
ou o erro deve estar em outra parte que nao analisei?
Se for possivel me ajude novamente
vlw
EDIT:Desculpem o monte de topico sobre compilar, e que estou lendo algumas apostilas, e estou querendo melhorar,sei que isso enche o saco,mas e o unico forum que o pessoal me ajuda.. |
