diff options
| author | redmatrix <git@macgirvin.com> | 2016-05-31 17:50:47 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-05-31 17:50:47 -0700 |
| commit | dfb6255f59980835d364402b372dd39f2b41ee7c (patch) | |
| tree | f8d97437d713311a9cd3cf13e0e8faa5b617fa8f /Zotlabs/Zot | |
| parent | 00b4843425371e4ff55c82be577a279e248c29fc (diff) | |
| download | volse-hubzilla-dfb6255f59980835d364402b372dd39f2b41ee7c.tar.gz volse-hubzilla-dfb6255f59980835d364402b372dd39f2b41ee7c.tar.bz2 volse-hubzilla-dfb6255f59980835d364402b372dd39f2b41ee7c.zip | |
more removal of reserved words from DB schemas
Diffstat (limited to 'Zotlabs/Zot')
| -rw-r--r-- | Zotlabs/Zot/Verify.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Zotlabs/Zot/Verify.php b/Zotlabs/Zot/Verify.php index 1192202db..06bd3188c 100644 --- a/Zotlabs/Zot/Verify.php +++ b/Zotlabs/Zot/Verify.php @@ -6,7 +6,7 @@ namespace Zotlabs\Zot; class Verify { function create($type,$channel_id,$token,$meta) { - return q("insert into verify ( type, channel, token, meta, created ) values ( '%s', %d, '%s', '%s', '%s' )", + return q("insert into verify ( vtype, channel, token, meta, created ) values ( '%s', %d, '%s', '%s', '%s' )", dbesc($type), intval($channel_id), dbesc($token), @@ -16,7 +16,7 @@ class Verify { } function match($type,$channel_id,$token,$meta) { - $r = q("select id from verify where type = '%s' and channel = %d and token = '%s' and meta = '%s' limit 1", + $r = q("select id from verify where vtype = '%s' and channel = %d and token = '%s' and meta = '%s' limit 1", dbesc($type), intval($channel_id), dbesc($token), @@ -32,7 +32,7 @@ class Verify { } function purge($type,$interval) { - q("delete from verify where type = '%s' and created < %s - INTERVAL %s", + q("delete from verify where vtype = '%s' and created < %s - INTERVAL %s", dbesc($type), db_utcnow(), db_quoteinterval($interval) |