1  <?php
2  /************************************************************************
3  PCCS MySQLDatabase Admin Tool
4  Copyright (C) Chauncey Thorn
5 
6  This program is free software; you can redistribute it and/or
7  modify it under the terms of the GNU General Public License
8  as published by the Free Software Foundation; either version 2
9  of the License, or (at your option) any later version.
10 
11  This program is distributed in the hope that it will be useful,
12  but WITHOUT ANY WARRANTY; without even the implied warranty of
13  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14  GNU General Public License for more details.
15 
16  You should have received a copy of the GNU General Public License
17  along with this program; if not, write to the Free Software
18  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA , USA.
19  **************************************************************************/
20 
21  ///////////////////////////////////////////////////////////////////////////////
22  // Create referer_include.php
23  // referer.php renamed to referer_include.php
24  // no need to modify unless you like hacking
25  // bugs report to cthorn
26  ///////////////////////////////////////////////////////////////////////////////
27 
28 
29  $referer_filename = "referer_include.php";
30 
31  $referer = fopen($appfiledir . $referer_filename,"w");
32  fputs($referer,"<?php\n// ** Generated by PCCS-MyAppGen\n");
33  fputs($referer,"\n");
34  fputs($referer,"\n");
35  fputs($referer,"//////////////////////////////////////////////////\n");
36  fputs($referer,"// MyReferer Version 1.0\n");
37  fputs($referer,"// Refererauswertung\n");
38  fputs($referer,"// http://www.php-homepage.de\n");
39  fputs($referer,"// referer.php3\n");
40  fputs($referer,"// Autor: Mark Kronsbein\n");
41  fputs($referer,"// Lizenz: GPL\n");
42  fputs($referer,"// Diesen Credit bitte NICHT löschen!\n");
43  fputs($referer,"// Sollten Sie dieses Script benutzen schicken Sie bitte\n");
44  fputs($referer,"// eine Mail an mk ! Danke\n");
45  fputs($referer,"// \n");
46  fputs($referer,"// Installation:\n");
47  fputs($referer,"// include(\"referrer_include.php\");\n");
48  fputs($referer,"//////////////////////////////////////////////////\n");
49  fputs($referer,"\n");
50  fputs($referer,"require('dbinclude.php');\n");
51  fputs($referer,"\$userstable = \"referer\";\n");
52  fputs($referer,"\$domain = \"yourdomain.com\";\n");
53  fputs($referer,"\n");
54  fputs($referer,"\$ref = \"\$HTTP_REFERER\";\n");
55  fputs($referer,"if (!empty (\$ref)){\n");
56  fputs($referer,"\$ref2= strtolower(\$ref);\n");
57  fputs($referer,"\$check=strstr(\$ref2,\"\$domain\");\n");
58  fputs($referer,"}\n");
59  fputs($referer,"\n");
60  fputs($referer,"if(!empty(\$check)){\n");
61  fputs($referer,"}\n");
62  fputs($referer,"\n");
63  fputs($referer,"elseif (empty(\$check)){\n");
64  //fputs($referer,"mysql_connect(\$hostname, \$username, \$password) or die(mysql_error());\n");
65  //fputs($referer,"mysql_select_db(\"\$dbName\") or die(mysql_error());\n");
66  fputs($referer,"\$query = \"select * from \$userstable where url = '\$ref'\";\n");
67  fputs($referer,"\$result = mysql_query(\$query);\n");
68  fputs($referer,"\$rows = mysql_num_rows(\$result);\n");
69  fputs($referer,"\n");
70  fputs($referer,"if (mysql_num_rows(\$result) == 0){\n");
71  fputs($referer," \$hits = \"1\";\n");
72  fputs($referer," \$query1 = \"insert into \$userstable (url,hits)
73  values('\$ref','\$hits')\";\n");
74  fputs($referer,"mysql_query(\$query1);\n");
75  fputs($referer,"}\n");
76  fputs($referer,"\n");
77  fputs($referer,"else {\n");
78  fputs($referer," \$hitquery = \"select hits from \$userstable where url =
79  '\$ref'\";\n");
80  fputs($referer," \$result2 = mysql_query(\$hitquery);\n");
81  fputs($referer," \$row = mysql_fetch_array(\$result2);\n");
82  fputs($referer,"\n");
83  fputs($referer," \$hits =\$row[\"hits\"];\n");
84  fputs($referer," \$query2 = \"update \$userstable set hits = hits+1 where url =
85  '\$ref'\";\n");
86  fputs($referer,"mysql_query(\$query2);\n");
87  fputs($referer,"}\n");
88  fputs($referer,"}\n");
89  fputs($referer,"\n");
90  fputs($referer,"\n");
91  fputs($referer," ?>\n");
92  fputs($referer,"\n");
93  fclose($referer);
94 
95  ?>