Custom HiveExt.dll Release

[Soul]

SHORTCODE LEGEND:

These shortcodes are used in the repo titles, this indicates what the specific repo is for.

SC     >>> SingleCurrency

MC     >>> MultiChar

999    >>> 998/999 custom query supported

 

 

 

Custom HiveExt.dll and needed sqf files + sql query file available on:

 

 

Variant 1:DayZ-Epoch_SCHiveExt

- Single currency support

- Admin rights support

 

Variant 2: Dayz-Epoch_SCMCHiveExt

- Single currency support

- Admin rights support

- Multi Char mod support

 

Variant 3: DayZ_epoch_SCMC999HiveExt

- Single currency support

- Admin rights support

- Multi Char mod support

- 999 call support

Variant 4: DayZ_epoch_SC999HiveExt

- Single currency support

- Admin rights support

- 999 call support

 

All 4 variants have the following in common.

- New CHILD:298 >>> fetching player bank data, used while player joins server

- New CHILD:299 >>> updates player bank data, used when banking.

- New CHILD:104 >>> gets all adminuids + their adminlevel from the admin_data table. (can be used to restrict access to admin tools aswell as infiSTAR AH)

- Updated CHILD: 101 >>> checks if player exists in banking_data table and adds ifnot or updates playername if change detected

- Updated CHILD:102 >>> added selection of cashMoney field during retrieving survivor data on login.

- Updated CHILD:201 >>> added element to handle players cashmoney during updates to database.

 

What is in variant 1?

Everything stated above.

 

What is in variant 2?

Added support for AxeCop's multi char mod. and everything that you have in variant 1.

 

What is in variant 3?

Added support for 999 database calls so you can do custom database queries and

everything found in variant 1 & 2. Only use this variant is you really want to use 998/999

calls despite of the security risks attached to them.

 

What is in variant 4?

Added support for 999 database calls so you can do custom database queries and

everything found in variant 1. Only use this variant is you really want to use 998/999

calls despite of the security risks attached to them.

 

What else can i find on the github repo's?

SCDBQuery.sql:

Run this file on your database by dragging and dropping

It will add the field "CashMoney" to the character_data table and

it will create a new table called "banking_data" with fields "PlayerUID,"PlayerName","BankSaldo"

 

SCDBQuery_TransferGoldCoins.sql:

Only run this file if you had Zupa's first release installed and you have players that have goldcoins stored in the headshots field.

It will grab the value from "HeadShots" and put it in "CashMoney" for each row in your "character_data" table.

 

SCDBQuery_TransferGoldCoins2.sql:

Only run this file if you had Zupa's first release installed and you have players that have goldcoins stored in the "morality" field?

It will make db entries for all players in "player_data" in the "banking_data" table and add the corresponding values from the "morality" field

into the "banksaldo" field.

 

admin_data.sql:

This file will add a table called "admin_data", this can be used in combination with infiSTAR AH or any other tool you need restricted access

to. Intended for advanced users.

 

Server folder:

Contains all files that where modified from Zupa's v1.1 version

Take care and use a diffmerge tool like BeyondCompare, better safe then sorry.

 

Mission folder:

Contains all files that where modified from Zupa's v1.1 version.

Take care and use a  diffmerge tool like BeyondCompare, better safe then sorry.

 

BE filters:

This needs to be added in the first line with !="" values inside the publicvarible.txt if using BE filters.

Add it after the last !="" value. If using BE filters and you skip this step your players will get kicked for trying to send this PV to the server.

!="PVDZE_bank_Save"

Before installing:

Always make backups of everything!

 

Q&A:

Q: Will support for AxeCops multi char mod be added in this hive?

A: There is a 2nd version of the custom hiveext.dll that has support added for this mod.

 

Q: Will there be 999 call support in this custom hiveext.dll

A: There is a 3rd version of the custom hiveext.dll that has support for everything in version 1 & 2 and added support for 999 calls.

 

Q: Does this hive have support vanilla epoch base maintenance?

A: Yes it has the required funtionality as this hive was build of the last version released by VB[Awol]

 

Q: Why are there 4 different variants of this custom hive?

A: More flavours to choose from really. It enables you to either use or stay away from the unsafe 999 calls and still use this custom hive for single currency.

 

Got any more question? Leave a post and i'll add them to the main post's Q&A section.

Cheers Soul!

Edited August 29, 2014 by Soul

[Storm]

Did you fix the gold count below 1?

I'll put on my test server and see.

 

Also it would be good to change your sql file to select headshots and insert the data onto a new field for players that are still using the old system.

I'll do this and post my file here so that users wont have to have a reset with mad players.

 

Here try using this for a query

INSERT INTO character_data (CashMoney)
SELECT HeadshotsZ FROM character_data; 

Not sure if it will work, as I just made it like 5 minutes ago.

[Soul]

i will test your query on my test db wich is filled with data from the live server and see if it works

if it does i'll update the github repo.

 

and yes the below 1goldcoin issue is resolved, would not have released before fixing that one ;)

anyway there is a second repository with a brand new compiled hiveext.dll that has the added

support for Axecop's mutlichar mod if you would ever want to use that mod...

 

edit:

 

query didnt work as i expected however

a secondary query could be run after adding the field to transfer goldcoins from headshots to cashmoney field

can be run with this sql code

update character_data
set CashMoney = HeadshotsZ

and that query is tested and works flawless.

going to update the github with it.

will be a seperate file for people who are doing there first install as they dont need to run this query.

Its only intended to be used by people who had the first zupa release installe and have players that have

goldcoins stored inthe headshots field in the database.

[Storm]

 

i will test your query on my test db wich is filled with data from the live server and see if it works

if it does i'll update the github repo.

 

and yes the below 1goldcoin issue is resolved, would not have released before fixing that one  ;)

anyway there is a second repository with a brand new compiled hiveext.dll that has the added

support for Axecop's mutlichar mod if you would ever want to use that mod...

 

edit:

 

query didnt work as i expected however

a secondary query could be run after adding the field to transfer goldcoins from headshots to cashmoney field

can be run with this sql code

update character_data
set CashMoney = HeadshotsZ

and that query is tested and works flawless.

going to update the github with it.

will be a seperate file tho for people who are doing there first install as they dont need this query to be ran.

 

 Like I said I made it 5 minutes ago.

 

But your way works just as well.

The code that I did originally was to copy the data into a whole new table instead of the same.

I was going to use it to update the player's bank instead of converting all of the money onto the character's data.

 

Edit

The code works very good. 

I don't see any problems here.

[Soul]

yeah and copying over bankmoney from morality field to banksalod is a different story

i requires some inner joins and i'm not all that good with them...

[Storm]

yeah and copying over bankmoney from morality field to banksalod is a different story

i requires some inner joins and i'm not all that good with them...

Not exactly.

If the bank is made in there you can use this to update the columns

UPDATE banking_data
SET BankSaldo = ( SELECT PlayerMorality FROM player_data);

It will only update if there is already data in banking_data otherwise you would have to use inner join.

 

Also this needs to be added in the publicvarible.txt if using BE filters

!="PVDZE_bank_Save" !="PVAH_AdminReq"

[Soul]

UPDATE banking_data
SET BankSaldo = ( SELECT PlayerMorality FROM player_data);

 

but that wouldnt check if the player uid matches between the two tables would it?

[Storm]

but that wouldnt check if the player uid matches between the two tables would it?

It does the same concept as the one you posted.

I tested it and it works, but I only did that when I had one character, would have to test it on a bigger db.

I'll look into it a little more as I am not really fond of using inner joins.

[Glenn]

Your SQL file to run contains this:

-- ----------------------------
-- Table structure for `character_data`
-- ----------------------------

ALTER TABLE character_data ADD CashMoney int(11) NOT NULL DEFAULT 0 AFTER last_updated;

However... in my character_data table, I dont have a last_updated.

Is that needed for everything to work?

Currently it placed CashMoney at the end of the list of columns in my character_data table,

[CommanderRetra]

Does this support custom hive writes as well? eg. Hive 999

EDIT: Disregard that (https://github.com/EpochSC/SingleCurrencyBanking999)

EDIT 2: Can you release the project source?

[CMDR. Taco]

Just installed this and it works freaking great. I can now maintain plot poles and use Zupa's currency. Thanks!

[Mystic Joker]

my players banks isnt saving

i need help real fast please

[Storm]

Your SQL file to run contains this:

-- ------------------------------ Table structure for `character_data`-- ----------------------------ALTER TABLE character_data ADD CashMoney int(11) NOT NULL DEFAULT 0 AFTER last_updated;

However... in my character_data table, I dont have a last_updated.

Is that needed for everything to work?

Currently it placed CashMoney at the end of the list of columns in my character_data table,

Its not needed. Long as the column is there it will pull data from it.

[Storm]

my players banks isnt saving

i need help real fast please

Then you need to check your dlls.

If not then check rpt.

[Soul]

Does this support custom hive writes as well? eg. Hive 999

EDIT: Disregard that (https://github.com/EpochSC/SingleCurrencyBanking999)

EDIT 2: Can you release the project source?

 

no it does not.

if i put it in it'll be a seperate branch so you can chose between a safe hive or take the risk and have the 999 child aswell

but i'm open for request and depending of the size of the task and time i have i might put in requested stuff...

 

Thinking of checking out another system that would allow alot of custom querying but isnt as bad as 999 or useless as epoch's 500 childs

[Soul]

my players banks isnt saving

i need help real fast please

 

well thats alot of information provided from your side right there, euhm let me see.

Your problem is that ... euhm, i have no clue mate!

[Zupa]

This will become the offical 2.0 release btw.

 

Big credits to Soul for the dll's and call edit in the files!

[Soul]

It does the same concept as the one you posted.

I tested it and it works, but I only did that when I had one character, would have to test it on a bigger db.

I'll look into it a little more as I am not really fond of using inner joins.

 

yeah but the query for transfering cashmoney is a row per row operation and the edit happens within the row it is operating on.

however transfering data from one table into another table is a different piece of cake as its not the same row it is operating on.

i mean there's no way telling they match up, for all i  know you could end up giving player A player B's bankmoney.... so the only

option really is inner joins.

[Mystic Joker]

will how in hell would i have info nothing comes up in rpt not even thing send money to bank doesnt store it really i followed your steps by step

really no info dude

 

could it be the dlls from zupa thing the database.dll and all that???

[Soul]

did you include the bankinit.sqf in your server_functions.sqf?

did you replace the hiveext.dll with my version?

did you replace the files in the gold folder?

are you using be filters

 

did you install zupa's release before this one?

 

...

[Nyx Grimlock]

Soul, I have a real issue installing this. I have installed the original 999 and ive tried this fix and it still didn't work.. Im confused now haha any ideas? My hive is through phpmyadmin. 

[Storm]

Soul, I have a real issue installing this. I have installed the original 999 and ive tried this fix and it still didn't work.. Im confused now haha any ideas? My hive is through phpmyadmin. 

phpmyadmin doesn't affect it in anyway.

Take a look at your sql db and what issue are you having?

We are not psychics

[Nyx Grimlock]

I think its because i don't have anything telling the coins to be written to the db, I checked my bank zones file and there's no bank init. So presumably that's the problem. Also does this save the coins on a player on restart and the banked coins on death?

[insertcoins]

quick question, if I have zupa's system installed, would you recommend a full redo with clean files? Or are the dll files interhcangeble?

[Mystic Joker]

yes to all those soul