Announcement

Collapse
No announcement yet.

[Release v2] Let users choose their own date and time format

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

  • #16
    U

    The EMAIL says:

    Database error in vBulletin: Invalid SQL: UPDATE user
    SET styleid='1',adminemail='1',
    showemail='1',invisible='0',cookieuser='1',
    maxposts='-1',daysprune='-1',
    dateformat='9',timeformat='-1',
    startofweek='2',options='15',receivepm='1',
    emailonpm='0',pmpopup='1',usergroupid='6',
    nosessionhash='0'
    WHERE userid='1'
    mysql error: Unknown column 'dateformat' in 'field list'
    mysql error number: 1054
    Date: Tuesday 18th of September 2001 01:00:28 AM
    Script:
    /vbb/member.php?invisible=no&cookieuser=yes&nosessionhash=no&allowmail=yes&showemail=yes&emailn otification=no&receivepm=yes&emailonpm=no&pmpopup=yes&showsignatures=yes&showavatars=yes&s howimages=yes&prunedays=-1&umaxposts=-1&startofweek=2&timezoneoffset=-5&newdateformat=9&newtimeformat=-1&vbcode=yes&newstyleset=1&action=updateoptions&Submit=Submit+Modifications
    Referer:
    http://www.shenlong20xl.com/vbb/memb...on=editoptions

    I cant find that code anywhere

    Comment


    • #17
      Looks like you didn't run the query like I said:
      Code:
      ALTER TABLE user ADD dateformat VARCHAR(4) DEFAULT '-1' not null AFTER timezoneoffset, ADD timeformat VARCHAR(4) DEFAULT '-1' not null AFTER dateformat;
      Run it using phpMyAdmin or Telnet.
      Chen Avinadav
      Better to remain silent and be thought a fool than to speak out and remove all doubt.

      גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

      Comment


      • #18
        Hi FireFly

        This is to say Thank You for doing this hack.

        It works well and has made many of my users very happy.

        This would be a very good hack to have included in the next version of VB

        Thanks Again.
        Mark Thornton

        Comment


        • #19
          Im not a super expert at hacks or anything firefly.

          so can u tell me like what to do more specific (EX: go to folder and then to whatever.php and insert code after bla)

          thanx

          Comment


          • #20
            Originally posted by FireFly

            Code:
            ALTER TABLE user ADD dateformat VARCHAR(4) DEFAULT '-1' not null AFTER timezoneoffset, ADD timeformat VARCHAR(4) DEFAULT '-1' not null AFTER dateformat;
            if you have run this query how can you undo it ????????

            Comment


            • #21
              Soul Lord XL:
              I can't really be more specific.
              Everything is in my first post, add X after/before Y in file Z.php, or add A to the B template.
              What exactly don't you understand?

              ubje:
              Code:
              ALTER TABLE user DROP dateformat, DROP timeformat
              Chen Avinadav
              Better to remain silent and be thought a fool than to speak out and remove all doubt.

              גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

              Comment

              Loading...
              Working...
              X