I used the proc TSU_ADD_COOKIES but dont fix the cookies... how to make??? please ! :(
I used the proc TSU_ADD_COOKIES but dont fix the cookies... how to make??? please ! :(
Cookies (sob)
Last edited by souemo; 17-12-10 at 05:20 AM.
Does anyone happen to have the typeid's for Clubsets?(Soul Reaper Set to be sepecific, but all would be nice) or know how to obtain them?
And when i try and play family mode it just does some AI mode thing, what is causing this problem?
Last edited by G0dzilla2000; 17-12-10 at 05:44 AM.
I remembered a few things while editing account inventories. I have a few more questions:
1. Where do I find the TypeIDs for all clothing/clubs/aztecs/items?
2. Where do I find these .iff files that people talk about?
3. Is it possible to implement outfits from other server versions into our private servers? (EX: I want all of the Vocaloid outfits from Pangya JP)
4. I want to edit some clothing textures. I use hontoshadow's Unpaker to unpack Pangya .pak files, but how can I repack them?
----------
(And these are concerns I brought up already, but I'm going to post them again to make sure they aren't lost in the thread. Plus, it's more convenient.)
5. My Nell's clothing won't stay equipped after leaving MyRoom. I saw a screenshot of someone using a clothed Nell outside of MyRoom. Anyone know what might be wrong with mine?
6. Is it possible to change the animation commands in the Lounge/PSQ (EX: /dance for the S4 dance command)? If not, anyone know where I can find a complete list of commands?
My clothing seems to always reset no matter what. Even if I change nothing, and even if I simply log out then back in instead of rebooting the client, my stuff still unequips itself. Is there something I could have missed in this case?
hello friends, good night ... well I did the server almost 90% but
I'm not getting put cookies
I've used the query
CREATE PROC TSU_ADD_COOKIES
and
EXEC @return_value = [dbo].[hb_py_gp_apply_userinfo_in]
@iUser_No = 1,
@iUser_ID = N'josiel',
@iUser_ip = N'127.0.0.1',
@iDB_id = NULL,
@iItem_no = NULL,
@iOrder_no = NULL,
@iPersonal_no = NULL,
@iApply_type = N'K0',
@iAmount = 10000
SELECT 'Return Value' = @return_value
GO
I run them when I get my cookies on the server does not appear
P is: 999,999,999 C: 0
help me please
---------- Post added at 04:39 AM ---------- Previous post was at 04:38 AM ----------
USE [INI3Bill_DB]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[hb_py_gp_apply_userinfo_in]
@iUser_No = 1,
@iUser_ID = N'josiel',
@iUser_ip = N'127.0.0.1',
@iDB_id = NULL,
@iItem_no = NULL,
@iOrder_no = NULL,
@iPersonal_no = NULL,
@iApply_type = N'K0',
@iAmount = 10000
SELECT 'Return Value' = @return_value
GO *
Do not know whether to be a significant change can make our own IP-logger
If you can really thank you
Good fun together with your friends
I also tested a new login device greatly matter whether the version of things ... can I go 583.01
To open into the room as I updated to the latest version ~
1. ummm to find all the clothing typeids you can look at (forgot the posters) query that is used to add all the clothing items into the itemtypelist for example
the underlined code is the type ID for that item.Code:GO INSERT INTO PANGYA_ITEM_TYPELIST(TYPEID,NAME,PRICE,ISCASH) VALUES (136464384,'Devil Tail (Luc',10000000,0)
as for the clubs i would like to know the list as well, and i dont know any of the others sorry
2. for the .iff files go into your PANGYA_TEST/LOGIN and rename the pangya_s4_TH.iff to .rar and you can then extract the .iff's poeple are talking about then hexedit them and put them back in and rename it back to .iff(thats what i have been doing, but idk if its right, cause i have had no success with trying to add clubs this way and such so sorry if its wrong)
Hope i helped
i have got error msg.
2010-12-17 14:31:32 107 MessengerServer#1 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.USP_GUILD_MEMBER_LIST'.)
2010-12-17 14:31:32 107 MessengerServer#1 1 [F_QUERY] LastSuccQuery({call dbo.ProcGetFriendList_Msn ('kimaru')}), CurrQuery({call dbo.USP_GUILD_MEMBER_LIST (0)})
and error msg.
0x006451B0 4 ei.tmp->ei.log.txt Log/20201_20101217_1512.1.ei.tmp ]] 0x00B455B8 4 4 ] 2010-12-17 15:12:46 1 PangyaPVS 1 [S_ITEM] INSERT : DBERR(0) CashIDX(-1), Pangya Card Pack No.2(TID:2092957700, ItemID:1), TotalCount(2) AddCount(1)
0x006451B0 4 ei.tmp->ei.log.txt Log/20201_20101217_1512.1.ei.tmp ]] 0x00B455B8 4 4 ] 2010-12-17 15:12:57 1 PangyaPVS 1 [E_CARD] CardPack Open : ErrorCode(1), Query(exec dbo.USP_CARDPACK_USE_S4 1, 2092957700, 1)
when open Pangya Cardpack.
can anyone fix this?
Last edited by kimaru; 17-12-10 at 09:16 AM.
Well, those two files come from the pangya_th.iff, so you pack all the extracted files from pangya_th.iff again, copy it to the login server directory (overwriting the old pangya_th.iff in there), copy it to the game server directory (same drill) and create a pak file with the file for the game client. The best way to do it is to repack the latest .pak file from the client to make sure it gets loaded.
Searching for item IDs in the database only works if they are inserted. That's not necessarily the case with the clubsets. So you might want to check earlier pages of this thread for information on how to retrieve IDs from the IFF files directly and add these to your database first.
As for the changing clothes issue... same as above. Items not in the IFF file on the server side and not registered in the database, so the server will issue an Invalid TypeID message and unequip it. See your logs for more information.
And mikumiku, please browse earlier pages of this thread to get answers to IFF related questions.
You *could* implement outfits from another region but the textures and models have to be carried over. Technically speaking it's rather easy for Pangya US and rather tricky for JP. The length of each recordset in those two versions are different - while US uses 512 byte records (like TH), JP uses something around 528 byte. So as long as you don't know where the extra bytes come from and what they do... you're out of luck ;)
Last edited by Tsukasa; 17-12-10 at 09:32 AM.
Last edited by bubbastic; 17-12-10 at 01:03 PM.
can someone share me his login.ini ?
Help-me please add cookies :(
Sorry if this sounds rude but : Do a minimum efforts if you want to launch this server. Search, try, learn....
If we give all the answers, you won't do any effort and you will still ask more and more questions. So try to find it by yourself, you can do it
Finding cookies took me 5 minutes o.O (and I'm not a sql expert) and you guys don't even try D:
Last edited by bubbastic; 17-12-10 at 01:06 PM.
I tried to make clear that five days I'm trying to put cookies
already try everything else I'm not getting already used the
[hb_py_gp_apply_userinfo_in]
and
PROC TSU_ADD_COOKIES
But no add cookies :(
Well, you helped a little. Never would have guessed you can extract .iffs from .iffs. Thanks. :P
But... Pangya_S4_TH.iff? Where are you getting this S4 .iff from? o.O
Exactly how would you go about repacking? And which .pak file are you supposed to pack into?
Isn't Nell's clothing already in the database? Without even editing anything, it's already in the shop. Yet, before I directly added the clothing to my inventory, I could purchase said clothing from the shop, but I wasn't allowed to keep it. I'll go ahead and check the logs, but I still find it odd that I can't use clothing that's sitting right in front of me.
Contrary to my previous newbie questions, I wouldn't have asked if I didn't already thoroughly examine the thread to see if my question was already answered. The only things that were discussed were 'hex edit the appropriate .iff file' and 'how to edit the item database using the hex editor'. How to find the appropriate .iff file and how to repack it into a .pak file was not brought up as far as I could see. If I somehow missed these, please point me to the appropriate post number where it was mentioned, and I will apologize.
Poopy.