Twilight
you know why when i buy something in cash shop i get client error?
Printable View
Twilight
you know why when i buy something in cash shop i get client error?
1. Unpack saf (ZeroSignal Python tools)Quote:
Originally Posted by metalknuxx
2. Generate csv or sql from Cash.SData
3. Delete all rows from ProductList table
4. exec import from csv or exec sql script for add new items in ProductList table
5. If error or crash check logs and edit store proc... i think problem RPC game.
Can I install the server in Windows Vista? is there any possibility, please complete a tutorial to help me. : (I do not understand the language of video.:blush: thanks
Hi Twilight^^
nice signature^^
didnt hear long time about B5^^ :thumbup:
the server will run in every version of windows
ah, and the server work with the 2005 version of sql, i'll make a how to later
Tnx. B5 In my heart.Quote:
Originally Posted by Destroyer6666
:):
Thanks metalknuxx, more as a server to run SQL SERVER 2008? only have to format my machine. Thanks = D, sory for inglish.. bye
I tried to run PSGMTool.exe, but I couldn't get it to work, I always get the same error message "GM Server connetion failed".Quote:
Originally Posted by Twilight
Is the solution quoted above a solution for the problem with PSGMTool.exe or it's only to make the Store Procedures to work?
PSGMTool.exe - I have no this file (I do not see the big necessity for it), is probable in the beginning is necessary DSN after that there is a verification using usp_GMTool_Login or (_2, _3)Quote:
Originally Posted by AngryBvr
My opinion at present:
.htaccess + php + store procs
How can i use these GM commands:
/gmnotice
/cnotice
/wnotice
/notice
/znotice
/bnotice
No one work except /bnotice. But when i use it in this form: /bnotice <sentence>
Error: Cannot post a notice. Please check.
Any help ?
Also how to start guild ranking event ?
Quote:
Originally Posted by LightRitual
you make it about this
/gmnotice "Hello"
and all notice cammand use same it
Quote:
Originally Posted by Twilight
hi
i test Status = 80
fill table Users_Master :
Admin = 1
Adminlevel = 255
Status = 80
Use Command
/notice or /getitem
Will Show Unsable command for name GM rights
:?:
Status 16
is use able for all command
Thx THENBA1
:P:
----------------------------------------------------------------------
How fix "%" or rate drop Money from monster? :?:
Thks THENBA1
In other hand, anybody know how to start guild event ?
The event that members from their guild went to Guild Hall, go through a portal and fight mobs for Guild Points and Rank.
my server not working proc usp_AdjustMobsMoney help plz
Quote:
-- ============================================================================
-- Author: ZeroSignal
-- Create date: 24/05/09
-- Description: Adjusts Mobs Money Drop Ranges.
-- Truncated Values are set to max value.
-- Params:
-- @multiplier The gold multiplier. Less than 1 will decrease value,
-- More than 1 will increase.
-- ============================================================================
CREATE PROCEDURE usp_AdjustMobsMoney
@multiplier float
AS
BEGIN TRAN
SET NOCOUNT ON
IF (@multiplier > 10.0)
BEGIN
DECLARE
@overflow smallint
SET @overflow = 32767 / @multiplier;
UPDATE Mobs SET Money1 = Money1 * @multiplier WHERE Money1 <= @overflow;
UPDATE Mobs SET Money2 = Money2 * @multiplier WHERE Money2 <= @overflow;
UPDATE Mobs SET Money1 = 32767 WHERE Money1 > @overflow;
UPDATE Mobs SET Money2 = 32767 WHERE Money2 > @overflow;
END
ELSE
BEGIN
UPDATE Mobs SET Money1 = ROUND(Money1 * @multiplier,0);
UPDATE Mobs SET Money2 = ROUND(Money2 * @multiplier,0);
END
SET NOCOUNT OFF
COMMIT TRAN
GO
I think the best approach to solve this problem is not to use ups_AdjustMobsMoney SP, and just modifiy the usp_Read_Mobs_R SP in this way:Quote:
Originally Posted by phprap
In this way you avoid altering any table data, and to vary the money that monters drop you only need to change the value of @Multiplier.Code:ALTER PROC [dbo].[usp_Read_Mobs_R]
AS
DECLARE @Multiplier AS INT
SET @Multiplier = 10
SELECT MobID, MobName, [Level], [Exp], AI,
(
CASE
WHEN (Money1 * @Multiplier) > 32767 THEN 32767
ELSE (Money1 * @Multiplier)
END
) AS Money1,
(
CASE
WHEN (Money2 * @Multiplier) > 32767 THEN 32767
ELSE (Money2 * @Multiplier)
END
) AS Money2,
QuestItemID, HP, SP, MP, Dex, Wis, Luc, [Day], [Size], Attrib, Defense, Magic,
ResistState1, ResistState2, ResistState3, ResistState4, ResistState5, ResistState6, ResistState7,
ResistState8, ResistState9, ResistState10, ResistState11, ResistState12, ResistState13,
ResistState14, ResistState15, ResistSkill1, ResistSkill2, ResistSkill3, ResistSkill4, ResistSkill5,
ResistSkill6, NormalTime, NormalStep, ChaseTime, ChaseStep, ChaseRange,
AttackType1, AttackTime1, Attackrange1, Attack1, Attackplus1, Attackattrib1,
Attackspecial1, Attackok1, Attacktype2, Attacktime2, Attackrange2, Attack2,
Attackplus2, Attackattrib2, Attackspecial2, Attackok2, Attacktype3, Attacktime3,
Attackrange3, Attack3, Attackplus3, Attackattrib3, Attackspecial3, Attackok3
FROM Mobs
ORDER BY
MobID ASC
If you have already used ups_AdjustMobsMoney SP, you need to restore Mobs Table data to its initial state to make your server work againg.
thank you.Quote:
Originally Posted by AngryBvr
tool > 1 http://www.megaupload.com/?d=S2K9JZMX
tool > 2 http://www.megaupload.com/?d=HC7MWUKL
tool > 3 http://www.megaupload.com/?d=X5R9SZ0I
http://img196.imageshack.us/img196/5...3839441.th.png
http://img188.imageshack.us/img188/3...0697b51.th.png
http://img40.imageshack.us/img40/815...d672851.th.png
http://img36.imageshack.us/img36/909...e4dd451.th.png
sql tools
link > http://www.megaupload.com/?d=F6DYFQI0
virus scan > virus found
Antiv
lol
No View
help me..!!
http://img91.imageshack.us/img91/9281/hhh111.jpg
... enable in game options game/playerQuote:
Originally Posted by smc1985
PS_DBAGENT_system.log
Anyone know which stored procedure is the affected one, I'll go through the posts but I'm feeling a bit lazy atm. :PCode:2009-06-10 19:57:09 PS_DBAGENT__system log start (DBAgent01)
2009-06-10 19:57:09 UpdateGuildPointRankDB Result=-1
2009-06-10 19:57:12 connect game
I'm guessing it's:
PS_GameData.dbo.uxp_Update_GuildPointRank that may be the issue.
Nevermind it's because of this section of code I have no GuildDetails records.
Code:IF @CheckDate = 1
BEGIN
SELECT @InitSystemCheck=Count(*) FROM GuildDetails
IF ( @InitSystemCheck = 0 )
BEGIN
RETURN -1
END
SET @OldRankTime = ( SELECT TOP 1 RankTime FROM GuildRankLog ORDER BY RankTime DESC )
IF ( @OldRankTime IS NOT NULL )
BEGIN
IF ( DATEDIFF( day, @OldRankTime, @RankTime ) < 7 )
BEGIN
RETURN 0
END
END
END
i need help. when i click Control Service> Start All Server Service. all loads and then pauses again. by themself... and Session doesen't even start. it holds on pause. what should i do?
about "Linked Servers" i made some video.
YOUTUBE VIDEO
and question... this is correctly ???
how use gm command /getitem?
Quote:
Originally Posted by g2server
/getitem Type TypeID Count
see PS_GameDefs->Items
Hi all :)Quote:
Originally Posted by ZeroSignal
most of commands on list dosent work on me, can anyone tell me how to use them and if only admin can use it all or normal GM too?
Thank you all
Thks..:rolleyes:Quote:
Originally Posted by Twilight
Help me ,please
When I going to caves, i usually swimming like that ( look at picture) ! And i always through the wall
http://i3.photobucket.com/albums/y52...Shaiya0000.jpg
http://i3.photobucket.com/albums/y52...Shaiya0001.jpg
http://i3.photobucket.com/albums/y52...Shaiya0002.jpg
:?::?:
That why?
phprap those tools u have aren't in english.. any1 feel like localising them? XD
NO!Quote:
Originally Posted by ZeroSignal
MY Tool edit data.saf
NetFrameWorks 2.0
Enjoy
db eps4 full ?Quote:
Originally Posted by ZeroSignal
anybody know how to start guild event ?
The event that members from their guild went to Guild Hall, go through a portal and fight mobs for Guild Points and Rank
@ZeroSignal
convert Cash.SData to .sql for me?
sorry my bad eng
No just Ep3, I'm pretty sure you need a new executable for Ep4.
Installation Instructions Here.
NIce Zero
Server update/Update to all server , progres OK..
but server can`t start ..
still this same thingJust click here to view
please some help about ..
database not restouring , post db backup ps_gameDefsQuote:
Originally Posted by ZeroSignal
2 DB ps_game.. not workingQuote:
Originally Posted by phprap
Can someone reup this ?Quote:
Originally Posted by AgMuN4o
ps_gameDefs is there, the issues was the ordering of command in the batch Installer. I have uploaded a new version, see:Quote:
Originally Posted by phprap
SHAIYA_SERVER_LITE_v0-12.zip
Make sure you clear your previous Databases and Shaiya Services.
Let me know if there is any issues.
does not restore sql2000Quote:
Originally Posted by ZeroSignal
Could you give instructions on how to save changes in English please.Quote:
Originally Posted by phprap
I can export and open the sdata files, but can't seem to get changes to save.
I don't see why it wouldn't did you install with Mixed mode Authentication?Quote:
Originally Posted by slichan
If you posted the error instead of just saying does not work I may be able to help.
Help me, please :(::(::*::*::*:Quote:
Originally Posted by zrockmanx
sorry...I am not good at English.Quote:
Originally Posted by ZeroSignal
-----------------------------------------
Error 3169 :
The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.
-----------------------------------------
the database of sql2005 is not Restore in sql2000.
Ah I c ok, I will have to look into that issue to see if I can support legacy backup structures, thanks for the feedback.Quote:
Originally Posted by slichan
upload game.exe + ep4 plz
It is possible to construct itself in any language..Quote:
Originally Posted by LightRitual
Example five -minute codes. Change INI
this problem is really strange...
still this same thingi.. strange thing video.
about DB when restore see this error message http://brzozki.com/chiters/tytułu.bmp
im use MSSQL 2000 sp4
is install with Mixed mode Authentication
:grr: :mad: HARDCORE , im lose 48 hours ...
reup game.exe ep4 plz
http://www.***********.de/forum/shaiya/
Has the Shaiya[US] Ep4 NoGG Mutliclient.
With your tools excellent work but since it's in a different language it's very difficult to use. If you make language strings part saved in Project Properties >> Settings, we can change the language strings via a config file.
ip change?Quote:
Originally Posted by ZeroSignal
SImple just search for "72.55.177.194" then change it to your IP Address followed by a null terminator (0x00). Make sure the byte order is preserved or u will corrupt the executable.
http://img195.imageshack.us/img195/8650/aee.jpgQuote:
Originally Posted by ZeroSignal
http://img195.imageshack.us/img195/676/aeer.jpg
Make sure local login Server is running as 127.0.0.1.
thx, now workedQuote:
Originally Posted by ZeroSignal
http://img31.imageshack.us/img31/7477/gfge4g.jpg
hello everyone im stuk with something and i hope this tread can solve my problems.
1
I can buy and use but I can't Give Gift to other
"No item located on th at spot"
works well for me (server 2003/mssql 2k5)
tyvm!
Help!
Required, Gift Points Item to database.
I can add in the database?
[QUOTE=Dogo;5081952]hello everyone im stuk with something and i hope this tread can solve my problems.
1
Help me. I want money drop *200 but I don't know how.
plz tell me code sql or code query.
[ Double post sorry ]
why if i buy something on cash shop my client crashes?
people please help me change this ip 192.168.1.007 file.... thanks a lot...PHP Code:http://www.mediafire.com/download.php?thiytkm1tm5
This file is packed (ASProtect 1.23 RC4 - 1.3.08.24-> Alexey Solodovnikov)Quote:
Originally Posted by linjimmy
For unpacking use stripper_v207ht or other new version
At unpacking by should be npkcrypt.dll and npkpdb.dll
Using odbg it is removed GG
Using HEX the editor is changeable 3 IP addresses.
To me this all to make laziness.
If that you are not able, download already opened exe change in it IP (HEX)
Success
@Twilight: How to check version of the client join in the server ?
any one can answer me?
why when i buy something on de cash shop i get: Error 0 ?
see logs... mb error store proc... or wrong itemsQuote:
Originally Posted by metalknuxx
the log says:
now , the procedure usp_Save_User_BuyPointItems_PayLetterTQuote:
2009-06-19 15:57:11 SaveBuyPointItem 260 [AE]-Kelly qerr=-1, {?=call usp_Save_User_BuyPointItems_PayLetterT(393,260,200,'B1_Mycha0001','2009-06-19 15:57:11',1)}
and the procedure usp_Update_UserPointQuote:
/****** Object: Stored Procedure dbo.usp_Save_User_BuyPointItems_PayLetterT Script Date: 2008-6-7 18:31:58 ******/
/****** Object: Stored Procedure dbo.usp_Save_User_BuyPointItems Script Date: 2008/3/15 下午 05:25:51 ******/
CREATE Proc usp_Save_User_BuyPointItems_PayLetterT
@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@UseDate datetime,
@ServerID int
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @UseType int
DECLARE @ReturnValue int
SET @UseType = 1 -- 掘衙
BEGIN DISTRIBUTED TRANSACTION
EXEC @ReturnValue = game.PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
GOTO ERROR
END
-- 檣 離馬(Old, 夥煎 UPDATE僥 陳塒唳辦 醴憮纂陛 號檜 橾橫陴)
--UPDATE game.PS_UserData.dbo.Users_Master SET Point=Point-@UsePoint WHERE UserUID=@UserUID
--IF( @@ERROR<>0 OR @@ROWCOUNT=0)
--BEGIN
-- GOTO ERROR
--END
-- 檣 煎斜 晦煙
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@ProductCode,@UseDate)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END
COMMIT TRAN
RETURN 1
ERROR:
ROLLBACK TRAN
RETURN -1
SET XACT_ABORT OFF
SET NOCOUNT OFF
GO
help plzzz :xQuote:
/****** Object: Stored Procedure dbo.usp_Update_UserPoint Script Date: 2008-6-7 18:34:05 ******/
CREATE Proc usp_Update_UserPoint
@UserUID int,
@UsePoint int
AS
SET NOCOUNT ON
DECLARE
@UserPoint int
SELECT @UserPoint= ISNULL(Point,0) FROM Users_Master WHERE UserUID=@UserUID
IF ( @@ROWCOUNT=0 OR @UserPoint-@UsePoint < 0 )
BEGIN
UPDATE Users_Master SET Point=0 WHERE UserUID=@UserUID
RETURN -1
END
UPDATE Users_Master SET Point=ISNULL(Point,0)-@UsePoint WHERE UserUID=@UserUID
IF( @@ERROR<>0 )
BEGIN
RETURN -1
END
RETURN 1
SET NOCOUNT OFF
GO
For ex check errors store proc:Quote:
Originally Posted by metalknuxx
1. Run Query Analyzer and select db PS_GameData.
2. In SQL query window:
exec usp_Save_User_BuyPointItems_PayLetterT(393,260,200 ,'B1_Mycha0001','2009-06-19 15:57:11',1)
and press button green arrow (RUN)... see error?
i think problem in row
EXEC @ReturnValue = game.PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
change
EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
PS: Query Analyzer error log?
query analyzer error
man i love you :3Quote:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '393'.
problem fixed
one more thing Twilight
can you post the product list and Cash.SData of RunUp client?
Before to execute a script, it is necessary to remove all old records from table ProductListQuote:
Originally Posted by metalknuxx
well, you have the item list and the item.SData of runup too? :D
repack error in last rowQuote:
Originally Posted by metalknuxx
well, you have the item list and the item.SData of runup too? :D
[quote=metalknuxx;5091651]well, you have the item list and the item.SData of runup too? :D
Any one help me run SData Extractor in Python ?
I put the Skill.SData in the SData folder, Right click at the SData.py -> Edit with IDLE and then...
http://c.uploadanh.com/upload/0/348/...1245476414.bmp
create bat file.. and runQuote:
Originally Posted by LightRitual
inside:
SData.py Skill -o sql_update_lang
Example bat.. extract All
i have this error using Item.Py, of ZeroSignal
http://img291.imageshack.us/img291/2479/semttulocbm.png
You do not call Item.py. You call SData.py and specify which SData you want to work on.
To find out the usage type:
For your example:Code:python SData.py
Code:python SData.py Item -o csv_import
i'm not used de SData complete tool
i used only the item.py, that you posted.
when ai use the SData.py for Item csv_impot
it says that is a invalid parameter
Twilight.... I want database PS_GameDefs item shop work for ranup. Plz give me. I bad ENG sorry T.T
Thank You.
I got a few problems with setting up a server hope some people can help.
1. I start up my server they all go to the green arrow to show them ready to go.
5 seconds later "session" goes to the Pause icon a few seconds after that they all go to it. ive tried restarting and adding npcoff thing in the groups section but still no luck
2. can you use "Hamachi" to host a private server if so do i need to change every "127.0.0.1" i find in the server folder and change it to my Hamachi address?
hope somone can help :)
see logs inQuote:
Originally Posted by Timmmeh
PSM_Client\Bin\Log\
hi,
anyone can tell me where i can find and edit quests and NPC on my server? I have look around but dont find anything for quest, I have edited it on client side but it is only changed on screen need do same on server, please help
thanks
There's nothing in that folder?Quote:
Originally Posted by Twilight
It is necessary to set up correctly all INI filesQuote:
Originally Posted by Timmmeh
In OS the list of services PSM_AgenrServer and PSM_Agent should be enabled
please anyone know? dam with 4 post i never get an answer , please someone helpQuote:
Originally Posted by Dogo
thanks
when buy item shop Disconnect error 0. help me Please
edit the procedure
usp_Save_User_BuyPointItems_PayLetterT
on GameData table
change this
EXEC @ReturnValue = game.PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
for this
EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
click apply and close
IN GameData no have usp_Save_User_BuyPointItems_PayLetterT (T.T) help me
Timmeh, did you find out if hamachi works to conect to server?Quote:
Originally Posted by Timmmeh
[Double post sorry]
Still havent got passed question 1. I think it may be because its not connecting to my SQL database when i install the server says its because "Remote connection defult is set to only take in somet" so i changed it but still not working :\Quote:
Originally Posted by superpayo
asoon as i get it up and running with 127.0.0.1 i will try using a hamachi IP and running it all.
Hamachi works fine!
please anyone can tell me where i can find NPC for edit them and insert items on shop? please answer me I never received answer on this forum lol please and thanks
http://c.uploadanh.com/upload/0/375/...1245941308.bmp
Can anyone upload the stored procedure 'usp_Insert_Action_Log_E' for me ?
And how to fix Guild store procedure, everytime I restart my server, all Guilds disappear, i check my database and i see that the Guilds Table is empty so i think that my problem is the store Guild procedure.
Srr for my bad eng.
Thanks in advanced.
PS_GameLog -> AttachQuote:
Originally Posted by LightRitual