using System;
using System.Data;
using System.Text;
using System.Threading;
using System.Collections;

using Holo.Virtual.Users;
using Ion.Storage;
namespace Holo.Virtual.Arrows
{
    /// <summary>
    /// Represents a job rank
    /// </summary>
    public class virtualArrow
    {
        #region Declares
        internal string Name;
        internal int ID;
        internal int ID2;
        internal int X2;
        internal int Y2;
        internal int X;
        internal int Y;
        internal int RoomID;
        internal bool linked;
        internal int RoomID2;
        #endregion

        #region Constructors/destructors
        internal virtualArrow(int ID)
        {

            DataRow dRow;
            DataRow dRow2;
            using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
            {
                dRow = dbClient.getRow("SELECT * FROM arrows WHERE id = '" + ID + "'");
                this.ID = ID;
                this.RoomID = Convert.ToInt32(dRow["roomid"]);
                this.X = Convert.ToInt32(dRow["x"]);
                this.Y = Convert.ToInt32(dRow["y"]);
                this.ID2 = Convert.ToInt32(dRow["arrow2"]);
                this.linked = (Convert.ToString(dRow["linked"]) == "1");
                if (linked)
                {
                    dRow2 = dbClient.getRow("SELECT * FROM arrows WHERE arrow2 = '" + ID + "'");
                    this.Y2 = Convert.ToInt32(dRow2["y"]);
                    this.X2 = Convert.ToInt32(dRow2["x"]);
                    this.RoomID2 = Convert.ToInt32(dRow2["roomid"]);
                }
                else
                {
                    ID2 = 0;
                }
            }
        }
        #endregion
    }
}