Download:
Xampp http://www.apachefriends.org/en/xampp.html
7zip http://www.7-zip.org/download.html
The mysql static data dump http://forums.eveonline.com/default.aspx?g=posts&t=61544
YaPeal http://code.google.com/p/yapeal/
Files mentioned here: https://www.fuzzwork.co.uk/resources/xamppsetup.zip


Install xampp. Just follow the defaults.

edit c:\xampp\php\php.ini, to take off the ; before extension=php_curl.dll

Start the xampp control panel. From there, start apache and mysql
Start the mysql admin from the control panel. This will start up phpmyadmin

unzip the datadump. You'll need to have installed 7zip to be able to open the file. It's a good package. better than winzip and free.


click on databases, in phpmyadmin
fill in an appropriate name into the create new database box. Something like eve, for example.
click on privileges. 
Click on add a new user

pick a username. Such as eve. 
change the host dropdown to local
pick a password. fill it in twice.
leave 'grant all privileges on database (the name you selected)' set
hit go

Click on databases again. enter yapeal, hit create

click on localhost, up at the top. 
click on privileges.
select edit privileges on the line with the user eve
scroll down to database specific privileges
select yapeal from the dropdown.
hit go in that box.

use check all for database specific privileges



Start a command prompt.
cd to the directory where you extracted the datadump
c:\xampp\mysql\bin\mysql.exe -u eve -p eve <cru11-mysql-innoDB-v1.sql
Type in the password you selected. This will take a while to complete.
You can close off the command prompt when it finishes.

You now have a local copy of the static data dump. 

Open the yapeal tarball. extract the yapeal directory to c:\xampp\htdocs\yapeal




Follow the instructions in the yapeaINSTALL.md Remember that you've created the database and user. when you need to run php, it's c:\xampp\php\php.exe

When creating the database, you may get a Strict Standards error. you can ignore is, as long as you see 'all database tables have been installed'


Now you want to create a php page to add your new api key to the yapeal db. I've provided a copy of a page from the utils. Put it in the yaeal directory (or it won't work). Edit it to add your key and vcode

run it with c:\xampp\php\php.exe c:\xampp\htdocs\yapeal\load.php

Than you need to select the api bits to load. put your key into the load2.php file.

c:\xampp\php\php.exe c:\xampp\htdocs\yapeal\load2.php 


Before you run the command to load data, you may want to remove the default api key. if so, go to the yapeal database in phpmyadmin, then the table accountapikeyinfo. delete the one that's not the key you've added.

Now run 
c:\xampp\php\php.exe c:\xampp\htdocs\yapeal\yapeal.php 


Now you need to add a character to the list to be downloaded. use phpmyadmin to look at the table yapeal.accountcharacters. you want the characterid for your main character. if you want to put in more, just rerun the script. Edit load3.php to add the characterid.


c:\xampp\php\php.exe c:\xampp\htdocs\yapeal\load3.php 

Now you need to turn on the character section for download. run load4.php

c:\xampp\php\php.exe c:\xampp\htdocs\yapeal\load2.php 




That done, run c:\xampp\php\php.exe c:\xampp\htdocs\yapeal\yapeal.php

The character tables should now be populated.


Finally, you need to set up a schedule, to keep on loading the data. 

Start the task scheduler. If you're using windows 7, just hit the start button and type in scheduler. It'll show up in the list at the top. 

Create a task. name it appropriately.
Go to actions.
put c:\xampp\php\php.exe into the program box
fill c:\xampp\htdocs\yapeal\yapeal.php as the argument
put  c:\xampp\htdocs\yapeal\ into the start in box
Hit ok

Go to triggers
Hit new
select 'at log on'
tick 'repeat task every'
Select '30 minutes'
If you don't reboot once a day, select indefinetly in the duration box.


you want to stop mysql, then tick the svc box on the control panel. reboot your machine.

Things should automatically update from now on. Apache won't, but you don't need that for yapeal to work. You may want to set apache up as a service too, so you have phpmyadmin. Alternatively, you may want another DB client. Such as using Excel, with the mysql ODBC client.