Problem Premium scroll script !

Sami_san · May 30, 2016

Hello i have this premium scroll script that on use gives premium points to the ots shop but when i run the server i get an error of db.executeQuery nill value

local points = 30 -- amount of premium points

function onUse(cid, item, fromPosition, itemEx, toPosition)
if isPlayer(cid) == TRUE then
local Sql = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)
db.executeQuery(Sql)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received 10 Premium Point")
doRemoveItem(item.uid)
end
return true
end

Nekiro · May 30, 2016

Try zothion's script

Sami_san · May 30, 2016

on your script i cant use the item . i just press use and nothing happens . no message in the console and no points in the shop. I dont even get a message you cant use that object.

Zothion · May 30, 2016

try

Code:

local addpoints = 10 -- amount of points to add

function onUse(player, item, fromPosition, target, toPosition, isHotkey)
if isPlayer(player) and doRemoveItem(item.uid, 1) then
db.query("UPDATE `accounts` SET `points` = `points` + "..addpoints.." WHERE `id` = '" ..getAccountNumberByPlayerName(player:getName()).. "';")
doPlayerSendTextMessage(player, MESSAGE_STATUS_CONSOLE_ORANGE, ""..addpoints.." premium points have been added to your account.")
return true
else
return false
end
end

Zothion · May 30, 2016

i just tried it, and the scripts executes fine on my 1.2 tfs server, however i get a query error (since i dont have a points field..)

Nekiro · May 30, 2016

Zothion said:
i just tried it, and the scripts executes fine on my 1.2 tfs server, however i get a query error (since i dont have a points field..)

I think its because of his sources.

Zothion · May 30, 2016

Thexamx said:
I think its because of his sources.

yep, it works fine for me other than the fact that my database doesnt have a points field lol

Sami_san · May 30, 2016

Can i get sources link for my tfs 1.2 please? Please guys.
And using those sources wont override scripts i added to my ots will they?

Sami_san · May 31, 2016

@Zothion thanks mate your script worked after o noticed that it edits and updates a points column which i dont have cause i got premium_points haha

CLOSED

Problem Premium scroll script !

Sami_san

New Member

Nekiro

Legendary OT User

Sami_san

New Member

Zothion

Veteran OT User

Zothion

Veteran OT User

Nekiro

Legendary OT User

Zothion

Veteran OT User

Sami_san

New Member

Sami_san

New Member

Similar threads