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?