Rappelz server files

[DaJohnson]

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?

[mecanizador]

when i cluick on genie wind blossom skill the harlock server crashes and i have to relog all of it..
anyone has any idea?

[lilnani]

when i open the character nothing happened it still on this




any one can give me his db with pet

[Strean]

Originally Posted by lilnani

when i open the character nothing happened it still on this




any one can give me his db with pet

did you change anything in the client with a hex editor ?

[loron]

please help Ifrit no taming who knows his model_id

[lilnani]

Originally Posted by Strean

did you change anything in the client with a hex editor ?

no


any one can give me resource folder

[ironhammer500]

Originally Posted by lilnani

when i open the character nothing happened it still on this




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

[stouf]

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

[mlouki]

Hello, Then here is I have a problem during the Advent the last stage of the installation of SQL server 2008 r2:





Help me plz ='(

[Muumiarmor]

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.

[frisky22]

anyone found a fix for pet unitys freezing and crashing server ?

genie gale force crashes it aswell.

[ironhammer500]

Originally Posted by Muumiarmor

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.

[Muumiarmor]

Originally Posted by ironhammer500

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.

[mecanizador]

cerb skills also make the game crash :x
and ifrit m.atk passive doesnt work

[Horus19]

Originally Posted by Muumiarmor

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?