LCM Mue s6e3 Free Edition Repack

LCM Mue Free Edition Repack

 

Hi! This repack includes some significant improvements + stability make up. It's a ready package for those who want to avoid fixing bits and pieces of Mu Server files.

 

This file is based on MUE Free Edition by Phit. We've used these files for our Midgard server previously. We have no use for this anymore, we got a our MUE Premium Files. So I'm here to share.

 

Notable Features:

Quote

1 Account Per IP

Custom Credit System (Simple System Structure For Web App Integration)

Fixed Empty Sphere (Client)

ExDB/Ranking/Chat/Event servers replace with DataServerEx from Mu-Server-Ex

Shops Pre-configured For Mid Rate Server

NPCS moderately pre-positioned

Kanturu, Balgass, Crywolf maps added

WZ_MLS_LOAD/SAVE Fixed

WZ_QMK_LOAD/SAVE FIXED

WZ_CONNECT_MEMB FIXED

WZ_DISCONNECT_MEMB FIXED

Lorencia Battle Ring

Mob Spots Pre-configured

 

Performance:

Stable/No Crashes

 

Downloads:

Serveris - https://mega.co.nz/#...TQ_fNlgL0ryfGrY

Klients - https://mega.co.nz/#...hSB4F8vhZCV-OtU

Project MU Main & Patch (including Battle Ring & Seed Sphere 4 & 5 fixes) - https://mega.co.nz/#...hzOiA6TgDUut4r8

NEW MAIN - https://mega.co.nz/#...2BePqIvU4WK0nGU

 

1 Account Per IP:

We've devised our own procedure of prevent multiple account connections by utilizing the WZ_CONNECT_MEMB SQL Procedure. How it works: WZ_CONNECT_MEMB checks if IP already exists in the MEMB_STAT table, if so transfer list GameID1 - 5 to G1 -5 and empty GameID1 - 5 in the AccountCharacter table.

 

The user is forced to create a new character. This time, once the user clicks "OK - Character Creation", WZ_CreateCharacter SQL Procedure is called. The procedure checks for IP from the MEMB_STAT table. If the number of records is more than 1 - rollback transaction. This results in the client being stuck in "Please wait" dialogue & the client is forced to quit.

 

Patches:

Quote

For MU Core 1.08

Find:

$make_me_acc

 

Add After:

 

$make_credits = $core_db2->Execute("INSERT INTO MEMB_CREDITS (memb___id,credits) VALUES (?,?)",array($userid, '0'));

Quote

Fix 1 Account Per IP (Open WZ_CONNECT MEMB)

Find:

IF(@ROW_COUNT > 0)

BEGIN

UPDATE AccountCharacter SET IP=@IP, G1=GameID1, G2=GameID2, G3=GameID3, G4=GameID4, G5=GameID5, GameID1='', GameID2='', GameID3='', GameID4='', GameID5='' WHERE id=@memb___id

 

Add After:

insert into MEMB_STAT (memb___id,ConnectStat,ServerName,IP,ConnectTM)

values(@memb___id, @ConnectStat, @ServerName, @IP, getdate())

Quote

Replace WZ_DISCONNECT_MEMB with:

CREATE PROCEDURE WZ_DISCONNECT_MEMB

@memb___id varchar(10)

AS

Begin 

set nocount on

Declare @find_id varchar(10) 

Declare @ConnectStat tinyint

Declare @OnlineHours real

Set @ConnectStat = 0 -- Á¢¼Ó »óÅ °ª 1 = Á¢¼Ó, 0 = Á¢¼ÓX

Set @find_id = 'NOT'

 

 

DECLARE @ROW_COUNT int

DECLARE @IP varchar(25)

 

SELECT @IP = IP FROM MEMB_STAT WHERE MEMB___ID = @memb___id

SELECT @ROW_COUNT = COUNT(IP) FROM MEMB_STAT WHERE IP=@IP

 

 

IF(@ROW_COUNT > 0)

BEGIN

 

UPDATE AccountCharacter SET GameID1=G1, GameID2=G2, GameID3=G3, GameID4=G4, GameID5=G5 WHERE id=@memb___id

DELETE FROM MEMB_STAT WHERE MEMB___ID = @memb___id

END

ELSE 

BEGIN

 

 

UPDATE AccountCharacter SET GameID1=G1, GameID2=G2, GameID3=G3, GameID4=G4, GameID5=G5 WHERE id=@memb___id

 

 

select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id 

where I.memb___id = @memb___id

 

if( @find_id <> 'NOT' ) -- Á¢¼Ó Á¾·á 󸮴 Á¢¼Ó 󸮸¦ ÇßÀ»¶§¸¸ À¯È¿ÇÏ°Ô ÇÑ´Ù

begin 

SELECT @OnlineHours=DATEDIFF(mi,ConnectTM,getdate()) FROM MEMB_STAT WHERE memb___id = @memb___id

UPDATE MEMB_CREDITS SET Credits=(Credits+(@OnlineHours/3)) WHERE memb___id=@memb___id

DELETE FROM MEMB_STAT WHERE MEMB___ID = @memb___id

 

--update MEMB_STAT set ConnectStat = 0, DisConnectTM = getdate()

-- where memb___id = @memb___id

end

END

end

GO

Quote

Go to your server files & edit: /data/lang/eng/commonloc.cfg

Replace the serial with: Ae2wLmoXmjioZukO or change it to your own serial.

 

Credits To:

Phit - MUEngine

Massimosee - Seed Sphere 4 & 5 Fix, Testing 1 IP fix