Guild Level:
Custom value on guild mysql (how to increase the guild level? :S)

Currencies:
-Gold (referred to guild vault gold)
-Workers (referred to custom value - guild mysql)
-Stone (referred to custom value - guild mysql)
-Wood (referred to custom value - guild mysql)
-Special: (referred to custom value -guild mysql, will be set togheder with the mask at guild creation)
can be:
0;steel (humans)
1;mana (b/helfs)
2;mithril (dwarfs)
3;plague (forsaken)
4;thorium(orcs)
5;ley(nelfs)
6;mojo(troll)
7;energy(gnomes)
8;herbs(taurens)
9;crystal(draenei),
Currencies Limits:
-MaxWorkers (referred to custom value - guild mysql, is the population limit - the formula is 15+3*guild level + building bonuses)
-MaxStorage (referred to custom value - guild mysql, is the max amount of stone and wood - ie: 400 means ma 400 stone and 400 wood and 400 special - the formula is 500+50*guild level + building bonuses)

Shop Types:

-Buildings/Ships
-Armory
-Units
-Trade Goods

Shop Masks

-Buildings masks:                -Buildings Submask:

1;HUMAN BUILDINGS                1;ENCAMPMENT
2;ORC BUILDINGS                        2;MILITARY
3;DWARF BUILDINGS                3;RESOURCES
4;NIGHTELF BUILDINGS                4;DEFENSE
5;UNDEAD BUILDINGS                5;SHIPS
6;TAUREN BUILDINGS                6;MISC
7;GNOME BUILDINGS
8;TROLL BUILDINGS
9;BLOODELF BUILDINGS
0;DRAENEI BUILDINGS

-Unit Masks:                        -Unit Submasks:

1;HUMAN UNITS                        1;COMMONER
2;ORC UNITS                        2;GATHERER
3;DWARF UNITS                        3;SOLDIER
4;NIGHTELF UNITS                4;PIRATE
5;UNDEAD UNITS                        5;ADVANCED
6;TAUREN UNITS                        6;MISC
7;GNOME UNITS
8;TROLL UNITS
9;BLOODELF UNITS
0;DRAENEI UNITS

-Armory Masks:                        -Armory Submasks:

1;ARMORS                        1;BASIC
2;WEAPONS                        2;ADVANCED
3;ARTILLERY                        3;ELITE
4;TABARDS
5;CLOTHING
6;MISC

-Trade Goods Masks:

1;RESOURCES
2;FURNITURE
3;UTILITIES
4;FOOD/WATER
5;EXPENSIVE
6;MISC

Income formulas:

Gold per week: 400+100*guild level
Workers per week: 5+4*guild level
Stone per day: 50+20*guild level + building/worker bonuses
Wood per day: 50+20*guild level + building/worker bonuses
Special per day: 20+10*guild level + building/worker bonuses

So guild table structure:

ID(referring to guild id on the original DB, where takes other ifos), Level, Gold(not sure), Workers, MaxWorkers, Stone, Wood, Special, SpecialName*, MaxStorage, BuildingsMask*, BuildingsSubmask*, UnitMask*, UnitSubmask*, ArmoryMask*, ArmorySubmask*, GoodsMask*, GoldIncome, WorkerIncome, StoneIncome, WoodIncome, SpecialIncome

*Default is NULL (masks are counted for EACH number, so if the value of buildingsmask is 145 the guild will see in the shop the masks 1 4 and 5, in that case orc, undead and tauren buildings, with a 02 buildingssubmask, will see of those buildings only 0 and 2 that are encampment and gathering buildings)

Cost: w=workers / g=gold / l=wood / p=stone /s=special

Then, shop table DB would be

ID, Name, Level, Type, WorkerCost, GoldCost, WoodCost, StoneCost, SpecialCost, Mask, Submask1, Submask2, Submask3, Submask4, Time, Tooltip, Income1, Income1type, Income2, Income2type, Income3, Income3type, RequiredLevel, RequiredID1, RequiredID2, RequiredExtra, ItemID, Icon

where

ID -the id
Name -the name
Level -item level (could be useful for later stuff)
Type -1 building, 2 unit, 3 armory, 4 good
WorkerCost - the following are how much they cost
GoldCost
WoodCost
StoneCost
SpecialCost
Mask - the relative mask (related to type of course)
Submask1 - the relative submasks (related to the type...
Submask2 ...i've split them because maybe it's easier to manage for you)
Submask3
Submask4
Time - the time that requires to be built (we will need a cooldown storage DB i think, and i'm not sure of the format)
Tooltip - description of the item
Income1 - the amount of the income (works like the stats at the items)
Income1type - the type of the income (1 worker, 2gold, 3wood, 4stone, 5special)
Income2
Income2type
Income3
Income3type
RequiredLevel - guild level required to buy this
RequiredID1 - you need at least one of that ID before buying this
RequiredID2
RequiredExtra - may serve for something
ItemID - the ref ID to the Ingame item (like build contract or recruit token)
Icon - the path in the website to the item icon (should be a 100x100 pic)

Buildings

--basic--

Tent
Cost: 50l 90g                        Time: 1day   Income: +2 worker limit
Mask all Submask 1

Wooden Tower
Cost: 150l 100g                        Time: 2days  (defensive building)
Mask all Submask 4

Wooden Palisade
Cost: 40l 40g                        Time: Istant (defensive building)
Mask all Submask 4

Well
Cost: 30l 60p 70g                Time: 1day   (water supply for the camp)
Mask all Submask 1,3,6

Command Tent
Cost 70l 150g                        Time: 2days  Income: +20 gold/day
Mask all Submask 2

Storage Pile
Cost 2w 100l 100g                Time: 2days  Income: +50 storage limit
Mask all Submask 3

Forge
Cost 1w 80p 120g                Time: 1day   (allow weapon/armor upgrades)
Mask all Submask 1,3,6

--Human--

Human Farm
Cost: 2w 150l 50p 140g                Time: 5days  Income: +5 worker limit
Mask 1 Submask 3

Human House
Cost: 1w 150l 80p 160g                Time: 6days  Income: +1 worker/day
Mask 1 Submask 3

Human Blacksmith
Cost: 2w 160l 120p 170g                Time: 6days  Income: +20 special/day
Mask 1 Submask 2,3

Human Stable
Cost: 2w 180l 50p 100g                Time: 4days  (allow horses)
Mask 1 Submask 2,3

Human Inn
Cost: 4w 200l 120p 120g                Time: 5days  Income: +40 gold/day
Mask 1 Submask 3,6

Human Chapel
Cost: 4w 200l 120p 120g                Time: 5days  (holy upgrades)
Mask 1 Submask 2,6

Human Barn
Cost: 3w 180l 50p 130g                Time: 6days  Income: +200 storage limit
Mask 1 Submask 3

Human Watchtower
Cost 3w 50l 450p 300g 40s        Time: 3days  (defensive building)
Mask 1 Submask 4

Human Wall (low quality)
Cost 2w 50l 600p 250g 20s        Time: 2days  (defensive building)
Mask 1 Submask 4

Human Wall (high quality)
Cost 3w 100l 800p 450g 60s        Time: 2days  (defensive building)
Mask 1 Submask 4

Human Gate
Cost 3w 120l 500p 240g 30s        Time: 2days  (defensive building)
Mask 1 Submask 4

Human Town Hall
Cost 5w 600l 920p 550g 50s        Time: 7days  Income: +15 woker limit +20 gold/day
Mask 1 Submask 2,3,6

Human Mage Tower
Cost 7w 800l 1000p 1300g 60s        Time: 8days  (ultimate mage building)
Mask 1 Submask 2,6

Human Cathedral
Cost 7w 200l 1500p 2300g 20s        Time: 7days  (ultimate paladin building)
Mask 1 Submask 2,6

Human Barracks
Cost 10w 1200l 3000p 2500g 250s Time: 10days (ultimate command building)
Mask 1 Submask 2