Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 10:09

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Help ! Nub Question

Discussion on Help ! Nub Question within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Sep 2009
Posts: 17
Received Thanks: 0
Unhappy 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
MOri750 is offline  
Old 09/15/2012, 00:46   #2
 
TeddyBear94's Avatar
 
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!
TeddyBear94 is offline  
Thanks
2 Users
Old 09/15/2012, 01:07   #3
 
elite*gold: 0
Join Date: Sep 2009
Posts: 17
Received Thanks: 0
Quote:
Originally Posted by TeddyBear94 View Post
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
MOri750 is offline  
Old 09/15/2012, 01:17   #4
 
JohnHeatz's Avatar
 
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:

JohnHeatz is offline  
Thanks
2 Users
Old 09/15/2012, 01:24   #5
 
x-DoeSn'TxMaTTeR-x's Avatar
 
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 >.<
x-DoeSn'TxMaTTeR-x is offline  
Thanks
2 Users
Old 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
MOri750 is offline  
Reply


Similar Threads Similar Threads
[Question] Wie ruft man in AutoIt eine Website per knopfdruck auf [Question]
08/04/2011 - AutoIt - 7 Replies
Wie ruft man eine Website per knopfdruck in AutoIt auf? Wenn geht Code und nochbesser Erklärung bei :D Danke schonmal im voraus :handsdown:



All times are GMT +1. The time now is 10:09.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.