<?php require_once dirname(__FILE__) . '/../../plugins/UsefulFunctions/bootstrap.console.php'; $Argument = GetValue(1, $argv); $SQL = Gdn::SQL(); $MaxUserID = $SQL->Select('UserID', 'max', 'MaxUserID')->From('User')->Get()->FirstRow()->MaxUserID; if ($Argument == 'structure') { $ThankfulPeoplePlugin = new ThankfulPeoplePlugin(); $Drop = Console::Argument('drop') !== False; $ThankfulPeoplePlugin->Structure($Drop); } elseif ($Argument == 'calc') { ThanksLogModel::RecalculateUserReceivedThankCount(); //ThanksLogModel::RecalculateCommentThankCount(); //ThanksLogModel::RecalculateDiscussionThankCount(); } elseif ($Argument == 'garbage') { $Limit = Console::Argument('limit'); if (!$Limit) { $Limit = 10; } $CommentDataSet = $SQL->Select('CommentID, DiscussionID, InsertUserID')->From('Comment')->OrderBy('DateInserted', 'desc')->Limit($Limit)->Get(); $Loop = Console::Argument('loop'); if (!is_numeric($Loop) || $Loop <= 0) { $Loop = 1; } for ($i = 0; $i < $Loop; $i++) { foreach ($CommentDataSet as $Comment) { $InsertUserID = mt_rand(1, $MaxUserID); $Fields = array('CommentID' => $Comment->CommentID); $Fields['UserID'] = $Comment->InsertUserID; $Fields['InsertUserID'] = $InsertUserID; $Fields['DateInserted'] = Gdn_Format::ToDateTime();
public function Structure() { /* Gdn::Structure() ->Table('Comment') ->Column('ThankCount', 'usmallint', 0) ->Set(); Gdn::Structure() ->Table('Discussion') ->Column('ThankCount', 'usmallint', 0) ->Set();*/ Gdn::Structure()->Table('User')->Column('ReceivedThankCount', 'usmallint', 0)->Set(); Gdn::Structure()->Table('ThanksLog')->Column('UserID', 'umediumint', False, 'key')->Column('CommentID', 'umediumint', 0)->Column('DiscussionID', 'umediumint', 0)->Column('DateInserted', 'datetime')->Column('InsertUserID', 'umediumint', False, 'key')->Engine('MyISAM')->Set(); $RequestArgs = Gdn::Controller()->RequestArgs; if (ArrayHasValue($RequestArgs, 'vanilla')) { ThanksLogModel::RecalculateUserReceivedThankCount(); } //ThanksLogModel::RecalculateCommentThankCount(); //ThanksLogModel::RecalculateDiscussionThankCount(); }