Social Engine Category Modifications

As per advanced doc I have added an Expert Guarantee for the timeframe I'd like to either to that or agree here that any cancellation fees due to lack of delivery will be borne by you since I am paying 20% extra to cover the fees you will incur otherwise. ## Deliverables Modify existing Social Engine Code to allow admin to create additional display categories which will be populated from a database including the following features: 1) Administration a. Create New Category i. Name ii. Select/Enter Core Table from Database (e.g. db_Companies) 1. DB iii. Define Tab Content As you know I in SE you can develop groups/categories in a similar fashion to what I want to do, except you are not connecting to a db table, it is more for setting inputs for users. In my case I am using Admin to allow Admin to create the categories and connect to the db. **1. ** **Information Tab** a. Field Display Name b. Populate (Where [login to view URL] = X) 1. Field from Current Category Table (e.g. Companies_Name) 2. Field from another table with Where (e.g. using the Current Table/Field to match to another table/field. c. Type i. Text (e.g. Name, Company, etc) 1. List. When I do a 'Where' that can contain a list of items i.e more then one value. I'd like to be able to choose the delimiter: a. Comma b. Bullet Points c. Carriage Return (no bullets) ii. Multi-Line Text (varchar) Some fields from the db (varchar, text) that are loaded will already have HTML formatting in inherent in them which I'd like to be parsed as such. For instance 1. I have some Wikipedia Grabs 2. I added some basic formatting to some fields e.g. <b></b>, <a href></a>, etc 3. Where I have ; I need a carriage-return So the basic point is for multi-line I need it to obey HTML. iii. Image (?) d. Link A Standard option in SE where a value can contain a link to the record it loads from to load that record instead. For instance if I had a Field called 'Related Companies' and a Where such as [login to view URL] Where [login to view URL] = [login to view URL] (meaning all companies where the type matches current company type) then those fields would display with a hyperlink to those records. 2. **Members Tab** *I am not sure yet if I will have look-up tables or just access data from source tables themselves but this is an example of the options I'd have to indicate which members 'belong' to and populate this tab*: a. Where Members.Company=[login to view URL] b. Where MemberCompany_LUT.CompanyID=CompanyID 3. **Events Tab** Same concept as above a. Where Event.Occupation=OccupationID b. Where GroupOccupation_LUT:OccupationID 4. **Groups Tab** Same concept as above a. Where Group.Occupation=OccupationID b. Where GroupOccupation_LUT:OccupationID Note that 'Where' should also allow me to do 'Contains', 'Starts With' etc. ie..standard Where. **5. ** **Discussions/Forum Tab** **a. ** I am using a 3rd party-forum in part because it has an extension that allows it to be added as a tab to any group as an 'Instance'. We used this already (minus Instancing) in the old Solution. The key here is that each Category needs it's own Instance, e.g. Company Groups, Occupation Groups, School Groups, etc. so that we can customize content/links/etc later on. I can create a New Instance for each Category on my own. I think then what I need to do in this Tab is i. Choose the Instance to use ii. Define what constitutes a Forum Post in that Category that links to the current record like I do with the rest b. Another reason I used this Forum is that it has an extension I bought, Group-Forum Extension that allows it to be attached to any Group. That same code can be used to attach it your Category Code. The source code is included with the plug-in that according to the developer can easily be changed to make it an X-Integration Extension instead of a Group-Integration Extension i.e. in this case Category-Integration Extension **6. ** **Jobs Tab** One of three tabs that populates with data from third-party sites using their APIs designed to do so. Each API has already been created already by other coders and provided as an iFrame, so no API coding is required at all. The iFrames populate with the data the APIs are created to provide and each is awaiting variables to be pushed into it order to customize results which is what you need provide. Like the other tabs, I need to define a field or fields but in this case just need to map those to the awaiting variables e.g. TableName.FieldName=VariableName1 And the iFrame should then pull the [login to view URL] from the current record into that variable. That is all for now as I/we can worry later on about controls to modify the results, so right now it is just admin to allow me to map the variables. 7. **Videos Tab** Exactly the same as Jobs Tab. Coder made an API that populates with Videos from YouTube, you need to call this and provide Admin for me to declare [login to view URL] to map to variables 8. **Books Tab** Same as above with one difference; they provided me an admin to make custom 'sets': Which load different controls but the concept is similar we just add a step: I select the Set to use in the iFrame instead of default. I will provide the table where the sets are loaded and then all we need to do is: a. Select the Set from the list of available sets (I can also type manually if that is easier as long as you still query that table) b. Map the Fields from the Category Table to the variables that are in the set The Jobs API will have several named variables it is waiting for. All I need to be able to do is to name the fields in the given category_record that are mapped to those. b. Scan/Link/Tag I am providing here the php code the prior code made which was the beginning of this process. The purpose is to scan multi-line text fields in the record against various other tables for a match and then to create both hyperlinks to other records and to update a Tag Table for the given record. Right now what it does is scan text-blocks for other Table/Field Names and if it finds them it creates a hyperlink in that text block to that record. However I have little control over which tables it scans and it does not create tags table so I need it to do that. ? For each Category I need to indicate which Table/Fields to scan for hyperlinks with 'Where' where necessary e.g. o [login to view URL] o [login to view URL] where Type=[login to view URL] etc. ? Each match needs to update a Tags Table o Tag.Name=Name o Category=Category (of record being scanned) o ID=ID (of record being scanned) o Weight (a field existing in most tables from the found term o Acronym? (Y/N again from field found)