Warrior General Games

Originally posted by LordEvil
This will be for season 20 those signing up, but I do want to run some test runs before this season is over to test the scoring, stats, etc and make sure evrthing will be smooth.

Maybe do the last few weeks in Gold this season with an automated type draft that each agent gets players and we just track their stats to see if everything works well and such. Just for fun and testing.

I am currently working on the draft sheet where each team submits their roster, so get to thinking who you want on your team. I will try and get this set up so we have some games left in the season to test everything out.

Originally posted by LordEvil
I am currently working on the draft sheet where each team submits their roster, so get to thinking who you want on your team. I will try and get this set up so we have some games left in the season to test everything out.


I have thoughts

dibs on all FGC and CTJ players

Hey Stoner, still feel like helping? Below is the code I just did for the sql Table for the draft. Can you use this info and create a php page (My Dream weaver isn't working on my new computer) where the user logs in, have to call a sql table to cross check password, then it pulls the teams Data from the table. I am thinking I need a sql table that has
User - Password - Last Action Time - Roster consisting of...
2 QBs
4 Hbs
2 FBs
6 Wrs
4 TEs
4 Dts
4 DEs
4 Lbs
4 Cbs
2 Fs
2 SS
2 Kickers

Somehow I have to add player Ids that pull from another table the position and players name.

I'm thinking after the full roster i sin view on top, below will be the page they set up their starting roster.
1 QB
2 RBs
1 FB
2 TE
3 Wrs
1 DT
1 DE
2 LBs
2 CBs
1 FS
1 SS
1 K
Either php or HTML but HTML can draw the info from the tables, but it can be in both forms. If you have time to do this I can start working on the program for calculating the stats. I already started on the offense and testing some simple player stat importing. I have to write the code for each players page within the program but it wont be that bad since I just copy the first formula for all the weeks remaining. Anyways here is the current Draft Tables in the database so you can get an Idea where to start

<CODE ?php
$con = mysql_connect("lxxxxxx","xxxxxxxx","xxxxxxxxx");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("xxxxxx_peewee1", $con);
$0username=mysql_real_escape_string($_POST['0username']);
$1password=mysql_real_escape_string($_POST['1password']);
$QBeast=mysql_real_escape_string($_POST['QBeast']);
$QBWest=mysql_real_escape_string($_POST['QBWest']);
$RB1East=mysql_real_escape_string($_POST['RB1East']);
$RB2East=mysql_real_escape_string($_POST['RB2East']);
$RB1West=mysql_real_escape_string($_POST['RB1West']);
$RB2West=mysql_real_escape_string($_POST['RB2West']);
$FB1East=mysql_real_escape_string($_POST['FB1East']);
$FB1West=mysql_real_escape_string($_POST['FB1West']);
$WR1East=mysql_real_escape_string($_POST['WR1East']);
$WR2East=mysql_real_escape_string($_POST['WR2East']);
$WR3East=mysql_real_escape_string($_POST['WR3East']);
$WR1West=mysql_real_escape_string($_POST['WR1West']);
$WR2West=mysql_real_escape_string($_POST['WR2West']);
$WR3West=mysql_real_escape_string($_POST['WR3West']);
$TE1East=mysql_real_escape_string($_POST['TE1East']);
$TE2East=mysql_real_escape_string($_POST['TE2East']);
$TE1West=mysql_real_escape_string($_POST['TE1West']);
$TE2West=mysql_real_escape_string($_POST['TE2West']);
$DT1East=mysql_real_escape_string($_POST['DT1East']);
$DT2East=mysql_real_escape_string($_POST['DT2East']);
$DT1West=mysql_real_escape_string($_POST['DT1West']);
$DT2West=mysql_real_escape_string($_POST['DT2West']);
$DE1East=mysql_real_escape_string($_POST['DE1East']);
$DE2East=mysql_real_escape_string($_POST['DE2East']);
$DE1West=mysql_real_escape_string($_POST['DE1West']);
$DE2West=mysql_real_escape_string($_POST['DE2West']);
$LB1East=mysql_real_escape_string($_POST['LB1East']);
$LB2East=mysql_real_escape_string($_POST['LB2East']);
$LB1West=mysql_real_escape_string($_POST['LB1West']);
$LB2West=mysql_real_escape_string($_POST['LB2West']);
$CB1East=mysql_real_escape_string($_POST['CB1East']);
$CB2East=mysql_real_escape_string($_POST['CB2East']);
$CB1West=mysql_real_escape_string($_POST['CB1West']);
$CB2West=mysql_real_escape_string($_POST['CB2West']);
$FS1East=mysql_real_escape_string($_POST['FS1East']);
$FS1West=mysql_real_escape_string($_POST['FS1West']);
$SS1East=mysql_real_escape_string($_POST['SS1East']);
$SS1West=mysql_real_escape_string($_POST['SS1West']);
$KickerEast1=mysql_real_escape_string($_POST['KickerEast1']);
$Kicker1West=mysql_real_escape_string($_POST['Kicker1West']);

$sql="INSERT INTO FFG (0username,1password,QBeast,QBWest,RB1East,RB2East,RB1West,RB2West,FB1East,FB1West,WR1East,WR2East,WR3East,WR1West,WR2West,WR3West,TE1East,TE2East,TE1West,TE2West,DT1East,DT2East,DT1West,DT2West,DE1East,DE2East,DE1West,DE2West,LB1East,LB2East,LB1West,LB2West,CB1East,CB2East,CB1West,CB2West,FS1East,FS1West,SS1East,SS1West,KickerEast1,Kicker1West) VALUES ('$0username','$1password','$QBeast','$QBWest','$RB1East','$RB2East','$RB1West','$RB2West','$FB1East','$FB1West','$WR1East','$WR2East','$WR3East','$WR1West','$WR2West','$WR3West','$TE1East','$TE2East','$TE1West','$TE2West','$DT1East','$DT2East','$DT1West','$DT2West','$DE1East','$DE2East','$DE1West','$DE2West','$LB1East','$LB2East','$LB1West','$LB2West','$CB1East','$CB2East','$CB1West','$CB2West','$FS1East','$FS1West','$SS1East','$SS1West','$KickerEast1','$Kicker1West')"; /*form_data is the name of the MySQL table where the form data will be saved.

name and email are the respective table fields*/
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
echo "Your Draft is now completed, your roster will be sent to you through pm.";
mysql_close($con);
?CODE>

I'll get to work in the morning when I'm sober.

I think once this is set up, we will just do total points instead of head to head since the season will be very short and we will only be testing scoring and such.

Anyways feel free to draft your team anytime while I set other stuff up.

http://www.nflfever2.com/FantasyFootballGold/FFDraftSheet.htm

DID IT! Umm, was I supposed to put my password from the GLB, cuz I didn't lol

Finished.

Originally posted by zmj44
DID IT! Umm, was I supposed to put my password from the GLB, cuz I didn't lol

me neither, although I kept the same username

Yeah use a different password for this game. Its just so we can tell who is changing whos picks.

How do we just pick random players without knowing who's been picked already and such

Originally posted by bmac1188
How do we just pick random players without knowing who's been picked already and such

For now its not a draft where you cant pick what someone else picks so yeah some teams may have the same player or 2.

So, where are we getting a PM and where are we seeing everything? lol

Originally posted by zmj44
So, where are we getting a PM and where are we seeing everything? lol

I am still working on it off and on. Will take a while. I am thinking we'll be able to have something ready by week 11 for the last 5 games.