/docs/www/colonyscout/internal/admin/do_addmember.php - Annotate - Colony Scout - Robotics Club

f59acf11

Dan Shope

<?php

2

include($_SERVER['DOCUMENT_ROOT']."/control/do_login.php");

3

doDB("dshope_robotics");

4

5

6

$userName = addslashes($_POST["user"]);

7

$emailAddress = addslashes($_POST["email"]);

8

9

if (!isset($_POST["bypass"])){

10

        //perform validation

11

12

        //check if email is in use

13

        $verify_email_sql = "SELECT id FROM members WHERE email = '".$emailAddress."'";

14

        $verify_email_res =  mysqli_query($mysqli, $verify_email_sql) or die(mysqli_error($mysqli));

15

16

        if (mysqli_num_rows($verify_email_res) > 0) {

17

                //this email address is already registered, so take to error page

18

19

                header("Location: inuse.php?t=email");

20

                exit;

21

22

23

        //-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

24

        //check if username is already in use

25

        $verify_account_sql = "SELECT id FROM members WHERE userName = '".$userName."'";

26

        $verify_account_res =  mysqli_query($mysqli, $verify_account_sql) or die(mysqli_error($mysqli));

27

28

        if (mysqli_num_rows($verify_account_res) > 0) {

29

                //this username address is already registered, so take to error page

30

31

                header("Location: inuse.php?t=user");

32

                exit;

//-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

37

//this step only occurs AFTER we know that this username is not in use...

38

//unless the checking step was bypassed by the re-registration form...

39

40

$userPass = addslashes($_POST["pass"]);

41

42

//get the users full name

43

$realName = addslashes($_POST["name"]);

44

$name = str_replace('  ', ' ', $realName);

45

$realNameList = explode(' ',$name);

46

47

$lastName = end($realNameList);

48

unset($realNameList[sizeof($realNameList)-1]);

49

50

$firstName = "";

51

foreach ($realNameList as $nameItem) {        //rebuild the full first name

52

        $firstName .= $nameItem." ";

53

54

55

$userString = str_replace(', ', ',', $userName); //take out extraneous spaces, leave good ones intact

56

$userDashed = str_replace(' ', '-', $userString); //any spaces remaining (within phrases) should be replaced with dashes

57

58

$today = date("Y-m-d");

59

$regcode = md5($realName.$emailAddress.$userName.$today);

60

61

//add record into members database

62

$add_member_sql = "INSERT INTO members(FirstName, LastName, userName, Password, Email, Validated, ValidDate, DateAdded) VALUES ('".$firstName."','".$lastName."','".$userName."',password('".$userPass."'),'".$emailAddress."', '".$regcode."', (SELECT DATE_ADD(now(), INTERVAL 2 DAY)), now())";

63

$add_member_res = mysqli_query($mysqli, $add_member_sql) or die(mysqli_error($mysqli));

64

65

//close connection to MySQL

66

mysqli_close($mysqli);

67

68

//-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

69

//send validation email

70

$headers = "From: registration@danshope.com\r\nContent-type: text/html";

71

72

$body = "<HTML><BODY><CENTER>

73

<TABLE BORDER='0'>

74

<TR><TD align='left'><IMG SRC='http://danshope.com/rsc/signup.jpg'><br><br></TD></TR>

75

<TR><TD align='left' STYLE='font-family:arial;'><B>Welcome to DanShope.com!</B><br><br>

76

Hi ".$userName."! We're glad you decided to become a member of the DanShope.com robotics family!<br>

77

As a member you are entitled to <b>50MB</b> online hosting for your projects. You also get your own message box for project communication, and a sweet project homepage!<br><br>

78

In order to complete your membership, you must click on the confirmation link below, or copy it into your web browser.<br><br>

79

<a href='http://www.danshope.com/confirm/".$regcode."'>http://www.danshope.com/confirm/".$regcode."</a><br><br>

80

The link below is your unique url to the site. Send this url to

81

everyone you know so they can see what you've been working on.<br>

82

<br>

83

Your URL: http://www.danshope.com/user/".$userDashed."<br>

84

<br>

85

To make the most of your DanShope.com experience complete the following:<br>

86

<br>

87

- Start a project<br>

88

- Upload any projects you've already started<br>

89

- Search and download anything that interests you<br>

90

<br>

91

-------------------------------------------------------------------------<br>

92

Email : ".$emailAddress."<br>

93

User Name : ".$userName."<br>

94

-------------------------------------------------------------------------<br><br>

95

<b>Thanks for joining!</b><br><br></TD></TR>

96

<tr><td STYLE='font-family:arial; font-size:12px;'>DanShope.com takes our users' privacy very seriously. This communication, together with any attachments hereto, may contain confidential information. If you have received this communication in error,

97

please notify the sender immediately by return e-mail message and delete all copies of the original communication, along with any attachments hereto or links herein, from your system.</td></tr>

98

</CENTER></BODY>

99

</HTML>";

100

101

mail($emailAddress, "DanShope.com Confirmation", $body, $headers);

102

103

?>

104

105

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

106

<html><head>

107

                <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

108

                <link href="/rsc/main-style.css" rel="stylesheet" type="text/css" media="screen">

109

                <link href="/rsc/robo-style.css" rel="stylesheet" type="text/css" media="screen">

110

                <title>Join! | danshope.com</title>

111

112

                </head><body>

113

114

<div id="general">

115

116

<?php

117

include($_SERVER['DOCUMENT_ROOT']."/nav.php");

118

?>

119

120

<div id="body">

121

        <div class="border-splash"></div>

122

        <?php

123

        include($_SERVER['DOCUMENT_ROOT']."/splashtop.php");

124

?>

125

  <div id="body-boxes">

126

    <div id="box-inside">

127

        <div id="box-padded">

128

                <div id="row"><br>

129

                        <span id="dkbluelargetext"><center>Congratulations <?php echo $realName; ?>!<br><br>

130

                        You are just one step away from officially joining the <br>

131

                        DanShope.com robotics community.

132

                        </center><br>

133

134

                        <hr class="GraySolid" width="100%"><br>

135

                          <img style="display: block;" src="/rsc/join-robo-splash-2.jpg">

136

                        <hr class="GraySolid" width="100%"><br><br>

137

138

                        All you have to do now is check your email (<?php echo $emailAddress; ?>)

139

                        and click on the confirmation link so we know YOU aren't a robot!<br><br>

140

                        <center>Thanks for Joining</center></span><br><br>

141

                </div>

142

        </div>

143

    <div>

144

  </div>

145

</div>

<?php

150

include($_SERVER['DOCUMENT_ROOT']."/footer.php");

151

?>

152

153

<script type="text/javascript">

154

var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");

155

document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));

156

</script>

157

<script type="text/javascript">

158

var pageTracker = _gat._getTracker("UA-6089041-1");

159

pageTracker._trackPageview();

160

</script>

161

162

</div><!--GENERAL!-->

163

</body></html>

Project

General

Profile

Colony » Colony Scout

colonymech / docs / www / colonyscout / internal / admin / do_addmember.php @ f59acf11