Mysql Not Saving
#8

I got it to work... Sorry it was registry giving trouble so " not inserting" i go it to work... i inserted the main things, and then made some more queries to update the the files

pawn Код:
new hashpass[129], query[2500];
                WP_Hash(hashpass,sizeof(hashpass),inputtext);

                format(query, sizeof(query), "INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Skin`, `Cash`, `Bank`, `Gold` ,`Level`, `Respect`, `Admin`, `Helper`, `VIP`, `Tutorial`, `X`, `Y`, `Z`, `A`, `INT`, `VW`, `Health`, `Armour`) VALUES ('%s', '%s', '%s', 26, 5000, 10000, 1, 1, 0, 0, 0, 0,0, 0.0, 0.0, 0.0, 0.0, 0, 0, 100.0, 0.0)", RPNU(playerid), hashpass, PlayerInfo[playerid][pIP]);
                mysql_format(mysql, query, sizeof(query), query);
                mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);

                format(query, sizeof(query), "UPDATE `accounts` SET `Weapon1`=0, `Ammo1`=0, `Weapon2`=0, `Ammo2`=0, `Weapon3`=0, `Ammo3`=0, `Weapon4`=0, `Ammo4`=0, `Weapon5`=0, `Ammo5`=0, `Weapon6`=0, `Ammo6`=0, `Weapon7`=0, `Ammo7`=0, `Weapon8`=0, `Ammo8`=0, `Weapon9`=0, `Ammo9`=0, `Weapon10`=0, `Ammo10`=0, `Weapon11`=0, `Ammo11`  WHERE `ID`=%d", PlayerInfo[playerid][pID]);
                mysql_tquery(mysql, query, "", "");
                format(query, sizeof(query), "UPDATE `accounts` SET `Weapon12`=0, `Ammo12`=0, `Weapon13`=0, `Ammo13`=0, `Seconds`=0, `Minutes`=0, `Hours`=0, `Kills`=0, `Deaths`=0, `Banned`=%s, `BanReason`=%s WHERE `ID`=%d", PlayerInfo[playerid][pID], "NO", "none");
                mysql_tquery(mysql, query, "", "");
Reply


Messages In This Thread
Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:05
Re: Mysql Not Saving - by Eth - 21.09.2014, 01:20
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:29
Re: Mysql Not Saving - by Eth - 21.09.2014, 01:32
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:54
Re: Mysql Not Saving - by Eth - 21.09.2014, 04:50
Re: Mysql Not Saving - by Ox1gEN - 21.09.2014, 05:33
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 08:48

Forum Jump:


Users browsing this thread: 3 Guest(s)