Duplicated name Quest VIP

02/03/2018 19:09 ByLost#1
Code:
quest vip begin
    state start begin
        when 40003.use begin
            if pc.count_item(40003)>=1 then
                say_title("Inel [VIP]")
                say("Vrei sa ai VIP in fata numelui")
                local a = select("Da!", "Nu")
                if a == 1 then
                    local name = pc.get_name()
                    local find_id = mysql_query("SELECT account_id from player.player WHERE name='"..name.."' LIMIT 1;")
                    local id = find_id[1][1]+1-1
                    mysql_query("UPDATE player.player SET name='[VIP]"..name.."' WHERE account_id='"..id.."' LIMIT 1;")
                    pc.remove_item(40003)
                    syschat("Votre demande à été envoyé au serveur. Votre")
                    syschat("changera dès que le serveur aura retourné l'information!")
                else
                    return
                end
            else
                say_title("Inel [VIP]")
                say("Aveti Nevoie de")
                say("Inelul VIP pentru a activa numele:")
                say_item_vnum(40003)
                say("Intoarcete cand ai.")
                return
            end
        end
    end
end
[Only registered and activated users can see links. Click Here To Register...]
02/04/2018 02:42 Nick#2
[Only registered and activated users can see links. Click Here To Register...] thread is about issues relating to quests.

#closed