[Help] Adding Draco pet to shops.

[torstmn]

Hey RaGEZONE,
yesterday I tried to add the Draco pet (kind'a horse) to the hotan stable (or any other shop!). My problem: the gameserver crashes after the "Initialize DB successfull" message at the beginning. Well, tried alot of things and I realy don't know why that error occures (No error message).

-> The item works ingame, so that's not the problem.
--> The item has been added to refPackageItem, refPricePolicyOfItem, refScrapOfPackageItem.

That works pretty fine.

Here's the code for those tables:

[_refPackageItem]

1 15 86444 PACKAGE_ITEM_COS_C_DRACO 0 EXPAND_TERM_ALL SN_ITEM_COS_C_DRACO SN_ITEM_COS_C_DRACO_TT_DESC cos\cos_c_draco.ddj -1 xxx -1 xxx -1 xxx -1 xxx

[_refScrapOfPackageItem]

1 15 PACKAGE_ITEM_COS_C_DRACO ITEM_COS_C_DRACO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 88957

[_refPricePolicyOfItem]

1 15 PACKAGE_ITEM_COS_C_DRACO 1 0 70000 0 xxx 0 xxx 0 xxx 0 xxx

Ok, there shouldn't be any misstake I guess, the server doesn't crash, everything is fine.

But the last step is adding this item to its related shop so last code:



[_refShopGoods]

1 15 STORE_KT_STABLE_TAB1 PACKAGE_ITEM_COS_C_DRACO 4 -1 xxx -1 xxx -1 xxx -1 xxx

That's the part where the server crashes.


My first thought was that the slot might be wrong.. But that's not the problem..

So guys, I hope you understood my question and help me out

Thanks for reading

[MentaL]

[Caosfox]

if im not wrong, the dbid is wrong on refpackageitem and scrap, they must match

on one is 86444 and on the other is 88957. try boths as 86444

[SnapPop]

if im not wrong, the dbid is wrong on refpackageitem and scrap, they must match

on one is 86444 and on the other is 88957. try boths as 86444

no you are wrong they not have to be the same

anyway humm i guess you fucked up something with refshopgoods i always like to make my custom DB so onetime i truncate that table and rebuild it with new lines so that give me GS crashes so the question is did you truncate that table before !!

[torstmn]

I'm using the DB Statiic released, forgot the version number but what I actually wanna say is that I didn't modify it yet. (That's the only new line in it).

[SnapPop]

I'm using the DB Statiic released, forgot the version number but what I actually wanna say is that I didn't modify it yet. (That's the only new line in it).

humm can you exactly copy all the lines that belongs to STORE_KT_STABLE_TAB1 ? for example i have only those from vsro 1.193

1	15	STORE_KT_STABLE_TAB1	PACKAGE_ITEM_COS_C_DHORSE1	3	-1	xxx	-1	xxx	-1	xxx	-1	xxx
0	15	STORE_KT_STABLE_TAB1	PACKAGE_ITEM_COS_C_DHORSE2	4	-1	xxx	-1	xxx	-1	xxx	-1	xxx
0	15	STORE_KT_STABLE_TAB1	PACKAGE_ITEM_COS_C_DHORSE3	4	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_KT_STABLE_TAB1	PACKAGE_ITEM_COS_C_HORSE1	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_KT_STABLE_TAB1	PACKAGE_ITEM_COS_C_HORSE2	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_KT_STABLE_TAB1	PACKAGE_ITEM_COS_C_HORSE3	2	-1	xxx	-1	xxx	-1	xxx	-1	xxx

BTW slots must be in same ranking like:0,1,2,3,etc maybe there're hidden lines contain the same slot that you have added for that pet!! ok anyway post all the lines that contains "STORE_KT_STABLE_TAB1"

[Caosfox]

no you are wrong they not have to be the same

anyway humm i guess you fucked up something with refshopgoods i always like to make my custom DB so onetime i truncate that table and rebuild it with new lines so that give me GS crashes so the question is did you truncate that table before !!

wel, i always use the same and everything is working on npcs (only uruchi boss is not wotking on npc, all the other bosses + adv elix + item mall items are working) so guess can be or not the same.

i always use this guide http://forum.ragezone.com/f723/guide...3/#post6855228

[torstmn]

@Caosfox : Yeah, that's the one ive been using, too. I did it step bye step. Right now I added Magic Lucky Powder to one of the shops and it worked great. .. Any other idea? Something wrong with the other tables (refPrice**...)

[Caosfox]

well, humor me and put the same id on both places, if still fail, try to add on another npc, like potion

[arabianfox]

ok i just have one question

is this Statiic DB ver 6.3 ?!!

[torstmn]

@arabianfox Yes, if 6.3 is the latest version of his databse it is.

@Caosfox -> As I said before, I added Lucky Magic Powder to shop and that worked fine (Even with different index/id) so that can't be the problem.

[arabianfox]

Then From where you get ID of Refpackageitem table which is 86444 ???

and the same thing for INDEX at Refscrapofpackageitem ???

you add them manually ?! or Automatic add

thank you

[torstmn]

@arabianfox

As you can read in my post, those tables don't crash the gameserver.
If those indexes/IDs would be wrong the gameserver would say "!! faild to create reference data of [_refShop] table !!". It doesnt say anything.

[Caosfox]

yup, not always they crash gameserver, in my case, uruchi summon scroll works perfect, can create it with gm command, can use it. but if i add to any npc.. insta client crash

[torstmn]

Yeah, I agree but the client doesn't crash.

I mean, I did everything correct I think so what's the go*da** problem?.. Realy I don't get it.

[arabianfox]

@arabianfox

As you can read in my post, those tables don't crash the gameserver.
If those indexes/IDs would be wrong the gameserver would say "!! faild to create reference data of [_refShop] table !!". It doesnt say anything.

If you just answer my question that will allows me to help you..

anyway thanks ... i just wana help :)

[torstmn]

@arabianfox

Sorry, guess I didn't read the question carefully.

So, I allways copy & paste the whole table to notepad and search for an ID.
If it can be found i can't use it, if it can't, I'm allowed. Statiic's table ended with the 86442 -> the 86443 was set, too but somewhere in the middle of the table. The next usable ID was the 86444. That one was free.

Same princip for the index.

[arabianfox]

From SQL main menu choose Tools >> Options and go to Designers and remove check from "Prevent saving changes that require table re-creation as shown here:



Then go to table Refpackageitem table Right click and choose Design



Then Right click on ID and choose "set primary key"



Then scroll down at column properties you will find "Identity specification" property >> choose "is identity" and choose "yes" as you can see here



This will make ID auto number and SQL will generate a unique number each time you try to add a new items to the table.

Do the same to table Refscrapofpackageitem but don't set primary key >> just make [INDEX] column identity to YES

now to add new item leave ID empty (NULL) and SQL will generate a new number (unique number) and this for [INDEX] at refscraofpackageitem too >> then copy this numbers to your media text files.

Thank you

[torstmn]

Wow, thanks for you help. I'll try again.