[SOLVED] fiddling around with phases and quests

[Nalo]

Good afternoon Emudev'ens

as title teases im fiddling around with phases

So here's my Question :

* is it possible for a SQL query to make a quest change a players phase upon accepting and then back upon completion

* is it possible for a C++ script to work better than a SQL query ?


Please assist only if you can
:scared:
Kind
regards
Nalo

 

[Tommy]

Good afternoon Emudev'ens

as title teases im fiddling around with phases

So here's my Question :

* is it possible for a SQL query to make a quest change a players phase upon accepting and then back upon completion

* is it possible for a C++ script to work better than a SQL query ?


Please assist only if you can
:scared:
Kind
regards
Nalo

1. Yes
2. What do you mean by that?

 

[Nalo]

is there a way you can give me an example of SQL set query tommy?

 

[Tommy]

is there a way you can give me an example of SQL set query tommy?

SET query? Are you referring to an UPDATE query?

I'll give you an example of an UPDATE execution and a SELECT query.

UPDATE:

    std::string newName = "Testing";
    QueryResult result = WorldDatabase.PExecute("UPDATE creature_template SET `name`='%s' WHERE entry='%u'", newName.c_str(), creature->GetEntry());

SELECT:

    QueryResult result = WorldDatabase.PQuery("SELECT modelid1, modelid2 FROM creature_template WHERE entry='%u'", creature->GetEntry());
    if (!result)
    {
        TC_LOG_ERROR("misc", "Failed!");
        return;
    }

    do
    {
        Field* fields = result->Fetch();

        ChatHandler(player->GetSession()).PSendSysMessage("Modelid1: %u, Modelid2: %u", fields[0].GetUInt32(), fields[1].GetUInt32());
    }while(result->NextRow());

 

[Nalo]

sorry its the way i chat i guess.

thank you il try it asap <3