|
You last visited: Today at 10:09
Advertisement
Help ! Nub Question
Discussion on Help ! Nub Question within the Shaiya Private Server forum part of the Shaiya category.
09/15/2012, 00:38
|
#1
|
elite*gold: 0
Join Date: Sep 2009
Posts: 17
Received Thanks: 0
|
Help ! Nub Question
Hi guys, im super nub at this just trying to install a server have fun test some stuff not going to run any server , here is the thing i Follow this Guide everything is ok server is up but when i try to log in with admin account its says Account dose not Exit so after searching i figure out i have to add admin in database in dbo.Users_Master , now my question is how to do it any Screen shot , video any help would be nice
like i said im Super nub lol just trying to learn slowly i spent 48 hour lol so plz help
also this is the EP 5.3 i try to install
thanks
|
|
|
09/15/2012, 00:46
|
#2
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,625
|
first of all u need to use the search function ur problem was posted several times already + search in youtube aswell. there are some nice vids about that. and using 48h to work on that thing is to less time u will need much more time!
|
|
|
09/15/2012, 01:07
|
#3
|
elite*gold: 0
Join Date: Sep 2009
Posts: 17
Received Thanks: 0
|
Quote:
Originally Posted by TeddyBear94
first of all u need to use the search function ur problem was posted several times already + search in youtube aswell. there are some nice vids about that. and using 48h to work on that thing is to less time u will need much more time!
|
i did search like i said im new to my sql and just need a little help to understand how to add the admin there even an screen shot would help
|
|
|
09/15/2012, 01:17
|
#4
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,976
|
You didn't use it well, because here is the link to the thread:
|
|
|
09/15/2012, 01:24
|
#5
|
elite*gold: 0
Join Date: Aug 2012
Posts: 152
Received Thanks: 71
|
Leave RowId as it is,
Quote:
UserId = ur Username
Password= Ur password
JoinDate= leave it as it is
Admin= (your choise..True for admin False for normal)
AdminLevel= 255 for admin 0 for normal
Usequeue= False
Status= 16 for admin 0 for normal
Leave= 0
LeaveDate= leave it as it is
Usertype= A for admin N for normal
|
Leave the rest as it is.
Don't know what everything mean but this should let you create a new ID.
Ah!
After this you will probably have the account name problem that already exist...Well if you will
Open the ServerManagmentStudio and do a new query and past this in:
Quote:
USE [PS_GameData]
GO
drop procedure [dbo].[usp_Save_Char_Item_Add_E]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/
CREATE Proc usp_Save_Char_Item_Add_E
@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@MaketimeZ varchar(50),
@Maketype char(1)
AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)
--SET NOCOUNT ON
IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END
INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
--SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
|
Then press execute and you will slove the problem...So you won't start another post like this >.<
|
|
|
09/15/2012, 01:30
|
#6
|
elite*gold: 0
Join Date: Sep 2009
Posts: 17
Received Thanks: 0
|
thanks for quick reply guys i missed that video lol
|
|
|
All times are GMT +1. The time now is 10:09.
|
|