View Single Post
  #4  
Old 11 Mar 2016, 03:53
Dr.CustUmz's Avatar
Dr.CustUmz Dr.CustUmz is offline
 
Join Date: Aug 2013
Real name: Ryan
Originally Posted by Paul M View Post
The original code will throw a database error, you just wont see it because its being run as a shutdown query.

You final code is fine, but you dont actually need the LIMIT 1.
without the limit 1 it erases every entry of that that thread id

thread views table looks like

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

if i remove limit 1 and view thread 8, all of its instances get removed and when the cron runs to update thread view its not accurate.


update****

the problem with the method im using

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

is if there is no row with that threadID in the threadviews table it adds the original view to the table.

Attached Images
File Type: jpg 2016-03-10_23-17-49.jpg (52.4 KB, 30 views)
__________________
If you need custom work done please use Dirt RIF CustUmz
Owner of vBTeam
vBulletin 3.8.14 DRC Edition PHP 7.4 Compatible- NOT a null, NOT complete files Requires a legit copy of vBulletin 3.8.11.

Last edited by Dr.CustUmz; 11 Mar 2016 at 04:20.
Reply With Quote