The Infinite Loop – Beginner's SEO, Beginner C# & JQuery Tutorials Problem. Problem Solved. Loop. – The life of a programmer

C#/PHP Database Object Generator/Database Access Layer Generator

This is something i have been working on.
It is virtually a tool I use to generate c#/php classes based on a database schema.
The c#/SQL integration works well, however, I am still working to support the php/mysql generation.

It creates very simple base C# classes based on a database connection. The program includes Saving Generation profiles and reloading them at a later time. It has a recently loaded profiles list - and allows you to regenerate the DAO as many times as you like.

By using this C# Database Object Generator/Database Access Layer Creation Tool I can focus on my application development as opposed to my DAL (data access layer) development.

This piece of software is currently in beta - and I am the only beta tester!

If you would like the installer - you can send me an email and I can send you a copy.

Here are some screenshots and some example usage!

And example usage of the classes generated by the c# database object generator tool. Note - the class HeroBase was from the generation files.

public HeroBase GetHeroById(int id)
{

SqlConnection conn = serv.GetConnection();
try
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM hero WHERE hero_id="+id;
cmd.Connection = conn;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
HeroBase h = HeroFromReaderRow(rdr);
if (h != null)
return h;
}
}
catch (Exception ex)
{
throw new Exception("Could not load Heros " + ex.Message);
}
finally
{
conn.Close();
}
return null;
}

public HeroBase HeroFromReaderRow(SqlDataReader rdr)
{
if (rdr == null)
return null;

HeroBase h = new HeroBase();
h.HeroId = Convert.ToInt32(rdr["hero_id"]);
h.HeroName = rdr["hero_name"].ToString();
h.HeroDescription = rdr["hero_description"].ToString();
h.HeroType = rdr["hero_type"].ToString();
h.ImageFile = rdr["image_file"].ToString();
h.ModelFile = rdr["model_file"].ToString();
h.BaseAutoAttackLow = Convert.ToInt32(rdr["base_auto_attack_low"]);
h.BaseAutoAttackHigh = Convert.ToInt32(rdr["base_auto_attack_high"]);
h.BaseMovementSpeed = Convert.ToInt32(rdr["base_movement_speed"]);
h.Premium = Convert.ToBoolean(rdr["premium"]);
h.Concentration = Convert.ToInt32(rdr["concentration"]);
h.ModelRotation = Convert.ToDouble(rdr["model_rotation"]);
h.ModelScale = Convert.ToDouble(rdr["model_scale"]);
h.Active = Convert.ToBoolean(rdr["active"]);
return h;

}

The reason the classes are affixed with the 'Base' word, is because this allows for the extension of these classes. HeroBase is the database version of the class - which includes base_hp, base_energy, base_movement_speed etc etc, however, an actual hero in a game will have much more than this (hp timers, energy/mana timers, current hp, current energy) - the naming of the classes allows for you to easily extend them.

For example:

public class Hero:HeroBase(){
public Hero():base(){
CurrentHP=MaxHP;
}
public int CurrentHP{get;set;}
}


I have classes created named service.
E.g HeroService - this service has necessary methods for loading heroes from the database. This service returns objects of the Hero/HeroBase type.

All in all - it saves me a ton of time and I am glad Ive written this tool. Please comment if you have any interest in it - as I would like to gauge interest before I invest more of my time into refining it. As it sits now - it is perfect for my side project development, however, if there is enough interest - I am more than willing to improve it

Beginner Game programming jobs in Toronto

Well, it seems to me that finding a game programming job in Toronto is going to be pretty hard.
I have used XNA and am currently working on a small c#/xna based engine for a game.
Currently I have the following, none of which are graphical (except for the heroes with a small chase camera):

Heroes (Health, HP regen, Energy Regen, Attacking Mechanisms, Defense Mechanisms)
Hero Abilities
Hero Stats
Creep Waves (CreepEngine class responsible for spawning waves and keeping track of wave timers etc)

and am currently working on a few mechanics - like stealing gold etc.
I guess Im just doing this to kill time and practice coding a game engine, but hopefully it gets to a point where it could be useful to someone.

It seems breaking into the game programming industry will be harder than I thought - teachers in college often discouraged me from it - saying it was a hard industry with tight deadlines etc etc...but what can be more fun than MAKING GAMES?!

There will be a point in time where I know that programming business apps will no longer do it for me - and thats when I want to switch over to game programming. Call it a midlife crisis (at 22 years old) - but I am passionate about it! It seems that most video game companies already want a ton of experience in the game industry - how can someone get that experience if no one in the industry will hire?

Its nuts.
3years with an advanced college diploma - and its not enough.
Everyone wants a bachelors degree in comp sci - because having the money to pay your way through university and being in debt is somehow a sign that your dedicated. I will continue working on my little demo - it wont be easy and it will take a while but, I will get there.

Is anyone in the same situation as me?
Does anyone feel helpless with this whole video game industry?

Its such a big industry - I don't even know where to start (Sure, I can go to a game programming school for $15,000/yr) - but life isnt a crystal staircase and I have bills to pay).

Any tips, inside knowledge etc, is highly appreciated - [b]comment if you'd like please!!! [/b]

Dreamweaver error: xml parsing fatal error: Invalid document structure

If you get an error like this, chances are one of your layout files went corrupt.
I received an xml parsing fatal error: mentioning that my workspace file Designer.xml could not be read.
If you get this error too, no worries, fixing it is simple.
Go to C:/. Click Tools>Folder Options. Click the View Tab. Click 'Show hidden files and folders'.

Navigate to C:/Documents and Settings/username/Application Data/Adobe/Dreamweaver/en_us/Configuration/Workspace. Make a new folder and move all files in that directory into this new folder. Close Dreamweaver and restart it. You should have no more problems with Dreamweaver (this may also work with Flash) and it should load.

Comment if this helped

<?php
/*paging*/
Line 1: $pg=(isset($_GET["pg"]) && is_numeric($_GET["pg"]) && $_GET["pg"]>0 ? $_GET["pg"] : 1);
Line 2: $rowsperpage=10;
Line 3: $offset=($pg>1 ? ($pg-1)*$rowsperpage : 0 );
Line 4: $limitstr=" LIMIT $offset, $rowsperpage";
?>

<?php
print '<div class="paging"><ul>';
for($i=1; $i<=$maxpage; $i++){
  if($pg==$i)
     print '<li><span>'.$i.'</span></li>';
  else
     print '<li><a href="?pg='.$i.'">'.$i.'</a></li>';
}
print "</ul></div>";
?>

using System; //Just so we can use the shortcut Console instead of System.Console
using System.IO; //Gives us access to file, directory objects

string path="C:/"; //set the root path we want to recurse through.

//check if the directory exists
if(Directory.Exists(path)){
        DirectoryInfo di=new DirectoryInfo(path);
        //based on a path, this object will give you directory information about that directory
        printDirectories(di);
        //this method will actually go through our directories and print out information
}else{
        Console.WriteLine("Directory does not exist. Press Enter to exit");
        Console.ReadLine(); //when you hit return the program will terminate.
}

static void printDirectories(DirectoryInfo di){
       foreach(FileInfo fi in di.GetFiles()){
              //we are going to run code for each file
              Console.WriteLine(fi.FullName); //this prints out the full file name including the path
       }

      //now that we process this directory for files, we do the same for every subdirectory in this directory
      foreach(DirectoryInfo subDir in di.GetDirectories()){
             //we are going to call the printDirectories method, with the subdirectory as the root.
            //its files will be processed, then its subdirectories will be checked
            //this happens foreach Directory in the current directory
            printDirectories(subDir); //recurse
      }
}