@ -70,49 +70,16 @@ end
----------------------------------------------------------------------------
----------------------------------------------------------------------------

-- function getNumberPhone(charid)
--     print("charid"..charid)
--     local result = MySQL.Sync.fetchAll("SELECT `phonenumber` FROM `characters` WHERE `id` = @char_id", {
--         -- ['@char_id'] = charid
--         ['@char_id'] = "2"
--     })
--     print("result"..result)
--     if result[1] ~= nil then
--         return result[1].phonenumber
--     end
--     return nil
-- end

function getNumberPhone(charid)
    print("charid"..charid)
    -- local result = MySQL.Sync.execute("SELECT rank FROM users WHERE name = @user", {['@user'] = 'Walrus'})
    MySQL.Async.fetchAll("SELECT rank FROM users WHERE name = 'Walrus' ", {}, function (result)
        print(#result)
    end)
    print("result"..result)
    if result[1] ~= nil then
        return result[1].phonenumber
    end
    return nil
end

-- function getNumberPhone(charid, callback)
--     print("charid: "..charid)
--     exports["externalsql"]:DBAsyncQuery({
--         -- string = "SELECT `phonenumber FROM `characters` WHERE `id` = :char_id",
--         -- string = "SELECT * FROM `characters` WHERE `playerid` = :char_id",
--         string = "SELECT `rank` FROM `users` WHERE `name` = :user",
--         data = {
--             user = "Walrus"
--         }
--     }, function(results)
--         print(results)
--         for k, v in ipairs(results) do
--             print("v: "..v)
--         end
--         callback(results)
--     end)
-- end
 function getNumberPhone(charid)
     local result = MySQL.Sync.fetchAll("SELECT `phonenumber` FROM `characters` WHERE `id` = @char_id", {
         ['@char_id'] = charid
     })
     print(result[1].phonenumber)
     if result[1] ~= nil then
         return result[1].phonenumber
     end
     return nil
 end

function getApp(name, callback)
    exports["externalsql"]:DBAsyncQuery({