Jump to content

damerit

Members
  • Posts

    33
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

damerit's Achievements

Member

Member (2/5)

0

Reputation

  1. I recently took over a Suse Linux system that hosts one of our mysq database servers. The database is getting auto populated ever day with new updates. In search to find out how I found a /home/pars profile that shows sites.(a date).output an output file from the database. The problem is that there is supposed to be a feed or push from the main server to this one. I looked at all cron jobs and I can't find how this is being updated. The Mysql data files show to be updated with current date but how it this happening? Please help. -divid
  2. This is part of a common free GPL sitemp.php file and I am trying to modify it so that I can only list the folder if it has a .html extension. I have hundreds of folders and I don't want to display all of them nor exclude each one. Can I get some pointers or ideas? $display['html'] = "html.gif"; $excludedir[] = ""; $excludefile[] = ""; while ($file = readdir($handle)) { if(is_dir($file) && $file != "." && $file != ".." && !in_array($file, $excludedir)) { $sdirs[] = $file; } elseif(is_file($file) && $file != "$self" && array_key_exists(get_extension($file), $display) && !in_array($file, $excludefile)) { $sfiles[] = $file; } }
  3. I need to know if this is possible. I have a variable of $status and a post value of 'Open' and 'Closed'. Open pulls from table1 and closed pulls from table2. How can I pull all 'Open + Closed' posts under and 'All' option? if($_POST['status'] == "Open") { if (!empty($clarifyID)) { mysql_select_db($database, $Calls); $query_Calls = "Select * FROM table1 WHERE $Clarify"; $ActiveCalls = mysql_query($query_ActiveCalls, $ActiveCalls) or die(mysql_error()); $count_Calls = mysql_num_rows($Calls); } else { mysql_select_db($database, $Calls); $query_Calls = "Select * FROM table1 WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $joinproductFamily AND $Product ORDER BY TimeInHouse"; $Calls = mysql_query($query_Calls, $Calls) or die(mysql_error()); $count_Calls = mysql_num_rows($Calls); } } // Status == Closed if($_POST['status'] == "Closed") { if (!empty($clarifyID)) { mysql_select_db($database, $Calls); $query_Calls = "Select * FROM table2 WHERE $Clarify"; $ActiveCalls = mysql_query($query_ActiveCalls, $ActiveCalls) or die(mysql_error()); $count_Calls = mysql_num_rows($Calls); } else { mysql_select_db($database, $Calls); $query_Calls = "Select * FROM table2 WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $joinproductFamily AND $Product ORDER BY TimeInHouse"; $Calls = mysql_query($query_Calls, $Calls) or die(mysql_error()); $count_Calls = mysql_num_rows($Calls); } } /////// Status == All /////////////// //[color=red][b]This is where I want to search for all calls in table1 and table2.[/b][/color] if($_POST['status'] == "All") { mysql_select_db($database_Calls, $Calls); $query_Calls = "Select * FROM callsclosed WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $Product ORDER BY TimeInHouse"; $query_Calls = "Select * FROM e1data WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $Product ORDER BY TimeInHouse"; $Calls = mysql_query($query_Calls, $Calls) or die(mysql_error()); $count_Calls = mysql_num_rows($Calls); } }
  4. Guys, We have an application that has a table with around 27,000 records and the consist of open and closed call information. The uppers and some noobie are pushing to move the closed calls to seperate table, which does consist of 95% of the data. I suggested using an index because splitting the table will affect much source changes and I don't think splitting the table will be that much of a benefit. What do you guys think? Should we split or index? thanks,
  5. I added a true statement and it worked. function validateForm(thisForm){ if ((thisForm.severity.value == "High") && (thisForm.bypass.checked == true) && (thisForm.whatObject.value == "")){ alert("Enter an answer or check bypass."); return false; }
  6. I want to validate so that if the checkbox of 'bypass' is not checked or if a text field = "" then a message to choose one or the other. I wrote the one below but it deeps asking for input both. I even used the or || operator. Can someone help me make sense of this? .... thnks function validateForm(thisForm){ if ((thisForm.bypass.checked == true) && (thisForm.whatObject.value == "")){ alert("Enter an answer or check bypass."); return false; }
  7. The mailto link is called in the if statement. $fccmail=$chkemail."?importance=High&subject=Update:".$notifTsubj." ".rawurlencode($row_Record['callerCustomer'])." - ".$row_Record['callerCity'].", ".$row_Record['callerStateProv']." - ".$row_Record['Type']." - ".$row_Record['system']."&" ."body=Problem: ".$checkNotif. " Report" ."%0A%0ACustomer: ".rawurlencode($row_Record['callerCustomer']) ."%0ALocation: ".$row_Record['callerCity'].", ".$row_Record['callerStateProv'].", ".$row_Record['callerCountry'] ."%0ARecord: ".$row_Record['ID'] ."%0ADate: ".date ("m/d/Y") ."%0AProblem: "; if((isset($notifType)) && $notifType != 'WZW'){ $mail = '<tr bgcolor="#930000"><td ALIGN="center" nowrap colspan="4"><font COLOR="#003366" SIZE="3"><strong><a CLASS="gwwhite" href="mailto:'.$fccmail.'"><b><font color="#FFFFFF" size="+1">Send Notification......</font></b></a></strong></font></td></tr>'; } else{ $mail = '<tr bgcolor="#930000"><td ALIGN="center" nowrap colspan="4"><font COLOR="#003366" SIZE="3"><strong><a CLASS="gwwhite" href="mailto:'.$chkemail."?Importance=2&subject=Outage&body=".$boxmail.'"><b><font color="#FFFFFF" size="+1">Send Alert Notification......</font></b></a></strong></font></td></tr>'; }
  8. Description: The variable $chkemail is assigned email addresses and $fccmail is tied to a mailto tag that initiates when a button is pressed. Problem: I have tried modifying the code below to handle html in the message but if fails. I have used content-type, mime_boundary, and I get nothing. Question: How can I modify the content below to accept html tags of <b><i> and <color>? What significance does the 'body' name hold below? If I change the body name the code will break. *Realize that this is all an url* $fccmail=$chkemail."?importance=High&subject=Update:".$notifTsubj." ".rawurlencode($row_Record['callerCustomer'])." - ".$row_Record['callerCity'].", ".$row_Record['callerStateProv']." - ".$row_Record['Type']." - ".$row_Record['system']."&" ."body=Problem: ".$checkNotif. " Report" ."%0A%0ACustomer: ".rawurlencode($row_Record['callerCustomer']) ."%0ALocation: ".$row_Record['callerCity'].", ".$row_Record['callerStateProv'].", ".$row_Record['callerCountry'] ."%0ARecord: ".$row_Record['ID'] ."%0ADate: ".date ("m/d/Y") ."%0AProblem: "; Thank you,
  9. This is solved. It was the rawurlencode() function that worked. The urlencode() function added '+' signs for spaces. How do we post this as solved? Thanks again, Maq.
  10. Thank you, Maq. I did notice that a '+' sign was added between the spaces of the text using the urlencode() function. I wounder if I should use the the grep function.
  11. Problem: The below code of field "callersCompany" chops off the remaining fields when there is an '&' sign. For example, "Smith & Wesson". Everything after Smith is lost. Question: What php method would solve this? Or, how could I handle the passing of the '&' sign? I tried htmlspecialchars(). $fccmail=$chkemail."?importance=High&subject=".$notifTsubj." ".$row_Record['callersCompany']." - ".$row_Record['callerCity'].", ".$row_Record['callerStateProv']." - ".$row_Record['pType']." - ".$row_Record['sType']."&" Thanks.
  12. I realize that I can't nest forms, but I have 2 forms on my page and I want them to look uniform and not have a space between them. How do I join them or merge them together to look uniform? Sorry, if this is the wrong forum for this question. <form action="page1.php" method="post"> <input type="button" name="button1" value="button"> </form> ----------- How to join these forms with borders touching ---------- <form action="page2.php" method="post"> <input type="text" name="txt1" value="My text"> </form>
  13. How do I change the user name on linux? For instance, I have a user 'jdm' who is on multiple goups and I want to change the user name to say, 'david'. If I can't change the name without causing havic, how do I create a new user of 'david' and give this user the same permissions and groups level as 'jdm'? thanks,
  14. I tried to kill the process and it gives me the "No such process". I'm just going to bite the bullet and restart the server. I hate to but I'm stuck. Is there any advice from here.... thanks by the way srv07:/ # ps aux|grep index.php root 2924 0.0 0.2 1828 616 pts/0 S+ 16:54 0:00 grep index.php srv07:/ # kill -9 2924 -bash: kill: (2924) - No such process srv07:/ #
  15. I wrote a script that will send out emails from my linux/apache server to my company email which is an exchange server. I removed the script and I'm still getting emails sent to my company account. It has been 3 days since I removed the script and I can't find out what is causing it to still generate e-mails. How do I look at the server and find the queue or service that runs the e-mail and stop it? I assume it was caught in a loop. your help is greatly appreciated...
×
×
  • 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.