PHP Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /home/ftp/u/umxopinm/wwwroot/wp-includes/wp-db.php on line 2033 WordPress数据库查询SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (805) ORDER BY t.name ASC 时发生Got error 28 from storage engine错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/shapely/page-templates/full-width.php'), get_header, locate_template, load_template, require_once('/themes/shapely/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, adjacent_posts_rel_link_wp_head, adjacent_posts_rel_link, get_adjacent_post_rel_link, get_permalink, get_the_category, get_the_terms, wp_get_object_terms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms查询的 PHP Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /home/ftp/u/umxopinm/wwwroot/wp-includes/wp-db.php on line 2033 WordPress数据库查询SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (815) ORDER BY t.name ASC 时发生Got error 28 from storage engine错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/shapely/page-templates/full-width.php'), get_header, locate_template, load_template, require_once('/themes/shapely/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, adjacent_posts_rel_link_wp_head, adjacent_posts_rel_link, get_adjacent_post_rel_link, get_permalink, get_the_category, get_the_terms, wp_get_object_terms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms查询的

Codes

Codes

Average Face Model

Python Codes:

import os
import cv2
import numpy as np
import math
import sys

def readPoints(path):
    
    pointsArray = [] # Create an array of array of points
    for filePath in os.listdir(path):
        if filePath.endswith(".txt"):
            points = [] #Create an array of points.       
            with open(os.path.join(path, filePath)) as file:
                for line in file :
                    x, y = line.split()
                    points.append((int(x), int(y))) # Store array of points
            pointsArray.append(points)
    return pointsArray
 
# Read all jpg images in folder
def readImages(path):  
    imagesArray = [] #Create array of array of images
    for filePath in os.listdir(path):
        if filePath.endswith(".jpg"):
            img = cv2.imread(os.path.join(path,filePath))
            img = np.float32(img)/255.0 # Convert to floating point
            imagesArray.append(img) # Add to array of images
    return imagesArray
 
def similarityTransform(inPoints, outPoints):
    s60 = math.sin(60*math.pi/180)
    c60 = math.cos(60*math.pi/180)  
    inPts = np.copy(inPoints).tolist()
    outPts = np.copy(outPoints).tolist()
    xin = c60*(inPts[0][0] - inPts[1][0]) - s60*(inPts[0][1] - inPts[1][1]) + inPts[1][0];
    yin = s60*(inPts[0][0] - inPts[1][0]) + c60*(inPts[0][1] - inPts[1][1]) + inPts[1][1];
    inPts.append([np.int(xin), np.int(yin)])
    xout = c60*(outPts[0][0] - outPts[1][0]) - s60*(outPts[0][1] - outPts[1][1]) + outPts[1][0]
    yout = s60*(outPts[0][0] - outPts[1][0]) + c60*(outPts[0][1] - outPts[1][1]) + outPts[1][1]
    outPts.append([np.int(xout), np.int(yout)]
    tform = cv2.estimateRigidTransform(np.array([inPts]), np.array([outPts]), False)
    return tform

def rectContains(rect, point): # Check if a point is inside a rectangle
    if point[0] < rect[0]:
        return False
    elif point[1] < rect[1]:
        return False
    elif point[0] > rect[2]:
        return False
    elif point[1] > rect[3]:
        return False
    return True
 
def calculateDelaunayTriangles(rect, points): # Calculate delanauy triangle
    subdiv = cv2.Subdiv2D(rect) # Create subdiv
    for p in points: # Insert points into subdiv
        subdiv.insert((p[0], p[1]))
    triangleList = subdiv.getTriangleList()
    # List of triangles; each triangle is a list of 3 points (6 numbers)
    delaunayTri = []
    for t in triangleList: # Find the indices of triangles in the points array
        pt = []
        pt.append((t[0], t[1]))
        pt.append((t[2], t[3]))
        pt.append((t[4], t[5]))
        pt1 = (t[0], t[1])
        pt2 = (t[2], t[3])
        pt3 = (t[4], t[5])        
        if rectContains(rect, pt1) and rectContains(rect, pt2) and rectContains(rect, pt3):
            ind = []
            for j in xrange(0, 3):
                for k in xrange(0, len(points)):                    
                    if(abs(pt[j][0] - points[k][0]) < 1.0 and abs(pt[j][1] - points[k][1]) < 1.0):
                        ind.append(k)                            
            if len(ind) == 3:                                                
                delaunayTri.append((ind[0], ind[1], ind[2]))
    return delaunayTri
 
def constrainPoint(p, w, h) :
    p =  (min(max( p[0], 0 ) , w - 1) , min(max(p[1], 0) , h - 1))
    return p

# Apply affine transform calculated using srcTri and dstTri to src and output an image of size
def applyAffineTransform(src, srcTri, dstTri, size):
    # Given a pair of triangles, find the affine transform
    warpMat = cv2.getAffineTransform(np.float32(srcTri), np.float32(dstTri))
    # Apply the Affine Transform just found to the src image
    dst = cv2.warpAffine(src, warpMat, (size[0], size[1]), None, flags=cv2.INTER_LINEAR, borderMode=cv2.BORDER_REFLECT_101)
    return dst

# Warps and alpha blends triangular regions from img1 and img2 to img
def warpTriangle(img1, img2, t1, t2):
    # Find bounding rectangle for each triangle
    r1 = cv2.boundingRect(np.float32([t1]))
    r2 = cv2.boundingRect(np.float32([t2]))
    # Offset points by left top corner of the respective rectangles
    t1Rect = [] 
    t2Rect = []
    t2RectInt = []
    for i in xrange(0, 3):
        t1Rect.append(((t1[i][0] - r1[0]),(t1[i][1] - r1[1])))
        t2Rect.append(((t2[i][0] - r2[0]),(t2[i][1] - r2[1])))
        t2RectInt.append(((t2[i][0] - r2[0]),(t2[i][1] - r2[1])))
    mask = np.zeros((r2[3], r2[2], 3), dtype = np.float32) # Get mask by filling triangle
    cv2.fillConvexPoly(mask, np.int32(t2RectInt), (1.0, 1.0, 1.0), 16, 0)
    # Apply warpImage to small rectangular patches
    img1Rect = img1[r1[1]:r1[1] + r1[3], r1[0]:r1[0] + r1[2]]
    size = (r2[2], r2[3])
    img2Rect = applyAffineTransform(img1Rect, t1Rect, t2Rect, size)
    img2Rect = img2Rect * mask
    # Copy triangular region of the rectangular patch to the output image
    img2[r2[1]:r2[1]+r2[3], r2[0]:r2[0]+r2[2]] = img2[r2[1]:r2[1]+r2[3], r2[0]:r2[0]+r2[2]] * ((1.0, 1.0, 1.0) - mask)
    img2[r2[1]:r2[1]+r2[3], r2[0]:r2[0]+r2[2]] = img2[r2[1]:r2[1]+r2[3], r2[0]:r2[0]+r2[2]] + img2Rect

if __name__ == '__main__':
    path = 'presidents/'
    # Dimensions of output image
    w = 600
    h = 600
    # Read points for all images
    allPoints = readPoints(path)
    # Read all images
    images = readImages(path)
    # Eye corners
    eyecornerDst = [(np.int(0.3 * w ), np.int(h / 3)), (np.int(0.7 * w ), np.int(h / 3))]
    imagesNorm = []
    pointsNorm = []
    # Add boundary points for delaunay triangulation
    boundaryPts = np.array([(0,0), (w/2,0), (w-1,0), (w-1,h/2), ( w-1, h-1 ), ( w/2, h-1 ), (0, h-1), (0,h/2) ])
    # Initialize location of average points to 0s
    pointsAvg = np.array([(0,0)]* ( len(allPoints[0]) + len(boundaryPts) ), np.float32())
    n = len(allPoints[0])
    numImages = len(images)
    # warp images and trasnform landmarks to output coordinate system, and find average of transformed landmarks
    for i in xrange(0, numImages):
        points1 = allPoints[i]
        # Corners of the eye in input image
        eyecornerSrc  = [allPoints[i][36], allPoints[i][45]]
        # Compute similarity transform
        tform = similarityTransform(eyecornerSrc, eyecornerDst)        
        # Apply similarity transformation
        img = cv2.warpAffine(images[i], tform, (w,h))
        # Apply similarity transform on points
        points2 = np.reshape(np.array(points1), (68,1,2))
        points = cv2.transform(points2, tform)
        points = np.float32(np.reshape(points, (68, 2)))
        # Append boundary points. Will be used in Delaunay Triangulation
        points = np.append(points, boundaryPts, axis=0)
        # Calculate location of average landmark points.
        pointsAvg = pointsAvg + points / numImages
        pointsNorm.append(points)
        imagesNorm.append(img)
    # Delaunay triangulation
    rect = (0, 0, w, h);
    dt = calculateDelaunayTriangles(rect, np.array(pointsAvg))
    # Output image
    output = np.zeros((h,w,3), np.float32())
    # Warp input images to average image landmarks
    for i in xrange(0, len(imagesNorm)):
        img = np.zeros((h,w,3), np.float32());
        # Transform triangles one by one
        for j in xrange(0, len(dt)):
            tin = [] 
            tout = []
            for k in xrange(0, 3):                
                pIn = pointsNorm[i][dt[j][k]]
                pIn = constrainPoint(pIn, w, h)
                pOut = pointsAvg[dt[j][k]]
                pOut = constrainPoint(pOut, w, h)
                tin.append(pIn)
                tout.append(pOut)
            warpTriangle(imagesNorm[i], img, tin, tout)
        output = output + img # Add image intensities for averaging
    output = output / numImages # Divide by numImages to get average
    cv2.imshow('image', output) # Display result
    cv2.waitKey(0);
PHP Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /home/ftp/u/umxopinm/wwwroot/wp-includes/wp-db.php on line 2033 WordPress数据库查询SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (801, 819, 825) ORDER BY t.name ASC 时发生Got error 28 from storage engine错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/shapely/page-templates/full-width.php'), get_template_part, locate_template, load_template, require('/themes/shapely/template-parts/content.php'), do_action('shapely_single_after_article'), WP_Hook->do_action, WP_Hook->apply_filters, Shapely_Related_Posts->output_related_posts, Shapely_Related_Posts->get_related_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, _prime_post_caches, update_post_caches, update_object_term_cache, wp_get_object_terms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms查询的 PHP Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /home/ftp/u/umxopinm/wwwroot/wp-includes/wp-db.php on line 2033 WordPress数据库查询SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (815, 805) ORDER BY t.name ASC 时发生Got error 28 from storage engine错误,这是由require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/shapely/page-templates/full-width.php'), get_template_part, locate_template, load_template, require('/themes/shapely/template-parts/content.php'), do_action('shapely_single_after_article'), WP_Hook->do_action, WP_Hook->apply_filters, Shapely_Related_Posts->output_related_posts, Shapely_Related_Posts->get_related_posts, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms查询的
Kathleen Li

发表评论

电子邮件地址不会被公开。 必填项已用*标注