Alliance SQL script

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Alliance SQL script

Postby posterberg » Tue Aug 15, 2006 8:15 pm

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
Attachments
updateforwowroster.txt
Merge script
(5.45 KiB) Downloaded 256 times
Last edited by posterberg on Tue Aug 15, 2006 8:18 pm, edited 2 times in total.
User avatar
posterberg
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Tue Aug 08, 2006 12:23 pm

Alliance SQL script

Postby Hannah » Tue Aug 15, 2006 9:21 pm

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
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Re: Alliance SQL script

Postby posterberg » Tue Aug 15, 2006 11:38 pm

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....
User avatar
posterberg
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Tue Aug 08, 2006 12:23 pm

Alliance SQL script

Postby Hannah » Wed Aug 16, 2006 12:02 am

I think PoloDude is working on that limiting persons who couls upload...
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Re: Alliance SQL script

Postby posterberg » Wed Aug 16, 2006 2:10 am

I just couldn't wait... Took me 30 minutes to get this working... =)
User avatar
posterberg
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Tue Aug 08, 2006 12:23 pm


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron