SimDog.net Is A Simulated Dog Network
Print All MySQL Database Tables & Fields Using PHP on 1.13.2009 - <?php //connection variables $database = "your_db_name"; $user = "your_username"; $pass = "your_pass"; //connection to the database mysql_connect($host, $user, $pass) or die ('cannot connect to the database: ' . mysql_error()); //select the database mysql_select_db($database) or die ('cannot select database: ' . mysql_error()); //loop to show all the tables and fields $loop = mysql_query("SHOW tables FROM $database") or die ('cannot select tables'); while($row = mysql_fe...SQL Server 2005, Select All Tables & Fields on 1.13.2009 - SQL: select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_name in (select name from sysobjects where xtype='U') order by table_name...
Contract PHP/MySQL Programmer Needed on 11.25.2008 - Are you passionate about games?!? Like animals? Do you live in Northern Virginia? Then perhaps you're the person I'm looking for. My name is Jade and I started programming my first game when I was only 13. Today it has over 100k members and it's still growing!! Only I can't keep up with it anymore, and that's where you come in. Job Description I'm looking for someone in the Northern Virginia area whose interested in game programming on a contract basis starting in January 20...
VGXPO Success! on 11.24.2008 - Wow, I had a great time and I got to meet a ton of really great people!! Steve Reid and Gano Haine gave excellent advice on how to pitch a game idea. They stressed topics like tailoring to your target audience, discussing key factors in your game, avoiding things that would make someone's eyes glass over (like talking someone through the opening video scene -- kill me now!), to catching executives attention with creative strategies. One example they gave ...
VGXPO Meet N Greet List on 11.17.2008 - Here's a list of everyone I'm planning to talk to/meet this coming Saturday. Heh, I'm bringing resumes, business cards, and hopefully my finished business plan. Matt Shaw - Chief Technology Officer at Mythic Entertainment (EA Games) Ravi Mehta - VP of Publishing at Viximo Chris Oltyan - Director of Product Development at ...
GameFrenzi Image Uploader/Manager on 11.6.2008 - Started working on the GameFrenzi uploading script and image manager and ran into a snag. Turns out you can't grab the file you're uploading and use Ajax unless you use an iframe. This sets the entire project back as we re-work the image processing code. Hopefully this tutorial will help....
CSS Javascript Properties on 10.27.2008 - document.getElementById("id_name_here").style property = whatever; CSS PropertyJavaScript Equivalentbackgroundbackgroundbackground-attachmentbackgroundAttachme...
Ubisoft & Best Buy Affiliations? on 10.10.2008 - So I'm finally breaking down and hiring a financial adviser for my little business. Her name is Jacqui Shea and she's a doll!! She helped my mom invest her money in this horrible stock market right now (yes!! forget TV, now is the time to buy! 30% discount, whoo hoo!!). It turns out her associate has contacts with the marketing director at Ubisoft and is willing to hook me up. He also knows some big directors from Best Buy who give out ...
Havok Physics Contest on 10.3.2008 - I found this cool contest I'm thinking about entering. It's sponsored by Intel and winner gets 40k. Maybe it's worth my time or maybe it's worth yours!...
Lesson 7: Pits of Doom -- Join, Login & Lost Password on 9.25.2008 - In the last lesson we created a database class to make doing queries quick and easy to handle. Then we converted over the current character file and map editor to use the database when storing/retrieving information. Finally, I added an additional file so you could import your map.txt files into your database from any you made in the previous lessons. Now it's time to make our game start to feel like a real game. In this lesson we'll create two new classes, a member's class and a character's ...
Lesson 6: Pits of Doom -- MySQL Database Class on 9.18.2008 - In the last lesson I introduced you to functions, reading & writing to a file, some simple javascript and adding features to the game so we could swap in/out maps and move up/down map levels. Now this is all fine and dandy, but we live in the age of databases so it's time to pull out your thinking caps. Let's get busy converting everything we've done so far to a database. Lesson Concepts MySQL Basics ...
Lesson 5: Pits of Doom -- Easy Map Editor on 9.18.2008 - In the last lesson we made some real progress. Now, instead of having a boring page with a click of one button before the game is over, we have a character that can move around a much larger area, be blocked by walls, fall into pits and die, and then win if they find the treasure. That's all fine and dandy but our game needs more substance. It's time to add more maps, map levels, and our very own easy map editor so we can quickly make maps, generate map files, and play our game with a whole n...
Austin Game Developer's Conference on 7.25.2008 - Bruce Sterling to Keynote Austin GDC "Computer Entertainment 35 Years From Today" Presented by Bruce Sterling, Science Fiction Author When Pong emerged 36 years ago, it broke the m...
Lesson 4: Pits of Doom -- And Array We Go on 7.19.2008 - In the last lesson we covered how to create a function, how to use some of php's built in functions, and how to deal with sessions. Now we'll take it even a step further. If you've tried the little game we have setup right now you'll agree with me that's its not only boring, it's really REALLY boring. Right now you can click one button and either win or loose the game. In the big scheme of things we want our character to walk around different maps, moving from place to place as well as fighti...
Lesson 3: Pits of Doom -- Mixing Things Up on 7.16.2008 - In the last lesson we covered how to make a form, check to see if a button has been pressed, and display a message according to whether the user found the treasure or not. Now it's time to take our very simple navigation page to the next level: random treasure location. In our final game, the position of the treasure will be pre-determined by data in our database. However, we won't know what position the treasure is in as the user is navigating their character around the game because this inf...
Lesson 2: Pits of Doom -- Breaking It Down on 7.14.2008 - One of the best things to do if you've never made a game before or you don't have much programming experience is to break things down into their most basic parts. We'll start off making this game by doing some really really simple programming and then adding functionality until the game is complete. It doesn't look like much now, but at the end of this tutorial you'll be able to download a fully working version with an installation file that you can use under the GNU public license to modify and...
Lesson 2: Pits of Doom -- Breaking It Down on 7.14.2008 - One of the best things to do if you've never made a game before or you don't have much programming experience is to break things down into their most basic parts. We'll start off making this game by doing some really really simple programming and then adding functionality until the game is complete. It doesn't look like much now, but at the end of this tutorial you'll be able to download a fully working version with an installation file that you can use under the GNU public license to modify and...
Lesson 1: Pits of Doom -- the planning stage on 7.10.2008 - Before you start any kind of online game you need to take a minute to sit down and consider some of the following questions: What is my game called? What is my target audience? Can I afford the cost and time of manging my own game? Am I good at working with people? What competition already exists for the game I'm going to make? How will my game work? It's All In A Name A name can make or break a g...
Free Multiplayer PHP/MySQL Game -- Pits of Doom on 6.30.2008 - About a month ago I started giving someone PHP/MySQL lessons. In the lessons I made up a little game to teach the guy how to do different things in PHP all the way up to making his own multiplayer online text-based game. So in the next few months I'm going to share insights on creating your own PHP/MySQL game by posting the code for this little game under the GNU public license. That way you're free to edit/update and change it as you see fit. If you'd give me credit for it (or at least keep the...
Movie Video Games: Cop-Outs? on 5.23.2008 - Just yesterday I was watching the TV and a commercial for the new Narnia Movie came up. Or so I thought. Instead it turns out it was for the Narnia video game. Then today I open my Gamasutra Newsletter and what do I see? More movies being turned into video games. Maybe its just me, but somehow I feel like these games are a cop-out. Instead of coming up with their own fresh, original ideas they snatch someone else's creative vision. Yes, yes I know that most brilliant ideas are a bunch of good...
Now Offering AJAX Chat on 5.23.2008 - Design1online.com is now proud to offer a AJAX chat room as a part of its basic online game package. Now, instead of having a refreshing PHP chatroom, reloading pages is no longer an issue. The chatroom is a modded version of the free open source AJAX chat from blueimp. It comes fully integrated into your game's control panel and your game. Only members of your game will be able to enter the chat and they always enter with their username...
Vancouver International Game Summit features Call of Duty 4, May 21- 22 on 5.11.2008 - T...
Learning PHP (Part 3) on 5.3.2008 - In part 2 I covered else-if statements and more complicated if statements. One of the other concepts that's essential to learning any kind of programming is loops. There are three different types of loops (while loop, for loop, and do while loop), but I'm only going to cover two of them here. While Loops The concepts of loops is extremely simple. While some condition is true you're going to run the same bit of code again an...
Learning ASP on 4.30.2008 - Well, it looks like I'm resigned to learning several new languages if I'm going to program in them for the next several years. So I figured out how to turn on the IIS in Windows Vista (dreadful OS, I know) and start the server up and running so I can practice before I start coding this coming Monday. If you have Vista then you can easily write and test your own ASP scripts without downloading a thing you just have to setup IIS. Here's how you do it: Setting up IIS for Vista ...
Potential Game Engine on 4.13.2008 - So the bad news is I spent a good 5-6 hours downloading a lot of game engines, perusing through the soure code, and trying to complie it on my machine. Most of them were very annoying and I ended up giving up fairly quickly. A few of them had really, really slow FPS rates (*cough* OGRE *cough*) and if they were slow on my computer they have no chance in a multiplayer setup. The good news is I found one I really liked. It's called Irrlicht. The engine is completely open source so I can add to ...
Go To Page: 1 2
Go Play!
