• 0
Sign in to follow this  
Followers 0
XYZ Loki

Unable to create player id

Question

5 answers to this question

  • 1

I'm still learning about all this but I would say it's a database issue, if you get the spawn as a bird. Double check the instructions on the changes to the database.  maybe somebody else will have a better answer for you soon.

Share this post


Link to post
Share on other sites
  • 0

Not sure if it's related but look at

  1. 23:06:20   Error setdir: Type Array, expected Number
  2. 23:06:20 File mpmissions\__cur_mp.Chernarus\initServer.sqf, line 1068
Edited by Razor77

Share this post


Link to post
Share on other sites
Advertisement
  • 0
4 hours ago, Razor77 said:

Did you have to change anything on the database with this mod?

Yeah we had too..

ALTER TABLE `container`
ADD COLUMN `is_trap` tinyint(1) NOT NULL DEFAULT '0';

CREATE TABLE `raid_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(32) NOT NULL,
  `thief` varchar(64) NOT NULL,
  `territory_id` int(11) NOT NULL,
  `position_x` double NOT NULL,
  `position_y` double NOT NULL,
  `position_z` double NOT NULL,
  `object` varchar(64) NOT NULL,
  `type` varchar(20) NOT NULL,
  `object_type` varchar(20) NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=latin1;

Find this:

[loadContainer]
SQL1_1 = SELECT id,class,account_uid,is_locked,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,territory_id,abandoned,deleted_at,money FROM container WHERE id = ?
Number Of Inputs = 1
SQL1_INPUTS = 1
OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16,17-STRING,18,19-STRING,20,21

And replace with this:

[loadContainer]
SQL1_1 = SELECT id,class,account_uid,is_locked,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,territory_id,abandoned,deleted_at,money,is_trap FROM container WHERE id = ?
Number Of Inputs = 1
SQL1_INPUTS = 1
OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16,17-STRING,18,19-STRING,20,21,22



Add this to bottom:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;Added for Xtended base raiding mechaniX by : oSoDirty
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[setSafeTraps]
SQL1_1= UPDATE container SET is_trap = ? WHERE id = ?
Number of Inputs = 2
SQL1_INPUTS = 1,2

[updateContainerLock]
SQL1_1 = UPDATE container SET is_locked = ? WHERE id = ?
Number of Inputs = 2
SQL1_INPUTS = 1,2

[saveLockpickUsage]
 SQL1_1 = INSERT INTO raid_history SET owner = ?, thief = ?, territory_id = ?, position_x = ?, position_y = ? , position_z = ?, object = ?, type = ? , object_type = ? ,datetime = NOW()
 Number Of Inputs = 9
 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9
 Return InsertID = true

 

Share this post


Link to post
Share on other sites
  • 0
2 hours ago, Razor77 said:

I'm still learning about all this but I would say it's a database issue, if you get the spawn as a bird. Double check the instructions on the changes to the database.  maybe somebody else will have a better answer for you soon.

i redid everything and well it worked im no longer a bird aha

1 person likes this

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.