Version: 1.00, by leonsio
Developer Last Online: Jun 2013
Version: 3.5.0
Rating:
Released: 09-29-2005
Last Update: Never
Installs: 1
No support by the author.
what this hack do,
you can define rights for smilies, like posticons
for example you can give registerd users right zu access all smilies, unregistred or not loged user can use only default smilies
installation: easy
4 plugins ( 1 product )
4 file change
import the XML file, with product importer
in the misc.php
find ( on 2 positions !! )
Code:
$smilies = $db->query_read("
SELECT smilietext AS text, smiliepath AS path, smilie.title, smilieid,
imagecategory.title AS category
FROM " . TABLE_PREFIX . "smilie AS smilie
LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
");
replace
Code:
// Smilies for Usergroups Hack BEGIN
$smilies = $db->query_read("
SELECT smilietext AS text, smiliepath AS path, smilie.title, smilieid,
imagecategory.title AS category
FROM " . TABLE_PREFIX . "smilie AS smilie
LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
WHERE imagecategory.imagecategoryid NOT IN (0$badcategories)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
");
// Smilies for Usergroups Hack END
include/functions_editor.php
find
Code:
// query smilies
$smilies = $vbulletin->db->query_read("
SELECT smilieid, smilietext, smiliepath, smilie.title,
imagecategory.title AS category
FROM " . TABLE_PREFIX . "smilie AS smilie
LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
")
replace
Code:
// Smilies for Usergroups Hack BEGIN
// query smilies
$smilies = $vbulletin->db->query_read("
SELECT smilieid, smilietext, smiliepath, smilie.title,
imagecategory.title AS category
FROM " . TABLE_PREFIX . "smilie AS smilie
LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
WHERE imagecategory.imagecategoryid NOT IN (0$badcategories)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder
");
// Smilies for Usergroups Hack END
includes/class_bbcode.php
find
Code:
$smilies = $this->registry->db->query_read("
SELECT *, LENGTH(smilietext) AS smilielen
FROM " . TABLE_PREFIX . "smilie
ORDER BY smilielen DESC
");
replace
Code:
// Smilies for Usergroups Hack BEGIN
$badcategories= construct_smilies();
$smilies = $this->registry->db->query_read("
SELECT *, LENGTH(smilie.smilietext) AS smilielen
FROM " . TABLE_PREFIX . "smilie AS smilie
LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)
WHERE imagecategory.imagecategoryid NOT IN (0$badcategories)
ORDER BY smilielen DESC
");
// Smilies for Usergroups Hack END