• 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!

buyskill tfs 0.2.11pl2 client 9.1

marcelao777

marcelao777

New Member
Joined
Sep 9, 2011
Messages
81
Reaction score
0
My script buyskill removes the item the 9971 from bp but not add the skill, i use tfs 0.2.11pl2 mystic spirit client 9.1

my buyskill.lua
function onSay(cid, words, param, channel)
local x = {
item = 9971, -- Item que vai ser removido
quantidade = 1, -- Quantidade vai ser removido
quantidadeskill = 1, -- Quantidade que o player irá comprar
limiteskill = 349 -- Se o limite for 350, faz 350-1(quantidade de skill) = 349
}

local xml = {
item = 9971, -- Item para poder comprar
quantidade = 3, -- Quantidade de item que vai gastar
quantidademl = 1, -- Quantidade que o player irá comprar
limitedeml = 199 -- Se o limite for 200, faz 200-1(quantidade de ml) = 199
}

local pid = getPlayerGUID(cid) -- Não mecha

local id = {
["skillclub"] = 1, -- Não mecha
["skillsword"]= 2, -- Não mecha
["skillaxe"] = 3, -- Não mecha
["skilldistance"] = 4, -- Não mecha
["skillshielding"] = 5 -- Não mecha
}

local voc = {
["skillclub"] = {4, 8, 9, 10}, -- Vocações que irá comprar club
["skillsword"] = {4, 8}, -- Vocações que irá comprar sword
["skillaxe"] = {4, 8}, -- Vocações que irá comprar axe
["skilldistance"] = {3, 7}, -- Vocações que irá comprar distance
["skillshielding"] = {4, 8, 9, 10} -- Vocações que irá comprar shielding
}

local vocml = {1, 2, 11, 5, 6, 12} -- Vocações que irá comprar magic level

local pz = "sim"

if(pz == "sim") and (getTilePzInfo(getCreaturePosition(cid)) == false) then
doPlayerSendCancel(cid, "Você precisa estar em protection zone pra poder comprar.")
return true
end

if (param == '') then
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Como usar: !comprar skillclub.")
return true
end

if (param == 'magiclevel') then
if getPlayerMagLevel(cid) <= xml.limitedeml then
if isInArray(vocml, getPlayerVocation(cid)) == true then
if doPlayerRemoveItem(cid, xml.item, xml.quantidade) then
doRemoveCreature(cid, true)
db.executeQuery("UPDATE `players` SET `maglevel` = `maglevel` + ".. xml.quantidademl .." WHERE `id` = ".. pid .. "")
else
doPlayerSendCancel(cid, "Você não tem 3 Barras de ouro.")
end
else
doPlayerSendCancel(cid, "Voce não pode comprar magic level.")
end
else
doPlayerSendCancel(cid, "Você chegou no limite de magic level.")
end
return true
end

if(id[param:lower()]) then
if(getPlayerSkill(cid, id[param:lower()]) <= x.limiteskill) then
if isInArray(voc[param:lower()], getPlayerVocation(cid)) == true then
if doPlayerRemoveItem(cid, x.item, x.quantidade) then
doRemoveCreature(cid, true)
db.executeQuery("UPDATE `player_skills` SET `value` = `value` + ".. x.quantidadeskill .." WHERE `player_id` = ".. pid .. " and `skillid` = ".. id[param:lower()] ..";")
else
doPlayerSendCancel(cid, "Você não tem 1 Barra de ouro.")
end
else
doPlayerSendCancel(cid, "Voce não pode comprar este skill.")
end
else
doPlayerSendCancel(cid, "Você chegou no limite de skill.")
end
else
doPlayerSendCancel(cid, "Skill desconhecida.")
end
return true
end
Click to expand...

help
 
Sort by date Sort by votes
Lua: 
 -- made by Fire Element
function onSay(cid, words, param, channel)
        local x = {
                item = 9971,
                amount = 10,
                amountskill = 10,
                limitskill = 340
        }
 
        local xml = {
                item = 9971,
                amount = 15,
                amountml = 5,
                limitml = 195
        }
 
        local pid = getPlayerGUID(cid)
 
        local id = {
                ["skillclub"] = 1,
                ["skillsword"]= 2,
                ["skillaxe"] = 3,
                ["skilldistance"] = 4,
                ["skillshielding"] = 5
        }
 
        local voc = {
                ["skillclub"] = {4, 8},
                ["skillsword"] = {4, 8},
                ["skillaxe"] = {4, 8},
                ["skilldistance"] = {3, 7},
                ["skillshielding"] = {4, 8}
        }
 
        local vocml = {1, 2, 5, 6}
 
        local pz = "yes"
 
        if(pz == "yes") and (getTilePzInfo(getCreaturePosition(cid)) == false) then
           doPlayerSendCancel(cid, "You need be in protect zone to buy.")
           return true
        end
 
        if (param == '') then
           doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Example: !buy skillshielding.")
           return true
        end
 
        if (param == 'magiclevel') then
            if getPlayerMagLevel(cid) <= xml.limitml then
                    if isInArray(vocml, getPlayerVocation(cid)) == true then
                            if doPlayerRemoveItem(cid, xml.item, xml.amount) then
                                            doRemoveCreature(cid, true)
                                            db.executeQuery("UPDATE `players` SET `maglevel` = `maglevel` + ".. xml.amountml .." WHERE `id` = ".. pid .. "")
                                    else
                                            doPlayerSendCancel(cid, "You don't have required item.")
                                    end
                        else
                                   doPlayerSendCancel(cid, "You can't buy magic level.")
                        end
            else
                    doPlayerSendCancel(cid, "You've reached the limit of magic level.")
            end
return true
end
 
                if(id[param:lower()]) then
                        if(getPlayerSkill(cid, id[param:lower()]) <= x.limitskill) then
                                if isInArray(voc[param:lower()], getPlayerVocation(cid)) == true then
                                if doPlayerRemoveItem(cid, x.item, x.amount) then
                                        doRemoveCreature(cid, true)
                                        db.executeQuery("UPDATE `player_skills` SET `value` = `value` + ".. x.amountskill .." WHERE `player_id` = ".. pid .. " and `skillid` = ".. id[param:lower()] ..";")
                                else
                                        doPlayerSendCancel(cid, "You don't have required item.")
                                end
                              else
                                 doPlayerSendCancel(cid, "You can't buy this skill.")
                              end 
                        else            
                                doPlayerSendCancel(cid, "You've reached the limit of this skill.")
                        end
                else
                        doPlayerSendCancel(cid, "Unknown skill.")
                end
return true
end
 
Upvote 0 Downvote
ruggedmage said:
Lua: 
 -- made by Fire Element
function onSay(cid, words, param, channel)
        local x = {
                item = 9971,
                amount = 10,
                amountskill = 10,
                limitskill = 340
        }
 
        local xml = {
                item = 9971,
                amount = 15,
                amountml = 5,
                limitml = 195
        }
 
        local pid = getPlayerGUID(cid)
 
        local id = {
                ["skillclub"] = 1,
                ["skillsword"]= 2,
                ["skillaxe"] = 3,
                ["skilldistance"] = 4,
                ["skillshielding"] = 5
        }
 
        local voc = {
                ["skillclub"] = {4, 8},
                ["skillsword"] = {4, 8},
                ["skillaxe"] = {4, 8},
                ["skilldistance"] = {3, 7},
                ["skillshielding"] = {4, 8}
        }
 
        local vocml = {1, 2, 5, 6}
 
        local pz = "yes"
 
        if(pz == "yes") and (getTilePzInfo(getCreaturePosition(cid)) == false) then
           doPlayerSendCancel(cid, "You need be in protect zone to buy.")
           return true
        end
 
        if (param == '') then
           doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Example: !buy skillshielding.")
           return true
        end
 
        if (param == 'magiclevel') then
            if getPlayerMagLevel(cid) <= xml.limitml then
                    if isInArray(vocml, getPlayerVocation(cid)) == true then
                            if doPlayerRemoveItem(cid, xml.item, xml.amount) then
                                            doRemoveCreature(cid, true)
                                            db.executeQuery("UPDATE `players` SET `maglevel` = `maglevel` + ".. xml.amountml .." WHERE `id` = ".. pid .. "")
                                    else
                                            doPlayerSendCancel(cid, "You don't have required item.")
                                    end
                        else
                                   doPlayerSendCancel(cid, "You can't buy magic level.")
                        end
            else
                    doPlayerSendCancel(cid, "You've reached the limit of magic level.")
            end
return true
end
 
                if(id[param:lower()]) then
                        if(getPlayerSkill(cid, id[param:lower()]) <= x.limitskill) then
                                if isInArray(voc[param:lower()], getPlayerVocation(cid)) == true then
                                if doPlayerRemoveItem(cid, x.item, x.amount) then
                                        doRemoveCreature(cid, true)
                                        db.executeQuery("UPDATE `player_skills` SET `value` = `value` + ".. x.amountskill .." WHERE `player_id` = ".. pid .. " and `skillid` = ".. id[param:lower()] ..";")
                                else
                                        doPlayerSendCancel(cid, "You don't have required item.")
                                end
                              else
                                 doPlayerSendCancel(cid, "You can't buy this skill.")
                              end 
                        else            
                                doPlayerSendCancel(cid, "You've reached the limit of this skill.")
                        end
                else
                        doPlayerSendCancel(cid, "Unknown skill.")
                end
return true
end
Click to expand...


error in console
deler.jpg
 
Upvote 0 Downvote
try

Lua: 
-- made by Fire Element
dofile("./config.lua")
function onSay(cid, words, param, channel)
	local x = {
		item = 9971,
		amount = 10,
		amountskill = 10,
		limitskill = 340
	}
	
	local xml = {
		item = 9971,
		amount = 15,
		amountml = 5,
		limitml = 195
	}
	
	local pid = getPlayerGUID(cid)
	
	local id = {
		["skillclub"] = 1,
		["skillsword"]= 2,
		["skillaxe"] = 3,
		["skilldistance"] = 4,
		["skillshielding"] = 5
	}
	
	local voc = {
		["skillclub"] = {4, 8},
		["skillsword"] = {4, 8},
		["skillaxe"] = {4, 8},
		["skilldistance"] = {3, 7},
		["skillshielding"] = {4, 8}
	}
	
	local vocml = {1, 2, 5, 6}
	
	local pz = "yes"

	if sqlType == "mysql" then
		env = assert(luasql.mysql())
		con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
	else -- sqlite
		env = assert(luasql.sqlite3())
		con = assert(env:connect(sqliteDatabase))
	end

	if(pz == "yes") and (getTilePzInfo(getCreaturePosition(cid)) == FALSE) then
		doPlayerSendCancel(cid, "You need be in protect zone to buy.")
		return true
	end
	
	if (param == '') then
		doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Example: !buy skillshielding.")
		return true
	end
	
	if (param == 'magiclevel') then
		if getPlayerMagLevel(cid) <= xml.limitml then
			if isInArray(vocml, getPlayerVocation(cid)) then
				if doPlayerRemoveItem(cid, xml.item, xml.amount) then
					doRemoveCreature(cid, true)
					assert(con:execute("UPDATE `players` SET `maglevel` = `maglevel` + ".. xml.amountml .." WHERE `id` = ".. pid .. ""))
				else
					doPlayerSendCancel(cid, "You don't have required item.")
				end
			else
				doPlayerSendCancel(cid, "You can't buy magic level.")
			end
           else
			doPlayerSendCancel(cid, "You've reached the limit of magic level.")
		end
		return true
	end
	
	if(id[param:lower()]) then
		if(getPlayerSkill(cid, id[param:lower()]) <= x.limitskill) then
			if isInArray(voc[param:lower()], getPlayerVocation(cid)) then
				if doPlayerRemoveItem(cid, x.item, x.amount) then
					doRemoveCreature(cid, true)
					assert(con:execute("UPDATE `player_skills` SET `value` = `value` + ".. x.amountskill .." WHERE `player_id` = ".. pid .. " and `skillid` = ".. id[param:lower()] ..";"))
				else
					doPlayerSendCancel(cid, "You don't have required item.")
				end
			else
				doPlayerSendCancel(cid, "You can't buy this skill.")
			end 
		else            
			doPlayerSendCancel(cid, "You've reached the limit of this skill.")
		end
	else
		doPlayerSendCancel(cid, "Unknown skill.")
	end
	return true
end
 
Upvote 0 Downvote
i change
doRemoveCreature(cid, true) --- (doRemoveCreature(cid)
assert(con:execute("UPDATE `player_skills` SET `value` = `value` + ".. x.amountskill .." WHERE `player_id` = ".. pid .. " and `skillid` = ".. id[param:lower()] ..";"))
Click to expand...

very very thank - :D
 
Upvote 0 Downvote

Similar threads

F
  • Question
talkaction limit skill tfs 1.2 10.98
Replies
1
Views
285
foundation5
F
samuel157
  • Question
Lua [SQLite] -=[TFS]=- 0.4 8.60 Is not working command !desbug and buy item free condition VIP LVL 717217 and Premium
Replies
11
Views
452
samuel157
samuel157
V
  • Question
TFS 1.X+ [Error - mysql_real_query] Query: UPDATE players
Replies
0
Views
225
vitorelias1
V
samuel157
  • Question
Lua -=[TFS]=- 0.4 8.60 teleports the player only in the protect zone to the temple
Replies
1
Views
327
DestinationSer
DestinationSer
samuel157
  • Question
Lua [SQLite] -=[TFS]=- 0.4 8.60 Use only reset 100 storage = 54676
Replies
2
Views
438
Paulix
Paulix
J
  • Question
Castle 24 tfs 1.5 Problem
Replies
0
Views
272
jareczekjsp
J
E
  • Question
Lua Item chest Action uniqueid 1624 with 1 backpack id 10518 and 42 backpack with 100 scarab coins found of 42 backpack
Replies
0
Views
82
Enderlop
E
Shoorkill
  • Question
TFS 1.X+ [TFS 1.5]Could anyone help me make this script work in tfs 1.5? it is a reset script, with attributes for each vocation
Replies
4
Views
335
marcelomnzs
marcelomnzs
samuel157
  • Question
Lua [SQLite] -=[TFS]=- 0.4 8.60 if you know put this script to use only level 717217 and with vip storage 13545 and only if you have premium
Replies
0
Views
206
samuel157
samuel157
Sanzenkai
  • Solved
TFS 0.X Solved.
Replies
8
Views
1K
Evil Puncker
E
Back
Top