• 02-01-2011, 17:32:08
    #1
    Mister estate ve Ea improved bileşenleri var ben mister estatedeki verileri ea improvede sokmak istiyorum... fakat sanırım biraz sql bilgisi gerektiriyor çözemedim bunu
    ea improved yapısı:
    CREATE TABLE IF NOT EXISTS `jos_estateagent` (
      `id` int(10) NOT NULL auto_increment,
      `obj_id` varchar(25) NOT NULL default '',
      `cat` int(10) NOT NULL default '0',
      `type` tinyint(2) NOT NULL default '0',
      `title` varchar(255) NOT NULL default '',
      `alias` varchar(255) NOT NULL default '',
      `description` text NOT NULL,
      `location` text NOT NULL,
      `condition` text NOT NULL,
      `other` text NOT NULL,
      `rooms` smallint(4) NOT NULL default '0',
      `bedrooms` smallint(4) NOT NULL default '0',
      `wc` smallint(4) NOT NULL default '0',
      `space` decimal(10,2) NOT NULL default '0.00',
      `homes` smallint(5) NOT NULL default '0',
      `homes_size` decimal(10,2) NOT NULL default '0.00',
      `pp_size` decimal(10,2) NOT NULL default '0.00',
      `trade_units` smallint(5) NOT NULL default '0',
      `trade_size` decimal(10,2) NOT NULL default '0.00',
      `position` varchar(50) NOT NULL default '',
      `lift` tinyint(1) NOT NULL default '0',
      `handicap` tinyint(1) NOT NULL default '0',
      `yobuilt` varchar(10) NOT NULL default '',
      `toheat` tinytext NOT NULL,
      `toheat_ufloor` tinyint(1) NOT NULL default '0',
      `fireside` tinyint(1) NOT NULL default '0',
      `aircondition` tinyint(1) NOT NULL default '0',
      `tv` tinyint(1) NOT NULL default '0',
      `dsl` tinyint(1) NOT NULL default '0',
      `swpool` tinyint(1) NOT NULL default '0',
      `balcony` tinyint(1) NOT NULL default '0',
      `terrace` tinyint(1) NOT NULL default '0',
      `garden` tinyint(1) NOT NULL default '0',
      `parkarea` tinyint(1) NOT NULL default '0',
      `garage` tinyint(1) NOT NULL default '0',
      `rent` decimal(10,2) NOT NULL default '0.00',
      `rent_extra` decimal(10,2) NOT NULL default '0.00',
      `price` decimal(20,2) NOT NULL default '0.00',
      `commis` varchar(15) NOT NULL default '',
      `secure` decimal(10,2) NOT NULL default '0.00',
      `receipts` decimal(10,2) NOT NULL default '0.00',
      `street` varchar(255) NOT NULL default '',
      `streetnr` varchar(5) NOT NULL default '',
      `pcode` varchar(10) NOT NULL default '',
      `town` tinytext NOT NULL,
      `district` tinytext NOT NULL,
      `locstate` tinytext NOT NULL,
      `country` tinytext NOT NULL,
      `hits` int(6) NOT NULL default '0',
      `hot` tinyint(1) NOT NULL default '0',
      `sold` tinyint(1) NOT NULL default '0',
      `mapcoords` tinytext NOT NULL,
      `metadesc` varchar(255) NOT NULL default '',
      `metakey` varchar(255) NOT NULL default '',
      `created` datetime NOT NULL,
      `modified` datetime NOT NULL,
      `created_by` int(11) NOT NULL default '0',
      `access` tinyint(3) NOT NULL default '0',
      `publish_up` datetime NOT NULL,
      `publish_down` datetime NOT NULL,
      `published` tinyint(1) NOT NULL default '1',
      `checked_out` tinyint(1) NOT NULL default '0',
      `checked_out_time` time default NULL,
      PRIMARY KEY  (`id`),
      UNIQUE KEY `id` (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    
    --
    -- Tablo döküm verisi `jos_estateagent`
    --
    mister estate:
    CREATE TABLE IF NOT EXISTS `jos_misterestate` (
      `id` int(10) NOT NULL auto_increment,
      `obj_id` varchar(25) NOT NULL default '',
      `cat` tinyint(4) NOT NULL default '0',
      `type` tinyint(2) NOT NULL default '0',
      `title` varchar(255) NOT NULL default '',
      `description` text NOT NULL,
      `location` text NOT NULL,
      `condition` text NOT NULL,
      `other` text NOT NULL,
      `rooms` smallint(4) NOT NULL default '0',
      `bedrooms` smallint(4) NOT NULL default '0',
      `wc` smallint(4) NOT NULL default '0',
      `space` decimal(10,2) NOT NULL default '0.00',
      `homes` smallint(5) NOT NULL default '0',
      `homes_size` decimal(10,2) NOT NULL default '0.00',
      `pp_size` decimal(10,2) NOT NULL default '0.00',
      `trade_units` smallint(5) NOT NULL default '0',
      `trade_size` decimal(10,2) NOT NULL default '0.00',
      `position` varchar(50) NOT NULL default '',
      `lift` tinyint(1) NOT NULL default '0',
      `handicap` tinyint(1) NOT NULL default '0',
      `yobuilt` varchar(10) NOT NULL default '',
      `toheat` tinytext NOT NULL,
      `toheat_ufloor` tinyint(1) NOT NULL default '0',
      `fireside` tinyint(1) NOT NULL default '0',
      `aircondition` tinyint(1) NOT NULL default '0',
      `tv` tinyint(1) NOT NULL default '0',
      `dsl` tinyint(1) NOT NULL default '0',
      `swpool` tinyint(1) NOT NULL default '0',
      `balcony` tinyint(1) NOT NULL default '0',
      `terrace` tinyint(1) NOT NULL default '0',
      `garden` tinyint(1) NOT NULL default '0',
      `parkarea` tinyint(1) NOT NULL default '0',
      `garage` tinyint(1) NOT NULL default '0',
      `rent` decimal(10,2) NOT NULL default '0.00',
      `rent_extra` decimal(10,2) NOT NULL default '0.00',
      `price` decimal(10,2) NOT NULL default '0.00',
      `commis` varchar(15) NOT NULL default '',
      `secure` decimal(10,2) NOT NULL default '0.00',
      `receipts` decimal(10,2) NOT NULL default '0.00',
      `street` varchar(255) NOT NULL default '',
      `streetnr` varchar(5) NOT NULL default '',
      `pcode` varchar(10) NOT NULL default '',
      `town` tinytext NOT NULL,
      `district` tinytext NOT NULL,
      `state` tinytext NOT NULL,
      `country` tinytext NOT NULL,
      `hits` int(6) NOT NULL default '0',
      `hot` tinyint(1) NOT NULL default '0',
      `metadesc` varchar(255) NOT NULL default '',
      `metakey` varchar(255) NOT NULL default '',
      `created` date NOT NULL default '0000-00-00',
      `created_by` int(11) NOT NULL default '0',
      `access` tinyint(3) NOT NULL default '0',
      `verified` tinyint(1) NOT NULL default '-1',
      `publish_up` date NOT NULL default '0000-00-00',
      `publish_down` date NOT NULL default '0000-00-00',
      `publish` tinyint(1) NOT NULL default '1',
      PRIMARY KEY  (`id`),
      UNIQUE KEY `id` (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=385 ;
    bu yapılabilr mi ?
  • 02-01-2011, 18:19:13
    #2
    hım sadece verileri ceksen de direk okutmayı denesen olmuyormu misal a veri tabanınının içinden al verileri b veritabanının içine yukleme yapsan?
  • 05-01-2011, 02:06:35
    #3
    ücretli olarak yapabilirm. karasairim@gmail.com msn adresim bu.