Rare price catalog for your client (update)

Josel

New Member
Feb 18, 2021
7
16
Hello everyone! In retros it is essential to have an economy, therefore knowing the prices of each of the rares is essential, so I coded a price catalog of rares, I hope you enjoy it a lot for your retros! Remember that you can implement it in any cms, you can use the base code and modify it to your liking!

Excuse my English a little, my natural language is Spanish.

You must be registered for see images attach


You must be registered for see images attach


You must be registered for see images attach


Download: (Update thanks Sledmore)

Installation:
1.
First put the client folder in the root of your CMS.
2. Then go to client and in the catalogo_client.php file edit your data in the following snippet.
$servername = "localhost";
$username = "root";
$password = "contraseña";
$dbname = "DataBase";

3. Put this SQL code in your database.

4. In the client file of your hotel put the following code:
<?php
include_once 'client/catalogo_client.php';
?>

Credits:
ZayterDep (Code)

I did an update separating the css from the php, adding the images, and correcting some part thanks also to Sledmore for the fix.
Maybe this will update it creating a version 2.0.

I hope you like it! I plan to bring more contributions!


Remember that I also uploaded the levelsystem plugin rewards here:
 
Last edited:

Puffin

Spooky Donator
Mar 17, 2018
430
377
Dude you saved me 50 euro.... Arpy has a similar plugin I was considering buying. This one looks much better
 

FunkyBohh

Member
Jun 21, 2011
181
6
Where would i put the?

<?php
include_once 'client/catalogo_client.php';
?>

I'm using atomcms?


Hello everyone! In retros it is essential to have an economy, therefore knowing the prices of each of the rares is essential, so I coded a price catalog of rares, I hope you enjoy it a lot for your retros! Remember that you can implement it in any cms, you can use the base code and modify it to your liking!

Excuse my English a little, my natural language is Spanish.

You must be registered for see images attach


You must be registered for see images attach


You must be registered for see images attach


Download:


Installation:
1.
First put the client folder in the root of your CMS.
2. Then go to client and in the catalogo_client.php file edit your data in the following snippet.


3. Put this SQL code in your database.


4. In the client file of your hotel put the following code:


Credits:
ZayterDep (Code)

I hope you like it! I plan to bring more contributions!

Remember that I also uploaded the levelsystem plugin rewards here:
 

FunkyBohh

Member
Jun 21, 2011
181
6
The CMS is showing an error: Undefined Error $nombr and referring to line 156.

Code:
  $sql = "SELECT * FROM catalogo_zayter WHERE nombre LIKE '%$nombre%' ORDER BY nombre";

I removed the '$' and the client loads, however, nothing from the catalogo_zayter table appears?
 

Sledmore

Chaturbate Livestreamer
Staff member
FindRetros Moderator
Jul 24, 2010
5,199
3,934
Nice release, but I'd be surprised if it doesn't error as $nombre isn't defined? I would say you should also use prepared statements, but you have some JS for filtering so I don't think you even need that query, I'd change:

PHP:
$sql = "SELECT * FROM catalogo_zayter WHERE nombre LIKE '%$nombre%' ORDER BY nombre";
To:
PHP:
$sql = "SELECT * FROM catalogo_zayter ORDER BY nombre";

I would probably also make a slight change to:
PHP:
echo "<div class='col-lg-6 col-xl-4 order-first'>";
Change to:
PHP:
echo "<div class='col-lg-6 col-xl-4 order-first rare-entry'>";

And:
JavaScript:
$(".card").filter(function() {
To:
JavaScript:
$(".rare-entry").filter(function() {
That way you don't have empty divs making space.

It's a nice release, just seems unneccessarily heavily. Calling image assets from habborator, habboassets & habbo, and then on top of that lots of other dependencies.
 

Josel

New Member
Feb 18, 2021
7
16
Nice release, but I'd be surprised if it doesn't error as $nombre isn't defined? I would say you should also use prepared statements, but you have some JS for filtering so I don't think you even need that query, I'd change:

PHP:
$sql = "SELECT * FROM catalogo_zayter WHERE nombre LIKE '%$nombre%' ORDER BY nombre";
To:
PHP:
$sql = "SELECT * FROM catalogo_zayter ORDER BY nombre";

I would probably also make a slight change to:
PHP:
echo "<div class='col-lg-6 col-xl-4 order-first'>";
Change to:
PHP:
echo "<div class='col-lg-6 col-xl-4 order-first rare-entry'>";

And:
JavaScript:
$(".card").filter(function() {
To:
JavaScript:
$(".rare-entry").filter(function() {
That way you don't have empty divs making space.

It's a nice release, just seems unneccessarily heavily. Calling image assets from habborator, habboassets & habbo, and then on top of that lots of other dependencies.
Thanks bro I'll take it into account
Post automatically merged:

Because people are really interested in this I will be making the V2 catalog, if you have some suggestions much better.

Update V2.
You must be registered for see images attach
 
Last edited:

Josel

New Member
Feb 18, 2021
7
16
Anyone adding this be aware you will need to do quite a bit of CSS fixes, especially if your furniture name is longer than ‘Throne’ but it’s a great base to start off of.

Also best to move all of these assets it’s pulling from to your local server to make things load faster :)

We switched to icons instead of full sizes furni so we can just pull the icon path easily instead.

Love the LtD change by the way but the font overlay could use work, I think it’d look better centerized in the box

As I read your new post I see you did mostly the same changes we did haha
Post automatically merged:

Other than that you have a couple of useless fields in your database table you should make use of, like the VIP function. Should also add categories since you have a field in the table for that as well.
You must be registered for see images attach

If I'm running version 2
Post automatically merged:

is this a plugin ?
No, you can put it in any cms
 

duckietm

Member
Dec 31, 2010
43
22
Hmmmm a simple select call in a php scrippie everytime you call it.
how to get your DB down, nice. its a good thing this is down.
 

Puffin

Spooky Donator
Mar 17, 2018
430
377
other than the plugin version created by Arpy for 50 euros (I think) which is what this is based off of, no, but as mentioned above using this is a great way to get your database wiped.
 

Users who are viewing this thread

Top