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)

True, but I doubt I could find adequate time to provide consistent support, so I don't guarantee it. Anyway, what ideas would you integrate? I like the comments extension, but I'm thinking it might need a new layout, perhaps a while loop to template each comment, pagination on the view all list, maybe a link to comment instead of the comment box, blah blah. None too hard, just some of that time... ;)

Quote:

Originally Posted by AndrewD

.. as do we all ...

Actually, I'm quite happy to integrate some of these ideas into the main code - this is has been happening all along for this hack.

Quote:

Originally Posted by AndrewD

Actually, I'm quite happy to integrate some of these ideas into the main code - this is has been happening all along for this hack.

Which is what I'll be waiting for .. I'd much perfer to see the comments subhack as part of the main hack .. with all of the intergration that would include (permissions etc) ..

Looking forward to it if it happens, but saying that I'm very happy with the hack as it is .. :)

<font face="Courier New">
While I cannot guarantee completeness, accuracy, or support, here are some LFDB hack suggestions. The input is checked (intval, addslashes, etcetera) but there are spots that do not set default values or check permissions should someone save the HTML, mess with the HTML, and then submit changes to the script, or should someone alter or create a query string and submit changes that way. For example, a user who does not have permission to add a link could set $action to doaddlink and add a link even though, when $action is set to addlink, the user is told to bugger off. Another example is when $action is set to dosendtofriend. Pass the appropriate variables and send email even though, when $action is set to sendtofriend, permissions are checked. Suggestions, FWIW.
</font>

In local_links.php find:

Code:

if ($_REQUEST['action'] == "doeditlink") {

And afterwards find:

Code:

                foreach ($pcatid as $p) {

                        $DB_site->query("

                        INSERT INTO ".THIS_TABLE."linksltoc (linkid, catid)

                        VALUES ('$viewlinkid', '$p')

                        ");

                }

And replace with:

Code:

                foreach ($pcatid as $p) {

                        $DB_site->query("

                        INSERT INTO ".THIS_TABLE."linksltoc (linkid, catid)

                        VALUES ($viewlinkid, ".intval($p).")

                        ");

                }

Maybe it'd be better to check that $pcatid (and other variables) contain valid value(s) before getting to a query. FWIW. :)

Calorie - I'm very happy to have these suggestions, particularly to improve stability, etc. But it would probably be easier for others and for me if you simply PM me or email me with your comments rather than overloading this thread.

Thanks and OK?

As I couldn´t find a ´m trying to set this up as a store directory where users can submit their articles and services, which they can trade with the ushop money OR with the money from a partner assossiation.

It seems to be very easy, but i just have the following questions:

Is it possible that a user can edit only his own links and not those submitted by others?

Is there a way to tell in the template the instruction that:

if the category is not one of the following (1,4,6,7,9), bypass this and that.

(i need such a conditional for having the rating feature only for selected categories, or f.ex. remove the "new link textfield box", etc.)

Or maybe there´s a better way for doing this? I don´t know.

I´d be very happy if someone can help me.

Quote:

Originally Posted by Tradjick

Is it possible that a user can edit only his own links and not those submitted by others?

This is already possible. A link can always be edited by the submitting user and *also* by users who are in groups that have *can_edit_link* privilege (go to the links admin page). By default, *can_edit_link* is set so that only members of the admin group have this privilege.

Quote:

Originally Posted by tradjick

Is there a way to tell in the template the instruction that:

if the category is not one of the following (1,4,6,7,9), bypass this and that.

(i need such a conditional for having the rating feature only for selected categories, or f.ex. remove the "new link textfield box", etc.)

Or maybe there?s a better way for doing this? I don?t know.

I?d be very happy if someone can help me.

I'll think about this and let you know.

Thanks, Andrew!

I´m going on with the following condition in order to choose the available features per category:

<if condition="$viewcatid == X">action here...</if>

I´m currently trying to figure out how to create an attitional userfield in order to fetch the value into a template, but it´s not so easy. :hurt:

I just altered the links_linkbit a little bit. If anyone likes it, here?s the code:

HTML Code:

<tr>  <td class="alt$linkstyle" colspan="2">  <fieldset class="fieldset" style="margin: 0px 0px 0px 0px;">  <legend style="background: white; border: 2px;">    </legend>  <table cellpadding="0" cellspacing="0" border="0" width="100%"><tr>  <if condition="$linkimg">  <td width="$linkimgsize">  <if condition="$linkurl"><a <if condition="$linkmode<2">href="local_links.php?action=jump&amp;id=$linkid"<else />href="$linkurl"</if> target="_blank"></if>  <img src="local_resize.php?pic=$linkimg&amp;size=$linkimgsize" border="0" alt="" /><if condition="$linkurl"></a></if>  </td>  <td width="2">&nbsp;</td>  </if>  <td valign="bottom">      <fieldset class="fieldset" style="margin: 5px 0px 5px 10px;">  <legend><strong>  <if condition="$linkurl">$linktypebit <a <if condition="$linkmode<2">href="local_links.php?action=jump&amp;id=$linkid"<else />href="$linkurl"</if> target="_blank"></if>$linkname<if condition="$linkurl"></a></if>  <if condition="$linknew">$vbphrase[ll_new]</if>  </strong>  <if condition="$links_permissions[can_mark_link]">  <if condition="$linkfav">  <if condition="$viewcatid!=-2"> <span class="highlight">$vbphrase[ll_myfav]</span></if>  [<a href="local_links.php?action=dofavlink&amp;id=$linkid&amp;set=-1&amp;catid=$viewcatid&amp;page=$pagenumber" title="$vbphrase[ll_myfav_del]">$vbphrase[ll_ab_favminus]</a>]  <else />  [<a href="local_links.php?action=dofavlink&amp;id=$linkid&amp;set=1&amp;catid=$viewcatid&amp;page=$pagenumber" title="$vbphrase[ll_myfav_add]">$vbphrase[ll_ab_favplus]</a>]  </if>  <if condition="$links_permissions[can_send_tofriend]">  [<a href="local_links.php?action=sendtofriend&amp;id=$linkid" target="_blank" title="$vbphrase[ll_sendtofriend]">$vbphrase[ll_ab_send]</a>]  </if>  </if>  &nbsp;        <if condition="$viewcatid == 4"><span align = "right" style="color : green; align : right; text-decoration : underline;">==OFFRE==</span></if>  </legend>      <BR />  <span class="smallfont">  $linkdesc  <if condition="$linkshowothercatbit>0"><br /><br />$vbphrase[ll_seealso] $linkothercatsbit</if>  </span>  </td>    <td width="25%" align="right" valign="bottom">  <fieldset class="fieldset" style="margin: 5px 5px 5px 5px;">  $linkratebit  <span class="smallfont">  $linkdate  <if condition="$linkstatus>1"> [$linkstatus $vbphrase[ll_kb]]</if>  <if condition="$linkstatus==0"> [$vbphrase[ll_unknown_status]]</if>  <if condition="$links_permissions[can_view_hits]">  <br />$vbphrase[ll_submitby] <a href="member.php?u=$linkuserid">$linkusername</a>  <br />$vbphrase[ll_hits] $linkhits  </if>  <if condition="$links_permissions[can_rate_link]">  <br />$vbphrase[ll_rate]   <a href="local_links.php?action=doratelink&amp;vote=1&amp;id=$linkid&amp;catid=$viewcatid&amp;page=$pagenumber">1</a>/  <a href="local_links.php?action=doratelink&amp;vote=2&amp;id=$linkid&amp;catid=$viewcatid&amp;page=$pagenumber">2</a>/  <a href="local_links.php?action=doratelink&amp;vote=3&amp;id=$linkid&amp;catid=$viewcatid&amp;page=$pagenumber">3</a>/  <a href="local_links.php?action=doratelink&amp;vote=4&amp;id=$linkid&amp;catid=$viewcatid&amp;page=$pagenumber">4</a>/  <a href="local_links.php?action=doratelink&amp;vote=5&amp;id=$linkid&amp;catid=$viewcatid&amp;page=$pagenumber">5</a> *  </if>  <if condition="$links_permissions[can_moderate_links] and $linkstatus==$LINK_HIDDEN">  <br />  [$vbphrase[ll_hidden]]  </if>  <if condition="$links_permissions[can_edit_link] or $bbuserinfo[userid] == $linkuserid">  <br />  <a href="local_links.php?action=editlink&amp;linkid=$linkid&amp;catid=$viewcatid&amp;page=$pagenumber" title="$vbphrase[ll_edit]">$vbphrase[ll_editlc]</a>  </if>  </span>  </td>  </fieldset>  </fieldset>  </tr>  </table>  </fieldset>  </td>  </tr>

Does one have to make the line breaks manually in vB HTML code? I copied from Uedit.

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

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 (1)bbcode_html_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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.03468 seconds Memory Usage 1,787KB 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_html_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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: