clpanel/index.php at master · ksmaze/clpanel · GitHub

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
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
<?php
  // Database connectivity
  $user  = "clpanel";
  $pass  = "t3mp123**";
  $dbase = "clpanel";
  $host  = "127.0.0.1";

  // session_start();
  $self   = $_SERVER["PHP_SELF"];
  $lpage  = $_GET["lpage"];
  $search = $_POST["search"];
  $date   = $_POST["date"];

  // Give me the option to go back over 3 days
  $neg1 = strtotime("-1 days");
  $neg2 = strtotime("-2 days");
  $neg3 = strtotime("-3 days");
  $neg4 = strtotime("-4 days");
  $neg5 = strtotime("-5 days");
  $neg6 = strtotime("-6 days");
  $neg7 = strtotime("-7 days");
  $neg8 = strtotime("-8 days");
  $neg9 = strtotime("-9 days");
  $neg10 = strtotime("-10 days");
  $neg12 = strtotime("-1 month");

  $today = date("M j");
  $neg1_d = date("M j", $neg1);
  $neg2_d = date("M j", $neg2);
  $neg3_d = date("M j", $neg3);
  $neg4_d = date("M j", $neg4);
  $neg5_d = date("M j", $neg5);
  $neg6_d = date("M j", $neg6);
  $neg7_d = date("M j", $neg7);
  $neg8_d = date("M j", $neg8);
  $neg9_d = date("M j", $neg9);
  $neg10_d = date("M j", $neg10);
  $neg11_d = date("M");
  $neg12_d = date("M", $neg12);
?>
<html>
<title>Craigslist Global Search</title>
<head>
<link rel="stylesheet" href="stylesheets/style.css" type="text/css" media="screen">
</head>
<div id="page">
  <div id="header">
    <table><tr>
    	<td><a href="http://mymanagedpbx.com"><img src="images/logo.png" border="0"></a></td><td>Craigslist Global Search!</td></tr>
    </table>
  </div>
  <div id="links">
    <?php
	// Set the page search options
	if($lpage == "gigs") {
	  echo "
	    <form action=$self?lpage=gigs method=post>
	    <table>
              <td><b>GIG SEARCH</b></td>
              <td><a href=index.php>Clear/Home</a></td>
              <td><input type=submit name=search value=php></td>
	      <td><input type=submit name=search value=linux></td>
	      <td><input type=submit name=search value=asterisk></td>
	      <td><input type=submit name=search value=perl></td>
	      <td>
	      <select name=date size=1>
	 	<option value=\"$today\">$today</option>
		<option value=\"$neg1_d\">$neg1_d</option>
		<option value=\"$neg2_d\">$neg2_d</option>
		<option value=\"$neg3_d\">$neg3_d</option>
		<option value=\"$neg4_d\">$neg4_d</option>
		<option value=\"$neg5_d\">$neg5_d</option>
		<option value=\"$neg6_d\">$neg6_d</option>
		<option value=\"$neg7_d\">$neg7_d</option>
		<option value=\"$neg8_d\">$neg8_d</option>
		<option value=\"$neg9_d\">$neg9_d</option>
		<option value=\"$neg10_d\">$neg10_d</option>
		<option value=\"$neg11_d\">$neg11_d</option>
		<option value=\"$neg12_d\">$neg12_d</option>
	      </select>
	      </td>
	    </table>
	    </form>
	  ";
	}
	elseif($lpage == "jobs") {
	  echo "
	    <form action=$self?lpage=jobs method=post>
	    <table>
              <td><b>JOB SEARCH</b></td>
              <td><a href=index.php>Clear/Home</a></td>
              <td><input type=submit name=search value=php> </td>
	      <td><input type=submit name=search value=linux> </td>
	      <td><input type=submit name=search value=asterisk> </td>
	      <td><input type=submit name=search value=perl> </td>
	      <td>
	      <select name=date size=1>
	 	<option value=\"$today\">$today</option>
		<option value=\"$neg1_d\">$neg1_d</option>
		<option value=\"$neg2_d\">$neg2_d</option>
		<option value=\"$neg3_d\">$neg3_d</option>
		<option value=\"$neg4_d\">$neg4_d</option>
		<option value=\"$neg5_d\">$neg5_d</option>
		<option value=\"$neg6_d\">$neg6_d</option>
		<option value=\"$neg7_d\">$neg7_d</option>
		<option value=\"$neg8_d\">$neg8_d</option>
		<option value=\"$neg9_d\">$neg9_d</option>
		<option value=\"$neg10_d\">$neg10_d</option>
		<option value=\"$neg11_d\">$neg11_d</option>
		<option value=\"$neg12_d\">$neg12_d</option>
	      </select>
	      </td>
	    </table>
	    </form>
	  ";
	} else {
	  echo "
	    <b>FUNCTION:</b>
	    <a href=index.php?lpage=jobs>Search jobs</a> |
	    <a href=index.php?lpage=gigs>Search gigs</a> |
	    <a href=https://accounts.craigslist.org/ target=_blank>Post to CL</a>
	  ";
	}
    ?>
  </div>
  <div id="display">
    <table>
    <!--# Where all the PHP happens #-->
    <?php
      mysql_connect($host,$user,$pass);
      @mysql_select_db($dbase) or die("Unable to select database");

      $query = "select * from results where func='$lpage' AND search='$search' AND result like '%$date%'";
      $result = mysql_query($query);

      while ($row=mysql_fetch_array($result)) {
        echo "
<tr>
  <td>$row[0]</td>
  <td>$row[1]</td>
  <td>$row[2]</td>
  <td>$row[3]</td>
  <td>$row[4]</td>
</tr>
        ";
      }

      mysql_close();

    ?>
    </table>
  </div>
  <div id="footer">
	<a href="http://dan.mymanagedpbx.com/wordpress">Created by Danny Williams of My Managed PBX</a>
  </div>
</div>
</html>