Gesior ACC 2019 8.60 New Features

Natan Beckman

Active Member
Joined
Aug 1, 2010
Messages
545
Best answers
0
Reaction score
40
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
75
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

I'd rather kiss a rattlesnake
Joined
May 30, 2009
Messages
5,799
Best answers
26
Reaction score
1,788
Location
160,54,7
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

I'd rather kiss a rattlesnake
Joined
May 30, 2009
Messages
5,799
Best answers
26
Reaction score
1,788
Location
160,54,7
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

I'd rather kiss a rattlesnake
Joined
May 30, 2009
Messages
5,799
Best answers
26
Reaction score
1,788
Location
160,54,7
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