[release] Battle Ground Flag LUA and SQL files

[runiker]

Hello all i have made a flag for both sides using sql and lua. They should work in theory but if a problem comes up report details asap so i can fix. I would be glad to help out anyone that needs it. All you need to do is spawn the horde flag at the horde base ally at theres. Here is some tips and tricks to get you going.

How it works. A player must get quest from there own flag, after getting quest must head and get to the ally flag from there head back to own flag.
This all must happen within 10 min or else quest will end.
This can be used for pvp or even pve depending on placement.

1. make some quests that need the token items found from getting flags
2. Make some npc's so it is harder to get back and forth.
3. not ready to make a place? place in the main citys


tech notes-
=flag's are lua scripted to give item if player has item from quest start
=Start of quest gives out Horde or ally mark to fig out if player is horde or ally.
=There is a 10 min timeline you might want to make this higher if your needs say so.
=The level is 100 min on quest change if need be
=Please keep in mind player will still have flag after death

----fix's that need be done----
Still have flag after death.
Flag exp time.

part 1 - Lua
part 2 - Lua
part 3 - Sql

[runiker]

Humm... Can anyone help me or tell me somthing anything even a lazy leaching flame would be good atm lol.

[Maisteri]

Sounds nice will test it soon

[hotandsekc]

i get an error saying "SQL Error: Table 'mangos.gameobject_names' doesnt exist."

[hotandsekc]

think if i change to gameobject_template it would work?

[Power of Illuminati]

It's because the SQL is made for a ascent DB

[TheSpidey]

It's not for mangos..

[runiker]

It's not for mangos..

Yes it does not work on mangos it was made in ascent.

[Bapesy]

To drop the flag after you do register a function as On Die (4) and then have the function remove the item.

Bapes

[runiker]

Alright thank you +rep