Rappelz server files

Page 96 of 154

05/19/2011 18:32 massimino4#1426

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)

05/19/2011 19:22 lilnani#1427

Quote:

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

05/19/2011 19:26 massimino4#1428

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

05/19/2011 19:56 Horus19#1429

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

Spoiler

What is the problem an how can I fix it?

05/19/2011 20:29 dmanbzicki#1430

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

05/19/2011 20:35 massimino4#1431

Quote:

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...^_^

05/19/2011 20:54 mecanizador#1432

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?

05/19/2011 21:26 woty#1433

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. ;)

05/19/2011 21:55 woty#1434

Quote:

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 ^^

05/19/2011 21:58 woty#1435

Quote:

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 :/

05/19/2011 22:05 kaizoku801#1436

Quote:

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

05/19/2011 22:07 woty#1437

Quote:

Originally Posted by speedy-nl

[Only registered and activated users can see links. Click Here To Register...]

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

It worked, thanks alot Speedy ;)

05/19/2011 22:12 reddragon45#1438

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

05/19/2011 22:48 Naruto�#1439

[Only registered and activated users can see links. Click Here To Register...] Pls help me :'(
I want play rappelz :(

05/19/2011 22:59 kaizoku801#1440

Quote:

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

Page 96 of 154