Thank you Schlumpf, for that haste response! I never imagined it being quite so straightforward. Something so simple has been holding me back for quite a while. I must admit, I spent time on different days trying to get another piece of the site to work - and in the end it turned out I'd used a "_" somewhere I shouldn't have, and ended up being treated as a wildcard (I think).

Thanks!

/Cuana

Hi,

I'm currently working on a CMS for the Trinity World DB. I'm kind of new to PHP/SQL and am seeking a simple explanation for executing multiple queries at once!

Currently I am able to insert data into the creature_template database using a HTML form. This works fine as there's only one table where data needs to be inputed.

However when it comes to quests - i have no problem entering data into the quest_template table. However in order to link the quest to an NPC (start/finish) it requires the creature_questrelation, and creature_involved relation table.

So I need to take data from one form and the input the data into appropriate tables.


So far I have:

$sql="INSERT INTO creature_template (...)
VALUES (...) ";

$result = mysql_query($sql);

if($result){
header("Location: 1a_success.php#show");
}

else {
(will link error page here)
}

I need something like

$result = mysql_query($sql1, $sql2, sql3) and then have 3 queries than run. If all 3 queries are successful then I need it to redirect to a success page.

Any ideas? Thanks!

Hi,

Is it possible to display NPC models using PHP/SQL (i.e. A Web CMS) - apart from visiting 3rd party websites like wowhead? I'm working on a CMS atm, and I'm considering literally screenshotting every Display ID using some kind of script.

I'm wondering how plausible it would be, to basically:

1) Position camera in WoW, then let script run to morph NPCs to every display ID (1-24,000) every 3/4 seconds

2) Take small screenshots (about 275x200px) every 3 seconds for example

3) Have the screenshots named $id.png (maybe smaller format JPG?) - so the display ID is the name of the file

4) IMG for NPC could be retrieved to using PHP/SQL query + IMG location (same name as variable)


The only issues is the storage might be 2GB - not exactly an ideal solution for a CMS. And anyway, it seems like a very backwards method - hence why I'm asking for advice!

Obviously every NPC model is contained within the MPQs - but how could you go about harvesting them? How does the serverside Display ID link to a model?

NB: The Display ID is the important thing as it would largely be custom NPCs - using many of the models already in WoW. Hence it would be ideal to have a Display ID reference!



Thanks for reading!

/Cuana

United Kingdom

(it's actually Ireland but it's technically part of Britain!)

Dexter
Death Note

Daria
Futurama

Arrested Development
30 Rock

and BBC Horion for documentaries!