Dayo

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html this article better explains what I said earlier

Is the web application that you are accessing the database from on the same server as the MySQL database?

After a few threads today it got me wondering who used linux, if so what distributions do they use? At work i use Arch Linux for my main development PC, the product we develop uses gentoo. At home i have a computer running Ubuntu and another dual booting Arch+Windows (for gaming)

so you want to access your MySQL server remotely from a different machine? if so there are two options. 1) You can open a ssh tunnel from you local PC to the remote server to forward the mysql port (usualy 3306) 2) You can edit the my.cnf file and edit the bind address from 127.0.0.1 to 0.0.0.0 then alter the MySQL user privileges to allow connections from any host (% i think)

I used elementary for a while, the UI is very nice but runs off an old Linux kernel and is not as fast as alternatives. But i would recommend this/Ubuntu to a first time Linux user. i would recommend arch Linux to someone use to the command line Some laptops have a recovery partition on the HDD, you could check if you have one. But i would advise checking Linux out at some point even if you have it as a VM, for development it is so much easier then windows

Title: The Forbidden Age Game abstract: TFA is a text-based RPG based of games like runescape, skyrim etc... You can make multiple characters of various classes and explore a large expanding world. (Some of the) Unique features: - A large game world - A content driven game - Multiple skills for the user to train - Easy to expand on (i plan on having things like DLC that you get on consoles (for free)) - There can be multiple game worlds Technology used: I use my own JavaScript framework for everything on the front end, on the backend there will be a API written in PHP using a MySQL database. There will also be a node application running to handle the real time events. Current development status: I have started on the coding side bellow is what has been completed: - Front end framework - Back-end PHP API - An installer written in BASH to create new game worlds - Login/register - Server selection - Character selection - Create a character - Open/Exit game My own skills and tasks in the game: I am more of a developer then a content writer or designer, i work full time making energy management systems, i use PHP/MySQL/JavaScript everyday so i would say im fairly good with them. What I/we are looking for: Im really looking for a content writer as i have a basic idea of what i want but to take it to the next level i will need someone else. Expenses will be covered by: I will pay all of the hosting/domain costs, i have already sourced 90% of the graphics that we will need so i cant foresee any bills that would come up in the next 3-6 months but if any do i am willing to pay them. Current team: Currently it is just myself, but i do have plans on expanding as the game progresses Share / gain of the partners: This is negotiable depending what you can bring to the table. If you do not want a percentage i am happy to pay for your work or even a mix of both.

@op This looks interesting i may see if i can use this at work for our graphing software as some graphs have 1m+ data points would be handy to stream teh data down rather then wait for it all to load I had 3 extra monitors running of of these http://www.ebay.co.uk/itm/1080P-UGA-USB-2-0-To-DVI-HDMI-VGA-Multi-Display-Adapter-Converter-Graphics-Card-/200732269188 they were great for programming (not so good for gaming)

You would connect just as normal unless you are using port 8080 for something else I agree currenly these values are randomly generated like mt_rand(1, 7)." days ".mt_rand(1, 23)." hours" justy so i could see what the UI would look like. But once its coded properly it will be formatted correctly (i.e. missing the 's')

Everything about the game is/will use ajax loads (i even use them to load new modules (pages)), ill also use node sockets for things like mail/events so the user gets them real time :)

Ill look into the brick background. As for the logo that is because it is bellow a backdrop (like my The Mercenarys project if anyone remembers), the screen shots i provided dose not show that properly see bellow: Server Select: http://prntscr.com/7m9004 Ingame: http://prntscr.com/7m90gh Please not alot of the quality was lost with the upload I have someone working on a new logo at the moment, he is making several designs then from there ill choose one

Ive been working on the backend the last few days so there has been little to show you. Ive now started the in game UI ive got a few ideas on the layout thought i would post them here to get peoples opinion. This is what i have so far: http://prntscr.com/7m32a5 Options 1) Have a fixed bar along the bottom with the character stats 2) The bar at the bottom can be expanded to show the stats/inventory/levels 3) Have a menu/stats down the left side of the page

You could possibly even use a node.js server with sockets so that you don't need to do ajax polling granted this a bit more work but would eliminate most of the strain on your server. If this is not possible (ie your on shared hosting or dont want to learn it) you can use ajax polling, but as you are using mccodes you will need to make a php script that only puts a php array in JSON format then use JQuerys $.ajax with a setInterval()

That is not possible unless you use $.ajax and set async to false (but this would be the wrong way as the rest of the script cant run). To do this properly and asynchronously you would have to do something like this $.get("a.php", function () { var b = "derp"; var a = { b: 2300000, c: data }; // do something with `a` here within the get callback });

The art is either from Graphic River or released under licences that let me use them i them merge them together to make what you see :) As for Runescape/Skyrim that is the sort of game im making so im glad its giving off that vibe :D

Thanks im glad people are liking what they see :) Ive just finished coding the create a character module so now i can start on the game modules :D

Last week i decided to resurrect TFA a project i started over a year ago after finding the old project files. After going through the old code i have started from scratch using my PHP and JS framework. So far i have coded the basics. Ill be updating this album with modules as ive made them. Ive estimated the coding will take 6-8 weeks and the content another 4-6 weeks so by October i should have some sort of beta to show.

Started work on the map tonight as it is going to be a major part of the game, this is what i have so far (for the start im only going to do one continent as you will see there is still a lot to do :P) Zoomed out: http://prntscr.com/7izkea 100%: http://prntscr.com/7izl9f Will still need some work but ill refine it as i go

After looking throght my old archives i found the old TFA documents and looking at the artwork now available on graphic river/open game art i decided to re start TFA but rather then start with the million features i had planned before ill make the core of the game then add new features as i go. I have the main framework coded up and most of the database structure designed. Over the weekend ill code up the front end template from my sketches. Whilst im doing that my brother will be starting work on the content i.e. making the items, NPCs, towns etc. I also have 20 days of holiday i have to take at work so i may take a week or two so i can get some serious development underway. Im not going too put a time scale down at the moment as i have to go through every module and plan what i need to do. Does any one know of a project management tool that is any good as the one we use at work is crap lol.

want people opinion of a game idea me and my brother has had. Its a text based game but 90% of the game is single player missions, throughout the missions you can die but there would be save points you could load from. As for the 10% of the game that is not single player there would be certain citys/safe zones were people can trade/battle etc

If i were coding this i would first make a system to store and show stats, then once you have this then code the achievements on top. Something like <?php /* CREATE TABLE `statistics` ( `user` int PRIMARY KEY, `type` int PRIMARY KEY, `success` int, `fail` int ); CREATE TABLE `statisticTypes` ( `id` int PRIMARY KEY AUTO_INCREMENT, `name` varchar(255) ); */ class Stats { public function __construct($uid = false) { //$database_connection = new PDO(); $this->db = $database_connection; if ($uid) { $this->uid = $uid; } else { $this->uid = $_SESSION["uid"]; } } private function addNewType($typeName) { $insertType = $this->db->prepare("INSERT INTO `statisticTypes` (`id`, `name`) VALUES (NULL, :name);"); $insertType->bindParam(":name", $typeName); $insertType->execute(); return $this->db->lastInsertId(); } private function getTypeID($typeName) { $selectType = $this->db->prepare("SELECT `id` FROM `statisticTypes` WHERE `name` = :name"); $selectType->bindParam(":name", $typeName); $selectType->execute(); $type = $selectType->fetch(PDO::FETCH_ASSOC); if (!empty($type["id"]) { return $type["id"]; } else { return $this->addNewType($typeName); } } private function insert($typeName, $success = false) { $typeID = $this->getTypeID($typeName); $col = ($success?"success":"fail"); $altCol = ($success?"fail":"success"); $updateStat = $this->db->prepare("UPDATE `statistics` SET `".$col."`=`".$col."`+1 WHERE `user` = :uid AND `type` = :type"); $updateStat->bindParam(":uid", $this->uid); $updateStat->bindParam(":type", $typeID); if (!$updateStat->execute()) { $insertStat = $this->db->prepare("INSERT INTO `statistics` (`user`, `type`, `".$col."`, `".$altCol."`) VALUES (:user, :type, 1, 0);"); $insertStat->bindParam(":uid", $this->uid); $insertStat->bindParam(":type", $typeID); $insertStat->execute(); } } public function fail($typeName) { $this->insert($typeName, false); } public function success($typeName) { $this->insert($typeName, true); } }; $attacker = new Stats($user1); $defender = new Stats($user2); $attacker->fail("attack"); $defender->success("defence"); Ive just thrown this together untested so will need some work. If you coded it like this module makers could implement it without doing anything in the database.

looks sweet

I mainly use sublime and vim. I have used brackets.io alotvtoo

Yea it was a good/unique concept but as you can see there were alot of features/gameplay ideas too much for me to take on atm :P The thing is i wish i would of coded it a different way now. Just latley ive been using JS for 90% of my work and only using PHP to do DB calls but to do this i would be better off starting from scratch

The problem with TFA was the ideas i had were just so large, it would take me a year or so just writing the content.

The last year or so i have taken a break from any serious game development, but now that is finished i will be getting back into game development. If there is any work that you need doing i.e. mods, templates, securing, bug fixing etc feel free to contact me via PM. Examples of work: - Available upon request Languages: HTML/CSS JS/JQuery PHP/MySQL (+MsSQL but im sure no one uses it here)