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

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X