SpellVendors.mac (20 Aug 2004)

Post your completed (working) macros here. Only for macros using MQ2Data syntax!

Moderator: MacroQuest Developers

BlackTooth
a lesser mummy
a lesser mummy
Posts: 50
Joined: Mon Dec 08, 2003 10:32 am

weee more goodies

Post by BlackTooth » Fri Aug 20, 2004 4:24 pm

Heres Halas and Everfrost Peaks did em last night while i was visitin LDoN =)

spellvendorlist.inc

Code: Select all

[Halas]
Jenkis O`Malley=(325,340)
Corak=(424,309)
Tukanta=(423,356)
Telvina=(453,313)
Boraskor=(449,356)
Bolace=(482,326)
Toralia=(480,340)
Shenigan Mc`Macky=(232,654)
[Everfrost Peaks]
Starn Bearjumper=(-3431,2871)
SpellVendors.inc

Code: Select all

[2634]
Jenkis O`Malley=Halas
[2635]
Jenkis O`Malley=Halas
Shenigan Mc`Macky=Halas
[2636]
Jenkis O`Malley=Halas
Shenigan Mc`Macky=Halas
[2637]
Jenkis O`Malley=Halas
Shenigan Mc`Macky=Halas
[2638]
Jenkis O`Malley=Halas
Shenigan Mc`Macky=Halas
[2639]
Jenkis O`Malley=Halas
Shenigan Mc`Macky=Halas
[2640]
Jenkis O`Malley=Halas
Shenigan Mc`Macky=Halas
[2641]
Jenkis O`Malley=Halas
[40]
Corak=Halas
[93]
Corak=Halas
[200]
Corak=Halas
[205]
Corak=Halas
[213]
Corak=Halas
[225]
Corak=Halas
[266]
Corak=Halas
[267]
Corak=Halas
[36]
Corak=Halas
[203]
Corak=Halas
[211]
Corak=Halas
[224]
Corak=Halas
[269]
Corak=Halas
[270]
Corak=Halas
[271]
Corak=Halas
[272]
Corak=Halas
[274]
Corak=Halas
[275]
Corak=Halas
[17]
Tukanta=Halas
[50]
Tukanta=Halas
[278]
Tukanta=Halas
[279]
Tukanta=Halas
[35]
Tukanta=Halas
[86]
Tukanta=Halas
[230]
Tukanta=Halas
[261]
Tukanta=Halas
[280]
Tukanta=Halas
[281]
Tukanta=Halas
[282]
Tukanta=Halas
[283]
Tukanta=Halas
[284]
Tukanta=Halas
[505]
Tukanta=Halas
[345]
Tukanta=Halas
[15]
Telvina=Halas
[39]
Telvina=Halas
[60]
Telvina=Halas
[150]
Telvina=Halas
[151]
Telvina=Halas
[162]
Telvina=Halas
[349]
Telvina=Halas
[506]
Telvina=Halas
[111]
Telvina=Halas
[131]
Telvina=Halas
[160]
Telvina=Halas
[161]
Telvina=Halas
[167]
Telvina=Halas
[326]
Telvina=Halas
[431]
Telvina=Halas
[509]
Telvina=Halas
[12]
Boraskor=Halas
[48]
Boraskor=Halas
[110]
Boraskor=Halas
[146]
Boraskor=Halas
[147]
Boraskor=Halas
[228]
Boraskor=Halas
[308]
Boraskor=Halas
[61]
Boraskor=Halas
[144]
Boraskor=Halas
[148]
Boraskor=Halas
[149]
Boraskor=Halas
[220]
Boraskor=Halas
[222]
Boraskor=Halas
[265]
Boraskor=Halas
[508]
Boraskor=Halas
[649]
Boraskor=Halas
[1884]
Boraskor=Halas
[145]
Bolace=Halas
[152]
Bolace=Halas
[153]
Bolace=Halas
[155]
Bolace=Halas
[507]
Bolace=Halas
[49]
Bolace=Halas
[64]
Bolace=Halas
[154]
Bolace=Halas
[158]
Bolace=Halas
[163]
Bolace=Halas
[168]
Bolace=Halas
[170]
Bolace=Halas
[389]
Bolace=Halas
[417]
Bolace=Halas
[510]
Bolace=Halas
[112]
Toralia=Halas
[156]
Toralia=Halas
[157]
Toralia=Halas
[159]
Toralia=Halas
[337]
Toralia=Halas
[2611]
Shenigan Mc`Macky=Halas
[2612]
Shenigan Mc`Macky=Halas
[2613]
Shenigan Mc`Macky=Halas
[2633]
Shenigan Mc`Macky=Halas
[2614]
Shenigan Mc`Macky=Halas
[2615]
Shenigan Mc`Macky=Halas
[2616]
Shenigan Mc`Macky=Halas
[2617]
Shenigan Mc`Macky=Halas
[2618]
Shenigan Mc`Macky=Halas
[2619]
Shenigan Mc`Macky=Halas
[2620]
Shenigan Mc`Macky=Halas
[2621]
Shenigan Mc`Macky=Halas
[2068]
Shenigan Mc`Macky=Halas
[75]
Starn Bearjumper=Everfrost Peaks
[226]
Starn Bearjumper=Everfrost Peaks
[277]
Starn Bearjumper=Everfrost Peaks
[227]
Starn Bearjumper=Everfrost Peaks
[365]
Starn Bearjumper=Everfrost Peaks
[511]
Starn Bearjumper=Everfrost Peaks
[526]
Starn Bearjumper=Everfrost Peaks
[96]
Starn Bearjumper=Everfrost Peaks
[434]
Starn Bearjumper=Everfrost Peaks
[437]
Starn Bearjumper=Everfrost Peaks
[95]
Starn Bearjumper=Everfrost Peaks
[31]
Starn Bearjumper=Everfrost Peaks
[63]
Starn Bearjumper=Everfrost Peaks
[62]
Starn Bearjumper=Everfrost Peaks
[435]
Starn Bearjumper=Everfrost Peaks
[438]
Starn Bearjumper=Everfrost Peaks
[527]
Starn Bearjumper=Everfrost Peaks
[32]
Starn Bearjumper=Everfrost Peaks
[98]
Starn Bearjumper=Everfrost Peaks
[436]
Starn Bearjumper=Everfrost Peaks

Chill
Contributing Member
Contributing Member
Posts: 435
Joined: Fri May 07, 2004 5:06 pm
Location: Erie, PA

SpellUpdate.mac

Post by Chill » Fri Aug 20, 2004 8:16 pm

Thanks Black, I just added those to my ini file which I will post a link to as soon as I find a place to put it (anyone want to hook me up with some web storage?

Wrote another small macro to add other peope's ini files to mine. I will post it here in case anyone else wants to combine their own ini files:

Code: Select all

| SpellUpdate.mac - 20 Aug 2004
| Simple macro to add spell vendor data from one ini file to another,
| to be used with SpellsToBuy.mac later.
| usage: /mac SpellUpdate <FILENAME>
| *note you must supply the name of the file containing spell vendor data to be included into your INIFile defined below

#define INIFile SpellVendors.ini

Sub Main
/declare newfile string outer
/declare c int outer 0
/declare v int outer 0
/declare vendors string outer

/if (!${Defined[Param0]}) {
   /echo usage: /mac SpellUpdate <file name>
   /end
} else {
   /varset newfile ${Param0}
}

/for c 1 to 5797
   /if (${Ini["${newfile}","${c}"].NotEqual[NULL]}) {
      /varset vendors ${Ini["${newfile}","${c}"]}
		/for v 1 to ${Math.Calc[${vendors.Count[|]}-1]}
		   /echo Adding Spell[${c}] Vendor: ${vendors.Arg[${v},|]} for ${Ini["${newfile}","${c}","${vendors.Arg[${v},|]}"]}
		   /ini "INIFile" "${c}" "${vendors.Arg[${v},|]}" "${Ini["${newfile}","${c}","${vendors.Arg[${v},|]}"]}"

		/next v
   }
/next c

/endmacro

No_Idea_At_All
a lesser mummy
a lesser mummy
Posts: 49
Joined: Sat Aug 07, 2004 11:28 pm

Post by No_Idea_At_All » Fri Aug 20, 2004 11:52 pm

Damn wish this was around a couple of years ago :).

Anyway going to go wandering today and see if I can't fill this out a fair bit.

hehe didn't see the second page, SpeelUpdate is cool, saves having to sort so many files out. Was already thinking up plans on how to add without duplication.

Chill
Contributing Member
Contributing Member
Posts: 435
Joined: Fri May 07, 2004 5:06 pm
Location: Erie, PA

Post by Chill » Sat Aug 21, 2004 12:33 am

Yea, would be silly to have to cut and paste everything. I will take care of compiling the inis posted, so you dont really need to worry about that unless you want to compile your own. In a few days I will put them all together and post a zip of the full ini.

Just try to hit up as many spell vendors as you can and post the ini files!

No_Idea_At_All
a lesser mummy
a lesser mummy
Posts: 49
Joined: Sat Aug 07, 2004 11:28 pm

Post by No_Idea_At_All » Sat Aug 21, 2004 1:49 am

OK did a little running around today.

I also modified the macro to just continue running and whenever you open up a merchant to check for spells.

Spell vendor zones completed :
Rivervale
Iceclad Ocean
Thurgadin
Nedaria's Landing
Natimbi
Abysmal Sea
Erudin (1 enchanter in library wouldn't speak to me, this does not include Erudin Palace zone.)
Surefall Glade
Toxxulia Forest
North Karana
East Commonlands (non-adventure merchant)
North Ro (non-adventure merchant)
Oasis
South Ro (non-adventure merchant, DE's not speaking to me)
Butcherblock (druid ring only)
Steamfont Mountains
Plane of Knowlegde
Echo Caverns
ShadowHaven
Bazaar
Everfrost
Halas


Going to link files rather than paste here.

SpellVendorList.ini
SpellVendors.ini

Also just posting the continuos running macro.
All you have to do is make sure the merchant you are viewing is the closest one to you.

Code: Select all

| SpellVendors.mac - 20 Aug 2004 
| Will add Merchants and their zones to the specified INIFile. 
| Will add Merchants with their locs, organized by Zone, to the Specified INIListFile 
| Run with a spell vendor targeted or a Merchant Window open. 

#define dly 100 
#define INIFile SpellVendors.ini 
#define INIListFile SpellVendorList.ini 

Sub Main 

/declare c int outer 0 
/declare spellcount int outer 0 

:Main
 /if (${Merchant.Open}) {
   /target ${NearestSpawn[npc merchant].Name}
   /delay 8

   /for c 1 to 80 
      /if (${Merchant.Item[${c}].Name.Find[Spell:]} || ${Merchant.Item[${c}].Name.Find[Song:]}) { 
         /echo Adding ${Merchant.Item[${c}].Spell}  vendor:  ${Target.CleanName} (${Zone}) 
         /ini "INIFile" "${Merchant.Item[${c}].Spell.ID}" "${Target.CleanName}" "${Zone}" 
         /varcalc spellcount ${spellcount}+1 
      }
   /next c 

   /if (${spellcount}) { 
      /ini "INIListFile" "${Zone}" "${Target.CleanName}" "(${Int[${Target.X}]},${Int[${Target.Y}]})" 
      /echo (${spellcount}) spells added for ${Target.CleanName} (${Zone}) on ${Time.Date} 
      /mqlog (${spellcount}) spells added for ${Target.CleanName} (${Zone}) 
   } else {
	/echo No Spells on ${Target.CleanName}
   }
   /call Closewin 
   /varset spellcount 0
 }
 /goto :Main
/endmacro 

Sub CloseWin 
   /notify MerchantWnd MW_DoneButton leftmouseup 
   /delay 1 
/return

User avatar
blueninja
a grimling bloodguard
a grimling bloodguard
Posts: 541
Joined: Thu Aug 28, 2003 7:03 am
Location: Göteborg, Sweden

Post by blueninja » Sat Aug 21, 2004 6:22 am

Here's Pok, WFP caster guild, NFP cleric/pally guild, Shady in EC, Overthere, Bazaar and Qeynos catacombs.


EDIT: Hmm well guess it was a bit too big for a paste. Here are links instead:

SpellVendorList.ini
SpellVendors.ini

Chill
Contributing Member
Contributing Member
Posts: 435
Joined: Fri May 07, 2004 5:06 pm
Location: Erie, PA

Post by Chill » Sat Aug 21, 2004 10:47 am

Added NIAA and BlueNinja's ini files into mine and posted them up in the first 3 posts. Still lots of zones to hit, but its coming along!

BlackTooth
a lesser mummy
a lesser mummy
Posts: 50
Joined: Mon Dec 08, 2003 10:32 am

Post by BlackTooth » Thu Aug 26, 2004 1:19 pm

Looks as tho the files are gettin pretty big here

If you want me to host them I would be happy to do so =)

Chill
Contributing Member
Contributing Member
Posts: 435
Joined: Fri May 07, 2004 5:06 pm
Location: Erie, PA

Web Space

Post by Chill » Thu Aug 26, 2004 2:31 pm

Sure! If you can hook me up with a little bit of storage that would rock.

Still a lot of zones left to hit too. A lot of old world cities, etc. You can basically look at the second ini file to see which zones / vendors not listed there.

User avatar
Night Hawk
a grimling bloodguard
a grimling bloodguard
Posts: 590
Joined: Fri Aug 13, 2004 4:56 pm

Post by Night Hawk » Tue Sep 28, 2004 3:19 pm

Has this been abandoned or just forgotten?

Chill
Contributing Member
Contributing Member
Posts: 435
Joined: Fri May 07, 2004 5:06 pm
Location: Erie, PA

Post by Chill » Tue Sep 28, 2004 11:40 pm

Neither, I have added in all spell data that has been posted to date. I said up in the first post I wasnt going to run around to vendors myself, only write the tool to do it.

I will help maintain the ini files if/when others get more spell data. They can be downloaded from the first three posts.

User avatar
Night Hawk
a grimling bloodguard
a grimling bloodguard
Posts: 590
Joined: Fri Aug 13, 2004 4:56 pm

Post by Night Hawk » Sat Oct 16, 2004 3:49 pm

I have the macro for looking up what spells I need. And I have this one with the collected data, and the macro to collect the data. But how do they acctually cross each other? I gotta open up INI and search for it? Just wondering if I was missing something here.

Chill
Contributing Member
Contributing Member
Posts: 435
Joined: Fri May 07, 2004 5:06 pm
Location: Erie, PA

Post by Chill » Mon Oct 18, 2004 9:39 am

No, the ini with all the spell vendor location is meant to support a future enhancement of the SpellsToBuy macro.

I think the original thought was to display the vendor information in addition to the names of the spells that you need. It would not be that hard to do and I may be willing to do it in the next few days if you dont want to make the edit yourself.

Will look at the ini file and see whats missing as well.

User avatar
blueninja
a grimling bloodguard
a grimling bloodguard
Posts: 541
Joined: Thu Aug 28, 2003 7:03 am
Location: Göteborg, Sweden

Post by blueninja » Mon Oct 18, 2004 9:44 am

I already did something like that.. The SearchVendors command will search the ini files made by chill's macro..
http://www.macroquest2.com/phpBB2/viewt ... 8519#64031

User avatar
Night Hawk
a grimling bloodguard
a grimling bloodguard
Posts: 590
Joined: Fri Aug 13, 2004 4:56 pm

Post by Night Hawk » Mon Oct 18, 2004 10:12 am

blueninja wrote:I already did something like that.. The SearchVendors command will search the ini files made by chill's macro..
http://www.macroquest2.com/phpBB2/viewt ... 8519#64031
Ahhh thanx Blueninja. Just shoot me now, I don't see how in the hell I missed a post like that more than once.