[Mccodes V2] Shop Reduction Prices

[Guest Sniko`]

After talking to karlos, i decided to give this for free as it was unsecure and around five lines of work :)

Okay basically this mod (or shall i say edit) allows the admin to reduce the price of all the items in a particular shop by 'X' amount.

 

NOTE: THERE IS AN ERROR (REDUCING THE DESIRED REDUCED PRICE FROM THE ORIGINAL PRICE)

 

Firstly open PHPMYADMIN and enter this SQL

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Now open staff_shops.php and find

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

After It Add

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Now Find (in staff_shops.php)

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

After Add

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Now Find (In staff_shops.php)

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

And Replace With

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Now open shops.php and find

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Now find (in shops.php)

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

And replace with

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

//Thanks to Karlos for getting this working

Now go to itembuy.php and find

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

And Replace With

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

//ERROR IS HERE

Please +1 me and the one who fixes the error

Do not post negative feedback please

thanks

Sniko

[Guest Sniko`]

Re: [Mccodes V2] Shop Reduction Prices

I am still working on this guys - i havent just left it

[Guest Sniko`]

Re: [Mccodes V2] Shop Reduction Prices

 

NOTE: Ive tried to do this in the newstock function in staff_shops.php - but doesnt work - im still trying guys

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

The error is

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Query was SELECT shopID FROM shops WHERE shopID=

Although i dont see the error as

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Is the same as deleting a shop and getting the ID of the shop except ss is sn

Im still figuering it out guys

[Karlos]

Re: [Mccodes V2] Shop Reduction Prices

Tryed $db->fetch_row(); ;)

[CrazyT]

Re: [Mccodes V2] Shop Reduction Prices

Try

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[Guest Sniko`]

Re: [Mccodes V2] Shop Reduction Prices

 

Try

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

if this is for itembuy.php it wont work because there is no sql to collect data from shops.

[CrazyT]

Re: [Mccodes V2] Shop Reduction Prices

 

Try

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

if this is for itembuy.php it wont work because there is no sql to collect data from shops.

Then make the SQL.

[MyGunWars]

Re: [Mccodes V2] Shop Reduction Prices

I'm Going To Add This To The New Player Shop Mod I Bought.

http://www.pbbgaming.com/mods/playershops.html

[Guest Sniko`]

Re: [Mccodes V2] Shop Reduction Prices

THANKS TO MAGICTALLGUY - this MOD now works

The new_stock_function();

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

THIS MOD NOW WORKS!!