zTeam Ex802 Full English Server And Client Cracked !

[Maddox]

Main.exe is encrypted? i cant put Game Guard in this main. anybody knows how to insert antihack in this client? thanks :)

[kbcakbca]

someone help me fix the imperial event Guardiam (Gaion order event), time to kill

mobs is only one minute want to increase the time, anyone know

how to change it?

[KarLi]

I also tried that in Map 31 (Land of Trials) I set the drop rate into 10000 or 1000 but not work.

i think the rate for LOT its between 1 - 100 ?

[MaskARRA]

How to add command for Mary System?

[2009x2014]

How to add command for Mary System?

Mary system does not exist in current release.

[PgStyleR]

Buglist for now? Have crashes? Backdoor?

[berzinsj]

when i sell in shop soul, she give me 250kk , how to change to 1kk?

[jakess]

Hello there! I have some bugs what i dont know how to fix:
1) Mastery Ice storm skill stuns players in pvp 100%. Cant move till death.
2) Mana turns negative when use summoner buff berserker and kill monsters. It happens till some level and after that works fine.
3) When make summoner wings in CM, they are with durability 0 and can not repair it.
4) Excellent items do not shine/glow like excellent.

Please help me with that. Need to fix those bugs. Thank you!!!
...

[Maddox]

how to set excellent items drop into 100% because this is not working..

MonsterExcellentItemRollRate = 10000 //-> Range: 1~10000

===================

JewelofHarmony Option works only at Level 13 items? thanks :)

thanks.

[KarLi]

Hey can anyone convert this sql script

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GensServerInfo]
 @imapSvrGroup		SMALLINT,
	@iUpdateDays		INT,
	@iPrizeDays			INT
AS
BEGIN
	BEGIN TRANSACTION
	SET NOCOUNT ON
	DECLARE @lastUPDATE_DAY		int
	
	IF NOT EXISTS( SELECT UPDATE_TIME FROM GensMainInfo WHERE MAP_SVR_GROUP = @imapSvrGroup )
	BEGIN
		INSERT INTO GensMainInfo (MAP_SVR_GROUP,UPDATE_TIME) VALUES  @imapSvrGroup,GETDATE())
	END
	
	SELECT @lastUPDATE_DAY=DATEDIFF(day,UPDATE_TIME,GETDATE()) FROM GensMainInfo
	
	IF @lastUPDATE_DAY > @iPrizeDays
	BEGIN
		UPDATE GensUserInfo SET memb_rank = (SELECT COUNT(*) FROM GensUserInfo a1, GensUserInfo a2 WHERE a1.memb_contribution <= a2.memb_contribution AND a1.memb_char = GensUserInfo.memb_char AND a1.memb_clan = a2.memb_clan GROUP BY a1.memb_contribution )
	END
	
	IF @lastUPDATE_DAY >= @iUpdateDays
	BEGIN
		UPDATE GensMainInfo SET UPDATE_TIME = GETDATE() WHERE MAP_SVR_GROUP = @imapSvrGroup
		UPDATE GensUserInfo SET memb_reward = 0
		SET @lastUPDATE_DAY = 0
	END
	
	SELECT @lastUPDATE_DAY AS DaysFromUpdate

    IF(@@Error <> 0 )
		ROLLBACK TRANSACTION
	ELSE	
		COMMIT TRANSACTION
END
GO
/****** Object:  StoredProcedure [dbo].[GensDelUser]    Script Date: 08/13/2014 10:59:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GensDelUser]
	@szCharacter	VARCHAR(10),
 @igens			INT
AS
BEGIN
	BEGIN TRANSACTION
	SET NOCOUNT ON;
	
	DECLARE @curGens INT;
	DECLARE @Result INT;
	
	SET @curGens = 0;
	SET @Result = 0;
	
	SELECT @curGens=memb_clan FROM GensUserInfo WHERE memb_char = @szCharacter
	
	IF @curGens <> @igens
	BEGIN
		SET @Result = 3;
	GOTO ProcEnd
	END
	ELSE
	BEGIN
		DELETE FROM GensUserInfo WHERE memb_char = @szCharacter
		SET @Result = @@Error;
	END
	
ProcEnd:

	IF @Result <> 0 )
		ROLLBACK TRANSACTION
	ELSE	
		COMMIT TRANSACTION		
		
	SELECT @Result AS Result
END
GO
/****** Object:  StoredProcedure [dbo].[GensAddUser]    Script Date: 08/13/2014 10:59:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[GensAddUser]
	@szCharacter	VARCHAR(10),
 @szguildMaster	VARCHAR(10),
 @igens			TINYINT
AS
BEGIN
	BEGIN TRANSACTION
	SET NOCOUNT ON;
	
	DECLARE @Result INT
	DECLARE @guildGens INT
	DECLARE @Rank	INT
	
	SET @Rank = 0;
	SET @Result = 0;
	SET @guildGens = @igens;
	
	IF  @szguildMaster <> '' )
	BEGIN
		IF NOT EXISTS(SELECT memb_char FROM GensUserInfo WHERE memb_char = @szguildMaster)
		BEGIN
			SET @Result = 5;
			GOTO ProcEnd
		END
		ELSE
		BEGIN
			SELECT @guildGens=memb_clan FROM GensUserInfo WHERE memb_char = @szguildMaster
		END
	END
	
	IF  @guildGens <> @igens )
	BEGIN
		SET @Result = 4;
		GOTO ProcEnd
	END
	
	IF EXISTS(SELECT memb_char FROM GensUserInfo WHERE memb_char = @szCharacter )
	BEGIN
		SET @Result = 1;
	END
	ELSE
	BEGIN
		SET @Rank = (SELECT COUNT(*) FROM GensUserInfo WHERE memb_clan = @igens)+1
		INSERT INTO GensUserInfo (memb_char,memb_clan,memb_contribution,memb_rank,memb_reward) VALUES
			(@szCharacter @igens,0 @Rank,0)
			
		SET @Result  = @@Error
	END
	
ProcEnd:
	
	IF @Result <> 0 )
		ROLLBACK TRANSACTION
	ELSE	
		COMMIT TRANSACTION
		
	SELECT
	 @Result AS Result,
	 @igens AS iGens,
		0 AS iContrib,
	 @Rank AS iRank

END

to make it work on zGameServer cus i am trying to make sql 2000 database work and i get only that error in zMultiServer yet.


[03:23:32] exec GensServerInfo 0,30,7
[03:23:32] SQLSTATE:42S02, SQLSTRING:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'GensMainInfo'.
[03:23:32] SQLSTATE:25000, SQLSTRING:[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 256, current count = 257.


Thanks =]

[Maddox]

how to hide Common.z which is ip and serial encoded?

Enigmas has error due to main.exe is not open.

thanks.

[MaskARRA]

i think the rate for LOT its between 1 - 100 ?

Ok ill try later mate.. Thanks

- - - Updated - - -

ok thank you mate :)

[CyvorgZhen]

Boxes cant drop.. (11-8) update.

[KarLi]

how to hide Common.z which is ip and serial encoded?

Enigmas has error due to main.exe is not open.

thanks.

hide or not it doesn't matter much they can find it somehow.

[jakess]

Hello there! I have some bugs what i dont know how to fix:
1) Mana turns negative when use summoner buff berserker and kill monsters. It happens till some level and after that works fine.
2) Excellent items do not shine/glow like excellent.

Please help me with that. Need to fix those bugs. Any ideas?