epvp*coders project #0001

# MySQL-Front 3.2 (Build 14.8)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost  Database: loki
# ------------------------------------------------------
# Server version 5.0.22-community-nt

DROP DATABASE IF EXISTS `loki`;
CREATE DATABASE `loki` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `loki`;

#
# Table structure for table accounts
#

CREATE TABLE `accounts` (
 `AccountID` int(11) NOT NULL default '0',
 `Username` text NOT NULL,
 `Password` text NOT NULL,
 `SessionID1` int(11) NOT NULL default '0',
 `SessionID2` int(11) NOT NULL default '0',
 `Registration_Date` datetime NOT NULL default '0000-00-00 00:00:00',
 `LastIP` text NOT NULL,
 PRIMARY KEY (`AccountID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table accounts
#

INSERT INTO `accounts` VALUES (10000,'cyrus','master',76741,0,'0000-00-00 00:00:00','127.0.0.1');

#
# Table structure for table characters
#

CREATE TABLE `characters` (
 `CharID` int(11) NOT NULL auto_increment,
 `CharSlot` int(11) default '0',
 `AccountID` int(11) default '0',
 `CharName` text,
 `Class` int(11) default '0',
 `BaseExp` int(11) default '0',
 `BaseLevel` int(11) default '0',
 `JobExp` int(11) default '0',
 `JobLevel` int(11) default '0',
 `State` int(11) default '0',
 `Ailments` int(11) default '0',
 `Option_` int(11) default '0',
 `Zeny` int(11) default '0',
 `HP` int(11) default '0',
 `MaxHP` int(11) default '0',
 `SP` int(11) default '0',
 `MaxSP` int(11) default '0',
 `Karma` int(11) default '0',
 `Manner` int(11) default '0',
 `StatusPoints` int(11) default '0',
 `SkillPoints` int(11) default '0',
 `HairColor` int(11) default '0',
 `HairStyle` int(11) default '0',
 `STR` int(11) default '0',
 `AGI` int(11) default '0',
 `DEX` int(11) default '0',
 `INT_` int(11) default '0',
 `LUK` int(11) default '0',
 `VIT` int(11) default '0',
 `HeadTop` int(11) default '0',
 `HeadMid` int(11) default '0',
 `HeadBtm` int(11) default '0',
 `ClothesColor` int(11) default '0',
 PRIMARY KEY (`CharID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table characters
#

INSERT INTO `characters` VALUES (9,0,10000,'CyRuS',0,0,1,0,1,0,0,0,800,50,50,20,20,0,0,0,0,0,1,9,9,9,1,1,1,0,0,0,0);
INSERT INTO `characters` VALUES (11,1,10000,'CyRuS2',0,0,1,0,1,0,0,0,800,50,50,20,20,0,0,0,0,0,1,9,9,9,1,1,1,0,0,0,0);

#
# Table structure for table serverinfo
#

CREATE TABLE `serverinfo` (
 `id` int(11) NOT NULL auto_increment,
 `ServerType` int(11) default NULL,
 `ServerName` text,
 `ServerPort` int(11) default NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table serverinfo
#

INSERT INTO `serverinfo` VALUES (1,1,'Loki - Main',4500);

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

return ( int )SqlHelper.ExecuteScalar(
  Configuration.DatabaseConnection,
  CommandType.Text,
  @"
  	SELECT COUNT([Text]) FROM dbo.CategoryNames
  	WHERE [Text] = @CatName
  ",
  new SqlParameter( "@CatName", catName )
  ) > 0;

ConfigurationSettings.AppSettings[ "DatabaseConnection" ];

    Dim CharacterName As String
...
    Player.Charname = CharacterName
    Player.STR = Packet.GetValue(26)
    Player.AGI = Packet.GetValue(27)
    Player.VIT = Packet.GetValue(28)
    Player.INT = Packet.GetValue(29)
    Player.DEX = Packet.GetValue(30)
    Player.LUK = Packet.GetValue(31)