SQL Version

Quick and easy way to see what recipes your character is missing

Moderators: zeryl, Teta68

SQL Version

Postby sendrome » Thu Mar 15, 2007 3:12 am

Hello everyone,
I have made a version of the addon that uses a local database to do the queries on. This version supports BC as of version 2.8 and it is fairly easy to install just extract to your addons folder and import the sql file into your database. There is a read me included that should help explain how to install the sql file. This is a beta 1 release so let me know if you have any questions or problems. If you want to see it in action you can see it on our guild website
Fools of Chaos
Image
Attachments
missingrecipe.zip
beta 1
(115.48 KiB) Downloaded 146 times
Last edited by sendrome on Sat Apr 07, 2007 6:24 am, edited 1 time in total.
sendrome
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Dec 21, 2006 2:36 pm

SQL Version

Postby nogarth » Thu Apr 05, 2007 1:45 am

can we have an updated SQL to update the database as theres no JC in there
nogarth
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Tue Jul 04, 2006 10:46 pm

Re: SQL Version

Postby sendrome » Sat Apr 07, 2007 6:16 am

i have fixed a few bugs mainly with jewelcrafting and first aid not showing up correctly so please update to this version (beta 2). I also added my dbmaker.php script which will extract the data from the websites and turn it into a csv so you can load it into you database. I plan on making this an admin feature in the future so that you can just update your database.
Attachments
missingrecipe.zip
beta 2
(70.47 KiB) Downloaded 152 times
sendrome
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Dec 21, 2006 2:36 pm

SQL Version

Postby vbdh » Sat Apr 07, 2007 7:02 am

ok i cant get into my sql folder and i removed my old copy of missingrecipe can someone add a link to the one before this one thanks :)
Last edited by vbdh on Sat Apr 07, 2007 7:07 am, edited 1 time in total.
Long Live The Fighters
User avatar
vbdh
WR.net Apprentice
WR.net Apprentice
 
Posts: 45
Joined: Wed Jan 03, 2007 12:48 pm

Re: SQL Version

Postby sendrome » Tue Apr 10, 2007 1:52 am

IF you are looking for the previous version of the addon you can see it at the top of this thread just download it. If you need the current SQL export you can always fetch it from here

http://thedruidwar.com/roster/addons/missingrecipe/sql/
Image
sendrome
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Dec 21, 2006 2:36 pm

SQL Version

Postby vbdh » Tue Apr 10, 2007 2:45 am

nope not working :(
Long Live The Fighters
User avatar
vbdh
WR.net Apprentice
WR.net Apprentice
 
Posts: 45
Joined: Wed Jan 03, 2007 12:48 pm

Re: SQL Version

Postby sendrome » Wed Apr 11, 2007 3:45 am

what exactly is not working? and what error are you getting?

was the beta1 sql version working for you?
Image
sendrome
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Dec 21, 2006 2:36 pm

SQL Version

Postby vbdh » Wed Apr 11, 2007 4:54 am

im trying to find the norm version not the sql one but i cant find a link to it
Long Live The Fighters
User avatar
vbdh
WR.net Apprentice
WR.net Apprentice
 
Posts: 45
Joined: Wed Jan 03, 2007 12:48 pm

Re: SQL Version

Postby sendrome » Fri Apr 13, 2007 8:50 pm

You access all addon downloads from the "download" link at the top. Here is the link for this addon

Download just click on download now to find a mirror.
Image
sendrome
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Dec 21, 2006 2:36 pm

Re: SQL Version

Postby Stigg » Mon Apr 16, 2007 12:33 am

I like the way this seems to work.
Going to give it a shot, thanks for the work you've done on it :)
Stigg
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Thu Mar 22, 2007 7:55 am

Re: SQL Version

Postby rrhode » Mon Apr 23, 2007 9:06 am

:cyclops: Do you have a copy of this I could test out? OR can someone please upload an updated version? PLEASE!!!! I can't get it to work properly.

For example... One of the leatherworkers are saying all it is showing is patterns they already know and not the missing ones. But I know for sure that before it showed the missing ones for the characters I tested.

Also, are the item icons not supposed to hover an item stats link?

If anyone can or has done this please post here.
rrhode
WR.net Apprentice
WR.net Apprentice
 
Posts: 22
Joined: Wed Dec 13, 2006 6:36 pm

SQL Version

Postby Nahojrog » Sun May 13, 2007 8:27 pm

Sendrome,

I was hoping to get this to work sice the allow_url_fopen was prohibiting me from getting the data from the outside servers.

I imported the sql file in my roster database, was that ok? Or did i need to create a new database?

The thing i get now when choosing my character and profession is a white page with the same dropdown menus (profession and character), but no output is generated.

Maybe you can have a look at: The Hooligans

Thnx in advance :mrgreen:
Greetz,

Nahojrog
User avatar
Nahojrog
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat May 12, 2007 9:04 pm


Return to Missing Recipes

Who is online

Users browsing this forum: No registered users and 0 guests

cron