Changeset 8
- Timestamp:
- 11/30/05 19:40:35 (3 years ago)
- Files:
-
- devel/.htaccess (modified) (1 diff)
- devel/CHANGELOG (modified) (1 diff)
- devel/CONTRIBUTORS (modified) (3 diffs)
- devel/INSTALL (modified) (8 diffs)
- devel/README (modified) (2 diffs)
- devel/_communities (added)
- devel/_communities/index.php (added)
- devel/_communities/members.php (added)
- devel/_communities/owned.php (added)
- devel/_files/action_redirection.php (modified) (1 diff)
- devel/_files/cache (added)
- devel/_files/download.php (modified) (1 diff)
- devel/_files/icon.php (added)
- devel/_files/rss2.php (modified) (1 diff)
- devel/_rpc (added)
- devel/_rpc/RPC2.php (added)
- devel/_userdetails/index.php (modified) (1 diff)
- devel/_weblog/rss091.php (modified) (1 diff)
- devel/_weblog/rss2.php (modified) (1 diff)
- devel/_weblog/view_post.php (modified) (1 diff)
- devel/content/mainindex/content_main_index.php (modified) (1 diff)
- devel/content/users/content_log_on_pane.php (modified) (1 diff)
- devel/distribution/database/elgg.sql (modified) (20 diffs)
- devel/distribution/database/upgrade.sql (added)
- devel/includes.php (modified) (3 diffs)
- devel/includes_system.php (modified) (2 diffs)
- devel/profile/edit.php (modified) (1 diff)
- devel/profile/rss2.php (modified) (2 diffs)
- devel/units/communities (added)
- devel/units/communities/communities_access_level_check.php (added)
- devel/units/communities/communities_access_level_sql_check.php (added)
- devel/units/communities/communities_access_levels.php (added)
- devel/units/communities/communities_actions.php (added)
- devel/units/communities/communities_create.php (added)
- devel/units/communities/communities_edit.php (added)
- devel/units/communities/communities_edit_wrapper.php (added)
- devel/units/communities/communities_members.php (added)
- devel/units/communities/communities_moderator_of.php (added)
- devel/units/communities/communities_owned.php (added)
- devel/units/communities/community_memberships.php (added)
- devel/units/communities/community_wiki.php (added)
- devel/units/communities/main.php (added)
- devel/units/communities/permissions_check.php (added)
- devel/units/communities/profile_edit_link.php (added)
- devel/units/communities/user_info_menu.php (added)
- devel/units/communities/userdetails_edit.php (added)
- devel/units/display/function_input_field_display.php (modified) (3 diffs)
- devel/units/display/function_log_on_pane.php (modified) (2 diffs)
- devel/units/display/function_output_field_display.php (modified) (1 diff)
- devel/units/engine/menu_main.php (modified) (1 diff)
- devel/units/files/edit_file.php (modified) (2 diffs)
- devel/units/files/files_actions.php (modified) (16 diffs)
- devel/units/files/files_init.php (modified) (3 diffs)
- devel/units/files/files_mimetype_determine.php (modified) (2 diffs)
- devel/units/files/files_user_info_menu.php (modified) (3 diffs)
- devel/units/files/files_view.php (modified) (2 diffs)
- devel/units/files/folder_edit.php (modified) (9 diffs)
- devel/units/files/folder_view.php (modified) (7 diffs)
- devel/units/files/function_search.php (modified) (2 diffs)
- devel/units/files/main.php (modified) (1 diff)
- devel/units/files/permissions_check.php (added)
- devel/units/files/select_folder.php (modified) (3 diffs)
- devel/units/files/templates_preview.php (modified) (2 diffs)
- devel/units/files/weblogs_posts_add_fields.php (modified) (2 diffs)
- devel/units/friends/friends_actions.php (modified) (2 diffs)
- devel/units/friends/friends_edit.php (modified) (1 diff)
- devel/units/friends/friends_of_edit.php (modified) (1 diff)
- devel/units/friends/profile_friends.php (modified) (3 diffs)
- devel/units/friends/user_friends.php (modified) (1 diff)
- devel/units/friends/user_info_menu.php (modified) (1 diff)
- devel/units/groups/groups_access_levels.php (modified) (1 diff)
- devel/units/groups/groups_explanation.php (added)
- devel/units/groups/main.php (modified) (1 diff)
- devel/units/groups/menu_main.php (modified) (1 diff)
- devel/units/icons/function_actions.php (modified) (8 diffs)
- devel/units/icons/function_add_icons.php (modified) (3 diffs)
- devel/units/icons/function_edit_icons.php (modified) (4 diffs)
- devel/units/icons/main.php (modified) (1 diff)
- devel/units/icons/menu_main.php (modified) (1 diff)
- devel/units/icons/permissions_check.php (added)
- devel/units/invite/invite_actions.php (modified) (1 diff)
- devel/units/invite/menu_main.php (modified) (1 diff)
- devel/units/permissions (added)
- devel/units/permissions/function_check.php (added)
- devel/units/permissions/main.php (added)
- devel/units/phpthumb (added)
- devel/units/phpthumb/cache (added)
- devel/units/phpthumb/phpThumb.config.php (added)
- devel/units/phpthumb/phpThumb.demo.cacheconvert.php (added)
- devel/units/phpthumb/phpThumb.demo.demo1.php (added)
- devel/units/phpthumb/phpThumb.demo.demo2.php (added)
- devel/units/phpthumb/phpThumb.demo.showpic.php (added)
- devel/units/phpthumb/phpThumb.php (added)
- devel/units/phpthumb/phpthumb.bmp.php (added)
- devel/units/phpthumb/phpthumb.changelog.txt (added)
- devel/units/phpthumb/phpthumb.class.php (added)
- devel/units/phpthumb/phpthumb.filters.php (added)
- devel/units/phpthumb/phpthumb.functions.php (added)
- devel/units/phpthumb/phpthumb.gif.php (added)
- devel/units/phpthumb/phpthumb.license.txt (added)
- devel/units/phpthumb/phpthumb.readme.txt (added)
- devel/units/phpthumb/phpthumb.unsharp.php (added)
- devel/units/profile/edit_link.php (added)
- devel/units/profile/function_actions.php (modified) (3 diffs)
- devel/units/profile/function_edit.php (modified) (3 diffs)
- devel/units/profile/function_editfield_display.php (modified) (2 diffs)
- devel/units/profile/function_init.php (modified) (1 diff)
- devel/units/profile/function_search.php (modified) (1 diff)
- devel/units/profile/function_search_rss.php (modified) (1 diff)
- devel/units/profile/main.php (modified) (2 diffs)
- devel/units/profile/menu_main.php (modified) (2 diffs)
- devel/units/profile/permissions_check.php (added)
- devel/units/rpc (added)
- devel/units/rpc/README (added)
- devel/units/rpc/TODO (added)
- devel/units/rpc/debug (added)
- devel/units/rpc/debug/xmlrpc-debug-proxy.py (added)
- devel/units/rpc/lib (added)
- devel/units/rpc/lib/class_comment.php (added)
- devel/units/rpc/lib/class_elggobject.php (added)
- devel/units/rpc/lib/class_file.php (added)
- devel/units/rpc/lib/class_folder.php (added)
- devel/units/rpc/lib/class_post.php (added)
- devel/units/rpc/lib/class_tag.php (added)
- devel/units/rpc/lib/class_user.php (added)
- devel/units/rpc/lib/class_weblog.php (added)
- devel/units/rpc/lib/class_weblog.php_old (added)
- devel/units/rpc/lib/function_authenticate.php (added)
- devel/units/rpc/lib/function_load_comment.php (added)
- devel/units/rpc/lib/function_load_file.php (added)
- devel/units/rpc/lib/function_load_folder.php (added)
- devel/units/rpc/lib/function_load_post.php (added)
- devel/units/rpc/lib/function_load_tag.php (added)
- devel/units/rpc/lib/function_load_user.php (added)
- devel/units/rpc/lib/function_load_weblog.php (added)
- devel/units/rpc/lib/library.php (added)
- devel/units/rpc/lib/library_friends.php (added)
- devel/units/rpc/lib/library_user.php (added)
- devel/units/rpc/lib/library_weblog.php (added)
- devel/units/rpc/main.php (added)
- devel/units/rpc/rpc_init.php (added)
- devel/units/rpc/test (added)
- devel/units/rpc/test/xmlrpc-debug-proxy.py (added)
- devel/units/rpc/xmlrpc (added)
- devel/units/rpc/xmlrpc/library_blogger_xmlrpc.php (added)
- devel/units/rpc/xmlrpc/library_friends_xmlrpc.php (added)
- devel/units/rpc/xmlrpc/library_livejournal_xmlrpc.php (added)
- devel/units/rpc/xmlrpc/library_metaweblog_xmlrpc.php (added)
- devel/units/rpc/xmlrpc/library_mt_xmlrpc.php (added)
- devel/units/rpc/xmlrpc/xmlrpc_server.php (added)
- devel/units/search/search_suggest_rss.php (modified) (1 diff)
- devel/units/search/search_suggest_users.php (modified) (1 diff)
- devel/units/search/search_user_info_menu.php (modified) (2 diffs)
- devel/units/search/tags_display.php (modified) (1 diff)
- devel/units/templates/default_template.php (modified) (13 diffs)
- devel/units/templates/menu_main.php (modified) (1 diff)
- devel/units/templates/templates_add.php (modified) (1 diff)
- devel/units/templates/templates_view.php (modified) (5 diffs)
- devel/units/templates/variables_substitute.php (modified) (1 diff)
- devel/units/users/conf.php (modified) (1 diff)
- devel/units/users/function_display_name.php (modified) (1 diff)
- devel/units/users/function_log_off.php (modified) (1 diff)
- devel/units/users/function_log_on.php (modified) (1 diff)
- devel/units/users/function_session_current_status.php (modified) (1 diff)
- devel/units/users/function_session_start.php (modified) (1 diff)
- devel/units/users/get_type.php (added)
- devel/units/users/library.php (modified) (1 diff)
- devel/units/users/main.php (modified) (2 diffs)
- devel/units/users/menu_main.php (modified) (1 diff)
- devel/units/users/menu_user.php (modified) (1 diff)
- devel/units/users/permissions_check.php (added)
- devel/units/users/userdetails_actions.php (modified) (4 diffs)
- devel/units/users/userdetails_edit.php (modified) (2 diffs)
- devel/units/weblogs/archives_view.php (modified) (2 diffs)
- devel/units/weblogs/archives_view_month.php (modified) (1 diff)
- devel/units/weblogs/default_template.php (modified) (2 diffs)
- devel/units/weblogs/function_search.php (modified) (4 diffs)
- devel/units/weblogs/function_search_rss.php (modified) (2 diffs)
- devel/units/weblogs/main.php (modified) (2 diffs)
- devel/units/weblogs/menu_main.php (modified) (2 diffs)
- devel/units/weblogs/permissions_check.php (added)
- devel/units/weblogs/weblogs_actions.php (modified) (4 diffs)
- devel/units/weblogs/weblogs_friends_view.php (modified) (2 diffs)
- devel/units/weblogs/weblogs_post_field.php (added)
- devel/units/weblogs/weblogs_posts_add.php (modified) (2 diffs)
- devel/units/weblogs/weblogs_posts_edit.php (modified) (3 diffs)
- devel/units/weblogs/weblogs_posts_view.php (modified) (7 diffs)
- devel/units/weblogs/weblogs_user_info_menu.php (modified) (2 diffs)
- devel/units/weblogs/weblogs_view.php (modified) (1 diff)
- devel/units/weblogs/weblogs_view_month.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
devel/.htaccess
r6 r8 1 1 Options +FollowSymLinks 2 2 RewriteEngine on 3 RewriteBase /4 3 5 4 RewriteRule ^([0-9\-]+)\.css$ _templates/css.php?template=$1 devel/CHANGELOG
r6 r8 1 1 Elgg changelog 2 3 0.2 (20th June 2005) 4 -------------------- 5 Incorporated cookied login patch by Leonard Lin 6 Incorporated phpThumb() by James Heinrich - see units/phpthumb/phpthumb.readme.txt 7 Added communities 2 8 3 9 0.1.2a (24th April 2005) devel/CONTRIBUTORS
r6 r8 2 2 code. The following people have made additions and changes to the 3 3 core release, and are listed in alphabetical order. Contributors may 4 email elgg@apcala.comin order to have contact details added or4 email system@elgg.net in order to have contact details added or 5 5 amended for the next release. 6 6 … … 10 10 11 11 David Eshelman 12 http://www.ksucentral.com/esh/ 13 ------------------------------ 14 Icon upload 12 -------------- 13 Icon upload fixes 14 15 Misja Hoebe 16 http://www.chn.nl/ 17 ------------------ 18 XML-RPC unit 19 20 Leonard Lin 21 http://www.usc.edu/~lhl/ 22 ------------------------ 23 Cookied logins 24 Authentication refactoring 15 25 16 26 David Tosh … … 22 32 23 33 Ben Werdmuller 24 http:// apcala.com/ben/25 ---------------------- 34 http://elgg.net/bwerdmuller/ 35 ---------------------------- 26 36 Main system programmer devel/INSTALL
r6 r8 1 Elgg version 0. 1.2 alphainstallation instructions1 Elgg version 0.2 installation instructions 2 2 3 3 Ben Werdmuller <ben@elgg.net> 4 2 3rd April, 20054 21st June, 2005 5 5 6 6 … … 8 8 9 9 1.1 Requirements 10 11 Please read LICENSE. 10 12 11 13 Elgg currently requires the Apache web server with mod_rewrite … … 17 19 All for the virtual server where Elgg is installed. 18 20 19 Elgg mustbe installed on the root of a domain - for example,21 Elgg prefers to be installed on the root of a domain - for example, 20 22 at http://elgg.net/, as opposed to http://elgg.net/subdirectory/. 23 However, it has now been tested to work in subdirectories, although 24 this remains experimental until the next release. 21 25 22 26 You must have a database on the MySQL server ready for use by Elgg. 23 27 24 IF YOU ARE UPGRADING FROM 0.1.1a, you do not need to alter the database 25 schema (and can ignore section 3 of these instructions). 28 You must have the GD library installed. 26 29 27 IF YOU ARE UPGRADING FROM EARLIER VERSIONS, you must drop any existing 28 database tables and insert the new database schema. 30 If you have any problems installing, please consider joining 31 http://elgg.net/ and joining the Elgg Installation Support 32 community at http://elgg.net/support/ . 33 34 This version of Elgg only supports upgrading from version 0.1.1a 35 and above. Upgrading from all older versions will require a re-install. 29 36 30 37 … … 54 61 the root of your web server account. 55 62 63 Remember to include the .htaccess files; these may be invisible by 64 default if you are using MacOS X. 65 56 66 IF YOU ARE UPGRADING, you may wish to retain your existing 57 67 includes.php file. … … 72 82 chmod 777 data 73 83 74 Repeat this process for /_files/data. 84 Repeat this process for /_files/data and /_files/cache. 85 86 IF YOU ARE UPGRADING, please note that /_files/cache is new in this 87 release. Please remember to chmod it to 777. 75 88 76 89 … … 78 91 3. SETTING UP THE DATABASE 79 92 93 If you are upgrading, please skip to 3.4. 80 94 81 95 3.1 Open database schema … … 112 126 directory. 113 127 128 3.4 Upgrading 129 130 Perform either 3.2 or 3.3 but with the upgrade.sql file found in 131 /distribution/database instead of elgg.sql. 132 114 133 115 134 … … 139 158 140 159 141 4.3 Log in 160 4.3 XML-RPC 161 162 Misja Hoebe has written an XML-RPC unit that requires the PEAR library. 163 This allows users to use third-party blogging tools to post to your 164 Elgg systme. 165 166 Please see units/rpc/README for more details. If you are sure you have 167 all the prerequisites for this unit, uncomment the 'include XMLRPC' line 168 in the plugins section of includes.php. 169 170 171 4.4 Log in 142 172 143 173 We have included a default user, "news". This user owns all the devel/README
r6 r8 1 Elgg (The Learning Landscape) version 0. 1.2a1 Elgg (The Learning Landscape) version 0.2 2 2 Copyright (C) 2004-2005 David Tosh and Ben Werdmuller 3 4 This program includes the phpThumb program written by James Heinrich; 5 please see units/phpthumb/phpthumb.readme.txt for its information. 3 6 4 7 This program is free software; you can redistribute it and/or modify … … 23 26 Copyright (C) 2004-2005 David Tosh and Ben Werdmuller 24 27 25 Elgg 0. 1.2ais released under the GNU Public License (GPL), which28 Elgg 0.2 is released under the GNU Public License (GPL), which 26 29 is supplied in this distribution as LICENSE. 27 30 devel/_files/action_redirection.php
r2 r8 10 10 global $redirect_url; 11 11 global $messages; 12 global $page_owner; 13 14 if (isset($_REQUEST['files_owner'])) { 15 $page_owner = (int) $_REQUEST['files_owner']; 16 } 12 17 13 18 if (isset($messages) && sizeof($messages) > 0) { devel/_files/download.php
r6 r8 26 26 // ... and the owner of the file in the URL line hasn't been spoofed ... 27 27 28 if (run("users:name_to_id",$_REQUEST['files_name']) == $file->owner) { 28 if (run("users:name_to_id",$_REQUEST['files_name']) == $file->owner 29 || run("users:name_to_id",$_REQUEST['files_name']) == $file->files_owner) { 29 30 30 31 // ... and the current user is allowed to access it ... devel/_files/rss2.php
r6 r8 41 41 END; 42 42 if (!isset($_REQUEST['tag'])) { 43 $files = db_query("select * from files where owner = $page_owner and access = 'PUBLIC' order by time_uploaded desc limit 10");43 $files = db_query("select * from files where files_owner = $page_owner and access = 'PUBLIC' order by time_uploaded desc limit 10"); 44 44 } else { 45 45 $tag = addslashes($_REQUEST['tag']); 46 $files = db_query("select files.* from tags left join files on files.ident = tags.ref where files. owner= $page_owner and files.access = 'PUBLIC' and tags.tagtype = 'file' and tags.tag = '$tag' order by files.time_uploaded desc limit 10");46 $files = db_query("select files.* from tags left join files on files.ident = tags.ref where files.files_store = $page_owner and files.access = 'PUBLIC' and tags.tagtype = 'file' and tags.tag = '$tag' order by files.time_uploaded desc limit 10"); 47 47 } 48 48 if (sizeof($files) > 0) { devel/_userdetails/index.php
r2 r8 6 6 require("../includes.php"); 7 7 8 run("profile:init"); 8 9 run("userdetails:init"); 9 run("profile:init");10 10 11 11 protect(1); 12 12 13 $title = run("profile:display:name") . " :: Edit userdetails";13 $title = run("profile:display:name") . " :: Edit details"; 14 14 15 15 $body = run("templates:draw", array( devel/_weblog/rss091.php
r2 r8 39 39 <link>$mainurl</link> 40 40 END; 41 $entries = db_query("select * from weblog_posts where owner= $page_owner and access = 'PUBLIC' order by posted desc limit 10");41 $entries = db_query("select * from weblog_posts where weblog = $page_owner and access = 'PUBLIC' order by posted desc limit 10"); 42 42 if (sizeof($entries) > 0) { 43 43 foreach($entries as $entry) { devel/_weblog/rss2.php
r6 r8 40 40 END; 41 41 if (!isset($_REQUEST['tag'])) { 42 $entries = db_query("select * from weblog_posts where owner= $page_owner and access = 'PUBLIC' order by posted desc limit 10");42 $entries = db_query("select * from weblog_posts where weblog = $page_owner and access = 'PUBLIC' order by posted desc limit 10"); 43 43 } else { 44 44 $tag = addslashes($_REQUEST['tag']); 45 $entries = db_query("select weblog_posts.* from tags left join weblog_posts on weblog_posts.ident = tags.ref where weblog_posts. owner= $page_owner and weblog_posts.access = 'PUBLIC' and tags.tag = '$tag' and tags.tagtype = 'weblog' order by weblog_posts.posted desc limit 10");45 $entries = db_query("select weblog_posts.* from tags left join weblog_posts on weblog_posts.ident = tags.ref where weblog_posts.weblog = $page_owner and weblog_posts.access = 'PUBLIC' and tags.tag = '$tag' and tags.tagtype = 'weblog' order by weblog_posts.posted desc limit 10"); 46 46 } 47 47 if (sizeof($entries) > 0) { devel/_weblog/view_post.php
r2 r8 25 25 global $page_owner; 26 26 global $profile_id; 27 $profile_id = $post-> owner;28 $page_owner = $post-> owner;27 $profile_id = $post->weblog; 28 $page_owner = $post->weblog; 29 29 30 30 $title = run("profile:display:name") . " :: Weblog :: " . stripslashes($post->title); devel/content/mainindex/content_main_index.php
r6 r8 15 15 <table border="0" cellspacing="0" cellpadding="0"> 16 16 <tr> 17 <td><img src=" /images/front_page/1.jpg" width="80" height="80" alt="1." /></td>17 <td><img src="images/front_page/1.jpg" width="80" height="80" alt="1." /></td> 18 18 <td width="50"> </td> 19 19 <td>Sign up for an account - it's completely free, and all you need is a valid email address.</td> 20 20 </tr> 21 21 <tr> 22 <td><img src=" /images/front_page/2.jpg" width="80" height="80" alt="2." /></td>22 <td><img src="images/front_page/2.jpg" width="80" height="80" alt="2." /></td> 23 23 <td width="50"> </td> 24 24 <td>Create your own weblog, journal, store of files like photos and Word documents - as much or as little as you want!</td> 25 25 </tr> 26 26 <tr> 27 <td><img src=" /images/front_page/3.jpg" width="80" height="80" alt="3." /></td>27 <td><img src="images/front_page/3.jpg" width="80" height="80" alt="3." /></td> 28 28 <td width="50"> </td> 29 29 <td>Share them with your friends, academic staff and other $sitename users. <b>YOU</b> decide who can see them! </td> devel/content/users/content_log_on_pane.php
r2 r8 23 23 </tr> 24 24 <tr> 25 <td> </td> 26 <td> 27 <label><input type="checkbox" name="remember" checked="checked" /> Remember Login</label> 28 </td> 29 </tr> 30 <tr> 25 31 <td colspan="2" align="right"> 26 32 <label>Log on: <input type="submit" name="submit" value="Go" /></label> devel/distribution/database/elgg.sql
r2 r8 1 -- 2 --ELGG database schema3 -- 4 --This must be installed into your chosen Elgg database before you can run Elgg5 -- 6 7 ----------------------------------------------------------8 9 -- 10 --Table structure for table `file_folders`11 -- 1 # 2 # ELGG database schema 3 # 4 # This must be installed into your chosen Elgg database before you can run Elgg 5 # 6 7 # -------------------------------------------------------- 8 9 # 10 # Table structure for table `file_folders` 11 # 12 12 13 13 CREATE TABLE `file_folders` ( 14 14 `ident` int(11) NOT NULL auto_increment, 15 15 `owner` int(11) NOT NULL default '0', 16 `files_owner` int(11) NOT NULL default '0', 16 17 `parent` int(11) NOT NULL default '0', 17 18 `name` varchar(128) NOT NULL default '', … … 19 20 PRIMARY KEY (`ident`), 20 21 KEY `owner` (`owner`,`parent`,`name`,`access`) 21 ) TYPE=MyISAM; 22 23 -- -------------------------------------------------------- 24 25 -- 26 -- Table structure for table `file_metadata` 27 -- 22 ) TYPE=MyISAM AUTO_INCREMENT=5 ; 23 24 # 25 # Dumping data for table `file_folders` 26 # 27 28 29 # -------------------------------------------------------- 30 31 # 32 # Table structure for table `file_metadata` 33 # 28 34 29 35 CREATE TABLE `file_metadata` ( … … 34 40 PRIMARY KEY (`ident`), 35 41 KEY `name` (`name`,`file_id`) 36 ) TYPE=MyISAM; 37 38 -- -------------------------------------------------------- 39 40 -- 41 -- Table structure for table `files` 42 -- 42 ) TYPE=MyISAM AUTO_INCREMENT=1 ; 43 44 # 45 # Dumping data for table `file_metadata` 46 # 47 48 49 # -------------------------------------------------------- 50 51 # 52 # Table structure for table `files` 53 # 43 54 44 55 CREATE TABLE `files` ( 45 56 `ident` int(11) NOT NULL auto_increment, 46 57 `owner` int(11) NOT NULL default '0', 58 `files_owner` int(11) NOT NULL default '0', 47 59 `folder` int(11) NOT NULL default '-1', 48 60 `community` int(11) NOT NULL default '-1', … … 59 71 KEY `time_uploaded` (`time_uploaded`), 60 72 KEY `originalname` (`originalname`), 61 KEY `community` (`community`) 62 ) TYPE=MyISAM; 63 64 -- 65 -- Table structure for table `friends` 66 -- 73 KEY `community` (`community`), 74 KEY `files_owner` (`files_owner`) 75 ) TYPE=MyISAM AUTO_INCREMENT=17 ; 76 77 # 78 # Dumping data for table `files` 79 # 80 81 82 # -------------------------------------------------------- 83 84 # 85 # Table structure for table `friends` 86 # 67 87 68 88 CREATE TABLE `friends` ( … … 72 92 PRIMARY KEY (`ident`), 73 93 KEY `owner` (`owner`,`friend`) 74 ) TYPE=MyISAM; 75 76 -- 77 -- Table structure for table `group_membership` 78 -- 94 ) TYPE=MyISAM AUTO_INCREMENT=8 ; 95 96 # 97 # Dumping data for table `friends` 98 # 99 100 101 # -------------------------------------------------------- 102 103 # 104 # Table structure for table `group_membership` 105 # 79 106 80 107 CREATE TABLE `group_membership` ( … … 84 111 PRIMARY KEY (`ident`), 85 112 KEY `user_id` (`user_id`,`group_id`) 86 ) TYPE=MyISAM; 87 88 -- -------------------------------------------------------- 89 90 -- 91 -- Table structure for table `groups` 92 -- 113 ) TYPE=MyISAM AUTO_INCREMENT=1 ; 114 115 # 116 # Dumping data for table `group_membership` 117 # 118 119 120 # -------------------------------------------------------- 121 122 # 123 # Table structure for table `groups` 124 # 93 125 94 126 CREATE TABLE `groups` ( … … 100 132 KEY `owner` (`owner`,`name`), 101 133 KEY `access` (`access`) 102 ) TYPE=MyISAM; 103 104 -- 105 -- Table structure for table `icons` 106 -- 134 ) TYPE=MyISAM AUTO_INCREMENT=1 ; 135 136 # 137 # Dumping data for table `groups` 138 # 139 140 141 # -------------------------------------------------------- 142 143 # 144 # Table structure for table `icons` 145 # 107 146 108 147 CREATE TABLE `icons` ( … … 113 152 PRIMARY KEY (`ident`), 114 153 KEY `owner` (`owner`,`filename`,`description`) 115 ) TYPE=MyISAM; 116 117 -- 118 -- Table structure for table `invitations` 119 -- 154 ) TYPE=MyISAM AUTO_INCREMENT=10 ; 155 156 # 157 # Dumping data for table `icons` 158 # 159 160 161 # -------------------------------------------------------- 162 163 # 164 # Table structure for table `invitations` 165 # 120 166 121 167 CREATE TABLE `invitations` ( … … 128 174 PRIMARY KEY (`ident`), 129 175 KEY `name` (`name`,`email`,`code`,`owner`,`added`) 130 ) TYPE=MyISAM; 131 132 -- -------------------------------------------------------- 133 134 -- 135 -- Table structure for table `profile_data` 136 -- 176 ) TYPE=MyISAM AUTO_INCREMENT=2 ; 177 178 # 179 # Dumping data for table `invitations` 180 # 181 182 183 # -------------------------------------------------------- 184 185 # 186 # Table structure for table `profile_data` 187 # 137 188 138 189 CREATE TABLE `profile_data` ( … … 144 195 PRIMARY KEY (`ident`), 145 196 KEY `owner` (`owner`,`access`,`name`) 146 ) TYPE=MyISAM; 147 148 -- -------------------------------------------------------- 149 150 -- 151 -- Table structure for table `tags` 152 -- 197 ) TYPE=MyISAM AUTO_INCREMENT=7 ; 198 199 # 200 # Dumping data for table `profile_data` 201 # 202 203 204 # -------------------------------------------------------- 205 206 # 207 # Table structure for table `tags` 208 # 153 209 154 210 CREATE TABLE `tags` ( … … 163 219 KEY `owner` (`owner`), 164 220 FULLTEXT KEY `tag_2` (`tag`) 165 ) TYPE=MyISAM; 166 167 -- -------------------------------------------------------- 168 169 -- 170 -- Table structure for table `template_elements` 171 -- 221 ) TYPE=MyISAM AUTO_INCREMENT=7 ; 222 223 # 224 # Dumping data for table `tags` 225 # 226 227 INSERT INTO `tags` VALUES (6, 'elgg', 'weblog', 15, 'PUBLIC', 1); 228 229 # -------------------------------------------------------- 230 231 # 232 # Table structure for table `template_elements` 233 # 172 234 173 235 CREATE TABLE `template_elements` ( … … 178 240 PRIMARY KEY (`ident`), 179 241 KEY `name` (`name`,`template_id`) 180 ) TYPE=MyISAM ;181 182 -- 183 --Dumping data for table `template_elements`184 -- 242 ) TYPE=MyISAM AUTO_INCREMENT=25180 ; 243 244 # 245 # Dumping data for table `template_elements` 246 # 185 247 186 248 INSERT INTO `template_elements` VALUES (24787, 'weblogcomment', ' \r\n<li>\r\n {{body}}\r\n <p style=\\"border: 0px; border-bottom: 1px; border-style: solid; border-color: #000000\\">\r\n <small>Posted by {{postedname}} on {{posted}}</small>\r\n </p>\r\n</li>\r\n ', 1); 187 249 INSERT INTO `template_elements` VALUES (24786, 'weblogcomments', ' <hr noshade=\\"noshade\\" />\r\n <h3>Comments</h3>\r\n <ol>\r\n {{comments}}\r\n </ol>', 1); 188 INSERT INTO `template_elements` VALUES (24785, 'weblogpost', '<table width=\\"100%\\" style=\\"margin-bottom: 5px; background-color: #FFFFFF; border: 1px; border-color: #C5D3F6; border-style: dashed\\" >\r\n <tr>\r\n <td valign=\\"top\\" align=\\"left\\"> \r\n <a href=\\" /{{username}}/weblog/\\"><img src=\\"/_icons/data/{{usericon}}\\" border=\\"0\\" align=\\"right\\" style=\\"margin-left: 10px; margin-bottom: 10px\\" /></a>\r\n <p>\r\n <b>{{title}}</b>\r\n </p>\r\n <div style=\\"margin-left: 20px\\">\r\n {{body}}\r\n </div>\r\n <p>\r\n <small>Posted by <a href=\\"/{{username}}/weblog/\\">{{fullname}}</a> at {{date}} :: {{commentslink}} {{trackbackslink}}</small>\r\n </p>\r\n {{comments}}\r\n </td>\r\n </tr>\r\n</table>\r\n', 1);250 INSERT INTO `template_elements` VALUES (24785, 'weblogpost', '<table width=\\"100%\\" style=\\"margin-bottom: 5px; background-color: #FFFFFF; border: 1px; border-color: #C5D3F6; border-style: dashed\\" >\r\n <tr>\r\n <td valign=\\"top\\" align=\\"left\\"> \r\n <a href=\\"{{url}}{{username}}/weblog/\\"><img src=\\"{{url}}_icons/data/{{usericon}}\\" border=\\"0\\" align=\\"right\\" style=\\"margin-left: 10px; margin-bottom: 10px\\" /></a>\r\n <p>\r\n <b>{{title}}</b>\r\n </p>\r\n <div style=\\"margin-left: 20px\\">\r\n {{body}}\r\n </div>\r\n <p>\r\n <small>Posted by <a href=\\"{{url}}{{username}}/weblog/\\">{{fullname}}</a> at {{date}} :: {{commentslink}} {{trackbackslink}}</small>\r\n </p>\r\n {{comments}}\r\n </td>\r\n </tr>\r\n</table>\r\n', 1); 189 251 INSERT INTO `template_elements` VALUES (24784, 'databoxvertical', ' \r\n<table width=\\"95%\\" class=\\"profiletable\\" align=\\"center\\" style=\\"margin-bottom: 3px\\">\r\n <tr>\r\n <td align=\\"center\\" class=\\"fieldname\\">\r\n {{name}}\r\n </td>\r\n &
