select id, url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where url=? and enabled is not null
field (s) = Personality-Test

PHP Error
Error number 8: Undefined index: guidetitle
Line 85 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php


PHP Error
Error number 8: Undefined index: guidemetadescription
Line 86 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php

select id, pagedataid from categories where id = 177
select p.id, p.template from categories c, pagedata p where c.pagedataid=p.id and c.id=
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

PHP Error
Error number 8: Use of undefined constant categories_pagedataid - assumed 'categories_pagedataid'
Line 94 of /home/testdeveloper/secure_html/Alp/controllers/HomeController.php

select pagesize from settings
select qstnset, free from examset where free is not null

AJAX Debug:

select distinct adid, link, image, imgtitle, imgalt, rank, showgoogle from adsdesc where status is null and categoryid=177 union all select distinct adid, link, image, imgtitle, imgalt, rank+200, showgoogle from adsdesc where status is null and parentid=177 union all select distinct adid, link, image, imgtitle, imgalt, rank+300, showgoogle from adsdesc where status is null and rootid=177 union all select adid, link, image, imgtitle, imgalt, rank+100, showgoogle from ad where status is null and rank is not null order by rank limit 10
select guidelink from categories where id=177
select url, name, guideurl, guidelink, dirtitle, dhtmltitle, htmldesciption, metadescription, keywordsdesc, categorydesc, htmldesciption, practicetesturl, toppagelinks, examid, examtext1, examtext2, examimage from categories where id=177 and enabled is not null

Personality Test

Personality tests and personality testing resources. Free personality tests, informational guide and more to help you learn about yourself and others.
select count(id) records from ( select p.id, p.priority from product p, organization o, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=177 and pending is null and (p.pricecheck is null or (p.pricecheck!=3 and p.pricecheck!=404)) union select p.id, p.priority from product p, organization o, categories c, productcategories pc where p.orgid=o.id and p.id=pc.product and pc.category=c.id and c.parent=177 and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) ) x
select id, url, name, orgname, type, price, phone, email, title, priority, price1, followlink, descr, city, state, address, orgcity, orgstate, zip, orgphone, fax, orgemail, country, loctype, showprice from ( select p.id, p.url, p.contacturl, p.name, o.name orgname, o.image, p.orgid, p.type, p.price, ifnull(p.phone,o.phone) phone, ifnull(p.email,o.email) email, p.title, p.priority, p.price1, p.followlink, o.showprice, p.descr, ifnull(p.city,o.city) city, ifnull(p.state,o.state) state, o.address, o.city as orgcity, o.state as orgstate, o.zip, o.phone as orgphone, o.fax, o.email as orgemail, o.country, o.loctype, freesort from product p, organization o, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=177 union select p.id, p.url, p.contacturl, p.name, o.name orgname, o.image, p.orgid, p.type, p.price, ifnull(p.phone,o.phone) phone, ifnull(p.email,o.email) email, p.title, p.priority, p.price1, p.followlink, o.showprice, p.descr, ifnull(p.city,o.city) city, ifnull(p.state,o.state) state, o.address, o.city as orgcity, o.state as orgstate, o.zip, o.phone as orgphone, o.fax, o.email as orgemail, o.country, o.loctype, freesort from product p, organization o, categories c, productcategories pc where p.orgid=o.id and pending is null and ((p.pricecheck!=3 and p.pricecheck!=404) or pricecheck is null) and p.id=pc.product and pc.category=c.id and c.parent=177 ) x order by ifnull(priority,999), freesort limit 0 , 10
 
Test Item Organization Description Cost
select pagename from contactvendors where prodid=193503
Personality Assessment
Personality Assessment
Location Type: Online

Organization: Personality Net
Address: USA
Personality Net
The most detailed personality assessment on the Internet. Take the Test.
select pagename from contactvendors where prodid=193920
Love Tests
Love Tests
Location Type: Online

Organization: Tests.com
Address: USA
Tests.com
The top 3 love tests.
select pagename from contactvendors where prodid=9303
The Myers-Briggs Type Indicator® Online
The Myers-Briggs Type Indicator® Online
Email: brian@DiscoveryYourPersonality.com
Phone: 858-5 71-3931

Organization: Career and Personality Tests Online
Address: 5389 Caminito VelasquezSan Diego USA CA 92124
Phone: 858-571-3931
Description: Take the genuine Myers-Briggs online. Also in Spanish, French, German and other languages. Group rates available.
Career and Personality Tests Online
858-5 71-3931
Myers-Briggs Personality Test Online, MBTI, Online Group and Team Testing, Test Packages
select pagename from contactvendors where prodid=30164
Personality Tests
Personality Tests
Email: webmaster@psychometric-success.com
Location Type: Online

Organization: Psychometric Success
Address: USA
Description: Personality questionnaires used in selection are far from perfect but you need to know what they are trying to measure and why.
Psychometric Success
How Personality Tests Work
select pagename from contactvendors where prodid=57874
The Personality Profile
The Personality Profile
Email: help@personalityonline.com

Organization: Personality Online
Description: A site dedicated to the subject of self discovery, find out about your personality, who you are, how you act and react in certain situations, and learn more about yourself. Use our interactive tests to give yourself a better understanding.
Personality Online
Personality Online - Online personality,relationship and apptitude tests, find out who you
select pagename from contactvendors where prodid=96700
AMPM Personality Test
AMPM Personality Test
Email: support@psychtests.com
Phone: 212-260-7210

Organization: Psychology Today
Address: 115 E. 23rd StNew York NY 10010
Phone: 212-260-7210
Psychology Today
212-260-7210
Self Tests by Psychology Today
select pagename from contactvendors where prodid=97338
Conners Comprehensive Behavior Rating Scales (Conners CBRS)
Conners Comprehensive Behavior Rating Scales (Conners CBRS)
Email: info@psychcorp.co.uk
Phone: 0845-630-88-88

Organization: Pearson Assessment
Address: Halley Court, United Kingdom OX2 8EJ
Phone: 0845 630 88 88
Fax: 0845 630 55 55
Description: Pearson Assessment, formerly Harcourt Assessment, develops and distributes tests and related products for psychologists, therapists, teachers, SENCOs and HR professionals.
Pearson Assessment
0845-630-88-88
Conners Comprehensive Behavior Rating Scales (Conners CBRS) from Pearson Assessment
select pagename from contactvendors where prodid=97390
Millon Pre-Adolescent Clinical Inventory (M-PACI)
Millon Pre-Adolescent Clinical Inventory (M-PACI)
Email: info@psychcorp.co.uk
Phone: 0845-630-88-88

Organization: Pearson Assessment
Address: Halley Court, United Kingdom OX2 8EJ
Phone: 0845 630 88 88
Fax: 0845 630 55 55
Description: Pearson Assessment, formerly Harcourt Assessment, develops and distributes tests and related products for psychologists, therapists, teachers, SENCOs and HR professionals.
Pearson Assessment
0845-630-88-88
Millon Pre-Adolescent Clinical Inventory (M-PACI) from Pearson Assessment
select pagename from contactvendors where prodid=103453
Extroversion/Introversion Test
Extroversion/Introversion Test
Email: privacy_policy@discovery.com
Phone: 240-662-2000

Organization: Discovery Health
Address: Silver Spring USA MD 20910
Phone: 240-662-2000
Description: Take an extroversion/introversion test to see if you are oriented towards the outer or inner world.
Discovery Health
240-662-2000
Discovery Health :: Personality Assessments: Extroversion/Introversion
select pagename from contactvendors where prodid=103463
Leadership Test
Leadership Test
Email: privacy_policy@discovery.com
Phone: 240-662-2000

Organization: Discovery Health
Address: Silver Spring USA MD 20910
Phone: 240-662-2000
Description: Take a leadership test to see if you have the right attitudes, behaviors and skills to be an effective leader.
Discovery Health
240-662-2000
Discovery Health :: Personality Assessments: Leadership


select linkname, url, template, examid, viewid, pageid from categorylinks where catid=177 order by posn
select name, value from publiccontent where page='home' or page='All Pages'