vb.org Archive - vB Links Directory 2.0 *NEW VERSION*

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)

Quote:

Yesterday at 11:58 PM mbowers said this in Post #490
It might benefit future users of this hack if you went through and corrected the spelling of "category". It's "catAgory" in a bunch of places. I think I got them all, but I'm sure my users will let me know if I didn't... :paranoid:

Yeah I want mine spelled right too. :p

I installed this hack and everything is running great, except, I put a border around the table and it is gray.

DOes anyone know how to change the color on this?

Here is the URL:

Board

And I also attached a screen shot showing the border.

I had to hack the template to make it different than the rest of the board.

First of all, yes the new version has the spelling fixes. The categories are still ordered by catname or catid ONLY in this version. I am actually going through this thread finding all the errors and fixing them. There is also a new look to it ;)

Quote:

06-28-03 at 06:24 PM 97cobracpe said this in Post #468
Do you have direct access to you database? If so, do the following:

In the gportal_weblinkslink table, the field named 'hits' has the datatype set to 'text'. Change it to 'int'. I did it on my site, and it worked with no lost information in the hit counters. They all remained intact.

Otherwise, I could modify the install script that when it creates the tables for the database it has the change built it. You would end up having to uninstall the hack, upload the new modifed installer script, and run the new one instead. You would lose all your links this way and have to start over.

This worked like a champ. Thanks for the suggestion!!!

:D

[high]DATABASE FIX[/high]
? This is a required update, if you have installed vB Links Directory before July 10,2003, you must execute this script.

THIS MUST BE RUN AFTER THE INSTALLATION!

Instructions
1. Download the script
2. Upload to admin cp
3. Execute script
4. If all goes well delete it from admin cp

Thanks for the update, never realised that problem!

Ok, I installed this script and when I click on add link I get:

Quote:

Call to undefined function: maketableheaderview() in /home/authorz/public_html/forums/admin/weblinksadmin.php on line 12

Hi,

This hack is very useful thank you, can be viewed at

Anyway I made a little mod, I don't know how this will be affected by the update.

Original code

Quote:

if ($action=="main") {
$ebg = $DB_site->query("SELECT * FROM gportal_weblinkscat ORDER BY catname");
if ($DB_site->num_rows($ebg)) {
while ($myrow=$DB_site->fetch_array($ebg)) {
$hasattach=1;
$catid=$myrow["webcatid"];
$catname=$myrow["catname"];
$catdesc=$myrow["catdesc"];
eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
}
}
eval("dooutput(\"".gettemplate('drkslinks_main')." \");");
}

Modified code

Quote:

if ($action=="main") {
$ebg = $DB_site->query("SELECT a.webcatid, a.catname, a.catdesc, COUNT(b.categoryid) AS catcount FROM gportal_weblinkscat a LEFT OUTER JOIN $gportal_weblinkslink b ON a.webcatid = b.categoryid GROUP BY a.webcatid, a.catname, a.catdesc ORDER BY a.catname ASC;");
if ($DB_site->num_rows($ebg)) {
while ($myrow=$DB_site->fetch_array($ebg)) {
$hasattach=1;
$catid=$myrow["webcatid"];
$catname=$myrow["catname"];
$catdesc=$myrow["catdesc"];
$catcount=$myrow[catcount];
eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
}
}
eval("dooutput(\"".gettemplate('drkslinks_main')." \");");
}

Basically I can now count the number of items in each category so if you see I get a total links in category.

If you haven't already done this thought it would make a nice addition, can you let me know if your db update php will affect my mod please?

Regards

Russ

Can someone help please?

I have registered members and Premium (Group) members.

I only want to allow the Premium group members to be able to submit links.

How can I get this done?

Somebody please help?

Max

I still get:
Fatal error: Call to undefined function: maketableheaderview() in /home/authorz/public_html/forums/admin/weblinksadmin.php on line 12
whe I click View all Links in the cp.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01487 seconds Memory Usage 1,746KB 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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: