Chatter of the day

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Chatter of the day

    Hello to everyone, why do not you see the photo and profile of users?
    PHP Code:
    echo "<small>Random Gallery Pics</small><br/>";
    $sql=mysql_fetch_array(mysql_query("SELECT uid, itemurl FROM ibwf_users  ORDER BY RAND() LIMIT 1"));
    $nick getnick_uid($sql[0]);
    echo 
    "<small><img src=\"$sql[1]\" width=\"100\" height=\"100\" alt=\"$sql[0]\"/><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$nick</a></small><br/><br/><br/>"

    #2
    what does right click copy image address say?

    probably:
    $sql=mysql_fetch_array(mysql_query("SELECT uid, itemurl FROM ibwf_users ORDER BY RAND() LIMIT 1"));

    is wrong

    sure its not avatar instead of itemurl ?

    Comment


      #3
      and what is the right function so that you can see the photo and profile of users?

      Comment


        #4
        I dont know what your sql is but most peoples sites its:

        $sql=mysql_fetch_array(mysql_query("SELECT uid, avatar FROM ibwf_users ORDER BY RAND() LIMIT 1"));

        but you have also put its a random gallery pic and that sql is from ibwf_users not gallery?

        Comment


          #5
          is Lavalair! All photos in the folder pics_original, but there are also other photos that do not centered with the profile. If the address is in the folder pics_original you see all the photos, but I wish you could see only the profile photos of users who have..

          Comment


            #6
            it should be ok as u had it above just replace the line i put above

            Comment


              #7
              not understand, what do I do??

              Comment


                #8
                Code:
                echo "<small>Random Gallery Pics</small><br/>";
                $sql=mysql_fetch_array(mysql_query("SELECT uid, avatar FROM ibwf_users ORDER BY RAND() LIMIT 1"));
                $nick = getnick_uid($sql[0]);
                echo "<small><img src=\"$sql[1]\" width=\"100\" height=\"100\" alt=\"$sql[0]\"/><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$nick</a></small><br/><br/><br/>";

                Comment


                  #9
                  I did copy paste, but the picture is loaded, you can not see: (

                  Comment


                    #10
                    Small error:
                    Code:
                    echo "<small>Random Gallery Pics</small><br/>";
                    $sql=mysql_fetch_array(mysql_query("SELECT id, avatar FROM ibwf_users ORDER BY RAND() LIMIT 1"));
                    $nick = getnick_uid($sql[0]);
                    echo "<small><img src=\"$sql[1]\" width=\"100\" height=\"100\" alt=\"$sql[0]\"/><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$nick</a></small><br/><br/><br/>";

                    Comment


                      #11
                      lol thanks you see. Now when you click the nick says you are not logged in or your session has expired! you should see the profile..

                      Comment


                        #12
                        Sorry, the pictures change every page load. How do you change them every 24 hours?

                        Comment


                          #13
                          you need extra sql for that maybe put it in ibwf_settings :P

                          Comment


                            #14
                            and give me extra sql, please???? and how it fits in ibwf_settings?? :p

                            Comment


                              #15
                              i think youre using old lava gallery script that dont use sql...

                              Comment

                              Working...
                              X