Jump to content

[HELP]executeSQLUpdate() error


InDev

Recommended Posts

Posted

Yes, again SQL...

I have a probleme with an executeSQLUpdate i made, i tried many solutions but all of them can't repaired the error

The script:

executeSQLUpdate( "MTA_players"," Level="..tonumber(level)..", Membre="..tonumber(membre)..", Rang="..tonumber(rang)..",  HeuresJ='"..tonumber(heuresj).."', Morts="..tonumber(morts)..",  Meurtres="..tonumber(meurtres)..",  Money="..tonumber(money)..",  Car='"..tonumber(car).."', House="..tonumber(house)..", Biz="..tonumber(biz)..", Admin="..tonumber(admin)..",  Age="..tonumber(age)..",  Banque="..tonumber(banque)..",  Sexe="..tonumber(sexe)..",  Activated="..tonumber(sexe)..",  Skin="..tonumber(skin)..",  Job="..tonumber(job)..",  Respect="..tonumber(respect)..",  Crimes="..tonumber(crimes)..", PermisV="..tonumber(PermisV)..",  PermisAv="..tonumber(PermisAv).."',  PermisAr="..tonumber(PermisAr)..", PermisB="..tonumber(PermisB)..", PermisM="..tonumber(PermisM)..", PermisCa="..tonumber(PermisCa)..", PermisCe='"..tonumber(PermisCe).." ","Password='"..pass.."'" )

This is a french one so if you don't understand the whole thing it's normal :lol:

The error message is:

attempt to concatenate a nil value

If someone can help...

Welcome to the beginning...

Posted

Remove the tonumber calls for one (they're completely useless and can be the source for the error) and if you want people to understand your script, script in English.

Do NOT PM ME for help unless invited. - New MTA Script Editor

Scripting help "etiquette": understandable language, relevant code (ALL code if unsure), [Lua] tags, error messages with line numbers. Super simple stuff.

Posted

Ok thx it's helping me, after this error i had an other but it's ok i used string.format i like this function ><

Thanks for all

Edit:

and if you want people to understand your script, script in English.

I don't want people, except me, to understand my script, unfortunately i need help sometimes and must show my french script :mrgreen:

Welcome to the beginning...

Posted
I don't want people, except me, to understand my script, unfortunately i need help sometimes and must show my french script :mrgreen:

And that means we need to understand your script. Script in English..

Do NOT PM ME for help unless invited. - New MTA Script Editor

Scripting help "etiquette": understandable language, relevant code (ALL code if unsure), [Lua] tags, error messages with line numbers. Super simple stuff.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...