paintball event

[BillyBob31]

Hmm, Its good.. Has a few glitches.. Ez fix though..
Shoots quick.. just a fast shooting gun.. nothing special really..
code this is C++ and watch the awesomeness happen.

Could you list EXACTLY what you fixed ... and maybe also the new sql or w/e so we can use the fixes if it sounds good ??

... maybe also list the bugs you noticed and fixed ... =)

[Skuxta]

I made paintball ages ago. But it was scripted up and it was in an arena ( edited inside the arena into a paintball arena )so it worked quite well. ( used arena teams ) And also has paintball armour sets. For some of those who played on Seven Suns they would know. Nice release though

[BillyBob31]

Um how do i make it so everyone can use and not just hunters ....?


.. and btw when i try to buy from vendor it says "cant carry any more of these"
and no not full inventory and yes i have enough gold ....

[Skuxta]

You take of the requirement in one of the fields in the database.

Or you can make a crossbow with a gun display Id I think.

Or have a npc that teaches you the gun skill.

[pooooo132]

yes just get a npc to teach you the gunskill what a bad question, what do u think only hunters can use guns or somthing 0.o?

[pooooo132]

O and the vendors yeag sorry i dont know how to fix that it does it on my server to

[BillyBob31]

yes just get a npc to teach you the gunskill what a bad question, what do u think only hunters can use guns or somthing 0.o?

Well if you have a blizzlike server and you dont want everyone to be able to use guns unless they are that kinda character that is supposed to use guns, except for this paintball deal ...
so yeah its a good question ...

[pooooo132]

Ok sorry lol i forgot about blizzlike servers :P i thought it was all about FUNSERVERS

[BillyBob31]

No its not so if anyone knows answer to my question cool =)

Um how do i make it so everyone can use and not just hunters ....?


.. and btw when i try to buy from vendor it says "cant carry any more of these"
and no not full inventory and yes i have enough gold ....

[Lilltimmy]

If you get an Error when you buy it, it can be those 2 Probs i had:

1: When you add an Item to an vendor --> .npc vendoradditem <itemID> 1 write 1 or more after dont leave it blank then it will be a Bugged item :P

2: If you have like 220k or more you cant buy things from Vendors... Money Bugg

[BillyBob31]

Its not a money bug cause all my custom items and such and everything else works fine ... its just this vendor and these 2 items .... so yeah i havent had time to search for that problem wondering if anyone else had this and figured it out ...

.... also wondered how to make everyone able to use the weapon .... without teaching everyone the bow hunter skill =/ cause i have blizzlike server

[Skuxta]

Like I said before. Use a bow or crossbow and have it to a Gun display ID.

Or you can write a script in C++ that teaches them the gun skill and then un teaches it..

Or have a npc that appears after the event. In which to get out of the event you have to un learn guns and then the npc will teleport you out.

[moltn]

Ok i made these for a paint ball event on my server its pretty cool i made the gun attack speed pretty fast like a real paint ball gun and made the dps pretty low and i made a paintball course (im gonna leave the pantball course up to you) but here are the sql query's for the paint ball gun, vendor, and paint balls

for paint balls its:

INSERT INTO items (entry, class, subclass, field4, name1, 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 (123125,6,3,-1,"blue painballs","blue painballs","blue painballs","blue painballs",31813,4,0,1000000,10000,24,-1,-1,70,70,0,0,0,0,0,0,0,100,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,5,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3000,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,0,0,0,0,0,"need your painballs to play paintball",0,0,0,0,0,2,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0);

and for the gun its:

INSERT INTO items (entry, class, subclass, field4, name1, 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 (123123,2,3,-1,"pantball gun v1","pantball gun v1","pantball gun v1","pantball gun v1",41430,4,0,00000,00000,26,-1,-1,70,70,0,0,0,0,0,0,0,1,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,1,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0500,3,100,1583,1,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,0,"dont foget to buy your painballz",0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

and for the vendor its:

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES (123126, 100, 100, 814, 100000000, 100000000, 10000000, 1, 128, 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, 0, 0);
INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_float1, unknown_float2, Civilian, Leader, info_str)
VALUES (123126,"pantball vendor","buy paintball guns and paintballs here!",0,7,0,0,0,NULL,22917,22917,1, 1,1,NULL, '');
INSERT INTO vendors (entry, item, amount)
VALUES (123126,123125,-1);
INSERT INTO vendors (entry, item, amount)
VALUES (123126,123123,-1);

hope you like it its a big hit on my server so i just decided to share it :wave:

p.s o and if u think this is a repost i promiss you its not and i there might be a paintball event out there already but if there is i have never heard of it

Nicely done! +Rep for the data and for sharing! ^^ This'll be a fun Event for my server. Hehe. :3

[iccy]

hehe... thats a good idea I'll have to try it out .

[moltn]

Ok i made these for a paint ball event on my server its pretty cool i made the gun attack speed pretty fast like a real paint ball gun and made the dps pretty low and i made a paintball course (im gonna leave the pantball course up to you) but here are the sql query's for the paint ball gun, vendor, and paint balls

for paint balls its:

INSERT INTO items (entry, class, subclass, field4, name1, 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 (123125,6,3,-1,"blue painballs","blue painballs","blue painballs","blue painballs",31813,4,0,1000000,10000,24,-1,-1,70,70,0,0,0,0,0,0,0,100,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,5,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3000,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,0,0,0,0,0,"need your painballs to play paintball",0,0,0,0,0,2,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0);

and for the gun its:

INSERT INTO items (entry, class, subclass, field4, name1, 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 (123123,2,3,-1,"pantball gun v1","pantball gun v1","pantball gun v1","pantball gun v1",41430,4,0,00000,00000,26,-1,-1,70,70,0,0,0,0,0,0,0,1,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,1,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0500,3,100,1583,1,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,0,"dont foget to buy your painballz",0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

and for the vendor its:

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES (123126, 100, 100, 814, 100000000, 100000000, 10000000, 1, 128, 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, 0, 0);
INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_float1, unknown_float2, Civilian, Leader, info_str)
VALUES (123126,"pantball vendor","buy paintball guns and paintballs here!",0,7,0,0,0,NULL,22917,22917,1, 1,1,NULL, '');
INSERT INTO vendors (entry, item, amount)
VALUES (123126,123125,-1);
INSERT INTO vendors (entry, item, amount)
VALUES (123126,123123,-1);

hope you like it its a big hit on my server so i just decided to share it :wave:

p.s o and if u think this is a repost i promiss you its not and i there might be a paintball event out there already but if there is i have never heard of it

Hehe, it would really be awesome if everybody could use the Paintball Gun. =P IE: Like Mages and Warlocks. They can't use guns at all.