[Release] Auction system V2.[1] UPDATED 22.01.10

newguy

newguy

Well-Known Member
Joined
Nov 23, 2008
Messages
644
Reaction score
572
  1. Почти изцяло ajax базирана без много изображения което я прави изключително лека
  2. Възможност за интегриране на всички Web сайтове (имащи логин система) с промяната на 1 дума в config файла.
  3. Брояч за обратно време
  4. Автоматично добавяне на предмети в vault-а. (damian)
  5. Възможност за преглеждане на различни търгове.
  6. Автоматично презареждане на частта от страницата която показва кой колко кредита е заложил (презарежда се автоматично на всеки 3 секунди).
  7. Автоматично избиране на произволен предмет от базата данни слагайки му всички опции.

Снимки:

auction21.jpg


auction22.jpg



Item list

Small Axe
Hand Axe
Double Axe
Tomahawk
Elven Axe
Battle Axe
Nikkea Axe
Larkan Axe
Crescent Axe
Chaos Dragon Axe
Kris
Short Sword
Rapier
Katache
Sword of Asasin
Blade
Gladius
Falchion
Serpent Sword
Salamander
Light Saber
Legendary Sword
Helical Sword
Double Blade
Lighting Sword
Giant Sword
Sword of Destruction
Dark Breaker
Thunder Blade
Sword of Archangel
Knight Blade
Black Reign Blade
Rune Blade
Mace
Morning Star
Flail
Great Hammer
Crystal Morning Star
Crystal Sword
Elemental Mace
Battle Scepter
Master Scepter
Great Scepter
Lord Scepter
Great Lord Scepter
Light Spear
Spear
Dragon Lance
Giant Trident
Serpent Spear
Double Halberd
Halberd
Bardiche
Great Scythe
Bill of Balrog
Dragon Spear
Short Bow
Bow
Elven Bow
Battle Bow
Tiger Bow
Silver Bow
Chaos Nature Bow
Bolt
Crossbow
Gold Crossbow
Arquebus
Light Crossbow
Serpent Crossbow
Bluewing Crossbow
Aquagold Crossbow
Arrows
Saint Crossbow
Celestial Bow
Crossbow of Archangel
Great Reign Crossbow
Arrow Viper Bow
Skull Staff
Angelic Staff
Serpent Staff
Thunder Staff
Gorgon Staff
Legendary Staff
Staff of Resurrection
Chaos Lighting Staff
Staff of Destruction
Dragon Soul Staff
Staff of Archangel
Staff of Kundun
Bronze Helm
Dragon Helm
Pad Helm
Legendary Helm
Bone Helm
Leather Helm
Scale Helm
Sphinx Mask
Brass Helm
Plate Helm
Vine Helm
Silk Helm
Wind Helm
Spirit Helm
Guardian Helm
Black Dragon Helm
Dark Phoenix Helm
Grand Soul Helm
Divine Helm
Great Dragon Helm
Dark Soul Helm
Red Spirit Helm
Light Plate Mask
Adamantine Mask
Dark Steel Mask
Dark Master Mask
Bronze Armor
Dragon Armor
Pad Armor
Legendary Armor
Bone Armor
Leather Armor
Scale Armor
Sphinx Armor
Brass Armor
Iron Armor
Vine Armor
Silk Armor
Wind Armor
Spirit Armor
Guardian Armor
Storm Crow Armor
Black Dragon Armor
Dark Phoenix Armor
Grand Soul Armor
Divine Armor
Thunder Hawk Armor
Great Dragon Armor
Dark Soul Armor
Hurricane Armor
Red Spirit Armor
Light Plate Armor
Adamantine Armor
Dark Steel Armor
Dark Master Armor
Bronze Gloves
Dragon Gloves
Pad Gloves
Legendary Gloves
Bone Gloves
Leather Gloves
Scale Gloves
Sphinx Gloves
Brass Gloves
Iron Gloves
Vine Gloves
Silk Gloves
Wind Gloves
Spirit Gloves
Guardian Gloves
Storm Crow Gloves
Black Dragon Gloves
Dark Phoenix Gloves
Soul Gloves
Divine Gloves
Thunder Hawk Gloves
Great Dragon Gloves
Dark Soul Gloves
Hurricane Gloves
Red Spirit Gloves
Light Plate Gloves
Adamantine Gloves
Dark Steel Gloves
Dark Master Gloves
Bronze Pants
Dragon Pants
Pad Pants
Legendary Pants
Bone Pants
Leather Pants
Scale Pants
Sphinx Pants
Brass Pants
Iron Pants
Vine Pants
Silk Pants
Wind Pants
Spirit Pants
Guardian Pants
Storm Crow Pants
Black Dragon Pants
Dark Phoenix Pants
Grand Soul Pants
Divine Pants
Thunder Hawk Pants
Great Dragon Pants
Dark Soul Pants
Hurricane Pants
Red Spirit Pants
Light Plate Pants
Adamantine Pants
Dark Steel Pants
Dark Master Pants
Bronze Boots
Dragon Boots
Pad Boots
Legendary Boots
Bone Boots
Leather Boots
Scale Boots
Sphinx Boots
Brass Boots
Iron Boots
Vine Boots
Silk Boots
Wind Boots
Spirit Boots
Guardian Boots
Storm Crow Boots
Black Dragon Boots
Dark Phoenix Boots
Grand Soul Boots
Divine Boots
Thunder Hawk Boots
Great Dragon Boots
Dark Soul Boots
Hurricane Boots
Red Spirit Boots
Light Plate Boots
Adamantine Boots
Dark Steel Boots
Dark Master Boots
Small Shield
Horn Shield
Kite Shield
Elven Shield
Buckler
Dragon Slayer Shield
Skull Shield
Spike Shield
Tower Shield
Plate Shield
Large Round Shield
Serpent Shield
Bronze Shield
Chaos Shield
Legendary Shield
Grand Soul Shield
Elemental Shield
Pendant of Lighting
Pendant of Fire
Pendant of Ice
Pendant of Wind
Pendant of Water
Pendant of Ability
Wings of Spirits
Wings of Soul
Wings of Dragon
Wings of Darkness
Cape of Lord
Ring of Ice
Ring of Poison
Ring of Fire
Ring of Earth
Ring of Wind
Ring of Magic

Code: 
CREATE TABLE [log] (
	[napravil] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[time] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [lastauctuion] (
	[item] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[turgbroj] [int] NULL ,
	[vreme] [int] NULL ,
	[winn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[succ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO



CREATE TABLE [auctionlogin] (
	[member] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
	[resets] [int] NOT NULL CONSTRAINT [DF__auctionlo__reset__69C6B1F5] DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [turgove] (
	[turgid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[winners] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[credits] [int] NOT NULL ,
	[itema] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [zalaganiq] (
	[member] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
	[broj] [int] NOT NULL CONSTRAINT [DF__zalaganiq__broj__6D9742D9] DEFAULT (0),
	[brojnaturga] [int] NULL 
) ON [PRIMARY]
GO


CREATE TABLE [allitems] (
	[itemname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[itemid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

Delete From allitems 
INSERT INTO allitems (itemname, itemid) VALUES ('Small Axe','20') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hand Axe','21') 
INSERT INTO allitems (itemname, itemid) VALUES ('Double Axe','22') 
INSERT INTO allitems (itemname, itemid) VALUES ('Tomahawk','23') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elven Axe','24') 
INSERT INTO allitems (itemname, itemid) VALUES ('Battle Axe','25') 
INSERT INTO allitems (itemname, itemid) VALUES ('Nikkea Axe','26') 
INSERT INTO allitems (itemname, itemid) VALUES ('Larkan Axe','27') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crescent Axe','28') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Dragon Axe','46') 
INSERT INTO allitems (itemname, itemid) VALUES ('Kris','00') 
INSERT INTO allitems (itemname, itemid) VALUES ('Short Sword','01') 
INSERT INTO allitems (itemname, itemid) VALUES ('Rapier','02') 
INSERT INTO allitems (itemname, itemid) VALUES ('Katache','03') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sword of Asasin','04') 
INSERT INTO allitems (itemname, itemid) VALUES ('Blade','05') 
INSERT INTO allitems (itemname, itemid) VALUES ('Gladius','06') 
INSERT INTO allitems (itemname, itemid) VALUES ('Falchion','07') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Sword','08') 
INSERT INTO allitems (itemname, itemid) VALUES ('Salamander','09') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Saber','0A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Sword','0B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Helical Sword','0C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Double Blade','0D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Lighting Sword','0E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Giant Sword','0F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sword of Destruction','10') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Breaker','11') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Blade','12') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sword of Archangel','13') 
INSERT INTO allitems (itemname, itemid) VALUES ('Knight Blade','14') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Reign Blade','15') 
INSERT INTO allitems (itemname, itemid) VALUES ('Rune Blade','1F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Mace','40') 
INSERT INTO allitems (itemname, itemid) VALUES ('Morning Star','41') 
INSERT INTO allitems (itemname, itemid) VALUES ('Flail','42') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Hammer','43') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crystal Morning Star','44') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crystal Sword','45') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elemental Mace','47') 
INSERT INTO allitems (itemname, itemid) VALUES ('Battle Scepter','48') 
INSERT INTO allitems (itemname, itemid) VALUES ('Master Scepter','49') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Scepter','4A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Lord Scepter','4B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Lord Scepter','4C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Spear','60') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spear','61') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Lance','62') 
INSERT INTO allitems (itemname, itemid) VALUES ('Giant Trident','63') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Spear','64') 
INSERT INTO allitems (itemname, itemid) VALUES ('Double Halberd','65') 
INSERT INTO allitems (itemname, itemid) VALUES ('Halberd','66') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bardiche','67') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Scythe','68') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bill of Balrog','69') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Spear ','6A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Short Bow','80') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bow','81') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elven Bow','82') 
INSERT INTO allitems (itemname, itemid) VALUES ('Battle Bow','83') 
INSERT INTO allitems (itemname, itemid) VALUES ('Tiger Bow','84') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silver Bow','85') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Nature Bow','86') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bolt','87') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crossbow','88') 
INSERT INTO allitems (itemname, itemid) VALUES ('Gold Crossbow','89') 
INSERT INTO allitems (itemname, itemid) VALUES ('Arquebus','8A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Crossbow','8B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Crossbow','8C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bluewing Crossbow','8D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Aquagold Crossbow','8E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Arrows','8F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Saint Crossbow','90') 
INSERT INTO allitems (itemname, itemid) VALUES ('Celestial Bow','91') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crossbow of Archangel','92') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Reign Crossbow','93') 
INSERT INTO allitems (itemname, itemid) VALUES ('Arrow Viper Bow','94') 
INSERT INTO allitems (itemname, itemid) VALUES ('Skull Staff','A0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Angelic Staff','A1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Staff','A2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Staff','A3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Gorgon Staff','A4') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Staff','A5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Resurrection','A6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Lighting Staff','A7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Destruction','A8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Soul Staff','A9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Archangel','AA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Kundun','AB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Helm','E0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Helm','E1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Helm','E2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Helm','E3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Helm','E4') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Helm','E5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Helm','E6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Mask','E7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Helm','E8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Plate Helm','E9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Helm','EA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Helm','EB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Helm','EC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Helm','ED') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Helm','EE') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Helm','F0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Helm','F1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Helm','F2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Helm','F3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Helm','F5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Helm','F6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Helm','F8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Mask','F9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Mask','FA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Mask','FB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Mask','FC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Armor','100') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Armor','101') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Armor','102') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Armor','103') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Armor','104') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Armor','105') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Armor','106') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Armor','107') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Armor','108') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Armor','109') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Armor','10A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Armor','10B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Armor','10C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Armor','10D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Armor','10E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Armor','10F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Armor','110') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Armor','111') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Armor','112') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Armor','113') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Armor','114') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Armor','115') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Armor','116') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Armor','117') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Armor','118') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Armor','119') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Armor','11A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Armor','11B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Armor','11C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Gloves','140') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Gloves','141') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Gloves','142') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Gloves','143') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Gloves','144') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Gloves','145') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Gloves','146') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Gloves','147') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Gloves','148') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Gloves','149') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Gloves','14A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Gloves','14B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Gloves','14C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Gloves','14D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Gloves','14E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Gloves','14F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Gloves','150') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Gloves','151') 
INSERT INTO allitems (itemname, itemid) VALUES ('Soul Gloves','152') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Gloves','153') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Gloves','154') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Gloves','155') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Gloves','156') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Gloves','157') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Gloves','158') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Gloves','159') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Gloves','15A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Gloves','15B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Gloves','15C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Pants','120') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Pants','121') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Pants','122') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Pants','123') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Pants','124') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Pants','125') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Pants','126') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Pants','127') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Pants','128') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Pants','129') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Pants','12A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Pants','12B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Pants','12C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Pants','12D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Pants','12E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Pants','12F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Pants','130') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Pants','131') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Pants','132') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Pants','133') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Pants','134') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Pants','135') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Pants','136') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Pants','137') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Pants','138') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Pants','139') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Pants','13A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Pants','13B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Pants','13C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Boots','160') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Boots','161') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Boots','162') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Boots','163') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Boots','164') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Boots','165') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Boots','166') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Boots','167') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Boots','168') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Boots','169') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Boots','16A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Boots','16B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Boots','16C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Boots','16D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Boots','16E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Boots','16F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Boots','170') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Boots','171') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Boots','172') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Boots','173') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Boots','174') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Boots','175') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Boots','176') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Boots','177') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Boots','178') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Boots','179') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Boots','17A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Boots','17B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Boots','17C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Small Shield','C0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Horn Shield','C1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Kite Shield','C2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elven Shield','C3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Buckler','C4') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Slayer Shield','C5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Skull Shield','C6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spike Shield','C7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Tower Shield','C8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Plate Shield','C9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Large Round Shield','CA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Shield','CB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Shield','CC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Shield','CD') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Shield','CE') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Shield','CF') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elemental Shield','D0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Lighting','1AC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Fire','1AD') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Ice ','1B9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Wind','1BA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Water','1BB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Ability','1BC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Spirits','183') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Soul','184') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Dragon','185') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Darkness','186') 
INSERT INTO allitems (itemname, itemid) VALUES ('Cape of Lord','1BE') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Ice','1A8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Poison','1A9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Fire','1B5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Earth','1B6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Wind','1B7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Magic','1B8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Small Axe','20') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hand Axe','21') 
INSERT INTO allitems (itemname, itemid) VALUES ('Double Axe','22') 
INSERT INTO allitems (itemname, itemid) VALUES ('Tomahawk','23') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elven Axe','24') 
INSERT INTO allitems (itemname, itemid) VALUES ('Battle Axe','25') 
INSERT INTO allitems (itemname, itemid) VALUES ('Nikkea Axe','26') 
INSERT INTO allitems (itemname, itemid) VALUES ('Larkan Axe','27') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crescent Axe','28') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Dragon Axe','46') 
INSERT INTO allitems (itemname, itemid) VALUES ('Kris','00') 
INSERT INTO allitems (itemname, itemid) VALUES ('Short Sword','01') 
INSERT INTO allitems (itemname, itemid) VALUES ('Rapier','02') 
INSERT INTO allitems (itemname, itemid) VALUES ('Katache','03') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sword of Asasin','04') 
INSERT INTO allitems (itemname, itemid) VALUES ('Blade','05') 
INSERT INTO allitems (itemname, itemid) VALUES ('Gladius','06') 
INSERT INTO allitems (itemname, itemid) VALUES ('Falchion','07') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Sword','08') 
INSERT INTO allitems (itemname, itemid) VALUES ('Salamander','09') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Saber','0A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Sword','0B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Helical Sword','0C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Double Blade','0D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Lighting Sword','0E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Giant Sword','0F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sword of Destruction','10') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Breaker','11') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Blade','12') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sword of Archangel','13') 
INSERT INTO allitems (itemname, itemid) VALUES ('Knight Blade','14') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Reign Blade','15') 
INSERT INTO allitems (itemname, itemid) VALUES ('Rune Blade','1F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Mace','40') 
INSERT INTO allitems (itemname, itemid) VALUES ('Morning Star','41') 
INSERT INTO allitems (itemname, itemid) VALUES ('Flail','42') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Hammer','43') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crystal Morning Star','44') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crystal Sword','45') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elemental Mace','47') 
INSERT INTO allitems (itemname, itemid) VALUES ('Battle Scepter','48') 
INSERT INTO allitems (itemname, itemid) VALUES ('Master Scepter','49') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Scepter','4A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Lord Scepter','4B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Lord Scepter','4C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Spear','60') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spear','61') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Lance','62') 
INSERT INTO allitems (itemname, itemid) VALUES ('Giant Trident','63') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Spear','64') 
INSERT INTO allitems (itemname, itemid) VALUES ('Double Halberd','65') 
INSERT INTO allitems (itemname, itemid) VALUES ('Halberd','66') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bardiche','67') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Scythe','68') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bill of Balrog','69') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Spear ','6A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Short Bow','80') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bow','81') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elven Bow','82') 
INSERT INTO allitems (itemname, itemid) VALUES ('Battle Bow','83') 
INSERT INTO allitems (itemname, itemid) VALUES ('Tiger Bow','84') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silver Bow','85') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Nature Bow','86') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bolt','87') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crossbow','88') 
INSERT INTO allitems (itemname, itemid) VALUES ('Gold Crossbow','89') 
INSERT INTO allitems (itemname, itemid) VALUES ('Arquebus','8A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Crossbow','8B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Crossbow','8C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bluewing Crossbow','8D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Aquagold Crossbow','8E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Arrows','8F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Saint Crossbow','90') 
INSERT INTO allitems (itemname, itemid) VALUES ('Celestial Bow','91') 
INSERT INTO allitems (itemname, itemid) VALUES ('Crossbow of Archangel','92') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Reign Crossbow','93') 
INSERT INTO allitems (itemname, itemid) VALUES ('Arrow Viper Bow','94') 
INSERT INTO allitems (itemname, itemid) VALUES ('Skull Staff','A0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Angelic Staff','A1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Staff','A2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Staff','A3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Gorgon Staff','A4') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Staff','A5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Resurrection','A6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Lighting Staff','A7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Destruction','A8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Soul Staff','A9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Archangel','AA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Staff of Kundun','AB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Helm','E0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Helm','E1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Helm','E2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Helm','E3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Helm','E4') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Helm','E5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Helm','E6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Mask','E7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Helm','E8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Plate Helm','E9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Helm','EA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Helm','EB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Helm','EC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Helm','ED') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Helm','EE') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Helm','F0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Helm','F1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Helm','F2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Helm','F3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Helm','F5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Helm','F6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Helm','F8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Mask','F9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Mask','FA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Mask','FB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Mask','FC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Armor','100') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Armor','101') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Armor','102') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Armor','103') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Armor','104') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Armor','105') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Armor','106') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Armor','107') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Armor','108') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Armor','109') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Armor','10A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Armor','10B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Armor','10C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Armor','10D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Armor','10E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Armor','10F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Armor','110') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Armor','111') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Armor','112') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Armor','113') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Armor','114') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Armor','115') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Armor','116') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Armor','117') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Armor','118') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Armor','119') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Armor','11A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Armor','11B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Armor','11C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Gloves','140') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Gloves','141') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Gloves','142') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Gloves','143') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Gloves','144') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Gloves','145') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Gloves','146') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Gloves','147') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Gloves','148') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Gloves','149') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Gloves','14A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Gloves','14B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Gloves','14C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Gloves','14D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Gloves','14E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Gloves','14F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Gloves','150') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Gloves','151') 
INSERT INTO allitems (itemname, itemid) VALUES ('Soul Gloves','152') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Gloves','153') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Gloves','154') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Gloves','155') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Gloves','156') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Gloves','157') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Gloves','158') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Gloves','159') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Gloves','15A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Gloves','15B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Gloves','15C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Pants','120') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Pants','121') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Pants','122') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Pants','123') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Pants','124') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Pants','125') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Pants','126') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Pants','127') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Pants','128') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Pants','129') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Pants','12A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Pants','12B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Pants','12C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Pants','12D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Pants','12E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Pants','12F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Pants','130') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Pants','131') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Pants','132') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Pants','133') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Pants','134') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Pants','135') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Pants','136') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Pants','137') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Pants','138') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Pants','139') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Pants','13A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Pants','13B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Pants','13C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Boots','160') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Boots','161') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pad Boots','162') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Boots','163') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bone Boots','164') 
INSERT INTO allitems (itemname, itemid) VALUES ('Leather Boots','165') 
INSERT INTO allitems (itemname, itemid) VALUES ('Scale Boots','166') 
INSERT INTO allitems (itemname, itemid) VALUES ('Sphinx Boots','167') 
INSERT INTO allitems (itemname, itemid) VALUES ('Brass Boots','168') 
INSERT INTO allitems (itemname, itemid) VALUES ('Iron Boots','169') 
INSERT INTO allitems (itemname, itemid) VALUES ('Vine Boots','16A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Silk Boots','16B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wind Boots','16C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spirit Boots','16D') 
INSERT INTO allitems (itemname, itemid) VALUES ('Guardian Boots','16E') 
INSERT INTO allitems (itemname, itemid) VALUES ('Storm Crow Boots','16F') 
INSERT INTO allitems (itemname, itemid) VALUES ('Black Dragon Boots','170') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Phoenix Boots','171') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Boots','172') 
INSERT INTO allitems (itemname, itemid) VALUES ('Divine Boots','173') 
INSERT INTO allitems (itemname, itemid) VALUES ('Thunder Hawk Boots','174') 
INSERT INTO allitems (itemname, itemid) VALUES ('Great Dragon Boots','175') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Soul Boots','176') 
INSERT INTO allitems (itemname, itemid) VALUES ('Hurricane Boots','177') 
INSERT INTO allitems (itemname, itemid) VALUES ('Red Spirit Boots','178') 
INSERT INTO allitems (itemname, itemid) VALUES ('Light Plate Boots','179') 
INSERT INTO allitems (itemname, itemid) VALUES ('Adamantine Boots','17A') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Steel Boots','17B') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dark Master Boots','17C') 
INSERT INTO allitems (itemname, itemid) VALUES ('Small Shield','C0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Horn Shield','C1') 
INSERT INTO allitems (itemname, itemid) VALUES ('Kite Shield','C2') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elven Shield','C3') 
INSERT INTO allitems (itemname, itemid) VALUES ('Buckler','C4') 
INSERT INTO allitems (itemname, itemid) VALUES ('Dragon Slayer Shield','C5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Skull Shield','C6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Spike Shield','C7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Tower Shield','C8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Plate Shield','C9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Large Round Shield','CA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Serpent Shield','CB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Bronze Shield','CC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Chaos Shield','CD') 
INSERT INTO allitems (itemname, itemid) VALUES ('Legendary Shield','CE') 
INSERT INTO allitems (itemname, itemid) VALUES ('Grand Soul Shield','CF') 
INSERT INTO allitems (itemname, itemid) VALUES ('Elemental Shield','D0') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Lighting','1AC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Fire','1AD') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Ice ','1B9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Wind','1BA') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Water','1BB') 
INSERT INTO allitems (itemname, itemid) VALUES ('Pendant of Ability','1BC') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Spirits','183') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Soul','184') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Dragon','185') 
INSERT INTO allitems (itemname, itemid) VALUES ('Wings of Darkness','186') 
INSERT INTO allitems (itemname, itemid) VALUES ('Cape of Lord','1BE') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Ice','1A8') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Poison','1A9') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Fire','1B5') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Earth','1B6') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Wind','1B7') 
INSERT INTO allitems (itemname, itemid) VALUES ('Ring of Magic','1B8')


Начин на инсталация! Чети ВНИМАТЕЛНО!
  1. Изтеглете архива
  2. Резархивирайте и копирайте файловете в нова създадена от вас папка (за пример ще дам turg)
  3. Отидете в Query analizer-a и изпълнете заявката от по-горе в таблицата MuOnline!
  4. Отидете в inc/config.php и попълнете вашите данни.
  5. Отворете адреса в който сте копирали файловете както по-горе дадох за пример turg значи http://САЙТАВИ/turg/
  6. Вероятно ще ви напише, че не сте логнат в акаунта си. Ако използвате muweb 0.8 не би трябвало да имате този проблем. Логвате се и когато отидете на адреса http://САЙТАВИ/turg/ ще ви отвори същината на сайта. Дайте refresh на браузъра ще започне брояч с обратно време и ще ви каже за какъв предмет е търга.
  7. НЕЩО МНОГО ВАЖНО! СПЕЧЕЛЕТЕ ПЪРВИЯТ ТЪРГ ВИЕ! ЗАЛОЖЕТЕ 1 кредит/точка отидете в enterprise manager-а датабаза MuOnline>lastauction дайте десен бутон open table > return in rows. Така ще ви отвори нещо подобно
  8. Премахнете последната цифра от времето и затворете с X. Рефрешнете страницата с търга. Автоматично трябва да сте спечелил търг. Няма да ви даде предмет първия път. Всеки следващ обаче ще бъде възнаграден.

Въпроси и проблеми пишете в темата.

newguy said:
Важно! Забравих да спомена за 1 файл в главната директория - clear.php. Той служи за нулиране на всичко до момента. Изтрива всички търгове залагания и т.н. . Удобен е ако ще сменяте търг системата от кредити към точки или обратното. В противен случей силно ви съветвам да изтриете файла с цел защитни мерки.
Click to expand...


newguy said:
V2.1​

Нови попълнения:
  1. Лог записващ действията на потребителите (кой колко кредите е вложил заменил за рестарти дали предмета е успешно добавен след търга или vault-а е пълен). Има възможност за спиране и пускане на тази опция от config файла.
  2. Интегрирана login система. Вече не е нужно да се притеснявате с кой Web сте.

В query analizer-a.
Code: 
CREATE TABLE [log] (
	[napravil] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[time] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Снимки:
auctionv21.jpg


auctionv2.jpg


За новите версии бъга не е оправен. Методите за добавяне явно са други. Питах damian каза, че старите използват 20 битов код а новите 32.
Click to expand...

sNG said:
English version:
2shared.com - free file sharing and storage
404 - Page Not Found - GameFront

If you find any mistakes, feel free to tell me.
Click to expand...

newguy said:
NakazaTeLq said:
намерих 1 бъг :D пишеш 20 кредита примерно и нямаш повече кредити или имаж няма значение , но после пишеш -20 и ти маха кредитите връща ти ги :D по тая логика може да си ги зимаме по всяко време :)

и още нещо като се логвам си седи на едно място .... имам някакъв проблем със старт сесията ??? измислете как да го фикс ;)
Click to expand...
Благодаря променете modules/add.php на:
PHP: 
<?php
@session_start();
include "../inc/config.php";
include "../inc/log.php";
$dobavi = $_POST['dobavqm'];

echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=1251\">";
if ($zalog == "1") // КОГАТО Е С КРЕДИТИ

{
    if ($dobavi == null)
    {
        echo "Моля попълнете полето.";
    }
    else
    {
        if ((int)$dobavi > 0)
        {
            $dobavi = (int)$dobavi;
            $x = mssql_fetch_assoc(mssql_query("
	SELECT credits FROM MEMB_CREDITS where memb___id='" . $_SESSION[$siteloginsession] .
                "'
"));
            $b = $x['credits'];
            if ($b < (int)$dobavi)
            {
                echo "Нямате достатъчно кредити";
            }
            else
            {
                $u = mssql_fetch_assoc(mssql_query("SELECT count(member) as memb from zalaganiq where member='" .
                    $_SESSION[$siteloginsession] . "'"));
                $qup = mssql_fetch_assoc(mssql_query("SELECT turgbroj FROM lastauctuion")) or
                    die(mssql_get_last_message());
                $show = $qup['turgbroj'];
                if ($u['memb'] == "0")
                {

                    mssql_query("INSERT INTO zalaganiq(member, broj, brojnaturga)
VALUES('" . $_SESSION[$siteloginsession] . "', '0', '$show')");
                }
                mssql_query("UPDATE zalaganiq SET broj=broj+'" . (int)$dobavi .
                    "', brojnaturga='$show'
WHERE member='" . $_SESSION[$siteloginsession] . "'");
                mssql_query("UPDATE MEMB_CREDITS SET credits=credits-'" . (int)$dobavi . "'
WHERE memb___id='" . $_SESSION[$siteloginsession] . "'");
                if ($logon > 0)
                {
                    logsave("<font color='#ffffff'>" . $_SESSION[$siteloginsession] .
                        "</font> добави " . (int)$dobavi . " кредита в търга.");
                }
                echo "Кредитите са успешно добавени.";
            }
        }
        else
        {
            echo "Числото трябва да е по-голямо от 0!";
        }
    }
}
// КОГАТО Е С КРЕДИТИ КРАЙ

elseif ($zalog == "2") // КОГАТО Е С РЕСОВЕ

{

    if ($dobavi == null)
    {
        echo "Моля попълнете полето.";
    }
    else
    {
        if ((int)$dobavi > 0)
        {
            $dobavi = $_POST['dobavqm'];
            $xo = mssql_fetch_assoc(mssql_query("SELECT resets FROM auctionlogin WHERE member='" .
                $_SESSION[$siteloginsession] . "'"));
            $getresets = $xo['resets'];
            if ($dobavi > $getresets)
            {
                echo "Нямате достатъчно точки.";
            }
            else
            {
                $u = mssql_fetch_assoc(mssql_query("SELECT count(member) as memb from zalaganiq where member='" .
                    $_SESSION[$siteloginsession] . "'"));
                $qup = mssql_fetch_assoc(mssql_query("SELECT turgbroj FROM lastauctuion")) or
                    die(mssql_get_last_message());
                $show = $qup['turgbroj'];
                if ($u['memb'] == "0")
                {

                    mssql_query("INSERT INTO zalaganiq(member, broj, brojnaturga)
VALUES('" . $_SESSION[$siteloginsession] . "', '0', '$show')");
                }
                mssql_query("UPDATE zalaganiq SET broj=broj+'" . (int)$dobavi .
                    "', brojnaturga='$show'
WHERE member='" . $_SESSION[$siteloginsession] . "'");
                mssql_query("UPDATE auctionlogin SET resets=resets-'" . (int)$dobavi . "'
WHERE member='" . $_SESSION[$siteloginsession] . "'");
                if ($logon > 0)
                {
                    logsave("<font color='#fff'>" . $_SESSION[$siteloginsession] . "</font> добави " .
                        (int)$dobavi . " точки в търга.");
                }
                echo "Точките са успешно добавени.";
            }
        }
        else
        {
            echo "Числото трябва да е по-голямо от 0!";
        }
    }

} // КОГАТО Е С РЕСОВЕ КРАЙ


?>
Click to expand...

Изтеглете от тук:
 

Attachments

  • auction V2.rar
    154.9 KB · Views: 181
  • auction V2.1.rar
    158.1 KB · Views: 462
Last edited:
  • Like
Reactions: Deleted member 3583, BeautyDeaD, ShAd0w and 49 others
Просто, newguy ти си изумителен отново ! Страхотна работа !!!! :)
 
Невероятен Релийз , и обяснено перфектно , БРАВО !!!
 
:)
Добре е хората да релийзват нещо добро направено лично от тях
БРАВО!
 
newguy ти си просто перфектен 10/10 :*
 
как се слага за къф предмет да е търга
добре видях че е автоматично но кога избира предмета ?
 
Last edited:
дава ми грешка на 111 ред в index.php
 
Не съм дал правилната заявка. В allitems трябва да има много записи но не мога да експортна таблицата. Някой да помогне бързо.
 
please somebody translate this , google can't translate it...
 
Мисля да я тест-вам, понеже изглежда доста добра ;]
thx 4 sharing :p
 
Първият коментар е обновен. Оправен е проблема. Трябва да въведете отново кода в query analizer-а бях пропуснал 1 таблица в която са имената и кодовете на предметите. Извинявам се. Вече не би трябвало да имате проблем.
 
You must log in or register to reply here.

Similar threads

D
[Release] DPWeb Auction System + Admin Panel
Replies
11
Views
3K
Releases
mudreamworld
mudreamworld
newguy
[Release] Търг система/ Auction system
Replies
49
Views
5K
Releases
ivowe3
ivowe3
DemonuMu
[Release] ServerWeb Firewall Release System
Replies
0
Views
11
Releases
DemonuMu
DemonuMu
J
[Release] Reset System 97d dynamic
Replies
0
Views
1K
Releases
jhuletys
J
D
[Release] MuOnline Quest system v0.1 - Savoy
Replies
0
Views
2K
Releases
dota-sdso
D
Top Bottom
Back