Help ! Nub Question

09/15/2012 00:38 MOri750#1

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 [Only registered and activated users can see links. Click Here To Register...] 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
[Only registered and activated users can see links. Click Here To Register...]
thanks

09/15/2012 00:46 TeddyBear94#2

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! :p

09/15/2012 01:07 MOri750#3

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! :p

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 JohnHeatz#4

You didn't use it well, because here is the link to the thread:

[Only registered and activated users can see links. Click Here To Register...]

09/15/2012 01:24 x-DoeSn'TxMaTTeR-x#5

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 MOri750#6

thanks for quick reply guys i missed that video lol