1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Modification zTeam compatibility patch

Discussion in 'Customizations & Modules' started by Lautaro, Nov 3, 2014.

  1. Lautaro

    Lautaro Administrator Developer

    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
     

    Attached Files:

    Fabiano Mello and Netzo like this.
  2. Lautaro

    Lautaro Administrator Developer

    @wiraly this might be of your interest.
     
  3. Netzo

    Netzo Customer Customer

    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
     
  4. wiraly

    wiraly Customer Customer

    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)
     
  5. A$$kicker

    A$$kicker Customer Customer

    Any patch for TT version ?
     
  6. Lautaro

    Lautaro Administrator Developer

    There's no TT patch at the moment... I thought that team was dead..
     

Share This Page