Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Fix and Feature Catalogue

Newbie Spellweaver
Joined
Mar 29, 2011
Messages
34
Reaction score
7
The Fix and Feature Catalogue
Last Update: 2011-04-18

Please note: This thread is under construction.

You followed terrorofdeath's great step-by-step tutorial and have your server up and running. Yay!

But what's that? Some features don't work. Well, since this community is constantly working on the rough edges, some of the fixes didn't make it into the Server Repack.

That's what this thread is for. You can easily look up fixes you might need to correct problems on your server.

Please read the descriptions of the fixes and features until you find one that somewhat describes your problem. Applying them might just solve the problem.

How to install & notes
For the most part it should be sufficient to open a new query in Management Studio, paste the code from the threads into it and hit "Execute".

If you get errors that a procedure does not exist, you should substitute the ALTER statement with a CREATE statement at the beginning of a query.

As usual: Reading the release thread will probably help you in case you're stuck.

Newer Fixes (you should install these!)
There's a high probability you need these fixes. They correct problems within the game and enable some features to work. If you have problems with a specific fix, please consult the source thread.

Pangya Card Equip Fix
Supplied by: Acardia
Source: See here
Already applied on: -

Description: Fixes errors in the card-specific SPs. The procedures will work as expected, you will still need to add the cards to the database yourself.

TA_CARDPACK and TA_CARDPACK_ITEM values
Supplied by: Acardia
Source: See here
Already applied on: -

Description: Adds most of the cards to the tables to allow cardpacks to work and open. Cards should work fine after applying the Card Equip Fix and this one.

Tutorial Fix
Supplied by: chreadie
Source: See here
Already applied on: -

Description: Fills the necessary tables values in the database to use the in-game tutorial without problems. May requires other fixes to be applied (i.e. USP_MAIL_SEND).

TD_CHAR_EQUIP_S4 Fix
Supplied by: chreadie
Source: See here
Already applied on: -

Description: Fixes the problem that certain items will be unequipped after each login. This version is reportedly working well with the Server Repack v2.

USP_NICKNAME_UPDATE
Supplied by: chreadie
Source: See here
Already applied on: -

Description: Enables players to change their nickname in-game via the entry in the game options.

TA_ROOM_ITEM values
Supplied by: Tsukasa
Source: See here
Already applied on: -

Description: Adds the table values necessary to successfully buy and arrange furnitures from the shop.

Please note these values do not allow you to "use" a furniture's special feature.

USP_MAIL_SEND
Supplied by: chreadie
Source: See here
Already applied on: -

Description: Allows in-game mailing, including item sending. This also fixes the /giveitem command for GMs which relies on the mail system.

Note: Some items cannot be sent at the current time; see the source thread for more informations.

usp_card_spcl_pop_s5
Supplied by: hvdaedalus
Source: See here
Already applied on: -

Description:

Additional Procedures you might find useful
These procedures are not required for the normal operation of the game but may enhance your experience.


TSU_Add_Cookies
Supplied by: Tsukasa
Source: See here
Already applied on: -

Description: For those who want to use a simple stored procedure to add cookies for an account, this might be what you're searching for. It might be buggy.

TSU_AddItemToUser
Supplied by: Tsukasa
Source: Can't find it, see here
Already applied on: Variant is available on Server Repack

Description: Adds a new stored procedure that allows you to add items to a user. Please note that the user has to logout and login to see and use the items.

Register Proc that auto-adds Cookies
Supplied by: X_Sarah_X
Source: See here
Already applied on: -

Description: Modifies the behaviour of the server to automatically add the amount of X cookies to a user on their first login.

Things you should not use
There are a few snippets floating around the forums and made their way into several repacks of the server files which you should avoid.
  • The "Give All Items" query
    Stay away as far as possible from it. It adds every item in Pangya_Item_Typelist to a specified account - with no regard whether adding a specific item to the table is correct or not.

    Using this query will cause the following glitches:
    - You will be unable to buy new equipment
    - You might not be able to login to a game-server anymore
    - Loading the game-server list may be delayed for a prolonged period of time

    Again, if you're curious about this query, please use it on a dedicated test account only!
 
Last edited by a moderator:
Newbie Spellweaver
Joined
Mar 29, 2011
Messages
34
Reaction score
7
just wow "by Tsukasa!"
Awesome work mate:)
 
Joined
Jul 18, 2009
Messages
390
Reaction score
129
Stickied.
This topic will be very usefull to new server hosters.
That way they don't have to cruise around the pangya section to find all these fixes.

(clap) @ your job on providing these guides/tuts over the past week :)
 
Newbie Spellweaver
Joined
Mar 29, 2011
Messages
34
Reaction score
7
This topic was actually redesigned by Tsukasa :)
 
Initiate Mage
Joined
Jul 30, 2011
Messages
3
Reaction score
1
usp_card_spcl_pop_s5
Supplied by: hvdaedalus
Source:
Already applied on: -
There's a typo on the url here - "http://http://" or something~
just saying :p
 
Back
Top