Changeset 1019 in ExiteCMS for modules/common/advertising/php-files/modules/advertising/click.php

Timestamp:

10/24/07 23:38:09 (5 years ago)

Author:

hverton

Message:

change of table name

File:

• modules/common/advertising/php-files/modules/advertising/click.php (modified) (1 diff)

modules/common/advertising/php-files/modules/advertising/click.php

@@ -16 +16 @@
 
 // get the requested ad from the database
-$result = dbquery("SELECT * FROM ".$db_prefix."adverts where adverts_id = '".$id."'");
+$result = dbquery("SELECT * FROM ".$db_prefix."advertising where adverts_id = '".$id."'");
 if(dbrows($result)) {
     $row = dbarray($result);
     // update the hit (don't count the clients own hits!)
     if (!isset($userdata['user_id']) || $userdata['user_id'] != $row['adverts_userid']) {
-        dbquery("UPDATE ".$db_prefix."adverts SET adverts_clicks=adverts_clicks+1 where adverts_id='".$id."'");
+        dbquery("UPDATE ".$db_prefix."advertising SET adverts_clicks=adverts_clicks+1 where adverts_id='".$id."'");
     }
 }