static void Main(string[] args)
{
var results = new Claw().Sniff(442, 444, new Network().ResolveDNStoIPList("www.google.com")[0]);
var iptarget = new Network().ResolveDNStoIPList("www.google.com")[0];
Console.WriteLine(iptarget);
var pingIPs = new Network().Ping_IPs(new[] { iptarget });
foreach (var p in pingIPs)
{
Console.WriteLine("ip {0} ping {1}", p.Key, p.Value);
}
var whoisdata = new Network().GetWhoisInformation("whois.verisign-grs.com", "google.com");
Console.Write(whoisdata);
var whoisServerDictionary = new Data().ExtractWhoisServerList("whoisServers.dat");
foreach (var entry in whoisServerDictionary)
{
string formatedOutput = String.Format("|{0,10}|{1,10}", entry.Key, entry.Value);
Console.WriteLine(formatedOutput);
}
var targetWhoIs1 = new Network(whoisServerDictionary).GetWhoisInformation("google.co.uk");
var targetWhoIs2 = new Network(whoisServerDictionary).GetWhoisInformation("ed.ac.uk");
}
void Start()
{
// Sets our AudioPlayer to the RigController
ClawAudioPlayer = this.GetComponentInChildren <ClawAudioPlayer>();
// Sets our ClawRayCaster to the RigController
ClawRayCaster = this.GetComponentInChildren <ClawRayCaster>();
// Sets our Claw to the RigController
Claw = this.GetComponentInChildren <Claw>();
input = new ClawRigControlMap();
//Moving the horizontal railing so that it is directly over the claw
hRail.position = new Vector3(hRail.position.x, hRail.position.y, Claw.transform.position.z);
//Moving the vertical railing so that it is directly over the claw
vRail.position = new Vector3(Claw.transform.position.x, vRail.position.y, vRail.position.z);
// initializing our claw rig states with a refrence to this.
rigIsOff = new ClawStatePowerOff(this);
rigIsEmpty = new ClawStateNotHoldingBox(this);
rigIsHoldingBox = new ClawStateHoldingBox(this);
clawLowering = new ClawLowering(this);
clawLifting = new ClawLifting(this);
// setting the initial state to off.
currentClawRigState = rigIsOff;
}
// Use this for initialization
void Start()
{
currentCraneState = craneState_t.first_idle;
cameras = GetComponentsInChildren <Camera>(true);
currentCameraState = cameraState_t.side;
//grab global settings, video, sound, level settings, etc.
gbSettings = GameObject.Find("Global Settings").GetComponent <GlobalSettings>();
SetCamera();
claw = GetComponentInChildren <Claw>();
claw.currentMode = gbSettings.settings.currentmode;
claw.Init();
SetupCallbacks();
//get the player from the SQL database. until then use a placeholder
currentPlayer = new PlayerInfo();
//if strict mode, enable physics history
if (gbSettings.settings.currentmode == Claw.gameMode.strict)
{
UpdateHistory();
}
currentLevel = GetComponentInChildren <Level>();
currentLevel.OnComplete += OnWin;
SetupGUI();
;
}
private void Start()
{
chain = GetComponent <LineRenderer>();
player = GameManager.ActiveGameManager.Player;
tracksManager = GameManager.ActiveGameManager.TracksManager;
claw = transform.Find("Claw").GetComponent <Claw>();
chain.positionCount = 2;
}
private void SpawnClaw()
{
if (!clawObject)
{
Debug.LogError("clawObject must have a claw prefab");
}
myClaw = (Claw)SpawnItem(clawObject, righthandpos, myClaw);
}
// Use this for initialization
void Start()
{
foreach (ChildCollider collider in GetComponentsInChildren <ChildCollider>())
{
collider.hitEvent += Collide;
}
claw = GetComponentInChildren <Claw>();
}
private void Start()
{
m_claw = GetComponentInParent <Claw>();
// gets whether vibration is on
if (OptionsManager.InstanceExists)
{
m_bVibrationToggle = OptionsManager.Instance.m_bVibration;
}
}
private void OnTriggerExit(Collider other)
{
Claw claw = other.GetComponent <Claw>();
if (claw == null)
{
return;
}
claw.ClawGrabbableExited(this);
}
public override void OnInspectorGUI()
{
Claw myTarget = (Claw)target;
DrawDefaultInspector();
if (GUILayout.Button("Release"))
{
myTarget.Ungrab();
}
}
void Awake()
{
// Init component
_transform = transform;
_rigidbody = GetComponent <Rigidbody2D>();
_originPosition = _transform.position;
// Init value
_isShotted = false;
_claw = GetComponentInChildren <Claw>();
_line = GetComponentInChildren <LineController>();
}
private void OnTriggerStay2D(Collider2D collider)
{
if (collider.CompareTag("Claw"))
{
Claw gripper = collider.GetComponent <Claw>();
if (gripper.gripped)
{
health -= Time.deltaTime * 5;
sprite.color = Color.Lerp(Color.black, topColor, health / maxHealth);
Jitter();
if (health <= 0)
{
gripper.Stun(0.5f);
Destroy(gameObject);
}
}
}
}
// Update is called once per frame
void Update()
{
if (Input.GetMouseButton(0) && currentAttract && currentClaw)
{
currentAttract.transform.position = main.ScreenToWorldPoint((Vector2)Input.mousePosition);
}
if (Input.GetMouseButtonDown(0))
{
currentClaw = null;
Vector2 pos = main.ScreenToWorldPoint((Vector2)Input.mousePosition);
float shortestDist = float.MaxValue;
float next;
foreach (Claw claw in claws)
{
if (!claw.stunned)
{
next = Vector2.Distance(pos, claw.transform.position);
if (next < shortestDist)
{
shortestDist = next;
currentClaw = claw;
}
}
}
if (currentClaw)
{
currentAttract = currentClaw.attractPoint;
currentClaw.Click();
}
}
if (Input.GetMouseButtonUp(0) && !stunned)
{
if (currentClaw)
{
currentAttract = null;
currentClaw.Unclick();
currentClaw = null;
}
}
}
///////////////////////////////////////Input window for claws
void ClawInput(Claw side)
{
if (side == Claw.Left)
{
leftClaw = true;
leftPressed = true;
anim.SetTrigger("snapsLeft");
if (leftBufferCo == null)
{
leftBufferCo = StartCoroutine(LeftBuffer());
}
else
{
StopCoroutine(leftBufferCo);
leftBufferCo = StartCoroutine(LeftBuffer());
}
}
else
{
rightClaw = true;
rightPressed = true;
anim.SetTrigger("snapsRight");
if (rightBufferCo == null)
{
rightBufferCo = StartCoroutine(RightBuffer());
}
else
{
StopCoroutine(rightBufferCo);
rightBufferCo = StartCoroutine(RightBuffer());
}
}
hrnD.OnClaw(side);
}
public cOGL(Control pb)
{
m_DisplayPanel = pb;
InitializeGL();
obj = GLU.gluNewQuadric(); //!!!
PrepareLists();
teddyBear = new TeddyBear(TEDDY_BEAR_LIST, TEDDY_BEAR_SHADOW_LIST, 7, "toy.obj");
toyCar = new ToyCar(CAR_LIST, CAR_SHADOW_LIST, 2, "car.obj");
claw = new Claw(obj, CLAW_LIST, CLAW_SHADOW_LIST);
ClawMachine = new ClawMachine(obj, CLAW_MACHINE_LIST, SHADOW_LIST, teddyBear, claw);
MainLightSource = new LightSource(0, 0, 0);
StaticRedLightSource = new LightSource(10, 8, 10);
StaticBlueLightSource = new LightSource(-10, 8, -10);
m_SideMachine = new SideMachine(SIDE_MACHINE_LIST, SIDE_MACHINE_SHADOW_LIST);
mainShadowManager = new ShadowUtills(MainLightSource);
redShadowManager = new ShadowUtills(StaticRedLightSource);
blueShadowManager = new ShadowUtills(StaticBlueLightSource);
ground[0, 0] = 1;
ground[0, 1] = -3f;
ground[0, 2] = 0f;
ground[1, 0] = 0;
ground[1, 1] = -3f;
ground[1, 2] = 1f;
ground[2, 0] = 1;
ground[2, 1] = -3f;
ground[2, 2] = 1f;
//----------banner light position-----------
bannerLightPos[0] = 0;
bannerLightPos[1] = 5.9f;
bannerLightPos[2] = 2.7f;
bannerLightPos[3] = 1f;
bannerLightDirection = "RIGHT";
}
public void loadArm(string partName)
{
if (!robot.transform.Find("Chassis"))
{
return;
}
while (removeAttached("Arm"))
{
;
}
GameObject anchor = r.armAnchors [0];
GameObject w = Instantiate(PartData.findArm(partName));
w.transform.SetParent(robot.transform.Find("Chassis"));
w.transform.position = anchor.transform.position;
Vector3 rot = anchor.transform.rotation.eulerAngles;
rot.z = 0;
rot.y = 0;
w.transform.localRotation = Quaternion.Euler(rot);
w.transform.Rotate(new Vector3(0, 90, 90));
Claw c = w.GetComponent <Claw> ();
HingeJoint[] hjs = w.GetComponentsInChildren <HingeJoint> ();
foreach (HingeJoint hj in hjs)
{
hj.connectedBody = robot.transform.Find("Chassis").gameObject.GetComponent <Rigidbody>();
Vector3 pos = hj.gameObject.transform.position;
hj.connectedAnchor = pos;
hj.gameObject.transform.position = pos;
}
w.name = "Arm";
}
void Start()
{
soundPlayed = false;
_claw = GameObject.FindObjectOfType <Claw>().GetComponent <Claw>();
finished = false;
}
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 MoveLeft()
{
GameManager _gameManager = new GameManager();
_claw = _gameManager.Claw;
}
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 BeGrabbed(Claw claw)
{
//捕猎器与AI角力
}
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 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;
}
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;
}