WebEngine's 6th Anniversary

On December 19th, 2018 we will be celebrating 6 years of WebEngine CMS!
The event is here!

Modification zTeam compatibility patch

Lautaro

Administrator
Developer
#1
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
#3
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
#4
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)
 
Top