21.09.2014, 08:48
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, "", "");