|
You last visited: Today at 03:07
Advertisement
Rappelz server files
Discussion on Rappelz server files within the Rappelz Private Server forum part of the Rappelz category.
05/14/2011, 17:46
|
#1036
|
elite*gold: 0 
Join Date: Aug 2008
Posts: 596
Received Thanks: 171
|
a few ITEM-IDs:
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
|
|
|
|
05/14/2011, 17:46
|
#1037
|
elite*gold: 0
Join Date: Feb 2011
Posts: 597
Received Thanks: 174
|
any one can help
i download ageofrappelz client but the same error
i restore the db 3 times nothing happened
|
|
|
|
|
05/14/2011, 17:50
|
#1038
|
elite*gold: 0
Join Date: Aug 2008
Posts: 596
Received Thanks: 171
|
lilnani got this 2 ?
Account table:
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:
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
|
|
|
|
|
05/14/2011, 18:37
|
#1039
|
elite*gold: 0
Join Date: May 2011
Posts: 41
Received Thanks: 30
|
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
|
#1040
|
elite*gold: 0
Join Date: Feb 2011
Posts: 597
Received Thanks: 174
|
Quote:
Originally Posted by Gangxtar1
lilnani got this 2 ?
Account table:
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:
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
|
#1041
|
elite*gold: 0
Join Date: May 2008
Posts: 339
Received Thanks: 69
|
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
|
#1042
|
elite*gold: 65
Join Date: May 2010
Posts: 2,265
Received Thanks: 128
|
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
|
#1043
|
elite*gold: 0
Join Date: Mar 2010
Posts: 15
Received Thanks: 1
|
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
|
#1044
|
elite*gold: 0
Join Date: Jul 2010
Posts: 156
Received Thanks: 7
|
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 ?
|
|
|
|
|
05/14/2011, 20:29
|
#1045
|
elite*gold: 0
Join Date: Aug 2008
Posts: 313
Received Thanks: 18
|
Quote:
Originally Posted by Gangxtar1
lilnani got this 2 ?
Account table:
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:
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
|
#1046
|
elite*gold: 1
Join Date: Dec 2009
Posts: 258
Received Thanks: 140
|
Fixed Genie and Ifrit, Tutorial soon 
|
|
|
|
|
05/14/2011, 20:55
|
#1047
|
elite*gold: 0
Join Date: Jul 2010
Posts: 156
Received Thanks: 7
|
GENIIEEEE DDD
|
|
|
|
|
05/14/2011, 20:57
|
#1048
|
elite*gold: 2
Join Date: Feb 2009
Posts: 61
Received Thanks: 2
|
hey, there are already some what to get pp lm m inis or the other?
|
|
|
|
|
05/14/2011, 21:04
|
#1049
|
elite*gold: 0
Join Date: Jul 2010
Posts: 156
Received Thanks: 7
|
you can enter them if instead of using portals u use wrap
|
|
|
|
|
05/14/2011, 21:06
|
#1050
|
elite*gold: 65
Join Date: May 2010
Posts: 2,265
Received Thanks: 128
|
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.
|
|
|
|
Similar Threads
|
Rappelz Server-Files
02/17/2012 - Rappelz - 10 Replies
Hy,
Here the Server-Files From Rappelz.
The Files are From Gpotato
and the Language is german.
This Downloads has all Information
witch i have .
I can't give support for this Files .
Thanks For Understanding
And
|
Is there anyone there has the Rappelz server files?
04/08/2011 - Rappelz - 4 Replies
Is there anyone there has the Rappelz server files?
I just wanna know becouse I relly need them..
If nobody have them cant we just "grab" the data? we got the ip's?
|
All times are GMT +1. The time now is 03:09.
|
|
