1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
error mysql
nbx2000
Big Clucker
***
Posts: 107
Threads: 50
Joined: Dec 2016
Reputation: 0
#1

03.06.2018, 03:57
error 075: input line too long (after substitutions) TARJET ERROR !!!!!!!!!ERROR HERE

Код:
public OnGameModeInit() {
  mysql_log(LOG_ERROR | LOG_WARNING);
  mysql = mysql_connect("127.0.0.1", "root", "casa", "");
  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), FEX INT(10), SAM 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 mrlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS fexlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS samlog(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, "", "");
  !!!!!!!!!ERROR HERE !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), FEX INT(10), SAM 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");
Find
Reply
HoNEYKISS
Big Clucker
**
Posts: 45
Threads: 5
Joined: Aug 2017
Reputation: 0
#2

03.06.2018, 04:25
You gotta create some tables in your mysql database so the files can be saved
Find
Reply
nbx2000
Big Clucker
***
Posts: 107
Threads: 50
Joined: Dec 2016
Reputation: 0
#3

03.06.2018, 04:37
Quote:
Originally Posted by HoNEYKISS
Посмотреть сообщение
You gotta create some tables in your mysql database so the files can be saved
Код:
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS CLANS(MR INT(10), FEX INT(10), SAM INT(10) )");
  mysql_tquery(mysql, Query, "", "");
CORRECT?
Find
Reply
HoNEYKISS
Big Clucker
**
Posts: 45
Threads: 5
Joined: Aug 2017
Reputation: 0
#4

03.06.2018, 04:44
Quote:
Originally Posted by nbx2000
Посмотреть сообщение
Код:
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS CLANS(MR INT(10), FEX INT(10), SAM INT(10) )");
  mysql_tquery(mysql, Query, "", "");
CORRECT?
I mean on your mysql database you have to create some tables do you even have mysql?
Find
Reply
nbx2000
Big Clucker
***
Posts: 107
Threads: 50
Joined: Dec 2016
Reputation: 0
#5

03.06.2018, 04:56
( Последний раз редактировалось nbx2000; 03.06.2018 в 05:42. )
if you added the new new in below config

Код:
public OnGameModeInit() {
  mysql_log(LOG_ERROR | LOG_WARNING);
  mysql = mysql_connect("127.0.0.1", "root", "casa", "");
  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), FEX INT(10), SAM 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 mrlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS fexlog(Log VARCHAR(250) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS samlog(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), 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, "", "");
  NEW !format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS CLANS(MR INT(10), FEX INT(10), SAM 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");
old code !!!!!!!!!! it is
Код:
UpdateConfig()
{
    new Query[450],Cache:result = mysql_query(mysql, "SELECT * FROM config");
	if(!cache_num_rows()) {
	format(Query, sizeof(Query),"INSERT INTO `config`(`MaxPing`,`ReadPms`,`AntiAdv`,`ReadCmds`,`AdminOnlySkins`,`AdminSkin`,`AdminSkin2`,`VIP`,`AntiSpam`,`NoCaps`\
	,`Locked`,`SaveWeap`,`ConnectMessages`,`AdminCMDMessages`,`AutoLogin`,`Notification`,`MaxMuteWarnings`,`MaxAdminLevel`,`AccountSecurity`,`MR`,`FEX`,`SAM`) VALUES (1200,1,1,0,\
	0,217,214,3,1,0,0,1,1,1,0,0,4,8,0,5,5,5)");
    mysql_tquery(mysql, Query, "", "");
    }
    if(cache_num_rows())
	{
		ServerInfo[MaxPing] = cache_get_field_content_int(0, "MaxPing");
		ServerInfo[ReadPMs] = cache_get_field_content_int(0, "ReadPms");
		ServerInfo[AntiAdv] = cache_get_field_content_int(0, "AntiAdv");
		ServerInfo[ReadCmds] = cache_get_field_content_int(0, "ReadCmds");
		ServerInfo[AdminOnlySkins] = cache_get_field_content_int(0, "AdminOnlySkins");
		ServerInfo[AdminSkin] = cache_get_field_content_int(0, "AdminSkin");
		ServerInfo[AdminSkin2] = cache_get_field_content_int(0, "AdminSkin2");
		ServerInfo[AntiSpam] = cache_get_field_content_int(0, "AntiSpam");
		ServerInfo[NoCaps] = cache_get_field_content_int(0, "NoCaps");
		ServerInfo[Locked] = cache_get_field_content_int(0, "Locked");
		ServerInfo[GiveWeap] = cache_get_field_content_int(0, "SaveWeap");
		ServerInfo[ConnectMessages] = cache_get_field_content_int(0, "ConnectMessages");
		ServerInfo[AdminCmdMsg] = cache_get_field_content_int(0, "AdminCMDMessages");
		ServerInfo[AutoLogin] = cache_get_field_content_int(0, "AutoLogin");
		ServerInfo[Notification] = cache_get_field_content_int(0, "Notification");
		ServerInfo[MaxMuteWarnings] = cache_get_field_content_int(0, "MaxMuteWarnings");
		ServerInfo[MaxAdminLevel] = cache_get_field_content_int(0, "MaxAdminLevel");
		ServerInfo[MaxVIPLevel] = cache_get_field_content_int(0, "VIP");
		ServerInfo[AccountSecurity] = cache_get_field_content_int(0, "AccountSecurity");
		ServerInfo[MaxMRLevel] = cache_get_field_content_int(0, "MR");
		ServerInfo[MaxFEXLevel] = cache_get_field_content_int(0, "FEX");
		ServerInfo[MaxSAMLevel] = cache_get_field_content_int(0, "SAM");
		print("\n -configuration Settings Loaded");
	}
	cache_delete(result);
}
new code is correct bro ?
Код:
UpdateConfig()
{
    new Query[450],Cache:result = mysql_query(mysql, "SELECT * FROM config");
	if(!cache_num_rows()) {
	format(Query, sizeof(Query),"INSERT INTO `config`(`MaxPing`,`ReadPms`,`AntiAdv`,`ReadCmds`,`AdminOnlySkins`,`AdminSkin`,`AdminSkin2`,`VIP`,`AntiSpam`,`NoCaps`\
	,`Locked`,`SaveWeap`,`ConnectMessages`,`AdminCMDMessages`,`AutoLogin`,`Notification`,`MaxMuteWarnings`,`MaxAdminLevel`,`AccountSecurity`,`MR`,`FEX`,`SAM`) VALUES (1200,1,1,0,\
	0,217,214,3,1,0,0,1,1,1,0,0,4,8,0)");
    mysql_tquery(mysql, Query, "", "");
    format(Query, sizeof(Query),"INSERT INTO `clans`(`MR`,`FEX`,`SAM`) VALUES (5,5,5)");
    mysql_tquery(mysql, Query, "", "");
	}
    if(cache_num_rows())
	{
		ServerInfo[MaxPing] = cache_get_field_content_int(0, "MaxPing");
		ServerInfo[ReadPMs] = cache_get_field_content_int(0, "ReadPms");
		ServerInfo[AntiAdv] = cache_get_field_content_int(0, "AntiAdv");
		ServerInfo[ReadCmds] = cache_get_field_content_int(0, "ReadCmds");
		ServerInfo[AdminOnlySkins] = cache_get_field_content_int(0, "AdminOnlySkins");
		ServerInfo[AdminSkin] = cache_get_field_content_int(0, "AdminSkin");
		ServerInfo[AdminSkin2] = cache_get_field_content_int(0, "AdminSkin2");
		ServerInfo[AntiSpam] = cache_get_field_content_int(0, "AntiSpam");
		ServerInfo[NoCaps] = cache_get_field_content_int(0, "NoCaps");
		ServerInfo[Locked] = cache_get_field_content_int(0, "Locked");
		ServerInfo[GiveWeap] = cache_get_field_content_int(0, "SaveWeap");
		ServerInfo[ConnectMessages] = cache_get_field_content_int(0, "ConnectMessages");
		ServerInfo[AdminCmdMsg] = cache_get_field_content_int(0, "AdminCMDMessages");
		ServerInfo[AutoLogin] = cache_get_field_content_int(0, "AutoLogin");
		ServerInfo[Notification] = cache_get_field_content_int(0, "Notification");
		ServerInfo[MaxMuteWarnings] = cache_get_field_content_int(0, "MaxMuteWarnings");
		ServerInfo[MaxAdminLevel] = cache_get_field_content_int(0, "MaxAdminLevel");
		ServerInfo[MaxVIPLevel] = cache_get_field_content_int(0, "VIP");
		ServerInfo[AccountSecurity] = cache_get_field_content_int(0, "AccountSecurity");
		ServerInfo[MaxMRLevel] = cache_get_field_content_int(0, "MR");
		ServerInfo[MaxFEXLevel] = cache_get_field_content_int(0, "FEX");
		ServerInfo[MaxSAMLevel] = cache_get_field_content_int(0, "SAM");
		print("\n -configuration Settings Loaded");
	}
	cache_delete(result);
}
Find
Reply
GTLS
High-roller
*****
Posts: 1,071
Threads: 24
Joined: Aug 2014
Reputation: 0
#6

03.06.2018, 06:09
If line is longer, press Enter after he end of the line. Dont let it scroll and you'll be good to go.
Find
Reply
nbx2000
Big Clucker
***
Posts: 107
Threads: 50
Joined: Dec 2016
Reputation: 0
#7

03.06.2018, 20:35
Quote:
Originally Posted by GTLS
Посмотреть сообщение
If line is longer, press Enter after he end of the line. Dont let it scroll and you'll be good to go.
example
Find
Reply
GTLS
High-roller
*****
Posts: 1,071
Threads: 24
Joined: Aug 2014
Reputation: 0
#8

04.06.2018, 05:19
Quote:
Originally Posted by nbx2000
Посмотреть сообщение
example
PHP код:
 format(Query, sizeof(Query),"INSERT INTO `config`(`MaxPing`,`ReadPms`,`AntiAdv`,`ReadCmds`,`AdminOnlySkins`,`AdminSkin`,`AdminSkin2`,`VIP`,`AntiSpam`,`NoCaps`\
    ,`Locked`,`SaveWeap`,`ConnectMessages`,`AdminCMDMessages`,`AutoLogin`,`Notification`,`MaxMuteWarnings`,`MaxAdminLevel`,`AccountSecurity`,`MR`,`FEX`,`SAM`) VALUES (1200,1,1,0,\ 
This line, could be made like:

PHP код:
format(Query, sizeof(Query),"INSERT INTO `config`(`MaxPing`,`ReadPms`,`AntiAdv`,`ReadCmds`,`AdminOnlySkins`,`AdminSkin`,`AdminSkin2`,`VIP`,
`AntiSpam`,`NoCaps`\
    ,`Locked`,`SaveWeap`,`ConnectMessages`,`AdminCMDMessages`,`AutoLogin`,
`Notification`,`MaxMuteWarnings`,`MaxAdminLevel`,`AccountSecurity`,`MR`,`FEX`,`SAM`) 
VALUES (1200,1,1,0,\ 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help