writeln("
") writeln("
") // writeln("") writeln("") writeln("") writeln("
") writeln("") writeln("
Add League
") writeln(" Home Page



") writeln("Help? Questions? Advertising?
email: info@fpconline.com") writeln("
") orderby = ( request.orderby ? request.orderby : "leaguename" ) writeln("Leage Name
") writeln(" Description
") writeln(" Commissioner
") writeln(" # Players
") writeln("
") writeln("") writeln("
") writeln("
") writeln("
") writeln("
") writeln("
") writeln("
") /* writeln("
") writeln("FPC gives you the ability to create your own league.

") writeln("Each league will have its own weekly and cumulative standings.

") writeln("You may join as many leagues as you would like or create your own.
") writeln("Click on the league name to see players/join.

") writeln("
") */ writeln("") writeln("
") writeln("
") var cid = '' var nStatusCode = 0 var lContinue = true if (!database.connected()) { write("

Error: Database is not available.

") lContinue = false } if (lContinue) { corder = "groupname" if (request.orderby) { if ( request.orderby == "leaguename" ) corder = "groupname" else if (request.orderby == "description" ) corder = "description" else if (request.orderby == "commissioner" ) corder = "commissioner" else if (request.orderby == "players" ) corder = "players DESC" } csql = "select * from groupm order by " + corder cursor1 = database.cursor(csql) writeln("
") writeln("
") writeln("") writeln(""); qo = unescape("%22") morerecs = true while (cursor1.next()) { cGroupname = replchar(alltrim(cursor1.groupname)," ","+") write("") write("") write("") write("") write("") } write("
League Name/DescriptionCommissionerPlayers
") write(cursor1.groupname + "
") write("  " + cursor1.description + "		" + ( alltrim(cursor1.commissioner) ? cursor1.commissioner : " ") + "" + cursor1.players + "
"); writeln("
") write("
"); if (cursor1.next()) { lContinue = true } else { lContinue = false } cursor1.close() lf = unescape("%0A") }