vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vB Links Directory 2.0 *NEW VERSION* (https://vborg.vbsupport.ru/showthread.php?t=44551)

DrkFusion 11-21-2002 09:14 PM

It seems as the catagoryid was not passed through, so then catagoryid was blank.

I am not really sure how to fix your hit problem, but try doing this, in links.php
fnd:
PHP Code:

if ($noshutdownfunc) {
  
$DB_site->query("UPDATE gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'");
} else {
  
$shutdownqueries[]="UPDATE LOW_PRIORITY gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'";


replace with
PHP Code:

$DB_site->query("UPDATE gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'"); 

Also can you please PM me your site url.

Thanks

DrkFusion 11-21-2002 09:15 PM

Quote:

Originally posted by cklaszlo
Is it possible to add a "New" image next to new links and also next to the main catagories if there are new links in the respective cats?
Do you mean add an image beside a link if it is new since the last time they visited?

cklaszlo 11-21-2002 10:36 PM

No I mean when a new image has been added to the directory. Say it stays "New" for like 5 days (or length is set by the admin).

Banana 11-22-2002 06:26 AM

The "Top 10 Visited Links" doesn't sort properly. The problem is that the db column is text and not a number. Therefore "9" comes above "11" etc. My top ten list reads: 9,9,6,5,4,36,29,17,15,14.

Will a simple alteration of the column type work or will that muck up the PHP? Thanks

DrkFusion 11-22-2002 06:53 PM

Umm...Yea I noticed that, I thought I had fixed that and updated it all, I had changed alot of the tables from the first release...I will check it out.

ForYou 11-24-2002 06:29 AM

Hello ,

When i need to do first install there is message for me like this ..
---------------------------------------

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: CREATE TABLE `gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` VARCHAR(255) NOT NULL,
`catdesc` TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM
mysql error: You have an error in your SQL syntax near '`gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` V' at line 1

mysql error number: 1064
----------------------------------------------

what can i do please to solve it ..

regards

DrkFusion 11-24-2002 11:58 AM

Run this manually through phpmyadmin
[sql]CREATE TABLE gportal_weblinkscat (
webcatid INT(11) NOT NULL AUTO_INCREMENT,
catname VARCHAR(255) NOT NULL,
catdesc TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM[/sql]

Highlander 11-26-2002 02:40 AM

hi there.. is there a ability to user this linkdatabase with yours.. i mean i needed it merged.. some option yours and some option of mine would be a GREAT hack ..

direkt link
http://www.spieleplanet.org/forum/do...hp?dominator=2

would be cool if i get an answer on
admin@spieleplanet.net

(i just user the quick reply box for this answer so i did not get notifivation by email.. )

Legacy 11-30-2002 03:44 PM

Admin CP Error

Fatal error: Cannot redeclare maketableheaderview() in /home/virtual/site1/fst/var/www/html/forums/admin/adminfunctions.php on line 132


EDITED...NEVER MIND..FOUND PROBLEM

You do not need to edit the adminfunctions.php file if your upgrading :( doh


But the Validation doesnt work...also glad to see the serch function working with ensim now

great Job...any solution on validation

Banana 11-30-2002 03:50 PM

Quote:

Originally posted by Banana
The "Top 10 Visited Links" doesn't sort properly. The problem is that the db column is text and not a number. Therefore "9" comes above "11" etc. My top ten list reads: 9,9,6,5,4,36,29,17,15,14.

Will a simple alteration of the column type work or will that muck up the PHP? Thanks

Hi, is there a fix for this yet? Thanks

ArunanS 11-30-2002 09:47 PM

Try
[SQL]ALTER TABLE `gportal_weblinkslink` CHANGE `hits` `quantity` INT(99) DEFAULT '0'[/SQL]

GMeadows 12-01-2002 10:52 AM

There must be a simple way to include the links box on the front page of the forum....? Down under the forums.

Got me beat right now.

ArunanS 12-01-2002 12:27 PM

Well if you check out http://www.noxmedia.net/links.php

I have done it for that site.

Martin64 12-01-2002 02:26 PM

Great hack, installed. :)

DrkFusion 12-04-2002 12:55 AM

Well can we please move this to pm.

Thanks

DrkFusion 12-04-2002 02:12 AM

Many of you may be wondering why the stuff I have promised is not out yet, its because I have been busy with my personal life, and thanks to alot of people here at vB.org i have learned alot of new stuff in php and Mysql, and will be releasing yet a new big release, with great new features, and a full code revamp.

Also I will be making a new one for vB3 when that comes out.
Here are some features on the TODO
- Sub Categories
- Link Editing (By user who added the link and admin on the site itself)
- Revamped Admin Panel with more control in vB options
- New Style
- Link Rating
- Mini Topsites
- Advanced Toggle Options in AdminCP for all features
- UserGroup Permissions (Allow certan usergoups to view/add links)
- Built-In Banner/Button rotator (Maybe)
- Banner/Button Engine (Allows the user to display a button or banner, can be toggled on or off)
- Adding Rules (make it so only 1 user can add 1 link etc)
- Easy Integration Instructions (vBhome, main site etc)
and many other features, this will be a full re-write of the code, and the best part about all this is, the goal is no more than 11 queires per major function. The Currect Directory potentially only has 6-7 queries, but with all the extra addons less than 11, 10, and if all features are turned off less than 8, I will be giving you more information soon.

supreemball 12-04-2002 10:52 PM

great hack..

only one problem.. seems that when users add some links with ' or commas or other special characters in the description field, they don't show up on validation, even though it says they added the link successfully.

any solutions? tia :)

DrkFusion 12-05-2002 01:20 AM

I believe this problem was fixed...hmm well the Validation Feature isn't really something that appeals to me, but I have to say Mark has done an excellent job with it, I will look into it, if you are willing to wait, I will get out a new update as soon as I am not full of work.

Xer 12-06-2002 11:56 AM

thx DrkFusion !!
working on 2.2.9

this hack very nice..
waiting your vb3 Power edition!!

cessna140 12-06-2002 04:42 PM

Not sure if it has been requested or not but how about a "suggest a category" link.

Perhaps it could be set up similar to posting a link but would be moderated. The admin could approve it and have the new category added or disapprove and it would be deleted.

Another option would be to allow users to suggest a new category when posting a link. The admin could add the category or change the category to an existing one when moderating the link?

Would be a nice touch.
Installed on 2.2.8 and working like a champ! Thanks for a great hack!

Visionray 12-06-2002 05:06 PM

Quote:

Originally posted by supreemball
great hack..

only one problem.. seems that when users add some links with ' or commas or other special characters in the description field, they don't show up on validation, even though it says they added the link successfully.

any solutions? tia :)


Yup, that was a bug fix I suggested awhile back that obviously didn't get fixed. MarkB solved it though.

You can find the fix for that in this post.

https://vborg.vbsupport.ru/showthrea...002#post317002

Littlebit 12-06-2002 05:14 PM

Drkfusion,
I haven't got to your hack yet, but as I was reinstalling my hacks after upgrading to 2.2.9, I got an idea...I'll PM you
:smoke:

DrkFusion 12-06-2002 07:48 PM

Visionray, I am sure the v2 had the fixes in them. Sorry

FlyBoy73 12-07-2002 11:28 PM

Wow, this is a great hack. I just spent $195.00 for In-Link's directory and this one looks more appealing to me! lol Think I will sell the In-Link.
Great job, DrkFusion

Littlebit 12-08-2002 05:59 AM

Hi Drk,
I installed and all works great! I love it :cool:
I am wondering if you have already written this part yet or not:
Quote:

UserGroup Permissions (Allow certan usergoups to view/add links)
I guess, would it be similar to the hack used to give the option of what usergroups can see the Calendar?
Anyway, thanks for the very precise instructions too
-littlebit

arracing 12-09-2002 01:56 AM

You should make it so people cannont submit duplicate links if their is already that same link address already submitted.

coolsurfin 12-09-2002 08:55 PM

Hi,
Getting this error when installing
Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: CREATE TABLE `gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` VARCHAR(255) NOT NULL,
`catdesc` TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM
mysql error: You have an error in your SQL syntax near '`gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` V' at line 1

mysql error number: 1064

Date: Monday 09th of December 2002 05:04:24 PM
Script: http://www.coolsurfin.com/forum/foru....php?install=3
Referer: http://www.coolsurfin.com/forum/admi....php?install=2

DrkFusion 12-11-2002 08:18 PM

coolsurfin, run the following manually
[SQL]CREATE TABLE gportal_weblinkscat (
webcatid INT(11) NOT NULL AUTO_INCREMENT,
catname VARCHAR(255) NOT NULL,
catdesc TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM
[/SQL]

buss2002 12-18-2002 07:40 PM

Hi,

1.The hack seems cool...i installed but dont know about the folder with templates in the zip...dont know what to do with them....no instruction for those?

2.Is that link directory suppose to be added to the forum home somehow?I can pull it up tru the url to links.php but isent it supose to be implemented into the forum home page?

3.how do i add a extra field for site owners to put in information
about ther return link?

4. were can i display a rule for adding lnks to the directory?

hope for some help to a newbie -:)

JakeC 12-20-2002 09:40 PM

I'm having a slight difficulty. I have changed around some of my styles tweaking things hear and there and now all of my links and links directories have disappeared. They still show in the forum admin under the links directory section but nothing shows up on the site. also, how many templates are supposed to show up in the custom templates portion of the template set? I only count three in mine. drkslinks_addnewlink, drkslinks_browselink, and drkslinks_main. Here are a couple of screenshots:

Links Directory in the CP

Links directory in the site

My templates

Any help would be very much appreciated.

JakeC

P.S. I'm not completely sure that tweaking my styles had anything to do with the links error. I just happened to notice it after messing with my styles.

JakeC 12-20-2002 10:22 PM

Never mind, I got it. I guess for some reason I lost all but three of my templates. I went ahead and created them by hand and everything is good to go. Thanks.

JakeC

buss2002 12-20-2002 11:01 PM

somebody out there?

Smoothie 12-21-2002 02:43 AM

Hey! Finally got around to installing. Nice Job!
[high]* Smoothie clicks that darn install button. ;)[/high]

Smoothie 12-21-2002 02:45 AM

BTW, it's "category", not catagory. ;)

Dean C 12-21-2002 05:50 AM

Hehe awesome... you installed after all ;) !

Regards

- miSt

arracing 12-21-2002 02:49 PM

if you excluded a domain and you want to bring it back, how do you do that?

DrkFusion 12-21-2002 03:39 PM

Quote:

Originally posted by buss2002
somebody out there?
Some of your questions have been answered in the support forum.

:)

DrkFusion 12-21-2002 03:41 PM

Quote:

Originally posted by Smoothie
BTW, it's "category", not catagory. ;)
I can't start teo tell you how many people told me, lol I keep forgetting when I update, also some people might have problems with html while viewing the Links Directory, there should be a solution to this in this thread, I will look for it, and fix it.

I have started to code the major update of 2.5, on my site I am running 2.5a :) It has major security fixes, and some new features, that have been coded in but not used yet.

DrkFusion 12-21-2002 03:42 PM

Quote:

Originally posted by arracing
if you excluded a domain and you want to bring it back, how do you do that?
Can you please rephrase your question, sorry I do not understand

Regards

Dean C 12-21-2002 04:48 PM

Have you included ratings because this is the only thing thats stopping me from installing?

- miSt


All times are GMT. The time now is 10:53 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02674 seconds
  • Memory Usage 1,832KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete