• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Losing shop points when you die?

spyk3z

spyk3z

Theós:Undying
Joined
Jul 23, 2007
Messages
385
Reaction score
90
Location
Home.
I've been searching for a few days and i've tried to create a few different scripts to no avail. So I was wondering if anyone knew how to do it and would help me with a script.
 
Sort by date Sort by votes
Shop points? As in points you get when donating? Isn't that a bit harsh?

If that's not the case I have no idea what you're talking about
 
Upvote 0 Downvote
Darad said:
Shop points? As in points you get when donating? Isn't that a bit harsh?

If that's not the case I have no idea what you're talking about
Click to expand...

Well yes that's what I'm talking about, and I'm going to edit it from shop points to another point system.
 
Upvote 0 Downvote
heres a example how you could do it (its not complete)
LUA: 
function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)
db.executeQuery("UPDATE `accounts` SET `premium_points` = "-1"   bla bla bla
end
 
Upvote 0 Downvote
chris77 the sql query need to be
LUA: 
function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)
    db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` -1 WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
    return TRUE
end
 
Upvote 0 Downvote
Back
Top