   DECLARE profession_id INT;
   DECLARE start_scene INT;
   DECLARE start_x FLOAT;DECLARE start_y FLOAT;DECLARE start_z FLOAT;
-  DECLARE shortSpecies CHAR(32);
+  DECLARE shortSpecies CHAR(255);
+  DECLARE longSpecies CHAR(255);
   DECLARE shared_template_string CHAR(64);
   DECLARE model_position INT;
   DECLARE gender INT(3);


   SELECT scene_id, x, y, z FROM starting_location WHERE location LIKE 'coronet' INTO start_scene, start_x, start_y, start_z;

   SELECT sf_SpeciesShort(base_model_string) INTO shortSpecies;

   SELECT id from species where species.name like shortSpecies into race_id;

   INSERT INTO `object` VALUES (object_id, start_scene, parent_id, base_model_string, start_x,start_y,start_z,oX,oY,oZ,oW, 0, base_model_string, base_model_string, start_custom_name,0, NOW(), NOW(), null, 'player character');
   INSERT INTO `creature`(id, owner_id, bank_credits, cash_credits, posture, scale, acceleration_base, acceleration_modifier, speed_base, speed_modifier, run_speed, slope_modifier_angle, slope_modifier_percent, walking_speed) 
	VALUES (object_id, parent_id, 2000, 0, 0,start_scale, 1, 5, 1, 5, 10, 5, 5, 5 );
	INSERT INTO `player` (id, profession_tag, born_date, csr_tag, current_language, jedi_state)

# --------------------------------------------------------
# Host:                         127.0.0.1
# Server version:               5.3.2-MariaDB
# Server OS:                    Win32
# HeidiSQL version:             6.0.0.3603
# Date/time:                    2011-10-16 13:54:25
# --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
