Buy furniture on the site?

[Baloe20xd]

Hi

I intend to build a system on the site that you can buy on 1 page of furniture which you then get in the client with your items.

But now my question was how do I make something like that with query.
Because I already have a system for diamonds.

Who can help me with that?

Thanks in advance.

 

[Joe]

Hi

I intend to build a system on the site that you can buy on 1 page of furniture which you then get in the client with your items.

But now my question was how do I make something like that with query.
Because I already have a system for diamonds.

Who can help me with that?

Thanks in advance.

Just make a query to insert an item into that user ID’s inventory when they buy it. The only problem I see with this is that you’d have to be offline to use it properly.

Post automatically merged: Mar 12, 2019

At least I think you would, unless it updates in real time.

 

[JynX]

As JMG said you'd just need to run an insert query to insert the furniture into the database if they're offline and you'd also probably want to use RCON to give them the item if they are online.

 

[Baloe20xd]

Hi,
Thanks for your comment!
But how do I build that query?
I already have everything that you need to be offline when you go buy it.
But building the query is not my best side ...

I now have this:

"INSERT INTO items (user_id, item_id, extra_data) VALUES ((SELECT id FROM items_base WHERE item_name = 'ITEM_NAME'))"

Is this already something?
Can someone help me to continue building the Query?

 

[Joe]

Hi,
Thanks for your comment!
But how do I build that query?
I already have everything that you need to be offline when you go buy it.
But building the query is not my best side ...

I now have this:

"INSERT INTO items (user_id, item_id, extra_data) VALUES ((SELECT id FROM items_base WHERE item_name = 'ITEM_NAME'))"

Is this already something?
Can someone help me to continue building the Query?

I’m on my phone but I’m pretty sure the query’s exist here

You must be registered for see links

 

[Baloe20xd]

I’m on my phone but I’m pretty sure the query’s exist here

You must be registered for see links

Thanks for your comment!

I just tested it on RevCMS everything works but you don't get any items in the client?
"You bought a crate, check your inventory to open your crate!"
He also makes nothing in the '' items '' db.
But in crate_logs

 

[Joe]

Maybe this version is better than the original one I gave you.

You must be registered for see links

Use it as a base, the code is all there.

 

[Baloe20xd]

Maybe this version is better than the original one I gave you.

You must be registered for see links

Use it as a base, the code is all there.

Done!
But it still doesn't work ..
Everything it is supposed to do in the topic that is indicated does it except the item on my account? There is nothing in the '' items ''

But I have the feeling that this is due? :

You must be registered for see links

What should I change in the item table or in that piece of code?

I just don't understand that ..
This is how my "" items "" looks like:

You must be registered for see links

You must be registered for see links

Code:

mysql_query("INSERT INTO `items` (`id`, `user_id`, `base_item`, `extra_data`) VALUES ('".$iDs."', '".$_SESSION['user']['id']."', '920020', 'JoeThank you for purchasing a loot crate, double click to open!643246337249')");

 

[Joe]

Read the thread again, you’re not changing the values that you’re supposed to.

I’ve set up the creates before, they do work.

Post automatically merged: Mar 13, 2019

Maybe making a catalogue on the CMS isn’t for you since you’re struggling with basic queries.