Hokay,

I posted in the Gossamer Forum forum asking if anyone could think of any plugins that they'd like me to create and I was asked about MyLinks for Links SQL so I decided to post here.

I'll consider restarting this project as there seems to be several people requesting it.

I'll just need people to give me a clear list of features they'd like to see.

This will be a paid plugin as the last version was around 100kb in size which obviously takes a lot of work.

Hi Paul,

A few ideas/suggestions:

1. Allow the user to organise links in folders and move items around - sort of like the browser.cgi - so I could ex. make a new folder - name it 'constrauction' and then dump links there

2. Possibility of working across Links installations so you can bookmark items across installations (perhaps even products - ex. save a thread from a forum)

That's a start

Cheers
Klaus

---

http://www.ameinfo.com

Hi,

Thanks. Folders is something I'll add. Not sure about the second suggestion though. In order to bookmark a thread from Gossamer Forum or save a link from another Links SQL installation you'd have to gain access to the database for that installation to retrieve the details of that bookmark which would require usernames and passwords and creating a new GT::SQL object and I think it may get a little messy.

I'm adding the ability to let users save custom bookmarks so that may implement your suggestion *in a way* as it will let you save bookmarks relating to other sites.

Hi,

Well with Community in place will it not solve the username/password issue at least?

Klaus

---

http://www.ameinfo.com

Perhaps, but then not everyone will be using community.

I am very interested in this plugin, and would be very eager to purchase it should it be released.

Possible changes:

1) Upgrade script from old version. I think lsql 2.12 brought in the enumerated ID's for the lsql_Users table, so I guess any new script will now be using the user ID rather than the username in the lsql_mylinks join table. I'd like to be able to import/convert my existing lsql_mylinks to use the new system.

2) I don't think that the grouping worked properly in the old version. No matter what the grouping was set to, you always had the full category path above the link. I'd like to turn this off or put it in folders in the new version.

3) Perhaps some integration with the pagebuilder plugin, so that you can have a proper title_linked on the mylinks pages.

4) Given that you can already update certain user settings in the mylinks script, it might also be useful to be able to update contact details and passwords via the script.

Maybe a community version on top then?

Klaus

---

http://www.ameinfo.com

Thanks for the suggestions. The new plugin can be installed alongside the original plugin as the plugin file names and templates are different to the original, so whilst you set up the new version you can leave the old one installed. I will make a seperate upgrade script instead of building it into the plugin.


I've not used this plugin before so am not sure what you mean exactly?


Ok.

Paul,



Are you starting "now"? Do you have any idea of how long it will take you?

What will it coast (I have already payed for your last version)?

Also, I remember deleting a user from the lsql database and that user's links are still listed. Can you fix this in the new one?

--------------------------------------------------------------------------------
Quote
--------------------------------------------------------------------------------

Perhaps some integration with the pagebuilder plugin, so that you can have a proper title_linked on the mylinks pages.

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Quote
--------------------------------------------------------------------------------

I've not used this plugin before so am not sure what you mean exactly?

--------------------------------------------------------------------------------


The pagebuilder plugin allows you to create pages with "breadcrumbed" navigation as such:

Home > Help Pages > How to Use X > More Info > Details

It would be quite nice to have similar functionality in the mysqlinks script, particularly as it may constitute a large section of the site in some instances. So, for example, on the mylsqllinks main page you can have as the navigation:

Home > My Links > Main Page

and then for the other pages:

Home > My Links > User Settings and Options > Update Contact Details

and for the categories

Home > My Links > Information and Technology > Other Custom Folder > Page 2

etc etc. Just increases usability, makes navigation more intuitive, and makes everything look more professional.

---

Also, another thing, that may or may not come under the mylinks plugin. There has been some mention of need for improved category support. Some people (including me) would like to link parallel categories together and develop some way of managing this.



For example, if you had a database of website design related sites, you might have a taxonomy constituted as such:

Home > By Region > United Kingdom > Flash Specialists > Page 1
Home > By Region > United States > Flash Specialists > Page 1

as well as

Home > By Speciality > Flash > United Kingdom > Page 1
Home > By Speciality > Flash > United States > Page 2

things become more complex when you have additional categories and properties of links. It would be useful if you could just define some fields or join tables as such:

Join Table 1 --> Country LinkID
Join Table 2 --> SpecialityID LinkID
Join Table 3 --> PriceRange LinkID
Join Table 4 --> NumberOfEmployees LinkID

Then, the plugin would automatically update the catlinks table and allow you to have a much more sophisticated directory and category structure. If you could make a decent UI for this and make it intuitive there should be some demand for this, as it seems like a logical necessity of any directory. Or perhaps not.

Yes, I started earlier this evening.


Currently not. The basic mylinks functionality shouldn't take more than a few days to finish, it is just all the extra features that may take some time and also the templates are time consuming, more so than the code on occasions. Currently I've added shells for 11 templates and I expect a few more will be needed so you may be looking at 15 templates. I hope to at least to have the bulk done within two weeks. This may be less if I get time to do lots of work on it.


I'm not 100% sure yet on the price. It depends on what features are added along the way amongst other things. I'd say defintely under $75. I will deduct $40 for anyone who purchased the original mylinks.


Yes this was an issue as I forgot to add foreign keys. This will be fixed.

I'll make the breadcrumb available as a tag so it can be removed for those not desiring it.

So far the features are:

Saving directory links
Saving custom links
Recommending links to friends
Folder support
Links SQL profile editing capabilities

Paul;

Fantastic! I am very happy you are starting this back up. You can count me in for a purchase. I am requesting the following features.

Feature Suggestions:

1. Link Notes/Comments/Reviews

- Sometimes we later forget why we have bookmarked a link, also when emailing others these links, it may be good to tell them exactly what is special about them, or to pass on a short summary/review. A single comment field may suffice.

2. Link Checking

- After the links are in the system a while, likely there would be bad ones.

Before looking stupid by sending out a email saying how great these broken links are, it would be fantastic for a quick link check to give us the edit/delete/keep options.

Thanks for the ideas. I'll see what I can do :)

I'd love to see this too, working alongside Community.
Piers

I just upgraded to 2.1.2 and started making the plugin using the user id in the mylinks table but I just took a look at the users table and I don't see an ID column?

Paul,

Glad to see you back. You are one of the more insightful people here (There are many) and I've learned a lot from your posts. I'm not sure if this has been said before but adding a catagory (and then all of its subcatagories) would be nice.

I was also toying a 'quick add' idea. A rundown - Remember when a bunch of you guys were on the '404 error pages' postings. Well, we have a catagory in our directory for '404 error pages'. It would be nice, to email a catagory to someone, with a 'quick add to MyLinks' icon. Just a thought.

Howard J. Brubaker

Sorry for wasting your time, I assumed after Alex mentioned that such a change (I think) that it would be implemented, as it would be needed for community. I guess that it hasn't, and, as such, no import script is necessary.

>>>Glad to see you back. <<<

He never really went

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

By this do you mean you'd like to bookmark categories or bookmark all the links within a category?

I guess the answer to that will clear up this point also...

It's ok, I hadn't gotten too far into the coding. Perhaps the ID column is added when you install community?

I was thinking about getting my plugin to add in the ID column to the users table....any thoughts on that?....maybe it would be easier just to keep using the username. It poops on the idea of relational databases a little but that's Alex's fault for not having an ID column

Hmmm,

I think bookmarking a catagory would make more sense. If you bm all of the links and choose an incorrect catagory in error you'd have potentially thousands of links, plus not really knowing where they were from.

hjb

I'm not sure if community adds the ID column. Nevertheless, in the long run the ID column is going to be a necessity, and as soon as it is added in the mylinks plugin might has problems, given that users may be able to alter their username as in gforum. Perhaps it might be useful to check with Alex?

Personally, I would find this very useful.

Andy,

I meant in developing the MyLinks plugin.

I'll have to hire an email writer if you guys nitpick me like that. :)

hjb

>>>I'll have to hire an email writer if you guys nitpick .me like that. <<<



Its a good thing he started work on it....otherwise you would have been left with my programming skills on a SQL version of my MyFaves

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Yeah I'll contact Alex with a few questions

Phew, looks like I saved the world from disaster then =)

Hi,

Ok I've spoken to Alex and he has recommended I carry on using the username field.

Hmm. What was his reasoning?

He said there are no immediate plans to add an id column to the Users table and he said getting my plugin to add such a column would cause problems.

This is what I have so far...is it looking ok?

It looks great. Keep up the good work!

Looks great Paul.... let me know if/when you need beta tester :-)

Klaus

---

http://www.ameinfo.com

I guess I should make some backups...I'd hate to lose this:

Looks as though a great deal of work went into it.

Paul, could you add the functionality so we can decide what to call the mylinks script when we install it? (So, during the install there is a text box where one can alter the name of the script, so it can be MyFavouriteEquities.cgi rather than mylinks.cgi).

You can change the name (its mylinks2.cgi by default) - you'd just have to update the hyperlinks in the templates.

Adding a plugin option is a possibility but it would mean I'd have to load that option for each template - it would probably be easier done with a global....or one other solution is for me to change all hyperlinks to "?" which takes the current file name being viewed as the link target.

Do people still want the functionality to make favorites lists public or can that be left out?

Small update.

So far the features implemented are the basic mylinks features such as adding links and deleting links. I've also added the folder related code. Admin can set a limit for the number of folders a user can make and also can set a total for the number of allowed saved links. Links can be moved between folders and when deleting a folder you can delete all links or move them to another existing folder. When adding new links to your mylinks account the link will be placed into a default folder ready to be moved by the user to their desired custom folder. I *may* add a user option to let them set a folder of their choice into which new links will go by default but I'm not 100% sure there is a need as the default folder works exactly the same. By the way, the default folder name and description are also customizable by admin.

The feature I implemented today is link recommendations. You can recommend a link to one or more friends and can provide a custom message to each friend. I've setup the html and perl code to allow you to add extra friend fields, so there is no limit to how many people you can send recommendations to. the email for the recommendations is template based, as is pretty much everything - I've tried to make it as easy to customize as possible.

As you realise, it's no great problem, but just makes everything a lot faster when installing.

Everything sounds really good

Personally I like this feature - people tend to be quite nosy! If they can see other people's folders it may make them more likely to go through the sign up process to get access to their own folders.

Don't worry though if it is a lot of work - I'd rather see the plugin asap!

Laura.
The UK High Street

I am not using it in the current version - so it can be left ou as far as I am concerned

Klaus

---

http://www.ameinfo.com

Looking good Paul! Glad to see this one back on the burner.

It's nice to see you've got some of the features discussed in the last Mylinks thread already working ..
http://www.gossamer-threads.com/...tring=Mylinks#220470

As far as the Public/Private functionality goes I would like to see it in there. I agree with Laura, it gets people to sign up.

Either way, you can count me in for the upgrade.

Good luck with the plug man.

How's everything going Paul? Are things progressing well?

Yes things are going well. The plugin is about 85 kb in size so far (compressed) - that should give you an indication of how much I'm working on it =)

Although it's not an accurate measure, the old version that I have is 14.9 KB.

Seems like it's going to be a very impressive plugin

Hmm which one do you have?...the last one was about 90kb

I have MyLinks_DB - it's 14.9 compressed (ZIP) and 90kb uncompressed. I think that this the version that you are referring to, but not sure what compression method could lead to a 0% reduction.

I have a tar version on my pc and it is 93kb

tar is not compressed, it's just an archive format.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Yep I know. tar.gz is the compressed format.

Just another update. So far I've done all the stuff I already mentioned plus the ability to add, edit and delete custom links.

There are about 10 admin options so far and I've added in some user sorting options.

There are 20 templates so far and the plugin is 110kb. Who says size doesn't matter =)

In about 1-2 days I should have a beta ready. If anyone wants to try the beta please email paul@adsql.com or send me a pm. I only need a couple of people to test it ot make sure it works before I release it

It *should* work pretty well but you know, when you think it's working well you give it to someone else and it dies, so ideally you may only want to test it out if you have a development copy of Links SQL installed somewhere.

Thanks for reading.

Nice one, Paul, thanks for persisting with the plugin.

I've just finished the user profile page allowing you to edit your Links SQL user profile.

Paul,

Quick question... I like the ability to have a surfer click on the "bookmark" link next to each link in my directory and have an interim page load saying something to the effect of:

"You are now adding 'LINK TITLE", "LINK URL" to your bookmarks"

If they have an account, a cookie has been set which will cause the page to say the link was added, if they are a first time user, they will see the above information and then have the option to create an account to actually save that link.

The reasoning behind this is that by allowing that interim page, you create more spider food for the search engines. Each of those interim pages has the link title and url which work wonders for the SEs, however if when they click to bookmark a link they simply get a login screen, that benefit is lost.

Just some feedback on what was a nice hack for me with the old standard links 2.0 version with cookies.

marc

MyLinks is dynamic and so even with an interim page, it wouldn't exist as soon as the user left the page and so the search engines wouldn't spider it.

Here is an example of a link that was easily spidered from my previous bookmarking program in Links 2.0

http://www.mydomain.com/...tion=add&ID=6327

Would each link be assigned an ID such as the example above?

thanks for the info!

marc

Yes, a link like that will go into link.html. That will probably be spidered if you are building your html pages as the link will be static.

Paul;

Progress sounds fantastic. I can't wait for this plugin and thank you for working on this valuable project!

Have you been able to add the features listed below in? I am interested in both, but would pick the comment feature for overall usefulness because so often I bookmark a link, yet do not recall the exact reason a month later when scanning a list of bookmarks...

Feature Suggestions:

1. Link Notes/Comments/Reviews

- Sometimes we later forget why we have bookmarked a link, also when emailing others these links, it may be good to tell them exactly what is special about them, or to pass on a short summary/review. A single comment field may suffice.

2. Link Checking

- After the links are in the system a while, likely there would be bad ones.

Before looking stupid by sending out a email saying how great these broken links are, it would be fantastic for a quick link check to give us the edit/delete/keep options.

thanks...

I've added in the link checking when recommending links - I'll look at adding comments.

User comments for each link would be great - sometimes people forget why they bookmarked it :-)

Klaus

---

http://www.ameinfo.com

I've emailed the first beta to a couple of people who offered to test it for me. Some screenshots are below:

Hi Paul,

Getting rid of the old version is that as simple as Un-installing it (ie will it remove everything incl tables, templates etc?)

Klaus

---

http://www.ameinfo.com

Yes it should do - I can' remember exactly how thorough it is though. It should remove most stuff.

The new version installs and uninstalls everything very cleanly =)

You should be able to install MyLinks2 without uninstalling the original though.

Yes I have them both installed right now - just like to clean up :-)

Klaus

---

http://www.ameinfo.com

Hi Paul,

I installed MyLinks2 in a fresh LinksSQL 2.1.2 with 1 category and 1 link. I tried to add a new user in admin. I didn't fill in the 5 fields CustomSortOrd, PerPage and etc., so it failed with 5 errors- PerPage cannot contain the value ''....

Using mysqlman it tells me those columns can be null but I made a booboo by entering regexs in the def files.

I'll fix it on my copy.

If you want, just go into the Users.def file (be careful) and remove the regexs for those columns.

1. Change Users.def. Works fine.

2.



I would like to suggest the above line to be more end user friendly.

If you want you can change it to:


...and it will show the error page. Then just create a new language variable in the admin panel:

MY_BAD_ACTION
The action '%s' is invalid and cannot be processed.

I'll look at changing this if people want a template based error.

By the way...I need to add a fix in the handle() routine to prevent a nasty eternal loop =)

I won't tell you how to cause it but you'll probably guess.

I've made some fixes and changes thanks to the beta testers experiments ...so they are doing the final testing now and if it all looks ok I'll be sending it to Mel to add to the download area later today.

The plugin is just under 150kb in total and includes 25 templates. It will cost $70 due the amount of work I've spent on it.

I will be setting up a realtime paypal payment page so that you can download the plugin after purchasing.

I'll post more later today.

Edit: Those wishing to upgrade from MyLinks will need their PayPal order number handy when purchasing.

Hi Paul,

Yesterday, when I am playing around MyLinks2, I found I couldn't delete a user in admin. I searched a user, checked the box, and hit the 'Delete Users' button, and the result: 0 record(s) were deleted. I searched the above user again, his record was still there. I could add, modify users, but not delete users. Today, I tried it again. Delete users still didn't work. Then I uninstalled MyLinks2 and successfully deleted the user. I installed it again, changed the .def file, and I couldn't delete a user.

Hmm strange. I can't think of any reason why not.

I'll go and test. I've made quite a few changes since I sent you the last copy.

What version of Links SQL do you have?

With my copy I get:

>>
A fatal error has occured:

GT::SQL::Table (3428): Wrong argument passed to this subroutine. Usage: Could not create a condition object out of arguments. at e:/apache1/cgi-bin/lsql/admin/Links/Users.pm line 77.

Please enable debugging in setup for more details.
<<

...and thats with or without the plugin so it looks like a Links SQL bug?

LinksSQL 2.1.2, without any modification, only this plugin, 1 category, 1 link and add a few users.

Perl Version:5.005_03, MySQL Version:3.23.56

Weird - I can't get user deletion to work even without the plugin installed =(

Works fine for me? Do you have Community installed?

Klaus

---

http://www.ameinfo.com

I've fixed the bugs you've found - it was related to a foreign key issue.

It also fixed the error I was getting..heh!

MyLinks2 can now be found in the download area of your admin panel.

Let me know if you have any questions

Since you asked...

How does MyLinks2 handle saving links that are in multilpule categories? Most of my links are placed in several categories so I need to make sure this is supported before I buy the upgrade.

Thanks

How would you like it to be supported? ...how should it behave?

Hi Paul,

I installed the last file you sent me, but the problem was still there. Then I went over some of the core files and found there was a typo that turned to be a bug in Install.pm line#214:

get_file('mylinks2_folders.schema.fk'). I changed it to:

get_file('mylinks2_custom.schema.fk'),

and changed mylinks2_folders.schema.fk and mylinks2_custom.schema.fk back to the first ones (..fk => 'Username').

Now it seems working fine.

Ahh you found it =)

Thanks!

I've added the latest plugin to the download area in the admin panel.

Fortune: If you can send me your Links SQL admin email I can add you as an allowed downloader.

Took some time to find it.

Do you think the following change is better,

changed mylinks2_folders.schema.fk and mylinks2_custom.schema.fk back to the first ones (..fk => 'Username').

or my_folder_user_username_fk => 'my_user_username_fk' is?

I've returned it to point to Username as that was how it was originally. It was just that darn typo throwing me off

Hi Paul,

Before I completely make a mess of the new tables, please can you just give some hints for moving all the information in the old MyLinks to the new one?

I assume I can do this with an Update SQL command - I'm just not too sure what the command is when more than one table is involved. I hope it is possible?

Thanks,

Laura.
The UK High Street

I'll write a little script to do this so others can use it too. I'll post it later today hopefully.

Even better! Thanks.

Small bug: On the my_users page the span seems to build enough pages for all the users instead of users with saved links.

My bad. On line 72 in MyLinks2.pm you'll see:


To fix the bug just move it down to line 88, just above:


That should fix it. I'll update the plugin asap.

Hi Paul,

I've been away so I'm a little late on the reply....

Well, I guess with links located in multiple categories the plug should save the single link and not the multiple listings. The previous MyLinks DB saved just one link but showed problems with totals and display totals. I spent a lot of time customizing the templates and ended up uninstalling the whole thing because of these problems. Basically I'd just like to see the plug handle links in multiple categories and have mylinks save only one listing while displaying correct saved totals and display totals ( User chooses display 10 and they see 10 saved links displayed ). I'm using globals to allow users to submit/modify to multiple categories, so I can really buy the upgrade with knowing this is supported. I'd really love to use you plug so I hope you can come up with something if MyLinks2 is not already capable of doing this. Maybe others can provide some ideas about how this should work as well. That's about all I can offer without using the new version. If you would like me to test it out for mult categories just let me know. I'd be glad to help.

Thanks Paul

Where do you set the defult description of the Default folder?

Klaus

---

http://www.ameinfo.com

In the plugin settings page - click "Edit" next to the installed plugin.

Hi,

I'll test it out today.

The name of the folder yes - not the description?

Klaus

---

http://www.ameinfo.com

Oops, mis-read your post =)

I've updated the plugin in the download area. You can just uninstall the current version leaving the templates and then install the new one without overwriting the templates.

Sorry about that.

Cheers Paul - now it works :-)

Klaus

---

http://www.ameinfo.com

If the MyLinksSQL2 works for links listed in multiple categories, I think I will order it.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

I'm checking on that now (and working on the upgrader).

Here is the script to upgrade to MyLinks2. Just run it from your Links SQL cgi directory.

I've tested it briefly and it worked - the only problem you may encounter is moving the date from the MyLinks_Custom table to the MyLinks2_Custom table because the original MyLinks used a date but the new plugin uses a timestamp. It should insert an up to date timestamp though if the date can't be converted successfully.

Also I can let you all know that links in multiple categories are handled properly =)

Thanks a lot for that. There did seem to be a problem with the date - an example in the new table for the timestamp: 1019775600 which I assume isn't correct. Anyway didn't have many custom links so that wasn't a problem.

Moving the line in the script yesterday sorted out the number of span pages for the users list - I now have the correct number of pages but the whole list is shown on every page. (Also they don't seem to be sorted by the field I selected in the options).

Laura.

What makes you say that? ...that is a correct timestamp - it is something like April 2002.

I'm investigating the span/sort problems now.

Darn bugs

Sorry for nagging but I'm just putting the new version live on my site now so I'm going through it to check its working. I may make a few posts with little things I find

On the page for someone else's public links in a folder it doesn't show the number of links - just:

There are currently link(s) in the Default folder!

Sorry - confused between timestamp and datetime!

To fix the wrong count on the public page, on line 706 of MyLinks2.pm change:


...to...

Nevermind, I've fixed all issues and uploaded the update.

The error with the spanning was caused by the fact I'd defined a table object using:

my $table = $DB->table('Users');

...then set the ordering/limits but stupidly used a new table object for the query instead of $table which had all the options set.

The sorting problem was partly related to that, but I'd also forgotten to add the user sort order to the admin panel.

Was just about to send you a pm.

Bit worried about installing - can I do it over the top of the existing one - I don't want to uninstall and lose all the information in the tables?

You can do the uninstall and leave the templates and tables installed, then when you reinstall the plugin will ask if you want to overwrite templates - say no, and it will detect your tables and ask if you want to drop them, select no again.

Unfortunately, not quite fixed. The sort order seems to be working but I now get 1 or two users per page - and the number of users has gone back up to near the total number of users instead of the number with public folders.

Having had a look through the sub, I think that the problem may be that you limit the number of users you're looking through before deciding whether they have any public folders - does that sound right? I think that may be why you weren't using $table to begin with?

I'm playing around with it - I'll let you know if I fix it.

Bah.

I'm going to look again =(

It seemed to work on my copy. Ugh.

Would I be able to access your copy - this might be the best way to fix it.

Hi Paul,

A couple questions...

Will this work with Community?

Is there a version that is void of the user profile section?



Thanks!

Brian

Just use hidden fields and insert <%comm_password%> instead of <%password%> then it works :-)

Klaus

---

http://www.ameinfo.com

Hello all:

I am thinking I would like to add this.... but I wanted to see it in action! Paul was going to dummy one up for me, but also suggested I ask a couple of you users to see your versions!

If one or two of you would be so kind... would you PM me with a site URL with this up and running so I can see it?

Thanks!
dave

Big Cartoon DataBase
Big Comic Book DataBase

Currently not but you can just rename the appropriate subroutines relating to the profile to begin with anything other than my_ and then they can't be accessed.

To anyone reading:

The bugs Laura pointed out have been fixed. I'm not totally happy with the code for the fix as it does a few too many queries than I'd like so I'm going to keep working on it and will hopefully post the fix over the weekend.

You can have a look at mine at

http://www.theukhighstreet.com/...hops.cgi?do=my_users

I haven't finished customising it yet but it is live so you're welcome to play around with it. Please let me know if you find anything broken.

Laura.
The UK High Street

Laura:

That is exactly what I wanted to see... and exactly what I was hoping this would do! Thank you!
dave

Big Cartoon DataBase
Big Comic Book DataBase

Hi Paul,

I tried setting a comment from one PC and then accessing it from another machine and got Comment is not a valid tag?

I then clicked - Set Comment - and my comment was there - I clicked Submit and then it worked?

I am showing the comment as text in the my_link.html - ie not using the javascript bit. Should I load the comment somehow or?

EDIT: Got it sorted - using <%my_comment%> instead...


Klaus

---

http://www.ameinfo.com

Was that a typo on my part or had you used the wrong tag?

No it was my typo when I removed the escape_js from the template. Funny thing is that it worked with <%comment%> - well sometimes?!?

Anyway - sorted thanks!

Klaus

---

http://www.ameinfo.com

Hmm it shouldn't have ...are you using mod_perl?

no not using mod_perl - yet...

Klaus

---

http://www.ameinfo.com

I have a problem sorting links - I use ex:
/mylinks2.cgi?do=my_folder_list&my_folder_id=4&sf=Title&so=DESC

and did a template dump and found that sf and so are the default values set in the profile?

Was it not suppose to show be the current setting in the dropdown or?

Klaus

---

http://www.ameinfo.com

And another small problem:

I tried to use the javascript warning as follows:


But - even if I click cancel - the n it deletes the link anyway... any suggestions?

Klaus

---

http://www.ameinfo.com

This is a bug =( ....it's in the my_custom subroutine too.

You need to switch $IN->param and the custom user option, so for example:


...would become:

You need:

onclick="return the_warning('<%escape_js Title%>');"

..was that my fault again or had you changed the javascript?

No it was not even in the latest template set - only the javascript at the top - but never called in the my_links.html

Works now after adding the return

Cheers
Klaus

---

http://www.ameinfo.com

Thanks Paul - I assume you will update the plugin with the latest bug fixes so I can just download it again after the week-end?

Klaus

---

http://www.ameinfo.com

It has been updated =)

I also would like to display the comment on the user's list of saved links - I assume that this is how most people will use it rather than having to click to read the comment?

I would like to turn it into more of a personal review of the site - I might make it publicly viewable - not sure about this. I have changed it so that the comment can be entered into a text box but I want to stop html being added and would like to convert line breaks to <br> tags.

Obviously I can do this myself but if everyone uses it in the same way it would be easier if it was added to the plugin?

You can just insert <%my_comment%> into my_public_link.html or my_link.html instead of using the popup.

If people want html removing etc, please let me know.

Paul,

The problem with the comment thing was that on the my_comment.html template you wrote call the input field "comment" - is that not suppose to be my_comment?

Cheers
Klaus

---

http://www.ameinfo.com

No, the comment field is just used for that form and then gets inserted into the database. The column name is my_comment wihch is what is sent to the template as a tag.

Ok well it works fine now (using "comment" as input) - but perhaps that was the reason <%comment%> worked - sometimes..

Thanks Paul

Klaus

---

http://www.ameinfo.com

Paul:

>>> If people want html removing etc, please let me know.

Yes, I think this would be good.
dave

Big Cartoon DataBase
Big Comic Book DataBase

I agree, this would be very usefull.

~ ERASER

---

Free JavaScripts @ Insight Eye

I noticed that if I add a link to the default folder and then moce the link to another folder then I can add the same link again to the default folder and move it one more time to the other folder..

Should MyLinks2 not check if a link is avaiable in any folder the user has?

Cheers
Klaus

---

http://www.ameinfo.com

Hi Paul,

Teh sort issue (where the dropdown can't remember the current staus) is also a problem on the users list...

Klaus

---

http://www.ameinfo.com

Regarding the sorting...when did you last install an update?...I just checked the lastest copy and the fix is present...




Hmm this is an "overlook" on my part. It will throw an error if you try to add the same link to the same folder twice. You can fix this in sub my_link_add by changing:


to...


...then it will make sure the link doesn't exist anywhere rather than just in the current folder.

I updated today - few hours ago?

Have you added the check of links in any folder to the current version available from admin?

Klaus

---

http://www.ameinfo.com

Yeah it's updated now.

I've just checked the sorting on the user page and the select list selects the correct field when playing with the sort order.

Cheers Paul

---

http://www.ameinfo.com

Hi Paul,

How can I disable the URL check when using the recommend feature?

Many of my entries does not have a URL
Klaus

---

http://www.ameinfo.com

Hmm, I'll add a plugin option to let you turn it on/off. I just have to get some breakfast and I'll update the plugin.

Perfect - I'm sure other will appreciate this too :-)

Klaus

---

http://www.ameinfo.com

Hi Paul,

How are the folders sorted? - they do not seem to be affected by the Profile settings?

Klaus

---

http://www.ameinfo.com

Folders aren't sorted (but they are now )

I've added sorting options for the public/private folder lists as well as in the plugin options page in the admin panel. I've added a plugin option for turning URL checking on and off and I'm just about to deal with the html issue.

so I would have to replace my templates?

Or could you advise the changes by any chance...

Is it ready for download now?

Klaus

---

http://www.ameinfo.com

No it's not ready yet.

I think what I'm going to do regarding the html is just change < to &lt; otherwise I'd have to add error checking for every field.

Yes there would be template changes. As long as you've edited your templates using the template editor then you'll have a custom copy in the "local" directory and so when you install, the new ones will go in the main template directory and then you can cut/paste the changes.

The changes are in:

my_home.html
my_public_home.html
my_users.html

I think that's all

Oh the other issue I forgot to mention is that two new column have been added to the user table so you would have to drop and re-create the tables to make that table update. Or if you don't want to do that you can add them manually using the table editor.

Col Spec:

FolderSortField, VARCHAR, 255, ^[\w\s]+$

FolderSortOrd, VARCHAR, 255, ^(?:A|DE)SC$

no problem - all my tables are empty anyway - but for some it is surely important...

Let me know when the new version is available for download...

What are the > issues in the html?

Klaus

---

http://www.ameinfo.com

People wanted me to remove html from the fields incase someone entered some nasty code or just decided to go to town by formatting their folders or links =)

But, that would mean I'd have to check each field and report any errors, so the easiest thing to do it convert < to &lt; and so if anyone enters html it will just show as plain text rather than being parsed as html.

Ah ok - sorry - I solved it with a global I use for other fields stripping html code...

Klaus

---

http://www.ameinfo.com

Ok it has been updated. Probably created more bugs in the process

Cheers Paul - will give it a go and keep you posted :-)

Klaus

---

http://www.ameinfo.com

I dread seeing replies in this thread now as I keep thinking it's another bug report

Hi Paul,

Seems everyhting is under control now - could not put my fingers on anything.. :-)

Thanks for your help
Klaus

---

http://www.ameinfo.com

Hi Paul,

One more question - how can I use HTML code in the e-mail message (Recommend.eml.html)?

Klaus

---

http://www.ameinfo.com

You'd need to change the header passed into GT::Mail on line 918 of MyLinks2.pm. You'd need to add:

type => 'text/html',

yes it worked - thanks Paul

Klaus

---

http://www.ameinfo.com

Hi Paul,

In the recommed function - if you leave freind name empty or enter a non valid e-mail address I get:

The email address 'ARRAY(0x84fd674)' is invalid.

Any suggestions?
Klaus

---

http://www.ameinfo.com

Blech. Line 862 of MyLinks2.pm change:


to...

Thnaks Paul - hope that's the last time I need to bother you with this plugin

Klaus

---

http://www.ameinfo.com

Paul:

Just d/led the plug-in, and I am starting to edit the templates. I have a couple extra User fields (Location, Hobbies, etc) and I wanted to add those fields to your "my_profile.html" page, so that the user could edit them all there.

Is it OK if I just add the new fields to the html page, or do I also have to edit youe of the .pm files and all so that those "new" fields are recognized and updated?

Thanks!
dave

Big Cartoon DataBase
Big Comic Book DataBase

You can just add them into the template - no perl code changes needed =)

Paul:

Thanks- that makes it easy!
dave

Big Cartoon DataBase
Big Comic Book DataBase

Hi Poul,

Two things (for the next version I suppose as this one is done).

1. Option to select which folder is default
2. Option to make multiple link move

Cheers
Klaus

---

http://www.ameinfo.com

Thanks for the ideas. They'll no doubt get added this week sometime.

Paul:

Hate to be the pest, but a couple things...

MY_BADLINK_URL came up when testing Reccomend It, using my addy and name, and no TO addy or name... Might want to add that into your language pack.

When I go to see the user list, I put ONE public folder in it (mine!) for right now. But it does not show up- in fact, it teells me there are 0 users, not 1.

Also, when pulling up the User List, I found it VERY CPU intensive- 15-20 percent, for 20 seconds or so... the only thing I have that runs that hard is a rebuild of Links!

OK, all fairly minor things, but thought you would want to be aware!

Other than that, looks good. Hope to put it online later tomorrow.
dave

Big Cartoon DataBase
Big Comic Book DataBase

Hmm. MY_BADLINK_URL is for a URL that is dead. You can add the language var manually if you want - something like:

The URL '%s' is dead.

I'll fix it up though soon.


Strange. I've not seen that before. Can you tell me what you see for the entry in the MyLinks2 table and the corresponsing entry in the MyLinks2_Folders table.


I am aware of that (unfortunately )...you can see my post on it here...

http://www.gossamer-threads.com/...i?post=238753#238753

This will definitely be altered.

Actually ignore my reply for the second quote. It is happening for me too.

I'll update all these issues asap. Hopefull by tommorrow.

When you made your folder public were you logged in as an administrator? If so you need to add Administrator status into the plugin options "Show Status" field.

Paul:

>>> I'll update all these issues asap. Hopefull by tommorrow.

No rush. I had already added some language for the one error... I just thought you would like to know.

Yes, I was logged in as am admin...

Where are the "plugin options "Show Status" field" located at?

Also, when I was in language, I see that there is a limit on the number of folders/links etc one can have (or I assume that based on some of the rror language I see there). Where do set the limits for these? Under Insralled Plug Ins, I only have an "About" link, no "set up" links or things like that. (Sorry if that is a stupid question!)
dave

Big Cartoon DataBase
Big Comic Book DataBase

Next to the installed plugin you have:

Edit | Uninstall

If you click "Edit" you'll see loads of options that you never knew were there :)

Scroll down to the botton and you'll see the textarea when you need to enter "Administrator" - then your folder will show :)

THAT did it! (Sorry for being so stupid!) AND it awnsered my next question.... which shall now not be asked!
dave

Big Cartoon DataBase
Big Comic Book DataBase

Paul - if you are updating the plugin anyway - could you make a few things optional from the plugin settings:

1. HTML or TEXT mail
2. Check names and e-mail addresses ON/OFF
3. Recommend (allow all/registered user)

Just selfish suggestions as I need to change this every time I update the plugin... (perfectly understandable if you don't want to do it though)

Cheers
Klaus

---

http://www.ameinfo.com

Why would you want to turn off name/email checking?

Bacause it caused me some problems... nothing to do with your rules - just me having some issues with certain names and addresses... so I prefer not to check at all

Klaus

---

http://www.ameinfo.com

If you let me know which names/addresses caused problems I can alter the regexs.

Hi Paul,

Names with numbers - but the problem I have is an error page wich is a javascript that make a msg box with the error and go back to the page the user came from - and then it gets messed up and people are re-directed to the wrong page. So I have disabled checking at the moment - until I find a solution

Klaus

---

http://www.ameinfo.com

Since when have names had numbers in

With the javascript you should be able to redirect them by just using:

history.go(-1)

good point Paul - our users are a bit strange... I did that - the problem is if you start on page A - click Recommend (page B) and get error you will goto page B again and when you then suceed entering the correct e-mail or name then you are suppose to be taken back to page A - but because of the error you are taken back to page B again...

Makes sense?

Klaus

---

http://www.ameinfo.com

Hmm I see. I'll see what I can do.

Thanks Paul - don't waste too much time on it though - I"ll just swith the check off in case I can't get it going..

Klaus

---

http://www.ameinfo.com

Is there a new version uploaded Paul?

Klaus

---

http://www.ameinfo.com

Sorry not yet, I'm juggling a few jobs at the moment, but I've not forgotten MyLinks =)

Ok Paul - no worries

Klaus

---

http://www.ameinfo.com

Hi Paul,

Don't worry this isn't a bug report . Just wondering whether the final (ish) version is the one we can download now - are you planning on any more updates in the next few days?

The reason I ask is that I'm thinking about trying to change the custom links so that they are added to one of the folders instead of being completely separate - I think this will make them much more useful on my site - but I don't want to start mucking about with the code if you're still tinkering with it.

Laura.
The UK High Street

Hi,

I've been busy with other projects for the past few weeks. I'll will make some updates and release them hopefully before this weekend.

We are having a new conservatory built on the back of the house so I've also been assigned the job of keeping an eye on the builders

Gosh, Mylinks must be proving very profitable!!! Good luck with the pesky builders.

Ok I've got some time to work on this. Can people just give me a reminder of what needs doing :)

One thing I'm aware of is the user list slowness. I'll try to fix that.

Anything else?

Hi Paul,

Here are a few things:

1. Allow a user to nominate a default folder

2. Suport for moving multiple items from one folder to another

3. Include a Links::init_date(); please

4. When a user use the send a link feature - count in a table called recommended so we can rank links based on most recommended/sent

5. Option to switch off name and e-mail address and message checking (ref previous posts)

6. Allow the mail function to be used by non-registered users (so you can use it for all - send a link functionality instead of having to use two programs - like recommend_it)

That's all that I can think of right now

Klaus

---

http://www.ameinfo.com