help me error mysql
#1

.pwn(1860) : error 075: input line too long (after substitutions)
.pwn(1861) : error 037: invalid string (possibly non-terminated string)
.pwn(1861) : error 017: undefined symbol "CREATE"
.pwn(1861) : error 017: undefined symbol "TABLE"
.pwn(1861) : fatal error 107: too many error messages on one line

Код:
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS config(MaxPing INT(128), ReadPms INT(10), AntiAdv INT(10), ReadCmds INT(10), VIP INT(10), MR INT(10), SAM INT(10), FEX INT(10), GTA INT(10), PP INT(10), NFS INT(10), PL INT(10), AdminOnlySkins INT(10),\
  AdminSkin INT(10), AdminSkin2 INT(10), AntiSpam INT(10), NoCaps INT(10), Locked INT(10), SaveWeap INT(10), ConnectMessages INT(10),\
  AdminCMDMessages INT(10), AutoLogin INT(10), Notification INT(10), MaxMuteWarnings INT(10), MaxAdminLevel INT(10), AccountSecurity INT(10) )" );
  mysql_tquery(mysql, Query, "", "");
Reply
#2

You have to use the strcat function so that it works.
example of strcat:
Код:
	strcat(string, "{FF0000}        text1\n");
	strcat(string, "{FF0000}1. {FFFFFF}text2.\n");
	strcat(string, "{FF0000}2. {FFFFFF}text3.\n");
	strcat(string, "{FF0000}3. {FFFFFF}text4.\n");
	strcat(string, "		{FF0000}text5\n");
	strcat(string, "{ff0000}1.{ffffff} text6\n");
	strcat(string, "{ff0000}2.{ffffff} text7\n");
	strcat(string, "{ff0000}3.{ffffff} text8");
Ofcourse you need to define a string, and string size to it. As an example:
Код:
new string[256];
And you need to divide your query into 5-6 lines i guess with that much text you got in there.
Hope I helped.
Reply
#3

Quote:
Originally Posted by EgyptForLife
Посмотреть сообщение
You have to use the strcat function so that it works.
example of strcat:
Код:
	strcat(string, "{FF0000}        text1\n");
	strcat(string, "{FF0000}1. {FFFFFF}text2.\n");
	strcat(string, "{FF0000}2. {FFFFFF}text3.\n");
	strcat(string, "{FF0000}3. {FFFFFF}text4.\n");
	strcat(string, "		{FF0000}text5\n");
	strcat(string, "{ff0000}1.{ffffff} text6\n");
	strcat(string, "{ff0000}2.{ffffff} text7\n");
	strcat(string, "{ff0000}3.{ffffff} text8");
Ofcourse you need to define a string, and string size to it. As an example:
Код:
new string[256];
And you need to divide your query into 5-6 lines i guess with that much text you got in there.
Hope I helped.
this the complete code
How do I do it?
Код:
public OnGameModeInit() {
  mysql_log(LOG_ERROR | LOG_WARNING);
  mysql = mysql_connect("127.0.0.1", "", "", "");
  if(mysql_errno(mysql) != 0)
  {
   print("Could not connect to database!");
  }
  else
 {
  new Query[590],handle[1200];
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS accounts(Name VARCHAR(128), vehicleo1 INT(10), vehicleo2 INT(10), vehicleo3 INT(10), vehicleo4 INT(10) , vehicleo5 INT(10), vehicleo6 INT(10), vehicleo7 INT(10),\
  vehicleo8 INT(10), vehicle1 INT(128), vehicle2 INT(128), vehicle3 INT(128), vehicle4 INT(128), vehicle5 INT(128), vehicle6 INT(128), vehicle7 INT(128), vehicle8 INT(128), Level INT(10), Password VARCHAR(250), Score INT(128),");
  strcat(handle,Query);
  format(Query,sizeof Query," Money INT(128), hID INT(128), X VARCHAR(128), Y VARCHAR(128), Z VARCHAR(128), Interior INT(10), World INT(10), HOwned INT(10), bID INT(128), bOwned INT(10), Bank INT(128), LastOn VARCHAR(128), RDate VARCHAR(128), weed INT(128)\
  , TimeOnServer INT(128), Condoms INT(128), Skin INT(10), SkinID INT(128), Kills INT(128), Deaths INT(128), IP VARCHAR(128), noCash INT(10), TempDemote INT(10), TempDemoteDate INT(128), sboost INT(10), TempDemotel INT(10),");
  strcat(handle,Query);
  format(Query,sizeof Query," LastY INT(128), LastM INT(128), LastD INT(128), VIP INT(10) MR INT(10), SAM INT(10), FEX INT(10), GT INT(10), PP INT(10), NFS INT(10), PL INT(10) , PMBlock INT(10), SecurityQ VARCHAR(250), SecurityQA VARCHAR(250), bInterior INT(10) )");
  strcat(handle,Query);
  mysql_tquery(mysql, handle, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS banneds(name VARCHAR(128), ip VARCHAR(128), date VARCHAR(128), time VARCHAR(128)\
  , bannedby VARCHAR(128), banned INT(10), reason VARCHAR(128), bdate INT(128), tempban INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS weapons(Name VARCHAR(128), weap1 INT(10), weap2 INT(10), weap3 INT(10), weap4 INT(10)\
  , weap5 INT(10), weap6 INT(10), weap1ammo INT(128), weap2ammo INT(128), weap3ammo INT(128), weap4ammo INT(128), weap5ammo INT(128), weap6ammo INT(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS levellog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS KickLog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS cwlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS CarSpawns(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS advisorylog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS cmlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS TempLevelLog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS viplog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS resetlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS bannedips(ip VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS gpci(Name VARCHAR(128), gpci  VARCHAR(256), banned INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS bussines(bID INT(128), X VARCHAR(128), Y VARCHAR(128), Z VARCHAR(128), Name VARCHAR(128)\
  , Owner VARCHAR(128), Owned INT(10), Profit INT(128), Price INT(128), Sprice INT(128), Cash INT(128), Make INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS ignorelist(Name VARCHAR(128), pName VARCHAR(128), cIgnore INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS config(MaxPing INT(128), ReadPms INT(10), AntiAdv INT(10), ReadCmds INT(10), VIP INT(10), MR INT(10), SAM INT(10), FEX INT(10), GTA INT(10), PP INT(10), NFS INT(10), PL INT(10), AdminOnlySkins INT(10),\
  AdminSkin INT(10), AdminSkin2 INT(10), AntiSpam INT(10), NoCaps INT(10), Locked INT(10), SaveWeap INT(10), ConnectMessages INT(10),\
  AdminCMDMessages INT(10), AutoLogin INT(10), Notification INT(10), MaxMuteWarnings INT(10), MaxAdminLevel INT(10), AccountSecurity INT(10) )" );
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS carlog(ID INT(128), Name VARCHAR(128), Time VARCHAR(128), Date VARCHAR(128), Action VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS houselog(ID INT(128), Name VARCHAR(128), Time VARCHAR(128), Date VARCHAR(128), Action VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS transferlog(Name VARCHAR(128), pName VARCHAR(128), amount INT(128), Action VARCHAR(128), Date VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  mysql_format(mysql, Query, sizeof(Query),"SELECT * FROM `banneds` WHERE `banned` = 1 OR `tempban` = 1");
  mysql_tquery(mysql, Query, "TotalBans", "");
  mysql_format(mysql, Query, sizeof(Query),"SELECT * FROM `banneds` WHERE `tempban` = 1");
  mysql_tquery(mysql, Query, "TotalBans1", "");
  mysql_format(mysql, Query, sizeof(Query),"SELECT * FROM `bannedips`");
  mysql_tquery(mysql, Query, "Totalbanips", "");
  format(Query, sizeof(Query), "SELECT * FROM bussines");
  mysql_tquery(mysql, Query, "LoadBussines", "");
  mysql_format(mysql, Query,sizeof Query,"SELECT * FROM `accounts`");
  mysql_tquery(mysql, Query, "InactiveCheck", "");
  print("  Successfully connected on DB ");
  print("  Loading Cars & Houses ");
  format(Query, sizeof(Query), "SELECT * FROM vehicles");
  mysql_tquery(mysql, Query, "LoadVehicles", "");
  format(Query, sizeof(Query), "SELECT * FROM houses");
  mysql_tquery(mysql, Query, "LoadHouses", "");
  new Cache:result = mysql_query(mysql, "SELECT id FROM vehicles");
  for(new i = 0; i < cache_num_rows(); i++) {
	  VehicleID1[cache_get_row_int(i, 0, mysql)] = 1;
  }
  cache_delete(result);
  result = mysql_query(mysql, "SELECT bID FROM bussines");
  for(new i = 0; i < cache_num_rows(); i++) {
	  BizID1[cache_get_row_int(i, 0, mysql)] = 1;
  }
  cache_delete(result);
  result = mysql_query(mysql, "SELECT ID FROM houses");
  for(new i = 0; i < cache_num_rows(); i++) {
	  HouseID1[cache_get_row_int(i, 0, mysql)] = 1;
  }
  cache_delete(result);
  SetTimer("AddCarHouseBiz",4000,0);
  }
  SetTimer("AddObjects",4000,0);
  Database = db_open(_DB_);
  db_query(Database,
  "CREATE TABLE IF NOT EXISTS `gates` (`ID` NUMBERIC,`Placer` TEXT, `PlaceDate` TEXT, `X` TEXT, `Y` TEXT, `Z` TEXT, `A` TEXT, `Password` TEXT )");
  print("  Gate System Successfully Loaded");
Reply
#4

Quote:
Originally Posted by nbx2000
Посмотреть сообщение
this the complete code
How do I do it?
Код:
public OnGameModeInit() {
  mysql_log(LOG_ERROR | LOG_WARNING);
  mysql = mysql_connect("127.0.0.1", "", "", "");
  if(mysql_errno(mysql) != 0)
  {
   print("Could not connect to database!");
  }
  else
 {
  new Query[590],handle[1200];
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS accounts(Name VARCHAR(128), vehicleo1 INT(10), vehicleo2 INT(10), vehicleo3 INT(10), vehicleo4 INT(10) , vehicleo5 INT(10), vehicleo6 INT(10), vehicleo7 INT(10),\
  vehicleo8 INT(10), vehicle1 INT(128), vehicle2 INT(128), vehicle3 INT(128), vehicle4 INT(128), vehicle5 INT(128), vehicle6 INT(128), vehicle7 INT(128), vehicle8 INT(128), Level INT(10), Password VARCHAR(250), Score INT(128),");
  strcat(handle,Query);
  format(Query,sizeof Query," Money INT(128), hID INT(128), X VARCHAR(128), Y VARCHAR(128), Z VARCHAR(128), Interior INT(10), World INT(10), HOwned INT(10), bID INT(128), bOwned INT(10), Bank INT(128), LastOn VARCHAR(128), RDate VARCHAR(128), weed INT(128)\
  , TimeOnServer INT(128), Condoms INT(128), Skin INT(10), SkinID INT(128), Kills INT(128), Deaths INT(128), IP VARCHAR(128), noCash INT(10), TempDemote INT(10), TempDemoteDate INT(128), sboost INT(10), TempDemotel INT(10),");
  strcat(handle,Query);
  format(Query,sizeof Query," LastY INT(128), LastM INT(128), LastD INT(128), VIP INT(10) MR INT(10), SAM INT(10), FEX INT(10), GT INT(10), PP INT(10), NFS INT(10), PL INT(10) , PMBlock INT(10), SecurityQ VARCHAR(250), SecurityQA VARCHAR(250), bInterior INT(10) )");
  strcat(handle,Query);
  mysql_tquery(mysql, handle, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS banneds(name VARCHAR(128), ip VARCHAR(128), date VARCHAR(128), time VARCHAR(128)\
  , bannedby VARCHAR(128), banned INT(10), reason VARCHAR(128), bdate INT(128), tempban INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS weapons(Name VARCHAR(128), weap1 INT(10), weap2 INT(10), weap3 INT(10), weap4 INT(10)\
  , weap5 INT(10), weap6 INT(10), weap1ammo INT(128), weap2ammo INT(128), weap3ammo INT(128), weap4ammo INT(128), weap5ammo INT(128), weap6ammo INT(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS levellog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS KickLog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS cwlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS CarSpawns(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS advisorylog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS cmlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS TempLevelLog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS viplog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS resetlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS bannedips(ip VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS gpci(Name VARCHAR(128), gpci  VARCHAR(256), banned INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS bussines(bID INT(128), X VARCHAR(128), Y VARCHAR(128), Z VARCHAR(128), Name VARCHAR(128)\
  , Owner VARCHAR(128), Owned INT(10), Profit INT(128), Price INT(128), Sprice INT(128), Cash INT(128), Make INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS ignorelist(Name VARCHAR(128), pName VARCHAR(128), cIgnore INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS config(MaxPing INT(128), ReadPms INT(10), AntiAdv INT(10), ReadCmds INT(10), VIP INT(10), MR INT(10), SAM INT(10), FEX INT(10), GTA INT(10), PP INT(10), NFS INT(10), PL INT(10), AdminOnlySkins INT(10),\
  AdminSkin INT(10), AdminSkin2 INT(10), AntiSpam INT(10), NoCaps INT(10), Locked INT(10), SaveWeap INT(10), ConnectMessages INT(10),\
  AdminCMDMessages INT(10), AutoLogin INT(10), Notification INT(10), MaxMuteWarnings INT(10), MaxAdminLevel INT(10), AccountSecurity INT(10) )" );
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS carlog(ID INT(128), Name VARCHAR(128), Time VARCHAR(128), Date VARCHAR(128), Action VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS houselog(ID INT(128), Name VARCHAR(128), Time VARCHAR(128), Date VARCHAR(128), Action VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS transferlog(Name VARCHAR(128), pName VARCHAR(128), amount INT(128), Action VARCHAR(128), Date VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  mysql_format(mysql, Query, sizeof(Query),"SELECT * FROM `banneds` WHERE `banned` = 1 OR `tempban` = 1");
  mysql_tquery(mysql, Query, "TotalBans", "");
  mysql_format(mysql, Query, sizeof(Query),"SELECT * FROM `banneds` WHERE `tempban` = 1");
  mysql_tquery(mysql, Query, "TotalBans1", "");
  mysql_format(mysql, Query, sizeof(Query),"SELECT * FROM `bannedips`");
  mysql_tquery(mysql, Query, "Totalbanips", "");
  format(Query, sizeof(Query), "SELECT * FROM bussines");
  mysql_tquery(mysql, Query, "LoadBussines", "");
  mysql_format(mysql, Query,sizeof Query,"SELECT * FROM `accounts`");
  mysql_tquery(mysql, Query, "InactiveCheck", "");
  print("  Successfully connected on DB ");
  print("  Loading Cars & Houses ");
  format(Query, sizeof(Query), "SELECT * FROM vehicles");
  mysql_tquery(mysql, Query, "LoadVehicles", "");
  format(Query, sizeof(Query), "SELECT * FROM houses");
  mysql_tquery(mysql, Query, "LoadHouses", "");
  new Cache:result = mysql_query(mysql, "SELECT id FROM vehicles");
  for(new i = 0; i < cache_num_rows(); i++) {
	  VehicleID1[cache_get_row_int(i, 0, mysql)] = 1;
  }
  cache_delete(result);
  result = mysql_query(mysql, "SELECT bID FROM bussines");
  for(new i = 0; i < cache_num_rows(); i++) {
	  BizID1[cache_get_row_int(i, 0, mysql)] = 1;
  }
  cache_delete(result);
  result = mysql_query(mysql, "SELECT ID FROM houses");
  for(new i = 0; i < cache_num_rows(); i++) {
	  HouseID1[cache_get_row_int(i, 0, mysql)] = 1;
  }
  cache_delete(result);
  SetTimer("AddCarHouseBiz",4000,0);
  }
  SetTimer("AddObjects",4000,0);
  Database = db_open(_DB_);
  db_query(Database,
  "CREATE TABLE IF NOT EXISTS `gates` (`ID` NUMBERIC,`Placer` TEXT, `PlaceDate` TEXT, `X` TEXT, `Y` TEXT, `Z` TEXT, `A` TEXT, `Password` TEXT )");
  print("  Gate System Successfully Loaded");
The thing that you need to edit is this:
Код:
format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS config(MaxPing INT(128), ReadPms INT(10), AntiAdv INT(10), ReadCmds INT(10), VIP INT(10), MR INT(10), SAM INT(10), FEX INT(10), GTA INT(10), PP INT(10), NFS INT(10), PL INT(10), AdminOnlySkins INT(10),\
  AdminSkin INT(10), AdminSkin2 INT(10), AntiSpam INT(10), NoCaps INT(10), Locked INT(10), SaveWeap INT(10), ConnectMessages INT(10),\
  AdminCMDMessages INT(10), AutoLogin INT(10), Notification INT(10), MaxMuteWarnings INT(10), MaxAdminLevel INT(10), AccountSecurity INT(10) )" );
try to write it like this:
PHP код:
strcat(Query"CREATE TABLE IF NOT EXISTS");
strcat(Query" config(MaxPing INT(128), ReadPms INT(10), AntiAdv INT(10), ");
strcat(Query" ReadCmds INT(10), VIP INT(10), MR INT(10), SAM INT(10), ");
strcat(Query" FEX INT(10), GTA INT(10), PP INT(10), NFS INT(10), PL INT(10), AdminOnlySkins INT(10), ");
strcat(Query"AdminSkin INT(10), AdminSkin2 INT(10), AntiSpam INT(10), ");
strcat(Query"NoCaps INT(10), Locked INT(10), SaveWeap INT(10), ConnectMessages INT(10), ");
strcat(Query"AdminCMDMessages INT(10), AutoLogin INT(10), Notification INT(10), ");
strcat(Query"MaxMuteWarnings INT(10), MaxAdminLevel INT(10), AccountSecurity INT(10) )");
mysql_tquery(mysqlQuery""""); 
Should work fine I guess, don't forget to +rep if I helped!
Reply
#5

Quote:
Originally Posted by EgyptForLife
Посмотреть сообщение
The thing that you need to edit is this:
Код:
format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS config(MaxPing INT(128), ReadPms INT(10), AntiAdv INT(10), ReadCmds INT(10), VIP INT(10), MR INT(10), SAM INT(10), FEX INT(10), GTA INT(10), PP INT(10), NFS INT(10), PL INT(10), AdminOnlySkins INT(10),\
  AdminSkin INT(10), AdminSkin2 INT(10), AntiSpam INT(10), NoCaps INT(10), Locked INT(10), SaveWeap INT(10), ConnectMessages INT(10),\
  AdminCMDMessages INT(10), AutoLogin INT(10), Notification INT(10), MaxMuteWarnings INT(10), MaxAdminLevel INT(10), AccountSecurity INT(10) )" );
try to write it like this:
PHP код:
strcat(Query"CREATE TABLE IF NOT EXISTS");
strcat(Query" config(MaxPing INT(128), ReadPms INT(10), AntiAdv INT(10), ");
strcat(Query" ReadCmds INT(10), VIP INT(10), MR INT(10), SAM INT(10), ");
strcat(Query" FEX INT(10), GTA INT(10), PP INT(10), NFS INT(10), PL INT(10), AdminOnlySkins INT(10), ");
strcat(Query"AdminSkin INT(10), AdminSkin2 INT(10), AntiSpam INT(10), ");
strcat(Query"NoCaps INT(10), Locked INT(10), SaveWeap INT(10), ConnectMessages INT(10), ");
strcat(Query"AdminCMDMessages INT(10), AutoLogin INT(10), Notification INT(10), ");
strcat(Query"MaxMuteWarnings INT(10), MaxAdminLevel INT(10), AccountSecurity INT(10) )");
mysql_tquery(mysqlQuery""""); 
Should work fine I guess, don't forget to +rep if I helped!
error does not create the table in my phpmyadmin
Reply
#6

Why don't you just execute the code via SQL in Phpmyadmin?
Reply
#7

Quote:
Originally Posted by Verc
Посмотреть сообщение
Why don't you just execute the code via SQL in Phpmyadmin?
Because he's trying to make a system that does this, without the need for the user to go to the phpmyadmin and import it so they don't need to learn how to do that.
Reply
#8

Quote:
Originally Posted by nbx2000
Посмотреть сообщение
error does not create the table in my phpmyadmin
You need to check on the query.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)