Rappelz server files

Page 70 of 154

05/14/2011 17:46 Gangxtar1#1036

a few ITEM-IDs:

05/14/2011 17:46 lilnani#1037

any one can help

i download ageofrappelz client but the same error
i restore the db 3 times nothing happened
[Only registered and activated users can see links. Click Here To Register...]

05/14/2011 17:50 Gangxtar1#1038

lilnani got this 2 ?

Account table:

Spoiler

Account procedure:

Spoiler

05/14/2011 18:37 TheStranger#1039

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

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 =)

05/14/2011 19:02 lilnani#1040

Quote:

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

05/14/2011 19:44 kaizoku801#1041

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)

05/14/2011 20:04 Horus19#1042

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

05/14/2011 20:21 vitale3#1043

[Only registered and activated users can see links. Click Here To Register...]
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

05/14/2011 20:26 mecanizador#1044

i just found out a way to change pets :D
u just buy a koala and go to:
arcadia- then tables and then dbo.summonresource :D
there u find a code(id)...
after go to telecaster...tables...dbo.summon and change your pet id and there you gooo! :D
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 :D)
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 ?

05/14/2011 20:29 Cylar#1045

Quote:

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 ?

05/14/2011 20:54 Chaosnightmare#1046

Fixed Genie and Ifrit, Tutorial soon :)

05/14/2011 20:55 mecanizador#1047

GENIIEEEE :DDDD

05/14/2011 20:57 Animeworld<3#1048

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

05/14/2011 21:04 mecanizador#1049

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

05/14/2011 21:06 Horus19#1050

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.

Page 70 of 154

« First

120

Last »