Raised This Month: $31 Target: $400
 7% 

Mysql


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Breyke
New Member
Join Date: Mar 2021
Location: Spain
Old 02-28-2022 , 04:57   Mysql
Reply With Quote #1

Hello, I recently decided to open a sh server, (a bit of nostalgia) but I have a problem, every time the map is changed or someone leaves and enters the server, they have to choose all the powers again. I use a mysql saving method, with those tables:

CREATE TABLE `sh_savexp` (
`SH_KEY` varchar(32) binary NOT NULL default '',
`PLAYER_NAME` varchar(32) binary NOT NULL default '',
`LAST_PLAY_DATE` timestamp(6) NOT NULL,
`XP` int(10) NOT NULL default '0',
`HUDHELP` tinyint(3) unsigned NOT NULL default '1',
`SKILL_COUNT` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`SH_KEY`)
) ENGINE=MyISAM COMMENT='SUPERHERO XP Saving Table';


CREATE TABLE `sh_saveskills` (
`SH_KEY` varchar(32) binary NOT NULL default '',
`SKILL_NUMBER` tinyint(3) unsigned NOT NULL default '0',
`HERO_NAME` varchar(25) NOT NULL default '',
PRIMARY KEY (`SH_KEY`,`SKILL_NUMBER`)
) ENGINE=MyISAM COMMENT='SUPERHERO Skill Saving Table';




-And these are the errors that appear in the console:

[superheromodmysql.amxx] DEBUG: Error Writing MySQL Skills for [BOT]V0id: [1064] 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to us' - 'INSERT INTO `sh_saveskills` VALUES ('[BOT]V0id','11','Xavier'), ('[BOT]V0id','12','Morpheus'), ('[BOT]V0id','13','US Marine'), ('[BOT]V0id','14L 02/12/2022 - 216:07: "[P0D]M0rbid

L 02/28/2022 - 109:03: [superheromodmysql.amxx] DEBUG: Error Making Tables: [1426] 'Too big precision 14 specified for column 'LAST_PLAY_DATE'. Maximum is 6.' - 'CREATE TABLE IF NOT EXISTS `sh_savexp` ( `SH_KEY` varchar(32) binary NOT NULL default '', `PLAYER_NAME` varchar(32) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, `XP` int(10) NOT NULL default '0'L 02/28/2022 - 109:03: "Breyke<213><STEAM_0:1:82881504><>" entered the game

I don't know if I'm missing something, I'm new to this, I hope you can help me, have a good day!
Breyke is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 15:24.


Powered by vBulletin®
Copyright ©2000 - 2023, vBulletin Solutions, Inc.
Theme made by Freecode