Rappelz server files

[XavierDeFawks]

i completely agree jw988 its just im confused on why im getting errors when i executed the update just fine o.o

ill do all the updates again just to make sure i didnt do anything wrong

[jw988]

you will need to change the Summon table to this if you want it to get over 115 in level as the exp is an int but needs to be bigint, so far the pets stats dont seem bugged.

 Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Summon] Script Date: 05/05/2011 16:46:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create TABLE [dbo].[Summon](
[SID] [int] NOT NULL,
[ACCOUNT_ID] [int] NULL,
[OWNER_ID] [int] NULL,
[CODE] [int] NULL,
[CARD_UID] [int] NULL,
[NAME] [nvarchar](64) NULL,
[LV] [int] NULL,
[JLV] [int] NULL,
[MAX_LEVEL] [int] NULL,
[EXP] [bigint] NULL,
[JP] [int] NULL,
[LAST_DECREASED_EXP] [bigint] NULL,
[HP] [int] NULL,
[MP] [int] NULL,
[SP] [int] NULL,
[FP] [int] NULL,
[PREV_LEVEL_01] [int] NULL,
[PREV_LEVEL_02] [int] NULL,
[PREV_ID_01] [int] NULL,
[PREV_ID_02] [int] NULL,
[TRANSFORM] [int] NULL
) ON [PRIMARY]

GO

[khshe]

Why can not insert pet form.suschestv? added it to my database!

USE [Arcadia]
GO

/****** Object: Table [dbo].[SummonDefaultNameResource] Script Date: 05/04/2011 23:05:50 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SummonDefaultNameResource]') AND type in (N'U'))
DROP TABLE [dbo].[SummonDefaultNameResource]
GO

USE [Arcadia]
GO

/****** Object: Table [dbo].[SummonDefaultNameResource] Script Date: 05/04/2011 23:05:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SummonDefaultNameResource](
[sid] [int] NOT NULL,
[is_post_fix] [int] NOT NULL,
[text_id] [int] NULL
) ON [PRIMARY]

GO

[jw988]

Put this in the table that his script makes

1 - 0 - 27
2 - 1 - 28

should make it work, seems the post fix need to be the first one.
so far my white dragon is leveling fine with no stat bugs yet.

[khshe]

Originally Posted by jw988

Put this in the table that his script makes

1 - 0 - 27
2 - 1 - 28

should make it work, seems the post fix need to be the first one.
so far my white dragon is leveling fine with no stat bugs yet.

Do please backup your database?

[traff]

Hey there,

im a programmer myself if there is anything like an svn repository? maybe we can work together :>

[wisp66]

guys off topic butas we all know aor has decided not to share and no plans to fix ****
so heres his sframe unpacked get what u can out of it
if it helps cool.... if not well its the thought i guess


id assume he would have encrypted it sad part was it wasnt he just repacked

[traff]

i already found the sourceforge rep

but is there a way to download all files at once and not clicking every one by one?

[lilnani]

any one can give my afull server file with sql database

[khshe]

Id say a staff 150 + 155 + and 160 +

[DragonMaxBR]

Originally Posted by EatMyDebuff

Found some buffs while looking through the lua scripts.
Enjoy!

thanks for it .. i found some more buffs , including Aura of Halisha , Stamina Saver.

 Spoiler

Template:
#add_state( ID , VALUE, TIME, NAME)
-----------------------------------------------------------
#add_state(1001, 50, 9000, "Your Toonname Here") //max HP
#add_state(1002, 50, 9000, "Your Toonname Here") //max MP
#add_state(1003, 50, 9000, "Your Toonname Here") //hp reg.
#add_state(1004, 50, 9000, "Your Toonname Here") //hp Rec.
#add_state(1005, 50, 9000, "Your Toonname Here") //mp Reg.
#add_state(1006, 50, 9000, "Your Toonname Here") //mp rec.
#add_state(1007, 50, 9000, "Your Toonname Here") //Patk.
#add_state(1008, 50, 9000, "Your Toonname Here") //Matk
#add_state(1009, 50, 9000, "Your Toonname Here") //Pdef
#add_state(1010, 50, 9000, "Your Toonname Here") //Mdef
#add_state(1011, 50, 9000, "Your Toonname Here") //Atk Speed
#add_state(1012, 50, 9000, "Your Toonname Here") //Cast Speed
#add_state(1013, 50, 9000, "Your Toonname Here") //Mov Speed
#add_state(1014, 50, 9000, "Your Toonname Here") //Acc.
#add_state(1015, 50, 9000, "Your Toonname Here") //Evasion
#add_state(1016, 50, 9000, "Your Toonname Here") //Macc
#add_state(1017, 50, 9000, "Your Toonname Here") //Mres
#add_state(1018, 50, 9000, "Your Toonname Here") //Crit Ratio
#add_state(1019, 50, 9000, "Your Toonname Here") //Crit Pow.
#add_state(1507, 50, 9000, "Your Toonname Here") //Luck
#add_state(2601, 50, 9000, "Your Toonname Here") //Threat Increase
#add_state(4016, 50, 9000, "Your Toonname Here") //MP regeneration
#add_state(4042, 50, 9000, "Your Toonname Here") //Kentaurus Pot Effect
#add_state(4065, 50, 9000, "Your Toonname Here") //Slowly HP recovery
#add_state(4088, 50, 9000, "Your Toonname Here") //30 MP regen
#add_state(4518, 50, 9000, "Your Toonname Here") //Agility Increase
#add_state(4541, 50, 9000, "Your Toonname Here") //Skeleton Desguise
#add_state(5013, 50, 9000, "Your Toonname Here") //Decrease Mres
#add_state(6010, 50, 9000, "Your Toonname Here") //Debuff Stun
#add_state(6513, 50, 9000, "Your Toonname Here") //Harmony of Life
#add_state(7017, 50, 9000, "Your Toonname Here") //Ornito for Ridding
#add_state(9911, 50, 9000, "Your Toonname Here") //Pieces of Vitality
#add_state(12022, 50, 9000, "Your Toonname Here") //Decreases Mdef
#add_state(13035, 50, 9000, "Your Toonname Here") //Unable attack
#add_state(13442, 50, 9000, "Your Toonname Here") //Increase CriRatio/Threat
#add_state(14402, 50, 9000, "Your Toonname Here") //Mental Support Buff
#add_state(145210, 50, 9000, "Your Toonname Here") //Flame Blow - Strong debuff
#add_state(145609, 50, 9000, "Your Toonname Here") //Unity of Siren
#add_state(145733, 50, 9000, "Your Toonname Here") //Encouragement - Intelligence
#add_state(145740, 50, 9000, "Your Toonname Here") //Encouragement - Dexterity
#add_state(145741, 50, 9000, "Your Toonname Here") //Fortune Clover - INcrease DropRate
#add_state(145742, 50, 9000, "Your Toonname Here") //Encouragement - Agility
#add_state(145409, 50, 9000, "Your Toonname Here") //Painfull Auria - Strong Debuff
#add_state(145501, 50, 9000, "Your Toonname Here") //Decreases Mov Speed
#add_state(145502, 50, 9000, "Your Toonname Here") //decreases Accuracy
#add_state(145504, 50, 9000, "Your Toonname Here") //decreases Patk / Pdef
#add_state(145507, 50, 9000, "Your Toonname Here") //Strong Debuff
#add_state(145509, 50, 9000, "Your Toonname Here") //Strong Debuff
#add_state(145510, 50, 9000, "Your Toonname Here") //debuff
#add_state(145511, 50, 9000, "Your Toonname Here") //debuff
#add_state(145512, 50, 9000, "Your Toonname Here") //debuff
#add_state(145513, 50, 9000, "Your Toonname Here") //debuff
#add_state(145514, 50, 9000, "Your Toonname Here") //debuff
#add_state(145515, 50, 9000, "Your Toonname Here") //debuff
#add_state(145516, 50, 9000, "Your Toonname Here") //debuff
#add_state(145517, 50, 9000, "Your Toonname Here") //debuff accuracy
#add_state(145518, 50, 9000, "Your Toonname Here") //debuff accuracy
#add_state(145519, 50, 9000, "Your Toonname Here") //debuff MovSpeed
#add_state(145720, 50, 9000, "Your Toonname Here") //Gigantic
#add_state(145521, 50, 9000, "Your Toonname Here") //Ifrit Lv150 Buff skill
#add_state(146001, 50, 9000, "Your Toonname Here") //HP recovery
#add_state(146002, 50, 9000, "Your Toonname Here") //Decreases Damage %
#add_state(146007, 50, 9000, "Your Toonname Here") //Vampiric Rage
#add_state(164805, 50, 9000, "Your Toonname Here") //Might of Underworld
#add_state(201001, 50, 9000, "Your Toonname Here") //Instant Kill, unable to revive
#add_state(201032, 50, 9000, "Your Toonname Here") //Sleep
#add_state(201033, 50, 9000, "Your Toonname Here") //Stun
#add_state(201035, 50, 9000, "Your Toonname Here") //Fear
#add_state(164407, 50, 9000, "Your Toonname Here") //Aura of Halisha
#add_state(201025, 50, 9000, "Your Toonname Here") //Wrath
#add_state(4003, 50, 9000, "Your Toonname Here") //Stamina Saver
#add_state(2605, 50, 9000, "Your Toonname Here") //Never get Fear
#add_state(6016, 50, 9000, "Your Toonname Here") //Hidding

[traff]

ahhh im failing initialising the mysql db any quick tut?

[teleginma]

tell me pls how to create an account in DB and where was stored acount password.
Sorry for my English

[RoflcopterGoesSoiSoiSoi]

Hey Link, whip up a tut and I'll mess around with the SQL later today or tom. I'm jazzy with all that stuff, I think like a programmer (and I'm good at it too!).

[demonroro]

Link got exams this week, he comes back on Friday...