Nicaragua Expat Forum

  SELECT * FROM genset 
WHERE dbname = "ee"

      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	

	Select *
	From Networks
	Where frmid = 654 

	Select *
	From Networks
	where isCity = 'country'
	order by networkname

	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 

	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 654 

	Select *
	From citynetworks
	Where networkID = 295
	and status <> 'hold'
	ORDER by city

  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname

	Select *
	From Networks
	Where networkID = 295 

  SELECT f.frmid as frmid, frmname, t.tpcname, m.msgtext, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, t.tpcnamenew, t.summary, t.keywords, m.msgid
  FROM forums f, topics t, messages m  
  WHERE f.frmid = 654 
  AND t.tpcid = 3436357 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0

  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3436357
  and  t.tpcid = 3436357
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1

	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 295
	order by lastsent ASC

  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, t.tpcupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3436357
  and  t.tpcid = 3436357
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1

	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 295
	order by lastsent ASC

SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-03-03"
and param1 = 'aw'
ORDER BY logtime DESC

SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-06-02 00:00:00.000"
and logtime < "2020-06-02 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC

SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-05-26"
and param1 = 'awdyn'
ORDER BY logtime DESC

	SELECT *
	From contentcountcountry
	Where networkid = 295 

	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
    and bannerPlacement.networkid = 295
    and bannerPlacement.bannerid = banners.bannerid

  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 

  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 654 
  AND tpcid = 3436357 
  AND f.isactive = 1
  
  and f.frmid = t.frmid

  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 654
  AND u.userdbname = "ee"
  ORDER BY u.username

  SELECT *
  FROM categories
  WHERE catid = "2"

  SELECT * FROM designset
  WHERE designsetid = 11 

  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, topics.tpcname, forums.frmname, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3436357
  AND m.userid = u.userid
  AND topics.tpcid = 3436357
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1

  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3436357
  AND m.userid = u.userid
  AND topics.tpcid = 3436357
    AND m.isdeleted <> 1
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
     AND m.msgparent <> 0
  AND m.isapproved = 1
   
    ORDER BY m.msgid ASC 

	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 295
	AND "2020-06-02" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-02"
     
         and rptarticlenetworks.networkid = 295 
    ORDER by rptarticles.rptarticleID asc   
    

	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 16
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID

	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 

SELECT  hiimg
FROM rptarticles
where rptarticleID = 16
and hiimg <> ''

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 295 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-02"

    ORDER by articles.articleID asc   
    

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 295 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 295 
          and date > '2013-04-01'
		order by date DESC

		Select summary, hiimg 
		FROM answers
         where answerid = 74149
         and summary <> ''

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/expat/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/expat/index.cfm
QUERY_STRING=frmid=654&tpcid=3436357
REMOTE_ADDR=173.245.54.151
REMOTE_HOST=173.245.54.151
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=

Cookie Variables:
MS=flat

Session Variables:
cfid=28855425
cftoken=79105176
sessionid=IBEXPATEXCHANGE.COM_28855425_79105176
urltoken=CFID=28855425&CFTOKEN=79105176

URL Parameters:
frmid=654
tpcid=3436357