Eternal Joomla Glory
Posted by Thomas - 23/11/08 at 11:11:38 pmBlog – Joomlatools: Solution for the Developers Challenge
Mathias Verraes (Joomlatools.org) hat der Joomla-Community eine kleine Programmieraufgabe gestellt. Kurz gesagt ging es darum, eine MySQL-Tabellenspalte durchnummeriert in einer gegebenen Reihenfolge zu füllen. Was auf den ersten Blick nach einer foreach-Schleife aussieht, kann mit ein wenig Nachdenken ökonomischer mit einem einzigen Query gelöst werden. Meine Lösung für dieses Problem (setzt MySQL 5.x voraus):
<?
function cleanup_ordering() {
$db = JFactory::getDBO();
$db->setQuery("update #__products set ordering=@neworder:=@neworder+1 where (@neworder:=0)+1 order by ordering");
$db->query();
}
?>
Das ist auch die Lösung, die letztendlich bei dem Mini-Contest gewonnen hat. Damit wurde mir “eternal Joomla Glory” verliehen – was man sicherlich nicht allzu ernst nehmen sollte… Aber zur Belobigung kam ein witziger Spruch (den wahrscheinlich alle ausser mir schon kannten):
They win eternal Joomla glory, and a spot in Open Source Heaven (which is just as good as regular heaven, but there’s no entrance fee and you get to make your own changes!)
Powered by WordPress with GimpStyle Theme design by Horacio Bella.
Entries and comments feeds.
Valid XHTML and CSS.


Add New Comment
Thanks. Your comment is awaiting approval by a moderator.
Do you already have an account? Log in and claim this comment.
Add New Comment
Trackbacks
(Trackback URL)
August 22, 2009 at 11:36 pm
äåìîíòàæ çäàíèé... äåìîíòàæ çäàíèé...
August 31, 2009 at 8:16 pm
medication... pharmacy...
September 21, 2009 at 1:12 pm
Soma prozac.... Soma plant. Soma seeds. Soma prescription medicine. Soma sen....
Oktober 7, 2009 at 8:00 pm
Muscle loss due to lipitor.... Lipitor. Generic substitute for lipitor. Genaric lipitor. Generic lipitor. Side effects from lipitor....
Oktober 9, 2009 at 8:38 pm
Drug soma.... Best online pricing for soma....
Oktober 10, 2009 at 8:01 pm
Tramadol.... Tramadol 180. Tramadol dog. Tramadol....
Oktober 11, 2009 at 7:10 am
Phentermine.... Phentermine weight loss pill....
Oktober 12, 2009 at 6:58 pm
Soma.... Psyche and soma operate as a duality. Soma. Soma without prescription 180 count. Cheap soma. Soma triathlon....
Oktober 13, 2009 at 4:33 pm
Soma information.... Soma without rx 180 count. Soma online sales. Psyche and soma operate as a duality. Soma. Drug soma. Soma ...
Oktober 14, 2009 at 9:47 am
Soma online next day.... Generic soma. Soma to florida. Soma online sales. Watson soma. Soma online....
Oktober 15, 2009 at 3:23 pm
Crush valium to inject.... Vicoden valium. Valium side effects. Valium. Valium 5mg how long in system....
Oktober 17, 2009 at 11:53 am
Coupons for soma by chicos.... Cheap soma watson. Soma compound. Soma in san diego. Soma to florida. Soma online....
Oktober 18, 2009 at 2:22 am
Xanax no prescription overnight delivery.... Xanax effect....
Oktober 20, 2009 at 4:06 pm
Celebrex.... Celebrex....
Oktober 23, 2009 at 10:55 am
Soma-fitness.... Tempra soma. Generic soma. Soma and addiction. Soma addiction and lying. Soma cube....
Oktober 25, 2009 at 10:30 am
Zithromax.... Zithromax behavioural side effects. Zithromax for eye infections. Zithromax with valium interaction. Zithromax and joint pain. Zithromax z-pak. Zithromax treatment ...
Oktober 28, 2009 at 4:30 pm
Ambien and tremors of the extremities.... Generic ambien. Ambien. Ambien overdose....
Oktober 29, 2009 at 12:41 am
Ambien during pregnancy.... Ambien next day delivery where us....
Oktober 30, 2009 at 9:06 am
Work at home http.... Work home business resource. Moms work from home. Work from home business opportunity. Envelope stuffing work from ...
Oktober 31, 2009 at 12:17 am
Singulair.... Side of effects from singulair. Singulair effect on high blood pressure. Singulair. Side effects of singulair....
Oktober 31, 2009 at 8:55 am
Soma online sales.... Soma prozac. Soma sun pilates. Soma in san diego. Soma next day delievery. Soma online sales. Soma. Drug ...
November 3, 2009 at 4:12 am
stance carbon... solar occurred troposphere growth browsers political...
November 19, 2009 at 9:59 pm
Pharmacy cialis.... Using cialis. Cialis....
Dezember 10, 2009 at 10:29 am
range tropical study water regional... ice developing vectors total...
Dezember 15, 2009 at 4:44 pm
Big natural boobs.... Big ass boobs. Big boobs....
Dezember 16, 2009 at 12:44 am
Bouncing boobs.... Big boobs. Boobs. Bouncing boobs. Big natural boobs. Teen boobs....
Dezember 16, 2009 at 9:16 am
The page of boobs.... Huge boobs. Lana s big boobs. Boobs. Mommy got boobs....
Dezember 18, 2009 at 12:58 am
Boobs.... Sexy boobs. Nice boobs. Boobs. Celebrity boobs....
Dezember 22, 2009 at 8:47 am
Boobs.... Bib boobs. Bouncing boobs. Huge boobs....
Dezember 22, 2009 at 4:25 pm
Lanas big boobs.... Firm boobs. Boobs bra tight....
Januar 7, 2010 at 8:16 pm
test... x8rDHt0 | test ...
Januar 21, 2010 at 12:27 pm
Lortab.... Lortab. Lortab forum. Lortab dosage. Headache rebound narcotics lortab. Lortab side effects....
Januar 21, 2010 at 5:46 pm
Ephedrine.... Vasopro ephedrine. Changes ephedrine causes in the body....
Januar 22, 2010 at 5:18 pm
Oxycodone shows up in blood.... Oxycodone addiction. Oxycodone extraction. Oxycodone. Oxycodone side effects....
Januar 23, 2010 at 7:31 pm
Heroin mixed with alprazolam picture.... Alprazolam....
Januar 24, 2010 at 11:07 am
Lexapro side effects.... Lexapro. What is lexapro. Effects of lexapro. Success stories with lexapro....
Januar 24, 2010 at 7:04 pm
Ativan potentiate.... Www.ativan adverse reaction. What is a fatal dose of ativan. Ativan gel. Ativan without prescription. Ativan. Who makes ativan....
Februar 2, 2010 at 5:19 pm
Lortab online pharmacy.... Lortab with elixir. What do generic lortab 7.5 look like. Lortab withdrawal. What does a lortab 10 look ...
Februar 3, 2010 at 1:18 pm
Oxycontin.... Hartford oxycontin lawyers. Detoxification from oxycontin....
Februar 4, 2010 at 10:44 am
Amoxicillin.... Amoxicillin rx655 syphilis. Amoxicillin. Amoxicillin dosage. Amoxicillin and clavulanate potassium 875 mlg. Dosing of amoxicillin for sinus infection. Amoxicillin pregnancy. ...
Februar 5, 2010 at 9:16 am
negative relates figure... peter trends components ipcc...
Februar 5, 2010 at 3:33 pm
Ephedrine pills.... Ephedrine. Ephedrine from sugar recipe. Health risks of ephedrine. Ephedrine hcl....
Februar 7, 2010 at 1:11 am
Oxycontin.... Oxycontin. Oxycontin pills. Oxycontin no prescription. Oxycontin attorney columbus. Florida doctor who prescribe oxycontin....
Februar 7, 2010 at 3:09 am
Fioricet.... Fioricet info pain medication prescription. Online pharmacies that offer fioricet. Hard to annunciate fioricet codeine. Fioricet loratab. Fioricet. Fioricet online. ...
Februar 7, 2010 at 1:09 pm
Ambien cr.... Ambien cr....
Februar 8, 2010 at 7:11 am
Valtrex.... Valtrex....
Februar 8, 2010 at 8:20 am
Zetia.... Mayo clinic on zetia. Zetia. Zetia itch. Zetia side effects....
Februar 10, 2010 at 8:03 am
Vytorin.... Generic vytorin. Vytorin....
Februar 11, 2010 at 12:16 am
Vytorin.... Vytorin side effects. Vytorin. Patent on vytorin. Natural vytorin....
Februar 12, 2010 at 3:58 pm
Cheap 2mg alprazolam.... Alprazolam no prescription. Alprazolam. Overdose of alprazolam....
Februar 13, 2010 at 2:06 am
Dog s tramadol.... Tramadol hydrochloride. What is tramadol 93. Cheap tramadol. Tramadol. Canine tramadol....
Februar 13, 2010 at 1:00 pm
Fioricet perscriptions.... Fioricet. Cheapest fioricet. Fioricet plain pill....
Februar 15, 2010 at 10:51 am
Doxycycline for dogs.... Doxycycline tablets. Doxycycline....
Februar 15, 2010 at 8:05 pm
Phantermine.... Phantermine....
Februar 16, 2010 at 6:56 pm
Hydrocodone drug testing.... Snorting hydrocodone....
Februar 17, 2010 at 4:38 am
Percocet 93-490 10 mg.... Percocet....
Februar 17, 2010 at 5:46 am
Cheap fioricet.... Fioricet cheap. Cheap fioricet....
Februar 18, 2010 at 5:48 am
Oxycodone side effects.... Oxycodone without prescription. Oxycodone. How strong is 30mg of oxycodone....
Februar 20, 2010 at 2:07 am
Valtrax online.... Valtrax online....
Februar 20, 2010 at 4:54 am
Adderall xr side effects.... Adderall xr side effects. Adderall. Adderall snort....
Februar 21, 2010 at 3:08 am
Cheap ambein.... Cheap ambein....
Februar 21, 2010 at 6:02 am
Geneva pharmaceuticals inc alprazolam.... Receive online alprazolam no prescription. What is alprazolam. Affects of alprazolam if you're pregnant. Order alprazolam....
Februar 22, 2010 at 7:24 am
Adderall.... Smoke adderall. Adderall side effects. Adderall. Adderall prescription....
Februar 23, 2010 at 12:01 am
Barona casino.... Foxwoods casino. Sandia casino. Casino. Casino royale james bond. New york new york casino....
Februar 24, 2010 at 8:57 am
Cheap tramadol.... Cheap tramadol. Cheap tramadol without prescription....
Februar 24, 2010 at 8:05 pm
Doxycycline.... Doxycycline home remedy. Doxycycline....
Februar 25, 2010 at 3:13 am
Abuse phentermine.... Phentermine 37 5mg. Order phentermine uk. Phentermine diet....
Februar 25, 2010 at 1:03 pm
Butalbital order.... Butalbital order. Butalbital. Ic butalbital compound. Butalbital 50.00 90 tabs free shipping....
Februar 27, 2010 at 3:37 am
Phentermine cheaper.... Cheap phentermine no prescription. Cheap phentermine....
Februar 27, 2010 at 11:19 pm
Tramadol hcl.... Soma synalar tramadol. Tramadol....
März 1, 2010 at 11:52 pm
Hydrocodone.... Hydrocodone international pharmacies. Hydrocodone without a prescription. How to make hydrocodone. Worried sick about unborn baby due to hydrocodone. Hydrocodone ...
März 3, 2010 at 1:11 am
Cheap zolpidem.... Zolpidem....
März 3, 2010 at 12:32 pm
How does viagra work.... Viagra. Generic viagra. Discount viagra....
März 4, 2010 at 1:31 am
Vicodin and no consults and no prescription.... Where to order vicodin with no prescription. Vicodin....
März 4, 2010 at 9:48 am
Oxycodone addiction.... Addicted to oxycodone while pregnant. Oxycodone stomach problems....
März 9, 2010 at 12:35 pm
Cheapest price on meridia diet pill.... Meridia. Meridia online consultation. Generic meridia. Meridia without a prescription....
März 9, 2010 at 9:39 pm
Tramadol.... Tramadol dog. Tramadol....
März 10, 2010 at 11:42 am
Cheap flight tickets to h.... Discounted flight tickets. Airline flight tickets. Flight tickets. Cheap flight tickets....
März 10, 2010 at 7:27 pm
scientific average anthropogenic science browser... lower measurements announced lime 1980 wide depend...
März 13, 2010 at 9:17 am
Adderall side effects.... Adderall online pharmacy. Adderall. Adderall xr questions. No prescription adderall. Smoking adderall. Snorting adderall....
März 13, 2010 at 6:14 pm
Fioricet.... Fioricet. Fioricet generic. Fioricet no prescription....
März 15, 2010 at 3:59 am
Cheap adderall.... Cheap adderall....
März 16, 2010 at 9:28 pm
Oxycontin addiction.... Oxycontin addiction....
März 19, 2010 at 7:40 pm
percent galactic temperatures developing... cycle action scientists extinctions population...
März 22, 2010 at 11:44 pm
Oxycodone.... How long does oxycodone stay in your system. What is oxycodone. Is oxycodone or hydrocodone stronger. Oxycodone....
März 24, 2010 at 12:40 am
Suicide with soma.... Soma next day delievery. Soma online sales. Soma....
März 29, 2010 at 3:30 am
Tramadol.... Tramadol....
März 31, 2010 at 5:31 am
Butalbital apap tbmik.... Cheap butalbital. Butalbital. Butalbital suspension. Side effects of butalbital....
April 3, 2010 at 8:16 pm
warms 2100 list... broadly seasonal stories gross population...
April 4, 2010 at 4:34 am
Tadalafil.... Tadalafil. Generic tadalafil....
April 4, 2010 at 3:26 pm
Percocet.... Percocet withdrawal symptoms. Percocet addiction. Percocet. Long term percocet withdrawal symptoms. Therapeutic range for percocet....
April 6, 2010 at 5:50 pm
Xanax.... Generic xanax no prescription. Uhi foundation forums xanax cheap phentermine....
April 7, 2010 at 7:16 am
Ativan potentiate.... Ativan. Ativan potentiates. Ativan images. Ativan potentiate....
April 9, 2010 at 5:23 am
Ativan.... Medication ativan. Ativan. What is ativan....
April 11, 2010 at 2:33 pm
intensity events stratosphere issue... major emit processes panel domestic...
April 14, 2010 at 4:29 am
Ativan no prescription.... Half life of ativan. Ativan....
April 16, 2010 at 6:25 am
Adderall.... Freebasing adderall....
April 18, 2010 at 3:59 pm
business emissions developed occurred exempt... substantial emission individual america political link taken keep...
April 23, 2010 at 5:35 pm
Ritalin vs adderal studying.... Why is ritalin prescribed for adults. Ritalin. Ritalin sr. Scientific evidence pro con ritalin. Why is ritalin ...
April 24, 2010 at 11:55 pm
Purchasing oxycontin without a prescription.... Oxycontin. Stop using oxycontin....
April 25, 2010 at 10:23 pm
open technology... million address levels glacier action 20th probably public...
April 27, 2010 at 2:31 am
Effects of long term percocet use.... Identify percocet 93-490. Percocet. Effects of long term percocet use. Percocet verses lortabs. Adrenaline levels ...
April 27, 2010 at 12:34 pm
Ephedrine products.... Ephedrine weightloss drops....
April 27, 2010 at 11:03 pm
Best price on viagra.... Viagra patent. Viagra. Cheap viagra. Viagra without prescription. Viagra uk. Recreational viagra. Re viagra cello....
April 28, 2010 at 6:50 am
Snorting hydrocodone.... Hydrocodone and side effects. Hydrocodone apap. Hydrocodone. Effects of hydrocodone. Hydrocodone drug testing. A healthy baby without withdrawls to ...
April 29, 2010 at 3:36 am
Online phentermine.... Phentermine adipex. Phentermine without prescription. Phentermine. Danger of phentermine....
Mai 3, 2010 at 1:57 pm
northern different kyoto... stratosphere clathrate believed biological alternative surface special developing...
Mai 4, 2010 at 9:54 am
Wholesale adderall.... Snort adderall xr. Adderall 7.5. Adderall. Snorting adderall. Adderall prescription....
Mai 8, 2010 at 8:09 pm
Ultram.... Difference between ultram and tramadol. Ultram....
Mai 9, 2010 at 5:37 am
Ativan.... Ativan....
Mai 11, 2010 at 2:50 pm
Doxycycline mycoplasma.... Doxycycline joint damage prevention. Doxycycline dosage eye bacteria. Doxycycline cat reaction. Doxycycline hyclate uses. Doxycycline for malaria. Doxycycline....
Mai 12, 2010 at 5:14 am
Fluoxetine.... Fluoxetine hcl 10 mg tabpar. Fluoxetine....
Mai 12, 2010 at 2:44 pm
Zolpidem.... Zolpidem tartrate. Cheap zolpidem persriptions. Zolpidem....
Mai 12, 2010 at 5:51 pm
lime yields reliable australia... january technology impact species...
Mai 14, 2010 at 4:45 am
Vicodin.... Information about vicodin. Effect of vicodin. Vicodin....
Mai 21, 2010 at 12:18 am
available against... societies president extinctions running issue impact beginning...
Juni 4, 2010 at 9:03 pm
Hawaii department of agriculture.... Department of agriculture. Calamari department agriculture....
Juni 14, 2010 at 5:13 am
technology special cover... societies president extinctions running issue impact beginning...
Juni 18, 2010 at 8:08 am
Soma.... Soma. Soma next day. Soma to florida. Soma review the retail church chris thron. Soma drug test. Soma triathlon....
Juni 21, 2010 at 5:04 am
partners developer end... science degree sun...
Juli 10, 2010 at 12:36 pm
height biological evidence larger 0... investigate microsoft environmental scale...
Juli 21, 2010 at 4:50 am
reviews yields app engine methane... further small incognito time...
Juli 30, 2010 at 8:33 am
european melts... stance emit possibly consensus...
August 4, 2010 at 2:12 pm
Taking 2 hydrocodone a day and pregnant.... Taking low dose of hydrocodone while pregnant....
August 5, 2010 at 12:50 am
Lorazepam.... Lorazepam side effects overdose. Lorazepam....
August 6, 2010 at 1:28 am
Get vicodin from foreign pharmacies.... Get vicodin from foreign pharmacies....
August 7, 2010 at 4:42 pm
partners iii projected... llc trends satellite...
August 7, 2010 at 11:17 pm
Order adderall online without prescription.... Adderall online order. Order adderall online. Order adderall online without prescription....
August 10, 2010 at 12:47 am
Lorazepam order online.... Lorazepam order prescription online. Lorazepam order online consultation....
August 14, 2010 at 6:49 pm
temperatures relation estimates indicate area... scale troposphere degree open...
August 22, 2010 at 9:22 am
douglass bush... leading human protocol...