index.php 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149
  1. <?php
  2. session_start();
  3. $http_host = $_SERVER["HTTP_HOST"];
  4. $doc_root = $_SERVER["DOCUMENT_ROOT"];
  5. include $doc_root . "functions.php";
  6. $proto = get_protocol();
  7. $con = start_db();
  8. $server = $proto . $http_host;
  9. $lang = select_language();
  10. $lserver = $server . "/" . $lang;
  11. $cur_section = "";
  12. $cur_entry = "";
  13. ?>
  14. <!DOCTYPE html>
  15. <html>
  16. <head>
  17. <meta content='text/html; charset=utf-8' http-equiv='content-type'/>
  18. <meta charset='utf-8'/>
  19. <meta name='viewport' content='width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1'/>
  20. <title>I&ntilde;igo Valentin</title>
  21. <link rel='shortcut icon' href='<?=$lserver?>/img/logo/x2/favicon.ico'/>
  22. <!-- CSS files -->
  23. <style>
  24. <?php
  25. include $doc_root . "css/ui.css";
  26. include $doc_root . "css/home.css";
  27. ?>
  28. </style>
  29. <!-- CSS for mobile version -->
  30. <style media='(max-width : 990px)'>
  31. <?php
  32. include $doc_root . "css/m/ui.css";
  33. include $doc_root . "css/m/home.css";
  34. ?>
  35. </style>
  36. <!-- Script files -->
  37. <script type='text/javascript'>
  38. <?php
  39. include $doc_root . "script/ui.js";
  40. ?>
  41. </script>
  42. <!-- Meta tags -->
  43. <link rel='canonical' href='<?=$lserver?>'/>
  44. <link rel='author' href='<?=$lserver?>'/>
  45. <link rel='publisher' href='<?=$lserver?>'/>
  46. <meta name='description' content=''/>
  47. <meta property='og:title' content='I&ntilde;igo Valentin'/>
  48. <meta property='og:url' content='<?=$lserver?>'/>
  49. <meta property='og:description' content=''/>
  50. <meta property='og:image' content='<?=$lserver?>/img/logo/x3/favicon.ico''/>
  51. <meta property='og:site_name' content='I&ntilde;igo Valentin'/>
  52. <meta property='og:type' content='website'/>
  53. <meta property='og:locale' content='<?=$lang?>'/>
  54. <meta name='twitter:card' content='summary'/>
  55. <meta name='twitter:title' content='I&ntilde;igo Valentin'/>
  56. <meta name='twitter:description' content=''/>
  57. <meta name='twitter:image' content='<?=$lserver?>/img/logo/x3/favicon.ico''/>
  58. <meta name='twitter:url' content='<?=$lserver?>'/>
  59. <meta name='robots' content='index follow'/>
  60. </head>
  61. <body>
  62. <div id='logo'>
  63. <img id='logo' src='<?=$lserver?>/img/logo/x6/inigovalentin.png' alt='I&ntilde;igo Valentin'/>
  64. </div>
  65. <?php
  66. include $doc_root . "header.php";
  67. ?>
  68. <div id='content'>
  69. <div id='content_row'>
  70. <div class='content_cell' id='content_cell_profile'>
  71. <div class='section'>
  72. <h3 class='section_title'>I&ntilde;igo Valentin</h3>
  73. <div class='entry'>
  74. <img id='profile' src='<?=$lserver?>/img/profile/x16/preview/0.png' alt='I&ntilde;igo Valentin' title='I&ntilde;igo Valentin' />
  75. </div> <!-- .entry -->
  76. </div> <!-- .section -->
  77. </div> <!-- #content_cell_profile -->
  78. <div class='content_cell' id='content_cell_content'>
  79. <div class='section'>
  80. <h3 class='section_title'>TR#Ultimos proyectos</h3>
  81. <?php
  82. $q_project = mysqli_query($con, "SELECT id, permalink, type, title, logo, header, license, (SELECT dtime FROM project_version WHERE project = p.id AND visible = 1 ORDER BY dtime desc LIMIT 1) AS modified FROM project p WHERE visible = 1 ORDER BY modified DESC LIMIT 3;");
  83. while ($r_project = mysqli_fetch_array($q_project)){
  84. ?>
  85. <a href='<?=$lserver?>/project/<?=$r_project["permalink"]?>'>
  86. <div class='entry project_row'>
  87. <table>
  88. <tr>
  89. <?php
  90. if (strlen($r_project["logo"]) > 0){
  91. ?>
  92. <td>
  93. <img alt='<?=text($con, $r_project["title"], $lang)?>' title='<?=text($con, $r_project["title"], $lang)?>' src='<?=$lserver?>/img/project/x2/<?=$r_project["logo"]?>'/>
  94. </td>
  95. <?php
  96. }
  97. ?>
  98. <td>
  99. <h4><?=text($con, $r_project["title"], $lang)?></h4>
  100. <?=text($con, $r_project["header"], $lang)?>
  101. </td>
  102. </tr>
  103. </table>
  104. </div> <!-- .entry -->
  105. </a>
  106. <?php
  107. }
  108. ?>
  109. <h3 class='section_title'>TR#Ultimos posts</h3>
  110. <?php
  111. $q_blog = mysqli_query($con, "SELECT * FROM post WHERE visible = 1 ORDER BY dtime DESC LIMIT 2;");
  112. while ($r_blog = mysqli_fetch_array($q_blog)){
  113. $q_image = mysqli_query($con, "SELECT * FROM post_image WHERE post = $r_blog[id] ORDER BY id LIMIT 1;");
  114. ?>
  115. <a href='<?=$lserver?>/blog/<?=$r_blog["permalink"]?>'>
  116. <div class='entry blog_row'>
  117. <table>
  118. <tr>
  119. <?php
  120. if (mysqli_num_rows($q_image) > 0){
  121. $r_image = mysqli_fetch_array($q_image);
  122. ?>
  123. <td>
  124. <img alt='<?=text($con, $r_blog["title"], $lang)?>' title='<?=text($con, $r_blog["title"], $lang)?>' src='<?=$lserver?>/img/blog/x2/<?=$r_image["image"]?>'/>
  125. </td>
  126. <?php
  127. }
  128. ?>
  129. <td>
  130. <h4><?=text($con, $r_blog["title"], $lang)?></h4>
  131. <?=cut_text(text($con, $r_project["header"], $lang), 165, "TR#Leer mas", $lserver . "/blog/" . $r_blog["permalink"])?>
  132. </td>
  133. </tr>
  134. </table>
  135. </div> <!-- .entry -->
  136. </a>
  137. <?php
  138. }
  139. ?>
  140. </div> <!-- .section -->
  141. </div> <!-- #content_cell_content -->
  142. </div> <!-- .content_row -->
  143. </div> <!-- #content -->
  144. <?php
  145. include $doc_root . "footer.php";
  146. stats($con, $cur_section, $cur_entry);
  147. ?>
  148. </body>
  149. </html>