Rappelz server files

05/20/2011 13:53 DaJohnson#1501
Far as I understand it, get_value() returns values from column in-use by that function, for example, on_login references the dbo.Characters table, so get_value("lv") would return the characters level. To have additional columns added, you need, far as I see it, to change the dbo.smp_ stored procedures, to return your additional values.

I tried doing this to set "premium" for HV, if you read a few pages back, but couldnt figure out the errors Herlock was giving me.


*Edit

Anyone had the R7 T1/T2/T3 Armor bonus buff's activate for them?
05/20/2011 14:21 mecanizador#1502
when i cluick on genie wind blossom skill the harlock server crashes and i have to relog all of it..
anyone has any idea?
05/20/2011 14:33 lilnani#1503
when i open the character nothing happened it still on this

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


any one can give me his db with pet
05/20/2011 14:37 Strean#1504
Quote:
Originally Posted by lilnani View Post
when i open the character nothing happened it still on this

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


any one can give me his db with pet
did you change anything in the client with a hex editor ?
05/20/2011 14:37 loron#1505
please help Ifrit no taming who knows his model_id
[Only registered and activated users can see links. Click Here To Register...]
05/20/2011 14:42 lilnani#1506
Quote:
Originally Posted by Strean View Post
did you change anything in the client with a hex editor ?

no


any one can give me resource folder
05/20/2011 14:45 ironhammer500#1507
Quote:
Originally Posted by lilnani View Post
when i open the character nothing happened it still on this

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


any one can give me his db with pet
I think you got the wrong client thats navislama or w/e spelling is ^^

the AoR client is the next epic or part along which is what u need it works.

That or ive never seen that background during my loads.


Also jw why is it i cant edit ur database u just uploaded with sql? i mean my querys dont seem to affect the tables. And when i added it i did what u said in ur guide wondering if i missed anything that allows me to edit or somthing.

Btw thx for the guide massive help for a nubie like me ^^ also Thank you to all the other devs giving us nubies the files and putting up with the beggers ^^

Also i did google sql help but i cant seem to figure out what im doing wrong and i hate changing all the 4k+ values for enchance just to make +20 100%.

Also i looked at the Lua for the mosnter and at bottom found something linked to the auto trap ive set mine to 0 as it was 1 not sure what it did tho just wondering if that is linked to spawns.

But what i think is they all do spawn just not on the map or well when u can "exsist" if you know what i mean as i did the no collsion in gamesserver.opt and herlock stoped the endless spam so im guessing the mobs spawn just not in the right places.

also if mobs ids are correct then im not sure how i would use the herlock commands to spawn them.

i tried #respawn(mob id , 1 (how many) , "chara name" ) didnt seem to work im guessing the commands work just no idea what they are and ive seen ppl spawning mobes but idk how and i dont wanna edit lua files, dont wanna risk breaking it again xD
05/20/2011 15:02 stouf#1508
I think the command to spawn mobs from the server console should be :
respawn( id, interval, x, y, mob_id, count, is_wandering )

But it is not (really) working right now. If you spawn a mob with lua, it seems to work well, but if I try to spawn a mob via console, the mob seems to pop up, is invisible / not selectable, but is able to see and hurt you (you see your HP bar going down, and finally die).
This test was done with respawn_rare_mob command and SandLord boss, I don't think it makes a big difference
05/20/2011 15:09 mlouki#1509
Hello, Then here is I have a problem during the Advent the last stage of the installation of SQL server 2008 r2:

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



Help me plz ='(
05/20/2011 15:14 Muumiarmor#1510
Code:
if ID == 11 then	-- °¡ÀÌ¾Æ ½ÃÀÛÁöÁ¡1
		monster_ID = { 1002, 2002, 2002, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5044, 5046, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 100, 0 }
		
	elseif ID == 21 then-- °¡ÀÌ¾Æ ½ÃÀÛÁöÁ¡2 (Áß°£°øÅÍ & ÁøÇà·çÆ®)
		monster_ID = { 2002, 3003, 1002, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5044, 5046, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 100, 0 }
		
	elseif ID == 12 then-- µ¥¹Ù ½ÃÀÛÁöÁ¡1
		monster_ID = { 1003, 2003, 2003, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5049, 0, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 0, 0 }
		
	elseif ID == 22 then-- µ¥¹Ù ½ÃÀÛÁöÁ¡2 (´Ù¸®°Ç³ÊÆí)
		monster_ID = { 2003, 3004, 1003, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5049, 0, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 0, 0 }
		
	elseif ID == 13 then-- ¾Æ¼ö¶ó ½ÃÀÛÁöÁ¡1
		monster_ID = { 1004, 2004, 2004, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }
				
	elseif ID == 23 then-- ¾Æ¼ö¶ó ½ÃÀÛÁöÁ¡2 (Áß°£°øÅÍ)
		monster_ID = { 2004, 3005, 1004, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }
			
		Raremob_ID = { 5041, 5043, 0, 0 }   
		Raremob_count = { 1, 1, 1, 1 }  
		Raremob_interval = { 100, 100, 100, 0 }

	elseif ID == 42 then-- Ãʱޱ³°ü ÁÖº¯Áö¿ª
		monster_ID = { 4002, 3006, 2002, 3003, 135007, 135007 }
		density = { 1.0, 0.5, 0.4, 0.4, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5049, 0, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 0, 0 }
Open your 'monster_respawn' file and hold CTRL down and press 'F' find 1002 (take a look in monster resource and you will see it's the lvl 1 mobs) Change my '135007' to what ever mob id you want to spawn, the monsters will spawn at start points on TI.
05/20/2011 15:19 frisky22#1511
anyone found a fix for pet unitys freezing and crashing server ?

genie gale force crashes it aswell.
05/20/2011 15:25 ironhammer500#1512
Quote:
Originally Posted by Muumiarmor View Post

Open your 'monster_respawn' file and hold CTRL down and press 'F' find 1002 (take a look in monster resource and you will see it's the lvl 1 mobs) Change my '135007' to what ever mob id you want to spawn, the monsters will spawn at start points on TI.
Ah ok ty ill try that and maybe if i find the duka mobs i can make them into the dungeon bosses or somthing.
05/20/2011 15:41 Muumiarmor#1513
Quote:
Originally Posted by ironhammer500 View Post
Ah ok ty ill try that and maybe if i find the duka mobs i can make them into the dungeon bosses or somthing.
I did have the 180 or 170 [++] WD's spawning there (can't remember as I was testing at this point) but I assume you can have anything spawning, I noticed after I changed the lua respawn most of my spawns changed, no more harpys at waterfall, no 160+ mobs near CV so not sure what I did, I think I changed the resouce folder as I was having problems with the gameserver.
05/20/2011 15:43 mecanizador#1514
cerb skills also make the game crash :x
and ifrit m.atk passive doesnt work
05/20/2011 16:03 Horus19#1515
Quote:
Originally Posted by Muumiarmor View Post
Code:
if ID == 11 then	-- °¡ÀÌ¾Æ ½ÃÀÛÁöÁ¡1
		monster_ID = { 1002, 2002, 2002, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5044, 5046, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 100, 0 }
		
	elseif ID == 21 then-- °¡ÀÌ¾Æ ½ÃÀÛÁöÁ¡2 (Áß°£°øÅÍ & ÁøÇà·çÆ®)
		monster_ID = { 2002, 3003, 1002, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5044, 5046, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 100, 0 }
		
	elseif ID == 12 then-- µ¥¹Ù ½ÃÀÛÁöÁ¡1
		monster_ID = { 1003, 2003, 2003, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5049, 0, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 0, 0 }
		
	elseif ID == 22 then-- µ¥¹Ù ½ÃÀÛÁöÁ¡2 (´Ù¸®°Ç³ÊÆí)
		monster_ID = { 2003, 3004, 1003, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5049, 0, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 0, 0 }
		
	elseif ID == 13 then-- ¾Æ¼ö¶ó ½ÃÀÛÁöÁ¡1
		monster_ID = { 1004, 2004, 2004, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }
				
	elseif ID == 23 then-- ¾Æ¼ö¶ó ½ÃÀÛÁöÁ¡2 (Áß°£°øÅÍ)
		monster_ID = { 2004, 3005, 1004, 135007, 135007, 135007 }
		density = { 1.2, 0.7, 0.4, 0.15, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }
			
		Raremob_ID = { 5041, 5043, 0, 0 }   
		Raremob_count = { 1, 1, 1, 1 }  
		Raremob_interval = { 100, 100, 100, 0 }

	elseif ID == 42 then-- Ãʱޱ³°ü ÁÖº¯Áö¿ª
		monster_ID = { 4002, 3006, 2002, 3003, 135007, 135007 }
		density = { 1.0, 0.5, 0.4, 0.4, 0.1, 0.07 }
		interval = { 100, 100, 100, 100, 100, 100 }

		Raremob_ID = { 5049, 0, 0, 0 }
		Raremob_count = { 1, 1, 1, 1 }
		Raremob_interval = { 100, 100, 0, 0 }
Open your 'monster_respawn' file and hold CTRL down and press 'F' find 1002 (take a look in monster resource and you will see it's the lvl 1 mobs) Change my '135007' to what ever mob id you want to spawn, the monsters will spawn at start points on TI.

Do i have to add the code to my monster_respawn(XXX).lua?