Union Limit - Restrict it to X Guilds

[Tazdingo]

Hello,

I put this thread in general zone because i think that will be interesting for alot of members.
I dont put it in help section because will be unnoticed to alot of members

So the main question is:

Someone knows how to restrict the limit of union to 3-4 guilds for example ?
vSro old files

I tried to figure it out playing with olly on my gameserver but i can't success.(sro_client too)
Im thinking of make a trigger that delete automatically the last guild that join when that union pass the limit (i dont see the tables of union so idk if its possible yet, its only an idea)

Thanks in advance

[MentaL]

[DrugDealers]

if you mean union limit of Velestia Server system
it's not a server files edit it's DB Side edit

in this is StoredProcedure


[dbo].[_AllianceCreate]

[Tazdingo]

if you mean union limit of Velestia Server system
it's not a server files edit it's DB Side edit

in this is StoredProcedure


[dbo].[_AllianceCreate]

I will take a look :)

[Royalblade]

Tazdingo,

If you mean the union limit system that i created on Velestia you most likely want to edit _AliianceCreate and _AllianceDelete or whatever they were called. Make an exception of union being deleted and at union creation put new guilds inside.

There is a way to make those ones invisible but i was lazy to implement it ever... its going to come in one of the updates most likely.

Also it's impossible to do it via a GS/client edit... ludoworks ppz have tried it, they were able to icnrease it but decreasing it didnt work as far as i know

[Tazdingo]

at union creation put new guilds inside.

There is a way to make those ones invisible but i was lazy to implement it ever... its going to come in one of the updates most likely.

I dont understand that part.
Do you mean to add "automatically" non-exist guilds ?

btw i 'll download velestia to have a look

[MeGaMaX]

Tazdingo,

If you mean the union limit system that i created on Velestia you most likely want to edit _AliianceCreate and _AllianceDelete or whatever they were called. Make an exception of union being deleted and at union creation put new guilds inside.

There is a way to make those ones invisible but i was lazy to implement it ever... its going to come in one of the updates most likely.

Also it's impossible to do it via a GS/client edit... ludoworks ppz have tried it, they were able to icnrease it but decreasing it didnt work as far as i know

it was some how if i decreased it less than the normal it fack up the other data -.- ( fack sro any way )

[Royalblade]

Yeah, tried the same as well.. it fucks up even more than that after u join and leave the union multiple times... at some point the guild will say 4/3 and will completely fck up and the _Alliance table shows you nothing because of the foreignkey....

The query keeps returning -1 tot he gameserver as well.

thats why i did it db sidedly... easiest solution really :)

[Royalblade]

Exec _Guild_Create @struserid,@refcharid; Exec _Guild_Create @struserid1,@refcharid1
Exec _Guild_Create @struserid2,@refcharid2; Exec _Guild_Create @struserid3,@refcharid3
Declare @2ndGuild int = (Select ID from SRO_VT_SHARD.dbo._Guild with (nolock) where Name = @struserid )
,        @3rdGuild int = (Select ID from SRO_VT_SHARD.dbo._Guild with (nolock) where Name = @struserid1 )
,        @4thGuild int = (Select ID from SRO_VT_SHARD.dbo._Guild with (nolock) where Name = @struserid2 )
,        @5thGuild int = (Select ID from SRO_VT_SHARD.dbo._Guild with (nolock) where Name = @struserid3 )

Just a little hint for you tazdingo :)

[Tazdingo]

Did you made a list of "clean chars" to associate it to these "nonexistent" guilds ?
I understand that @struseridX is the Name of the guild that you create and @refcharidX is the ID of the char that you will use to create that guild.
Im thinking of create "clean chars" then add it to another table with a value that say if that char is already in a guild or not to avoid a repeat. (I think it will work but btw i think there is a better way to do such a thing)

[Royalblade]

Well there kinda is^^

Skype:Akasch93

[Isoline]

can the same be done for Guilds? meaning like 20 guild members maximum amout of players (still lvl 5 guild)

[Royalblade]

Technically yes. In reality.. possible much easier than all that^^

[Tazdingo]

Well Today i start working at this idea and i got this :)



When someone create a new union it automatically add 2 "system" guilds, that cant be ban (you can ban it via client but db side will stay correctly added)

[Artuuro_lv]

Well Today i start working at this idea and i got this :)



When someone create a new union it automatically add 2 "system" guilds, that cant be ban (you can ban it via client but db side will stay correctly added)

if union master will ban that nulled02 and nulled03 guild he'll be able to join another 2 normal guilds.

[Isoline]

if union master will ban that nulled02 and nulled03 guild he'll be able to join another 2 normal guilds.

well, for that he need to edit _AlianceDelete smth like that :)