vb.org Archive - Links and Files Database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Links and Files Database (https://vborg.vbsupport.ru/showthread.php?t=60403)

Quote:

Originally Posted by Imperial Fritz

I meant the uploaded links. :) Don't worry about the translations, I'll redo them manually, not much work as I did only a few pages. :)

Then you will be able to upgrade without problems. There is a minor bug on the admin pages of the available 1.52 , which will be fixed with the next upload this weekend.

Oh wow! I love this hack! THANK YOU SO MUCH!

I had a table full of categorized link items already and wanted to migrate it into Links 1.51 so that it could become the foundation of my collection. It was a duplicated system up to this point where people would use a forum for URL discussion and I was manually updating a table with phpmyadmin. Anyway, this solution fixes all that.

So I wrote my own php script to import the stuff and I figured I'd share it here in case anyone else has to do something similar.

First, use the Links interface to create enough categories to match the ones you were using before;
Then, run a script sort of like the one I've included before to get the toc and linkslinks tables populated with stuff. I used a counter for the key indices and ignored whatever indices I had. I made my items query from newest to oldest (using whatever key IDs I had), as I didn't want to populate Links with older links at the top of pages. I used my own user account for the userid, and a datestamp from a manual link entry to generate the integer for the time.
Although I did notice Links recount how many items were in each category and update the Category records while testing and clicking around, I did it manually anyway by querying (through phpmyadmin) with WHERE catid='n' (cat number) or whatever to get a count for how many items had imported into each category.
Edit category records and insert the actual count of items imported for each.

All of this is a sloppy way of doing it and it shows that I'm a little new to all this. I couldn't get phpmyadmin to generate a CSV file while escaping the commas in my news article quotes, and it was tricking imports into thinking a grammatical comma was defining a new field, and it just wouldn't work.

I then had trouble with apostrophes from words like can't, so I had to use the addslashes() function on the titles and descriptions I was importing.

But it worked, and very well. I was able to populate Links with about 400 links, all into the right categories. Here's the ugly amateurish php script with some extra echo commands I used for testing. You can omit those:

Code:

<?php                                        

                                

$link_id = mysql_connect("localhost", "username", "password");

        

$result=mysql_list_dbs($link_id);

        

mysql_select_db("dbase_name", $link_id);

        

$result=mysql_query("SELECT * FROM tbl_news where newsType in ('Media', 'Research', 'Opinion', 'Inspiration') order by newsID desc", $link_id);

        

if($result) {

        $idx_count=0;

        while($query_data=mysql_fetch_row($result)){

                                        

                $idx_count++;

                                        

                echo "IDX = $idx_count<br>";

                                        

                if ($query_data[2]=="Media")

                        $catid=1;

                if ($query_data[2]=="Research")

                        $catid=3;

                if ($query_data[2]=="Opinion")

                        $catid=4;

                if ($query_data[2]=="Inspiration")

                        $catid=5;

                echo "$query_data[2] catid=$catid<br>";

                                        

                $result2=mysql_query("INSERT local_linksltoc SET 

                        ltoc='',

                        linkid='$idx_count',

                        catid='$catid',

                        displayorder='$idx_count'", $link_id);

                        echo "$idx_count, $catid, $idx_count<br>";

                                        

                        $query_data[3]=addslashes($query_data[3]);

                        $query_data[4]=addslashes($query_data[4]);

                                        

                        $result3=mysql_query("INSERT local_linkslink SET

                                linkid='$idx_count',

                                linkname='$query_data[3]', // newsTitle field

                                linkdesc='$query_data[4]',  // newsBody field

                                linkurl='$query_data[5]',    // newsURL field

                                linkhits='0',

                                linkforum='-999',

                                linkcheck='1108148258',   // whatever is "now"

                                linkstatus='1',

                                linkdate='1108148258',    // whatever is "now"

                                linkusername='username',

                                linkuserid='1',                   // my userid

                                linkmoderate='0',

                                linkmoddate='0',

                                linkreviewfreq='0'", $link_id);

                        if ($result3==1)

                                echo "$idx_count, $query_data[3], $query_data[4], $query_data[5]<br><hr><br>";

                        else

                                echo "<h1>$idx_count - $query_data[3] - ERROR</h1>";

        }

}

mysql_close($link_id);                                

?>

Hope this is useful to somebody.

Attached are FROM (the original news/links database) and TO (Links 1.51) screen caps.

I noted earlier that mass move of links to a different category or mass change of permissions would be very welcome, is there any hope of seeing this in the future? :)

Quote:

Originally Posted by Imperial Fritz

I noted earlier that mass move of links to a different category or mass change of permissions would be very welcome, is there any hope of seeing this in the future? :)

Mass change of permissions is already coded for release in v1.55; I missed the request for mass move, but will give that some thought.

I have a simple question

How can I remove the image on the section place.

For example on a HD links database I run: http://www.juicyduff.com/forum/local...=links&catid=2

The avatar at the top messes things up and I don't want it to be there, how would I make it NOT display there?

"Avatars [img(removethis)]http://www.juicyduff.com/dloadz/avatars/wellysm/2.gif[/img(removethis)]" - Also, that displays on the title at the top near forum navigation ... I want that removed too.

BTW - AWESOME HACK!

Quote:

Originally Posted by Zain Jaffer

Thanks.

Put your image tag into the category description (if you want it to appear in the category listings) or into the extended description (if you want it to show up only in the category itself). Don't put it into the category name.

Hi Andrew,

Perhaps I was too vague and should make myself more clear:

Sorry, but the 2 solutions failed to solve the problem:

Bascically, I want the avatar to remain where it is on the front page but its image NOT be displayed how it is in the link above but to remain where it is.

Here is the main page: http://www.juicyduff.com/forum/local_links.php

You can see that the "wallpapers" images is moved, basically I only want the thumbnails to be on the left handside (category) and no where else.

Thanks, your help is appreciated...

Quote:

Originally Posted by Zain Jaffer

Then you will have to edit a couple of the templates, links_main and links_catbit. links_main is the one that gives you the category title near the top of the page and links_catbit gives you the listing of categories within a page. There are three bits of information that you play with: the category name, its description and its extended description.

As you observe, if you put an image tag (or any other tag) into the category name, then the tag also shows up in the navigation bar as text. (I'll see if I can check for that condition and remove it, but I need to be careful that I don't kill anything else in the process.)

What you could do (easier if you are the only person creating categories on your board) is use the description or its extended description purely to hold the bbcode image tage, and modify the template accordingly.

For example. you could use the description to hold only the image tag and put the accompanying text into the extended description. So, you might edit these lines in the links_main template:

Code:

<tr align="center">

        <td class="tcat" align="center"><strong>$viewcatname</strong>

        <if condition="$catclosed != 0"><span class="smallfont">[closed]</span></if>

        </td>

</tr><tr>

        <td class="alt1"><span class="smallfont">$viewcattext</span></td>

</tr></tbody>

replacing $viewcatname by $viewcatdesc $viewcatname

You would also have to make a similar change in the links_catbit template, where the three variables are $catname, $catdesc amd $cattext.

Code:

<tr valign="top">

<td class="alt$catstyle">

<span class="smallfont">

<if condition="$catnew">

<b>

</if>

<a href="local_links.php?action=links&amp;catid=$catid">$catname</a>

<if condition="$catnew">

</b>

</if>

</span>

</td>

<td class="alt$catstyle">

<table cellpadding="0" cellspacing="0" border="0" width="100%">

<tr><td width="75%">

<span class="smallfont">

<if condition="$catnew">

<b>

</if>

$catdesc

<if condition="$catnew">

</b> (new entry $catdate)

</if>

<if condition="$links_permissions[can_edit_category]">

<a href="local_links.php?action=editcat&amp;catid=$catid">[edit]</a>

</if>

<if condition="$subcatnames"><br /><strong>Sub-categories:</strong> $subcatnames</if>

</span>

</td>

<td class="alt$catstyle" width="25%" align="right">

<span class="smallfont">

<if condition="$links_defaults[count_depth]==0">

[$catsub categ/$catentry entries]

<else />

[$catchildentry entries]

</if>

</span>

</td>

</tr>

</table>

</td>

</tr>

Good luck

Unfortunately that didn't work :(

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 (3)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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.01790 seconds Memory Usage 1,798KB 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 (3)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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: