• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Gesior ACC 2019 8.60 New Features

Natan Beckman

Active Member
Joined
Aug 1, 2010
Messages
547
Best answers
0
Reaction score
47
Location
Teresina-PI/Br
UPDATE 29/06/2019!
Hello my friends, this is my last free contribution I make in the area of OTserver, I made a very complete update of the Gesior comparing with the available ones.

- Some layout images have been changed to refresh the look.
37397

- Create Account requiring passwords with lowercase letters, capital letters and numbers, strengthening the security of your client and making future headaches difficult.
37398

- Characters.php redone, in this image is a view of an account with access admin.
37399

- New SHOP with improved and modernized layout structure.
37400

Other images:
Screenshot (https://prnt.sc/o8hpz0)
Screenshot (https://prnt.sc/o8hpj4)
Screenshot (https://prnt.sc/o8hpp2)
Screenshot (https://prnt.sc/o8hpu2)
Screenshot (https://prnt.sc/o8hq2q)

Screenshot (https://prnt.sc/o8hq73)
Screenshot (https://prnt.sc/o8hqli)
Screenshot (https://prnt.sc/o8hqor)

globalevents/shop.lua:

Lua:
local SHOP_MSG_TYPE = MESSAGE_EVENT_ORANGE
local SQL_interval = 30
--- ### Outfits List ###
local femaleOutfits = {
    ["citizen"]={136},
    ["hunter"]={137},
    ["mage"]={138},
    ["knight"]={139},
    ["noblewoman"]={140},
    ["summoner"]={141},
    ["warrior"]={142},
    ["barbarian"]={147},
    ["druid"]={148},
    ["wizard"]={149},
    ["oriental"]={150},
    ["pirate"]={155},
    ["assassin"]={156},
    ["beggar"]={157},
    ["shaman"]={158},
    ["norsewoman"]={252},
    ["nightmare"]={269},
    ["jester"]={270},
    ["brotherhood"]={279},
    ["demonhunter"]={288},
    ["yalaharian"]={324},
    ["warmaster"]={336},
    ["wayfarer"]={366},
    ["afflicted"]={431},
    ["elementalist"]={433},
    ["deepling"]={464},
    ["insectoid"]={466},
    ["red baron"]={471},
    ["crystal warlord"]={513},
    ["soil guardian"]={514},
    ["demon"]={542}
}
local maleOutfits = {
    ["citizen"]={128},
    ["hunter"]={129},
    ["mage"]={130},
    ["knight"]={131},
    ["noblewoman"]={132},
    ["summoner"]={133},
    ["warrior"]={134},
    ["barbarian"]={143},
    ["druid"]={144},
    ["wizard"]={145},
    ["oriental"]={146},
    ["pirate"]={151},
    ["assassin"]={152},
    ["beggar"]={153},
    ["shaman"]={154},
    ["norsewoman"]={251},
    ["nightmare"]={268},
    ["jester"]={273},
    ["brotherhood"]={278},
    ["demonhunter"]={289},
    ["yalaharian"]={325},
    ["warmaster"]={335},
    ["wayfarer"]={367},
    ["afflicted"]={430},
    ["elementalist"]={432},
    ["deepling"]={463},
    ["insectoid"]={465},
    ["red baron"]={472},
    ["crystal warlord"]={512},
    ["soil guardian"]={516},
    ["demon"]={541}
}

function onThink(interval, lastExecution)
    local result_plr = db.getResult("SELECT * FROM z_ots_comunication")
    if(result_plr:getID() ~= -1) then
        while(true) do
        
            id = tonumber(result_plr:getDataInt("id"))
            local action = tostring(result_plr:getDataString("action"))
            local delete = tonumber(result_plr:getDataInt("delete_it"))
            local cid = getPlayerByName(tostring(result_plr:getDataString("name")))
            
            if isPlayer(cid) then
            
                local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
                local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
                local outfit_name = string.lower(tostring(result_plr:getDataString("param3")))
                local itemvip = tonumber(result_plr:getDataInt("param4"))
                local add_item_type = tostring(result_plr:getDataString("param5"))
                local add_item_name = tostring(result_plr:getDataString("param6"))
                local points = tonumber(result_plr:getDataInt("param7"))
                local received_item = 0
                local full_weight = 0
                
                if(action == 'give_item') then
                    full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    if isItemRune(itemtogive_id) == TRUE then
                        full_weight = getItemWeightById(itemtogive_id, 1)
                    else
                        full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    end
                    
                    local free_cap = getPlayerFreeCap(cid)

                    local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
                    
                    if full_weight <= free_cap then
                        received_item = doPlayerAddItemEx(cid, new_item)
                        if received_item == RETURNVALUE_NOERROR then
                            doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << RELOGUE PARA SALVAR URGENTE.')
                            db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                                db.query("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
                        else
                            doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about '.. SQL_interval ..' seconds to get it.')
                        end
                    else
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot and wait about '.. SQL_interval ..' seconds to get it.')
                    end
                end
                
                if(action == 'give_outfit') then
                    if outfit_name ~= "" and maleOutfits[outfit_name] and femaleOutfits[outfit_name] then
                        local add_outfit = getPlayerSex(cid) == 0 and femaleOutfits[outfit_name][1] or maleOutfits[outfit_name][1]
                        if not canPlayerWearOutfit(cid, add_outfit, 3) then
                            db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                            doSendMagicEffect(getCreaturePosition(cid), CONST_ME_GIFT_WRAPS)
                            doPlayerAddOutfit(cid, add_outfit, 3)
                            doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, "You received the outfit " .. add_item_name .. " of our Shop Online.")
                        else
                            doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, "You already have this outfit. Your points were returned, thank you.")
                            db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                            db.query("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
                        end
                    end
                end
                
            end
            if not(result_plr:next()) then
                break
            end
        end
        result_plr:free()
    end
    
    return true
end
 

Attachments

cabrera2608

New Member
Joined
Dec 21, 2018
Messages
109
Best answers
0
Reaction score
3
there is an error, it will not let me create an account
use ubuntu 14.0437492
 

soom13

New Member
Joined
May 28, 2016
Messages
15
Best answers
0
Reaction score
2
i got a problem loading the localhost site

37695
how do i fix it if i can get help or require something to show me with you can add my discord
Nanichan20 is broken#7422
 

soom13

New Member
Joined
May 28, 2016
Messages
15
Best answers
0
Reaction score
2
what TFS are you using?
wait what tfs is this gesior for, cause it didn't say, and i use the Cryingdamson files( i think they use 8.2 or something
it says v8.2 so i am guessing it is 8.2 TFS??, actually new to this but i've been trying for like almost a year now on trying to get it to work
and if i need a specific TFS, is there a chance you you or anyone could send T~T, trying my best to do this on my own.
 
Last edited:

Evil Puncker

its just a flu
TFS Developer
Joined
May 30, 2009
Messages
6,678
Best answers
85
Reaction score
2,345
wait what tfs is this gesior for, cause it didn't say, and i use the Cryingdamson files( i think they use 8.2 or something
it says v8.2 so i am guessing it is 8.2 TFS??, actually new to this but i've been trying for like almost a year now on trying to get it to work
and if i need a specific TFS, is there a chance you you or anyone could send T~T, trying my best to do this on my own.
try this one
 

soom13

New Member
Joined
May 28, 2016
Messages
15
Best answers
0
Reaction score
2
try this one
Just incase i like don't get this Server version is there a chance you could like help, sorry for asking to much, although i want to try to do it myself, i feel like i would just mess it up
 

Evil Puncker

its just a flu
TFS Developer
Joined
May 30, 2009
Messages
6,678
Best answers
85
Reaction score
2,345
yes you need, since the sql from the server that I told you to download is different from the old one you were using
 

soom13

New Member
Joined
May 28, 2016
Messages
15
Best answers
0
Reaction score
2
yes you need, since the sql from the server that I told you to download is different from the old one you were using
i did download the file you send me but that's the error i get when i upload the database and move the gesior file into xampp and try to make an account
ofcourse i change some settings in the eula thingy
 

soom13

New Member
Joined
May 28, 2016
Messages
15
Best answers
0
Reaction score
2
then only @Natan Beckman can help you :(
well i mean i might be doing something wrong you might want to add me on somewhere i can show you how i do it, if you want

[edited]
yeah i think i might need help from Natan Beckman, cause it said the same error after re-installing everything T~T, but i do appricate your help cause it did help me the only thing that isn't working is the website when i want to create an account, and btw when i set up the local host thing it say some things already existed

so not sure if that is the problem

database and everything works fine it says i have an account but i think it's the gesior that is having some bug or something

(ofcourse that would be the sample account, since i can't create an account with the createaccount thing error)

btw @Evil Puncker do you have a server running i might come and join you on the server
 
Last edited:

Evil Puncker

its just a flu
TFS Developer
Joined
May 30, 2009
Messages
6,678
Best answers
85
Reaction score
2,345
well i mean i might be doing something wrong you might want to add me on somewhere i can show you how i do it, if you want

[edited]
yeah i think i might need help from Natan Beckman, cause it said the same error after re-installing everything T~T, but i do appricate your help cause it did help me the only thing that isn't working is the website when i want to create an account, and btw when i set up the local host thing it say some things already existed

so not sure if that is the problem

database and everything works fine it says i have an account but i think it's the gesior that is having some bug or something

(ofcourse that would be the sample account, since i can't create an account with the createaccount thing error)

btw @Evil Puncker do you have a server running i might come and join you on the server
actually I dont have a server, and maybe you should try another AAC site, like znote AAC or my-AAC and see if the problem is really gesior
 

soom13

New Member
Joined
May 28, 2016
Messages
15
Best answers
0
Reaction score
2
actually I dont have a server, and maybe you should try another AAC site, like znote AAC or my-AAC and see if the problem is really gesior
sure i can try that, how do i do it xD, send the link and stuff and i'll try it out

just incase add me on discord Nanichan20#7422,if you don't have a mic no worries just need a guider
 
Top