oXo u told us about vote and we choose option 1 about delete vote4silks and add 2 silk/hour to prevent cheatQuote:
Really sorry but the Vote4Silk is on account, not on IP.
Really can you? I would like to see those accounts made just for VOTE :DQuote:
oXo u told us about vote and we choose option 1 about delete vote4silks and add 2 silk/hour to prevent cheat
i can create more than 50 accounts and vote4silks alot every 12h i will get huge silks after week
Quote:
I will test it now.
set @FoundationDate = GetDate()
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_1', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_2', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_3', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_4', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_5', 1, 0, @FoundationDate,0,0)
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_6', 1, 0, @FoundationDate,0,0)
I tested this and something is missing because I see the other 6 guilds in the table but not in the union.Quote:
use this instead of the current one that create a fake 6 guilds at each and every union which means only 2 guilds are the limitCode:set @FoundationDate = GetDate() insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_1', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_2', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_3', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_4', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_5', 1, 0, @FoundationDate,0,0) insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_6', 1, 0, @FoundationDate,0,0)
here you go the query just copy paste itQuote:
I tested this and something is missing because I see the other 6 guilds in the table but not in the union.