Gossamer Forum
Home : Products : Gossamer Links : Discussions :

URGENT: LinkSQL 3.0 suggestions

Quote Reply
URGENT: LinkSQL 3.0 suggestions
I was about the post few weeks back of some very important fixes etc that are needed in new version.
I am still using latest LinkSQL 2.X version.

Here is some very useful, suggestion... I hope it's not too late to post for new version.
I have been using paid LinkSQL for about 6 years now.

Here are some suggestions that will really help (not in any order)
  • Link validation like when user submit... it goes to next screen (page) with confirmation suggesting... while linksql checks the link for any problem... like 404..403 etc... shows up to the user... asking to correct it.
  • Limiting user to add suppose X number of links in 7 days etc.
  • blocking duplicate url entries etc... not really exact but like... http://www.xyz.com/abc.htm or http://www.xyz.com/xyz.htm and case type like http://www.xyz.com or http://www.XYZ.com
  • (important) Allowing user to add links only at sub-categories instead of main category like... xyz\sub_xyz (allowed), but posting to xyz\ (not allowed)
  • problem with latest version of 2.X where linkSQL gets stuck on links (random every time) while checking their status... & although shows 404, 200 etc after linksql verify page finishes. But re-running the verify.. shows some come back & still keep checking over & over the same links (like say using 15 days old links etc). I even manually went to MySQL editor & changed status for all to same checked all today)... then run it... shows 0 links to be checked(normal)... then 15 days later... it start checking the links... somewhere while checking it gets stuck and keep the link as unchecked... & every time... running verify it checks the check even shows 200 or 404. I think LinkSQL loose track of the links it checks & random do that. btw... I have to run at night in cron... as after check around 50 +/- links it stops & shows results. so I have to set cron to run that script every 15 mins 5-6 times at night of 15 days old links... btw I have about 4000-4500 links using MySQL.
  • Sometimes... link is fine... but verify shows -4 - Could not connect
  • Now comes the managing part of LinkSQL... mainly fighting spammers (link should have link next to it where admin clicks & shows all links under that user helps to delete if the user is a spammer.
  • I have not been able to setup Payment method (i prefer paypal myself). Very confusing, I had some customize some result pages in template... now is their easy way, where payment method is added without deleting all custom pages & loading new linkSQL or manually going over each page in template to added payment. if payment method connect be automatically inserted in these templated... then please write some doc/pdf file... guiding step by step on what pages to modify to enable payment method... as loading all default templates & then re-customising is very.... I mean very long process for me.... any suggestions on this. Maybe also adding doc file for step by step to setup method all together. I tried few times in admin page... I just gave up.

Anyway, one strong point I see is LinkSQL search is near prefect... really good searches as well as very strong & reliable search engine. keep it up Smile
Quote Reply
Re: [jasy007] URGENT: LinkSQL 3.0 suggestions In reply to
Sorry, but it's a little late for adding features since we're looking to release next week. Note that some of the features you speak of have already been added. Take a look at the changelog. We will take note of this thread and may add some of these features into a future version.

Adrian
Quote Reply
Re: [brewt] URGENT: LinkSQL 3.0 suggestions In reply to
Hi brewt,
Thanks for reply... some of the above mention also have bugs & some new features. Can you at least fix the bugs... I hope those if not fixed so far will be taken into consideration.

thanks!
Quote Reply
Re: [brewt] URGENT: LinkSQL 3.0 suggestions In reply to
Hi

There are definitely some issues wrt GT of Glinks 3:

It breaks few things in Gossmer Mail:

http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=279687

All by itself, when Community's GT are also loaded, then column update from admin in Glinks3 also fails with error:

http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=279471

This gets eradicated by symlinking to Glinks 3 GT, but Gossamer mail never gets out of the error syndrome once Glinks3 GT libs are in play... There is no problem with loading sequence .. it follows the recommendations from GT as in Announcement forum...

Confirm please.

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

Last edited by:

HyperTherm: Apr 3, 2005, 2:22 PM
Quote Reply
Re: [jasy007] URGENT: LinkSQL 3.0 suggestions In reply to
The link validation/link checking for duplicate and similar URL's can be done in a plugin. Just like the spider_url for adding in found meta data, there is a plugin that checks for duplicate/existing url.

The problem comes from shared hosts that provide webspace to users. What constitutes a duplicate url?

http://shared.webhost.com/useraccount/
http://shared.webhost.com/useraccount/index.asp
http://shared.webhost.com/useraccount/index.html
http://shared.webhost.com/
http://shared.webhost.com/index.html

Which of these are duplicates? On some servers, they will ALL point to the same content page. On other servers, they could all be different, or more likely point to 2 completely different content pages.

Using 'LIKE' to search the database will get rid of the www.xyz.com vs www.XYZ.com problems.

What would be cool, and I've been meaning to add it in, is to alter the admin "Check" code to do a "LIKE" search for the main webhost, then bring up a pop up window of all found URLs and ID's. The URL would link to the site, the ID would link to the database entry.

Doing something like that on the Add page, would not stop (should not) stop a user from adding a similar page, but should bring up a notice that the following URLs have already been added to the database.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] URGENT: LinkSQL 3.0 suggestions In reply to
In Reply To:

What would be cool, and I've been meaning to add it in, is to alter the admin "Check" code to do a "LIKE" search for the main webhost, then bring up a pop up window of all found URLs and ID's. The URL would link to the site, the ID would link to the database entry.

Doing something like that on the Add page, would not stop (should not) stop a user from adding a similar page, but should bring up a notice that the following URLs have already been added to the database.
Quote Reply
Re: [loxly] URGENT: LinkSQL 3.0 suggestions In reply to
hmmm.... here is something ... I found workaround... install plug in for duplicates.
so... some of them were blocked

for rest like entering too much description... bla..bla etc
went to database set description field to XX spaces. So, when someone submit, they are happy with long list... & everything shows up as they wanted, but in fact only XX amount is added. (original ideaWink)

Fixed, users using ALL CAPS... in heading or disc etc... found plug in to correct it (great plug-in)

looking for a way to mark the user a spammer & just block any submission from him, w/o letting him know. that way he don't create new user & continue the BS addition... (shows the spammer as if everything is OK with submission on his side.)

that is true...
ISP sites will be a issue for duplicates... don't see much help unless some clever idea to detect it... like
submit...
www.xyz.com
www.xyz.com\user_folder\
are fine.

where as...
www.xyz.com
www.xyz.com\abc.htm
www.xyz.com\def.htm
not fine... so blocking multiple files at same level are blocked (give some help)

I hope this makes sense.
Quote Reply
Re: [jasy007] URGENT: LinkSQL 3.0 suggestions In reply to
Quote:
for rest like entering too much description... bla..bla etc
went to database set description field to XX spaces. So, when someone submit, they are happy with long list... & everything shows up as they wanted, but in fact only XX amount is added.

Something more meaningful of this i had seen on zeal.com as an editor there few years back. A nifty looking progress bar which progressed as one typed and then when the limit was reached the user could no longer key in anything.

not sure if it was javascript or something else, but it was good.

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Quote Reply
Re: [HyperTherm] URGENT: LinkSQL 3.0 suggestions In reply to
Here's a javascript example:

<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function textCounter(field, countfield, maxlimit) {
if (field.value.length > maxlimit)
field.value = field.value.substring(0, maxlimit);
else
countfield.value = maxlimit - field.value.length;
}
// End -->
</script>

Description:(Limited to 150 characters)
<textarea wrap="virtual" name="Description" cols=40 rows=4 onKeyDown="textCounter(this.form.Description,this.form.remLen,150);" onKeyUp="textCounter(this.form.message,this.form.remLen,125);"><%if Description%><%Description%><%endif%></textarea>
<input readonly type=text name=remLen size=3 maxlength=3 value="150"> characters left
Quote Reply
Re: [afinlr] URGENT: LinkSQL 3.0 suggestions In reply to
cool afinlr ... make sense, I know their are lot of ways to skin the sheep... anyway anyone able to make canAdd method work( http://gossamer-threads.com/...search_string=canAdd )... if so, please let me know exact steps needed to implement the feature...

I tried myselft didn't work, even created the add a column to Category table named 'canAdd' ENUM(Yes,No) with default 'yes'

no luck