Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div style="clear:both;"></div>
- <h1>Willkommen auf Grufix.de</h1>
- <p>Mit dem neuen Grufix.de könnt ihr viel anstellen. Ihr könnt eure ganzen Screenshots von
- euren Designs posten und sie verwalten und anschliessend auch noch zum Forum hoch-
- laden wenn du Lust darauf hast. Ausserdem kannst du auch andere Designs kommentieren.
- Das ist doch was tolles oder? Was sagst du dazu?</p>
- <br>
- <?php
- echo anchor( 'feedback' , 'Gib uns Feedback!' );
- ?>
- <hr style="margin-top: 40px; margin-bottom: 30px;" />
- <?php
- $sql = "SELECT * FROM images ORDER BY likes DESC LIMIT 10";
- $query = $this->db->query($sql);
- foreach( $query->result() as $row )
- {
- echo "<div class='imgWrapper'>";
- echo "<img src='" . $row->source . "' alt='" . $row->name . "' width='240px;' /><br />";
- $imageid = mysql_real_escape_string($row->image_id);
- $memberid = mysql_real_escape_string($row->user_id);
- $sql_member = "SELECT * FROM member WHERE `member_id`=" . $memberid . " LIMIT 1";
- $query_member = $this->db->query($sql_member);
- $row_member = $query_member->row();
- echo "<div class='imgHover'>
- <a href='graphs/" . $imageid . "' class='link'></a>
- <font style='font-weight: bold; margin-top: 5px; display: inline-block;'>" . $row->name . "</font>
- <br />
- <span class='author'>by " . anchor( "user/view/" . $row->user_id , $row_member->name . " " . $row_member->surname ) . "</span><br />
- <span class='author'>am " . $row->date . "
- </div>";
- echo "</div>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement