1. Sign up for news, events and more!

    You're currently visiting the official DarkRP Forums as a guest. Sign up now to participate in our community and we'll let you know when we have news.

Release GBay - A Garry's Mod marketplace!

Discussion in 'DarkRP Addon & Plugin Releases' started by XxLMM13xXgaming, Mar 7, 2017.

  1. XxLMM13xXgaming

    XxLMM13xXgaming New Member

    [​IMG]
    Welcome to GBay

    What is GBay?
    GBay is a Garry's Mod marketplace for DarkRP! GBay is PACKED with tons of features your players will love! Here's a list of some of the GBay features!

    Features
    1.) Nice ebay looking design
    2.) Custom materials with workshop addon
    3.) Nice loading screen featuring moat's fireworks!
    4.) Loading bar to check progress on loading
    5.) TMySQL4 saving
    6.) Sidebar to show many.. many different thinks
    7.) Minimize feature to close the menu but keep it open in background to re-open for later! (useful for config and many other things)
    8.) In-Game configuration
    9.) MailNPC to deliver items
    10.) Player rep system
    11.) Banning system
    12.) Admin system
    13.) Ads system
    14.) Tax system
    15.) Fee for posting
    16.) Notifications for players
    17.) Updates tab - always keep up to date!
    18.) Help tab to watch videos related to GBay help
    19.) Admin panel
    20.) Selling shipments
    21.) Selling services
    22.) Selling entities
    23.) Player dashboard
    24.) Quantity selection
    25.) Order page
    26.) Receipt
    27.) Edit items
    28.) Remove items

    Planned Features
    1.) Coupons
    2.) In-game issue reporting
    3.) New mysql stuff
    4.) Website

    Screenshots

    1.)Loading Screen
    [​IMG]

    2.) Main Menu
    [​IMG]

    3.) Main Menu + side bar opened with player dashboard
    [​IMG]

    4.) Main Menu + shipment entry
    [​IMG]

    5.) Order Page
    [​IMG]

    6.) Order Page + players dashboard
    [​IMG]

    7.) Order Page + receipt
    [​IMG]

    8.) Updates page
    [​IMG]

    9.) Help page
    [​IMG]

    What are services?
    Services are items that can be sold. Lets say for example you and some friends want to build bases for players on your fav server! Well now you can sell the service and advertise it people can buy it and you can then give them that service!

    What do i do if there is an error?
    Well you can discuss it here but i would rather you make a post here OR you can click the support button on the GBay website (link coming soon!)

    Ok sweet I want this addon! Now what?
    You can download this addon for free here (from github)

    Why is this gem free?!?
    Well i want to get my rep back up with some projects by releasing them open source! I have plans to make a "pro" version and sell that one but we will see!

    What do i need to run GBay?
    You will need the following
    1.) TMySQL4
    2.) Add the content pack to FastDL (you can find the pack here)
    3.) Watch the video below to install!

    Heres a quick video to help install!
    [video=youtube;z99FbZ6LjyY]

    Credits
    I would like to give credits to the following:
    1.) Beast - Helping me with some things alone the way and giving me support one dirty snapchat at a time :wideeye:
    2.) Moat - Open source fireworks GUI thingy for my loading screen and giving me perms to use it!
    3.) Sir Klutch - Help with testing (put up with me)

    NOTE: Description coppied from the Facepunch... please comment there if you can!
     
    Last edited: Mar 7, 2017
    platinum11, Pirat and konamikode like this.
  2. does it require mysql to function?
     
  3.  
  4. XxLMM13xXgaming

    XxLMM13xXgaming New Member

  5. XxLMM13xXgaming

    XxLMM13xXgaming New Member

    That is not true there are currently no exploits as of 1.0.5 there never really were extreme exploits.
     
  6. Who are you talking to? did they delete their comments or what?
     
  7. XxLMM13xXgaming

    XxLMM13xXgaming New Member

    Yes they said that this addon was easy exploitable and someone has exploited it or something like that
     
  8. ah ok, great addon by the way! really changes the ways gun dealers operate! you should consider selling it on scriptfodder!
     
  9. XxLMM13xXgaming

    XxLMM13xXgaming New Member

    Well i have plans possibly for a GBay 2 and may sell that but i want to give to the community!
     
  10. [MyDarkRP] WabelHD

    [MyDarkRP] WabelHD New Member

    How to install TMYSQL4?
     
  11. bump, everywhere I look is either really shady looking, or deprecated. I have a mysql server up, but I have NO idea how to install TMYSQL4
    HALP PLS
     
  12. Sir Klutch

    Sir Klutch Active Member

  13. benji2675

    benji2675 New Member

    How to install TMysql4 ?
     
  14. Sir Klutch

    Sir Klutch Active Member

  15. benji2675

    benji2675 New Member

    Thanks.
    I have a error.
    GBay MySQL Error: Table '*****.bans' doesn't exist L 06/15/2017 - 17:33:12: Lua Error: addons/gbay-1.1.5/lua/gbay/core/sv_core.lua:266: attempt to compare number with nil
    My info is verified and good.
     
  16. FusionLord

    FusionLord New Member

    Tables don't get created automatically, its a bug.

    Query this: Taken from gbay-1.1.5\lua\gbay\mysql\sv_mysql.lua:L3-132
    Code (Text):
    CREATE TABLE IF NOT EXISTS `ads` (
      `id` int(11) NOT NULL,
      `asid` varchar(17) NOT NULL,
      `type` varchar(255) NOT NULL,
      `iid` int(255) NOT NULL,
      `timetoexpire` int(255) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS `bans` (
      `id` int(11) NOT NULL,
      `bid` varchar(17) NOT NULL,
      `aid` varchar(17) NOT NULL,
      `time` int(255) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS `entities` (
      `id` int(11) NOT NULL,
      `sidmerchant` varchar(17) NOT NULL,
      `name` varchar(27) NOT NULL,
      `description` varchar(81) NOT NULL,
      `ent` varchar(255) NOT NULL,
      `price` int(255) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS `orders` (
      `id` int(11) NOT NULL,
      `sidmerchant` varchar(17) NOT NULL,
      `sidcustomer` varchar(17) NOT NULL,
      `type` varchar(255) NOT NULL,
      `weapon` varchar(255) NOT NULL,
      `weaponshipname` varchar(255) NOT NULL,
      `quantity` int(255) NOT NULL,
      `pricepaid` int(255) NOT NULL,
      `timestamp` int(255) NOT NULL,
      `completed` tinyint(1) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS `players` (
      `id` int(11) NOT NULL,
      `sid` varchar(17) NOT NULL,
      `rank` varchar(255) NOT NULL,
      `positiverep` int(255) NOT NULL,
      `neutralrep` int(255) NOT NULL,
      `negativerep` int(255) NOT NULL,
      `rating` varchar(255) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS `serverinfo` (
      `id` int(11) NOT NULL,
      `servername` varchar(15) NOT NULL,
      `ads` tinyint(1) NOT NULL,
      `services` tinyint(1) NOT NULL,
      `coupons` tinyint(1) NOT NULL,
      `feepost` int(255) NOT NULL,
      `maxprice` int(255) NOT NULL,
      `taxpercent` int(255) NOT NULL,
      `ttnoo` int(255) NOT NULL,
      `npcpos` varchar(255) NOT NULL,
      `npcang` varchar(255) NOT NULL,
      `npcmodel` varchar(255) NOT NULL,
      `ranks` varchar(255) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS `service` (
      `id` int(11) NOT NULL,
      `sidmerchant` varchar(17) NOT NULL,
      `name` varchar(20) NOT NULL,
      `description` varchar(81) NOT NULL,
      `price` int(255) NOT NULL,
      `buyers` varchar(255) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    CREATE TABLE IF NOT EXISTS `shipments` (
      `id` int(11) NOT NULL,
      `sidmerchant` varchar(17) NOT NULL,
      `name` varchar(27) NOT NULL,
      `description` varchar(81) NOT NULL,
      `wep` varchar(255) NOT NULL,
      `wepname` varchar(255) NOT NULL,
      `price` int(255) NOT NULL,
      `amount` int(255) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    ALTER TABLE `ads`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `bans`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `entities`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `orders`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `players`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `serverinfo`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `service`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `shipments`
      ADD PRIMARY KEY (`id`);

    ALTER TABLE `ads`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

    ALTER TABLE `bans`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

    ALTER TABLE `entities`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

    ALTER TABLE `orders`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

    ALTER TABLE `players`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

    ALTER TABLE `serverinfo`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

    ALTER TABLE `service`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

    ALTER TABLE `shipments`
      MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
     
    benji2675 likes this.
  17. benji2675

    benji2675 New Member

    How to create a table ?
    Im on PHPMyAdmin and table.
     
  18. FusionLord

    FusionLord New Member

    >>>3. Copy an paste the query from above.<<<
    [​IMG]
     
    Last edited: Jun 19, 2017
    benji2675 likes this.
  19. benji2675

    benji2675 New Member

    What i put on "SQL query on db" ?
    Thank's
     

Share This Page