XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


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


31
zyspec
Re: Job module

  • 2020/3/5 22:59

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


I quickly patched the JobCategory class so you should be able to add Job Categories now too...

Again - let us know if it's working or if you're still having problems. Feedback either way is appreciated.

Once I hear from you I'll commit some additional changes I've made to improve the admin side.
Topic | Forum


32
zyspec
Re: Job module

  • 2020/3/5 21:23

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


@heh26,

I've uploaded a quick fix to my fork to allow you to set permissions.

I also uploaded a quick fix for the dB tables. They weren't being uninstalled correctly when the module was uninstalled.

I have several other changes to improve the module but I didn't want to include them until we're sure the permissions issue is fixed.

Please let me know if this fixes the issue you were seeing. I'll look into the issue you were seeing adding a category next.

You can see my fork athttps://github.com/zyspec/jobs
Topic | Forum


33
zyspec
Re: Job module

  • 2020/3/3 18:52

  • zyspec

  • Module Developer

  • Posts: 1095

  • 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.
Topic | Forum


34
zyspec
Re: Job module

  • 2020/3/3 15:07

  • zyspec

  • Module Developer

  • Posts: 1095

  • 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.
Topic | Forum


35
zyspec
Re: Job module

  • 2020/3/2 23:31

  • zyspec

  • Module Developer

  • Posts: 1095

  • 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
Topic | Forum


36
zyspec
Re: use line-break in tpl files

  • 2020/2/13 22:41

  • zyspec

  • Module Developer

  • Posts: 1095

  • 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....
Topic | Forum


37
zyspec
Re: help with mysql xoops query and msaccess database

  • 2020/1/29 15:59

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


Great! Glad you got it working....
Topic | Forum


38
zyspec
Re: help with mysql xoops query and msaccess database

  • 2020/1/27 14:06

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


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

implode(',', 'deptIdArray')

should be:
implode(',', $deptIdArray)
Topic | Forum


39
zyspec
Re: help with mysql xoops query and msaccess database

  • 2020/1/27 1:48

  • zyspec

  • Module Developer

  • Posts: 1095

  • 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");
Topic | Forum


40
zyspec
Re: How to create a new xoopsDB connection - from scratch

  • 2019/12/13 3:00

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


Try
$db     = XoopsDatabaseFactory::getDatabaseConnection();
Topic | Forum



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



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

232 user(s) are online (165 user(s) are browsing Support Forums)

Members: 0

Guests: 232

more...

Donat-O-Meter

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

Latest GitHub Commits