Gossamer Forum
Home : Products : DBMan : Customization :

Current Status:DBMan's Marriage with Links2

Quote Reply
Current Status:DBMan's Marriage with Links2
Because of the interest I have been getting on this subject, I will post in this thread any current ideas that both I and others might have on the Current Status of DBMan's marriage with Links2.

Note that this mod/project can also be used for other Links/Dbman needs in bits and pieces. Such as just allowing user (on-the-fly) deletions of their links or data, etc. Just use your imagination for more ideas Smile

OBJECTIVE of project:
To disturb as little as possible, the current integrity of both DBMan and Links2 in their current operation. Allowing both DBMan and Links2 to maintain their present identities and features and to design mods in such a way that will allow the features of each to be shared. (Hence the word "Marriage" as opposed to "Merge" in my project title Smile

REASONS for using DBMan/Links2 together:

**You get ALL the wonderfull features of both DBMan and Links made available to you to use as you need them!

**No more waiting for your favorite mod(s)to be developed for one or the other. Many times a mod is available in either DBMan or Link but not in both.

**You can have a choice of either on-the-fly instant update of your database (as DBMan performs) or you can have admin validation before update (as Links performs) or mix and max both based on your needs.

**Search Engines Cannot "see to list" on-the-fly generated web pages or databases. Increase web traffic with HTML generated web pages!!! (as Links performs).

**Increase or Decrease your Database access security to what ever level you need based on DBMan's available features and/or Links available features.

**Need "Templates" for DBMan? Until this option is added to DBMan you can use the Links2 Templates feature. Use the Templates on the Links2 side to perform your actions on the DBMan side by accessing DBman.cgi.

** MANY more to come as I think of them throughout developement.

[The latter are ideas and food for thoughts only Smile]

Please feel free to include your ideas and needs for this project in this thread. Because of time constraints I will not answer most feedback (so I thank you in advance for your input and ideas). However, I will read all input and use what I can. This thread will be updated as needed so you can follow our current progress. Smile

Uploaded text versions of all modules that are changed will be at:

http://www.site-city.com/dbman_links2/

07-30-99: Do a feasibility study on using DBMan as the front end for links2 add, modify, delete, on-the-fly and instant links database.

08-01-99: Research shows DBMan will do all (and more) than is required for this project.

08-04-99: First step is to install DBMan .cfg with required settings to access the heart of links2... links.db, linksid.txt, and categories.db. COMPLETED Frownongoing)

08-07-99: Need to make DBMan work with Links2: Categories.db so DBMan will display the links2 Categories field in forms properly (a selected list). COMPLETED: 08-12-99 (See thread http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000693.html for details.)

08-12-99: Research the "Authorization Options" in DBMan and set them so Registered Users can add, view, modify, delete only own records (based on userID). Use Links2 side (templates) to allow user to view and search Links2 database (no password or userID required on this end of access). COMPLETED: see (http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000695.html)


Thanks
TimRyan



[This message has been edited by timryan (edited August 22, 1999).]
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
08-13-99 Day; Think'n and Toy'n on the DBMan/Links Templates access. (should I or shouldn't I? I wanna make it plain and simple as can be Smile. Night; Just got a late night idea Smile

UPDATE:08/29/99..
MOD completed for beta test for DBMan Templates ...
http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000833.html

Bug fixed on url.db update/add for DBMan/Links2 Mod ...
http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000829.html

Need help/ideas on parsing the userid....
http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000820.html

MOD for dbman Templates online sneak peak...
http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000814.html

Who Is interested in a Templates MOD for DBMan?...
http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000778.html

TimRyan


[This message has been edited by timryan (edited August 29, 1999).]
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
Greetings TimRyan!

We currently run the Classified Ads links and have been looking for many of the things you have mentioned. I have indicated an interest to Eliot about his DBMan classified however he has quite rightly suggested we should look at your finished product as well as his.

Room on our server is not a problem and we do like the ease of using links and agree with both you and Eliot that especially with a classified Ads engine there are a lot of features missing which DBMan already has.

We are no perl programmers - just good at follwing instructions to get these scripts running.

We will await the final outcome of the "marriage" of links with DBMan and go from there.

Many thanks for without people like you and Eliot and many others in these forums us novices would not end up with exceptional products we can use on our sites.



------------------
http://www.nzcid.godzone.net.nz
New Zealand Christian Internet Directory


Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
08/19/99:
Change Links2 templates Category.html and Home.html so the "add link and modify links" are directed to DBMan.cgi (ie,..
/dbm_db.cgi?db=dbm_db&add_form=1
/dbm_db.cgi?db=dbm_db&modify_search=1

This allows Login Users to make "on-the-fly" add and modify to Links.db.

I also, modified DBMan.cgi to update the Links2 "url.db" with the url used by "jump.cgi". Keeping in mind that the next links build will rebuild the entire "url.db" I did not do a mod as yet that will also update url.db on a modify or delete. But at least the links will work with jump.cgi immediately upon add.

For those interested in "toying", I have uploaded my daily R&D to:
_______________
http://www.incorp.net/bizsearcher/cat/
Notice the | Add a Site | Modify a Site | are links to DBMan... with the other links (including the categories) eventually pointing also to DBMan where needed.
_______________
with current text versions of changed modules uploaded at:
_______________
http://www.site-city.com/dbman_links2/
_______________

UPDATE:08/29/99:
See: MOD: On-the-fly links.db access and add/update/modify/delete using DBMan as front end...
http://www.gossamer-threads.com/scripts/forum/resources/Forum3/HTML/002951.html
for the stand-alone mod for other addtions to this mod.

TimRyan



[This message has been edited by timryan (edited August 20, 1999).]

[This message has been edited by timryan (edited August 29, 1999).]
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
 

timryan:


I started looking into this myself last night.. and today I found your post.. I'm no perl guru, but if I can help in anyway, let me know.. I'm good enought to bug test, even write / mode code.. I think this is one of the best ideas for both scripts yet!

I also have an idea.. To incorporate another script into links ( Newspro ) .. Building news based on SECTIONS.. Anywho..



------------------
The Crowe crowe@chareter.net
www.lit.org Seriously Modded Links 2.0 For Anyone interested in Writing or online Fiction!


Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
TimRyan,

Great to see that you are still working on it. Need any help yet? Let me know.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
Looking over the file layouts, it appears that to make Links "DBman-ready" the only field one would need to add is Userid.
Code:
Userid => [15, 'alpha', -2, 15, 0, '', '']
Even if there is only a slight possibility that you'll be using DBman and Links together, it may be a good idea to add the field. Anything else we should catch early-on?
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
bjordan, you make a good point Smile. In fact, I usually ad a couple "future" fields in my database files when I think of it. There is nothing more that will impact a project than having to change the file layout mid stream Smile

I will try and post here any other fields one might add "now" for future use. Be aware of course this will make your data base a bit larger in size over time. So use this "future" idea with caution.

Another field I might add is an extra "Date" field. One for current date and another for some other date you might use later on for something. [update:yes, thanks that was it; a "Date_Expired" field. Smile ]

Because the password is in another file I do not think we will need that field. But, I think I saw a mod somewhere that might require such a field also. That is if someone decides to use such a mod. I also saw a mod somewhere that encrypted the password. That is another feature we should ad in this project.

Anyone else? Feel free to suggest fields here.

Personally, as I have progressed with this project, I find many new ideas openning up daily. There are just not enough hours in a day to work on them and do the docs and pass the changes around. Smile

Also, thanks to all on the "help" requests. I hate documentation, and because I/we are keeping everyone up to date (almost daily) .... the details are almost becoming a jigsaw puzzle Smile So anyone and everyone, feel free to copy/use and put together what you can where ever you want with hopes to put it all in one place. (Maybe JPD's place (hint hint... Smile)

One final note: Please let me know the URL of where you might try any of this project so we can see it in action and iron out the wrinkle in our docs and code. This helps us formulate new ideas Smile I would like to put Switches in the cfg that turned on/off other mods and options as the user requires them. (another phase of this project Smile)


TimRyan


[This message has been edited by timryan (edited August 20, 1999).]
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
  
Quote:
Another field I might add is an extra "Date" field. One for current date and another for some other date you might use later on for something
Yes. I have a DBman custom mod (I should say developed for me, not written by me) that performs something similar to the "Expirator" function in Links, except it uses the actual date of expiration and not number of days. If I remember correctly, it transparently purges the flatfile whenever either the Admin or any User logs on to work in the file. I'm not proposing this as a Mod --more of a reason to stop now and think ahead a bit.

Bob

ps Links and DBman are not the ONLY flatfile handlers out there (though they are the best). I've seen a few that require a closing pipe just before the line break. You'd need a "dummy" DBman/Links field at the end of the record if you're planning to point one of those third-party scripts at these flatfiles.

[This message has been edited by bjordan (edited August 20, 1999).]
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
UPDATE/MOD:
Note that this mod, though for the DBMan/Links2 Marriage project, it (so far) only requires changes to the Links2 side.

08-20-99:
1. Decided to use the User-Friendly Html.pl because it has better login, sign-up, etc.(see http://jpdeni.com/). At least until I get back to the "DBMan Templates project".
UPDATE:8/29/99: I will put a switch in db.cfg that will give option to use templates.pl or html.pl

2. Making mod to Links2 so the Links2 build will generate all category links that points (URL) to Links2 search.cgi?Category=whatever_category/you/want.... instead of pointing to category directory. Must put in a switch that senses $dbm_build_root_url is set. ["" means use as is and "anypath" means use it]. Notice that by using the links search.cgi for the dbman searches of data base it allows multi pages with now extra mods.
UPDATE:08/29/99.. I really must explain this better Smile Because this is a mod to make the home page of links2 categories point to your path../search.cgi?Category=Business_and_Finance. Using links search.cgi to pull out on the fly links.db(and/or dbman) records.

Decided to leave the resulting "Category" link (at Top of link results) so it still point to the current nph_build directory URL. This could be made to also point to a new search but, if left alone will...
1. Help search engines spider rest of html built pages.
2. Allows for a more flexibility in creating search/display variations.
3. Importanly, the searcher still has a way to see the subcategories by clicking on the category link. (Have not yet developed the code to make search.cgi display subcategories)
UPDATE:08/29/99... found this to NOT be a good idea. Instead, I will make nph-build make a second home page (index1.html) that will point to and use search.cgi for on the fly. Then use index.html for the html build version so search engines can find us.

I am sure one could also link to a mod that has a more flexible/creative search routine.

UPDATE:8/20/99 New Mod Fixes Comming Soon for this. I did not like the test results so I have removed these for now. Smile You can find my current results and testing at:
http://www.incorp.net/bizsearcher/cat/

Just swipe your mouse over the links index and categories to see they all go and work upon DBMan instead of Links Html Directories.

I plan to create another index1.html (Called a "Database Archive") that will link to directories/html that are generated from the Links Build now. This will allow access by search engine spiders and will also have links to index.html (Called "Current Master Database Access") front dbman pages.


NOTE: At this session, this mod does not effect the "What's New" or "What's Cool" pages.

For those of us who like to see the effects of this mod, place your mouse over the category to physically see the category URL change and where it points.
UPDATE:08/29/99 This is all online at:
http://incorp.net/bizsearcher/cat
and
http://incorp.net/cgi-bin/bizsearcher/dbm_db.cgi (for direct to the dbman side)

TimRyan


[This message has been edited by timryan (edited August 29, 1999).]
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
08/24/99:
Today went well... completed the some front end routines/templates. But with over 20 templates (to test, code, then make as templates) I still have many to convert and then place the code in
dbm_templates_html.pl
Will keep you posted. The theory tests well and the current code/templates for login, add, listall, and delete test well. I just have to do the error routines/templates for those also.
TimRyan
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
can i ask what you are trying to do?

i don't see much of a change other than a few things like UserID.. if you are running them on templates.. then you only need to add a few subs in db.cgi and use templates.pm

jerry
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
OK... Spent the day cleaning up some and doing some more error templates.
http://incorp.net/cgi-bin/bizsearcher/dbm_db.cgi

has the current version for you to look at and play with. For those who do not want to play you can take a quick look and use "author" as both password and Userid. THen just do a "list all" etc. do see the new templates and feel free to play. Just please do not delete to many author records.
Thanks
TimRyan
PS. Hi widget... The top of this thread pretty much explains it all. Let me know if you have any specific questions. Thanks for the interest Smile
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
UPDATE:08/29/99:
All DBMan templates are complete and online at:
MOD completed for beta test for DBMan Templates ..
http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000833.html

Next project is to do some more doc/mod and cleanup where needed. Also, will research the email options mentions in the latter thread.

Also, note my many "UPDATES" above in the "TimRyan" parts of this thread.

Added to my DO LIST:
1. Make homepage show ALL categories with links pointing to search.cgi?... Now only the main categories are there. Not good Frown

TimRyan


[This message has been edited by timryan (edited August 29, 1999).]
Quote Reply
Re: Current Status:DBMan's Marriage with Links2 In reply to
TimRyan,

Great job! I will be looking over your templates in the next few days.

Did you read my response regarding email options between LINKS and DBMAN in the other Thread in this forum?? Let me know what you think.

Thanks.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us