Go Back   vb.org Archive > vBulletin Modifications > vBulletin 4.x Modifications > vBulletin 4.x Add-ons
[DBTech] DragonByte SEO v2 (vB4) Details »»
[DBTech] DragonByte SEO v2 (vB4)
Version: 2.0.43, by DragonByte Tech DragonByte Tech is offline
Developer Last Online: Mar 2023 Show Printable Version Email this Page

Category: Major Additions - Version: 4.x.x Rating:
Released: 02-18-2014 Last Update: 03-05-2020 Installs: 286
DB Changes Uses Plugins
Additional Files Translations  
No support by the author.

Improve your URL structure and alleviate duplicate content penalties for your forum with DragonByte SEO, a search engine optimisation mod for vBulletin 3.8.x and vBulletin 4.x.x.

Uses
DragonByte SEO is a complete, modern and fully supported Search Engine Optimisation solution for vBulletin 3.8.x and vBulletin 4.x.x, allowing you to easily eliminate duplicate content penalties from search engines and improve the search engine friendliness of your content URLs via multiple powerful tools.

By giving you total control over how the URLs are presented, DragonByte SEO allows you to customise your site's URL structure should you so choose, or leave the settings at their default values for a "set-it-and-forget-it" experience.

Integrated sitemap builders automatically submit multiple content types to various search engines, ensuring any new URL formats are instantly picked up upon.


Customer Performance Data

This graph was provided by a customer demonstrating the changes he noticed while running DragonByte SEO. Click here to read more details.



A report showing changes across multiple customers sites/setups is in the works.

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

Other addons available @ www.DragonByte-Tech.com/forum
Support posted at our forum is generally answered much quicker.

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

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!

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

Major Features (Lite)

PHP 5.4 Support: By creating DragonByte SEO on PHP 5.4, we've been able to ensure compatibility with this PHP version in the event you or your host decides to upgrade in order to continue to receive bugfix and security updates.

Google Analytics Integration: You can easily integrate Google Analytics with your forum by simply entering your account ID, and choose the level of detail you want to track.

Dynamic Meta Tags: Meta Keywords and Descriptions can become content-aware on certain pages like blogs and threads, increasing the relevance of these pages.

External Link Handling: You can choose to add "nofollow" to all external links, preventing search engine spiders from leaving your site. With the ability to fine-tune where this applies, white- and blacklist support as well as optional anonymisation techniques, you are in complete control over your external references.

Powerful URL Rewrites: Almost every URL found in vBulletin can be rewritten via powerful rewrite rules, enabling you to customise your rule set to perfection. The default rewrite URL settings match that of DragonByte-Tech!

Sitemap Generation: Sitemaps can be automatically created for all supported URLs, and automatically submitted to search engines.


Major Features (Pro)

vBSEO Importer: DragonByte SEO is compatible with vBSEO rewrite rules, and can import your rule set from the latest version of vBSEO seamlessly.

Custom URL Rewrites: Take further control over your forum URLs with the ability to write your own URL formats.

Custom Blog Domain: Run your vBulletin Blog from blog.yourdomain.com (or any other domain you wish).

Custom CMS Domain: Run your vBulletin CMS from cms.yourdomain.com (or any other domain you wish).

Custom Rewrite Rules: If you have custom vBulletin-powered pages, you can create rewrite rules for them using this feature.

Custom Sitemap URLs: Your custom pages can also be added to the sitemap, with individual update frequency / priority / last update date settings.

Custom 301 Redirects: You no longer have to edit your server-side rewrite rules in order to create 301 redirects for your content.

Content-Aware SEO Titles: Blogs, CMS Articles and Threads can generate SEO titles based on the content rather than the title, great for forums with a high number of unhelpful titles.

Advanced Logging: Spider and Sitemap hits can be logged, and the logs can be browsed via the DBSEO AdminCP via the same intuitive interface used in vBulletin's own log browsers.


Complete Feature List (Lite)

Persistent SEO Titles
  • Store SEO'd titles in a database table
  • Saves processing when loading a page
  • Ability to turn it off via settings

vBulletin Options
  • Display Version Number
  • (Optional) Conntrol Panel Password
  • Whether the password replaces or augments usergroup settings

Usergroup Permissions
  • Can Administer DragonByte SEO

Sitemap Generator
  • Based on the default vB4 sitemap builder
  • Submits to more search engines than vBSEO sitemap builder & vB4 sitemap builder
  • Powerful error handling
  • Works with the "Global Ignore" system
  • Integrates with the "Admin Message" system to display errors if needed
  • Can be re-built manually via the DBSEO CP

Sitemap Settings - General
  • Enable Automatic Sitemap Generation
  • Automatic Sitemap Generation Frequency (Days)
  • Automatic Sitemap Search Engine Submission
  • Sitemap File Path
  • URLs Per Page
  • Email Notifications

Sitemap Settings - Page Settings
  • Excluded Forums
  • Smart Show Thread Update Frequency
  • Smart Priority
  • Custom Priority
  • Include Show Post
  • Show Post Update Frequency
  • Show Post Priority Range
  • Include Member Profiles
  • Member Profile Update Frequency
  • Member Profile Priority Range
  • Include Show Thread
  • Show Thread Update Frequency
  • Show Thread Priority Range
  • Include Forum Display
  • Forum Display Update Frequency
  • Forum Display Priority Range
  • Include Poll Results
  • Poll Results Update Frequency
  • Poll Results Priority Range
  • Include Blog
  • Blog Update Frequency
  • Blog Priority Range
  • Include Blog Tag
  • Blog Tag Update Frequency
  • Blog Tag Priority Range
  • Include Member Profile Album
  • Member Profile Album Update Frequency
  • Member Profile Album Priority Range
  • Include Social Group
  • Social Group Update Frequency
  • Social Group Priority Range
  • Include Social Group Discussion
  • Social Group Discussion Update Frequency
  • Social Group Discussion Priority Range
  • Include Tags
  • Tags Update Frequency
  • Tags Priority Range
  • Include CMS Content
  • CMS Content Update Frequency
  • CMS Content Priority Range
  • Include CMS Section
  • CMS Section Update Frequency
  • CMS Section Priority Range

Canonical URLs
  • Supported URL formats 301 redirects to its canonical URLs
  • Prevents duplicate content
  • Improves compatibility with old URL formats

Datastore Caching
  • Reads config.php and uses the Datastore cache parameters
  • Disable Datastore caching for DBSEO only, while remaining active for the forum
  • Cache the following queries
    • Username Reverse Lookup
    • Social Group
    • Social Group Discussion
    • Social Group Message
    • Social Group Picture Comment
    • Album
    • CMS Content
    • CMS Category
    • User
    • User Picture
    • Package
    • Content Type
    • vBulletin Options
    • Forum Cache
    • Attachment
    • Blog
    • Blog Custom Block
    • Blog Category
    • Poll
    • Post
    • Thread
    • Next Thread
    • Previous Thread

Cache Purging
  • Automatically purges the cache when you save settings
  • Quick link to manually purge the cache if need be

General / Other
  • Shortcut link to the DBSEO AdminCP in the vBulletin AdminCP

General Settings
  • Turn mod on/off
  • Configure 404 handling
  • Choose between www and no-www with 301 redirects
  • Excluded pages

Link Titles
  • Choose how title is added to links
  • Enable for external URLs
  • External URL blacklist

Google Analytics
  • Turn Google Analytics integration on or off
  • Input Google Analytics account ID
  • External link tracking, to track outgoing links
  • Format to use for external links
  • User Tracking Breakdown; None, Guests & Members or Individual Usergroups (Doesn't work with "Universal Analytics")
  • Compatibility with the new "Universal Analytics" from Google Analytics (Experimental)
  • Should not be enabled unless you're sure you need it
  • Future-proof as all future profiles will be switched over to this format

Dynamic Meta Tags
  • Meta Keywords
    • Forums
    • Threads
    • Posts
    • Member Profiles
    • Blogs
  • Meta Description
    • Forums
    • Threads
    • Posts
    • Member Profiles
    • Blogs
  • Meta Description Length
  • Member Profile Meta Description

External Link Handling
  • Add "nofollow" to external URLs
  • Anonymise external urls, stops sites seeing what threads the clicks came from
  • Excluded Forums
  • Domain Whitelist
  • Domain Blacklist

Stopwords
  • Remove Stopwords: Yes, No, Only on long URLs
  • Stopword List

General URL Rewrite Settings
  • URL Part Separator: -, _ or .
  • Maximum URL Keywords
  • Filter Non-Latin Characters
  • Custom Character Filter
  • Enable UTF-8
  • Force Forum Directory Index
  • Filter Tag URLs
  • Rewrite Emails
  • Add "Canonical URL" Tag
  • "Nav Bullet" Prefix
  • Avatar Prefix
  • Attachment Prefix

Forum URLs
  • Define "[forum_path]"
  • Rewrite Forum URLs
  • Forum URLs
  • Forum Pagination URLs
  • Rewrite Announcement URLs
  • Announcement URLs
  • Multiple Announcements URL
  • Rewrite Thread URLs
  • Thread URL
  • Thread Pagination URL
  • Thread Last Post URL
  • Thread New Post URL
  • Thread Go To Post URL
  • Thread Go To Post (Paged) URL
  • Previous Thread URL
  • Next Thread URL
  • Rewrite Printer-Friendly Thread URLs
  • Printer-Friendly Thread URLs
  • Printer-Friendly Thread (Paged) URLs
  • Rewrite "Show Post" URLs
  • Show Post URLs
  • Rewrite "Poll" URLs
  • Poll URLs
  • Rewrite "Member List" URLs
  • Member List URLs
  • Member List (Paged) URLs
  • Member List (Letter) URLs
  • Rewrite "Avatar" URLs
  • Avatar URL
  • Rewrite "Nav Bullet" URLs
  • "Nav Bullet" Prefix
  • Nav Bullet (Forum) URLs
  • Nav Bullet (Thread) URLs
  • Rewrite Attachment URLs
  • Attachment URLs
  • Rewrite "Attachment Alt Attribute"
  • Attachment Alt Attribute
  • Rewrite "Tag" URLs
  • Tag List URLs
  • Tag (Single) URLs
  • Tag (Single) Paged URLs

vB CMS URLs (vB4-Only)
  • Rewrite CMS URLs
  • CMS Home URL
  • CMS Section URL
  • CMS Section Article List URL
  • CMS Section Article List (Paged) URL
  • CMS Category URL
  • CMS Category (Paged) URL
  • CMS Author URL
  • CMS Author (Paged) URL
  • CMS Entry URL
  • CMS Entry (Paged) URL
  • CMS Comments (Paged) URL
  • CMS Attachments URL

Blog URLs
  • Rewrite Blog URLs
  • Blogs URL
  • Blog URL
  • Blog (Paged) URL
  • Rewrite Blog Entry URLs
  • Blog Entry URL
  • Blog Entry (Paged) URL
  • Blog Comment URL
  • Next Blog Entry URL
  • Previous Blog Entry URL
  • Rewrite Blog Custom Pages
  • Blog Custom Page URL
  • Rewrite Blog Category URLs
  • Blog Global Category URL
  • Blog Global Category (Paged) URL
  • Blog Category URL
  • Blog Category (Paged) URL
  • Rewrite Blog Attachment URLs
  • Blog Attachment URL
  • Rewrite Blog Feed URLs
  • Blog Feed (User) URL
  • Blog Feed (Global) URL
  • Rewrite Blog List URLs
  • "Blogs By Day" List (User) URL
  • "Blogs By Day" List (Global) URL
  • "Blogs By Day" List (Global, Paged) URL
  • "Blogs By Month" List (User) URL
  • "Blogs By Month" List (Global) URL
  • "Blogs By Month" List (Global, Paged) URL
  • "All Blog Entries" List URL
  • "All Blog Entries" List (Paged) URL
  • "Recent Blog Entries" List URL
  • "Recent Blog Entries" List (Paged) URL
  • "Latest Blog Entries" List URL
  • "Latest Blog Entries" List (Paged) URL
  • "Best Blog Entries" List URL
  • "Best Blog Entries" List (Paged) URL
  • "Best Blogs" List URL
  • "Best Blogs" List (Paged) URL
  • "Blog Comments" List URL
  • "Blog Comments" List (Paged) URL
  • Rewrite Blog Tag URLs
  • Blog Tags Home URL
  • Blog Tag List URL
  • Blog Tag List (Paged) URL

Social Group URLs
  • Rewrite Social Group URLs
  • Social Group Home URL
  • Social Group List URL
  • Social Group List (Paged) URL
  • Social Group URL
  • Social Group (Paged) URL
  • Social Group Discussion URL
  • Social Group Discussion (Paged) URL
  • Social Group Discussion (Last Post) URL
  • Social Group Members URL
  • Social Group Members (Paged) URL
  • Social Group Pictures URL
  • Social Group Pictures (Paged) URL
  • Social Group Picture URL
  • Social Group Picture (Paged) URL
  • Social Group Picture File URL
  • Social Group Category List URL
  • Social Group Category List (Paged) URL
  • Social Group Category URL
  • Social Group Category (Paged) URL

Member Profile URLs
  • Rewrite Member Profile URLs
  • Member Profile URL
  • Visitor Messages (Paged) URL
  • Visitor Messages Conversation URL
  • Visitor Messages Conversation (Paged) URL
  • Friends List (Paged) URL
  • Rewrite Member Album URLs
  • Member Albums URL
  • Member Albums (Paged) URL
  • Album List URL
  • Album List (Paged) URL
  • Album URL
  • Album (Paged) URL
  • Album Picture URL
  • Album Picture (Paged) URL
  • Album Picture File URL

URL Rewrite History
  • Change your URL Rewrite Rules without losing ranking
  • Checks for old URL formats only if no matches are made to existing formats
  • Stores only one copy of each old URL format for maximum database efficiency
  • Results are cached in the Datastore for maximum performance

Social Sharing Settings
  • Global on/off
  • Publisher ID
  • Enable Facebook
  • Enable Twitter
  • Enable Google+
  • Enable Reddit
  • Enable Pinterest
  • Enable LinkedIn
  • Usergroup Permissions

Social Sharing Page Settings
  • Thread: Above Post List
  • Thread: Below Post List
  • Thread: Post Content
  • Blog: Above Blog Entry
  • Blog: Below Blog Entry
  • Blog: Comment Content
  • Social Group: Above Message List
  • Social Group: Below Message List
  • Social Group: Message Content

Social Sharing Button Display Styles
  • Horizontal (With Count)
  • Horizontal (Big Buttons, No Count)
  • Horizontal (Small Buttons, No Count)
  • Vertical (With Count)
  • Vertical (Big Buttons, No Count)
  • Vertical (Small Buttons, No Count)

AddOn Support
  • Allows other modifications to add their own rewrite rules / sitemap integration
  • Powers our front page & product info pages
  • Content-powered DBTech modification support coming

3rd Party Extension Support
  • Allows additional tracking of sitemap views or rewriting sitemap files
  • Allows adding additional search engines to submit to, or changing the sitemap filenames
  • Allows modifying the starting content ID for each content type
  • Allows modifying the keywords and descriptions used for Meta Tag replacements

Automatic Sitemap Generation
  • Set a time of day for sitemap generation
  • Lets you target sitemap generation for the time of day your forum is less active
  • Improves reliability of sitemap generation

General / Other
  • Global Option: Enable "DragonByte SEO AdminCP" Footer Link
  • General Settings: Link Titles: External URLs - Limit
  • DBSEO CP Quick Link: Return to vB AdminCP



Complete Feature List (Pro)

Content-Aware SEO Titles
  • Ability to generate SEO titles from the content based on defined keywords
  • Keywords can have 3 different levels of priority; Low, Medium and High
  • Higher priority keywords get added first
  • Threads, CMS Entry and Blog Entry supported
  • Scans every word in the page text for the keywords

Custom Sitemap URLs
  • Allows for custom pages to be included in a sitemap
  • Import multiple URLs and set default Update Frequency, Priority Range and Last Updated
  • Add single new sitemap URL
  • Browse all URLs in the sitemap, with search parameters
  • Edit / Delete individual URLs
  • Set a path to a file that is automatically imported on sitemap generation
  • Default priority option
  • Default frequency option
  • Prune Custom Sitemap URL table

Log Controls
  • Ability to turn off Sitemap Hit tracking
  • Ability to turn off Spider Hit tracking
  • Saves database space for large forums

Sitemap Hit Log
  • Tracks all spiders accessing your Sitemaps
  • Stores time, spider identification, full user agent, ip address and sitemap file accessed
  • Browseable log with date range options
  • Automatic prune after X days (default: 90)

Spider Hit Log
  • Tracks all spiders accessing your forum
  • Stores a daily log of what scripts the spiders accessed, and how many times they accessed that script
  • Browseable log with date range options
  • Automatic prune after X days (default: 90)

General Settings
  • Custom Rewrite Rules
  • Custom Redirects

URL Rewrite Rules
  • Customise any of the Forum URLs, vB CMS URLs (vB4-Only), Blog URLs, Social Group URLs, Member Profile URLs
  • Custom CMS Domain
  • Custom Blog Domain

vBSEO Importer
  • Transfers equivalent settings from vBSEO
  • Ensures smooth transition from vBSEO
  • Safety precautions to ensure settings are only overwritten if you explicitly tick Yes

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

This mod displays a copyright notification in the footer of all pages, which includes:
  • 1 Link to DragonByte Technologies homepage
  • 1 Link to Product Description page of this modification

Download Now

File Type: zip [DBTech] DragonByte SEO 2.0.43 [Lite].zip (2.58 MB, 187 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #542  
Old 11-23-2014, 03:14 PM
katie hunter's Avatar
katie hunter katie hunter is offline
 
Join Date: May 2007
Posts: 533
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Fillip (: I am not sure how we can use this feature ? From my understanding a custom Google search is simply a generated code you generate from google webmaster. Right ?

What do we need to do to try this feature ?

Custom SiteLinks URL
If you are using a custom URL for your search engine (such as Google Custom Search), you can alter this variable to match your search form.

Available replacement variables:
{bburl} (your forum URL)
{homeurl} (your home page URL)
{search_term_string} (Required).
Reply With Quote
  #543  
Old 11-23-2014, 03:21 PM
DragonByte Tech's Avatar
DragonByte Tech DragonByte Tech is offline
 
Join Date: Feb 2010
Location: Scotland
Posts: 8,814
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Follow the instructions on this site: https://www.google.co.uk/cse/


Fillip
Reply With Quote
  #544  
Old 11-23-2014, 04:25 PM
Gadget_Guy Gadget_Guy is offline
 
Join Date: Jun 2010
Posts: 271
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Since installing this mod... links to my "home" which are linked like this:

https://www.mysite.com/forums

Go to:

https://www.mysite.com/forums/blogs/all/


What do I have to correct to make it go to /forms and not the blogs?


This is what my .htaccess file looks like:

Quote:

<IfModule mod_rewrite.c>

RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.toronto-subaru-club.com/\forums\/$1 [R=301,L]

RewriteEngine on

# Set to vbulletin directory
RewriteBase /forums/

# Retrieve gamedata requests and send to new dbtech locations
RewriteRule ^arcade/gamedata/(.*) dbtech/vbarcade/media/$1 [L]

# Retrieve crossdomain requests and send to new dbtech location
RewriteRule ^crossdomain\.xml dbtech/vbarcade/crossdomain.xml [L]

# Send hardcoded legacy scores to arcade instead
RewriteCond %{REQUEST_URI} newscore\.php [OR]
RewriteCond %{REQUEST_URI} viewgame\.php
RewriteRule .* arcade.php?sendscore=legacy [L,QSA]

# Send hardcoded legacy scores to arcade instead
RewriteCond %{QUERY_STRING} func=storeScore [OR]
RewriteCond %{QUERY_STRING} autocom=arcade [OR]
RewriteCond %{QUERY_STRING} act=arcadelib [OR]
RewriteCond %{QUERY_STRING} act=Arcade
RewriteRule .* arcade.php [L,QSA]

# Reroute v3arcade liveinstaller
RewriteCond %{QUERY_STRING} do=liveinstall
RewriteCond %{REQUEST_URI} v3arcade_admin\.php

# If you renamed your admincp directory, change it here
RewriteRule .* %{DOCUMENT_ROOT}/admincp/arcade_admin.php?%{QUERY_STRING}&do=review&import= browse&system=v3a [L,R=301]
</IfModule>
RewriteEngine Off

RewriteEngine On

RewriteRule ^classifieds/([^/]*)/ ./ozzmodz_classifieds.php?do=main&catid=$1 [L,NC]
RewriteRule ^sale/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^wanted/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^trade/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^offer/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^seller/([^/]*)/ ./ozzmodz_classifieds.php?do=seller&sellerid=$1 [L,NC]


RewriteEngine On

# If you are having problem with "None Could Be Negotiated" errors in Apache, uncomment this to turn off MultiViews
# Options -MultiViews

RewriteRule ^threads/.* showthread.php [QSA]
RewriteRule ^forums/.* forumdisplay.php [QSA]
RewriteRule ^members/.* member.php [QSA]
RewriteRule ^blogs/.* blog.php [QSA]
RewriteRule ^entries/.* entry.php [QSA]

RewriteCond %{REQUEST_URI} !(admincp/|dbseocp/|modcp/|cron|arrowchat/|cometchat/|mobiquo|forumrunner|api\.php|reviewpost/|classifieds/|photopost/)
RewriteRule ^((archive/)?(.*\.php(/.*)?))$ dbseo.php [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !/(admincp|dbseocp|modcp|clientscript|cpstyles|image s|reviewpost|classifieds|photopost)/
RewriteRule ^(.+)$ dbseo.php [L,QSA]

D.
Reply With Quote
  #545  
Old 11-26-2014, 08:47 PM
cdoyle cdoyle is offline
 
Join Date: Oct 2004
Posts: 462
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cdoyle View Post
So I have had this installed for awhile, but there are now so many different options.
Is there a recommended way to have all the options set up in regards to SEO?
To others who are using this, are there any settings that you recommend being enabled or disabled?
Reply With Quote
  #546  
Old 11-26-2014, 09:23 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by cdoyle View Post
To others who are using this, are there any settings that you recommend being enabled or disabled?
Leave most at default, you will need to change a few things when first installed to make your site to work right but apart from that leave the rest default
Reply With Quote
  #547  
Old 11-27-2014, 12:46 AM
Cla75 Cla75 is offline
 
Join Date: Aug 2009
Posts: 156
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My continue error...

Database error in DragonByte SEO 1.3.2:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*\*p[aАБВГДЕабвгде][oТУФХЦШтуфхцш]l[aАБВГДЕабвгде]\*.htm(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Thursday, November 27th 2014 @ 01:21:48 AM
Error Date : Thursday, November 27th 2014 @ 01:21:48 AM
Script : http://www.XXX.com/members/*paola*.htm
Referrer :
IP Address : 202.46.56.124
Username : N/A
Classname : DBSEO_Database
MySQL Version :
------------------------


I was hoping you could do accept the "@" or "*" or "&" or other, in all the links (especially if your nickname contains special characters).
in other link, where in the title the "@" and is removed!
thanks
Reply With Quote
  #548  
Old 11-27-2014, 12:54 AM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Cla75 View Post
My continue error...

Database error in DragonByte SEO 1.3.2:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*\*p[aАБВГДЕабвгде][oТУФХЦШтуфхцш]l[aАБВГДЕабвгде]\*.htm(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Thursday, November 27th 2014 @ 01:21:48 AM
Error Date : Thursday, November 27th 2014 @ 01:21:48 AM
Script : http://www.XXX.com/members/*paola*.htm
Referrer :
IP Address : 202.46.56.124
Username : N/A
Classname : DBSEO_Database
MySQL Version :
------------------------

I was hoping you could do accept the "@" in all the links (soprattutto se il nickname contiene caratteri speciali).
in other link, where in the title the "@" and is removed!
thanks
http://stackoverflow.com/questions/2...egexp-in-mysql
Reply With Quote
  #549  
Old 11-27-2014, 02:30 AM
Gadget_Guy Gadget_Guy is offline
 
Join Date: Jun 2010
Posts: 271
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ForceHSS View Post
How does this help people like myself who are having this issue?

Or was this directed at the developer to help correct this in their code?

D.
Reply With Quote
  #550  
Old 11-27-2014, 03:29 AM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I linked you that to tell you to remove the special characters from members usernames and it will fix the problem and in admincp/settings/options/User Registration Options/Username Regular Expression put ^[a-zA-Z0-9\s.\-_']+$
Or something like this to stop members registering with things like this if you already have this filled, maybe what you have in there is wrong

On another note, maybe the dev has a way around to allow them if it has anything to do with this mod, but I think it is more mysql does not allow them
regexp is short for Regular expression
Reply With Quote
  #551  
Old 11-27-2014, 03:39 AM
Gadget_Guy Gadget_Guy is offline
 
Join Date: Jun 2010
Posts: 271
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How can I do a search / replace of existing usernames that have special characters in them now?

D.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:48 PM.


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.14204 seconds
  • Memory Usage 2,397KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (17)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete