[Help] L2off Interlude Dvamp 1.75Dll unbelieveable error

[sublixo]

Hi guys,

I'm having this issue in my l2off Interlude Dvamp 1.75Dll (By Shakal), I thing this is a database error. When I create a character, i can create varios without the same name restriction... also when i delete the character, there's no time for waiting for deletion, it's istantly.

 

Can anyone help me?

 

PS of My Client, L2Server and CacheD.

 

 

 

 

 

Thanks in advance.

 

 

[manton]

1) Check if namn exist. lin_CreateChar

 

if exists(select char_name from user_data (nolock) where char_name = @char_name)  

begin  

RETURN -1  

end

 

2) delete the character, there's no time for waiting for deletion, it's istantly

 

GM Account?

[kelviow2]

KEYs mssql :D

[rtoservers]

after restart character goback for level 1, what s the solution problem?

the server s perfeit... more s this trouble?

thx

[nightkhaos]

i have the same problem, as manton said it must be a name mismatch in SQL ... look in SCRIPT "7 lin2world"

and check the procedure "lin.CreateChar" for parameter mismatch or smth else

[nightkhaos]

1) Check if namn exist. lin_CreateChar

 

if exists(select char_name from user_data (nolock) where char_name = @char_name) 

begin 

RETURN -1 

end

 

2) delete the character, there's no time for waiting for deletion, it's istantly

 

GM Account?

 

This will work but in the case you have 4000 people online you must do a select in huge table, because we are not using the user_reserved  table..So if someone has a optimzed solution post it here, becouse i have the same problem