Ir para conteúdo
  • Cadastre-se

Posts Recomendados

pessoal, estou aqui novamente para pedir pra vcs uma ajudinha ><'

eu tenho um sistema de character market

venda e compra de character in game, ele está funcionando perfeitamente

mais quero mudar uma coisa nele, ele está vendendo character por golds

eu queria a ajuda de vcs para adaptar ele, pra vender character em points

ou pode ser tbm pra aceitar outra moeda, sem ser o gold

 

Servidor 8.60

 

alguem pode me ajudar ?? REP+

 

aqui o sistema de points que eu uso

http://www.tibiaking.com/forum/topic/8183-system-pontos-p-points-system/

 

aqui o script character market

http://www.tibiaking.com/forum/topic/18488-mod-characters-market-system/

Editado por subhe (veja o histórico de edições)

n35408.gif

Link para o post
Compartilhar em outros sites

pessoal, estou aqui novamente para pedir pra vcs uma ajudinha ><'

eu tenho um sistema de character market

venda e compra de character in game, ele está funcionando perfeitamente

mais quero mudar uma coisa nele, ele está vendendo character por golds

eu queria a ajuda de vcs para adaptar ele, pra vender character em points

ou pode ser tbm pra aceitar outra moeda, sem ser o gold

 

alguem pode me ajudar ?? REP+

 

aqui o sistema de points que eu uso

http://www.tibiaking.com/forum/topic/8183-system-pontos-p-points-system/

 

aqui o script character market

http://www.tibiaking.com/forum/topic/18488-mod-characters-market-system/

Tentei Adaptar ele testa aí...

Data provided by Pastebin.com - Download Raw - See Original
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Characters Market System" version="1.0" author="LuckOake" contact="none" enabled="yes">
------------------------------------------------------------------------------------
<config name="market"><![CDATA[
price = 27112
owner = 27113
level = 30 -- Level mínimo que o character deve ter para ser vendido
min_price = 100 -- Preço mínimo de um character
max_price = 1000000 -- Preço máximo de um character

function doTransferCharacter(cid, accId)
	 return db.executeQuery("UPDATE `players` SET `account_id` = "..accId.." WHERE `id` = "..getPlayerGUIDByName(cid).."")
end

function doOfflinePlayerAddMoney(guid, money)
	 return db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..money.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
end

function setOfflinePlayerStorageValue(name, key, value)
	 local result = db.getResult("SELECT * FROM `player_storage` WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return db.executeQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (".. getPlayerGUIDByName(name) ..", ".. key ..", ".. value ..");")
	 else
			 result:free()
			 return db.executeQuery("UPDATE `player_storage` SET `value` = ".. value .." WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 end
end

function getOfflinePlayerStorageValue(name, key)
	 local result, ret = db.getResult("SELECT `value` FROM `player_storage` WHERE `player_id` = '".. getPlayerGUIDByName(name) .."' AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return nil
	 end
	 ret = result:getDataInt("value")
	 result:free()
	 return ret
end

function getOfflinePlayerValue(name, value)
	 local result, ret = db.getResult("SELECT `"..value.."` FROM `players` WHERE `id` = "..getPlayerGUIDByName(name)..";")
	 ret = result:getDataInt(value)
	 result:free()
	 return ret
end

function isCharacterForSale(name)
	 if not getOfflinePlayerStorageValue(name, price) or getOfflinePlayerStorageValue(name, price) < 1 then
	 return false
	 else
	 return true
	 end
end
]]></config>
------------------------------------------------------------------------------------
<talkaction words="!character" event="buffer"><![CDATA[
domodlib('market')
	 local t = string.explode(param, ",")
	
	 if t[1] == "sell" then
			 if not t[3] or not tonumber(t[3]) or t[4] or tonumber(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name and the price.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is already for sale.") return true
			 elseif getPlayerGUIDByName(t[2]) == getPlayerGUID(cid) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You cannot sell yourself.") return true
			 elseif getPlayerByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "The character must be offline to be sold.") return true
			 elseif getOfflinePlayerValue(t[2], "level") < level then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your character can't be sold until it has level "..level..".") return true
			 elseif tonumber(t[3]) < min_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the minimum price for selling a character is "..min_price..".") return true
			 elseif tonumber(t[3]) > max_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the maximum price for selling a character is "..max_price..".") return true
			 end
	
					 setOfflinePlayerStorageValue(t[2], price, t[3])
					 setOfflinePlayerStorageValue(t[2], owner, getPlayerGUID(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" is now for sale for the price of "'..t[3]..'" gold coins.')
	 elseif t[1] == "buy" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif not playerExists(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character doesn't exist.") return true
			 elseif getPlayerAccountId(cid) == getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You can't buy your own character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 elseif not doPlayerRemoveMoney(cid, db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` - '"..money.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
end, price)) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Not enough Points. This character's price is "..getOfflinePlayerStorageValue(t[2], price).." gold coins.") return true
			 end
					
			 if not getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)) then
					 doOfflinePlayerAddMoney(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), getOfflinePlayerStorageValue(t[2], price))
					 setOfflinePlayerStorageValue(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), 41792, getPlayerGUIDByName(t[2]))
			 else
					 doPlayerAddMoney(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), getOfflinePlayerStorageValue(t[2], price))
					 doPlayerSendTextMessage(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" has been sold for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
			 end
					 doTransferCharacter(t[2], getPlayerAccountId(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You bought the character "'..t[2]..'" for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
					 setOfflinePlayerStorageValue(t[2], owner, -1)
					 setOfflinePlayerStorageValue(t[2], price, -1) return true
	 elseif t[1] == "remove" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 end
			
					 setOfflinePlayerStorageValue(t[2], price, -1)
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You removed the character "'..t[2]..'" from the Characters Market.') return true
	 elseif t[1] == "list" then
			 local result = db.getResult("SELECT `name` FROM `players`")
			 if result:getID() == -1 then
					 return true
			 end
			 local msg = "Characters for Sale:\n\n"
			 while true do
					 local name = result:getDataString("name")
					 if isCharacterForSale(name) then
					 local sex = getOfflinePlayerValue(name, "sex") == 1 and "Male" or "Female"
							 msg = ""..msg.." - ".. name .." (Level: "..getOfflinePlayerValue(name, "level").." / Vocation: "..getVocationInfo(getOfflinePlayerValue(name, "vocation")).name.." / Sex: "..sex.." / Owner: "..getPlayerNameByGUID(getOfflinePlayerStorageValue(name, owner))..") [Price: "..getOfflinePlayerStorageValue(name, price).."] \n"
					 end
					 if not result:next() then
							 break
					 end
			 end
					 doPlayerPopupFYI(cid, msg) return true
	 elseif not t[1] or t[1] ~= "buy" or t[1] ~= "sell" or t[1] ~= "remove" or t[1] ~= "list" then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Incorrect params. You can only 'buy' or 'sell' a character, 'remove' it from the Characters Market or see the 'list' of characters for sale.") return true
	 end
return true
]]></talkaction>
------------------------------------------------------------------------------------
<event type="login" name="MarketLogin" event="script"><![CDATA[
function onLogin(cid)
domodlib('market')
	 if getPlayerStorageValue(cid, price) > 0 then return false
	 elseif getPlayerStorageValue(cid, 41792) ~= -1 then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You sold the character "..getPlayerNameByGUID(getPlayerStorageValue(cid, 41792))..". The Points is in your bank account.")
			 setPlayerStorageValue(cid, 41792, -1)
	 end
return true
end
]]></event>
</mod>
Editado por cs007 (veja o histórico de edições)
Link para o post
Compartilhar em outros sites

 

Tentei Adaptar ele testa aí...

Data provided by Pastebin.com - Download Raw - See Original
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Characters Market System" version="1.0" author="LuckOake" contact="none" enabled="yes">
------------------------------------------------------------------------------------
<config name="market"><![CDATA[
price = 27112
owner = 27113
level = 30 -- Level mínimo que o character deve ter para ser vendido
min_price = 100 -- Preço mínimo de um character
max_price = 1000000 -- Preço máximo de um character

function doTransferCharacter(cid, accId)
	 return db.executeQuery("UPDATE `players` SET `account_id` = "..accId.." WHERE `id` = "..getPlayerGUIDByName(cid).."")
end

function doOfflinePlayerAddMoney(guid, money)
	 return db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..money.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
end

function setOfflinePlayerStorageValue(name, key, value)
	 local result = db.getResult("SELECT * FROM `player_storage` WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return db.executeQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (".. getPlayerGUIDByName(name) ..", ".. key ..", ".. value ..");")
	 else
			 result:free()
			 return db.executeQuery("UPDATE `player_storage` SET `value` = ".. value .." WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 end
end

function getOfflinePlayerStorageValue(name, key)
	 local result, ret = db.getResult("SELECT `value` FROM `player_storage` WHERE `player_id` = '".. getPlayerGUIDByName(name) .."' AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return nil
	 end
	 ret = result:getDataInt("value")
	 result:free()
	 return ret
end

function getOfflinePlayerValue(name, value)
	 local result, ret = db.getResult("SELECT `"..value.."` FROM `players` WHERE `id` = "..getPlayerGUIDByName(name)..";")
	 ret = result:getDataInt(value)
	 result:free()
	 return ret
end

function isCharacterForSale(name)
	 if not getOfflinePlayerStorageValue(name, price) or getOfflinePlayerStorageValue(name, price) < 1 then
	 return false
	 else
	 return true
	 end
end
]]></config>
------------------------------------------------------------------------------------
<talkaction words="!character" event="buffer"><![CDATA[
domodlib('market')
	 local t = string.explode(param, ",")
	
	 if t[1] == "sell" then
			 if not t[3] or not tonumber(t[3]) or t[4] or tonumber(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name and the price.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is already for sale.") return true
			 elseif getPlayerGUIDByName(t[2]) == getPlayerGUID(cid) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You cannot sell yourself.") return true
			 elseif getPlayerByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "The character must be offline to be sold.") return true
			 elseif getOfflinePlayerValue(t[2], "level") < level then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your character can't be sold until it has level "..level..".") return true
			 elseif tonumber(t[3]) < min_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the minimum price for selling a character is "..min_price..".") return true
			 elseif tonumber(t[3]) > max_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the maximum price for selling a character is "..max_price..".") return true
			 end
	
					 setOfflinePlayerStorageValue(t[2], price, t[3])
					 setOfflinePlayerStorageValue(t[2], owner, getPlayerGUID(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" is now for sale for the price of "'..t[3]..'" gold coins.')
	 elseif t[1] == "buy" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif not playerExists(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character doesn't exist.") return true
			 elseif getPlayerAccountId(cid) == getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You can't buy your own character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 elseif not doPlayerRemoveMoney(cid, getOfflinePlayerStorageValue(t[2], price)) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Not enough Points. This character's price is "..getOfflinePlayerStorageValue(t[2], price).." gold coins.") return true
			 end
					
			 if not getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)) then
					 doOfflinePlayerAddMoney(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), getOfflinePlayerStorageValue(t[2], price))
					 setOfflinePlayerStorageValue(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), 41792, getPlayerGUIDByName(t[2]))
			 else
					 doPlayerAddMoney(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), getOfflinePlayerStorageValue(t[2], price))
					 doPlayerSendTextMessage(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" has been sold for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
			 end
					 doTransferCharacter(t[2], getPlayerAccountId(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You bought the character "'..t[2]..'" for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
					 setOfflinePlayerStorageValue(t[2], owner, -1)
					 setOfflinePlayerStorageValue(t[2], price, -1) return true
	 elseif t[1] == "remove" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 end
			
					 setOfflinePlayerStorageValue(t[2], price, -1)
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You removed the character "'..t[2]..'" from the Characters Market.') return true
	 elseif t[1] == "list" then
			 local result = db.getResult("SELECT `name` FROM `players`")
			 if result:getID() == -1 then
					 return true
			 end
			 local msg = "Characters for Sale:\n\n"
			 while true do
					 local name = result:getDataString("name")
					 if isCharacterForSale(name) then
					 local sex = getOfflinePlayerValue(name, "sex") == 1 and "Male" or "Female"
							 msg = ""..msg.." - ".. name .." (Level: "..getOfflinePlayerValue(name, "level").." / Vocation: "..getVocationInfo(getOfflinePlayerValue(name, "vocation")).name.." / Sex: "..sex.." / Owner: "..getPlayerNameByGUID(getOfflinePlayerStorageValue(name, owner))..") [Price: "..getOfflinePlayerStorageValue(name, price).."] \n"
					 end
					 if not result:next() then
							 break
					 end
			 end
					 doPlayerPopupFYI(cid, msg) return true
	 elseif not t[1] or t[1] ~= "buy" or t[1] ~= "sell" or t[1] ~= "remove" or t[1] ~= "list" then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Incorrect params. You can only 'buy' or 'sell' a character, 'remove' it from the Characters Market or see the 'list' of characters for sale.") return true
	 end
return true
]]></talkaction>
------------------------------------------------------------------------------------
<event type="login" name="MarketLogin" event="script"><![CDATA[
function onLogin(cid)
domodlib('market')
	 if getPlayerStorageValue(cid, price) > 0 then return false
	 elseif getPlayerStorageValue(cid, 41792) ~= -1 then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You sold the character "..getPlayerNameByGUID(getPlayerStorageValue(cid, 41792))..". The Points is in your bank account.")
			 setPlayerStorageValue(cid, 41792, -1)
	 end
return true
end
]]></event>
</mod>

ainda está comprando por gold

olha o que aparece quando nao tenho dinheiro

""11:02 Not enough Points. This character's price is 1 gold coins."""

 fala o nome points..

 

ai olha o que acontece quando eu tenho dinheiro

""11:03 You bought the character "test knight" for the price of 1 gold coins."

 

nao deu certo

n35408.gif

Link para o post
Compartilhar em outros sites

testa lá...Editei o script

nao funcionou

da esse erro aqui, nao sei se vai ajudar, mais o meu servidor eh 8.60

 

[02/04/2015 12:16:11] [Lua Error] 

[02/04/2015 12:16:11] [string "loadBuffer"]:40: ')' expected (to close '(' at line 39) near 'end'
Editado por subhe (veja o histórico de edições)

n35408.gif

Link para o post
Compartilhar em outros sites

up

 

alguem me ajuda por favor


up


up

Editado por subhe (veja o histórico de edições)

n35408.gif

Link para o post
Compartilhar em outros sites

Testa ainda mano.. Abraço

Data provided by Pastebin.com - Download Raw - See Original
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Characters Market System" version="1.0" author="LuckOake" contact="none" enabled="yes">
------------------------------------------------------------------------------------
<config name="market"><![CDATA[
price = 27112
owner = 27113
level = 30 -- Level mínimo que o character deve ter para ser vendido
min_price = 100 -- Preço mínimo de um character
max_price = 1000000 -- Preço máximo de um character

function doTransferCharacter(cid, accId)
	 return db.executeQuery("UPDATE `players` SET `account_id` = "..accId.." WHERE `id` = "..getPlayerGUIDByName(cid).."")
end

function doOfflinePlayerAddMoney(guid, money)
	 return db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..money.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
end

function setOfflinePlayerStorageValue(name, key, value)
	 local result = db.getResult("SELECT * FROM `player_storage` WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return db.executeQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (".. getPlayerGUIDByName(name) ..", ".. key ..", ".. value ..");")
	 else
			 result:free()
			 return db.executeQuery("UPDATE `player_storage` SET `value` = ".. value .." WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 end
end

function getOfflinePlayerStorageValue(name, key)
	 local result, ret = db.getResult("SELECT `value` FROM `player_storage` WHERE `player_id` = '".. getPlayerGUIDByName(name) .."' AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return nil
	 end
	 ret = result:getDataInt("value")
	 result:free()
	 return ret
end

function getOfflinePlayerValue(name, value)
	 local result, ret = db.getResult("SELECT `"..value.."` FROM `players` WHERE `id` = "..getPlayerGUIDByName(name)..";")
	 ret = result:getDataInt("value")
	 result:free()
	 return ret
end

function isCharacterForSale(name)
	 if not getOfflinePlayerStorageValue(name, price) or getOfflinePlayerStorageValue(name, price) < 1 then
	 return false
	 else
	 return true
	 end
end
]]></config>
------------------------------------------------------------------------------------
<talkaction words="!character" event="buffer"><![CDATA[
domodlib('market')
	 local t = string.explode(param, ",")
	
	 if t[1] == "sell" then
			 if not t[3] or not tonumber(t[3]) or t[4] or tonumber(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name and the price.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is already for sale.") return true
			 elseif getPlayerGUIDByName(t[2]) == getPlayerGUID(cid) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You cannot sell yourself.") return true
			 elseif getPlayerByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "The character must be offline to be sold.") return true
			 elseif getOfflinePlayerValue(t[2], "level") < level then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your character can't be sold until it has level "..level..".") return true
			 elseif tonumber(t[3]) < min_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the minimum price for selling a character is "..min_price..".") return true
			 elseif tonumber(t[3]) > max_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the maximum price for selling a character is "..max_price..".") return true
			 end
	
					 setOfflinePlayerStorageValue(t[2], price, t[3])
					 setOfflinePlayerStorageValue(t[2], owner, getPlayerGUID(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" is now for sale for the price of "'..t[3]..'" gold coins.')
	 elseif t[1] == "buy" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif not playerExists(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character doesn't exist.") return true
			 elseif getPlayerAccountId(cid) == getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You can't buy your own character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 elseif not db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` - '"..price.."';") then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Not enough Points. This character's price is "..getOfflinePlayerStorageValue(t[2], price).." gold coins.") return true
			 end
					
			 if not getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)) then
					 db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
					 setOfflinePlayerStorageValue(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), 41792, getPlayerGUIDByName(t[2]))
			 else
					 db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
					 doPlayerSendTextMessage(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" has been sold for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
			 end
					 doTransferCharacter(t[2], getPlayerAccountId(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You bought the character "'..t[2]..'" for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
					 setOfflinePlayerStorageValue(t[2], owner, -1)
					 setOfflinePlayerStorageValue(t[2], price, -1) return true
	 elseif t[1] == "remove" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 end
			
					 setOfflinePlayerStorageValue(t[2], price, -1)
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You removed the character "'..t[2]..'" from the Characters Market.') return true
	 elseif t[1] == "list" then
			 local result = db.getResult("SELECT `name` FROM `players`")
			 if result:getID() == -1 then
					 return true
			 end
			 local msg = "Characters for Sale:\n\n"
			 while true do
					 local name = result:getDataString("name")
					 if isCharacterForSale(name) then
					 local sex = getOfflinePlayerValue(name, "sex") == 1 and "Male" or "Female"
							 msg = ""..msg.." - ".. name .." (Level: "..getOfflinePlayerValue(name, "level").." / Vocation: "..getVocationInfo(getOfflinePlayerValue(name, "vocation")).name.." / Sex: "..sex.." / Owner: "..getPlayerNameByGUID(getOfflinePlayerStorageValue(name, owner))..") [Price: "..getOfflinePlayerStorageValue(name, price).."] \n"
					 end
					 if not result:next() then
							 break
					 end
			 end
					 doPlayerPopupFYI(cid, msg) return true
	 elseif not t[1] or t[1] ~= "buy" or t[1] ~= "sell" or t[1] ~= "remove" or t[1] ~= "list" then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Incorrect params. You can only 'buy' or 'sell' a character, 'remove' it from the Characters Market or see the 'list' of characters for sale.") return true
	 end
return true
]]></talkaction>
------------------------------------------------------------------------------------
<event type="login" name="MarketLogin" event="script"><![CDATA[
function onLogin(cid)
domodlib('market')
	 if getPlayerStorageValue(cid, price) > 0 then return false
	 elseif getPlayerStorageValue(cid, 41792) ~= -1 then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You sold the character "..getPlayerNameByGUID(getPlayerStorageValue(cid, 41792))..". The Points is in your bank account.")
			 setPlayerStorageValue(cid, 41792, -1)
	 end
return true
end
]]></event>
</mod>
Link para o post
Compartilhar em outros sites

 

<?xml version="1.0" encoding="ISO-8859-1"?>

<mod name="Characters Market System" version="1.0" author="LuckOake" contact="none" enabled="yes">
------------------------------------------------------------------------------------
<config name="market"><![CDATA[
price = 27112
owner = 27113
level = 10 -- Level mínimo que o character deve ter para ser vendido
min_price = 1 -- Preço mínimo de um character
max_price = 1000000 -- Preço máximo de um character
 
function doTransferCharacter(cid, accId)
return db.executeQuery("UPDATE `players` SET `account_id` = "..accId.." WHERE `id` = "..getPlayerGUIDByName(cid).."")
end
 
function doOfflinePlayerAddMoney(guid, money)
return db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..money.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
end
 
function setOfflinePlayerStorageValue(name, key, value)
local result = db.getResult("SELECT * FROM `player_storage` WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
if result:getID() == -1 then
return db.executeQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (".. getPlayerGUIDByName(name) ..", ".. key ..", ".. value ..");")
else
result:free()
return db.executeQuery("UPDATE `player_storage` SET `value` = ".. value .." WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
end
end
 
function getOfflinePlayerStorageValue(name, key)
local result, ret = db.getResult("SELECT `value` FROM `player_storage` WHERE `player_id` = '".. getPlayerGUIDByName(name) .."' AND `key` = ".. key ..";")
if result:getID() == -1 then
return nil
end
ret = result:getDataInt("value")
result:free()
return ret
end
 
function getOfflinePlayerValue(name, value)
local result, ret = db.getResult("SELECT `"..value.."` FROM `players` WHERE `id` = "..getPlayerGUIDByName(name)..";")
ret = result:getDataInt("value")
result:free()
return ret
end
 
function isCharacterForSale(name)
if not getOfflinePlayerStorageValue(name, price) or getOfflinePlayerStorageValue(name, price) < 1 then
return false
else
return true
end
end
]]></config>
------------------------------------------------------------------------------------
<talkaction words="!character" event="buffer"><![CDATA[
domodlib('market')
local t = string.explode(param, ",")
 
if t[1] == "sell" then
if not t[3] or not tonumber(t[3]) or t[4] or tonumber(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name and the price.") return true
elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
elseif isCharacterForSale(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is already for sale.") return true
elseif getPlayerGUIDByName(t[2]) == getPlayerGUID(cid) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You cannot sell yourself.") return true
elseif getPlayerByName(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "The character must be offline to be sold.") return true
elseif getOfflinePlayerValue(t[2], "level") < level then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your character can't be sold until it has level "..level..".") return true
elseif tonumber(t[3]) < min_price then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the minimum price for selling a character is "..min_price..".") return true
elseif tonumber(t[3]) > max_price then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the maximum price for selling a character is "..max_price..".") return true
end
 
setOfflinePlayerStorageValue(t[2], price, t[3])
setOfflinePlayerStorageValue(t[2], owner, getPlayerGUID(cid))
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" is now for sale for the price of "'..t[3]..'" gold coins.')
elseif t[1] == "buy" then
if not t[2] then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
elseif not playerExists(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character doesn't exist.") return true
elseif getPlayerAccountId(cid) == getAccountIdByName(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You can't buy your own character.") return true
elseif not isCharacterForSale(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
elseif not db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` - '"..price.."';") then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Not enough Points. This character's price is "..getOfflinePlayerStorageValue(t[2], price).." gold coins.") return true
end
 
if not getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)) then
db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
setOfflinePlayerStorageValue(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), 41792, getPlayerGUIDByName(t[2]))
else
db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
doPlayerSendTextMessage(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" has been sold for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
end
doTransferCharacter(t[2], getPlayerAccountId(cid))
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You bought the character "'..t[2]..'" for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
setOfflinePlayerStorageValue(t[2], owner, -1)
setOfflinePlayerStorageValue(t[2], price, -1) return true
elseif t[1] == "remove" then
if not t[2] then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
elseif not isCharacterForSale(t[2]) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
end
 
setOfflinePlayerStorageValue(t[2], price, -1)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You removed the character "'..t[2]..'" from the Characters Market.') return true
elseif t[1] == "list" then
local result = db.getResult("SELECT `name` FROM `players`")
if result:getID() == -1 then
return true
end
local msg = "Characters for Sale:\n\n"
while true do
local name = result:getDataString("name")
if isCharacterForSale(name) then
local sex = getOfflinePlayerValue(name, "sex") == 1 and "Male" or "Female"
msg = ""..msg.." - ".. name .." (Level: "..getOfflinePlayerValue(name, "level").." / Vocation: "..getVocationInfo(getOfflinePlayerValue(name, "vocation")).name.." / Sex: "..sex.." / Owner: "..getPlayerNameByGUID(getOfflinePlayerStorageValue(name, owner))..") [Price: "..getOfflinePlayerStorageValue(name, price).."] \n"
end
if not result:next() then
break
end
end
doPlayerPopupFYI(cid, msg) return true
elseif not t[1] or t[1] ~= "buy" or t[1] ~= "sell" or t[1] ~= "remove" or t[1] ~= "list" then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Incorrect params. You can only 'buy' or 'sell' a character, 'remove' it from the Characters Market or see the 'list' of characters for sale.") return true
end
return true
]]></talkaction>
------------------------------------------------------------------------------------
<event type="login" name="MarketLogin" event="script"><![CDATA[
function onLogin(cid)
domodlib('market')
if getPlayerStorageValue(cid, price) > 0 then return false
elseif getPlayerStorageValue(cid, 41792) ~= -1 then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You sold the character "..getPlayerNameByGUID(getPlayerStorageValue(cid, 41792))..". The Points is in your bank account.")
setPlayerStorageValue(cid, 41792, -1)
end
return true
end
]]></event>
</mod>

 

agora da esse erro aqui

 

[06/04/2015 08:43:09] Error during getDataInt(value).

e nao coloca o char pra vender

n35408.gif

Link para o post
Compartilhar em outros sites
Data provided by Pastebin.com - Download Raw - See Original
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Characters Market System" version="1.0" author="LuckOake" contact="none" enabled="yes">
------------------------------------------------------------------------------------
<config name="market"><![CDATA[
price = 27112
owner = 27113
level = 30 -- Level mínimo que o character deve ter para ser vendido
min_price = 100 -- Preço mínimo de um character
max_price = 1000000 -- Preço máximo de um character

function doTransferCharacter(cid, accId)
	 return db.executeQuery("UPDATE `players` SET `account_id` = "..accId.." WHERE `id` = "..getPlayerGUIDByName(cid).."")
end

function doOfflinePlayerAddMoney(guid, money)
	 return db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..money.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
end

function setOfflinePlayerStorageValue(name, key, value)
	 local result = db.getResult("SELECT * FROM `player_storage` WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return db.executeQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (".. getPlayerGUIDByName(name) ..", ".. key ..", ".. value ..");")
	 else
			 result:free()
			 return db.executeQuery("UPDATE `player_storage` SET `value` = ".. value .." WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 end
end

function getOfflinePlayerStorageValue(name, key)
	 local result, ret = db.getResult("SELECT `value` FROM `player_storage` WHERE `player_id` = '".. getPlayerGUIDByName(name) .."' AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return nil
	 end
end

function getOfflinePlayerValue(name, value)
	 local result, ret = db.getResult("SELECT `"..value.."` FROM `players` WHERE `id` = "..getPlayerGUIDByName(name)..";")

end

function isCharacterForSale(name)
	 if not getOfflinePlayerStorageValue(name, price) or getOfflinePlayerStorageValue(name, price) < 1 then
	 return false
	 else
	 return true
	 end
end
]]></config>
------------------------------------------------------------------------------------
<talkaction words="!character" event="buffer"><![CDATA[
domodlib('market')
	 local t = string.explode(param, ",")
	
	 if t[1] == "sell" then
			 if not t[3] or not tonumber(t[3]) or t[4] or tonumber(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name and the price.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is already for sale.") return true
			 elseif getPlayerGUIDByName(t[2]) == getPlayerGUID(cid) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You cannot sell yourself.") return true
			 elseif getPlayerByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "The character must be offline to be sold.") return true
			 elseif getOfflinePlayerValue(t[2], "level") < level then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your character can't be sold until it has level "..level..".") return true
			 elseif tonumber(t[3]) < min_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the minimum price for selling a character is "..min_price..".") return true
			 elseif tonumber(t[3]) > max_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the maximum price for selling a character is "..max_price..".") return true
			 end
	
					 setOfflinePlayerStorageValue(t[2], price, t[3])
					 setOfflinePlayerStorageValue(t[2], owner, getPlayerGUID(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" is now for sale for the price of "'..t[3]..'" gold coins.')
	 elseif t[1] == "buy" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif not playerExists(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character doesn't exist.") return true
			 elseif getPlayerAccountId(cid) == getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You can't buy your own character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 elseif not db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` - '"..price.."';") then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Not enough Points. This character's price is "..getOfflinePlayerStorageValue(t[2], price).." gold coins.") return true
			 end
					
			 if not getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)) then
					 db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
					 setOfflinePlayerStorageValue(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), 41792, getPlayerGUIDByName(t[2]))
			 else
					 db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
					 doPlayerSendTextMessage(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" has been sold for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
			 end
					 doTransferCharacter(t[2], getPlayerAccountId(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You bought the character "'..t[2]..'" for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
					 setOfflinePlayerStorageValue(t[2], owner, -1)
					 setOfflinePlayerStorageValue(t[2], price, -1) return true
	 elseif t[1] == "remove" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 end
			
					 setOfflinePlayerStorageValue(t[2], price, -1)
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You removed the character "'..t[2]..'" from the Characters Market.') return true
	 elseif t[1] == "list" then
			 local result = db.getResult("SELECT `name` FROM `players`")
			 if result:getID() == -1 then
					 return true
			 end
			 local msg = "Characters for Sale:\n\n"
			 while true do
					 local name = result:getDataString("name")
					 if isCharacterForSale(name) then
					 local sex = getOfflinePlayerValue(name, "sex") == 1 and "Male" or "Female"
							 msg = ""..msg.." - ".. name .." (Level: "..getOfflinePlayerValue(name, "level").." / Vocation: "..getVocationInfo(getOfflinePlayerValue(name, "vocation")).name.." / Sex: "..sex.." / Owner: "..getPlayerNameByGUID(getOfflinePlayerStorageValue(name, owner))..") [Price: "..getOfflinePlayerStorageValue(name, price).."] \n"
					 end
					 if not result:next() then
							 break
					 end
			 end
					 doPlayerPopupFYI(cid, msg) return true
	 elseif not t[1] or t[1] ~= "buy" or t[1] ~= "sell" or t[1] ~= "remove" or t[1] ~= "list" then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Incorrect params. You can only 'buy' or 'sell' a character, 'remove' it from the Characters Market or see the 'list' of characters for sale.") return true
	 end
return true
]]></talkaction>
------------------------------------------------------------------------------------
<event type="login" name="MarketLogin" event="script"><![CDATA[
function onLogin(cid)
domodlib('market')
	 if getPlayerStorageValue(cid, price) > 0 then return false
	 elseif getPlayerStorageValue(cid, 41792) ~= -1 then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You sold the character "..getPlayerNameByGUID(getPlayerStorageValue(cid, 41792))..". The Points is in your bank account.")
			 setPlayerStorageValue(cid, 41792, -1)
	 end
return true
end
]]></event>
</mod>

Testá aí sangue se não for não vou poder ajudar.

Link para o post
Compartilhar em outros sites
Data provided by Pastebin.com - Download Raw - See Original
<?xml version="1.0" encoding="UTF-8"?>
<mod name="Characters Market System" version="1.0" author="LuckOake" contact="none" enabled="yes">
------------------------------------------------------------------------------------
<config name="market"><![CDATA[
price = 27112
owner = 27113
level = 30 -- Level mínimo que o character deve ter para ser vendido
min_price = 100 -- Preço mínimo de um character
max_price = 1000000 -- Preço máximo de um character

function doTransferCharacter(cid, accId)
	 return db.executeQuery("UPDATE `players` SET `account_id` = "..accId.." WHERE `id` = "..getPlayerGUIDByName(cid).."")
end

function doOfflinePlayerAddMoney(guid, money)
	 return db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..money.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
end

function setOfflinePlayerStorageValue(name, key, value)
	 local result = db.getResult("SELECT * FROM `player_storage` WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return db.executeQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (".. getPlayerGUIDByName(name) ..", ".. key ..", ".. value ..");")
	 else
			 result:free()
			 return db.executeQuery("UPDATE `player_storage` SET `value` = ".. value .." WHERE `player_id` = ".. getPlayerGUIDByName(name) .." AND `key` = ".. key ..";")
	 end
end

function getOfflinePlayerStorageValue(name, key)
	 local result, ret = db.getResult("SELECT `value` FROM `player_storage` WHERE `player_id` = '".. getPlayerGUIDByName(name) .."' AND `key` = ".. key ..";")
	 if result:getID() == -1 then
			 return nil
	 end
end

function getOfflinePlayerValue(name, value)
	 local result, ret = db.getResult("SELECT `"..value.."` FROM `players` WHERE `id` = "..getPlayerGUIDByName(name)..";")

end

function isCharacterForSale(name)
	 if not getOfflinePlayerStorageValue(name, price) or getOfflinePlayerStorageValue(name, price) < 1 then
	 return false
	 else
	 return true
	 end
end
]]></config>
------------------------------------------------------------------------------------
<talkaction words="!character" event="buffer"><![CDATA[
domodlib('market')
	 local t = string.explode(param, ",")
	
	 if t[1] == "sell" then
			 if not t[3] or not tonumber(t[3]) or t[4] or tonumber(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name and the price.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is already for sale.") return true
			 elseif getPlayerGUIDByName(t[2]) == getPlayerGUID(cid) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You cannot sell yourself.") return true
			 elseif getPlayerByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "The character must be offline to be sold.") return true
			 elseif getOfflinePlayerValue(t[2], "level") < level then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your character can't be sold until it has level "..level..".") return true
			 elseif tonumber(t[3]) < min_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the minimum price for selling a character is "..min_price..".") return true
			 elseif tonumber(t[3]) > max_price then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Sorry, but the maximum price for selling a character is "..max_price..".") return true
			 end
	
					 setOfflinePlayerStorageValue(t[2], price, t[3])
					 setOfflinePlayerStorageValue(t[2], owner, getPlayerGUID(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" is now for sale for the price of "'..t[3]..'" gold coins.')
	 elseif t[1] == "buy" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif not playerExists(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character doesn't exist.") return true
			 elseif getPlayerAccountId(cid) == getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You can't buy your own character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 elseif not db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` - '"..price.."';") then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Not enough Points. This character's price is "..getOfflinePlayerStorageValue(t[2], price).." gold coins.") return true
			 end
					
			 if not getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)) then
					 db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
					 setOfflinePlayerStorageValue(getPlayerNameByGUID(getOfflinePlayerStorageValue(t[2], owner)), 41792, getPlayerGUIDByName(t[2]))
			 else
					 db.executeQuery("UPDATE `accounts` SET `p_points` = `p_points` + '"..price.."' WHERE `id` = '"..getPlayerGUIDByName(guid).."';")
					 doPlayerSendTextMessage(getPlayerByGUID(getOfflinePlayerStorageValue(t[2], owner)), MESSAGE_STATUS_CONSOLE_BLUE, 'Your character "'..t[2]..'" has been sold for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
			 end
					 doTransferCharacter(t[2], getPlayerAccountId(cid))
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You bought the character "'..t[2]..'" for the price of '..getOfflinePlayerStorageValue(t[2], price)..' gold coins.')
					 setOfflinePlayerStorageValue(t[2], owner, -1)
					 setOfflinePlayerStorageValue(t[2], price, -1) return true
	 elseif t[1] == "remove" then
			 if not t[2] then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Incorrect Params. Specify the character name.") return true
			 elseif getPlayerAccountId(cid) ~= getAccountIdByName(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This is not your character.") return true
			 elseif not isCharacterForSale(t[2]) then
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "This character is not for sale.") return true
			 end
			
					 setOfflinePlayerStorageValue(t[2], price, -1)
					 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, 'You removed the character "'..t[2]..'" from the Characters Market.') return true
	 elseif t[1] == "list" then
			 local result = db.getResult("SELECT `name` FROM `players`")
			 if result:getID() == -1 then
					 return true
			 end
			 local msg = "Characters for Sale:\n\n"
			 while true do
					 local name = result:getDataString("name")
					 if isCharacterForSale(name) then
					 local sex = getOfflinePlayerValue(name, "sex") == 1 and "Male" or "Female"
							 msg = ""..msg.." - ".. name .." (Level: "..getOfflinePlayerValue(name, "level").." / Vocation: "..getVocationInfo(getOfflinePlayerValue(name, "vocation")).name.." / Sex: "..sex.." / Owner: "..getPlayerNameByGUID(getOfflinePlayerStorageValue(name, owner))..") [Price: "..getOfflinePlayerStorageValue(name, price).."] \n"
					 end
					 if not result:next() then
							 break
					 end
			 end
					 doPlayerPopupFYI(cid, msg) return true
	 elseif not t[1] or t[1] ~= "buy" or t[1] ~= "sell" or t[1] ~= "remove" or t[1] ~= "list" then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Incorrect params. You can only 'buy' or 'sell' a character, 'remove' it from the Characters Market or see the 'list' of characters for sale.") return true
	 end
return true
]]></talkaction>
------------------------------------------------------------------------------------
<event type="login" name="MarketLogin" event="script"><![CDATA[
function onLogin(cid)
domodlib('market')
	 if getPlayerStorageValue(cid, price) > 0 then return false
	 elseif getPlayerStorageValue(cid, 41792) ~= -1 then
			 doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You sold the character "..getPlayerNameByGUID(getPlayerStorageValue(cid, 41792))..". The Points is in your bank account.")
			 setPlayerStorageValue(cid, 41792, -1)
	 end
return true
end
]]></event>
</mod>

Testá aí sangue se não for não vou poder ajudar.

 

 

não funcinou :/

da erro

 

[06/04/2015 12:28:41] [Error - TalkAction Interface] 

[06/04/2015 12:28:41] buffer
[06/04/2015 12:28:41] Description: 
[06/04/2015 12:28:41] [string "loadBuffer"]:19: attempt to compare nil with number

n35408.gif

Link para o post
Compartilhar em outros sites

alguem pode me ajudar ??

n35408.gif

Link para o post
Compartilhar em outros sites

up


alguem me ajudar por favor

n35408.gif

Link para o post
Compartilhar em outros sites

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emojis são permitidos.

×   Seu link foi automaticamente incorporado.   Mostrar como link

×   Seu conteúdo anterior foi restaurado.   Limpar o editor

×   Não é possível colar imagens diretamente. Carregar ou inserir imagens do URL.

  • Quem Está Navegando   0 membros estão online

    Nenhum usuário registrado visualizando esta página.

×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo