[Help Thread] Please post your questions here.

Quote:

Originally Posted by thndr Did you make changes to it with Raskims Database Manager 2013?

Quote:

Originally Posted by Mslolita yes i did

Quote:

Originally Posted by Mslolita yes i did

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

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.

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.

Quote:

Originally Posted by .BlackCat. I posted it in the Previous page. [Only registered and activated users can see links. Click Here To Register...]

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?

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 ?

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

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

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 .