Game Master Vendors and Items

[LTGH]

".recall port GM" works too.

[phc_chaos]

".recall port GM" works too.

i got THE port to GMisland down! i need to figure out how the **** to get the vendors up on the island and stuff

:cussing: :banghead:

[damon161]

i keep gettin these error

[Err] 1054 - Unknown column 'name' in 'field list'
[Err] INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (101001,2,0,-1,"The Shadow Vanquisher","The Shadow Vanquisher","The Shadow Vanquisher","The Shadow Vanquisher",32603,4,0,5000000,200000,13,2,-1,85,80,0,0,0,0,0,0,0,0,1,0,7,50,4,50,5,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,120,150,0 ,45,45,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50,0,1500,0,0,18084,2,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,1,3,0,0,0,0,220,0,0,0,0,2,0,8, 0,1,0,2869,0,0,0,0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[slyfox101]

Change "name" to "name1"

That'll fix it.

[LTGH]

Ty for helping him Slyfox :P

[iccy]

Nice, I like it. +rep

[phc_chaos]

Change "name" to "name1"

That'll fix it.

in my SQLyog right?

haha srry bout this :yuck:\


_____________________________________________________________

I HAVE NO LIFE SO GET THE FARK OUT OF MY HOUSE!!
Access denied. Computer cannot compute.
:cussing: what do you mean you can't compute damnit!?
Computer cannot compute.
Ugh!! :cussing: thats what I think of you!!
Computer now activating self-destruct sequence. Termination in 5 seconds.
"Oh shit.."

[Outlands]

olnly need 1 post more to link image

[Outlands]

I have a problem when excute Batch file, he has an error, help me plz

Thx .

[phc_chaos]

I have a problem when excute Batch file, he has an error, help me plz

Thx .

you probably need to select a database

[Outlands]

I go to Antrix Database i click and then i hit Execute BacthFile and the have the error . where is the error? i this , i have only problems with this Creature_Proto.
I into in Game_Master_Pack and copy and paste in other docuement, go to Creature_Proto and i hit Import Wizard and says the error, the Creture_Proto is this:
/* creature_proto */
INSERT INTO creature_proto VALUES (11000000, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_proto VALUES (11000001, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_proto VALUES (11000002, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_proto VALUES (11000003, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_proto VALUES (11000004, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_proto VALUES (11000005, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_proto VALUES (11000006, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_proto VALUES (11000007, 255, 814, 9999999, 9999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);

[Outlands]

Ok, Ok, Forget IT, i execute it with other mode. All good 0 errors, but i can't speak with vendors :S fu!! The Item ID work, The Vendor and Creature_Proto ID Work!! plz help me i can't speak with they look:

[phc_chaos]

post the item id for yer weap please :wave:

they look cool and I dont know what your problem is.

it says "no sell template found" so that could be why.
and where did you get yer antrix version at? link please

[earthwalker]

awesome, nice work! +rep

[Outlands]

Ok ok i fix it, thx you phc_chaos for your time. i have antrix server 2.1.0 but its all modified, i have tier7 thx to Slyfox, the items of this post and some more. thx for all