package ru.catssoftware.gameserver.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import ru.catssoftware.L2DatabaseFactory;
import ru.catssoftware.gameserver.model.actor.instance.L2PcInstance;
import ru.catssoftware.tools.random.Rnd;

/**
*
* @author Freesty1e
* @author Seregakill
*/
public class FakePlayers
{
private static final org.apache.log4j.Logger _log= org.apache.log4j.Logger.getLogger(FakePlayers.class.getName());
private static final String LOAD_FAKE_PLAYERS = "SELECT * FROM fake_players";
int x,y,z;
L2PcInstance FakePlayers;
public int FakePlayersCount = 0;
private static FakePlayers _instance;

public static FakePlayers getInstance()
{
if(_instance == null)
{
_instance = new FakePlayers();
}
return _instance;
}

private FakePlayers()
{
FakePlayer();
}

public void FakePlayer()
{
Connection con = null;
try {
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement stm = con.prepareStatement(LOAD_FAKE_PLAYERS);
ResultSet rs = stm.executeQuery();
while(rs.next() && FakePlayersCount < 50)
{
x = rs.getInt("x");
y = rs.getInt("y");
z = rs.getInt("z");
FakePlayers = L2PcInstance.load(rs.getInt("charId"));
//проверяем стоят ли координаты
if (x != 0 || y != 0 || z !=0)
// берём координаты в таблице
FakePlayers.spawnMe(x + Rnd.get(1, 250), y + Rnd.get(1, 250), z);
else
//спавним по этим координатам
FakePlayers.spawnMe(82315 + Rnd.get(1, 250), 148840 + Rnd.get(1, 250), -3464);
FakePlayers.broadcastUserInfo();
FakePlayers.setOnlineStatus(true);
FakePlayersCount++;

}
rs.close();
stm.close();
con.close();
_log.info("############################################################");
_log.info("Loaded fake Pkayers by Freesty1e & seregakill");
_log.info("Loaded: " +FakePlayersCount+ " Fake Players");
_log.info("############################################################");
} catch (Exception e) {
e.printStackTrace();
}
}
}

CREATE TABLE `fake_players` (
`charId` decimal(11,0) NOT NULL DEFAULT '0',
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`z` int(11) NOT NULL,
PRIMARY KEY (`charId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;