boardom

yewel · Joined: 20 Nov 2002 Posts: 5 Location: melbourne

hi!

this is a fantastic hack!

i've just installed it last night at http://adrian.newyew.net/thedailygrind

i was wondering how i can work the code such that when displaying text links (see the section at the top entitled "Inside Yew"), the description of the link is not echoed again after going into the title="describtion" area

i.e.
i would like my text links to show :
<a href="link_url[i]" title="[i]description" target="top">link_text</a>

instead of

<a href="link_url[i]" title="[i]description" target="top">link_text</a> description

cheers!

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Folks,
There is yet another new version of the B2 Link Manager available. Version 0.9
You can obtain it from the B2 Link Manager page.

New features:
* URLs are optional.
* Delete asks for confirmation.
* You can now turn off the descriptions, even if you have no image
defined or have images turned off.

This last one just for you yewel

Feedback, bug reports/fixes, and general comments appreciated.

Still on the todo list:
* Sort out the bookmarklets thing.
* Arbitrary display order.
* Remember the show option from page to page.

Enjoy,
Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

MiniSizeIt · Joined: 02 Nov 2002 Posts: 70

Amazing work mikelittle! I'll be sure to update my version when I get to my server tomorrow. Keep up the great work Very Happy

yewel · Joined: 20 Nov 2002 Posts: 5 Location: melbourne

you are a gem!
thank you!!!! Very Happy

i haven't quite figured out how to get the syntax to hide the dsescription when i have a mix of images and test links in the same category, but don't worry, i'll work it out. Mr. Green

albert · Joined: 11 Oct 2002 Posts: 52

you just keep pumping these updates out dont you?
_________________
"so fresh so clean"

lordscarlet · Joined: 27 Nov 2002 Posts: 4 Location: Fredericksburg, VA

Could you possibly create a build script for the MySQL tables? Some of us don't have telnet or phpMyAdmin access Smile

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Hi Lordscarlet,
Yes I will turn the table creation into a php script. I've been pretty much asked the same thing for another of my hacks.

I'll work on it now....
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

OK. Here is a first pass at a table creation script. Upload this to your B2 directory as b2links.install.php and 'call' it with your browser http://www.your.domain/b2links.install.php

[php:1:35552611f2]<?php
// $Id$
//
// B2 Link Manager
// Copyright (C) 2002 Mike Little -- [email protected]
//
// This is an add-on to b2 weblog / news publishing tool
// b2 is copyright (c)2001, 2002 by Michel Valdrighi - [email protected]
//
// **********************************************************************
// Copyright (C) 2002 Mike Little
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful, but
// WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
//
// Mike Little ([email protected])
// *****************************************************************

// Start Connect To MYSQL
require_once("b2config.php");
include_once("$b2inc/b2vars.php");
include_once("$b2inc/b2functions.php");

$tablelinks = "b2links";
$tablelinkcategories = "b2linkcategories";

$got_links = false;
$got_cats = false;
$got_row = false;
?><html>
<head>
<title>b2 > Installation</title>
</head>
<body>
Checking for tables...
<?php
$result = mysql_list_tables($dbname);
if (!$result) {
print "DB Error, could not list tables\n";
print 'MySQL Error: ' . mysql_error();
exit;
}

while ($row = mysql_fetch_row($result)) {
if ($row[0] == $tablelinks)
$got_links = true;
if ($row[0] == $tablelinkcategories)
$got_cats = true;
//print "Table: $row[0] \n";
}
if (!$got_cats) {
echo "Can't find table '$tablelinkcategories', gonna create it...\n";
$sql = "CREATE TABLE $tablelinkcategories ( " .
" cat_id int(11) NOT NULL auto_increment, " .
" cat_name tinytext NOT NULL, ".
" PRIMARY KEY (cat_id) ".
") ";
$result = mysql_query($sql) or print ("Can't create the table '$tablelinkcategories' in the database. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Table '$tablelinkcategories' created OK\n";
$got_cats = true;
}
} else {
echo "Found table '$tablelinkcategories', don't need to create it...\n";
}
if (!$got_links) {
echo "Can't find '$tablelinks', gonna create it...\n";
$sql = "CREATE TABLE $tablelinks ( " .
" link_id int(11) NOT NULL auto_increment, " .
" link_url varchar(255) NOT NULL default '', " .
" link_name varchar(255) NOT NULL default '', " .
" link_image varchar(255) NOT NULL default '', " .
" link_target varchar(25) NOT NULL default '', " .
" link_category int(11) NOT NULL default 0, " .
" link_description varchar(255) NOT NULL default '', " .
" link_visible enum ('Y','N') NOT NULL default 'Y', " .
" link_owner int NOT NULL DEFAULT '1', " .
" PRIMARY KEY (link_id) " .
") ";
$result = mysql_query($sql) or print ("Can't create the table '$tablelinks' in the database. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Table '$tablelinks' created OK\n";
$got_links = true;
}
} else {
echo "Found table '$tablelinks', don't need to create it...\n";
}

if ($got_links && $got_cats) {
echo "Looking for category 1...\n";
$sql = "SELECT * FROM $tablelinkcategories WHERE cat_id=1 ";
$result = mysql_query($sql) or print ("Can't query '$tablelinkcategories'. " . $sql . " " . mysql_error());
if ($result != false) {
if ($row = mysql_fetch_object($result)) {
echo "You have at least got category 1. Good!\n";
$got_row = true;
} else {
echo "Gonna insert category 1...\n";
$sql = "INSERT INTO b2linkcategories (cat_id, cat_name) VALUES (1, 'General')";
$result = mysql_query($sql) or print ("Can't query insert category. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Inserted category Ok\n";
$got_row = true;
}
}
}
}

if ($got_row) {
echo "All done.\n";
}
?>
</body>
</html>
[/php:1:35552611f2]

Let me know of any problems. I'll include this in the next release.

Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Folks,
There is a new version available, 0.9.1
This a very minor update: I've simply of added the DB install script I posted earlier.

You can get it from the B2 Link Manager page.

Enjoy,
Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

lordscarlet · Joined: 27 Nov 2002 Posts: 4 Location: Fredericksburg, VA

After the includes at the top of b2links.install.php you should add:

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Hmmm, that's interesting, because I didn't need to do that.
I developed and tested it without any problems. I kept dropping the tables or deleting the rows to check I'd got all my logic correct. But I never had any trouble connecting.

I developed and tested it under Windows, I wonder if that make any difference?

Did you get it working then?
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

lordscarlet · Joined: 27 Nov 2002 Posts: 4 Location: Fredericksburg, VA

i don't know if windows had to do with it or not. It kept trying to login as nobody@localhost or something..r ather than having the correct login. there may be something with windows DSN's that keep it from having that problem. So, if anyone has login problems do what I did. Smile

but yes, it ended up working.

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Folks,
B2 Link Manager has made it to version 1.0!

This new release includes:

Of particular interest is the rating system which includes the ability to display images to indicate the rating of a link. And the auto-toggle category flag which forces only one link in that category to be visible, automatically toggling the others nvisible. Think 'current CD' or 'current mood'.

You can find a zip file and tarball at the b2 link manager page.

As ususal, comments, bug reports, etc to this topic please.

Still to do:
* Arbitrary ordering. (But you can use the rating system for now)
* Sidebar/favelets thing.

Enjoy,

Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Oops, I forgot to update the install script with the table changes for this release.
You can get the updated version from http://zed1.com/b2links/b2links.install.php.txt
save it as b2links.install.php and run it to create the tables.

This is only needed if you are installing for the first time, if you are upgrading there is b2links.update-1.0.sql

I guess I need to incorporate a PHP update script too. Hmmm, maybe in the next release.

Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

lg · Joined: 05 Jan 2003 Posts: 8 Location: Oxford, MS, USA

I installed the Link Manager 1.0, and have made a fix. When I tried adding a link category with auto-toggle unchecked, I got the error "Couldn't add category...". I tracked it down to the $auto_toggle being blank when updating the database. Here's my fix:

b2linkcategories.php
change both lines shown