collapse collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 202
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

Installation errors? Mod incompatibilities? Upgrade problems? Make your way over to the Install and Upgrade Support board for all your solutions!

Author Topic: Polls Block with these changes.  (Read 4343 times)

0 Members and 1 Guest are viewing this topic.

techprince

  • Guest
Polls Block with these changes.
« on: January 07, 2009, 02:32:59 PM »
I need a poll block with these changes :

1) IDs text field with multiple id separated by comma.
2) A RND (Random) Function which will iterate through all these ids.
3) Find all polls in which user didnt voted and all polls for guests, then display randomly.
4) A board ids field allowing multiple board ids from which polls to find.


Offline ディン1031

  • ... feel not as a dev at the moment ...
  • Comrade
  • *
  • Posts: 789
  • Gender: Male
  • Overworked <<
  • SMF Version: None
  • SP Version: None
Re: Polls Block with these changes.
« Reply #1 on: January 08, 2009, 06:45:51 AM »
This is a nice idea :), i will think about it.

1) Possible? But should the pols shown in one block?
2) Automatic with 1) or is this something seperate?
But at point 3... this could be heavy querys... and will be not easy. The Guest Vote work only in SMF2.
4) Hmmm a random poll from a board id, or the latest or the first?

Bye
DIN1031
« Last Edit: January 08, 2009, 06:52:26 AM by ディン1031 »
Again... I'm having time problems...

Normal Monday to Friday I'm at office from 6:00-16:00 (On my local time ;P).

techprince

  • Guest
Re: Polls Block with these changes.
« Reply #2 on: January 10, 2009, 07:19:45 PM »
1 for 2, they are not separate.
3rd will require more lines of code and will generate resource and time consuming queries so exclude it.
But 4th must include a drop down list with random & latest :)

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Polls Block with these changes.
« Reply #3 on: February 02, 2009, 09:41:31 AM »
You can use these codes in a PHP block:

Code: [Select]
global $db_prefix, $user_info, $boarddir, $ID_MEMBER;

require_once($boarddir . '/SSI.php');

$poll_ids = array(1, 2, 3);
$boardsAllowed = boardsAllowedTo('poll_view');

$request = db_query("
SELECT t.ID_TOPIC
FROM ({$db_prefix}polls AS p, {$db_prefix}boards AS b, {$db_prefix}topics AS t)
LEFT JOIN {$db_prefix}log_polls AS lp ON (lp.ID_POLL = p.ID_POLL AND lp.ID_MEMBER = $ID_MEMBER)
WHERE p.votingLocked = 0
AND lp.ID_CHOICE IS NULL
AND t.ID_POLL = p.ID_POLL
AND b.ID_BOARD = t.ID_BOARD
AND $user_info[query_see_board]" . (!in_array(0, $boardsAllowed) ? "
AND b.ID_BOARD IN (" . implode(', ', $boardsAllowed) . ")" : '') . "
AND t.ID_TOPIC IN (" . implode(', ', $poll_ids) . ")" . "
ORDER BY RAND()
LIMIT 1", __FILE__, __LINE__);
list ($poll) = mysql_fetch_row($request);
mysql_free_result($request);

if (empty($poll))
{
$request = db_query("
SELECT t.ID_TOPIC
FROM ({$db_prefix}polls AS p, {$db_prefix}boards AS b, {$db_prefix}topics AS t)
WHERE t.ID_POLL = p.ID_POLL
AND b.ID_BOARD = t.ID_BOARD
AND $user_info[query_see_board]" . (!in_array(0, $boardsAllowed) ? "
AND b.ID_BOARD IN (" . implode(', ', $boardsAllowed) . ")" : '') . "
AND t.ID_TOPIC IN (" . implode(', ', $poll_ids) . ")" . "
ORDER BY RAND()
LIMIT 1", __FILE__, __LINE__);
list ($poll) = mysql_fetch_row($request);
mysql_free_result($request);
}

if (empty($poll))
{
echo 'There are no polls to show!';
return;
}

ssi_showPoll($poll);

You don't need board ids, because you already give the topic ids to look for.
And slowly, you come to realize... It's all as it should be...

techprince

  • Guest
Re: Polls Block with these changes.
« Reply #4 on: February 16, 2009, 07:41:22 AM »
You can use these codes in a PHP block:

Code: [Select]
global $db_prefix, $user_info, $boarddir, $ID_MEMBER;

require_once($boarddir . '/SSI.php');

$poll_ids = array(1, 2, 3);
$boardsAllowed = boardsAllowedTo('poll_view');

$request = db_query("
SELECT t.ID_TOPIC
FROM ({$db_prefix}polls AS p, {$db_prefix}boards AS b, {$db_prefix}topics AS t)
LEFT JOIN {$db_prefix}log_polls AS lp ON (lp.ID_POLL = p.ID_POLL AND lp.ID_MEMBER = $ID_MEMBER)
WHERE p.votingLocked = 0
AND lp.ID_CHOICE IS NULL
AND t.ID_POLL = p.ID_POLL
AND b.ID_BOARD = t.ID_BOARD
AND $user_info[query_see_board]" . (!in_array(0, $boardsAllowed) ? "
AND b.ID_BOARD IN (" . implode(', ', $boardsAllowed) . ")" : '') . "
AND t.ID_TOPIC IN (" . implode(', ', $poll_ids) . ")" . "
ORDER BY RAND()
LIMIT 1", __FILE__, __LINE__);
list ($poll) = mysql_fetch_row($request);
mysql_free_result($request);

if (empty($poll))
{
$request = db_query("
SELECT t.ID_TOPIC
FROM ({$db_prefix}polls AS p, {$db_prefix}boards AS b, {$db_prefix}topics AS t)
WHERE t.ID_POLL = p.ID_POLL
AND b.ID_BOARD = t.ID_BOARD
AND $user_info[query_see_board]" . (!in_array(0, $boardsAllowed) ? "
AND b.ID_BOARD IN (" . implode(', ', $boardsAllowed) . ")" : '') . "
AND t.ID_TOPIC IN (" . implode(', ', $poll_ids) . ")" . "
ORDER BY RAND()
LIMIT 1", __FILE__, __LINE__);
list ($poll) = mysql_fetch_row($request);
mysql_free_result($request);
}

if (empty($poll))
{
echo 'There are no polls to show!';
return;
}

ssi_showPoll($poll);

You don't need board ids, because you already give the topic ids to look for.

Poll IDs :| How about Board IDs to choose Polls from.

Offline Jade Elizabeth

  • Comrade
  • *
  • Posts: 1146
  • Gender: Female
    • Jades-World
  • SMF Version: None
  • SP Version: None
Re: Polls Block with these changes.
« Reply #5 on: February 16, 2009, 11:06:39 AM »
You want a random poll block like I do, don't you?

One that grabs the latest poll from a specified board? Or from the entire forum?

Yeah. I want that :P.
Jade Elizabeth
(Ex Language Coordinator)
Owner of Awesome Crazy (the home of the insane),
Color Me Forum (For Adult Coloring Enthusiasts), and
Creative Burrow (A place for creative people).

techprince

  • Guest
Re: Polls Block with these changes.
« Reply #6 on: February 16, 2009, 04:37:34 PM »
No problem i made it :)

Offline Jade Elizabeth

  • Comrade
  • *
  • Posts: 1146
  • Gender: Female
    • Jades-World
  • SMF Version: None
  • SP Version: None
Re: Polls Block with these changes.
« Reply #7 on: February 16, 2009, 05:02:38 PM »
Share?
Jade Elizabeth
(Ex Language Coordinator)
Owner of Awesome Crazy (the home of the insane),
Color Me Forum (For Adult Coloring Enthusiasts), and
Creative Burrow (A place for creative people).

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Polls Block with these changes.
« Reply #8 on: February 19, 2009, 12:48:23 PM »
Poll block supports 3 types as a definite, recent, or random poll in 2.2.

2.2 is not out yet though.
And slowly, you come to realize... It's all as it should be...