The frog...

Shagz · Aug 1, 2006

I remember the Frog being a really popular way back when I first got into GW, but I haven't heard anything about him/her/it showing up in a long time.

Anybody know of any recent frog appearances?

Dauntless · Aug 1, 2006

He shows up every couple of weeks or so when Gaile is on, sometiems he gets there before or sometimes a little after but he still comes.

They usually hang out in Kaineng interntaional district 1 now. Guild Wars Guru keeps logs on all their appearences in teh gaem and dev tracker section of teh forum.

vibrokatana · Aug 1, 2006

how much you wanna bet a bunch of 13 year olds made a religion around "the frog"

Dauntless · Aug 1, 2006

vibrokatana said:
how much you wanna bet a bunch of 13 year olds made a religion around "the frog"

Back when the frog hung out in Lions Arch there were always a good 5-10 players huddled around it. And if you got too close they would flame you for touching "t3h s4cr3d fr0gz0rz"... Err something like that.

vibrokatana · Aug 1, 2006

Dauntless said:
"t3h s4cr3d fr0gz0rz"

wow people have too much time...

Thrawn · Aug 1, 2006

Yes. Yes they do...

vibrokatana · Aug 1, 2006

when i get bored I write stuff like this

Code:

<CFIF NOT isDefined("OBJ_KEYS")>
<cfif isDefined("cookie.lineinfo")>
<CFSET OBJ_KEYS = cookie.lineinfo>
</cfif>
</cfif>
<cfcookie name="lineinfo" value='#PreserveSingleQuotes(OBJ_KEYS)#' expires="never">

<CFIF isDefined("form.Size")>
<CFIF form.Size eq "-">
<CFSET SizeSearch = "">
<cfelse>
	<CFSET SizeSearch = "AND a.GasSizeID = " & form.Size>
</cfif>
<cfelse>
<CFSET SizeSearch = "">
</cfif>

<CFIF isDefined("form.Material")>
<cfif form.Material eq "-">
<cfset MaterialSearch = "">
<cfelse>
	<cfif form.Size eq "-">
		<cfset MaterialSearch = "AND a.GasMaterialID = " & form.Material>
	<cfelse>
		<cfset MaterialSearch = "AND a.GasMaterialID = " & form.Material>
	</cfif>
</cfif>
<cfelse>
<cfset MaterialSearch = "">
</cfif>

<CFIF isDefined("form.type")>
<CFIF form.type eq "-">
<CFSET TypeSearch = "">
<cfelse>
	<CFSET TypeSearch = "AND a.GasLineTypeID = " & form.type>
</cfif>
<cfelse>
<CFSET TypeSearch = "">
</cfif>

<cfquery name="Count" datasource="dbGIS-2">
SELECT DISTINCT count(a.UniqueID) AS Count
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID #SizeSearch##MaterialSearch##TypeSearch#
</cfquery>

<cfquery name="CountLine" datasource="dbGIS-2">
SELECT DISTINCT count(a.UniqueID) AS Count
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID AND a.GasLineTypeID = 4 #SizeSearch##MaterialSearch##TypeSearch#
</cfquery>

<cfquery name="CountMain" datasource="dbGIS-2">
SELECT DISTINCT count(a.UniqueID) AS Count
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID AND a.GasLineTypeID = 3 #SizeSearch##MaterialSearch##TypeSearch#
</cfquery>

<cfquery name="infoquery" datasource="dbGIS-2">
SELECT DISTINCT a.GasLineID, a.GasLine_HTE_Project, a.GasLine_HTE_WorkOrder, b.GasLineTypeName, c.GasSizeName, d.GasMaterialName
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID #SizeSearch##MaterialSearch##TypeSearch#
order by GasLineID
</cfquery>


<html>
<Head>
<Title>Project Data</Title>
</Head>
<Body>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<table border=0 width=400>
<tr><td><font size="2" face="Verdana">Okaloosa Gas District</font></td></tr>
<tr>
	<td><font size="5" face="Verdana">Project Data</font></h2></td>
</tr>
<tr>
	<td width=120>
		<p align="Left">
		<cfquery name="time" datasource="dbGIS-2">
		select CONVERT(CHAR(17),GETDATE(),113) as Time
		</cfquery>
		<cfoutput query="time"><p align="right">#Time# &nbsp;
		</p>
	</td>
</tr>
</cfoutput>
</table>
</tr>


<tr>
<cfform action="ProjectNum.cfm">
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td>
Size:
</td>
<td>
		<cfselect name="Size">
		<option value="-">	-	</option>
		<option value="0">	Unknown	</option>
		<option value="6">	1/3"	</option>
		<option value="7">	1/4"	</option>
		<option value="1">	5/8"	</option>
		<option value="2">	3/4"	</option>
		<option value="3">	1"	</option>
		<option value="4">	1-1/4"	</option>
		<option value="5">	1-1/2"	</option>
		<option value="8">	2"	</option>
		<option value="18">	2-1/4"	</option>
		<option value="9">	2-3/8"	</option>
		<option value="17">	2-1/2"	</option>
		<option value="19">	2-7/8"	</option>
		<option value="10">	3"	</option>
		<option value="13">	4"	</option>
		<option value="14">	4-1/2"	</option>
		<option value="11">	5"	</option>
		<option value="15">	6"	</option>
		<option value="20">	8"	</option>
		<option value="12">	10"	</option>
		<option value="16">	12"	</option>
		</cfselect>
</td>
</tr><tr>
<td>
Material:
</td>
<td>
		<cfselect name="Material">
		<option value="-">	-		</option>
		<option value="0">	Unknown		</option>
		<option value="1">	Steel		</option>
		<option value="2">	Plastic		</option>
		<option value="3">	Cast Iron	</option>
		<option value="4">	PE Insert	</option>
		</cfselect>
</td>
</tr><tr>
<td>
Type:
</td>
<td>
		<cfselect name="type">
		<option value="-">	-			</option>
		<option value="0">	Unknown			</option>
		<option value="1">	High Pressure		</option>
		<option value="2">	Intermediate Pressure	</option>
		<option value="3">	Mains			</option>
		<option value="4">	Service Lines		</option>
		</cfselect>
</td>
</tr><tr>
<td>
		<input type="Submit" value="Search">
</cfform>
</td>
</tr>
</table>
</tr>
<tr>

<cfoutput query="Count">
<i> Query returned #Count[1]# rows</i>
</cfoutput>
<br>
<cfoutput query="CountMain">
<i> Consisting of #Count[1]# Mains</i>
</cfoutput>
<cfoutput query="CountLine">
<i> And #Count[1]# Service Lines</i>
</cfoutput>
</tr>
<tr>
<table border=1>
	<tr>
		<td>GasLineID</td>
		<td>Project</td>
		<td>WorkOrder</td>
		<td>Type</td>
		<td>Size</td>
		<td>Material</td>
	</tr>

<cfoutput query="infoquery">
	<tr>
		<td>#GasLineID# &nbsp;</td>
		<td>#GasLine_HTE_Project# &nbsp;</td>
		<td>#GasLine_HTE_WorkOrder# &nbsp;</td>
		<td>#GasLineTypeName# &nbsp;</td>
		<td>#GasSizeName# &nbsp;</td>
		<td>#GasMaterialName#</td>
	</tr>
</cfoutput>
</table>
</tr>
</table>


</body>
</html>

Thrawn · Aug 1, 2006

vibrokatana · Aug 1, 2006

Thrawn said:
...

for even more fun I switch to a session variable instead of a cookie

Code:

<cfapplication name="Project_Num" 
sessionmanagement="Yes">

<CFIF NOT isDefined("OBJ_KEYS")>
<cfif isDefined("cookie.lineinfo")>

<cflock timeout=20 scope="Session" type="Exclusive">
<CFSET OBJ_KEYS = Session.Project_Num>
</cflock>
</cfif>
</cfif>

<cflock timeout=20 scope="Session" type="Exclusive">
  <cfset Session.Project_Num = OBJ_KEYS>
</cflock>

<CFIF isDefined("form.Size")>
<CFIF form.Size eq "-">
<CFSET SizeSearch = "">
<cfelse>
	<CFSET SizeSearch = "AND a.GasSizeID = " & form.Size>
</cfif>
<cfelse>
<CFSET SizeSearch = "">
</cfif>

<CFIF isDefined("form.Material")>
<cfif form.Material eq "-">
<cfset MaterialSearch = "">
<cfelse>
	<cfif form.Size eq "-">
		<cfset MaterialSearch = "AND a.GasMaterialID = " & form.Material>
	<cfelse>
		<cfset MaterialSearch = "AND a.GasMaterialID = " & form.Material>
	</cfif>
</cfif>
<cfelse>
<cfset MaterialSearch = "">
</cfif>

<CFIF isDefined("form.type")>
<CFIF form.type eq "-">
<CFSET TypeSearch = "">
<cfelse>
	<CFSET TypeSearch = "AND a.GasLineTypeID = " & form.type>
</cfif>
<cfelse>
<CFSET TypeSearch = "">
</cfif>

<cfquery name="Count" datasource="dbGIS-2">
SELECT DISTINCT count(a.UniqueID) AS Count
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID #SizeSearch##MaterialSearch##TypeSearch#
</cfquery>

<cfquery name="CountLine" datasource="dbGIS-2">
SELECT DISTINCT count(a.UniqueID) AS Count
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID AND a.GasLineTypeID = 4 #SizeSearch##MaterialSearch##TypeSearch#
</cfquery>

<cfquery name="CountMain" datasource="dbGIS-2">
SELECT DISTINCT count(a.UniqueID) AS Count
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID AND a.GasLineTypeID = 3 #SizeSearch##MaterialSearch##TypeSearch#
</cfquery>

<cfquery name="testquery" datasource="dbGIS-2">
SELECT DISTINCT a.GasLineID, a.GasLine_HTE_Project, a.GasLine_HTE_WorkOrder, b.GasLineTypeName, c.GasSizeName, d.GasMaterialName
FROM tblGasLines a, tblGasLineTypes b, tblGasSizes c, tblGasMaterials d
WHERE UniqueID IN (#PreserveSingleQuotes(OBJ_KEYS)#) and a.GasSizeID = c.GasSizeID and a.GasLineTypeID = b.GasLineTypeID and a.GasMaterialID = d.GasMaterialID #SizeSearch##MaterialSearch##TypeSearch#
order by GasLineID
</cfquery>

<html>
<Head>
<Title>Project Data</Title>
</Head>
<Body>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<table border=0 width=400>
<tr><td><font size="2" face="Verdana">Okaloosa Gas District</font></td></tr>
<tr>
	<td><font size="5" face="Verdana">Project Data</font></h2></td>
</tr>
<tr>
	<td width=120>
		<p align="Left">
		<cfquery name="time" datasource="dbGIS-2">
		select CONVERT(CHAR(17),GETDATE(),113) as Time
		</cfquery>
		<cfoutput query="time"><p align="right">#Time# &nbsp;
		</p>
	</td>
</tr>
</cfoutput>
</table>
</tr>

<tr>
<cfform action="ProjectNum.cfm">
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td>
Size:
</td>
<td>
		<cfselect name="Size">
		<option value="-">	-	</option>
		<option value="0">	Unknown	</option>
		<option value="6">	1/3"	</option>
		<option value="7">	1/4"	</option>
		<option value="1">	5/8"	</option>
		<option value="2">	3/4"	</option>
		<option value="3">	1"	</option>
		<option value="4">	1-1/4"	</option>
		<option value="5">	1-1/2"	</option>
		<option value="8">	2"	</option>
		<option value="18">	2-1/4"	</option>
		<option value="9">	2-3/8"	</option>
		<option value="17">	2-1/2"	</option>
		<option value="19">	2-7/8"	</option>
		<option value="10">	3"	</option>
		<option value="13">	4"	</option>
		<option value="14">	4-1/2"	</option>
		<option value="11">	5"	</option>
		<option value="15">	6"	</option>
		<option value="20">	8"	</option>
		<option value="12">	10"	</option>
		<option value="16">	12"	</option>
		</cfselect>
</td>
</tr><tr>
<td>
Material:
</td>
<td>
		<cfselect name="Material">
		<option value="-">	-		</option>
		<option value="0">	Unknown		</option>
		<option value="1">	Steel		</option>
		<option value="2">	Plastic		</option>
		<option value="3">	Cast Iron	</option>
		<option value="4">	PE Insert	</option>
		</cfselect>
</td>
</tr><tr>
<td>
Type:
</td>
<td>
		<cfselect name="type">
		<option value="-">	-			</option>
		<option value="0">	Unknown			</option>
		<option value="1">	High Pressure		</option>
		<option value="2">	Intermediate Pressure	</option>
		<option value="3">	Mains			</option>
		<option value="4">	Service Lines		</option>
		</cfselect>
</td>
</tr><tr>
<td>
		<input type="Submit" value="Search">
</cfform>
</td>
</tr>
</table>
</tr>
<tr>

<cfoutput query="Count">
<i> Query returned #Count[1]# rows</i>
</cfoutput>
<br>
<cfoutput query="CountMain">
<i> Consisting of #Count[1]# Mains</i>
</cfoutput>
<cfoutput query="CountLine">
<i> And #Count[1]# Service Lines</i>
</cfoutput>
</tr>
<tr>
<table border=1>
	<tr>
		<td>GasLineID</td>
		<td>Project</td>
		<td>WorkOrder</td>
		<td>Type</td>
		<td>Size</td>
		<td>Material</td>
	</tr>

<cfoutput query="testquery">
	<tr>
		<td>#GasLineID# &nbsp;</td>
		<td>#GasLine_HTE_Project# &nbsp;</td>
		<td>#GasLine_HTE_WorkOrder# &nbsp;</td>
		<td>#GasLineTypeName# &nbsp;</td>
		<td>#GasSizeName# &nbsp;</td>
		<td>#GasMaterialName#</td>
	</tr>
</cfoutput>
</table>
</tr>
</table>


</body>
</html>

janc · Aug 1, 2006

ColdFusion geek

Personally, my "fun" coding has moved from CF to PHP.

Atown · Aug 1, 2006

i need to visit the frog....

Stc95 · Aug 1, 2006

if you kiss it does it turn into a prince....?

Dauntless · Aug 1, 2006

Stc95 said:
if you kiss it does it turn into a prince....?

Yep Prince Rurik complete with a Fiery Dragon Sword and Mending

Thrawn · Aug 1, 2006

Dauntless said:
Yep Prince Rurik complete with a Fiery Dragon Sword and Mending

Oh sweet Balthazar whatever you do, DON'T KISS THE FROG!

vibrokatana · Aug 1, 2006

janc said:
ColdFusion geek

Personally, my "fun" coding has moved from CF to PHP.

im working on my own php cms, so far I havent done much on it. I have the menu loop done, thats about it

. sql is the easy part for me, its the php scripting that is the pain.

The frog...

Shagz

New Member

Dauntless

New Member

vibrokatana

New Member

Dauntless

New Member

vibrokatana

New Member

Thrawn

New Member

vibrokatana

New Member

Thrawn

New Member

vibrokatana

New Member

janc

New Member

Atown

Christian Gamers Alliance Amazon Store Manager

Stc95

Tribe of Judah Guild Wars Chapter Leader

Dauntless

New Member

Thrawn

New Member

vibrokatana

New Member

Forum statistics

Share this page