Pradinis
Pagalba
Užsisakyk!
- Reklamą
- Hostingą
- El. pašto dėžutę
Užsisakyk!
Įrankiai
Pasidalink
- Visos temos
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Expert PHP, MySQL klausimai |
Autorius: lilas | Peržiūrų: 1705 |
lilas Narys Kapitonas Pranešimai: 793 Įstojęs: 2007 Lap. 20 15:11:44 | |
Kaip padaryti kad uzbalsavus rezultatus rodytu pagal rezultatu skaiciu mazejimo tvarka? poll'o kodas: openside($locale['global_130']); if (isset($_POST['cast_vote']) && (isset($_POST['poll_id']) && isnum($_POST['poll_id']))) { $result = dbquery("SELECT * FROM ".DB_POLL_VOTES." WHERE vote_user='".$userdata['user_id']."' AND poll_id='".$_POST['poll_id']."'"); if (!dbrows($result)) { if (isset($_POST['voteoption']) && isnum($_POST['voteoption'])) { $result = dbquery("INSERT INTO ".DB_POLL_VOTES." (vote_user, vote_opt, poll_id) VALUES ('".$userdata['user_id']."', '".$_POST['voteoption']."', '".$_POST['poll_id']."')"); } redirect(FUSION_SELF.(FUSION_QUERY ? "?".FUSION_QUERY : "")); } } $result = dbquery("SELECT * FROM ".DB_POLLS." ORDER BY poll_started DESC LIMIT 1"); if (dbrows($result)) { $data = dbarray($result); $poll_title = parsesmileys($data['poll_title']); $poll_option = array(); for ($i = 0; $i <= 9; $i++) { if ($data["poll_opt_".$i]) $poll_option[$i] = parsesmileys($data["poll_opt_".$i]); } if (iMEMBER) $result2 = dbquery("SELECT * FROM ".DB_POLL_VOTES." WHERE vote_user='".$userdata['user_id']."' AND poll_id='".$data['poll_id']."'"); if ((!iMEMBER || !dbrows($result2)) && $data['poll_ended'] == 0) { $poll = ""; $i = 0; $num_opts = count($poll_option); while ($i < $num_opts) { $poll .= "<label><input type='radio' name='voteoption' value='$i' /> $poll_option[$i]</label><br />\n"; $i++; } echo "<form name='voteform' method='post' action='".FUSION_SELF.(FUSION_QUERY ? "?".FUSION_QUERY : "")."'>\n"; echo "<div style='text-align:center'>".$poll_title."</div><br />\n".$poll; echo "<div style='text-align:center'><input type='hidden' name='poll_id' value='".$data['poll_id']."' /><br />\n"; if (iMEMBER) { echo "<input type='submit' name='cast_vote' value='".$locale['global_131']."' class='button' />"; } else { echo $locale['global_132']; } echo "</div>\n</form>\n"; } else { $poll = ""; $i = 0; $num_opts = count($poll_option); $poll_votes = dbcount("(vote_opt)", DB_POLL_VOTES, "poll_id='".$data['poll_id']."'"); while ($i < $num_opts) { $num_votes = dbcount("(vote_opt)", DB_POLL_VOTES, "vote_opt='$i' AND poll_id='".$data['poll_id']."'"); $opt_votes = ($poll_votes ? number_format(100 / $poll_votes * $num_votes) : 0); $ilgis = $opt_votes/2; $poll .= "<div>".parsesmileys($poll_option[$i])."</div>\n"; $poll .= "<div><img src='".get_image("pollbar")."' height='7' width='".$ilgis."' class='poll' /><span class='small1'> ".$opt_votes."% (".$num_votes." ".($num_votes == 1 ? $locale['global_133'] : $locale['global_134']).")</span></div>\n"; $i++; } echo "<div style='text-align:center'>".$poll_title."</div><br />\n"; echo "<div>".$poll."</div>"; echo "<div style='text-align:center'>"; $data['poll_ended'])."\n"; $result = dbquery("SELECT * FROM ".DB_POLLS); if (dbrows($result) > 1) { echo "<br /><a href='".INFUSIONS."member_poll_panel/polls_archive.php' class='side'>".$locale['global_138']."</a>\n"; } echo "</div>\n"; } } else { echo "<div style='text-align:center'>".$locale['global_142']."</div>\n"; } closeside(); Gyvenkim šiandiena sugrįžkim namo kur širdys gyvena Redagavo lilas 2009 Vas. 11 20:02:07 |
|
ramon Narys Ekspertas Pranešimai: 2977 Įstojęs: 2006 Gru. 18 11:12:50 | |
query... |
|
lilas Narys Kapitonas Pranešimai: 793 Įstojęs: 2007 Lap. 20 15:11:44 | |
Ties kuria viena rasyt ir kaip tiksliau? Gyvenkim šiandiena sugrįžkim namo kur širdys gyvena |
Peršokti į forumą: |