(2011-03-01, 07:36 AM)raminh Wrote: [ -> ]Where are you?
no one's helping?!!!!
I have felt very ill all week and I'm doing my best, give me a damn break.
Run this one:
UPDATE `mybb_settings` SET `optionscode` = 'php\r\n<select name=\\"upsetting[{$setting[''name'']}]\\">\r\n<option value=\\"-12\\" ".($setting[''value''] == -12?"selected=\\"selected\\"":"").">GMT -12:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -12).")</option>\r\n<option value=\\"-11\\" ".($setting[''value''] == -11?"selected=\\"selected\\"":"").">GMT -11:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -11).")</option>\r\n<option value=\\"-10\\" ".($setting[''value''] == -10?"selected=\\"selected\\"":"").">GMT -10:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -10).")</option>\r\n<option value=\\"-9\\" ".($setting[''value''] == -9?"selected=\\"selected\\"":"").">GMT -9:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -9).")</option>\r\n<option value=\\"-8\\" ".($setting[''value''] == -8?"selected=\\"selected\\"":"").">GMT -8:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -8).")</option>\r\n<option value=\\"-7\\" ".($setting[''value''] == -7?"selected=\\"selected\\"":"").">GMT -7:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -7).")</option>\r\n<option value=\\"-6\\" ".($setting[''value''] == -6?"selected=\\"selected\\"":"").">GMT -6:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -6).")</option>\r\n<option value=\\"-5\\" ".($setting[''value''] == -5?"selected=\\"selected\\"":"").">GMT -5:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -5).")</option>\r\n<option value=\\"-4\\" ".($setting[''value''] == -4?"selected=\\"selected\\"":"").">GMT -4:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -4).")</option>\r\n<option value=\\"-3.5\\" ".($setting[''value''] == -3.5?"selected=\\"selected\\"":"").">GMT -3:30 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -3.5).")</option>\r\n<option value=\\"-3\\" ".($setting[''value''] == -3?"selected=\\"selected\\"":"").">GMT -3:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -3).")</option>\r\n<option value=\\"-2\\" ".($setting[''value''] == -2?"selected=\\"selected\\"":"").">GMT -2:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -2).")</option>\r\n<option value=\\"-1\\" ".($setting[''value''] == -1?"selected=\\"selected\\"":"").">GMT -1:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, -1).")</option>\r\n<option value=\\"0\\" ".($setting[''value''] == 0?"selected=\\"selected\\"":"").">GMT (".my_date($mybb->settings[''timeformat''], TIME_NOW, 0).")</option>\r\n<option value=\\"+1\\" ".($setting[''value''] == 1?"selected=\\"selected\\"":"").">GMT +1:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 1).")</option>\r\n<option value=\\"+1.5\\" ".($setting[''value''] == 1.5?"selected=\\"selected\\"":"").">GMT +1:30 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 1.5).")</option>\r\n<option value=\\"+2\\" ".($setting[''value''] == 2?"selected=\\"selected\\"":"").">GMT +2:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 2).")</option>\r\n<option value=\\"+3\\" ".($setting[''value''] == 3?"selected=\\"selected\\"":"").">GMT +3:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 3).")</option>\r\n<option value=\\"+3.5\\" ".($setting[''value''] == 3.5?"selected=\\"selected\\"":"").">GMT +3:30 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 3.5).")</option>\r\n<option value=\\"+4\\" ".($setting[''value''] == 4?"selected=\\"selected\\"":"").">GMT +4:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 4).")</option>\r\n<option value=\\"+4.5\\" ".($setting[''value''] == 4.5?"selected=\\"selected\\"":"").">GMT +4:30 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 4.5).")</option>\r\n<option value=\\"+5\\" ".($setting[''value''] == 5?"selected=\\"selected\\"":"").">GMT +5:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 5).")</option>\r\n<option value=\\"+5.5\\" ".($setting[''value''] == 5.5?"selected=\\"selected\\"":"").">GMT +5:30 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 5.5).")</option>\r\n<option value=\\"+5.75\\" ".($setting[''value''] == 5.75?"selected=\\"selected\\"":"").">GMT +5:45 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 5.75).")</option>\r\n<option value=\\"+6\\" ".($setting[''value''] == 9?"selected=\\"selected\\"":"").">GMT +6:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 6).")</option>\r\n<option value=\\"+7\\" ".($setting[''value''] == 7?"selected=\\"selected\\"":"").">GMT +7:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 7).")</option>\r\n<option value=\\"+8\\" ".($setting[''value''] == 8?"selected=\\"selected\\"":"").">GMT +8:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 8).")</option>\r\n<option value=\\"+9\\" ".($setting[''value''] == 9?"selected=\\"selected\\"":"").">GMT +9:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 9).")</option>\r\n<option value=\\"+9.5\\" ".($setting[''value''] == 9.5?"selected=\\"selected\\"":"").">GMT +9:30 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 9.5).")</option>\r\n<option value=\\"+10\\" ".($setting[''value''] == 10?"selected=\\"selected\\"":"").">GMT +10:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 10).")</option>\r\n<option value=\\"+10.5\\" ".($setting[''value''] == 10.5?"selected=\\"selected\\"":"").">GMT +10:30 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 10.5).")</option>\r\n<option value=\\"+11\\" ".($setting[''value''] == 11?"selected=\\"selected\\"":"").">GMT +11:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 11).")</option>\r\n<option value=\\"+12\\" ".($setting[''value''] == 12?"selected=\\"selected\\"":"").">GMT +12:00 Hours (".my_date($mybb->settings[''timeformat''], TIME_NOW, 12).")</option>\r\n</select>' WHERE `name` = 'timezoneoffset';