Resource icon

Vanity Names 1.1.2

No permission to download
Great update! and I have a new request.

Vanity name moderations (for some user-groups)

Facebook allow user choose his vanity name if it is available but they have to approve it.
 
Last edited:
The vanity url does not show when hovering over a user's member card or clicking their username link.

Can you add a feature to this addon to force the vanity url to show?
 
What's this?

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near <snip>
 
Last edited by a moderator:
Since the vanity urls come right after the domain, you should add someway to check for routes that already exist. If some weird user chose the vanity url resources, then it could conflict with the resource manager.
 
Nicely done. You should now also code this into the store addon:
http://xenforo.com/community/resources/*******-store-framework.2665/

That way people can use the store to allow members the ability to buy this ;)
 
Nicely done. You should now also code this into the store addon:
http://xenforo.com/community/resources/*******-store-framework.2665/

That way people can use the store to allow members the ability to buy this ;)

I'll look into it...
 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'http:www.circle.amservice?bid=235&sid=3418%25255C''' at line 1 - library/Zend/Db/Statement/Mysqli.php:77 Generated By: Unknown Account, Today at 8:20 AM Stack Trace #0 /home/blah/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT * FROM `...') #1 /home/blah/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT * FROM `...') #2 /home/blah/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT * FROM `...') #3 /home/blah/public_html/library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('SELECT * FROM `...', Array) #4 /home/blah/public_html/library/LiamVanityNames/Model/VanityNames.php(14): Zend_Db_Adapter_Abstract->fetchRow('SELECT * FROM `...') #5 /home/blah/public_html/library/LiamVanityNames/Addon.php(47): LiamVanityNames_Model_VanityNames->getUserFromName(''http:www.circl...') #6 [internal function]: LiamVanityNames_Addon::routerOverride(Object(XenForo_FrontController), Object(XenForo_RouteMatch)) #7 /home/blah/public_html/library/XenForo/CodeEvent.php(90): call_user_func_array(Array, Array) #8 /home/blah/public_html/library/XenForo/FrontController.php(132): XenForo_CodeEvent::fire('front_controlle...', Array) #9 /home/blah/public_html/index.php(13): XenForo_FrontController->run() #10 {main} Request State array(3) { ["url"] => string(69) "https://8th.us/'http:/www.circle.am/service/?bid=235&sid=3418%255C'" ["_GET"] => array(2) { ["bid"] => string(3) "235" ["sid"] => string(10) "3418%255C'" } ["_POST"] => array(0) { } }
 
@DRE

I have no idea how that could be happening. It's practically impossible, especially with the new version...

I'll have to look into it further.

Liam
 
Another quick issue about this addon. When enabled, it seems to break my landing page for my forum/site (which is currently via XenPorta.) Not sure what would cause this issue. Although I'd love to see this addon fully working, so hoping I gave enough info to fix the issues.
 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\'' at line 1 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Yesterday at 4:17 AM
Stack Trace
#0 /home/blah/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT * FROM `...')
#1 /home/blah/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT * FROM `...')
#2 /home/blah/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT * FROM `...')
#3 /home/blah/public_html/library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('SELECT * FROM `...', Array)
#4 /home/blah/public_html/library/LiamVanityNames/Model/VanityNames.php(14): Zend_Db_Adapter_Abstract->fetchRow('SELECT * FROM `...')
#5 /home/blah/public_html/library/LiamVanityNames/Addon.php(47): LiamVanityNames_Model_VanityNames->getUserFromName('\')
#6 [internal function]: LiamVanityNames_Addon::routerOverride(Object(XenForo_FrontController), Object(XenForo_RouteMatch))
#7 /home/blah/public_html/library/XenForo/CodeEvent.php(90): call_user_func_array(Array, Array)
#8 /home/blah/public_html/library/XenForo/FrontController.php(132): XenForo_CodeEvent::fire('front_controlle...', Array)
#9 /home/blah/public_html/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(16) "https://8th.us/\"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 
Top Bottom