�����JFIF��XX����������    $.' ",#(7),01444'9=82<.342  2!!22222222222222222222222222222222222222222222222222�����"����4���������������������������� ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������,�PG"Z_�4�˷����kjز�Z�,F+��_z�,�© �����zh6�٨�ic�fu������������������������������������#ډb���_�N��?�����������wQ���5-�~�I���8���������������������������������TK<5o�Iv-������������������k�_U_������������������������������~b�M��d��������Ӝ�U�Hh��?]��E�w��Q���k�{��_}qFW7HTՑ��Y��F�����?_�'ϔ��_�Ջt������������������������=||I �����6�έ"�����D���/[�k�9����Y�8������ds|\���Ҿp6�Ҵ���]��.����6���z<�v��@]�i%������������������������$j��~����g��J>��no����pM[me�i$[�����������s�o�ᘨ�˸ nɜG-�ĨU�ycP���3.DB�li�;���������������������hj���x����7Z^�N�h��������N3u{�:j�����x�힞��#M��&��jL P@��_���� P�������������������&��o8��������9������@Sz���6�t7#O�ߋ �����s}Yf�T������lmr����Z)'N��k�۞p�����w\�T���������������ȯ?�8`���O��i{wﭹW�[�r�� ��Q4F�׊������3m&L�=��h3�������z~��#����\�l :�F,j@�� ʱ�wQT����8�"kJO����6�֚l������������������}����R�>ډK���]��y����&����p�}b������;N�1�m�r$����|��7�>e�@���B�TM*-i�H��g�D�)� E�m�|�ؘbҗ�a���Ҿ����������������t4�����o���G��*oCN�rP���Q��@z,|?W[0���������:�n,j���WiE��W������$~/�hp\��?��{(�0���+�Y8rΟ�+����>S-S���������������VN;���}�s?.����� w��9��˟<���Mq4�Wv'������{)0�1mB����V����W[��������8�/<� �%���wT^�5���b��)iM� p�g�N�&ݝ������������VO~��q���u���9��� ����!��J27�����$����O-���! �:���%H��� ـ�������y�ΠM=t{!S�� �oK8�������t<����è��������:a��������[������ա�H���~��w��Qz`�p����o�^ ������Q��n����� �,uu�C��$ ^���,�������8�#��:�6��e�|~�����������!�3��3.�\0�����q��o�4`.|� ����y�Q�`~;�d�ׯ,��O�Zw�������`73�v�܋�<�����Ȏ�� ـ4k��5�K�a�u�=9Yd��$>x�A�&�� j0� ���vF��� Y���|�y��� ~�6�@c��1vOp��������Ig�����4��l�OD�����L����� R���c���j�_�uX�6��3?nk��Wy�f;^*B� ��@���~a�`��Eu�������+�����6�L��.ü>��}y���}_�O�6�͐�:�Yr���G�X��kG������l^w����������~㒶sy���Iu�!���� W ��X��N�7BV��O��!X�2����wvG�R�f�T#�����t�/?���%8�^�W�aT����G�cL�M���I��(J����1~�8�?aT ���]����AS�E��(��*E}� 2������#I/�׍qz��^t�̔���������b�Yz4x����t�){ OH�����+(E��A&�N�������XT��o��"�XC����'���)}�J�z�p� ����~5�}�^����+�6����w��c��Q�|�Lp�d�H��}�(�.|����k��c4^�����"�����Z?ȕ ��a<�������L�!0�39C� �Eu�����C�F�Ew�ç ;�n?�*o���B�8�bʝ���'#Rqf����M}7����]�������s2tcS{�\icTx;�\��7K���P������ʇ Z O-��~�������c>"��?��������P�����E��O�8��@�8��G��Q�g�a�Վ���󁶠��䧘��_%#r�>�����1�z�a���eb��qcP��ѵ��n���#L��� =��׀t� L�7�`�����V����A{�C:�g���e@�����w1 Xp�3�c3�ġ�������p��M"'-�@n4���fG���B3�DJ�8[Jo�ߐ���gK)ƛ��$���� �������8�3�����+���� �����6�ʻ���� ���S�kI�*KZlT _`�������?��K�����QK�d���������B`�s}�>���`������*�>��,*@J�d�oF*�����弝��O}�k��s��]��y�ߘ�������c1G�V���<=�7��7����6��q�PT��tXԀ�!9*4�4Tހ���3XΛex�46�������Y��D ����� ����BdemDa����\�_l,����G�/���֌7���Y�](�xTt^%�GE�����4�}bT����ڹ�����;��Y)���B�Q��u��>J/J ���⮶.�XԄ��j�ݳ������+E��d ���r�5�_D�����1 ���o�� �B�x�΢�#����<��W�����8���R6�@���g�M�.��� dr�D��>(otU��@�x=��~v���2� ӣ�d�oBd�����3�eO�6�㣷����������ݜ�6��6Y��Qz`����S��{���\P��~z m5{J/L��1������<�e�ͅPu���b�]�ϔ��������'�������f�b� Zpw��c`"��i���BD@:)ִ�:�]��h���v�E��w���T�l�������P����"Ju�}��وV ��J��G6��. J/�Qgl߭�e�����@�z�Zev2u����)]կ���������7x�������s�M�-<ɯ�c��r��v�����@��$�ޮ}lk���a����'����>x��O\�Z������Fu>������ck#��&:��`�$��ai�>2Δ����l���oF[h�������lE�ܺ�Π���k:)���`������� $[6�����9�����kOw�\|�����8}������ބ:��񶐕��������I�A1/���=�2[�,�!��.}gN#�u����b���� ~���������݊��}34q�����d�E��L��������c��$���"�[q�U�硬g^��%B ��z���r�p�������J�ru%v\h�����1Y�ne`������ǥ:g����pQM~�^��Xi� ��`S�:V2������9.�P���V������?B�k�� ��������AEvw%�_�9C�Q����wKekP�ؠ�\������;Io d�{ ߞo�c1eP�����\� `����E=���@K<�Y��������eڼ�J����w����{av�F�'�M�@��������������/J��+9p����|]���������Iw &`���8���&�M�hg���[�{�������Xj���%��Ӓ�������������������$��(�����ʹN�������<>�I���RY�����K2�NPlL�ɀ�)��&e��������B+ь����(������������������� � �JTx����_?EZ� }@���� 6�U���뙢ط�z��dWI��n` D����噥�[��uV��"�G&�����Ú����2�g�}&m���������������������?ċ���"����Om#�������������������������� ��{���������������������ON��"S�X���Ne��ysQ���@�������������Fn��Vg�����dX�~nj����������������������]J�<�K]:����FW���b�������62����������=��5f����JKw����bf�X������������������������55��~J �%^�������:�-�QIE��P��v�nZum� z � ~ə ���� ���ة����;�f��\v�������g�8�1��f2�������������������������4;�V���ǔ�)�������������������9���1\������������������������������c��v�/'Ƞ�w������������������$�4�R-��t����������������������������������� e�6�/�ġ �̕Ecy�J���u�B���<�W�ַ~�w[B1L۲�-JS΂�{���΃�������������������������������������������A��20�c#���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������@���� 0!1@AP"#2Q`$3V�%45a6�FRUq����� ������^7ׅ,$n��������+��F�`��2X'��0vM��p�L=�������5��8������u�p~���.�`r�����\����O��,ư�0oS ��_�M�����l���4�kv\JSd���x���SW�<��Ae�IX����������$I���w�:S���y���›R��9�Q[���,�5�;�@]�%���u�@ *ro�lbI �� ��+���%m:�͇ZV�����u�̉����θau<�fc�.����{�4Ա� �Q����*�Sm��8\ujqs]{kN���)qO�y�_*dJ�b�7���yQqI&9�ԌK!�M}�R�;�������S�T���1���i[U�ɵz�]��U)V�S6���3$K{��ߊ<�(� E]Զ[ǼENg�����'�\?#)Dkf��J���o��v���'�%ƞ�&K�u��!��b�35LX�Ϸ��63$K�a�;�9>,R��W��3�3� d�JeTYE.Mϧ��-�o�j3+y��y^�c�������VO�9NV\nd�1 ��!͕_)a�v;����թ�M�lWR1��)El��P;��yوÏ�u 3�k�5Pr6<�⒲l�!˞*��u־�n�!�l:����UNW ��%��Chx8vL'��X�@��*��)���̮��ˍ��� ����D-M�+J�U�kvK����+�x8��cY������?�Ԡ��~3mo��|�u@[XeY�C�\Kp�x8�oC�C�&����N�~3-H���� ��MX�s�u<`���~"WL��$8ξ��3���a�)|:@�m�\���^�`�@ҷ)�5p+��6���p�%i)P M���ngc�����#0Aruz���RL+xSS?���ʮ}()#�t��mˇ!��0}}y����<�e� �-ή�Ԩ��X������ MF���ԙ~l L.3���}�V뽺�v������멬��Nl�)�2����^�Iq��a��M��qG��T�����c3#������3U�Ǎ���}��לS�|qa��ڃ�+���-��2�f����/��bz��ڐ�� �ݼ[2�ç����k�X�2�* �Z�d���J�G����M*9W���s{��w���T��x��y,�in�O�v��]���n����P�$��JB@=4�OTI�n��e�22a\����q�d���%�$��(���:���: /*�K[PR�fr\nڙdN���F�n�$�4��[�� U�zƶ����� �mʋ���,�ao�u 3�z� �x��Kn����\[��VFmbE;�_U��&V�Gg�]L�۪&#n%�$ɯ��dG���D�TI=�%+AB�Ru#��b4�1�»x�cs�YzڙJG��f��Il���d�eF'T� iA��T���uC�$����Y��H?����[!G`}���ͪ� �纤Hv\������j�Ex�K���!���OiƸ�Yj�+u-<���'q����uN�*�r\��+�]���<�wOZ.fp�ێ��,-*)V?j-kÊ#�`�r��dV����(�ݽBk�����G�ƛk�QmUڗe��Z���f}|����8�8��a���i��3'J�����~G_�^���d�8w������ R�`(�~�.��u���l�s+g�bv���W���lGc}��u���afE~1�Ue������Z�0�8�=e�� f@/�jqEKQQ�J���oN��J���W5~M>$6�Lt�;$ʳ{���^��6�{����v6���ķܰg�V�cnn �~z�x�«�,2�u�?cE+Ș�H؎�%�Za�)���X>uW�Tz�Nyo����s���FQƤ��$��*�&�LLXL)�1�" L��eO��ɟ�9=���:t��Z���c��Ž���Y?�ӭV�wv�~,Y��r�ۗ�|�y��GaF�����C�����.�+� ���v1���fήJ�����]�S��T��B��n5sW}y�$��~z�'�c ��8 ��� ,! �p��VN�S��N�N�q��y8z˱�A��4��*��'������2n<�s���^ǧ˭P�Jޮɏ�U�G�L�J�*#��<�V��t7�8����TĜ>��i}K%,���)[��z�21z ?�N�i�n1?T�I�R#��m-�����������������1����lA�`��fT5+��ܐ�c�q՝��ʐ��,���3�f2U�եmab��#ŠdQ�y>\��)�SLY����w#��.���ʑ�f��� ,"+�w�~�N�'�c�O�3F�������N<���)j��&��,-� �љ���֊�_�zS���TǦ����w�>��?�������n��U仆�V���e�����0���$�C�d���rP �m�׈e�Xm�Vu� �L��.�bֹ��� �[Դaզ���*��\y�8�Է:�Ez\�0�Kq�C b��̘��cө���Q��=0Y��s�N��S.����3.���O�o:���#���v7�[#߫ ��5�܎�L���Er4���9n��COWlG�^��0k�%<���ZB���aB_���������'=��{i�v�l�$�uC���mƎҝ{�c㱼�y]���W�i ��ߧc��m�H� m�"�"�����;Y�ߝ�Z�Ǔ�����:S#��|}�y�,/k�Ld� TA�(�AI$+I3��;Y*���Z��}|��ӧO��d�v��..#:n��f>�>���ȶI�TX��� 8��y����"d�R�|�)0���=���n4��6ⲑ�+��r<�O�܂~zh�z����7ܓ�HH�Ga롏���nCo�>������a ���~]���R���̲c?�6(�q�;5%� |�uj�~z8R�=X��I�V=�|{v�Gj\gc��q����z�؋%M�ߍ����1y��#��@f^���^�>N������#x#۹��6�Y~�?�dfPO��{��P�4��V��u1E1J �*|���%����JN��`eWu�zk M6���q t[�� ��g�G���v��WIG��u_ft����5�j�"�Y�:T��ɐ���*�;� e5���4����q$C��2d�}���� _S�L#m�Yp��O�.�C�;��c����Hi#֩%+) �Ӎ��ƲV���SYź��g |���tj��3�8���r|���V��1#;.SQ�A[���S������#���`n�+���$��$�I �P\[�@�s��(�ED�z���P��])8�G#��0B��[ى��X�II�q<��9�~[Z멜�Z�⊔IWU&A>�P~�#��dp<�?����7���c��'~���5 ��+$���lx@�M�dm��n<=e�dyX��?{�|Aef ,|n3�<~z�ƃ�uۧ�����P��Y,�ӥQ�*g�#먙R�\���;T��i,��[9Qi歉����c>]9�� ��"�c��P�� �Md?٥��If�ت�u��k��/����F��9�c*9��Ǎ:�ØF���z�n*�@|I�ށ9����N3{'��[�'ͬ�Ҳ4��#}��!�V� Fu��,�,mTIk���v C�7v���B�6k�T9��1�*l� '~��ƞF��lU��'�M ����][ΩũJ_�{�i�I�n��$����L�� j��O�dx�����kza۪��#�E��Cl����x˘�o�����V���ɞ�ljr��)�/,�߬h�L��#��^��L�ф�,íMƁe�̩�NB�L�����iL����q�}��(��q��6IçJ$�W�E$��:������=#����(�K�B����zђ <��K(�N�۫K�w��^O{!����)��H���>x�������lx�?>Պ�+�>�W���,Ly!_�D���Ō�l���Q�!�[ �S����J��1��Ɛ�Y}��b,+�Lo�x�ɓ)����=�y�oh�@�꥟/��I��ѭ=��P�y9��� �ۍYӘ�e+�p�Jnϱ?V\SO%�(�t� ���=?MR�[Ș�����d�/ ��n�l��B�7j� ��!�;ӥ�/�[-���A�>��dN�sLj ��,ɪv��=1c�.SQ�O3�U���ƀ�ܽ�E����������̻��9G�ϷD�7(�}��Ävӌ\��y�_0[w ���<΍>����a_��[0+�L��F.�޺��f�>oN�T����q;���y\��bՃ��y�jH�<|q-eɏ�_?_9+P���Hp$�����[ux�K w�Mw��N�ی'$Y2�=��q���KB��P��~�������Yul:�[<����F1�2�O���5=d����]Y�sw:���Ϯ���E��j,_Q��X��z`H1,#II ��d�wr��P˂@�ZJV����y$�\y�{}��^~���[:N����ߌ�U�������O��d�����ؾe��${p>G��3c���Ė�lʌ�� ת��[��`ϱ�-W����dg�I��ig2��� ��}s ��ؤ(%#sS@���~���3�X�nRG�~\jc3�v��ӍL��M[JB�T��s3}��j�Nʖ��W����;7���ç?=X�F=-�=����q�ߚ���#���='�c��7���ڑW�I(O+=:uxq�������������e2�zi+�kuG�R��������0�&e�n���iT^J����~\jy���p'dtG��s����O��3����9* �b#Ɋ�� p������[Bws�T�>d4�ۧs���nv�n���U���_�~,�v����ƜJ1��s�� �QIz���)�(lv8M���U=�;����56��G���s#�K���MP�=��LvyGd��}�VwWBF�'�à �?MH�U�g2�� ����!�p�7Q��j��ڴ����=��j�u��� Jn�A s���uM������e��Ɔ�Ҕ�!)�'��8Ϣ�ٔ���ޝ(��Vp���צ֖d=�IC�J�Ǡ{q������kԭ�߸���i��@K����u�|�p=..�*+����x�����z[Aqġ#s2a�Ɗ���RR�)*HRsi�~�a &f��M��P����-K�L@��Z��Xy�'x�{}��Zm+���:�)�) IJ�-i�u���� ���ܒH��'��L(7�y�GӜq���� j��� 6ߌg1�g�o���,kر���tY�?W,���p���e���f�OQS��!K�۟cҒA�|ս�j�>��=⬒��˧L[�� �߿2JaB~R��u�:��Q�] �0H~���]�7��Ƽ�I���(�}��cq '�ήET���q�?f�ab���ӥvr� �)o��-Q��_'����ᴎo��K������;��V���o��%���~OK ����*��b�f:���-ťIR��`B�5!RB@���ï�� �u �̯e\�_U�_������� g�ES��3��������QT��a�����x����U<~�c?�*�#]�MW,[8O�a�x��]�1bC|踤�P��lw5V%�)�{t�<��d��5���0i�XSU��m:��Z�┵�i�"��1�^B�-��P�hJ��&)O��*�D��c�W��vM��)����}���P��ܗ-q����\mmζZ-l@�}��a��E�6��F�@��&Sg@���ݚ�M����� ȹ 4����#p�\H����dYDo�H���"��\��..R�B�H�z_�/5˘����6��KhJR��P�mƶi�m���3��,#c�co��q�a)*P�t����R�m�k�7x�D�E�\Y�閣_X�<���~�)���c[[�BP����6�Yq���S��0����%_����;��Àv�~�| VS؇ ��'O0��F0��\���U�-�d@�����7�SJ*z��3n��y��P����O����������m�~�P�3|Y��ʉr#�C�<�G~�.,! ���bqx���h~0=��!ǫ�jy����l��O,�[B��~��|9��ٱ����Xly�#�i�B��g%�S��������tˋ���e���ې��\[d�t)��.+u�|1 ������#�~Oj����hS�%��i.�~X���I�H�m��0n���c�1uE�q��cF�RF�o���7� �O�ꮧ� ���ۛ{��ʛi5�rw?׌#Qn�TW��~?y$��m\�\o����%W� ?=>S�N@�� �Ʈ���R����N�)�r"C�:��:����� �����#��qb��Y�. �6[��2K����2u�Ǧ�HYR��Q�MV��� �G�$��Q+.>�����nNH��q�^��� ����q��mM��V��D�+�-�#*�U�̒ ���p욳��u:�������IB���m����PV@O���r[b= �� ��1U�E��_Nm�yKbN�O���U�}�the�`�|6֮P>�\2�P�V���I�D�i�P�O;�9�r�mAHG�W�S]��J*�_�G��+kP�2����Ka�Z���H�'K�x�W�MZ%�O�YD�Rc+o��?�q��Ghm��d�S�oh�\�D�|:W������UA�Qc yT�q��������~^�H��/��#p�CZ���T�I�1�ӏT����4��"�ČZ�����}��`w�#�*,ʹ�� ��0�i��課�Om�*�da��^gJ݅{���l�e9uF#T�ֲ��̲�ٞC"�q���ߍ ոޑ�o#�XZTp����@ o�8��(jd��xw�]�,f���`~��|,s��^����f�1���t��|��m�򸄭/ctr��5s��7�9Q�4�H1꠲BB@�l9@���C�����+�wp�xu�£Yc�9��?`@#�o�mH�s2��)�=��2�.�l����jg�9$�Y�S�%*L������R�Y������7Z���,*=�䷘$�������arm�o�ϰ���UW.|�r�uf����IGw�t����Zwo��~5 ��YյhO+=8fF�)�W�7�L9lM�̘·Y���֘YLf�큹�pRF���99.A �"wz��=E\Z���'a� 2��Ǚ�#;�'}�G���*��l��^"q��+2FQ� hj��kŦ��${���ޮ-�T�٭cf�|�3#~�RJ����t��$b�(R��(����r���dx� >U b�&9,>���%E\� Ά�e�$��'�q't��*�א���ެ�b��-|d���SB�O�O��$�R+�H�)�܎�K��1m`;�J�2�Y~9��O�g8=vqD`K[�F)k�[���1m޼c��n���]s�k�z$@��)!I �x՝"v��9=�ZA=`Ɠi �:�E��)`�7��vI��}d�YI�_ �o�:ob���o ���3Q��&D&�2=�� �Ά��;>�h����y.*ⅥS������Ӭ�+q&����j|UƧ�����}���J0��WW< ۋS�)jQR�j���Ư��rN)�Gű�4Ѷ(�S)Ǣ�8��i��W52���No˓� ۍ%�5brOn�L�;�n��\G����=�^U�dI���8$�&���h��'���+�(������cȁ߫k�l��S^���cƗjԌE�ꭔ��gF���Ȓ��@���}O���*;e�v�WV���YJ\�]X'5��ղ�k�F��b 6R�o՜m��i N�i�����>J����?��lPm�U��}>_Z&�KK��q�r��I�D�Չ~�q�3fL�:S�e>���E���-G���{L�6p�e,8��������QI��h��a�Xa��U�A'���ʂ���s�+טIjP�-��y�8ۈZ?J$��W�P� ��R�s�]��|�l(�ԓ��sƊi��o(��S0���Y� 8�T97.�����WiL��c�~�dxc�E|�2!�X�K�Ƙਫ਼�$((�6�~|d9u+�qd�^3�89��Y�6L�.I�����?���iI�q���9�)O/뚅����O���X��X�V��ZF[�یgQ�L��K1���RҖr@v�#��X�l��F���Нy�S�8�7�kF!A��sM���^rkp�jP�DyS$N���q���nxҍ!U�f�!eh�i�2�m����`�Y�I�9r�6� �TF���C}/�y�^���Η���5d�'��9A-��J��>{�_l+�`��A���[�'��յ�ϛ#w:݅�%��X�}�&�PSt�Q�"�-��\縵�/����$Ɨh�Xb�*�y��BS����;W�ջ_mc�����vt?2}1�;qS�d�d~u:2k5�2�R�~�z+|HE!)�Ǟl��7`��0�<�,�2*���Hl-��x�^����'_TV�gZA�'j� ^�2Ϊ��N7t�����?w�� �x1��f��Iz�C-Ȗ��K�^q�;���-W�DvT�7��8�Z�������� hK�(P:��Q- �8�n�Z���܃e貾�<�1�YT<�,�����"�6{�/ �?�͟��|1�:�#g��W�>$����d��J��d�B���=��jf[��%rE^��il:��B���x���Sּ�1հ��,�=��*�7 fcG��#q� �eh?��2�7�����,�!7x��6�n�LC�4x��},Geǝ�tC.��vS �F�43��zz\��;QYC,6����~;RYS/6���|2���5���v��T��i����������mlv��������&� �nRh^ejR�LG�f���? �ۉҬܦƩ��|��Ȱ����>3����!v��i�ʯ�>�v��オ�X3e���_1z�Kȗ\<������!�8���V��]��?b�k41�Re��T�q��mz��TiOʦ�Z��Xq���L������q"+���2ۨ��8}�&N7XU7Ap�d�X��~�׿��&4e�o�F��� �H�����O���č�c�� 懴�6���͉��+)��v;j��ݷ�� �UV�� i��� j���Y9GdÒJ1��詞�����V?h��l�����l�cGs�ځ�������y�Ac������\V3�? �� ܙg�>qH�S,�E�W�[�㺨�uch�⍸�O�}���a��>�q�6�n6�����N6�q��������N� ���! 1AQaq�0@����"2BRb�#Pr���3C`��Scst���$4D���%Td���� ?�����N����a��3��m���C���w��������xA�m�q�m����m������$����4n淿t'��C"w��zU=D�\R+w�p+Y�T�&�պ@��ƃ��3ޯ?�Aﶂ��aŘ���@-�����Q�=���9D��ռ�ѻ@��M�V��P��܅�G5�f�Y<�u=,EC)�<�Fy'�"�&�չ�X~f��l�KԆV��?�� �W�N����=(� �;���{�r����ٌ�Y���h{�١������jW����P���Tc�����X�K�r��}���w�R��%��?���E��m�� �Y�q|����\lEE4����r���}�lsI�Y������f�$�=�d�yO����p�����yBj8jU�o�/�S��?�U��*������ˍ�0�������u�q�m [�?f����a�� )Q�>����6#������� ?����0UQ����,IX���(6ڵ[�DI�MNލ�c&���υ�j\��X�R|,4��� j������T�hA�e��^���d���b<����n�� �즇�=!���3�^�`j�h�ȓr��jẕ�c�,ٞX����-����a�ﶔ���#�$��]w�O��Ӫ�1y%��L�Y<�wg#�ǝ�̗`�x�xa�t�w��»1���o7o5��>�m뭛C���Uƃߜ}�C���y1Xνm�F8�jI���]����H���ۺиE@I�i;r�8ӭ�����V�F�Շ| ��&?�3|x�B�MuS�Ge�=Ӕ�#BE5G������Y!z��_e��q�р/W>|-�Ci߇�t�1ޯќd�R3�u��g�=0 5��[?�#͏��q�cf���H��{ ?u�=?�?ǯ���}Z��z���hmΔ�BFTW�����<�q��(v� ��!��z���iW]*�J�V�z��gX֧A�q�&��/w���u�gYӘa���; �i=����g:��?2�dž6�ى�k�4�>�Pxs����}������G�9���3 ���)gG�R<>r h�$��'nc�h�P��Bj��J�ҧH� -��N1���N��?��~��}-q!=��_2hc�M��l�vY%UE�@|�v����M2�.Y[|y�"Eï��K�ZF,�ɯ?,q�?v�M 80jx�"�;�9vk�����+ ֧�� �ȺU��?�%�vcV��mA�6��Qg^M�����A}�3�nl� QRN�l8�kkn�'�����(��M�7m9و�q���%ޟ���*h$Zk"��$�9��: �?U8�Sl��,,|ɒ��xH(ѷ����Gn�/Q�4�P��G�%��Ա8�N��!� �&�7�;���eKM7�4��9R/%����l�c>�x;������>��C�:�����t��h?aKX�bhe�ᜋ^�$�Iհ �hr7%F$�E��Fd���t��5���+�(M6�t����Ü�UU|zW�=a�Ts�Tg������dqP�Q����b'�m���1{|Y����X�N��b �P~��F^F:����k6�"�j!�� �I�r�`��1&�-$�Bevk:y���#y�w��I0��x��=D�4��tU���P�ZH��ڠ底taP��6����b>�xa�����Q�#� WeF��ŮNj�p�J* mQ�N�����*I�-*�ȩ�F�g�3 �5��V�ʊ�ɮ�a��5F���O@{���NX��?����H�]3��1�Ri_u��������ѕ�� ����0��� F��~��:60�p�͈�S��qX#a�5>���`�o&+�<2�D����: �������ڝ�$�nP���*)�N�|y�Ej�F�5ټ�e���ihy�Z �>���k�bH�a�v��h�-#���!�Po=@k̆IEN��@��}Ll?j�O������߭�ʞ���Q|A07x���wt!xf���I2?Z��<ץ�T���cU�j��]���陎Ltl �}5�ϓ��$�,��O�mˊ�;�@O��jE��j(�ا,��LX���LO���Ц�90�O �.����a��nA���7������j4 ��W��_ٓ���zW�jcB������y՗+EM�)d���N�g6�y1_x��p�$Lv�:��9�"z��p���ʙ$��^��JԼ*�ϭ����o���=x�Lj�6�J��u82�A�H�3$�ٕ@�=Vv�]�'�qEz�;I˼��)��=��ɯ���x �/�W(V���p�����$ �m�������u�����񶤑Oqˎ�T����r��㠚x�sr�GC��byp�G��1ߠ�w e�8�$⿄����/�M{*}��W�]˷.�CK\�ުx���/$�WP�w���r� |i���&�}�{�X� �>��$-��l���?-z���g����lΆ���(F���h�vS*���b���߲ڡn,|)mrH[���a�3�ר�[1��3o_�U�3�TC�$��(�=�)0�kgP���� ��u�^=��4 �WYCҸ:��vQ�ר�X�à��tk�m,�t*��^�,�}D*�� �"(�I��9R����>`�`��[~Q]�#af��i6l��8���6�:,s�s�N6�j"�A4���IuQ��6E,�GnH��zS�HO�uk�5$�I�4��ؤ�Q9�@��C����wp��BGv[]�u�Ov����0I4���\��y�����Q�Ѹ��~>Z��8�T��a��q�ޣ;z��a���/��S��I:�ܫ_�|������>=Z����8:�S��U�I�J��"IY���8%b8���H��:�QO�6�;7�I�S��J��ҌAά3��>c���E+&jf$eC+�z�;��V����� �r���ʺ������my�e���aQ�f&��6�ND���.:��NT�vm�<- u���ǝ\MvZY�N�NT��-A�>jr!S��n�O 1�3�Ns�%�3D@���`������ܟ 1�^c<���� �a�ɽ�̲�Xë#�w�|y�cW�=�9I*H8�p�^(4���՗�k��arOcW�tO�\�ƍR��8����'�K���I�Q�����?5�>[�}��yU�ײ -h��=��% q�ThG�2�)���"ו3]�!kB��*p�FDl�A���,�eEi�H�f�Ps�����5�H:�Փ~�H�0Dت�D�I����h�F3�������c��2���E��9�H��5�zԑ�ʚ�i�X�=:m�xg�hd(�v����׊�9iS��O��d@0ڽ���:�p�5�h-��t�&���X�q�ӕ,��ie�|���7A�2���O%P��E��htj��Y1��w�Ѓ!����  ���� ࢽ��My�7�\�a�@�ţ�J ��4�Ȼ�F�@o�̒?4�wx��)��]�P��~�����u�����5�����7X ��9��^ܩ�U;Iꭆ 5 �������eK2�7(�{|��Y׎ �V��\"���Z�1� Z�����}��(�Ǝ"�1S���_�vE30>���p;� ΝD��%x�W�?W?v����o�^V�i�d��r[��/&>�~`�9Wh��y�;���R���� ;;ɮT��?����r$�g1�K����A��C��c��K��l:�'��3 c�ﳯ*"t8�~l��)���m��+U,z��`(��>yJ�?����h>��]��v��ЍG*�{`��;y]��I�T� ;c��NU�fo¾h���/$���|NS���1�S�"�H��V���T���4��uhǜ�]�v;���5�͠x��'C\�SBpl���h}�N����� A�Bx���%��ޭ�l��/����T��w�ʽ]D�=����K���ž�r㻠l4�S�O?=�k �M:� ��c�C�a�#ha���)�ѐxc�s���gP�iG���{+���x���Q���I= �� z��ԫ+ �8"�k�ñ�j=|����c ��y��CF��/���*9ж�h{ �?4�o� ��k�m�Q�N�x��;�Y��4膚�a�w?�6�>�e]�����Q�r�:����g�,i"�����ԩA��*M�<�G��b�if��l^M��5�� �Ҩ�{����6J��ZJ�����P�*�����Y���ݛu�_4�9�I8�7���������,^ToR���m4�H��?�N�S�ѕw��/S��甍�@�9H�S�T��t�ƻ���ʒU��*{Xs�@����f������֒Li�K{H�w^���������Ϥm�tq���s� ���ք��f:��o~s��g�r��ט� �S�ѱC�e]�x���a��) ���(b-$(�j>�7q�B?ӕ�F��hV25r[7 Y� }L�R��}����*sg+��x�r�2�U=�*'WS��ZDW]�WǞ�<��叓���{�$�9Ou4��y�90-�1�'*D`�c�^o?(�9��u���ݐ��'PI&� f�Jݮ�������:wS����jfP1F:X �H�9dԯ����˝[�_54 �}*;@�ܨ�� ð�yn�T���?�ןd�#���4rG�ͨ��H�1�|-#���Mr�S3��G�3�����)�.᧏3v�z֑��r����$G"�`j �1t��x0<Ɔ�Wh6�y�6��,œ�Ga��gA����y��b��)���h�D��ß�_�m��ü �gG;��e�v��ݝ�nQ� ��C����-�*��o���y�a��M��I�>�<���]obD��"�:���G�A��-\%LT�8���c�)��+y76���o�Q�#*{�(F�⽕�y����=���rW�\p���۩�c���A���^e6��K������ʐ�cVf5$�'->���ՉN"���F�"�UQ@�f��Gb~��#�&�M=��8�ט�JNu9��D��[̤�s�o�~������� G��9T�tW^g5y$b��Y'��س�Ǵ�=��U-2 #�MC�t(�i� �lj�@Q 5�̣i�*�O����s�x�K�f��}\��M{E�V�{�υ��Ƈ�����);�H����I��fe�Lȣr�2��>��W��I�Ȃ6������i��k�� �5�YOxȺ����>��Y�f5'��|��H+��98pj�n�.O�y�������jY��~��i�w'������l�;�s�2��Y��:'lg�ꥴ)o#'Sa�a�K��Z� �m��}�`169�n���"���x��I ��*+� }F<��cГ���F�P�������ֹ*�PqX�x۩��,� ��N�� �4<-����%����:��7����W���u�`����� $�?�I��&����o��o��`v�>��P��"��l���4��5'�Z�gE���8���?��[�X�7(��.Q�-��*���ތL@̲����v��.5���[��=�t\+�CNܛ��,g�SQnH����}*F�G16���&:�t��4ُ"A��̣��$�b �|����#rs��a�����T�� ]�<�j��B�S�('$�ɻ� �wP;�/�n��?�ݜ��x�F��yUn�~mL*-�������Xf�wd^�a�}��f�,=t�׵i�.2/wpN�Ep8�OР���•��R�FJ� 55TZ��T �ɭ�<��]��/�0�r�@�f��V��V����Nz�G��^���7hZi����k��3�,kN�e|�vg�1{9]_i��X5y7� 8e]�U����'�-2,���e"����]ot�I��Y_��n�(JҼ��1�O ]bXc���Nu�No��pS���Q_���_�?i�~�x h5d'�(qw52] ��'ޤ�q��o1�R!���`ywy�A4u���h<קy���\[~�4�\ X�Wt/� 6�����n�F�a8��f���z �3$�t(���q��q�x��^�XWeN'p<-v�!�{�(>ӽDP7��ո0�y)�e$ٕv�Ih'Q�EA�m*�H��RI��=:��� ���4牢) �%_iN�ݧ�l]� �Nt���G��H�L��� ɱ�g<���1V�,�J~�ٹ�"K��Q�� 9�HS�9�?@��k����r�;we݁�]I�!{ �@�G�[�"��`���J:�n]�{�cA�E����V��ʆ���#��U9�6����j�#Y�m\��q�e4h�B�7��C�������d<�?J����1g:ٳ���=Y���D�p�ц� ׈ǔ��1�]26؜oS�'��9�V�FVu�P�h�9�xc�oq�X��p�o�5��Ա5$�9W�V(�[Ak�aY錎qf;�'�[�|���b�6�Ck��)��#a#a˙��8���=äh�4��2��C��4tm^ �n'c����]GQ$[Wҿ��i���vN�{Fu ��1�gx��1┷���N�m��{j-,��x�� Ūm�ЧS�[�s���Gna���䑴�� x�p 8<������97�Q���ϴ�v�aϚG��Rt�Һ׈�f^\r��WH�JU�7Z���y)�vg=����n��4�_)y��D'y�6�]�c�5̪��\� �PF�k����&�c;��cq�$~T�7j ���nç]�<�g ":�to�t}�159�<�/�8������m�b�K#g'I'.W������6��I/��>v��\�MN��g���m�A�yQL�4u�Lj�j9��#44�t��l^�}L����n��R��!��t��±]��r��h6ٍ>�yҏ�N��fU�� ���� Fm@�8}�/u��jb9������he:A�y�ծw��GpΧh�5����l}�3p468��)U��d��c����;Us/�֔�YX�1�O2��uq�s��`hwg�r~�{ R��mhN��؎*q 42�*th��>�#���E����#��Hv�O����q�}������6�e��\�,Wk�#���X��b>��p}�դ��3���T5��†��6��[��@��P�y*n��|'f�֧>�lư΂�̺����SU�'*�q�p�_S�����M�� '��c�6������m�� ySʨ;M��r���Ƌ�m�Kxo,���Gm�P��A�G�:��i��w�9�}M(�^�V��$ǒ�ѽ�9���|���� �a����J�SQ�a���r�B;����}���ٻ֢�2�%U���c�#�g���N�a�ݕ�'�v�[�OY'��3L�3�;,p�]@�S��{ls��X�'���c�jw��k'a�.��}�}&�� �dP�*�bK=ɍ!����;3n�gΊU�ߴmt�'*{,=SzfD� A��ko~�G�aoq�_mi}#�m�������P�Xhύ�����mxǍ�΂���巿zf��Q���c���|kc�����?���W��Y�$���_Lv����l߶��c���`?����l�j�ݲˏ!V��6����U�Ђ(A���4y)H���p�Z_�x��>���e���R��$�/�`^'3qˏ�-&Q�=?��CFVR �D�fV�9��{�8g�������n�h�(P"��6�[�D���< E�����~0<@�`�G�6����Hг�cc�� �c�K.5��D��d�B���`?�XQ��2��ٿyqo&+�1^� DW�0�ꊩ���G�#��Q�nL3��c���������/��x ��1�1�[y�x�პCW��C�c�UĨ80�m�e�4.{�m��u���I=��f�����0QRls9���f���������9���~f�����Ǩ��a�"@�8���ȁ�Q����#c�ic������G��$���G���r/$W�(��W���V�"��m�7�[m�A�m����bo��D� j����۳� l���^�k�h׽����� ��#� iXn�v��eT�k�a�^Y�4�BN���ĕ���0������� !01@Q"2AaPq3BR�������?�����@4�Q�����T3,���㺠�W�[=JK�Ϟ���2�r^7��vc�:�9 �E�ߴ�w�S#d���Ix��u��:��Hp��9E!�� V 2;73|F��9Y���*ʬ�F��D����u&���y؟��^EA��A��(ɩ���^��GV:ݜDy�`��Jr29ܾ�㝉��[���E;Fzx��YG��U�e�Y�C���� ����v-tx����I�sם�Ę�q��Eb�+P\ :>�i�C'�;�����k|z�رn�y]�#ǿb��Q��������w�����(�r|ӹs��[�D��2v-%��@;�8<a���[\o[ϧw��I!��*0�krs)�[�J9^��ʜ��p1)� "��/_>��o��<1����A�E�y^�C��`�x1'ܣn�p��s`l���fQ��):�l����b>�Me�jH^?�kl3(�z:���1ŠK&?Q�~�{�ٺ�h�y���/�[��V�|6��}�KbX����mn[-��7�5q�94�������dm���c^���h� X��5��<�eޘ>G���-�}�دB�ޟ� ��|�rt�M��V+�]�c?�-#ڛ��^ǂ}���Lkr���O��u�>�-D�ry� D?:ޞ�U��ǜ�7�V��?瓮�"�#���r��չģVR;�n���/_� ؉v�ݶe5d�b9��/O��009�G���5n�W����JpA�*�r9�>�1��.[t���s�F���nQ� V 77R�]�ɫ8����_0<՜�IF�u(v��4��F�k�3��E)��N:��yڮe��P�`�1}�$WS��J�SQ�N�j��ٺ��޵�#l���ј(�5=��5�lǏmoW�v-�1����v,W�mn��߀$x�<����v�j(����c]��@#��1������Ǔ���o'��u+����;G�#�޸��v-lη��/(`i⣍Pm^����ԯ̾9Z��F��������n��1��� ��]�[��)�'�������:�֪�W��FC����� �B9،!?���]��V��A�Վ�M��b�w��G F>_DȬ0¤�#�QR�[V��kz���m�w�"��9ZG�7'[��=�Q����j8R?�zf�\a�=��O�U����*oB�A�|G���2�54 �p��.w7� �� ���&������ξxGHp� B%��$g�����t�Џ򤵍z���HN�u�Я�-�'4��0���;_���3������� !01"@AQa2Pq#3BR�������?����ʩca��en��^��8���<�u#��m*08r��y�N"�<�Ѳ0��@\�p��� �����Kv�D��J8�Fҽ� �f�Y��-m�ybX�NP����}�!*8t(�OqѢ��Q�wW�K��ZD��Δ^e��!� ��B�K��p~�����e*l}z#9ң�k���q#�Ft�o��S�R����-�w�!�S���Ӥß|M�l޶V��!eˈ�8Y���c�ЮM2��tk���� ������J�fS����Ö*i/2�����n]�k�\���|4yX�8��U�P.���Ы[���l��@"�t�<������5�lF���vU�����W��W��;�b�cД^6[#7@vU�xgZv��F�6��Q,K�v��� �+Ъ��n��Ǣ��Ft���8��0��c�@�!�Zq s�v�t�;#](B��-�nῃ~���3g������5�J�%���O������n�kB�ĺ�.r��+���#�N$?�q�/�s�6��p��a����a��J/��M�8��6�ܰ"�*������ɗud"\w���aT(����[��F��U՛����RT�b���n�*��6���O��SJ�.�ij<�v�MT��R\c��5l�sZB>F��<7�;EA��{��E���Ö��1U/�#��d1�a�n.1ě����0�ʾR�h��|�R��Ao�3�m3 ��%�� ���28Q�� ��y��φ���H�To�7�lW>����#i`�q���c����a��� �m,B�-j����݋�'mR1Ήt�>��V��p���s�0IbI�C.���1R�ea�����]H�6�����������4B>��o��](��$B���m�����a�!=���?�B� K�Ǿ+�Ծ"�n���K��*��+��[T#�{�E�J�S����Q�����s�5�:�U�\wĐ�f�3����܆&�)�����I���Ԇw��E T�lrTf6Q|R�h:��[K�� �z��c֧�G�C��%\��_�a��84��HcO�bi��ؖV��7H �)*ģK~Xhչ0��4?�0��� �E<���}3���#���u�?�� ��|g�S�6ꊤ�|�I#Hڛ� �ա��w�X��9��7���Ŀ%�SL��y6č��|�F�a 8���b���$�sק�h���b9RAu7�˨p�Č�_\*w��묦��F ����4D~�f����|(�"m���NK��i�S�>�$d7SlA��/�²����SL��|6N�}���S�˯���g��]6��; �#�.��<���q'Q�1|KQ$�����񛩶"�$r�b:���N8�w@��8$�� �AjfG|~�9F ���Y��ʺ��Bwؒ������M:I岎�G��`s�YV5����6��A �b:�W���G�q%l�����F��H���7�������Fsv7���k�� 403WebShell
403Webshell
Server IP : 172.67.166.40  /  Your IP : 104.23.197.203
Web Server : Apache
System : Linux tastesys.restaurant-online.biz 3.10.0-1160.144.1.el7.tuxcare.els4.x86_64 #1 SMP Tue Apr 7 08:40:40 UTC 2026 x86_64
User : restaura ( 1002)
PHP Version : 5.4.45
Disable Function : exec,passthru,shell_exec,system
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/restaura/public_html/roo/larrys-jonesboro_OFFLINE/rooadmin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /home/restaura/public_html/roo/larrys-jonesboro_OFFLINE/rooadmin/editmenuitemsub.php
<?php
// if ($_SESSION['FirstName'] == "") {
// 	echo 'You are not authorized to view this page. <br><br>You may <a href="index.php">log in here.</a></div></div>';
// 	exit;
// 	}

// include "sessionchecklink.php";

//require_once ('mysql_connect.php');
$action          = $_GET["a"];
$action2          = $_GET["action2"];
$move          = $_GET["d"];
$editchoice          = $_GET["editchoice"];
$choicekey          = $_GET["ckey"];
$fixingkey          = $_GET["fkey"];
$deleteoption =  $_GET["del"];
$active = $_POST['chkactive'];
$defaultcrust = $_POST['chkdefault'];
$defaultsauce = $_POST['chkdefaultsauce'];
$multisized = $_POST['chksizes'];
$freetopping = $_POST['chkfreetopping'];
$taxable = $_POST['chktaxable'];
$oldnum = $_POST['oldnum']; 	//get original order number so we know if it has been changed
$itemKey  = $_GET["key"];
$sizeKey  = $_GET["sizekey"];
$fixings = $_POST['chkfixings'];
$upsell = $_POST['chkupsell'];

//variables for size upselling options
$upsellsizes = $_POST['chkupsellsize'];
$upsell_cost = $_POST['upgrade_cost'];
$upsell_discount = $_POST['upgrade_discount'];
$upsell_nodiscount = $_POST['chk_nodiscount'];

$upsellcat  = $_GET["upsellcat"];
$editfixings  = $_GET["editfixings"];
//set catfilter based on selected category key
if(!empty($_POST["catfilter"])){
      $catfilter  =   $_POST["catfilter"] ;
} elseif(!empty($_GET["catkey"])){
      $catfilter  = $_GET["catkey"];
}

if ($action == "delimage") {
    $query1 = "update menuItem set imagePath = Null where itemKey =" . $itemKey ;
		mysql_query($query1);
		echo "<font color='red'>Image was deleted.</font>";
	$action = "edit";	//change action flag to edit so changed record will be displayed again
}

if ($action == "upload") {
    include('item-img.php');
    $action = "edit";	//change action flag to edit so changed record will be displayed again
	echo "<font color='red'>Image was uploaded.</font>";
}
 /*       
if(!empty($move)){  //menu item being moved up or down
        unset($previouskey);
        unset($nextkey);
        $query = "SELECT orderNum from menuItem WHERE itemKey =". $itemKey  ;  //get current ordernumber for item being moved
          $rt=mysql_query($query);
          while($nt=mysql_fetch_array($rt)){
          $ordernumber = $nt[orderNum];
        }
        mysql_close;
        
      		$query = "SELECT * from menuItem WHERE categoryKey =" . $catfilter .  " order by orderNum" ;
          $rt=mysql_query($query);
			while($nt=mysql_fetch_array($rt)){
        //echo 'itemkey: ' .$nt[itemKey] . ' - ord#: ' . $nt[orderNum]. '<br>';
            if($nt[orderNum]<$ordernumber){ //if current record is not record selected to be moved, save itemkey as previous record
                 $previouskey = $nt[itemKey];
                 $previousnum = $nt[orderNum];
                 //echo 'checkpoint 1<br>';
                 //echo 'previouskey ' . $nt[itemKey] . '<br>';
                 //echo 'previous #' . $nt[orderNum] . '<br>';
            }
            if($nt[orderNum]>$ordernumber){    //if
                  $nextkey = $nt[itemKey];
                  $nextnum = $nt[orderNum];
                  //echo 'checkpoint 2<br>';
                  break;  //go to end of loop, stop looking thru records
            }
      }     //end of loop to check through item numbers

   if($move=="dn"){
     //echo 'checkpoint 3<br>';
           if(!empty($nextkey)){
             //echo 'checkpoint 4<br>';
                 $query="Update menuItem set orderNum =" . $nextnum . " where itemKey = " . $itemKey ;
                 mysql_query($query);
                 //echo $query . '<br>';
                 $query="Update menuItem set orderNum =" . $ordernumber . " where itemKey = " . $nextkey ;
                 mysql_query($query);
                 //echo $query . '<br>';
           }
   }
   if($move=="up"){
         if(!empty($previouskey)){
                 $query="Update menuItem set orderNum =" . $previousnum . " where itemKey = " . $itemKey ;
                 mysql_query($query);
                 //echo $query . '<br>';
                 $query="Update menuItem set orderNum =" . $ordernumber . " where itemKey = " . $previouskey ;
                 mysql_query($query);
                //echo $query . '<br>';
           }
   }

}
  */
	//echo 'item key = ' . $itemKey; //(for testing)
//require_once ('config.inc');
if(!empty($choicekey)){    //if choice item key is populated, insert choice item into option table, or delete selected item
     if($deleteoption =="del"){
           $query = "Delete from options where optionkey = " . $choicekey ;
           if (!mysql_query($query)){
					echo $query;
  					die('Error: ' . mysql_error());
 			     }
     }else{
       //check for duplicate first
       $update = "Select * from options where choice = " . $editchoice . " AND parentkey = " . $itemKey . " AND itemkey = " . $choicekey ;
       $rt=mysql_query($update);          // query executed
			echo mysql_error();
       if (mysql_num_rows($rt) == 0) {


     $query = "insert into options (choice, parentkey, itemkey, price) values (" . $editchoice . ", " . $itemKey . ", " . $choicekey . ", ";
     $q2 = "Select itemPrice from menuItem where itemKey = " . $choicekey ;
     $rt=mysql_query($q2);          // query executed
			echo mysql_error();                    // if any error is there that will be printed to the screen
			while($nt=mysql_fetch_array($rt)){
            $itemprice = $nt[itemPrice];
      }
      if(empty($itemprice)){
        $itemprice=0;
      }
      $query .= "'" . $itemprice . "')";
      if (!mysql_query($query)){
					echo $query;
  					die('Error: ' . mysql_error());
 			 }

          }  else {
                //record already exists - do nothing?
          }
    }
}

if(!empty($fixingkey)){    //if fixings item key is populated, insert fixings item into fixings table, or delete selected item
     if($deleteoption =="del"){
           $query = "Delete from fixings where fixingkey = " . $fixingkey ;
           if (!mysql_query($query)){
					echo $query;
  					die('Error: ' . mysql_error());
 			     }
     }else{
       //check for duplicate first
       $update = "Select * from fixings where parentkey = " . $itemKey . " AND itemkey = " . $fixingkey ;
       $rt=mysql_query($update);          // query executed
			echo mysql_error();
       if (mysql_num_rows($rt) == 0) {


     $query = "insert into fixings (parentkey, itemkey, price) values (" . $itemKey . ", " . $fixingkey . ", ";
     $q2 = "Select itemPrice from menuItem where itemKey = " . $fixingkey ;
     $rt=mysql_query($q2);          // query executed
			echo mysql_error();                    // if any error is there that will be printed to the screen
			while($nt=mysql_fetch_array($rt)){
            $itemprice = $nt[itemPrice];
      }
      $query .= "'" . $itemprice . "')";
      if (!mysql_query($query)){
					echo $query;
  					die('Error: ' . mysql_error());
 			 }

          }  else {
                //record already exists - do nothing?
          }
    }
}
if ($action2 == "unblocksize") {
	$record = $_GET['record'];
	$delete = "delete from crust_bad_size where recordkey = '$record'";
	mysql_query($delete);

	$action = "edit";	//change action flag to edit so changed record will be displayed again
}
if ($action2 == "blocksize") {
	$record = $_GET['record'];
	$insert = "insert into crust_bad_size (itemkey, sizekey) values ('$_GET[key]', '$_GET[sizekey]')";
	mysql_query($insert);

	$action = "edit";	//change action flag to edit so changed record will be displayed again
}
if (($action == "addsize") && ($_POST['newsize'] !=="")) {
	$newsize= mysql_real_escape_string($_POST['newsize']);
	//echo $newsize . '<br>';
	
	$query = "Insert into itemSize (size, itemKey) Values ('" . $newsize . "', '" .  $itemKey  . "')";
		if (!mysql_query($query)){
					echo $query;
  					die('Error: ' . mysql_error());
 			 } else {
			//echo $query .'<br>';	//for testing 
				echo "<div align=center><font color=red>Size added successfully.</font></div>";
				$action="edit";	//reset so edit item view will be shown again after update
			}
}
if ($action == "copysize") { 
//remove existing sizes
    $query = "Delete from itemSize where itemKey = '" . $itemKey . "'";
	//echo $query."<br>";
    mysql_query($query);          // query executed
		echo mysql_error(); 		//display any error
		//copy sizes from passed in item
		$squery="Select * from itemSize where itemKey='" . $_POST["copyfrom"] . "'";
		//echo $squery."<br>";
		$srt6=mysql_query($squery);          // query executed
        while($snt6=mysql_fetch_array($srt6)){
				$query="insert into itemSize (itemKey, size, price) values ('".$itemKey ."', '". $snt6["size"] ."', '". $snt6["price"] ."')";
				mysql_query($query);          // query executed
				//echo $query."<br>";
				
			}	
		 mysql_close;
		
		$action = "edit";	//change action flag to edit so changed record will be displayed again
		echo "<div align=center><font color=red>Size table updated successfully.</font></div>";
}
if ($action == "delsize") {
    $query = "Delete from itemSize where recordKey = '" . $sizeKey . "'";
    mysql_query($query);          // query executed
		echo mysql_error(); 		//display any error
		
		$action = "edit";	//change action flag to edit so changed record will be displayed again
		echo "<div align=center><font color=red>Size table updated successfully.</font></div>";
}
if ($action == "sizeupd") {

		//this item selected for upsell, clear other in this category
		$upsellqry = "Update itemSize set upsell='0' WHERE itemKey = '" . $_GET["key"] ."'" ;
		mysql_query($upsellqry);          // query executed 
		echo mysql_error(); 		//display any error

		$query = "Update itemSize Set size = '" . $_POST['size'] . "', price = '" . $_POST['sizeprice'] . "'";

if (empty($upsell)){
			$query = $query . ", upsell='0'";
		} else {
			$query = $query . ", upsell='1'";
		}


$query = $query . " Where recordKey = '" . $sizeKey . "'";





if (!mysql_query($query)){
					echo $query;
  					die('Error: ' . mysql_error());
 			 } else {
			//echo $query .'<br>';	//for testing
				echo "<div align=center><font color=red>Size table updated successfully.</font></div>";
				
			}

$action = "edit";	//change action flag to edit so changed record will be displayed again
}
if (($action == "add") && ($_POST['newitem'] !=="")) {
			//get highest ordernum before adding new record - will increase by one and assign to new Item
			$query = "Select max(orderNum) as maxnum from menuItem";
			$rt=mysql_query($query);          // query executed 
			echo mysql_error();                    // if any error is there that will be printed to the screen
			while($nt=mysql_fetch_array($rt)){
				$highnum = ($nt[maxnum] +1);
			
				}
			if ($catfilter !=""){ //if filtered by category, add category to new item being added
				$query = "Insert into menuItem (ItemName, orderNum, categoryKey) Values ('" . mysql_real_escape_string($_POST['newitem']) . "', '" .  $highnum  . "', '". $catfilter . "')";
			} else {
			$query = "Insert into menuItem (ItemName, orderNum) Values ('" . mysql_real_escape_string($_POST['newitem']) . "', '" .  $highnum  . "')";
			}
			if (!mysql_query($query)){
					echo $query;
  					die('Error: ' . mysql_error());
 			 }
 			 $itemKey = mysql_insert_id();


			//item has been added - now change to edit mode and bring up new item to add details
			$query = "Select * from menuItem where itemKey ='" . mysql_real_escape_string($itemKey) . "'";

			$rt = mysql_query($query);
			$nt = mysql_fetch_assoc($rt);
		    $action = "edit";

      mysql_close;
		}

if ($action == "update") {
$checkbox = $_POST['chkdelete'];


	if (empty($checkbox) && !empty($_POST['Item'])) {
		//delete not checked, save other updated info


		if (isset($_POST["Item"])) {
		$query = "UPDATE menuItem SET ItemName = '" . mysql_real_escape_string($_POST['Item']) . "', Active ='";
		if (empty($active)){
			$query = $query . "0'";
		} else {
			$query = $query . "1'";
		}

		if (empty($multisized)){
			$query = $query . ", multisized='0'";
		} else {
			$query = $query . ", multisized='1'";
		}
		
		if (empty($fixings)){
			$query = $query . ", usefixings='0'";
		} else {
			$query = $query . ", usefixings='1'";
		}
		
		if (empty($freetopping)){
			$query = $query . ", freeTopping='0'";
		} else {
			$query = $query . ", freeTopping='$freetopping'";
		}
		
		if (empty($upsell)){
			$query = $query . ", upsell='0'";
		} else {
			//this item selected for upsell, clear other in this category
			$upsellqry = "Update menuItem set upsell='0' Where categoryKey = '" . $upsellcat . "'";
			mysql_query($upsellqry);          // query executed 
			echo mysql_error(); 		//display any error

			$query = $query . ", upsell='1'";
		}
		
		if (empty($upsellsizes)){
			$query = $query . ", upsellSizes='0'";
		} else {
			$query = $query . ", upsellSizes='1'";
		}
		
		if(empty($upsell_cost)){
			$query = $query . ", upsell_cost='0.00'";
		} else {
			$query = $query . ", upsell_cost='$upsell_cost'";
		}
		
		if(empty($upsell_discount)){
			$query .= ", upsell_pct_disc='0.00'";
		} else {
			$query .= ", upsell_pct_disc='$upsell_discount'";
		}
		
		if (empty($defaultcrust)){
			$query = $query . ", defaultCrust='0'";
		} else {

			//this item selected for default crust type, clear others
			$crustqry = "Update menuItem set defaultCrust='0' Where defaultCrust = '1'";
			mysql_query($crustqry);          // query executed
			echo mysql_error(); 		//display any error

			$query = $query . ", defaultCrust='1'";
		}
		
		if (empty($defaultsauce)){
			$query = $query . ", defaultSauce='0'";
		} else {

			//this item selected for default sauce type, clear others
			$sauceqry = "Update menuItem set defaultSauce='0' Where defaultSauce = '1'";
			mysql_query($sauceqry);          // query executed
			echo mysql_error(); 		//display any error

			$query = $query . ", defaultSauce='1'";
		}
		
		if (empty($taxable)){
			$query = $query . ", taxable='0'";
		} else {
			$query = $query . ", taxable='1'";
		}
		$query = $query . ", categorykey ='" . $_POST['category'] . "', description = '"
        . mysql_real_escape_string($_POST['descrip']) ."'";
        if(!empty($_POST['price'])){
           $query .= ", itemPrice='" . $_POST['price'] . "'";
        } else{
           $query .= ", itemPrice=null";
        }
        if(!empty($_POST['defcrust'])){
           $query .= ", crust='" . $_POST['defcrust'] . "'";
      }
      if(!empty($_POST['defsauce'])){
            $query .= ", sauce='" . $_POST['defsauce'] . "'";
        }
        $query .= " WHERE itemKey = '" . $_GET['key'] ."'" ;
		//echo $query  ;
		mysql_query($query) or die(mysql_error());   //execute query

		//confirmation message that delete worked...
		echo '<div align="center"><font color=red>Item updated successfully.</font></div>';
		$action="edit";   //change so that edited item will be displayed again after update

		}

	} else { 
			//delete item	
			$query = "DELETE FROM menuItem WHERE itemKey = '" . $_GET["key"] ."'" ;
			mysql_query($query) or die(mysql_error());   //execute query
			//delete any other sizes set up for item
			$query = "DELETE FROM itemSize WHERE itemKey = '" . $_GET["key"] ."'" ;
			mysql_query($query) or die(mysql_error());   //execute query

			//confirmation message that delete worked...
			if (!empty($_POST['chkdelete'])) {
				echo "<font color=red>Item deleted successfully.</font>";
			}

			die();
		}
	}	//end of update query



if ($action =="edit") {
 // echo '<div align="left"><a id="save-button" href="editmenuitem.php#add">Add New Item</a></div><br><br>';
	$query = "SELECT * from menuItem WHERE itemKey ='" . $itemKey . "'";
		//echo $query . "<br>";

		$rt=mysql_query($query);          // query executed 
		echo mysql_error();                    // if any error is there that will be printed to the screen
		echo '<div align="left"><form action="' . $_SERVER['PHP_SELF'] . '?a=update&key=' . $itemKey . '" method="post"><div class="item-info-wrapper"><table border=0 width="380px">';
		while($nt=mysql_fetch_array($rt)){
			echo '<tr><td width="100px"></td></tr>
			<tr><td valign=center>Item name: <td valign=top><input type="text" name="Item" id="Item" size="40" value="' . $nt[itemName] . '">';

			$result2 = mysql_query("SELECT categoryName, category_type, recordKey FROM menuCategory where active=1 order by categoryName");
			if (!$result2){    
				print("There was a problem getting categories: <b>" . mysql_error());    
				exit();  
			}
			$counter = 0;

			// Create the HTML code for the label and select list
			$catSelectList .= " <tr><td valign=top>Category: <td valign=top><select name='category' id='menuCategory'><option value='' size='40'> - select a category - </option>\n";
			while ($row = mysql_fetch_array($result2)){
				if ($row["recordKey"] == $nt[categoryKey]){ // add selected argument if option matches
				
					$catSelectList .= "<option value='".$row["recordKey"]."' selected='selected'>" . $row["categoryName"] . "</option>\n" ;
					$selectedcat = $row["categoryName"] ;
					$category_type = $row["category_type"] ;
					$catselection=$row["recordKey"];

				} else {
					$catSelectList .= "<option value='".$row["recordKey"]."'>" . $row["categoryName"] . "</option>\n" ;
				}
				$counter++;
				if ($row["categoryName"]=="Options")   {
				     $selectedcatkey = $row["recordKey"];
				}
				if ($row["categoryName"]=="Fixings")   {
				     $fixingcatkey = $row["recordKey"];
				}
			}
			$catSelectList .= "</select>";
		
			if ($counter == 0){
				echo "<input type=hidden name='category' value=''>";		
			}else{
				echo $catSelectList;
			}

$counter = 0;
$catSelectList = "";


	echo '<tr><td valign="top">Description: <td valign=top><textarea name="descrip" cols="43" rows="3">'
  . $nt[description] . '</textarea><tr><td><td valign=top><div align=left>';
  if (($selectedcat == "Pizza")||($category_type=='1'))  {  //if this is a pizza, show sauce and crust selectors
     //get category keys for crusts & sauces
     $squery = "Select RecordKey from menuCategory where CategoryName = 'Pizza Sauce'";
     $cquery = "Select RecordKey from menuCategory where CategoryName = 'Pizza Crust'";
      $rsq=mysql_query($squery);          // query executed
			echo mysql_error(); 		//display any error
			while($nt3=mysql_fetch_array($rsq)){
           $saucecat = $nt3["RecordKey"];
      }
      mysql_close;
      $rsq = mysql_query($cquery);          // query executed
			echo mysql_error(); 		//display any error
			while($nt3=mysql_fetch_array($rsq)){
           $crustcat = $nt3["RecordKey"];
      }
      mysql_close;
      echo '<tr><td valign=top><div align=left>Default crust: <td><select name=defcrust>';
      $query3 = "Select itemKey, itemName, defaultCrust from menuItem where categoryKey = " . $crustcat;
      $result3 = mysql_query($query3);          // query executed
			echo mysql_error(); 		//display any error
      while($nt3=mysql_fetch_array($result3)){
            echo '<option value="' . $nt3["itemKey"] . '"';
            if($nt["crust"]==$nt3["itemKey"]){
               echo 'selected="selected"';
            }elseif(($nt3["defaultCrust"]==1)&&(empty($nt["crust"]))){
              echo 'selected="selected"';
            }
            echo '>' .  $nt3["itemName"] . '</option>';
      }
      echo '</select>';
      
      mysqlclose;
      
      echo '<tr><td valign=top><div align=left>Default sauce: <td><select name=defsauce>';
      $query3 = "Select itemKey, itemName, defaultSauce from menuItem where categoryKey = " . $saucecat;
            $result3 = mysql_query($query3);          // query executed
			echo mysql_error(); 		//display any error
      while($nt3=mysql_fetch_array($result3)){
            echo '<option value="' . $nt3["itemKey"] . '"';
            if($nt["sauce"]==$nt3["itemKey"]){
               echo 'selected="selected"';
            }elseif(($nt3["defaultSauce"]==1)&&(empty($nt["sauce"]))){
              echo 'selected="selected"';
              }
            echo '>' .  $nt3["itemName"] . '</option>';
      }
      echo '</select>';

      mysqlclose;
  }
	//alow multi-size option here if not a sauce or crust category
	if (($selectedcat !=="Pizza Crust")&&($selectedcat !=="Pizza Sauce")){
		echo '<tr><td valign=top><div align=left>Multiple sizes: <td valign=top><input type="checkbox" name="chksizes"';
		if(!empty($nt[multisized])){
			echo 'checked=true';
			$multisized=1; 	//set variable here - to be used to show multiple size boxes below if this option is selected
		} else {
			$multisized=0;
		}
		echo '>';
	}
	
	//allow blocking specific sizes for pizza crusts, as many stores don't offer specialty crusts in all sizes
	if ($selectedcat =="Pizza Crust"){
		echo '<tr><td valign=top><div align=left>Unavailable Sizes: <td valign=top>';
		echo "<font color='red'><i>By default, all pizza sizes are allowed for crusts. <br>Sizes selected here will NOT be available for this crust type:</i></font><br>";
		$bad_crusts = "Select * from crust_bad_size where itemkey ='$nt[itemKey]'";
		//echo "<br>qry=" . $bad_crusts;
		$cres = mysql_query($bad_crusts);   
		while($ntres=mysql_fetch_array($cres)){
			$qry = "Select sizeName from sizeMaster where recordKey = '$ntres[sizekey]'";
			//echo "<br>qry=" . $qry;
			$qrs = mysql_query($qry);  
			while($qnt=mysql_fetch_array($qrs)){
				echo "<a href='". $_SERVER['PHP_SELF'] . "?a=edit&action2=unblocksize&record=$ntres[recordkey]&key=$nt[itemKey]' title='click to unblock this size'><font color='blue'>$qnt[sizeName] - [x]</font></a><br>";
			}
		}
		echo "<br>";
		echo "Click on a size below to disable for this crust.<br>";
		$sizes = "Select * from sizeMaster where recordKey not in(select sizekey as recordKey from crust_bad_size where itemkey ='$nt[itemKey]')";
		//echo "<br>qry=" . $sizes;
		$srs = mysql_query($sizes);
		while($ntsize=mysql_fetch_array($srs)){
			echo "<a href='". $_SERVER['PHP_SELF'] . "?a=edit&action2=blocksize&sizekey=$ntsize[recordKey]&key=$nt[itemKey]' title='click to block size'><font color='blue'>$ntsize[sizeName]</font></a><br>";
		}
		
	}
	
if (($selectedcat !=="Fixings")&&($selectedcat !=="Options")&&($selectedcat !=="Pizza Toppings")&&($selectedcat !=="Pizza Crust")&&($selectedcat !=="Pizza Sauce")){
	echo '<tr><td valign=top><div align=left>Allow Fixings: <td valign=top><input type="checkbox" name="chkfixings"';
	if(!empty($nt[usefixings])){
		echo 'checked=true';
  $fixings = 1;
	}
echo '>';
}
if ($selectedcat == "Pizza")  {


/*echo '<tr><td><td valign=top><div align=left>
  Include free toppings: <td valign=top><input type="checkbox" name="chkfreetopping"';
	if(!empty($nt[freeTopping])){
		echo 'checked=true';
		$freetopping=1; 	//set variable here - to be used to show multiple size boxes below if this option is selected
	} else {
		$freetopping=0;
	}
echo '>';
*/
echo '<tr><td valign=top><div align=left>
  Include free toppings: <td valign=top><select name="chkfreetopping">';
 $x=0;
while ($x<6){
	echo"<option value='$x'";
	if($nt[freeTopping]==$x){echo 'selected="selected"';}
	echo ">$x</option>";
	$x++;
}
echo '</select>';

}
	echo '<tr><td valign=top><div align=left>Taxable: <td valign=top><input type="checkbox" name="chktaxable"';
	if(!empty($nt[taxable])){
		echo 'checked=true';
	} 
echo '>';
	echo '<tr><td valign=top><div align=left>Active: <td valign=top><input type="checkbox" name="chkactive"';
	if(!empty($nt[active])){
		echo 'checked=true';
	} 
echo '>';
if ($selectedcat =="Pizza Crust"){      //if item is a pizza crust, show default box to set as default
                 echo '<tr><td valign=top><div align=left>Default crust: <td valign=top><input type="checkbox" name="chkdefault"';
	               if(!empty($nt[defaultCrust])){
		             echo 'checked=true';
	              }
echo '>';
	}
if ($selectedcat =="Pizza Sauce"){      //if item is a pizza sauce, show default box to set as default
                 echo '<tr><td valign=top><div align=left>Default sauce: <td valign=top><input type="checkbox" name="chkdefaultsauce"';
	               if(!empty($nt[defaultSauce])){
		             echo 'checked=true';
	              }
echo '>';
	}
	if ($selectedcat !=="Options"){
		echo '<tr><td valign=top><div align=left>Upsell: <td valign=top><input type="checkbox" name="chkupsell"';
	    if(!empty($nt[upsell])){
		    echo 'checked=true';
		}
		echo '>';
		echo '<font color="red"><i>&nbsp;&nbsp;(Select one upsell item per category. Upsell occurs at checkout.)</i></font>';
		if($multisized==1){
			echo '<tr><td valign=top><div align=left>Upsell next size: <td valign=top><input type="checkbox" name="chkupsellsize"';
			if(!empty($nt[upsellSizes])){
				echo 'checked=true';
			}
			echo '>';
			echo '<font color="red"><i>&nbsp;&nbsp;(When item added to cart, offer upgrade to next size.)</i></font>';
		}
		if(!empty($nt[upsellSizes])){	//show options for size upsell
			echo '<br><div align=left>Size upgrade flat cost: <input type="text" size="3" name="upgrade_cost" id="upgrade_cost" value="'.$nt[upsell_cost].'" onchange="updateDiscount()"> <img src="images/question.png" title="This will offer a flat upgrade cost from any one size to the next. Example: If you set the cost to $2.00, the Small to Medium upgrade is $2.00, the Medium to Large upgrade is $2.00, etc...">';
			echo '<br><div align=left>Size upgrade discount %: <input type="text" size="3" name="upgrade_discount" id="upgrade_discount" value="'.$nt[upsell_pct_disc].'" onchange="updateCost()"> <img src="images/question.png" title="This will offer a discount price when upgrading from one size to the next. Example: If a Large is $5 more than a Medium, and you set the discount percent to .5 (50%), the upgrade will be offered at $2.50. *** NOTE: The discount is a multiplier and should always be entered in decimal form. 10% should be entered as .10, NOT 10.0">';
			echo '<br><div align=left>No discount: <input type="checkbox" name="chk_nodiscount"';
			if(((empty($nt[upsell_pct_disc]))&&(empty($nt[upsell_cost])))||(($nt[upsell_pct_disc]=="0.00")&&($nt[upsell_cost]=="0.00"))){
				echo 'checked=true';
			}
			echo ' disabled="disabled">';
		}
	}
if(($multisized==1)||($selectedcat=="Options")){
	//do not display price here, need to add to each size offered
} else {
	echo '<tr><td valign=top>Price: <td valign=top>';
	 echo '<input type="text" name="price" size="7" value="' . $nt[itemPrice] . '">';
}
echo '<tr><td valign=top><div align=left>Delete:<td valign=top><input type="checkbox" name="chkdelete" value="true"><tr><td><td valign=top><div align=left><input id="save-button" type="submit" name="save" value="Save"></form></div><tr><td colspan=3>

</table></div>';
echo '<div align="left"><table border=0 width="400px"><div class="product-image-section"><h2>Product image:</h2><center>';
if(!empty($nt[imagePath])){

      echo '<br><img src="../images/menu/'.$nt[imagePath].'?'. time().'" width=150>
      <br><a href="' . $_SERVER['PHP_SELF'] . '?a=delimage&key=' . $nt[itemKey] . '"><font color="red">Remove image</font></a>';
    }
echo '</center>';
?> <!--************************BEGINNING OF IMAGE UPLOAD *************************-->
        <?php if(isset($_REQUEST['upload_message'])){?>
            <div class="upload_message_<?php echo $_REQUEST['upload_message_type'];?>">
            <?php echo htmlentities($_REQUEST['upload_message']);?>
            </div>
		<?php }


echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=upload&key=' . $nt[itemKey] . '#' . $nt[itemKey] . '" method="post" enctype="multipart/form-data" name="image_upload_form" id="image_upload_form" style="margin-bottom:0px;">
<label>Image file, maximum 4MB. it can be jpg, gif,  png:</label><br />
          <input name="image_upload_box" type="file" id="image_upload_box" size="30" /> &nbsp; 
          <input type="submit" id="update" name="submit" value="Upload image" />

     <br />
	<br />
    <input name="max_width_box" type="hidden" id="max_width_box" value="100" size="4">
      <input name="max_height_box" type="hidden" id="max_height_box" value="100" size="4">
<input name="submitted_form" type="hidden" id="submitted_form" value="image_upload_form" />
          </form></div>';
echo '</div>'; //end product-image-section

echo '<div class="sizes-offered-section">';
//add multiple size boxes here if multisized option selected
	if($multisized==1){
		$query = "SELECT recordKey, itemKey, size, price, upsell FROM itemSize WHERE itemKey ='" . $itemKey . "'";
		//echo $query . "<br>";
		echo '<div><A NAME="sizes"><h2>Sizes Offered</h2></A>';
		$rt3=mysql_query($query);          // query executed 
		echo mysql_error();                    // if any error is there that will be printed to the screen
		if (mysql_num_rows($rt3) == 0) {
			echo '<br><font color="red">No sizes have been set up yet. Please use the selector below to add new sizes.</font>';
		} else {
			echo '<br><div style="border-bottom:solid 1px #000;"> &nbsp;Upsell &nbsp;  &nbsp;Size &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Price &nbsp;  &nbsp; &nbsp; Save</div>';
			while($nt3=mysql_fetch_array($rt3)){ 
				echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=sizeupd&key=' . $itemKey . '&sizekey=' . $nt3[recordKey] . '&upsellcat='. $nt[categoryKey] . '#sizes" method="post">
				<div><input type="checkbox" name="chkupsell"';
				if(!empty($nt3[upsell])){
					echo 'checked=true';				
				} 
				echo '>&nbsp;<input type="text" name="size" size=12 maxlength=12 value="' . $nt3[size] . '" readonly="readonly">&nbsp;<input type="text" name="sizeprice" size=5 maxlength=5 value="' . $nt3[price] . '">&nbsp;<input type="submit" name="sizeupd" id="update" value="Update">&nbsp;<a href="' . $_SERVER['PHP_SELF'] . '?a=delsize&key=' . $itemKey . '&sizekey=' . $nt3[recordKey] . '#sizes" id="update">Remove</a></div></form>';
			}
		}	
	
		echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=addsize&key=' . $itemKey .'#sizes" method="post"><br>';
		//get size list
		$result2 = mysql_query("SELECT sizeName, recordKey FROM sizeMaster order by sizeName");
		if (!$result2){
			print("There was a problem getting sizes: <b>" . mysql_error());
			exit();
		}
		$counter = 0;

		// Create the HTML code for the label and select list
		$sizeSelectList .= " Available sizes: <select name='newsize'><option value='' size='10'> - select a size - </option>\n";
		while ($row = mysql_fetch_array($result2)){

				$sizeSelectList .= "<option value='".$row["sizeName"]."'>" . $row["sizeName"] . "</option>\n" ;

			$counter++;
		}
		$sizeSelectList .= "</select>";

		if ($counter == 0){
			echo "<input type=hidden name='category' value=''>";
		}else{
			echo $sizeSelectList;
		}
		$counter = 0;
		$sizeSelectList = "";
			
			//end of size list

		   echo ' <input type="submit" id="update" name="save" value="Add this Size">
				</form>';
		//add option to copy pricing from similar item - (for reference: $catfilter = selected category key)
		$priceqry = "Select * from itemSize where itemKey in(select itemKey from menuItem where categoryKey = '" . $catselection . "')";
		//echo $priceqry;
		$pqrt=mysql_query($priceqry);
		if (mysql_num_rows($pqrt) >0) {
			$sizesfound=1;
		}
		mysql_close;
		if($sizesfound==1){
		echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=copysize&key=' . $itemKey .'#sizes" method="post">Copy sizes & pricing from: <select name="copyfrom">';
		$comps = "select itemName, itemKey from menuItem where categoryKey='" . $catselection . "'";
		$crt=mysql_query($comps);
		while($cnt=mysql_fetch_array($crt)){ 
			echo"<option value='" . $cnt[itemKey] . "'>" . $cnt[itemName] . "</option>";
		}
		mysql_close;
	
		echo'</select>';
		echo' <input type="submit" id="update" value="Apply"></form>';
		}
		
		echo'</div>';
		
		
		echo'</div>';
		

		
	}
		
}
echo '</div>'; //end sizes-offered-section
echo '<div style="clear:both;width:100%;"></div><div class="choices-offered-section">';
       if (($selectedcat !=="Fixings")&&($selectedcat !=="Options")&&($selectedcat !=="Pizza Toppings")&&($selectedcat !=="Pizza Crust")&&($selectedcat !=="Pizza Sauce")){
                         //add section for user choices:
                     echo '<a name="choices"><div align="center"><h2>Choices Offered</h2></div></a>';
                       //show any existing choice lists here, split into 3 columns
                  // echo '<table width="50%">';
                   echo '<div class="sections"><u><div style="margin-bottom:2px;">Choice list 1</u></div><br>';
                       $query = "Select * from options where parentkey = " . $itemKey . " AND choice = 1";
                         $rt5=mysql_query($query);          // query executed
		                     echo mysql_error();                    // if any error is there that will be printed to the screen

		                     while($nt5=mysql_fetch_array($rt5)){
                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";
                                        $rt7=mysql_query($itemqry);          // query executed
		                                    echo mysql_error();                    // if any error is there that will be printed to the screen

		                                    while($nt7=mysql_fetch_array($rt7)){
                                        echo '<div class="item-listing">' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=1&ckey=' . $nt5[optionkey] . '&del=del&1=1#choices" title="remove"><font color="red"> (-)</font></a></div><br>';
                                      }
                                      mysql_close;
                                      
                         }
                         if ($editchoice==1){
                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $selectedcatkey . " AND active = 1";
                               $rt6=mysql_query($query);          // query executed
		                           echo mysql_error();                    // if any error is there that will be printed to the screen
                              echo '<br><br><u>Add to list 1:</u><br />';
                               while($nt6=mysql_fetch_array($rt6)){
                                 echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=1&ckey=' . $nt6[itemKey] . '&1=1#choices"><font color="blue">' . $nt6[itemName] . '</font></a><br>';
                         }
                         }else {   //add link to add more choices
                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=1&1=1#choices"><br /><font color="blue">Add choices</font></a>';
                         }
					echo '</div>';
                     echo '<div class="sections"><div style="margin-bottom:2px;"><u>Choice list 2</u></div><br>';
                        $query = "Select * from options where parentkey = " . $itemKey . " AND choice = 2";
                         $rt5=mysql_query($query);          // query executed
		                     echo mysql_error();                    // if any error is there that will be printed to the screen
                       while($nt5=mysql_fetch_array($rt5)){
                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";
                                        $rt7=mysql_query($itemqry);          // query executed
		                                    echo mysql_error();                    // if any error is there that will be printed to the screen

		                                    while($nt7=mysql_fetch_array($rt7)){
                                        echo '<div class="item-listing">' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=2&ckey=' . $nt5[optionkey] . '&del=del&1=1#choices" title="remove"><font color="red"> (-)</font></a></div><br>';
                                      }
                                      mysql_close;

                         }
                         if ($editchoice==2){
                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $selectedcatkey . " AND active = 1";
                               $rt6=mysql_query($query);          // query executed
		                           echo mysql_error();                    // if any error is there that will be printed to the screen
                              echo '<br><br><u>Add to list 2:</u><br />';
                               while($nt6=mysql_fetch_array($rt6)){
                                 echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=2&ckey=' . $nt6[itemKey] . '&1=1#choices"><font color="blue">' . $nt6[itemName] . '</font></a><br>';
                         }
                         }else {   //add link to add more choices
                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=2&1=1#choices"><br /><font color="blue">Add choices</font></a>';
                         }
						 echo '</div>';
                         echo '<div class="sections"><div style="margin-bottom:2px;"><u>Choice list 3</u></div><br>';
                       $query = "Select * from options where parentkey = " . $itemKey . " AND choice = 3";
                         $rt5=mysql_query($query);          // query executed
		                     echo mysql_error();                    // if any error is there that will be printed to the screen
                       while($nt5=mysql_fetch_array($rt5)){
                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";
                                        $rt7=mysql_query($itemqry);          // query executed
		                                    echo mysql_error();                    // if any error is there that will be printed to the screen

		                                    while($nt7=mysql_fetch_array($rt7)){
                                        echo '<div class="item-listing">' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=3&ckey=' . $nt5[optionkey] . '&del=del&1=1#choices" title="remove"><font color="red"> (-)</font></a></div><br>';
                                      }
                                      mysql_close;

                         }
                        if ($editchoice==3){
                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $selectedcatkey . " AND active = 1";
                               $rt6=mysql_query($query);          // query executed
		                           echo mysql_error();                    // if any error is there that will be printed to the screen
                              echo '<br><br><u>Add to list 3:</u><br />';
                               while($nt6=mysql_fetch_array($rt6)){
                                 echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=3&ckey=' . $nt6[itemKey] . '&1=1#choices"><font color="blue">' . $nt6[itemName] . '</font></a><br>';
                         }
                         }else {   //add link to add more choices
                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=3&1=1#choices"><br /><font color="blue">Add choices</font></a>';
                         }
                        // echo '</table>';
						echo '</div>';
                  }    //end of options section
                 echo "</div>"; 
                  //add section for fixings:
                  if($fixings==1){
                     echo '<div class="fixings-offered-section"><a name="fixings"><div align="center"><h2>Fixings Offered</h2></div></a>';
					 
					                          //display section add more toppings available for this menu item


						 
                     //display current fixings allowed
                     //echo '<table width=50% border=0><tr><td width="33%"><td width="33%"><td width="33%"><tr>';
                     $query = "Select * from fixings where parentkey = " . $itemKey;
                         $rt5=mysql_query($query);          // query executed
		                     echo mysql_error();                    // if any error is there that will be printed to the screen
                         $x=0;
		                     while($nt5=mysql_fetch_array($rt5)){
                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";
                                        $rt7=mysql_query($itemqry);          // query executed
		                                    echo mysql_error();                    // if any error is there that will be printed to the screen

		                                    while($nt7=mysql_fetch_array($rt7)){
                                        echo '<div class="item-listing_fixings">' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editfixings=1&fkey=' . $nt5[fixingkey] . '&del=del&1=1#fixings" title="remove"><font color="red"> (-)</font></a></div>';

                                        //echo 'x=' . $x;
                                        //if ($x == 2){
                                        //  echo '<br>';
                                        //  $x=0;
                                        //}
                                       //$x = $x + 1;
                                      }
                                      mysql_close;

                         }
						 
						 if ($editfixings==1){
                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $fixingcatkey . " AND active = 1";
                               $rt6=mysql_query($query);          // query executed
		                           echo mysql_error();                    // if any error is there that will be printed to the screen
                              echo '<br><br><div align="center"><u>Add to toppings available:</u></div>';
                              //echo '<table width=100% border=0><tr><td width="33%"><td width="33%"><td width="33%"><tr>';
                              $x=0;
                               while($nt6=mysql_fetch_array($rt6)){
                                 echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editfixings=1&fkey=' . $nt6[itemKey] . '&1=1#fixings"><font color="blue">' . $nt6[itemName] . '</font></a><br>';
                                  //if ($x == 2){
                                  //        echo '<br>';
                                  //        $x=0;
                                   //     }
                                   //    $x = $x + 1;
                         }
                         }else {   //add link to add more choices
                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editfixings=1&1=1#fixings"><font color="blue"><br />Add Fixings</font></a>';
                         }
						 
                         echo '</div>';

echo '</div>'; //end choices-offered-section
                         //echo '</table><hr>';
                  }
} else { //$action is NOT = "edit"

	echo '<div id="single-admin-button">
	<ul>
	<a href="index.php"><li>BACK TO HOME ADMIN</li></a>
	<!--<a href="#add"><li>ADD NEW ITEM</li></a>-->
	</ul>
	</div>';

	// Select all categories
	$categories = array();
	$sql = "SELECT categoryName, recordKey 
			FROM menuCategory 
			WHERE active = 1 
			ORDER BY categoryName";

	$categoriesResult = mysql_query($sql) or die(mysql_error());

	while ($row = mysql_fetch_assoc($categoriesResult)) {
		$row['menu_items'] = array(); // Place holder for menu items
		$categories[$row['recordKey']] = $row;
	}

	// Delete menu items where name is empty
	$sql = "DELETE FROM menuItem WHERE ItemName = ''";
	mysql_query($sql) or die(mysql_error());

	// Get all menu items
	$menuItems = array();
	$sql = "SELECT itemKey, ItemName, active, orderNum, categoryKey, itemPrice, description, taxable 
			FROM menuItem
			ORDER BY orderNum";

	$menuItemsResult = mysql_query($sql) or die(mysql_error());

	while ($row = mysql_fetch_assoc($menuItemsResult)) {
		if (array_key_exists($row['categoryKey'], $categories)) {
			$categories[$row['categoryKey']]['menu_items'][] = $row;
		}
	}

	echo '<form id="form-menu-items" action="' . $_SERVER['PHP_SELF'] . '?a=filter" method="post">';
	echo '<div class="arrowlistmenu">';
	foreach ($categories as $categoryKey => $category) {
		echo "<h3 class='menuheader expandable'>".$category['categoryName']."</h3>";	
		echo'<ul class="categoryitems">';
		echo '<li>';

		echo '<div align="center">';
		
		echo '<table  class="menu-items" border=0 cellpadding=3 cellspacing=0>';
		echo '<tr>';
		//echo '<td width="70"><div align=left><u><b><font face="verdana, arial" size=2>Move</u></b></div></td>';
		echo '<td valign=top width="200"><div align="left"><u><b><font face="verdana, arial" size=2>Item name</u></b></div></td>';
		echo '<td valign=top width="430"><font size=2 face="verdana, arial"><div align=left><u><b>Description</u></b></div></font></td>';
		echo '<td valign=top width="40"></td>';
		echo '</tr>';
		echo '</table>';


		//echo '<div class="item-button-area">';
		echo '<table  class="menu-items" border=0 cellpadding=3 cellspacing=0>';
		foreach ($category['menu_items'] as $menuItem) {
			echo '<div class="item-button-area"><tr class="item-row-background">';
			//echo '<td id="item-data-left" align="left" width="70">&nbsp;<!--<img class="handle" src="http://www.pilotwebs.com/images/icon-drag.png" />-->';
			echo '<input type="hidden" name="menu_items_order[]" value="'.$menuItem['itemKey'].'" />';

			echo '<td valign=center width="200" id="item-data-left"><div align="left"><p><span id="menu-item-name-'.$menuItem['itemKey'].'">' . $menuItem['ItemName']  .'</span></p></td>';

			echo '<td valign=center width="430" id="item-data-right"><p style="font-size:12px;"><span id="menu-item-description-'.$menuItem['itemKey'].'">' . $menuItem['description']  .'</span></p></td>';
			echo '<td width="40" style="background:#fff;">';
			// echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=edit&key=' . $menuItem['itemKey'] . '" method="post">';
			echo '<input id="save-button" style="margin-bottom:3px;margin-left:5px;" class="popup edit-menu-item edit-menu-item-'.$menuItem['itemKey'].'" data-popup-id="'.$menuItem['itemKey'].'" data-cat-key="'.$menuItem['categoryKey'].'" type="submit" name="edit" value="Edit" /> ';
			// echo '</form>';

			echo "
				<div class='toPopDiv menu-item' id='popup_".$menuItem['itemKey']."'> 
					<div class='close'></div>
					<span class='ecs_tooltip'>Esc to close <span class='arrow'></span></span>
					<iframe class='menu-item-iframe edit' id='iframe-".$menuItem['itemKey']."' data-menu-id='".$menuItem['itemKey']."' src=''></iframe>
				</div> <!--toPopup end-->
			";
			echo '</td>';
			echo '</tr></div><tr class="item-row-spacer"><td colspan="4"></td></tr>';
				
		}
		echo '<tr><td colspan="4"></td></tr><tr><td style="text-align:center;><a class="popup add-menu-item" id="save-button" class="popup add-menu-item" data-popup-id="add" data-cat-key="'.$categoryKey.'">New Item</a></td><td colspan="2"></td></tr></table>';
		//echo '</div>';
		
	//	echo '<div align="right" style="text-align:center;"><a class="popup add-menu-item" id="save-button" class="popup add-menu-item" data-popup-id="add" data-cat-key="'.$categoryKey.'">New Item</a></div>';
		echo '</div>';

		echo '</li>';
		echo '</ul>';
	}
	// Add menu item popup
	echo "
		<div class='toPopDiv menu-item' id='popup_add'> 
			<div class='close'></div>
			<span class='ecs_tooltip'>Esc to close <span class='arrow'></span></span>
			<iframe class='menu-item-iframe' id='iframe-add' src=''></iframe>
		</div> <!--toPopup end-->
	";

	// Popup background
	echo "
			<div class='loader'></div>
			<div id='backgroundPopup'></div>
			<input id='cur-popup-id' type='hidden' value='' />";

	echo '</div>'; // end .arrowlistmenu
	echo '</form>';
	?>
	<script type="text/javascript">
		// Return a helper with preserved width of cells
		var fixHelper = function(e, ui) {
			ui.children().each(function() {
				$(this).width($(this).width());
			});
			return ui;
		};

		var currentMenuItemSettings = [];

		$(document).ready(function() {
			// set up interval to check for session expiration
			window.setInterval(function() {
				checkForSessionExpire();
			}, 30000);

			$(".menu-items tbody").sortable({
				helper: fixHelper,
				update: function(event, ui) {
					resetRowSpacers();
					updateMenuItemsOrder();
				}
			}).disableSelection();

			$('.popup.edit-menu-item').click(function() {
				var popupId = $(this).data('popup-id');
				loadCurrentSettings(popupId);
				$('#iframe-'+popupId).attr('src', 'editmenuitemiframe.php?a=edit&key='+popupId);
			});

			$('.popup.add-menu-item').click(function() {
				var popupId = $(this).data('popup-id');
				var catKey = $(this).data('cat-key');

				$.ajax({
					type: 'GET',
					url: 'editmenuitemiframe.php?jquery_action=add&catkey='+catKey
				}).done(function(response) {
					console.log(response);
					if (response != '0') {
						menuItemId = response;
						loadCurrentSettings(menuItemId);
						$('#iframe-'+popupId).attr('src', 'editmenuitemiframe.php?a=edit&key='+menuItemId);
						$('#iframe-'+popupId).data('menu-id', menuItemId);
					}
				});
			});

			$('#backgroundPopup, .toPopDiv .close').click(function() {
				var currentPopupId = $("#cur-popup-id").val();
				if (currentPopupId.length > 0) {
					if (currentPopupId == 'add') {
						location.reload();
					} else {
						updateItemDetails(currentPopupId);
					}
				}
			});

			$('.menu-item-iframe').load(function() {
				var iframeLocation = $(this).get(0).contentWindow.location.search;
				if (iframeLocation.indexOf("a=update") > -1) {
					updateItemDetails($(this).data('menu-id'));
				} else {
					loadCurrentSettings($(this).data('menu-id'));
				}
			});
		});

		function loadCurrentSettings(menuItemId) {
			$.ajax({
				type: 'GET',
				url: 'editmenuitemiframe.php?jquery_action=details&id='+menuItemId
			}).done(function(response) {
				if (response != '0') {
					response = $.parseJSON(response);
					currentMenuItemSettings = response;
				}
			});
		}

		function resetRowSpacers() {
			var spacerEl = $('.item-row-spacer').clone();
			$('.item-row-spacer').remove();
			$('.item-row-background').after('<tr class="item-row-spacer"><td colspan="4"></td</tr>');
		}

		function updateMenuItemsOrder() {
			$.ajax({
				type: 'POST',
				url: 'save_menu_items_order.php',
				data: $('#form-menu-items').serialize()
			}).done(function(response) {
				if (response != '1') {
					alert('Error updating menu items order.');
				}
			});
		}
		function updateItemDetails(menuItemId) {
			$.ajax({
				type: 'GET',
				url: 'editmenuitemiframe.php?jquery_action=details&id='+menuItemId
			}).done(function(response) {
				if (response != '0') {
					response = $.parseJSON(response);
					console.log(response);
					if ($('#menu-item-name-'+menuItemId).length > 0) {
						if (response.hasOwnProperty('categoryKey')) {
							console.log('yes');
							var category = response.categoryKey;
							var currentCategory = $('.edit-menu-item-'+menuItemId).data('cat-key');
							if (currentCategory != category) {
								location.reload();
							}
						}
						if (response.hasOwnProperty('itemName')) {
							var name = response.itemName;
							$('#menu-item-name-'+menuItemId).text(name);
						}
						if (response.hasOwnProperty('description')) {
							var description = response.description;
							$('#menu-item-description-'+menuItemId).text(description);
						}

						// check if popup should be closed
						if ((currentMenuItemSettings.multisized == 0 && response.multisized != currentMenuItemSettings.multisized) || (currentMenuItemSettings.usefixings == 0 && response.usefixings != currentMenuItemSettings.usefixings)) {
							// don't disable popup
						} else {
							disablePopup();
						}
					} else {
						console.log('no');
						if ((currentMenuItemSettings.multisized == 0 && response.multisized != currentMenuItemSettings.multisized) || (currentMenuItemSettings.usefixings == 0 && response.usefixings != currentMenuItemSettings.usefixings)) {
							// don't disable popup
						} else {
							location.reload();
						}
					}

				} else {
					location.reload();
				}
				loadCurrentSettings(menuItemId);
			});
		}

		function disablePopup() {
				if(popupStatus == 1) {
					var popDivs = $(".toPopDiv");
					
					$.each(popDivs,function(){
						$(this).fadeOut("normal");
					});
					
					//$("#toPopup_"+idNum[0]).fadeOut("normal");  
					$("#backgroundPopup").fadeOut("normal");
					popupStatus = 0;  // and set value to 0
			}
		}

		function checkForSessionExpire() {
			if (popupStatus == 0) return false;

			$.ajax({
				type: 'GET',
				url: 'checkifloggedin.php'
			}).done(function(response) {
				if (response != '1') {
					// disablePopup();
					location.reload();
					return true;
				} else {
					return false;
				}
			});
		}
	</script>
	<?php

	echo '<div align="center">';

	//echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=add" method="post">Add new Item' ;


	//echo ': <a name="add"></a><br><input type="text" name="newitem" size=50><input type="hidden" name="catfilter" value="' . $catfilter . '"><input id="save-button" type="submit" name="save" value="Save"></form>';
	echo '</div></div>';


} 	//end of 'edit' loop
		

//	echo '<div align="center"><br><a href="index.php"><font color="blue">Back to Main Admin Page</font></a>
// <br><a href="editmenucat.php"><font color="blue">Edit Categories</font></a><br><a href="editmenuitem.php"><font color="blue">Edit Menu Items</font></a>
// </div></div>';
	

	

?>
<script>
function updateDiscount() {
	//alert('test');
	var elem = document.getElementById("upgrade_discount");
	elem.value = "0.00";	
};

function updateCost(){
	//alert('test2');
	var percentage = document.getElementById("upgrade_discount");
	if(percentage.value >1) {
		percentage.value = percentage.value/100;
	}
	var elem = document.getElementById("upgrade_cost");
	elem.value = "0.00";		
};
</script>
<script>$("#itemsort").sortable({
    axis: 'y',
    stop: function (event, ui) {
        var data = $(this).sortable("serialize").toString();
		var idsInOrder = $(this).sortable("toArray").toString();
		//alert(idsInOrder); //popup alert to show data for testing		
		//var elem = document.getElementById("results").value = idsInOrder;	//update results input field for testing
        $.ajax({
            data: data,
            type: 'POST',
            url: 'save_item_order.php'
        });
    }
});
</script>

Youez - 2016 - github.com/yon3zu
LinuXploit