Visit:http://www.marcellobrandao.eti.br/
CREATE TABLE `yogurt_friendpetition` (
`friendpet_id` int(11) NOT NULL auto_increment,
`petitioner_uid` int(11) NOT NULL,
`petioned_uid` int(11) NOT NULL,
PRIMARY KEY (`friendpet_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_friendship` (
`friendship_id` int(11) NOT NULL auto_increment,
`friend1_uid` int(11) NOT NULL,
`friend2_uid` int(11) NOT NULL,
`level` int(11) NOT NULL,
`hot` tinyint(4) NOT NULL,
`trust` tinyint(4) NOT NULL,
`cool` tinyint(4) NOT NULL,
`fan` tinyint(4) NOT NULL,
PRIMARY KEY (`friendship_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_images` (
`cod_img` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`data_creation` date NOT NULL,
`data_update` date NOT NULL,
`uid_owner` varchar(50) NOT NULL,
`url` text NOT NULL,
`private` varchar(1) NOT NULL,
PRIMARY KEY (`cod_img`)
) TYPE=MyISAM ;
CREATE TABLE `yogurt_visitors` (
`cod_visit` int(11) NOT NULL auto_increment,
`uid_owner` int(11) NOT NULL,
`uid_visitor` int(11) NOT NULL,
`uname_visitor` varchar(30) NOT NULL,
`datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`cod_visit`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_seutubo` (
`video_id` int(11) NOT NULL auto_increment,
`uid_owner` int(11) NOT NULL,
`video_desc` text NOT NULL,
`youtube_code` varchar(11) NOT NULL,
`main_video` varchar(1) NOT NULL,
PRIMARY KEY (`video_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_reltribeuser` (
`rel_id` int(11) NOT NULL auto_increment,
`rel_tribe_id` int(11) NOT NULL,
`rel_user_uid` int(11) NOT NULL,
PRIMARY KEY (`rel_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_tribes` (
`tribe_id` int(11) NOT NULL auto_increment,
`owner_uid` int(11) NOT NULL,
`tribe_title` varchar(255) NOT NULL,
`tribe_desc` tinytext NOT NULL,
`tribe_img` varchar(255) NOT NULL,
PRIMARY KEY (`tribe_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_scraps` (
`scrap_id` int(11) NOT NULL auto_increment,
`scrap_text` text NOT NULL,
`scrap_from` int(11) NOT NULL,
`scrap_to` int(11) NOT NULL,
`private` tinyint(1) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`scrap_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_configs` (
`config_id` int(11) NOT NULL auto_increment,
`config_uid` int(11) NOT NULL,
`pictures` tinyint(1) NOT NULL,
`videos` tinyint(1) NOT NULL,
`tribes` tinyint(1) NOT NULL,
`scraps` tinyint(1) NOT NULL,
`friends` tinyint(1) NOT NULL,
`profile_contact` tinyint(1) NOT NULL,
`profile_general` tinyint(1) NOT NULL,
`profile_stats` tinyint(1) NOT NULL,
`suspension` tinyint(1) NOT NULL,
`backup_password` varchar(255) NOT NULL,
`backup_email` varchar(255) NOT NULL,
`end_suspension` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`config_id`),
KEY `config_uid` (`config_uid`)
) TYPE=MyISAM ;
CREATE TABLE `yogurt_suspensions` (
`uid` int(11) NOT NULL,
`old_pass` varchar(32) NOT NULL,
`old_email` varchar(60) NOT NULL,
`old_signature` text NOT NULL,
`suspension_time` int(11) NOT NULL,
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
by tom on 2007/11/16 13:57:04
Could you not just make this field dynamic and allow the admin/webmaster to choose it themselves?
(I know it would be easy enough for them to edit the lang file)
by mjoel on 2007/11/16 16:06:55
nice thanks for the updates suico...
-- any expected date of release ?
-- is search member feature will be included in this version ?
-- how do the upgrade from yogurt (user's photos) to yogurt social networks works ?
--my2cents: the tabs feature will be much more nicer if ajax tab is usedhttp://www.dynamicdrive.com/dynamicindex17/ajaxtabscontent/
by shalommemphi on 2007/11/19 22:13:07
I might have missed this in regards to TRIBES - Which I simply call COMMUNITIES .
Will the administrator be able to limit tribe creations? Such as not allow users but create a specific number of TRIBES?
In my case it would be a tribie (COMMUNITY) for each state in the U.S. to help my diversified membership locate others in the same state.
by sarahmx on 2007/11/22 7:56:39
it would be cool if xoopstube can be integrate with yogurt (video section)
as example user select video from xoopstube module to be featured in the profile
No problem suico, take your time. I look forward to this feature in future.
As promise, I'm sending back simplified chinese (utf8 encoding) language pack to you. Most of translations are done except for one of admin page, i will finish it when i have time these days.
-Daniel
$button_tray = new XoopsFormElementTray('' ,'');
$submit_btn = new XoopsFormButton('', 'post', _MD_XTL_POST, 'submit');
$submit_btn->setExtra('accesskey="s"');
$button_tray->addElement($submit_btn);
$cancel_btn = new XoopsFormButton('', 'cancel', _MD_XTL_CANCEL, 'reset');
$cancel_btn->setExtra('accesskey="c"');
$button_tray->addElement($cancel_btn);
$sform->addElement($button_tray);
//$form->assign($xoopsTpl);//If your server is php 5 uncomment this line
$form->display(); //If your server is php 4.4 uncomment this line