Hi,

I wanted as many others to use WoW-roster for an alliance of two guilds. I found that there is no native support for this.

I did setup one separate WoW-rosters for each guild. I then let our members upload data to those rosters.

Then i created a third roster which I named Optimus, that is the name of our alliance.

I then hacked together a SQL-script that merge the two first databases and put it together in the third, I let this script run nce every hour.

Dunno if this will help anyone but it works for me =)

I have all tables in the same database and use the following prefix's

roster_ = guild1
roster2_ = guild2
roster3_ = Alliance

Change the first INSERT row to match the name of you alliance and realm...

The script is attached to this posting...

Pallervante@Aszune

An other attempt to solve this problem Nice

Have you seen public roster in the download section?
This is something different in one db...

CU
Hannah

Yeah I read about that public mob. Never checked it though, was a bit concerned when I read something about not being able to limit who can upload.

I have however checked the public's homepage now. I really most say that I really like the feature that it shows every members guild name. My script will of course not do that....

I think PoloDude is working on that limiting persons who couls upload...

I just couldn't wait... Took me 30 minutes to get this working... =)