SQL To Export All Bank and Character Items?

Here you can find plenty of help with your general coding needs and projects
If it is about a specific program, use the corresponding forum
DO NOT ask basic questions such as "How do I print a variable", use Google for that

SQL To Export All Bank and Character Items?

Postby Rustyd » Fri Feb 01, 2008 7:04 pm

I have a Druid which needs at least 2 or more complete outfits.
I'm wondering how to go about using an SQL statement to simply list or export all of my Inventory and Bank items so I can see them all side by side for comparison?

So, in essence,
Select * from <what?> WHERE Character="Mine" Sort Asc

I've tried but I simply don't understand all of the tables to make this work.

Thank you in Advance.

Using RC2

Rustyd

EDIT:
This sorta works (now if I could only get the links to Thottbot. I'd be in business!:

SELECT `cms_wowrosterdf_roster_members`.`name` , `cms_wowrosterdf_roster_items` . *
FROM cms_wowrosterdf_roster_members, cms_wowrosterdf_roster_items
WHERE (
`cms_wowrosterdf_roster_members`.`name` = 'MyName'
)
ORDER BY `cms_wowrosterdf_roster_members`.`name` ASC
Last edited by Rustyd on Fri Feb 01, 2008 7:31 pm, edited 1 time in total.
Rustyd
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Sat May 05, 2007 3:50 am

Return to General Code Help

Who is online

Users browsing this forum: Exabot [Bot] and 0 guests

cron