echo get_the_author_meta('display_name'); ?> " width="80" height="80" class="photo" /> </a> </figure> <div id="autor_<?php the_ID(); ?> "> <h2><?php the_author_posts_link(); ?> </h2> <?php author_info(); ?> <p><?php the_author_meta('description'); ?> </p> </div> </div> <?php dreams_related_posts(); ?> </footer> <?php // end article footer
function DeltaImport($mysql_db, $date) { $mysql_db->query("CREATE TABLE myrulib_update(date integer primary key, aid integer, bid integer, sid integer, zid integer)"); $sqltest = "SELECT * FROM myrulib_update WHERE date=(SELECT MAX(date) FROM myrulib_update WHERE date<{$date})"; $query = $mysql_db->query($sqltest); if ($row = $query->fetch_array()) { $code = $row["date"]; $sqlite_db = new PDO("sqlite:./{$code}.upd"); create_tables($sqlite_db, $date); setup_params($sqlite_db, $date, "DELTA"); convert_authors($mysql_db, $sqlite_db, $row['aid']); convert_seqnames($mysql_db, $sqlite_db, $row['sid']); convert_books($mysql_db, $sqlite_db, $row['bid']); convert_sequences($mysql_db, $sqlite_db, $row['bid']); convert_genres($mysql_db, $sqlite_db, $row['bid']); convert_dates($mysql_db, $sqlite_db, $row['bid']); convert_zips($mysql_db, $sqlite_db, $row['zid']); convert_files($mysql_db, $sqlite_db, $row['zid'], $row['bid']); author_info($mysql_db, $sqlite_db, $row['aid']); book_info($mysql_db, $sqlite_db, $row['bid']); system("zip {$code}.zip {$code}.upd"); } $mysql_db->query("INSERT INTO myrulib_update(date) VALUES(" . $date . ")"); $mysql_db->query("\n\tUPDATE myrulib_update SET \n\t aid=(SELECT MAX(AvtorId) FROM libavtorname),\n\t bid=(SELECT MAX(BookId) FROM libbook),\n\t sid=(SELECT MAX(SeqId) FROM libseq),\n\t zid=(SELECT MAX(zid) FROM myrulib_zip)\n\tWHERE date={$date}"); }