แจกของฟรี

./Sources/Poll.php
Find: [Select]

global $topic, $txt, $user_info, $smcFunc, $sourcedir, $modSettings;

Add After: [Select]

$poll = !empty($_REQUEST['poll']) ? (int)$_REQUEST['poll'] : 0;
   


Find: [Select]

FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}polls AS p ON (p.id_poll = t.id_poll)
         LEFT JOIN {db_prefix}log_polls AS lp ON (p.id_poll = lp.id_poll AND lp.id_member = {int:current_member} AND lp.id_member != {int:not_guest})
      WHERE t.id_topic = {int:current_topic}
      LIMIT 1',
      array(
         'current_member' => $user_info['id'],
         'current_topic' => $topic,
         'not_guest' => 0,
      )

Replace With: [Select]

FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}polls AS p ON (p.id_topic = t.id_topic)
         LEFT JOIN {db_prefix}log_polls AS lp ON (p.id_poll = lp.id_poll AND lp.id_member = {int:current_member} AND lp.id_member != {int:not_guest})
      WHERE p.id_topic = {int:current_topic} AND (p.id_poll = {int:poll} OR p.id_poll = t.id_poll)
      ORDER BY p.id_poll DESC
      LIMIT 1',
      array(
         'current_member' => $user_info['id'],
         'current_topic' => $topic,
         'not_guest' => 0,
         'poll' => $poll,
      )


Find: [Select]

global $topic, $user_info, $smcFunc;

   checkSession('get');

Add After: [Select]

$poll = !empty($_REQUEST['poll']) ? (int)$_REQUEST['poll'] : 0;
   


Find: [Select]

SELECT t.id_member_started, t.id_poll, p.voting_locked
      FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}polls AS p ON (p.id_poll = t.id_poll)
      WHERE t.id_topic = {int:current_topic}
      LIMIT 1',
      array(
         'current_topic' => $topic,
      )

Replace With: [Select]

SELECT t.id_member_started, p.id_poll, p.voting_locked
      FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}polls AS p ON (p.id_topic = t.id_topic)
      WHERE p.id_topic = {int:current_topic} AND (p.id_poll = {int:poll} OR p.id_poll = t.id_poll)
      ORDER BY p.id_poll DESC
      LIMIT 1',
      array(
         'current_topic' => $topic,
         'poll' => $poll,
      )


Find: [Select]

global $txt, $user_info, $context, $topic, $board, $smcFunc, $sourcedir, $scripturl;

Add After: [Select]

$poll = !empty($_REQUEST['poll']) ? (int)$_REQUEST['poll'] : 0;
   


Find: [Select]

// Check if a poll currently exists on this topic, and get the id, question and starter.
   $request = $smcFunc['db_query']('', '
      SELECT
         t.id_member_started, p.id_poll, p.question, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
         m.subject, p.guest_vote, p.id_member AS poll_starter
      FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
         LEFT JOIN {db_prefix}polls AS p ON (p.id_poll = t.id_poll)
      WHERE t.id_topic = {int:current_topic}
      LIMIT 1',
      array(
         'current_topic' => $topic,
      )
   );

Replace With: [Select]

if($context['is_edit'])
   {
      // Check if a poll currently exists on this topic, and get the id, question and starter.
      $request = $smcFunc['db_query']('', '
         SELECT
            t.id_member_started, p.id_poll, p.question, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
            m.subject, p.guest_vote, p.id_member AS poll_starter
         FROM {db_prefix}topics AS t
            INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
            LEFT JOIN {db_prefix}polls AS p ON (p.id_topic = t.id_topic)
         WHERE p.id_topic = {int:current_topic} AND (p.id_poll = {int:poll} OR p.id_poll = t.id_poll)
            ORDER BY p.id_poll DESC
         LIMIT 1',
         array(
            'current_topic' => $topic,
            'poll' => $poll
         )
      );
   }
   else
   {
      // Check if a poll currently exists on this topic, and get the id, question and starter.
      $request = $smcFunc['db_query']('', '
         SELECT
            t.id_member_started, p.id_poll, p.question, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
            m.subject, p.guest_vote, p.id_member AS poll_starter
         FROM {db_prefix}topics AS t
            INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
            LEFT JOIN {db_prefix}polls AS p ON (p.id_poll = t.id_poll)
         WHERE t.id_topic = {int:current_topic}
         LIMIT 1',
         array(
            'current_topic' => $topic,
         )
      );
   }


Find: [Select]

// If we are adding a new poll - make sure that there isn't already a poll there.
   if (!$context['is_edit'] && !empty($pollinfo['id_poll']))
      fatal_lang_error('poll_already_exists');

Replace With: [Select]

/* REMEMBER TO RE-ADD CODE HERE 289347 */


Find: [Select]

elseif ($context['is_edit'] && empty($pollinfo['id_poll']))

Replace With: [Select]

if ($context['is_edit'] && empty($pollinfo['id_poll']))


Find: [Select]

global $modSettings, $user_info, $smcFunc, $sourcedir;

Add After: [Select]

   $poll = !empty($_REQUEST['poll']) ? (int)$_REQUEST['poll'] : 0;
   


Find: [Select]

// Get the starter and the poll's ID - if it's an edit.
   $request = $smcFunc['db_query']('', '
      SELECT t.id_member_started, t.id_poll, p.id_member AS poll_starter, p.expire_time
      FROM {db_prefix}topics AS t
         LEFT JOIN {db_prefix}polls AS p ON (p.id_poll = t.id_poll)
      WHERE t.id_topic = {int:current_topic}
      LIMIT 1',
      array(
         'current_topic' => $topic,
      )
   )

Replace With: [Select]

if($isEdit)
   {
      // Check if a poll currently exists on this topic, and get the id, question and starter.
      $request = $smcFunc['db_query']('', '
         SELECT
            t.id_member_started, p.id_poll, p.question, p.hide_results, p.expire_time, p.max_votes, p.change_vote,
            m.subject, p.guest_vote, p.id_member AS poll_starter
         FROM {db_prefix}topics AS t
            INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
            LEFT JOIN {db_prefix}polls AS p ON (p.id_topic = t.id_topic)
         WHERE p.id_topic = {int:current_topic} AND (p.id_poll = {int:poll} OR p.id_poll = t.id_poll)
            ORDER BY p.id_poll DESC
         LIMIT 1',
         array(
            'current_topic' => $topic,
            'poll' => $poll
         )
      );
   }
   else
   {
      // Check if a poll currently exists on this topic, and get the id, question and starter.
      $request = $smcFunc['db_query']('', '
         SELECT
            t.id_member_started
         FROM {db_prefix}topics AS t
         WHERE t.id_topic = {int:current_topic}
         LIMIT 1',
         array(
            'current_topic' => $topic,
         )
      );
   }


Find: [Select]

// Check their adding/editing is valid.
   if (!$isEdit && !empty($bcinfo['id_poll']))
      fatal_lang_error('poll_already_exists');

Replace With: [Select]

/* REMEMBER TO RE-ADD CODE HERE 892734 */


Find: [Select]

elseif ($isEdit && empty($bcinfo['id_poll']))

Replace With: [Select]

if ($isEdit && empty($bcinfo['id_poll']))


Find: [Select]

$smcFunc['db_insert']('',
         '{db_prefix}polls',
         array(
            'question' => 'string-255', 'hide_results' => 'int', 'max_votes' => 'int', 'expire_time' => 'int', 'id_member' => 'int',
            'poster_name' => 'string-255', 'change_vote' => 'int', 'guest_vote' => 'int'
         ),
         array(
            $_POST['question'], $_POST['poll_hide'], $_POST['poll_max_votes'], $_POST['poll_expire'], $user_info['id'],
            $user_info['username'], $_POST['poll_change_vote'], $_POST['poll_guest_vote'],
         ),
         array('id_poll')
      );

Replace With: [Select]

$smcFunc['db_insert']('',
         '{db_prefix}polls',
         array(
            'id_topic' => 'int', 'question' => 'string-255', 'hide_results' => 'int', 'max_votes' => 'int', 'expire_time' => 'int', 'id_member' => 'int',
            'poster_name' => 'string-255', 'change_vote' => 'int', 'guest_vote' => 'int'
         ),
         array(
            $topic, $_POST['question'], $_POST['poll_hide'], $_POST['poll_max_votes'], $_POST['poll_expire'], $user_info['id'],
            $user_info['username'], $_POST['poll_change_vote'], $_POST['poll_guest_vote'],
         ),
         array('id_poll')
      );


Find: [Select]

$smcFunc['db_query']('', '
         UPDATE {db_prefix}polls
         SET question = {string:question}, change_vote = {int:change_vote},' . (allowedTo('moderate_board') ? '
            hide_results = {int:hide_results}, expire_time = {int:expire_time}, max_votes = {int:max_votes},
            guest_vote = {int:guest_vote}' : '
            hide_results = CASE WHEN expire_time = {int:expire_time_zero} AND {int:hide_results} = 2 THEN 1 ELSE {int:hide_results} END') . '
         WHERE id_poll = {int:id_poll}',
         array(
            'change_vote' => $_POST['poll_change_vote'],
            'hide_results' => $_POST['poll_hide'],
            'expire_time' => !empty($_POST['poll_expire']) ? $_POST['poll_expire'] : 0,
            'max_votes' => !empty($_POST['poll_max_votes']) ? $_POST['poll_max_votes'] : 0,
            'guest_vote' => $_POST['poll_guest_vote'],
            'expire_time_zero' => 0,
            'id_poll' => $bcinfo['id_poll'],
            'question' => $_POST['question'],
         )
      );

Replace With: [Select]

$smcFunc['db_query']('', '
         UPDATE {db_prefix}polls
         SET id_topic = {int:current_topic},
            question = {string:question}, change_vote = {int:change_vote},' . (allowedTo('moderate_board') ? '
            hide_results = {int:hide_results}, expire_time = {int:expire_time}, max_votes = {int:max_votes},
            guest_vote = {int:guest_vote}' : '
            hide_results = CASE WHEN expire_time = {int:expire_time_zero} AND {int:hide_results} = 2 THEN 1 ELSE {int:hide_results} END') . '
         WHERE id_poll = {int:id_poll}',
         array(
            'current_topic' => $topic,
            'change_vote' => $_POST['poll_change_vote'],
            'hide_results' => $_POST['poll_hide'],
            'expire_time' => !empty($_POST['poll_expire']) ? $_POST['poll_expire'] : 0,
            'max_votes' => !empty($_POST['poll_max_votes']) ? $_POST['poll_max_votes'] : 0,
            'guest_vote' => $_POST['poll_guest_vote'],
            'expire_time_zero' => 0,
            'id_poll' => $bcinfo['id_poll'],
            'question' => $_POST['question'],
         )
      );


Find: [Select]

// Link the poll to the topic
      $smcFunc['db_query']('', '
         UPDATE {db_prefix}topics
         SET id_poll = {int:id_poll}
         WHERE id_topic = {int:current_topic}',
         array(
            'current_topic' => $topic,
            'id_poll' => $bcinfo['id_poll'],
         )
      );

Replace With: [Select]

// Link the poll to the topic
      $smcFunc['db_query']('', '
         UPDATE {db_prefix}topics
         SET id_poll = {int:id_poll}
         WHERE id_topic = {int:current_topic} AND id_poll = 0',
         array(
            'current_topic' => $topic,
            'id_poll' => $bcinfo['id_poll'],
         )
      );


Find: [Select]

global $topic, $user_info, $smcFunc;

   // Make sure the topic is not empty.

Add After: [Select]


         $poll = !empty($_REQUEST['poll']) ? (int)$_REQUEST['poll'] : 0;
   


Find: [Select]

$request = $smcFunc['db_query']('', '
         SELECT t.id_member_started, p.id_member AS poll_starter
         FROM {db_prefix}topics AS t
            INNER JOIN {db_prefix}polls AS p ON (p.id_poll = t.id_poll)
         WHERE t.id_topic = {int:current_topic}
         LIMIT 1',
         array(
            'current_topic' => $topic,
         )
      );

Replace With: [Select]

$request = $smcFunc['db_query']('', '
         SELECT t.id_member_started, p.id_member AS poll_starter
         FROM {db_prefix}topics AS t
            INNER JOIN {db_prefix}polls AS p ON (p.id_topic = t.id_topic)
         WHERE p.id_topic = {int:current_topic} AND (p.id_poll = {int:poll} OR p.id_poll = t.id_poll)
         LIMIT 1',
         array(
            'current_topic' => $topic,
            'poll' => $poll,
         )
      );


Find: [Select]

$request = $smcFunc['db_query']('', '
      SELECT id_poll
      FROM {db_prefix}topics
      WHERE id_topic = {int:current_topic}
      LIMIT 1',
      array(
         'current_topic' => $topic,
      )
   );

Replace With: [Select]

$request = $smcFunc['db_query']('', '
      SELECT p.id_poll
      FROM {db_prefix}topics AS t
         LEFT JOIN {db_prefix}polls AS p ON (p.id_topic = t.id_topic)
      WHERE p.id_topic = {int:current_topic} AND (p.id_poll = {int:poll} OR p.id_poll = t.id_poll)
      ORDER BY p.ID_POLL DESC
      LIMIT 1',
      array(
         'current_topic' => $topic,
         'poll' => $poll
      )
   );


Find: [Select]

// Finally set the topic poll ID back to 0!
   $smcFunc['db_query']('', '
      UPDATE {db_prefix}topics
      SET id_poll = {int:no_poll}
      WHERE id_topic = {int:current_topic}',
      array(
         'current_topic' => $topic,
         'no_poll' => 0,
      )
   );

Replace With: [Select]

// Finally set the topic poll ID back to 0!
   $smcFunc['db_query']('', '
      UPDATE {db_prefix}topics
      SET id_poll = {int:no_poll}
      WHERE id_topic = {int:current_topic} AND id_poll = {int:id_poll}',
      array(
         'current_topic' => $topic,
         'no_poll' => 0,
         'id_poll' => $pollID,
      )
   );


Find: [Select]

// Take the moderator back to the topic.
   redirectexit('topic=' . $topic . '.' . $_REQUEST['start']);
}

?>

Add Before: [Select]

   if($smcFunc['db_affected_rows']() > 0)
   {
      $request = $smcFunc['db_query']('', '
         SELECT id_poll
         FROM {db_prefix}polls
         WHERE ID_TOPIC = {int:current_topic}
         LIMIT 1',
         array(
            'current_topic' => $topic
         )
      );         
      
      if($smcFunc['db_num_rows']($request) > 0)
      {
         list($pollID) = $smcFunc['db_fetch_row']($request);
         
         $smcFunc['db_free_result']($request);
         
         $smcFunc['db_query']('', '
            UPDATE {db_prefix}topics
            SET id_poll = {int:poll}
            WHERE ID_TOPIC = {int:current_topic}
            LIMIT 1',
            array(
               'current_topic' => $topic,
               'poll' => $pollID,
            )
         );
      }
   }