vb.org Archive
Page 4 of 125 « First 23 4 561454104 Last »
Show 40 post(s) from this thread on one page

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)

dede1 01-27-2004 07:45 PM
linkhits? Is the templates?

Where is to be? I inserted 11 Templates

13th_Disciple 01-27-2004 11:52 PM
updating the database won't be a template.. there is probably a query you didn't run for the install of 0.2

check your install and make sure you followed all directions.. haven't installed this hack, but since it refers to an unknown column, that means there should be a column that isn't there and was probably added by a query for the install..

AndrewD 01-28-2004 04:24 AM
Quote:
Originally Posted by dede1
linkhits? Is the templates?

Where is to be? I inserted 11 Templates

The zip file that you downloaded contained a file called instructions.txt and a file called links_maketable.sql. This is only the beta 0.2 release, so you have to manually run the sql code in the second file, e.g. using phpmyadmin or the command line mysql.exe etc. This sets up the four tables and populates the admin table. The next release will automate this process. Sorry if this is confusing.

After installation, you will have four tables (all with names starting local_links), eleven templates (all with names starting links_) and one php file.

dede1 01-28-2004 06:25 AM
Yes that have I everything made.

Nevertheless this error comes

Natch 01-29-2004 02:07 AM
PM sent re: a HTL version I made for my own use ...

AndrewD 01-29-2004 05:32 PM
Quote:
Originally Posted by dede1
Yes that have I everything made.

Nevertheless this error comes
Pls use VB's adminCP to backup just the 4 local_links tables and pm then to me so that I can take a look.

SpankMe 01-31-2004 03:25 AM
Just installed this and found the following bug:

The userid and username are not added to the links db when a member adds a link.

replace:
PHP Code:
        $DB_site->query("
                INSERT INTO local_linkslink (linkname, linkurl, linkdesc, linkhits, linkforum, linkcheck, linkstatus, linkdate)
                VALUES (
                '".addslashes(htmlspecialchars($linkname))."',
                '$linkurl',
                '".addslashes(htmlspecialchars($linkdesc))."',
                0,
                '$pforum',
                $statustime,
                $statuscheck,
                $statustime
                )
        "); 
with:
PHP Code:
        $DB_site->query("
                INSERT INTO local_linkslink (linkname, linkurl, linkdesc, linkhits, linkforum, linkcheck, linkstatus, linkdate, linkusername, linkuserid)
                VALUES (
                '".addslashes(htmlspecialchars($linkname))."',
                '$linkurl',
                '".addslashes(htmlspecialchars($linkdesc))."',
                0,
                '$pforum',
                $statustime,
                $statuscheck,
                $statustime,
                '".addslashes(htmlspecialchars($bbuserinfo[username]))."',
                $bbuserinfo[userid]
                )
        "); 
and replace:
PHP Code:
    $query = "
                SELECT link.linkid AS linkid, link.linkname AS linkname, 
with:
PHP Code:
    $query = "
                SELECT link.linkid AS linkid, link.linkname AS linkname, link.linkuserid AS linkuserid, 
and add the following:
PHP Code:
        $linkuserid = $myrow["linkuserid"]; 
below this code:
PHP Code:
    while ($myrow=$DB_site->fetch_array($asb)) {
        $linkid     = $myrow["linkid"];
        $linkname   = parse_bbcode2($myrow["linkname"], 1, 1, 1, 1);
        $linkurl    = $myrow["linkurl"];
        $linkhits   = $myrow["linkhits"];
        $linkstatus = $myrow["linkstatus"]; 
also the templates are not setup to show the "edit" link for members own links.

In the links_linkbit template

replace:
HTML Code:
<if condition="$links_permissions[can_edit_link]>
with:
HTML Code:
<if condition="$links_permissions[can_edit_link] or $bbuserinfo[userid] == $linkuserid">
I think thats everything.

AndrewD 01-31-2004 05:52 AM
Quote:
Originally Posted by SpankMe
Just installed this and found the following bug:

The userid and username are not added to the links db when a member adds a link.

etc

I think thats everything.
Thanks - will make these fixes in the main release - the userid code was one of the more recent bits to go in. Appreciate your effort.

daFish 02-02-2004 08:55 AM
<font face="Arial">Great Hack but what about a HTL version?
Is there one available?

-Fish
</font>

AndrewD 02-02-2004 08:58 AM
Quote:
Originally Posted by daFish
Great Hack but what about a HTL version?
Is there one available?

-Fish
Yes, the next beta will be an HTL version - but give me a few days as I've a lot on this week.

Thanks to Natch for the insight into HTL.


All times are GMT. The time now is 06:54 AM.
Page 4 of 125 « First 23 4 561454104 Last »
Show 40 post(s) from this thread on one page

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.01898 seconds
  • Memory Usage 1,768KB
  • 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_html_printable
  • (6)bbcode_php_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