Hey,
As you know I am having trouble with this script. Below is the information that I hope you can use to help me resolve this problem/glitch.
<html>
<head>
<title>fixes</title>
<style type="text/css">
.title {
color:white;
background-color:black;
}
.red {
color:white;
background-color:red;
}
.green {
color:white;
background-color:green;
}
</style>
</head>
<body>
<?php
$link = mysql_connect('????????', '????????', '????????'); //replace with your mysql server, user, and password
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('????????'); //replace with your database name
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
$changes[]=array('uploads/cg_hentai/Mamori_Gami_Sama/','uploads/cg_hentai/Mamori_Kamisama/');
// knock yourself out, I used this with 30 changes at once, I have no idea how well it scales beyond that
echo "<table>";
foreach ($changes as $key => $change) {
echo "<tr class=\"title\">";
echo "<td>$key</td>";
echo "<td>{$change[0]}</td>";
echo "<td>{$change[1]}</td>";
echo "</tr>";
$results=mysql_query("SELECT filepath,pid,filename FROM cpg_pictures WHERE filepath LIKE '%/{$change[0]}/%'");
while ($row = mysql_fetch_assoc($results)) {
echo "<tr>";
echo "<td>{$row["pid"]}</td>";
echo "<td>{$row["filepath"]}</td>";
echo "<td>{$row["filename"]}</td>";
echo "</tr>";
// echo "<tr colspan=\"3\">";
$row['filepath']=addslashes(str_replace($change[0],$change[1],$row['filepath']));
$update_sql="UPDATE cpg_pictures SET filepath='{$row['filepath']}' WHERE pid='{$row['pid']}' LIMIT 1";
$update_results=mysql_query($update_sql);
if ($update_results) {
$class="green";
} else {
$class="red";
}
// echo "<td>$update_sql</td>";
// echo "</tr>";
echo "<tr class=\"$class\">";
echo "<td>{$row["pid"]}</td>";
echo "<td>{$row["filepath"]}</td>";
echo "<td>{$row["filename"]}</td>";
echo "</tr>";
}
}
echo "</table>";
?>
</body>
</html>
And here is the html ouput that I get when I run the script.
<html>
<head>
<title>fixes</title>
<style type="text/css">
.title {
color:white;
background-color:black;
}
.red {
color:white;
background-color:red;
}
.green {
color:white;
background-color:green;
}
</style>
</head>
<body>
<table>
<tr class="title"><td>0</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>1</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>2</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>3</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>4</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>5</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>6</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>7</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>8</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>9</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>10</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>11</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>12</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>13</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>14</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>15</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>16</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>17</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>18</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>19</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>20</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>21</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>22</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>23</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>24</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>25</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>26</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>27</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>28</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>29</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>30</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>31</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>32</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>33</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>34</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>35</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>36</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>37</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>38</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
<tr class="title"><td>39</td><td>uploads/cg_hentai/Mamori_Gami_Sama/</td><td>uploads/cg_hentai/Mamori_Kamisama/</td></tr>
</table>
</body>
</html>
As you can see if left out the database username etc. (For security reasons). As I mentioned before I am running version 1.4.2 of Coppermine. And the only code changes that I have made is that "Most Viewed" and "Top Rated" now only show 100 images instead of infinite. Although I seriously doubt that this is the problem. Can you rewrite the code for Coppermine 1.4.2 or higher if nessecary please.
Thanks, Gereph.