$other_commenter = fetch($comment_table_name, "member", "cliurl = '" . $_REQUEST['client'] . "' and type = '2' and source=1");
if ($other_commenter != '') {
$message = "A new comment was posted for the <a href=\"http://www.selectsmart.com/FREE/select.php?client=" . $_REQUEST['client'] . "\">" . fetch($free_table_name, "SelectorTitle", "uname = '" . $_REQUEST['client'] . "'") . "</a> yes/no quiz. You previously posted a comment there too, you may want to see the new one <a href=\"http://www.selectsmart.com/4me/comments.php?client=" . $_REQUEST['client'] . "\">HERE</a>.";
$csub = "select * from $comment_table_name where cliurl = '" . $_REQUEST['client'] . "' and type = '2' and source=1 group by member";
$cres = mysql_db_query($db_name, $csub);
while($crow = mysql_fetch_array($cres)) {
$sub2 = "insert into $message_table_name set type = '2', posted_to = '" . $crow[member] . "', headline = 'Another comment for a yes/no quiz', announcement = '$message', comments = 'Automated announcement from 4me/comments.php', date_posted = '$now'";
$res2 = mysql_query($sub2);
}
}
============================================
SELECT count(id) as cnt, `source` FROM `master_comments` WHERE 1 group by source order by cnt desc
================================================
cnt Ascending source 1:FREE; 2:plus.
96880 1
21329 2
14372 10
5487 4
122 3
24 8
12
4 45
3 89
3 152
2 38
2 26
1 75
1 151
1 101
==========================================
Full texts id name type color
1 Free Selectors Yes/No Quiz #48D1CC
2 Plus Selectors Multiple Choice #D5829E
3 Free Poll Poll #BF5FFF
4 Knowledge Quizzes Knowledge Quiz #8080ff
5 Bonus Poll Poll #ECC8EC
6 Column Column #FFA500
7 Forum Forum Members #CFDBC5
8 Flowchart Flowcharts #E6E6FA
9 Debate Debates #FFFFAA
10 Pro Selector Staff Created #66CC33
11 How Will I Die? Staff Created #C0C0C0
12 Mutt Matcher Staff Created #EEC591
13 Sexual Positions Recommender Yes/No Quiz #FF3E96
14 Dog Breed Missing Letters Game Puzzle #FFCC11
15 More Cowbell Or Not? Flowchart #ADFF2F
========================================================
1= FREE
2= plus
3= poll
4= knowledge
5= flow
6=
7=
8= http://SelectSmart.com/philosophy
9=
10=
26= http://selectsmart.com/topjobs.html
38= http://SelectSmart.com/religion
45= http://SelectSmart.com/pastlives
75= http://SelectSmart.com/bestcollege
89= http://www.selectsmart.com/names/nameguess.html (& http://www.selectsmart.com/NAMES/nameguess.html)
101= http://SelectSmart.com/president (2016)
151= http://SelectSmart.com/dietplans (SB 88 ??)
152= http://SelectSmart.com/nations (SB 95 ??)
---------------------------------------------------
PRO selector list:
3 SelectsMart.com Webware Selector
8 http://SelectSmart.com/philosophy Ethical Philosophy Selector
12 http://selectsmart.com/camera
13 Diode Laser Concepts Module Selector
15 Florida Gubernatorial Candidate Selector
16 2004 PRESIDENTIAL Redirect
18 http://www.SelectSmart.com/president
19 Guidant Pacemaker Selector
20 Bnet? Body Solid Home Gym Selector
21 California Recall Election Candidate Selector
23 Florida Senatorial Candidate Selector
24 http://www.selectsmart.com/canada2011.html
25 Ashland, Oregon Restaurant Guide
26 http://selectsmart.com/topjobs.html http://selectsmart.com/topjobs.html
27 Subaru Volvo Mitsubishi Vehicle Selector
28 Car & Truck Selector Results:
29 http://selectsmart.com/president/2008.html
31 http://selectsmart.com/scotus/2008.html
32 http://SelectSmart.com/positions ID #15
33 Hollywood Star Match
34 http://www.poconorecord.com/apps/pbcs.dll/article?AID=/99999999/NEWS0301/71017013
35 http://www.southbendtribune.com/apps/pbcs.dll/section?category=elections01
36 Diet Selector
37 http://SelectSmart.com/demovp08/2008.html
38 http://SelectSmart.com/religion Script ID #7
39 Minnesota
40 http://www.selectsmart.com/carpersonality ID #8
41 http://southbendtribune.com
42 http://southbendtribune.com
43 http://SelectSmart.com/states See /MOVE and /RETIRE
44 TV Shows
45 http://SelectSmart.com/pastlives 108 23
46 http://SelectSmart.com/nicknames Nicknames
47 http://selectsmart.com/president http://selectsmart.com/president
48 http://SelectSmart.com/pastpres ID #30
50 http://SelectSmart.com/DOG ID #6
51 Bnet Test
52 Jew0
53 Judaism Branch Selector
54 http://SelectSmart.com/nontheism
55 SelectSmart.com/palin
56 http://SelectSmart.com/coldflu
57 SelectSmart.com/OregonGuv/2010.html
58 http://SelectSmart.com/politicalpersonality http://SelectSmart.com/politicalpersonality/
59 Homeopathy
60 Death causes
61 Death causes
62 http://SelectSmart.com/dogfood Dog Food
64 Dog Food 2
65 Film Finder
66 Boxing Champions
67 SelectSmart.com/wjar
68 http://SelectSmart.com/books
72 Life Coach
73 http://www.selectsmart.com/dogfood Dog Food 3
74 http://SelectSmart.com/collegemajor ID #53
75 http://SelectSmart.com/bestcollege Script ID #54
76 http://selectsmart.com/WINE ID #22
77 The DISC Diet Quiz!
78 http://SelectSmart.com/animal http://SelectSmart.com/animal
79 http://SelectSmart.com/bestcollege/onlineschools.html ID #147
80 Health Clubs
81 home gyms
82 PACs
85 Super PACs
86 http://SelectSmart.com/dietplans ID #151
87 SelectSmart.com/ma2012senator
88 http://SelectSmart.com/smartphones test selector
89 http://www.selectsmart.com/names/nameguess.html ID #22
90 http://www.selectsmart.com/4me/comments.php?special=90 Flowcharts & Columns 133 50
91 http://SelectSmart.com/CAT
92 http://SelectSmart.com/PET
93 http://SelectSmart.com/DOG Duplicate Test Dog Selector
94 http://selectsmart.com/nation
95 http://SelectSmart.com/nations
96 http://wdwprepschool.com/wp-content/uploads/hotelform.html
97 http://reviews.cnet.com/digital-cameras/
98 http://SelectSmart.com/cheese
99 http://SelectSmart.com/cereal 153 95
100 http://SelectSmart.com/SLR
101 http://SelectSmart.com/president
102
103 http://www.cthealthchannel.org/CT_Connecticut_individual_health_insurance_healthinsurance_health_insurance_plan_compare_health_insurance // https://www.extendhealth.com/health-insurance/types-of-health-insurance-plans
104
========================================================================