public string GetFen()
{
var sb = new StringBuilder();
sb.Append(Board.GetFenCode(FenMode.Classical));
sb.Append(" ");
sb.Append(WhosTurn == PlayerAffiliation.White ? 'w' : 'b');
sb.Append(" ");
var fenWhite = White.GetFenCastle();
var fenBlack = Black.GetFenCastle();
if (fenWhite == string.Empty && fenBlack == string.Empty)
{
sb.Append("-");
}
else
{
sb.Append(fenWhite);
sb.Append(fenBlack);
}
sb.Append(" ");
sb.Append("-");
sb.Append(" ");
sb.Append(HalfmovesSinceLastCaptureOrPawn);
sb.Append(" ");
sb.Append(Movecounter);
sb.Append(" ");
return(sb.ToString());
}
public void TestThatIfWhiteCheckerIsCapturedAChangeShowsItIsMovedToTheBar()
{
int[] mainBoard = new int[] {
-2, 0, 0, 0, 0, 5,
0, 3, 0, 0, 0, -5,
5, 0, 0, 0, -3, 0,
-5, 0, 0, 1, 0, 1
};
fd.SetReturnValues(ar(1, 3));
bg = new BackgammonGame(mainBoard, fd, 0, 0, 0, 0, Black);
bg.Move(Black, 19, 22);
var changes = bg.GetChanges();
Assert.AreEqual(4, changes.Count());
var c1 = changes[0];
var c2 = changes[1];
var c3 = changes[2];
var c4 = changes[3];
Assert.IsTrue(c1.IsDiceState(), "c1 is not dice state");
Assert.IsTrue(c2.IsMove(), "c2 is not move");
Assert.IsTrue(c3.IsMove());
Assert.IsTrue(c4.IsDiceState(), "c3 is not dice state");
Assert.IsTrue(arrayEqual(ar(1, 3), c1.AsDiceState().GetDiceValues()), "Expected 1,3 but got " + string.Join(",", c1.AsDiceState().GetDiceValues()));
Assert.AreEqual("b 19 22", c2.AsMove().DebugString());
Assert.AreEqual("w 22 " + White.GetBar(), c3.AsMove().DebugString());
Assert.IsTrue(arrayEqual(new int[] { 1 }, c4.AsDiceState().GetDiceValues()));
}
internal int GetAmountOfCheckersAtPoint(int i)
{
if (i == CheckerColor.Black.GetBar())
{
return(BlackBar.GetAmount());
}
else if (i == White.GetBar())
{
return(WhiteBar.GetAmount());
}
else if (i == White.BearOffPositionID())
{
return(WhiteBearOff.GetAmount());
}
else if (i == Black.BearOffPositionID())
{
return(BlackBearOff.GetAmount());
}
else
{
int value = Points[i].GetAmount();
if (value != 0 && Points[i].GetTopChecker().Color == Black)
{
return(-value);
}
return(value);
}
}
/// <summary>验证来源地址</summary>
/// <param name="ip"></param>
/// <returns></returns>
public Boolean ValidSource(String ip)
{
if (ip.IsNullOrEmpty())
{
return(true);
}
// 匹配黑名单
var ps = Black.Split(",", ";");
if (ps != null && ps.Length > 0)
{
if (ps.Any(e => ip.IsMatch(ip)))
{
return(false);
}
}
// 匹配白名单
ps = White.Split(",", ";");
if (ps != null && ps.Length > 0)
{
if (ps.Any(e => ip.IsMatch(ip)))
{
return(true);
}
// 白名单存在，但匹配失败，则直接失败
return(false);
}
return(true);
}
internal int GetClickedPoint()
{
foreach (Point p in Points)
{
if (InputManager.Instance.WasClicked(p.GetBounds()))
{
if (p.Equals(WhiteBar))
{
return(White.GetBar());
}
else if (p.Equals(WhiteBearOff))
{
return(White.BearOffPositionID());
}
else if (p.Equals(BlackBar))
{
return(Black.GetBar());
}
else if (p.Equals(BlackBearOff))
{
return(Black.BearOffPositionID());
}
else
{
return(Points.IndexOf(p));
}
}
}
return(-1);
}
public string GetFen()
{
var sb = new StringBuilder();
sb.Append(BoardController.GetFenCode(FenMode.Classical));
sb.Append(" ");
sb.Append(Game.WhosTurn == PlayerAffiliation.White ? 'w' : 'b');
sb.Append(" ");
var fenWhite = White.GetFenCastle();
var fenBlack = Black.GetFenCastle();
if (string.IsNullOrEmpty(fenWhite) && string.IsNullOrEmpty(fenBlack))
{
sb.Append("-");
}
else
{
sb.Append(fenWhite);
sb.Append(fenBlack);
}
sb.Append(" ");
sb.Append("-");
sb.Append(" ");
sb.Append(Game.HalfmovesSinceLastCaptureOrPawn);
sb.Append(" ");
sb.Append(Game.Movecounter);
sb.Append(" ");
return(sb.ToString());
}
public Board Copy()
{
var result = new Board();
result.Black = Black.Copy();
result.White = White.Copy();
return(result);
}
public void CanSwitchAllLightsOff()
{
var controller = new WifiController("192.168.0.6");
controller.Send(White.Off(Zone.All));
controller.Send(Colour.Off(Zone.All));
}
public void White()
{
Wire wire = new White();
Assert.AreEqual(ResultType.Explode, wire.Cut(new White()));
Assert.AreEqual(ResultType.Disarm, wire.Cut(new Red()));
Assert.AreEqual(ResultType.Explode, wire.Cut(new Black()));
Assert.AreEqual(ResultType.Disarm, wire.Cut(new Orange()));
Assert.AreEqual(ResultType.Disarm, wire.Cut(new Green()));
Assert.AreEqual(ResultType.Disarm, wire.Cut(new Purple()));
}
internal int GetClickedPoint(int i)
{
if (GamePadPointOrdering[i] == WhiteBearOff)
{
return(White.BearOffPositionID());
}
else if (GamePadPointOrdering[i] == BlackBearOff)
{
return(Black.BearOffPositionID());
}
return(Points.IndexOf(GamePadPointOrdering[i]));
}
public void DrawTest()
{
Green green = new Green();
Circle circle = new Circle();
circle.SetColor(green);
Assert.Equal("Green Circle", circle.Draw());
White white = new White();
circle.SetColor(white);
Assert.Equal("White Circle", circle.Draw());
}
// used by UI to choose human player turn
public void TogglePlayerColor()
{
playerGoesFirst = !playerGoesFirst;
if (playerGoesFirst)
{
Black.SetHuman();
White.SetComputer();
ui.SetPlayerColorImage(Color.black);
}
else
{
Black.SetComputer();
White.SetHuman();
ui.SetPlayerColorImage(Color.white);
}
}
public void XmlifyMoveAndParseBackFromString()
{
Move move1 = new Move(White, 6, 3);
string move1Xml = UpdateCreatorParser.CreateXmlForMove(move1);
Move parsedMove1 = UpdateCreatorParser.ParseMove(move1Xml);
Assert.AreEqual("<move>w 6 3</move>", move1Xml);
Assert.AreEqual(move1, parsedMove1);
Move move2 = new Move(White, 6, White.GetBar());
string move2Xml = UpdateCreatorParser.CreateXmlForMove(move2);
Move parsedMove2 = UpdateCreatorParser.ParseMove(move2Xml);
Assert.AreEqual("<move>w 6 25</move>", move2Xml);
Assert.AreEqual(move2, parsedMove2, "this one failing");
Move move3 = new Move(White, 6, White.BearOffPositionID());
string move3Xml = UpdateCreatorParser.CreateXmlForMove(move3);
Move parsedMove3 = UpdateCreatorParser.ParseMove(move3Xml);
Assert.AreEqual("<move>w 6 28</move>", move3Xml);
Assert.AreEqual(move3, parsedMove3);
Move move4 = new Move(Black, 20, 24);
string move4Xml = UpdateCreatorParser.CreateXmlForMove(move4);
Move parsedMove4 = UpdateCreatorParser.ParseMove(move4Xml);
Assert.AreEqual("<move>b 20 24</move>", move4Xml);
Assert.AreEqual(move4, parsedMove4);
Move move5 = new Move(Black, 24, Black.BearOffPositionID());
string move5Xml = UpdateCreatorParser.CreateXmlForMove(move5);
Move parsedMove5 = UpdateCreatorParser.ParseMove(move5Xml);
Assert.AreEqual("<move>b 24 27</move>", move5Xml);
Assert.AreEqual(move5, parsedMove5);
Move move6 = new Move(Black, 20, Black.GetBar());
string move6Xml = UpdateCreatorParser.CreateXmlForMove(move6);
Move parsedMove6 = UpdateCreatorParser.ParseMove(move6Xml);
Assert.AreEqual("<move>b 20 26</move>", move6Xml);
Assert.AreEqual(move6, parsedMove6);
}
public override int GetHashCode()
{
unchecked
{
var hashCode = (Event != null ? Event.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Site != null ? Site.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (White != null ? White.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Black != null ? Black.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Date != null ? Date.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Round != null ? Round.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (int)Result;
hashCode = (hashCode * 397) ^ (MoveText != null ? MoveText.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Eco != null ? Eco.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ WhiteElo.GetHashCode();
hashCode = (hashCode * 397) ^ BlackElo.GetHashCode();
return(hashCode);
}
}
internal static string CreateXmlForGameBoardState(GameBoardState state, string rootTag)
{
if (state == null)
{
throw new ArgumentNullException("state");
}
if (rootTag == null)
{
throw new ArgumentNullException("rootTag");
}
//Separating each element of the array with a space, and removes trailing spaces
var board = state.getMainBoard().Select(i => i + " ").Aggregate((a, b) => a + b).Trim();
//Wrap the board with tags
board = "<board>" + board + "</board>";
int whiteGoal = state.GetCheckersOnPosition(White.BearOffPositionID());
int whiteBar = state.GetCheckersOnPosition(White.GetBar());
//The agreed format is that black checkers on bar and target should be represented as negative
int blackGoal = state.GetCheckersOnPosition(Black.BearOffPositionID());
blackGoal = Math.Min(blackGoal, blackGoal * -1);
int blackBar = state.GetCheckersOnPosition(Black.GetBar());
blackBar = Math.Min(blackBar, blackBar * -1);
//Wrap each of the above four values in their own tags
var rest = String.Format("<whiteGoal>{0}</whiteGoal><whiteBar>{1}</whiteBar><blackGoal>{2}</blackGoal><blackBar>{3}</blackBar>",
whiteBar, whiteGoal, blackBar, blackGoal);
//Wrapping the entire message in the supplied root tags
if (rootTag == "")
{
return(board + rest);
}
else
{
return(String.Format("<{0}>" + board + rest + "</{0}>", rootTag));
}
}
private void AddWhitePieces()
{
var fields = Board.Fields;
var rook1 = new Rook(White, Board, fields[0, 0]);
var rook2 = new Rook(White, Board, fields[7, 0]);
var knight1 = new Knight(White, Board, fields[1, 0]);
var knight2 = new Knight(White, Board, fields[6, 0]);
var bishop1 = new Bishop(White, Board, fields[2, 0]);
var bishop2 = new Bishop(White, Board, fields[5, 0]);
var queen = new Queen(White, Board, fields[3, 0]);
var king = new King(White, Board, fields[4, 0]);
var pawn1 = new Pawn(White, Board, fields[0, 1]);
var pawn2 = new Pawn(White, Board, fields[1, 1]);
var pawn3 = new Pawn(White, Board, fields[2, 1]);
var pawn4 = new Pawn(White, Board, fields[3, 1]);
var pawn5 = new Pawn(White, Board, fields[4, 1]);
var pawn6 = new Pawn(White, Board, fields[5, 1]);
var pawn7 = new Pawn(White, Board, fields[6, 1]);
var pawn8 = new Pawn(White, Board, fields[7, 1]);
White.AddPiece(rook1);
White.AddPiece(rook2);
White.AddPiece(knight1);
White.AddPiece(knight2);
White.AddPiece(bishop1);
White.AddPiece(bishop2);
White.AddPiece(queen);
White.AddPiece(king);
White.AddPiece(pawn1);
White.AddPiece(pawn2);
White.AddPiece(pawn3);
White.AddPiece(pawn4);
White.AddPiece(pawn5);
White.AddPiece(pawn6);
White.AddPiece(pawn7);
White.AddPiece(pawn8);
}
// Start is called before the first frame update
void Start()
{
Bltext = Black.GetComponent <Text>();
Whtext = White.GetComponent <Text>();
Vector3 put;
for (int i = 0; i < 8; i++)
{
for (int j = 0; j < 8; j++)
{
put = new Vector3(-3.5f + j, 0, 3.5f - i);
boardinfo[i, j] = -1;
disclist[i, j] = Instantiate(disc, put, Quaternion.identity);
Boardlist[i, j] = Instantiate(Board, put, Quaternion.identity);
}
}
boardinfo[3, 3] = boardinfo[4, 4] = 0;
boardinfo[3, 4] = boardinfo[4, 3] = 1;
Checkit();
}
private static int AdaptPositionFromOutputFormat(int pos)
{
if (pos == WHITE_BAR_POSITION_IN_UPDATE_MESSAGE)
{
return(White.GetBar());
}
if (pos == WHITE_TARGET_POSITION_IN_UPDATE_MESSAGE)
{
return(White.BearOffPositionID());
}
if (pos == BLACK_BAR_POSITION_IN_UPDATE_MESSAGE)
{
return(Black.GetBar());
}
if (pos == BLACK_TARGET_POSITION_IN_UPDATE_MESSAGE)
{
return(Black.BearOffPositionID());
}
return(pos);
}
// Start is called before the first frame update
void Start()
{
if (Instance)
{
Debug.LogError("Another game instance exists");
Destroy(this);
return;
}
Instance = this;
gomoku = new Minimax();
Black = Instantiate(playerPrefab).GetComponent <Player>();
White = Instantiate(playerPrefab).GetComponent <Player>();
Black.Init(Color.black, 1, "Black");
White.Init(Color.white, 2, "White");
ui.Init();
gridBoard.InitializeMatrix();
TogglePlayerColor();
// SetTwoPlayer();
}
/// <summary>
/// Opens new window and attaches white's automation object to it.
/// </summary>
/// <param name="windowFactory">A factory method used to create new window</param>
/// <param name="window">Returns created window</param>
/// <param name="whiteWindow">Returns white's application for created window</param>
public static void OpenWindow(Func<Window> windowFactory, out Window window,
out White.Core.UIItems.WindowItems.Window whiteWindow)
{
var title = Guid.NewGuid().ToString();
Window temporaryWindow = null;
lock (typeof (GuiApplicationContainer))
{
EnsureApplicationIsRunning();
Invoke(() =>
{
temporaryWindow = windowFactory();
temporaryWindow.Title = title;
temporaryWindow.Show();
});
}
window = temporaryWindow;
whiteWindow = _whiteApplication.GetWindow(title, InitializeOption.NoCache);
if (whiteWindow == null)
throw new InvalidStateException("whiteWindow cannot be null");
}
public void TestCanGenerateAndParseListOfMoves()
{
Move move1 = new Move(White, 5, 2);
Move move2 = new Move(Black, 20, Black.GetBar());
Move move3 = new Move(White, 1, White.BearOffPositionID());
List <Move> moves = new List <Move>()
{
move1, move2, move3
};
string xml = UpdateCreatorParser.GenerateXmlForListOfMoves(moves);
string expected = "<moves><move>w 5 2</move><move>b 20 26</move><move>w 1 28</move></moves>";
Assert.AreEqual(expected, xml);
List <Move> parsedMoves = UpdateCreatorParser.ParseListOfMoves(xml);
Assert.IsTrue(parsedMoves.Contains(move1));
Assert.IsTrue(parsedMoves.Contains(move2));
Assert.IsTrue(parsedMoves.Contains(move3));
}
void GameOver()
{
//게임 오버
if (!Stop)
{
BirdSound_3.Play();
}
Stop = true;
Floor.GetComponent <Animator>().enabled = false;
White.SetActive(true);
Score.gameObject.SetActive(false);
if (PlayerPrefs.GetInt("BestScore", 0) < int.Parse(Score.text))
{
PlayerPrefs.SetInt("BestScore", int.Parse(Score.text));
}
if (transform.position.y < -2.55f)
{
Quit.SetActive(true);
Quit.transform.Find("ScoreScreen").GetComponent <Text>().text = Score.text;
Quit.transform.Find("BestScreen").GetComponent <Text>().text = PlayerPrefs.GetInt("BestScore").ToString();
}
}
public void Draw(White c)
{
Turtle.SetColor(c.Value.R, c.Value.G, c.Value.B);
}
public void CapillaryBackfill()
{
BackfillTutorial Backfill = White.GetComponent <BackfillTutorial>();
Backfill.ShowThumb();
}
public void CanTurnWhiteLightsOn()
{
var controller = new WifiController("192.168.0.6");
controller.Send(White.On(Zone.All));
}
public BaseItem GetRebirthPillDrop(Monster m)
{
DbParameter levelParameter = _db.CreateParameter(DbNames.GETPILLDROPITEM_LEVEL_PARAMETER, m.Level);
levelParameter.DbType = DbType.Int32;
List<BaseItem> items = new List<BaseItem>();
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETPILLDROPITEM_STOREDPROC, CommandType.StoredProcedure, levelParameter);
int ordinalITEM_REFERENCEID = reader.GetOrdinal(DbNames.ITEM_REFERENCEID);
int ordinalITEM_BTYPE = reader.GetOrdinal(DbNames.ITEM_BTYPE);
int ordinalITEM_BKIND = reader.GetOrdinal(DbNames.ITEM_BKIND);
int ordinalITEM_VISUALID = reader.GetOrdinal(DbNames.ITEM_VISUALID);
int ordinalITEM_COST = reader.GetOrdinal(DbNames.ITEM_COST);
int ordinalITEM_CLASS = reader.GetOrdinal(DbNames.ITEM_CLASS);
int ordinalITEM_LEVEL = reader.GetOrdinal(DbNames.ITEM_LEVEL);
int ordinalITEM_DEX = reader.GetOrdinal(DbNames.ITEM_DEX);
int ordinalITEM_STR = reader.GetOrdinal(DbNames.ITEM_STR);
int ordinalITEM_STA = reader.GetOrdinal(DbNames.ITEM_STA);
int ordinalITEM_ENE = reader.GetOrdinal(DbNames.ITEM_ENE);
int ordinalITEM_MAXIMBUES = reader.GetOrdinal(DbNames.ITEM_MAXIMBUES);
int ordinalITEM_MAXDURA = reader.GetOrdinal(DbNames.DROPITEM_DURABILITY);
int ordinalITEM_DAMAGE = reader.GetOrdinal(DbNames.ITEM_DAMAGE);
int ordinalITEM_DEFENCE = reader.GetOrdinal(DbNames.ITEM_DEFENCE);
int ordinalITEM_ATTACKRATING = reader.GetOrdinal(DbNames.ITEM_ATTACKRATING);
int ordinalITEM_ATTACKSPEED = reader.GetOrdinal(DbNames.ITEM_ATTACKSPEED);
int ordinalITEM_ATTACKRANGE = reader.GetOrdinal(DbNames.ITEM_ATTACKRANGE);
int ordinalITEM_INCMAXLIFE = reader.GetOrdinal(DbNames.ITEM_INCMAXLIFE);
int ordinalITEM_INCMAXMANA = reader.GetOrdinal(DbNames.ITEM_INCMAXMANA);
int ordinalITEM_LIFEREGEN = reader.GetOrdinal(DbNames.ITEM_LIFEREGEN);
int ordinalITEM_MANAREGEN = reader.GetOrdinal(DbNames.ITEM_MANAREGEN);
int ordinalITEM_CRITICAL = reader.GetOrdinal(DbNames.ITEM_CRITICAL);
int ordinalITEM_TOMAPID = reader.GetOrdinal(DbNames.ITEM_TOMAPID);
int ordinalITEM_IMBUERATE = reader.GetOrdinal(DbNames.ITEM_IMBUERATE);
int ordinalITEM_IMBUEINCREASE = reader.GetOrdinal(DbNames.ITEM_IMBUEINCREASE);
int ordinalITEM_BOOKSKILLID = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLID);
int ordinalITEM_BOOKSKILLLEVEL = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLLEVEL);
int ordinalITEM_BOOKSKILLDATA = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLDATA);
int ordinalITEM_MAXPOLISHTRIES = reader.GetOrdinal(DbNames.ITEM_MAXPOLISHTRIES);
int ordinalITEM_POLISHTRIES = reader.GetOrdinal(DbNames.ITEM_POLISHTRIES);
int ordinalITEM_SIZEX = reader.GetOrdinal(DbNames.ITEM_SIZEX);
int ordinalITEM_SIZEY = reader.GetOrdinal(DbNames.ITEM_SIZEY);
while (reader.Read())
{
BaseItem b = null;
int BType = reader.GetByte(ordinalITEM_BTYPE);
int BKind = reader.GetByte(ordinalITEM_BKIND);
if (BType == (byte)bType.Weapon || BType == (byte)bType.Clothes || BType == (byte)bType.Hat || BType == (byte)bType.Necklace
|| BType == (byte)bType.Ring || BType == (byte)bType.Shoes || BType == (byte)bType.Cape)
{
if (BKind == (byte)bKindWeapons.Sword && BType == (byte)bType.Weapon)
{
b = new Sword();
}
if (BKind == (byte)bKindWeapons.Blade && BType == (byte)bType.Weapon)
{
b = new Blade();
}
if (BKind == (byte)bKindWeapons.Fan && BType == (byte)bType.Weapon)
{
b = new Fan();
}
if (BKind == (byte)bKindWeapons.Brush && BType == (byte)bType.Weapon)
{
b = new Brush();
}
if (BKind == (byte)bKindWeapons.Claw && BType == (byte)bType.Weapon)
{
b = new Claw();
}
if (BKind == (byte)bKindWeapons.Axe && BType == (byte)bType.Weapon)
{
b = new Axe();
}
if (BKind == (byte)bKindWeapons.Talon && BType == (byte)bType.Weapon)
{
b = new Talon();
}
if (BKind == (byte)bKindWeapons.Tonfa && BType == (byte)bType.Weapon)
{
b = new Tonfa();
}
if (BKind == (byte)bKindArmors.SwordMan && BType == (byte)bType.Clothes)
{
b = new Clothes();
}
if (BKind == (byte)bKindArmors.Mage && BType == (byte)bType.Clothes)
{
b = new Dress();
}
if (BKind == (byte)bKindArmors.Warrior && BType == (byte)bType.Clothes)
{
b = new Armor();
}
if (BKind == (byte)bKindArmors.GhostFighter && BType == (byte)bType.Clothes)
{
b = new LeatherClothes();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Hat)
{
b = new Hood();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Hat)
{
b = new Tiara();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Hat)
{
b = new Helmet();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Hat)
{
b = new Hat();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Shoes)
{
b = new SmBoots();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Shoes)
{
b = new MageBoots();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Shoes)
{
b = new WarriorShoes();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Shoes)
{
b = new GhostFighterShoes();
}
if (BKind == 0 && BType == (byte)bType.Ring)
{
b = new Ring();
}
if (BKind == 0 && BType == (byte)bType.Necklace)
{
b = new Necklace();
}
if (BType == (byte)bType.Cape)
{
b = new Cape();
Cape c = b as Cape;
c.MaxPolishImbueTries = reader.GetInt16(ordinalITEM_MAXPOLISHTRIES);
c.PolishImbueTries = reader.GetByte(ordinalITEM_POLISHTRIES);
}
Equipment e = b as Equipment;
e.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
e.RequiredDexterity = reader.GetInt16(ordinalITEM_DEX);
e.RequiredStrength = reader.GetInt16(ordinalITEM_STR);
e.RequiredStamina = reader.GetInt16(ordinalITEM_STA);
e.RequiredEnergy = reader.GetInt16(ordinalITEM_ENE);
e.MaxImbueTries = reader.GetByte(ordinalITEM_MAXIMBUES);
e.Durability = reader.GetInt32(ordinalITEM_MAXDURA);
e.MaxDurability = reader.GetInt32(ordinalITEM_MAXDURA);
e.Damage = reader.GetInt32(ordinalITEM_DAMAGE);
e.Defence = reader.GetInt32(ordinalITEM_DEFENCE);
e.AttackRating = reader.GetInt32(ordinalITEM_ATTACKRATING);
e.AttackSpeed = reader.GetInt16(ordinalITEM_ATTACKSPEED);
e.AttackRange = reader.GetInt16(ordinalITEM_ATTACKRANGE);
e.IncMaxLife = reader.GetInt16(ordinalITEM_INCMAXLIFE);
e.IncMaxMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
e.IncLifeRegen = reader.GetInt16(ordinalITEM_LIFEREGEN);
e.IncManaRegen = reader.GetInt16(ordinalITEM_MANAREGEN);
e.Critical = reader.GetInt16(ordinalITEM_CRITICAL);
}
if (BType == (byte)bType.ImbueItem)
{
if (BKind == (byte)bKindStones.Black)
{
b = new Black();
}
if (BKind == (byte)bKindStones.White)
{
b = new White();
}
if (BKind == (byte)bKindStones.Red)
{
b = new Red();
}
if (BKind == (byte)bKindStones.Dragon)
{
b = new Dragon();
}
if (BKind == (byte)bKindStones.RbItem)
{
b = new RbHoleItem();
}
ImbueItem im = b as ImbueItem;
im.ImbueChance = reader.GetInt16(ordinalITEM_IMBUERATE);
im.IncreaseValue = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
}
if (BType == (byte)bType.Potion)
{
if (BKind == (byte)bKindPotions.Normal)
{
b = new Potion();
}
if (BKind == (byte)bKindPotions.Elixir)
{
b = new Elixir();
}
PotionItem pot = b as PotionItem;
pot.HealHp = reader.GetInt16(ordinalITEM_INCMAXLIFE);
pot.HealMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
}
if (BType == (byte)bType.Book)
{
if (BKind == (byte)bKindBooks.SoftBook)
{
b = new SoftBook();
}
if (BKind == (byte)bKindBooks.HardBook)
{
b = new HardBook();
}
if (BKind == (byte)bKindBooks.RebirdBook)
{
b = new RebirthBook();
}
if (BKind == (byte)bKindBooks.FourthBook)
{
b = new FourthBook();
}
if (BKind == (byte)bKindBooks.FeSkillBook)
{
b = new FeSkillBook();
}
if (BKind == (byte)bKindBooks.FeBook)
{
b = new FiveElementBook();
}
if (BKind == (byte)bKindBooks.FocusBook)
{
b = new FocusBook();
}
BookItem book = b as BookItem;
book.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
book.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
book.SkillID = reader.GetInt32(ordinalITEM_BOOKSKILLID);
book.SkillLevel = reader.GetByte(ordinalITEM_BOOKSKILLLEVEL);
book.SkillData = reader.GetInt32(ordinalITEM_BOOKSKILLDATA);
}
if (BType == (byte)bType.Bead)
{
if (BKind == (byte)bKindBeads.Normal)
{
b = new Bead();
}
BeadItem bead = b as BeadItem;
bead.ToMapID = reader.GetInt32(ordinalITEM_TOMAPID);
}
if (BType == (byte)bType.StoreTag)
{
b = new StoreTag();
StoreTag tag = b as StoreTag;
tag.TimeLeft = reader.GetInt16(ordinalITEM_MAXDURA);
tag.TimeMax = reader.GetInt16(ordinalITEM_MAXDURA);
}
if (BType == (byte)bType.PetItem)
{
if (BKind == (byte)bKindPetItems.Taming)
b = new TameItem();
if (BKind == (byte)bKindPetItems.Food)
b = new PetFood();
if (BKind == (byte)bKindPetItems.Potion)
b = new PetPotion();
if (BKind == (byte)bKindPetItems.Resurect)
b = new PetResurrectItem();
PetItem p = b as PetItem;
p.TameChance = reader.GetInt16(ordinalITEM_IMBUERATE);
p.DecreaseWildness = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
p.HealLife = reader.GetInt16(ordinalITEM_INCMAXLIFE);
}
if (BType == (byte)bType.Pill)
{
if (BKind == (byte)bKindPills.Rebirth)
b = new RebirthPill();
RebirthPill p = b as RebirthPill;
p.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
p.RequiredRebirth = reader.GetByte(ordinalITEM_CLASS);
p.ToRebirth = (byte)(p.RequiredRebirth + 1);
p.IncreaseSp = reader.GetInt16(ordinalITEM_DEX);
}
b.ItemID = 0;
b.OwnerID = 0;
b.ReferenceID = reader.GetInt16(ordinalITEM_REFERENCEID);
b.VisualID = reader.GetInt16(ordinalITEM_VISUALID);
b.Bag = 0;
b.Slot = 0;
b.bType = reader.GetByte(ordinalITEM_BTYPE);
b.bKind = reader.GetByte(ordinalITEM_BKIND);
b.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
b.Amount = 1;
b.SizeX = reader.GetByte(ordinalITEM_SIZEX);
b.SizeY = reader.GetByte(ordinalITEM_SIZEY);
b.Price = reader.GetInt32(ordinalITEM_COST);
items.Add(b);
}
reader.Close();
_db.Close();
if (items.Count > 0)
{
Random rand = new Random();
int itemPos = rand.Next(0, items.Count);
return items[itemPos];
}
else
return null;
}
private void initLevels()
{
Salami salami = new Salami();
Chicken chicken = new Chicken();
Salad salad = new Salad();
Tomato tomato = new Tomato();
White white = new White();
WholeGrain wholeGrain = new WholeGrain();
levels = new List <Level>()
{
new Level {
enemyTypeAmount = new List <KeyValuePair <int, int> >()
{
new KeyValuePair <int, int>(Enemy.NORMAL, 12)
},
maxFailsForGameOver = 2,
minKillsForWin = 12,
availableIngredients = new List <Ingredient>()
{
chicken
},
spawnInterval = 3,
availableBreadsWithHits = new List <KeyValuePair <Bread, int> >()
{
new KeyValuePair <Bread, int>(white, 20)
}
},
new Level {
enemyTypeAmount = new List <KeyValuePair <int, int> >()
{
new KeyValuePair <int, int>(Enemy.VEGAN, 5),
new KeyValuePair <int, int>(Enemy.NORMAL, 5),
new KeyValuePair <int, int>(Enemy.VEGAN, 5),
new KeyValuePair <int, int>(Enemy.NORMAL, 2)
},
maxFailsForGameOver = 3,
minKillsForWin = 17,
availableIngredients = new List <Ingredient>()
{
chicken, tomato
},
spawnInterval = 3,
availableBreadsWithHits = new List <KeyValuePair <Bread, int> >()
{
new KeyValuePair <Bread, int>(white, 20)
}
},
new Level {
enemyTypeAmount = new List <KeyValuePair <int, int> >()
{
new KeyValuePair <int, int>(Enemy.NORMAL, 5),
new KeyValuePair <int, int>(Enemy.VEGAN, 5),
new KeyValuePair <int, int>(Enemy.FAT, 1),
new KeyValuePair <int, int>(Enemy.NORMAL, 5),
new KeyValuePair <int, int>(Enemy.FAT, 1),
new KeyValuePair <int, int>(Enemy.VEGAN, 5)
},
maxFailsForGameOver = 4,
minKillsForWin = 22,
availableIngredients = new List <Ingredient>()
{
chicken, tomato, salad, salami
},
spawnInterval = 3,
availableBreadsWithHits = new List <KeyValuePair <Bread, int> >()
{
new KeyValuePair <Bread, int>(white, 20),
new KeyValuePair <Bread, int>(wholeGrain, 30)
}
},
new Level {
enemyTypeAmount = new List <KeyValuePair <int, int> >()
{
new KeyValuePair <int, int>(Enemy.NORMAL, 8),
new KeyValuePair <int, int>(Enemy.VEGAN, 7),
new KeyValuePair <int, int>(Enemy.FAT, 7)
},
maxFailsForGameOver = 6,
minKillsForWin = 22,
availableIngredients = new List <Ingredient>()
{
chicken, tomato, salad, salami
},
spawnInterval = 2,
availableBreadsWithHits = new List <KeyValuePair <Bread, int> >()
{
new KeyValuePair <Bread, int>(white, 20),
new KeyValuePair <Bread, int>(wholeGrain, 30)
}
},
new Level {
enemyTypeAmount = new List <KeyValuePair <int, int> >()
{
new KeyValuePair <int, int>(Enemy.NORMAL, 8),
new KeyValuePair <int, int>(Enemy.VEGAN, 8),
new KeyValuePair <int, int>(Enemy.FAT, 9)
},
maxFailsForGameOver = 6,
minKillsForWin = 25,
availableIngredients = new List <Ingredient>()
{
chicken, tomato, salad, salami
},
spawnInterval = 1,
availableBreadsWithHits = new List <KeyValuePair <Bread, int> >()
{
new KeyValuePair <Bread, int>(white, 20),
new KeyValuePair <Bread, int>(wholeGrain, 30)
}
}
};
/* levels = new List<Level>(){
* new Level {
* enemyTypeAmount = new List<KeyValuePair<int, int>>() {
* new KeyValuePair<int, int>(Enemy.NORMAL, 10)
* },
* maxFailsForGameOver = 1,
* minKillsForWin = 10,
* availableIngredients = new List<Ingredient>() {chicken},
* spawnInterval = 3,
* availableBreadsWithHits = new List<KeyValuePair<Bread, int>>() {
* new KeyValuePair<Bread, int>(white, 30)
* }
* },
* new Level {
* enemyTypeAmount = new List<KeyValuePair<int, int>>() {
* new KeyValuePair<int, int>(Enemy.VEGAN, 5),
* new KeyValuePair<int, int>(Enemy.NORMAL, 5),
* new KeyValuePair<int, int>(Enemy.VEGAN, 5),
* new KeyValuePair<int, int>(Enemy.NORMAL, 5)
* },
* maxFailsForGameOver = 1,
* minKillsForWin = 20,
* availableIngredients = new List<Ingredient>() {chicken, tomato},
* spawnInterval = 3,
* availableBreadsWithHits = new List<KeyValuePair<Bread, int>>() {
* new KeyValuePair<Bread, int>(white, 30),
* new KeyValuePair<Bread, int>(wholeGrain, 20)
* }
* },
* new Level {
* enemyTypeAmount = new List<KeyValuePair<int, int>>() {
* new KeyValuePair<int, int>(Enemy.NORMAL, 5),
* new KeyValuePair<int, int>(Enemy.VEGAN, 5),
* new KeyValuePair<int, int>(Enemy.FAT, 1),
* new KeyValuePair<int, int>(Enemy.NORMAL, 5),
* new KeyValuePair<int, int>(Enemy.FAT, 1),
* new KeyValuePair<int, int>(Enemy.VEGAN, 5)
* },
* maxFailsForGameOver = 1,
* minKillsForWin = 22,
* availableIngredients = new List<Ingredient>() {chicken, tomato, salad, salami},
* spawnInterval = 1,
* availableBreadsWithHits = new List<KeyValuePair<Bread, int>>() {
* new KeyValuePair<Bread, int>(white, 30),
* new KeyValuePair<Bread, int>(wholeGrain, 20)
* }
* }
* };*/
}
public void CanSwitchWhiteLightsOffForAllZones()
{
var controller = new WifiController("192.168.0.6");
controller.Send(White.Off(Zone.All));
}
public List<BaseItem> GetAllItemsInBag(byte bag, int characterId)
{
DbParameter bagIdParameter = _db.CreateParameter(DbNames.GETALLITEMSBYBAGID_BAGID_PARAMETER, bag);
bagIdParameter.DbType = DbType.Byte;
DbParameter characterIdParameter = _db.CreateParameter(DbNames.GETALLITEMSBYBAGID_CHARACTERID_PARAMETER, characterId);
characterIdParameter.DbType = DbType.Int32;
List<BaseItem> items = new List<BaseItem>();
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLITEMSBYBAGID_STOREDPROC, CommandType.StoredProcedure, bagIdParameter, characterIdParameter);
int ordinalITEM_ITEMID = reader.GetOrdinal(DbNames.ITEM_ITEMID);
int ordinalITEM_OWNERID = reader.GetOrdinal(DbNames.ITEM_OWNERID);
int ordinalITEM_REFERENCEID = reader.GetOrdinal(DbNames.ITEM_REFERENCEID);
int ordinalITEM_BTYPE = reader.GetOrdinal(DbNames.ITEM_BTYPE);
int ordinalITEM_BKIND = reader.GetOrdinal(DbNames.ITEM_BKIND);
int ordinalITEM_VISUALID = reader.GetOrdinal(DbNames.ITEM_VISUALID);
int ordinalITEM_COST = reader.GetOrdinal(DbNames.ITEM_COST);
int ordinalITEM_CLASS = reader.GetOrdinal(DbNames.ITEM_CLASS);
int ordinalITEM_AMOUNT = reader.GetOrdinal(DbNames.ITEM_AMOUNT);
int ordinalITEM_LEVEL = reader.GetOrdinal(DbNames.ITEM_LEVEL);
int ordinalITEM_DEX = reader.GetOrdinal(DbNames.ITEM_DEX);
int ordinalITEM_STR = reader.GetOrdinal(DbNames.ITEM_STR);
int ordinalITEM_STA = reader.GetOrdinal(DbNames.ITEM_STA);
int ordinalITEM_ENE = reader.GetOrdinal(DbNames.ITEM_ENE);
int ordinalITEM_MAXIMBUES = reader.GetOrdinal(DbNames.ITEM_MAXIMBUES);
int ordinalITEM_MAXDURA = reader.GetOrdinal(DbNames.ITEM_MAXDURA);
int ordinalITEM_CURDURA = reader.GetOrdinal(DbNames.ITEM_CURDURA);
int ordinalITEM_DAMAGE = reader.GetOrdinal(DbNames.ITEM_DAMAGE);
int ordinalITEM_DEFENCE = reader.GetOrdinal(DbNames.ITEM_DEFENCE);
int ordinalITEM_ATTACKRATING = reader.GetOrdinal(DbNames.ITEM_ATTACKRATING);
int ordinalITEM_ATTACKSPEED = reader.GetOrdinal(DbNames.ITEM_ATTACKSPEED);
int ordinalITEM_ATTACKRANGE = reader.GetOrdinal(DbNames.ITEM_ATTACKRANGE);
int ordinalITEM_INCMAXLIFE = reader.GetOrdinal(DbNames.ITEM_INCMAXLIFE);
int ordinalITEM_INCMAXMANA = reader.GetOrdinal(DbNames.ITEM_INCMAXMANA);
int ordinalITEM_LIFEREGEN = reader.GetOrdinal(DbNames.ITEM_LIFEREGEN);
int ordinalITEM_MANAREGEN = reader.GetOrdinal(DbNames.ITEM_MANAREGEN);
int ordinalITEM_CRITICAL = reader.GetOrdinal(DbNames.ITEM_CRITICAL);
int ordinalITEM_PLUS = reader.GetOrdinal(DbNames.ITEM_PLUS);
int ordinalITEM_SLVL = reader.GetOrdinal(DbNames.ITEM_SLVL);
int ordinalITEM_IMBUETRIES = reader.GetOrdinal(DbNames.ITEM_IMBUETRIES);
int ordinalITEM_DRAGONSUCCESSIMBUETRIES = reader.GetOrdinal(DbNames.ITEM_DRAGONSUCCESSIMBUETRIES);
int ordinalITEM_DISCOUNTREPAIRFEE = reader.GetOrdinal(DbNames.ITEM_DISCOUNTREPAIRFEE);
int ordinalITEM_TOTALDRAGONIMBUES = reader.GetOrdinal(DbNames.ITEM_TOTALDRAGONIMBUES);
int ordinalITEM_DRAGONDAMAGE = reader.GetOrdinal(DbNames.ITEM_DRAGONDAMAGE);
int ordinalITEM_DRAGONDEFENCE = reader.GetOrdinal(DbNames.ITEM_DRAGONDEFENCE);
int ordinalITEM_DRAGONATTACKRATING = reader.GetOrdinal(DbNames.ITEM_DRAGONATTACKRATING);
int ordinalITEM_DRAGONLIFE = reader.GetOrdinal(DbNames.ITEM_DRAGONLIFE);
int ordinalITEM_MAPPEDSTUFF = reader.GetOrdinal(DbNames.ITEM_MAPPEDSTUFF);
int ordinalITEM_FORCENUMBER = reader.GetOrdinal(DbNames.ITEM_FORCENUMBER);
int ordinalITEM_REBIRTHHOLE = reader.GetOrdinal(DbNames.ITEM_REBIRTHHOLE);
int ordinalITEM_REBIRTHHOLESTAT = reader.GetOrdinal(DbNames.ITEM_REBIRTHHOLESTAT);
int ordinalITEM_TOMAPID = reader.GetOrdinal(DbNames.ITEM_TOMAPID);
int ordinalITEM_IMBUERATE = reader.GetOrdinal(DbNames.ITEM_IMBUERATE);
int ordinalITEM_IMBUEINCREASE = reader.GetOrdinal(DbNames.ITEM_IMBUEINCREASE);
int ordinalITEM_IMBUEDATA = reader.GetOrdinal(DbNames.ITEM_IMBUEDATA);
int ordinalITEM_BOOKSKILLID = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLID);
int ordinalITEM_BOOKSKILLLEVEL = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLLEVEL);
int ordinalITEM_BOOKSKILLDATA = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLDATA);
int ordinalITEM_MAXPOLISHTRIES = reader.GetOrdinal(DbNames.ITEM_MAXPOLISHTRIES);
int ordinalITEM_POLISHTRIES = reader.GetOrdinal(DbNames.ITEM_POLISHTRIES);
int ordinalITEM_VIGISTAT1 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT1);
int ordinalITEM_VIGISTAT2 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT2);
int ordinalITEM_VIGISTAT3 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT3);
int ordinalITEM_VIGISTAT4 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT4);
int ordinalITEM_VIGISTATADD1 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD1);
int ordinalITEM_VIGISTATADD2 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD2);
int ordinalITEM_VIGISTATADD3 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD3);
int ordinalITEM_VIGISTATADD4 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD4);
int ordinalITEM_PETID = reader.GetOrdinal(DbNames.ITEM_PETID);
int ordinalITEM_DAMAGEABSORB = reader.GetOrdinal(DbNames.ITEM_DAMAGEABSORB);
int ordinalITEM_DEFENSEABSORB = reader.GetOrdinal(DbNames.ITEM_DEFENSEABSORB);
int ordinalITEM_ATTACKRATINGABSORB = reader.GetOrdinal(DbNames.ITEM_ATTACKRATINGABSORB);
int ordinalITEM_LIFEABSORB = reader.GetOrdinal(DbNames.ITEM_LIFEABSORB);
int ordinalITEM_BAG = reader.GetOrdinal(DbNames.ITEM_BAG);
int ordinalITEM_SLOT = reader.GetOrdinal(DbNames.ITEM_SLOT);
int ordinalITEM_SIZEX = reader.GetOrdinal(DbNames.ITEM_SIZEX);
int ordinalITEM_SIZEY = reader.GetOrdinal(DbNames.ITEM_SIZEY);
while (reader.Read())
{
BaseItem b = null;
int BType = reader.GetByte(ordinalITEM_BTYPE);
int BKind = reader.GetByte(ordinalITEM_BKIND);
if (BType == (byte)bType.Weapon || BType == (byte)bType.Clothes || BType == (byte)bType.Hat || BType == (byte)bType.Necklace
|| BType == (byte)bType.Ring || BType == (byte)bType.Shoes || BType == (byte)bType.Cape || BType == (byte)bType.Mirror)
{
if (BKind == (byte)bKindWeapons.Sword && BType == (byte)bType.Weapon)
{
b = new Sword();
}
if (BKind == (byte)bKindWeapons.Blade && BType == (byte)bType.Weapon)
{
b = new Blade();
}
if (BKind == (byte)bKindWeapons.Fan && BType == (byte)bType.Weapon)
{
b = new Fan();
}
if (BKind == (byte)bKindWeapons.Brush && BType == (byte)bType.Weapon)
{
b = new Brush();
}
if (BKind == (byte)bKindWeapons.Claw && BType == (byte)bType.Weapon)
{
b = new Claw();
}
if (BKind == (byte)bKindWeapons.Axe && BType == (byte)bType.Weapon)
{
b = new Axe();
}
if (BKind == (byte)bKindWeapons.Talon && BType == (byte)bType.Weapon)
{
b = new Talon();
}
if (BKind == (byte)bKindWeapons.Tonfa && BType == (byte)bType.Weapon)
{
b = new Tonfa();
}
if (BKind == (byte)bKindArmors.SwordMan && BType == (byte)bType.Clothes)
{
b = new Clothes();
}
if (BKind == (byte)bKindArmors.Mage && BType == (byte)bType.Clothes)
{
b = new Dress();
}
if (BKind == (byte)bKindArmors.Warrior && BType == (byte)bType.Clothes)
{
b = new Armor();
}
if (BKind == (byte)bKindArmors.GhostFighter && BType == (byte)bType.Clothes)
{
b = new LeatherClothes();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Hat)
{
b = new Hood();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Hat)
{
b = new Tiara();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Hat)
{
b = new Helmet();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Hat)
{
b = new Hat();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Shoes)
{
b = new SmBoots();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Shoes)
{
b = new MageBoots();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Shoes)
{
b = new WarriorShoes();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Shoes)
{
b = new GhostFighterShoes();
}
if (BKind == 0 && BType == (byte)bType.Ring)
{
b = new Ring();
}
if (BKind == 0 && BType == (byte)bType.Necklace)
{
b = new Necklace();
}
if (BType == (byte)bType.Cape)
{
b = new Cape();
Cape c = b as Cape;
c.MaxPolishImbueTries = reader.GetInt16(ordinalITEM_MAXPOLISHTRIES);
c.PolishImbueTries = reader.GetByte(ordinalITEM_POLISHTRIES);
c.VigiStat1 = reader.GetInt16(ordinalITEM_VIGISTAT1);
c.VigiStatAdd1 = reader.GetInt16(ordinalITEM_VIGISTATADD1);
c.VigiStat2 = reader.GetInt16(ordinalITEM_VIGISTAT2);
c.VigiStatAdd2 = reader.GetInt16(ordinalITEM_VIGISTATADD2);
c.VigiStat3 = reader.GetInt16(ordinalITEM_VIGISTAT3);
c.VigiStatAdd3 = reader.GetInt16(ordinalITEM_VIGISTATADD3);
c.VigiStat4 = reader.GetInt16(ordinalITEM_VIGISTAT4);
c.VigiStatAdd4 = reader.GetInt16(ordinalITEM_VIGISTATADD4);
}
if (BType == (byte)bType.Mirror)
{
// bkind 4 = mirror, 0 = jar
b = new Mirror();
Mirror m = b as Mirror;
m.PetID = reader.GetInt32(ordinalITEM_PETID);
m.LifeAbsorb = reader.GetInt16(ordinalITEM_LIFEABSORB);
m.DamageAbsorb = reader.GetInt16(ordinalITEM_DAMAGEABSORB);
m.DefenseAbsorb = reader.GetInt16(ordinalITEM_DEFENSEABSORB);
m.AttackRatingAbsorb = reader.GetInt16(ordinalITEM_ATTACKRATINGABSORB);
}
Equipment e = b as Equipment;
e.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
e.RequiredDexterity = reader.GetInt16(ordinalITEM_DEX);
e.RequiredStrength = reader.GetInt16(ordinalITEM_STR);
e.RequiredStamina = reader.GetInt16(ordinalITEM_STA);
e.RequiredEnergy = reader.GetInt16(ordinalITEM_ENE);
e.MaxImbueTries = reader.GetByte(ordinalITEM_MAXIMBUES);
e.Durability = reader.GetInt16(ordinalITEM_CURDURA);
e.MaxDurability = reader.GetInt16(ordinalITEM_MAXDURA);
e.Damage = reader.GetInt32(ordinalITEM_DAMAGE);
e.Defence = reader.GetInt32(ordinalITEM_DEFENCE);
e.AttackRating = reader.GetInt32(ordinalITEM_ATTACKRATING);
e.AttackSpeed = reader.GetInt16(ordinalITEM_ATTACKSPEED);
e.AttackRange = reader.GetInt16(ordinalITEM_ATTACKRANGE);
e.IncMaxLife = reader.GetInt16(ordinalITEM_INCMAXLIFE);
e.IncMaxMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
e.IncLifeRegen = reader.GetInt16(ordinalITEM_LIFEREGEN);
e.IncManaRegen = reader.GetInt16(ordinalITEM_MANAREGEN);
e.Critical = reader.GetInt16(ordinalITEM_CRITICAL);
e.Plus = reader.GetByte(ordinalITEM_PLUS);
e.Slvl = reader.GetByte(ordinalITEM_SLVL);
e.ImbueTries = reader.GetByte(ordinalITEM_IMBUETRIES);
e.DragonSuccessImbueTries = reader.GetInt16(ordinalITEM_DRAGONSUCCESSIMBUETRIES);
e.DiscountRepairFee = reader.GetByte(ordinalITEM_DISCOUNTREPAIRFEE);
e.TotalDragonImbueTries = reader.GetInt16(ordinalITEM_TOTALDRAGONIMBUES);
e.DragonDamage = reader.GetInt32(ordinalITEM_DRAGONDAMAGE);
e.DragonDefence = reader.GetInt32(ordinalITEM_DRAGONDEFENCE);
e.DragonAttackRating = reader.GetInt32(ordinalITEM_DRAGONATTACKRATING);
e.DragonLife = reader.GetInt16(ordinalITEM_DRAGONLIFE);
e.MappedData = reader.GetByte(ordinalITEM_MAPPEDSTUFF);
e.ForceSlot = reader.GetByte(ordinalITEM_FORCENUMBER);
e.RebirthHole = reader.GetInt16(ordinalITEM_REBIRTHHOLE);
e.RebirthHoleStat = reader.GetInt16(ordinalITEM_REBIRTHHOLESTAT);
}
if (BType == (byte)bType.ImbueItem)
{
if (BKind == (byte)bKindStones.Black)
{
b = new Black();
}
if (BKind == (byte)bKindStones.White)
{
b = new White();
}
if (BKind == (byte)bKindStones.Red)
{
b = new Red();
}
if (BKind == (byte)bKindStones.Dragon)
{
b = new Dragon();
}
if (BKind == (byte)bKindStones.RbItem)
{
b = new RbHoleItem();
}
ImbueItem im = b as ImbueItem;
im.ImbueChance = reader.GetInt16(ordinalITEM_IMBUERATE);
im.IncreaseValue = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
im.ImbueData = reader.GetByte(ordinalITEM_IMBUEDATA);
}
if (BType == (byte)bType.Potion)
{
if (BKind == (byte)bKindPotions.Normal)
{
b = new Potion();
}
if (BKind == (byte)bKindPotions.Elixir)
{
b = new Elixir();
}
PotionItem pot = b as PotionItem;
pot.HealHp = reader.GetInt16(ordinalITEM_INCMAXLIFE);
pot.HealMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
}
if (BType == (byte)bType.Book)
{
if (BKind == (byte)bKindBooks.SoftBook)
{
b = new SoftBook();
}
if (BKind == (byte)bKindBooks.HardBook)
{
b = new HardBook();
}
if (BKind == (byte)bKindBooks.RebirdBook)
{
b = new RebirthBook();
}
if (BKind == (byte)bKindBooks.FourthBook)
{
b = new FourthBook();
}
if (BKind == (byte)bKindBooks.FeSkillBook)
{
b = new FeSkillBook();
}
if (BKind == (byte)bKindBooks.FeBook)
{
b = new FiveElementBook();
}
if (BKind == (byte)bKindBooks.FocusBook)
{
b = new FocusBook();
}
BookItem book = b as BookItem;
book.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
book.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
book.SkillID = reader.GetInt32(ordinalITEM_BOOKSKILLID);
book.SkillLevel = reader.GetByte(ordinalITEM_BOOKSKILLLEVEL);
book.SkillData = reader.GetInt32(ordinalITEM_BOOKSKILLDATA);
}
if (BType == (byte)bType.Bead)
{
if (BKind == (byte)bKindBeads.Normal)
{
b = new Bead();
}
BeadItem bead = b as BeadItem;
bead.ToMapID = reader.GetInt32(ordinalITEM_TOMAPID);
}
if (BType == (byte)bType.StoreTag)
{
b = new StoreTag();
StoreTag tag = b as StoreTag;
tag.TimeLeft = reader.GetInt16(ordinalITEM_CURDURA);
tag.TimeMax = reader.GetInt16(ordinalITEM_MAXDURA);
}
if (BType == (byte)bType.PetItem)
{
if (BKind == (byte)bKindPetItems.Taming)
b = new TameItem();
if (BKind == (byte)bKindPetItems.Food)
b = new PetFood();
if (BKind == (byte)bKindPetItems.Potion)
b = new PetPotion();
if (BKind == (byte)bKindPetItems.Resurect)
b = new PetResurrectItem();
PetItem p = b as PetItem;
p.TameChance = reader.GetInt16(ordinalITEM_IMBUERATE);
p.DecreaseWildness = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
p.HealLife = reader.GetInt16(ordinalITEM_INCMAXLIFE);
}
if (BType == (byte)bType.Pill)
{
if (BKind == (byte)bKindPills.Rebirth)
b = new RebirthPill();
RebirthPill p = b as RebirthPill;
p.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
p.RequiredRebirth = reader.GetByte(ordinalITEM_CLASS);
p.ToRebirth = (byte)(p.RequiredRebirth + 1);
p.IncreaseSp = reader.GetInt16(ordinalITEM_DEX);
}
b.ItemID = reader.GetInt32(ordinalITEM_ITEMID);
b.OwnerID = reader.GetInt32(ordinalITEM_OWNERID);
b.ReferenceID = reader.GetInt16(ordinalITEM_REFERENCEID);
b.VisualID = reader.GetInt16(ordinalITEM_VISUALID);
b.Bag = reader.GetByte(ordinalITEM_BAG);
b.Slot = reader.GetByte(ordinalITEM_SLOT);
b.bType = reader.GetByte(ordinalITEM_BTYPE);
b.bKind = reader.GetByte(ordinalITEM_BKIND);
b.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
b.Amount = reader.GetInt16(ordinalITEM_AMOUNT);
b.SizeX = reader.GetByte(ordinalITEM_SIZEX);
b.SizeY = reader.GetByte(ordinalITEM_SIZEY);
b.Price = reader.GetInt32(ordinalITEM_COST);
items.Add(b);
}
reader.Close();
_db.Close();
return items;
}
public void CanSwitchWhiteLightsOnForZoneOne()
{
var controller = new WifiController("192.168.0.6");
controller.Send(White.On(Zone.One));
}
public BaseItem GetImbueDropItem()
{
List<BaseItem> items = new List<BaseItem>();
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETIMBUEDROPITEM_STOREDPROC, CommandType.StoredProcedure);
int ordinalITEM_REFERENCEID = reader.GetOrdinal(DbNames.ITEM_REFERENCEID);
int ordinalITEM_BTYPE = reader.GetOrdinal(DbNames.ITEM_BTYPE);
int ordinalITEM_BKIND = reader.GetOrdinal(DbNames.ITEM_BKIND);
int ordinalITEM_VISUALID = reader.GetOrdinal(DbNames.ITEM_VISUALID);
int ordinalITEM_COST = reader.GetOrdinal(DbNames.ITEM_COST);
int ordinalITEM_CLASS = reader.GetOrdinal(DbNames.ITEM_CLASS);
int ordinalITEM_LEVEL = reader.GetOrdinal(DbNames.ITEM_LEVEL);
int ordinalITEM_DEX = reader.GetOrdinal(DbNames.ITEM_DEX);
int ordinalITEM_STR = reader.GetOrdinal(DbNames.ITEM_STR);
int ordinalITEM_STA = reader.GetOrdinal(DbNames.ITEM_STA);
int ordinalITEM_ENE = reader.GetOrdinal(DbNames.ITEM_ENE);
int ordinalITEM_MAXIMBUES = reader.GetOrdinal(DbNames.ITEM_MAXIMBUES);
int ordinalITEM_MAXDURA = reader.GetOrdinal(DbNames.DROPITEM_DURABILITY);
int ordinalITEM_DAMAGE = reader.GetOrdinal(DbNames.ITEM_DAMAGE);
int ordinalITEM_DEFENCE = reader.GetOrdinal(DbNames.ITEM_DEFENCE);
int ordinalITEM_ATTACKRATING = reader.GetOrdinal(DbNames.ITEM_ATTACKRATING);
int ordinalITEM_ATTACKSPEED = reader.GetOrdinal(DbNames.ITEM_ATTACKSPEED);
int ordinalITEM_ATTACKRANGE = reader.GetOrdinal(DbNames.ITEM_ATTACKRANGE);
int ordinalITEM_INCMAXLIFE = reader.GetOrdinal(DbNames.ITEM_INCMAXLIFE);
int ordinalITEM_INCMAXMANA = reader.GetOrdinal(DbNames.ITEM_INCMAXMANA);
int ordinalITEM_LIFEREGEN = reader.GetOrdinal(DbNames.ITEM_LIFEREGEN);
int ordinalITEM_MANAREGEN = reader.GetOrdinal(DbNames.ITEM_MANAREGEN);
int ordinalITEM_CRITICAL = reader.GetOrdinal(DbNames.ITEM_CRITICAL);
int ordinalITEM_TOMAPID = reader.GetOrdinal(DbNames.ITEM_TOMAPID);
int ordinalITEM_IMBUERATE = reader.GetOrdinal(DbNames.ITEM_IMBUERATE);
int ordinalITEM_IMBUEINCREASE = reader.GetOrdinal(DbNames.ITEM_IMBUEINCREASE);
int ordinalITEM_BOOKSKILLID = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLID);
int ordinalITEM_BOOKSKILLLEVEL = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLLEVEL);
int ordinalITEM_BOOKSKILLDATA = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLDATA);
int ordinalITEM_MAXPOLISHTRIES = reader.GetOrdinal(DbNames.ITEM_MAXPOLISHTRIES);
int ordinalITEM_POLISHTRIES = reader.GetOrdinal(DbNames.ITEM_POLISHTRIES);
int ordinalITEM_SIZEX = reader.GetOrdinal(DbNames.ITEM_SIZEX);
int ordinalITEM_SIZEY = reader.GetOrdinal(DbNames.ITEM_SIZEY);
while (reader.Read())
{
BaseItem b = null;
int BType = reader.GetByte(ordinalITEM_BTYPE);
int BKind = reader.GetByte(ordinalITEM_BKIND);
if (BType == (byte)bType.ImbueItem)
{
if (BKind == (byte)bKindStones.Black)
{
b = new Black();
}
if (BKind == (byte)bKindStones.White)
{
b = new White();
}
if (BKind == (byte)bKindStones.Red)
{
b = new Red();
}
if (BKind == (byte)bKindStones.Dragon)
{
b = new Dragon();
}
if (BKind == (byte)bKindStones.RbItem)
{
b = new RbHoleItem();
}
ImbueItem im = b as ImbueItem;
im.ImbueChance = reader.GetInt16(ordinalITEM_IMBUERATE);
im.IncreaseValue = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
}
b.ItemID = 0;
b.OwnerID = 0;
b.ReferenceID = reader.GetInt16(ordinalITEM_REFERENCEID);
b.VisualID = reader.GetInt16(ordinalITEM_VISUALID);
b.Bag = 0;
b.Slot = 0;
b.bType = reader.GetByte(ordinalITEM_BTYPE);
b.bKind = reader.GetByte(ordinalITEM_BKIND);
b.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
b.Amount = 1;
b.SizeX = reader.GetByte(ordinalITEM_SIZEX);
b.SizeY = reader.GetByte(ordinalITEM_SIZEY);
b.Price = reader.GetInt32(ordinalITEM_COST);
items.Add(b);
}
reader.Close();
_db.Close();
if (items.Count > 0)
{
Random rand = new Random();
int itemPos = rand.Next(0, items.Count);
return items[itemPos];
}
else
return null;
}
/// <summary>
/// Sets the <see cref="RGBWLights"/> and
/// <see cref="RGBLights"/> to white and
/// switches 'on' all <see cref="WhiteLights"/>.
/// </summary>
public void AllWhite()
{
RGBW.SwitchWhite(0);
White.SwitchOn();
RGB.SetColor(Color.White);
}
public BaseItem GetItemByItemID(int itemID)
{
DbParameter itemIdParameter = _db.CreateParameter(DbNames.GETITEMBYITEMID_ITEMID_PARAMETER, itemID);
itemIdParameter.DbType = DbType.Int32;
BaseItem b = null;
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETITEMBYITEMID_STOREDPROC, CommandType.StoredProcedure, itemIdParameter);
int ordinalITEM_ITEMID = reader.GetOrdinal(DbNames.ITEM_ITEMID);
int ordinalITEM_OWNERID = reader.GetOrdinal(DbNames.ITEM_OWNERID);
int ordinalITEM_REFERENCEID = reader.GetOrdinal(DbNames.ITEM_REFERENCEID);
int ordinalITEM_BTYPE = reader.GetOrdinal(DbNames.ITEM_BTYPE);
int ordinalITEM_BKIND = reader.GetOrdinal(DbNames.ITEM_BKIND);
int ordinalITEM_VISUALID = reader.GetOrdinal(DbNames.ITEM_VISUALID);
int ordinalITEM_COST = reader.GetOrdinal(DbNames.ITEM_COST);
int ordinalITEM_CLASS = reader.GetOrdinal(DbNames.ITEM_CLASS);
int ordinalITEM_AMOUNT = reader.GetOrdinal(DbNames.ITEM_AMOUNT);
int ordinalITEM_LEVEL = reader.GetOrdinal(DbNames.ITEM_LEVEL);
int ordinalITEM_DEX = reader.GetOrdinal(DbNames.ITEM_DEX);
int ordinalITEM_STR = reader.GetOrdinal(DbNames.ITEM_STR);
int ordinalITEM_STA = reader.GetOrdinal(DbNames.ITEM_STA);
int ordinalITEM_ENE = reader.GetOrdinal(DbNames.ITEM_ENE);
int ordinalITEM_MAXIMBUES = reader.GetOrdinal(DbNames.ITEM_MAXIMBUES);
int ordinalITEM_MAXDURA = reader.GetOrdinal(DbNames.ITEM_MAXDURA);
int ordinalITEM_CURDURA = reader.GetOrdinal(DbNames.ITEM_CURDURA);
int ordinalITEM_DAMAGE = reader.GetOrdinal(DbNames.ITEM_DAMAGE);
int ordinalITEM_DEFENCE = reader.GetOrdinal(DbNames.ITEM_DEFENCE);
int ordinalITEM_ATTACKRATING = reader.GetOrdinal(DbNames.ITEM_ATTACKRATING);
int ordinalITEM_ATTACKSPEED = reader.GetOrdinal(DbNames.ITEM_ATTACKSPEED);
int ordinalITEM_ATTACKRANGE = reader.GetOrdinal(DbNames.ITEM_ATTACKRANGE);
int ordinalITEM_INCMAXLIFE = reader.GetOrdinal(DbNames.ITEM_INCMAXLIFE);
int ordinalITEM_INCMAXMANA = reader.GetOrdinal(DbNames.ITEM_INCMAXMANA);
int ordinalITEM_LIFEREGEN = reader.GetOrdinal(DbNames.ITEM_LIFEREGEN);
int ordinalITEM_MANAREGEN = reader.GetOrdinal(DbNames.ITEM_MANAREGEN);
int ordinalITEM_CRITICAL = reader.GetOrdinal(DbNames.ITEM_CRITICAL);
int ordinalITEM_PLUS = reader.GetOrdinal(DbNames.ITEM_PLUS);
int ordinalITEM_SLVL = reader.GetOrdinal(DbNames.ITEM_SLVL);
int ordinalITEM_IMBUETRIES = reader.GetOrdinal(DbNames.ITEM_IMBUETRIES);
int ordinalITEM_DRAGONSUCCESSIMBUETRIES = reader.GetOrdinal(DbNames.ITEM_DRAGONSUCCESSIMBUETRIES);
int ordinalITEM_DISCOUNTREPAIRFEE = reader.GetOrdinal(DbNames.ITEM_DISCOUNTREPAIRFEE);
int ordinalITEM_TOTALDRAGONIMBUES = reader.GetOrdinal(DbNames.ITEM_TOTALDRAGONIMBUES);
int ordinalITEM_DRAGONDAMAGE = reader.GetOrdinal(DbNames.ITEM_DRAGONDAMAGE);
int ordinalITEM_DRAGONDEFENCE = reader.GetOrdinal(DbNames.ITEM_DRAGONDEFENCE);
int ordinalITEM_DRAGONATTACKRATING = reader.GetOrdinal(DbNames.ITEM_DRAGONATTACKRATING);
int ordinalITEM_DRAGONLIFE = reader.GetOrdinal(DbNames.ITEM_DRAGONLIFE);
int ordinalITEM_MAPPEDSTUFF = reader.GetOrdinal(DbNames.ITEM_MAPPEDSTUFF);
int ordinalITEM_FORCENUMBER = reader.GetOrdinal(DbNames.ITEM_FORCENUMBER);
int ordinalITEM_REBIRTHHOLE = reader.GetOrdinal(DbNames.ITEM_REBIRTHHOLE);
int ordinalITEM_REBIRTHHOLEITEM = reader.GetOrdinal(DbNames.ITEM_REBIRTHHOLEITEM);
int ordinalITEM_REBIRTHHOLESTAT = reader.GetOrdinal(DbNames.ITEM_REBIRTHHOLESTAT);
int ordinalITEM_TOMAPID = reader.GetOrdinal(DbNames.ITEM_TOMAPID);
int ordinalITEM_IMBUERATE = reader.GetOrdinal(DbNames.ITEM_IMBUERATE);
int ordinalITEM_IMBUEINCREASE = reader.GetOrdinal(DbNames.ITEM_IMBUEINCREASE);
int ordinalITEM_BOOKSKILLID = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLID);
int ordinalITEM_BOOKSKILLLEVEL = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLLEVEL);
int ordinalITEM_BOOKSKILLDATA = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLDATA);
int ordinalITEM_MAXPOLISHTRIES = reader.GetOrdinal(DbNames.ITEM_MAXPOLISHTRIES);
int ordinalITEM_POLISHTRIES = reader.GetOrdinal(DbNames.ITEM_POLISHTRIES);
int ordinalITEM_VIGISTAT1 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT1);
int ordinalITEM_VIGISTAT2 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT2);
int ordinalITEM_VIGISTAT3 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT3);
int ordinalITEM_VIGISTAT4 = reader.GetOrdinal(DbNames.ITEM_VIGISTAT4);
int ordinalITEM_VIGISTATADD1 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD1);
int ordinalITEM_VIGISTATADD2 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD2);
int ordinalITEM_VIGISTATADD3 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD3);
int ordinalITEM_VIGISTATADD4 = reader.GetOrdinal(DbNames.ITEM_VIGISTATADD4);
int ordinalITEM_BAG = reader.GetOrdinal(DbNames.ITEM_BAG);
int ordinalITEM_SLOT = reader.GetOrdinal(DbNames.ITEM_SLOT);
int ordinalITEM_SIZEX = reader.GetOrdinal(DbNames.ITEM_SIZEX);
int ordinalITEM_SIZEY = reader.GetOrdinal(DbNames.ITEM_SIZEY);
while (reader.Read())
{
int BType = reader.GetByte(ordinalITEM_BTYPE);
int BKind = reader.GetByte(ordinalITEM_BKIND);
if (BType == (byte)bType.Weapon || BType == (byte)bType.Clothes || BType == (byte)bType.Hat || BType == (byte)bType.Necklace
|| BType == (byte)bType.Ring || BType == (byte)bType.Shoes || BType == (byte)bType.Cape)
{
if (BKind == (byte)bKindWeapons.Sword && BType == (byte)bType.Weapon)
{
b = new Sword();
}
if (BKind == (byte)bKindWeapons.Blade && BType == (byte)bType.Weapon)
{
b = new Blade();
}
if (BKind == (byte)bKindWeapons.Fan && BType == (byte)bType.Weapon)
{
b = new Fan();
}
if (BKind == (byte)bKindWeapons.Brush && BType == (byte)bType.Weapon)
{
b = new Brush();
}
if (BKind == (byte)bKindWeapons.Claw && BType == (byte)bType.Weapon)
{
b = new Claw();
}
if (BKind == (byte)bKindWeapons.Axe && BType == (byte)bType.Weapon)
{
b = new Axe();
}
if (BKind == (byte)bKindWeapons.Talon && BType == (byte)bType.Weapon)
{
b = new Talon();
}
if (BKind == (byte)bKindWeapons.Tonfa && BType == (byte)bType.Weapon)
{
b = new Tonfa();
}
if (BKind == (byte)bKindArmors.SwordMan && BType == (byte)bType.Clothes)
{
b = new Clothes();
}
if (BKind == (byte)bKindArmors.Mage && BType == (byte)bType.Clothes)
{
b = new Dress();
}
if (BKind == (byte)bKindArmors.Warrior && BType == (byte)bType.Clothes)
{
b = new Armor();
}
if (BKind == (byte)bKindArmors.GhostFighter && BType == (byte)bType.Clothes)
{
b = new LeatherClothes();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Hat)
{
b = new Hood();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Hat)
{
b = new Tiara();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Hat)
{
b = new Helmet();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Hat)
{
b = new Hat();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Shoes)
{
b = new SmBoots();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Shoes)
{
b = new MageBoots();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Shoes)
{
b = new WarriorShoes();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Shoes)
{
b = new GhostFighterShoes();
}
if (BKind == 0 && BType == (byte)bType.Ring)
{
b = new Ring();
}
if (BKind == 0 && BType == (byte)bType.Necklace)
{
b = new Necklace();
}
if (BType == (byte)bType.Cape)
{
b = new Cape();
Cape c = b as Cape;
c.MaxPolishImbueTries = reader.GetInt16(ordinalITEM_MAXPOLISHTRIES);
c.PolishImbueTries = reader.GetByte(ordinalITEM_POLISHTRIES);
c.VigiStat1 = reader.GetInt16(ordinalITEM_VIGISTAT1);
c.VigiStatAdd1 = reader.GetInt16(ordinalITEM_VIGISTATADD1);
c.VigiStat2 = reader.GetInt16(ordinalITEM_VIGISTAT2);
c.VigiStatAdd2 = reader.GetInt16(ordinalITEM_VIGISTATADD2);
c.VigiStat3 = reader.GetInt16(ordinalITEM_VIGISTAT3);
c.VigiStatAdd3 = reader.GetInt16(ordinalITEM_VIGISTATADD3);
c.VigiStat4 = reader.GetInt16(ordinalITEM_VIGISTAT4);
c.VigiStatAdd4 = reader.GetInt16(ordinalITEM_VIGISTATADD4);
}
Equipment e = b as Equipment;
e.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
e.RequiredDexterity = reader.GetInt16(ordinalITEM_DEX);
e.RequiredStrength = reader.GetInt16(ordinalITEM_STR);
e.RequiredStamina = reader.GetInt16(ordinalITEM_STA);
e.RequiredEnergy = reader.GetInt16(ordinalITEM_ENE);
e.MaxImbueTries = reader.GetByte(ordinalITEM_MAXIMBUES);
e.Durability = reader.GetInt16(ordinalITEM_CURDURA);
e.MaxDurability = reader.GetInt16(ordinalITEM_MAXDURA);
e.Damage = reader.GetInt16(ordinalITEM_DAMAGE);
e.Defence = reader.GetInt16(ordinalITEM_DEFENCE);
e.AttackRating = reader.GetInt16(ordinalITEM_ATTACKRATING);
e.AttackSpeed = reader.GetInt16(ordinalITEM_ATTACKSPEED);
e.AttackRange = reader.GetInt16(ordinalITEM_ATTACKRANGE);
e.IncMaxLife = reader.GetInt16(ordinalITEM_INCMAXLIFE);
e.IncMaxMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
e.IncLifeRegen = reader.GetInt16(ordinalITEM_LIFEREGEN);
e.IncManaRegen = reader.GetInt16(ordinalITEM_MANAREGEN);
e.Critical = reader.GetInt16(ordinalITEM_CRITICAL);
e.Plus = reader.GetByte(ordinalITEM_PLUS);
e.Slvl = reader.GetByte(ordinalITEM_SLVL);
e.ImbueTries = reader.GetByte(ordinalITEM_IMBUETRIES);
e.DragonSuccessImbueTries = reader.GetInt16(ordinalITEM_DRAGONSUCCESSIMBUETRIES);
e.DiscountRepairFee = reader.GetByte(ordinalITEM_DISCOUNTREPAIRFEE);
e.TotalDragonImbueTries = reader.GetInt16(ordinalITEM_TOTALDRAGONIMBUES);
e.DragonDamage = reader.GetInt16(ordinalITEM_DRAGONDAMAGE);
e.DragonDefence = reader.GetInt16(ordinalITEM_DRAGONDEFENCE);
e.DragonAttackRating = reader.GetInt16(ordinalITEM_DRAGONATTACKRATING);
e.DragonLife = reader.GetInt16(ordinalITEM_DRAGONLIFE);
e.MappedData = reader.GetByte(ordinalITEM_MAPPEDSTUFF);
e.ForceSlot = reader.GetByte(ordinalITEM_FORCENUMBER);
e.RebirthHole = reader.GetByte(ordinalITEM_REBIRTHHOLE);
e.RebirthHoleItem = reader.GetByte(ordinalITEM_REBIRTHHOLEITEM);
e.RebirthHoleStat = reader.GetInt16(ordinalITEM_REBIRTHHOLESTAT);
}
if (BType == (byte)bType.ImbueItem)
{
if (BKind == (byte)bKindStones.Black)
{
b = new Black();
}
if (BKind == (byte)bKindStones.White)
{
b = new White();
}
if (BKind == (byte)bKindStones.Red)
{
b = new Red();
}
if (BKind == (byte)bKindStones.Dragon)
{
b = new Dragon();
}
ImbueItem im = b as ImbueItem;
im.ImbueChance = reader.GetInt16(ordinalITEM_IMBUERATE);
im.IncreaseValue = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
}
if (BType == (byte)bType.Potion)
{
if (BKind == (byte)bKindPotions.Normal)
{
b = new Potion();
}
if (BKind == (byte)bKindPotions.Elixir)
{
b = new Elixir();
}
PotionItem pot = b as PotionItem;
pot.HealHp = reader.GetInt16(ordinalITEM_INCMAXLIFE);
pot.HealMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
}
if (BType == (byte)bType.Book)
{
if (BKind == (byte)bKindBooks.SoftBook)
{
b = new SoftBook();
}
if (BKind == (byte)bKindBooks.HardBook)
{
b = new HardBook();
}
BookItem book = b as BookItem;
book.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
book.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
book.SkillID = reader.GetInt32(ordinalITEM_BOOKSKILLID);
book.SkillLevel = reader.GetByte(ordinalITEM_BOOKSKILLLEVEL);
book.SkillData = reader.GetInt32(ordinalITEM_BOOKSKILLDATA);
}
if (BType == (byte)bType.Bead)
{
if (BKind == (byte)bKindBeads.Normal)
{
b = new Bead();
}
BeadItem bead = b as BeadItem;
bead.ToMapID = reader.GetInt32(ordinalITEM_TOMAPID);
}
b.ItemID = reader.GetInt32(ordinalITEM_ITEMID);
b.OwnerID = reader.GetInt32(ordinalITEM_OWNERID);
b.ReferenceID = reader.GetInt16(ordinalITEM_REFERENCEID);
b.VisualID = reader.GetInt16(ordinalITEM_VISUALID);
b.Bag = reader.GetByte(ordinalITEM_BAG);
b.Slot = reader.GetByte(ordinalITEM_SLOT);
b.bType = reader.GetByte(ordinalITEM_BTYPE);
b.bKind = reader.GetByte(ordinalITEM_BKIND);
b.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
b.Amount = reader.GetInt16(ordinalITEM_AMOUNT);
b.SizeX = reader.GetByte(ordinalITEM_SIZEX);
b.SizeY = reader.GetByte(ordinalITEM_SIZEY);
b.Price = reader.GetInt32(ordinalITEM_COST);
}
reader.Close();
_db.Close();
return b;
}
public List<BaseItem> GetAllItemsInNpcBag(byte bag, int npcId)
{
DbParameter bagIdParameter = _db.CreateParameter(DbNames.GETALLNPCITEMSBYBAGID_BAGID_PARAMETER, bag);
bagIdParameter.DbType = DbType.Byte;
DbParameter characterIdParameter = _db.CreateParameter(DbNames.GETALLNPCITEMSBYBAGID_NPCID_PARAMETER, npcId);
characterIdParameter.DbType = DbType.Int32;
List<BaseItem> items = new List<BaseItem>();
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLNPCITEMSBYBAGID_STOREDPROC, CommandType.StoredProcedure, bagIdParameter, characterIdParameter);
int ordinalITEM_REFERENCEID = reader.GetOrdinal(DbNames.ITEM_REFID);
int ordinalITEM_BTYPE = reader.GetOrdinal(DbNames.ITEM_BTYPE);
int ordinalITEM_BKIND = reader.GetOrdinal(DbNames.ITEM_BKIND);
int ordinalITEM_VISUALID = reader.GetOrdinal(DbNames.ITEM_VISUALID);
int ordinalITEM_CLASS = reader.GetOrdinal(DbNames.ITEM_CLASS);
int ordinalITEM_AMOUNT = reader.GetOrdinal(DbNames.ITEM_AMOUNT);
int ordinalITEM_PRICE = reader.GetOrdinal(DbNames.ITEM_PRICE);
int ordinalITEM_LEVEL = reader.GetOrdinal(DbNames.ITEM_LEVEL);
int ordinalITEM_DEX = reader.GetOrdinal(DbNames.ITEM_DEX);
int ordinalITEM_STR = reader.GetOrdinal(DbNames.ITEM_STR);
int ordinalITEM_STA = reader.GetOrdinal(DbNames.ITEM_STA);
int ordinalITEM_ENE = reader.GetOrdinal(DbNames.ITEM_ENE);
int ordinalITEM_DURABILITY = reader.GetOrdinal(DbNames.ITEM_DURABILITY);
int ordinalITEM_DAMAGE = reader.GetOrdinal(DbNames.ITEM_DAMAGE);
int ordinalITEM_DEFENCE = reader.GetOrdinal(DbNames.ITEM_DEFENCE);
int ordinalITEM_ATTACKRATING = reader.GetOrdinal(DbNames.ITEM_ATTACKRATING);
int ordinalITEM_ATTACKSPEED = reader.GetOrdinal(DbNames.ITEM_ATTACKSPEED);
int ordinalITEM_ATTACKRANGE = reader.GetOrdinal(DbNames.ITEM_ATTACKRANGE);
int ordinalITEM_INCMAXLIFE = reader.GetOrdinal(DbNames.ITEM_INCMAXLIFE);
int ordinalITEM_INCMAXMANA = reader.GetOrdinal(DbNames.ITEM_INCMAXMANA);
int ordinalITEM_LIFEREGEN = reader.GetOrdinal(DbNames.ITEM_LIFEREGEN);
int ordinalITEM_MANAREGEN = reader.GetOrdinal(DbNames.ITEM_MANAREGEN);
int ordinalITEM_CRITICAL = reader.GetOrdinal(DbNames.ITEM_CRITICAL);
int ordinalITEM_TOMAPID = reader.GetOrdinal(DbNames.ITEM_TOMAPID);
int ordinalITEM_IMBUERATE = reader.GetOrdinal(DbNames.ITEM_IMBUERATE);
int ordinalITEM_IMBUEINCREASE = reader.GetOrdinal(DbNames.ITEM_IMBUEINCREASE);
int ordinalITEM_BOOKSKILLID = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLID);
int ordinalITEM_BOOKSKILLLEVEL = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLLEVEL);
int ordinalITEM_BOOKSKILLDATA = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLDATA);
int ordinalITEM_MAXPOLISHTRIES = reader.GetOrdinal(DbNames.ITEM_MAXPOLISHTRIES);
int ordinalITEM_MAXIMBUETRIES = reader.GetOrdinal(DbNames.ITEM_MAXIMBUES);
int ordinalITEM_BAG = reader.GetOrdinal(DbNames.ITEM_BAG);
int ordinalITEM_SLOT = reader.GetOrdinal(DbNames.ITEM_SLOT);
int ordinalITEM_SIZEX = reader.GetOrdinal(DbNames.ITEM_SIZEX);
int ordinalITEM_SIZEY = reader.GetOrdinal(DbNames.ITEM_SIZEY);
while (reader.Read())
{
BaseItem b = null;
int BType = reader.GetByte(ordinalITEM_BTYPE);
int BKind = reader.GetByte(ordinalITEM_BKIND);
if (BType == (byte)bType.Weapon || BType == (byte)bType.Clothes || BType == (byte)bType.Hat || BType == (byte)bType.Necklace
|| BType == (byte)bType.Ring || BType == (byte)bType.Shoes || BType == (byte)bType.Cape)
{
if (BKind == (byte)bKindWeapons.Sword && BType == (byte)bType.Weapon)
{
b = new Sword();
}
if (BKind == (byte)bKindWeapons.Blade && BType == (byte)bType.Weapon)
{
b = new Blade();
}
if (BKind == (byte)bKindWeapons.Fan && BType == (byte)bType.Weapon)
{
b = new Fan();
}
if (BKind == (byte)bKindWeapons.Brush && BType == (byte)bType.Weapon)
{
b = new Brush();
}
if (BKind == (byte)bKindWeapons.Claw && BType == (byte)bType.Weapon)
{
b = new Claw();
}
if (BKind == (byte)bKindWeapons.Axe && BType == (byte)bType.Weapon)
{
b = new Axe();
}
if (BKind == (byte)bKindWeapons.Talon && BType == (byte)bType.Weapon)
{
b = new Talon();
}
if (BKind == (byte)bKindWeapons.Tonfa && BType == (byte)bType.Weapon)
{
b = new Tonfa();
}
if(BKind == (byte)bKindWeapons.Hammer && BType == (byte)bType.Weapon)
{
b = new Hammer();
}
if (BKind == (byte)bKindArmors.SwordMan && BType == (byte)bType.Clothes)
{
b = new Clothes();
}
if (BKind == (byte)bKindArmors.Mage && BType == (byte)bType.Clothes)
{
b = new Dress();
}
if (BKind == (byte)bKindArmors.Warrior && BType == (byte)bType.Clothes)
{
b = new Armor();
}
if (BKind == (byte)bKindArmors.GhostFighter && BType == (byte)bType.Clothes)
{
b = new LeatherClothes();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Hat)
{
b = new Hood();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Hat)
{
b = new Tiara();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Hat)
{
b = new Helmet();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Hat)
{
b = new Hat();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Shoes)
{
b = new SmBoots();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Shoes)
{
b = new MageBoots();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Shoes)
{
b = new WarriorShoes();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Shoes)
{
b = new GhostFighterShoes();
}
if (BKind == 0 && BType == (byte)bType.Ring)
{
b = new Ring();
}
if (BKind == 0 && BType == (byte)bType.Necklace)
{
b = new Necklace();
}
if (BType == (byte)bType.Cape)
{
b = new Cape();
Cape c = b as Cape;
c.MaxPolishImbueTries = reader.GetInt16(ordinalITEM_MAXPOLISHTRIES);
}
Equipment e = b as Equipment;
e.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
e.RequiredDexterity = reader.GetInt16(ordinalITEM_DEX);
e.RequiredStrength = reader.GetInt16(ordinalITEM_STR);
e.RequiredStamina = reader.GetInt16(ordinalITEM_STA);
e.RequiredEnergy = reader.GetInt16(ordinalITEM_ENE);
e.Durability = reader.GetInt32(ordinalITEM_DURABILITY);
e.MaxDurability = e.Durability;
e.Damage = reader.GetInt16(ordinalITEM_DAMAGE);
e.Defence = reader.GetInt16(ordinalITEM_DEFENCE);
e.AttackRating = reader.GetInt16(ordinalITEM_ATTACKRATING);
e.AttackSpeed = reader.GetInt16(ordinalITEM_ATTACKSPEED);
e.AttackRange = reader.GetInt16(ordinalITEM_ATTACKRANGE);
e.IncMaxLife = reader.GetInt16(ordinalITEM_INCMAXLIFE);
e.IncMaxMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
e.IncLifeRegen = reader.GetInt16(ordinalITEM_LIFEREGEN);
e.IncManaRegen = reader.GetInt16(ordinalITEM_MANAREGEN);
e.Critical = reader.GetInt16(ordinalITEM_CRITICAL);
e.MaxImbueTries = reader.GetByte(ordinalITEM_MAXIMBUETRIES);
}
if (BType == (byte)bType.ImbueItem)
{
if (BKind == (byte)bKindStones.Black)
{
b = new Black();
}
if (BKind == (byte)bKindStones.White)
{
b = new White();
}
if (BKind == (byte)bKindStones.Red)
{
b = new Red();
}
if (BKind == (byte)bKindStones.Dragon)
{
b = new Dragon();
}
ImbueItem im = b as ImbueItem;
im.ImbueChance = reader.GetInt16(ordinalITEM_IMBUERATE);
im.IncreaseValue = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
}
if (BType == (byte)bType.Potion)
{
if (BKind == (byte)bKindPotions.Normal)
{
b = new Potion();
}
if (BKind == (byte)bKindPotions.Elixir)
{
b = new Elixir();
}
PotionItem pot = b as PotionItem;
pot.HealHp = reader.GetInt16(ordinalITEM_INCMAXLIFE);
pot.HealMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
}
if (BType == (byte)bType.Book)
{
if (BKind == (byte)bKindBooks.SoftBook)
{
b = new SoftBook();
}
if (BKind == (byte)bKindBooks.HardBook)
{
b = new HardBook();
}
BookItem book = b as BookItem;
book.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
book.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
book.SkillID = reader.GetInt32(ordinalITEM_BOOKSKILLID);
book.SkillLevel = reader.GetByte(ordinalITEM_BOOKSKILLLEVEL);
book.SkillData = reader.GetInt32(ordinalITEM_BOOKSKILLDATA);
}
if (BType == (byte)bType.Bead)
{
if (BKind == (byte)bKindBeads.Normal)
{
b = new Bead();
}
BeadItem bead = b as BeadItem;
bead.ToMapID = reader.GetInt32(ordinalITEM_TOMAPID);
}
b.ReferenceID = reader.GetInt16(ordinalITEM_REFERENCEID);
b.VisualID = reader.GetInt16(ordinalITEM_VISUALID);
b.Bag = reader.GetByte(ordinalITEM_BAG);
b.Slot = reader.GetByte(ordinalITEM_SLOT);
b.bType = reader.GetByte(ordinalITEM_BTYPE);
b.bKind = reader.GetByte(ordinalITEM_BKIND);
b.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
b.Amount = reader.GetInt16(ordinalITEM_AMOUNT);
b.SizeX = reader.GetByte(ordinalITEM_SIZEX);
b.SizeY = reader.GetByte(ordinalITEM_SIZEY);
b.Price = reader.GetInt32(ordinalITEM_PRICE);
items.Add(b);
}
reader.Close();
_db.Close();
return items;
}
public void SetTwoPlayer()
{
Black.SetHuman();
White.SetHuman();
}
public List <BaseItem> GetAllItemsInNpcBag(byte bag, int npcId)
{
DbParameter bagIdParameter = _db.CreateParameter(DbNames.GETALLNPCITEMSBYBAGID_BAGID_PARAMETER, bag);
bagIdParameter.DbType = DbType.Byte;
DbParameter characterIdParameter = _db.CreateParameter(DbNames.GETALLNPCITEMSBYBAGID_NPCID_PARAMETER, npcId);
characterIdParameter.DbType = DbType.Int32;
List <BaseItem> items = new List <BaseItem>();
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLNPCITEMSBYBAGID_STOREDPROC, CommandType.StoredProcedure, bagIdParameter, characterIdParameter);
int ordinalITEM_REFERENCEID = reader.GetOrdinal(DbNames.ITEM_REFID);
int ordinalITEM_BTYPE = reader.GetOrdinal(DbNames.ITEM_BTYPE);
int ordinalITEM_BKIND = reader.GetOrdinal(DbNames.ITEM_BKIND);
int ordinalITEM_VISUALID = reader.GetOrdinal(DbNames.ITEM_VISUALID);
int ordinalITEM_CLASS = reader.GetOrdinal(DbNames.ITEM_CLASS);
int ordinalITEM_AMOUNT = reader.GetOrdinal(DbNames.ITEM_AMOUNT);
int ordinalITEM_PRICE = reader.GetOrdinal(DbNames.ITEM_PRICE);
int ordinalITEM_LEVEL = reader.GetOrdinal(DbNames.ITEM_LEVEL);
int ordinalITEM_DEX = reader.GetOrdinal(DbNames.ITEM_DEX);
int ordinalITEM_STR = reader.GetOrdinal(DbNames.ITEM_STR);
int ordinalITEM_STA = reader.GetOrdinal(DbNames.ITEM_STA);
int ordinalITEM_ENE = reader.GetOrdinal(DbNames.ITEM_ENE);
int ordinalITEM_DURABILITY = reader.GetOrdinal(DbNames.ITEM_DURABILITY);
int ordinalITEM_DAMAGE = reader.GetOrdinal(DbNames.ITEM_DAMAGE);
int ordinalITEM_DEFENCE = reader.GetOrdinal(DbNames.ITEM_DEFENCE);
int ordinalITEM_ATTACKRATING = reader.GetOrdinal(DbNames.ITEM_ATTACKRATING);
int ordinalITEM_ATTACKSPEED = reader.GetOrdinal(DbNames.ITEM_ATTACKSPEED);
int ordinalITEM_ATTACKRANGE = reader.GetOrdinal(DbNames.ITEM_ATTACKRANGE);
int ordinalITEM_INCMAXLIFE = reader.GetOrdinal(DbNames.ITEM_INCMAXLIFE);
int ordinalITEM_INCMAXMANA = reader.GetOrdinal(DbNames.ITEM_INCMAXMANA);
int ordinalITEM_LIFEREGEN = reader.GetOrdinal(DbNames.ITEM_LIFEREGEN);
int ordinalITEM_MANAREGEN = reader.GetOrdinal(DbNames.ITEM_MANAREGEN);
int ordinalITEM_CRITICAL = reader.GetOrdinal(DbNames.ITEM_CRITICAL);
int ordinalITEM_TOMAPID = reader.GetOrdinal(DbNames.ITEM_TOMAPID);
int ordinalITEM_IMBUERATE = reader.GetOrdinal(DbNames.ITEM_IMBUERATE);
int ordinalITEM_IMBUEINCREASE = reader.GetOrdinal(DbNames.ITEM_IMBUEINCREASE);
int ordinalITEM_BOOKSKILLID = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLID);
int ordinalITEM_BOOKSKILLLEVEL = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLLEVEL);
int ordinalITEM_BOOKSKILLDATA = reader.GetOrdinal(DbNames.ITEM_BOOKSKILLDATA);
int ordinalITEM_MAXPOLISHTRIES = reader.GetOrdinal(DbNames.ITEM_MAXPOLISHTRIES);
int ordinalITEM_MAXIMBUETRIES = reader.GetOrdinal(DbNames.ITEM_MAXIMBUES);
int ordinalITEM_BAG = reader.GetOrdinal(DbNames.ITEM_BAG);
int ordinalITEM_SLOT = reader.GetOrdinal(DbNames.ITEM_SLOT);
int ordinalITEM_SIZEX = reader.GetOrdinal(DbNames.ITEM_SIZEX);
int ordinalITEM_SIZEY = reader.GetOrdinal(DbNames.ITEM_SIZEY);
while (reader.Read())
{
BaseItem b = null;
int BType = reader.GetByte(ordinalITEM_BTYPE);
int BKind = reader.GetByte(ordinalITEM_BKIND);
if (BType == (byte)bType.Weapon || BType == (byte)bType.Clothes || BType == (byte)bType.Hat || BType == (byte)bType.Necklace ||
BType == (byte)bType.Ring || BType == (byte)bType.Shoes || BType == (byte)bType.Cape)
{
if (BKind == (byte)bKindWeapons.Sword && BType == (byte)bType.Weapon)
{
b = new Sword();
}
if (BKind == (byte)bKindWeapons.Blade && BType == (byte)bType.Weapon)
{
b = new Blade();
}
if (BKind == (byte)bKindWeapons.Fan && BType == (byte)bType.Weapon)
{
b = new Fan();
}
if (BKind == (byte)bKindWeapons.Brush && BType == (byte)bType.Weapon)
{
b = new Brush();
}
if (BKind == (byte)bKindWeapons.Claw && BType == (byte)bType.Weapon)
{
b = new Claw();
}
if (BKind == (byte)bKindWeapons.Axe && BType == (byte)bType.Weapon)
{
b = new Axe();
}
if (BKind == (byte)bKindWeapons.Talon && BType == (byte)bType.Weapon)
{
b = new Talon();
}
if (BKind == (byte)bKindWeapons.Tonfa && BType == (byte)bType.Weapon)
{
b = new Tonfa();
}
if (BKind == (byte)bKindWeapons.Hammer && BType == (byte)bType.Weapon)
{
b = new Hammer();
}
if (BKind == (byte)bKindArmors.SwordMan && BType == (byte)bType.Clothes)
{
b = new Clothes();
}
if (BKind == (byte)bKindArmors.Mage && BType == (byte)bType.Clothes)
{
b = new Dress();
}
if (BKind == (byte)bKindArmors.Warrior && BType == (byte)bType.Clothes)
{
b = new Armor();
}
if (BKind == (byte)bKindArmors.GhostFighter && BType == (byte)bType.Clothes)
{
b = new LeatherClothes();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Hat)
{
b = new Hood();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Hat)
{
b = new Tiara();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Hat)
{
b = new Helmet();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Hat)
{
b = new Hat();
}
if (BKind == (byte)bKindHats.SwordMan && BType == (byte)bType.Shoes)
{
b = new SmBoots();
}
if (BKind == (byte)bKindHats.Mage && BType == (byte)bType.Shoes)
{
b = new MageBoots();
}
if (BKind == (byte)bKindHats.Warrior && BType == (byte)bType.Shoes)
{
b = new WarriorShoes();
}
if (BKind == (byte)bKindHats.GhostFighter && BType == (byte)bType.Shoes)
{
b = new GhostFighterShoes();
}
if (BKind == 0 && BType == (byte)bType.Ring)
{
b = new Ring();
}
if (BKind == 0 && BType == (byte)bType.Necklace)
{
b = new Necklace();
}
if (BType == (byte)bType.Cape)
{
b = new Cape();
Cape c = b as Cape;
c.MaxPolishImbueTries = reader.GetInt16(ordinalITEM_MAXPOLISHTRIES);
}
Equipment e = b as Equipment;
e.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
e.RequiredDexterity = reader.GetInt16(ordinalITEM_DEX);
e.RequiredStrength = reader.GetInt16(ordinalITEM_STR);
e.RequiredStamina = reader.GetInt16(ordinalITEM_STA);
e.RequiredEnergy = reader.GetInt16(ordinalITEM_ENE);
e.Durability = reader.GetInt32(ordinalITEM_DURABILITY);
e.MaxDurability = e.Durability;
e.Damage = reader.GetInt16(ordinalITEM_DAMAGE);
e.Defence = reader.GetInt16(ordinalITEM_DEFENCE);
e.AttackRating = reader.GetInt16(ordinalITEM_ATTACKRATING);
e.AttackSpeed = reader.GetInt16(ordinalITEM_ATTACKSPEED);
e.AttackRange = reader.GetInt16(ordinalITEM_ATTACKRANGE);
e.IncMaxLife = reader.GetInt16(ordinalITEM_INCMAXLIFE);
e.IncMaxMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
e.IncLifeRegen = reader.GetInt16(ordinalITEM_LIFEREGEN);
e.IncManaRegen = reader.GetInt16(ordinalITEM_MANAREGEN);
e.Critical = reader.GetInt16(ordinalITEM_CRITICAL);
e.MaxImbueTries = reader.GetByte(ordinalITEM_MAXIMBUETRIES);
}
if (BType == (byte)bType.ImbueItem)
{
if (BKind == (byte)bKindStones.Black)
{
b = new Black();
}
if (BKind == (byte)bKindStones.White)
{
b = new White();
}
if (BKind == (byte)bKindStones.Red)
{
b = new Red();
}
if (BKind == (byte)bKindStones.Dragon)
{
b = new Dragon();
}
ImbueItem im = b as ImbueItem;
im.ImbueChance = reader.GetInt16(ordinalITEM_IMBUERATE);
im.IncreaseValue = reader.GetInt16(ordinalITEM_IMBUEINCREASE);
}
if (BType == (byte)bType.Potion)
{
if (BKind == (byte)bKindPotions.Normal)
{
b = new Potion();
}
if (BKind == (byte)bKindPotions.Elixir)
{
b = new Elixir();
}
PotionItem pot = b as PotionItem;
pot.HealHp = reader.GetInt16(ordinalITEM_INCMAXLIFE);
pot.HealMana = reader.GetInt16(ordinalITEM_INCMAXMANA);
}
if (BType == (byte)bType.Book)
{
if (BKind == (byte)bKindBooks.SoftBook)
{
b = new SoftBook();
}
if (BKind == (byte)bKindBooks.HardBook)
{
b = new HardBook();
}
BookItem book = b as BookItem;
book.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
book.RequiredLevel = reader.GetInt16(ordinalITEM_LEVEL);
book.SkillID = reader.GetInt32(ordinalITEM_BOOKSKILLID);
book.SkillLevel = reader.GetByte(ordinalITEM_BOOKSKILLLEVEL);
book.SkillData = reader.GetInt32(ordinalITEM_BOOKSKILLDATA);
}
if (BType == (byte)bType.Bead)
{
if (BKind == (byte)bKindBeads.Normal)
{
b = new Bead();
}
BeadItem bead = b as BeadItem;
bead.ToMapID = reader.GetInt32(ordinalITEM_TOMAPID);
}
b.ReferenceID = reader.GetInt16(ordinalITEM_REFERENCEID);
b.VisualID = reader.GetInt16(ordinalITEM_VISUALID);
b.Bag = reader.GetByte(ordinalITEM_BAG);
b.Slot = reader.GetByte(ordinalITEM_SLOT);
b.bType = reader.GetByte(ordinalITEM_BTYPE);
b.bKind = reader.GetByte(ordinalITEM_BKIND);
b.RequiredClass = reader.GetByte(ordinalITEM_CLASS);
b.Amount = reader.GetInt16(ordinalITEM_AMOUNT);
b.SizeX = reader.GetByte(ordinalITEM_SIZEX);
b.SizeY = reader.GetByte(ordinalITEM_SIZEY);
b.Price = reader.GetInt32(ordinalITEM_PRICE);
items.Add(b);
}
reader.Close();
_db.Close();
return(items);
}
static White()
{
Instance = new White();
}
