arkadaslar bi site yaptım. icinde uyelik sistemi falan war.simdi merak ettigim su; ben bu portala SMF entegre etmek istiyorum.SMF nin admin panelinden uye olma işlemini kapattım.artık sadece benim yazdıgım scriptten uye olabilecekler.sorunum ise su; SMF kendi uye olma script inde sadece tek bir tabloyamı veri girisi yapıyor yoksa baska tablolarada veri girisi yapıyormu?SMF asagıdaki tabloda uyenin bilgilerini tutuyor sanırım?
CREATE TABLE `smf_members` (
`ID_MEMBER` mediumint(8) unsigned NOT NULL auto_increment,
`memberName` varchar(80) NOT NULL default '',
`dateRegistered` int(10) unsigned NOT NULL default '0',
`posts` mediumint(8) unsigned NOT NULL default '0',
`ID_GROUP` smallint(5) unsigned NOT NULL default '0',
`lngfile` tinytext NOT NULL,
`lastLogin` int(11) NOT NULL default '0',
`realName` tinytext NOT NULL,
`instantMessages` smallint(5) NOT NULL default '0',
`unreadMessages` smallint(5) NOT NULL default '0',
`im_ignore_list` tinytext NOT NULL,
`passwd` varchar(64) NOT NULL default '',
`emailAddress` tinytext NOT NULL,
`personalText` tinytext NOT NULL,
`gender` tinyint(4) unsigned NOT NULL default '0',
`birthdate` date NOT NULL default '0000-00-00',
`websiteTitle` tinytext NOT NULL,
`websiteUrl` tinytext NOT NULL,
`location` tinytext NOT NULL,
`ICQ` tinytext NOT NULL,
`AIM` varchar(16) NOT NULL default '',
`YIM` varchar(32) NOT NULL default '',
`MSN` tinytext NOT NULL,
`hideEmail` tinyint(4) NOT NULL default '0',
`showOnline` tinyint(4) NOT NULL default '1',
`timeFormat` varchar(80) NOT NULL default '',
`signature` text,
`timeOffset` float NOT NULL default '0',
`avatar` tinytext NOT NULL,
`im_email_notify` tinyint(4) NOT NULL default '0',
`karmaBad` smallint(5) unsigned NOT NULL default '0',
`karmaGood` smallint(5) unsigned NOT NULL default '0',
`usertitle` tinytext NOT NULL,
`notifyAnnouncements` tinyint(4) NOT NULL default '1',
`notifyOnce` tinyint(4) NOT NULL default '1',
`memberIP` tinytext NOT NULL,
`secretQuestion` tinytext NOT NULL,
`secretAnswer` tinytext NOT NULL,
`ID_THEME` tinyint(4) unsigned NOT NULL default '0',
`is_activated` tinyint(3) unsigned NOT NULL default '1',
`validation_code` varchar(10) NOT NULL default '',
`ID_MSG_LAST_VISIT` int(10) unsigned NOT NULL default '0',
`additionalGroups` tinytext NOT NULL,
`smileySet` varchar(48) NOT NULL default '',
`ID_POST_GROUP` smallint(5) unsigned NOT NULL default '0',
`totalTimeLoggedIn` int(10) unsigned NOT NULL default '0',
`passwordSalt` varchar(5) NOT NULL default '',
PRIMARY KEY (`ID_MEMBER`),
KEY `memberName` (`memberName`(30)),
KEY `dateRegistered` (`dateRegistered`),
KEY `ID_GROUP` (`ID_GROUP`),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `lastLogin` (`lastLogin`),
KEY `lngfile` (`lngfile`(30)),
KEY `ID_POST_GROUP` (`ID_POST_GROUP`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
eger baska tabloayada uye olurken veri girisi yaptırıyorsa, benim yazdıgım scriptte sadece bu tabloya veri girisi yapmam, sorun getirebilir.