Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
thx your share files.
but first connnect mysql error
C:\DB Clone\Game>node web.js [ NORMAL ]: MYSQL Connect! [ NORMAL ]: Listening on LOCAL 81Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.query (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:200:8) at MySQLStore.set (C:\DB Clone\Game\node_modules\express-mysql-session\lib\index.js:192:19) at Session.save (C:\DB Clone\Game\node_modules\express-session\session\session.js:72:25) at Session.save (C:\DB Clone\Game\node_modules\express-session\index.js:381:15) at ServerResponse.end (C:\DB Clone\Game\node_modules\express-session\index.js:330:21) at ServerResponse.send (C:\DB Clone\Game\node_modules\express\lib\response.js:205:10)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.query (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:200:8) at MySQLStore.set (C:\DB Clone\Game\node_modules\express-mysql-session\lib\index.js:192:19) at Session.save (C:\DB Clone\Game\node_modules\express-session\session\session.js:72:25) at Session.save (C:\DB Clone\Game\node_modules\express-session\index.js:381:15) at ServerResponse.end (C:\DB Clone\Game\node_modules\express-session\index.js:330:21) at SendStream.notModified (C:\DB Clone\Game\node_modules\send\index.js:351:7)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)Error: connect ECONNREFUSED 127.0.0.1:3306 at Object.exports._errnoException (util.js:1026:11) at exports._exceptionWithHostPort (util.js:1049:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1081:14) -------------------- at Protocol._enqueue (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:141:48) at Protocol.handshake (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:52:41) at PoolConnection.connect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Connection.js:136:18) at Pool.getConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:48:16) at Pool.releaseConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:155:10) at Pool._removeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:275:8) at Pool._purgeConnection (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:256:8) at Handshake.onConnect (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\Pool.js:57:14) at Handshake.Sequence.end (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\sequences\Sequence.js:85:24) at Protocol.handleNetworkError (C:\DB Clone\Game\node_modules\express-mysql-session\node_modules\mysql\lib\protocol\Protocol.js:364:14)
if you have trouble importing the SQL do this.
create database called "game" and import as follow
1. game_accounts.sql
2. game_account_sessions.sql
3. game_users.sql
4. game_user_avatars.sql
5. game_user_avatar_equiped.sql
6. game_guild.sql
7. game_guild_member.sql
8. game_routines.sql
9. game_event_log.sql