xoops forums

trabis

Core Developer
Posted on: 2007/12/4 1:33
trabis
trabis (Show more)
Core Developer
Posts: 2268
Since: 2006/9/1 1
#131

Re: Yogurt Social Network Service

I suico,
Your site is down, it has been all day. Anyway, I already have your module for long time and have been learning a lot studing your code. It´s very nice work, outside and inside. Many thanks and congratulations!

Ps: Arent´t you brazilian? Did not find a portuguese translation in it, weird....

suico

Friend of XOOPS
Posted on: 2007/12/4 11:22
suico
suico (Show more)
Friend of XOOPS
Posts: 374
Since: 2003/7/24
#132

Re: Yogurt Social Network Service

Thanks trabis, the site is back now , though the download is available in sourceforge.net if needed too.

The portuguese translation haven t been done yet , I am such a lazy guy :P Hope someone else will be able to do it for me .
Yogurt Social Network Service
Visit: http://www.marcellobrandao.eti.br/

elbeer

Just popping in
Posted on: 2007/12/8 15:51
elbeer
elbeer (Show more)
Just popping in
Posts: 68
Since: 2007/8/26
#133

Re: "Orkut like" module [Orkut, LinkedIn, Friendster, Zaibatsu, Tribe.net, multiply, etc ]

got a problem with MySQL version


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP, PRIMARY KEY (`tribe_id`) ) ENGINE=MyISAM'

i am using MySQL Version 4.0.25-standard

suico

Friend of XOOPS
Posted on: 2007/12/10 1:19
suico
suico (Show more)
Friend of XOOPS
Posts: 374
Since: 2003/7/24
#134

Re: "Orkut like" module [Orkut, LinkedIn, Friendster, Zaibatsu, Tribe.net, multiply, etc ]

please try replacing the sql/mysql.sql file content with:

CREATE TABLE `yogurt_friendpetition` (
  `
friendpet_idint(11NOT NULL auto_increment,
  `
petitioner_uidint(11NOT NULL,
  `
petioned_uidint(11NOT NULL,
  
PRIMARY KEY  (`friendpet_id`)
TYPE=MyISAM;


CREATE TABLE `yogurt_friendship` (
  `
friendship_idint(11NOT NULL auto_increment,
  `
friend1_uidint(11NOT NULL,
  `
friend2_uidint(11NOT NULL,
  `
levelint(11NOT NULL,
  `
hottinyint(4NOT NULL,
  `
trusttinyint(4NOT NULL,
  `
cooltinyint(4NOT NULL,
  `
fantinyint(4NOT NULL,
  
PRIMARY KEY  (`friendship_id`)
TYPE=MyISAM;

CREATE TABLE `yogurt_images` (
  `
cod_imgint(11NOT NULL auto_increment,
  `
titlevarchar(255NOT NULL,
  `
data_creationdate NOT NULL,
  `
data_updatedate NOT NULL,
  `
uid_ownervarchar(50NOT NULL,
  `
urltext NOT NULL,
  `
privatevarchar(1NOT NULL,
  
PRIMARY KEY  (`cod_img`)
TYPE=MyISAM  ;

CREATE TABLE `yogurt_visitors` (
  `
cod_visitint(11NOT NULL auto_increment,
  `
uid_ownerint(11NOT NULL,
  `
uid_visitorint(11NOT NULL,
  `
uname_visitorvarchar(30NOT NULL,
`
datetimetimestamp NOT NULL default CURRENT_TIMESTAMP,
  
PRIMARY KEY  (`cod_visit`)
TYPE=MyISAM;

CREATE TABLE `yogurt_seutubo` (
  `
video_idint(11NOT NULL auto_increment,
  `
uid_ownerint(11NOT NULL,
  `
video_desctext NOT NULL,
  `
youtube_codevarchar(11NOT NULL,
  `
main_videovarchar(1NOT NULL,
  
PRIMARY KEY  (`video_id`)
TYPE=MyISAM;


CREATE TABLE `yogurt_reltribeuser` (
  `
rel_idint(11NOT NULL auto_increment,
  `
rel_tribe_idint(11NOT NULL,
  `
rel_user_uidint(11NOT NULL,
  
PRIMARY KEY  (`rel_id`)
TYPE=MyISAM;


CREATE TABLE `yogurt_tribes` (
  `
tribe_idint(11NOT NULL auto_increment,
  `
owner_uidint(11NOT NULL,
  `
tribe_titlevarchar(255NOT NULL,
  `
tribe_desctinytext NOT NULL,
  `
tribe_imgvarchar(255NOT NULL,

  
PRIMARY KEY  (`tribe_id`)
TYPE=MyISAM;

CREATE TABLE `yogurt_scraps` (
  `
scrap_idint(11NOT NULL auto_increment,
  `
scrap_texttext NOT NULL,
  `
scrap_fromint(11NOT NULL,
  `
scrap_toint(11NOT NULL,
  `
privatetinyint(1NOT NULL,
  `
datetimestamp NOT NULL default CURRENT_TIMESTAMP,
  
PRIMARY KEY  (`scrap_id`)
TYPE=MyISAM;

CREATE TABLE `yogurt_configs` (
  `
config_idint(11NOT NULL auto_increment,
  `
config_uidint(11NOT NULL,
  `
picturestinyint(1NOT NULL,
  `
videostinyint(1NOT NULL,
  `
tribestinyint(1NOT NULL,
  `
scrapstinyint(1NOT NULL,
  `
friendstinyint(1NOT NULL,
  `
profile_contacttinyint(1NOT NULL,
  `
profile_generaltinyint(1NOT NULL,
  `
profile_statstinyint(1NOT NULL,
  `
suspensiontinyint(1NOT NULL,
  `
backup_passwordvarchar(255NOT NULL,
  `
backup_emailvarchar(255NOT NULL,
  `
end_suspensiontimestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  
PRIMARY KEY  (`config_id`),
  
KEY `config_uid` (`config_uid`)
TYPE=MyISAM  ;

CREATE TABLE `yogurt_suspensions` (
  `
uidint(11NOT NULL,
  `
old_passvarchar(32NOT NULL,
  `
old_emailvarchar(60NOT NULL,
  `
old_signaturetext NOT NULL,
  `
suspension_timeint(11NOT NULL,
  
PRIMARY KEY  (`uid`)
TYPE=MyISAM;
Yogurt Social Network Service
Visit: http://www.marcellobrandao.eti.br/

antifmradio

Just can't stay away
Posted on: 2007/12/17 3:09
antifmradio
antifmradio (Show more)
Just can't stay away
Posts: 457
Since: 2007/8/15
#135

Re: "Orkut like" module [Orkut, LinkedIn, Friendster, Zaibatsu, Tribe.net, multiply, etc ]

i have a question here

in the documentation before uploading
it says "If you want to make the users page the mainpage apon loading"
edit this:


Open userinfo.php in the root of your site, search at the very beggining of the file for

$uid = intval($_GET['uid']);
if ($uid <= 0) {
redirect_header('index.php', 3, _US_SELECTNG);
exit();
}

Add after this the following line:
header("Location:".XOOPS_URL."/modules/yogurt/index.php?uid=".$uid);



well heres something

This is a module installed into XOOPS so if someone opens the page who is either NOT logged in or NOT registered
would they automatically see whatever page we have made the mainpage for example the NEWS page? (if set by admin)

suico

Friend of XOOPS
Posted on: 2007/12/17 11:47
suico
suico (Show more)
Friend of XOOPS
Posts: 374
Since: 2003/7/24
#136

Re: "Orkut like" module [Orkut, LinkedIn, Friendster, Zaibatsu, Tribe.net, multiply, etc ]

antifmradio the instructions are about the module mainpage not the XOOPS site mainpage. If the user tries to visit the module and he is not logged in he will see the admin s profile.
Yogurt Social Network Service
Visit: http://www.marcellobrandao.eti.br/

antifmradio

Just can't stay away
Posted on: 2007/12/18 4:23
antifmradio
antifmradio (Show more)
Just can't stay away
Posts: 457
Since: 2007/8/15
#137

Re: "Orkut like" module [Orkut, LinkedIn, Friendster, Zaibatsu, Tribe.net, multiply, etc ]

Thank you Suico

next question.

I would obviously like to use the Yogurt USEINFO.php for everyone to see profiles instead of the core XOOPS Userinfo.php

is there a way of doing this?
Im sure i will have to go into whatever file spits out info for the USER MENU and change a link in there as well?

suico

Friend of XOOPS
Posted on: 2007/12/18 17:26
suico
suico (Show more)
Friend of XOOPS
Posts: 374
Since: 2003/7/24
#138

Re: "Orkut like" module [Orkut, LinkedIn, Friendster, Zaibatsu, Tribe.net, multiply, etc ]



Change your userinfo.php file in the root of your site like suggested in install.txt

$uid intval($_GET['uid']);
if (
$uid <= 0) {
redirect_header('index.php'3_US_SELECTNG);
exit();
}

Add after this the following line:
header("Location:".XOOPS_URL."/modules/yogurt/index.php?uid=".$uid);
Yogurt Social Network Service
Visit: http://www.marcellobrandao.eti.br/

antifmradio

Just can't stay away
Posted on: 2007/12/18 17:54
antifmradio
antifmradio (Show more)
Just can't stay away
Posts: 457
Since: 2007/8/15
#139

Re: Yogurt Social Network Service

what i did to change SCRAPS to a different name was to go into the LANGUAGE files > Search all referances to SCRAPS ( text ) and changed them to "Comments"

hope this helps

antifmradio

Just can't stay away
Posted on: 2007/12/18 17:58
antifmradio
antifmradio (Show more)
Just can't stay away
Posts: 457
Since: 2007/8/15
#140

Re: "Orkut like" module [Orkut, LinkedIn, Friendster, Zaibatsu, Tribe.net, multiply, etc ]

i did that
Thanks suico

also

i see on the users main pages ( guess this would be yogurt index.php )

everything is in line straight from TOP to bottom ( all the sections


Tribes



comments



Details



and so on


i wanted to organize these by putting them into tables of percentage sizes.


But i tried to add a table with columns and it didnt work out right


is there a css method or did i just add my tables incorrectly to the page?