habe die suche benutzt nichts darüber gefunden!
joomla user zu pragmamx importieren & exportieren geht das überhaupt? :gruebel:
Hi :)
gehen tut das bestimmt ;)
Nur , ein fertiges Script gibt es dafür noch nicht.
Um sowas zu machen, müsste man sich genauer mit den userdaten in joomla befassen...
hilft mir bitte eine möchte auf Pragmamx umsteigen
hollo läute,
nun haben über 90 läute angeschaut und bin mir definitiv sicher das ich auf pragmamx umsteigen will
aber will halt nicht alleine sondern auch meine ca. 1700 User mitnehmen bitte helft mir bestimmt hätte Andi was gemacht wenn er zeit hätte aber bin mir gaaaanz sicher das es auch andere können vielleicht "DU" :idea:
joomla tabelle
DROP TABLE IF EXISTS `guzeloglan_users`;
CREATE TABLE IF NOT EXISTS `guzeloglan_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=162 ;
--
-- Daten für Tabelle `guzeloglan_users`
--
INSERT DELAYED IGNORE INTO `guzeloglan_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (62, 'Doggdfrtssderan', 'Doggdfrtssderan', 'info@infodachau.de', 'e65adfb8bf48f1dttzuer489dd6bff7fb29e5f', 'Super Administrator', 0, 1, 25, '2007-01-31 14:02:00', '2007-07-17 17:20:50', '', 'editor=tinymce\nexpired=\nexpired_time='),
pragmamx tabelle
DROP TABLE IF EXISTS `mx_users`;
CREATE TABLE IF NOT EXISTS `mx_users` (
`uid` int(11) unsigned NOT NULL auto_increment,
`name` varchar(60) collate latin1_german2_ci NOT NULL default '',
`uname` varchar(25) collate latin1_german2_ci NOT NULL default '',
`email` varchar(100) collate latin1_german2_ci NOT NULL default '',
`femail` varchar(100) collate latin1_german2_ci NOT NULL default '',
`url` varchar(255) collate latin1_german2_ci NOT NULL default '',
`user_avatar` varchar(255) collate latin1_german2_ci NOT NULL default '',
`user_regdate` varchar(20) collate latin1_german2_ci NOT NULL default '',
`user_icq` varchar(15) collate latin1_german2_ci default NULL,
`user_occ` varchar(100) collate latin1_german2_ci default NULL,
`user_from` varchar(100) collate latin1_german2_ci default NULL,
`user_intrest` varchar(150) collate latin1_german2_ci default NULL,
`user_sig` text collate latin1_german2_ci NOT NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) collate latin1_german2_ci default NULL,
`user_yim` varchar(25) collate latin1_german2_ci default NULL,
`user_msnm` varchar(25) collate latin1_german2_ci default NULL,
`pass` varchar(40) collate latin1_german2_ci NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) collate latin1_german2_ci NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext collate latin1_german2_ci NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` text collate latin1_german2_ci NOT NULL,
`theme` varchar(100) collate latin1_german2_ci NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '0',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`user_ingroup` int(10) NOT NULL default '1',
`user_lastvisit` int(11) NOT NULL default '0',
`user_regtime` int(11) unsigned NOT NULL default '0',
`user_lastip` varchar(60) collate latin1_german2_ci NOT NULL default '',
`user_lastmod` varchar(40) collate latin1_german2_ci NOT NULL default '',
`user_lasturl` varchar(255) collate latin1_german2_ci NOT NULL default '',
`user_pm_poptime` smallint(4) unsigned NOT NULL default '0',
`user_stat` tinyint(1) NOT NULL default '0',
`user_bday` date default NULL,
`user_sexus` tinyint(1) unsigned NOT NULL default '0',
`user_guestbook` tinyint(1) unsigned NOT NULL default '1',
`user_pic` varchar(30) collate latin1_german2_ci default NULL,
`views` tinyint(10) NOT NULL default '0',
`user_from1` varchar(100) collate latin1_german2_ci NOT NULL default '',
`user_heigh` char(3) collate latin1_german2_ci NOT NULL default '',
`user_gewicht` char(3) collate latin1_german2_ci NOT NULL default '',
`user_piercing` varchar(25) collate latin1_german2_ci NOT NULL default '',
`user_tatto` varchar(25) collate latin1_german2_ci NOT NULL default '',
`user_sucht` varchar(35) collate latin1_german2_ci NOT NULL default '',
`user_beziehung` varchar(40) collate latin1_german2_ci NOT NULL default '',
`user_haar` varchar(30) collate latin1_german2_ci NOT NULL default '',
`user_augen` varchar(30) collate latin1_german2_ci NOT NULL default '',
`user_l1` varchar(150) collate latin1_german2_ci default NULL,
`user_l2` varchar(150) collate latin1_german2_ci default NULL,
`user_l3` varchar(150) collate latin1_german2_ci default NULL,
`user_l4` varchar(150) collate latin1_german2_ci default NULL,
`user_l5` varchar(150) collate latin1_german2_ci default NULL,
`user_l6` varchar(150) collate latin1_german2_ci default NULL,
`user_l7` varchar(150) collate latin1_german2_ci default NULL,
`user_l8` varchar(150) collate latin1_german2_ci default NULL,
`user_positiv` varchar(250) collate latin1_german2_ci default NULL,
`user_negativ` varchar(250) collate latin1_german2_ci default NULL,
`user_smoke` varchar(40) collate latin1_german2_ci default NULL,
`user_alkohol` varchar(40) collate latin1_german2_ci default NULL,
`user_partneralter1` char(2) collate latin1_german2_ci default NULL,
`user_partneralter2` char(2) collate latin1_german2_ci default NULL,
`user_partnerwie` varchar(255) collate latin1_german2_ci default NULL,
`user_famstatus` varchar(25) collate latin1_german2_ci default NULL,
`user_partnerfigur` varchar(100) collate latin1_german2_ci default NULL,
`user_kinder` varchar(100) collate latin1_german2_ci default NULL,
`user_click` bigint(20) NOT NULL default '0',
`user_pm_mail` int(1) NOT NULL default '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `uname` (`uname`),
KEY `user_ingroup` (`user_ingroup`),
KEY `user_stat` (`user_stat`),
KEY `user_lastvisit` (`user_lastvisit`),
KEY `user_lastmod` (`user_lastmod`),
KEY `user_bday` (`user_bday`),
KEY `email` (`email`),
KEY `pass` (`pass`),
KEY `user_sexus` (`user_sexus`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=5 ;
--
-- Daten für Tabelle `mx_users`
--
INSERT DELAYED IGNORE INTO `mx_users` (`uid`, `name`, `uname`, `email`, `femail`, `url`, `user_avatar`, `user_regdate`, `user_icq`, `user_occ`, `user_from`, `user_intrest`, `user_sig`, `user_viewemail`, `user_theme`, `user_aim`, `user_yim`, `user_msnm`, `pass`, `storynum`, `umode`, `uorder`, `thold`, `noscore`, `bio`, `ublockon`, `ublock`, `theme`, `commentmax`, `counter`, `newsletter`, `user_posts`, `user_attachsig`, `user_rank`, `user_level`, `user_ingroup`, `user_lastvisit`, `user_regtime`, `user_lastip`, `user_lastmod`, `user_lasturl`, `user_pm_poptime`, `user_stat`, `user_bday`, `user_sexus`, `user_guestbook`, `user_pic`, `views`, `user_from1`, `user_heigh`, `user_gewicht`, `user_piercing`, `user_tatto`, `user_sucht`, `user_beziehung`, `user_haar`, `user_augen`, `user_l1`, `user_l2`, `user_l3`, `user_l4`, `user_l5`, `user_l6`, `user_l7`, `user_l8`, `user_positiv`, `user_negativ`, `user_smoke`, `user_alkohol`, `user_partneralter1`, `user_partneralter2`, `user_partnerwie`, `user_famstatus`, `user_partnerfigur`, `user_kinder`, `user_click`, `user_pm_mail`) VALUES (1, '', 'Anonymous', '', '', '', '', 'Aug 10, 2003', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 4, 0, 0, 0, 0, 1, 0, 0, 973810800, '', '', '', 0, -1, '1970-01-01', 0, 1, NULL, 0, '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0),
(2, 'dogan', 'dogan', 'info@infxx.de', '', 'http://www.xxxxxxx.de', 'dogan.avatar.2.gif', 'Jun 23, 2007', 'Ihr ICQ:', 'dfhg', 'fdh', 'dfh', 'dfh', NULL, NULL, 'Ihr AIM:', 'Ihr YIM:', 'Ihr MSNM:', 'e65adfb8bf48f1d489dd6bff7fb29e5f', 10, '', 0, 0, 0, 'dfh', 1, '', '', 4096, 0, 1, 0, 0, 0, 1, 1, 1183288707, 1182600854, '84.155.82.234', 'Top', '/modules.php?name=Top', 0, 1, '1973-05-11', 2, 1, NULL, 0, 'Deutschland', '456', '456', '_YA_KA', '_YA_NEIN', '_YA_FRAU', '_YA_BZ2', 'fdh', 'fdh', 'dfh', 'gdfh', 'dfh', 'dfh', 'dfh', 'dfh', 'dfh', 'dgh', 'dfh', 'dfh', '_YA_KA', '_YA_OFT', '30', '40', 'dfh', '_YA_FAMSTAT1', '_YA_F2', '_YA_KIND2', 0, 0),
nun die frage an experten geht das überhaupt?????