[HELP]Starting Characters

01/14/2013 17:47 gedimazs#1
hi it's me again. Have you noticed guys that new classes characters appears with no weapon or skills even if you did it to their main [DEV] characters.
I have used those suggested lines:

Code:
DEKARON0000001  	[DEV]KNIGHT	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    336     363     336     366     7       7       0       4000    200     0       10      0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON10000001 	[DEV]CONCERRA	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    354     146     354     146     7       7       0       4000    200     10      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON1000001  	[DEV]HUNTER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    336     215     336     216     7       7       0       4000    200     1       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON11000001 	[DEV]SEGURIPER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     11      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON12000001 	[DEV]HALFBAGI	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     12      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON2000001  	[DEV]MAGICIAN	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     2       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON3000001  	[DEV]SUMMONER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     232     158     7       7       0       4000    200     3       117     0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON4000001  	[DEV]SEGNALLE	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     4       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON5000001  	[DEV]WARRIOR	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     5       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON6000001  	[DEV]ALLOKEN	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     6       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON9000001  	[DEV]DARKWIZARD	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     9       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
And what we notice that for example [DEV]CONCERRA or [DEV]SEGURIPER have longer character_no DEKARON11000001 by one number. So I'm guessing that it is the problem why they appear without any items we have gave them. I have checked user_suit and other tables so they are there.
So my thoughts are that the problem is in SP_CHAR_CREATE but need someone's help to find out where is the problem.
01/14/2013 17:56 conquer93#2
the start weap = User_suit
and skill user_skill

add it ther on ur dev chars and all chars will have it :P
01/14/2013 18:13 gedimazs#3
conquer93 I said that I have added to my dev chars but after creating new character you don't see added items. And this problem appears only for those which character_no is longer than others.

I think this part is responsible why I don't see added items to new classes with longer character_no than others:

Code:
-- ????? ???? ???? ??
	SET @rand_no = CAST(3*Rand()+1 as INT)
	SET @wh_char_no = 'DEKARON'+CAST(@v_byPCClass as varchar(2))+'000001'
01/15/2013 04:05 yamakuza#4
Quote:
Originally Posted by gedimazs View Post
conquer93 I said that I have added to my dev chars but after creating new character you don't see added items. And this problem appears only for those which character_no is longer than others.

I think this part is responsible why I don't see added items to new classes with longer character_no than others:

Code:
-- ????? ???? ???? ??
	SET @rand_no = CAST(3*Rand()+1 as INT)
	SET @wh_char_no = 'DEKARON'+CAST(@v_byPCClass as varchar(2))+'000001'
We have the same problem on starter pck.. I already added them on eah dev classes but only concerra,segeuriper and halfbagi isnt working.. hopefully there is someone can post a script about the this starter pck.
01/15/2013 11:05 gedimazs#5
Quote:
Originally Posted by yamakuza View Post
We have the same problem on starter pck.. I already added them on eah dev classes but only concerra,segeuriper and halfbagi isnt working.. hopefully there is someone can post a script about the this starter pck.
As I already mentioned this is because of longer character_no that these classes have cause their pcclass is 10,11 and 12
01/17/2013 08:25 fiore14#6
The solution to this is honestly quite simple. If you understand the code your looking at, you can quickly tell why its not working. Since, I'm not one to spoon-feed answers, I will tell you it has to do with one of the DECLARE lines in the stored procedure.

No one ever learned anything from being given the answer.

(Before people say "Oh, you don't know what your talking about", I have already fixed and tested this on my own test server.)
01/17/2013 10:06 gedimazs#7
Quote:
Originally Posted by fiore14 View Post
The solution to this is honestly quite simple. If you understand the code your looking at, you can quickly tell why its not working. Since, I'm not one to spoon-feed answers, I will tell you it has to do with one of the DECLARE lines in the stored procedure.

No one ever learned anything from being given the answer.

(Before people say "Oh, you don't know what your talking about", I have already fixed and tested this on my own test server.)
You are talking about SP_CHAR_CREATE stored procedure?

Edited: Thanks I have found the problem and solved.
01/17/2013 13:52 yamakuza#8
Quote:
Originally Posted by fiore14 View Post
The solution to this is honestly quite simple. If you understand the code your looking at, you can quickly tell why its not working. Since, I'm not one to spoon-feed answers, I will tell you it has to do with one of the DECLARE lines in the stored procedure.

No one ever learned anything from being given the answer.

(Before people say "Oh, you don't know what your talking about", I have already fixed and tested this on my own test server.)
finally made it work ^^... tnx for the hint anyways ;)
01/17/2013 16:14 fiore14#9
:) Good to hear, it was pretty simple 1 digit change.