Thread: MySQL error...
View Single Post
Old April 19th, 2005, 08:33 PM   #6 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,752
Now that makes more sense you never said when deleting a products. Thats a whole separate script

In adm-product.php find this

$ipaddr = findenv("REMOTE_ADDR");
$date = time();
$what = "Deleted product: $filename ($ptitle)";
$what = addslashes($what);
$query = "REPLACE INTO {$Globals['pp_db_prefix']}admlog (adminuser,ip,datestamp,description) VALUES ('{$User['username']}','$ipaddr','$date','$what')";
$resultb = ppmysql_query($query,$link);

change to this

$username = addslashes($User['username']);
$ipaddr = findenv("REMOTE_ADDR");
$date = time();
$what = "Deleted product: $filename ($ptitle)";
$what = addslashes($what);
$query = "REPLACE INTO {$Globals['pp_db_prefix']}admlog (adminuser,ip,datestamp,description) VALUES ('$username','$ipaddr','$date','$what')";
$resultb = ppmysql_query($query,$link);
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.

Last edited by Chuck S; April 20th, 2005 at 09:06 PM.
Chuck S is offline   Reply With Quote