[Help Thread] Please post your questions here.

ThunderNikk · 02/21/2014, 12:51

Did you make changes to it with Raskims Database Manager 2013?

Mslolita · 02/21/2014, 14:39

yes i did

Quote:

Originally Posted by thndr

Did you make changes to it with Raskims Database Manager 2013?

~~guildeur~~ · 02/21/2014, 14:41

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

.BlackCat. · 02/21/2014, 14:45

Quote:

Originally Posted by Mslolita

yes i did

Try this one .

ThunderNikk · 02/21/2014, 15:15

Quote:

Originally Posted by Mslolita

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.

DrMaRe · 02/21/2014, 15:54

Quote:

Originally Posted by DrMaRe

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", "#@creature_name@#",tostring(get_creature_value( handle, "name" )) ,"#@creature_level@#",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!

Mslolita · 02/21/2014, 16:04

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

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.

.BlackCat. · 02/21/2014, 16:51

Quote:

Originally Posted by Mslolita

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.

Mslolita · 02/21/2014, 18:28

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.

I posted it in the Previous page.

.BlackCat. · 02/21/2014, 18:38

Quote:

Originally Posted by Mslolita

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 .

MrStubborn · 02/22/2014, 07:11

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 ?

.BlackCat. · 02/22/2014, 08:34

Quote:

Originally Posted by MrStubborn

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 .

Mslolita · 02/22/2014, 08:58

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.

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 .

KirieZ · 02/22/2014, 18:16

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

Makenci · 02/22/2014, 19:33

Kann mir jemand vielleicht ein tip geben woran es liegen kann das alle meine soulpets die Attribute vit, int, str, usw 0 haben?? In der db hatte ich schon geguckt bei statresourcen da sind stat eingetragen für die soulpets und hatte dies auch als versuch gehasht und in den resourcen ordner getan aber weiterhin die stats 0 bei soulpets.... mir fällt leider nichts mehr ein was man machen könnte