Solved Donation NPC dosent work

Tjockis · Aug 8, 2013

So my donation NPC that will sel Don items for premium points will not wok.

I can talk to him and se the list of items he sells and so, but when I try to buy a item he tells me that i dont have premium points to buy it but I have premium points at the website .

No erros or somthing like that

Script

Code:

<?xml version="1.0" encoding="UTF-8"?>
<npc name="Donation Shop" script="donations.lua" walkinterval="2000" floorchange="0">
	<health now="100" max="100"/>
	<look type="130" head="114" body="113" legs="114" feet="114" addons="3"/>
	<parameters>
		<parameter key="message_greet" value="Hello |PLAYERNAME|, You can {buy} items from me for premium points. You can see in the {list} which items you can buy."/>
	</parameters>
</npc>

Code:

local keywordHandler = KeywordHandler:new()
local npcHandler = NpcHandler:new(keywordHandler)
NpcSystem.parseParameters(npcHandler)
local talkState = {}
 
function onCreatureAppear(cid)				npcHandler:onCreatureAppear(cid) end
function onCreatureDisappear(cid)			npcHandler:onCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg)			npcHandler:onCreatureSay(cid, type, msg) end
function onThink()					npcHandler:onThink() end
 
local function getPremiumPoints(cid)
    local res = db.getResult('select `premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'')
    if(res:getID() == -1) then
       return 0
    end
    local ret = res:getDataInt("premium_points")
    res:free()
    return tonumber(ret)
end
 
function creatureSayCallback(cid, type, msg)
	if(not npcHandler:isFocused(cid)) then
		return false
	end
 
	local talkUser = NPCHANDLER_CONVBEHAVIOR == CONVERSATION_DEFAULT and 0 or cid
 
local items = {
	["Thaian Sword"] = {points = 100, itemid = 7391}, 	
	["Golden Helmet"] = {points = 100, itemid = 2471} 
}
 
 	local function addCptl(first, rest)
  		return first:upper()..rest:lower()
	end
 
	local x = items[msg:gsub("(%a)([%w_']*)", addCptl)]
 
	local buy = (msgcontains(msg, 'buy'))
	if buy then
		selfSay('Which donate item would you like to buy?', cid)
		talkState[talkUser] = 2
	end
 
	if x and talkState[talkUser] >= 1 then 
		selfSay('Do you want to buy 1 '..msg..' for '..x.points..' premium points?', cid)
		xmsg = msg
		talkState[talkUser] = 3
	end
	local agree = (msgcontains(msg, 'yes'))
	if agree and talkState[talkUser] == 3 then 
		x = items[xmsg:gsub("(%a)([%w_']*)", addCptl)]
		if getPremiumPoints(cid) >= x.points then
			selfSay('Here you are, have fun with it.', cid)
 			doPlayerAddItem(cid, x.itemid, 1)
			db.executeQuery('UPDATE accounts SET premium_points=premium_points-'..x.points..' WHERE id=' .. getPlayerAccountId(cid))
			talkState[talkUser] = 1
		else
			selfSay('You don\'t have enough points.', cid)
			talkState[talkUser] = 1
		end
	end
 
	local list = (msgcontains(msg, 'list'))
	if list then
	text = 'Donation Items\n'
		for i, x in pairs(items) do
				text = text .. "\n" .. i .. " - "..x.points.." points"
		end
		doShowTextDialog(cid, 7391, "" .. text)
		talkState[talkUser] = 1
	end
 
	if not x and not list and not buy and not agree and talkState[talkUser] == 2 then
		selfSay('You can\'t buy this item from me, look in the {list} which items you can buy.', cid)
	elseif not x and not list and not buy and not agree and talkState[talkUser] ~= 2 then
		selfSay('What? I don\'t understand what you mean with '..msg..'.', cid)
	end
	return true
end
 
npcHandler:setCallback(CALLBACK_MESSAGE_DEFAULT, creatureSayCallback)
npcHandler:addModule(FocusModule:new())

Rep++

Tnx Tjockis.

Ninja · Aug 8, 2013

Replace

Code:

local res = db.getResult('select `premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'')

with

Code:

local res = db.getResult('SELECT premium_points FROM accounts WHERE id = '..getPlayerAccountId(cid))

Tjockis · Aug 9, 2013

Ninja said:

Replace

Code:

local res = db.getResult('select `premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'')

with

Code:

local res = db.getResult('SELECT premium_points FROM accounts WHERE id = '..getPlayerAccountId(cid))

Same problem ,
At the website I have , You have 500 points. (Buy points).

Ingame when U use !pointbalance 00:33 You currently have 0 points on your account!

Can it be that I use znonte acc or somthing ? cuz its more tabels and shit with that :S

Ninja · Aug 9, 2013

You should have mentioned that before.

Lua:

local res = db.getResult('SELECT points FROM znote_accounts WHERE account_id = '..getPlayerAccountId(cid))

db.executeQuery('UPDATE znote_accounts SET points=points-'..x.points..' WHERE account_id=' .. getPlayerAccountId(cid))

Tjockis · Aug 9, 2013

Ninja said:

You should have mentioned that before.

Lua:

local res = db.getResult('SELECT points FROM znote_accounts WHERE account_id = '..getPlayerAccountId(cid))

db.executeQuery('UPDATE znote_accounts SET points=points-'..x.points..' WHERE account_id=' .. getPlayerAccountId(cid))

Ok , so I just replace
This

Code:

local res = db.getResult('select `premium_points` from accounts where name = \''..getPlayerAccount(cid)..'\'')

With This?

Code:

local res = db.getResult('SELECT points FROM znote_accounts WHERE account_id = '..getPlayerAccountId(cid))
 
db.executeQuery('UPDATE znote_accounts SET points=points-'..x.points..' WHERE account_id=' .. getPlayerAccountId(cid))

Ninja · Aug 9, 2013

Lua:

local keywordHandler = KeywordHandler:new()
local npcHandler = NpcHandler:new(keywordHandler)
NpcSystem.parseParameters(npcHandler)
local talkState = {}
 
function onCreatureAppear(cid)                npcHandler:onCreatureAppear(cid) end
function onCreatureDisappear(cid)            npcHandler:onCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg)            npcHandler:onCreatureSay(cid, type, msg) end
function onThink()                    npcHandler:onThink() end
 
local function getPremiumPoints(cid)
    local res = db.getResult('SELECT points FROM znote_accounts WHERE account_id = '..getPlayerAccountId(cid))
    if(res:getID() == -1) then
       return 0
    end
    local ret = res:getDataInt("points")
    res:free()
    return tonumber(ret)
end
 
function creatureSayCallback(cid, type, msg)
    if(not npcHandler:isFocused(cid)) then
        return false
    end
 
    local talkUser = NPCHANDLER_CONVBEHAVIOR == CONVERSATION_DEFAULT and 0 or cid
 
local items = {
    ["Thaian Sword"] = {points = 100, itemid = 7391},     
    ["Golden Helmet"] = {points = 100, itemid = 2471} 
}
 
     local function addCptl(first, rest)
          return first:upper()..rest:lower()
    end
 
    local x = items[msg:gsub("(%a)([%w_']*)", addCptl)]
 
    local buy = (msgcontains(msg, 'buy'))
    if buy then
        selfSay('Which donate item would you like to buy?', cid)
        talkState[talkUser] = 2
    end
 
    if x and talkState[talkUser] >= 1 then 
        selfSay('Do you want to buy 1 '..msg..' for '..x.points..' premium points?', cid)
        xmsg = msg
        talkState[talkUser] = 3
    end
    local agree = (msgcontains(msg, 'yes'))
    if agree and talkState[talkUser] == 3 then 
        x = items[xmsg:gsub("(%a)([%w_']*)", addCptl)]
        if getPremiumPoints(cid) >= x.points then
            selfSay('Here you are, have fun with it.', cid)
             doPlayerAddItem(cid, x.itemid, 1)
            db.executeQuery('UPDATE znote_accounts SET points=points-'..x.points..' WHERE account_id=' .. getPlayerAccountId(cid))
            talkState[talkUser] = 1
        else
            selfSay('You don\'t have enough points.', cid)
            talkState[talkUser] = 1
        end
    end
 
    local list = (msgcontains(msg, 'list'))
    if list then
    text = 'Donation Items\n'
        for i, x in pairs(items) do
                text = text .. "\n" .. i .. " - "..x.points.." points"
        end
        doShowTextDialog(cid, 7391, "" .. text)
        talkState[talkUser] = 1
    end
 
    if not x and not list and not buy and not agree and talkState[talkUser] == 2 then
        selfSay('You can\'t buy this item from me, look in the {list} which items you can buy.', cid)
    elseif not x and not list and not buy and not agree and talkState[talkUser] ~= 2 then
        selfSay('What? I don\'t understand what you mean with '..msg..'.', cid)
    end
    return true
end
 
npcHandler:setCallback(CALLBACK_MESSAGE_DEFAULT, creatureSayCallback)
npcHandler:addModule(FocusModule:new())

Tjockis · Aug 9, 2013

Ninja said:

Lua:

local keywordHandler = KeywordHandler:new()
local npcHandler = NpcHandler:new(keywordHandler)
NpcSystem.parseParameters(npcHandler)
local talkState = {}
 
function onCreatureAppear(cid)                npcHandler:onCreatureAppear(cid) end
function onCreatureDisappear(cid)            npcHandler:onCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg)            npcHandler:onCreatureSay(cid, type, msg) end
function onThink()                    npcHandler:onThink() end
 
local function getPremiumPoints(cid)
    local res = db.getResult('SELECT points FROM znote_accounts WHERE account_id = '..getPlayerAccountId(cid))
    if(res:getID() == -1) then
       return 0
    end
    local ret = res:getDataInt("points")
    res:free()
    return tonumber(ret)
end
 
function creatureSayCallback(cid, type, msg)
    if(not npcHandler:isFocused(cid)) then
        return false
    end
 
    local talkUser = NPCHANDLER_CONVBEHAVIOR == CONVERSATION_DEFAULT and 0 or cid
 
local items = {
    ["Thaian Sword"] = {points = 100, itemid = 7391},     
    ["Golden Helmet"] = {points = 100, itemid = 2471} 
}
 
     local function addCptl(first, rest)
          return first:upper()..rest:lower()
    end
 
    local x = items[msg:gsub("(%a)([%w_']*)", addCptl)]
 
    local buy = (msgcontains(msg, 'buy'))
    if buy then
        selfSay('Which donate item would you like to buy?', cid)
        talkState[talkUser] = 2
    end
 
    if x and talkState[talkUser] >= 1 then 
        selfSay('Do you want to buy 1 '..msg..' for '..x.points..' premium points?', cid)
        xmsg = msg
        talkState[talkUser] = 3
    end
    local agree = (msgcontains(msg, 'yes'))
    if agree and talkState[talkUser] == 3 then 
        x = items[xmsg:gsub("(%a)([%w_']*)", addCptl)]
        if getPremiumPoints(cid) >= x.points then
            selfSay('Here you are, have fun with it.', cid)
             doPlayerAddItem(cid, x.itemid, 1)
            db.executeQuery('UPDATE znote_accounts SET points=points-'..x.points..' WHERE account_id=' .. getPlayerAccountId(cid))
            talkState[talkUser] = 1
        else
            selfSay('You don\'t have enough points.', cid)
            talkState[talkUser] = 1
        end
    end
 
    local list = (msgcontains(msg, 'list'))
    if list then
    text = 'Donation Items\n'
        for i, x in pairs(items) do
                text = text .. "\n" .. i .. " - "..x.points.." points"
        end
        doShowTextDialog(cid, 7391, "" .. text)
        talkState[talkUser] = 1
    end
 
    if not x and not list and not buy and not agree and talkState[talkUser] == 2 then
        selfSay('You can\'t buy this item from me, look in the {list} which items you can buy.', cid)
    elseif not x and not list and not buy and not agree and talkState[talkUser] ~= 2 then
        selfSay('What? I don\'t understand what you mean with '..msg..'.', cid)
    end
    return true
end
 
npcHandler:setCallback(CALLBACK_MESSAGE_DEFAULT, creatureSayCallback)
npcHandler:addModule(FocusModule:new())

Tnx man

rep ^^

Solved Donation NPC dosent work

Tjockis

New Member

Ninja

Global Moderator

Tjockis

New Member

Ninja

Global Moderator

Tjockis

New Member

Ninja

Global Moderator

Tjockis

New Member

Similar threads