Shop Points at a Certain level doesn't work

[Tyson12302]

I searched a couple scripts where you get Shop points at a certain level here is the script that i have in my creaturescripts/scripts/points.lua.

local t, storage = {
{30, 30},
{190, 30},
{220, 30},
{250, 30},
{280, 30},
{300, 30},
{315, 30},
{330, 30}
}, 256

function onAdvance(cid, skill, oldLevel, newLevel)
if skill ~= SKILL__LEVEL then
return true
end
for i = 1, #t do
local v = t
if newLevel >= v[1] and getStorage(storage) < i then
db.executeQuery('UPDATE accounts SET premium_points=premium_points+'.. v[2] ..' WHERE id=' .. getPlayerAccountId(cid))
doSetStorage(storage, i)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have earned '.. v[2] ..' Premium Points!')
doBroadcastMessage('Congratulations! ' .. getCreatureName(cid) .. ' advenced to ' .. v[1] .. 'lvl and got ' .. v[2] .. ' ptz to sms shop.')
break
end
end
return true
end

login.lua

registerCreatureEvent(cid, "ReportBug")
    registerCreatureEvent(cid, "AdvanceSave")
    registerCreatureEvent(cid, "PlayerAdvance")
    registerCreatureEvent(cid, "Inq")
    registerCreatureEvent(cid, "death")
    return true
end

And creaturescript.xml

<event type="advance" name="pointsforlvl" event="script" value="points.lua"/>

I get a error in the console when i reach the level.
"attempt to compare table with numbers"

 

[Limos]

Best is to post the full error for next time and always post your server version, in every thread.

Change t to

t[i]

in local v = t

 

[Ninja]

L17, change

local v = t

to

local v = t[i]

 

[Tyson12302]

[08/06/2015 18:08:00] [Error - CreatureScript Interface]
[08/06/2015 18:08:00] data/creaturescripts/scripts/points.luanAdvance
[08/06/2015 18:08:00] Description:
[08/06/2015 18:08:01] data/creaturescripts/scripts/points.lua:18: attempt to compare table with number
[08/06/2015 18:08:01] stack traceback:
[08/06/2015 18:08:01] data/creaturescripts/scripts/points.lua:18: in function <data/creaturescripts/scripts/points.lua:12>

Tibia Version 8.6/ 0.3.6

I'll try out that. I'll report back if it works.

The Red Broadcast worked when i reached the level, BUT the points dont appear online? Do i have to wait a certain time or are they meant to appear straight away?
I get this error on the console [08/06/2015 18:15:54] mysql_real_query(): UPDATE accounts SET premium_points=premium_points+30 WHERE id=3 - MYSQL ERROR: Unknown column 'premium_points' in 'field list' (1054)

 

[Limos]

ALTER TABLE `accounts` ADD `premium_points` INT NOT NULL DEFAULT 0;

https://otland.net/threads/mysql-how-to-run-a-query.177833/

 

[Tyson12302]

The error is gone, But the Points still didn't arrive in the Shop. I get the Broadcast message but the points down appear online.

 

[Limos]

In which shop? Make sure it's using the same column for premium points, else change the column name in the Lua script.

 

[Tyson12302]

The Website Shop where people can buy items listed on the website.

local t, storage = {
{38, 30},
{40, 30},
{220, 30},
{250, 30},
{280, 30},
{300, 30},
{315, 30},
{330, 30}
}, 256

function onAdvance(cid, skill, oldLevel, newLevel)
if skill ~= SKILL__LEVEL then
return true
end
for i = 1, #t do
local v = t[i]
if newLevel >= v[1] and getStorage(storage) < i then
db.executeQuery('UPDATE accounts SET premium_points=premium_points+'.. v[2] ..' WHERE id=' .. getPlayerAccountId(cid))
doSetStorage(storage, i)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have earned '.. v[2] ..' Premium Points!')
doBroadcastMessage('Congratulations! ' .. getCreatureName(cid) .. ' advenced to ' .. v[1] .. 'lvl and got ' .. v[2] .. ' ptz to sms shop.')
break
end
end
return true
end

where do i put the column on here?

I made the column with the same name and is still doesnt work.

 

[Limos]

Look which column it is using and use that column name in the Lua script instead of premium_points.

 

[Tyson12302]

Here is the column i am using on phpmyadmin

And im using that on the lua file as you can see from my other post.

 

[Limos]

I mean the one from your shop.

 

[Tyson12302]

So this right?

If yes then can you please copy my code and paste it with my new column because i get mixed up with it. Thanks

 

[Limos]

If that is the one your shop is using than just change premium_points to points in your Lua script.

 

[Tyson12302]

Alright i tried it with the SQL Code and it said that the Column Points doenst exist in the field list when it does. Heres the proof. Yeah i get this error again in console when getting the level, [08/06/2015 19:24:44] mysql_real_query(): UPDATE accounts SET points=points+30 WHERE id=3 - MYSQL ERROR: Unknown column 'points' in 'field list' (1054)

 

[Tyson12302]

When i browse the points this is what it shows me

. Doesn't this mean that i got 30 points, but i actually dont.

 

[StreamSide]

[08/06/2015 19:24:44] mysql_real_query(): UPDATE accounts SET points=points+30 WHERE id=3 - MYSQL ERROR: Unknown column 'points' in 'field list' (1054)
lets take a look, thats says "points" in "accounts" ya?
and ur script says "premium_points"
points and premium_points are 2 different things

 

[Tyson12302]

I changed them all. I just figured out that a SQL code that acutally works here it is

UPDATE`otserv`.`znote_accounts`SET`points`='70'WHERE`znote_accounts`.`points`=60LIMIT1;

This code works if i use it. How can i implement this to the LUA script?

 

[Limos]

Just change accounts to znote_accounts and premium_points to points in the Lua script.

 

[Tyson12302]

The SQL code works now let me try it with the Shop points Script on the server sec

 

[Tyson12302]

I changed it and tried it on a different account and now it doesn't even broadcast the message when i get the level. It only works on 1 account. When i try it on other accounts it doesnt work.