Yarnell

Yeah, the chart has the option to switch between visitors and customers. I used the customer_id field to limit to customers only.

Yeah, the users online tab. and I put a traffic chart on my dashboard. I will try converting that field to a varchar... see if that makes a difference.

2022 was just an example. I would like to weed out any sessions that I don't need to track. cron jobs for example. I have a wget command running every 30 mins or so and cubecart creates a new session each time it runs. So would it be ok for me to just change the field to varchar... it won't effect anything?

I noticed that the location field is varbinary. Is there anyway to match the above code to a varbinary field? I can't seem to get it to work.

Database::getInstance()->delete('CubeCart_sessions', array('location' >= 2022), false); Hey all, How do I change the >= 2022 to LIKE %2022%?

Awesome. I ended up using the following code: require dirname(__FILE__).DIRECTORY_SEPARATOR.'ini.inc.php'; define('CC_IN_ADMIN', false); include CC_ROOT_DIR.CC_DS.'controllers'.CC_DS.'controller.index.inc.php'; Many thanks Brian

Hey all, I am using the following code in a php script to grab config data and db data, this works perfectly. require 'ini.inc.php'; define('ADMIN_CP', true); require 'includes/functions.inc.php'; $GLOBALS['cache'] = Cache::getInstance(); $GLOBALS['db'] = Database::getInstance($glob); $GLOBALS['config'] = Config::getInstance($glob); unset($glob); $GLOBALS['config']->merge('config', '', $config_default); I am having trouble getting user data... when I add: $GLOBALS['user'] = User::getInstance(); It results in the following error: [Wed Dec 27 20:19:02.242234 2023] [proxy_fcgi:error] [pid 13504] [client 192.168.0.5:25441] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to a member function load() on null in /XXX/classes/user.class.php:1135\nStack trace:\n#0 /XXX/classes/user.class.php(143): User->_load()\n#1 /XXX/classes/user.class.php(167): User->__construct()\n#2 /XXX/player.php(19): User::getInstance()\n#3 {main}\n thrown in /XXX/classes/user.class.php on line 1135', referer: https://domain.com Is there a way to get data from the current user instance? Thanks -- Yarnell

If anyone happens to run into this issue I have resolved it by using a bit of javascript. Html <div> <a href="javascript:void(0)" onclick="makeChange()">Make Changes</a> </div> Javascript <script> function myFunction() { var x = document.getElementById("checkout_register_form"); var y = document.getElementById("register_false_address"); if (x.style.display === "block") { x.style.display = "none"; y.style.display = "block"; } else { x.style.display = "block"; y.style.display = "none"; } } </script> This snippet will hide the confirmation div and show the registration form.

Yes. Once the customer has entered thier address the confirmation page comes up. I'd like to add a link to go back and make changes if needed. I tried using the stage links but its stuck on the confirmation page.

Morning, I can't seem to figure out the following: skins\foundation\templates\content.checkout.confirm.php <div class="pad-top"><a href="#" class="button small show_address_form"><svg class="icon"><use xlink:href="#icon-reply"></use></svg> {$LANG.form.make_changes}</a></div> This method works for the foundation skin but not in other skins. Is there any way to go back and make changes by clicking a link without the #?

Awesome. thanks B

Hey all, Quick question. I have 2 shipping costs, the first item is 12.50 and each additional item is 2.50. How would I go about setting that up?

Sup all, I just noticed that pagination is not working. I'm not sure if its my custom mods or not. The page links are generated but the products do not change when i click a page link. I'm using version 6.5.1. Is this a bug or did I mess something up? Thanks

ahhh. ok. great... opposite of what I was thinking. thanks

Hey all, just a quick question. Is the live_from column in the inventory table the date in which the product goes live? I see it uses a UNIX_TIMESTAMP() format. How would i make a unix timestamp with php's date function? thanks.