Points in game!

[dervin13]

Anyone can help me with one talkaction who player can see how much points they have in account??

Like !checkpoints.

And appear in game: You have 30 premium points.

ty

 

[Wymietek]

You need to do a talkactions what will get it from db smth like that

'SELECT `premium_points` FROM `account`s WHERE `id` = ' ..AccID

I wont do it for u cuz u will never learn anything.

 

[dervin13]

If i post here, i tried before!

If you dont wanna help, pls dont post!

ty

You need to do a talkactions what will get it from db smth like that

'SELECT `premium_points` FROM `account`s WHERE `id` = ' ..AccID

I wont do it for u cuz u will never learn anything.

 

[nsanee]

function onSay(cid, words, param)
	res = db.getResult('select premium_points from accounts where id = '..getPlayerAccountId(cid))
	if res:getID() ~= -1 then
		doPlayerPopupFYI(cid, 'You have '..res:getDataInt('premium_points') ..' premium points.')
	else
		doPlayerPopupFYI(cid, 'Database error, contact server administrator.')
	end
	return TRUE
end

 

[dervin13]

Ty nsanee!

Like always you are helping a lot!

function onSay(cid, words, param)
	res = db.getResult('select premium_points from accounts where id = '..getPlayerAccountId(cid))
	if res:getID() ~= -1 then
		doPlayerPopupFYI(cid, 'You have '..res:getDataInt('premium_points') ..' premium points.')
	else
		doPlayerPopupFYI(cid, 'Database error, contact server administrator.')
	end
	return TRUE
end