Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-27-2016, 09:57 AM
Dinocanid's Avatar
Dinocanid Dinocanid is offline
Member
 
Join Date: Aug 2016
Location: Maryland, USA
Posts: 516
Gender: Unknown/Other
Credits: 68,513
Dinocanid is on a distinguished road
Default "For loop" statements

I was wondering how it would be possible to use "for loop" statements with the mysidia script since it can run a single line of code multiple times. I've looked at a bunch of tutorials online and I'm still lost with what to do with it. I wanted to use it to clean up the raffle script since, at the moment, the same line of code is copy-pasted over and over to make multiple database entries, like so:

PHP Code:
public function index(){
        
$mysidia Registry::get("mysidia");
        
$document $this->document;        
            
$document->setTitle("Pet Outcomes");
                
$pool $mysidia->db->select("raffle", array("pool"))->fetchColumn();
$document->add(new Comment"There is currently {$pool} CURRENCY in the pool!"));
$document->add(new Paragraph());

//This section checks the date!
      
$currenttime time();
      
$timerange = array(strtotime($this->stopdate));
         if(!empty(
$timerange[1]) and $currenttime $timerange[1]){
             
// The raffle has ended!
             
$winner $mysidia->db->select("raffle_tickets", array("owner"), "1 ORDER BY RAND() DESC LIMIT 1")->fetchColumn();
                         
$document->add(new Comment"{$winner} won {$pool} CURRENCY from the raffle! Congratulations!"));    
                         
$endraffle TRUE;
         }
         else{
  
//This is the ticket form!
$ticketForm = new FormBuilder("ticketForm""""post");
$exampleDropdown = new DropdownList("myList");
$exampleDropdown->add(new Option("5 tickets""5")); 
$exampleDropdown->add(new Option("10 tickets""10"));
$exampleDropdown->add(new Option("15 tickets""15"));
$exampleDropdown->add(new Option("20 tickets""20"));
$ticketForm->buildComment("Amount: "FALSE);
$ticketForm->add($exampleDropdown);
$ticketForm->buildComment("<br></br>");
  
$ticketForm->buildButton("Buy tickets""buy""submit");
        
$document->add($ticketForm);
}
//This part adds the number of tickets the user buys to the database
if($mysidia->input->post("buy")){
$chosenOption $mysidia->input->post("myList");
    if(
$chosenOption == "5"){
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
           }
    elseif(
$chosenOption == "10"){
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
           }
    elseif(
$chosenOption == "15"){
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
           }           
    elseif(
$chosenOption == "20"){
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
        
$mysidia->db->insert("raffle_tickets", array("owner" => $mysidia->user->username));
           }  
        }
        
        
//This park picks a winner from the database
if($mysidia->input->post("win")){
$winner $mysidia->db->select("raffle_tickets", array("owner"), "1 ORDER BY RAND() DESC LIMIT 1")->fetchColumn();
$document->add(new Comment"{$winner} won {$pool} CURRENCY from the raffle!"));

It works, but it's not ideal and the code would get very lengthy if more tickets are wanted (like 50).
__________________
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 06:06 AM.

Currently Active Users: 862 (0 members and 862 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636