TalkAction Improved Bounty-Hunter System by Tufte

HTala · Aug 3, 2009

For what u need the "string.lower(hunt) ~= string.lower(getCreatureName(cid))"??

5mok3 · Aug 14, 2009

[14/08/2009 04:50:44] [Warning - Event::loadScript] Cannot load script (data/talkactions/scripts/bounty.lua)
[14/08/2009 04:50:44] data/talkactions/scripts/bounty.lua:1: unexpected symbol near '{'

help? jaja

DedicatedOT · Aug 14, 2009

Why do you use MyISAM? TFS uses InnoDB.

5mok3 · Aug 14, 2009

say what? jaja

5mok3 · Aug 14, 2009

@bumpp
i can't get this script working :S

Shawak · Aug 14, 2009

There isn't a "{" in the first line, <_<.

Sync · Aug 14, 2009

This doesnt work. <_<

5mok3 · Aug 14, 2009

Thats why i need help o.o
that's the error im getting..

Tufte · Aug 15, 2009

edited my first post, so if you get the result not set error, check the buttom of my first post please.

all you have to do, is to replace your lib/database.lua with mine, which is improved by Colandus.

PHP:

if(result == nil) then
	print("> WARNING: Couldn't load database lib.")
	return
end

Result = createClass(nil)
Result:setAttributes({
	id = -1
})

function Result:getID()
	return self.id
end

function Result:setID(_id)
	self.id = _id
end

function Result:getQuery()
	return self.query
end

function Result:setQuery(_query)
	self.query = _query
end

function Result:create(_query)
	self:setQuery(_query)
	local _id = db.storeQuery(self:getQuery())
	if(_id) then
		self:setID(_id)
	end

	return self:getID()
end

function Result:getRows(free)
	if(self:getID() == -1) then
		error("[Result:getRows]: Result not set!")
	end

	local c = 0
	while true do
		if not self:next() then
			break
		end
		
		c = c + 1
	end

	if(free) then
		self:free()
	end

	return c
end

function Result:getDataInt(s)
	if(self:getID() == -1) then
		error("[Result:getDataInt]: Result not set!")
	end

	return result.getDataInt(self:getID(), s)
end

function Result:getDataLong(s)
	if(self:getID() == -1) then
		error("[Result:getDataLong]: Result not set!")
	end

	return result.getDataLong(self:getID(), s)
end

function Result:getDataString(s)
	if(self:getID() == -1) then
		error("[Result:getDataString]: Result not set!")
	end

	return result.getDataString(self:getID(), s)
end

function Result:getDataStream(s)
	if(self:getID() == -1) then
		error("[Result:getDataStream]: Result not set!")
	end

	return result.getDataStream(self:getID(), s)
end

function Result:next()
	if(self:getID() == -1) then
		error("[Result:next]: Result not set!")
	end

	return result.next(self:getID())
end

function Result:free()
	if(self:getID() == -1) then
		error("[Result:free]: Result not set!")
	end

	local ret = result.free(self:getID())
	self:setID(-1)
	return ret
end

Result.numRows = Result.getRows
function db.getResult(query)
	if(type(query) ~= 'string') then
		return nil
	end

	local res = Result:new()
	res:setID(db.storeQuery(query))
	return res
end

Master-m · Aug 15, 2009

Tufte said:

edited my first post, so if you get the result not set error, check the buttom of my first post please.

all you have to do, is to replace your lib/database.lua with mine, which is improved by Colandus.

PHP:

if(result == nil) then
	print("> WARNING: Couldn't load database lib.")
	return
end

Result = createClass(nil)
Result:setAttributes({
	id = -1
})

function Result:getID()
	return self.id
end

function Result:setID(_id)
	self.id = _id
end

function Result:getQuery()
	return self.query
end

function Result:setQuery(_query)
	self.query = _query
end

function Result:create(_query)
	self:setQuery(_query)
	local _id = db.storeQuery(self:getQuery())
	if(_id) then
		self:setID(_id)
	end

	return self:getID()
end

function Result:getRows(free)
	if(self:getID() == -1) then
		error("[Result:getRows]: Result not set!")
	end

	local c = 0
	while true do
		if not self:next() then
			break
		end
		
		c = c + 1
	end

	if(free) then
		self:free()
	end

	return c
end

function Result:getDataInt(s)
	if(self:getID() == -1) then
		error("[Result:getDataInt]: Result not set!")
	end

	return result.getDataInt(self:getID(), s)
end

function Result:getDataLong(s)
	if(self:getID() == -1) then
		error("[Result:getDataLong]: Result not set!")
	end

	return result.getDataLong(self:getID(), s)
end

function Result:getDataString(s)
	if(self:getID() == -1) then
		error("[Result:getDataString]: Result not set!")
	end

	return result.getDataString(self:getID(), s)
end

function Result:getDataStream(s)
	if(self:getID() == -1) then
		error("[Result:getDataStream]: Result not set!")
	end

	return result.getDataStream(self:getID(), s)
end

function Result:next()
	if(self:getID() == -1) then
		error("[Result:next]: Result not set!")
	end

	return result.next(self:getID())
end

function Result:free()
	if(self:getID() == -1) then
		error("[Result:free]: Result not set!")
	end

	local ret = result.free(self:getID())
	self:setID(-1)
	return ret
end

Result.numRows = Result.getRows
function db.getResult(query)
	if(type(query) ~= 'string') then
		return nil
	end

	local res = Result:new()
	res:setID(db.storeQuery(query))
	return res
end

.thanks Lolandus = pr0

Tufte · Aug 15, 2009

HTala said:
For what u need the "string.lower(hunt) ~= string.lower(getCreatureName(cid))"??

so you cant hunt yourself? -.-

btw check first post fixed errors

Sizaro · Aug 24, 2009

[24/08/2009 18:14:03] mysql_real_query(): SELECT `player_name` FROM `bounty_hunters` WHERE `player_name` = 'Jivaro' AND `kill_time` < 1 - MYSQL ERROR: Unknown column 'player_name' in 'field list' (1054)

I removed the scripts and I still get the error? -.-

Atleta · Oct 10, 2009

im have errors ;/

[10/10/2009 21:55:17] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.lua

nThink

[10/10/2009 21:55:18] luaResultGetDataInt(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.lua

nThink

[10/10/2009 21:55:18] luaResultGetDataString(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.lua

nThink

[10/10/2009 21:55:18] luaResultGetDataInt(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.lua

nThink

[10/10/2009 21:55:18] luaResultGetDataString(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.lua

nThink

[10/10/2009 21:55:18] luaResultNext(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.lua

nThink

[10/10/2009 21:55:18] luaResultFree(). Result not found.

hodleo · Oct 25, 2009

haleko said:
im have errors ;/

[10/10/2009 21:55:17] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.luanThink

[10/10/2009 21:55:18] luaResultGetDataInt(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.luanThink

[10/10/2009 21:55:18] luaResultGetDataString(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.luanThink

[10/10/2009 21:55:18] luaResultGetDataInt(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.luanThink

[10/10/2009 21:55:18] luaResultGetDataString(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.luanThink

[10/10/2009 21:55:18] luaResultNext(). Result not found.

[10/10/2009 21:55:18] Lua Script Error: [GlobalEvent Interface]
[10/10/2009 21:55:18] data/globalevents/scripts/shop.luanThink

[10/10/2009 21:55:18] luaResultFree(). Result not found.

rofl what does that has to do with the thread?

Scofield · Oct 26, 2009

working great for me, Thanks

papirri · Nov 6, 2009

Has any scripter made this compatible with tfs 2.5?

piti129 · Nov 6, 2009

Tufte said:

edited my first post, so if you get the result not set error, check the buttom of my first post please.

all you have to do, is to replace your lib/database.lua with mine, which is improved by Colandus.

PHP:

if(result == nil) then
	print("> WARNING: Couldn't load database lib.")
	return
end

Result = createClass(nil)
Result:setAttributes({
	id = -1
})

function Result:getID()
	return self.id
end

function Result:setID(_id)
	self.id = _id
end

function Result:getQuery()
	return self.query
end

function Result:setQuery(_query)
	self.query = _query
end

function Result:create(_query)
	self:setQuery(_query)
	local _id = db.storeQuery(self:getQuery())
	if(_id) then
		self:setID(_id)
	end

	return self:getID()
end

function Result:getRows(free)
	if(self:getID() == -1) then
		error("[Result:getRows]: Result not set!")
	end

	local c = 0
	while true do
		if not self:next() then
			break
		end
		
		c = c + 1
	end

	if(free) then
		self:free()
	end

	return c
end

function Result:getDataInt(s)
	if(self:getID() == -1) then
		error("[Result:getDataInt]: Result not set!")
	end

	return result.getDataInt(self:getID(), s)
end

function Result:getDataLong(s)
	if(self:getID() == -1) then
		error("[Result:getDataLong]: Result not set!")
	end

	return result.getDataLong(self:getID(), s)
end

function Result:getDataString(s)
	if(self:getID() == -1) then
		error("[Result:getDataString]: Result not set!")
	end

	return result.getDataString(self:getID(), s)
end

function Result:getDataStream(s)
	if(self:getID() == -1) then
		error("[Result:getDataStream]: Result not set!")
	end

	return result.getDataStream(self:getID(), s)
end

function Result:next()
	if(self:getID() == -1) then
		error("[Result:next]: Result not set!")
	end

	return result.next(self:getID())
end

function Result:free()
	if(self:getID() == -1) then
		error("[Result:free]: Result not set!")
	end

	local ret = result.free(self:getID())
	self:setID(-1)
	return ret
end

Result.numRows = Result.getRows
function db.getResult(query)
	if(type(query) ~= 'string') then
		return nil
	end

	local res = Result:new()
	res:setID(db.storeQuery(query))
	return res
end

When i use this not work comends, !frags etc.

TFS 0.3.5pl1

lizz · Nov 28, 2009

Errrm? How do i add an "SQL-Query?"

andrew95434 · Aug 14, 2010

CREATE TABLE IF NOT EXISTS `bounty_hunters` (
`id` int(11) NOT NULL auto_increment,
`player_name` varchar(50) collate utf8_unicode_ci NOT NULL,
`hunted_by` varchar(50) collate utf8_unicode_ci NOT NULL,
`killed_by` varchar(11) collate utf8_unicode_ci NOT NULL,
`added` int(15) NOT NULL,
`prize` int(11) NOT NULL,
`kill_time` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

i have to copy this code into any place or i have to add it manaully?
please answer me, im searching for the answer for many time
sorry for my english

kaspertje100 · Oct 27, 2010

andrew95434 said:
i have to copy this code into any place or i have to add it manaully?
please answer me, im searching for the answer for many time
sorry for my english

you should add it in your mysql database in http://localhost/phpmyadmin then go to your server and then click on SQL. then you see a blank field where you can type things paste it there and click start AND DONE;d

Now my questioon xD
Is this compitable with OTServ 0.6.3 rev 5791 by pietia10 client version 860/861 ty Kasper

TalkAction Improved Bounty-Hunter System by Tufte

New Member

Emporia

New Member

Emporia

Emporia

Intermediate OT User

Ø,ø

Emporia

Member

Need help? Just ask!

Member

Advanced OT User

Banned User

Formerly cbrm -Crypto enthusiast, Retired scripter

New Member

quepedo

New Member

Good Mapper

Banned User

Member

Similar threads