[DiscordArchive] with a lot of help from <@490003662882603030> I have found something interesting with the talent po
[DiscordArchive] with a lot of help from <@490003662882603030> I have found something interesting with the talent po
Original source
with a lot of help from <@490003662882603030> I have found something interesting with the talent point issue I was having earlier in this thread (right above, actually)
Ill try to explain this cause it makes NO sense how or why...
```-- "Working, but not"
PLAYER_EVENT_ON_COMPLETE_QUEST = 54
function onTurnIn(event, player, quest)
local questID = quest:GetId()
local PUID = player:GetGUIDLow()
if questID == 41547 then
CharDBExecute(string.format("UPDATE characters SET totalTalentPoints = totalTalentPoints + 1 WHERE guid = %i", PUID))
CharDBExecute(string.format("UPDATE characters SET extraBonusTalentCount = COALESCE(extraBonusTalentCount, 0) + 1 WHERE guid = %i", PUID))
end
end
RegisterPlayerEvent(PLAYER_EVENT_ON_COMPLETE_QUEST, onTurnIn)```
The above code crashes the server, and I understand WHY... there is no 'totalTalentPoints' in the characters DB, but when it crashes it ACTUALLY properly awards and saves the Bonus Talent Point for use when the Server is rebooted. Every time.
NOW, Remove the line of code that causes the server crash:
```-- "Not Working..."
PLAYER_EVENT_ON_COMPLETE_QUEST = 54
function onTurnIn(event, player, quest)
local questID = quest:GetId()
local PUID = player:GetGUIDLow()
if questID == 41547 then
CharDBExecute(string.format("UPDATE characters SET extraBonusTalentCount = COALESCE(extraBonusTalentCount, 0) + 1 WHERE guid = %i", PUID))
end
end
RegisterPlayerEvent(PLAYER_EVENT_ON_COMPLETE_QUEST, onTurnIn)```
And suddenly its not crashing the server, but it is giving the Talent Point and then the Talent Point is gone when the character logs out/in.
Why does removing the faulty code make it stop saving as expected?
rektbyfaith
08-08-2025, 06:39 PM #1Archived author: Ahuramazda • Posted: 2025-08-08T18:39:41.019000+00:00
Original source
with a lot of help from <@490003662882603030> I have found something interesting with the talent point issue I was having earlier in this thread (right above, actually)
Ill try to explain this cause it makes NO sense how or why...
```-- "Working, but not"
PLAYER_EVENT_ON_COMPLETE_QUEST = 54
function onTurnIn(event, player, quest)
local questID = quest:GetId()
local PUID = player:GetGUIDLow()
if questID == 41547 then
CharDBExecute(string.format("UPDATE characters SET totalTalentPoints = totalTalentPoints + 1 WHERE guid = %i", PUID))
CharDBExecute(string.format("UPDATE characters SET extraBonusTalentCount = COALESCE(extraBonusTalentCount, 0) + 1 WHERE guid = %i", PUID))
end
end
RegisterPlayerEvent(PLAYER_EVENT_ON_COMPLETE_QUEST, onTurnIn)```
The above code crashes the server, and I understand WHY... there is no 'totalTalentPoints' in the characters DB, but when it crashes it ACTUALLY properly awards and saves the Bonus Talent Point for use when the Server is rebooted. Every time.
NOW, Remove the line of code that causes the server crash:
```-- "Not Working..."
PLAYER_EVENT_ON_COMPLETE_QUEST = 54
function onTurnIn(event, player, quest)
local questID = quest:GetId()
local PUID = player:GetGUIDLow()
if questID == 41547 then
CharDBExecute(string.format("UPDATE characters SET extraBonusTalentCount = COALESCE(extraBonusTalentCount, 0) + 1 WHERE guid = %i", PUID))
end
end
RegisterPlayerEvent(PLAYER_EVENT_ON_COMPLETE_QUEST, onTurnIn)```
And suddenly its not crashing the server, but it is giving the Talent Point and then the Talent Point is gone when the character logs out/in.
Why does removing the faulty code make it stop saving as expected?
Original source
It's not realted to Docker, it's that the Docker installation can't find the playerbot SQL scripts. Eluna has no database interaction during compile nor during startup
rektbyfaith
08-08-2025, 09:03 PM #2Archived author: metallinos • Posted: 2025-08-08T21:03:51.780000+00:00
Original source
It's not realted to Docker, it's that the Docker installation can't find the playerbot SQL scripts. Eluna has no database interaction during compile nor during startup
Original source
Just run the SQLs manually
rektbyfaith
08-08-2025, 09:03 PM #3Archived author: metallinos • Posted: 2025-08-08T21:03:55.918000+00:00
Original source
Just run the SQLs manually
1 Guest(s)
1 Guest(s)