root/buddyloo/update.sql @ 736

Revision 736, 11.4 kB (checked in by d0nut, 4 years ago)

buddyloo now is a full open social container (by using google friend connect)
Line 
1DROP TABLE IF EXISTS wcf1_buddyloo_gadget_variables;
2CREATE TABLE wcf1_buddyloo_gadget_variables (
3  variableID int(10) unsigned NOT NULL auto_increment,
4  gadgetID int(10) unsigned NOT NULL,
5  variableName varchar(64) NOT NULL,
6  variableType ENUM('text','textarea','radio','checkbox','select','multiselect') NOT NULL,
7  variableDefault varchar(255) NOT NULL,
8  PRIMARY KEY (variableID),
9  UNIQUE(gadgetID, variableName)
10) ENGINE=MyISAM DEFAULT CHARSET=utf8;
11
12DROP TABLE IF EXISTS wcf1_buddyloo_gadget_variables_value;
13CREATE TABLE wcf1_buddyloo_gadget_variables_value (
14  variableID int(10) unsigned NOT NULL,
15  boxID int(10) unsigned NOT NULL,
16  userID int(10) unsigned NOT NULL,
17  variableValue varchar(255) NOT NULL,
18  PRIMARY KEY (variableID, boxID, userID)
19) ENGINE=MyISAM DEFAULT CHARSET=utf8;
20
21INSERT INTO `wcf1_buddyloo_gadget` (`gadgetID`, `gadgetTitle`, `gadgetCode`, `gadgetImage`, `gadgetDescription`) VALUES
22(1, 'Members gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678532311" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''HEIGHT''] = ''385'';\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderMembersGadget(\r\n { id: ''div-1228678532311'',\r\n   site: ''08725200924522186419''},\r\n  skin);\r\n</script>\r\n', NULL, 'The Members gadget allows visitors to join your site, sign in and out, see pictures of other site members, see pictures of their friends, explore other members'' profiles, invite other people to join your site.'),
23(2, 'Sign In gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678744328" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\nskin[''ALIGNMENT''] = ''right'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderSignInGadget(\r\n { id: ''div-1228678744328'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'The Sign In gadget allows visitors to join your site, sign in and out, and invite people to become members. It doesn''t have all the features of the Members gadget, but it can fit neatly in to a small space.'),
24(3, '''User'' Wall gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228680667275" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\nskin[''DEFAULT_COMMENT_TEXT''] = ''{$DEFAULT_COMMENT_TEXT}'';\r\nskin[''HEADER_TEXT''] = ''{$HEADER_TEXT}'';\r\nskin[''POSTS_PER_PAGE''] = ''5'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderWallGadget(\r\n { id: ''div-1228680667275'',\r\n   site: ''{$siteID}'',\r\n   ''view-params'':{"scope":"ID","features":"video,comment","docId":"{$userID}"}\r\n},\r\n  skin);\r\n</script>\r\n', NULL, 'Allows viewers to post comments, or links to videos on your site.'),
25(4, 'Review/Rate gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678871007" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\nskin[''DEFAULT_COMMENT_TEXT''] = ''- add your review here -'';\r\nskin[''HEADER_TEXT''] = ''Ratings'';\r\nskin[''POSTS_PER_PAGE''] = ''5'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderReviewGadget(\r\n { id: ''div-1228678871007'',\r\n   site: ''{$siteID}'',\r\n   ''view-params'':{"disableMinMax":"false","scope":"ID","docId":"{$userID}","startMaximized":"true"}\r\n},\r\n  skin);\r\n</script>\r\n', NULL, 'Allows viewers to rate a page, or a section of a page. Viewers can use this to rate videos, articles, books, photos, songs, or anything else you can imagine. You can put multiple Review/Rate gadgets on one page, one for each item you want viewers to review.'),
26(5, 'OpenSocial Demo', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678942573" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderOpenSocialGadget(\r\n { id: ''div-1228678942573'',\r\n   url:''http://www.google.com/friendconnect/gadgets/sample.xml'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'This is a sample OpenSocial application that demonstrates the basic concepts that an OpenSocial developer can use in their application.'),
27(6, 'LameGame demo', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228678995231" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderOpenSocialGadget(\r\n { id: ''div-1228678995231'',\r\n   url:''http://www.google.com/friendconnect/gadgets/lamegame.xml'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'Here is a silly game (lame) where visitors simply click as often as they can to increase their score vs. their friends and other members.'),
28(7, 'Custom Gadget', '<!-- Include the Google Friend Connect javascript library. -->\r\n<script type="text/javascript" src="http://www.google.com/friendconnect/script/friendconnect.js"></script>\r\n\r\n<!-- Define the div tag where the gadget will be inserted. -->\r\n<div id="div-1228679272840" style="width:100%;border:1px solid #cccccc;"></div>\r\n<!-- Render the gadget into a div. -->\r\n<script type="text/javascript">\r\nvar skin = {};\r\nskin[''BORDER_COLOR''] = ''#cccccc'';\r\nskin[''ENDCAP_BG_COLOR''] = ''#e0ecff'';\r\nskin[''ENDCAP_TEXT_COLOR''] = ''#333333'';\r\nskin[''ENDCAP_LINK_COLOR''] = ''#0000cc'';\r\nskin[''ALTERNATE_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_BG_COLOR''] = ''#ffffff'';\r\nskin[''CONTENT_LINK_COLOR''] = ''#0000cc'';\r\nskin[''CONTENT_TEXT_COLOR''] = ''#333333'';\r\nskin[''CONTENT_SECONDARY_LINK_COLOR''] = ''#7777cc'';\r\nskin[''CONTENT_SECONDARY_TEXT_COLOR''] = ''#666666'';\r\nskin[''CONTENT_HEADLINE_COLOR''] = ''#333333'';\r\ngoogle.friendconnect.container.setParentUrl(''/'' /* location of rpc_relay.html and canvas.html */);\r\ngoogle.friendconnect.container.renderOpenSocialGadget(\r\n { id: ''div-1228679272840'',\r\n   url:''{$GADGET_URL}'',\r\n   site: ''{$siteID}''},\r\n  skin);\r\n</script>\r\n', NULL, 'Use this to generate the code snippet that you need to add a custom OpenSocial gadget to your site.');
29
30
31INSERT INTO `wcf1_buddyloo_gadget_variables` (`variableID`, `gadgetID`, `variableName`, `variableType`, `variableDefault`) VALUES
32(1, 3, 'DEFAULT_COMMENT_TEXT', 'text', '- add your comment here -'),
33(2, 3, 'HEADER_TEXT', 'text', 'Comments'),
34(3, 7, 'GADGET_URL', 'text', '');
Note: See TracBrowser for help on using the browser.