I've modified an old polls for osdate 2.1.9.

The modification is fine for osdate evo.

Need some adjustment , it cause some issue in the layout:

See screens

When nobody is log on the site i have this error that appear at the top

Input array has 1 params, does not match query: 'SELECT count(*) FROM osdate_pollips WHERE ip = ? and pollid = ? '
that cause a template error. The Our members, Recently active members and the newest profiles are at the bottom.


Everything is fine when a user is logged in.
Any help will be appreciated.

here are the screens of site

Hi Benoitc64,

I will have a look at it soon and see if I can get the same error.

By the way, osDateEvo doesn't have leftside menu that's responsive and won't work correctly, change it
in the admin under global settings where it is suppose to be set to top only

Find User Menu to be used top NOT side menu.

Think I need to remove those settings in the database so it stays as Top for the members.

Hi Benoitc64,

There seems to be a few mismatched sql files, very different to osDateEvo

I will ask CBG to look at it, this is more his thing to work out.

Hi Benoitc64,

You said it from osDate 2.1.9 and it is modified.
What changes did you make?

As it on line 43 of Polls.php you are passing the session UserID, as no one logged in, it through a mismatch, as it not getting all the details it needs.
The problem seems to start on lines 43 to 45 of polls.php

However the SQL code is ip = ? for that answer, it is giving a UserID and not the user IP

Are you only wanting logged in members to vote?
If not let me know what you trying to do and I see if I can help.

THe script is the same that's it from 2.1.9.

The only change i've made is change $db->  to $osDB

Yes  the ip = ? is from the old version this is the UserID for prevent user to vote more than once.

The vote will be only accessible when the user is logon. -
     If the user has already vote, that display the result for the poll
     if the user has not vote that display the voting choice.
 

In the leftcolumn.tpl  I've modified the poll part for


{if $smarty.session.UserId != '' && $poll_data|@count > 0 }
   {include file="polls.tpl"}
   <br />
{/if}

Hi,

I will try and sort. Should be later today, or tomorrow morning.

Hi Benoitc64,

Try these updated .php files.
I added an if/else to make sure the UserID was set if not it, exit and if it is, it runs.

After update those files,  the website is blank screen.

Hi,

Try these updated ones.

hi , with the new file , when signoff everything appear fine, but when we sign on  the site is blank.

Hi,

Try these .php files.
If not I will need to look at it tomorrow and test it out.

Hi, it don't works

the problem seems to be with the $_SESSION['UserId']

The global var  aren't set when nobody  is online that cause a problem with the sql statement.

Hi,

Ok, I think I have the answer now, and I have tested this, and works fine for me.

Step 1:
Restore the original polls.php and votehere.php files, you posted.

Step 2:
Open init.php

Find:
if (!isset($_SESSION['AdminId'])) {
include_once( 'polls.php' );
include_once( 'stories.php' );
include_once( 'news.php' );
if ($config['display_list_of_events'] > 0) include_once( 'showevents.php' );

}

Change to:
if (!isset($_SESSION['AdminId'])) {
// include_once( 'polls.php' );
include_once( 'stories.php' );
include_once( 'news.php' );
if ($config['display_list_of_events'] > 0) include_once( 'showevents.php' );

}

Directly below add:
if (isset($_SESSION['UserId'])) {
    include_once( 'polls.php' );
}

This should now look like

if (!isset($_SESSION['AdminId'])) {
// include_once( 'polls.php' );
include_once( 'stories.php' );
include_once( 'news.php' );
if ($config['display_list_of_events'] > 0) include_once( 'showevents.php' );

}

if (isset($_SESSION['UserId'])) {
    include_once( 'polls.php' );
}


Thanks  , it works perfectly.

if you want , you can include it in the new package of osdate evo