sonnb - XenGallery (XenForo Gallery) [Deleted]

Interesting. I have the Pro version but disabled it since I'm using this one for picture gallery and the idea of using space for people to share YouTube videos seemed silly. If I can embed my own locally hosted videos that would be a really useful thing for my guitar lesson site.
I don't think embedding YouTube videos would take up much space at all, where as adding your local host videos will eat up HDD space and Bandwidth real fast, never mind add to the server load when it converts the video.
 
  • Like
Reactions: rdn
This seems like a viable solution, as I'm becoming pretty annoyed awaiting the release of Chris' gallery that allows user albums. This one has full permissions that cater the same thing for the user, which means they control who views and interacts with their content. Nice job @sonnb
 
I don't think embedding YouTube videos would take up much space at all, where as adding your local host videos will eat up HDD space and Bandwidth real fast, never mind add to the server load when it converts the video.
I'm curios if people said the same in the early internetdays (e.g. as phpbb 3.0 introduced attachments):P
 
I deleted the old version and installed the new one:

Zend_Db_Statement_Mysqli_Exception:Mysqli prepare error: Unknown column 'sonnb_xengallery_album_count' in 'field list' -library/Zend/Db/Statement/Mysqli.php:77
Сгенерирована пользователем:админ,4 мин. назад
Трассировка стэка
#0 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_user...')
#1 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_user...')
#2 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_user...')
#3 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
#4 /home/s/sm42/forum.xxx.su/public_html/library/sonnb/XenGallery/DataWriter/Album.php(1623): Zend_Db_Adapter_Abstract->update('xf_user', Array, 'user_id = 1')
#5 /home/s/sm42/forum.xxx.su/public_html/library/sonnb/XenGallery/DataWriter/Album.php(305): sonnb_XenGallery_DataWriter_Album->rebuildUserAlbumCount()
#6 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/DataWriter.php(1397): sonnb_XenGallery_DataWriter_Album->_postSave()
#7 /home/s/sm42/forum.xxx.su/public_html/library/sonnb/XenGallery/ControllerPublic/XenGallery/Album.php(556): XenForo_DataWriter->save()
#8 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(337): sonnb_XenGallery_ControllerPublic_XenGallery_Album->actionSave()
#9 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/s/sm42/forum.xxx.su/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Содержимое запроса
array(3) {
["url"] => string(46) "http://forum.xxx.su/gallery/albums/0/save"
["_GET"] => array(0) {
}
["_POST"] => array(35) {
["title"] => string(5) "Space"
["category_id"] => string(1) "1"
["description"] => string(0) ""
["_xfRelativeResolver"] => string(46) "http://forum.xxx.su/gallery/albums/create"
["album_location"] => string(0) ""
["stream_name"] => string(0) ""
["album_with"] => string(0) ""
["allow_view"] => string(8) "everyone"
["allow_view_username"] => string(0) ""
["allow_comment"] => string(7) "members"
["allow_comment_username"] => string(0) ""
["allow_download"] => string(4) "none"
["allow_download_username"] => string(0) ""
["allow_add_photo"] => string(4) "none"
["allow_add_photo_username"] => string(0) ""
["allow_add_video"] => string(4) "none"
["allow_add_video_username"] => string(0) ""
["content_title"] => array(1) {
[4] => string(0) ""
}
["content_description"] => array(1) {
[4] => string(0) ""
}
["content_people"] => array(1) {
[4] => string(0) ""
}
["content_location"] => array(1) {
[4] => string(0) ""
}
["location_lat"] => array(1) {
[4] => string(0) ""
}
["location_lng"] => array(1) {
[4] => string(0) ""
}
["video_key"] => array(1) {
[4] => string(0) ""
}
["video_type"] => array(1) {
[4] => string(0) ""
}
["content_type"] => array(1) {
[4] => string(5) "photo"
}
["delete"] => array(1) {
[0] => string(0) ""
}
["cover_content_id"] => string(1) "0"
["content_data_hash"] => string(32) "c3668863d105195d5422fdb28ed82f95"
["album_location_lat"] => string(0) ""
["album_location_lng"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(22) "/gallery/albums/create"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 
I don't think embedding YouTube videos would take up much space at all, where as adding your local host videos will eat up HDD space and Bandwidth real fast, never mind add to the server load when it converts the video.
I'm curios if people said the same in the early internetdays (e.g. as phpbb 3.0 introduced attachments):p

Video upload will not available in core of XenGallery. It will be an separated addon integrate with XenGallery. It will be act as an option for any administrators who really need video uploading.
 
  • Like
Reactions: rdn
I deleted the old version and installed the new one:

Zend_Db_Statement_Mysqli_Exception:Mysqli prepare error: Unknown column 'sonnb_xengallery_album_count' in 'field list' -library/Zend/Db/Statement/Mysqli.php:77
Сгенерирована пользователем:админ,4 мин. назад
Трассировка стэка
#0 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('UPDATE `xf_user...')
#1 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'UPDATE `xf_user...')
#2 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('UPDATE `xf_user...')
#3 /home/s/sm42/forum.xxx.su/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
#4 /home/s/sm42/forum.xxx.su/public_html/library/sonnb/XenGallery/DataWriter/Album.php(1623): Zend_Db_Adapter_Abstract->update('xf_user', Array, 'user_id = 1')
#5 /home/s/sm42/forum.xxx.su/public_html/library/sonnb/XenGallery/DataWriter/Album.php(305): sonnb_XenGallery_DataWriter_Album->rebuildUserAlbumCount()
#6 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/DataWriter.php(1397): sonnb_XenGallery_DataWriter_Album->_postSave()
#7 /home/s/sm42/forum.xxx.su/public_html/library/sonnb/XenGallery/ControllerPublic/XenGallery/Album.php(556): XenForo_DataWriter->save()
#8 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(337): sonnb_XenGallery_ControllerPublic_XenGallery_Album->actionSave()
#9 /home/s/sm42/forum.xxx.su/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/s/sm42/forum.xxx.su/public_html/index.php(13): XenForo_FrontController->run()
#11 {main}
Содержимое запроса
array(3) {
["url"] => string(46) "http://forum.xxx.su/gallery/albums/0/save"
["_GET"] => array(0) {
}
["_POST"] => array(35) {
["title"] => string(5) "Space"
["category_id"] => string(1) "1"
["description"] => string(0) ""
["_xfRelativeResolver"] => string(46) "http://forum.xxx.su/gallery/albums/create"
["album_location"] => string(0) ""
["stream_name"] => string(0) ""
["album_with"] => string(0) ""
["allow_view"] => string(8) "everyone"
["allow_view_username"] => string(0) ""
["allow_comment"] => string(7) "members"
["allow_comment_username"] => string(0) ""
["allow_download"] => string(4) "none"
["allow_download_username"] => string(0) ""
["allow_add_photo"] => string(4) "none"
["allow_add_photo_username"] => string(0) ""
["allow_add_video"] => string(4) "none"
["allow_add_video_username"] => string(0) ""
["content_title"] => array(1) {
[4] => string(0) ""
}
["content_description"] => array(1) {
[4] => string(0) ""
}
["content_people"] => array(1) {
[4] => string(0) ""
}
["content_location"] => array(1) {
[4] => string(0) ""
}
["location_lat"] => array(1) {
[4] => string(0) ""
}
["location_lng"] => array(1) {
[4] => string(0) ""
}
["video_key"] => array(1) {
[4] => string(0) ""
}
["video_type"] => array(1) {
[4] => string(0) ""
}
["content_type"] => array(1) {
[4] => string(5) "photo"
}
["delete"] => array(1) {
[0] => string(0) ""
}
["cover_content_id"] => string(1) "0"
["content_data_hash"] => string(32) "c3668863d105195d5422fdb28ed82f95"
["album_location_lat"] => string(0) ""
["album_location_lng"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(22) "/gallery/albums/create"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Somehow the installation was failed to alter the xf_user table. Please run following query to recreate it.

Code:
ALTER TABLE  xf_user
                                ADD COLUMN sonnb_xengallery_album_count INT(10) UNSIGNED NULL DEFAULT 0,
                                  ADD COLUMN sonnb_xengallery_photo_count INT(10) UNSIGNED NULL DEFAULT 0,
                                  ADD COLUMN sonnb_xengallery_video_count INT(10) UNSIGNED NULL DEFAULT 0,
                                  ADD COLUMN sonnb_xengallery_cover blob NULL;
 
This on DEFAULT style XenForo. On custom styles situation is very, very bad!
I don't moderate any thread. And my moderators also.
This is when xenGallery addon turn ON:
8e0k.jpg

axhi.jpg


This is screenshots when xenGallery addon turn OFF:

a0rd.jpg

xpte.jpg


This is on custom style:
8f3f.jpg

3ene.jpg

Please, fix it.
 
Last edited:
This on DEFAULT style XenForo. On custom styles situation is very, very bad!
I don't moderate any thread. And my moderators also.
This is when xenGallery addon turn ON:
8e0k.jpg

axhi.jpg


This is screenshots when xenGallery addon turn OFF:

a0rd.jpg

xpte.jpg


This is on custom style:
8f3f.jpg

3ene.jpg

Please, fix it.
This is not an issue of xengallery.
 
Back
Top Bottom