SMF Links

[Elen]

The only problem I still have with it is when I go to set permissions there is no text against the tick boxes.  I had a look at the source code so figured out which tick box was for what but life would be a lot simpler if there was some text there.  At forst I wondered if it was something to do with the theme I'm using, that maybe the text was there but not visible but looking at the source code, it's definitely not there at all.

[SMFHacks]

You don't have something like this?



Are you using another language other than english for your forum?

[Elen]

The only language I have on the Forum is English.  This is what my Permissions screen looks like.


As you can see, the check boxes are there but the text labels next to them are not.  Apart from that it all works really well - the mod is just what I was looking for

[SMFHacks]

Open up Modifications.english.php

Add these before ?>

Code: [Select]

//Begin SMF Links Text Strings
$txt['smflinks_menu'] = 'Links';
$txt['permissiongroup_smflinks'] = 'SMF Links';
$txt['permissionname_view_smflinks'] = 'View Links Page';
$txt['permissionhelp_view_smflinks'] = 'Sets if the user can view the links page.';
$txt['cannot_view_smflinks'] = 'You can not view the links page.';
$txt['permissionname_add_links'] = 'Add Links';
$txt['permissionhelp_add_links'] = 'If the user is allowed to submit links';
$txt['cannot_add_links'] = 'You can not add links.';
$txt['permissionname_edit_links'] = 'Edit Links';
$txt['permissionhelp_edit_links'] = 'If the user is allowed to edit links';
$txt['cannot_edit_links'] = 'You can not edit links.';
$txt['permissionname_delete_links'] = 'Delete Links';
$txt['permissionhelp_delete_links'] = 'If the user is allowed to delete links';
$txt['cannot_delete_links'] = 'You can not delete links.';
$txt['permissionname_approve_links'] = 'Approve Links';
$txt['permissionhelp_approve_links'] = 'If the user is allowed to approve links';
$txt['cannot_approve_links'] = 'You can not approve links.';
$txt['permissionname_links_auto_approve'] = 'Links Auto Approved';
$txt['permissionhelp_links_auto_approve'] = 'If the users links are auto approved when submitted.';
$txt['permissionname_rate_links'] = 'Rate Links';
$txt['permissionhelp_rate_links'] = 'If the user is allowed to rate links';
$txt['cannot_rate_links'] = 'You are not allowed to rate links.';
$txt['permissionname_links_manage_cat'] = 'Manage Categories';
$txt['permissionhelp_links_manage_cat'] = 'User can add/remove/edit/reorder categories';
$txt['cannot_links_manage_cat'] = 'You are not allowed to manage categories.';
//END SMF Links Strings


[Elen]

Thanks for the code - that fixed it   I had 2 Modifications.english.php files - one in the default theme which did have that code and one in the theme I'm using, which didn't - now I've added it, the text shows up.

Thanks you again for your help - it's a great Mod

[penny]

I added the option that people can add their own banner!

In each table "top 5 rated, top 5 visited, category" in links.template.php i added the banner option:

Here an example of a table, because i don't know how to show it otherwise 

Code: [Select]

echo '<table border="0" cellpadding="0" cellspacing="0" width="50%">
  <tr>
    <td width="100%">';

//Show Top 5 rated
echo '<div class="tborder" style="margin: 2%;"><div class="catbg2" align="center">Top Five Rated Links</div>';
$dbresult = db_query("SELECT l.ID_LINK, l.rating, l.title,l.date, m.memberName, l.ID_MEMBER,banner,l.description,l.hits FROM {$db_prefix}links AS l, {$db_prefix}members AS m WHERE  l.ID_MEMBER = m.ID_MEMBER AND l.approved = 1 ORDER BY l.rating DESC LIMIT 5", __FILE__, __LINE__);
while($row = mysql_fetch_assoc($dbresult))
{
echo '<div class="tborder" style="margin: 2%;"><div><a href="' . $scripturl . '?action=links;sa=visit;id=' . $row['ID_LINK'] . '" target="blank">' . $row['title'] . '</a></div>';
echo '<div class="banner" style="margin: 2%;"><a href="' . $scripturl . '?action=links;sa=visit;id=' . $row['ID_LINK'] . '" target="blank"><img src=" ' . $row['banner'] . '" maxwidth="468" maxheight="60"></a></div>';
echo '<div class="banner">' . nl2br($row['description']) . '<br /><br />';
echo 'Hits: ' . $row['hits'] . '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Rating: ' . $row['rating'];
if($ratelink)
echo '&nbsp;<a href="' . $scripturl . '?action=links;sa=rate;value=1;id=' . $row['ID_LINK'] . '"><img src="', $settings['images_url'], '/post/good.gif" alt="Good Link" border="0" /></a>&nbsp;&nbsp;<a href="' . $scripturl . '?action=links;sa=rate;value=0;id=' . $row['ID_LINK'] . '"><img src="', $settings['images_url'], '/post/bad.gif" alt="Bad Link" border="0" /></a>' .'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Comments:' .'&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://pinklady.ath.cx/MPCS/comment.php?pageid=1" target="_blank">Comments</a><br>';
echo '<br /></div>';
if($editlink)
echo '<a href="' . $scripturl . '?action=links;sa=editlink;id=' . $row['ID_LINK'] . '">[Edit]</a>&nbsp;';
if($deletelink)
echo '<a href="' . $scripturl . '?action=links;sa=deletelink;id=' . $row['ID_LINK'] . '">[Delete]</a>
<br />';
echo ' Submitted by:<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">'  . $row['memberName'] . '</a>&nbsp;<font class="smalltext">Added on ' . timeformat($row['date']) . '</font><br>';
echo '</div></div><br />';
}
echo '</div>';

echo '</td>';


echo '</tr>
</table>';
Also add in links.template.php:


After code:

Code: [Select]

<tr>
    <td width="28%" height="22" class="windowbg2"><span class="gen"><b>Url</b></span></td>
    <td width="72%" height="22" class="windowbg2"><input type="text" name="url" size="64" maxlength="250" value="http://" /></td>
  </tr>
Insert this code after above code!

Code: [Select]

<tr>
    <td width="28%" height="22" class="windowbg2"><span class="gen"><b>Banner(maxwidth 468px and maxheight 60px)</b></span></td>
   <td width="72%" height="22" class="windowbg2"><input type="text" name="banner" size="64" maxlength="250" value="http://" /></td>
  </tr>

The links.php: ( search for all the "banner" words and add those lines/words in your links.php )

Code: [Select]

<?php
/*
SMF Links
Version 1.1
by:vbgamer45
http://www.smfhacks.com
*/

if (!defined('SMF'))
die('Hacking attempt...');

function LinksMain()
{

//Load the main links template
loadtemplate('Links');

//Link actions
$subActions = array(

'addlink' => 'AddLink',
'addlink2' => 'AddLink2',
'editlink' => 'EditLink',
'editlink2' => 'EditLink2',
'visit' => 'VisitLink',
'deletelink' => 'DeleteLink',
'deletelink2' => 'DeleteLink2',
'catup' => 'CatUp',
'catdown' => 'CatDown',
'addcat' => 'AddCat',
'addcat2' => 'AddCat2',
'editcat' => 'EditCat',
'editcat2' => 'EditCat2',
'deletecat' => 'DeleteCat',
'deletecat2' => 'DeleteCat2',
'rate' => 'RateLink',
'approve' => 'Approve',
'noapprove' => 'NoApprove',
'alist' => 'ApproveList'
);


// Follow the sa or just go to main links index.
if (!empty($subActions[@$_GET['sa']]))
$subActions[$_GET['sa']]();
else
view();

}
function view()
{
global $context, $mbname;

//Check if the current user can view the links list
isAllowedTo('view_smflinks');

//Load the main index links template
$context['sub_template']  = 'main';

//Set the page title
$context['page_title'] = $mbname . ' - Links';
}
function AddCat()
{
global $context, $mbname;
isAllowedTo('links_manage_cat');

$context['sub_template']  = 'addcat';

//Set the page title
$context['page_title'] = $mbname . ' - Links - Add Category';

}
function AddCat2()
{
global $db_prefix;
isAllowedTo('links_manage_cat');

//Clean the input
$title = htmlentities($_POST['title'], ENT_QUOTES);
$description = htmlentities($_POST['description'], ENT_QUOTES);

if($title == '')
fatal_error('You need to enter a category title');

//Do the order
$dbresult = db_query("SELECT roworder FROM {$db_prefix}links_cat ORDER BY roworder DESC", __FILE__, __LINE__);
$row = mysql_fetch_assoc($dbresult);

$order = $row['roworder'];
$order++;

//Insert the category
$request = db_query("INSERT INTO {$db_prefix}links_cat
(title, description,roworder)
VALUES ('$title', '$description',$order)", __FILE__, __LINE__);
mysql_free_result($dbresult);

$_POST = '';

redirectexit('action=links');


}
function EditCat()
{
global $context, $mbname;
isAllowedTo('links_manage_cat');

$context['sub_template']  = 'editcat';

//Set the page title
$context['page_title'] = $mbname . ' - Links - Edit Category';

}
function EditCat2()
{
global $db_prefix;
isAllowedTo('links_manage_cat');

//Clean the input
$title = htmlentities($_POST['title'], ENT_QUOTES);
$description = htmlentities($_POST['description'], ENT_QUOTES);
$catid = htmlentities($_POST['catid'], ENT_QUOTES);

if($title == '')
fatal_error('You need to enter a category title');

//Update the category
$request = db_query("UPDATE {$db_prefix}links_cat
SET title = '$title', description = '$description' WHERE ID_CAT = $catid", __FILE__, __LINE__);


$_POST = '';

redirectexit('action=links');

}
function DeleteCat()
{
global $context, $mbname;
isAllowedTo('links_manage_cat');

$context['sub_template']  = 'deletecat';

//Set the page title
$context['page_title'] = $mbname . ' - Links - Delete Category';

}
function DeleteCat2()
{
global $db_prefix;
isAllowedTo('links_manage_cat');
$catid = htmlentities($_POST['catid'], ENT_QUOTES);

//Delete All links
db_query("DELETE FROM {$db_prefix}links WHERE ID_CAT = $catid", __FILE__, __LINE__);
//Finally delete the category
db_query("DELETE FROM {$db_prefix}links_cat WHERE ID_CAT = $catid", __FILE__, __LINE__);

$_POST = '';

redirectexit('action=links');
}



function AddLink()
{
global $context, $mbname;
isAllowedTo('add_links');

$context['sub_template']  = 'addlink';

//Set the page title
$context['page_title'] = $mbname . ' - Links - Add Link';

}
function AddLink2()
{
global $ID_MEMBER,$db_prefix;

isAllowedTo('add_links');

//Clean the input
$title = htmlentities($_POST['title'], ENT_QUOTES);
$banner = htmlentities($_POST['banner'], ENT_QUOTES);
$description = htmlentities($_POST['description'], ENT_QUOTES);
$url = htmlentities($_POST['url'], ENT_QUOTES);
$catid = htmlentities($_POST['catid'], ENT_QUOTES);

if($title == '')
fatal_error('You need to enter a link title');

if($url == '')
fatal_error('You need to enter a link url');

//Check if the url already exists?
$dbresult = db_query("SELECT l.url,l.ID_CAT, l.title linkname, c.title cname FROM {$db_prefix}links AS l, {$db_prefix}links_cat AS c WHERE l.url = '$url' AND l.ID_CAT = c.ID_CAT", __FILE__, __LINE__);
$row = mysql_fetch_assoc($dbresult);
//The link already exists
if(db_affected_rows() != 0)
fatal_error('The link already exists in category ' . $row['cname'] . ' with link title of ' . $row['linkname']);


//Insert the links
$t = time();
if(allowedTo('links_auto_approve'))
{
$request = db_query("INSERT INTO {$db_prefix}links
(ID_CAT, url, title, banner, description,ID_MEMBER,date,approved)
VALUES ($catid,'$url','$title', '$banner', '$description',$ID_MEMBER,$t,1)", __FILE__, __LINE__);
}
else
{
$request = db_query("INSERT INTO {$db_prefix}links
(ID_CAT, url, title, banner, description,ID_MEMBER,date,approved)
VALUES ($catid,'$url','$title','$banner','$description',$ID_MEMBER,$t,0)", __FILE__, __LINE__);

fatal_error('Note: Your link needs to be approved before it is visible.');
}
//Redirect back to category
redirectexit('action=links;cat=' . $catid);


}
function EditLink()
{
global $context, $mbname;
isAllowedTo('edit_links');

$context['sub_template']  = 'editlink';

//Set the page title
$context['page_title'] = $mbname . ' - Links - Edit Link';

}
function EditLink2()
{
global $db_prefix;
isAllowedTo('edit_links');

//Clean the input
$title = htmlentities($_POST['title'], ENT_QUOTES);
$banner = htmlentities($_POST['banner'], ENT_QUOTES);
$description = htmlentities($_POST['description'], ENT_QUOTES);
$url = htmlentities($_POST['url'], ENT_QUOTES);
$id = htmlentities($_POST['id'], ENT_QUOTES);

if($title == '')
fatal_error('You need to enter a link title');

if($url == '')
fatal_error('You need to enter a link url');

//Update the category
$request = db_query("UPDATE {$db_prefix}links
SET title = '$title',url= '$url', description = '$description' WHERE ID_LINK = $id", __FILE__, __LINE__);


//Redirect back to category
redirectexit('action=links;cat=' . $catid);

}
function DeleteLink()
{
global $context, $mbname;
isAllowedTo('delete_links');

$context['sub_template']  = 'deletelink';

//Set the page title
$context['page_title'] = $mbname . ' - Links - Delete Link';

}
function DeleteLink2()
{
global $db_prefix;

isAllowedTo('delete_links');

$id = @$_REQUEST['id'];

if($id == '')
fatal_error('No link selected');

db_query("DELETE FROM {$db_prefix}links WHERE ID_LINK = $id", __FILE__, __LINE__);

}
function VisitLink()
{
global $db_prefix;
//Check if the current user can view the links list
isAllowedTo('view_smflinks');

$id = @$_REQUEST['id'];

if($id == '')
fatal_error('No link selected');

//Update site lists
$request = db_query("UPDATE {$db_prefix}links
SET hits = hits + 1 WHERE ID_LINK = $id", __FILE__, __LINE__);

//Redirect to the site
$dbresult = db_query("SELECT url FROM {$db_prefix}links WHERE ID_LINK = $id", __FILE__, __LINE__);
$row = mysql_fetch_assoc($dbresult);
mysql_free_result($dbresult);
header("Location: " . $row['url']);
}
function CatUp()
{
global $db_prefix;
//Check if they are allowed to manage cats
isAllowedTo('links_manage_cat');

//Get the cat id
$cat = @$_REQUEST['cat'];
//Check if there is a category above it
//First get our row order
$dbresult1 = db_query("SELECT roworder FROM {$db_prefix}links_cat WHERE ID_CAT = $cat", __FILE__, __LINE__);
$row = mysql_fetch_assoc($dbresult1);
$oldrow = $row['roworder'];
$o = $row['roworder'];
$o--;

mysql_free_result($dbresult1);
$dbresult = db_query("SELECT ID_CAT, roworder FROM {$db_prefix}links_cat WHERE roworder = $o", __FILE__, __LINE__);
if(db_affected_rows()== 0)
fatal_error('There is no category above the current one.');
$row2 = mysql_fetch_assoc($dbresult);


//Swap the order Id's
$request = db_query("UPDATE {$db_prefix}links_cat
SET roworder = $oldrow WHERE ID_CAT = " .$row2['ID_CAT'], __FILE__, __LINE__);

$request = db_query("UPDATE {$db_prefix}links_cat
SET roworder = $o WHERE ID_CAT = $cat", __FILE__, __LINE__);


mysql_free_result($dbresult);

//Redirect to index to view cats
redirectexit('action=links');
}
function CatDown()
{
global $db_prefix;

//Check if they are allowed to manage cats
isAllowedTo('links_manage_cat');

//Get the cat id
$cat = @$_REQUEST['cat'];
//Check if there is a category below it
//First get our row order
$dbresult1 = db_query("SELECT roworder FROM {$db_prefix}links_cat WHERE ID_CAT = $cat", __FILE__, __LINE__);
$row = mysql_fetch_assoc($dbresult1);
$oldrow = $row['roworder'];
$o = $row['roworder'];
$o++;

mysql_free_result($dbresult1);
$dbresult = db_query("SELECT ID_CAT, roworder FROM {$db_prefix}links_cat WHERE roworder = $o", __FILE__, __LINE__);
if(db_affected_rows()== 0)
fatal_error('There is no category above the current one.');
$row2 = mysql_fetch_assoc($dbresult);


//Swap the order Id's
$request = db_query("UPDATE {$db_prefix}links_cat
SET roworder = $oldrow WHERE ID_CAT = " .$row2['ID_CAT'], __FILE__, __LINE__);

$request = db_query("UPDATE {$db_prefix}links_cat
SET roworder = $o WHERE ID_CAT = $cat", __FILE__, __LINE__);


mysql_free_result($dbresult);


//Redirect to index to view cats
redirectexit('action=links');
}
function ApproveList()
{
global $context, $mbname;
isAllowedTo('approve_links');

$context['sub_template']  = 'approvelinks';

//Set the page title
$context['page_title'] = $mbname . ' - Links - Approve Links';
}
function Approve()
{
global $db_prefix;

isAllowedTo('approve_links');
//Get link id
@$id = $_REQUEST['id'];

$request = db_query("UPDATE {$db_prefix}links
SET approved = 1 WHERE ID_LINK = $id LIMIT 1", __FILE__, __LINE__);


redirectexit('action=links;sa=alist');
}
function NoApprove()
{
global $db_prefix;

isAllowedTo('approve_links');
//Get link id
@$id = $_REQUEST['id'];

$request = db_query("UPDATE {$db_prefix}links
SET approved = 0 WHERE ID_LINK = $id LIMIT 1", __FILE__, __LINE__);


redirectexit('action=links');
}
function RateLink()
{
global $db_prefix, $ID_MEMBER;

isAllowedTo('rate_links');

//Get the link ID
@$id = $_REQUEST['id'];

if($id == '')
fatal_error('Invalid Link ID');

//See if the user already rated the link.
$dbresult = db_query("SELECT ID_LINK, ID_MEMBER FROM {$db_prefix}links_rating WHERE ID_MEMBER = $ID_MEMBER AND ID_LINK = $id", __FILE__, __LINE__);
if(db_affected_rows()!= 0)
fatal_error('You already rated this link');


//Get the value of rating
@$value = $_REQUEST['value'];


//Check value
if($value ==0)
{
//Lower Ranking

//Insert rating
$request = db_query("INSERT INTO {$db_prefix}links_rating
(ID_LINK, ID_MEMBER,value)
VALUES ($id, $ID_MEMBER,0)", __FILE__, __LINE__);

//Update main link rating
$dbresult = db_query("UPDATE {$db_prefix}links
SET rating = rating - 1 WHERE ID_LINK = $id LIMIT 1", __FILE__, __LINE__);

}
else
{
//Higher Ranking
//Insert rating
$request = db_query("INSERT INTO {$db_prefix}links_rating
(ID_LINK, ID_MEMBER,value)
VALUES ($id, $ID_MEMBER,1)", __FILE__, __LINE__);

//Update main link rating
$dbresult = db_query("UPDATE {$db_prefix}links
SET rating = rating + 1 WHERE ID_LINK = $id LIMIT 1", __FILE__, __LINE__);
}


redirectexit('action=links');
}
?>
In style.css add: ( this will give a maximum height and width to banners that members can add! You can change this if you want )

Code: [Select]

.banner
{
width: 468px;
height: 60px;
overflow: hidden;
padding: 3px;
}
Hope you guys can understand this Otherwise contact me and i will help you  ( hope i didn't forget code  otherwise contact me if it doesn't work )

Regards,

Penny

[penny]

I have also a question. Is it possible to have comments for each link?
That everyone can give a comment about the link?

I installed MPCS http://tpvgames.co.uk/web/mpcs/ which looks great for comments but how can i add this seperatly for each link?

Hope someone can help me! 

[SMFHacks]

Not yet I might add comments/reviews in next version. Trying to see the scope of this links project heh.

SMFHacks.com

[Jump1979man]

I keep getting this error when trying to install...

An Error Has Occurred!
You cannot download or install new packages because the Packages directory or one of the files in it are not writable! 


I have my permissions set to 777 for the packages directory but it still will not work.  First time this has happened on over 15 mods done to my site.  Any help?

[SMFHacks]

Not sure where you download it from?

[Jump1979man]

Not sure where you download it from?

here, smf site, and fromt he news center on my smf site.

[Jump1979man]

anyone else help with this?  I would really like to add it to my site..

[~!~]

Hi
This mods is wonderful. It is just fit my idea of a common favourite menu for all members. They could add the links and the admin/moderators would decide whether to allow.

I added the mods to Amber theme myself, so if anyone need the instructions to add it to Amber theme, I would be glad to help.

But there is still a problem. I could not post Unicode character. As my forum is for Vietnamese, this is very important.
You can see at : http://www.itbk.org/forum/index.php?action=links;cat=2

Would you please fix it in the next version so that it could display Unicode? 
Thank you,

[~!~]

Strange! how quiet it is 

[SMFHacks]

I don't know what to do for this. I have no experience using unicode.