MYSQL Database problem 2
#3

Quote:
Originally Posted by Mencent
Посмотреть сообщение
Hello!

Maybe it is a mistake in your save-function. Can you share this function with us?

- Mencent :cool:
This?:
Код HTML:
//------------------------------------------------------------------
            //MySQL INSERT
            //------------------------------------------------------------------
			format(rQuery, 4096, "INSERT INTO `Accounts` (`ID`, `Name`, `Password`, `IP`, `E-Mail`, `LoggedIn`, `RegisterDate`, `LastOn`, `Level`, `VIP`, `Cash`, `Score`, `Coins`, `Credits`, \
											  `Headshots`, `Kills`, `Deaths`, `Hours`, `Minutes`, `Seconds`, `BestKillings`, `KillingSpree`, `FavSkin`, `UseSkin`, `House`, `Property`, \
											  `Description1`, `Description2`, `Description3`, `Positive`, `Negative`, `ClanID`, `ClanRank`, `ClanPoints`, `ClanKills`, `ClanDeaths`,");
			//------------------------------------------------------------------
			format(rQuery, 4096, "%s `Kicks`, `Bans`, `Jails`, `Warns`, `ClearChats`, `ReactionTest`, `MathTest`, `Mutes`, `Jailed`, `JailTime`, `Frozen`, `FreezeTime`, `Muted`, `MuteTime`, \
											  `RaceScore`, `StuntScore`, `DriftScore`, `GangID`, `GangRank`, `GangSkin`, `GangKills`, `GangDeaths`, `GangWarns`, `GangCaptures`, `GangPoints`, \
											  `Ignores`, `LottoNumber`, `C4`, `StatsNote`, `VIPTime`, `FreeVIP`, `TempVIP`, `RLSClan`, `RLSRank`, `AdmWarns`, `VIPWarns`, `KickW`)", rQuery);
			//------------------------------------------------------------------
			format(rQuery, 4096, "%s VALUES (0, '%s', '%s', '%s', 'changeme@etrion.ro', '1', '%02d/%02d/%02d', '%02d/%02d/%02d', \
											'0', '0', '25000', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '217', '1', '0', '0', \
											' ', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', \
											'0', '0', '0', '0', '0', '0', '0', '0', '0', '00:00', '0', '00:00', '0', '00:00', \
											'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', \
											'0/0/0/0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0')", rQuery, PlayerName(playerid), rPassword, GetPlayerIPEx(playerid), liDay, liMonth, liYear, liDay, liMonth, liYear);
			//------------------------------------------------------------------
			mysql_tquery(DB_Connect, rQuery, "OnAccountCreated", "i", playerid);
			//------------------------------------------------------------------
Reply


Messages In This Thread
MYSQL Database problem 2 - by darkowner - 15.06.2015, 19:07
AW: MYSQL Database problem 2 - by Mencent - 15.06.2015, 19:09
Re: AW: MYSQL Database problem 2 - by darkowner - 15.06.2015, 19:25
Re: MYSQL Database problem 2 - by Konstantinos - 15.06.2015, 19:29
Re: MYSQL Database problem 2 - by darkowner - 16.06.2015, 07:42
Re: MYSQL Database problem 2 - by mamorunl - 16.06.2015, 09:27
Re: MYSQL Database problem 2 - by darkowner - 16.06.2015, 10:39
Re: MYSQL Database problem 2 - by mamorunl - 16.06.2015, 12:29
Re: MYSQL Database problem 2 - by darkowner - 16.06.2015, 13:50
Re: AW: MYSQL Database problem 2 - by mamorunl - 17.06.2015, 07:23

Forum Jump:


Users browsing this thread: 2 Guest(s)