[IzadorO]

Код:

new
	      query[1028];
	      
		format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `accounts` (`Character` VARCHAR(24) NOT NULL, `Password` VARCHAR(129) NOT NULL, `Skin` INTEGER DEFAULT 29 NOT NULL, `pSpawn` INTEGER DEFAULT 0 NOT NULL, `pMoney` INTEGER DEFAULT 5000 NOT NULL, `pBank` INTEGER DEFAULT 0 NOT NULL, `pLevel` INTEGER DEFAULT 1 NOT NULL, `pHours` INTEGER DEFAULT 0 NOT NULL, `pExperience` INTEGER DEFAULT 0 NOT NULL, `pStaff` INTEGER DEFAULT 0 NOT NULL, `pMask` INTEGER DEFAULT 0 NOT NULL, `pIP` VARCHAR(16) NOT NULL");
		format(query, sizeof(query), "%s, `pSlot` INTEGER DEFAULT 0 NOT FULL, `pPhoneN` INTEGER DEFAULT 0 NOT FULL, `pFaction` INTEGER DEFAULT 0 NOT FULL, `pRank` INTEGER DEFAULT 0 NOT FULL, `pJob` INTEGER DEFAULT 0 NOT FULL, `pRadio` INTEGER DEFAULT 0 NOT FULL, `pStrength` FLOAT DEFAULT 1.0)", query);
		db_free_result(db_query(db_handle, query));
	    
		db_free_result(db_query(db_handle, "CREATE TABLE IF NOT EXISTS `blacklist` (`IP` VARCHAR(16) NOT NULL, `Username` VARCHAR(24) NOT NULL, `BannedBy` VARCHAR(24) NOT NULL, `Reason` VARCHAR(128) NOT NULL, `Date` VARCHAR(36) NOT NULL)"));

	    format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `businesses` (`Name` VARCHAR(32) NOT NULL, `Owner` VARCHAR(24) NOT NULL, `Message` VARCHAR(128) NOT NULL, `Type` INTEGER DEFAULT 0 NOT NULL, `ExteriorX` FLOAT DEFAULT 0.0, `ExteriorY` FLOAT DEFAULT 0.0, `ExteriorZ` FLOAT DEFAULT 0.0, `InteriorX` FLOAT DEFAULT 0.0, `InteriorY` FLOAT DEFAULT 0.0, `InteriorZ` FLOAT DEFAULT 0.0, `InteriorAngle` FLOAT DEFAULT 0.0, `ID` INTEGER DEFAULT 1 NOT NULL");
	    format(query, sizeof(query), "%s, `Interior` INTEGER DEFAULT 0, `Exterior` INTEGER DEFAULT 0, `World` INTEGER DEFAULT 0, `Price` INTEGER DEFAULT 0)", query);
        db_free_result(db_query(db_handle, query));
		print("Successfully created a connection to \"server.db\".");
		SetTimer("OneMinuteCallback", 60000, true);
		for(new i = 0; i < MAX_BUSINESSES; i++) SQL_BizLoad(i);

Every table under OnGameModeInit is created, except from `accounts`, which is stopping everything account related from saving, as there are no tables nor rows for it. I've skimmed through the query numerous times, and still fail to see what's wrong with it. Any thoughts?

[IzadorO]

Alright, so the tables are now all being created, but new accounts are not being sorted in to their appropriate tables.

Код:

new
	    query[512];
	    
	  format(query, sizeof(query), "INSERT INTO `char` (`Character`, `Password`, `pIP`) VALUES('%s', '%s', '%s')", username, password, ReturnIP(playerid));
	  db_query(db_handle, query);

Any issues with the code above?

Also, my sampdb .db file looks like this: (with notepad .txt)

Код:

SQLite format 3   @                                                                     -в   ы    ы                                                                                                                                                                                                                                                              ЃR‚stableblacklistblacklistCREATE TABLE `blacklist` (`IP` VARCHAR(16) NOT NULL, `Username` VARCHAR(24) NOT NULL, `BannedBy` VARCHAR(24) NOT NULL, `Reason` VARCHAR(128) NOT NULL, `Date` VARCHAR(36) NOT NULL)ѓ7†QtablecharcharCREATE TABLE `char` (`Character` VARCHAR(24) NOT NULL, `Password` VARCHAR(129) NOT NULL, `Skin` INTEGER DEFAULT 29 NOT NULL, `pSpawn` INTEGER DEFAULT 0 NOT NULL, `pMoney` INTEGER DEFAULT 5000 NOT NULL, `pBank` INTEGER DEFAULT 0 NOT NULL, `pLevel` INTEGER DEFAULT 1 NOT NULL, `pHours` INTEGER DEFAULT 0 NOT NULL, `pExperience` INTEGER DEFAULT 0 NOT NULL, `pStaff` INTEGER DEFAULT 0 NOT NULL, `pIP` VARCHAR(16) NOT    
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
   q q+m                                                                                                                                                                                                                                                                                                                                                                   ѓ7†QtablecharcharCREATE TABLE `char` (`Character` VARCHAR(24) NOT NULL, `Password` VARCHAR(129) NOT NULL, `Skin` INTEGER DEFAULT 29 NOT NULL, `pSpawn` INTEGER DEFAULT 0 NOT NULL, `pMoney` INTEGER DEFAULT 5000 NOT NULL, `pBank` INTEGER DEFAULT 0 NOT NULL, `pLevel` INTEGER DEFAULT 1 NOT NULL, `pHours` INTEGER DEFAULT 0 NOT NULL, `pExperience` INTEGER DEFAULT 0 NOT NULL, `pStaff` INTEGER DEFAULT 0 NOT NULL, `pIP` VARCHAR(16) NOT NULL)ЃR‚stableblacklistblacklistCREATE TABLE `blacklist` (`IP` VARCHAR(16) NOT NULL, `Username` VARCHAR(24) NOT NULL, `BannedBy` VARCHAR(24) NOT NULL, `Reason` VARCHAR(128) NOT NULL, `Date` VARCHAR(36) NOT NULL)
   У У                                                                                                                                                                                                                                                                                                                                                                                                                                                                         „*!!€tablebusinessesbusinessesCREATE TABLE `businesses` (`Name` VARCHAR(32) NOT NULL, `Owner` VARCHAR(24) NOT NULL, `Message` VARCHAR(128) NOT NULL, `Type` INTEGER DEFAULT 0 NOT NULL, `ExteriorX` FLOAT DEFAULT 0.0, `ExteriorY` FLOAT DEFAULT 0.0, `ExteriorZ` FLOAT DEFAULT 0.0, `InteriorX` FLOAT DEFAULT 0.0, `InteriorY` FLOAT DEFAULT 0.0, `InteriorZ` FLOAT DEFAULT 0.0, `InteriorAngle` FLOAT DEFAULT 0.0, `ID` INTEGER DEFAULT 1 NOT NULL, `Interior` INTEGER DEFAULT 0, `Exterior` INTEGER DEFAULT 0, `World` INTEGER DEFAULT 0, `Price` INTEGER DEFAULT 0)

EDIT: OK so, that is NOT the problem. It's magically started inserting again... although, the REAL problem, is the fact that the data for player accounts is not being stored.

Код:

format(query, sizeof(query), "UPDATE `char` SET `Skin` = %d, `pSpawn` = %d, `pMoney` = %d, `pBank` = %d, `pLevel` = %d, `pHours` = %d, `pExperience` = %d, `pStaff` = %d, `pMask` = %d, `pIP` = '%s' WHERE `Character` = '%s'",
      pData[playerid][pSkin],
      pData[playerid][pSpawn],
      pData[playerid][pMoney],
      pData[playerid][pBank],
      pData[playerid][pLevel],
      pData[playerid][pHours],
      pData[playerid][pExperience],
      pData[playerid][pStaff],
      pData[playerid][pMask],
      DB_Escape(pData[playerid][pIP]),
	  DB_Escape(ReturnName(playerid))
	  );

The above is the code for saving.