31
zyspec
Re: Job module
  • 2020/3/3 18:52

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


I'll try and find some time in the next few days to load this on my test server and see if I can find anything.... I'll let you know the outcome.



32
zyspec
Re: Job module
  • 2020/3/3 15:07

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


Please turn on XOOPS Debug and see if the system generates any errors or shows any type of dB SQL Query calls that look incorrect (text displayed in RED and showing an error). Let us know what you find.



33
zyspec
Re: Job module
  • 2020/3/2 23:31

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


You might try Mamba's version. It has quite a few updates from the version you're using....

https://github.com/mambax7/jobs

It should fix the pass-by-reference issues you're seeing.

Here's a summary of the changes:

4.4 RC 4 [NOT RELEASED] - Dev: Xoops 2.5.9, PHP 7.2.3
================================================
- moved all images, CSS, and JS files to /assets (mamba)
- renamed .html Smarty templates to .tpl (mamba)
- XOOPS 2.5.9, PHP 7 (mamba)
- Converted to XOOPS 2.5.8 Admin GUI (Mamba)
- removed @version (mamba)
- PSR-2 code cosmetics (mamba)
- addNavigation(basename(__FILE__)) (mamba)
- dirname(__FILE__) to __DIR__ (mamba)
- replaced < br /> with < br > (mamba)
- Unnecessary double quotes (mamba)
- reference mismatch (mamba)
- Hardening to type safe (mamba)
- update Help (mamba)
- changed _handler to Handler (mamba)
- removed '/' from void HTML elements (<br>, <img>, etc) (mamba)
- HTML 5: removed 'selected' and 'checked' (mamba)
- updated file headers for consistency (mamba)
- renamed several $indexAdmin with $adminObject for consistency (mamba)
- Updates for PayPal changes (zyspec)
- added Contributing.md (mamba)
- started conversion to XMF (mamba)
- updated addInfoBoxLine entries (mamba)
- displayNavigation(basename(__FILE__)) (mamba)
- changed to ->displayButton('left') (mamba)

4.4 RC3 [2014-02-19]
=================================================
- redesigned Type Management - added tables (mamba)
- small source code changes related to PSR-2 (mamba)
- added folder/file checker



34
zyspec
Re: use line-break in tpl files
  • 2020/2/13 22:41

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


@goffy,

This may depend on if you're sending the email as HTML or plain text. $xoopsMailer->setHTML(true|false);

Instead of using
$xoopsMailer->assign('RESULT''Newsletter 1<br>Newsletter 2<br>Newsletter 3);

I would suggest you try something like:
$xoopsMailer->assign('RESULT''Newsletter 1' chr(10) . 'Newsletter 2' chr(10) . 'Newsletter 3');


Let us know what you find out....



35
zyspec
Re: help with mysql xoops query and msaccess database
  • 2020/1/29 15:59

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


Great! Glad you got it working....



36
zyspec
Re: help with mysql xoops query and msaccess database
  • 2020/1/27 14:06

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


sorry... just looked at the code I posted again.

implode(',''deptIdArray')

should be:
implode(','$deptIdArray)



37
zyspec
Re: help with mysql xoops query and msaccess database
  • 2020/1/27 1:48

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


@mjoel,

I haven't tried this but I think I'd take an approach something like this:

// first get a list of department IDs
$result $GLOBALS['xoopsDB']->query('SELECT DISTINCT(DEPTID) FROM ' $GLOBALS['xoopsDB']->prefix('mydepartments'));
list(
$deptIdArray) = $GLOBALS['xoopsDB']->fetchRow($result);

// connect to the Access dB
$conn odbc_connect('mydata','','');
if (!
$conn) {
    exit(
"Connection Failed: " $conn);
}

// now get the Access dB departments not in XOOPS
$accessQuery "SELECT DEPTID, DEPTNAME FROM DEPARTMENTS WHERE DEPTID NOT IN (" implode(',''deptIdArray') . ")";
$rs odbc_exec($conn$accessQuery);
if (!
$rs) {
    exit(
"Error in SQL");
}

// now put new departments into 'mydepartments' table
while(odbc_fetch_row($rs)){
    list(
$deptId$deptName) = odbc_result($rs'DEPTID''DEPTNAME');
    
$result $GLOBALS['xoopsDB']->query("INSERT INTO " $xoopsDB->prefix('mydepartments') . "($deptId$deptName));
    if (!
$result) {
        exit('Error inserting new department');
    }
    ++
$i;
    }
}
exit("
{$i} new departments entered into the database");



38
zyspec
Re: How to create a new xoopsDB connection - from scratch
  • 2019/12/13 3:00

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


Try
$db     XoopsDatabaseFactory::getDatabaseConnection();



39
zyspec
Re: Which editor do you use ?
  • 2019/12/12 17:26

  • zyspec

  • Module Developer

  • Posts: 1093

  • Since: 2004/9/21


I typically use Eclipse PDT.... I like it because:
  • there are versions for both Windows and Linux - so it's easy to switch between my various systems.
  • easy to create/modify coding styles (modified PSRxx, etc)
  • it's free
  • easily "jump-to" referenced functions
  • customized syntax highlighting for PHP, JS, XML, MySQL, etc
  • refactoring
  • GitHub integration (easy to pull/push/commit/etc)
  • Composer support
  • Good build/run tools
  • Eclipse community support
  • Bug/Issue tracking integration
  • code completion


  • The one drawback is lack of Smarty syntax support - there's a plugin for it but it's old & doesn't work well.

    I also use Notepad++ for a quick editor when needed. PHPStorm is a good product too but I haven't found enough difference/advantage to it that would cause me to change from Eclipse (and pay the money).



    40
    zyspec
    Re: Really stupid php / sql problem
    • 2019/12/12 14:58

    • zyspec

    • Module Developer

    • Posts: 1093

    • Since: 2004/9/21


    One thing is it appears that the print_r() in the getEmailsFromGroup() is missing the 'true' parameter in:
    file_put_contents(OLEDRION_GATEWAY_LOG_PATH"groupId: " print_r($groupId) . "n"FILE_APPEND LOCK_EX);


    should be:
    file_put_contents(OLEDRION_GATEWAY_LOG_PATH"groupId: " print_r($groupIdtrue) . "n"FILE_APPEND LOCK_EX);


    don't know if that's the only issue but looks like it should be corrected.




    TopTop
    « 1 2 3 (4) 5 6 7 ... 100 »



    Login

    Username:
    Password:

    Lost Password? Register now!

    Who's Online

    70 user(s) are online (30 user(s) are browsing Support Forums)


    Members: 0


    Guests: 70


    more...

    Donat-O-Meter

    Stats
    Goal: $100.00
    Due Date: May 31
    Gross Amount: $0.00
    Net Balance: $0.00
    Left to go: $100.00
    Make donations with PayPal!

    Latest GitHub Commits