[Request] Fiesta Launcher

[xZenon]

Hi,
I'm looking for someone who can create launcher with Visual Basic.
Files are HK, therefore, I do not need to make a login, but yes a patcher.

To contact, private.


PD:
I Dont know if this post is in this section, move it if necessary.

[MentaL]

[xArva]

https://mega.nz/#!g4kQDAwR!VzuoOGLl4...pS75TiblBPtYBc Here.

[aqua512]

Thank you for the release xArva. I did something pretty cool with this release.




The 1 on the left is the Original HK launcher. The 1 on the right is my rebuild of it using this release.


EDIT: I am going to rebuild the MoePromise launcher next.

EDIT: After some adjustments to the images and code. Here is the final look of my rebuild of the Hunter Kingdom Launcher.

[Delius]

Continuous reminders of why I left this section lol.
Gj tho Aqua, maybe release the working edition for this guy.

[aqua512]

All I did was rebuilt the images. Then added them to the launcher. changed the address the launcher was looking for. Compiled. and presto a HK look alike. I did not have to do very much to the code. Oh I had to add the second box. Copy and paste does wonders.

[xZenon]

Thanks all for help.
I have another question... i have PHP Shop, but i don't know what is the db table (HK files) to premium inventory in game.
I need put (configure) with a php query when the user buy item in shop and goes to premium inventory.
(Remark: I have query, but i don't know what is the table)

Thanks.

[xteslaz]

Account DB -> dbo.tPurchases (I use odin, may be slightly different for HK)

[xZenon]

Account DB -> dbo.tPurchases (I use odin, may be slightly different for HK)

Yes, is different...

[aqua512]

dbo.tCash is for coins,
dbo.CashLog is payment records in the CS made with coins,
dbo.Item is for items in CS,
dbo.ItemCategory is CS categories,
dbo.ChargeItem is where purchases are recorded.

[xZenon]

Ok,... -.-"
I create a line in dbo.ChargeItem with a premium item and i have the item in Premium Inventory.
But now, when i clic the item to pass to normal inventory, say error: 4162
Why?

[aqua512]

There is a screwed up procedure in the Char db. You have to fix it. Someone posted the fix for it somewhere on RZ.

[xArva]

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

[aqua512]

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

Useless fix. Try removing [ACCDB] all together. It makes it more efficient. The procedure has less steps to make. Learn SQL plz. That is like saying lets add another flight of stairs to what you already have to climb just for the hell of it. Makes absolutely no sense. This procedure does not require any call function. Therefore it can be removed. Lets not make things harder than they have to be.

[hannesa]

Useless fix. Try removing [ACCDB] all together. It makes it more efficient. The procedure has less steps to make. Learn SQL plz. That is like saying lets add another flight of stairs to what you already have to climb just for the hell of it. Makes absolutely no sense. This procedure does not require any call function. Therefore it can be removed. Lets not make things harder than they have to be.

This procedure IS called directly from character service, therefore its needed to *draw* items from premium inventory.

[aqua512]

This procedure IS called directly from character service, therefore its needed to *draw* items from premium inventory.

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................................

[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.

<---- 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.