[SQL][MySQL][PHP]Zapytanie i błąd Opcje

[musiek86]

Skrypt wypełnia tabele w bazie i mam taki rekord do dodania

[PHP] pobierz, plaintext 
$inserts[] = "INSERT INTO efora__{$nazwa}__settings ('sid', 'name', 'title', 'description', 'optionscode', 'value', 'disporder', 'gid', 'isdefault') VALUES
(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),
(...)
(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),
(...)
(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);";
[PHP] pobierz, plaintext 

Podczas wykonywania otrzymuje błąd

[PHP] pobierz, plaintext 
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
[PHP] pobierz, plaintext 

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?

[melkorm]

Odpal w zwykłym edytorze, przeformatuj kod to zobaczysz, zresztą forum nie parser.

[musiek86]

Mam odpalone w notepad++ który koloruje ale skrypt jest tak napisany ze wszystko mam w kolorze szarym co utrudnia mi to nieco, wiec jesli widzisz błą to łaskawie wskaż mi go.
Dodam jeszcze iż nie chce by ten kod był analizowany, konkretniej mowiąc w tabeli optionscode ma znajdować sie słowo w słowo tekst 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> zmienne nie maja być podmieniane a kod analizowany przez parser.

EDIT:
Juz sobie poradziłem konstruując skrypt w nieco innej formie. Do zamknięcia.

Ten post edytował musiek86 18.08.2012, 02:26:44