Lua DoAccountAddPremium_points??

[Ataro]

Is there an lua script for that?
I want that if you say example: !test
you loose 5 premium points.
This is not working:

  if doPlayerAccountAddPremium_Points(cid, -5) == true then

Neither is:

  if doAccountAddPremium_Points(cid, -5) == true then

Full script:

function onSay(cid, words, param)

local test = 8931

  if doPlayerAccountAddPremium_Points(cid, -5) == true then
	doPlayerPopupFYI(cid, "Working :O ")
	doPlayerAddItem(cid, test, 1)
	doSendMagicEffect(getCreaturePosition(cid), CONST_ME_MAGIC_BLUE)
  else
	doPlayerSendCancel(cid, "Sorry, test error xD .")
  end
return true
end

Someone can help me?

 

[SpiderOT]

doPlayerRemovePremiumDays(cid, days)

 

[Chris]

Premium days and premium points are not the same though. There's no function like that in the original TFS revs as of yet (if ever. Remember that the premium points field is not an official database field).

 

[Ataro]

isnt there a way to use it??

 

[Chris]

You can create a new function, creating a database connection (unless there's a global one? doubt it though) and run a query to remove the number of days specified through a parameter.

 

[Ataro]

Dont get it totally
Got some scipts mayby? else another explaination?

 

[Chris]

I'm afraid I do not have a script for it, sorry.
It would look something like this though (I'm not actually creating the script, so do not try to use the following code, it is merely an example):

function doAddAccountPremiumPoints(account, points)
     local db = databaseConnectionHere
     if not db.query("query here") then
          doSendCancel(cid, "Sorry, it failed")
     end

     doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "It worked!")
     return TRUE
end

 

[Ataro]

so for me it would be like:

function doAddAccountPremiumPoints(account, points)
     local db = databaseConnectionHere
     if not db.query("premium_points") then
          doSendCancel(cid, "Sorry, it failed")
     end
 
     doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "It worked!")
     return TRUE
end

where to put it? xDD
??

 

[Chris]

I'm not sure how the database connection works with LUA as I haven't really used it. And I haven't done any LUA scripts for slightly over a year. It might not even be db.query to execute a query. As I stated in my above post, this was merely an example. Not an actual functioning script.

 

[Ataro]

alright

 

[Fallen]

function doAddAccountPremiumPoints(account, points)
	local p = ""
	if tostring(points):sub(1, 2) == "-" then
		p = "-";
	elseif tostring(points):sub(1, 2) == "+" then
		p = "+";
	end
	local query = "UPDATE `accounts` SET `premdays` = `premdays` " .. p .. " " .. tostring(points):sub(2) .. " WHERE `account` = " .. account .. ";"
	if not db.executeQuery(query) then
		return false
	end
	return true
end

not tested

 

[SpiderOT]

open lib/function.lua
and add this code

function addpremiumpoint(cid,amount)
local getpoint = getPlayerAccount(cid)
local Info = db.getResult("SELECT * FROM `accounts` WHERE `name` = '"..getpoint.."'")
point = tonumber(Info:getDataInt("premium_points"))
name = tonumber(Info:getDataInt("name"))
newpoint = point + amount 
db.executeQuery("UPDATE `accounts` SET `premium_points` ='"..newpoint.."' WHERE `name` = '"..name.."'")
return true 
end
function removepremiumpoint(cid,amount)
local getpoint = getPlayerAccount(cid)
local Info = db.getResult("SELECT * FROM `accounts` WHERE `name` = '"..getpoint.."'")
point = tonumber(Info:getDataInt("premium_points"))
name = tonumber(Info:getDataInt("name"))
newpoint = point - amount 
db.executeQuery("UPDATE `accounts` SET `premium_points` ='"..newpoint.."' WHERE `name` = '"..name.."'")
return true 
end

now to add premium point to player use this

addpremiumpoint(cid, amount)

and to remove point use this

removepremiumpoint(cid, amount)

 

[Chris]

function doAddAccountPremiumPoints(account, points)
	local p = ""
	if tostring(points):sub(1, 2) == "-" then
		p = "-";
	elseif tostring(points):sub(1, 2) == "+" then
		p = "+";
	end
	local query = "UPDATE `accounts` SET `premdays` = `premdays` " .. p .. " " .. tostring(points):sub(2) .. " WHERE `account` = " .. account .. ";"
	if not db.executeQuery(query) then
		return false
	end
	return true
end

not tested

Now this is more like it! Although, I would change elseif tostring(points):sub(1, 2) == "+" then to else. Otherwise he would have to do +1, +2, +3 whenever he would like to actually add points.

 

[Cykotitan]

Or simply this instead..

function doAddPremiumPoints(accountName, points)
	points = tostring(points)
	return db.executeQuery('UPDATE `accounts` SET `premium_points` = `premium_points` ' .. (not points:find('^%-') and '+' or '-') .. points:sub(points:find('%d+')) .. ' WHERE `name` = ' .. accountName .. ' LIMIT 1;')
end

To remove, just place a - in front of the number.