Custom pages or vanilla CMS

jhardin

Hello,

I could really use some help with this. I am trying to create a form for a registration for an event. I am hopeing that after I get this one form done I can then work on making it a plugin that would allow people to make custom forms in the future for various reasons.

The code is posted in the next comment.

I also need to find a way to deny access depending on roles.

I really don't know what I'm doing. I'm reading all kinds of things but not really finding the answers that I need and that might be because I don't know the right questions.

I am using an embedded version of the forum.

Thank you for your time.

Sincerely,

jhardin

 <?php if (!defined('APPLICATION')) exit(); 



             $Session = Gdn::Session();
             if ($Session->IsValid()) {
             $userid = $Session->UserID;
            $Name = $Session->User->Name; }
            echo $Name;

            new Database();         
            $Database->Select('Email');
            $Database->From('GDN_User');
            $Database->Where('Name =',$Name);
            $DataSet = $Database->Get();
            echo $Dataset;



            $con = mysql_connect("localhost","######","######");
                    if (!$con)
                        {
                        die('Could not connect: ' . mysql_error());
                        }
            mysql_select_db("######", $con) or die(mysql_error());
            $sql="INSERT INTO KhanKon2012 
            (email, username, GameSession1, GameSession2, GameSession3, GameSession4)
            VALUES ('$_POST[email]','$_POST[Name]','$_POST[GameSession1]','$_POST[GameSession2]','$_POST[GameSession3]','$_POST[GameSession4]')";

        if (!mysql_query($sql,$con))
                {
                die('Error: ' . mysql_error());
                }
        echo "1 record added";

 mysql_close($con);

 ?>

jhardin

So this is what I have now but the submit button doesn't seem to do anything

<?php if (!defined('APPLICATION')) exit(); 


    // only execute if postback


            $Session = Gdn::Session();
            if ($Session->IsValid()) {
            $userid = $Session->UserID;
            $Name = $Session->User->Name; }

            $con = mysql_connect("","","");

            mysql_select_db("ourplayb_vnl1", $con) or die(mysql_error());

            $result = mysql_query("SELECT Email FROM GDN_User 
            WHERE Name='$Name'");

            if (!$result) {
                $message  = 'Invalid query: ' . mysql_error() . "\n";
                $message .= 'Whole query: ' . $query;
                die($message);
            }

                $row = mysql_fetch_assoc($result);
                var_dump($row); // see what type of variable mysql_fetch_array() gave you
                $Email2 = $row['Email'];  // ...and use that knowledge here

if($_SERVER['REQUEST_METHOD'] == 'POST')
{


            $sql="INSERT INTO KhanKon2012 (email, username, GameSession1, GameSession2, GameSession3, GameSession4)
            VALUES ('$Email2','$Name','$_POST[GameSession1]','$_POST[GameSession2]','$_POST[GameSession3]','$_POST[GameSession4]')";

            if (!mysql_query($sql,$con))
                {
                die('Error: ' . mysql_error());
                }
        echo "1 record added";

mysql_close($con);
}

?>


<p>Pleas pick which events at the CON you would like to attend.</p>

<h1>Saturday</h2>

<form method="post" action="<?php echo $PHP_SELF;?>">
<select name="GameSession1">
    <option value="battlestar">Battlestar Galactica</option>
    <option value="vampire">Vampire Red Dawn (GM: Francis)</option>
    <option value="something">Something else</option>
</select>


<select name="GameSession2">
    <option value="battlestar">Battlestar Galactica</option>
    <option value="vampire">Vampire Red Dawn (GM: Francis)</option>
    <option value="something">Something else</option>
</select>



<select name="GameSession3">
    <option value="battlestar">Battlestar Galactica</option>
    <option value="vampire">Vampire Red Dawn (GM: Francis)</option>
    <option value="something">Something else</option>
</select>
</form>



<h1>Sunday</h2>
<select name="GameSession4">
    <option value="battlestar">Battlestar Galactica</option>
    <option value="vampire">Vampire Red Dawn (GM: Francis)</option>
    <option value="something">Something else</option>
</select>
<input type="submit" value="submit" name="submit_button" />

</form>

Does anybody have any advice as to what I am doing heinously wrong?

Aolee

I suggest you create a plugin instead of creating a reg page using CustomPages. Check out the AboutMe plugin. it's one of the most basic and simple plugin i can think of that uses Form submission. => http://vanillaforums.org/addon/aboutme-plugin

jhardin

With a plugin can I have it on a seperate page?

peregrine

check out the members plugins. They produce separate pages and are plugins. That with Aolee's suggestion should provide you a good start. Don't be afraid to start over from scratch, it might be easier. Also read the documentation on models, views, controllers, and modules. Also look at plugins by the the creators of vanilla and x00 to name a few.

jhardin

Thanks, I've been looking at aboutme and I'm starting to understand a bit more what I was doing wrong. I'll also check out the other ones you mentioned. I think when I am done, I will write up a tutorial to help other noobs who are having similar problems as me. At the vary least I will post something here for other people to see when I get 'something' working and hopefully somebody on the forum can then say why what I'm doing is wrong for everyone's education.

Vanilla is a great piece of software and I hope more people end up using it.

peregrine

I clicked awesome, because you look like you want to give back to the community after you learn some things, and the buttons awesome, insightful are used to show your appreciation for help as well as intentions implied by the commenter.

this might also provide some insights on plugins, applications, etc.

http://vanillaforums.org/discussion/comment/165696/#Comment_165696

jhardin

Thanks for the vote of awesome. Hopefully I can get this done. I am making some progress, thank you for pointing in the right direction.

jhardin

So, I followed through with just using the custom pages and it seems to be working now. However, after reading what you guys had to say it does seem making it as a plugin would make many times over more sense.

However, this is what I have so far.