Stock Script similar to NodeDeploy / BuyVM

zafouhar

I have seen that NodeDeploy and BuyVM have scripts that show the stock status and i was wondering if there is a similar script somewhere available to download/purchase?

Thx

zafouhar

@PhilND

HalfEatenPie

Code it yourself?

curtisg

I believe BlueVM released his script...

gubbyte

@HalfEatenPie said: Code it yourself?

Hey, why are you using that browser you're using just now?

Code one yourself?

Ash_Hawkridge

Not sure how you would do it but i bet its possible to pull those stats from the WHMCS stock level system and display them externally.

HalfEatenPie

@gubbyte said: Hey, why are you using that browser you're using just now?

Code one yourself?

I will admit, I don't have any response to this. Touche sir.

[Deleted User]

@GetKVM_Ash said: Not sure how you would do it but i bet its possible to pull those stats from the WHMCS stock level system and display them externally.

That's what I always imagined was being done.

zafouhar

I did find some code from Matt from WHMCS:

$query = "SELECT qty FROM tblproducts WHERE id='1'"; $result=mysql_query($query); $data = mysql_fetch_array($result); $qty = $data['qty']; if ($qty=="0") { echo("Currently Out Of Stock"); } else { echo("$qty Available"); }

But the question for me is what is next, i don't really know a lot of coding.

Ash_Hawkridge

Just change

WHERE id='1'"

To reflect the product ID in WHMCS.

gameon

is it really required to pull from WHMCS ? if my guess is right the site 'doesbuyvmhavestock.com' when it started was not affiliated to buyvm , yet they could pull the live stats.

i'm not sure about it though , may be @Francisco can help

zafouhar

Yep i know that @GetKVM_Ash

What i am unsure currently is how to get that to display in my stock.php page

NHRoel

@zafouhar said: What i am unsure currently is how to get that to display in my stock.php page

DB connect?

Ash_Hawkridge

You just need to establish a MYSQL connection (Loads of tutorials for that around) and use that code within the PHP code.

Im not much of a coder myself but i recon its that simple.

zafouhar

Yes seems i just managed to code something despite my very limited knowledge:

<?php $con = mysql_connect("localhost","myusername","mypassword"); if (!$con) { die('Could not connect: ' . mysql_error()); } $query = "SELECT qty FROM tblproducts WHERE id='1'"; $result=mysql_query($query); $data = mysql_fetch_array($result); $qty = $data['qty']; if ($qty=="0") { echo("Currently Out Of Stock"); } else { echo("$qty Available"); } // mysql_query($sql,$con); // some code mysql_close($con); ?>

kamalnasser

lowendstock.com

zafouhar

And i get an error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/username/public_html/stock.php on line 10

djvdorp

Or just scrape dem pages

BlueVM

@zafouhar - Here's some example code for you that will list all of your products in a table.

http://pastie.org/private/yzzcx25vbg0bspeudyk5a

Simply fill in the database information and it will display all of your non-hidden products and how much stock they have left. You can apply whatever template you like. I will probably make this into a whmcs "addon" at some point.

zafouhar

Thx for that @BlueVM however i get the following error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in /home/public_html/stock.php on line 17

joepie91

@zafouhar said: Thx for that @BlueVM however i get the following error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in /home/public_html/stock.php on line 17

That means there were no results from the database query.

Ben1002

I coded the NodeDeploy one, I need to recode it at some point.

zafouhar

But if i run the query SELECT * FROM tblproducts WHERE hidden != 'on' via phpmyadmin for example it returns 2 rows which is currently correct. @joepie91

HalfEatenPie

Is it using the same database user as WHMCS (aka permissions?) or a different database user?

kamalnasser

Try adding echo mysql_error(); after the mysql_query() line to see the error.

@joepie91 said: That means there were no results from the database query.

That means that there was an SQL error.

Damian

@zafouhar said: But if i run the query SELECT * FROM tblproducts WHERE hidden != 'on'

@zafouhar said: $query = "SELECT qty FROM tblproducts WHERE id='1'";

These are two different queries. Do you have a product with ID = 1?

zafouhar

I am using the same database user as WHMCS is using @HalfEatenPie

Yes i have a product with id of 1 @Damian

I've tried adding echo myself_error() but the message i get remains the same @kamalnasser

BlueVM

@zafouhar - I actually pasted the wrong piece of code try this one instead:

http://pastie.org/private/2dusfny2urbxf3nkcikumw

Tested working: https://bluevm.com/test.php

Damian

If this is going to be part of your WHMCS template, also see http://docs.whmcs.com/SQL_Helper_Functions

If not going to be part of your WHMCS template, please use mysqli at least, see the BRW at http://us1.php.net/mysql_query

Wintereise

You just need to establish a MYSQL connection (Loads of tutorials for that around) and use that code within the PHP code.

Do not enter the db details there, you have no need to. Include dbconnect.php, you can just fetch results with your query after that.

zafouhar

Ok it now works with the updated script that @BlueVM just provided, thx @BlueVM for providing the script and everyone else!