How Can I Disable A Vendor Account Using Php

General General Questions
1

I have tried this but it's not working,

$status_to = 'D';

db_query("UPDATE ?:companies SET ?u WHERE company_id = ?i", $status_to, $company_id);

Any help is appreciated, thanks

2

Hello

db_query("UPDATE ?:companies SET ?u WHERE company_id = ?i", array("status"=> $status_to), $company_id);

Best regards

Robert

3

Hello

db_query("UPDATE ?:companies SET ?u WHERE company_id = ?i", array("status"=> $status_to), $company_id);

Best regards

Robert

It's not working

4

db_query("UPDATE ?:copanies SET status=?s WHERE company_id=?i", 'D', $company_id);

5

All answers are correct but the problem is $company_id is not getting the vendor's id


How can i get the vendor's id?

6

Hello

It depends on where you are in the cs-cart (frontend, backend). company_id can be taken from e.g. a session.

Best regards

Robert

7

I'm on the backend

8

Hello

What place of backend? Have you connected to any addon? some controller?

Best regards

Robert

9

On the controller area, i finally used $is_vendor_id = Registry::get('runtime.company_id'); Thanks a lot.

10

Hello

You are welcome :)

Best regards

Robert