Lua tfs 1.2 looking for the line which make ppl downgrade 1 level

[StevenTrembly]

am looking for the line which let ppl lose 1 level for TFS 1.2

if bla bla bla
player:something (downgrade -1)
end

thanks

 

[Itutorial]

What TFS are you using?

 

[StevenTrembly]

as titled said
tfs 1.2

 

[Itutorial]

My bad, dont think you can without making player log out first in TFS 1.2

 

[StevenTrembly]

yea its okay i just need the line for it

 

[Itutorial]

db.executeQuery("UPDATE `players` SET `level` = level - 1 WHERE `id` = " ..player:getGUID().. ";")

 

[Michael Orsino]

Or something like this:

  local function getExpForLevel(level)
    level = level - 1
    return ((50 * level * level * level) - (150 * level * level) + (400 * level)) / 3
  end

  player:removeExperience(player:getExperience - getExpForLevel(player:getLevel() - 1))

 

[whitevo]

Or something like this:

  local function getExpForLevel(level)
    level = level - 1
    return ((50 * level * level * level) - (150 * level * level) + (400 * level)) / 3
  end

  player:removeExperience(player:getExperience - getExpForLevel(player:getLevel() - 1))

I recently made so everything in my server gives percent experience, seems to work perfectly.

Mdwilliams piece of code is exactly what you need.

 

[StevenTrembly]

Or something like this:

  local function getExpForLevel(level)
    level = level - 1
    return ((50 * level * level * level) - (150 * level * level) + (400 * level)) / 3
  end

  player:removeExperience(player:getExperience - getExpForLevel(player:getLevel() - 1))

do player need to be offline for this ?

 

[Michael Orsino]

Nope, you can do this with the player online. =]

 

[StevenTrembly]

error it says bad expected behind "-" which is in line

player:removeExperience(player:getExperience - getExpForLevel(player:getLevel() - 1))

 

[Jano]

player:getExperience -> player:getExperience()

 

[Michael Orsino]

Yeah, sorry about that - I wrote it out on my phone and missed the parenthesis

 

[silveralol]

db.executeQuery("UPDATE `players` SET `level` = level - 1 WHERE `id` = " ..player:getGUID().. ";")

please don't use it man, you downgrade the level but the health. mana, and cap is not changed.

 

[StevenTrembly]

Yeah, sorry about that - I wrote it out on my phone and missed the parenthesis

can u re fix it please ?

 

[Itutorial]

player:removeExperience(player:getExperience() - getExpForLevel(player:getLevel() - 1))