vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   vBulletin Forum Sideblocks - Show Poll In Forum Sideblock (https://vborg.vbsupport.ru/showthread.php?t=266481)

wildheart 07-13-2011 04:16 PM

No, we are working to get it right, I really appreciate your help especially because I am still so much in the dark. Do you suggest I undo everything and try again?

cherylferraro 07-16-2011 05:32 PM

Great mod thank you for sharing it. It works well with the thread id however when I try to use a forum id instead of the thread id loading the forum page generates the following error:
Code:

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum
LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;

MySQL Error  : Unknown column 'forum.forumid' in 'field list'
Error Number  : 1054
Request Date  : Saturday, July 16th 2011 @ 11:23:12 AM
Error Date    : Saturday, July 16th 2011 @ 11:23:13 AM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/
IP Address    : *
Username      : me
Classname    : vB_Database
MySQL Version : 5.1.56


Badshah93 07-17-2011 04:19 AM

1 Attachment(s)
Quote:

Originally Posted by cherylferraro (Post 2221261)
Great mod thank you for sharing it. It works well with the thread id however when I try to use a forum id instead of the thread id loading the forum page generates the following error:
Code:

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum
LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;

MySQL Error  : Unknown column 'forum.forumid' in 'field list'
Error Number  : 1054
Request Date  : Saturday, July 16th 2011 @ 11:23:12 AM
Error Date    : Saturday, July 16th 2011 @ 11:23:13 AM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/
IP Address    : 98.164.244.76
Username      : me
Classname    : vB_Database
MySQL Version : 5.1.56


try this xml

AttalaEA 07-18-2011 05:51 PM

Thank you so much :)

AttalaEA 07-18-2011 06:03 PM

How can I change poll title to anything else in the sideblock same vbulletin.

Badshah93 07-18-2011 06:26 PM

Quote:

Originally Posted by AttalaEA (Post 2222071)
How can I change poll title to anything else in the sideblock same vbulletin.

Edit this phrase

Code:

sideblock_poll_title

AttalaEA 07-18-2011 06:31 PM

Quote:

Originally Posted by Sherif (Post 2222077)
Edit this phrase

Code:

sideblock_poll_title

Thank You Sherif. This works great. :)

Trek 07-18-2011 09:00 PM

I'm having the same problem as the other person mentioned with the SQL error and using a ForumID. I tried your new XML, but the problem continues.

Badshah93 07-19-2011 05:46 AM

1 Attachment(s)
Quote:

Originally Posted by Trek (Post 2222123)
I'm having the same problem as the other person mentioned with the SQL error and using a ForumID. I tried your new XML, but the problem continues.

uninstall the product and delete all poll sideblock forum block manager. then install this new xml.

i tested this mod on a forum with table prefix, its working fine there hopefully it will be for u also.

mjp1111 07-19-2011 06:16 AM

Can I show a poll from multiple or all forums if I separate with a comma or do something else?

Badshah93 07-19-2011 06:26 AM

Quote:

Originally Posted by mjp1111 (Post 2222325)
Can I show a poll from multiple or all forums if I separate with a comma or do something else?

no.. i have not integrated that feature yet but will be doing later tonight. (as i got many request for it)

wildheart 07-19-2011 11:21 AM

All my edit problems has been sorted and I reinstalled this mod! Works perfectly and I love the look of it.:up:

Thanks for your help. :D

Here is an example of what it looks like: http://reptile-parrots.com/forums/

Dennis Kaczor 07-19-2011 06:57 PM

Been looking for something like this and installed OK.

My only problem is I have a dark skin and the tittle text is very dark looking, where can I edit that to make it lighter to read... Anyone point me in the right direction on this, and thanks in advance.

Dennis

cherylferraro 07-19-2011 07:08 PM

Quote:

Originally Posted by Sherif (Post 2221394)
try this xml

Thank you for the suggestion. I installed the xml file you provided but unfortunately when I switch the selection from thread id to forum id it generates this error:
Code:

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum
LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;

MySQL Error  : Unknown column 'forum.forumid' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, July 19th 2011 @ 01:02:13 PM
Error Date    : Tuesday, July 19th 2011 @ 01:02:14 PM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/index.php
IP Address    : *
Username      : me
Classname    : vB_Database
MySQL Version : 5.1.56


Badshah93 07-20-2011 03:10 AM

Quote:

Originally Posted by cherylferraro (Post 2222533)
Thank you for the suggestion. I installed the xml file you provided but unfortunately when I switch the selection from thread id to forum id it generates this error:
Code:

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum
LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;

MySQL Error  : Unknown column 'forum.forumid' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, July 19th 2011 @ 01:02:13 PM
Error Date    : Tuesday, July 19th 2011 @ 01:02:14 PM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/index.php
IP Address    : *
Username      : me
Classname    : vB_Database
MySQL Version : 5.1.56


please see this post

Code:

https://vborg.vbsupport.ru/showpost.php?p=2222317&postcount=49
Quote:

Originally Posted by Dennis Kaczor (Post 2222527)
Been looking for something like this and installed OK.

My only problem is I have a dark skin and the tittle text is very dark looking, where can I edit that to make it lighter to read... Anyone point me in the right direction on this, and thanks in advance.

Dennis

GO to edit templates -> Block Templates -> block_sideblock template

in that you can change the color by editing css.

Dennis Kaczor 07-20-2011 01:30 PM

GO to edit templates -> Block Templates -> block_sideblock template

in that you can change the color by editing css.[/QUOTE]

I seen this in your code, but did not know where to find it, and thanks worked like a charm

VBUsers 07-22-2011 11:57 PM

nothing is showing up for me

Badshah93 07-23-2011 04:10 AM

Quote:

Originally Posted by VBUsers (Post 2223748)
nothing is showing up for me

Please read all the pages of this thread, i am sure you will find your answer.

netzwart 07-28-2011 06:08 PM

This sounds like a cool MOD. I have two questions:

1. Is it possible to let the MOD choose the polls randomly ? In other words, the polls shown in the sidebar should change regularly without the need to define which poll should be shown in the admincp.

2. Is this MOD working with vB 4.0.8 ?

Thank you

Netzwart

Badshah93 07-28-2011 06:49 PM

Version 2.1 Added.

New Feature -> user can enter multiple forumid's to fetch latest poll.

Bandit8007 07-30-2011 08:00 AM

works fine on 4.14 and a great mod!
however i do have a feature request..
could be added on what usergroups it will show only?
or a selectable field for it?
for wish users it can view in sidebar?
think thats a great addon! :)

shrimpca 07-30-2011 08:07 AM

Don't work for me T^T

I'm use Everywhere in sidebar

netzwart 07-30-2011 10:38 AM

What I found out myself:

Quote:

Originally Posted by netzwart (Post 2226135)
1. Is it possible to let the MOD choose the polls randomly ? In other words, the polls shown in the sidebar should change regularly without the need to define which poll should be shown in the admincp.

NO, it is not possible!

Quote:

Originally Posted by netzwart (Post 2226135)
2. Is this MOD working with v4.0.8 ?

NO, the whole forum collapses as soon as this MOD is activated!

Unfortunately, none of the MODs I would use.... :(

Netzwart

Badshah93 07-30-2011 11:07 AM

Quote:

Originally Posted by shrimpca (Post 2226740)
Don't work for me T^T

I'm use Everywhere in sidebar

Please see this post to find out ur answer

Code:

https://vborg.vbsupport.ru/showpost.php?p=2219039&postcount=26

Badshah93 07-30-2011 11:13 AM

Quote:

Originally Posted by Bandit8007 (Post 2226738)
works fine on 4.14 and a great mod!
however i do have a feature request..
could be added on what usergroups it will show only?
or a selectable field for it?
for wish users it can view in sidebar?
think thats a great addon! :)

ya it can be done.
i will add in next version.

Bandit8007 07-30-2011 01:06 PM

thank you Sherif :)

fevredsuk 08-07-2011 10:32 PM

hi thanks for this mod, but I have a problem

using vb 4.13

the poll shows fine in the sidebar, but if a member votes in the poll in from the side bar, the vote isn't registered

votes are only registered if the go to the actaul thread and vote

which really defeats the object of having the poll in the side bar

Im using a public poll

Badshah93 08-08-2011 03:55 AM

Quote:

Originally Posted by fevredsuk (Post 2230659)
hi thanks for this mod, but I have a problem

using vb 4.13

the poll shows fine in the sidebar, but if a member votes in the poll in from the side bar, the vote isn't registered

votes are only registered if the go to the actaul thread and vote

which really defeats the object of having the poll in the side bar

Im using a public poll

when member votes in the poll, his votes are registered first and then he is redirected to showthread page.

You might be getting the problem of cache time.

Open Show Poll in forum block in Forum Block Manager

and Set Cache time -> to 0 (if it is something else)

David_R 08-08-2011 10:21 AM

Sheriff,

Thanks for the Poll, My concerned Can i added in my menu bar of forums ?

SᴩiDᴇЯ 08-08-2011 02:53 PM

WOW awesome Mod, I have nominated it for MOTM and installed it on vB4.1.4 works great first go, no problems at all, I would like to ask why the top tcat is missing and same for the bottom, i will show you what i mean:

look: http://screensnapr.com/v/uLUy5Y.png it looks nothing like the theme for my sidebar blogs, any way of fixing this?

Thank you in advance.

SᴩiDᴇЯ

Badshah93 08-08-2011 03:17 PM

Quote:

Originally Posted by SᴩiDᴇЯ (Post 2230912)
WOW awesome Mod, I have nominated it for MOTM and installed it on vB4.1.4 works great first go, no problems at all, I would like to ask why the top tcat is missing and same for the bottom, i will show you what i mean:

look: http://screensnapr.com/v/uLUy5Y.png it looks nothing like the theme for my sidebar blogs, any way of fixing this?

Thank you in advance.

SᴩiDᴇЯ

Your having custom skin and sidebar is also custom. Open block_htrml template and send me the contents of it by PM.

SᴩiDᴇЯ 08-08-2011 04:09 PM

Sherif i cant PM you i must put it here, look what happens when i try to send you a PM: http://screensnapr.com/v/qZCrJE.png

XLCR GODFATHER 08-14-2011 11:37 PM

Great MOD works fine. Is it possible to have it show more then 1 poll at a time in the side block similar to the poll widget in the CMS?

Snowman_175 09-06-2011 06:01 PM

works fine when only one forum ID is selected. When more than one are selected it shows no polls...

any ideas?

gnagplank6 09-12-2011 06:53 AM

Cool hack, Installed!!

Quote:

Originally Posted by fevredsuk (Post 2230659)
hi thanks for this mod, but I have a problem

using vb 4.13

the poll shows fine in the sidebar, but if a member votes in the poll in from the side bar, the vote isn't registered

votes are only registered if the go to the actaul thread and vote

which really defeats the object of having the poll in the side bar

Im using a public poll

Did you ever find out whether your issue was the result of cache time?

inphoenix 10-05-2011 12:33 AM

Quote:

Originally Posted by Snowman_175 (Post 2242704)
works fine when only one forum ID is selected. When more than one are selected it shows no polls...

any ideas?

Same thing here on 4.1.5. Would love to have this working for all forums.

Sam Lee 10-05-2011 10:49 AM

installed but didnt work on V5.1.4

inphoenix 10-09-2011 03:44 AM

This was working for 1 forum. I just installed Everywhere sidebar and this stopped working at all.

https://vborg.vbsupport.ru/showthread.php?t=233871

isurua 10-11-2011 04:09 AM

Is it possible to have this as a CMS widget? (The default cms poll widget doesnt allow voting)

Badshah93 10-12-2011 03:24 PM

Quote:

Originally Posted by isurua (Post 2255795)
Is it possible to have this as a CMS widget? (The default cms poll widget doesnt allow voting)

well i created for CMS also but final touch is yet to give. If i get free time, then i will release it here..


All times are GMT. The time now is 01:03 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.01538 seconds
  • Memory Usage 1,838KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (8)bbcode_code_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete