|
You last visited: Today at 03:12
Advertisement
[HELP] Remove OMG_Gameweb from New SQL
Discussion on [HELP] Remove OMG_Gameweb from New SQL within the Shaiya Private Server forum part of the Shaiya category.
09/14/2013, 11:18
|
#1
|
elite*gold: 0
Join Date: Mar 2012
Posts: 2
Received Thanks: 3
|
[HELP] Remove OMG_Gameweb from New SQL
How to I remove the OMG_Gameweb from the new SQL new installation.sql ?
Code:
/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END
EXEC sp_addsrvrolemember 'Shaiya', '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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
/* 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,PwQuestion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,Sms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer','email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0',
'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END
I do not have the OMG_Gameweb database. Thats why I need to remove it from the query. Thx for any info on this
|
|
|
09/14/2013, 11:44
|
#2
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,451
|
Quote:
Code:
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
|
This is what you have to remove from your query.
|
|
|
09/15/2013, 01:34
|
#3
|
elite*gold: 0
Join Date: Mar 2012
Posts: 2
Received Thanks: 3
|
When I remove that it still give me an error.
Msg 4701, Level 16, State 1, Line 9
Cannot find the object "GameAccountTBL" because it does not exist or you do not have permissions.
This is what i have with out what you said nubness. Thx for responding btw.
Code:
/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END
EXEC sp_addsrvrolemember 'Shaiya', '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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
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,'Shaiya','Shaiya123'
/* 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 PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Detail
(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQuestion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,Sms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer','email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0',
'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END
And when I try to remove anything thats says OMG_Gameweb it just gives more errors. I saw somewhere that someone said to patch the loging over it but didnt really say anything else and im not sure what they mean by that.
|
|
|
09/15/2013, 10:36
|
#4
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,451
|
Since we're not totally aware of your real situation, why don't you simply attach the OMG_GameWeb database ? It never harms.
|
|
|
09/22/2013, 14:51
|
#5
|
elite*gold: 1
Join Date: Dec 2010
Posts: 33,281
Received Thanks: 5,715
|
#closed
|
|
|
Similar Threads
|
[Request Help] Remove mobs / remove eur items / remove npc
02/15/2013 - SRO Private Server - 0 Replies
Iam sure all now saies this guy is mad :D why not remove the db
i want to know how i can remove mobs from samrkand and add alex mobs there and remove eur item from npc and drobs
and remove some npcs
ty guys
_________________________
I see that there is too much help here
it's my topic no.2
without any answer
|
[REQUEST]OMG_GameWEB
02/19/2012 - Shaiya Private Server - 3 Replies
Hi all I just wanted to ask if someone could upload a OMG_GameWEB file to attach because I messed something up and can't log into the game.....
and I don't have it anymore in my DB.
Tried to reinstall :rtfm: but get errors so could someone do that for me please... :handsdown:
|
All times are GMT +2. The time now is 03:12.
|
|