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.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 378
  • 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]

Blocks speak! Do you have an interest in getting more blocks - or even making your own? The Blocks Board is for you!

Author Topic: 2 or 3 most recent polls?  (Read 6798 times)

0 Members and 1 Guest are viewing this topic.

Offline Dzonny

  • Comrade
  • *
  • Posts: 22
    • Samo-opusteno
  • SMF Version: 2.0.6
  • SP Version: 2.3.5
2 or 3 most recent polls?
« on: June 18, 2014, 06:03:02 PM »
Hey all,

Is it possible to add two or three most recent polls on portal? I'm currently using custom php block to show 3 hidden poll blocks on my portal with custom poll IDs. I would like to show 3 most recent polls if it's possible though.

Any help would be appreciated.

Regards,
Dzonny

Offline emanuele

  • Developer
  • *
  • Posts: 293
Re: 2 or 3 most recent polls?
« Reply #1 on: June 18, 2014, 06:51:09 PM »
If it is *any* poll, you could just grab the IDs from the db:
Code: [Select]
$smcFunc['db_query']('', '
    SELECT id_poll
    FROM {db_prefix}polls
    ORDER BY id_poll DESC
    LIMIT 3',
    array()
);
Of course this doesn't check for permissions (you wrote "hidden poll" so I assumed the polls are in hidden boards for some reason), if you need permissions, though, you have to join boards and use {query_see_board}.

Offline Dzonny

  • Comrade
  • *
  • Posts: 22
    • Samo-opusteno
  • SMF Version: 2.0.6
  • SP Version: 2.3.5
Re: 2 or 3 most recent polls?
« Reply #2 on: July 06, 2014, 08:05:15 AM »
Thanks for your answer Ema!
However I'm not sure where can I use the code you provided and how?

Thanks for your help!

Offline Dzonny

  • Comrade
  • *
  • Posts: 22
    • Samo-opusteno
  • SMF Version: 2.0.6
  • SP Version: 2.3.5
Re: 2 or 3 most recent polls?
« Reply #3 on: July 14, 2014, 07:42:24 AM »
Anyone can suggest how to deal with this please? :)

Offline andy

  • On Leave
  • *
  • Posts: 861
  • Gender: Male
    • Outdoor Club Japan (OCJ) アウトドア・クラブ・ジャパン
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
  • Elkarte Version: None
Re: 2 or 3 most recent polls?
« Reply #4 on: July 14, 2014, 11:16:49 PM »
I guess that code will work in a Simple Portal  custom php block.

If you are not sure what to do using custom code there is a default poll block. You need to read up about using blocks - see the documentation about them and try experimenting with blocks.

http://simpleportal.net/index.php?action=docs;area=working_with_blocks


I recommend choosing the best solution available rather than trying to customize everything exactly as you want - which usually mean lots of time and headaches.
« Last Edit: July 14, 2014, 11:19:22 PM by andy »
Everyone is a volunteer here so please try and make a small donation to keep the Simple Portal website running


Offline Dzonny

  • Comrade
  • *
  • Posts: 22
    • Samo-opusteno
  • SMF Version: 2.0.6
  • SP Version: 2.3.5
Re: 2 or 3 most recent polls?
« Reply #5 on: July 18, 2014, 08:38:35 AM »
Hm, i don't think this can be placed in custom php block by itself. The code ema gave is just a sql query, apart from that there must be formatted output for showing actual data.

Offline andy

  • On Leave
  • *
  • Posts: 861
  • Gender: Male
    • Outdoor Club Japan (OCJ) アウトドア・クラブ・ジャパン
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
  • Elkarte Version: None
Re: 2 or 3 most recent polls?
« Reply #6 on: July 19, 2014, 02:16:09 AM »
Yes you are right - I didnt look at it closely.

As I said, sometimes best to take the easy solution even though not perfect. Use the standard block for polls or keep trying to get the custom code.
Not many volunteers here so best to expect it will take time for custom coding.
Everyone is a volunteer here so please try and make a small donation to keep the Simple Portal website running


Offline oNLy1

  • Jr. Member
  • **
  • Posts: 53
  • SMF Version: 2.0.2
  • SP Version: 2.3.5
Re: 2 or 3 most recent polls?
« Reply #7 on: July 26, 2014, 04:09:24 AM »
not sure how much this will help but here is the SSI code

most recent poll
Code: [Select]
ssi_recentPoll();
most voted in poll
Code: [Select]
ssi_topPoll();
to slectiviely show a single poll (change '$topicID' with the ID #)
Code: [Select]
ssi_showPoll($topicID);
you could put two or three together, example
Code: [Select]
ssi_recentPoll();
ssi_topPoll();

ssi_showPoll(181);

again, not sure how much that helps but could be a good place to start?

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: 2 or 3 most recent polls?
« Reply #8 on: July 27, 2014, 08:20:17 AM »
You could modify the original function a little bit to achieve this.

Sources/PortalBlocks.php

Code: (Find) [Select]
LIMIT 1',
array(
'boards_allowed_list' => $boardsAllowed,
'not_locked' => 0,
'is_approved' => 1,
'recycle_enable' => $modSettings['recycle_board'],
'type' => $type == 1 ? 'p.id_poll DESC' : 'RAND()',
)
);
list ($topic) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);
}

Code: (Replace) [Select]
LIMIT {int:limit}',
array(
'boards_allowed_list' => $boardsAllowed,
'not_locked' => 0,
'is_approved' => 1,
'recycle_enable' => $modSettings['recycle_board'],
'type' => $type == 1 ? 'p.id_poll DESC' : 'RAND()',
'limit' => $type == 1 ? 3 : 1,
)
);
$topics = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$topics[] = $row['id_topic'];
$smcFunc['db_free_result']($request);
}

foreach ($topics as $topic)
{

Code: (Find) [Select]
', $txt['poll_cannot_see'];
Code: (Replace) [Select]
', $txt['poll_cannot_see'];

}

Change 3 in the first replace as the number of recent polls you want to be displayed.

Then just create a new Poll block with the Type set as Recent.
« Last Edit: July 27, 2014, 08:25:10 AM by [SiNaN] »
And slowly, you come to realize... It's all as it should be...