Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Version 1.13 + Editor/Password Logon

Quote Reply
Version 1.13 + Editor/Password Logon
I just installed the version 1.13 in my test directory, and will make it live in the next few hours at http://www.creepycards.com

You can also try it out on the FAQ site (link below) and maybe even contribute a valid (helpful) thread here <G>.

I've created a set of instructions to install the editor/password mod I made, and now have followed them twice, catching most problems.

It's _probably_ stable enough if someone wants to try it.

Check back for the list of things it does, but basically:

1) It makes the Editor & User logons work.
2) It can tell the difference between Users and Editors & Cheif_Editors.
3) It forces the User to logon before add or modify options are active
4) It presents an Editor with the links they can modify in pick-list form
5) It presents a User with a list of their links in pick-list form
6) It allows for a Chief Editor that can edit all 'pending' links, but not 'validate' them.
7) Removes 'validate' powers from any Editor, and allows it only for the Admin.
(This could probably be hacked into an option).
8) A few other odds and ends.
9) It reworks and reverses or changes some of the logic, so you need to know what you are doing (with Links SQL in general) to use these mods in the larger 'whole' of a planned growth (and compatibility with links 1.2?)

Note: I cut out a _lot_ of 'features' and stripped the routines down to the barest I could to make them work (that doesn't mean they are efficient, and that there is no 'dead' or redundant code, but it means that stuff is _not_ used).

You need to have _some_ idea of what you are doing to use this mod, since although the templates are fairly generic, you _will_ get tag errors, and such on your site until you edit them down to your needs (or modify your own templates to work with the changes).

_but_ the scripts and stuff work, I've installed it on 3 'new' sites.

Let me know if you'd like to try it.

I would rather a few people who _really_ want to use it try it before I post the code. Don't ask for the code unless you are going to install it. It just wastes my time, and you'll have to upgrade it most likely anyway.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Version 1.13 + Editor/Password Logon In reply to
I'd be VERY interested in this code. I remember widgetz had a mod like this for LinkSQL but it didn't work right.

Please notify me. You can at info@virtuetech.com

Jim Murray
PaintballCity.com
http://www.paintballcity.com
Quote Reply
Re: Version 1.13 + Editor/Password Logon In reply to
Ok,

It's probably easier if I zip up the files, and let people grab them.

Check the FAQ site in a few hours, the ZIP will be posted there.

It will contain the 4 scripts, the documentation with the subroutines and code changes, and the templates.

GENERAL DISCLAIMER:

Remember, if you can't figure out where the files go, or how to make them
run, you should _not_ be using this release.

If something doesn't work, _that_ I want to know.

READ THE DOCUMENTATION!!! It should go step by step of _everything_ you need to do to make things work (bugs excluded).



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Version 1.13 + Editor/Password Logon In reply to
I have a new version of the Editor/Password logon routine to be posted tonight on the FAQ site.

Minor fixes, and some additional template features.

Also, changed the template set from the Links FAQ to my more general site templates. They _will_ generate some tag/include errors on your site, used as-is, but I think they are over all cleaner and easier to see the code that actually does the work. The Links FAQ site follows GT's layout, and there are several (too many) layers of nested tables to make things clear.

I have followed the instructions on each site I've updated, and where I've had to deviate, I've changed the instructions, so they are "hands-on" not 'theoretical' install instructions.

If anyone is using this mod, please let me know if you hit any bugs or make any changes. I've gotten virtually _no_ feedback on it, and I can't belive it's so good as to work without any problems on everyones sites!! <G>



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Version 1.03: Now ratings tracked by username In reply to
I've added a new version of the program, to include allowing ratings only by registered, logged on users.

It uses a Rate_Log table, that tracks the votes, etc.

It does not use the Rate_Track table, so you can safely _empty_ that table and reclaim the space.

Currently, the way links calculates the ratings is pretty poor... really. So, there is no way to allow a user to alter their vote. _BUT_ the next release of this (or maybe with the Next Generation) There will be that capability, because the ratings will be calculated on the sum/average of the ratings for that link on each run.

_yes_ this is calculation intensive, but it's the only way to get real ratings, and no stacking.

There is a way to possibly cut the processing time, using intermediate tables, but I'm not sure where the savings will occur... possibly moving the calculations to lower-load times, and/or only processing ratings that have actually changed. But, none of this is in the current links, so any system is my own invention..... and I don't like striking out on my own for something that needs to be a part of the main system.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Version 1.03: Now ratings tracked by username In reply to
I would like to try the Mod. It sound excellent.

But when I found the Mod in your LinkSQL FAQ (http://pugdog.com/LinkSQL/pages/Detailed/127.html), I can not download the Zip file (http://postcards.com/FAQ/LinkSQL/files/editor_logon_03.zip), it redirect me to a invalid URL (http:////LinkSQL/pages//LinkSQL/files/editor_logon_03.zip). Problay you set the rewrite rule of Apache incorrectly.

Could your correct the minor error or tell me the new correct URL to download the Mod?

Thank you ofr your kindly helpness very much.

Quote Reply
Re: Version 1.03: Now ratings tracked by username In reply to
Yeah, between the two servers there are multiple rewrite rules that are incompatible in this case. I'll fix it.

Thanks.



PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ


Quote Reply
Re: Version 1.03: Now ratings tracked by username In reply to
I found it. the correct URL should be:
http://pugdog.com/LinkSQL/pages/files/editor_logon_03.zip

Thank you.

Quote Reply
Re: Version 1.03: Now ratings tracked by username In reply to
Are you saying the new links don't work?

I changed the links so that they should be correctly linked.



PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ


Quote Reply
Re: Version 1.03: Now ratings tracked by username In reply to
I mean the links in the URL: http://pugdog.com/LinkSQL/pages/Detailed/127.html still not work. I test it again just now.

But I found it by guess.