[Video Tutorials] Shaiya EP4 Private Server By Omega

08/14/2011 02:11 Autrux#406
I have a problem when i will creat a character it says name already in use?
08/14/2011 02:35 xaoz#407
Quote:
Originally Posted by 12Renton View Post
I have a problem when i will creat a character it says name already in use?
Mee ttooo please help!! T_T
08/14/2011 04:06 stinka123#408
use this ps_gamedata restore to your SQL ps_gamedata, im sure its can fix your prob
download: [Only registered and activated users can see links. Click Here To Register...]
08/14/2011 05:14 xaoz#409
Quote:
Originally Posted by stinka123 View Post
use this ps_gamedata restore to your SQL ps_gamedata, im sure its can fix your prob
download: [Only registered and activated users can see links. Click Here To Register...]
how do you restore ??? ps_gamedata ???

and thks for help! >_<
(sorry for my english soso T_T )
08/14/2011 05:19 JohnHeatz#410
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
08/14/2011 08:13 alexistheboss15#411
guys do u have any idea why i cant login to the SQL? i posted the log before..
08/14/2011 08:20 JohnHeatz#412
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
08/14/2011 08:58 alexistheboss15#413
do u knw which files? and how to look for them? sorries i am nub just trying to learn.
08/14/2011 18:01 xaoz#414
Quote:
Originally Posted by JohnHeatz View Post
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!!
08/14/2011 22:18 JohnHeatz#415
Code:
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:
[Only registered and activated users can see links. Click Here To Register...]

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)
08/14/2011 23:48 xaoz#416
thks JohnHeatz the problem was solved
(muchas gracias por la respuesta y si funciono y gracias a arutema )

>_<
08/15/2011 07:54 alexistheboss15#417
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

Quote:
Originally Posted by xaoz View Post
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.
08/15/2011 11:05 [GM]Twinky#418
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
08/15/2011 11:18 alexistheboss15#419
Quote:
Originally Posted by [GM]Twinky View Post
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:
[Only registered and activated users can see links. Click Here To Register...]


Here is the error in screenShot:
[Only registered and activated users can see links. Click Here To Register...]
so i select my computer name...
then i press ok: this is how it is configured:
[Only registered and activated users can see links. Click Here To Register...]
and this is what comes up when i press connect:
[Only registered and activated users can see links. Click Here To Register...]
08/15/2011 11:37 [GM]Twinky#420
you are miss some files