Solved Help convert to lua

[Sigoles]

I have this script:

function onKill(creature, target)
    if target:isPlayer() and target:getLevel() >= 200 then
        creature:setStorageValue(167912, math.max(0, creature:getStorageValue(167912)) + 1)
  
         db.query("UPDATE `players` SET `frag_points` = `frag_points` + '1' WHERE `name` = '"..creature:getName().."';")
    end
    return true
end

I got this error, because the name have symbol:

And I want to put something like this (in C++):

std::ostringstream query;
    std::string escapedName = Database::getInstance()->escapeString(getPlayerName());
    query << "UPDATE `players` SET `frag_points`=`frag_points` + '1' WHERE
"<< escapedName << ", .............

Help to fix this please

 

[slaw]

Use db.escapeString

like this:

function onKill(creature, target)
   if target:isPlayer() and target:getLevel() >= 200 then
        creature:setStorageValue(167912, math.max(0, creature:getStorageValue(167912)) + 1)
       
         db.query("UPDATE `players` SET `frag_points` = `frag_points` + '1' WHERE `name` = '"..db.escapeString(creature:getName()).."';")
    end
    return true
end

 

[Sigoles]

Use db.escapeString

like this:

function onKill(creature, target)
   if target:isPlayer() and target:getLevel() >= 200 then
        creature:setStorageValue(167912, math.max(0, creature:getStorageValue(167912)) + 1)
      
         db.query("UPDATE `players` SET `frag_points` = `frag_points` + '1' WHERE `name` = '"..db.escapeString(creature:getName()).."';")
    end
    return true
end

Hey man, thanks I'll test

I was tested and got this error look please:

@slawkens

 

[slaw]

Hey man, thanks I'll test

I was tested and got this error look please:

@slawkens

Try now:

function onKill(creature, target)
  if target:isPlayer() and target:getLevel() >= 200 then
        creature:setStorageValue(167912, math.max(0, creature:getStorageValue(167912)) + 1)
      
         db.query("UPDATE `players` SET `frag_points` = `frag_points` + '1' WHERE `name` = "..db.escapeString(creature:getName())..";")
    end
    return true
end

 

[Sigoles]

thanks works