: Adding Kooh to your server ::


1. Goto Pangya_Item_TypeList table (SQL Manager) -> Open Table -> Return all rows ->
Click SQL in toolbar menu and replace this command :

INSERT INTO Pangya_Item_TypeList (TypeId, Name, Icon, Price) VALUES(67108869, 'Kooh','e_def', 29000)
then click '!' in toolbar menu.
2. Right Click on 'Stored Procedures' -> Click 'New Stored Procedure...' then replace all text to textbox area :

CREATE Proc AddKoohAndItemTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES(@UID,67108869)
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 1355448*** 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544833, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544834, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135569408, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135569409, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585792, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585793, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585794, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135634944, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135634945, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135528449, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135561217, 1, getdate());
RETURN
END
GO

3. Go to sql command to execute procedure name 'AddKoohAndItemTo' with parameter userid :
example : AddKoohAndItemTo 'yourloginname'
then click '!'

Quote:

:: Make Skin and Ball to Pangya_Item_Typelist table. ::

INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107015,'Green Bag Slot',5000)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107014,'Blue Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107013,'Pink Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912722,'Lolo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912721,'Pipin Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912720,'Tiki Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912719,'Titang Boo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718411,'Flower Garden Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718410,'Green Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718409,'Pink Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718408,'Tangled Bronze Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524103,'Green Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524102,'Purple Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524****'Ivy Vines',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524****'The Best Rice',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(335544330,'Chistmas Aztec (50)',12)


#----- Make Procedures to add Skin, Chistmas Ball, House Club -----

CREATE Proc AddSkinItemTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107015, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107014, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107013, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912722, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912721, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912720, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912719, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718411, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718410, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718409, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718408, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524103, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524103, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524102, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524**** 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524**** 1, getdate());
RETURN
END
GO
#----- Add Club and Status PWR,CTL,ACC,SPN,CRV -----

CREATE Proc AddHClubTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0,C1,C2,C3,C4) VALUES (@UID, 268435459, 1, getdate(), 3, 6, 4, 2, 2);
GO


#----- Add Chismas Aztech ball to player ------

CREATE Proc AddCMBallTo
@userid varchar(32),
@ball int
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0 and @ball > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0) VALUES (@UID, 335544330, 1, getdate(), @ball);
GO

#------ Example to use procedures -----
Look Menu Bar and Go to Tools > SQL Query Manager
AddSkinItemTo 'yourloginname'
AddHClubTo 'yourloginname'
AddCMBallTo 'yourloginname', 100

Example : My ID is Gerrard
then type AddSkinItemTo Gerrard

And If you Want Some Item In Shop But you can't buy it, go to Pangya Bn game > DataBase> Pangya Item List and search item code, and change item code in procedure.

Source : Ragezone.com

Pangya Offline With New Theme, look at some pictures :



Download In Here :
Client Pangya Offline 2.15c has 10 part and 1 part has 15 mb, You Must download all part..

1. PangYa Offline Part 1
2. PangYa Offline Part 2
3. PangYa Offline Part 3
4. PangYa Offline Part 4
5. PangYa Offline Part 5
6. PangYa Offline Part 6
7. PangYa Offline Part 7
8. PangYa Offline Part 8
9. PangYa Offline Part 9
10. PangYa Offline Part 10

Pangya Server Offline with Backup DataBase(Easy)

Pangya database, 1 part = 20mb and has 4 part. When you want to extract database to data MSQL , Service Manager must be stop until finish.

• Pangya Full Database Offline part1
• Pangya Full Database Offline part2
• Pangya Full Database Offline part3
• Pangya Full Database Offline part4

And You Need MSQL Server 2000



You can download the guide :
Download Guide Pangya Offline

I have create Pangya Theme .pak, i here you can change :
1>Wallpapers
Look This Picture :

Download Wallpapers .pak

2> Pangya Icon
Look The Picture Again :

Download Pangya Icon .pak (Sorry have make some part, because my connection slowly)
Part 1
Part 2
Part 3

And Pangya Sountrack in game
Part 1
Part2

Faronics Deep Freeze helps eliminate workstation damage and downtime by making computer configurations indestructible. Once Deep Freeze is installed on a workstation, any changes made to the computer—regardless of whether they are accidental or malicious—are never permanent. Deep Freeze provides immediate immunity from many of the problems that plague computers today—inevitable configuration drift, accidental system misconfiguration, malicious software activity, and incidental system degradation.

Deep Freeze ensures computers are absolutely bulletproof, even when users have full access to system software and settings. Users get to enjoy a pristine and unrestricted computing experience, while IT personnel are freed from tedious helpdesk requests, constant system maintenance, and continuous configuration drift.

Balancing Security with Productivity

Deep Freeze is the only solution that effectively balances workstation security with user productivity. By mapping user and application data to a Thawed (unprotected) partition or drive, users are able to store their documents, pictures, music, etc., while still enjoying the total system consistency that Deep Freeze offers.

Flexible Resiliency

Deep Freeze offers flexible scheduling options that enable IT administrators to easily create automated update and maintenance periods. Schedule Deep Freeze to allow system and virus definition updates to occur from predefined times—either with the Deep Freeze Enterprise Console or using your preferred third-party desktop management solution.

Download Deep Freeze v6.30

Blue Coat® K9 Web Protection is a content filtering solution for your home computer. Its job is to provide you with a family-safe Internet experience, where YOU control the Internet content that enters your home. K9 Web Protection implements the same enterprise-class Web filtering technology used by Blue Coat's Fortune 500 customers around the world, wrapped in simple, friendly, and reliable software for your Windows 2000, Windows XP or Windows Vista computer.

Blue Coat's unique Web filtering technology divides Internet content into 60 distinct categories. These categories are stored in the master Blue Coat database, through which we maintain and update more than 15 million ratings of websites and domains. A Web site will fall into one or more of these categories, based on the content of the site. To meet your particular needs and preferences, you can configure the software to block or allow specific categories.

* Service-based filtering – Blue Coat's filtering database operates as a service. It receives and rates over 80 million requests every day, making it the most accurate content filtering database available. This accuracy is important in protecting your family, given the Internet's rapid changes and growth. Plus, there is no database to download. K9 Web Protection won't clog your Internet connection, get "stale" or out of date, or slow down your computer like other products do.
* Dynamic Real-Time Rating™ (DRTR) – Blue Coat's patent-pending DRTR technology is a very powerful element in our solution, and is vastly different from the old-fashioned "key word filtering" that is so frustrating to users. Using a method of statistical analysis and artificial intelligence to rate new or previously unrated Web pages, DRTR can determine the category of a URL on the fly, without human intervention. However, DRTR only renders a rating when it is confident that it has reached an accurate conclusion.

We've focused DRTR on recognizing the kinds of categories most likely to be blocked. In particular, DRTR is highly accurate in blocking pornography and other "adult content" sites. This focus for DRTR is particularly important because these kinds of sites are constantly – daily and even hourly – popping up on the Internet, and no static database can keep up.
* Automatic updating – Automatic updates of the K9 Web Protection application ensure that you are always protected by the latest features. For example, in Spring of 2005, we added two new categories to our solution: Spyware/Malware Sources, and Spyware Effects/Privacy Concerns. By electing to block sites in these categories, your computer's rate of infection by unwanted software can be reduced dramatically. We have a variety of new features planned, and your K9 installation will automatically receive updates that include them.
* Efficient caching – K9 Web Protection is a product from Blue Coat. Blue Coat is recognized world-wide as expert in high-performance caching and secure proxy technology. We take advantage of that expertise in K9, so your Internet experience is as fast, reliable, and safe as we can make it.

Unlike other filtering solutions, K9 Web Protection ensures the highest level of protection by building the most relevant ratings database available. Its effective coverage reaches more than one billion Web pages. With K9 Web Protection, you finally have a chance to build a family-safe Internet experience for your home, simply and easily.

Download In Here

Now i realease pangya club files, you can change your club use air knight II (English : air lance II),
take easy, only copy and paste like hair pack.