[Request] Fiesta Launcher

[hannesa]

I did not say to remove the procedure. I said to remove "[ACCDB]". This call function is not needed. It just gives the procedure more steps, which is not necessary. Therefore it can be removed.

Attachment 155236 <---- like this................................

This is not a removal, its replacing the original
EXEC [ACCDB].dbo.usp_Charge_ItemDraw @Row_NO, @user_NO, @ret OUTPUT

with

EXEC Account.dbo.usp_Charge_ItemDraw @Row_NO, @user_NO, @ret OUTPUT

and this was exactly what @xArva said.

Don't know where your problem is/was.

[aqua512]

So tell me how is this:
ALTER PROCEDURE [dbo].[usp_ChargeItem_Draw]
@Row_NO INT,
@user_NO INT,
@ret INT = 0 OUTPUT
AS
BEGIN
SET NOCOUNT ON
SET LOCK_TIMEOUT 5000

EXEC [ACCDB].Account.dbo.usp_Charge_ItemDraw @Row_NO, @user_NO, @ret OUTPUT

SET NOCOUNT OFF
SET LOCK_TIMEOUT -1
END


This:
ALTER PROCEDURE [dbo].[usp_ChargeItem_Draw]
@Row_NO INT,
@user_NO INT,
@ret INT = 0 OUTPUT
AS
BEGIN
SET NOCOUNT ON
SET LOCK_TIMEOUT 5000

EXEC Account.dbo.usp_Charge_ItemDraw @Row_NO, @user_NO, @ret OUTPUT

SET NOCOUNT OFF
SET LOCK_TIMEOUT -1
END

If you cannot see the difference, you sir are blind. Loool. Oh and I did not mod the code before posting it. I just copied it right from the original character DB and the fixed Char DB. So please tell me how in the world your example is even a valid argument. Hell even in your example it was changed. I am trying to direct the correct way to fix the issue. Not all of us like these crap work arounds and junk codes. Some of us like to have things proper. On top of that, that is not what xArva said to do. He instructed the thread poster to change "[ACCDB].Account.dbo.usp_Charge_ItemDraw @Row_NO, @user_NO, @ret OUTPUT" with "[World00_Character].Account.dbo.usp_Charge_ItemDraw @Row_NO, @user_NO, @ret OUTPUT" So once again how is your argument even valid?

Look for procedure usp_ChargeItem_Draw. Change [ACCDB] to [World00_Character] or what ever you have the Character DB named.

[xArva]

But it's working fine. So idk what you want :O
Maybe there are some unuseful lines, but it's still a fix if you correct the [ACCDB](...) to [World00_Character](...) .

[aqua512]

But it's working fine. So idk what you want :O
Maybe there are some unuseful lines, but it's still a fix if you correct the [ACCDB](...) to [World00_Character](...) .

All I am doing is giving the correct way to fix it. Not some crap inefficient way.(no offense) I did not ask for an argument. I pointed out a fact, and the fact is being argued. The issue is really no longer with you xArva. I do believe you got my point a while ago. I cannot see you being that hard headed. You seem like an intelligent person. Now I am trying to explain it to hennesa. He does not seem to understand exactly what I am pointing out.

[hannesa]

Ok, from this statement you are right, maybe its better to explain what EXEC does and whitch arguments are needed.
Didn't remember that there were 2 Databases given for the first argument.
Also don't know exactly but think that this never runs that way.
But what if your *Account* database is named AccDB or else?
In that case, the EXEC in usp_ChargeItem_Draw and also usp_ChargeItem_GetList has to be changed to refer to
the right Database, otherwise the premium inventory won't work.

Normally people who are playing with that files and each other fiesta related should know the SQL syntax.

Just misunderstood what you wanna tell because it was clear to me that it has to be
*databasename.procedurename*
and not
*databasename.databasename.procedurename*.

I think all lacks of clarity have now been eliminated.

[aqua512]

Ok, from this statement you are right, maybe its better to explain what EXEC does and whitch arguments are needed.
Didn't remember that there were 2 Databases given for the first argument.
Also don't know exactly but think that this never runs that way.
But what if your *Account* database is named AccDB or else?
In that case, the EXEC in usp_ChargeItem_Draw and also usp_ChargeItem_GetList has to be changed to refer to
the right Database, otherwise the premium inventory won't work.

Normally people who are playing with that files and each other fiesta related should know the SQL syntax.

Just misunderstood what you wanna tell because it was clear to me that it has to be
*databasename.procedurename*
and not
*databasename.databasename.procedurename*.

I think all lacks of clarity have now been eliminated.

I do believe that would be correct. Anything named Account in the Char DB would have to be changed to direct to the DB.
Also thank you for understanding what I was trying to say. I was not trying to be an ass to anyone. It just gets frustrating when I try to explain something and no one understands my point. Once again thank you. Also I apologize if I came across as an ass to anyone. Was not my intention. I am running on 2 hours of sleep, so I'm a bit edgy. Sorry if I took it out on anyone.

xArva, No worries bro. We good.

[hannesa]

Its all fine, no problem.

So summarized again:
The EXEC commands in procedures usp_ChargeItem_Draw and usp_ChargeItem_GetList located in the
character db are refering to the wrong (Account) database and needs to be corrected in order to get the
premium inventory running.

Maybe not needed but the same problem for procedure p_Event_Friend_Reward (also same on some other procedures).

Instructions on how to use EXEC can be found here:
https://msdn.microsoft.com/de-de/lib...ql.120%29.aspx

[xZenon]

I did not say to remove the procedure. I said to remove "[ACCDB]". This call function is not needed. It just gives the procedure more steps, which is not necessary. Therefore it can be removed.


<---- like this................................

Ok, i execute query:

ALTER PROCEDURE [dbo].[usp_ChargeItem_Draw] @Row_NO INT, @user_NO INT, @ret	INT = 0 OUTPUT
AS
BEGIN
SET NOCOUNT ON
SET LOCK_TIMEOUT 5000


EXEC Account.dbo.usp_Charge_ItemDraw @Row_NO, @user_NO, @ret OUTPUT


SET NOCOUNT OFF
SET LOCK_TIMEOUT -1
END

And now works.
But hannesa, you say:

Its all fine, no problem.
So summarized again:
The EXEC commands in procedures usp_ChargeItem_Draw and usp_ChargeItem_GetList located in the [...]

And i dont have execute anything for usp_ChargeItem_GetList.
What is the other query?

[hannesa]

I think we made all things clear.

You should not copy, paste and execute, you should read the discussion and search for stored procedures
where the wrong database is given for the EXEC or some other commands, selects or inserts and so on.

Normally if your Account DB is named "Account" most of things should be fine but if your Account DB name
is different you have to edit some procedures to prevent errors.
Find it by yourself, i don't have all in my mind.

[aqua512]

Now you know why I did not just give the answer at first. I wanted OP to find the fix for himself. I guess it is OK if he wants to be a copyfag.