[DiscordArchive] where is the stat selectet ?
[DiscordArchive] where is the stat selectet ?
Original source
i figure it out but its not this
rektbyfaith
02-11-2024, 08:19 PM #11Archived author: ᴋɪʟʟꜱᴇᴛ • Posted: 2024-02-11T20:19:45.878000+00:00
Original source
i figure it out but its not this
Original source
oh wait
rektbyfaith
02-11-2024, 08:20 PM #12Archived author: Rymercyble • Posted: 2024-02-11T20:20:17.112000+00:00
Original source
oh wait
Original source
was actually the misc value
rektbyfaith
02-11-2024, 08:20 PM #13Archived author: ᴋɪʟʟꜱᴇᴛ • Posted: 2024-02-11T20:20:20.297000+00:00
Original source
was actually the misc value
Original source
misc value then
rektbyfaith
02-11-2024, 08:20 PM #14Archived author: Rymercyble • Posted: 2024-02-11T20:20:27.563000+00:00
Original source
misc value then
Original source
I think i found the error, one of mine lua scripts have active in spell table
rektbyfaith
02-11-2024, 08:55 PM #15Archived author: cyberpro98 • Posted: 2024-02-11T20:55:47.041000+00:00
Original source
I think i found the error, one of mine lua scripts have active in spell table
Original source
![[Image: IMG_1191.png?ex=690c62a5&is=690b1125&hm=...a400a494c&]](https://cdn.discordapp.com/attachments/284406375495368704/1206342921540997130/IMG_1191.png?ex=690c62a5&is=690b1125&hm=d454f1e1d3f11fefd122f9e60583dceb953835fcceae4cc60110ecaa400a494c&)
![[Image: IMG_1192.png?ex=690c62a5&is=690b1125&hm=...207bf77e2&]](https://cdn.discordapp.com/attachments/284406375495368704/1206342921981394974/IMG_1192.png?ex=690c62a5&is=690b1125&hm=e280481b9f167c081b05611577feaecbc8d3b8625a6d7973d044f74207bf77e2&)
rektbyfaith
02-11-2024, 08:56 PM #16Archived author: cyberpro98 • Posted: 2024-02-11T20:56:05.423000+00:00
Original source
Original source
function Vip.setVipAllCharAccount(event, selectTarget)
--Give VIP to all characters on account if they have the item or spell
local account = selectTarget:GetAccountId()
local hasSpellQuery = CharDBQuery(
"SELECT characters.guid FROM characters JOIN character_spell ON characters.guid = character_spell.guid WHERE characters.account = " ..
account .. " AND character_spell.spell = " .. Vip.SpellId)
if (hasSpellQuery) then
-- account has spell, add it to new character
local guid = selectTarget:GetGUIDLow()
local hasSpellQuery2 = CharDBQuery("SELECT 1 FROM character_spell WHERE guid = " ..
guid .. " AND spell = " .. Vip.SpellId)
if (not hasSpellQuery2) then
CharDBExecute("INSERT INTO character_spell (guid, spell, active, disabled) VALUES (" ..
guid .. ", " .. Vip.SpellId .. ", 1, 0)")
end
end
end
rektbyfaith
02-11-2024, 08:57 PM #17Archived author: cyberpro98 • Posted: 2024-02-11T20:57:18.195000+00:00
Original source
function Vip.setVipAllCharAccount(event, selectTarget)
--Give VIP to all characters on account if they have the item or spell
local account = selectTarget:GetAccountId()
local hasSpellQuery = CharDBQuery(
"SELECT characters.guid FROM characters JOIN character_spell ON characters.guid = character_spell.guid WHERE characters.account = " ..
account .. " AND character_spell.spell = " .. Vip.SpellId)
if (hasSpellQuery) then
-- account has spell, add it to new character
local guid = selectTarget:GetGUIDLow()
local hasSpellQuery2 = CharDBQuery("SELECT 1 FROM character_spell WHERE guid = " ..
guid .. " AND spell = " .. Vip.SpellId)
if (not hasSpellQuery2) then
CharDBExecute("INSERT INTO character_spell (guid, spell, active, disabled) VALUES (" ..
guid .. ", " .. Vip.SpellId .. ", 1, 0)")
end
end
end
Original source
<@376752492656066562> Excellent. There is the cause.
rektbyfaith
02-11-2024, 08:58 PM #18Archived author: stevej • Posted: 2024-02-11T20:58:40.970000+00:00
Original source
<@376752492656066562> Excellent. There is the cause.
Original source
Because i remember myself i used more times command #vip update and the command updates all characters on acc
rektbyfaith
02-11-2024, 08:59 PM #19Archived author: cyberpro98 • Posted: 2024-02-11T20:59:33.688000+00:00
Original source
Because i remember myself i used more times command #vip update and the command updates all characters on acc
Original source
I will try it tomorrow oncce more, i will delete active and the ,1 and it should be done xD maybe the script wont work good but then need to be fixed
rektbyfaith
02-11-2024, 09:00 PM #20Archived author: cyberpro98 • Posted: 2024-02-11T21:00:16.747000+00:00
Original source
I will try it tomorrow oncce more, i will delete active and the ,1 and it should be done xD maybe the script wont work good but then need to be fixed
1 Guest(s)
1 Guest(s)