TalkAction Basic Anti-dupe System

Sweddy · Jul 11, 2011

But idk if this system will work or not :S

Gomgom · Jul 15, 2011

Good job

russogracie · Jul 15, 2011

In the command /track only appears when I buy the items if I play at home and get the serial devolta already gone.

There is to see items in houses dupeds oO.

dervin13 · Jul 18, 2011

I dont know where i put the doItemSetAttribute(uid, "serial", generateSerial()) in shop.lua of gesior...

I tried that, but the serial wont appear yet..

My shop:

-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")
if(result_plr:getID() ~= -1) then
while(true) do
id = tonumber(result_plr:getDataInt("id"))
action = tostring(result_plr:getDataString("action"))
delete = tonumber(result_plr:getDataInt("delete_it"))
cid = getCreatureByName(tostring(result_plr:getDataString("name")))
if isPlayer(cid) == TRUE then
local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
local container_id = tonumber(result_plr:getDataInt("param3"))
local container_count = tonumber(result_plr:getDataInt("param4"))
local add_item_type = tostring(result_plr:getDataString("param5"))
local add_item_name = tostring(result_plr:getDataString("param6"))
local received_item = 0
local full_weight = 0
if add_item_type == 'container' then
full_weight = getItemWeightById(itemtogive_id, 1)
end
local free_cap = getPlayerFreeCap(cid)
if full_weight <= free_cap then
if add_item_type == 'container' then
local new_container = doCreateItemEx(container_id, 1)
doItemSetAttribute(new_container, "serial", generateSerial())
local iter = 0
while iter ~= container_count do
local new_container_item = doCreateItemEx(itemtogive_id, itemtogive_count)
doItemSetAttribute(new_container_item, "serial", generateSerial())
doAddContainerItemEx(new_container, new_container_item)
iter = iter + 1
end
received_item = doPlayerAddItemEx(cid, new_container)
doItemSetAttribute(received_item, "serial", generateSerial())
else
local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
doItemSetAttribute(received_item, "serial", generateSerial())
received_item = doPlayerAddItemEx(cid, new_item)
end
if received_item == RETURNVALUE_NOERROR then
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')

db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
db.executeQuery("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 not(result_plr:next()) then
break
end
end
result_plr:free()
end
return TRUE
end

ty

Lessaire · Jul 18, 2011

tigerx2 said:
Please, could you do auto-punishiment ? Removing BOTH items and baning BOTH players !
Thank you, and REP+

Heavy handed.

One could innocently purchase a duped item and be unaware of it.
And sometimes one can even dupe items on accident. Such as transferring items between characters and the server crashes for reasons unrelated to them.

The whole point of a tracking table is to generate a history and nuke repeat offenders hard, not dish zero tolerance out the gate.

dervin13 · Jul 21, 2011

no one??

Lessaire · Jul 24, 2011

dervin13 said:
no one??

edit your post to use [noparse]

Code:

[/noparse] tags please, and I may examine that for you.

dervin13 · Jul 24, 2011

Lessaire said:
edit your post to use [noparse]

Code:

[/noparse] tags please, and I may examine that for you.

In my ot, not working! I tried put doItemSetAttribute(new_container, "serial", generateSerial()) in many places of my shop.lua but do not work.

Code:

-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")
if(result_plr:getID() ~= -1) then
while(true) do
id = tonumber(result_plr:getDataInt("id"))
action = tostring(result_plr:getDataString("action"))
delete = tonumber(result_plr:getDataInt("delete_it"))
cid = getCreatureByName(tostring(result_plr:getDataStrin g("name")))
if isPlayer(cid) == TRUE then
local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
local container_id = tonumber(result_plr:getDataInt("param3"))
local container_count = tonumber(result_plr:getDataInt("param4"))
local add_item_type = tostring(result_plr:getDataString("param5"))
local add_item_name = tostring(result_plr:getDataString("param6"))
local received_item = 0
local full_weight = 0
if add_item_type == 'container' then
full_weight = getItemWeightById(itemtogive_id, 1)
end
local free_cap = getPlayerFreeCap(cid)
if full_weight <= free_cap then
if add_item_type == 'container' then
local new_container = doCreateItemEx(container_id, 1)
doItemSetAttribute(new_container, "serial", generateSerial())
local iter = 0
while iter ~= container_count do
local new_container_item = doCreateItemEx(itemtogive_id, itemtogive_count)
doItemSetAttribute(new_container_item, "serial", generateSerial())
doAddContainerItemEx(new_container, new_container_item)
iter = iter + 1
end
received_item = doPlayerAddItemEx(cid, new_container)
doItemSetAttribute(received_item, "serial", generateSerial())
else
local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
doItemSetAttribute(received_item, "serial", generateSerial())
received_item = doPlayerAddItemEx(cid, new_item)
end
if received_item == RETURNVALUE_NOERROR then
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')

db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
db.executeQuery("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 not(result_plr:next()) then
break
end
end
result_plr:free()
end
return TRUE
end

Shalk · Jul 25, 2011

working to 8.7 tfs?

johnsito · Jul 27, 2011

doItemSetAttribute(uid, "serial", generateSerial())

Where i need put this line????

Make your account

funsystemrl.no-ip.org

anotapreta · Jul 29, 2011

Need to edit the scripts of quests, shop, NPC sell items, add "serial" in the SQL table and remove all old items that do not have a serial before add this script?

dervin13 · Jul 29, 2011

i receive the msg "lost mysql connection"... how can i solve it?

setembro · Aug 2, 2011

Man have one bug

[21:41:35.953] [Error - TalkAction Interface]
[21:41:35.953] data/talkactions/scripts/trackitems.lua

nSay
[21:41:35.953] Description:
[21:41:35.968] (luaGetPlayerNameByGUID) Player not found

[21:41:35.968] [Error - TalkAction Interface]
[21:41:35.968] data/talkactions/scripts/trackitems.lua

nSay
[21:41:35.968] Description:
[21:41:35.968] data/talkactions/scripts/trackitems.lua:8: attempt to concatenate
a nil value
[21:41:35.968] stack traceback:
[21:41:35.968] data/talkactions/scripts/trackitems.lua:8: in function <data/tal
kactions/scripts/trackitems.lua:1>

Darkhaos · Aug 3, 2011

Here is the second version for this script, you can see all features in the post. http://otland.net/f82/anti-dupe-delete-all-duplicated-items-your-database-136899/#post1317307

Slave Ots · Jun 10, 2013

great work bro
thx for relasing

goesraphael · Jun 3, 2018

dervin13 said:
i receive the msg "lost mysql connection"... how can i solve it?

I'm having the same issue, anyone have the fix for it?

Letalo · Nov 9, 2018

I need help.

this error:

Lua:

Error execute query: near "USING": syntax error
<simple query executor>

with this..

Code:

SELECT * , SUBSTRING( CONVERT( attributes
USING latin1 )
FROM 18 ) AS  'serial'
FROM player_items
WHERE CONVERT( attributes
USING latin1 ) LIKE  '%serial%'

TalkAction Basic Anti-dupe System

Sweddy

Well-Known Member

Gomgom

Member

russogracie

New Member

dervin13

Active Member

Lessaire

Omniscient Hypervisor

dervin13

Active Member

Lessaire

Omniscient Hypervisor

dervin13

Active Member

Shalk

Royal Angels ATS

johnsito

New Member

anotapreta

New Member

dervin13

Active Member

setembro

New Member

Darkhaos

(:

Slave Ots

LUA Newbie™

goesraphael

Member

Letalo

New Member

Similar threads