Rappelz server files

[Gangxtar1]

a few ITEM-IDs:

 Spoiler

540037 - White Dragon Empty
960019 - T-Pro
5020012 - smite card
490009 - Large Quilt Bag
306701 - R6 Cloak
5040012 - SummonCreatureCard
5040032 - CreatureTamingCard
3630079 - red wings deco
3620023 - wd random box
3630061 - swimsuit shoes
3630062 - swimsuit top
3600046 - thx giving event box
2010895 - usa cloak
2902009 - carrot
2010679 - whip
2902165 - lucky potion
950073 - ss delux
950021 - e-repair
950020 - epro
920004 - cnc
608406 - creature res
306409 - angel cloak
490011 - 9k bag
2010731 - cool japan cloak
2010941 - epic 6 part2 solis cloak
950048 - witch hat
540100 - white lydian
3600044 - Rain Drop Event Box
2010693 - Pirate Ship
3600044 - Rain Drop
3001702 - 30 ss bag
3600066 - 8gmfb bag
3600067 - 10gmfb bag
2010913 - Germany Cloak
2902165 - Luck Pot
950070 - Perfect E-Repair (saves stones?)
2010292 - Black Hole Mask
950031 - Bandits Mask

[lilnani]

any one can help

i download ageofrappelz client but the same error
i restore the db 3 times nothing happened

[Gangxtar1]

lilnani got this 2 ?

Account table:

 Spoiler

USE [Auth]
GO

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

USE [Auth]
GO

/****** Object: Table [dbo].[Accounts] Script Date: 05/02/2011 23:19:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Accounts](
[account_id] [int] IDENTITY(1,1) NOT NULL,
[login_name] [nvarchar](31) NULL,
[password] [nvarchar](32) NULL,
[block] [int] NULL,
[withdraw_remain_time] [int] NULL,
[age] [int] NULL,
[auth_ok] [int] NULL,
[pcbang] [int] NULL,
[last_login_server_idx] [int] NULL,
[event_code] [int] NULL,
[server_list_mask] [nvarchar](31) NULL,
[result] [int] NULL,
[ip] [int] NULL,
[game_code] [nvarchar](50) NULL,
[gamecode] [varchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[account_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Account procedure:

 Spoiler

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[smp_account]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[smp_account]
GO

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_character
CREATE PROCEDURE [dbo].[smp_account]
@IN_ACCOUNT nvarchar(31),
@IN_GAMECODE nvarchar(50),
@IN_PASSWORD nvarchar(32)
AS
SET NOCOUNT ON

--IF NOT EXISTS ( SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT )
-- INSERT dbo.Accounts( login_name,ip,password ) VALUES( @IN_ACCOUNT,0,@IN_ACCOUNT )

SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT --AND password = @IN_PASSWORD
SELECT * FROM dbo.Accounts WHERE password = @IN_PASSWORD

RETURN @@ERROR

GO

[TheStranger]

I'm having way to much fun lol.

Btw, i tried editing the lua script for teleporters, by changing the coordinates it teleports to. But it didnt work, i even restarted the server. Anyone have any ideas how to change teleport locations?

Also, can anyone tell me which dbo i need to be in to change what skills my pet has?
I want to give my ent skills =)

[lilnani]

Originally Posted by Gangxtar1

lilnani got this 2 ?

Account table:

 Spoiler

USE [Auth]
GO

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

USE [Auth]
GO

/****** Object: Table [dbo].[Accounts] Script Date: 05/02/2011 23:19:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Accounts](
[account_id] [int] IDENTITY(1,1) NOT NULL,
[login_name] [nvarchar](31) NULL,
[password] [nvarchar](32) NULL,
[block] [int] NULL,
[withdraw_remain_time] [int] NULL,
[age] [int] NULL,
[auth_ok] [int] NULL,
[pcbang] [int] NULL,
[last_login_server_idx] [int] NULL,
[event_code] [int] NULL,
[server_list_mask] [nvarchar](31) NULL,
[result] [int] NULL,
[ip] [int] NULL,
[game_code] [nvarchar](50) NULL,
[gamecode] [varchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[account_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Account procedure:

 Spoiler

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[smp_account]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[smp_account]
GO

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_character
CREATE PROCEDURE [dbo].[smp_account]
@IN_ACCOUNT nvarchar(31),
@IN_GAMECODE nvarchar(50),
@IN_PASSWORD nvarchar(32)
AS
SET NOCOUNT ON

--IF NOT EXISTS ( SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT )
-- INSERT dbo.Accounts( login_name,ip,password ) VALUES( @IN_ACCOUNT,0,@IN_ACCOUNT )

SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT --AND password = @IN_PASSWORD
SELECT * FROM dbo.Accounts WHERE password = @IN_PASSWORD

RETURN @@ERROR

GO

didnt work

can u give me your gameserver.opt and authserver.opt

[kaizoku801]

go to auth database... from MS SQL management... right click on auth tables... select "add new query" and copy paste that into it... it should say something like succesfully added after pressing the execute button (the lil red ! on left corner)

[Horus19]

Hello,
I got the most now working but two things wont work:
I Cant Open Shops and I cant Add me items
EDIT: And the Server Shutsdown when I Equip A Koala (((

[vitale3]

I saw such problem already was, but I couldn't solve it.
I tried to change ip on 127.0.0.1 but doesn't help. Help who can

[mecanizador]

i just found out a way to change pets
u just buy a koala and go to:
arcadia- then tables and then dbo.summonresource
there u find a code(id)...
after go to telecaster...tables...dbo.summon and change your pet id and there you gooo!
this way u get any pet u need -.^( if before u change the pet u get the skills of lets imagine a koala and then u change it to a angel u will get both skills )
p.s.: if u need more jp go to dbo.summon and give your pet more jps :P


btw anyone knows why i cant open the mystic jewel seller ?

[Cylar]

Originally Posted by Gangxtar1

lilnani got this 2 ?

Account table:

 Spoiler

USE [Auth]
GO

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

USE [Auth]
GO

/****** Object: Table [dbo].[Accounts] Script Date: 05/02/2011 23:19:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Accounts](
[account_id] [int] IDENTITY(1,1) NOT NULL,
[login_name] [nvarchar](31) NULL,
[password] [nvarchar](32) NULL,
[block] [int] NULL,
[withdraw_remain_time] [int] NULL,
[age] [int] NULL,
[auth_ok] [int] NULL,
[pcbang] [int] NULL,
[last_login_server_idx] [int] NULL,
[event_code] [int] NULL,
[server_list_mask] [nvarchar](31) NULL,
[result] [int] NULL,
[ip] [int] NULL,
[game_code] [nvarchar](50) NULL,
[gamecode] [varchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[account_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Account procedure:

 Spoiler

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[smp_account]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[smp_account]
GO

USE [Auth]
GO

/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 05/02/2011 23:20:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_character
CREATE PROCEDURE [dbo].[smp_account]
@IN_ACCOUNT nvarchar(31),
@IN_GAMECODE nvarchar(50),
@IN_PASSWORD nvarchar(32)
AS
SET NOCOUNT ON

--IF NOT EXISTS ( SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT )
-- INSERT dbo.Accounts( login_name,ip,password ) VALUES( @IN_ACCOUNT,0,@IN_ACCOUNT )

SELECT * FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT --AND password = @IN_PASSWORD
SELECT * FROM dbo.Accounts WHERE password = @IN_PASSWORD

RETURN @@ERROR

GO

Ich hab auch den fehler das wenn ich mich mit admin/admin einlogge und char erstellen will das leider nicht geht egal ob mit Epic 6 oder 7.2 client.
Habe diese 2 sachen mal eingetragen aber jetzt komm ich mit Admin/Admin nicht mehr ins game ^^
Wie sind den jetzt die daten zum einloggen ?

[Chaosnightmare]

Fixed Genie and Ifrit, Tutorial soon

[mecanizador]

GENIIEEEE DDD

[Animeworld<3]

hey, there are already some what to get pp lm m inis or the other?

[mecanizador]

you can enter them if instead of using portals u use wrap

[Horus19]

A little question:
The People who can add items to theriselves with #insert_item which Tutorial/Files did you used? I Used the TuT form JW988 and put the files from Link404 In the Database but nothing will work
Only Failures: If I Equip a Pet the Server Crashes, I Cant add Anything.