Changeset 24

Show
Ignore:
Timestamp:
08/19/05 00:34:27 (7 years ago)
Author:
alexx
Message:
  • add Meta Album feature (to link .node profile with external album on Flickr or interAlbum.com)
  • change method to find BASEPATH (to be more reliable)
  • add Meta Album link to profile page (to be modified later)
  • modify default data for db (old data isn't good with cache)
  • add is_valid function to .... valid things ;)
  • add config param for flickr api_key
  • DB: modify database structure to add metalbum table 
    CREATE TABLE `metalbum` (
`id` varchar(32) NOT NULL default '',
`type` varchar(16) NOT NULL default '',
`login` varchar(64) NOT NULL default '',
`nb_items` int(10) unsigned default NULL,
PRIMARY KEY  (`id`,`type`,`login`)
) TYPE=MyISAM;
Location:
trunk
Files:
13 added
11 modified

Legend:

Unmodified
Added
Removed

  • trunk/dotnode-data.sql

    r14 r24  
    4242INSERT INTO `access` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','user_contact','address','friends_of_friends'); 
    4343INSERT INTO `access` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','user_professional','company','everyone'); 
     44INSERT INTO `access` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','user_general','birthday','everyone'); 
     45INSERT INTO `access` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','user_contact','email','members'); 
     46INSERT INTO `access` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','user_contact','im','friends_of_friends'); 
     47INSERT INTO `access` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','user_contact','phone','friends_of_friends'); 
     48INSERT INTO `access` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','user_contact','cell_phone','friends_of_friends'); 
     49INSERT INTO `access` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','user_contact','address','friends_of_friends'); 
     50INSERT INTO `access` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','user_professional','company','members'); 
     51INSERT INTO `access` VALUES ('28d956398f784ad039d48501c7ff66dd','user_general','birthday','everyone'); 
     52INSERT INTO `access` VALUES ('28d956398f784ad039d48501c7ff66dd','user_contact','email','members'); 
     53INSERT INTO `access` VALUES ('28d956398f784ad039d48501c7ff66dd','user_contact','im','friends_of_friends'); 
     54INSERT INTO `access` VALUES ('28d956398f784ad039d48501c7ff66dd','user_contact','phone','friends_of_friends'); 
     55INSERT INTO `access` VALUES ('28d956398f784ad039d48501c7ff66dd','user_contact','cell_phone','friends_of_friends'); 
     56INSERT INTO `access` VALUES ('28d956398f784ad039d48501c7ff66dd','user_contact','address','friends_of_friends'); 
     57INSERT INTO `access` VALUES ('28d956398f784ad039d48501c7ff66dd','user_professional','company','members'); 
    4458 
    4559-- 
    … …  
    89103-- 
    90104 
    91 INSERT INTO `cache_user` VALUES ('354a778bacabffaff3d3fd74f93ac278','alexx','Alexandre','DATH','','A42536','D000','','France','male',25,'committed','friend,business,partners',1084260676,'y',2,'1353c20315c720ad6c88a498ccc1c1ac,00112233445566778899001122334455',1,'1',0,0,0,0,0.00,0.00,0.00); 
    92 INSERT INTO `cache_user` VALUES ('00112233445566778899001122334455','moderator','Moderator','Moderator','','','','','France','male',25,'','',1084260676,'y',1,'354a778bacabffaff3d3fd74f93ac278',0,'',0,0,0,0,0.00,0.00,0.00); 
    93 INSERT INTO `cache_user` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','mdoe','John','Doe',NULL,'J500','D000',NULL,'France','male',0,'single','business,partners',1122934961,'y',1,'354a778bacabffaff3d3fd74f93ac278',0,'',1,0,1,5,0.00,0.00,0.00); 
     105INSERT INTO `cache_user` VALUES ('354a778bacabffaff3d3fd74f93ac278','alexx','Alexandre','DATH',NULL,'A42536','D000',NULL,'France','male',25,'committed','friend,business,partners',1084260676,'y',3,'1353c20315c720ad6c88a498ccc1c1ac,7fd5694bc166bbcc91c2ff72ad71dfd4,00112233445566778899001122334455',1,'1',0,2,1,1,3.00,2.00,1.00); 
     106INSERT INTO `cache_user` VALUES ('00112233445566778899001122334455','moderator','Moderator','Moderator',NULL,'M3636','M3636',NULL,'France','male',1,'','',1084260676,'y',1,'354a778bacabffaff3d3fd74f93ac278',0,'',0,0,0,0,0.00,0.00,0.00); 
     107INSERT INTO `cache_user` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','mdoe','John','Doe',NULL,'J500','D000',NULL,'France','male',0,'single','business,partners',1122934961,'y',1,'354a778bacabffaff3d3fd74f93ac278',0,'',1,0,0,5,3.00,0.00,0.00); 
     108INSERT INTO `cache_user` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','test','Test','toto',NULL,'T230','T000',NULL,'France','male',0,'single',NULL,1123530303,'n',2,'354a778bacabffaff3d3fd74f93ac278,28d956398f784ad039d48501c7ff66dd',0,'',0,0,0,0,0.00,0.00,0.00); 
     109INSERT INTO `cache_user` VALUES ('28d956398f784ad039d48501c7ff66dd','zetrezre','testes','tesezezfez',NULL,'T232','T212',NULL,'France','male',0,NULL,NULL,1123530566,'n',1,'7fd5694bc166bbcc91c2ff72ad71dfd4',0,'',0,0,0,0,0.00,0.00,0.00); 
    94110 
    95111-- 
    … …  
    137153 
    138154INSERT INTO `community_event` VALUES (1,1,'354a778bacabffaff3d3fd74f93ac278','Alexandre','First event',1122984000,'dev.dotnode.net','Internet','France','Lancement de l\'ouverture du code de .node !\r\nHoura ! ;)',1122844267); 
     155INSERT INTO `community_event` VALUES (2,1,'354a778bacabffaff3d3fd74f93ac278','Alexandre','testesets',1124566680,'estsetse','testsetse','Antigua & Barbuda','test et zrez ',1123616309); 
    139156 
    140157-- 
    … …  
    155172 
    156173INSERT INTO `community_post` VALUES (1,1,1,'354a778bacabffaff3d3fd74f93ac278','Alexandre','First topic','For test only',1122844117); 
    157 INSERT INTO `community_post` VALUES (2,1,1,'354a778bacabffaff3d3fd74f93ac278','Alexandre',NULL,'A simple response to the test topic',1122844134); 
     174INSERT INTO `community_post` VALUES (2,1,1,'354a778bacabffaff3d3fd74f93ac278','Alexandre',NULL,'A ===simple=== response to the test //topic//\n[Modified on 10.08.2005 20:55]',1122844134); 
    158175 
    159176-- 
    … …  
    187204-- 
    188205 
    189 INSERT INTO `global_data` VALUES ('nb_nodians','3'); 
     206INSERT INTO `global_data` VALUES ('nb_nodians','5'); 
    190207INSERT INTO `global_data` VALUES ('actually','1'); 
    191208 
    … …  
    200217 
    201218INSERT INTO `invitation_email` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','354a778bacabffaff3d3fd74f93ac278','Test','Debug','test-debug@dotnode.com','fr_FR','man','done','accepted',1122928681,0,NULL,'82.225.136.176'); 
     219INSERT INTO `invitation_email` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','354a778bacabffaff3d3fd74f93ac278','Test','toto','test-arezarez@ikse.org','en_US','man','done','accepted',1123529926,0,NULL,'82.225.136.176'); 
     220INSERT INTO `invitation_email` VALUES ('28d956398f784ad039d48501c7ff66dd','7fd5694bc166bbcc91c2ff72ad71dfd4','testes','tesezezfez','test-tsetez@ikse.org','es_ES','man','done','accepted',1123530490,0,NULL,'82.225.136.176'); 
     221INSERT INTO `invitation_email` VALUES ('6721d31e857f92630c8dab94464525cb','354a778bacabffaff3d3fd74f93ac278','test','testsetsetes','tsets@ikse.org','fr_FR','man','doing',NULL,1124270971,0,NULL,'82.225.136.176'); 
    202222 
    203223-- 
    … …  
    205225-- 
    206226 
     227INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',37,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rezrezrez','rzerezrez','inbox','read',1123792949); 
     228INSERT INTO `message` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4',2,'28d956398f784ad039d48501c7ff66dd','testes','friend_invitation_accepted','one','testes has accepted your invitation','Thanks','inbox','new',1123530566); 
     229INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',39,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rezrezrzerzer','zrezrze zer ezr','inbox','new',1123792954); 
     230INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',41,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' ez rezr ez rez','ez rez rezrez rez','inbox','new',1123792960); 
     231INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',43,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' rez r','ezr ezrezr zerezrez rze','inbox','new',1123792965); 
     232INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',45,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' ez rezr ezrezr ezr','ezrez rezrez rez rez rez','inbox','new',1123792970); 
     233INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',47,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','r ezr ezrezr ezrez','rez rezr zerez rez','inbox','new',1123792975); 
     234INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',49,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' rez rzerezrezezr ezr ezr','r ez rezr ezr ezrezrez ','inbox','new',1123792981); 
     235INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',51,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' ez rezr ezrez rezr ezrez','r ezr ezzer ezrezr ez','inbox','new',1123792987); 
     236INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',53,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','r ezr ezrezrezrzrez e rez',' rezr ezrezr ezrez','inbox','new',1123792993); 
     237INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',55,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','ezr ezrezre','zr ezr zerezrez rezrez','inbox','new',1123792999); 
     238INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',57,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rez reza rezarez arezarza rez','arez rezare razer zar','save','read',1123793005); 
     239INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',59,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rtret retrezterz t','rezt ertreztreztez','inbox','new',1123793010); 
     240INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',61,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tre tzete ztrezt rez','treztrez trezt rezt rez','inbox','new',1123793015); 
     241INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',103,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','fdsvfdsvfvfds','vfdsvfds vfds vfdsvfdv','inbox','read',1123793108); 
     242INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',66,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tr ezt reztrez tre','zt reztreztr ez','inbox','new',1123793023); 
     243INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',68,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' trez treztreztreztre z','tre terzt reztrez','inbox','new',1123793027); 
     244INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',70,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' trez erzt reztrezter trez','t rezt ezrt er','inbox','new',1123793032); 
     245INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',72,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' rte treztre ztrezt ezrt',' tret erzt retreztrez','inbox','new',1123793039); 
     246INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',74,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tre trezt rezt reztrez','t rezt rezt e trez','inbox','new',1123793043); 
     247INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',76,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','t retr eztret','ertez tez trze','save','read',1123793051); 
     248INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',78,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','t rezt reztrez trez','t rezt reztreztez','inbox','read',1123793055); 
     249INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',80,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','trezatrz','treazt etre ','inbox','read',1123793059); 
     250INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',82,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','trez trezt erz','t reztrezt rezt rezt rez','inbox','read',1123793064); 
     251INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',84,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','eztreztez','tre ztrez tr','inbox','new',1123793067); 
     252INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',86,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','zetret ez','trez trez terztr','inbox','new',1123793070); 
     253INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',88,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','trez terz etez','t rez trezt ezt','inbox','new',1123793074); 
     254INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',90,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','t rezt rez','t rez treztrezt ezt ','save','read',1123793079); 
     255INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',92,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','cxwvdsqvdfsq','tre ebcwvcxwvcxwvcxwvcxw','inbox','new',1123793083); 
     256INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',94,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfdvdfqvfdq','vfdsqvfdqvfdqvfdq','save','read',1123793088); 
     257INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',96,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfdsvfdsvf','vfdqvfdqvfdsvfdsvsdfv','inbox','new',1123793093); 
     258INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',98,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfd fdsv fdsvfds vfds','vfdsvfdsvfds vdqzervf\r\n','inbox','read',1123793099); 
     259INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',35,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','test','test','inbox','new',1123792943); 
     260INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',36,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','test','test','send','read',1123792943); 
     261INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',38,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rezrezrez','rzerezrez','send','read',1123792949); 
     262INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',40,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rezrezrzerzer','zrezrze zer ezr','send','read',1123792954); 
     263INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',42,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' ez rezr ez rez','ez rez rezrez rez','send','read',1123792960); 
     264INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',44,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' rez r','ezr ezrezr zerezrez rze','send','read',1123792965); 
     265INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',46,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' ez rezr ezrezr ezr','ezrez rezrez rez rez rez','send','read',1123792970); 
     266INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',48,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','r ezr ezrezr ezrez','rez rezr zerez rez','send','read',1123792975); 
     267INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',50,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' rez rzerezrezezr ezr ezr','r ez rezr ezr ezrezrez ','send','read',1123792981); 
     268INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',52,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' ez rezr ezrez rezr ezrez','r ezr ezzer ezrezr ez','send','read',1123792987); 
     269INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',54,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','r ezr ezrezrezrzrez e rez',' rezr ezrezr ezrez','send','read',1123792993); 
     270INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',56,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','ezr ezrezre','zr ezr zerezrez rezrez','send','read',1123792999); 
     271INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',58,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rez reza rezarez arezarza rez','arez rezare razer zar','send','read',1123793005); 
     272INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',60,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','rtret retrezterz t','rezt ertreztreztez','send','read',1123793010); 
     273INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',62,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tre tzete ztrezt rez','treztrez trezt rezt rez','send','read',1123793015); 
     274INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',64,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tre treztr ezt','rezt reztez','inbox','new',1123793019); 
     275INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',65,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tre treztr ezt','rezt reztez','send','read',1123793019); 
     276INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',67,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tr ezt reztrez tre','zt reztreztr ez','send','read',1123793023); 
     277INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',69,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' trez treztreztreztre z','tre terzt reztrez','send','read',1123793027); 
     278INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',71,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' trez erzt reztrezter trez','t rezt ezrt er','send','read',1123793032); 
     279INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',73,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one',' rte treztre ztrezt ezrt',' tret erzt retreztrez','send','read',1123793039); 
     280INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',75,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','tre trezt rezt reztrez','t rezt rezt e trez','send','read',1123793043); 
     281INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',77,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','t retr eztret','ertez tez trze','send','read',1123793051); 
     282INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',79,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','t rezt reztrez trez','t rezt reztreztez','send','read',1123793055); 
     283INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',81,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','trezatrz','treazt etre ','send','read',1123793059); 
     284INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',83,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','trez trezt erz','t reztrezt rezt rezt rez','send','read',1123793064); 
     285INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',85,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','eztreztez','tre ztrez tr','send','read',1123793067); 
     286INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',87,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','zetret ez','trez trez terztr','send','read',1123793070); 
     287INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',89,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','trez terz etez','t rez trezt ezt','send','read',1123793074); 
     288INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',91,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','t rezt rez','t rez treztrezt ezt ','send','read',1123793079); 
     289INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',93,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','cxwvdsqvdfsq','tre ebcwvcxwvcxwvcxwvcxw','send','read',1123793083); 
     290INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',95,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfdvdfqvfdq','vfdsqvfdqvfdqvfdq','send','read',1123793088); 
     291INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',97,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfdsvfdsvf','vfdqvfdqvfdsvfdsvsdfv','send','read',1123793093); 
     292INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',99,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfd fdsv fdsvfds vfds','vfdsvfdsvfds vdqzervf\r\n','send','read',1123793099); 
     293INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',101,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfdsvfdsvf','vfdxvfdvfdsqvfdsgvfdsvds','save','read',1123793104); 
     294INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',102,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','vfdsvfdsvf','vfdxvfdvfdsqvfdsgvfdsvds','send','read',1123793104); 
     295INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',104,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','fdsvfdsvfvfds','vfdsvfds vfds vfdsvfdv','send','read',1123793108); 
     296INSERT INTO `message` VALUES ('354a778bacabffaff3d3fd74f93ac278',107,'354a778bacabffaff3d3fd74f93ac278','Alexandre','message','one','Diff entre pagination à l\'ancienne et avec Pager_dotnode :)','Index: inbox.inc.php\r\n===================================================================\r\n--- inbox.inc.php       (revision 15)\r\n+++ inbox.inc.php       (working copy)\r\n@@ -22,33 +22,12 @@\r\n  * Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.\r\n  ******************** http://opensource.ikse.net/projects/dotnode ***/\r\n \r\n+include(INCLUDESPATH.\'/pager.inc.php\');\r\n+\r\n $_SMARTY[\'Title\'] =  \'Messages\';\r\n \r\n-/** Pagination ***************/\r\n-$pagination[\'nb_elements\'] = $db->getOne(\'SELECT COUNT(id) FROM message WHERE id=? AND box=?\', array($_SESSION[\'my_id\'], \'inbox\') );\r\n-$pagination[\'elmt_by_page\'] = 20;\r\n-if($pagination[\'nb_elements\'] > 0)\r\n-       $pagination[\'nb_pages\'] = ceil($pagination[\'nb_elements\']/$pagination[\'elmt_by_page\']);\r\n-else\r\n-       $pagination[\'nb_pages\'] = 1;\r\n+$messages_r = $db->query(\'SELECT id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id=? AND box=? ORDER by date DESC\', array($_SESSION[\'my_id\'],\'inbox\'));\r\n \r\n-if(is_numeric($token[2]) && \r\n-   $token[2] <= $pagination[\'nb_pages\'] && \r\n-   $token[2] > 0 )\r\n-       $pagination[\'current_page\'] = $token[2];\r\n-else\r\n-{\r\n-       header(\'Location: /messages/inbox/1\');\r\n-       exit();\r\n-}\r\n-\r\n-$pagination[\'pages\'] = @array_fill(1,$pagination[\'nb_pages\'], NULL);\r\n-\r\n-$_SMARTY[\'pagination\'] =  $pagination;\r\n-/******************************/\r\n-\r\n-$messages_r = $db->query(\'SELECT id_mess, id_from, from_str, type, dest, subject, message, flag, date FROM message WHERE id=? AND box=? ORDER by date DESC LIMIT ?,?\', array($_SESSION[\'my_id\'],\'inbox\',  ($pagination[\'current_page\']-1)*$pagination[\'elmt_by_page\'], $pagination[\'elmt_by_page\']));\r\n-\r\n if(!DB::isError($messages_r) )\r\n while($message = $messages_r->fetchRow())\r\n        $messages[$message[\'id_mess\']] = $message;\r\n@@ -58,6 +37,10 @@\r\n $_SESSION[\'nb_new_messages\'] = $db->getOne(\'SELECT COUNT(id_mess) FROM message WHERE id=? AND box=? AND flag=?\', array($_SESSION[\'my_id\'], \'inbox\', \'new\'));\r\n $_SESSION[\'nb_new_messages_timestamp\'] = 1;\r\n \r\n+$pager =& Pager_dotnode::factory($messages);\r\n+$links = $pager->getPageData();\r\n \r\n-$_SMARTY[\'messages\'] =  $messages;\r\n+$_SMARTY[\'pager\'] = $pager->getLinks();\r\n+$_SMARTY[\'messages\'] = $pager->getPageData();\r\n+\r\n ?>\r\n','send','read',1123808836); 
     297 
     298-- 
     299-- Dumping data for table `metalbum` 
     300-- 
     301 
     302INSERT INTO `metalbum` VALUES ('354a778bacabffaff3d3fd74f93ac278','flickr','alex-ikse',NULL); 
     303INSERT INTO `metalbum` VALUES ('354a778bacabffaff3d3fd74f93ac278','interalbum','alexx',NULL); 
    207304 
    208305-- 
    … …  
    210307-- 
    211308 
    212 INSERT INTO `relation` VALUES ('354a778bacabffaff3d3fd74f93ac278','00112233445566778899001122334455',0,0,0,0,'havent_seen','other',1119595944); 
     309INSERT INTO `relation` VALUES ('354a778bacabffaff3d3fd74f93ac278','00112233445566778899001122334455',0,0,0,0,'havent_seen','other',1124147539); 
    213310INSERT INTO `relation` VALUES ('00112233445566778899001122334455','354a778bacabffaff3d3fd74f93ac278',0,0,0,0,'havent_seen','other',1116620277); 
    214 INSERT INTO `relation` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','354a778bacabffaff3d3fd74f93ac278',2,3,1,0,'havent_seen','internet',1122935145); 
    215 INSERT INTO `relation` VALUES ('354a778bacabffaff3d3fd74f93ac278','1353c20315c720ad6c88a498ccc1c1ac',0,3,0,1,'havent_seen','work',1122935182); 
     311INSERT INTO `relation` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','354a778bacabffaff3d3fd74f93ac278',2,3,1,0,'havent_seen','internet',1123618998); 
     312INSERT INTO `relation` VALUES ('354a778bacabffaff3d3fd74f93ac278','1353c20315c720ad6c88a498ccc1c1ac',0,3,0,1,'havent_seen','work',1124400958); 
     313INSERT INTO `relation` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','354a778bacabffaff3d3fd74f93ac278',0,0,0,0,'friend','internet',1123530409); 
     314INSERT INTO `relation` VALUES ('354a778bacabffaff3d3fd74f93ac278','7fd5694bc166bbcc91c2ff72ad71dfd4',0,0,0,0,'friend','internet',1124147557); 
     315INSERT INTO `relation` VALUES ('28d956398f784ad039d48501c7ff66dd','7fd5694bc166bbcc91c2ff72ad71dfd4',0,0,0,0,'friend','internet',1123530582); 
     316INSERT INTO `relation` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','28d956398f784ad039d48501c7ff66dd',0,0,0,0,'friend','internet',0); 
    216317 
    217318-- 
    … …  
    226327 
    227328INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'d786c560e72e04f4312c4ce3242276f7','#1: .node ne détecte pas si les cookies ne sont pas activés ...','Dotnode devrait prevenir qu\'il a detecté que les cookies ne sont pas activé et indiquer a l\'utilisateur que c\'est indispensable...',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/1',1122803681); 
     329INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'b68aae197bfc4830bf8748f4da9a639e','#7: installation','Il faudrait un manuel pour montrer comment l\'installer. Ou un petit ou d\'installation.\nJusqu\'a maintenant je n\'ai reussi qu\'avoir la page d\'accueil en anglais, en bidouillant. Aucune autre page...',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/7',1123247174); 
     330INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'94cd13e6df338a0222c79c5daba695a7','#3: bug sur la page d\'affichage des communautés','voila pour que ce soit plus clair j\'ai fait un screen :\n[http://home.geekdrop.org/~ucode/screen.dotnode.png screen]\n\nceertaines lignes ds le rappel des derniers messages de la communauté apparaissent grises, et la date du dernier post n\'apparait pas, est-ce normal ou non ?',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/3',1123179234); 
     331INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'03a16c3297daa97fd4249bac938830cf','#5: Impossibilité d\'invité une personne, qui a déja été invité, mais qui ne s\'est pas encore inscrite','En voulant invité une personne, le système m\'a prévenu qu\'une autre personne l\'a déja faite, si cette personne n\'a pas reçu le mail, ou ne sais pas inscrite antérieurement, il est impossible d\'aller plus loin.\n\nLe mieux c\'est que le système renvoi un mail d\'inscription, avec le nom de la première personne qui l\'a inscrite.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/5',1123229011); 
     332INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'88d4e15e7714314cd78626d69047816e','#4: Problème d\'index sur la page Rechercher','Quand on va sur la page Rechercher et que l\'on fait une recherche quelquonque dont le résultat s\'étale sur plusieurs pages, on remarque la chose suivante:\n\nLe monsieur (ou la madame) qui se retrouve le(la) dernièr(e) en bas de la page N, est le(la) premièr(e) de la page N+1.\n\nJe suppute que c\'est un petit problème d\'index.\n\nSi c\'était voulu, désolé d\'avoir ouvert un ticket pour rien :)\n\nR ',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/4',1123188615); 
     333INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'1e44aa695e397834b56b9a8be5003b20','#9: Ajouter son propre fichier FOAF','Avoir la possibilité d\'ajouter son propre fichier FOAF.\n\nDeux possibilité : \n- Utiliser son fichier qu\'on envoi sur le serveur.\n- Donner un lien vers son fichier FOAF déjà en ligne.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/9',1123320769); 
     334INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'183e0bc7ff140c8fb39788c8f1e7cdf0','#10: Ajouter la langue &#34;Catalan&#34;','Le traducteur en charge du catalan a terminé sa traduction.\nJe l\'ajoute à l\'arrache dans dotnode.com, il faut maintenant que je l\'ajoute proprement dans \"Open .node\".',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/10',1123345279); 
     335INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'3a5211871b71750f4563c0112f42e8a1','#11: Jabber On DotNode','Ajout d\'un support jabber compte client <--> compte jabber\nhttp://freshmeat.net/projects/classjabberphp/\nhttp://cjphp.netflint.net/\n\n- création ou reception d\'un compte\n- import des contacts existants (+ invitation dans dotnode)\n- ajout des contacts dotnode dans les contacts jabber\n- messagerie instantannées en ligne',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/11',1123487077); 
     336INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'fcd70799866f711b85da4b5052f2c833','#14: conf smarty/cache dupliquée dans divers fichiers php','La conf de base de smarty (tous les _dir), la création de l\'objet smarty lui meme, et tout ce qui s\'ensuit (tous les $smarty->register_*), sont dupliquées dans tous les fichiers php qui ont besoin de ce dernier. Si ya une raison, je veux bien l\'entendre, sinon ca serait pratique d\'avoir tout ca dans un fichier a part, appellé a chaque fois. A la limite, faudra réfléchir a un truc pour ne pas appeller les register_* et leurs amis lorsque cela n\'est pas nécessaire, mais c\'est amha pas tellement important.\n\nNote: ne pas confondre avec smarty/configs/, que personellement je n\'ai jamais utilisé, et qui permet si j\'en crois la doc smarty d\'avoir des variables pré-assignées a utiliser ensuite dans les templates.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/14',1123545899); 
     337INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'997b6573bb06f490a997761a889bb72d','#15: Error 11/12/13','Dans les fichiers php dans /actions/my/blog/ un peu partout, il est fait référence a diverses erreurs en numérique, telles que /error/11/, /error/12/, etc.\n\nJe ne trouve nulle part ailleurs cette syntaxe pour les erreurs, et pas dans le fichier dotnode-error.php en tout cas, donc ca balance un \'Unknown Error\'.\n\nVieux truc jamais corrigé ? J\'ai un vague souvenir que les premieres versions de dotnode au moins utilisaient des urls de ce type pour les erreurs.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/15',1123550413); 
     338INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'32ff7c28664639f1551cddd2e53e633b','#16: Evenements: champ pays','Le champ pays lors de la création d\'un événement d\'une communauté est enregistrée.\n\nLorsqu\'on édite l\'événement, le champ pays est vide.\nLa liste des pays n\'est pas disponible.\n\nLorsqu\'on enregistre l\'événement après l\'avoir éditer, on perd donc le champ pays.\n',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/16',1123608278); 
     339INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'be9a322b1560422da8bd19f4d5e55e98','#17: Plusieurs images qui tournent pour la meme communauté','Idée honteusement piquée de http://dotnode.com/communities/viewTopic/5284 :\n\nUn truc qui serait pas mal, ca serait d\'avoir la possibilité d\'avoir plusieurs images qui tournent aleatoirement pour chaque communauté (voire meme chaque profil, mais on verra ca apres :). \n\nJ\'ai fait un rapide passage dans le code d\'affichage d\'une communauté et ca ne semble pas tres sorcier, faudrait genre garder dans un coin de la base le nombre total de logos, les stocker soit dans un repertoire a part (ok, ya deja un hash sur 2 niveaux, c\'est ptet trop), soit avec un nom de fichier genre idcomm_idimage.png, et faire un random dessus.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/17',1123713142); 
     340INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'5bc48aacfa9a2cf9b63fdb95b95dadce','#20: Pagination difficile a utiliser ?','Je trouve la pagination (dans les albums des gens, dans les messages) assez difficile a remarquer et a utiliser. Comme il n\'y a que des liens vers les chiffres, la zone de clic est assez petite. Par ailleurs, pour aller a la page suivante ou précédente il faut en plus discerner la page actuelle (pas difficile, mais ca prend 1/2 seconde supplémentaire ^^).\n\nJ\'ai pas nécessairement beaucoup d\'idées sur le sujet, mais au moins des fleches pour faire suivant / precedent (« et » par exemple, mais en utf8 ya plein de caracteres sympa pour genre ← et →, chercher arrow dans gucharmap :), avec un accesskey dessus (je propose &lt; et &gt;, utilisés au moins sur linuxfr et skyblog :), ca serait pas mal.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/20',1123713943); 
     341INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'bb569e9d3d6bd054757955f917772fc5','#18: Album pour une communauté','Idée sympa : un album partagé entre les membres d\'une meme communautée, modérée par le créateur de la communauté (qui activerait ou non l\'option). Ca serait pratique pour pouvoir mettre des photos d\'une rencontre, par exemple.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/18',1123713237); 
     342INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'e2f0631129dd725db652d63d2062c50d','#19: Commentaires (optionels) pour les images des albums','Ca serait ptet pas mal de pouvoir commenter en option les images de albums des gens (Et si on fait #18 , des communautés, donc attention a faire du code réutilisable). Par contre, pour voir les commentaires et en déposer il faudrait etre identifié je pense.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/19',1123713409); 
     343INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'b64af0bea382ce9862df7bc72de90dff','#21: impossible de gerer les categories des signets','Ou est la gestion des categories des signets ?',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/21',1123753866); 
     344INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'070098a277a3692ff00247ef47b3e991','#22: Orthographe ?','Sur la page d\'affichage du blog, il est ecrit \"0 commentaire\".\n\nUn \'s\' suplementaire a \'commentaire\' me semble plus juste dans ce cas precis.\n\nA vous de faire la correction si cela vous semble necessaire...',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/22',1123770199); 
     345INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'5e584a6d614064569b84f2c1fbcc5bee','#24: Création d\'objet de base pour manipuler les données de .node','Creer des objets simples et cohérents pour manipuler les différents types d\'ensemble de données que contient .node.\n\nPar exemple:\n * une class User pour manipuler les données d\'un membre, voir meme de sois meme (on peut imaginer que dans le cas ou le User est soi-meme, cela soit une class qui hérite de User et ajoute qq méthode spécifique (pour la configuration par exemple)).\n * une classe Community, Forum, Event, Topic, Post ...\n * une classe Album, Image, ...\n * une classe Message \n * une classe Bookmark\n * une classe Blog, Ticket',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/24',1123809723); 
     346INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'885ba5c1889566efb6513c30cd7671be','#25: Et les geeks ?','Dans la partie : \"Vit avec\", il manque l\'option :\n\n\"Avec ses ordinateurs...\"\n\nCa pourrait etre marrant a rajouter ^_^.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/25',1123817375); 
     347INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'ad6407b8db62dc741e1ddbb416ac8897','#26: Bloquer les nouveaux messages d\'une communauté, autoriser pour certains','Si une communauté devient obsolète, ou bien subit un \"flood\" de messages,\nil doit être possible pour le modérateur de bloquer les nouveaux messages...\n\naccessoirement il devrait être possible pour le modérateur lui-même, de poster des messages malgré l\'interdiction, et peut-etre de pouvoir sélectionner des personnes ayant le droit de poster des messages... (équivalent au mode +m des chans IRC)\n\n',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/26',1123970863); 
     348INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'1529713852c1812c1e34138a94c8a665','#27: &lt;tags html&gt;On peu pas ?&lt;/tags html&gt;','J\'aimerai bien pouvoir agréementer les forums et mes blog d\'images. On pourait fait que un tag permette de récuperer des images dans l\'abum ou sur des url distante.\nDes tags pour mettre \'\'\'en gras\'\'\', en \'\'italique\'\' en <h3> et ces petits trucs qui facilitent la lisibilité, ca serait sympa je trouve.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/27',1123975552); 
     349INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'ec4214ac1547fe7905f3a7f8788759a8','#28: Ajouter des liens dans la barre à gauche sous la photo','Ce serait bien de pouvoir ajouter des liens sous la photo dans la barre à gauche, des liens que l\'on voudrait toujours présents : Mon CV, par exemple, ou Mon site perso, etc...\n\nDonc à la limite, quand on ajoute un lien, faire une case a cocher pour faire apparaitre le lien dans la barre de gauche...',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/28',1124109274); 
     350INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'ee7954996b64496148295769c3e0bebf','#29: suppression d\'une invitation en attente','impossible de supprimer une invitation en attente dans la rubrique Amis > Invitation. J\'utilise FireFox sur MacOSX.',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/29',1124267448); 
     351INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'a124f0ad3cc755a392e87c64c1bf1460','#30: Birthday reminder','Je viens de louper d\'une journée l\'anniversaire de babayou, ca serait bien d\'activer/de faire marcher la notification d\'anniversaire qui arrive pour éviter ca a l\'avenir :)',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/30',1124305299); 
     352INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'5179c982a301775881383c72592d90ec','#31: Message d\'erreur au login','Le message d\'erreur qui apparais lors d\'un mauvais mot de passe ou d\'un mauvais login et est anglais. Ceci même si la langue par défaut et le français.\n\n',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/31',1124368245); 
     353INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'4d9f6be2e48fa26a69fda58323fb9bef','#33: Orthographic corrector','It would be find to have an orthographic corrector on message boxes, just like GMail have.\n',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/33',1124369003); 
     354INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'12b7aeb3c65055619d75c9488b1f88c9','#32: Un feminin a .nodien ?','Quand on va sur la page d\'une personne en haut s\'affiche .nodien depuis XX XX et cela pour les filles comme pour les garçons. Peut être que pour les filles un petit .nodienne ?\n\nBon ce n’est pas super important.\n',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/32',1124368949); 
     355INSERT INTO `rss_blog_ticket` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',1,'78a0ff2ee5c2d7b4c81c2912d0d847be','#35: secure mode','Would be great if the password was not travelling uncrypted through the web. We should perhaps use a HTTPS login, no ?',NULL,'http://opensource.ikse.net/projects/dotnode/ticket/35',1124376138); 
    228356 
    229357-- 
    … …  
    231359-- 
    232360 
    233 INSERT INTO `session` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','8bfd5e78d4e0daffc59316730b35cf5b',1122935568); 
     361INSERT INTO `session` VALUES ('354a778bacabffaff3d3fd74f93ac278','beec977351d07ada0bd2f73b83a30905',1124401830); 
    234362 
    235363-- 
    … …  
    250378-- 
    251379 
    252 INSERT INTO `user` VALUES ('354a778bacabffaff3d3fd74f93ac278','alexx','1723ce1b6a6c6bd4','Alexandre','DATH',NULL,'y','Error: Unable to parse your RSS',1084260676,1083016054,1122935229,'fr_FR','0','ok','82.225.136.176'); 
     380INSERT INTO `user` VALUES ('354a778bacabffaff3d3fd74f93ac278','alexx','60e35759170fc0f5','Alexandre','DATH',NULL,'y','Error: Unable to parse your RSS',1084260676,1083016054,1124397173,'fr_FR','0','ok','82.225.136.176'); 
    253381INSERT INTO `user` VALUES ('00112233445566778899001122334455','moderator','1723ce1b6a6c6bd4','Moderator','Moderator',NULL,'y','',1084260676,1083016054,1122712133,'fr_FR','0','ok','82.225.136.176'); 
    254 INSERT INTO `user` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','mdoe','38fda18a4b89a2b7','John','Doe',NULL,'y',NULL,1122934961,1122928681,1122935261,'fr_FR','354a778bacabffaff3d3fd74f93ac278','ok','82.225.136.176'); 
     382INSERT INTO `user` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','mdoe','38fda18a4b89a2b7','John','Doe',NULL,'y',NULL,1122934961,1122928681,1123838533,'fr_FR','354a778bacabffaff3d3fd74f93ac278','ok','82.225.136.176'); 
     383INSERT INTO `user` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','test','378b243e220ca493','Test','toto','surnom','n',NULL,1123530303,1123529926,1123530330,'fr_FR','354a778bacabffaff3d3fd74f93ac278','ok',''); 
     384INSERT INTO `user` VALUES ('28d956398f784ad039d48501c7ff66dd','zetrezre','378b243e220ca493','testes','tesezezfez','surnom correct !','n',NULL,1123530566,1123530490,1123530579,'fr_FR','7fd5694bc166bbcc91c2ff72ad71dfd4','ok',''); 
    255385 
    256386-- 
    … …  
    258388-- 
    259389 
    260 INSERT INTO `user_comm` VALUES ('354a778bacabffaff3d3fd74f93ac278',1,'ok',1122844214); 
     390INSERT INTO `user_comm` VALUES ('354a778bacabffaff3d3fd74f93ac278',1,'ok',1123700103); 
    261391 
    262392-- 
    … …  
    267397INSERT INTO `user_contact` VALUES ('00112233445566778899001122334455','moderator@dotnode.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'France'); 
    268398INSERT INTO `user_contact` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','test-debug@dotnode.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'France'); 
     399INSERT INTO `user_contact` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','test-arezarez@ikse.org',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'France'); 
     400INSERT INTO `user_contact` VALUES ('28d956398f784ad039d48501c7ff66dd','test-tsetez@ikse.org',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'France'); 
    269401 
    270402-- 
    … …  
    275407INSERT INTO `user_general` VALUES ('00112233445566778899001122334455','','2004-06-16','','no','male','','no','no','','http://dotnode.com',NULL); 
    276408INSERT INTO `user_general` VALUES ('1353c20315c720ad6c88a498ccc1c1ac','single','2005-08-02','business,partners',NULL,'male',NULL,NULL,NULL,'alone,pet','http://opensource.ikse.net/projects/dotnode','Je suis plutôt ... virtuel'); 
     409INSERT INTO `user_general` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','single','2005-08-08',NULL,NULL,'male',NULL,NULL,NULL,NULL,NULL,NULL); 
     410INSERT INTO `user_general` VALUES ('28d956398f784ad039d48501c7ff66dd',NULL,'2005-08-08',NULL,NULL,'male',NULL,NULL,NULL,NULL,NULL,NULL); 
    277411 
    278412-- 
    … …  
    283417INSERT INTO `user_interests` VALUES ('00112233445566778899001122334455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
    284418INSERT INTO `user_interests` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
     419INSERT INTO `user_interests` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
     420INSERT INTO `user_interests` VALUES ('28d956398f784ad039d48501c7ff66dd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
    285421 
    286422-- 
    … …  
    291427INSERT INTO `user_personal` VALUES ('00112233445566778899001122334455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
    292428INSERT INTO `user_personal` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
     429INSERT INTO `user_personal` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
     430INSERT INTO `user_personal` VALUES ('28d956398f784ad039d48501c7ff66dd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
    293431 
    294432-- 
    … …  
    299437INSERT INTO `user_professional` VALUES ('00112233445566778899001122334455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
    300438INSERT INTO `user_professional` VALUES ('1353c20315c720ad6c88a498ccc1c1ac',NULL,'beta-testeur','entertainment','.node','http://dotnode.com','Junior',NULL,NULL,NULL); 
     439INSERT INTO `user_professional` VALUES ('7fd5694bc166bbcc91c2ff72ad71dfd4','test-6nergies',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
     440INSERT INTO `user_professional` VALUES ('28d956398f784ad039d48501c7ff66dd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); 
    301441 
    302442-- 

  • trunk/dotnode-id.php

    r18 r24  
    6161        $smarty->debugging_ctrl = false; 
    6262         
    63 if(strlen($token[1]) == 32) 
     63if(is_valid('user_id', $token[1])) 
    6464        list($url_id) = array_splice($token, 1,1); 
    6565else 

  • trunk/dotnode-struct.sql

    r1 r24  
    391391 
    392392-- 
     393-- Table structure for table `metalbum` 
     394-- 
     395 
     396CREATE TABLE `metalbum` ( 
     397  `id` varchar(32) NOT NULL default '', 
     398  `type` varchar(16) NOT NULL default '', 
     399  `login` varchar(64) NOT NULL default '', 
     400  `nb_items` int(10) unsigned default NULL, 
     401  PRIMARY KEY  (`id`,`type`,`login`) 
     402) TYPE=MyISAM; 
     403 
     404-- 
    393405-- Table structure for table `relation` 
    394406-- 

  • trunk/inc/my.inc.php

    r15 r24  
    8383 
    8484/************* menu *******************/ 
    85 $leftmenu["/profile/$url_id"] = 'View my own profile'; 
     85$_SMARTY['leftmenu']["/profile/$url_id"] = 'View my own profile'; 
    8686 
    8787if($my['info']['nb_photos'] > 0) 
    88         $leftmenu["/album/$url_id"] = 'Album'; 
     88        $_SMARTY['leftmenu']["/album/$url_id"] = 'Album'; 
     89$_SMARTY['leftmenu']["/metalbum/$url_id"] = 'Meta Album'; 
    8990 
    9091if($my['info']['nb_blogs'] > 0) 
    91         $leftmenu["/blog/$url_id"] = 'Blog'; 
     92        $_SMARTY['leftmenu']["/blog/$url_id"] = 'Blog'; 
    9293 
    9394if($my['info']['nb_bookmarks'] > 0) 
    94         $leftmenu["/bookmarks/$url_id"] = 'Bookmarks'; 
    95  
    96 $_SMARTY['leftmenu'] = $leftmenu; 
     95        $_SMARTY['leftmenu']["/bookmarks/$url_id"] = 'Bookmarks'; 
    9796 
    9897 

  • trunk/inc/profile.inc.php

    r15 r24  
    9898if($url_id != $_SESSION['my_id']) 
    9999{ 
    100         $leftmenu["/messages/write/$url_id/contact"] = 'Send message'; 
     100        $_SMARTY['leftmenu']["/messages/write/$url_id/contact"] = 'Send message'; 
    101101        if(!in_array($url_id, $_SESSION['my_friends_id'])) 
    102                 $leftmenu["/friends/$url_id/invitation"] = 'Add as a friend'; 
     102                $_SMARTY['leftmenu']["/friends/$url_id/invitation"] = 'Add as a friend'; 
    103103        elseif($id_parent != $_SESSION['my_id']) 
    104                 $leftmenu["/action/".$url_id."/friends/unlink"] = "Delete friendship' link"; 
     104                $_SMARTY['leftmenu']["/action/".$url_id."/friends/unlink"] = "Delete friendship' link"; 
    105105} 
    106106 
    107  
    108 $_SMARTY['leftmenu'] = $leftmenu; 
     107$_SMARTY['leftmenu']['/metalbum/'.$url_id] = 'Meta Album'; 
    109108 
    110109$_SMARTY['user'] = $user; 

  • trunk/includes/EDIT_config_server.inc.php

    r10 r24  
    4545); 
    4646 
     47// Get it on http://www.flickr.com/services/api/key.gne 
     48$config['metalbum']['flickr']['api_key'] = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'; 
     49 
    4750?> 

  • trunk/includes/config.inc.php

    r16 r24  
    2323 ******************** http://opensource.ikse.net/projects/dotnode ***/ 
    2424 
    25 if(array_key_exists('DOCUMENT_ROOT', $_SERVER) && strlen($_SERVER['DOCUMENT_ROOT']) > 0) 
    26         define('BASEPATH',$_SERVER['DOCUMENT_ROOT']); 
    27 elseif(array_key_exists('BASEPATH', $_ENV)) 
    28         define('BASEPATH', $_ENV['BASEPATH']); 
     25define('BASEPATH', dirname(__FILE__).'/../www'); 
    2926 
    3027define('INCLUDESPATH', BASEPATH.'/../includes'); 

  • trunk/includes/functions.inc.php

    r21 r24  
    450450} 
    451451 
     452function is_valid($type, $string) 
     453{ 
     454        global $labels; 
     455        switch($type) 
     456        { 
     457        case 'login': 
     458                return valid_login($string); 
     459                break; 
     460        case 'email': 
     461                return valid_email($string); 
     462                break; 
     463        case 'lang': 
     464                return valid_lang($lang); 
     465                break; 
     466        case 'user_id': 
     467                return ereg("[a-f0-9]{32}", $string); 
     468                break; 
     469        case 'metalbum_type': 
     470                if(in_array($string, array_keys($labels['metalbum']['type']))) 
     471                        return true; 
     472                else 
     473                        return false; 
     474                break; 
     475        case 'metalbum_name': 
     476                if(strpos($string, '@')) 
     477                { 
     478                        list($login, $type) = split('@', $string); 
     479                        if(ereg("[a-zA-Z0-9_-]{2,32}", $login) && is_valid('metalbum_type', $type)) 
     480                                return true; 
     481                } 
     482                else 
     483                        return false; 
     484                break; 
     485        } 
     486} 
     487 
    452488function valid_login($login) 
    453489{ 

  • trunk/includes/labels.inc.php

    r1 r24  
    218218        'stop' => tr('Operation stopped'), 
    219219        'error' => tr('Error') ); 
     220         
     221$labels['metalbum']['type'] = array( 
     222        'interalbum' => 'interAlbum.com', 
     223        'flickr' => 'Flickr.com' ); 
    220224 
    221225?> 

  • trunk/robots/launch_robots.sh

    r1 r24  
    11#/bin/sh 
    2  
    3 CURRENT_DIR=`dirname $0` 
    4 cd ~/$CURRENT_DIR 
    5  
    6 export BASEPATH=$PWD/../www 
    72 
    83nice -19 /usr/bin/php dispatch_message.bot.php && sleep 1 
    94 
    10 for lang in fr_FR en_US es_ES pt_BR ja_JP fa_IR; do 
     5for lang in fr_FR en_US es_ES pt_BR ja_JP fa_IR de_DE ca_ES; do 
    116        nice -19 /usr/bin/php send_invitation.bot.php $lang && sleep 1 
    127done 
    138 
    14 for lang in fr_FR en_US es_ES pt_BR ja_JP fa_IR; do 
     9for lang in fr_FR en_US es_ES pt_BR ja_JP fa_IR de_DE ca_ES; do 
    1510        nice -19 /usr/bin/php send_password.bot.php $lang && sleep 1 
    1611done 
    1712 
    18 for lang in fr_FR en_US es_ES pt_BR ja_JP fa_IR; do 
     13for lang in fr_FR en_US es_ES pt_BR ja_JP fa_IR de_DE ca_ES; do 
    1914        nice -19 /usr/bin/php send_confirmation_email.bot.php fr_FR && sleep 1 
    2015done 

  • trunk/www/default.css

    r1 r24  
    11321132} 
    11331133 
     1134table.album { 
     1135        width: 100%; 
     1136} 
     1137 
    11341138/* Hide from IE5-mac. Only IE-win sees this. \*/ 
    11351139* html ul {