mccode-v2 City Tax (Gang Addon)

[NonStopCoding]

I have decided to release this module for free can leaders can purchase a city and set a tax value 0-15% of there crime earnings

Gang leader will see who is owe them money from a log in the gang options and be able to claim it aswell once that's done it adds it to the gangs vault

SQL

You're unable to view this code.

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

 

Open explore.php and find

 

You're unable to view this code.

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

 

below this line add

 

You're unable to view this code.

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

 

open up yourgang.php and find

 

You're unable to view this code.

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

 

in the switch statements add 2 new cases

 

You're unable to view this code.

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

 

now find function gang_staff_idx() and replace it with this function or edit in if you need to

 

You're unable to view this code.

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

 

below that function add these two functions

 

You're unable to view this code.

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

 

Replace docrime.php with this if its not been edited

 

You're unable to view this code.

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

Edited June 11, 2016 by NonStopCoding

[boionfire81]

missing sql for citypayments

[NonStopCoding]

You're unable to view this code.

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

 

i dunno if that matches where it shows this info i just rebuilt it from the query

Edited June 13, 2016 by NonStopCoding

[boionfire81]

wrong fields?

A critical error has occurred, and page execution has stopped. Below are the details:

1054: Unknown column 'cityid' in 'where clause'

Action taken: Attempted to execute query: UPDATE `citypayments` SET `earnings` = `earnings` + 0.75 WHERE `userid` = 1

AND `cityid` = 1 AND `cowner` = 1

[NonStopCoding]

wrong fields?

A critical error has occurred, and page execution has stopped. Below are the details:

1054: Unknown column 'cityid' in 'where clause'

Action taken: Attempted to execute query: UPDATE `citypayments` SET `earnings` = `earnings` + 0.75 WHERE `userid` = 1

AND `cityid` = 1 AND `cowner` = 1

 

what page is showing these errors could help me faster but updated the location to cityid so fixes that

I have fully updated the table above give it a try ?

Edited June 11, 2016 by NonStopCoding

[NonStopCoding]

 

what page is showing these errors could help me faster but updated the location to cityid so fixes that

I have fully updated the table above give it a try ?

 

try this

 

You're unable to view this code.

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

 

use this docrime.php

http://pastie.org/10875551

Edited June 13, 2016 by NonStopCoding

[boionfire81]

ty found another error with it not recognizing the gangpresident, but fixed and it's good. Nice mod btw!

[NonStopCoding]

ty found another error with it not recognizing the gangpresident, but fixed and it's good. Nice mod btw!

 

ok thanks :P

[SaMz]

I have an issue with not deleting row from database after collection payment.

the query is $db->query("DELETE FROM `citypayments` WHERE `cowner` = {$gangdata['gangPRESIDENT']}");

help will be appreciated.

[Magictallguy]

From reading the code originally posted in 2015 and if I understand correctly (edit: I did not)

See this post for the fix

[SaMz]

43 minutes ago, Magictallguy said:

From reading the code originally posted in 2015 and if I understand correctly, alter that query to
 

$db->query('DELETE FROM citypayments WHERE cowner = '.$gangdata['gangID']);

You're unable to view this code.

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

 

I did try this earlier aswell but it deletes every row where the 'cowner' is gang ID but only collects selected row on gang function.

[Magictallguy]

1 minute ago, |SAMZ| said:

I did try this earlier aswell but it deletes every row where the 'cowner' is gang ID but only collects selected row on gang function.

Query updated

[SaMz]

19 minutes ago, Magictallguy said:

Query updated

Dont think that will work either.. it will just delete every tax owed in the location and only claim the selected row.. it needs to select userid from citypayments and delete that row 🤔

[Sim]

This is a cool mod, I'm glad I just seen this. It just gave me some great ideas.

[Magictallguy]

32 minutes ago, |SAMZ| said:

Dont think that will work either.. it will just delete every tax owed in the location and only claim the selected row.. it needs to select userid from citypayments and delete that row 🤔

Query updated

[SaMz]

30 minutes ago, Magictallguy said:

Query updated

Always miss the basics haha 

You're unable to view this code.

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

this should work!

There is now an issue with the docrime.php file where if the city is not owned It only displays the 

You're unable to view this code.

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

otherwise if the city is owned the page is displayed correctly with the queries submitting. 

This mod will be something if it can be completed.