Changeset 3105

Timestamp:

03/22/12 09:52:06 (11 years ago)

Author:

bruno

Message:

[Grumph 1.2] Fixed sql requests

Location:

plugins/grumph

Files:

• _define.php (modified) (1 diff)
• class.grumph.php (modified) (2 diffs)

plugins/grumph/_define.php

@@ -18 +18 @@
      /* Description*/         "Grab Resources and Urls to Manage Posts Handily",
      /* Author */             "Bruno Hondelatte",
-     /* Version */            "1.1",
+     /* Version */            "1.2",
      /* Permissions */        'usage,contentadmin'
 );

plugins/grumph/class.grumph.php

@@ -93 +93 @@
           $res = $this->grabResources($rs);
           $strReq = 'UPDATE '.$this->core->prefix.'post '.
-               "SET post_res='".serialize($res)."' ".
+               "SET post_res='".$this->core->con->escape(serialize($res))."' ".
                "WHERE post_id=".$rs->post_id." ";
           return $this->core->con->execute($strReq);   
@@ -103 +103 @@
           } else {
                $strReq = 'SELECT post_res FROM '.$this->core->prefix.'post '.
-                    'WHERE post_id='.$post->post_id;
+                    'WHERE post_id='.((integer)$post->post_id);
                $res = @unserialize($this->core->con->select($strReq)->f(0));         
           }