Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

> [SQL][MySQL][PHP]Zapytanie i błąd
musiek86
post
Post #1





Grupa: Zarejestrowani
Postów: 118
Pomógł: 0
Dołączył: 22.03.2008

Ostrzeżenie: (0%)
-----


Skrypt wypełnia tabele w bazie i mam taki rekord do dodania
  1. $inserts[] = "INSERT INTO efora__{$nazwa}__settings ('sid', 'name', 'title', 'description', 'optionscode', 'value', 'disporder', 'gid', 'isdefault') VALUES
  2. (1, 'enablecalendar', 'Enable Calendar Functionality', 'If you wish to disable the calendar on your board, set this option to no.', 'yesno', '1', 1, 1, 1),
  3. (...)
  4. (13, 'timezoneoffset', 'Default Timezone Offset', 'Here you can set the default timezone offset for guests and members using the default offset.', 'php\n<select name=\\'upsetting[{\$setting[''name'']}]\\'>\n<option value=\\'-12\\' '.($setting[''value''] == -12?'selected=\\'selected\\'':'').'>GMT -12:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -12).')</option>\n<option value=\\'-11\\' '.($setting[''value''] == -11?'selected=\\'selected\\'':'').'>GMT -11:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -11).')</option>\n<option value=\\'-10\\' '.($setting[''value''] == -10?'selected=\\'selected\\'':'').'>GMT -10:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -10).')</option>\n<option value=\\'-9\\' '.($setting[''value''] == -9?'selected=\\'selected\\'':'').'>GMT -9:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -9).')</option>\n<option value=\\'-8\\' '.($setting[''value''] == -8?'selected=\\'selected\\'':'').'>GMT -8:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -8).')</option>\n<option value=\\'-7\\' '.($setting[''value''] == -7?'selected=\\'selected\\'':'').'>GMT -7:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -7).')</option>\n<option value=\\'-6\\' '.($setting[''value''] == -6?'selected=\\'selected\\'':'').'>GMT -6:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -6).')</option>\n<option value=\\'-5\\' '.($setting[''value''] == -5?'selected=\\'selected\\'':'').'>GMT -5:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -5).')</option>\n<option value=\\'-4\\' '.($setting[''value''] == -4?'selected=\\'selected\\'':'').'>GMT -4:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -4).')</option>\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>\n<option value=\\'-3\\' '.($setting[''value''] == -3?'selected=\\'selected\\'':'').'>GMT -3:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -3).')</option>\n<option value=\\'-2\\' '.($setting[''value''] == -2?'selected=\\'selected\\'':'').'>GMT -2:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -2).')</option>\n<option value=\\'-1\\' '.($setting[''value''] == -1?'selected=\\'selected\\'':'').'>GMT -1:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, -1).')</option>\n<option value=\\'0\\' '.($setting[''value''] == 0?'selected=\\'selected\\'':'').'>GMT ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 0).')</option>\n<option value=\\'+1\\' '.($setting[''value''] == 1?'selected=\\'selected\\'':'').'>GMT +1:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 1).')</option>\n<option value=\\'+2\\' '.($setting[''value''] == 2?'selected=\\'selected\\'':'').'>GMT +2:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 2).')</option>\n<option value=\\'+3\\' '.($setting[''value''] == 3?'selected=\\'selected\\'':'').'>GMT +3:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 3).')</option>\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>\n<option value=\\'+4\\' '.($setting[''value''] == 4?'selected=\\'selected\\'':'').'>GMT +4:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 4).')</option>\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>\n<option value=\\'+5\\' '.($setting[''value''] == 5?'selected=\\'selected\\'':'').'>GMT +5:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 5).')</option>\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>\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>\n<option value=\\'+6\\' '.($setting[''value''] == 9?'selected=\\'selected\\'':'').'>GMT +6:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 6).')</option>\n<option value=\\'+7\\' '.($setting[''value''] == 7?'selected=\\'selected\\'':'').'>GMT +7:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 7).')</option>\n<option value=\\'+8\\' '.($setting[''value''] == 8?'selected=\\'selected\\'':'').'>GMT +8:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 8).')</option>\n<option value=\\'+9\\' '.($setting[''value''] == 9?'selected=\\'selected\\'':'').'>GMT +9:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 9).')</option>\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>\n<option value=\\'+10\\' '.($setting[''value''] == 10?'selected=\\'selected\\'':'').'>GMT +10:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 10).')</option>\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>\n<option value=\\'+11\\' '.($setting[''value''] == 11?'selected=\\'selected\\'':'').'>GMT +11:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 11).')</option>\n<option value=\\'+12\\' '.($setting[''value''] == 12?'selected=\\'selected\\'':'').'>GMT +12:00 Hours ('.my_date($mybb->settings[''timeformat''], TIME_NOW, 12).')</option>\n</select>', '+1', 4, 4, 1),
  5. (...)
  6. (205, 'prunethreads', 'Prune User Posts/Threads', 'For the users that are going to be removed, do you want to remove all of their posts/threads?', 'yesno', '0', 7, 21, 1);";


Podczas wykonywania otrzymuje błąd
  1. Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /opt/lampp/htdocs/e-fora/pliki/formularz/mybb_wypelnianie_tabel2.php on line 218

Tj odnosnie tekstu zaczynającego sie od (13, a kończącego sie przed (...)
(205,
. Nie wiem gdzie i co jest nie tak, nie widze, moze mnie ktos nakierowac?
Go to the top of the page
+Quote Post

Posty w temacie


Reply to this topicStart new topic
2 Użytkowników czyta ten temat (2 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 



RSS Aktualny czas: 3.10.2025 - 09:37