[Request] dvamp SQL fixes

[sickbastard]

Could someone share the dvamp 1.75mb SQL fixes?

For example the fix for the lin_SaveCharacter SP (so that the char wont lose his exp, sp, loc, etc..)

Also im missing the lin_ReloadRatedByAccountID SP and a fix for lin_UpdateActiveSKill, lin_CrateActiveSkill too many arguments error.

 

I tried to correct them myself but i dont know the datatypes of the extra SP arguments.

 

Anyway, little help would be greatly appreciated. Ty.

 

- Edit -

 

Ok, i read the cache error log and figured my lin_SaceCharacter SP is missing 11 arguments, which i found in advext forum that they are:

@ST_HairAll INT,

@ST_Agathon INT,

@ST_LeftBracelet INT,

@ST_RightBracelet INT,

@ST_Talisman1 INT,

@ST_Talisman2 INT,

@ST_Talisman3 INT,

@ST_Talisman4 INT,

@ST_Talisman5 INT,

@ST_Talisman6 INT,

@Souls INT

 

so i also added these extra 11 columns to my user_data table.

But now im getting cache error:

 

09/03/2012 18:29:30.171, Error sql: EXEC lin_SaveCharacter 0,0,93,1,-71453,258305,-3104,0,4484.198000,1607.808000,4484.198000,1607.808000,0,6000000000,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,0,0,1,93,-1,-1,-1,1793.679200,1793.679200,0,0,0,0,0,0,0,0,0,16777215,0,0,103795584,0,0,0,0,0,0,0,0,0 (0)

09/03/2012 18:29:30.187, Error 42000:[Microsoft]

[sql Server][u]Error converting data type numeric to int.[/u]

 

So the new argument datatypes are false? All of them or some? Any help?