[EgyptForLife]

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(mysql, Query, "", ""); 


Should work fine I guess, don't forget to +rep if I helped!