Pangya Season 4.9 Server Files and Database

Page 26 of 31 FirstFirst ... 161819202122232425262728293031 LastLast
Results 376 to 390 of 459
  1. #376

    Re: Pangya Season 4.9 Server Files and Database

    I used the proc TSU_ADD_COOKIES but dont fix the cookies... how to make??? please ! :(

  2. #377
    Novice souemo is offline
    MemberRank
    Dec 2010 Join Date
    1Posts

    Re: Pangya Season 4.9 Server Files and Database

    Cookies (sob)
    Last edited by souemo; 17-12-10 at 05:20 AM.

  3. #378
    Member G0dzilla2000 is offline
    MemberRank
    Jan 2010 Join Date
    54Posts

    Re: Pangya Season 4.9 Server Files and Database

    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.

  4. #379
    Enthusiast mikumiku is offline
    MemberRank
    Dec 2010 Join Date
    47Posts

    Re: Pangya Season 4.9 Server Files and Database

    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?

    Quote Originally Posted by G0dzilla2000 View Post
    Quite honestly it just kind of fixed itself, but it tends to happen time to time. Most of the time i find it happening when i change values and restart the server
    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?

  5. #380
    Apprentice josiel is offline
    MemberRank
    Dec 2010 Join Date
    5Posts

    Re: Pangya Season 4.9 Server Files and Database

    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 *

  6. #381
    Apprentice hh23162378 is offline
    MemberRank
    Feb 2007 Join Date
    13Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by fasa2008 View Post
    Hello All !


    * ProjectG 583.00
    * Unpacked
    * Game Guard Removed
    * Loader's Game Guard Removed
    * ProjectG Multi-Client
    * Exclusive RageZone
    * New Features
    * No Erro's
    * More Support Paks

    Credits: Fasa2008 <<<

    Download



    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 ~

  7. #382
    Member G0dzilla2000 is offline
    MemberRank
    Jan 2010 Join Date
    54Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by mikumiku View Post
    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?

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

    Code:
    GO
    INSERT INTO PANGYA_ITEM_TYPELIST(TYPEID,NAME,PRICE,ISCASH) VALUES (136464384,'Devil Tail (Luc',10000000,0)
    the underlined code is the type ID for that item.

    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

  8. #383
    Apprentice kimaru is offline
    MemberRank
    May 2007 Join Date
    ThailandLocation
    21Posts

    Re: Pangya Season 4.9 Server Files and Database

    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.

  9. #384
    Deny everything. Tsukasa is offline
    MemberRank
    Jun 2005 Join Date
    Net SlumLocation
    558Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by G0dzilla2000 View Post
    So, im assuming i must edit the part.iff(clothes) and clubset.ff (clubs) correct? and do i need to put the hexed .iff back into the Pangya_S4_TH.iff and the pangya_th_28102010.iff or just one or the other?

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

  10. #385
    Proficient Member bubbastic is offline
    MemberRank
    Nov 2010 Join Date
    WindHillLocation
    181Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by fasa2008 View Post
    Hello All !

    * ProjectG 583.00
    * Unpacked
    * Game Guard Removed
    * Loader's Game Guard Removed
    * ProjectG Multi-Client
    * Exclusive RageZone
    * New Features
    * No Erro's
    * More Support Paks


    Credits: Fasa2008 <<<
    Download
    Brigadu Fasa You rock XD
    Last edited by bubbastic; 17-12-10 at 01:03 PM.

  11. #386
    Apprentice Mouquette is offline
    MemberRank
    Dec 2010 Join Date
    6Posts

    Re: Pangya Season 4.9 Server Files and Database

    can someone share me his login.ini ?

  12. #387
    Apprentice josiel is offline
    MemberRank
    Dec 2010 Join Date
    5Posts

    Re: Pangya Season 4.9 Server Files and Database

    Help-me please add cookies :(

  13. #388
    Proficient Member bubbastic is offline
    MemberRank
    Nov 2010 Join Date
    WindHillLocation
    181Posts

    Re: Pangya Season 4.9 Server Files and Database

    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.

  14. #389
    Apprentice josiel is offline
    MemberRank
    Dec 2010 Join Date
    5Posts

    Re: Pangya Season 4.9 Server Files and Database

    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 :(

  15. #390
    Enthusiast mikumiku is offline
    MemberRank
    Dec 2010 Join Date
    47Posts

    Re: Pangya Season 4.9 Server Files and Database

    Quote Originally Posted by G0dzilla2000 View Post
    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
    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

    Quote Originally Posted by Tsukasa View Post
    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.
    Exactly how would you go about repacking? And which .pak file are you supposed to pack into?

    Quote Originally Posted by Tsukasa View Post
    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.
    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.

    Quote Originally Posted by Tsukasa View Post
    And mikumiku, please browse earlier pages of this thread to get answers to IFF related questions.
    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.

    Quote Originally Posted by Tsukasa View Post
    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 ;)
    Poopy.



Advertisement