Picture does not change

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

    Picture does not change

    Hello friends, the image after 24 hours should change but not change, remains the same, why?
    PHP Code:
    $pod mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='pod'")); 
      echo 
    "<p align=\"center\"><b><u><i>Chatter of the Day:</i></u></b><br/>"
    $sql=mysql_fetch_array(mysql_query("SELECT id, avatar FROM ibwf_users WHERE id='".$pod[0]."'")); 
    $nick getnick_uid($sql[0]); 
      echo 
    "<p align=\"center\"><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$nick</a></small>";  
      echo 
    "<p align=\"center\"><small><img src=\"$sql[1]\" width=\"100\" height=\"100\" alt=\"$sql[0]\"/><br/>"

    #2
    sql
    PHP Code:
    INSERT INTO `ibwf_settings` ( `id` , `name` , `value` )
    VALUES (
    NULL 'doc''1'
    ); 
    script:
    PHP Code:
    $check mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='doc'"));
    $date "".date("d")."";
    if(
    $check[0]!=$date){
    $user mysql_fetch_array(mysql_query("SELECT id FROM ibwf_users ORDER BY RAND()  LIMIT 1"));
    mysql_query("UPDATE ibwf_settings SET value='".$date."' WHERE name='doc'");
    mysql_query("UPDATE ibwf_settings SET value='".$user[0]."' WHERE name='pod'");

    Comment


      #3
      I removed the code, and replace all the code with the copy paste, modify SQL, but do not see anything

      Comment


        #4
        that code has to be run somewhere like top of index.php
        sql can be posted straight into db

        Comment


          #5
          then .. Let's see if I understand correctly. the code that you gave me a few days ago, I have to replace, but I must add this new code somewhere in the index.php file, I understand you correctly?

          Comment


            #6
            no dont replace the old code just add the new code on your index.php (somewhere at the top probably best)
            and just run the sql in db
            then if current date isnt equal date in database it updates uid for gallery and updates the date

            Comment


              #7
              I understand! and this code here
              PHP Code:
              INSERT INTO `ibwf_settings` ( `id` , `name` , `value` )
              VALUES (
              NULL 'doc''1'
              ); 
              , I have to add another row in the database folder ibwf_settings or should I add it along with the other code in the page index.php?

              Comment


                #8
                Originally posted by Leviathan73 View Post
                I understand! and this code here
                PHP Code:
                INSERT INTO `ibwf_settings` ( `id` , `name` , `value` )
                VALUES (
                NULL 'doc''1'
                ); 
                , I have to add another row in the database folder ibwf_settings or should I add it along with the other code in the page index.php?
                that is the new row in db all u have to do is run sql
                or do it the other way and add doc and 1 into ibwf_settings

                Comment


                  #9
                  something, lol, thanks finally changed image :p
                  Another question .. to make username emphasized how?
                  PHP Code:
                  echo "<p align=\"center\"><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\"><u>$nick</u></a></small>"
                  I tried so, but remains the same

                  Comment


                    #10
                    get rid of the small tags i guess

                    Comment


                      #11
                      lol or <big>text</big> or <b>text</b> or h1
                      Want something coded email me at sales@webnwaphost.com for a prices.




                      Comment


                        #12
                        I tried them, enlarge the text. I wanted the nick emphasized, such as nick nick above and below the line
                        leviathan73
                        _________

                        Comment


                          #13
                          how u want it emphasized?
                          Want something coded email me at sales@webnwaphost.com for a prices.




                          Comment


                            #14
                            yes ---> $nick

                            Comment

                            Working...
                            X