| @@ 80-84 (lines=5) @@ | ||
| 77 | $lid, $ratinguser, $rating, $ip, $datetime); |
|
| 78 | // $xoopsDB->query($sql) || $erh->show('0013'); // '0013' => 'Could not query the database.', // <br>Error: ' . mysql_error() . '', |
|
| 79 | $success = $xoopsDB->query($sql); |
|
| 80 | if (!$success) { |
|
| 81 | $modHandler = xoops_getModuleHandler('module'); |
|
| 82 | $myModule = $modHandler->getByDirname('adslight'); |
|
| 83 | $myModule->setErrors('Could not query the database.'); |
|
| 84 | } |
|
| 85 | ||
| 86 | //All is well. Calculate Score & Add to Summary (for quick retrieval & sorting) to DB. |
|
| 87 | // updateIrating($lid); |
|
| @@ 81-85 (lines=5) @@ | ||
| 78 | $usid, $ratinguser, $rating, $ip, $datetime); |
|
| 79 | // $xoopsDB->query($sql) || $erh->show('0013'); // '0013' => 'Could not query the database.', // <br>Error: ' . mysql_error() . '', |
|
| 80 | $success = $xoopsDB->query($sql); |
|
| 81 | if (!$success) { |
|
| 82 | $modHandler = xoops_getModuleHandler('module'); |
|
| 83 | $myModule = $modHandler->getByDirname('adslight'); |
|
| 84 | $myModule->setErrors('Could not query the database.'); |
|
| 85 | } |
|
| 86 | ||
| 87 | //All is well. Calculate Score & Add to Summary (for quick retrieval & sorting) to DB. |
|
| 88 | // updateUrating($usid); |
|
| @@ 101-105 (lines=5) @@ | ||
| 98 | $xoopsDB->prefix('adslight_listing'), $newid, $cid, $title, $status, $expire, $type, $desctext, $tel, $price, $typeprice, $typeusure, $date, $email, $submitter, $usid, $town, |
|
| 99 | $country, $contactby, $premium, $valid); |
|
| 100 | $success = $xoopsDB->query($sql); |
|
| 101 | if (!$success) { |
|
| 102 | $modHandler = xoops_getModuleHandler('module'); |
|
| 103 | $myModule = $modHandler->getByDirname('adslight'); |
|
| 104 | $myModule->setErrors('Could not query the database.'); |
|
| 105 | } |
|
| 106 | ||
| 107 | $lid = $xoopsDB->getInsertId(); |
|
| 108 | ||
| @@ 105-109 (lines=5) @@ | ||
| 102 | $country, $contactby, $premium, $valid); |
|
| 103 | // $xoopsDB->query($sql) || $erh->show('0013'); // '0013' => 'Could not query the database.', // <br>Error: ' . mysql_error() . '', |
|
| 104 | $success = $xoopsDB->query($sql); |
|
| 105 | if (!$success) { |
|
| 106 | $modHandler = xoops_getModuleHandler('module'); |
|
| 107 | $myModule = $modHandler->getByDirname('adslight'); |
|
| 108 | $myModule->setErrors('Could not query the database.'); |
|
| 109 | } |
|
| 110 | ||
| 111 | $lid = $xoopsDB->getInsertId(); |
|
| 112 | ||