Bugs When Buying

[Monks666]

Hi pp!

I've tha Pangya Version 2.15b with this archives:

Pangya-Server (2.15)
Pangya Patch (2.15b)
Pangya Client (2.15b)
MSSQL 2000

--- I've setup pangya following the forum tutorials and it works normally ---

But some errors are happening when I try to buy some itens like: Kooh, Cadie, Decoration, Kooh's Cothes... etc...

the errors are:

"There has been a error with your product"

and

"Insuficient Funds"

I'm Master A with 600000 pangs and 2000 cookies

What's hapenning? How can I resolve this?

[MentaL]

[g1garas2]

it easy, you can get this player by add procedure . you can search in google with key word " pangya offline add kooh" , sorry pangya post don't have moderator, it's very bad. I have to aska about pangya server pangya season 2, but no respon.

[Monks666]

Thx man... I've add the procedure but I don't know how to use that... how to use the command of procedure with my logname?


----

EDIT

Wooh! I've found an excelent web manager but it has an error and I can't do somethings in the web like log in, log in with ADM, trade pang by cookies and vice-versa...

ERROR:

----
Microsoft OLE DB Provider for ODBC Drivers erro '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER-1CCC01\IUSR_USER-1CCC01'.

/pangya/chklogin.asp, line 14
-----

How can I resolve this?

[g1garas2]

hahaha, first time, i see it's hard, but i know when i try. Look that

1.) Go to database> Bn_Game> Stored Prosedure.
2.) In stored prosedure, click right click > New Stored Procedure
3.) Delete all text( Exsample: CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS)
4.) Add your prosedure (Exsample you want to add kooh and some her item , add its :
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

5.) Klik Ok, and see menu bar> Tools > SQL Query Analyzer
6.) Add you procedure to your ID (exsample your ID is g1garas2 (is my ID ^^) and your want to add kooh and item, in your procedure with name "AddKoohAndItemTo")Add it :
AddKoohAndItemTo g1garas2
and then click Execute Query (or if you don't know click F5(it's this shortcut) and Tada~~~ Kooh in your ID)

now, if you want add item or another it your item but you can't buy it go to database>Bn_Game>Pangya_Item_TypeList and search code items are you want.
Exsample you can't buy Hana One Piece Red Carrot, you search the code and make new procedure, like make kooh and item and add this code

CREATE Proc AddHanaItemTo
@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, (Hana Code Item One Piece Red Carrot), 1, getdate());
RETURN
END
GO

and back to SQL Query Analyzer

Thanks you... Sorry For My Bad English

[Monks666]

Thx Man, finally now I know to execute procedures... but I'm still stoned with webmanagers... ^^,

[g1garas2]

You're welcome, and i need some help with you, have you got pangya server season 2? if you have share ,please . Thanks...

[Monks666]

So... I've found here the archives of a server 2.15+ that can be used with a client 3.12 Season 2... but I guess nobody knows exactly how to work totally the server... I've hexed the projectG and changed the IPs following the way that they told me but it just don't work... if you want try... go ahead plz... and if you have sucess... I beg you... share... ^^,

Archives...

Client
Server Files
discussion topic

SeeYa

[g1garas2]

thank you! i will try, if connect, i will give you..