Skip to content

[Request] dvamp SQL fixes

Featured Replies

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?

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.