[Release] Market System for Low Versions

[dota-sdso]

But don`t see the seller acc here... only my acc

1. Seller/Buyer account name doesn't go to this table but into your market table, once the item is added/sold
2. If you are "buying" your own item you wont receive anything of course
3. This is your credit table content and it's not related to the market at all. The market only use this information to check/withdraw/add credits to buyer seller, and nothing more than this (if use credits at all)
4. Once the item is sold to someone else the resources should be taken/added automatically from the related table and accounts (keep in mind if buyer/seller name doesn't exist in the resource table you wont receive anything if you don't have a check and additional inserting query)

I haven't check this market code, I'm just saying what generally can cause the problems

 

[prmuonline]

Someone has the Query ?

https://imgur.com/QZoiH9B

I have the same Problem Somebody habemmve querys?

 

[dota-sdso]

Missing table WebShop, as far as I understand it should contain items database

 

[MrLemon]

But don`t see the seller acc here... only my acc

Add this code in your register page:

$do_reg_insert = mssql_query("insert into MEMB_CREDITS (memb___id,credits) VALUES ('".$user_name."','0')");

 

[DemonuMu]

I have the same Problem Somebody habemmve querys?

USE [MuOnline] GO CREATE TABLE [dbo].[MarketPlace]( [market_id] [int] IDENTITY(1,1) NOT NULL, [cat_id] [tinyint] NOT NULL, [item_id] [tinyint] NOT NULL, [item] [varchar](32) NOT NULL, [serial] [varchar](10) NOT NULL, [price] [int] NOT NULL, [added_on] [int] NOT NULL, [expires_on] [int] NOT NULL, [seller] [varchar](10) NOT NULL, [X] [tinyint] NOT NULL, [Y] [tinyint] NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[MarketPlace] ADD CONSTRAINT [DF_MarketPlace_X] DEFAULT ((1)) FOR [X] GO ALTER TABLE [dbo].[MarketPlace] ADD CONSTRAINT [DF_MarketPlace_Y] DEFAULT ((1)) FOR [Y] GO

 

[hA7SH9dks]

When i click sell item it writes me "You sold Excellent Kundun Staff for 10 credits."!
But i no see any items in the market to be "for sale". (so the items dont go for sale in the market) someone can say me why ?
edit: i make a misstake with the query of the sql server tables i fix it and gotta say Very Good Release!

 

[DemonuMu]

several players are complaining about a strange problem,after 7 days the item does not come back to the vault,it disappears completely

 

[DemonuMu]

do not use this market has big problems,if an item is not sold in 7 days, it normally goes back to the vault, disappears and you lose that item, the second problem has an open door where it allows a hacker to add as many credits as he wants,something from the market allows him to obtain many credits for free

after I deleted the market from the website no more hack credits

Maybe bro DarkMaster can solve this problem

MarketBuyers[21_07_2024]

Date: 07:42:57 | Buyer: motroi1 | Seller: MOTROI1 | Item: 20001200000000000000
Date: 07:43:16 | Buyer: MOTROI1 | Seller: motroi1 | Item: 20001200000000000000
Date: 07:43:46 | Buyer: MOTROI1 | Seller: motroi1 | Item: 20001200000000000000
Date: 07:46:06 | Buyer: MOTROI1 | Seller: dawid14669 | Item: 3C4C6F0003D067860000
Date: 07:46:51 | Buyer: motroi1 | Seller: MOTROI1 | Item: 20001200000000000000
Date: 07:46:56 | Buyer: motroi1 | Seller: MOTROI1 | Item: 3C4C6F0003D075860000
Date: 07:47:41 | Buyer: MOTROI1 | Seller: motroi1 | Item: 20001200000000000000
Date: 07:47:44 | Buyer: MOTROI1 | Seller: motroi1 | Item: 3C4C6F0003D084860000
Date: 07:48:16 | Buyer: motroi1 | Seller: MOTROI1 | Item: 20001200000000000000
Date: 07:48:19 | Buyer: motroi1 | Seller: MOTROI1 | Item: 3C4C6F0003D08A860000
Date: 07:54:34 | Buyer: MOTROI1 | Seller: motroi1 | Item: 200012000000000070EF
Date: 07:54:39 | Buyer: MOTROI1 | Seller: motroi1 | Item: 845F010003D0E9FF00D0
Date: 07:54:43 | Buyer: MOTROI1 | Seller: motroi1 | Item: AB5F010003D0EA7F0200
Date: 07:54:48 | Buyer: MOTROI1 | Seller: motroi1 | Item: CDDF010003D0EC7F60F9
Date: 07:54:53 | Buyer: MOTROI1 | Seller: motroi1 | Item: 865F010003D0EFFF0000
Date: 07:55:49 | Buyer: motroi1 | Seller: MOTROI1 | Item: 200012000000000070EF
Date: 07:55:55 | Buyer: motroi1 | Seller: MOTROI1 | Item: 845F010003D0FFFF00D0
Date: 07:55:59 | Buyer: motroi1 | Seller: MOTROI1 | Item: AB5F010003D1017F0200
Date: 07:56:06 | Buyer: motroi1 | Seller: MOTROI1 | Item: CDDF010003D1027F60F9
Date: 09:47:57 | Buyer: edgar | Seller: EDGAR | Item: E2042B0003D6B8141432
Date: 09:48:01 | Buyer: edgar | Seller: EDGAR | Item: 0981370003D6B9141804
Date: 09:48:04 | Buyer: edgar | Seller: EDGAR | Item: 0980370003D6BA020000
Date: 09:48:07 | Buyer: edgar | Seller: EDGAR | Item: 4382410003D6BB20A029
Date: 09:48:10 | Buyer: edgar | Seller: EDGAR | Item: AA076A0000000041725F
Date: 09:48:13 | Buyer: edgar | Seller: EDGAR | Item: 8882250003D6C02160BF
Date: 09:49:03 | Buyer: EDGAR | Seller: edgar | Item: E2042B0003D6C7141432
Date: 09:49:08 | Buyer: EDGAR | Seller: edgar | Item: 0981370003D6CA141804
Date: 09:49:11 | Buyer: EDGAR | Seller: edgar | Item: 0980370003D6CB020000
Date: 09:49:15 | Buyer: EDGAR | Seller: edgar | Item: 4382410003D6CC20A029​

 

[MeMoS]

Possible reasons for the issues:

Issue: after 7 days the item does not come back to the vault
Possible reason: the check for online status maybe blocking the return of the item
Possible reason 2: depending on the php version the calculation for empty space maybe broken because if this is the same calculation from savoy it always had issues with overwriting items when they are missing in the database or calculating wrong items from hex because of server files or custom items

I would personally recommend not using anything from DTWeb 0.1 it's about 10 years old and it most likely has a lot of bugs and so many holes it resembles swiss cheese

Also the reason this is never gonna work on newer php versions (without adding some sort of wrapper) is that mssql_*() functions have been removed for many years now, the solution is to update the whole source code to use sqlsrv_*(), not sure if this is still an option, or PDO
Years ago I had a version that was running on php 5.6 and later php 7.0, also had a wrapper for mssql_* but I have lost them and they were not complete or, in case of the wrapper, had some weird issues

 

[DemonuMu]

Possible reasons for the issues:

Issue: after 7 days the item does not come back to the vault
Possible reason: the check for online status maybe blocking the return of the item
Possible reason 2: depending on the php version the calculation for empty space maybe broken because if this is the same calculation from savoy it always had issues with overwriting items when they are missing in the database or calculating wrong items from hex because of server files or custom items

I would personally recommend not using anything from DTWeb 0.1 it's about 10 years old and it most likely has a lot of bugs and so many holes it resembles swiss cheese

Also the reason this is never gonna work on newer php versions (without adding some sort of wrapper) is that mssql_*() functions have been removed for many years now, the solution is to update the whole source code to use sqlsrv_*(), not sure if this is still an option, or PDO
Years ago I had a version that was running on php 5.6 and later php 7.0, also had a wrapper for mssql_* but I have lost them and they were not complete or, in case of the wrapper, had some weird issues

as you said, it has many holes, security 0, the items do not return after 7 days back to the vault, you lose them all, works hack credits, it was an interesting project for a 97d, it's a shame it wasn't finished,because the market system for 97d never had