Random Adoptables - Mysidia Adoptables Support Forum

Home Community Mys-Script Creative Off-Topic

		Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports
Random Adoptables

Thread Tools

Display Modes

01-23-2010, 12:07 AM

Seapyramid Seapyramid is offline

Premium Member

Join Date: Feb 2009

Posts: 373

Gender: Female

Credits: 26,078

RE: Random Adoptables

this is the sql call I use

PHP Code:


			
 SELECT a.code,b.primaryimage FROM ".$prefix."adoptables AS a JOIN ".$prefix."levels AS b ON b.type=a.type AND a.whenisavail !='promo' AND a.whenisavail !='mystery' AND a.shop=b'0' AND a.grlelevel <= '$group' AND b.thisislevel=0 ORDER BY RAND() LIMIT 8";

My code is now greatly optimized from the original.. so you will have to understand some php to break it down.. but thats what I use.

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Random 3D Art	alonaria	Art Gallery	4	06-13-2011 05:19 PM
5 Random Adoptables = FAIL	Civil Engineer	Questions and Supports	18	10-01-2010 03:02 AM
Random Adoptables	fadillzzz	Questions and Supports	15	04-12-2010 10:29 PM
Random 5 is not realy random!	RipJawWolfFang	Questions and Supports	9	04-30-2009 06:03 AM
5 random adoptables	zhiichiro	Questions and Supports	3	04-25-2009 04:09 PM

All times are GMT -5. The time now is 02:20 PM.

Currently Active Users: 1701 (0 members and 1701 guests)
Threads: 4,082, Posts: 32,047, Members: 2,016
Welcome to our newest members, jolob.

What's New?

What's Hot?

What's Popular?