vb.org Archive

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)

AndrewD 05-12-2005 04:24 AM

Quote:

Originally Posted by Tradjick
When i save the settings i run into the following error. It saves things correctly, but what is it that?s causing this?

Warning: implode(): Bad arguments. in /local_links_admin.php on line 730

Warning: implode(): Bad arguments. in /local_links_admin.php on line 837

One of the arguments being passed from the permissions form to the script is bad. This shouldn't happen. Have you edited the admin templates at all?

Please can you upload the attached version of local_links_admin.php and go through the process of saving the settings. It will not actually save anything, but instead will produce a page of debugging messages. Pls send these to me by PM so I can take a look. Once you're done, just re-upload the original loccal_links_admin.php

AndrewD 05-12-2005 05:11 PM

Quote:

Originally Posted by AndrewD
One of the arguments being passed from the permissions form to the script is bad. This shouldn't happen. Have you edited the admin templates at all?

Please can you upload the attached version of local_links_admin.php and go through the process of saving the settings. It will not actually save anything, but instead will produce a page of debugging messages. Pls send these to me by PM so I can take a look. Once you're done, just re-upload the original loccal_links_admin.php

I don't understand why, but the value of monitor_dir is being returned from the form in the wrong format. I cannot reproduce this. However, the attached version of local_links_admin.php should correct the bug. Can you try?

Can you also let me know what version of php you are using.

Tradjick 05-12-2005 07:32 PM

Excellent! It works now.

Is that problem also fixed for future updates?

Thank you so much!

AndrewD 05-13-2005 04:13 AM

Quote:

Originally Posted by Tradjick
Excellent! It works now.

Is that problem also fixed for future updates?

Thank you so much!

Good, fixed and uploaded and imprinted on my mind...

joeychgo 05-13-2005 01:31 PM

INstalled again on my new Mopar Forum - Thanks for the great hack!

CHIngs 05-16-2005 12:55 AM

On the next version, can you please include a feature where we can limit ONE DOWNLOAD until the TIME SPECIFIED?

Because I tried it on my own and it didnt seem to quite work.

AndrewD 05-16-2005 05:21 AM

Quote:

Originally Posted by CHIngs
On the next version, can you please include a feature where we can limit ONE DOWNLOAD until the TIME SPECIFIED?

Because I tried it on my own and it didnt seem to quite work.

Thanks for the suggestion. Do you mean:

- When a user enters a link/file, she specifies the first time at which it can be accessed? (e.g. at 15:00 on the 1st June)

or

- The administrator can set up the database for that people can only make multiple downloads at certain times of day? (e.g. between 09:00 and 12:00)

or something else?

Slave 05-16-2005 08:44 AM

++++ .. I was happily adding links to my db and I suddenly get the following error message ..

Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                SELECT DISTINCT link.linkid AS linkid, link.linkname AS linkname, link.linkuserid AS linkuserid,
                        link.linkusername AS linkusername, link.linkurl AS linkurl, link.linkimg AS linkimg, link.linkdesc AS linkdesc,
                        link.linkhits AS linkhits, link.linkstatus AS linkstatus, link.linkdate AS linkdate,
                        link.linkmoderate AS linkmoderate,
                        ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder, ltoc2.catid AS linkcatid2
                FROM (local_linkslink AS link
                LEFT JOIN local_linksltoc AS ltoc
                ON link.linkid = ltoc.linkid)
                LEFT JOIN local_linksltoc AS ltoc2
                ON link.linkid = ltoc2.linkid
                WHERE
                        ltoc.catid = '6'
                        AND link.linkforum NOT IN (0)
               
                ORDER BY linkdorder ASC, linkname ASC,  linkcatid ASC
               
mysql error: Can't open file: 'local_linkslink.MYD'. (errno: 145)

mysql error number: 1016

Date: Monday 16th of May 2005 10:40:41 AM
Script: /local_links.php?catid=6
Referer: /local_links.php?action=links&catid=-1
Username: Slave
IP Address: 81.433.23.12

So I go and have a look at the local_linkslink table within the db and it's empty! and semingly corrupted ..

:(

So a quick reminder to peeps to keep things backed up .. just in case! Luckily I've got a backup from a few days ago I think so it's not too bad ..

AndrewD .. anything in the code that would cause this? .. or have you heard anything like that before?

AndrewD 05-16-2005 08:48 AM

Quote:

Originally Posted by Slave
++++ .. I was happily adding links to my db and I suddenly get the following error message ..

[code]Database error in vBulletin 3.0.3:

So a quick reminder to peeps to keep things backed up .. just in case! Luckily I've got a backup from a few days ago I think so it's not too bad ..

AndrewD .. anything in the code that would cause this? .. or have you heard anything like that before?

Ouch!

I've not seen this happen before - as you say, it looks like a corrupt database table.

I've found that it's worthwhile doing regular optimize/repair checks on your database - the VB admin page permits this, or phpmyadmin can do it also.

Slave 05-16-2005 08:50 AM

In fact I went one step further and repaired the table using the vB tools.php within the admin folder ..

/me wipes his brow!

Slave 05-16-2005 08:56 AM

Quote:

Originally Posted by AndrewD
Ouch!

I've not seen this happen before - as you say, it looks like a corrupt database table.

I've found that it's worthwhile doing regular optimize/repair checks on your database - the VB admin page permits this, or phpmyadmin can do it also.

Yeah .. I found the repair option :) .. didn't even know it was there.

Lucky I did before I did something stupid and overwrote the db with a backup .. it doesn't look like I've lost anything .. :)

CHIngs 05-17-2005 12:16 AM

Quote:

Originally Posted by AndrewD
Thanks for the suggestion. Do you mean:

- When a user enters a link/file, she specifies the first time at which it can be accessed? (e.g. at 15:00 on the 1st June)

or

- The administrator can set up the database for that people can only make multiple downloads at certain times of day? (e.g. between 09:00 and 12:00)

or something else?

Both the ideas you just said seem good to be included as well.

But what I mean is that, say a user clicks on a link, the script should LOG the exact second/minute/hour/day (and other info) in the database. In the ADMIN PANEL, I will specify the intervals between each download, say 60 seconds. So if a user tries to download another file within 60 seconds, it will give him/her an error message saying they have to wait 60 seconds until the NEXT download.

The code may look something similar to this:
PHP Code:

if ($time_of_download >= $current_time 60)
{
echo (
"Please wait 60 seconds until next download");


And you can make this feature GLOBAL (easy) or for individual category where the admin can specify individual times (a little more work). Its your choice.

But all I am asking is that, somehow, please try your best to include this feature in the next release, or a mini release :rolleyes: .

AndrewD 05-17-2005 04:13 AM

Quote:

Originally Posted by CHIngs
But what I mean is that, say a user clicks on a link, the script should LOG the exact second/minute/hour/day (and other info) in the database. In the ADMIN PANEL, I will specify the intervals between each download, say 60 seconds. So if a user tries to download another file within 60 seconds, it will give him/her an error message saying they have to wait 60 seconds until the NEXT download.

This feature is already coded as a global setting. You set the parameter timeout_hit_allow on the admin panel to the number of seconds between successive downloads. Let me know if you have problems with it.

CHIngs 05-18-2005 12:17 AM

Quote:

Originally Posted by AndrewD
This feature is already coded as a global setting. You set the parameter timeout_hit_allow on the admin panel to the number of seconds between successive downloads. Let me know if you have problems with it.

Do you have it in version 1.55? cause I cannot see it :(

Lizard King 05-18-2005 02:12 AM

Quote:

Originally Posted by CHIngs
Do you have it in version 1.55? cause I cannot see it :(

The supported version is 1.60c I advise you to upgrade to the latest version.

AndrewD 05-18-2005 04:16 AM

Quote:

Originally Posted by Lizard King
The supported version is 1.60c I advise you to upgrade to the latest version.

Indeed. This feature was added by request in version 1.56.

When upgrading, remember to check all the steps. It's important to upload/install the latest phrases and templates as well as code.

CHIngs 05-18-2005 07:34 PM

Quote:

Originally Posted by AndrewD
Indeed. This feature was added by request in version 1.56.

When upgrading, remember to check all the steps. It's important to upload/install the latest phrases and templates as well as code.

I know this is a stupid question but I just want to be sure. I can upgrade from 1.55 to 1.60c directly right? or do I first have to upgrade to 1.56 and then to 1.60c?

Because to make sure the script fits my template, I had to do some modifications. I dont want to lose anything in my database. I backed up everything tho, so thats cool.

Lizard King 05-19-2005 03:52 AM

Quote:

Originally Posted by CHIngs
I know this is a stupid question but I just want to be sure. I can upgrade from 1.55 to 1.60c directly right? or do I first have to upgrade to 1.56 and then to 1.60c?

Because to make sure the script fits my template, I had to do some modifications. I dont want to lose anything in my database. I backed up everything tho, so thats cool.

Yes you can upgrade from 1.55 to 160c without upgrading to 1.56. Just download the file and follow the instructions in Readme.txt
It wont take you more then 3-4 minutes to upgrade.

playstation 05-19-2005 10:31 AM

Working great.

Thank you.

*clicks install*

Bhuwan 05-24-2005 11:49 PM

I am using this as a way to hide my links for downloads and unfortunately i've found a major bug that defeats the purpose of the this hack :(

Bhuwan 05-25-2005 12:08 AM

fixed

Ranma2k 05-26-2005 11:58 PM

Hi AndrewD,

First i want to say thanks for the hack :) it helped me a lot .. and i hope you can upgrade it to work with vb 3.5.0 when it releases :D

Second : I wrote a script that extend your hack to help my website needs (A Ticket system )
i have been using it on my site for a quite time now ..
I received a request from people to share the ticket system with them but since it's originally your hack + the addon script i was wondering if it's ok to do so ?!

Thanks

Kei Kurono 05-27-2005 02:03 PM

How do i make it so instead of linking direct urls like this


I can link like this

Quote:

/stuff/godzilla.mp3
Can anybody please show me how ?

Yes when you add links it says you can do that but i have tried and it says i got the link wrong.

What am i doing wrong ?

AndrewD 05-27-2005 03:00 PM

Quote:

Originally Posted by Ranam2k
Hi AndrewD,

First i want to say thanks for the hack :) it helped me a lot .. and i hope you can upgrade it to work with vb 3.5.0 when it releases :D

Second : I wrote a script that extend your hack to help my website needs (A Ticket system )
i have been using it on my site for a quite time now ..
I received a request from people to share the ticket system with them but since it's originally your hack + the addon script i was wondering if it's ok to do so ?!

Thanks

Thanks - I'm very happy for you to share the work - the only proviso is that if it leads to support requests back in this forum, we need to sort out the details, so that we're not looking after multiple code versions. I'm sure you will handle this just fine.

AndrewD 05-27-2005 03:09 PM

Quote:

Originally Posted by Kei Kurono
How do i make it so instead of linking direct urls like this

Not sure - by default, if you create a link to a file called sally.pdf on your site, which is in subdirectory /fred/jim then you should be able to specify either
Code:

http://yoursite.com/fred/jim/sally.pdf
or
Code:

/fred/jim/sally.pdf
. Be aware that the default starting point is the root of your web site, not your forum directory, so if you are trying to get at a subdirectory of your forums, then you need to stick the forum directory name at the start of the structure.

If you change the parameter local_file_root (lf admin page) from 0 to 1, then the file is specified relative to your server's file system. This gives a way to store files outside the directory structure, provided you're careful about security settings on your site.

Slave 05-30-2005 07:52 AM

Hi AndrewD :)

Any chance you could make it so that when you create a linked sub forum the system also creates a link within that category back to the forum in question.

I'm just thinking about the "circle" users take .. They look at a forum, see the link to the category, click it, checkout the links, they then want to get back to the forum they were in. It would be nice if, near the top, there was a link to that forum.

AndrewD 05-30-2005 09:16 AM

Quote:

Originally Posted by Slave
Hi AndrewD :)

Any chance you could make it so that when you create a linked sub forum the system also creates a link within that category back to the forum in question.

I'm just thinking about the "circle" users take .. They look at a forum, see the link to the category, click it, checkout the links, they then want to get back to the forum they were in. It would be nice if, near the top, there was a link to that forum.

Good idea - I have a stack of 'tidying up' changes waiting to release in 1.61 - mainly those suggested by catalyst - I'll give this some thought. I'm hoping that the VVB3.5 plugin system is not going to require too many changes

Spinball 05-30-2005 01:07 PM

While we're in 'suggestions mode', I'd like to suggest the option of having category be a link elsewhere.
For example, we have a home cinema installers directory. It's a thread in which people pay to have an entry. It's a list of links but since people pay for it, I want it to be maintained by myself within a specific forum.
I'd like to be able to include it in the links database using a link to that specific thread as the category link.

In a similar way to forum categories being links elsewhere.
Is this possible?

Slave 05-30-2005 07:12 PM

Quote:

Originally Posted by AndrewD
Good idea - I have a stack of 'tidying up' changes waiting to release in 1.61 - mainly those suggested by catalyst - I'll give this some thought. I'm hoping that the VVB3.5 plugin system is not going to require too many changes

Cool :)

One other thing while you're there ..

Any chance you could make it that we can pick a vB style per category? or the same style as the forum I link the category to?

Goodspeed 05-30-2005 10:32 PM

Great hack!

But there is one important question: is it possible to convert pafiledb database into this hack?

Thank you!

AndrewD 05-31-2005 04:26 AM

Quote:

Originally Posted by Goodspeed
Great hack!

But there is one important question: is it possible to convert pafiledb database into this hack?

Thank you!

I'm sure it's possible - but I've never used pafiledb.

a) Can you code in php? If so, you could use the source code in the subdirectory upgrade_vblinks (see the release zip file) as a template
b) can pafiledb export its contents in some readable format? If so, we could probably tweak that format to be imported here.

AndrewD 05-31-2005 04:28 AM

Quote:

Originally Posted by Slave
Cool :)

One other thing while you're there ..

Any chance you could make it that we can pick a vB style per category? or the same style as the forum I link the category to?

Will have a look - second option is probably the easier

Arial 05-31-2005 12:10 PM

Hi

Can you tell me how I can allow somebody to use the 'ADD LINK' function if they are not a admin on the forum, can it be done via groups somehow?

AndrewD 05-31-2005 12:13 PM

Quote:

Originally Posted by Arial
Hi

Can you tell me how I can allow somebody to use the 'ADD LINK' function if they are not a admin on the forum, can it be done via groups somehow?

Straightforward - select links/administration/permissions and settings and specify the user groups who should have this (or any other) privilege.

The code works on VBulletin extended user groups so anybody who is either a primary or secondary member of the specified groups gains the right to add links.

wattieuk 06-01-2005 04:13 PM

Installed this but there was no facility to add links. Checked the permissions and reinstalled the hack but still no joy. Gave me the admin page, just no way at all of ading categories and links. Therefore it proved uselss for me, but must have being doing something wrong although I followed the steps to the letter.

AndrewD 06-02-2005 10:54 AM

Quote:

Originally Posted by wattieuk
Installed this but there was no facility to add links. Checked the permissions and reinstalled the hack but still no joy. Gave me the admin page, just no way at all of ading categories and links. Therefore it proved uselss for me, but must have being doing something wrong although I followed the steps to the letter.

Have you created a category? Until you do so, there is nowhere to put any links. The 'add link' command is only visible when you are in a place where the links can be stored, i.e. withi categories. This is the only thing I can think of.

wattieuk 06-02-2005 11:58 AM

thanks for the reply but there was no way to add a category either. :disappointed:

AndrewD 06-02-2005 03:35 PM

Quote:

Originally Posted by wattieuk
thanks for the reply but there was no way to add a category either. :disappointed:

Then something must have been missed out during the installation - can you pm me details of your board and ideally an admin username and pwd so I can take a look.

rmorley 06-03-2005 04:01 PM

I installed v1.60, and set the Moderate_links setting to 1. I then created a catagory, and added a couple of links via an admin user. These instantly appears, since I was the admin. That's OK. I then went to the website agian on another computer, did not log into the Vbulletin software, created another link, and it too showed up, even though I was not logged in.

It looks as though I am doing someting wrong because I cannot get the moderation to kick in for non-administrators. I double checked the permissions, and administrators are the only group set to handle the moderation of new links.

Any ideas?

Thanks
Rob

AndrewD 06-03-2005 07:32 PM

Quote:

Originally Posted by rmorley
I installed v1.60, and set the Moderate_links setting to 1. I then created a catagory, and added a couple of links via an admin user. These instantly appears, since I was the admin. That's OK. I then went to the website agian on another computer, did not log into the Vbulletin software, created another link, and it too showed up, even though I was not logged in.

It looks as though I am doing someting wrong because I cannot get the moderation to kick in for non-administrators. I double checked the permissions, and administrators are the only group set to handle the moderation of new links.

Any ideas?

Thanks
Rob

If a link is created by a user who is authorised to moderate links, then the link is immediately accepted. Moderation only applies to links created by users who are not authorised to moderate. I suspect that is what you are seeing.

The separate question is how to create links that can only be viewed by certain users. You do this by associating the link with a VB forum which has the required viewing permissions.


All times are GMT. The time now is 08:12 AM.

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.04032 seconds
  • Memory Usage 1,867KB
  • 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
  • (1)bbcode_php_printable
  • (25)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