-Keep adding to that table
-Make a new table and pull information from both tables everytime
-it doesnt matter
Thanks
Moderator: General Moderators
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
[syntax="sql"]CREATE TABLE `rpg_players` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`name` text NOT NULL,
`race_id` int(11) NOT NULL default '0',
`map_id` int(11) NOT NULL default '1',
`battle_id` mediumint(9) NOT NULL default '0',
`health` int(11) NOT NULL default '100',
`maxhp` int(11) NOT NULL default '100',
`status` text NOT NULL,
`city_id` int(11) NOT NULL default '1',
`city_screen` tinyint(4) NOT NULL default '1',
`cemetery` mediumint(9) NOT NULL default '1',
`inquest` tinyint(4) NOT NULL default '-1',
`partymembers` varchar(12) NOT NULL,
`mode` int(11) NOT NULL default '-1',
`ischat` tinyint(1) NOT NULL default '0',
`strength` int(11) NOT NULL default '5',
`defense` int(11) NOT NULL default '5',
`agility` int(11) NOT NULL default '30',
`tokens` int(11) NOT NULL default '100',
`maxtokens` int(11) NOT NULL default '500',
`money` int(11) NOT NULL default '100000',
`sherif` mediumint(9) NOT NULL default '0',
`wins` int(11) NOT NULL default '0',
`losses` int(11) NOT NULL default '0',
`battleswon` int(11) NOT NULL,
`battleslost` int(11) NOT NULL,
`battlesescaped` int(11) NOT NULL,
`monsterskilled` int(11) NOT NULL,
`distancewalked` int(11) NOT NULL,
`posx` int(11) NOT NULL default '0',
`posy` int(11) NOT NULL default '0',
`area` varchar(15) NOT NULL,
`area_id` int(11) NOT NULL,
`lastarea` varchar(15) NOT NULL,
`experience` int(11) NOT NULL,
`ap` smallint(6) NOT NULL,
`skills` text NOT NULL,
`weapons` varchar(255) NOT NULL,
`quests` text NOT NULL,
`keyitems` text NOT NULL,
`mugging` int(11) NOT NULL default '5',
`aiming` int(11) NOT NULL default '5',
`throwing` int(11) NOT NULL default '5',
`luck` int(11) NOT NULL default '5',
`balance` int(11) NOT NULL default '5',
`dropping` int(11) NOT NULL default '5',
`roping` int(11) NOT NULL default '5',
`spying` tinyint(4) NOT NULL default '5',
`awareness` tinyint(4) NOT NULL default '5',
`chests` text NOT NULL,
`hidenseek` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
)
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]