TFS 0.X [SQLite] -=[TFS]=- 0.4 8.60 How do I remove [VIP] from characters in the player name

[samuel157]

[SQLite] -=[TFS]=- 0.4 8.60 How do I remove [VIP] from characters in the player name

 

[lursky]

btw. do you really use SQLite?

UPDATE players SET name = TRIM(SUBSTR(name, LENGTH('[Vip]') + 1)) WHERE name LIKE '[Vip]%';

There might be a case that such player already exists (without [Vip]) so you could try with:

UPDATE players p
LEFT JOIN players p2 ON p2.name = TRIM(SUBSTR(p.name, LENGTH('[Vip]') + 1))
SET p.name = TRIM(SUBSTR(p.name, LENGTH('[Vip]') + 1))
WHERE p.name LIKE '[Vip]%' AND p2.name IS NULL;

As for SQLite these kind of queries are not supported try handle such cases manually (duplicates), to get a list of such:

SELECT p2.name
FROM players p
INNER JOIN players p2 ON p2.name = TRIM(SUBSTR(p.name, LENGTH('[Vip]') + 1))
WHERE p.name LIKE '[Vip]%'

 

[samuel157]

@lursky

[19:25:29] Error while executing SQL query on database 'Sam': near "(": syntax error


DATA TYPE VARCHAR

 

[Mateus Robeerto]

just add to login.lua. No need to add a script, just login.lua. It checks if the VIP has finished and automatically removes the player’s ‘VIP’ name.

data/creaturescripts/scripts/login.lua

if isPremium(cid) then


function EddyHavoc(cid)
if isPlayer(cid) then
db.executeQuery("UPDATE `players` SET `name` = '"..string.sub(getCreatureName(cid), 7).."' WHERE `id` = "..getPlayerGUID(cid)..";")
doRemoveCreature(cid)
end
end


if string.find(tostring(getCreatureName(cid)),"[[Vip]]") then
else
local name = getCreatureName(cid)
db.executeQuery("UPDATE `players` SET `name` = '[Vip] "..name.."' WHERE `id` = "..getPlayerGUID(cid)..";")
doRemoveCreature(cid)
end
elseif (not (isPremium)) and string.find(tostring(getCreatureName(cid)),"[[Vip]]") then
addEvent(EddyHavoc, 3*1000, cid)
end

 

[samuel157]

no have one query execute?

 

[Mateus Robeerto]

Just add login.lua and restart the server and power on, test. It will automatically check if the player has no more VIP days and will automatically remove the 'VIP' name from the player. It's that simple.

Post automatically merged: Sep 18, 2023

you don't want to check the premium... I already removed it here... you can test there.

function EddyHavoc(cid)
    if isPlayer(cid) then
        db.executeQuery("UPDATE `players` SET `name` = '" .. string.sub(getCreatureName(cid), 7) .. "' WHERE `id` = " .. getPlayerGUID(cid) .. ";")
        doRemoveCreature(cid)
    end
end

if string.find(tostring(getCreatureName(cid)), "[[Vip]]") then
    local name = getCreatureName(cid)
    db.executeQuery("UPDATE `players` SET `name` = '[Vip] " .. name .. "' WHERE `id` = " .. getPlayerGUID(cid) .. ";")
    doRemoveCreature(cid)
end

 

[samuel157]

It doesn't work Roberto even with query sqlitestudio

 

[Mateus Robeerto]

So, try with what he said, just SQLite, it should work for you...

Quanto ao SQLite, esse tipo de consulta não é suportado, tente lidar com esses casos manualmente (duplicados), para obter uma lista deles:

SELECT p2.name
FROM players p
INNER JOIN players p2 ON p2.name = TRIM(SUBSTR(p.name, LENGTH('[Vip]') + 1))
WHERE p.name LIKE '[Vip]%'

 

[samuel157]

WHAT DO I DO