This simply searches by the generally used QBCore tables to reply frequent questions that many RP servers could have.

You may:

  1. Discover duplicate weapons throughout the servers
  2. You may listing prime rich individuals (all cash, and autos)
  3. You could find gadgets throughout the server and see who owns what, it’ll determine flats, stashes and homes and who owns what.
  4. You could find autos and after they have been final taken out.
  1. Configure a mysql config file, it’s harcoded within the scripts as /and many others/.db.cnf, you may change this to something. It ought to appear to be beneath:

    [client]
    consumer=USERNAMEHERE
    password=PASSWORDHERE
    database=DATABASENAME
    port=PORTHERE
    host=IPHERE

  2. Change the desk names to what your tables are referred to as. Mine are referred to as gamers, stashitems, trunkitems, gloveboxitems` and many others. You’ll must edit the scripts in case your DB schema is completely different.

  3. You could must edit yours to suit your server. For instance I filter out issues like police proof baggage, and many others.

  4. In the event you’re calculating wealth, you’ll want to provide a autos.txt which has the mannequin identify and the way a lot its value in your server. I’ve included ours.

  5. You could must edit your autos desk to incorporate final withdrawl. Each time somebody takes a automobile from a storage we document is so we will preserve observe of if persons are driving these costly imports, and we repo them in the event that they sit too lengthy.

Find Duplicate Items (weapon serial numbers)

./duplicate-serials.rb
Serial: 90ZWL3JN340GSmG (weapon_compactrifle) is duplicated
    - Character: CKR43620 (Alejandro González )
    - Locations:
            - CKR43620 laguna pl2 stash
            - CKR43620 nowhere rd1 stash

Find items across the various places people can have them

./find-item.rb tunerlaptop
Person                         CID             Location       
Matt Kayden                    CCO33278        Player Inventory
Nova Gillon                    CNI32230        Player Inventory
Dominic Taylor                 FJX80892        Player Inventory
Ben Luchiano                   GTC47981        Player Inventory
TJ Rhodes                      IPQ16693        Player Inventory
Chamo Muerez                   OLD42979        Player Inventory
Skyla Rose                     PLC97196        Player Inventory
Anthony Polman                 QVI37300        Player Inventory
The Batman                     RBU82997        Player Inventory
Nico Northbeach                TGT80371        Player Inventory
Tate Sullivan                  VBJ05904        Player Inventory
David  Bale                    VBW93859        Player Inventory
Ben Lewis                      YCW97175        Player Inventory
Jamie Jackson                  KWL34317        alta st2       
TJ Rhodes                      IPQ16693        apartment2471  
Ben Lewis                      YCW97175        apartment31567 

Top 20 wealthy people (takes into account car costs)

./top_ten_wealth.rb 
Nova Gillon              $33,266,013
David  Bale              $11,633,155
Ben Lewis                $8,307,490
Ben Luchiano             $5,565,436
Matt Kayden              $5,145,782
Anthony Polman           $4,760,627
Nico Northbeach          $4,229,903
Donny Kebap              $3,717,491
Dominic Taylor           $3,565,971
Yang Shen                $3,343,175
Blood Bane               $3,315,084
Saoirse OTool            $3,277,094
George Ooaaa             $3,186,931
Tyler Reed               $2,870,417
Victor Wainwright        $2,810,497
Cole Hannan              $2,805,970
Chase Getaway            $2,773,179
Noah Bosch               $2,747,420
Talula Cole              $2,628,276
Rosa Klein               $2,621,455
Annie Apollo             $2,457,958

Find Vehicles

[email protected]:~/scripts$ ./find-vehicle.rb models
Person                         CID             Plate           Last Used (days)
Flo Bloom                      ABP31468        44OAB894        today          
Nova Gillon                    CNI32230        PAYURTAX        today          
Booka Kipps                    QCS86404        MOUNTAIN        1              
Sparky Taco                    NRW54072        TESLAAAA        1              
Darryl Umbridge                KYV85534        83JDX824        11             
Victor Wainwright              UQR90885        DFSW6285        13             
Aran Silver                    PXF77186        CHRU1239        41             
Scar Lawd                      WZW32122        QHCA4657        112



Looking for paid scripts? Click here