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 .
this for old Auth
it's not work with Auth V2
thanks any way
EDIT: i have try to change columns name but still give an ERROR message in Authserver
deutsch
moin moin.problem 1. 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.
problem 2.. Wenn ich die string resourcen änder und sie dann in meine resourcen vom client tu funktioniert alles wunderbar nur ein fehler kommt alle skillkarten zeigen kein wert mehr an zb patk 200 der zeigt danach nur noch patk %value% woran kann das liegen das er das ändert...
english
moin.. problem 1.. Can someone maybe give me a tip what could be there that all my soulpets have the attributes vit, int, str, etc 0 ? In the db I have already looked at statresourcen there are stat registered for soulpets and have hashed as a trial and but done in the resouces folder still the stats at 0 soulpets .... whats i can make..
problem 2...If I change the string resouces and i put it to my rescource from client then works .why all skill cards not worth more to eg patk 200 of the shows after that only patk %value% why he change that. ..
--Àü±¹°¡ °øÅë
local state_code = get_local_info()
--if state_code = 32 then
if race == 4 then
if get_env("game.use_auto_trap") == 1 then
open_popup("game.caution_url", "game.newbiehelp_deva_url", 0,1)
else
open_popup("game.newbiehelp_deva_url", 0,1)
end
elseif race == 5 then
if get_env("game.use_auto_trap") == 1 then
open_popup("game.caution_url", "game.newbiehelp_asura_url", 0,1)
else
open_popup("game.newbiehelp_asura_url", 0,1)
end
else
if get_env("game.use_auto_trap") == 1 then
open_popup("game.caution_url", "game.newbiehelp_gaia_url", 0,1)
else
open_popup("game.newbiehelp_gaia_url", 0,1)
end
-- end
--else
--±âÁ¸ ´ë¸¸ Á¦°Å
--local state_code = get_local_info()
--if state_code ~= 32 then
-- --if race == 4 then
-- --if get_env("game.use_auto_trap") == 1 then
-- open_popup("game.caution_url", "game.newbiehelp_deva_url", 0,1)
-- else
-- open_popup("game.newbiehelp_deva_url", 0,1)
-- end
-- elseif race == 5 then
-- if get_env("game.use_auto_trap") == 1 then
-- open_popup("game.caution_url", "game.newbiehelp_asura_url", 0,1)
-- else
-- open_popup("game.newbiehelp_asura_url", 0,1)
-- end
-- else
-- if get_env("game.use_auto_trap") == 1 then
-- open_popup("game.caution_url", "game.newbiehelp_gaia_url", 0,1)
-- else
-- open_popup("game.newbiehelp_gaia_url", 0,1)
-- end
-- end
[Helping Topic] 24/7 Helping Services! 08/27/2008 - EO PServer Hosting - 31 Replies 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 :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""