[Video Tutorials] Shaiya EP4 Private Server By Omega

[Autrux]

I have a problem when i will creat a character it says name already in use?

[xaoz]

Originally Posted by 12Renton

I have a problem when i will creat a character it says name already in use?

Mee ttooo please help!! T_T

[stinka123]

use this ps_gamedata restore to your SQL ps_gamedata, im sure its can fix your prob
download:

[xaoz]

Originally Posted by stinka123

use this ps_gamedata restore to your SQL ps_gamedata, im sure its can fix your prob
download:

how do you restore ??? ps_gamedata ???

and thks for help! >_<
(sorry for my english soso T_T )

[JohnHeatz]

Right click on database (first you will need to de attatch your PS_GameData) then on actions and restore, it will show you a window for you to choose the backup file you want to restore, after that everything is pretty self explanatory

[alexistheboss15]

guys do u have any idea why i cant login to the SQL? i posted the log before..

[JohnHeatz]

That log shows that you are missing some files, look for those files, and if they are actually there, uninstall SQL from your computer and install it again

[alexistheboss15]

do u knw which files? and how to look for them? sorries i am nub just trying to learn.

[xaoz]

Originally Posted by JohnHeatz

Right click on database (first you will need to de attatch your PS_GameData) then on actions and restore, it will show you a window for you to choose the backup file you want to restore, after that everything is pretty self explanatory

try several times but the problem remains the same

PS_GameData T_T (character it says name already in use)..... and thanks for help! X_x!!

[JohnHeatz]

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

Credits to arutema, everything you might need is in here:


As for alexis:
Root element is missing. (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Con fig\machine.config) (System.Configuration)

Root element is missing. (System.Xml)

[xaoz]

thks JohnHeatz the problem was solved
(muchas gracias por la respuesta y si funciono y gracias a arutema )

>_<

[alexistheboss15]

would it work if somebody gave me the files?

cause i re-installed it very carefully like 3 times, i redownloaded it etc....


ok i found the machine.config, what do i do with it o.o?
i cant open it, it says error if it try open it. how do i knw if System.xml is there or not?


sorry for being such a nub

Originally Posted by xaoz

thks JohnHeatz the problem was solved
(muchas gracias por la respuesta y si funciono y gracias a arutema )

>_<

pls thanks people when they help u out.

[[GM]Twinky]

I would suggest the following steps, so you can solve your problem. To do this go to the start and after that make a hit on the control panel. Now, under the control panel go to Add / Remove Programs and that is the Microsoft. NET Framework 3.5 SP1 and then remove or uninstall. Now that you uninstall the product on your system: Microsoft. NET Framework 3.0 Service Pack 2, Microsoft NET Framework 2.0 Service Pack 2. Now once that is completed, download the Microsoft. NET Framework 3.5 SP1 from official site. And then install and also install the other. Net framework as well.


try this alexisthboss12

[alexistheboss15]

Originally Posted by [GM]Twinky

I would suggest the following steps, so you can solve your problem. To do this go to the start and after that make a hit on the control panel. Now, under the control panel go to Add / Remove Programs and that is the Microsoft. NET Framework 3.5 SP1 and then remove or uninstall. Now that you uninstall the product on your system: Microsoft. NET Framework 3.0 Service Pack 2, Microsoft NET Framework 2.0 Service Pack 2. Now once that is completed, download the Microsoft. NET Framework 3.5 SP1 from official site. And then install and also install the other. Net framework as well.


try this alexisthboss12

i dont have this....
this is screenshot of all programs i have on my computer:



Here is the error in screenShot:

so i select my computer name...
then i press ok: this is how it is configured:

and this is what comes up when i press connect:

[[GM]Twinky]

you are miss some files