Bounty hunter for tfs 1.0

[HappyFeet]

I get this error....

[Error - mysql_real_query] Query: SELECT `bounty_hunters` WHERE `sp_id` = 10 AND `killed` = 0;
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `sp_id` = 10 AND `killed` = 0' at line 1
[Error - mysql_store_result] Query: SELECT `bounty_hunters` WHERE `sp_id` = 10 AND `killed` = 0;
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `sp_id` = 10 AND `killed` = 0' at line 1

can someone help me?

 

[Ninja]

Is this matter solved or just incorrect prefix?

Anyway add * FROM into the query, SELECT * FROM `bounty_hunters`

 

[HappyFeet]

already fixed it. I forgot * FROM before SELECT

new problem..

the talkaction part works but when I kill the player that is hunted I get this message in my console:

Lua Script Error: [CreatureScript Interface]
data/creaturescripts/scripts/others/playerdeath.lua:eek:nDeath
data/creaturescripts/scripts/others/playerdeath.lua:74: attempt to index a nil value
stack traceback:
[C]: in function '__index'
data/creaturescripts/scripts/others/playerdeath.lua:74: in function <data/creaturescripts/scripts/others/playerdeath.lua:4>

it does not give a reward and does not update the bounty_hunters table.

I hope someone can help me

 

[HappyFeet]

bump