Adding users to forum user groups

Cloudlessrain — Tue, 25 Feb 2020 18:26:56 +0000

This seems like a silly problem but I can't figure out how to add users to forum user groups (as opposed to normal Combu user groups) via script. You can add them in the Combu admin panel, or set the group to default, you can also ban them. But how is a user added?

status of forum asset

Cloudlessrain — Tue, 18 Feb 2020 06:08:18 +0000

HI there, I just got the Combu demo up and working and I'm excited to dive deeper.

In particular I want to build a forum system but before I purchase the forum asset I thought I'd check to make sure that it isn't deprecated. On the asset store it appears that there hasn't been an updated for a couple years.

Updating a int in column in database

slthompson — Sat, 06 Jul 2019 13:57:11 +0000

I'm using opencart and a rewards point addon module so when a user buys coins on my website for real money the rewards points are added to their coins column in the user table. I'm having a hard time figuring out how to make this happen.

The table name has a prefix, table name is 'customer', each customer has an id 'customer_id' and the column that needs to be updated (int added) with the reward points is 'coins'.

This is the script that does this:

Auto Reward Points
OC 1.5
2.0.0
Equotix



       // Auto Reward Points
    $this->load->model('sale/customer');

    $reward_total = $this->model_sale_customer->getTotalCustomerRewardsByOrderId($order_id);

    if (!$reward_total && $data == $this->config->get('config_complete_status_id')) {
     $this->language->load('sale/order');

     $order_info = $this->getOrder($order_id);

     if ($order_info && $this->config->get(base64_decode('YXV0b19yZXdhcmRfcG9pbnRzX2xpY2Vuc2VfbGljZW5zZV9rZXk='))) {
      $this->db->query("INSERT INTO " . DB_PREFIX . "customer_reward SET customer_id = '" . (int)$order_info . "', order_id = '" . (int)$order_id . "', points = '" . (int)$order_info . "', description = '" . $this->db->escape($this->language->get('text_order_id') . ' #' . $order_id) . "', date_added = NOW()");
     }
    }
    // End Auto Reward Points
   ]]>




       // Auto Reward Points
    $reward = 0;

$reward_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");

    foreach ($reward_query->rows as $product) {
     $reward += $product;
    }

    $reward_total = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_reward WHERE order_id = '" . (int)$order_id . "' AND points > 0");

    if (!$reward_total->row && $order_status_id == $this->config->get('config_complete_status_id')) {
     $this->language->load('account/order');

     $order_info = $this->getOrder($order_id);

     if ($order_info && $this->config->get('auto_reward_points_license_license_key')) {
      $this->db->query("INSERT INTO " . DB_PREFIX . "customer_reward SET customer_id = '" . (int)$order_info . "', order_id = '" . (int)$order_id . "', points = '" . (int)$reward . "', description = '" . $this->db->escape($this->language->get('text_order_id') . ' #' . $order_id) . "', date_added = NOW()");
     }
    }
    // End Auto Reward Points
   ]]>

Script also added as attachment.

Import xml

slthompson — Wed, 26 Jun 2019 13:08:11 +0000

I'm getting the following when importing the xml file into my database:

Error
SQL query:

USE `combu_addons`

MySQL said:
#1044 - Access denied for user 'cpses_baor6zseuz'@'localhost' to database 'combu_addons'

There isn't a combu_addons table in the combu database, is something missing?

Forum for Combu - Forums

Adding users to forum user groups

status of forum asset

Updating a int in column in database

Import xml