[Smertnik]

Hello i from Russian.
I create table to SQL inquiry.

############################################# #####################################
# Start: Create the databases
CREATE DATABASE IF NOT EXISTS SHeroDB;
USE SHeroDB;

#----------------------------------------------------
# Start: Create the tables
#----------------------------------------------------

CREATE TABLE IF NOT EXISTS `sh_saveskills` (
`SH_KEY` varchar(34) binary NOT NULL default '',
`SKILL_NUMBER` int(10) unsigned NOT NULL default '0',
`HERO_NAME` varchar(25) NOT NULL default '',
PRIMARY KEY (`SH_KEY`,`SKILL_NUMBER`)
) TYPE=MyISAM COMMENT='SUPERHERO Skill Saving Table';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON sh_saveskills TO SuperHeroModUser@localhost;

CREATE TABLE IF NOT EXISTS `sh_savexp` (
`SH_KEY` varchar(34) binary NOT NULL default '',
`PLAYER_NAME` varchar(32) binary NOT NULL default '',
`LAST_PLAY_DATE` timestamp(14) NOT NULL,
`XP` int(10) unsigned NOT NULL default '0',
`HUDHELP` tinyint(1) unsigned NOT NULL default '1',
`SKILL_COUNT` int(3) unsigned NOT NULL default '0',
PRIMARY KEY (`SH_KEY`)
) TYPE=MyISAM COMMENT='SUPERHERO XP Saving Table';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON sh_savexp TO SuperHeroModUser@localhost;

FLUSH PRIVILEGES;

#----------------------------------------------------
# Stop
#----------------------------------------------------
############################################# #####################################

XP saved to IP address!
How do you saved XP to name?

amxx 0.20/i use to LAN

Thank you.

Smertnik.

Excuse me i not speak English.