Search the Community
Showing results for tags 'mysql'.
-
Base MMORPG - Node, MySQL, Colyseus, Parcel and Phaser 3
Damian Pastorini posted a topic in Phaser 3
Hi everyone! Before anything I wasn't sure if this was the correct place to post this, please moderators move it as you consider if this should go to some other place like Projects and Demos. https://github.com/damian-pastorini/dwdgame Also, please consider that this is my first implementation ever! I've never used neither Node.js, even less Parcel, Colyseus or Phaser, my world before this first incursion in game development was all about PHP and Magento, so that should give you an idea from where I'm coming. This quite awful but working example took me 75hs, including the time I've used for research and for decide which platform use for the server and the client. After all the research, Node + Colyseus and Phaser 3 looked as the better start point since I was familiar with JS and HTML of course but had zero knowledge about Unity (the other option I would like to use), but I've prefered make the learn curve not so slow. So.... This is a really simple base MMORPG game created based on the Colyseus samples: https://github.com/gamestdio/colyseus-examples And on the Phaser 3 implementation from Jacky Rusly: https://github.com/jackyrusly/jrgame As you will see I've considerable modified how the jrgame was interacting with Socket.io in order to make it works as how the Colyseus example was working, I've thought that was the better way to do it (follow up on server ready samples and break apart the client sorry Jacky!) The game basics are login through DB, loader, scene change, players sync, but nothing like chat, items, or attacks was implemented here (so far). Here's the link to the repo: https://github.com/damian-pastorini/dwdgame Please feel free to create any tickets or pull requests for questions, fixes or improvements, I would love to get good feedback! I don't have a public link to show it yet but I'm planning to create a dev server soon (for now you will need to install it and run it to see it), at the end it will look like: https://jrgame.herokuapp.com But you will see the login screen first which in the server side will connect to the DB and all the players sync was done with Colyseus. I saw comments from people looking for Colyseus integrated with a DB engine (in this case I've chosen MySQL), so at least that part should be useful. I really hope this help more than one person, maybe someone like me who would love to get this as starting point. Best, Damian Reply- 18 replies
-
- multiplayer
- games
- (and 9 more)
-
i using nodejs ,mysql ,express i trying put two methods in same route to render the same file but i have this error in my firefox 404 my code aliança route const express = require('express') const router = express.Router() const connection = require('../../Config/database') const controllerAdmin = require('../../controllers/Administration') const controlleruser = require('../../controllers/Alliances') router.get('/Administration/Alliances', (req, res) => controllerAdmin.findcidade3(connection, req, res)); router.get('/Administration/Alliances', (req, res) => controlleruser.findAlianca(connection, req, res)); module.exports = app => app.use('/', router) aliança controller const Allianca = require('../models/Alliances') const findAlianca = async (connection, req, res) => { const allianca = await Allianca.find(connection,req.session.user.username) if (!allianca) { res.status(404).send('Nenhuma cidade encontrada.') return; } console.log("dddd"); req.session.alianca = allianca res.locals.alianca = allianca res.render('Administration/Alliances') } module.exports = { findAlianca } aliança models const find = (connection,username) => { return new Promise((resolve, reject) => { connection.query(`SELECT alianca.nome,alianca.N_membros,alianca.TAG FROM user INNER JOIN alianca ON user.cod_alianca=alianca.id WHERE user.username='${username}'`, (err, result) => { if(err){ reject(err) }else{ console.log(result[0]); resolve(result[0]) } }) }) } module.exports = { find } na app tenho o seguinte require('./routes/Administration/Alliances')(app) aliança.jade tenho assim extends layout block title .col-xs-6.col-xs-offset-3.col-sm-6.col-sm-offset-3 .col-sm-4(style='width:76%') div.panel.panel-primary(style='height:50px') Alliances Page div.panel.panel-primary(style='height:700px') fdssdklfsdklfjskldfjkldsjfl if locals.user.cod_alianca==null p You Dont Have Alliances else br span Your Aliance span= locals.alianca.nome .col-xs-2.panel-red(style='width:24%;height:100%;text-align:center') coneção com base dados tenho o seguinte const mysql = require('mysql') const config = require( "./config.json" ) const connection =mysql.createConnection({ host:config.host, user:config.user, password:config.password, database:config.database, // port:config.port }); connection.connect((err) =>{ if(err){ console.log(err) process.exit(0) }else{ console.log('database on') } }) connection.query(`CREATE TABLE IF NOT EXISTS user (userId INT(11) NOT NULL AUTO_INCREMENT, username VARCHAR(50) DEFAULT NULL, password VARCHAR(60) DEFAULT NULL, PRIMARY KEY (userId))`, (err ,result) =>{ if(err){ console.log(err) } }) module.exports = connection and cmd have this errors GET /Administration/Alliances 500 217.138 ms - 7876 GET /Administration/vendor/bootstrap/css/bootstrap.min.css 404 42.201 ms - 7876 GET /Administration/vendor/fontawesome/css/font-awesome.min.css 404 80.007 ms - 7876 GET /Administration/vendor/themify-icons/themify-icons.min.css 404 112.356 ms - 7876 GET /Administration/vendor/animate.css/animate.min.css 404 142.545 ms - 7876 GET /Administration/vendor/perfect-scrollbar/perfect-scrollbar.min.css 404 176.203 ms - 7876 GET /Administration/vendor/switchery/switchery.min.css 404 208.608 ms - 7876 GET /Administration/stylesheets/plugins.css 404 35.953 ms - 7876 GET /Administration/stylesheets/styles.css 404 64.049 ms - 7876 what i doing wrong
-
About MGN Studios: MGN Studios is the new game development division of Freedom! Family Limited. Our mission is to create great games and technologies that actively engage and involve the YouTube community of players, bloggers, reviewers and creators. We’re setting up shop right here in beautiful Vancouver! If you want to join a start-up where you get to work remotely and build something new, and be a part of an honest & transparent leadership team with a veteran Studio Head, then MGN Studios is for you! THE ROLE: Are you up for the challenge? We are currently seeking a Senior Game Engine Developer to join our team in leading the architecture and development of browser-based video game engine technology. You will be the driving force in the design and development of our studio’s game engine infrastructure. You should be comfortable diving deep into technical architectures and requirements, able to quickly identify solutions to challenges discovered during development, and ready to direct and mentor other developers in creating a robust and scalable code base. Prior experience building browser-based multiplayer game technology is preferred. We are looking for someone to be a key participant in the creation of a collaborative environment that leverages agile development and rapid prototyping; rewards creative solutions and intelligent risk taking; fosters a culture of excellence, respect, and fun; and makes great games. RESPONSIBILITIES: Are you ready to make a contribution to our team? Lead the design, implementation, and growth of a browser-based HTML5 multiplayer game engine. Manage and mentor a team of software developers through the interactive development process. Set company-wide code development standards and best practices. Work with game designers and artists in the development of game features, art pipelines, and tools. Partner with producers, PMs, and other leads on schedules and plans. Identify technical and production issues/risks and propose solutions. QUALIFICATIONS: Do you have what it takes? Degree in Computer Science and/or relevant professional experience. 5+ years experience in professional software development. 3+ years of experience in the development of game engines. Very good knowledge of existing game engines (e.g. Unity, GameMaker, Phaser, Pixi, Turbulenz, etc.) and server side technologies. Deep knowledge of modular programming, API design, and game architectural patterns. Extensive experience with frontend and backend technologies such as HTML5, Javascript, CSS/CSS3, jQuery, PHP, Python, Node.js, MySQL, etc. Source revision control experience (Github preferred). Professional experience in agile software development. Experience working effectively in cross-functional game teams. Excellent oral and written English communication skills. Experience developing MMO city builder games is a PLUS Experience developing casual MMO .io games is a PLUS Experience with Apache Ant, iOS WebKit, Android Webkit / Chrome is a PLUS Knowledge of video platforms including YouTube, Dailymotion and Twitch is PLUS COMPENSATION: Competitive Salary Flexible work hours Flexible work locations (home, office, etc.) Are you intrigued? Here are a few more reasons to make MGN Studios your daytime/anytime home: Work remotely - Did we already mention you get to work remotely? Yes, it’s true! Leadership - Do you like working with veteran Studio Head who will give you clear direction, honesty and guidance, and believes people are the pillars to success. He’s the opposite of an evil villian with a curly moustache. Build something new - Play a role in building a game development studio that can’t stop and won’t stop growing. Career growth - Make an impact by leading projects and driving the direction of the studio. Develop initiatives and solutions that drive your career and boost the studio’s growth. For Freedom! Does this sound like you? Please apply asap as we are interviewing immediately for this permanent, full time position. PM and we can arrange a time to speak over the phone!
-
Job posting: Studio FOW Position: Senior Game Software Developer We are looking for a game senior game software developer who can deliver web based, HTML5 game applications. The role includes overseeing the full development life cycle including identifying the correct technology, architecting the application, security, testing and deploying. This is not a project management role, you will be solely responsible for implementation. The candidate must have a proven track record in developing web based game applications using WebGL and JavaScript. We expect the developer to be able to deliver a modular, scalable and testable application. You will also be working to integrate existing pre-rendered video content into the game which forms an integral part of the player experience. Experience in enterprise grade applications would be necessary so the design could address high availability requirements (i.e. load balancing and clustering). Experience in WebSockets and relational databases such as MySQL, PostgreSQL or MS SQL are required. Experience in ECMAScript, NodeJS and node-webkit would be a plus. Knowledge of other programming languages (Python, C++) is also a plus. Please note that this game will be of the adult (18+) variety and therefore anyone uncomfortable with such content need not apply. A portfolio and references will be required during the interview process.
- 4 replies
-
- html5
- javascript
-
(and 5 more)
Tagged with:
-
Like many of my gen (back in the BBS days) I felt it would be nice to bring a game or two from that world, to the browser world. With some of the cool tricks you can do in HTML5, it became quite easy in some aspects and a little tricky in other aspects. I have (many times) rewrote LORD, from scratch - and no source code to follow - just various places around the net and my personal time in the original game - to php/sql and php/flatfile, but never released it, although Seth did check out one of them and said it was better than many he has seen-and that was an older version of mine. due to a mistake on my part switching drives (I have 5 HDD totally many TB) I lost lots of projects - one of my drives got wiped - LORD being one of them. After I saw some cool things with html5 - I started one back up again a few years later (last year to be exact). My question, Where can I post it for testers? How about if I want to know more about html5 to make it more enjoyable - as it sets it is STRICTLY a text game - to keep with the spirit of the original. Although much of it will be changing. I was gonna post all the info here, but after reading the posting requirements and see the examples - it doesn't look like it would be a good fit here - which leads to my 2nd question, where on the net do they have a browser game support and gallery?
- 3 replies
-
- bbs
- bbs to browser
-
(and 2 more)
Tagged with:
-
I am developing one application (platform) where I have 10 users (maybe this will increase with time). I have created one login page and created one map using tiled (phaser framework). But this map is now same for all users, What I want is to create a separate map for every user and that will be visible after login. Please give me some suggestion so that at least I can try. Or give some idea for this implementation. Thank you !
-
- javascript
- phaser
-
(and 2 more)
Tagged with:
-
Hey Guys, I'm a freelance developer since 2005. I'm developed about 100 slotmachines and other gambling stuff, build some casual games and working as webdeveloper on serveral projects like cashboard.de (winner of the SevenVentures Pitch Day 2014). At the last weeks I worked a lot with phaser and build some HTML5-Slots with it. Now I'm searching for some new experiences. If you need a programmer for your website or a game, feel free to contact me. MySkills: HTML5, CSS, JS, jQuery, Bootstrap, Phaser PHP, MySQL, Symfony2, Doctrine, Twig, RedbeanPHP Flash, ActionScript 2/3 Some Demos: Arthur - Be A King HTML5 | Phaser | Slotmachine Lost City Treasures HTML5 | Phaser | Slotmachine West Wind Pirates Flash ActionScript3 | 50:50 BubbleCrusher Flash ActionScript2 | Match-3 Find the Mistakes | HTML5 | Phaser | Find Differences IdleTower | HTML5 | no game framework just jQuery + jStorage | Idle-Game BloxxClicker | Flash ActionScript3 | Idle-Game
- 1 reply
-
- flashrevolution
- phaser
-
(and 8 more)
Tagged with:
-
The website I am working on has a game embedded in a page. Between levels the player navigates away from the game and is shown some page content (the game incentivises the customer to view the content using game play between viewing the pages. The user has a logged in status in a user table in Wordpress and they score points, playing the game, I save these in the database with e..g an ajax call from the game and php script. Then the user views a page of content. AFter viewing this page of content they get to play the game again, build on their score and the game has a new level. I could do an ajax call from the game to see if there are some variables for that player, such as their score, name etc from their profile. My game is split into states - preload, boot, game. I was planning on putting the ajax call in the create function of the game state. Does anyone have any experience with this? and can advise.
-
(and a tiny bit of HTML5 but mostly 4) 2-6 players old school hexmap wargame http://thesingularitytrap.com -- if a game is good it does not depend on graphics --
-
We currently have a number of Flash games that run with a PHP and MySQL backend, we are looking for HTML5 game developers to work on an ongoing project by project basis to convert the current Flash games to HTML5 games and also to make new HTML5 games that work with the PHP and MySQL backend. We do not mind what frameworks are used for the HTML5 games as long as the games work on mobile and desktop devices and can be embedded into a web page template along with other content. Looking for programmers with previous gaming experience and who are willing to sign a contract. Will be working from home so must have somewhere they can work at home and be able to work independently. If your interested, please pm me and we can discuss the specifics.
-
Hi.. How should I create and integrate backend made with node.js and mysql with my phaser game. Primarily I want to incorporate leaderboard.
-
I am developing a game and would like to connect it to database on a server in order to make a leaderboard . Its a memory excercise game and would contain some mini games. My aim is to let a user add other users to his friend list and receive notifications of his various activities of those friends like completing a level of one of the mini games, beating the high score of the user in one of the mini games. All in all I would like to how can I achieve php and mysql functionality in phaser.
-
Hi there, I am looking to make a turn-based multiplayer board game on Facebook. I am new to making Facebook games as this would be my first. I'm just looking for any advice or any routes/theories you would recommend. The game would be, 1. Turn Based 2. Play against friends or find someone in the world to play against (Could use request dialogs between friends) 3. Keep records of wins/loses 4. Chatting between the two users Any suggestions or links to would be appreciated. I have some knowledge with the use of JavaScript, PHP and MySQL Thanks
-
We are looking for a professional developer or group of developers for our MMO game that: - Is capable of working at least 20 hours a week - Is fluent in PHP and HTML5 game development - Can convert Flash assets for HTML5 (Ex. spritesheet or animations) - Is very experienced in SmartFoxServer - Is serious about our success as a team/family - Will work with us for life (Part ownership) Please email [email protected] with a cover letter, resume, and portfolio if qualified/interested.