Apklausa su iki 20 parametrų
Parašė Rytis 2007 rugpjūčio 9 09:08:08

---

delfas2 prašymu (forume) sukurtas patobulinimas, kuris leidžia sukurti apklausą su iki 20 parametrų.

---

---

FAILAI

Redaguojami failai:
phpmyadmin
/infusions/member_poll_panel/member_poll_panel.php
/infusions/member_poll_panel/polls_archive.php
/administration/polls.php


1. SQL duomenų bazėje įvykdykite šį kodą:

ALTER TABLE `{{PREFIX}}polls` ADD `poll_opt_10` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_9` ,
ADD `poll_opt_11` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_10` ,
ADD `poll_opt_12` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_11` ,
ADD `poll_opt_13` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_12` ,
ADD `poll_opt_14` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_13` ,
ADD `poll_opt_15` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_14` ,
ADD `poll_opt_16` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_15` ,
ADD `poll_opt_17` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_16` ,
ADD `poll_opt_18` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_17` ,
ADD `poll_opt_19` VARCHAR( 200 ) NOT NULL AFTER `poll_opt_18` ;




2. Atsidarykite /infusions/member_poll_panel/member_poll_panel.php ir susiraskite 27 eilutę, kurioje būs

for ($i=0; $i<=9; $i++) {




pakeiskite tai į:

for ($i=0; $i<=19; $i++) {




2. Atsidarykite /infusions/member_poll_panel/polls_archive.php ir susiraskite 37 eilutę, kurioje būs

for ($i=0; $i<=9; $i++) {




pakeiskite tai į:

for ($i=0; $i<=19; $i++) {




3. Atsidarykite /administration/polls.php ir susiraskite
45 eilutę, kurioje būs

$result = dbquery("UPDATE ".$db_prefix."polls SET poll_title='$poll_title', poll_opt_0='$poll_option[0]', poll_opt_1='$poll_option[1]', poll_opt_2='$poll_option[2]', poll_opt_3='$poll_option[3]', poll_opt_4='$poll_option[4]', poll_opt_5='$poll_option[5]', poll_opt_6='$poll_option[6]', poll_opt_7='$poll_option[7]', poll_opt_8='$poll_option[8]', poll_opt_9='$poll_option[9]',poll_opt_9='$poll_option[9]', poll_ended='$ended' WHERE poll_id='$poll_id'");




pakeiskite į

$result = dbquery("UPDATE ".$db_prefix."polls SET poll_title='$poll_title', poll_opt_0='$poll_option[0]', poll_opt_1='$poll_option[1]', poll_opt_2='$poll_option[2]', poll_opt_3='$poll_option[3]', poll_opt_4='$poll_option[4]', poll_opt_5='$poll_option[5]', poll_opt_6='$poll_option[6]', poll_opt_7='$poll_option[7]', poll_opt_8='$poll_option[8]', poll_opt_9='$poll_option[9]', poll_opt_10='$poll_option[10]', poll_opt_11='$poll_option[11]', poll_opt_12='$poll_option[12]', poll_opt_13='$poll_option[13]', poll_opt_14='$poll_option[14]', poll_opt_15='$poll_option[15]', poll_opt_16='$poll_option[16]', poll_opt_16='$poll_option[16]', poll_opt_17='$poll_option[17]', poll_opt_18='$poll_option[18]', poll_opt_19='$poll_option[19]', poll_ended='$ended' WHERE poll_id='$poll_id'");




Po to susirask 49 eilutę, kurioje būs

$result = dbquery("INSERT INTO ".$db_prefix."polls (poll_title, poll_opt_0, poll_opt_1, poll_opt_2, poll_opt_3, poll_opt_4, poll_opt_5, poll_opt_6, poll_opt_7, poll_opt_8, poll_opt_9, poll_started, poll_ended) VALUES ('$poll_title', '$poll_option[0]', '$poll_option[1]', '$poll_option[2]', '$poll_option[3]', '$poll_option[4]', '$poll_option[5]', '$poll_option[6]', '$poll_option[7]', '$poll_option[8]', '$poll_option[9]', '".time()."', '0')");




keisk į

   $result = dbquery("INSERT INTO ".$db_prefix."polls (poll_title, poll_opt_0, poll_opt_1, poll_opt_2, poll_opt_3, poll_opt_4, poll_opt_5, poll_opt_6, poll_opt_7, poll_opt_8, poll_opt_9, poll_opt_10, poll_opt_11, poll_opt_12, poll_opt_13, poll_opt_14, poll_opt_15, poll_opt_16, poll_opt_17, poll_opt_18, poll_opt_19, poll_started, poll_ended) VALUES ('$poll_title', '$poll_option[0]', '$poll_option[1]', '$poll_option[2]', '$poll_option[3]', '$poll_option[4]', '$poll_option[5]', '$poll_option[6]', '$poll_option[7]', '$poll_option[8]', '$poll_option[9]', '$poll_option[10]', '$poll_option[11]', '$poll_option[12]', '$poll_option[13]', '$poll_option[14]', '$poll_option[15]', '$poll_option[16]', '$poll_option[17]', '$poll_option[18]', '$poll_option[19]', '".time()."', '0')");




Susirask 101 eilutę, kurioje būs

for ($i=0; $i<=9; $i++) {




pakeiskite tai į:

for ($i=0; $i<=19; $i++) {




Susirask 113 eilutę, kurioje būs

$opt_count = ($_POST['opt_count'] != 10 ? count($poll_option) + 1 : $_POST['opt_count']);




keisk į

$opt_count = ($_POST['opt_count'] != 20 ? count($poll_option) + 1 : $_POST['opt_count']);




FAILAI PRISGETI

---