Database php codes

[Lbtg]

Hello i wery need help with add to phpMyAdmin me database

need php codes

Bans
tile_items
house_Lists

please help with it

 

[Lbtg]

sorry for double post but i need bump itt , please help me ! =(

 

[VirrageS]

Bans:

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
  `param` int(10) unsigned NOT NULL default '4294967295' COMMENT 'used only for ip banishment mask (integer)',
  `active` tinyint(1) NOT NULL default '1',
  `expires` int(11) NOT NULL,
  `added` int(10) unsigned NOT NULL,
  `admin_id` int(10) unsigned NOT NULL default '0',
  `comment` text NOT NULL,
  `reason` int(10) unsigned NOT NULL default '0',
  `action` int(10) unsigned NOT NULL default '0',
  `statement` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`value`),
  KEY `active` (`active`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

Tile_items:

CREATE TABLE IF NOT EXISTS `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
  KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

House_lists:

CREATE TABLE IF NOT EXISTS `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `listid` int(11) NOT NULL,
  `list` text NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Rep++

 

[Lbtg]

omg thats nice , but then i make this i dont get it on me database =((( whats wrongs please help me ? if you can contact me on msn [email protected]

 

[Lbtg]

please help with it......

 

[VirrageS]

Explain more what are doing when you add this tables.

 

[WibbenZ]

Bans:

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
  `param` int(10) unsigned NOT NULL default '4294967295' COMMENT 'used only for ip banishment mask (integer)',
  `active` tinyint(1) NOT NULL default '1',
  `expires` int(11) NOT NULL,
  `added` int(10) unsigned NOT NULL,
  `admin_id` int(10) unsigned NOT NULL default '0',
  `comment` text NOT NULL,
  `reason` int(10) unsigned NOT NULL default '0',
  `action` int(10) unsigned NOT NULL default '0',
  `statement` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`value`),
  KEY `active` (`active`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

Tile_items:

CREATE TABLE IF NOT EXISTS `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
  KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

House_lists:

CREATE TABLE IF NOT EXISTS `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `listid` int(11) NOT NULL,
  `list` text NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Rep++

use all in 1 script insted.

CREATE TABLE IF NOT EXISTS `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `listid` int(11) NOT NULL,
  `list` text NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
}
CREATE TABLE IF NOT EXISTS `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
  KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
}
CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
  `param` int(10) unsigned NOT NULL default '4294967295' COMMENT 'used only for ip banishment mask (integer)',
  `active` tinyint(1) NOT NULL default '1',
  `expires` int(11) NOT NULL,
  `added` int(10) unsigned NOT NULL,
  `admin_id` int(10) unsigned NOT NULL default '0',
  `comment` text NOT NULL,
  `reason` int(10) unsigned NOT NULL default '0',
  `action` int(10) unsigned NOT NULL default '0',
  `statement` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`value`),
  KEY `active` (`active`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
}

 

[Lbtg]

then i add this tables on sql its shows , added but i can't see it and they not exists. whats wrong ? please help

 

[WibbenZ]

have you installed sqlite.sql? or mysql.sql? Btw you mysql insted alot easier.

 

[Lbtg]

mysql me serverwas online and i poot safedp.php script , then i get this "root"@"%" - account has not been deleted.!
"pma"@"localhost" - account has been deleted.!
"pma"@"%" - account has not been deleted.!
"root"@"localhost" - User Password has been changed for "**********".!

and me website was dont work i was dont understand whats wrong so i make inport on me old databse mysql and some tables lost . after that i remember that need chnage password on config.lue and website works . so now i need add that tables.

Sorry for me realy bad english i hope you understand what i write

 

[Lbtg]

again sorry for double post . HELP ME PLEASE

 

[Lbtg]

OMG help me =(

 

[Lbtg]

Bump. Help with it please...

 

[VirrageS]

You should import "YOUROTS/data/schemas/mysql.txt"
to your database

 

[Lbtg]

its imported....