Modification zTeam compatibility patch

Lautaro

Administrator
Developer
Dec 19, 2012
555
231
43
zTeam Compatibility Patch

ONLY FOR WEBENGINE 1.0.7 PL1

What it does:
Code:
- Removes "Master Key" recovery from My Account module
- Fixes My Account module credits display
- Makes the whole web use the zTeam credits table and columns
- Fixes most of the rankings queries
- Fixes credit subtrackting (admincp)
- Fixes character edit (admincp)
- Fixes new registrations list (admincp)
What has been tested:
Code:
[Tested]
- Top level rankings
- Top resets rankings
- Top killers
- Top guilds
- Top grand resets
- Top votes
- Top gens
- Top master level
- Edit character (admincp)
- Edit master level (admincp)
- New registrations (admincp)
- Vote System
- Clear PK
- Reset character
- Clear Skill-Tree
- Unstuck character
- Fix stats
- Add stats
What is NOT compatible with zTeam:
Code:
[Non Compatible Modules]
- Top Online (MuEngine Exclusive)
- VIP System (MuEngine Exclusive)
- Top PVP Last Stand (MuEngine Exclusive)
And, what YOU need to do (using the admincp):
Code:
- add server_info.php cron
- add votes_ranking.php cron
INSTALLATION:
  1. Make a full backup of your website files
  2. Download the ZIP
  3. Extract contents in your website's root
 

Attachments

Netzo

Member
Premium Member
Oct 11, 2013
169
15
18
26
United Kingdom
Online time spent logging
Did not test or check but should work with some modifications:
Code:
/** Sistema "Ranking Minutos Online" **/
ALTER TABLE dbo.MEMB_STAT ADD MinutosOnline int NOT NULL CONSTRAINT DF_MEMB_STAT_MinutosOnline DEFAULT 0
Code:
Use MuOnline

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[WZ_CONNECT_MEMB]
@uid varchar(10),
@server varchar(20),
@uip varchar(20)

AS
BEGIN

BEGIN TRANSACTION

SET NOCOUNT ON
IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid )
BEGIN
UPDATE MEMB_STAT SET IP = @uip , ConnectStat = 1 , ServerName = @server , ConnectTM = (getdate()) WHERE memb___id = @uid
End

ELSE

BEGIN
INSERT INTO MEMB_STAT ( memb___id,IP,ConnectStat,ServerName,ConnectTM) valueS (@uid,@uip,1,@server,(getdate()))
End

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End
Code:
Use MuOnline

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON

GO
ALTER PROCEDURE [dbo].[WZ_DISCONNECT_MEMB]
@uid varchar(20)
AS
Begin
BEGIN TRANSACTION

SET NOCOUNT ON
IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
WHERE memb___id = @uid )
Begin
-- Variable Personalizada Por Andrei - wWw.DFGaMeZ.CoM
UPDATE MEMB_STAT SET DisConnectTM = (getdate()), ConnectStat = 0 , MinutosOnline = MinutosOnline+(DATEDIFF(mi,ConnectTM,getdate())) WHERE memb___id = @uid
-- Dejar GM En Mundo GM y Sin PK
UPDATE Character SET cLevel = 400 , MapNumber = 40, MapPosX = 225, MapPosY = 25, MapDir = 1, PkTime= 0 Where CtlCode = 32 And AccountID = @uid
End

ELSE

Begin
INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,ConnectStat) valueS (@uid,(getdate()),0)
End

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End
 

wiraly

New Member
Premium Member
Oct 16, 2014
24
3
3
31
Yea it is, thank you, i got vote ranking now after adding cron job.
Coins showing in user cp :)
later at evening will check if after donation will be added coins. (before they wasnt added and people get blocked in game)
 

Lautaro

Administrator
Developer
Dec 19, 2012
555
231
43
There's no TT patch at the moment... I thought that team was dead..