New Posting Features - [DBTech] Advanced User Tagging v3 (vB3)

Advanced @User Tagging Mod: What is it?

DragonByte Technologies is proud to present [DBTech] Advanced @User Tagging.
This version introduces several major new features that users have requested, and some others we were unable to fit in v1.0.

The @user Tagging mod is designed to increase activity on your forum by allowing members to mention each other in posts when talking about them.
This is done in a very easy way, very similar to how Twitter mentions people. We use @ ; as the tags, so for instance you could say:
----
This new mod from @Dragonbyte Tech; is pretty cool.
----
The ?@DragonByte Tech;? Will become a link to the DragonByte Tech users profile, it will also inform DragonByte Tech they had been mentioned, and link to the relevant thread/post via a new area in the profile section, as well as a new tab in the shoutbox.

It also allows members to ?tag? the thread for specific other members by inputting their usernames in the tag box above the posts of the thread.

This is a great way to increase your forum activity with no extra admin input required ? people will start to mention posts/threads to their friends, which will increase the amount of posting. This is especially useful of forums which have an international contingent (so threads posted in during the night for some of your members don't go overlooked) or forums which have a lot of posts/threads each day ? again to make sure that a post a person might want to read doesn't get lost in the crowd.

-------------------------------------------------------------------------------------------

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Priority support & Product Demos available at: http://www.dragonbyte-tech.com/forum.php

-------------------------------------------------------------------------------------------

Translations available @ [url="http://www.dragonbyte-tech.com/forums/91-Translations[/URL]
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------

Major Features
Twitter-style @ "Mentions": Typing @username produces a "Mention" that will alert the user to your post, as well as link to their profile.

Quote Alerts: Members you quote will be alerted, ensuring that discussions can continue smoothly even if they left the thread.

Profile Integration: Displays Mentions, Tags and Quotes in profile tabs for quick overview of a member's activities within the mod.


Complete Feature List
Lite

Emails:

• Email alerts for all features
• Globally disable emails for any of the features

General Features:

• Ability to disable Thread Tag list entirely for guests
• Globally disable any of the features

General:

• Statistics Page: Top X Thread Tagged, Top X Mentioned (Lite locked to Top 5)
• "Mention" alerts: Type @username to mention someone, and link to their profile. Email & forum notification
• Quote alerts: Email & forum notification
• Tag an user in a thread to alert them to the thread via a box above threads
• View list of tagged users above threads, with link to see all tags
• Profile Tabs: Lists both incoming and outgoing mentions, quotes and thread tags
• Shoutbox Integration: New Shoutbox Tab to list incoming mentions & tags
• Control how many users to display in inline tag list
• Turn statistics page on & off
• Control BBCode for mentioned usernames (Underline only)
• Control [DBTech] vBShout integration
• Turn features on & off per category
• Globally disable email alerts
• Ability to set maximum mentions per post (default: unlimited)

Pro

• Hash Tags:
  • One-click (un)subscribe to hash tags via the post list page
  • Clicking a hashtag shows all posts tagged with that word.
  • (vB4) Forum Sidebar widget with Recent and Trending hash tags
  • Control number of Recent / Trending hash tags
  • Control time span for Recent / Trending hash tags (x Hours/Days/Weeks)
  • Control stat weights given to individual users using the hash tag, and number of uses in total (for the Trending score)
  • Control display of number of users, number of uses and trending score
  • Deny usergroups access to sidebar block
  Emails:
  • Per-user email disable for any of the 4 features
  General Features:
  • Ability to Mention and Thread Tag whole usergroups by typing their name. Per-UG permission to disable Mentions / Thread Tags for this UG.
  General:
• Ability to tag all your friends by checking a checkbox instead of typing out usernames
• Ability to tag and mention all usergroups by typing out the usergroup name, permissions control what UGs can be mentioned and tagged
• Turn off alerts from everyone except friends
• Hide forum notifications for individual features
• Turn off email alerts for individual features
• Hash tags, Twitter-style, add a topic to your post, sends notification to subscribed users
• (vB4) Forum Sidebar block with Recent & Trending hash tags
• (vB4) Works with the Mobile Style (4.1.12+)
• Turn tag list off
• Control number of users displayed on Top X Stats
• Hide "@" on mentions
• Additional BBCode (Bold, Italic, Highlight) for mentions
• Exclude usergroups from features
• Exclude users from features

-------------------------------------------------------------------------------------------
This mod displays a copyright notification in the footer of pages generated by this mod which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[DragonByte Tech]

Added a fix for a MySQL 4.1.x issue.

Fillip

[Dave84311]

If you have a large forum, I would suggest not using this plugin. Why? Because it can be used to DDOS your forum. Apparently some smart ass spammed mentions or viewed mentions with a bot, and completely took down my forum. Not only that, but deleting mentions also makes my mysql go ape shit.

| 11020 | forum | localhost | forum | Query | 1 | Copying to tmp table | SELECT
post.pagetext AS message,
post.title AS posttitle,
thread.title AS threadtitle,
mention.dateline,
mention.postid,
mention.type,
user.userid,
user.username,
user.usergroupid,
user.infractiongroupid,
user.displaygroupid,
mentioned.userid AS mentioneduserid,
mentioned.username AS mentionedusername,
mentioned.usergroupid AS mentionedusergroupid,
mentioned.infractiongroupid AS mentionedinfractiongroupid,
mentioned.displaygroupid AS mentioneddisplaygroupid
FROM dbtech_usertag_mention AS mention
LEFT JOIN post AS post ON (post.postid = mention.postid)
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN user AS user ON (user.userid = mention.userid)
LEFT JOIN user AS mentioned ON (mentioned.userid = mention.mentionedid)
WHERE (mention.userid = 512784
OR mention.mentionedid = 512784)
AND thread.forumid IN(55,57,56,336,339,337,340,338,342,341,1,12,7,104 ,2,195,345,72,42,88,89,117,145,90,91,315,316,67,73 ,303,48,8,380,148,38,196,379,40,86,344,68,314,192, 354,313,180,226,440,39,6,10,70,76,170,37,118,259,7 4,75,166,270,147,201,282,283,284,289,285,216,450,1 41,217,214,318,364,169,360,174,190,468,460,142,381 ,171,191,227,228,269,279,281,482,308,323,286,229,2 45,352,355,356,368,361,373,357,304,404,395,418,419 ,420,164,197,506,183,305,500,186,484,184,207,334,4 44,210,319,211,266,293,403,292,288,416,172,223,302 ,224,225,295,271,263,359,375,376,397,409,515,476,2 65,199,175,232,504,182,306,309,296,243,212,242,443 ,194,290,287,256,320,254,324,366,388,387,499,389,3 99,321,28,189,126,136,159,262,442,291,365,129,61,4 61,105,453,426,433,474,132,168,29,297,173,298,127, 299,187,300,137,301,239,513,273,119,400,431,435,43 6,456,457,458,466,471,486,493,494,495,505,507,510, 278,370,383,390,312,394,153,274,483,294,398,204,41 3,414,428,462,434,200,261,351,202,246,429,177,176, 264,208,146,116,218,219,220,222,221,258,377,98,329 ,346,514,472,347,335,421,384,439,386,411,385,422,4 17,454,120,276,488,489,452,501,267,423,396,438,437 ,455,209,139,247,35,36,59,131,46,62,358,363,371,37 2,374,391,392,401,402,412,415,448,424,425,427,432, 441,445,446,447,449,451,459,463,464,465,467,213,46 9,473,477,478,479,480,481,485,487,496,497,498,508, 509,311,178,343,249,154,43,328,331,206,215,121,330 ,325,327,158,326,152,179,307,203,406,408,407,503,2 48,14,27,31,33,161,162,19,512,106,53,160,280,32,34 ,310,378,198,250,511,268,47,3,140,251,252,253,151, 17,193,24,233,234,237,238,362,236,348,349,350,235, 255,240,241,230,367,231,4,277,322,122,275,382,125, 490,123,124,143,165,393,475,18,20,26,21,22,25,41,5 8,60,69,87,78,81,50,82,103,51,110,111,112,113,115, 13,369,244,114,83,84,133,85,130,49,272,92,94,95,96 ,260,257,93,97,0)
AND mention.type = 'post'
ORDER BY dateline DESC, userid
LIMIT 0, 20 |

I saw this with "SHOW FULL PROCESSLIST;" about thirty times...

[Wonksta]

^ Hmm any ideas on how to prevent such thing from happening? Hopefully Dragon comes up with a solution

[SBlueman]

A question to the fine folks at DBTech......

Will having the ability to use the auto-fill feature when entering in usernames to invite to a thread be a feature we could look forward to seeing in the future? And if yes, would this feature be available to 3.8 users? How about the ability to invite entire usergroups to a thread?

[DragonByte Tech]

Originally Posted by Dave84311

If you have a large forum, I would suggest not using this plugin. Why? Because it can be used to DDOS your forum. Apparently some smart ass spammed mentions or viewed mentions with a bot, and completely took down my forum. Not only that, but deleting mentions also makes my mysql go ape shit.


I saw this with "SHOW FULL PROCESSLIST;" about thirty times...

Such is, unfortunately, the case with any mod that adds new functionality. For the time being I don't think there's anything I'm able to do about that

Originally Posted by SBlueman

A question to the fine folks at DBTech......

Will having the ability to use the auto-fill feature when entering in usernames to invite to a thread be a feature we could look forward to seeing in the future? And if yes, would this feature be available to 3.8 users? How about the ability to invite entire usergroups to a thread?

If you mean thread tags, then it's something we'll take into consideration for future versions


Fillip

[Dave84311]

Originally Posted by DragonByte Tech

Such is, unfortunately, the case with any mod that adds new functionality. For the time being I don't think there's anything I'm able to do about that

Fillip

If I have a little more information about it, maybe I can optimize it a bit myself: Where is that query coming from and why does it take so long to delete mentions?

Also, if you would implement something that limits how many mentions a user could post, it would plugin performance. Perhaps limit mentions per post and per day, so it can't be abused. I've noticed that deleting a full page of mentions takes me like 30 tries, most of the time it times out.

[DragonByte Tech]

It's in /dbtech/usertag/includes/class_profileblock.php

Deleting mentions isn't a feature, unless I'm misunderstanding you.


Fillip

[Dave84311]

Originally Posted by DragonByte Tech

It's in /dbtech/usertag/includes/class_profileblock.php

Deleting mentions isn't a feature, unless I'm misunderstanding you.


Fillip

Deleting posts with 200+ mentions seems to have a negative effect on performance (Assuming that mentions are deleted while doing that which accounts for the negative performance).

Disabling mentions for self (at least notifications), auto mark mentions as read after x days and limiting the number of mentions per post or per day will definitely help plugin performance.

[DragonByte Tech]

Mentions do not get removed when a post is deleted.

You have single posts on your forums with over two hundred mentions per post? O.O

Nothing wrong with that per say, just that it hasn't been tested under those conditions


Fillip

[Dave84311]

Originally Posted by DragonByte Tech

Mentions do not get removed when a post is deleted.

You have single posts on your forums with over two hundred mentions per post? O.O

Nothing wrong with that per say, just that it hasn't been tested under those conditions


Fillip

Not by choice, of course. That reminds me, users get mentions when a mention has been quoted. It creates issues when deleting posts where mentions have been spammed 100's of times (the lag issue).