Rappelz server files

[massimino4]

For tafari:


IINSERT INTO [Arcadia].[dbo].[SummonResource]
([id]
,[model_id]
,[name_id]
,[type]
,[magic_type]
,[rate]
,[stat_id]
,[size]
,[scale]
,[target_fx_size]
,[standard_walk_speed]
,[standard_run_speed]
,[riding_speed]
,[run_speed]
,[is_riding_only]
,[riding_motion_type]
,[attack_range]
,[walk_type]
,[slant_type]
,[material]
,[weapon_type]
,[attack_motion_speed]
,[form]
,[evolve_target]
,[camera_x]
,[camera_y]
,[camera_z]
,[target_x]
,[target_y]
,[target_z]
,[model]
,[motion_file_id]
,[face_id]
,[face_file_name]
,[card_id]
,[script_text]
,[illust_file_name]
,[text_feature_id]
,[text_name_id]
,[skill1_id]
,[skill1_text_id]
,[skill2_id]
,[skill2_text_id]
,[skill3_id]
,[skill3_text_id]
,[skill4_id]
,[skill4_text_id]
,[skill5_id]
,[skill5_text_id]
,[texture_group]
,[local_flag])
VALUES
('3601','103023','159007','1','0','0','22507','1.0 0','1.00','14.00','40','40','50','115','0','0','1. 00','33','0','0','106','0','1','3602','5','-14','26','-0.30','-0.60','14.86','spirit_tafari_lv1','103023','30028' ,'icon_creature_0046','540059','0','card_tafari_ba sic','0','0','0','0','0','0','0','0','0','0','0',' 0','-1','0'),


('3602','103024','164005','1','0','0','23007','1.2 0','1.20','16.80','40','80','50','120','0','0','8. 00','33','0','0','101','0','2','3603','5','-14','26','-0.30','-0.60','14.86','spirit_tafari_lv2','103024','30028' ,'icon_creature_0046','540059','0','card_tafari_gr ow','0','0','0','0','0','0','0','0','0','0','0','0 ','-1','0'),


('3603','103025','9103006','1','0','0','17021','1. 50','1.50','15.00','40','80','50','120','0','0','8 .00','33','0','0','101','0','3','0','5','-14','26','-0.30','-0.60','14.86','spirit_tafari_lv3','103025','30028' ,'icon_creature_00466','540059','0','card_tafari_e vol','0','0','0','0','0','0','0','0','0','0','0',' 0','-1','0')
(3 pm about that..so i direct write this here)

[lilnani]

Originally Posted by massimino4

For tafari:


INSERT INTO [Arcadia].[dbo].[SummonResource]
([id]
,[model_id]
,[name_id]
,[type]
,[magic_type]
,[rate]
,[stat_id]
,[size]
,[scale]
,[target_fx_size]
,[standard_walk_speed]
,[standard_run_speed]
,[riding_speed]
,[run_speed]
,[is_riding_only]
,[riding_motion_type]
,[attack_range]
,[walk_type]
,[slant_type]
,[material]
,[weapon_type]
,[attack_motion_speed]
,[form]
,[evolve_target]
,[camera_x]
,[camera_y]
,[camera_z]
,[target_x]
,[target_y]
,[target_z]
,[model]
,[motion_file_id]
,[face_id]
,[face_file_name]
,[card_id]
,[script_text]
,[illust_file_name]
,[text_feature_id]
,[text_name_id]
,[skill1_id]
,[skill1_text_id]
,[skill2_id]
,[skill2_text_id]
,[skill3_id]
,[skill3_text_id]
,[skill4_id]
,[skill4_text_id]
,[skill5_id]
,[skill5_text_id]
,[texture_group]
,[local_flag])
VALUES
('3601',' 103023', '159007', '1' ,'0' ,'0', '22507', '1.00', '1.00' ,'14.00', '40', '40', '50', '115', '0', '0', '1.00', '33', '0' ,'0', '106', '0', '1', '3602', '5', '-14' ,'26' ,'-0.30', '-0.60', '14.86', 'spirit_tafari_lv1', '103023', '30028', 'icon_creature_0046', '540059' ,'0', 'card_tafari_basic', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0')


('3602',' 103024', '164005', '1', '0', '0', '23007', '1.20', '1.20', '16.80', '40', '80', '50', '120', '0', '0', '8.00', '33', '0', '0', '101', '0', '2' ,'3603', '5' ,'-14', '26', '-0.30', '-0.60', '14.86', 'spirit_tafari_lv2', '103024', '30028', 'icon_creature_0046', '540059', '0', 'card_tafari_grow', '0', '0', '0', '0', '0', '0', ','0', '0', '0', '0', '0', '0', '-1', '0')


('3603', '103025', '9103006, '1', '0', '0', '17021', '1.50', '1.50', '15.00', '40', '80', '50', '120', '0', '0', '8.00', '33', '0', '0', '101', '0', '3', '0', '5', '-14', '26', '-0.30', '-0.60', '14.86', 'spirit_tafari_lv3', '103025', '30028', 'icon_creature_00466',' 540059', '0', 'card_tafari_evol' ,'0', '0', '0', '0', '0', '0', '0', '0', '0', '0' ,'0' ,'0' ,'-1', '0')
GO

(3 pm about that..so i direct write this here)

Msg 102, Level 15, State 1, Line 58
Incorrect syntax near '3602'.


this error when i but it in querry

[massimino4]

you must delete all and use this code...maybe ther is a copy error..i m going to chek ^^
check and rewrite try now

[Horus19]

hello, after a while the server shutsdown without a message.
In the GameLog only stands for today:

 Spoiler

2011/05/19 17:10:15 DB COM ERROR(Thread:2, HRESULT:80040E57, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateClientInfo(dbo.smp_update_client_info) : String or binary data would be truncated.
2011/05/19 17:10:18 DB COM ERROR(Thread:3, HRESULT:80040E57, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateClientInfo(dbo.smp_update_client_info) : String or binary data would be truncated.
2011/05/19 17:10:39 DB COM ERROR(Thread:0, HRESULT:80040E57, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateClientInfo(dbo.smp_update_client_info) : String or binary data would be truncated.

What is the problem an how can I fix it?

[dmanbzicki]

guys what to do, when i change the values in db.character, and i go right click -> execute, it resets to original value?

[massimino4]

Originally Posted by speedy-nl

think you forgot the , behind ) the 2 first rows

i made this 1 earlyer, and it works fine, tamed 2 nagas

INSERT INTO [Arcadia].[dbo].[SummonResource]
([id]
,[model_id]
,[name_id]
,[type]
,[magic_type]
,[rate]
,[stat_id]
,[size]
,[scale]
,[target_fx_size]
,[standard_walk_speed]
,[standard_run_speed]
,[riding_speed]
,[run_speed]
,[is_riding_only]
,[riding_motion_type]
,[attack_range]
,[walk_type]
,[slant_type]
,[material]
,[weapon_type]
,[attack_motion_speed]
,[form]
,[evolve_target]
,[camera_x]
,[camera_y]
,[camera_z]
,[target_x]
,[target_y]
,[target_z]
,[model]
,[motion_file_id]
,[face_id]
,[face_file_name]
,[card_id]
,[script_text]
,[illust_file_name]
,[text_feature_id]
,[text_name_id]
,[skill1_id]
,[skill1_text_id]
,[skill2_id]
,[skill2_text_id]
,[skill3_id]
,[skill3_text_id]
,[skill4_id]
,[skill4_text_id]
,[skill5_id]
,[skill5_text_id]
,[texture_group]
,[local_flag])
VALUES
('3601','103023','159007','1','0','0','22507','1.0 0','1.00','14.00','40','40','50','115','0','0','1. 00','33','0','0','106','0','1','3602','5','-14','26','-0.30','-0.60','14.86','spirit_tafari_lv1','103023','30028' ,'icon_creature_0046','540059','0','card_tafari_ba sic','0','0','0','0','0','0','0','0','0','0','0',' 0','-1','0'),


('3602','103024','164005','1','0','0','23007','1.2 0','1.20','16.80','40','80','50','120','0','0','8. 00','33','0','0','101','0','2','3603','5','-14','26','-0.30','-0.60','14.86','spirit_tafari_lv2','103024','30028' ,'icon_creature_0046','540059','0','card_tafari_gr ow','0','0','0','0','0','0','0','0','0','0','0','0 ','-1','0'),


('3603','103025','9103006','1','0','0','17021','1. 50','1.50','15.00','40','80','50','120','0','0','8 .00','33','0','0','101','0','3','0','5','-14','26','-0.30','-0.60','14.86','spirit_tafari_lv3','103025','30028' ,'icon_creature_00466','540059','0','card_tafari_e vol','0','0','0','0','0','0','0','0','0','0','0',' 0','-1','0')


GO

ops..sorry man!! T.T thx !!! edit my post...^_^

[mecanizador]

when i make my genie 115 the game crashes(or if its higher than 115)
other than that it works fine :S
anyone knows how to resolve it?

[woty]

When i execute the new query for implant the naga, i get this error:


Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.


Have a clue about this ?

Thanks in advance.

[woty]

Originally Posted by speedy-nl

any change you pasted/copy this alonge with it ?, (3 pm about that..so i direct write this here)

No i haven't copy this with it ^^

[woty]

Originally Posted by speedy-nl

did you tryed both versions ?, loks like something went wrong with the copy/paste thing, worked fine for me

Yes i tryed both, nothing works :/

[kaizoku801]

Originally Posted by dmanbzicki

guys what to do, when i change the values in db.character, and i go right click -> execute, it resets to original value?

Log out to char screen, you cant edit values while still ingame, you can however add cash and items while ingame....

When you start a new char and want it skilled, just up the Jlvls and go to herlock server type: learn_all_skills("char name") will save you some time



Here's my question, we've managed to insert some Roaming mobs, and items...
but few things been annoying me...

1. some mobs that i spawn are not tameable.. like tafari/naga for instance, "you can not use that skill on that target" (yes i have e-cards and skill)
and then again some nagas are tameable...

2. I managed to Spawn ENT and give it some skills (from other pets, not the original skills) the ent shows up visually too...

so i tried with Astaroth next.. astaroth did not show up visually however, earlier in the forums some1 posted a picture of a summoned astaroth, i used the "search this thread" for keyword "Astaroth", and looked through them all, but nothing usefull caught my eyes..

The Tables for ENT / Astaroth are basically the same, but if any1 can point me to the right direction of making pets visually appear i would be gratefull ^^

-Kaizoku801

[woty]

Originally Posted by speedy-nl

d/l this 1, i used it myself and worked fine

It worked, thanks alot Speedy

[reddragon45]

the prob is went you copy o the site the number get to long now just copy of notpad

[Naruto™]

Pls help me :'(
I want play rappelz

[kaizoku801]

Originally Posted by speedy-nl

both ent and ast are not complete in db, thats prolly the reason, genie, and naga are complete if you run the script that peeps made for them

uni is also not fully complete, i have added some things in db to it, but cant find a e-uni card to test it

I know ent and astaroth not complete, im trying to re-create ent atm, give it a motion file and skill tab of another pet + stuff like that... but i think i know where my problem lies in with astaroth...

I'll check back in few if im correct