Curse

Estic · Dec 02, 2006, 05:19 PM // 17:19

Hi there,

For all you Skill cappers out there looking for a nicely organised skill list… look no further! BUT! Before I will go any further, I am linking to Guildwiki pages in this Database. I would like to thank them for making this job a lot easier. If you can find all the elite skills nicely listed on one page it saves a lot of websearching. Beside that their pages have a nice look and setup. Yet again, thanks a lot people!

Now then: I created a database (DB) which lets you organise and search your capped skills easily (IMHO). It has been fabricated in Microsoft Acces. If you do not have Acces, the DB will not work (maybe it will with another DB program, but I’m not sure about that). The rest of this message will include a large explanation about the way the DB works. If you have worked with DB’s before… just go ahead and use it. I grouped the Query’s in Groups. I think they are easy to use this way, if you have questions I refer to the big message following this.

Database:
http://random.blobz.net/gw/estic/Elite_Skills.zip

Very well, for those of you who have never used a DB here’s a little explanation. All the data in a DB is stored in Tables (or in one specific Table here, “Elite Skills”). Ignore the Table “Elite Skills”, it’s a big load of unorganised data. It will take days to find what you want. The data can be organised by using Query’s. In this case I used 105 query’s if I am correct. They can be found under “Query’s”. You are advised to ignore these Query’s as well. They bring order to the Table, but are themselves an unorganised mess. To organise the Query’s, I used Groups. You can find them in the column to the left. I created a Group overview. This one includes the Query’s to see all your skills (capped and uncapped), and all your skills per chapter (capped and uncapped). Underneath that is a group for each profession. These groups include query’s to see all the skills of a profession (capped and uncapped) and all skills per chapter (capped and uncapped). This is the easiest way to use the DB.

Now that you know how to get information out of it, I’ll explain what categories I used in this DB. There are 10 columns, which include the following:

1. A yes/no box
2. The name of the elite skill
3. The profession who uses the elite skill
4. The chapter where the elite skill can be found
5. The boss who uses the skill
6. The area where the boss can be found
7. The boss who uses the skill (#2)
8. The area where the boss can be found (#3)
9. The boss who uses the skill (#3)
10. The area where the boss can be found (#3)

With the yes/no box you can indicate whether or not you capped the elite. The importance of the name, profession and chapter categories should be clear in my opinion. The boss (x3) consists of a link. This link redirects you to the Guildwiki page about the boss. This gives you a quick look at where the boss is exactly in his area. The area is just to make the DB look complete. If the boss hangs around in a mission, the name of the area is followed by “(mission)”. If the area is an explorable area of a mission (for example Boreas Seabed) it just says the name of the area (Boreas Seabed in this example).

The principle of the DB is quite easy. Once you cap a skill, check the box belonging to the skill and you are set. Because all the data is in one table, making a check in one query (for example: All Uncapped Ranger Tyrian Elite Skills) makes a check in all the query’s that are effected (in this case: All Uncapped Ranger Elite Skills, All Uncapped Tyrian Elite Skills and all Uncapped Elite Skills). This gives it a huge boost over for example Word or Excel because you can have different search results AND at the same time use only one set of data.

So in conclusion, here is a database to aid you in organising your skill capping exploits. Have fun with it, and good luck! Gotta cap them all!! (Apologies for the bad pun

)

Estic

Graywing · Dec 02, 2006, 09:51 PM // 21:51

As I allready said: very usefull

, now I actually know how many elites I still have to capture (

way too much...)

fotovince · Dec 03, 2006, 11:49 AM // 11:49

if you can set it to mysql you can use it for youre websites.

wolkje · Dec 08, 2006, 12:55 PM // 12:55

This will come in handy for my capping quests

oregonclarks · Feb 14, 2007, 01:38 AM // 01:38

This will be the most usful tool I have seen yet, That is as soon as I can figure out how to togle the yes/no box.

Emik · Feb 14, 2007, 05:34 AM // 05:34

Euhm just click the check box?

TheRaven · Feb 14, 2007, 08:46 PM // 20:46

What version of access did you use? All I have is Access 97 and I can't open it. I get "unrecognized database format".

Levi Garett · May 04, 2007, 09:33 PM // 21:33

Bumping this for the elite skill weekend. I just quickly looked at it and it looks like exactly what I need, and the links to wiki for all the bosses is going to save a ton of time.

Thank you very much!

bodyboarder · May 05, 2007, 06:01 AM // 06:01

How do you actually check a box????

Levi Garett · May 07, 2007, 01:42 AM // 01:42

Make sure the file is not read only.

I imported this into Access 2007 and have had zero problems thus far.

Exactly what I was looking for!

Free Wind · May 07, 2007, 09:30 AM // 09:30

Very, very much appreciate it!
This is exactly what I needed but was too lazy to compile the list myself
Now I can just export it into Excel and sort/filter/search in any way I can think of

bodyboarder · May 07, 2007, 09:56 AM // 09:56

how can u make it not read only?

All good found out how to make it work