Search

open.mp forum

RegisterLogin

Discussion

General
Chat
Tech
Life
Art
Programming
open.mp
Development Updates
Questions and Suggestions
SA-MP
General Discussions
Videos and Screenshots
Support
Pawn Scripting
Tutorials
Releases
Plugins
Libraries
Filterscripts
Gamemodes
Maps
Advertisements
Other languages
Spanish/Espa?ol
Programaci?n
Discusi?n GTA SA Multijugador
Mods
Offtopic
Juegos
Portuguese/Portugu?s
Russian/???????
Italian/Italiano
Dutch/Nederlands
German/Deutsch
Romanian/Rom?na
Ex-Yu
Polish/Polski
Og?lne
Serwery
Skryptowanie
Filmiki i zdjecia
Lithuanian/Lietuvi?kas
French/Fran?ais
Hungarian/Magyar
Hindi/Urdu
Turkish
Other
Internal
Team
Hidden
Archived

Library

 Collections Links Members Roles

Input to long (mysql)

Im trying to create this table if it doesn't exist, just as a backup in the event i some how manage to lose the sql.

ID
d6ouivfilegovhg7bki0
author
stones's avatar

Stones

@stones


View profile
Copy link
  Report member
started
Dec 23, 2020
replies
0
participating
No

scroll to top

powered by storyden

Login
Discussion
Pawn Scripting
Input to long (mysql)
stones's avatar

Stones

@stones


View profile
Copy link
  Report member
• 5y
Pawn Scripting

Input to long (mysql)

pawn

Im trying to create this table if it doesn't exist, just as a backup in the event i some how manage to lose the sql.



I've tried using strcat i've tried looking at?https://www.burgershot.gg/showthread.php?tid=660 and i just get the same message



SetupCharacters()

{

? mysql_tquery(SQL_CONNECTION, "CREATE TABLE IF NOT EXISTS `characters` (? `ID` int(6) NOT NULL AUTO_INCREMENT,? `A_ID` int(6) NOT NULL,? `Name` varchar(34) NOT NULL,? `RegisterIP` varchar(16) NOT NULL,? `RegisterDate` int(12) NOT NULL,? `LatestIP` varchar(16) NOT NULL,? `Tutorial` int(2) NOT NULL,? `Level` int(5) NOT NULL,? `VIP` int(2) NOT NULL,? `Human` int(1) NOT NULL,? `Zombie` int(1) NOT NULL,? `Talent` int(1) NOT NULL,? `XP` int(6) NOT NULL,? `Cash` int(11) NOT NULL,? `Skin` int(3) NOT NULL,? `PosX` float NOT NULL,? `PosY` float NOT NULL,? `PosZ` float NOT NULL,? `VWorld` int(4) NOT NULL,? `Interior` int(2) NOT NULL,? `Age` int(3) NOT NULL,? `Gender` int(2) NOT NULL,? `Kicks` int(5) NOT NULL,? `Muted` int(2) NOT NULL,? `Faction` int(2) NOT NULL,? `Rank` int(2) NOT NULL,? `Health` float NOT NULL,? `Armour` float NOT NULL,? `hEntered` int(5) NOT NULL,? `bEntered` int(5) NOT NULL,? `Vehicles` int(3) NOT NULL,? `Bank` int(12) NOT NULL,? `ExemptIP` int(11) NOT NULL,? `TotalTimePlayed` int(12) NOT NULL,? `OnlinePeriod` int(12) NOT NULL,? `Payday` int(12) NOT NULL,? `LastOnline` int(12) NOT NULL,? `Cuffed` int(1) NOT NULL,? `Spawn` int(1) NOT NULL,? `Jail` int(4) NOT NULL,? `Radio` int(2) NOT NULL,? `RadioFreq` int(4) NOT NULL DEFAULT 27,? `Weapons` varchar(104) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',? `Uniform` int(4) NOT NULL,? `Screwdriver` int(2) NOT NULL,? PRIMARY KEY (`ID`),? UNIQUE KEY `Username` (`Name`),? UNIQUE KEY `ID` (`ID`))");

? return 1;

}









error 075: input line too long (after substitutions)

error 037: invalid string (possibly non-terminated string)

error 017: undefined symbol "CREATE"

error 017: undefined symbol "IF"

fatal error 107: too many error messages on one line
0 likes0 replies

    Please sign up or log in to reply