I understand you had a difficult job.
tell who can play normally, no mistakes.
could release the DBS Correct.
think, if Turion123456 had not done that.:blushing:
nobody have anything.
Printable View
I understand you had a difficult job.
tell who can play normally, no mistakes.
could release the DBS Correct.
think, if Turion123456 had not done that.:blushing:
nobody have anything.
chiosin2 thank you I can make room for open lan in my internet cafe
yes you can. here's a pic
Hm, must have done something wrong somewhere then.
Anyone know how to add more characters/clothes/items to the account? Or how to set self as GM?
How does command this:
http://i52.tinypic.com/2ytuqo3.jpg
Nobody knows, or nobody can talk?
NOIDCheck = 1.Quote:
Originally Posted by renato__mouse
Solved
--------------------------------------
*Update
Hello everyone, to avoid problems would be better to use a projectG Pangya Kr .. in view is much more advanced than TH ... xD
I think you need GMTools for that notice on top of screenQuote:
Originally Posted by TheLost
Quote:
Originally Posted by KS212
But when I activate a NOIDCheck all accounts can be accessed with any password, and there are accounts that are created to be logged ... something to correct this?Quote:
Originally Posted by fasa2008
Could someone release the database ini3_py_account fixed? would be more practical!
I was looking at ur login verifies that the account ini3_userlogin, but there is nothing on that table ... and whenever I try to add something in the error Visa_Ref
Yes, you really got working. Share the database pleasee?Quote:
Originally Posted by chiosin2
i finally finished my tool.
heres a SQL script for all shop items,
just run it on sql and have fun :)
Would be easier for all of us if you could tell us which tables and procedures you have already tried or if you managed to become a GM and used /notice...Quote:
Originally Posted by TheLost
Open the ini3_py_account.sql file and in the CREATE statement for the table Ini3_UserLogin change VisaIDCard and Visa_Ref from NOT NULL to NULL, drop the table and create it again. Will work afterwards.Quote:
I was looking at ur login verifies that the account ini3_userlogin, but there is nothing on that table ... and whenever I try to add something in the error Visa_Ref
Excellent share! Thank you very much!Quote:
Originally Posted by jhonzinbr123
Wow, now the shop looks nice with all the items! :D
TYVM for this file. :thumbup:Quote:
Originally Posted by jhonzinbr123
Everything cost pangs :ott: lol Even fairy and elf ears ahahah.
Saved me a lot of time. Searching ID without tools takes too long to have 'em all.
So this code:
have to be this way?Quote:
CREATE TABLE [dbo].[Ini3_UserLogin](
[idx] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](32) NOT NULL,
[Password] [varchar](100) NOT NULL,
[IsDelete] [char](1) NOT NULL CONSTRAINT [DF_PY_UserLogin_IsDelete] DEFAULT ('N'),
[Birthday] [datetime] NOT NULL,
[Sex] [tinyint] NOT NULL,
[VisaIDCard] [char](13) NOT NULL,
[Confirm18] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Confirm18] DEFAULT ((0)),
[UserName] [varchar](32) NOT NULL,
[Zipcode] [char](5) NOT NULL,
[Item_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_ItemRate] DEFAULT ((1)),
[Exp_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Exp_Event] DEFAULT ((1)),
[Visa_Ref] [int] NOT NULL,
CONSTRAINT [PK_Ini3_UserLogin] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
This is the error: http://img94.imageshack.us/img94/385/imagem1xd.jpgQuote:
CREATE TABLE [dbo].[Ini3_UserLogin](
[idx] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](32) NOT NULL,
[Password] [varchar](100) NOT NULL,
[IsDelete] [char](1) NOT NULL CONSTRAINT [DF_PY_UserLogin_IsDelete] DEFAULT ('N'),
[Birthday] [datetime] NOT NULL,
[Sex] [tinyint] NOT NULL,
[VisaIDCard] [char](13) NULL,
[Confirm18] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Confirm18] DEFAULT ((0)),
[UserName] [varchar](32) NOT NULL,
[Zipcode] [char](5) NOT NULL,
[Item_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_ItemRate] DEFAULT ((1)),
[Exp_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Exp_Event] DEFAULT ((1)),
[Visa_Ref] [int] NULL,
CONSTRAINT [PK_Ini3_UserLogin] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
can anyone tell me how to make a GM account?? the old way doesn't seem like its working LoL
chiosin2 send pm me
chiosin2, hexing the version number did the trick! Thanks a ton, mate :laugh: .
renato__mouse, I've attached a working version of the .sql file. If you use this one, create and activate the account through the stored procedures and use the default server config (and using the command "alluseropen" in the login server) you should be able to login. Please be sure to drop the database ini3_py_account before using this file.
If that's not the case you should study the logs for messages prefixed with E_ or ODBC errors. Could be an issue of missing system-dsn entries or wrong database user/password :) .
For all the other people, here's a simple way to add cookies to your account. It creates a new stored procedure in INI3Bill_DB that requires the user-id (i.e. tsukasa) and the amount of cookies to be added.
Spoiler:
Edit: You can also use the procedure hb_py_gp_apply_userinfo_in. Here's an example call:Code:USE [INI3Bill_DB]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[hb_py_gp_apply_userinfo_in]
@iUser_No = 1,
@iUser_ID = N'tsukasa',
@iUser_ip = N'127.0.0.1',
@iDB_id = NULL,
@iItem_no = NULL,
@iOrder_no = NULL,
@iPersonal_no = NULL,
@iApply_type = N'K0',
@iAmount = 100000
SELECT 'Return Value' = @return_value
GO
no problem Tsukasa, now i have problems with Bongdari shop, make GM account, UCC, CARDS.. all that stuff. also i need to know how to edit the shop XD... a lot more, my websites almost done but the problem is i don't know how to add cookies/points. LoL XD
More after establishing the account in PangYa_Member_Info we must do more to ensure that it can be accessed?
For updating the cookies see my edited post above, added a simple procedure that should take care of it.
Game ranks can be adjusted using ProcUpdateUserLevel whereas game level has to be a value between 0 (Rookie F) and 65 (Legend A). game_points is the equivalent of the experience already earned for the next level.
As for GM... yeah, I'm curious too. I didn't find any procedure to elevate users yet (regrettably).
Wonder if there's an easy to update the actual shop with the new items from jhonzinbr123's file. The prospect of doing it by hand does not enthuse me x.x
well, for enable the items into the ingame shop, you edit the .iff. The file ive attached is a sql script to add all items into the table PANGYA_ITEM_TYPELIST
hey jhon, how can i make them points instead of pang?
editing the .iff 22 for pangs 21 for cookies/points
does anyone know how to fix the Tags? Like the ones you get for 's birthday or Nuri's Birthday?
@Jhon how do i edit the .iff i cant find any software for it. recommend one?
Use hex editor for edit iffsQuote:
Originally Posted by chiosin2
any hex editor will be good for edit .iff files
uhmm how? sorry.. i don't really understand this XD
If I want to teach, or do remote access.Quote:
Originally Posted by chiosin2
I have my own program for it ... xD
hello someone sends a translator for the current version of pangya TH (into English) please.
I'm in trouble at login. password if you have any logs in the login name and correct fix?
fasa, can you share your iff edit tool? ;)
Let me start by saying, you people are awesome. I don't do any kind of coding or programming, and depend on people like yourselves for my needs in this department.
I think it's great these files are out, and thanks to everyone for working on these fixes, inept people like myself appreciate your efforts.
Would anyone mind posting an organized list of all the files and fixes needed to run a server (so far)? I don't mind having a go at this with everything provided in this thread, but there's so much code and fixes and posts, I tend to get confused at some points. It can be in another thread or another post in this thread, but I need to know the following:
- What's needed to run the server (Server/database files, Pangya client & version, fixes, any extra helpful stuff (like jhon's shop item SQL script, etc). Of course, credit needs to be given for every file/code that's posted.)
- Program(s) needed to edit files
- (Optional, only if you feel generous enough) A step-by-step tutorial on how to get started
Much appreciated.
a lot of people worked hard to make their server work and still working hard for more progress. i'd say that you should be thankful coz these files were given or was released. a lot of people waited a long time you should at least read through the forums to help yourself, i know your just requesting but understand that its already easy to make the DB's connect. it will only take you about 15-20 min to set up while reading the posts. so good luck and hope you finish your server.
I realize this, and I am VERY thankful for everything that was provided in this thread, which is why I said the "tutorial" was optional. All I really need is a list of the files that are working. I don't want to have to load up a script or something to find out it doesn't work properly for me, and asking stupid questions that were probably already answered in this thread. Yes, I know I'm an idiot, but like I said, I get confused easily. Also, I have no idea what I need to edit any parts of the script if I want to. How could I possibly do anything on my own if I don't have all the basic resources I need?
I'm not asking to be spoon-fed, I'm asking to be pointed in the right direction.
@ mikumiku
you're already here aren't ya? so why not read about it a few posts back. it isn't that hard to click and read. the files are there i suggest you do it yourself. and besides if you don't know anything about this, i suggest you read some pages you might learn something. Almost all of the stuff your seeing here requires basic knowledge on sql and a whole lot of other stuff. so i suggest reading first before asking questions later.
Okay, so I downloaded all the files posted so far. I can't even figure out how to make an account, let alone how to use SQL. Guess this is where I give up. (Told you I'm stupid)
where I edit the information about cash, level, gm, etc. ...
fasa you have msn? your id is rzbr is fernando? sorry but i dont allowed send pm
:thumbup::D:Quote:
Originally Posted by f3l1p1nh0
Anyone here gotten the magic box/cauldron working? What needs to be changed to make that work?
If you take time to read the log files, you should have noticed this by yourself : QUERY FAILED : dbo.USP_ITEM_RECYCLE not foundQuote:
Originally Posted by KS212
@bubbastic can you teach me how to edit the .iff with hex editor? i can't seem to understand how this works.
At the moment I'm still learning this process too. Basically, 8 bytes in front of the item name, you should see a 01 in hexa (=active).Quote:
Originally Posted by chiosin2
The "pang" or "cookie" bytes is a bit more tricky to locate...count 6 lines under the name, the 1st byte on the left (but this is not constant I guess :S)
so i have to extract Item.iff CLubs.iff etc. to get it to work?
--------------------------------------------------
Hello All,
Cokkies = 01
Pangs = 02
Tag New = 11
Tag Hot = 21
Example:
Cokkies >>> 01 11 = iten for Cokkies and Tag New.
Cokkies >>> 01 21 = iten for Cokkies and Tag Hot.
---------------------------------------------------
you should really write a tuto. for this.
Friend try to do it myself, I am not obliged to make any tutorial, be more polite ... and humble.Quote:
Originally Posted by chiosin2
season in version 4.9 is to add items. by. iff?
---------- Post added at 04:23 PM ---------- Previous post was at 04:20 PM ----------
Quote:
Originally Posted by chiosin2
if you can not open a. iff so may withdraw their emulator pangya...
ok, then... i kind of understand how its, done. but how do you make it available in shop? what hex string do i need to change?
EDIT: and thanks for the tips by the way. i've been changing a few things here and there but i don't really know how to add it in the shop.
I'll make a tutorial of how to add items, clothes, change prices and to bring up shop ... soonQuote:
Originally Posted by chiosin2
sorry for my question.. but sql server 2008 R2 work perfect?
SQL Server 2005 (all editions) and newer will work fine.Quote:
Originally Posted by f3l1p1nh0
N how to setup server and Full database...^_^Quote:
Originally Posted by fasa2008
@gigok
Same rules apply with the 1st season of pangya. Just add the missing stored procedures and your good to go ^^
HELP PLEASE!
I'm having problems with the databases(INI3Bill_DB, ini3_py_account, Pangya_S4_TH) I put the code in Query Analyzer, F5 Grip (to perform the task), and these errors:
http://img690.imageshack.us/img690/5870/erro1n.png
http://img263.imageshack.us/img263/2893/erro2u.png
http://img146.imageshack.us/img146/9426/erro3.png
PS : Sorry for English but I'm from Brazil and used Google translator! :thumbup: Please HELP :*:
You're using SQL Server 2000, right?Quote:
Originally Posted by outlawzzbr
The queries you're trying to execute were created using SQL Server 2005, some other queries in this thread even with SQL Server 2008.
So I would advise that you upgrade or install an additional SQL Server 2008 instance.
I will download the SQL Server 2008, then post results!Quote:
Originally Posted by Tsukasa
Thanks! :rolleyes:
is not adding friends and cards do not work any fix?
Well I bring to you the first tutorial on Unlock, change price and status of the items ...
Red - Price of Item in shop. IN hEX
Yellow – Item cokkies or pangs
Brown - Enabled in the shop with the tag = Hot > 21, New > 11, Normal > 01 or 03.
http://img406.imageshack.us/img406/4448/addpart22.jpg
Thanks to all who thank me, gave work to do ... xD
PLEASE - Someone pass me a tutorial on how to install SQL SERVER 2008 R2 ?:?:
@outlawzzbr i used SQL 2005 and it worked just fine.
i used monk's DB's added a user monk and then made it work.
i also used some fixes made by tsukasa/fasa2008/bubbastic
^^ though there are still unanswered questions out there. but its better than nothing.
The DBs ini3_py_account and INI3Bill_DB worked perfectly, but the DB Pangya_S4_TH still with this problem, look:Quote:
Originally Posted by chiosin2
Spoiler:
PRINT : http://img826.imageshack.us/img826/7637/erro1h.png
HELP ME? :*:
look a few pages back i posted the same problem.. ^^
first thing you do is this.
-create a new log in named Monk (i'm assuming your using Monk's Databases)
-create 3 new filegroups names Pangya_S4_Th_Card/Pangya_S4_Th_gLog/Pangya_S4_Th_Item
and then execute it again.. it should work fine now.. ^^
Forgive the ignorance but how do they create filegroups? :blushing:Quote:
Originally Posted by chiosin2
sorryQuote:
Originally Posted by outlawzzbr
How about do not POST on rzbr because its using my name ILLEGALLY. We do not support nor allow replica ragezone websites, especially ones who abuse my trademark.Quote:
Originally Posted by fasa2008
The same topic is here has there. Since the User up there because it is Brazilian not get help there that would be easier for him to understand I'm not the owner of RZBR ... Sorry I did not post anything else ... xDQuote:
Originally Posted by MentaL
Thanks a lot for the guide. There are still a few things I'd like to understand. For instance in the blocks 6248-6251 (right after price value of the Zigzag Hairband) there is some value... any idea what that does? Same goes for 6264-6267, 6270 and the area 6280-6294... If anyone has any insight what these values do, I'd be most thankful for some feedback.Quote:
Originally Posted by fasa2008
Just to add to the understanding of the file format: A record in Part.iff is always 512blocks long. First records starts at an offset of 8, preceeded by two uint32 values indicating the total number of items in the file and the iff version (I assume) that is always 11 decimal.
great! time to get pangya running again
Someone teaches me how to create game account?
PLEASEEE :huh:
Execute ini3_py_account's stored procedure SP_PANGYA_REGIST and SP_PANGYA_ACTIVATE.Quote:
Originally Posted by outlawzzbr
Please note that you probably need to alter the table Ini3_User_Login first to allow NULL values in Visa_Ref and VisaIDCard.
Sorry but I do not understand! :*:Quote:
Originally Posted by Tsukasa
@outlawzzbr
just expand your database (INI3_Py_Account>Tables) right click on Ini3_UserLogin then click properties.
Add a check on the null column for the visa_ref. then go to stored procedures and exevute SP_PANGYA_REGIST, then SP_Pangya_Activate.
(just write what ever in your SP pangya regist then when activating just write in the ID you used)
Your done ^^
I marked the box and went where you had to go and look what happens :Quote:
Originally Posted by chiosin2
http://img529.imageshack.us/img529/3163/errohq.png
http://img153.imageshack.us/img153/5286/erro2ew.png
http://img140.imageshack.us/img140/9426/erro3.png
NOTE: It happens when I run both (SP_PANGYA_REGISTER e SP_PANGYA_ACTIVATE)
@outlawzzbr
ok so here's how it's done.
Step 1 execute the stored procedure
Step 2 Input Data
Step 3 Account Created
for
SP_PANGYA_ACTIVATE
just execute the stored procedure and write the id of the account you created. and that's it.
Thank you!! but ....Quote:
Originally Posted by chiosin2
now I need help with this here:.
dbo.ProcGetServerList
Someone pass me the code ???????
:grr:
Yes my friend always the beginning of the code. IFF tells us how many items are added within the file ... usually the first 2 values ...Quote:
Originally Posted by Tsukasa
Ex: In my case I have 480 items Part.IFF of it in HEX think that's>>> 52 11.
If I have not seen the picture show me where is your doubt ... and I tell you ... xD
I'm having the same problem:
http://forum.ragezone.com/attachment...-gameerror.jpg
Help please ..! :*:
there is already a fix for the error of friends?
and cards
design and self?
how to make new account comes with 100 items of exp?
someone can tell if some event work? what if it works and where to set it up?
Excuse the many questions
@outlawzzbr look at your logs.. you might be missing some stored procedure. Don't panic.. its all here.. it might be EQUIP_LOAD_S4 or something like that..
@Tsukasa here's the pic for the clubset.iff
http://forum.ragezone.com/attachment...1&d=1292166213
@fasa2008 Thanks for the tips!
Thanks a lot for your time :thumbup: .Quote:
Originally Posted by fasa2008
I've attached an image with the values in question. They are not set for every item, so my best guess is that they might alter effects.
@chiosin2: Yeah thanks, I'll work on the clubs as soon as I'm done with Part.iff and fixed all outstanding issues. :)
@wellan17: Yes, there is a fix for friends, you need to add the missing stored procedure. Cards - dunno. Self-design requires you to have a webservice to host and retrieve images - so nope, does not work yet. If you want to increase the game rank (like Rookie F or Beginner C) simply edit the game_rank value in Pangya_User_Statistics.
PLEASE - Can someone take a look at my logs? Here is the latest :
MEGAUPLOAD - The leading online storage and file delivery service
:*:
@outlawzzbr just post it.. i won't take the time to download it.
The problem is here:Quote:
Originally Posted by chiosin2
dbo.USP_CHAR_EQUIP_LOAD_S4
Somebody help me ?
@outlawzzbr
Like i said re-run the CHAR_EQUIP_LOAD_S4 <<-- Create that stored procedure.. it should be okay then.
@chiosin2
PLEASE - Pass me the query to create the stored procedure (dbo.USP_CHAR_EQUIP_LOAD_S4)
Here ya go.
Credit: bubbastic
Code:USE [Pangya_S4_TH]
GO
/****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_LOAD_S4] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[USP_CHAR_EQUIP_LOAD_S4] (
@UID INT
)
AS
BEGIN
SET NOCOUNT ON
IF ( @UID > 0 ) BEGIN
SELECT X.ITEM_ID
, TYPEID
/* new */
, ITEMID_PARTS_1
, ITEMID_PARTS_2
, ITEMID_PARTS_3
, ITEMID_PARTS_4
, ITEMID_PARTS_5
, ITEMID_PARTS_6
, ITEMID_PARTS_7
, ITEMID_PARTS_8
, ITEMID_PARTS_9
, ITEMID_PARTS_10
, ITEMID_PARTS_11
, ITEMID_PARTS_12
, ITEMID_PARTS_13
, ITEMID_PARTS_14
, ITEMID_PARTS_15
, ITEMID_PARTS_16
, ITEMID_PARTS_17
, ITEMID_PARTS_18
, ITEMID_PARTS_19
, ITEMID_PARTS_20
, ITEMID_PARTS_21
, ITEMID_PARTS_22
, ITEMID_PARTS_23
, ITEMID_PARTS_24
/* new */
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) X
INNER JOIN
(
SELECT
ITEM_ID
, ITEMID_PARTS_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN ITEMID ELSE 0 END)
FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) A
LEFT OUTER JOIN
(
SELECT CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM
FROM TD_CHAR_EQUIP_S4 WITH (NOLOCK)
WHERE UID = @UID
--AND ITEMID > 0
AND USE_YN = 'Y'
) B
ON A.ITEM_ID = B.CHAR_ITEMID
GROUP BY ITEM_ID
) Y
ON X.ITEM_ID = Y.ITEM_ID
END
END
It worked
VERY VERY VERY VERY Thanks!!
http://img686.imageshack.us/img686/25/thanksvw.png :thumbup1:
------
I have two doubts :
1° How do I add new items ?
2° How to solve this : http://img710.imageshack.us/img710/6591/helpx.png
OBS: It happens when opening the packs!
So I went for another run-through of this thread to see if I could get an at-least partially working server (All I want is a working Item Shop, MyRoom, and PSQ, nothing more). I have no idea what I'm missing. I successfully made an account, but I can't even login with it. But for some reason, when I close the loginserver window, a message in Thai pops up in the Pangya window, and then I get to the server list... which is empty. No idea how to add a server.
Another note, the gameserver isn't working either. Why is there more than one? Which one am I supposed to use? When I try to run any of them, I get:
Code:XXXX-XX-XX XX:XX:XX 0 Log Create Failed
XXXX-XX-XX XX:XX:XX LogSystem Create Failed
XXXX-XX-XX XX:XX:XX Server Start Have Some Problem
rename the folder PANGYA_SRV for PANGYA_TESTQuote:
Originally Posted by mikumiku
LOL no that's not it.
open your server.ini in game server and edit
Code:Log=(change to where you put your gameserver log folder is)
Can someone help me. I can not connect the channel
http://img545.imageshack.us/img545/8632/imagemiy.jpg
http://img585.imageshack.us/img585/5413/pangya313.jpg
You have to create three ODBC (ini3_py_account, INI3Bill_DB and Pangya_S4_THQuote:
Originally Posted by luizhill
Control Panel > Administrative Tools > Data Sources (ODBC)
In the window that opened click System DSN > ADD
Go down the list until the option "SQL Server" and click "Finish".
In the opened window fill in the fields as follows:
Name: ini3_py_account
Description: Leave blank
Server: Enter your internal IP (127.0.0.1) or your external IP.
Click NEXT
In the next part, make sure that the options are satisfied as shown in picture below.
http://img.photobucket.com/albums/v5...a/Pangya07.jpg
Click NEXT
Click "Change the default database to" then click the down arrow to open a list and choose "ini3_py_account."
Click NEXT and then "Finish".
Open a window, you can click OK.
Now repeat everything in the DBs INI3Bill_DB and Pangya_S4_TH
credits: casadostutoriais
Still cant see the CHANNEL LIST? How to fix it
I'm not the same person who you told to do this, but I get this error when I reach the part that I bolded and underlined in the quote.Quote:
Originally Posted by outlawzzbr
http://img41.imageshack.us/img41/6752/66960400.th.jpg
P.S. Still don't know how to add servers/channels to the list.
Hey, Ive been reading through this form for a while now downloading and preparing all the files, but I don't think i set up my SQL database right, can anyone give me a little direction on setting it up?
Also i am having the same error as mikumiku
EDIT: also when i try to Patch the files from 580.05 to 582.04 it loads the launcher and starts to install 582.06, is this ok? or should i not update it to that client
Sql Native Client >>> Emu <<< Newbie.Quote:
Originally Posted by outlawzzbr
I was screwed over by both Pangya GG and Pangya Ntreev and I would like to make a private server but, Wow. This looks really hard, I have read every page twice over and still have no idea where to start if anyone could give me their MSN to talk me over it with I would be extremely grateful.