Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 22:32

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #3136
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
how come adding this as rdb in my client source it keeps crashing when opening character/pet skills?

Quote:
Originally Posted by thndr View Post
You need to dump the English string resource from an English client, then use a database tool to import it into the database.

You can have my RDB file to save you the effort of having to find a client and dump it...



Mslolita is offline  
Old   #3137
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
Did you make changes to it with Raskims Database Manager 2013?


ThunderNikk is offline  
Old   #3138
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
yes i did

Quote:
Originally Posted by thndr View Post
Did you make changes to it with Raskims Database Manager 2013?
Mslolita is offline  
Old   #3139
 
elite*gold: 0
Join Date: Jun 2010
Posts: 129
Received Thanks: 2
bonjour je cherche a activer le village cacher je ne ses plus ou ses merci de m'aider si sa vous derange pas biens sur


guildeur is offline  
Old   #3140
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Quote:
Originally Posted by Mslolita View Post
yes i did
Try this one .
Attached Files
File Type: rar DataBase to RDB.rar (165.0 KB, 47 views)
.BlackCat. is offline  
Thanks
2 Users
Old   #3141
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
Quote:
Originally Posted by Mslolita View Post
yes i did
That is why, Raskim's database manager causes that bug on the string resource.

There is an issue with the function translation on the skill tree tool tip strings.

The Database to RDB the BlackCat posted should help you out with that error.

Import the raw string resource as I gave it to you into your database. Edit the database as you need to, then use the Database to RDB to create a new string resource RDB with your edits.
ThunderNikk is offline  
Thanks
1 User
Old   #3142
 
elite*gold: 0
Join Date: Sep 2013
Posts: 36
Received Thanks: 3
Quote:
Originally Posted by DrMaRe View Post
Noch einmal eine frage,

kann man eigendlich sein Pet über ein NPC leveln lassen, wo ich auch das level aussuchen kann?

Code:
function Test()		

		dlg_title( "Pet Leveln" )
		dlg_text( "Pet bitte leveln" )

for i = 0, 5 do

		handle = 0
		handle = get_creature_handle( i )

if handle ~= 0 and handle ~= nil then

		lv = get_creature_value( handle, "level" )
		

		text = sconv("@90010009", "#@[email protected]#",tostring(get_creature_value( handle, "name" )) ,"#@[email protected]#",tostring(lv))

		command = 'level_setzen( ' .. handle .. ' )'

		dlg_menu( text, command )

end
end

	dlg_menu( "@90010003", "XY()" )	-- Zurück
	dlg_menu( "@90010002", '' ) -- Auf Wiedersehn
	dlg_show()

end
function level_setzen( handle, lv )

		petlv = get_creature_value( handle, "level" )
		
if petlv >= 0 then

		set_creature_value( handle, "level", petlv + 1 )
		--sv( "jp", playerJPs - 20000000)
		cprint( "<#FFCC33>Deine Kreatur hat einen Jobpunkt erhalten." )
		YY()

else

	dlg_title( "Tausch Shop" )
				
	dlg_text( "Hups, du hast leider nicht genug Jop-Punkte. Es tut mir leid!" )
				
	dlg_menu( "@90010003", "XY()" )	-- Zurück
	dlg_menu( "@90010002", '' ) -- Auf Wiedersehn
	dlg_show()

end
end


Das ist eine abgewandeltete function von JP traden


Über eine Antwort würde ich mich freuen!
DrMaRe is offline  
Old   #3143
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
thanks for letting me know.

what tools should work for importing to database the rdb you just shared?
(The Database to RDB the BlackCat) can't find it.

Quote:
Originally Posted by thndr View Post
That is why, Raskim's database manager causes that bug on the string resource.

There is an issue with the function translation on the skill tree tool tip strings.

The Database to RDB the BlackCat posted should help you out with that error.

Import the raw string resource as I gave it to you into your database. Edit the database as you need to, then use the Database to RDB to create a new string resource RDB with your edits.
Mslolita is offline  
Old   #3144
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Quote:
Originally Posted by Mslolita View Post
thanks for letting me know.

what tools should work for importing to database the rdb you just shared?
(The Database to RDB the BlackCat) can't find it.
I posted it in the Previous page.

.BlackCat. is offline  
Thanks
1 User
Old   #3145
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
thank you, but this tool only creates rdb from db.
is there any non bugged tool that imports rdb to database?

Quote:
Originally Posted by .BlackCat. View Post
I posted it in the Previous page.

Mslolita is offline  
Old   #3146
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Quote:
Originally Posted by Mslolita View Post
thank you, but this tool only creates rdb from db.
is there any non bugged tool that imports rdb to database?

I'll be off for couple of hours , I'll make you one & send it to you via PM when I come back .
.BlackCat. is offline  
Thanks
1 User
Old   #3147
 
elite*gold: 0
Join Date: Oct 2012
Posts: 124
Received Thanks: 12
how can i save every user ip who login in my server ?
by Authserver I mean .

& can i do same thing with Gameserver ?
log players ip & time ?
MrStubborn is offline  
Old   #3148
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Quote:
Originally Posted by MrStubborn View Post
how can i save every user ip who login in my server ?
by Authserver I mean .

& can i do same thing with Gameserver ?
log players ip & time ?
If you don't have dbo.IPLog Table on your Auth , create it using :


Code:
USE [Auth]
GO
/****** Object:  Table [dbo].[IPLog]    Script Date: 22/02/2014 08:28:23 ******/
DROP TABLE [dbo].[IPLog]
GO
/****** Object:  Table [dbo].[IPLog]    Script Date: 22/02/2014 08:28:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IPLog](
	[account_id] [int] NULL,
	[account_name] [nvarchar](32) NOT NULL,
	[ip] [nvarchar](50) NOT NULL,
	[login_date] [date] NOT NULL,
	[login_time] [time](7) NOT NULL
) ON [PRIMARY]

GO
INSERT [dbo].[IPLog] ([account_id], [account_name], [ip], [login_date], [login_time]) VALUES (8715, N'BlackCat', N'127.0.0.1', CAST(0x23380B00 AS Date), CAST(0x076099F554520000 AS Time))


& smp_account like that :

Code:
USE [Auth]
GO
/****** Object:  StoredProcedure [dbo].[smp_account]    Script Date: 22/02/2014 08:26:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[smp_account]
@IN_ACCOUNT nvarchar(31),
@IN_GAMECODE nvarchar(50),
@IN_PASSWORD nvarchar(32)
AS
SET NOCOUNT ON

DECLARE @THIS_ACCOUNT_ID INT
SELECT @THIS_ACCOUNT_ID=account_id FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT

INSERT INTO dbo.IPLog(
account_id,
account_name,
ip,
login_date,
login_time
)VALUES(
@THIS_ACCOUNT_ID,
@IN_ACCOUNT,
@IN_GAMECODE,
GETDATE(),
GETDATE()
)

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

RETURN @@ERROR
If you don't have "Accounts" table like mine . EDIT THE SMP .
.BlackCat. is offline  
Thanks
2 Users
Old   #3149
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
I must say thanks for al your help, i like the way you help people around.

i need some help with the ingame cashshop


i did change the Gameserver.opt:
T game.cash_usable_server:1

Launcher edit:
/shop.url:

i think i need a php file to make players login while they are registerd in SQL database to connect to the cashshop.
i tried the 7.3 100% cashshop files but it doesnt include the php that connects to SQL.
I would be thankful for your Help


Quote:
Originally Posted by .BlackCat. View Post
If you don't have dbo.IPLog Table on your Auth , create it using :


Code:
USE [Auth]
GO
/****** Object:  Table [dbo].[IPLog]    Script Date: 22/02/2014 08:28:23 ******/
DROP TABLE [dbo].[IPLog]
GO
/****** Object:  Table [dbo].[IPLog]    Script Date: 22/02/2014 08:28:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IPLog](
	[account_id] [int] NULL,
	[account_name] [nvarchar](32) NOT NULL,
	[ip] [nvarchar](50) NOT NULL,
	[login_date] [date] NOT NULL,
	[login_time] [time](7) NOT NULL
) ON [PRIMARY]

GO
INSERT [dbo].[IPLog] ([account_id], [account_name], [ip], [login_date], [login_time]) VALUES (8715, N'BlackCat', N'127.0.0.1', CAST(0x23380B00 AS Date), CAST(0x076099F554520000 AS Time))


& smp_account like that :

Code:
USE [Auth]
GO
/****** Object:  StoredProcedure [dbo].[smp_account]    Script Date: 22/02/2014 08:26:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[smp_account]
@IN_ACCOUNT nvarchar(31),
@IN_GAMECODE nvarchar(50),
@IN_PASSWORD nvarchar(32)
AS
SET NOCOUNT ON

DECLARE @THIS_ACCOUNT_ID INT
SELECT @THIS_ACCOUNT_ID=account_id FROM dbo.Accounts WHERE login_name = @IN_ACCOUNT

INSERT INTO dbo.IPLog(
account_id,
account_name,
ip,
login_date,
login_time
)VALUES(
@THIS_ACCOUNT_ID,
@IN_ACCOUNT,
@IN_GAMECODE,
GETDATE(),
GETDATE()
)

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

RETURN @@ERROR
If you don't have "Accounts" table like mine . EDIT THE SMP .
Mslolita is offline  
Old   #3150
 
elite*gold: 0
Join Date: Oct 2011
Posts: 42
Received Thanks: 5
How to convert string resource to rdb correctly? I tried real database manager and convert db to rdb, but both of them display some estrange text (like "MAX HP + 0000.00000") in skills. thanks in advance


KirieZ is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 22:32.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.