How to add another value.

[Namindu]

Ok, so I been waiting to add another trader, but one that does not use Humanity, uses a VIP system. Briskly if a player played a certain amount of time, he can get in as a VIP. And it basically has four level, (Frist being 0).

 

Now, I made another column under 'player_data' in the data base called 'PlayerVIP' and set everyone to 0 by default. Then I edit a section of code to look like this:

        if (s_player_parts_crtl < 0) then {
 
 
 
            // get humanity
 
            _humanity = player getVariable ["humanity",0];
 
            _traderMenu = call compile format["menu_%1;",_traderType];
 
 
 
            //get VIP Level
 
            _viplevel = player getVariable ["PlayerVIP","0"];
 
            
 
            // diag_log ("TRADER = " + str(_traderMenu));
 
            
 
            _low_high = "low";
 
            _humanity_logic = false;
 
            if((_traderMenu select 2) == "friendly") then {
 
                _humanity_logic = (_humanity < -5000);
 
            };
 
            if((_traderMenu select 2) == "hostile") then {
 
                _low_high = "high";
 
                _humanity_logic = (_humanity > -5000);
 
            };
 
            if((_traderMenu select 2) == "hero") then {
 
                _humanity_logic = (_humanity < 5000);
 
            };
 
            if((_TraderMenu select 2) == "VIP0") then {
 
                _humanity_logic = (_viplevel = 0);
 
            };
 
            if((_TraderMenu select 2) == "VIP1") then {
 
                _humanity_logic = (_viplevel = 1);
 
            };
 
            if((_TraderMenu select 2) == "VIP2") then {
 
                _humanity_logic = (_viplevel = 2);
 
            };
 
            if((_TraderMenu select 2) == "VIP3") then {
 
                _humanity_logic = (_viplevel = 3);
 
            };
 
            if(_humanity_logic) then {
 
                _cancel = player addAction [format[localize "STR_EPOCH_ACTIONS_HUMANITY",_low_high], "\z\addons\dayz_code\actions\trade_cancel.sqf",["na"], 0, true, false, "",""];
 
                s_player_parts set [count s_player_parts,_cancel];
 
            } else {

From what I can tell, it’s not able to find/get the value for _VIPlevel from the database. How do I get it to find it?

[Joeyy]

You are using two variables of trademenu, _traderMenu & _TraderMenu.

Also you've got getVariable ["PlayerVIP","0"]; instead of getVariable ["PlayerVIP",0]; (notice the quotes!).

 

Not entirely sure this is the problem but you have some inconsitency there.

[Judge Bread]

_viplevel = player getVariable ["PlayerVIP","0"]; 

The above will work assuming you have already populated the player object with the PlayerVIP variable value containing the PlayerVIP value from the database. You will have to find and use the 500 or 505 custom query's to get the data from the database.

[Namindu]

Thanks, now i added that part, I currently placed my values for PlayerVIP, in 'player_data' in the database, Do i keep it there or move it?

[Judge Bread]

Its up to you. If you know how to use custom queries to get and set the value I can't see any issue with it being in that table except for hiccups in future upgrades. I personally would create a new table and use that if possible as you can just export/import the table and that way you are leaving the epoch tables in the format the devs intended. That way your custom table can hold any kind of information and you can simply record the players UID against the information you want to store just like the player_data and character_data tables.

 

P.S - If you have any documentation or any links on how to use custom queries, I would love to know how to do it as well and would be greatly appreciated.

[Namindu]

Thanks alot, i personnaly dont have any resources on custom queries.

[Namindu]

Just found this: http://dayzepoch.com/wiki/index.php?title=Custom_SQL_Calls

[Namindu]

Ok, i did all the fixeds posted, But i still cant seem to get it to work. When i do that. It just dose not let the Selfaction script to not work.

[Judge Bread]

If self_actions is broken then there is probably a syntax or logic error somewhere. First, do it in steps rather than 1 giant leap armstrong :P

 

This would be my work flow -

 

1) Get/Set the database values.

2) Then attach it to the player and test retrieving it.

3) Make the required changes to the trader file.

 

Always use isNil ("MY_VARIABLE") to test if it gets it as well as diag_log to spit out the values to the rpt file.