Losing my mind please help?

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
TashaAt
Forum Newbie
Posts: 2
Joined: Sun Jul 06, 2008 5:29 am

Losing my mind please help?

Post by TashaAt »

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? :banghead:
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: Losing my mind please help?

Post by Ollie Saunders »

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.
TashaAt
Forum Newbie
Posts: 2
Joined: Sun Jul 06, 2008 5:29 am

Re: Losing my mind please help?

Post by TashaAt »

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
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: Losing my mind please help?

Post by Ollie Saunders »

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.
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Losing my mind please help?

Post by Eran »

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
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: Losing my mind please help?

Post by Ollie Saunders »

pytrin wrote:Try also to indent your code, it is almost unreadable in its current state.
It is intended, click quote on his post. Yet another problem with not using code tags.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: Losing my mind please help?

Post by Benjamin »

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?

Code: Select all

 
DATE_ADD(NOW(), interval ".TIMEZONE_OFFSET." HOUR)
 
Post Reply