MuCore 1.0.8 Premium Full + 2 Template

[fratika]

MuCore 1.0.8 Premium Full + 2 Template

AS THE TITLE SAYS, HERE I WILL LEAVE YOU A VERY NICE MU CORE 1.0.8! I HOPE YOU ENJOY IT!!

     

Changelogs:
- 100% working PHP5 decoding
- Include Webzen template by default!
- Include MagicHand MU Editor 2.1 support CASH STORE/editor
- Add z-team Characters
- [Recover Password] Image Demo Check if reCAPTCHA™ is checked.
- [Site] "Returns" cache, you can now press the go back button without losing any filled form data
- [CP Admin] Number of hours have been increased on the Cron Jobs side.
- [Web Server] CPU and RAM usage reduced by 40%
- [System Login] Improved lag free. No more SQL queries needed.
- [Castle Siege Module]
- [Installation Process] the first time you visit the website using your Exlorer by typing http://localhost or http://127.0.0.1 the first runtime will redirect to the process facility.
- [Class Compatibility] Compatibility with Rage Fighter and Master Fist added, you can edit without any restrictions in your admin panel and its displayed in the ranking.
- [Event Log] We have created 2 new small modules called admin logger and user log, which allows you to keep a log of actions performed on our website (user side) and in the admin panel which keeps a log who accesses that area and what actions they perform and which IP is involved, this is a security measure implemented in order to check if administrators abuse their powers. All logs are stored in a protected folder.
- [Integration] Webshop added to the installation part. Once this is done, you will be able to view the store immediately without a problem. Additionally, the Webshop database has been fixed so that new items do not present a problem.
- [Organization] reorganized the navigation bar for better use of modules.

INSTALLATION GUIDE:

1. Edit PHP settings in php.ini:

+ Require extension enabled:
- MSSQL drivers (php_mssql.dll PHP 5.2, php_dblib.dll, php_sqlsrv.dll, php_pdo_sqlsrv.dll) if use Connection Type MSSQL
- GD Image Library (php_gd2.dll)
- OpenSSL (php_openssl.dll) if using SMTP secure connection (SSL or TSL).

- Magic_quotes_gpc must be disabled - Off
- Short_open_tag must be enabled - On

2. Enable MOD REWRITE if custom page URL
- Go to apache\conf\httpd.conf, open it, find modules #LoadModule rewrite_module/mod_rewrite.so, delete # from the front save and restart the web server

3. Install MSSQL Server! Recommended SQL Server 2008 R2 Standard / Pro / Ultimate, Express version does not have SQL Agent to run the job.
-> Restore DB or Attach skipp DB if you have DB.

4. If you use MD5: Add to MD5 database!
- Copy the 'WZ_MD5_MOD.dll' (included in installation folder) to C:\Program Files\Microsoft SQL Server\MSSQL\Binn\
- Run SQL queries:

-- ------------ -------------------------------------------------- ----------------
-- /****** Register MD5 ******/

Code Select Expand

USE [master]
GO

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS OFF
GO

-- /****** DROP Object:  ExtendedStoredProcedure [dbo].[XP_MD5_EncodeKeyVal]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[XP_MD5_EncodeKeyVal]') AND OBJECTPROPERTY(id, N'IsExtendedProc') = 1)
 EXEC sp_dropextendedproc N'[dbo].[XP_MD5_EncodeKeyVal]'
GO

-- /****** DROP Object:  ExtendedStoredProcedure [dbo].[XP_MD5_EncodeString]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[XP_MD5_EncodeString]') AND OBJECTPROPERTY(id, N'IsExtendedProc') = 1)
 EXEC sp_dropextendedproc N'[dbo].[XP_MD5_EncodeString]'
GO

-- /****** DROP Object:  ExtendedStoredProcedure [dbo].[XP_MD5_CheckValue]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[XP_MD5_CheckValue]') AND OBJECTPROPERTY(id, N'IsExtendedProc') = 1)
 EXEC sp_dropextendedproc N'[dbo].[XP_MD5_CheckValue]'
GO

-- /****** ADD Object:  ExtendedStoredProcedure [dbo].[XP_MD5_EncodeString]  *  Dao Van Trong - Trong.CF ******/
EXEC sp_addextendedproc N'XP_MD5_EncodeString', N'WZ_MD5_MOD.dll'
GO

-- /****** ADD Object:  ExtendedStoredProcedure [dbo].[XP_MD5_CheckValue]  *  Dao Van Trong - Trong.CF ******/
EXEC sp_addextendedproc N'XP_MD5_CheckValue',   N'WZ_MD5_MOD.dll'
GO

-- /****** ADD Object:  ExtendedStoredProcedure [dbo].[XP_MD5_EncodeKeyVal]  *  Dao Van Trong - Trong.CF ******/
EXEC sp_addextendedproc N'XP_MD5_EncodeKeyVal', N'WZ_MD5_MOD.dll'
GO

-- USE [Me_MuOnline]
USE [MuOnline]
GO

-- /****** DROP Object:  UserDefinedFunction [dbo].[fn_md5]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fn_md5]') AND type IN (N'FN', N'IF', N'TF', N'FS', N'FT'))
 DROP FUNCTION [dbo].[fn_md5]
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[fn_md5] *  Dao Van Trong - Trong.CF ******/
CREATE FUNCTION [dbo].[fn_md5]  @DaTa varchar(10), @DaTa2 varchar(10))
RETURNS binary(16)
AS
BEGIN
 DECLARE @Hash binary(16)
 EXEC master.dbo.XP_MD5_EncodeKeyVal @DaTa, @DaTa2, @Hash OUT
 RETURN @Hash
END
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[UFN_MD5_CHECKVALUE]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT  *  FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[UFN_MD5_CHECKVALUE]') AND xtype IN (N'FN', N'IF', N'TF'))
 DROP FUNCTION [dbo].[UFN_MD5_CHECKVALUE]
GO

CREATE FUNCTION UFN_MD5_CHECKVALUE (@btInStr VARCHAR(10), @btInStrIndex VARCHAR(10), @btInVal BINARY(16))
RETURNS TINYINT
AS
BEGIN
 DECLARE @ioutResult TINYINT
 EXEC master..XP_MD5_CheckValue @btInStr, @btInVal, @btInStrIndex, @ioutResult OUT
 RETURN @ioutResult
END
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[UFN_MD5_ENCODEVALUE]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT  *  FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[UFN_MD5_ENCODEVALUE]') AND xtype IN (N'FN', N'IF', N'TF'))
 DROP FUNCTION [dbo].[UFN_MD5_ENCODEVALUE]
GO

CREATE FUNCTION UFN_MD5_ENCODEVALUE (@btInStr VARCHAR(10), @btInStrIndex VARCHAR(10))
RETURNS BINARY(16)
AS
BEGIN
   DECLARE @btOutVal BINARY(16)
   EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
   RETURN @btOutVal
END
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[SP_MD5_ENCODE_VALUE]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[SP_MD5_ENCODE_VALUE]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[SP_MD5_ENCODE_VALUE]
GO

CREATE PROCEDURE SP_MD5_ENCODE_VALUE
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS 
BEGIN
 DECLARE @btOutVal BINARY(16)
 EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
 UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
 RETURN @btOutVal
END
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[Encript]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Encript]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[Encript]
GO

CREATE PROCEDURE Encript
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
 DECLARE @btOutVal BINARY(16)
 EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
 UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[Encripta]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Encripta]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[Encripta]
GO

CREATE PROCEDURE Encripta
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
 DECLARE @btOutVal BINARY(16)
 EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
 UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[DencriptPW]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DencriptPW]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[DencriptPW]
GO

CREATE PROCEDURE DencriptPW
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
 DECLARE @btOutVal BINARY(16)
 EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
 SELECT memb__pwd  FROM MEMB_INFO WHERE memb__pwd  = @btOutVal AND memb___id = @btInStrIndex
END
GO

-- /****** CREATE Object:  UserDefinedFunction [dbo].[Cassandra_MD5]  *  Dao Van Trong - Trong.CF ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Cassandra_MD5]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[Cassandra_MD5]
GO

CREATE PROCEDURE Cassandra_MD5
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
 DECLARE @btOutVal BINARY(16)
 EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
 SELECT @btOutVal
END
GO

-- ------------------------------------------------------------------------------
-- /****** Use MD5  *  Dao Van Trong - Trong.CF ******/
ALTER TABLE [dbo].[MEMB_INFO]
ADD memb__pwd2 varbinary(16)
GO

-- UPDATE [dbo].[MEMB_INFO] SET memb__pwd2 = CAST(memb__pwd as VARBINARY)
UPDATE [dbo].[MEMB_INFO] SET memb__pwd2 = CONVERT(varbinary(16),memb__pwd)
GO


ALTER TABLE [dbo].[MEMB_INFO]
DROP COLUMN memb__pwd
GO

EXEC sp_RENAME 'MEMB_INFO.[memb__pwd2]' , 'memb__pwd', 'COLUMN'
GO
-- ---------------------------------------------------------------------------------------
/* -- >=SQL2005 No DLL - Remove xp_md5 extended procedure first
USE [master]
GO

CREATE FUNCTION [dbo].[fn_md5]  @DaTa varchar(255))
RETURNS CHAR(32)  AS
BEGIN
 RETURN SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @DaTa)), 3, 32)
END
GO

GRANT EXECUTE ON [dbo].[fn_md5] TO [public]
GO
*/
-- ---------------------------------------------------------------------------------------

-- ------------------------------------------------------------------------------
-- /****** Not Use MD5  *  Dao Van Trong - Trong.CF ******/
/*
ALTER TABLE [dbo].[MEMB_INFO]
ALTER COLUMN memb__pwd varchar(16) NOT NULL
GO
*/
-- ------------------------------------------------------------------------------

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS ON
GO

--  Get Source SQL
--
-- USE master;
-- GO
-- EXEC sp_helptext 'fn_varbintohexstr';
-- GO
--
- Enable/replace MD5 in joinserver


5. Edit Web configuration in config.php:
+ Select connection type:
- MSSQL: $core['connection_type'] = "MSSQL";
Need MSSQL and prepared drivers to enable protocol: TCP/IP, Named Pipes

- ODBC: $core['connection_type'] = "ODBC";
Need Merge ODBC.reg file

+ If single use 'MuOnline' change core database $ ['server_use_2_db'] to '0'.
+ If use database like 2 'MuOnline' and 'change Me_MuOnline' $ core [ 'server_use_2_db'] to '1'

+ Change Connection Settings:
- $Core [ 'db_host *'] = "127.0.0.1"; database host IP address or pcname\SqlInstanceName
- $Core [ ' database_name *'] = "MuOnline"; Database name
- $Core [ 'db_user *'] = "sa"; SQL authentication user
- $Core [ 'db_password *'] = "YourSQLPassword"; SQL Authentication

+ Change Admin Login Info: - $Core['admin_username'] =
'Admin'; admin user
- $Core['admin_password'] = '12345';

/localhost will automatically redirect to the address http://localhost/install/install.php
If not automatically redirect please visit http://localhost/install/install.php

*Step 1 - Apache Mods required
*Step 2 - Connect to Databases
* Step 3 - Check, Alter Tables
* Step 4 - Add new rows to tables
* Step 5 - Import Cron Jobs
* Step 6 - Configure Website Settings
* Step 7 - Finish the installation.

7. Bug fix:
+ Image check not showing:
- Enabled GD Image Library extension (php_gd2.dll)
- Check site url

+ Connection error:
- Connection to MuOnline Database Failed
- Unable to connect to server
- Server connection error
-> Check information about config.php: Make sure the information entered is correct.
- Db_host: Database of host IP addresses or pcname\SqlInstanceName


- MSSQL extension no longer available on Windows with PHP 5.3 or later: use ODBC or reinstall WebServer/RECONFIG
-> If use SQL2000/2005 -> Install XAMPP + v1.7.3
-> If NOT use SQL2000 -> Installdll)

+ Registration Error / Login Error / Incorrect Password / Your account is invalid:
- Unable to register, reason: system error, please contact the administrator.
- Implicit conversion from varchar to varbinary data type is not allowed. Use CONVERT function to execute this query

-> This problem is changing DB or using MD5 but not config:
- If NOT use MD5 then disabled MD5 on website (Admin Control Panel).
-> Execute SQL query:

Code Select Expand

ALTER TABLE [dbo].[MEMB_INFO]
ALTER COLUMN memb__pwd varchar(16) NOT NULL
GO
Please check again! If it doesn't resolve, reinstall MuCore!


- If user visits MD5 MD5 setting then enable MD5 on website (Admin Control Panel). Please check again! If it doesn't resolve, reinstall MuCore!
Please check again! If it doesn't resolve, then check steps 4!

LINK: MuCore 1.0.8 Premium Full + 2 Template

I HOPE IT WORKS FOR YOU!!
     

You require the following to view this post content:

• You must thank this post to see the content.