Znote ACC Create account add 3500 rank on new player

[cocacola13]

hello, I need help from Znote ACC to add range 3500 automatically when creating characters.

 

[Evil Puncker]

isn't it better to do it on login?
something like this:

function onLogin(player)
    local loginStr = "Welcome to " .. configManager.getString(configKeys.SERVER_NAME) .. "!"
    if player:getLastLoginSaved() <= 0 then
        loginStr = loginStr .. " Please choose your outfit."
        player:sendOutfitWindow()
        db.query("UPDATE `player` SET `rank` = 3500 WHERE `id` = " .. (player:getId()))
    else
    -- rest of onLoginscript

 

[cocacola13]

hmm possible, just please direct me where should I add it to login.lua?

Post automatically merged: Apr 30, 2020

I added it to login.lua but it doesn't add rank

Post automatically merged: Apr 30, 2020

stupid question but, other script engine was altering my engine and something is wrong even if I delete the whole login. how is it possible

Post automatically merged: Apr 30, 2020

however I need a script or how to convert znote acc because the server has been converted so that it does not use login.lua

 

[Rombadr]

Set default to 3500 in that field for that table in the database

ALTER TABLE table_name ALTER COLUMN rank SET DEFAULT 3500;

And if you want to update ALL current players that have rank = 0 to 3500

 UPDATE table_name SET rank = 3500 WHERE rank = 0

Change table_name to the name of the table obviously.

 

[cocacola13]

Set default to 3500 in that field for that table in the database

ALTER TABLE table_name ALTER COLUMN rank SET DEFAULT 3500;

And if you want to update ALL current players that have rank = 0 to 3500

 UPDATE table_name SET rank = 3500 WHERE rank = 0

Change table_name to the name of the table obviously.

thank you worked,
and tell me, can you make a script to give a player like red skull between x and y rankings? the skull itself without anything