Eternal Joomla Glory

Posted by Thomas - 23/11/08 at 11:11:38 pm

Blog – 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!)


 

Trackbacks

(Trackback URL)

  • äåìîíòàæ çäàíèé

    August 22, 2009 at 11:36 pm

    äåìîíòàæ çäàíèé... äåìîíòàæ çäàíèé...

  • medication

    August 31, 2009 at 8:16 pm

    medication... pharmacy...

  • Soma.

    September 21, 2009 at 1:12 pm

    Soma prozac.... Soma plant. Soma seeds. Soma prescription medicine. Soma sen....

  • Lipitor fibromyalgia.

    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....

  • Soma sonic music.

    Oktober 9, 2009 at 8:38 pm

    Drug soma.... Best online pricing for soma....

  • Tramadol sr 100.

    Oktober 10, 2009 at 8:01 pm

    Tramadol.... Tramadol 180. Tramadol dog. Tramadol....

  • Phentermine online.

    Oktober 11, 2009 at 7:10 am

    Phentermine.... Phentermine weight loss pill....

  • Soma.

    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....

  • Soma without rx 180 count.

    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 ...

  • Soma plant.

    Oktober 14, 2009 at 9:47 am

    Soma online next day.... Generic soma. Soma to florida. Soma online sales. Watson soma. Soma online....

  • Valium.

    Oktober 15, 2009 at 3:23 pm

    Crush valium to inject.... Vicoden valium. Valium side effects. Valium. Valium 5mg how long in system....

  • Soma.

    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....

  • Xanax.

    Oktober 18, 2009 at 2:22 am

    Xanax no prescription overnight delivery.... Xanax effect....

  • Celebrex.

    Oktober 20, 2009 at 4:06 pm

    Celebrex.... Celebrex....

  • Soma without rx.

    Oktober 23, 2009 at 10:55 am

    Soma-fitness.... Tempra soma. Generic soma. Soma and addiction. Soma addiction and lying. Soma cube....

  • Tetracycline discoloration zithromax.

    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 ...

  • Ambien generic from india appearance.

    Oktober 28, 2009 at 4:30 pm

    Ambien and tremors of the extremities.... Generic ambien. Ambien. Ambien overdose....

  • Generic ambien.

    Oktober 29, 2009 at 12:41 am

    Ambien during pregnancy.... Ambien next day delivery where us....

  • Business opportunity home based work from.

    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 ...

  • Singulair.

    Oktober 31, 2009 at 12:17 am

    Singulair.... Side of effects from singulair. Singulair effect on high blood pressure. Singulair. Side effects of singulair....

  • Soma.

    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 ...

  • stance carbon

    November 3, 2009 at 4:12 am

    stance carbon... solar occurred troposphere growth browsers political...

  • Cialis uk suppliers.

    November 19, 2009 at 9:59 pm

    Pharmacy cialis.... Using cialis. Cialis....

  • range tropical study water regional

    Dezember 10, 2009 at 10:29 am

    range tropical study water regional... ice developing vectors total...

  • Big ass boobs.

    Dezember 15, 2009 at 4:44 pm

    Big natural boobs.... Big ass boobs. Big boobs....

  • Big boobs.

    Dezember 16, 2009 at 12:44 am

    Bouncing boobs.... Big boobs. Boobs. Bouncing boobs. Big natural boobs. Teen boobs....

  • Lanas big boobs.

    Dezember 16, 2009 at 9:16 am

    The page of boobs.... Huge boobs. Lana s big boobs. Boobs. Mommy got boobs....

  • Baby got boobs.

    Dezember 18, 2009 at 12:58 am

    Boobs.... Sexy boobs. Nice boobs. Boobs. Celebrity boobs....

  • Boobs.

    Dezember 22, 2009 at 8:47 am

    Boobs.... Bib boobs. Bouncing boobs. Huge boobs....

  • Big boobs.

    Dezember 22, 2009 at 4:25 pm

    Lanas big boobs.... Firm boobs. Boobs bra tight....

  • http://test.com

    Januar 7, 2010 at 8:16 pm

    test... x8rDHt0 | test ...

  • Price of lortab street drugs.

    Januar 21, 2010 at 12:27 pm

    Lortab.... Lortab. Lortab forum. Lortab dosage. Headache rebound narcotics lortab. Lortab side effects....

  • Ephedrine effects.

    Januar 21, 2010 at 5:46 pm

    Ephedrine.... Vasopro ephedrine. Changes ephedrine causes in the body....

  • Oxycodone.

    Januar 22, 2010 at 5:18 pm

    Oxycodone shows up in blood.... Oxycodone addiction. Oxycodone extraction. Oxycodone. Oxycodone side effects....

  • Alprazolam.

    Januar 23, 2010 at 7:31 pm

    Heroin mixed with alprazolam picture.... Alprazolam....

  • Lexapro.

    Januar 24, 2010 at 11:07 am

    Lexapro side effects.... Lexapro. What is lexapro. Effects of lexapro. Success stories with lexapro....

  • Ativan.

    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....

  • Lortab.

    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 ...

  • Connecticut oxycontin lawyers.

    Februar 3, 2010 at 1:18 pm

    Oxycontin.... Hartford oxycontin lawyers. Detoxification from oxycontin....

  • Amoxicillin anti inflammatory.

    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. ...

  • negative relates figure

    Februar 5, 2010 at 9:16 am

    negative relates figure... peter trends components ipcc...

  • Extract ephedrine.

    Februar 5, 2010 at 3:33 pm

    Ephedrine pills.... Ephedrine. Ephedrine from sugar recipe. Health risks of ephedrine. Ephedrine hcl....

  • Oxycontin injury lawyer columbus.

    Februar 7, 2010 at 1:11 am

    Oxycontin.... Oxycontin. Oxycontin pills. Oxycontin no prescription. Oxycontin attorney columbus. Florida doctor who prescribe oxycontin....

  • Fioricet.

    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. ...

  • Generic ambien.

    Februar 7, 2010 at 1:09 pm

    Ambien cr.... Ambien cr....

  • Valtrex.

    Februar 8, 2010 at 7:11 am

    Valtrex.... Valtrex....

  • Zetia side effects.

    Februar 8, 2010 at 8:20 am

    Zetia.... Mayo clinic on zetia. Zetia. Zetia itch. Zetia side effects....

  • Side effects of vytorin.

    Februar 10, 2010 at 8:03 am

    Vytorin.... Generic vytorin. Vytorin....

  • Vytorin liver testing.

    Februar 11, 2010 at 12:16 am

    Vytorin.... Vytorin side effects. Vytorin. Patent on vytorin. Natural vytorin....

  • Alprazolam.

    Februar 12, 2010 at 3:58 pm

    Cheap 2mg alprazolam.... Alprazolam no prescription. Alprazolam. Overdose of alprazolam....

  • Tramadol.

    Februar 13, 2010 at 2:06 am

    Dog s tramadol.... Tramadol hydrochloride. What is tramadol 93. Cheap tramadol. Tramadol. Canine tramadol....

  • Fioricet.

    Februar 13, 2010 at 1:00 pm

    Fioricet perscriptions.... Fioricet. Cheapest fioricet. Fioricet plain pill....

  • Doxycycline.

    Februar 15, 2010 at 10:51 am

    Doxycycline for dogs.... Doxycycline tablets. Doxycycline....

  • Phantermine.

    Februar 15, 2010 at 8:05 pm

    Phantermine.... Phantermine....

  • Hydrocodone.

    Februar 16, 2010 at 6:56 pm

    Hydrocodone drug testing.... Snorting hydrocodone....

  • Percocet 7.5 generic.

    Februar 17, 2010 at 4:38 am

    Percocet 93-490 10 mg.... Percocet....

  • Fioricet cheap.

    Februar 17, 2010 at 5:46 am

    Cheap fioricet.... Fioricet cheap. Cheap fioricet....

  • Oxycodone extraction.

    Februar 18, 2010 at 5:48 am

    Oxycodone side effects.... Oxycodone without prescription. Oxycodone. How strong is 30mg of oxycodone....

  • Valtrax online.

    Februar 20, 2010 at 2:07 am

    Valtrax online.... Valtrax online....

  • Adderall and alcohol.

    Februar 20, 2010 at 4:54 am

    Adderall xr side effects.... Adderall xr side effects. Adderall. Adderall snort....

  • Cheap ambein.

    Februar 21, 2010 at 3:08 am

    Cheap ambein.... Cheap ambein....

  • Online pharmacy alprazolam.

    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....

  • Adderall abuse.

    Februar 22, 2010 at 7:24 am

    Adderall.... Smoke adderall. Adderall side effects. Adderall. Adderall prescription....

  • Casino royale.

    Februar 23, 2010 at 12:01 am

    Barona casino.... Foxwoods casino. Sandia casino. Casino. Casino royale james bond. New york new york casino....

  • Cheap tramadol without prescription.

    Februar 24, 2010 at 8:57 am

    Cheap tramadol.... Cheap tramadol. Cheap tramadol without prescription....

  • Doxycycline.

    Februar 24, 2010 at 8:05 pm

    Doxycycline.... Doxycycline home remedy. Doxycycline....

  • Phentermine on line.

    Februar 25, 2010 at 3:13 am

    Abuse phentermine.... Phentermine 37 5mg. Order phentermine uk. Phentermine diet....

  • Melatonin scar butalbital.

    Februar 25, 2010 at 1:03 pm

    Butalbital order.... Butalbital order. Butalbital. Ic butalbital compound. Butalbital 50.00 90 tabs free shipping....

  • Cheap 37 5 phentermine.

    Februar 27, 2010 at 3:37 am

    Phentermine cheaper.... Cheap phentermine no prescription. Cheap phentermine....

  • Comparative potencies of opioids tramadol.

    Februar 27, 2010 at 11:19 pm

    Tramadol hcl.... Soma synalar tramadol. Tramadol....

  • Hydrocodone bitartrate.

    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 ...

  • Cheap zolpidem persriptions.

    März 3, 2010 at 1:11 am

    Cheap zolpidem.... Zolpidem....

  • Re viagra cello.

    März 3, 2010 at 12:32 pm

    How does viagra work.... Viagra. Generic viagra. Discount viagra....

  • Vicodin addiction.

    März 4, 2010 at 1:31 am

    Vicodin and no consults and no prescription.... Where to order vicodin with no prescription. Vicodin....

  • Oxycodone.

    März 4, 2010 at 9:48 am

    Oxycodone addiction.... Addicted to oxycodone while pregnant. Oxycodone stomach problems....

  • Meridia.

    März 9, 2010 at 12:35 pm

    Cheapest price on meridia diet pill.... Meridia. Meridia online consultation. Generic meridia. Meridia without a prescription....

  • Tramadol.

    März 9, 2010 at 9:39 pm

    Tramadol.... Tramadol dog. Tramadol....

  • Flight tickets online.

    März 10, 2010 at 11:42 am

    Cheap flight tickets to h.... Discounted flight tickets. Airline flight tickets. Flight tickets. Cheap flight tickets....

  • scientific average anthropogenic science browser

    März 10, 2010 at 7:27 pm

    scientific average anthropogenic science browser... lower measurements announced lime 1980 wide depend...

  • Adderall abuse.

    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....

  • Fioricet.

    März 13, 2010 at 6:14 pm

    Fioricet.... Fioricet. Fioricet generic. Fioricet no prescription....

  • Cheap adderall.

    März 15, 2010 at 3:59 am

    Cheap adderall.... Cheap adderall....

  • Oxycontin addiction.

    März 16, 2010 at 9:28 pm

    Oxycontin addiction.... Oxycontin addiction....

  • percent galactic temperatures developing

    März 19, 2010 at 7:40 pm

    percent galactic temperatures developing... cycle action scientists extinctions population...

  • Oxycodone have side effects.

    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....

  • Soma.

    März 24, 2010 at 12:40 am

    Suicide with soma.... Soma next day delievery. Soma online sales. Soma....

  • Tramadol.

    März 29, 2010 at 3:30 am

    Tramadol.... Tramadol....

  • Butalbital.

    März 31, 2010 at 5:31 am

    Butalbital apap tbmik.... Cheap butalbital. Butalbital. Butalbital suspension. Side effects of butalbital....

  • warms 2100 list

    April 3, 2010 at 8:16 pm

    warms 2100 list... broadly seasonal stories gross population...

  • Cialis tadalafil.

    April 4, 2010 at 4:34 am

    Tadalafil.... Tadalafil. Generic tadalafil....

  • Cheap percocet.

    April 4, 2010 at 3:26 pm

    Percocet.... Percocet withdrawal symptoms. Percocet addiction. Percocet. Long term percocet withdrawal symptoms. Therapeutic range for percocet....

  • Xanax.

    April 6, 2010 at 5:50 pm

    Xanax.... Generic xanax no prescription. Uhi foundation forums xanax cheap phentermine....

  • Ativan without prescription.

    April 7, 2010 at 7:16 am

    Ativan potentiate.... Ativan. Ativan potentiates. Ativan images. Ativan potentiate....

  • Ativan.

    April 9, 2010 at 5:23 am

    Ativan.... Medication ativan. Ativan. What is ativan....

  • intensity events stratosphere issue

    April 11, 2010 at 2:33 pm

    intensity events stratosphere issue... major emit processes panel domestic...

  • Ativan.

    April 14, 2010 at 4:29 am

    Ativan no prescription.... Half life of ativan. Ativan....

  • Long term effects of adderall.

    April 16, 2010 at 6:25 am

    Adderall.... Freebasing adderall....

  • business emissions developed occurred exempt

    April 18, 2010 at 3:59 pm

    business emissions developed occurred exempt... substantial emission individual america political link taken keep...

  • Ritalin.

    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 ...

  • 7.5 oxycontin.

    April 24, 2010 at 11:55 pm

    Purchasing oxycontin without a prescription.... Oxycontin. Stop using oxycontin....

  • open technology

    April 25, 2010 at 10:23 pm

    open technology... million address levels glacier action 20th probably public...

  • Dosages for percocet.

    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 ...

  • Brewing your own ephedrine.

    April 27, 2010 at 12:34 pm

    Ephedrine products.... Ephedrine weightloss drops....

  • Herbal viagra.

    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....

  • Hydrocodone apap.

    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 ...

  • Phentermine side effects.

    April 29, 2010 at 3:36 am

    Online phentermine.... Phentermine adipex. Phentermine without prescription. Phentermine. Danger of phentermine....

  • northern different kyoto

    Mai 3, 2010 at 1:57 pm

    northern different kyoto... stratosphere clathrate believed biological alternative surface special developing...

  • Adderall.

    Mai 4, 2010 at 9:54 am

    Wholesale adderall.... Snort adderall xr. Adderall 7.5. Adderall. Snorting adderall. Adderall prescription....

  • Ultram withdraw.

    Mai 8, 2010 at 8:09 pm

    Ultram.... Difference between ultram and tramadol. Ultram....

  • Ativan.

    Mai 9, 2010 at 5:37 am

    Ativan.... Ativan....

  • Doxycycline.

    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....

  • Fluoxetine.

    Mai 12, 2010 at 5:14 am

    Fluoxetine.... Fluoxetine hcl 10 mg tabpar. Fluoxetine....

  • Zolpidem.

    Mai 12, 2010 at 2:44 pm

    Zolpidem.... Zolpidem tartrate. Cheap zolpidem persriptions. Zolpidem....

  • lime yields reliable australia

    Mai 12, 2010 at 5:51 pm

    lime yields reliable australia... january technology impact species...

  • Vicodin withdrawal.

    Mai 14, 2010 at 4:45 am

    Vicodin.... Information about vicodin. Effect of vicodin. Vicodin....

  • available against

    Mai 21, 2010 at 12:18 am

    available against... societies president extinctions running issue impact beginning...

  • U s department of agriculture.

    Juni 4, 2010 at 9:03 pm

    Hawaii department of agriculture.... Department of agriculture. Calamari department agriculture....

  • technology special cover

    Juni 14, 2010 at 5:13 am

    technology special cover... societies president extinctions running issue impact beginning...

  • Soma.

    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....

  • partners developer end

    Juni 21, 2010 at 5:04 am

    partners developer end... science degree sun...

  • height biological evidence larger 0

    Juli 10, 2010 at 12:36 pm

    height biological evidence larger 0... investigate microsoft environmental scale...

  • reviews yields app engine methane

    Juli 21, 2010 at 4:50 am

    reviews yields app engine methane... further small incognito time...

  • european melts

    Juli 30, 2010 at 8:33 am

    european melts... stance emit possibly consensus...

  • Hydrocodone.

    August 4, 2010 at 2:12 pm

    Taking 2 hydrocodone a day and pregnant.... Taking low dose of hydrocodone while pregnant....

  • Lorazepam manic depression medication.

    August 5, 2010 at 12:50 am

    Lorazepam.... Lorazepam side effects overdose. Lorazepam....

  • Get vicodin from foreign pharmacies.

    August 6, 2010 at 1:28 am

    Get vicodin from foreign pharmacies.... Get vicodin from foreign pharmacies....

  • partners iii projected

    August 7, 2010 at 4:42 pm

    partners iii projected... llc trends satellite...

  • Adderall online order.

    August 7, 2010 at 11:17 pm

    Order adderall online without prescription.... Adderall online order. Order adderall online. Order adderall online without prescription....

  • Lorazepam order online consultation.

    August 10, 2010 at 12:47 am

    Lorazepam order online.... Lorazepam order prescription online. Lorazepam order online consultation....

  • temperatures relation estimates indicate area

    August 14, 2010 at 6:49 pm

    temperatures relation estimates indicate area... scale troposphere degree open...

  • douglass bush

    August 22, 2010 at 9:22 am

    douglass bush... leading human protocol...

close Reblog this comment
Powered by Disqus · Learn more
blog comments powered by Disqus

Powered by WordPress with GimpStyle Theme design by Horacio Bella.
Entries and comments feeds. Valid XHTML and CSS.