Losing my mind please help?
Moderator: General Moderators
Losing my mind please help?
I have a friend who had a website designed then the guy who did it skipped town, he installed PHP Job Site and now we are having problems with it. I can not find any help at the moment the one site I did find was not helpfull because the software was not purchased from them. Can anyone help me or just point me in the right direction? 
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: Losing my mind please help?
Sure we can help you. Sadly we're not psychic here (yet) so you're going to have to tell us what the problem is and post the PHP code in order for us to help you.
Re: Losing my mind please help?
LOL
Okay the problems are:
The sign on date for clients is never right they seem to be random some how?
In sql table structure for this specific part is:
`compid` int(5) NOT NULL auto_increment,
`email` varchar(255) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`company` varchar(255) NOT NULL default '',
`comp_contact` varchar(90) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`postalcode` varchar(20) NOT NULL default '',
`province` varchar(255) NOT NULL default '',
`locationid` int(3) NOT NULL default '0',
`phone` varchar(20) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`logo` varchar(10) NOT NULL default '',
`description` blob NOT NULL,
`url` varchar(255) NOT NULL default '',
`hide_address` char(3) NOT NULL default '',
`hide_location` char(3) NOT NULL default '',
`hide_phone` char(3) NOT NULL default '',
`hide_fax` char(3) NOT NULL default '',
`hide_email` char(3) NOT NULL default '',
`hide_contact` char(3) NOT NULL default '',
`discount` float(6,2) NOT NULL default '0.00',
`signupdate` date NOT NULL default '0000-00-00',
`lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
`lastip` varchar(50) NOT NULL default '',
`comp_akey` varchar(20) NOT NULL default '',
`comp_akey_status` tinyint(1) NOT NULL default '1',
`featured` tinyint(1) NOT NULL default '0',
`expire` date NOT NULL default '0000-00-00',
`company_notes` text NOT NULL,
`company_suspended` tinyint(1) NOT NULL default '0',
`comp_type` enum('E','R') NOT NULL default 'E',
`hear_about` varchar(255) NOT NULL default '',
`hear_text` varchar(255) NOT NULL default '',
`comp_joblink` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`compid`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;
And the PHP part is:
<?php
include('application_config_file.php');
$empl_menu=true;
$left_navigation_width="0%";
$right_navigation_width=RIGHT_NAV_WIDTH;
$main_navigation_width=MAIN_LNAV_WIDTH;
$bx_left_nav="no";
include(DIR_LANGUAGES.$language."/".FILENAME_COMPANY);
$jsfile="company.js";
if($HTTP_POST_VARS['action']) {
$action = $HTTP_POST_VARS['action'];
}
elseif($HTTP_GET_VARS['action']) {
$action = $HTTP_GET_VARS['action'];
}
else {
$action='';
}
if (!$HTTP_SESSION_VARS['employerid']) {
$site_title=TEXT_COMPANY_REGISTRATION;
}
if ($HTTP_POST_VARS['validation']){
$error=0;
if (USE_ACTIVATION_CODE=="yes" && $HTTP_SESSION_VARS['fsess']!=$HTTP_POST_VARS['fpsess']) {
$already_submited=true;
if (USE_ACTIVATION_CODE=="yes") {
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
$continue_browse=true;
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_ERROR_FORM);
include(DIR_SERVER_ROOT."footer.php");
bx_exit();
}
if ((!$HTTP_SESSION_VARS['employerid']) && (trim($HTTP_POST_VARS['company'])=="") || (strlen($HTTP_POST_VARS['company'])<ENTRY_COMAPANY_MIN_LENGTH))
{
$error=1;
$company_error=1;
}
else
{
$company_error=0;
}
if (trim($HTTP_POST_VARS['comp_contact'])=="") {
$error=1;
$contact_error=1;
}
else {
$contact_error=0;
}
if ((trim($HTTP_POST_VARS['address'])=="") || (strlen($HTTP_POST_VARS['address'])<ENTRY_ADDRESS_MIN_LENGTH))
{
$error=1;
$address_error=1;
}
else
{
$address_error=0;
}
if (ENTRY_CITY_MIN_LENGTH>0 && ((trim($HTTP_POST_VARS['city'])=="") || (strlen($HTTP_POST_VARS['city'])<ENTRY_CITY_MIN_LENGTH)))
{
$error=1;
$city_error=1;
}
else
{
$city_error=0;
}
if (ENTRY_POSTALCODE_MIN_LENGTH>0 && ((trim($HTTP_POST_VARS['postalcode'])=="") || (strlen($HTTP_POST_VARS['postalcode'])<ENTRY_POSTALCODE_MIN_LENGTH))) {
$error=1;
$postalcode_error=1;
}
else {
$postalcode_error=0;
}
if (ENTRY_PROVINCE_MIN_LENGTH>0 && ((trim($HTTP_POST_VARS['province'])=="") || (strlen($HTTP_POST_VARS['province'])<ENTRY_PROVINCE_MIN_LENGTH))) {
$error=1;
$province_error=1;
}
else
{
$province_error=0;
}
if ((trim($HTTP_POST_VARS['phone'])=="") || (strlen($HTTP_POST_VARS['phone'])<ENTRY_PHONE_MIN_LENGTH) || (verify($HTTP_POST_VARS['phone'],"phone")==1))
{
$error=1;
$phone_error=1;
}
else {
$phone_error=0;
}
if (($HTTP_POST_VARS['location']=="") || ($HTTP_POST_VARS['location']=="000"))
{
$error=1;
$location_error=1;
}
else
{
$location_error=0;
}
if ((trim($HTTP_POST_VARS['email']=="")) || (strlen($HTTP_POST_VARS['email'])<ENTRY_EMAIL_MIN_LENGTH) || (!eregi("(@)(.*)",$HTTP_POST_VARS['email'],$regs)) || (!eregi("([.])(.*)",$HTTP_POST_VARS['email'],$regs)))
{
$error=1;
$email_error=1;
}
else
{
$email_error=0;
}
$HTTP_POST_VARS['email'] = bx_addslashes(trim(strtolower($HTTP_POST_VARS['email'])));
$email_query=bx_db_query("select * from ".$bx_table_prefix."_companies where LCASE(email) like '".strtolower($HTTP_POST_VARS['email'])."' and compid!='".$HTTP_SESSION_VARS['employerid']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$email_number=bx_db_num_rows($email_query);
if (($email_number!=0) && ($check_email))
{
$error=1;
$email_result=bx_db_fetch_array($email_query);
if ($email_result['email']==$HTTP_POST_VARS['email']) {
$allready_email_error=1;
}
else {$allready_email_error=0;}
}
else
{
$allready_email_error=0;
}
if (CHECK_SAME_EMAIL=="no") {
$pemail_query=bx_db_query("select email from ".$bx_table_prefix."_persons where LCASE(email)='".strtolower($HTTP_POST_VARS['email'])."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$pemail_number=bx_db_num_rows($pemail_query);
if (($pemail_number!=0)) {
$error = 1;
$allready_email_error=1;
}
}
if ((trim($HTTP_POST_VARS['password'])=="") || (strlen($HTTP_POST_VARS['password'])<ENTRY_PASSWORD_MIN_LENGTH))
{
$error=1;
$password_error=1;
}
else
{
$password_error=0;
}
if (($HTTP_POST_VARS['password']!=$HTTP_POST_VARS['confpassword']) || (strlen($HTTP_POST_VARS['confpassword'])<ENTRY_PASSWORD_MIN_LENGTH))
{
$error=1;
$confpassword_error=1;
}
else
{
$confpassword_error=0;
}
if ($HTTP_POST_VARS['agree']=="") {
$error=1;
$terms_error=1;
}
else {
$terms_error=0;
}
if ($use_extra_fields) {
include_once(DIR_SERVER_ROOT."phpjob_companies.cfg.php");
include_once(DIR_FUNCTIONS."utils.php");
$php_errors=make_php_validate($companies_new_fields);
if (sizeof($php_errors)>0) {
$error=1;
}
}
}//end if validation etc
if ($HTTP_SESSION_VARS['employerid']) {
if ($action=="comp_update") {
if ($error==1) //we have errors
{
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end if error=1
else //no errors
{
if ($HTTP_POST_VARS['new_company']) {
if ($HTTP_SESSION_VARS['fsess']!=$HTTP_POST_VARS['fpsess']) {
$already_submited=true;
if (USE_ACTIVATION_CODE=="yes") {
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
$continue_browse=true;
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_ERROR_FORM);
include(DIR_SERVER_ROOT."footer.php");
bx_exit();
}
else{
$fsess=time();
bx_session_unregister("fsess");
bx_session_register("fsess");
}
}
if ($use_extra_fields) {
include(DIR_SERVER_ROOT."phpjob_companies.cfg.php");
include_once(DIR_FUNCTIONS."utils.php");
$q_extra_update=make_update_field($companies_new_fields);
}
else {
$q_extra_update = "";
}
bx_db_query("update ".$bx_table_prefix."_companies set comp_contact='".bx_dirty_words($HTTP_POST_VARS['comp_contact'])."',address='".bx_dirty_words($HTTP_POST_VARS['address'])."' , city='".bx_dirty_words($HTTP_POST_VARS['city'])."' , province='".bx_dirty_words($HTTP_POST_VARS['province'])."' , postalcode='".bx_dirty_words($HTTP_POST_VARS['postalcode'])."' , locationid='".$HTTP_POST_VARS['location']."' , phone='".bx_dirty_words($HTTP_POST_VARS['phone'])."' , fax='".bx_dirty_words($HTTP_POST_VARS['fax'])."' , description='".bx_dirty_words($HTTP_POST_VARS['description'],true)."', email='".$HTTP_POST_VARS['email']."' , url='".((trim($HTTP_POST_VARS['url'])!="")?bx_dirty_words((eregi("^http://|https://",trim($HTTP_POST_VARS['url']))?trim($HTTP_POST_VARS['url']):"http://".trim($HTTP_POST_VARS['url']))):"")."', password='".bx_addslashes($HTTP_POST_VARS['password'])."', hide_contact='".$HTTP_POST_VARS['hide_contact']."', hide_address='".$HTTP_POST_VARS['hide_address']."', hide_location='".$HTTP_POST_VARS['hide_location']."', hide_phone='".$HTTP_POST_VARS['hide_phone']."', hide_fax='".$HTTP_POST_VARS['hide_fax']."', hide_email='".$HTTP_POST_VARS['hide_email']."', comp_type = '".$HTTP_POST_VARS['comp_type']."'".$q_extra_update." where compid='".$HTTP_SESSION_VARS['employerid']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$success_message=TEXT_MODIFICATION_SUCCESS;
$back_url=bx_make_url(HTTP_SERVER.FILENAME_COMPANY."?action=comp_form", "auth_sess", $bx_session);
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_MESSAGE_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end else error=1
} //end if action=comp_update
else{
if ($HTTP_SESSION_VARS['auth_type']=="cookie") {
bx_session_destroy();
$HTTP_SESSION_VARS['employerid']='';
$employerid='';
@setcookie("phpjob_eid", $employerid, (time()-10000), '/');
header('Location: ' . bx_make_url(HTTP_SERVER.FILENAME_COMPANY."?action=comp_form&language=".$language, "auth_sess", $bx_session, true));
bx_exit();
}
else{
$company_query=bx_db_query("select * from ".$bx_table_prefix."_companies where compid='".$HTTP_SESSION_VARS['employerid']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$company_result=bx_db_fetch_array($company_query);
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
}
}
} //end if we have employerid
else //no employerid
{
if ($HTTP_POST_VARS['new_company']) //creating a new account
{
if ($error==1) //we have errors
{
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end if error=1
else //no errors
{
if ($HTTP_SESSION_VARS['fsess']!=$HTTP_POST_VARS['fpsess']) {
$already_submited=true;
if (USE_ACTIVATION_CODE=="yes") {
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
$continue_browse=true;
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_ERROR_FORM);
include(DIR_SERVER_ROOT."footer.php");
bx_exit();
}
else{
$fsess=time();
bx_session_unregister("fsess");
bx_session_register("fsess");
}
if($HTTP_POST_VARS['radio']==0) {
$featured="no";
} else {
$featured="yes";
}
if ($HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"] != ""){
$IP = $HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"];
}
else {
$IP = $HTTP_SERVER_VARS['REMOTE_ADDR'];
}
if ($use_extra_fields) {
include(DIR_SERVER_ROOT."phpjob_companies.cfg.php");
include_once(DIR_FUNCTIONS."utils.php");
$q_extra_field=make_insert_field($companies_new_fields);
$q_extra_value=make_insert_value($companies_new_fields);
}
else {
$q_extra_field = "";
$q_extra_value = "";
}
if(USE_HEAR_ABOUT=="yes"){
if (eregi("%%_intext_%%",${TEXT_HEARABOUT_OPT.$HTTP_POST_VARS['hear_about']})) {
$HTTP_POST_VARS['hear_text'] = $HTTP_POST_VARS['hear_text'.$HTTP_POST_VARS['hear_about']];
}
}
bx_db_insert($bx_table_prefix."_companies","company,comp_contact,address,city,province,postalcode,locationid,phone,fax,description,email,url,password,hide_contact,hide_address,hide_location,hide_phone,hide_fax,hide_email,hear_about,hear_text,comp_type,featured,signupdate, lastlogin,lastip".$q_extra_field,"'".bx_dirty_words($HTTP_POST_VARS['company'])."','".bx_dirty_words($HTTP_POST_VARS['comp_contact'])."','".bx_dirty_words($HTTP_POST_VARS['address'])."','".bx_dirty_words($HTTP_POST_VARS['city'])."','".bx_dirty_words($HTTP_POST_VARS['province'])."' ,'".bx_dirty_words($HTTP_POST_VARS['postalcode'])."' ,'".$HTTP_POST_VARS['location']."' ,'".bx_dirty_words($HTTP_POST_VARS['phone'])."' ,'".bx_dirty_words($HTTP_POST_VARS['fax'])."' , '".bx_dirty_words($HTTP_POST_VARS['description'],true)."','".$HTTP_POST_VARS['email']."' ,'".((trim($HTTP_POST_VARS['url'])!="")?bx_dirty_words((eregi("^http://|https://",trim($HTTP_POST_VARS['url']))?trim($HTTP_POST_VARS['url']):"http://".trim($HTTP_POST_VARS['url']))):"")."','".bx_addslashes($HTTP_POST_VARS['password'])."','".$HTTP_POST_VARS['hide_contact']."','".$HTTP_POST_VARS['hide_address']."','".$HTTP_POST_VARS['hide_location']."','".$HTTP_POST_VARS['hide_phone']."','".$HTTP_POST_VARS['hide_fax']."','".$HTTP_POST_VARS['hide_email']."','".$HTTP_POST_VARS['hear_about']."','".bx_dirty_words($HTTP_POST_VARS['hear_text'])."','".$HTTP_POST_VARS['comp_type']."','0','".bx_mdate('d-m-Y')."', DATE_ADD(NOW(), interval ".TIMEZONE_OFFSET." HOUR),'".$IP."'".$q_extra_value);
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$compid=bx_db_insert_id();
if(JOB_EXPIRE_DAY!=0) {
$jexpire=JOB_EXPIRE_DAY;
$jexpire_type="days";
}
elseif(JOB_EXPIRE_MONTH!=0){
$jexpire=JOB_EXPIRE_MONTH;
$jexpire_type="month";
}
elseif(JOB_EXPIRE_YEAR!=0){
$jexpire=JOB_EXPIRE_YEAR;
$jexpire_type="year";
}
bx_db_insert($bx_table_prefix."_companycredits","compid,jobs,featuredjobs,contacts,jexpire,jexpire_type","'".$compid."','0','0','0','".$jexpire."','".$jexpire_type."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
if($use_extra_modules==true && isset($mod_include['a105'])){
include($mod_include['a105']);
}
if (USE_ACTIVATION_CODE=="yes") {
$new_key = substr(md5($HTTP_POST_VARS['email'].time()), 0, 20);
bx_db_query("UPDATE ".$bx_table_prefix."_companies set comp_akey = '".$new_key."', comp_akey_status='0' where compid = '".$compid."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$HTTP_POST_VARS['activation_link'] = HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation&key=".$new_key;
$HTTP_POST_VARS['comp_akey'] = $new_key;
}
$pricing_query=bx_db_query("SELECT * from ".$bx_table_prefix."_pricing_".$bx_table_lng." where pricing_default='1'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
if (bx_db_num_rows($pricing_query)!=0) {
$pricing_result = bx_db_fetch_array($pricing_query);
bx_db_query("UPDATE ".$bx_table_prefix."_companycredits set jobs='".$pricing_result['pricing_avjobs']."', featuredjobs='".$pricing_result['pricing_fjobs']."',contacts='".$pricing_result['pricing_avsearch']."', jexpire='".$pricing_result['pricing_jexpire']."', jexpire_type='".$pricing_result['pricing_jexpire_type']."' where compid='".$compid."'");
bx_db_insert($bx_table_prefix."_membership","compid,pricing_id","'".$compid."','".$pricing_result['pricing_id']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
if($pricing_result['pricing_period']=='0') {
$planning_date = "0000-00-00";
}
else {
$planning_date = bx_mdate('Y-m-d',mktime(date('H'),0,0,date('m')+$pricing_result['pricing_period'],date('d'),date('Y')));
}
bx_db_query("UPDATE ".$bx_table_prefix."_companies set expire='".$planning_date."', featured='".(($pricing_result['pricing_fcompany']=="yes")?"1":"0")."', comp_joblink='".(($pricing_result['pricing_joblink']=="yes")?"1":"0")."' where compid='".$compid."'");
SQL_CHECK(0,__FILE__.":".(__LINE__-1));
}
//send mail to registered company
$HTTP_POST_VARS['today'] = bx_format_date(bx_mdate('d-m-Y'), DATE_FORMAT);
if (USE_ACTIVATION_CODE=="yes") {
$mailfile = $language."/mail/employer_registration_with_activation.txt";
}
else{
$mailfile = $language."/mail/employer_registration.txt";
}
include(DIR_LANGUAGES.$mailfile.".cfg.php");
if($mail_active=="yes"){
$mail_message = fread(fopen(DIR_LANGUAGES.$mailfile,"r"),filesize(DIR_LANGUAGES.$mailfile));
if ($use_extra_fields) {
make_mail_values($companies_new_fields,$HTTP_POST_VARS);
foreach($extra_fields as $key => $val) {
$fields[$key] = $val;
}
}
reset($fields);
while (list($h, $v) = each($fields)) {
$mail_message = str_replace($v[0],bx_htmlmailtransform($HTTP_POST_VARS[$h],$html_mail),$mail_message);
$file_mail_subject = str_replace($v[0],$HTTP_POST_VARS[$h],$file_mail_subject);
}
if ($add_html_header == "yes") {
$mail_message = str_replace("%%today_date%%",bx_format_date(bx_mdate('d-m-Y'), DATE_FORMAT),@fread(@fopen(DIR_LANGUAGES.$language."/mail/header.txt","r"),@filesize(DIR_LANGUAGES.$language."/mail/header.txt"))).$mail_message;
}
if ($add_html_footer == "yes") {
$mail_message .= str_replace("%%today_date%%",bx_format_date(bx_mdate('d-m-Y'), DATE_FORMAT),@fread(@fopen(DIR_LANGUAGES.$language."/mail/footer.txt","r"),@filesize(DIR_LANGUAGES.$language."/mail/footer.txt")));
}
if ($add_mail_signature == "on") {
$mail_message .= "\n".SITE_SIGNATURE;
}
bx_mail(SITE_NAME,FROM_MAIL,$HTTP_POST_VARS['email'], stripslashes($file_mail_subject), stripslashes($mail_message), $html_mail);
}
if (NOTIFY_ADMIN_REGISTRATION=="yes") {
$notify_type="comp";
include_once(DIR_SERVER_ROOT."notify_admin.php");
}
if (USE_ACTIVATION_CODE=="yes") {
$success_message=TEXT_NEW_COMPANY_CREATED_ACTIVATE;
$nocontinuetext=true;
$backtopage=TEXT_ACTIVATE_ACCOUNT;
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$success_message=TEXT_NEW_COMPANY_CREATION_SUCCESS;
$employerid=$compid;
bx_session_register("employerid");
$HTTP_SESSION_VARS['employerid'] = $compid;
$sessiontime = time();
bx_session_register("sessiontime");
$u_noname=true;
@bx_session_register("u_noname");
@setcookie("phpjob_uname", $HTTP_POST_VARS['company'], mktime(0,0,0,date('m')+3,date('d'),date('Y')), '/');
$left_navigation_width='0%';
$right_navigation_width=RIGHT_NAV_WIDTH;
$main_navigation_width=MAIN_LNAV_WIDTH;
$nocontinuetext=true;
$backtopage=TEXT_CONTINUE;
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_MESSAGE_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end else error=1
} //end if newaccount
else {
if ($action=="comp_form") {
$login='employer';
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_LOGIN_FORM);
include(DIR_SERVER_ROOT."footer.php");
}
else {
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
}
}
}
bx_exit();
?>
The dates show like this:
2020-05-20
or
2030-06-20
I need someone that knows the software and can give me some input as where to start looking.
This is just one of many errors
Okay the problems are:
The sign on date for clients is never right they seem to be random some how?
In sql table structure for this specific part is:
`compid` int(5) NOT NULL auto_increment,
`email` varchar(255) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`company` varchar(255) NOT NULL default '',
`comp_contact` varchar(90) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`postalcode` varchar(20) NOT NULL default '',
`province` varchar(255) NOT NULL default '',
`locationid` int(3) NOT NULL default '0',
`phone` varchar(20) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`logo` varchar(10) NOT NULL default '',
`description` blob NOT NULL,
`url` varchar(255) NOT NULL default '',
`hide_address` char(3) NOT NULL default '',
`hide_location` char(3) NOT NULL default '',
`hide_phone` char(3) NOT NULL default '',
`hide_fax` char(3) NOT NULL default '',
`hide_email` char(3) NOT NULL default '',
`hide_contact` char(3) NOT NULL default '',
`discount` float(6,2) NOT NULL default '0.00',
`signupdate` date NOT NULL default '0000-00-00',
`lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
`lastip` varchar(50) NOT NULL default '',
`comp_akey` varchar(20) NOT NULL default '',
`comp_akey_status` tinyint(1) NOT NULL default '1',
`featured` tinyint(1) NOT NULL default '0',
`expire` date NOT NULL default '0000-00-00',
`company_notes` text NOT NULL,
`company_suspended` tinyint(1) NOT NULL default '0',
`comp_type` enum('E','R') NOT NULL default 'E',
`hear_about` varchar(255) NOT NULL default '',
`hear_text` varchar(255) NOT NULL default '',
`comp_joblink` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`compid`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;
And the PHP part is:
<?php
include('application_config_file.php');
$empl_menu=true;
$left_navigation_width="0%";
$right_navigation_width=RIGHT_NAV_WIDTH;
$main_navigation_width=MAIN_LNAV_WIDTH;
$bx_left_nav="no";
include(DIR_LANGUAGES.$language."/".FILENAME_COMPANY);
$jsfile="company.js";
if($HTTP_POST_VARS['action']) {
$action = $HTTP_POST_VARS['action'];
}
elseif($HTTP_GET_VARS['action']) {
$action = $HTTP_GET_VARS['action'];
}
else {
$action='';
}
if (!$HTTP_SESSION_VARS['employerid']) {
$site_title=TEXT_COMPANY_REGISTRATION;
}
if ($HTTP_POST_VARS['validation']){
$error=0;
if (USE_ACTIVATION_CODE=="yes" && $HTTP_SESSION_VARS['fsess']!=$HTTP_POST_VARS['fpsess']) {
$already_submited=true;
if (USE_ACTIVATION_CODE=="yes") {
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
$continue_browse=true;
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_ERROR_FORM);
include(DIR_SERVER_ROOT."footer.php");
bx_exit();
}
if ((!$HTTP_SESSION_VARS['employerid']) && (trim($HTTP_POST_VARS['company'])=="") || (strlen($HTTP_POST_VARS['company'])<ENTRY_COMAPANY_MIN_LENGTH))
{
$error=1;
$company_error=1;
}
else
{
$company_error=0;
}
if (trim($HTTP_POST_VARS['comp_contact'])=="") {
$error=1;
$contact_error=1;
}
else {
$contact_error=0;
}
if ((trim($HTTP_POST_VARS['address'])=="") || (strlen($HTTP_POST_VARS['address'])<ENTRY_ADDRESS_MIN_LENGTH))
{
$error=1;
$address_error=1;
}
else
{
$address_error=0;
}
if (ENTRY_CITY_MIN_LENGTH>0 && ((trim($HTTP_POST_VARS['city'])=="") || (strlen($HTTP_POST_VARS['city'])<ENTRY_CITY_MIN_LENGTH)))
{
$error=1;
$city_error=1;
}
else
{
$city_error=0;
}
if (ENTRY_POSTALCODE_MIN_LENGTH>0 && ((trim($HTTP_POST_VARS['postalcode'])=="") || (strlen($HTTP_POST_VARS['postalcode'])<ENTRY_POSTALCODE_MIN_LENGTH))) {
$error=1;
$postalcode_error=1;
}
else {
$postalcode_error=0;
}
if (ENTRY_PROVINCE_MIN_LENGTH>0 && ((trim($HTTP_POST_VARS['province'])=="") || (strlen($HTTP_POST_VARS['province'])<ENTRY_PROVINCE_MIN_LENGTH))) {
$error=1;
$province_error=1;
}
else
{
$province_error=0;
}
if ((trim($HTTP_POST_VARS['phone'])=="") || (strlen($HTTP_POST_VARS['phone'])<ENTRY_PHONE_MIN_LENGTH) || (verify($HTTP_POST_VARS['phone'],"phone")==1))
{
$error=1;
$phone_error=1;
}
else {
$phone_error=0;
}
if (($HTTP_POST_VARS['location']=="") || ($HTTP_POST_VARS['location']=="000"))
{
$error=1;
$location_error=1;
}
else
{
$location_error=0;
}
if ((trim($HTTP_POST_VARS['email']=="")) || (strlen($HTTP_POST_VARS['email'])<ENTRY_EMAIL_MIN_LENGTH) || (!eregi("(@)(.*)",$HTTP_POST_VARS['email'],$regs)) || (!eregi("([.])(.*)",$HTTP_POST_VARS['email'],$regs)))
{
$error=1;
$email_error=1;
}
else
{
$email_error=0;
}
$HTTP_POST_VARS['email'] = bx_addslashes(trim(strtolower($HTTP_POST_VARS['email'])));
$email_query=bx_db_query("select * from ".$bx_table_prefix."_companies where LCASE(email) like '".strtolower($HTTP_POST_VARS['email'])."' and compid!='".$HTTP_SESSION_VARS['employerid']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$email_number=bx_db_num_rows($email_query);
if (($email_number!=0) && ($check_email))
{
$error=1;
$email_result=bx_db_fetch_array($email_query);
if ($email_result['email']==$HTTP_POST_VARS['email']) {
$allready_email_error=1;
}
else {$allready_email_error=0;}
}
else
{
$allready_email_error=0;
}
if (CHECK_SAME_EMAIL=="no") {
$pemail_query=bx_db_query("select email from ".$bx_table_prefix."_persons where LCASE(email)='".strtolower($HTTP_POST_VARS['email'])."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$pemail_number=bx_db_num_rows($pemail_query);
if (($pemail_number!=0)) {
$error = 1;
$allready_email_error=1;
}
}
if ((trim($HTTP_POST_VARS['password'])=="") || (strlen($HTTP_POST_VARS['password'])<ENTRY_PASSWORD_MIN_LENGTH))
{
$error=1;
$password_error=1;
}
else
{
$password_error=0;
}
if (($HTTP_POST_VARS['password']!=$HTTP_POST_VARS['confpassword']) || (strlen($HTTP_POST_VARS['confpassword'])<ENTRY_PASSWORD_MIN_LENGTH))
{
$error=1;
$confpassword_error=1;
}
else
{
$confpassword_error=0;
}
if ($HTTP_POST_VARS['agree']=="") {
$error=1;
$terms_error=1;
}
else {
$terms_error=0;
}
if ($use_extra_fields) {
include_once(DIR_SERVER_ROOT."phpjob_companies.cfg.php");
include_once(DIR_FUNCTIONS."utils.php");
$php_errors=make_php_validate($companies_new_fields);
if (sizeof($php_errors)>0) {
$error=1;
}
}
}//end if validation etc
if ($HTTP_SESSION_VARS['employerid']) {
if ($action=="comp_update") {
if ($error==1) //we have errors
{
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end if error=1
else //no errors
{
if ($HTTP_POST_VARS['new_company']) {
if ($HTTP_SESSION_VARS['fsess']!=$HTTP_POST_VARS['fpsess']) {
$already_submited=true;
if (USE_ACTIVATION_CODE=="yes") {
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
$continue_browse=true;
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_ERROR_FORM);
include(DIR_SERVER_ROOT."footer.php");
bx_exit();
}
else{
$fsess=time();
bx_session_unregister("fsess");
bx_session_register("fsess");
}
}
if ($use_extra_fields) {
include(DIR_SERVER_ROOT."phpjob_companies.cfg.php");
include_once(DIR_FUNCTIONS."utils.php");
$q_extra_update=make_update_field($companies_new_fields);
}
else {
$q_extra_update = "";
}
bx_db_query("update ".$bx_table_prefix."_companies set comp_contact='".bx_dirty_words($HTTP_POST_VARS['comp_contact'])."',address='".bx_dirty_words($HTTP_POST_VARS['address'])."' , city='".bx_dirty_words($HTTP_POST_VARS['city'])."' , province='".bx_dirty_words($HTTP_POST_VARS['province'])."' , postalcode='".bx_dirty_words($HTTP_POST_VARS['postalcode'])."' , locationid='".$HTTP_POST_VARS['location']."' , phone='".bx_dirty_words($HTTP_POST_VARS['phone'])."' , fax='".bx_dirty_words($HTTP_POST_VARS['fax'])."' , description='".bx_dirty_words($HTTP_POST_VARS['description'],true)."', email='".$HTTP_POST_VARS['email']."' , url='".((trim($HTTP_POST_VARS['url'])!="")?bx_dirty_words((eregi("^http://|https://",trim($HTTP_POST_VARS['url']))?trim($HTTP_POST_VARS['url']):"http://".trim($HTTP_POST_VARS['url']))):"")."', password='".bx_addslashes($HTTP_POST_VARS['password'])."', hide_contact='".$HTTP_POST_VARS['hide_contact']."', hide_address='".$HTTP_POST_VARS['hide_address']."', hide_location='".$HTTP_POST_VARS['hide_location']."', hide_phone='".$HTTP_POST_VARS['hide_phone']."', hide_fax='".$HTTP_POST_VARS['hide_fax']."', hide_email='".$HTTP_POST_VARS['hide_email']."', comp_type = '".$HTTP_POST_VARS['comp_type']."'".$q_extra_update." where compid='".$HTTP_SESSION_VARS['employerid']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$success_message=TEXT_MODIFICATION_SUCCESS;
$back_url=bx_make_url(HTTP_SERVER.FILENAME_COMPANY."?action=comp_form", "auth_sess", $bx_session);
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_MESSAGE_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end else error=1
} //end if action=comp_update
else{
if ($HTTP_SESSION_VARS['auth_type']=="cookie") {
bx_session_destroy();
$HTTP_SESSION_VARS['employerid']='';
$employerid='';
@setcookie("phpjob_eid", $employerid, (time()-10000), '/');
header('Location: ' . bx_make_url(HTTP_SERVER.FILENAME_COMPANY."?action=comp_form&language=".$language, "auth_sess", $bx_session, true));
bx_exit();
}
else{
$company_query=bx_db_query("select * from ".$bx_table_prefix."_companies where compid='".$HTTP_SESSION_VARS['employerid']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$company_result=bx_db_fetch_array($company_query);
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
}
}
} //end if we have employerid
else //no employerid
{
if ($HTTP_POST_VARS['new_company']) //creating a new account
{
if ($error==1) //we have errors
{
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end if error=1
else //no errors
{
if ($HTTP_SESSION_VARS['fsess']!=$HTTP_POST_VARS['fpsess']) {
$already_submited=true;
if (USE_ACTIVATION_CODE=="yes") {
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
$continue_browse=true;
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_ERROR_FORM);
include(DIR_SERVER_ROOT."footer.php");
bx_exit();
}
else{
$fsess=time();
bx_session_unregister("fsess");
bx_session_register("fsess");
}
if($HTTP_POST_VARS['radio']==0) {
$featured="no";
} else {
$featured="yes";
}
if ($HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"] != ""){
$IP = $HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"];
}
else {
$IP = $HTTP_SERVER_VARS['REMOTE_ADDR'];
}
if ($use_extra_fields) {
include(DIR_SERVER_ROOT."phpjob_companies.cfg.php");
include_once(DIR_FUNCTIONS."utils.php");
$q_extra_field=make_insert_field($companies_new_fields);
$q_extra_value=make_insert_value($companies_new_fields);
}
else {
$q_extra_field = "";
$q_extra_value = "";
}
if(USE_HEAR_ABOUT=="yes"){
if (eregi("%%_intext_%%",${TEXT_HEARABOUT_OPT.$HTTP_POST_VARS['hear_about']})) {
$HTTP_POST_VARS['hear_text'] = $HTTP_POST_VARS['hear_text'.$HTTP_POST_VARS['hear_about']];
}
}
bx_db_insert($bx_table_prefix."_companies","company,comp_contact,address,city,province,postalcode,locationid,phone,fax,description,email,url,password,hide_contact,hide_address,hide_location,hide_phone,hide_fax,hide_email,hear_about,hear_text,comp_type,featured,signupdate, lastlogin,lastip".$q_extra_field,"'".bx_dirty_words($HTTP_POST_VARS['company'])."','".bx_dirty_words($HTTP_POST_VARS['comp_contact'])."','".bx_dirty_words($HTTP_POST_VARS['address'])."','".bx_dirty_words($HTTP_POST_VARS['city'])."','".bx_dirty_words($HTTP_POST_VARS['province'])."' ,'".bx_dirty_words($HTTP_POST_VARS['postalcode'])."' ,'".$HTTP_POST_VARS['location']."' ,'".bx_dirty_words($HTTP_POST_VARS['phone'])."' ,'".bx_dirty_words($HTTP_POST_VARS['fax'])."' , '".bx_dirty_words($HTTP_POST_VARS['description'],true)."','".$HTTP_POST_VARS['email']."' ,'".((trim($HTTP_POST_VARS['url'])!="")?bx_dirty_words((eregi("^http://|https://",trim($HTTP_POST_VARS['url']))?trim($HTTP_POST_VARS['url']):"http://".trim($HTTP_POST_VARS['url']))):"")."','".bx_addslashes($HTTP_POST_VARS['password'])."','".$HTTP_POST_VARS['hide_contact']."','".$HTTP_POST_VARS['hide_address']."','".$HTTP_POST_VARS['hide_location']."','".$HTTP_POST_VARS['hide_phone']."','".$HTTP_POST_VARS['hide_fax']."','".$HTTP_POST_VARS['hide_email']."','".$HTTP_POST_VARS['hear_about']."','".bx_dirty_words($HTTP_POST_VARS['hear_text'])."','".$HTTP_POST_VARS['comp_type']."','0','".bx_mdate('d-m-Y')."', DATE_ADD(NOW(), interval ".TIMEZONE_OFFSET." HOUR),'".$IP."'".$q_extra_value);
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$compid=bx_db_insert_id();
if(JOB_EXPIRE_DAY!=0) {
$jexpire=JOB_EXPIRE_DAY;
$jexpire_type="days";
}
elseif(JOB_EXPIRE_MONTH!=0){
$jexpire=JOB_EXPIRE_MONTH;
$jexpire_type="month";
}
elseif(JOB_EXPIRE_YEAR!=0){
$jexpire=JOB_EXPIRE_YEAR;
$jexpire_type="year";
}
bx_db_insert($bx_table_prefix."_companycredits","compid,jobs,featuredjobs,contacts,jexpire,jexpire_type","'".$compid."','0','0','0','".$jexpire."','".$jexpire_type."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
if($use_extra_modules==true && isset($mod_include['a105'])){
include($mod_include['a105']);
}
if (USE_ACTIVATION_CODE=="yes") {
$new_key = substr(md5($HTTP_POST_VARS['email'].time()), 0, 20);
bx_db_query("UPDATE ".$bx_table_prefix."_companies set comp_akey = '".$new_key."', comp_akey_status='0' where compid = '".$compid."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
$HTTP_POST_VARS['activation_link'] = HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation&key=".$new_key;
$HTTP_POST_VARS['comp_akey'] = $new_key;
}
$pricing_query=bx_db_query("SELECT * from ".$bx_table_prefix."_pricing_".$bx_table_lng." where pricing_default='1'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
if (bx_db_num_rows($pricing_query)!=0) {
$pricing_result = bx_db_fetch_array($pricing_query);
bx_db_query("UPDATE ".$bx_table_prefix."_companycredits set jobs='".$pricing_result['pricing_avjobs']."', featuredjobs='".$pricing_result['pricing_fjobs']."',contacts='".$pricing_result['pricing_avsearch']."', jexpire='".$pricing_result['pricing_jexpire']."', jexpire_type='".$pricing_result['pricing_jexpire_type']."' where compid='".$compid."'");
bx_db_insert($bx_table_prefix."_membership","compid,pricing_id","'".$compid."','".$pricing_result['pricing_id']."'");
SQL_CHECK(0,"SQL Error at ".__FILE__.":".(__LINE__-1));
if($pricing_result['pricing_period']=='0') {
$planning_date = "0000-00-00";
}
else {
$planning_date = bx_mdate('Y-m-d',mktime(date('H'),0,0,date('m')+$pricing_result['pricing_period'],date('d'),date('Y')));
}
bx_db_query("UPDATE ".$bx_table_prefix."_companies set expire='".$planning_date."', featured='".(($pricing_result['pricing_fcompany']=="yes")?"1":"0")."', comp_joblink='".(($pricing_result['pricing_joblink']=="yes")?"1":"0")."' where compid='".$compid."'");
SQL_CHECK(0,__FILE__.":".(__LINE__-1));
}
//send mail to registered company
$HTTP_POST_VARS['today'] = bx_format_date(bx_mdate('d-m-Y'), DATE_FORMAT);
if (USE_ACTIVATION_CODE=="yes") {
$mailfile = $language."/mail/employer_registration_with_activation.txt";
}
else{
$mailfile = $language."/mail/employer_registration.txt";
}
include(DIR_LANGUAGES.$mailfile.".cfg.php");
if($mail_active=="yes"){
$mail_message = fread(fopen(DIR_LANGUAGES.$mailfile,"r"),filesize(DIR_LANGUAGES.$mailfile));
if ($use_extra_fields) {
make_mail_values($companies_new_fields,$HTTP_POST_VARS);
foreach($extra_fields as $key => $val) {
$fields[$key] = $val;
}
}
reset($fields);
while (list($h, $v) = each($fields)) {
$mail_message = str_replace($v[0],bx_htmlmailtransform($HTTP_POST_VARS[$h],$html_mail),$mail_message);
$file_mail_subject = str_replace($v[0],$HTTP_POST_VARS[$h],$file_mail_subject);
}
if ($add_html_header == "yes") {
$mail_message = str_replace("%%today_date%%",bx_format_date(bx_mdate('d-m-Y'), DATE_FORMAT),@fread(@fopen(DIR_LANGUAGES.$language."/mail/header.txt","r"),@filesize(DIR_LANGUAGES.$language."/mail/header.txt"))).$mail_message;
}
if ($add_html_footer == "yes") {
$mail_message .= str_replace("%%today_date%%",bx_format_date(bx_mdate('d-m-Y'), DATE_FORMAT),@fread(@fopen(DIR_LANGUAGES.$language."/mail/footer.txt","r"),@filesize(DIR_LANGUAGES.$language."/mail/footer.txt")));
}
if ($add_mail_signature == "on") {
$mail_message .= "\n".SITE_SIGNATURE;
}
bx_mail(SITE_NAME,FROM_MAIL,$HTTP_POST_VARS['email'], stripslashes($file_mail_subject), stripslashes($mail_message), $html_mail);
}
if (NOTIFY_ADMIN_REGISTRATION=="yes") {
$notify_type="comp";
include_once(DIR_SERVER_ROOT."notify_admin.php");
}
if (USE_ACTIVATION_CODE=="yes") {
$success_message=TEXT_NEW_COMPANY_CREATED_ACTIVATE;
$nocontinuetext=true;
$backtopage=TEXT_ACTIVATE_ACCOUNT;
$back_url=bx_make_url(HTTP_SERVER.FILENAME_LOGIN."?login=employer&type=activation", "auth_sess", $bx_session);
}
else{
$success_message=TEXT_NEW_COMPANY_CREATION_SUCCESS;
$employerid=$compid;
bx_session_register("employerid");
$HTTP_SESSION_VARS['employerid'] = $compid;
$sessiontime = time();
bx_session_register("sessiontime");
$u_noname=true;
@bx_session_register("u_noname");
@setcookie("phpjob_uname", $HTTP_POST_VARS['company'], mktime(0,0,0,date('m')+3,date('d'),date('Y')), '/');
$left_navigation_width='0%';
$right_navigation_width=RIGHT_NAV_WIDTH;
$main_navigation_width=MAIN_LNAV_WIDTH;
$nocontinuetext=true;
$backtopage=TEXT_CONTINUE;
$back_url=bx_make_url(HTTP_SERVER.FILENAME_EMPLOYER."?action=job_form", "auth_sess", $bx_session);
}
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_MESSAGE_FORM);
include(DIR_SERVER_ROOT."footer.php");
} //end else error=1
} //end if newaccount
else {
if ($action=="comp_form") {
$login='employer';
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_LOGIN_FORM);
include(DIR_SERVER_ROOT."footer.php");
}
else {
$fsess=($HTTP_SESSION_VARS['fsess'])?$HTTP_SESSION_VARS['fsess']:time();
bx_session_unregister("fsess");
bx_session_register("fsess");
include(DIR_SERVER_ROOT."header.php");
include(DIR_FORMS.FILENAME_COMPANY_FORM);
include(DIR_SERVER_ROOT."footer.php");
}
}
}
bx_exit();
?>
The dates show like this:
2020-05-20
or
2030-06-20
I need someone that knows the software and can give me some input as where to start looking.
This is just one of many errors
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: Losing my mind please help?
Please edit your post to use [syntax=sql]-- sql here[/syntax] and [syntax=php]/* php here */[/syntax].
Post again when you've done it and I'll take a look.
Post again when you've done it and I'll take a look.
Re: Losing my mind please help?
Try also to indent your code, it is almost unreadable in its current state. Be gracious to your fellow developers 
http://framework.zend.com/manual/en/cod ... ndard.html
http://framework.zend.com/manual/en/cod ... ndard.html
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: Losing my mind please help?
It is intended, click quote on his post. Yet another problem with not using code tags.pytrin wrote:Try also to indent your code, it is almost unreadable in its current state.
Re: Losing my mind please help?
You need to use [ code ] tags as the others as said.
Is this being interpreted by MySQL or is it being sent in the query as a string by your database class?
Is this being interpreted by MySQL or is it being sent in the query as a string by your database class?
Code: Select all
DATE_ADD(NOW(), interval ".TIMEZONE_OFFSET." HOUR)