Pogledajte određenu poruku
Staro 01. 10. 2008.   #6
cvele
Banned
Knowledge base
 
Avatar cvele
 
Datum učlanjenja: 01.07.2005
Poruke: 1.598
Hvala: 206
140 "Hvala" u 89 poruka
cvele ima spektakularnu aurucvele ima spektakularnu auru
Default

Evo resenja

Kôd:
					(
						select items.* from items left join owners_items on (items.id = owners_items.itemid and owners_items.ownerid = $ownerid)
						where type = '$type'
						and min_level<=$level 
						and owners_items.itemid is null
						and parent = -1
					)
						UNION
					(
						select items.* from items left join owners_items on (items.id = owners_items.itemid and owners_items.ownerid = $ownerid)
						where type = '$type'
						and min_level<=$level 
						and owners_items.itemid is null
						and parent in (
							select items.itemid from 
							items left join 
							owners_items on (items.id = owners_items.itemid and owners_items.ownerid = $ownerid)
							where owners_items.itemid is not null
						)			
					)
Ako neko ima ideju kako ovo da se ulepsa, shoot
cvele je offline   Odgovorite uz citat