Previous Thread
Next Thread
Print Thread
Rating: 5
Page 9 of 11 1 2 7 8 9 10 11
Joined: Oct 2001
Posts: 27
User
User
Joined: Oct 2001
Posts: 27
Ok so admittedly I am probably getting carried away with this script but I can't seem to leave it alone. The attachment contain the following mods:

1. Fixed the default rate in the 'rate this link' page to default to 1. It currently defaults to blank. I think the author intended it this way but made a typo.
2. Added a configurable option to allow / disallow the link submitter from voting on his/her own link.
3. Added a configurable option to specify the minimum number of votes required before a link will appear on the Top Rated page and before the 'stars' ratings will appear next to a link.
4. When a link submitter clicks on his/her link, it is no longer counted as a hit.

I'm going to try to leave this alone now but I'm not crazy about the way that the redirect sends the link in the clear.
Attachments
118140-TLD.zip (0 Bytes, 243 downloads)

Sponsored Links
Joined: Sep 2003
Posts: 803
Coder
Coder
Offline
Joined: Sep 2003
Posts: 803
So, does the first post in the thread contain the very latest release?

I tried to install this mod when it was still "new" and had errors everywhere. lol.

But since everyone is getting it working and you devoted some time to it, I might have to give it a go again...

Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
[]DrChaos said:
So, does the first post in the thread contain the very latest release?

I tried to install this mod when it was still "new" and had errors everywhere. lol.

But since everyone is getting it working and you devoted some time to it, I might have to give it a go again... [/]


ditto!

Joined: Oct 2001
Posts: 27
User
User
Joined: Oct 2001
Posts: 27
I think the first post is the latest (it's what I started with). Did it error out before or after you added my mods? You may need to include the other mods that I included in this thread. What kind of errors are you getting? Seems like this thread should me in the mods forum.

Joined: Sep 2003
Posts: 803
Coder
Coder
Offline
Joined: Sep 2003
Posts: 803
I was just wondering if there was one zipped file that had all the fixes. I installed it a long time ago. But as I read the post it seems that few people got it to work with your help.

Sponsored Links
Joined: Oct 2001
Posts: 27
User
User
Joined: Oct 2001
Posts: 27
I'll try and zip up what I have tonight.

Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
I've got this far now guys
i've installed it, called up links.php and now get this error

[]
Script:
Line#:
SQL Error: Table 'fordmond_threadsdb.w3t_links_favorites' doesn't exist
SQL Error #: 1146
Query: SELECT w3t_links_favorites.uid, w3t_links_favorites.lid, w3t_links_links.lid, w3t_links_links.title, w3t_links_links.url, w3t_links_links.description FROM w3t_links_favorites, w3t_links_links WHERE w3t_links_favorites.uid = '2' AND w3t_links_favorites.lid = w3t_links_links.lid
[/]

any ideas?
i know it's something to do with tables, but i dont know how to fix it!

Joined: Jun 2003
Posts: 1,025
Junior Member
Junior Member
Offline
Joined: Jun 2003
Posts: 1,025
You're missing tables. I don't know if there is an install script with this, but if there is, it appears that it didn't finish.

Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
hmm dang diggity.
i suppose i could add them manually via phpmyadmin yeah?

Joined: Oct 2001
Posts: 27
User
User
Joined: Oct 2001
Posts: 27
Here are my files. Sorry for the delay.
Attachments
118876-links.zip (0 Bytes, 283 downloads)

Sponsored Links
Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
i cant figure this out
why doesnt the install script create the tables guys?

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Very appreciated Looks pretty here:

https://www.ubbdev.com/forum/links.php



I updated the original post in this thread with emkempter's files added


- Allen wavey
- What Drives You?
Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
[]AllenAyres said:
Very appreciated Looks pretty here:

https://www.ubbdev.com/forum/links.php



I updated the original post in this thread with emkempter's files added [/]

hey allen
yours doesnt seem to be working m8.

[] Warning: main(languages//links.php): failed to open stream: No such file or directory in /home/threadsdev/domains/ubbdev.com/public_html/forum/links.php on line 55 [/]

Joined: Jul 2001
Posts: 808
Coder
Coder
Joined: Jul 2001
Posts: 808
Im trapped at the same error. I use the latest version witch runs on php5 (globals off) under 6.4.x

after Update to 6.5 I modify this:

// Require the library
require ("includes/main.inc.php");
require ("languages/${$config['cookieprefix']."w3t_language"}links.php");

to reflect the moving of the main.inc.php to the includes directory but get:

Warning: main(languages/links.php) [function.main]: failed to open stream: No such file or directory in /...path.../dragonclan-forum.de/ubbthreads/links.php on line 41

Any Idea ?

Joined: Mar 2003
Posts: 159
Member
Member
Joined: Mar 2003
Posts: 159
[]Zarzal said:
Im trapped at the same error. I use the latest version witch runs on php5 (globals off) under 6.4.x

after Update to 6.5 I modify this:

// Require the library
require ("includes/main.inc.php");
require ("languages/${$config['cookieprefix']."w3t_language"}links.php");

to reflect the moving of the main.inc.php to the includes directory but get:

Warning: main(languages/links.php) [function.main]: failed to open stream: No such file or directory in /...path.../dragonclan-forum.de/ubbthreads/links.php on line 41

Any Idea ? [/]
I had the same problem, but I got it working but using the full paths.

Change this:

Code
<br />// Require the library<br />require ("includes/main.inc.php");<br />require ("languages/${$config['cookieprefix']."w3t_language"}links.php");<br />


To This:

Code
<br />// Require the library<br />require ("/path/to/ubbthreads/includes/main.inc.php");<br />require ("/path/to/ubbthreads/links/languages/english/links.php");<br />


Probably not the right way to do it, but it does work.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
One important update on ANYTHING that you're converting to work on 6.5 - is that you have to change

${$config['cookieprefix']."w3t_language"}

to

{$myprefs['language']}

That'll fix why it's leaving "english" out of the language file include.

Joined: Jul 2001
Posts: 808
Coder
Coder
Joined: Jul 2001
Posts: 808
Thanks Josh. Last night I do the fix with fixed path to test out where the error comes from. I know that something was changed and that is it.

To bring TLD to work on Threads 6.5 do the following changens:

links.php:
require ("./includes/main.inc.php");
require ("./languages/{$myprefs['language']}/links.php");

links_admin.php
require ("./includes/main.inc.php");

links_redirect.php
require ("./includes/main.inc.php");

Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
i'm still getting this problem:

Script:
Line#:
SQL Error: Table 'fordmond_threadsdb.w3t_links_links' doesn't exist
SQL Error #: 1146
Query: SELECT lid,cat_id FROM w3t_links_links WHERE approved = '1'

Please use your back button to return to the previous page.


how do i insert these tables?

Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
Hmmm, even if i try the links_admin.php?op=upgrade_from_1_0 or the links_admin.php?op=create_tables manually which i've found in the links_admin.php file i STILL get the same error.
HELP!
I really want this working and it's doing my head in.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
OK- I've put this on a couple of 6.5 forums. I don't have a "pretty" way to do it, or else I'd re-post the mod for 6.5.
If I find myself with free time, I will. But for now I'm swamed.

To use this mod with 6.5 - I did the following.

inks.php:
require ("./includes/main.inc.php");
require ("./languages/{$myprefs['language']}/links.php");

links_admin.php
require ("./includes/main.inc.php");

links_redirect.php
require ("./includes/main.inc.php");


Then I manually created the tables using my Threads SQL interface. The following 3 queries need to be run.

CREATE TABLE `w3t_links_categories` (
`cat_id` int(11) NOT NULL auto_increment,
`parent_id` int(11) default NULL,
`title` varchar(50) NOT NULL default '',
`cat_order` tinyint(10) NOT NULL default '0',
`cat_desc` varchar(60) default NULL,
PRIMARY KEY (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=32 ;




CREATE TABLE `w3t_links_favorites` (
`num` int(9) unsigned NOT NULL auto_increment,
`lid` int(9) unsigned NOT NULL default '0',
`uid` int(9) unsigned NOT NULL default '0',
PRIMARY KEY (`num`),
KEY `FAV_indx1` (`uid`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;




CREATE TABLE `w3t_links_links` (
`lid` int(11) NOT NULL auto_increment,
`cat_id` int(11) default NULL,
`approved` tinyint(4) NOT NULL default '1',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`date_added` int(11) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
`user_number` int(11) NOT NULL default '0',
`member` char(2) NOT NULL default '',
`linkratingsummary` double(6,4) NOT NULL default '0.0000',
`totalvotes` int(11) NOT NULL default '0',
PRIMARY KEY (`lid`)
) TYPE=MyISAM AUTO_INCREMENT=65 ;


Once you make those tweaks, and create the tables, then it should all function normally.

Probably wouldn't be difficult to figure out how to allow the admin script by the SQL error on initial install. Or create a "createlinktable.php" script which you could run first and then delete it. But the above works just fine.

Joined: Jun 2001
Posts: 356
Junior Member
Junior Member
Offline
Joined: Jun 2001
Posts: 356
Josh, your a star!
I tried copying the sql code from the file myself and enter it in the threads sql box, i guess i must have copied it slightly wrong as i got errors!
But now it's working like a treat!
thanks m8!

Joined: Jul 2001
Posts: 808
Coder
Coder
Joined: Jul 2001
Posts: 808
As I see there is a V1.8 avaible at the start posting. I take a look and its not compatible with threads 6.5 too. It use the old way for languages.

I try to change this and test out the version but I get strange results in my library. Must the DB changed if I do an Update from 1.5 to 1.8 ? Is the 1.8 compatible with php5 register global off?

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmm... updated original post with latest bugfixes to use threads 6.5. It should run fine


- Allen wavey
- What Drives You?
Joined: Apr 2004
Posts: 54
Cro Offline
Power User
Power User
Joined: Apr 2004
Posts: 54
hi. i have a prob. when my users submit a site, the 'date submited' shows up the same all the time.... like 01/01/70 or something like that.. i guess its something to do with the date_added in my database field. should it be null for default? what else must i make sure its adjusted? thenks

Joined: Jul 2001
Posts: 808
Coder
Coder
Joined: Jul 2001
Posts: 808
Thank you for the update, but I have still problems. I use a old 1.5 version for a long time. Some month ago someone post a version wich works with globals=off in this thread.

This version works fine for me. No problem with php5 and no big problem with ubb 6.5

After installing this 1.8.1 the links index page looks fine ( http://www.dragonclan-forum.de/ubbthreads/links.php ) but if yo try enter a section or edit a link the chaos begins.

Is a database modification needet to bring this to work again ?

/edit: I try to submit a link or create a category. Everytime I get an error that nothing is submited. I fear this version is not compatible with php globals=off

I have to put my backup in again.

Can anyone verify this ?

/edit: First bug found? In links_show_cat.php there is a $parent_id = "= $id";

in my version this is only: $parent_id = $id;

Last edited by Zarzal; 10/12/2004 5:16 PM.
Joined: Jul 2001
Posts: 808
Coder
Coder
Joined: Jul 2001
Posts: 808
here is my version of links1.5
I do a compare between my version and 1.8.1. I use Beyond Compare and clean out all minor changes. The leftover differences are major changes between the versions. The followings files contains differences:

links.php
links_admin.php
links_rate_link.php
links_redirect.php
links_show_cat.php
links_show_links.php
links_submit_form.php
links_submit_link.php
links_submitrate_link.php
links_toprated_links.php
template/default/links_footer.php (just the copyright notice)

there are some differences in the code belongs to ' and ". I m not sure if these are the same in php so I leave it unchanged. In some places my code dont have ' ' around a value and the new one have " ". You will see it if compre it.

This pack works fine for me. Maybe this helps to find out why the new version doesnt work.
Attachments
121368-links15.zip (0 Bytes, 259 downloads)

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
[]Zarzal said:
/edit: First bug found? In links_show_cat.php there is a $parent_id = "= $id";

in my version this is only: $parent_id = $id;
[/]

That does look odd, there's also:

$parent_id = "= $parent_id";

and in links_show_links.php line #124 there's:
$parent_id = "= $id";

hmmm... I'll ask


- Allen wavey
- What Drives You?
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Yeah, that definately seems incorrect.

Should at least be:

$parent_id = "$parent_id";

And

$parent_id = "$id";

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
grazi josh

Files updated here with the 3 bugfixes


- Allen wavey
- What Drives You?
Joined: Jul 2001
Posts: 808
Coder
Coder
Joined: Jul 2001
Posts: 808
this looks better. Links 1.8.1 begins to work on my site. The main index is ok and subcats too. You can browse links without problems. But there are still 3 problems:

1) The redirector doesnt work. If you click a link I get a blank page, on top of the page a horizontal line, below that line a 'generated by Opera', thats all. Nothing happen.

[update] It seems that is related to Opera. Some Kind of protection. It work with IE.

2) You cant edit any link. If you click the green led-button to edit a link you get the edit mask but without any data. The fields are still empty.

3) If you try to submit a link you fill out the form and send it. You get an answer that 'http:// (nothing more)' isnt correct. It seems that the input from the form is not submitted to the script.

I put back may backup in again....

Last edited by Zarzal; 10/16/2004 8:08 AM.
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
I can do all those tasks here... hmmm - it would have to be a difference in how servers are setup.

1.5 does all those for you?


- Allen wavey
- What Drives You?
Joined: Jul 2001
Posts: 808
Coder
Coder
Joined: Jul 2001
Posts: 808
yes, 1.5 works real fine. Little bit above I attach my files. The thing with the redirector is Opera related, my fault. But the empty Input mask must be something different. I run on ZEUS, not on Apache with php5.x

As I notice in my 1.5 there are some additional varibales in some places. If you compare you see it. I do some testings but cant find out where is the problem with the input.

I cant edit
I cant send new one

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
That's a little over my head. I'll look at it, but I'm not sure if I can fix it. If someone else wants to take a look first, be my guest.

Files updated with minor xhtml-bugfixes


- Allen wavey
- What Drives You?
Joined: Apr 2001
Posts: 18
User
User
Offline
Joined: Apr 2001
Posts: 18
I get this error when try to add a category.

SQL ERROR: Fri, Jan 07 2005 10:29:22 +0100 Unable to do_query: INSERT INTO w3t_links_categories (parent_id, title, cat_desc) VALUES (0, 'Resa', '')
Resa was added to the database.

It worked before I switched webhotell.

Thanks
/Stefan

Joined: Feb 2002
Posts: 950
Hacker
Hacker
Offline
Joined: Feb 2002
Posts: 950
Just a heads up (might be in the previous 18 pages), I had to add a bunch of $tbclose's after the error messages to format the pages properly.

Joined: Feb 2002
Posts: 950
Hacker
Hacker
Offline
Joined: Feb 2002
Posts: 950
I combined mine with thumbshots.com to get a nice layout:

ViperAlley Resource Directory

I put a two-tiered display into place - nonmembers see the "free" thumbnail service which provides thumbnails for those sites listed in the DMOZ. My paying members see the paid service provided which provides for thumbnails of every site listed in the index.

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Looks nice


- Allen wavey
- What Drives You?
Joined: Aug 2004
Posts: 173
Member
Member
Offline
Joined: Aug 2004
Posts: 173
I would like to make my admins control of this, so my moderators have to have links approved and turn off the delete feature for them.

Can someone tell me how to do this please?

Joined: Mar 2003
Posts: 118
Journeyman
Journeyman
Offline
Joined: Mar 2003
Posts: 118
Hey Photopost, any chance you could share how to integrate the thumbshots into TLD?

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
I can look at this for you if you like, it's probably easy, tho I'm not sure... been a while since I looked at the code.


- Allen wavey
- What Drives You?
Page 9 of 11 1 2 7 8 9 10 11

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Gizmo
Gizmo
Portland, OR, USA
Posts: 5,833
Joined: January 2000
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)