-
Notifications
You must be signed in to change notification settings - Fork 0
/
update1d.cfm
137 lines (131 loc) · 5.54 KB
/
update1d.cfm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<cfinclude template="translatit.cfm">
<cfquery name="getpass" datasource="#attributes.dsn#">
SELECT *
FROM login
WHERE username='#user#'
</cfquery>
<cfif (#pass# is #getpass.password#) AND (#user# is #getpass.username#)>
<center>
<cfform action="loginpost.cfm" method="post">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="submit" value="Back to Admin Page" name="b1">
</cfform>
<cfif (#getpass.adminlevel# is 2)>
<cfquery datasource="#attributes.dsn#" name="getcontact">
SELECT *
FROM contacts
ORDER BY gender, age
</cfquery>
<cfelse>
<cfquery datasource="#attributes.dsn#" name="getcontact">
SELECT *
FROM contacts
WHERE district like #getpass.district#
ORDER BY gender, age
</cfquery>
</cfif>
<table>
<tr>
<cfoutput>
<td> </td>
<td align="left" valign="top">
<cfform action="update1a.cfm" method="post">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="submit" value="District" name="b1">
</cfform>
</td>
<td align="left" valign="top">
<cfform action="update1b.cfm" method="post">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="submit" value="Name" name="b2">
</cfform>
</td>
<td align="left" valign="top">
<cfform action="update1c.cfm" method="post">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="submit" value="City and Zip" name="b3">
</cfform>
</td>
<td align="left" valign="top">
<cfform action="update1e.cfm" method="post">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="submit" value="County" name="b5">
</cfform>
</td>
<td align="center" valign="top">
<cfform action="update1d.cfm" method="post">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="submit" value="Gender/Age" name="b6">
</cfform>
</td>
<td align="right" valign="top">
<font color="darkblue" size="4">Phone<br>Email</font>
</td>
<td align="center" valign="top">
<cfform action="update1f.cfm" method="post">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="submit" value="T/C" name="b6">
</cfform>
</td>
<td align="right" valign="top">
<font color="darkblue" size="4">Last<br>Updated</font>
</td>
</cfoutput>
</tr>
<tr>
<td colspan="10" align="center">
<hr>
<font size="2">click on buttons to resort by that column</font>
<hr />
</td>
</tr>
<cfoutput query="getcontact">
<tr>
<td>
<cfform method="post" action="update2.cfm">
<cfinput type="submit" value="Edit" name="edit">
<cfinput type="Hidden" name="pass" value="#getpass.password#">
<cfinput type="Hidden" name="user" value="#getpass.username#">
<cfinput type="hidden" name="adminlevel" value="#getpass.adminlevel#">
<cfinput type="hidden" name="contactid" value="#contactid#" size=3>
</cfform>
</td>
<td align="left" valign="top"><font color="darkblue">#state# <br> District #numberformat(district,99)# <br />#statepart#</font></td>
<td align="left" valign="top"><font color="darkblue">#first# #last# </font></td>
<td align="left" valign="top"><font color="darkblue">#address# <br>#city# #zip# </font></td>
<td align="left" valign="top"><font color="darkblue">#metro#<br>#county#</font></td>
<td align="left" valign="top"><font color="darkblue" size="4">#gender#<br>#age#</font></td>
<td align="left" valign="top"><font color="darkblue">#phone#<br>#email#</font></td>
<td align="center" valign="top"><font color="darkblue">#interest#</font></td>
<td align="right" valign="top"><font color="darkblue">#dateformat(added,"mm/dd/yyyy")#</font></td>
</tr>
</tr>
<tr>
<td colspan="10">
<hr color="mediumblue">
</td>
</tr>
</cfoutput>
</table>
</center>
<br><br><br>
<cfelse>
<font face="Arial" size="4">Sorry, you must enter a correct username and password!<br>
<br>
<a href="login.cfm">Back to Login</a></font></center>
<!-- Here you are ending your statement for username and password -->
</cfif>