Jump to content

doogie63

Members
 View Profile  See their activity

  • Posts

    20

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by doogie63

  1. doogie63
    ran your script and this is what I get for webpage Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home2/ammotro1/public_html/ass/test.php on line 34 this is line 34 $myDate= $d["year"]."-".$d["mon"]."-".$d["mday"];
  2. doogie63
    here is the view.php of my script could you give me hint or clue what to look for? Do you need the config.php? It really only has info to dbase. <?php require('./config.php'); $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); if($action=="post"){ if ($assname=="" || $asslocation=="" || $asscontent=="" || $name=="" || $email=="" || !isValidEmail($email)){ $msg1 = <<<ENDH <div align="center"> <center> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="373" height="30"> <tr> <td width="373" height="11" bgcolor="#0000FF"> <p align="center"><b><font color="#FFFFFF">Invalid Info</font></b></td> </tr> <tr> <td width="373" height="15" bgcolor="#FFFFFF"> <p align="center"><Font color=red>You have entered invalid information</font></td> </tr> </table> <br><p align="center">Press the back button to correct your information</p> </center> </div> ENDH; printContent($msg1); } else { $table_db = $ASS[$form]; $d = getdate (time()); $myDate= $d["year"]."-".$d["mon"]."-".$d["mday"]; $sql_query = "INSERT INTO $table_db (name, email, assname, asslocation, asscontent, publish, id, date) VALUES ('$name', '$email', '$assname', '$asslocation', '$asscontent', 'N', '', '$myDate')"; $gholi= mysql_query( $sql_query , $conn ); $msg1 = <<<ENDH <div align="center"> <center> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="373" height="30"> <tr> <td width="373" height="11" bgcolor="#0000FF"> <p align="center"><b><font color="#FFFFFF">Submission Information</font></b></td> </tr> <tr> <td width="373" height="15" bgcolor="#FFFFFF"> <p align="center"><Font color=green>Thankyou For your submission</font></td> </tr> </table> <br><p align="center">Click here <a href="http://www.ammotroops.com/">Ammotroops</a> to go to main page</p> </center> </div> ENDH; printContent($msg1); } } else if($action=="view"){ if($start=="" || $start < 0){ $start=0; } $max=$default_max; if(($start % $max) != 0){ header("Location:$home/$view?action=view&start=0&form=$form"); } if($pg==""){ $pg=1; } $num_cat = count($ASS); if($form >= $num_cat || $form < 0 || $form=="" ){ header ("Location: $home"); exit; } $table_db = $ASS[$form]; $num_rows = mysql_num_rows(mysql_query("SELECT * FROM $table_db where publish=\"Y\"")); $remainder = ($num_rows % $max); if(($start+$max) > ($num_rows + ($max - $remainder))){ $start=0; $max = $default_max; } head($form,$Title,$formpg); $sql_select_query = "SELECT * FROM $table_db WHERE publish=\"Y\" ORDER BY date DESC LIMIT $start,$max"; //echo $sql_select_query; $select_info = mysql_query( $sql_select_query , $conn ); while( $theRow = mysql_fetch_row( $select_info )){ echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[7]</td><td width=\"371\" height=\"24\" rowspan=\"4\">$theRow[4]</td></tr>"; echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[2]</td></tr>"; echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[3]</td></tr><tr><td height=100%> </td></tr>"; echo "</tr><tr><td width=\"555\" height=\"1\" colspan=\"2\" bgcolor=\"#E2E1D1\"> </td></tr>"; } echo "</table></div>"; $num_rows = mysql_num_rows(mysql_query("SELECT * FROM $table_db where publish=\"Y\"")); echo "Page: "; $remainder = ($num_rows % $max); $num_pg = (int)($num_rows / $max); if($remainder > 0) $num_pg = $num_pg+1; for ($i=0; $i< $num_pg; $i++) { $startVal = $i * $max; $page = $i+1; echo "\n<a href=$view?action=view&start=$startVal&max=$max&form=$form>$page</a> "; } mysql_close ($conn); foot(); } function isValidEmail($email){ if( strstr($email,'@') ) { return true; } else{ return false; } } function foot(){ $foot = <<<ENDH </center> </body> </html> ENDH; echo $foot; } function head($form,$Title,$formpg){ $head = <<<ENDH <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta name="Author" content="doogie"> <meta name="keywords" content="ammo, newgroups, binnews, ammo bowl, iyaayas, doogie, air force, ammo ass award, ammo dumb ass, ammo ace, ammo base"> <title>Ammo Ass www.AmmoTroops.com</title> </head> <body background="http://ass.ammotroops.com/froncoin4.jpg"> <center><a href="http://www.ammotroops.com">www.AmmoTroops.com</a> <div width="600"> <table align=center><tr><td align=center><b><font color="#FF0000"><font size="+3">$Title[$form] AWARD</font></font></b></td></tr> <tr><td align=center><a href=$formpg?form=$form>$Title[$form] Form</a></td></tr><tr><td> <br><br></td></tr></table> <table BORDER="1" COLS="2" WIDTH="577"> <tr> <td width="131" height="19" bgcolor="#E2E1D1"><center> <p><b>Date</b></p> </center></td> <td width="424" height="31" bgcolor="#E2E1D1" rowspan="3" valign="middle"> <p align="center"><b>Why</b></td> </tr> <tr> <td width="134" height="12" bgcolor="#E2E1D1"> <p align="center"><b>Name</b></td> </tr> <tr> <td width="134" height="1" bgcolor="#E2E1D1"> <p align="center"><b>Location</b></td> </tr> ENDH; echo $head; } function printContent($content){ $html = <<<ENDH <html> <head> <title>Ammo TRoops</title> </head> <body background="http://ass.ammotroops.com/froncoin4.jpg"> $content </body></html> ENDH; echo $html; } ?>
  3. doogie63
    I did not change my php.ini file yet with error info I did delete my php.ini file to try to break script again so I could read error.log I went to my cpanel and click error log but nothing came up about error for my php.view When I know goto url I just get blank page since global is turn off.
  4. doogie63
    You are right this is hard, plus im a noob. I did search on script looking for: $_ session variable I guess I need to turn off register_globals = On in my php.ini file so I will get errors and then add into my php.ini error_reporting -1
  5. doogie63
    I did not write the script someone wrote it for me long time ago. This is what script does http://ass.ammotroops.com/view.php?action=view&form=0 http://ass.ammotroops.com/view.php?action=view&form=1 http://ass.ammotroops.com/view.php?action=view&form=3 http://ass.ammotroops.com/view.php?action=view&form=4 and http://ass.ammotroops.com/guestbook1.php?a=B What should I look for in script to change, Im a noob but willing to learn and try to figure it out. Script also has admin where I click to post submit name, on the guestbook it send me email and I click link in email to update guestbook. Thaks for anyhelp
  6. doogie63
    How do I use jumi inside Joomla if the php code I want to run also needs a config.php file? I have put both files, guestbook.php and config.php into jumi/files but I get error i get same error if i past guestbook.php into jumi Warning: require(./config.php) [function.require]: failed to open stream: No such file or directory in /home2/website/public_html/components/com_jumi/files/guestbook.php on line 2 Fatal error: require() [function.require]: Failed opening required './config.php' (include_path='.:/usr/share/pear') in /home2/website/public_html/components/com_jumi/files/guestbook.php on line 2 also having trouble with this inside joomla using jumi, outside joomla not using jumi it works fine. http://ass.ammotroops.com/view.php?action=view&form=0 http://ass.ammotroops.com/view.php?action=view&form=1 http://ass.ammotroops.com/view.php?action=view&form=3 http://ass.ammotroops.com/view.php?action=view&form=4
  7. doogie63
    I need help with Jumi module for Joomla Can not figure out how to use code with /view.php?action=view&form=0 at end of url thanks
  8. doogie63
    I have script that I need register_globals = On right now I have to put php.ini into root of my webpage on webhost. but that means it turn on register_globals = On for whole site. I have tried just putting php.ini into subdomain but does not work, well script does not work. I have tried to put AddHandler application/x-httpd-php5s .php into the .htaccess in subdomain but that does not work either, script stop working. I can not get script to work if php.ini is in root of webpage webhost. What I'm I doing wrong, thanks
  9. doogie63
    Well everything is now working on site as far as my script goes. Now just trying to move it inside joomla using jumi module. Not having much luck but at least no matter what it will work outside joomla. Thanks for all the help.
  10. doogie63
    This is what I got back from Help desk of web host. Now working. http://ass.ammotroops.com/guestbook1.php?a=A http://ass.ammotroops.com/view.php?action=view&form=0 It looks like your script heavily relies on register_globals being on but it is currently set off by default. I noticed you had a php.ini file in that folder to try and turn them on but you are also using the Single INI version of our php which will only use the public_html/php.ini for all php settings. You would need to make that change in a php.ini file located in the public_html or you would need to set a different PHP type in that folder so that it will check the php.ini in that folder. To change the php type you could add "AddHandler application/x-httpd-php5 .php" into your .htaccess in that folder. I put my php.ini file in public_html and now it works, before I just had it in ass. I dont really understand what they want me to do to: "AddHandler application/x-httpd-php5 .php" into your .htaccess would I just add that line just as it reads into my .htaccess?
  11. doogie63
    in admin.php I have $conn1 = mysql_connect( $dbhost, $dbuser, $dbpass ); in guestbook1.php I have $conn = mysql_connect( $dbhost, $dbuser, $dbpass );
  12. doogie63
    http://ass.ammotroops.com/guestbook1.php?a=A guestbook1.php is using same congfig.php and it works connection to db. So I have right user name and password
  13. doogie63
    $conn1 = mysql_connect( $dbhost, $dbuser, $dbpass ); which in config.php gives answers. I edit it to post not to give out real user or pass, that i have the right info in config. //enter user info in here $dbhost="localhost"; $dbuser="user"; $dbpass="pass"; $dbname="doogie_ass";
  14. doogie63
    In the config.php I have the new database name, user, and password. Thats why http://ass.ammotroops.com/guestbook1.php?a=A works, its pulls info from config to open db to get info. I think thats what you are talking about?
  15. doogie63
    I think the error is talking about this part, What a good book I can start to read to learn more about php? For noob else $givenPass = $passwd; $sql_select_query = "SELECT * FROM ammopass"; $select_info = mysql_query( $sql_select_query , $conn1 ); $theRow = mysql_fetch_row( $select_info ); $currentPass = $theRow[0]; mysql_close($conn1); if ($currentPass==$givenPass) return true; else return false;
  16. doogie63
    error log for admin.php 10:44:03] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/ammotro1/public_html/ass/admin.php on line 220 [09-Feb-2012 10:44:03] PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/ammotro1/public_html/ass/admin.php on line 221 [09-Feb-2012 10:44:03] PHP Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home2/ammotro1/public_html/ass/admin.php on line 223
  17. doogie63
    I do have a php.ini I had to do that before on one of the other webhost. The other thing you wanted me to try not sure how to do that. Friend wrote the script but is not around anymore. It was over 10 yrs ago. register_globals = On
  18. doogie63
    I move my website to new webhost and now script does not work. Thinking maybe newer version of php. This script is old been using for 10 yrs and has worked on 3 different webhost. It has config.php which the only thing I should have to change is db name, db user, and db password which I did but still does not work. dont work http://ass.ammotroops.com/view.php?action=view&form=0 http://ass.ammotroops.com/view.php?action=view&form=1 http://ass.ammotroops.com/view.php?action=view&form=2 http://ass.ammotroops.com/view.php?action=view&form=3 http://ass.ammotroops.com/admin.php Somewhat works; http://ass.ammotroops.com/guestbook1.php?a=A It suppose to be able to click letter at top to switch users but stays with A's and form does not work. But at least I know config.php is working because it get info from mysql. If I change inside guestbook1.php $a= "a"; If I change "a" to "b" it will display b's config.php: <?php //enter user info in here $dbhost="localhost"; $dbuser="user"; $dbpass="password"; $dbname="database"; //enter the max per page default value $default_max=20; //here are your different categories. //Please do _NOT_ add to this list $ASS = array ( "ammoass", "ammodumbass", "ammoace", "ammobase" ); $Title = array ( "AMMO ASS", "AMMO DUMB ASS", "AMMO ACE", "AMMO BASE" ); //home URL (no trailing slash) $home = "[url]http://www.ammotroops.com/ass[/url]"; $formpg = "forms.php"; $view = "view.php"; $admin = "admin.php"; $guestbookTitle = "Guest Book"; $e_mail="[email][email protected][/email]"; ?> admin.php <?php require('config.php'); $status=0; if(isset($passwd)) $status=1; if($action=="logout"){ setcookie("passwd", "", time()-3600); header("Location: $home/$admin?action=login"); } elseif($action=="login"){ loginPage($home,$admin,$login); } elseif(passwd($password,$passwd, $dbhost, $dbuser, $dbpass, $dbname,$status) == true ){ if($status==0){ setcookie("passwd", md5($password)); } if($action=="view"){ $num_cat = count($ASS); if($form >= $num_cat || $form < 0 || $form=="" ){ head($admin); echo " There is No Such Section"; foot(); exit; } head($admin); $table_db = $ASS[$form]; $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $sql_select_query = "SELECT * FROM $table_db ORDER BY date DESC"; $select_info = mysql_query( $sql_select_query , $conn ); echo "<table BORDER=\"1\" COLS=\"2\" WIDTH=\"577\">"; $count=0; while( $theRow = mysql_fetch_row( $select_info )){ echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[7]</td>"; echo "<td width=\"371\" height=\"24\" rowspan=\"4\">$theRow[4]</td></tr>"; echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[2]</td></tr>"; echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[3]</td></tr>"; echo "<tr><td height=100%><center>"; if($theRow[8] == 0) echo "<font color=red>NEW</font>"; echo " <a href=$admin?action=edit&form=$form&num=$theRow[6]>EDIT</a></center></td></tr>"; echo "</tr><tr><td width=\"555\" height=\"1\" colspan=\"3\" bgcolor=\"#E2E1D1\"> </td></tr>"; $count = $count+1; } echo "</table>"; mysql_close ($conn); foot(); } elseif($action=="edit"){ if($form=="" || $num==""){ header("LOCATION: $home/$admin"); exit; } head($admin); $table_db = $ASS[$form]; $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $sql_select_query = "SELECT * FROM $table_db WHERE id=$num"; $select_info = mysql_query( $sql_select_query , $conn ); $theRow = mysql_fetch_row( $select_info); echo "<form method=\"POST\" action=\"$admin?action=finaledit\"><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"100%\" height=\"1\" id=\"AutoNumber1\">"; echo "<tr><td width=\"131\" height=\"1\" align=\"right\"><b><font size=\"2\">NAME:</font></b></td><td width=\"8\" height=\"1\" align=\"right\"></td><td width=\"667\" height=\"1\">"; echo "<input type=\"text\" name=\"name\" value=\"$theRow[0]\" size=\"20\">"; echo "</td></tr><tr><td width=\"131\" height=\"1\" align=\"right\"><b><font size=\"2\">EMAIL:</font></b></td><td width=\"8\" height=\"1\" align=\"right\"></td><td width=\"667\" height=\"1\">"; echo "<input type=\"text\" name=\"email\" value=\"$theRow[1]\"size=\"20\">"; echo "</td></tr><tr><td width=\"131\" height=\"26\" align=\"right\"><b><font size=\"2\">ASS NAME:</font></b></td><td width=\"8\" height=\"26\" align=\"right\"> </td><td width=\"667\" height=\"26\">"; echo "<input type=\"text\" name=\"assname\" value=\"$theRow[2]\" size=\"20\">"; echo "</td></tr><tr><td width=\"131\" height=\"1\" align=\"right\"><b><font size=\"2\">ASS LOCATION:</font></b></td><td width=\"8\" height=\"1\" align=\"right\"></td><td width=\"667\" height=\"1\">"; echo "<input type=\"text\" name=\"asslocation\" size=\"20\" value=\"$theRow[3]\">"; echo "</td></tr><tr><td width=\"131\" height=\"148\" valign=\"top\"><p align=\"right\"><br><b><font size=\"2\">WHY:</font></b></td><td width=\"8\" height=\"148\"><b><font size=\"2\"> </font></b></td><td width=\"667\" height=\"148\"><b><font size=\"2\">"; echo "<textarea rows=\"6\" name=\"asscontent\" cols=\"40\">$theRow[4]</textarea>"; echo "<br><BR><b>PUBLISH:</b> YES<input type=\"radio\" value=\"Y\" name=\"publish\"> NO<input type=\"radio\" value=\"N\" checked name=\"publish\">"; echo "<input type=hidden name=num value=$num><input type=hidden name=form value=$form><br><br><b>DATE: </b> <input type=text name=date value=\"$theRow[7]\" >"; echo "</font></b></td> </tr><tr><td width=\"131\" height=\"53\"> </td><td width=\"8\" height=\"53\"> </td><td width=\"667\" height=\"53\"><input type=\"submit\" value=\"Submit\" name=\"B1\"></td></tr></table></form><table><tr><td width=95> </td><td><form method=post action=$admin?action=delete><input type=hidden name=form value=$form><input type=hidden name=num value=$num><input type=submit value=Delete name=delete></form></td></tr></table>"; mysql_close ($conn); foot(); } elseif($action=="finaledit"){ head($admin); $table_db = $ASS[$form]; $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $sql_select_query = "UPDATE $table_db SET name='$name', email='$email', assname='$assname', asslocation='$asslocation', asscontent='$asscontent', publish='$publish', date='$date', num='1' WHERE id=$num"; $select_info = mysql_query( $sql_select_query , $conn ); mysql_close ($conn); echo "UPDATED FIELD"; foot(); } elseif($action=="chgpass"){ if($chng == 1 && $pass1 == $pass2 && $pass1 != ""){ ChangePass($pass1, $dbhost, $dbuser,$dbpass,$dbname); head($admin); echo "<center><font color=red size=2>Password Has been Set</font></center>"; foot(); exit; } head($admin); if($chng == 1){ echo "<font color=red size=2> Make Sure Passwords in both fields are the same </font>"; } echo "<div align=\"left\"><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"482\" height=\"166\">"; echo "<tr><td width=\"482\" height=\"25\"><u><b>Change Password</b></u></td></tr><tr><td width=\"482\" height=\"141\">"; echo "<form method=\"POST\" action=\"$admin?action=chgpass\">"; echo "New Password: <input type=\"password\" name=\"pass1\" size=\"20\"><br>"; echo "New Password again: <input type=\"password\" name=\"pass2\" size=\"20\"><br>"; echo "<input type=hidden name=chng value=1><input type=\"submit\" value=\"Submit\" name=\"B1\"></form></td></tr></table></div>"; foot(); } elseif($action=="delete"){ if($form=="" || $num==""){ header("Location: $home/$admin"); } head($admin); $table_db = $ASS[$form]; $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $sql_select_query = "DELETE FROM $table_db where id=$num"; $select_info = mysql_query( $sql_select_query , $conn ); mysql_close ($conn); echo "ENTRY DELETED"; foot(); } else{ head($admin); echo " You Are Logged In"; foot(); } } else{ header("LOCATION: $home/$admin?action=login"); } function loginPage($home, $admin,$flag){ $pageCode = <<<ENDH <html><head> <meta http-equiv="expires" content="Thu, 01-Jan-1970 00:00:01 GMT"> <title>AMMO TROOPS ADMIN</title></head><body> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="55%" id="AutoNumber1" height="140"> <tr> <td width="1%" height="19" bgcolor="#3366CC"> </td> <td width="55%" height="19" bgcolor="#3366CC"> <font face="Verdana" size="2" color="#FFFFFF"><b>Ammo Troops Admin Area</b></font></td> <td width="1%" height="19" bgcolor="#3366CC"> </td> </tr> <tr> <td width="1%" height="104"> </td> <td width="55%" height="104"><form method="POST" action="$home/$admin"> ENDH; echo $pageCode; if($flag == 1) echo "<font color=red size=2>Invalid Login, Please Try again</font>"; $pageCode = <<<ENDH <p>Please Login in: <br> <input type="password" name="password" size="20"> <input type="hidden" name="login" value="1"> <input type="submit" value="Login" name="B1"> </p> </p> </form></td> <td width="1%" height="104"> </td> </tr> <tr> <td width="57%" height="19" colspan="3" bgcolor="#3366CC"> <p align="center"><font size="2" face="Verdana" color="#FFFFFF">Made for Ammo (<a href="[url]http://www.ammotroops.com/[/url]"><font color=white>www.AmmoTroops.com</font></a>)</font></td> </tr></table></body></html> ENDH; echo $pageCode; } function ChangePass($password, $dbhost, $dbuser, $dbpass, $dbname){ $conn1 = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn1); $givenPass = md5($password); $sql_select_query = "UPDATE ammopass SET password='$givenPass' WHERE id=1"; $select_info = mysql_query( $sql_select_query , $conn1 ); setcookie("passwd", md5($password)); mysql_close ($conn1); } function passwd($password, $passwd,$dbhost, $dbuser, $dbpass, $dbname, $status){ $conn1 = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn1); if($status == 0) $givenPass = md5($password); else $givenPass = $passwd; $sql_select_query = "SELECT * FROM ammopass"; $select_info = mysql_query( $sql_select_query , $conn1 ); $theRow = mysql_fetch_row( $select_info ); $currentPass = $theRow[0]; mysql_close($conn1); if ($currentPass==$givenPass) return true; else return false; } function isValidEmail($email){ if( strstr($email,'@') ) { return true; } else{ return false; } } function foot(){ $foot = <<<ENDH </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td width="57%" height="19" colspan="3" bgcolor="#3366CC"> <p align="center"><font size="2" face="Verdana" color="#FFFFFF">Made for Ammo ([url=http://www.AmmoTroops.com]www.AmmoTroops.com[/url])</font></td> </tr></table></body></html> ENDH; echo $foot; } function head($admin){ $head = <<<ENDH <html><head> <title>AMMO TROOPS ADMIN</title></head><body> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600" id="AutoNumber1" height="140"> <tr> <td width="1%" height="19" bgcolor="#3366CC"> </td> <td width="57%" height="19" bgcolor="#3366CC"> <font face="Verdana" size="2" color="#FFFFFF"><b>Ammo Troops Admin Area</b></font></td> </tr> <tr> <td width="58%" height="104" colspan="2"> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="109"> <tr> <td width="22%" height="109" valign=top> <table border="1" style="border-collapse: collapse" bordercolor="#111111" width="170" id="AutoNumber3" height="151" cellpadding="0" cellspacing="0"> <tr> <td width="100%" height="19"> <p dir="ltr"> </td> </tr> <tr> <td width="100%" height="15" bgcolor="#3366CC"> <p dir="ltr"><b> <font face="Times New Roman" size="2" color="#FFFFFF">> VIEW</font></b></td> </tr> <tr> <td width="100%" height="79" bgcolor="#0099FF"> <ul> <li> <p dir="ltr"><b><font face="Times New Roman" size="2"><a href="$admin?action=view&form=0">AMMO ASS</a></font></b></li> <li> <p dir="ltr"><b><font face="Times New Roman" size="2"><a href="$admin?action=view&form=1">AMMO DUMB ASS</a></font></b></li> <li> <p dir="ltr"><b><font face="Times New Roman" size="2"><a href="$admin?action=view&form=2">AMMO ACE</a></font></b></li> <li> <p dir="ltr"><b><font face="Times New Roman" size="2"><a href="$admin?action=view&form=3">AMMO BASE</a></font></b></li> </ul> </td> </tr> <tr> <td width="100%" height="19" bgcolor="#3366CC"> <p dir="ltr"><b> <a href=$admin?action=logout><font face="Times New Roman" size="2" color="#FFFFFF">> LOGOUT</font></a></b></td> </tr> <tr> <td width="100%" height="11" bgcolor="#3366CC"> <p dir="ltr"><b><a href=$admin?action=chgpass> <font face="Times New Roman" size="2" color="#FFFFFF">> CHANGE PASSWORD</font></a></b></td> </tr> <tr> <td width="100%" height="19"> </td> </tr> </table> </td> <td width="78%" height="109"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber4"> <tr> <td> </td><td width="100%"> ENDH; echo $head; } ?> view.php <?php require('./config.php'); $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); if($action=="post"){ if ($assname=="" || $asslocation=="" || $asscontent=="" || $name=="" || $email=="" || !isValidEmail($email)){ $msg1 = <<<ENDH <div align="center"> <center> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="373" height="30"> <tr> <td width="373" height="11" bgcolor="#0000FF"> <p align="center"><b><font color="#FFFFFF">Invalid Info</font></b></td> </tr> <tr> <td width="373" height="15" bgcolor="#FFFFFF"> <p align="center"><Font color=red>You have entered invalid information</font></td> </tr> </table> <br><p align="center">Press the back button to correct your information</p> </center> </div> ENDH; printContent($msg1); } else { $table_db = $ASS[$form]; $d = getdate (time()); $myDate= $d["year"]."-".$d["mon"]."-".$d["mday"]; $sql_query = "INSERT INTO $table_db (name, email, assname, asslocation, asscontent, publish, id, date) VALUES ('$name', '$email', '$assname', '$asslocation', '$asscontent', 'N', '', '$myDate')"; $gholi= mysql_query( $sql_query , $conn ); $msg1 = <<<ENDH <div align="center"> <center> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="373" height="30"> <tr> <td width="373" height="11" bgcolor="#0000FF"> <p align="center"><b><font color="#FFFFFF">Submission Information</font></b></td> </tr> <tr> <td width="373" height="15" bgcolor="#FFFFFF"> <p align="center"><Font color=green>Thankyou For your submission</font></td> </tr> </table> <br><p align="center">Click here <a href="[url]http://www.ammotroops.com/[/url]">Ammotroops</a> to go to main page</p> </center> </div> ENDH; printContent($msg1); } } else if($action=="view"){ if($start=="" || $start < 0){ $start=0; } $max=$default_max; if(($start % $max) != 0){ header("Location:$home/$view?action=view&start=0&form=$form"); } if($pg==""){ $pg=1; } $num_cat = count($ASS); if($form >= $num_cat || $form < 0 || $form=="" ){ header ("Location: $home"); exit; } $table_db = $ASS[$form]; $num_rows = mysql_num_rows(mysql_query("SELECT * FROM $table_db where publish=\"Y\"")); $remainder = ($num_rows % $max); if(($start+$max) > ($num_rows + ($max - $remainder))){ $start=0; $max = $default_max; } head($form,$Title,$formpg); $sql_select_query = "SELECT * FROM $table_db WHERE publish=\"Y\" ORDER BY date DESC LIMIT $start,$max"; //echo $sql_select_query; $select_info = mysql_query( $sql_select_query , $conn ); while( $theRow = mysql_fetch_row( $select_info )){ echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[7]</td><td width=\"371\" height=\"24\" rowspan=\"4\">$theRow[4]</td></tr>"; echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[2]</td></tr>"; echo "<tr><td align=center width=\"200\" height=\"1\">$theRow[3]</td></tr><tr><td height=100%> </td></tr>"; echo "</tr><tr><td width=\"555\" height=\"1\" colspan=\"2\" bgcolor=\"#E2E1D1\"> </td></tr>"; } echo "</table></div>"; $num_rows = mysql_num_rows(mysql_query("SELECT * FROM $table_db where publish=\"Y\"")); echo "Page: "; $remainder = ($num_rows % $max); $num_pg = (int)($num_rows / $max); if($remainder > 0) $num_pg = $num_pg+1; for ($i=0; $i< $num_pg; $i++) { $startVal = $i * $max; $page = $i+1; echo "\n<a href=$view?action=view&start=$startVal&max=$max&form=$form>$page</a> "; } mysql_close ($conn); foot(); } function isValidEmail($email){ if( strstr($email,'@') ) { return true; } else{ return false; } } function foot(){ $foot = <<<ENDH </center> </body> </html> ENDH; echo $foot; } function head($form,$Title,$formpg){ $head = <<<ENDH <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta name="Author" content="doogie"> <meta name="keywords" content="ammo, newgroups, binnews, ammo bowl, iyaayas, doogie, air force, ammo ass award, ammo dumb ass, ammo ace, ammo base"> <title>Ammo Ass [url=http://www.AmmoTroops.com]www.AmmoTroops.com[/url]</title> </head> <body background="[url]http://ass.ammotroops.com/froncoin4.jpg[/url]"> <center><a href="[url]http://www.ammotroops.com[/url]">www.AmmoTroops.com</a> <div width="600"> <table align=center><tr><td align=center><b><font color="#FF0000"><font size="+3">$Title[$form] AWARD</font></font></b></td></tr> <tr><td align=center><a href=$formpg?form=$form>$Title[$form] Form</a></td></tr><tr><td> <br><br></td></tr></table> <table BORDER="1" COLS="2" WIDTH="577"> <tr> <td width="131" height="19" bgcolor="#E2E1D1"><center> <p><b>Date</b></p> </center></td> <td width="424" height="31" bgcolor="#E2E1D1" rowspan="3" valign="middle"> <p align="center"><b>Why</b></td> </tr> <tr> <td width="134" height="12" bgcolor="#E2E1D1"> <p align="center"><b>Name</b></td> </tr> <tr> <td width="134" height="1" bgcolor="#E2E1D1"> <p align="center"><b>Location</b></td> </tr> ENDH; echo $head; } function printContent($content){ $html = <<<ENDH <html> <head> <title>Ammo TRoops</title> </head> <body background="[url]http://ass.ammotroops.com/froncoin4.jpg[/url]"> $content </body></html> ENDH; echo $html; } ?> guestbook1.php <?php require('./config.php'); $fname = stripslashes($fname); $lname = stripslashes($lname); $rank = stripslashes($rank); $email = stripslashes($email); $current_base = stripslashes($current_base); $deros = stripslashes($deros); $shop = stripslashes($shop); $autovon = stripslashes($autovon); $previous_ass = stripslashes($previous_ass); $comments = stripslashes($comments); if($action == "form"){ printContent(showForm("",$fname,$lname,$rank,$email,$current_base,$deros,$shop,$autovon,$previous_ass,$comments),$guestbookTitle); } else if($action == "submit"){ if($fname=="" || $lname=="" || $rank=="" || $email =="" || $current_base == "" || $deros == "" || $shop == "" || $autovon == "" || $previous_ass=="" || $comments == ""){ printContent(showForm("Please Fill in all Fields", $fname,$lname,$rank, $email,$current_base,$deros,$shop,$autovon,$previous_ass,$comments),$guestbookTitle); } else if(!isValidEmail($email)){ printContent(showForm("You Have Entered An Invalid Email Address", $fname,$lname,$rank,$email,$current_base,$deros,$shop,$autovon,$previous_ass,$comments),$guestbookTitle); } else if(isDuplicatedName($fname,$lname,$dbhost,$dbname,$dbuser,$dbpass)){ //printContent("duplicated",$guestbookTitle); $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $fname = addslashes($fname); $lname = addslashes($lname); $rank = addslashes($rank); $email = addslashes($email); $current_base = addslashes($current_base); $deros = addslashes($deros); $shop = addslashes($shop); $autovon = addslashes($autovon); $previous_ass = addslashes($previous_ass); $comments = addslashes($comments); $sqlInsert = "INSERT INTO ammoupdate VALUES ('', '$fname', '$lname', '$rank', '$email', '$current_base', '$deros', '$shop', '$autovon', '$previous_ass', '$comments', '');"; mysql_query($sqlInsert); $id = mysql_insert_id(); mysql_close ($conn); $to = "AMMOTROOP <$e_mail>"; $subject = "GUESTBOOK - USER UPDATED INFO - AMMOTROOPS"; $message = <<<ENDH <html> <head><title>USER UPDATED THEIR INFO</title></head> <body> <p><u><b>USER <font color=green>"$fname $lname"</font> HAS UPDATED THEIR INFO<br> <br> </b></u>Go to address below to view and validated this users info.<br> ---------------------------------------------------------- <br><br> <a href="$home/guestbookupdate1.php?action=view&item=$id">$home/guestbookupdate1.php?action=view&item=$id</a> </p> </body></html> ENDH; /* To send HTML mail, you can set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; /* additional headers */ $headers .= "From: AMMOTROOPS WEBSITE <[email][email protected][/email]>\r\n"; /* and now mail it */ mail($to, $subject, $message, $headers); $msg = <<<ENDH <div align="center"> <center> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="373" height="30"> <tr> <td width="373" height="11" bgcolor="#0000FF"> <p align="center"><b><font color="#FFFFFF">Updating Information</font></b></td> </tr> <tr> <td width="373" height="15" bgcolor="#FFFFFF"> <p align="center"> Thankyou for registrering. Your information has been sent for confirmation.</p></td> </tr> </table> <br><p align="center">Click <a href=http://www.ammotroops.com/>here</a> to return to main page.</p> </center> </div> ENDH; printContent($msg, $guestbookTitle); } else{ $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $fname = addslashes($fname); $lname = addslashes($lname); $rank = addslashes($rank); $email = addslashes($email); $current_base = addslashes($current_base); $deros = addslashes($deros); $shop = addslashes($shop); $autovon = addslashes($autovon); $previous_ass = addslashes($previous_ass); $comments = addslashes($comments); $sqlInsert = "INSERT INTO ammoupdate VALUES ('', '$fname', '$lname', '$rank', '$email', '$current_base', '$deros', '$shop', '$autovon', '$previous_ass', '$comments', '');"; mysql_query($sqlInsert); $id = mysql_insert_id(); mysql_close ($conn); $to = "AMMOTROOP <$e_mail>"; $subject = "GUESTBOOK - NEW USER - AMMOTROOPS"; $message = <<<ENDH <html> <head><title>USER ADDED THEIR INFO</title></head> <body> <p><u><b>USER <font color=green>"$fname $lname"</font> HAS ADDED THEIR INFO<br> <br> </b></u>Go to address below to view and validated this users info.<br> ---------------------------------------------------------- <br><br> <a href="$home/guestbookupdate1.php?action=view&item=$id&type=new">$home/guestbookupdate1.php?action=view&item=$id&type=new</a> </p> </body></html> ENDH; /* To send HTML mail, you can set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; /* additional headers */ $headers .= "From: AMMOTROOPS WEBSITE <[email][email protected][/email]>\r\n"; /* and now mail it */ mail($to, $subject, $message, $headers); $msg = <<<ENDH <div align="center"> <center> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="373" height="30"> <tr> <td width="373" height="11" bgcolor="#0000FF"> <p align="center"><b><font color="#FFFFFF">Registration Successfull</font></b></td> </tr> <tr> <td width="373" height="15" bgcolor="#FFFFFF"> <p align="center"> Thankyou for registrering. Your name has been added to the $guestbookTitle.</td> </tr> </table> <br><p align="center">Click <a href=http://www.ammotroops.com/>here</a> to return to main page.</p> </center> </div> ENDH; printContent($msg, $guestbookTitle); } } else { if($a=="" || ord($a) >90 || ord($a) < 65 ) $a= "a"; $a = strtolower($a); ?> <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <head> <title>Guestbook</title> </head> <body background="[url]http://ass.ammotroops.com/froncoin4.jpg[/url]"> <center> <p style="margin-top: 0; margin-bottom: 0"><font size="+2"> <a href="[url]http://www.ammotroops.com/[/url]">HOME</a></font> <br> <font size="+2"> <?php for ($i=0; $i<26; $i++){ $ch = chr(65+$i); echo " <a href=\"guestbook1.php?a=$ch\" target=\"_top\">$ch</a>"; } ?> </font> </p> <p style="margin-top: 0; margin-bottom: 0"><b><font size="+3" color="#FF0000"> Welcome to the Locator</font></b> <br> <b><font size="+3" color="#FF0000"><?=strtoupper($a)?></font></b> </p> <p style="margin-top: 0; margin-bottom: 0"><br> <b><a href="guestbook1.php?action=form" target="_top"> <font size="6">Locator Form</font></a></b></p> </center> <?php $sqlstat = "SELECT * from ammoguest where alpha=\"$a\" order by lname"; $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $select_info = mysql_query( $sqlstat , $conn ); while( $theRow = mysql_fetch_row( $select_info )){ ?> <img SRC="[url]http://ass.ammotroops.com/flagbar.gif[/url]" height="16" width="700"><br> NAME: <?=$theRow[2]?>, <?=$theRow[1]?><br> RANK: <?=$theRow[3]?><br> EMAIL: <a href="mailto:<?=$theRow[4]?>"><?=$theRow[4]?></a><br> CURRENT BASE: <?=$theRow[5]?><br> DEROS: <?=$theRow[6]?><br> SHOP: <?=$theRow[7]?><br> AUTOVON#: <?=$theRow[8]?><br> PREVIOUS ASSIGNMENTS: <?=preg_replace("[\n\r\f]","<br>\n",$theRow[9])?><br> COMMENTS: <?=preg_replace("[\n\r\f]","<br>\n",$theRow[10])?><br> <?php } mysql_close ($conn); } ///////////////////////////////////////////////////////////////////// ////////////// check duplicated name //////////////////////////////// ///////////////////////////////////////////////////////////////////// function isDuplicatedName($fname,$lname,$dbhost,$dbname,$dbuser,$dbpass){ $conn = mysql_connect( $dbhost, $dbuser, $dbpass ); mysql_select_db($dbname,$conn); $sql = "select * from ammoguest where fname='$fname' and lname='$lname'"; $num_rows = mysql_num_rows(mysql_query($sql)); //echo $sql; if($num_rows > 0) return true; else return false; mysql_close ($conn); } ///////////////////////////////////////////////////////////////////// ////////////// Validate Email Address /////////////////////////////// ///////////////////////////////////////////////////////////////////// function isValidEmail($email){ if( strstr($email,'@') ) { return true; } else{ return false; } } ///////////////////////////////////////////////////////////////////// // SHOW FORM WITH MSG//////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////// function showForm($msg, $fname,$lname,$rank, $email,$current_base,$deros,$shop,$autovon,$previous_ass,$comments){ $html = <<<ENDH <form action=guestbook1.php?action=submit method=post> <center> <h1 style="margin-top: 0; margin-bottom: 0"> <a href="[url]http://www.ammotroops.com/[/url]">www.AmmoTroops.com</a></h1> <h1 style="margin-top: 0; margin-bottom: 0"><font COLOR="#000000">Thanks for visiting my site!</font> </h1> <p style="margin-top: 0; margin-bottom: 0"> </p> <p style="margin-top: 0; margin-bottom: 0"><b>Guess Book!</b></p> <p style="margin-top: 0; margin-bottom: 0"></p> <p style="margin-top: 0; margin-bottom: 0">Just complete this form. Click on Submit when ready to send.</p> <br><br> <Font size=4 color=red>$msg</font> </center> <table id="AutoNumber2" style="BORDER-COLLAPSE: collapse" borderColor="#111111" height="34" cellSpacing="0" cellPadding="0" width="100%" border="0"> <tr> <td width="26%" height="36"><b><font size="4">First Name:</font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="fname" value="$fname"></font></b></td> </tr> <tr> <td width="26%" height="36"><b><font size="4">Last Name:</font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="lname" value="$lname"></font></b></td> </tr> <tr> <td width="26%" height="36"><b><font size="4">Rank: </font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="rank" value="$rank"></font></b></td> </tr> <tr> <td width="26%" height="36"><b><font size="4">E-Mail Address:</font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="email" value="$email"></font></b></td> </tr> <tr> <td width="26%" height="36"><b><font size="4">Current Base:</font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="current_base" value="$current_base"></font></b></td> </tr> <tr> <td width="26%" height="36"><b><font size="4">DEROS:</font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="deros" value="$deros"></font></b></td> </tr> <tr> <td width="26%" height="36"><b><font size="4">SHOP:</font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="shop" value="$shop"></font></b></td> </tr> <tr> <td width="26%" height="36"><b><font size="4">AUTOVON:</font></b></td> <td width="74%" height="36"><b><font size="4"> <input maxLength="50" size="36" name="autovon" value="$autovon"></font></b></td> </tr> </table> <pre><b><font size="4">PREVIOUS ASSIGNMENTS:</font></b> <textarea name="previous_ass" rows="5" cols="50">$previous_ass</textarea> <b><font size="4">COMMENTS:</font></b> <textarea name="comments" rows="5" cols="50">$comments</textarea> <input type="submit" value="Send Mail!"><input type="reset" value=" Clear-Form"> </pre> </form> ENDH; return($html); } ///////////////////////////////////////////////////////////////////// ////////// print content surrounded by background//////////////////// ///////////////////////////////////////////////////////////////////// function printContent($content,$guestbookTitle){ $html = <<<ENDH <html> <head> <title>$guestbookTitle</title> </head> <body background="[url]http://ammotroops.com/froncoin4.jpg[/url]"> $content </body></html> ENDH; echo $html; } ?> MOD EDIT: PHP Manual [m] . . . [/m] tags changed to . . . tags.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.