Write to database
Closed this issue · 1 comments
extreme4all commented
A report must be written into the stgReports table
extreme4all commented
-- playerdata.stgReports definition
CREATE TABLE `stgReports` (
`ID` bigint NOT NULL AUTO_INCREMENT,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`reportedID` int NOT NULL,
`reportingID` int NOT NULL,
`region_id` int NOT NULL,
`x_coord` int NOT NULL,
`y_coord` int NOT NULL,
`z_coord` int NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`manual_detect` tinyint(1) DEFAULT NULL,
`on_members_world` int DEFAULT NULL,
`on_pvp_world` tinyint DEFAULT NULL,
`world_number` int DEFAULT NULL,
`equip_head_id` int DEFAULT NULL,
`equip_amulet_id` int DEFAULT NULL,
`equip_torso_id` int DEFAULT NULL,
`equip_legs_id` int DEFAULT NULL,
`equip_boots_id` int DEFAULT NULL,
`equip_cape_id` int DEFAULT NULL,
`equip_hands_id` int DEFAULT NULL,
`equip_weapon_id` int DEFAULT NULL,
`equip_shield_id` int DEFAULT NULL,
`equip_ge_value` bigint DEFAULT NULL,
PRIMARY KEY (`ID`)
);