Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 11:21

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

Advertisement



Error about Notice Board

Discussion on Error about Notice Board within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2010
Posts: 343
Received Thanks: 87
Error about Notice Board

Hello All, i try to find one solution to one pb about notice board...
In fact when i put in game one Auction to the board i get ony things in my database and when i down the server, i get error conversion varchar in datetime. The same error that u can get with other stored process like error 0 for warehouse stored or take in item mall but resolved with one simply command but from board i dont arrive i show u the log in the rar joined ... Thx to help me <3

and here i publish the query problem xD
usp_Market_ADD
PHP Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Market_ADD]    Script Date: 12/26/2011 19:37:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO







ALTER    Proc 
[dbo].[usp_Market_ADD]

@
MarketID        int,
@
CharID         int,
@
MinMoney        int,
@
DirectMoney        int,
@
MarketType        tinyint,

@
GuaranteeMoney    int,
@
TenderCharID        int,
@
TenderMoney        int,
@
EndDate        datetime,

@
ItemID         int,
@
ItemUID         bigint,

@
Type             tinyint,
@
TypeID         tinyint,
@
Quality         int,
@
Gem1         tinyint,
@
Gem2         tinyint,
@
Gem3         tinyint,
@
Gem4         tinyint,
@
Gem5         tinyint,
@
Gem6         tinyint,
@
Craftname         varchar(20) = ''
@
Count         tinyint,
@
Maketime         datetime,
@
Maketype         char(1),
@
TenderCharName    varchar(20) = ''
AS

SET NOCOUNT ON

BEGIN TRAN

INSERT INTO 
[MarketItems]([MarketID], [ItemID], [ItemUID], [Type], [TypeID], [Quality], [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype])
VALUES( @MarketID, @ItemID, @ItemUID, @Type, @TypeID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4, @Gem5, @Gem6, @Craftname, @Count, @Maketime,  @Maketype     )

IF( @@
ERROR <> )
BEGIN
    ROLLBACK TRAN
    
RETURN 0
END

INSERT INTO 
[Market]( [MarketID], [CharID], [MinMoney], [DirectMoney], [MarketType], [GuaranteeMoney], [TenderCharID], [TenderCharName], [TenderMoney],[EndDate])
VALUES( @MarketID, @CharID, @MinMoney, @DirectMoney, @MarketType, @GuaranteeMoney, @TenderCharID, @TenderCharName, @TenderMoney, @EndDate )

IF( @@
ERROR <> )
BEGIN
    ROLLBACK TRAN
    
RETURN 0
END

COMMIT TRAN

RETURN 1



SET NOCOUNT OFF 

andthe other pb of conversion i resolve by it...

PHP Code:
ALTER  Proc [dbo].[usp_Save_Guild_StoredItem_Add_E]

@
GuildID int,
@
ItemUID bigint,
@
Slot tinyint,
@
ItemID int,
@
Type tinyint,
@
TypeID tinyint,
@
Quality smallint,
@
Gem1 tinyint,
@
Gem2 tinyint,
@
Gem3 tinyint,
@
Gem4 tinyint,
@
Gem5 tinyint,
@
Gem6 tinyint,
@
Craftname varchar(20) = ''
@
Count tinyint,
[
B]@MaketimeZ varchar(50),
@
Maketype char(1)

AS
DECLARE @
Maketime as datetime
SELECT 
@Maketime CONVERT(datetime, @MaketimeZ120)[/B
but the same on first dont work

I precise the management studio is french ... i was thinking to passed him in english but can correct this pb ... and i change my PsData in data base and stilll same pb

wait ur answer thx much
Attached Files
File Type: rar Log.rar (3.5 KB, 25 views)
_Diavolino_ is online now  
Old 12/28/2011, 23:21   #2
 
elite*gold: 0
Join Date: May 2010
Posts: 343
Received Thanks: 87
So i think no ideas from no one ... lol

Same if u get a little interest to this request ? xD please xD
_Diavolino_ is online now  
Old 12/29/2011, 07:25   #3
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
I haven't tested this, but I would, firstly, try to do this change:

Code:
INSERT INTO [MarketItems] ([MarketID], [ItemID], [ItemUID], [Type], [TypeID], 
[Quality], [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], 
[Gem6], [Craftname], [Count], [Maketime], [Maketype])
VALUES (@MarketID, @ItemID, @ItemUID, @Type, @TypeID, @Quality, @Gem1, @Gem2, @Gem3, 
@Gem4, @Gem5, @Gem6, @Craftname, @Count, 
[B](convert(datetime, @Maketime))[/B],  @Maketype)
JohnHeatz is offline  
Thanks
3 Users
Old 12/30/2011, 14:12   #4
 
elite*gold: 0
Join Date: May 2010
Posts: 343
Received Thanks: 87
Thx Much Will try today and will let u read the consequence xD

so a forcely this replace to my query to usp_Market_ADD still give error in dbagent and let all item from notice board disapear and no link between notice board game and database ... cuz i dont find this item in my database in market i means... maybe there is one story with usp_Market_INIT or usp_Market_DEL ??? Thx for ur help


Edit : The error come Well from this comvertion of varchar in datetime and this u should to increament in all query in fonction of market Notice Board...

...
@MaketimeZ varchar(50),
@Maketype char(1)
...
AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)

And all the item put now sucess to be save and no error come on THx to ur Help love ur Work xD
_Diavolino_ is online now  
Reply


Similar Threads Similar Threads
Notice Board
06/06/2011 - Shaiya - 2 Replies
Ok so i followed omega's vid's to the T i am able to get game up and logged into game under account but when i try to go in game says failed to connect to game server anyone got any help or can point me in the right way hit me up here or on skype at thesyn840
IP Board Error .
03/26/2011 - Technical Support - 1 Replies
Hey ich habe ein Problem mit IP Board 2.3.5 . Ich hab es installiert und dann die Seite geöffnet dann kam das: Das Problem :( Klickt auf dem Bild, dann kommt ihr zu Homepage. BITTE UM HILFE !
KO Board Help - Error In Console
06/23/2010 - CO2 Private Server - 8 Replies
I used kinshi's KO board code for 5017, and when I try to login this happens: http://img22.imageshack.us/img22/5350/80879294.jp g Help will be appreciated!
*Notice*Warning Password stealing site*Notice*
12/28/2009 - World of Warcraft - 0 Replies
Notice is as follows, do not enter this site, if you get a notice in your email like this for gawd sakes dont give anyone your password Subject:World of Warcraft Account Trade Dispute Notice When we carry out a routine check when the account, we have evidence to show that your account has been involved in the disputed transactions. So we have to inform you visit our website(worldofwarcraft*com]fill out some information to facilitate our investigation. If you can not tie in with our soon...



All times are GMT +1. The time now is 11:27.


Powered by vBulletin®
Copyright ©2000 - 2025, 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 ©2025 elitepvpers All Rights Reserved.