"; $betsy0_exists=0; } ==================================================================================================== if (($_REQUEST['form_complete']) or ($_GET['u_id']>0)){ // Submit-Button gedrückt $user_found=mysql_query("SELECT u_id,u_name,u_pic FROM users where (u_id='".$_REQUEST['selectuser']."' and u_passcode=md5('".$_REQUEST['passcode']."')) or (u_id='".$_GET['u_id']."');"); if ($erg=mysql_fetch_array($user_found)) { echo ""; echo "
"; echo "


".$erg[u_name]."


"; echo "

"; echo ""; echo "

click here to change your profile"; echo "
"; if ($_GET['q_tip_clicked']) { $display_qtip_found_d1=$_GET['qtip1']; $display_qtip_found_d2=$_GET['qtip2']; $display_qtip_found_d3=$_GET['qtip3']; if (($_GET['qtip1']==0) or ($_GET['qtip2']==0) or ($_GET['qtip3']==0) or ($_GET['qtip1'] == $_GET['qtip2']) or ($_GET['qtip1'] == $_GET['qtip3']) or ($_GET['qtip2'] == $_GET['qtip3'])) { $q_tip_msg="your tip is invalid"; echo ""; } else { $time_check_q_f=mysql_query("SELECT g_id,g_datetime_q FROM gps WHERE g_id='".$_GET['gp_id']."';"); if ($time_check_q=mysql_fetch_array($time_check_q_f)){ $localtime=date("Y-m-d H:i:s",time()+$timeadjust); if (date_diff_f1($localtime,$time_check_q['g_datetime_q']) < 0) { echo ""; if ($qtip_exists==0){ $inserted=mysql_query("INSERT INTO tips (t_u_id,t_g_id,t_e_id,t_d_id_p1,t_d_id_p2,t_d_id_p3,t_timestamp) VALUES (".$_GET['u_id'].",".$_GET['gp_id'].",1,".$_GET['qtip1'].",".$_GET['qtip2'].",".$_GET['qtip3'].",date_add(now(), interval ".$hourdiff." hour));"); $q_tip_msg="your tip has been placed"; } else { $updated=mysql_query("UPDATE tips SET t_d_id_p1=".$_GET['qtip1'].",t_d_id_p2=".$_GET['qtip2'].",t_d_id_p3=".$_GET['qtip3'].",t_timestamp=date_add(now(), interval ".$hourdiff." hour) WHERE t_u_id=".$_GET['u_id']." AND t_g_id=".$_GET['gp_id']." aND t_e_id=1;"); $q_tip_msg="your tip has been updated"; } } else { $q_tip_msg="sorry, time has expired"; echo ""; } } } if (($_GET['qtip1']==0) and ($_GET['qtip2']==0) and ($_GET['qtip3']==0)) { $q_tip_msg=""; } } else { echo ""; } if ($_GET['r_tip_clicked']) { $display_rtip_found_d1=$_GET['rtip1']; $display_rtip_found_d2=$_GET['rtip2']; $display_rtip_found_d3=$_GET['rtip3']; $display_rtip_found_fl=$_GET['rtipfl']; $display_rtip_found_firstout=$_GET['rtipfirstout']; $display_rtip_found_bestcup=$_GET['rtipbestcup']; $display_rtip_found_bestteam=$_GET['rtipbestteam']; $display_rtip_found_sc_y=$_GET['rtip_sc_y']; $display_rtip_found_sc_n=$_GET['rtip_sc_n']; if (($_GET['rtip1']==0) or ($_GET['rtip2']==0) or ($_GET['rtip3']==0) or ($_GET['rtip1'] == $_GET['rtip2']) or ($_GET['rtip1'] == $_GET['rtip3']) or ($_GET['rtip2'] == $_GET['rtip3']) or ($_GET['rtipfirstout'] == $_GET['rtip1']) or ($_GET['rtipfirstout'] == $_GET['rtip2']) or ($_GET['rtipfirstout'] == $_GET['rtip3']) or (($_GET['rtipfirstout'] == $_GET['rtipbestcup']) AND ($_GET['rtipfirstout'] != '----------- please select -----------')) or (($_GET['rtip_sc_y'] == 'true') and ($_GET['rtip_sc_n'] == 'true'))) { $r_tip_msg="your tip is invalid"; echo ""; } else { if (($_GET['rtip_sc_y'] == 'false') and ($_GET['rtip_sc_n'] == 'false')) $rtip_sc=-1; if ($_GET['rtip_sc_y'] == 'true') $rtip_sc=1; if ($_GET['rtip_sc_n'] == 'true') $rtip_sc=0; if ($_GET['rtipfl'] == '----------- please select -----------') { $rtip_fl=9999; } else { $rtip_fl=$_GET['rtipfl']; } if ($_GET['rtipfirstout'] == '----------- please select -----------') { $rtip_firstout=9999; } else { $rtip_firstout=$_GET['rtipfirstout']; } if ($_GET['rtipbestcup'] == '----------- please select -----------') { $rtip_bestcup=9999; } else { $rtip_bestcup=$_GET['rtipbestcup']; } if ($_GET['rtipbestteam'] == '----------- please select -----------') { $rtip_bestteam=9999; } else { $rtip_bestteam=$_GET['rtipbestteam']; } $time_check_r_f=mysql_query("SELECT g_id,g_datetime_r FROM gps WHERE g_id='".$_GET['gp_id']."';"); if ($time_check_r=mysql_fetch_array($time_check_r_f)){ $localtime=date("Y-m-d H:i:s",time()+$timeadjust); if (date_diff_f1($localtime,$time_check_r['g_datetime_r']) < 0) { echo ""; if ($rtip_exists==0){ $inserted=mysql_query("INSERT INTO tips (t_u_id,t_g_id,t_e_id,t_d_id_p1,t_d_id_p2,t_d_id_p3,t_fl,t_firstout,t_bestcup,t_bestteam,t_sc,t_timestamp) VALUES (".$_GET['u_id'].",".$_GET['gp_id'].",2,".$_GET['rtip1'].",".$_GET['rtip2'].",".$_GET['rtip3'].",".$rtip_fl.",".$rtip_firstout.",".$rtip_bestcup.",".$rtip_bestteam.",".$rtip_sc.",date_add(now(), interval ".$hourdiff." hour));"); $r_tip_msg="your tip has been placed"; } else { $updated=mysql_query("UPDATE tips SET t_d_id_p1=".$_GET['rtip1'].",t_d_id_p2=".$_GET['rtip2'].",t_d_id_p3=".$_GET['rtip3'].",t_fl=".$rtip_fl.",t_firstout=".$rtip_firstout.",t_bestcup=".$rtip_bestcup.",t_bestteam=".$rtip_bestteam.",t_sc=".$rtip_sc.",t_timestamp=date_add(now(), interval ".$hourdiff." hour) WHERE t_u_id=".$_GET['u_id']." AND t_g_id=".$_GET['gp_id']." aND t_e_id=2;"); $r_tip_msg="your tip has been updated"; } } else { $r_tip_msg="sorry, time has expired"; echo ""; } } } if (($_GET['rtip1']==0) and ($_GET['rtip2']==0) and ($_GET['rtip3']==0)) { $r_tip_msg=""; } } else { echo ""; } } else { echo ""; echo ""; echo ""; // echo ""; // echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "


you
"; echo $selected_u_id=listbox_field($users, 'selectuser', 0,0); echo "
your"; echo " passcode
"; echo " "; echo "
"; echo " "; echo "

you are not a GRID TIPPER yet?
click here to apply for a username

forgot your passcode? click here"; echo "

wrong passcode
"; } } else { echo ""; echo ""; echo ""; // echo ""; // echo ""; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "


you
"; echo $selected_u_id=listbox_field($users, 'selectuser', 0,0); echo "
your"; echo " passcode
"; echo " "; echo "
"; echo " "; echo "

you are not a GRID TIPPER yet?
click here to apply for a username

forgot your passcode? click here"; echo "
"; } ?>