Bank System Nvault/SQL Support - Page 4

bloodypro05

Quote:

Originally Posted by Supremache

New Updates: v1.6

can we use this with this shop system ?
https://amxx-bg.info/viewtopic.php?f=21&t=50
i tried added to the code
#include <customshop>
but not working

Timo137

dont save money after restart the server..,.. bad...

Napoleon_be · *Last edited by Napoleon_be; 07-20-2021 at 11:20.*

Quote:

Originally Posted by Timo137

dont save money after restart the server..,.. bad...

That shouldn't happen. Are you playing the same map 24/7? If so, perform a map change before restarting the server, that might fix your issue. (Depends on how the saving system works, i haven't checked the code.)

EDIT: I checked the code and apparently it only saves when a player disconnects from the server. So a suggestion to the author, add more frequent savings such as on the donating moment, withdrawing moment, etc.

Supremache · *Last edited by Supremache; 07-21-2021 at 07:09.*

@bloodypro05, Sorry I forgot this plugin, do you mean point system of coustomshop? Yes you can do it by following these steps
Using this plugin with other currencies top

The plugin also has the option to use native plugins in place of money. In simple words - you can make this plugin work with Ammo Packs, BaseBuilder Credits, JBPacks and more. To do this, you need to edit the following lines (15/16):
Spoiler
Code:
#define get_user_money(%1) cs_get_user_money(%1)
#define set_user_money(%1,%2) cs_set_user_money(%1, %2)
To change it to Ammo Packs, replace the rows with this:
Code:
#define get_user_money(%1) zp_get_user_ammo_packs(%1)
#define set_user_money(%1,%2) zp_set_user_ammo_packs(%1, %2)
Also, add the natives you use in both rows:
Code:
native zp_get_user_ammo_packs(id)
native zp_set_user_ammo_packs(id, amount)
Or include file:
Code:
#include <zombieplague>

@Timo137, I will fix this issue

@Napoleon_be, I forgot this, I will remake this plugin and fixing this issue thanks

Supremache · 08-07-2021 , 21:43 Re: Bank System SQL Support

New Version 1.7 ( August, 8, 2021 ):
Plugin Remaded.

Code Optimized.

Add SQL support.

Add ini file.

Removed GIVE/TAKE/TIMEPRESENT became as bank.

Added Natives get_user_bank_cash.

Added Natives set_user_bank_cash.

P.S: I didn't tested this plugin for lack of pc, if someone tested it give me the feedback.

Natsheh · 08-07-2021 , 23:29 Re: Bank System SQL Support

I really don't understand the point of banks can you explan how this is better than just saving player money using MySQL l/nvault directly by from player's steamid ?

I mean the point of bank system is for the limitations because people couldn't take their money everywhere but ingames is just different and you can go along expectations...

Supremache · 08-08-2021 , 00:02 Re: Bank System SQL Support

Quote:

Originally Posted by Natsheh

I really don't understand the point of banks can you explan how this is better than just saving player money using MySQL l/nvault directly by from player's steamid ?

I mean the point of bank system is for the limitations because people couldn't take their money everywhere but ingames is just different and you can go along expectations...

It's easy to create plugin for saving player money automatic and there are a lot of plugins are made for auto save money but the bank makes the players think the game are realistic, also will makes them cares and the players will compete for who has the most money, this will make the game more fun and will make the players playing well for earning more money.

bigdaddy424 · 02-05-2022 , 16:47 Re: Bank System Nvault/SQL Support

bank.php

PHP Code:


			
<?php 



$host = '';

$table = 'tblStore';

$username = '';

$password = ''; 

$database = ''; 

$mysqli = new mysqli(host, $username, $password, $database);



echo '<html>

    <body> <style>

        a { color: white; text-decoration: none;}

        .styled-table {

            border-collapse: collapse;

            margin: 25px 0;

            font-size: 0.9em;

            font-family: sans-serif;

            min-width: 400px;

            box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);

        }



        .styled-table thead tr {

            background-color: #009879;

            color: #ffffff;

            text-align: left;

        }



        .styled-table th,

        .styled-table td {

            padding: 12px 15px;

        }



        .styled-table tbody tr {

            border-bottom: 1px solid #dddddd;

        }



        .styled-table tbody tr:nth-of-type(even) {

            background-color: #f3f3f3;

        }



        .styled-table tbody tr:last-of-type {

            border-bottom: 2px solid #009879;

        }



        .styled-table tbody tr.active-row {

            font-weight: bold;

            color: #009879;

        }

        </style> <center>

        <table class="styled-table">

            <thead>

                <tr>

                    <th scope="col">#</th>

                    <th scope="col">SteamID</th>

                    <th scope="col">Cash</th>

                </tr>

            </thead>

        <tbody>'

;



$query = 'SELECT * FROM `'.$table.'` ORDER BY `Cash` DESC;';



if ($result = $mysqli->query($query)) {

    $id = 0;

    while ($data = $result->fetch_assoc()) {

        $id++;

        echo '<tr>

                <td>'.$id.'</td>

                <td>'.$data["SteamID"].'</td>

                <td>$'.$data["Cash"].'</td>

            </tr>'

        ;

    }

    echo '</tbody></table></center></body></html>';

    $result->free();

}



?>

Supremache · 02-05-2022 , 16:52 Re: Bank System Nvault/SQL Support

Quote:

Originally Posted by bigdaddy424

bank.php

PHP Code:


			
<?php 



$host = '';

$table = 'tblStore';

$username = '';

$password = ''; 

$database = ''; 

$mysqli = new mysqli(host, $username, $password, $database);



echo '<html>

    <body> <style>

        a { color: white; text-decoration: none;}

        .styled-table {

            border-collapse: collapse;

            margin: 25px 0;

            font-size: 0.9em;

            font-family: sans-serif;

            min-width: 400px;

            box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);

        }



        .styled-table thead tr {

            background-color: #009879;

            color: #ffffff;

            text-align: left;

        }



        .styled-table th,

        .styled-table td {

            padding: 12px 15px;

        }



        .styled-table tbody tr {

            border-bottom: 1px solid #dddddd;

        }



        .styled-table tbody tr:nth-of-type(even) {

            background-color: #f3f3f3;

        }



        .styled-table tbody tr:last-of-type {

            border-bottom: 2px solid #009879;

        }



        .styled-table tbody tr.active-row {

            font-weight: bold;

            color: #009879;

        }

        </style> <center>

        <table class="styled-table">

            <thead>

                <tr>

                    <th scope="col">#</th>

                    <th scope="col">SteamID</th>

                    <th scope="col">Cash</th>

                </tr>

            </thead>

        <tbody>'

;



$query = 'SELECT * FROM `'.$table.'` ORDER BY `Cash` DESC;';



if ($result = $mysqli->query($query)) {

    $id = 0;

    while ($data = $result->fetch_assoc()) {

        $id++;

        echo '<tr>

                <td>'.$id.'</td>

                <td>'.$data["SteamID"].'</td>

                <td>$'.$data["Cash"].'</td>

            </tr>'

        ;

    }

    echo '</tbody></table></center></body></html>';

    $result->free();

}



?>

I don't understand is there any issue in the plugin ?

Supremache · 02-08-2022 , 11:18 Re: Bank System Nvault/SQL Support

Code Optimized.
Natives has been edited to get_user_bank & set_user_bank.

Please can someone test sql and check if the table will create if not exists

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode