User:Cegaiel/Macros/SandMining

Sand Mining (Autohotkey)

• The macro will walk you through the setup, via GUI interface.
• Asks for the pattern (ie Triple + 1 pair, or 2 pairs), all the options in Mining Guide.
• Whatever pattern is chosen, it will run the ore stones, as it is listed in wiki.
• Runs each workload in 6 (minimum) to 12 seconds (maximum) - depending on number of sets, for the particular pattern (@150 delay)
• If you see popup boxes, then you most likely chose the wrong pattern or one of the stones is too far away from you.
• Added: 10/27/2010

---

• Last Update: 10/28/2010 PM
  • I have aborted the pixel search method of finding the popup button. When working sandmines, on all sand terrain, it would occassionaly think an OK button was there, when it was not (thus causing you to move/run). Regardless of how I adjusted the shades, the results seemed to vary on occassions. Instead I now have included an OK.PNG image file in the zip. Make sure this file is in the same folder as your scripts. Now it will search for the actual word OK, in the popup. I have adjusted the script so it will find it, regardless of your resolution. You should not need to adjust anything. Tested at 1024x768, 1280x1024, 1680x1050 so pretty sure it will work on all. Basically this means that on the Sterope Public Sandmine, you should find yourself not moving/walking randomly.
• Last Update: 10/30/2010
  • Consolidated both the menus, at beginning into one menu. Also made the GUI windows pinup at the top left corner, automatically, so you dont have to drag it out of way anymore.
  • Second update on 10/30/2010: Replaced Triple pattern with Triple Alternative pattern from wiki. That results in 1 unbroken stone, instead of 2. Better chance for more gems and huge.
• Last Update: 10/30/2010
  • Minor update. If you record your ore locations and forget to choose pattern, it will now still remember the locations. So just choose a pattern and try again. Previously, the ore stones coordinates were lost when forgetting to select a pattern, from pulldown menu and running (Start).
  • Added an "Oops" button. This will run the last pattern and ore stone locations. No need to reselect patterns, on pulldown menu or reselect ore stone locations. Just ignore that it says "0 or 7 ore stones captured" and no need to reselect the pattern (Leaving as "Select one" is just fine, it will use whats listed as "Last Pattern:" on the GUI). The only time this button would be used, is if you forgot to minimize chat and it sent a bunch of AAASAAASAAAS, etc to the chat bar. Just go ahead and minimized it, hit the Oops button, and voila!
• Last Update: 11/02/2010
  • Fixed the "7 color" pattern. Was broken, missing a critical click... All pattern should work 100%, I hope...
• Last Update: 11/04/2010
  • Very minor update, not even worth mentioning. Focus goes to the game client after the GUI menu reappears, after mining (instead of focus going to GUI menu). Also updated some notes in the Help button area.
• Last Update: 11/13/2010
  • Updated the 4 color (3 Pair) pattern. Even though I used the wiki pattern perfectly, it was leaving 3 stones. It now clicks on the last 3 stones which will break them all. This is now a desireable/perfect pattern (100% all stone breaks). Help button notes has also been updated to reflect this.
• Last Update: 11/23/2010
  • Very minor update - Updated the notes, in the Help screen, that lets you know this macro disables the mouse while it is running the mine. If you should pause it, in the middle, your mouse will not move. You either need to resume and let it finish OR just Ctrl+R (Reload) the script to re-enable your mouse. Also rearranged triple pair on pull down menu, to be next to 2 pair. Easier to find/more logical, imo.
• Last Update: 11/25/2010
  • Adjusted the time to show 1/100th of seconds on GUI
• Last Update: 12/20/2010
  • Went through the code with a fine tooth comb. Found several inefficient pieces of code.
  • The macro will now work your mine 33% faster (without any change to the delay configuration).
  • Improved the popup detection routine. Previously lag may have cause a popup to not be closed correctly. The routine now checks for a popup and closes it, when found. If found, it runs the popup routine over and over until the popup is no longer detected. As soon as it verifies, that it is closed (whether it takes 1 time or multiple tries), it moves on. But not until then.
• Last Update: 12/30/2010
  • Added a F2 hotkey, that will abort the current pattern (stop clicking stones). This is idea if you forgot to minimize chat and want to abort the script. You can still click the Oops button after you minimize chat, to repeat the pattern. The macro is difficult to stop with the Pause (Ctrl+P) and Reload (Ctrl+R) hotkeys, but the holding down F2 will always work.
• Last Update: 1/3/2012 - New improved popup detection and closing.

---

IMPORTANT NOTES ABOUT DELAYS

At the top of the macro (view with text editor) or load the macro in ahk, right click the green box (in system tray) and click "Edit this script". Here you can edit the delay:

;	// START CONFIGURATION AREA

	;Set the speed in microseconds (100 = 1/10th second, 1000 = 1 second, etc)
	;If you got a slower computer or lag, then try raising it 50 or 100 at a time, ie 200, 250, 300

	;This is the speed that it selects/highlights your ore stones
	;If you fail to see all the stones getting selected, or getting "Ore Busy" popup messages, etc

		Delay = 150  ;Safe (lag) is 200+, Fast is 100 (fast computer, no lag) - I use 150 personally.


	;If you have problems with it not closing the popup, then try adjusting this number higher.

		PopUpDelay = 250  ;Safe (lag) is 250+, Fast is 150 (fast computer, no lag)


;	// END CONFIGURATION AREA

The lower the delay, the faster the macro operates (clicking stones). The higher the delay, the slower it runs, making it more lag friendly/slower computer friendly.

The delays are in microseconds (100 = 1/10th second, 1000 = 1 second, etc).

The lowest I recommend trying is 150. If you find it is missing some of the stones, or trying to click an already highlighted stone, or getting pop up errors "Ore stone busy", then you have it to low and need to increase the number to slow it down.

Lower or raise in 50 increments: 150, 200, 250, 300, etc. Once you have it operating smoothly, then possibly fine tune it in increments of 25. But if it ain't broke, dont try to fix it ;)

---

INSTRUCTIONS:

Before you work the mine, a pulldown menu will ask what the pattern is, choices are:

• 7 Color
• 6 Color (1 Pair)
• 5 Color (2 Pairs)
• 5 Color (Triple)
• 4 Color (3 Pairs)
• 4 Color (Triple + Pair)
• 4 Color (Quadruple)
• 3 Color (Triple + 2 Pairs)
• 3 Color (Quad + Pair)
• 3 Color (Quintuple)

Explanation of each pattern is located in the Sandmining Guide.

Choose the correct set of stones you see, then click Next. Then middle click all the stones

NOTE: Make sure you select (middle click) all of the stones with the highest amount of same colors first.

ie

Triple + Pair. You would middle click the triple colors first, then the pair, then all remaining single colors

Triple + 2 Pair. You click the triple colors first, then first pair, then the 2nd pair next, then the single colors.

Quadruple + 1 Pair. You would select the 4 stones with the same color first, then the pair next, then the single colors.

2 Pairs. You would first click the first pair, then the second pair, then the single colors.

1 Pair. You would first click the pair, then all the single colors.

If all goes well, then it should break all the stones possibly, for that pattern. Click the Help button to see what patterns should break all stones and which should have 1 or more stones remaining.

NOTE: You should NOT get any pop up messages saying "That workload has no value." If you do, then you likely chose the wrong pattern.

---

So you ready to give it a try? Just remember, wiki says that the gem locations are in these regions, so make sure you are sandming in the correct region. There is usually a public sandmine next to the CS in each region.

• Alcyone - Topaz
• Celeano - Emerald
• Maia - Ruby
• Merope - Sapphire
• Sterope - Quartz
• Taygete - Opal
• Sinai - Diamond

---

VIDEO:

Youtube Video of the macro in action.

---

DOWNLOAD:

Make sure you check back here often (daily or couple time a week) for updates. After releasing a new macro, I tweak it, find newer/better solutions, etc, etc and update very frequently.

.zip file includes .ahk and ok.png files. Make sure the ok.png is in the same folder as the scripts.

Download .zip file from Wiki Note wiki will produce a corrupt .zip file if downloaded with IE. Download with Firefox or Chrome.

Download .zip file from Mirror Site - No corrupt errors when downloaded with IE. Firefox/Chrome is fine too, of course.