[DiscordArchive] The first SQL queries on that link is that how you do it?
[DiscordArchive] The first SQL queries on that link is that how you do it?
Original source
Problem is I don't know coding at all like that
rektbyfaith
08-05-2023, 09:21 PM #11Archived author: Roddan • Posted: 2023-08-05T21:21:48.898000+00:00
Original source
Problem is I don't know coding at all like that
Original source
that's why we are learning
rektbyfaith
08-05-2023, 09:22 PM #12Archived author: Kitzunu • Posted: 2023-08-05T21:22:50.826000+00:00
Original source
that's why we are learning
Original source
This quest just became tougher and harder then I expected as a first project
rektbyfaith
08-05-2023, 09:24 PM #13Archived author: Roddan • Posted: 2023-08-05T21:24:00.674000+00:00
Original source
This quest just became tougher and harder then I expected as a first project
Original source
<:Okayge:1024706600293892106>
rektbyfaith
08-05-2023, 09:24 PM #14Archived author: Roddan • Posted: 2023-08-05T21:24:04.257000+00:00
Original source
<:Okayge:1024706600293892106>
Original source
well you dont have to move it to db
rektbyfaith
08-05-2023, 09:25 PM #15Archived author: Kitzunu • Posted: 2023-08-05T21:25:51.340000+00:00
Original source
well you dont have to move it to db
Original source
you could just add the indisposed ii spell
rektbyfaith
08-05-2023, 09:26 PM #16Archived author: Kitzunu • Posted: 2023-08-05T21:26:14.525000+00:00
Original source
you could just add the indisposed ii spell
Original source
```diff
diff --git a/src/server/scripts/World/go_scripts.cpp b/src/server/scripts/World/go_scripts.cpp
index ac53001b3..453a25c72 100644
--- a/src/server/scripts/World/go_scripts.cpp
+++ b/src/server/scripts/World/go_scripts.cpp
@@ -1621,6 +1621,7 @@ enum AmberpineOuthouse
NPC_OUTHOUSE_BUNNY = 27326,
QUEST_DOING_YOUR_DUTY = 12227,
SPELL_INDISPOSED = 53017,
+ SPELL_INDISPOSED_II = 48324,
SPELL_INDISPOSED_III = 48341,
SPELL_CREATE_AMBERSEEDS = 48330,
GOSSIP_OUTHOUSE_INUSE = 12775,
@@ -1656,6 +1657,7 @@ public:
if (target)
{
target->AI()->SetData(1, player->getGender());
+ go->CastSpell(target, SPELL_INDISPOSED_II);
go->CastSpell(target, SPELL_INDISPOSED_III);
}
go->CastSpell(player, SPELL_INDISPOSED);
```
Qualified guess would be this
rektbyfaith
08-05-2023, 09:26 PM #17Archived author: Kitzunu • Posted: 2023-08-05T21:26:24.211000+00:00
Original source
```diff
diff --git a/src/server/scripts/World/go_scripts.cpp b/src/server/scripts/World/go_scripts.cpp
index ac53001b3..453a25c72 100644
--- a/src/server/scripts/World/go_scripts.cpp
+++ b/src/server/scripts/World/go_scripts.cpp
@@ -1621,6 +1621,7 @@ enum AmberpineOuthouse
NPC_OUTHOUSE_BUNNY = 27326,
QUEST_DOING_YOUR_DUTY = 12227,
SPELL_INDISPOSED = 53017,
+ SPELL_INDISPOSED_II = 48324,
SPELL_INDISPOSED_III = 48341,
SPELL_CREATE_AMBERSEEDS = 48330,
GOSSIP_OUTHOUSE_INUSE = 12775,
@@ -1656,6 +1657,7 @@ public:
if (target)
{
target->AI()->SetData(1, player->getGender());
+ go->CastSpell(target, SPELL_INDISPOSED_II);
go->CastSpell(target, SPELL_INDISPOSED_III);
}
go->CastSpell(player, SPELL_INDISPOSED);
```
Qualified guess would be this
Original source
This spell that is added ``Indisposed (53017)`` is noticeable if the quest works or not and it doesn't use this spell even tho it's added
rektbyfaith
08-05-2023, 09:27 PM #18Archived author: Roddan • Posted: 2023-08-05T21:27:24.034000+00:00
Original source
This spell that is added ``Indisposed (53017)`` is noticeable if the quest works or not and it doesn't use this spell even tho it's added
Original source
Your character becomes invisible and is given an aura
rektbyfaith
08-05-2023, 09:28 PM #19Archived author: Roddan • Posted: 2023-08-05T21:28:10.209000+00:00
Original source
Your character becomes invisible and is given an aura
1 Guest(s)
1 Guest(s)