[HELP]Shaiya SQL New Installation Problem!

[PlugMan]

Hello E*PvP brothers !

While changing database password the link with server failed
I run the query Shaiya SQL New Installation from the Shaiya folder but still testing connection is not working ! ( The Test Connection with server failed )
and i can't run the game

The query i run :

 Spoiler

/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
EXEC sp_addlogin 'LIDA9493Mm', '1502SI2806mM', 'PS_GameDefs';
END
EXEC sp_addsrvrolemember 'LIDA9493Mm', 'sysadmin';

TRUNCATE TABLE PS_UserData.dbo.Users_Master;
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
TRUNCATE TABLE PS_UserData.dbo.Users_Detail;

if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'LIDA9493Mm','1502SI2806mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'LIDA9493Mm','1502SI2806mM '

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'LIDA9493Mm','1502SI2806m M'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'LIDA9493Mm','1502SI280 6mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_DEFINEDB')
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'LIDA9493Mm','1502SI280 6mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_GAMEDB01')
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'LIDA9493Mm','1502SI280 6mM'

/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
VALUES (1,'gmlight', 'gmlight123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END


IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
(UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPWD,CreateDate)
VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Detail
(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQue stion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,S ms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer' ,'email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'0','0',
'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END

What should i do now?

Thank you

[hronolight]

Originally Posted by PlugMan

What should i do now?

Stop creating a topic every day and learn at least something.

[XareL]

You can solve problems outside of Shaiya by searching from google

you can not learn everything from this forum

[Wa7dani]

delete this :


/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
VALUES (1,'gmlight', 'gmlight123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END


IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
(UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPWD,CreateDate)
VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Detail
(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQue stion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,S ms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer' ,'email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'0','0',
'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END

[[MXD]Takeshi]

Originally Posted by Wa7dani

delete this :


/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
VALUES (1,'gmlight', 'gmlight123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END


IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
(UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPWD,CreateDate)
VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Detail
(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQue stion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,S ms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer' ,'email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'0','0',
'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END

Not is here the problem.... it only create the user for first login, if already exist it dont do nothing

Originally Posted by PlugMan

Hello E*PvP brothers !

While changing database password the link with server failed
I run the query Shaiya SQL New Installation from the Shaiya folder but still testing connection is not working ! ( The Test Connection with server failed )
and i can't run the game

The query i run :

 Spoiler

/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
EXEC sp_addlogin 'LIDA9493Mm', '1502SI2806mM', 'PS_GameDefs';
END
EXEC sp_addsrvrolemember 'LIDA9493Mm', 'sysadmin';

TRUNCATE TABLE PS_UserData.dbo.Users_Master;
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
TRUNCATE TABLE PS_UserData.dbo.Users_Detail;

if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'LIDA9493Mm','1502SI2806mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'LIDA9493Mm','1502SI2806mM '

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'LIDA9493Mm','1502SI2806m M'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'LIDA9493Mm','1502SI280 6mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_DEFINEDB')
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'LIDA9493Mm','1502SI280 6mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_GAMEDB01')
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'LIDA9493Mm','1502SI280 6mM'

/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
VALUES (1,'gmlight', 'gmlight123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END


IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
(UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPWD,CreateDate)
VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Detail
(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQue stion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,S ms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer' ,'email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'0','0',
'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END

What should i do now?

Thank you

you need fix your link server file...

 Spoiler

if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'LIDA9493Mm','1502SI2806mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'LIDA9493Mm','1502SI2806mM '

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'LIDA9493Mm','1502SI2806m M'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'LIDA9493Mm','1502SI280 6mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_DEFINEDB')
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'LIDA9493Mm','1502SI280 6mM'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_GAMEDB01')
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'LIDA9493Mm','1502SI280 6mM'

delete old link server, change user and psw...
DELETE the user LIDA9493Mm created with ur old script.

[{Skrillex}]

You can´t have an space in your DB User Name or pass. Edit it and it should works fine.