07.08.2014, 04:17
Hey guys i did this little system that saves guns, and ammo when you disconnect, but my MySQL script got kind of funky:
This is to just save all the guns, and i think it is unecessary for three querys. Does anyone know of more efficient way? If so can you give me an example?
pawn Код:
format(MySQLQuery, sizeof(MySQLQuery), "UPDATE vartotojai SET Ginklas1=%i, Ginklas1a=%i, Ginklas2=%i, Ginklas2a=%i, Ginklas3=%i, Ginklas3a=%i, Ginklas4=%i, Ginklas4a=%i WHERE Vardas='%s'", WeaponInfo[playerid][Weapon1], WeaponInfo[playerid][Weapon1a], WeaponInfo[playerid][Weapon2], WeaponInfo[playerid][Weapon2a],WeaponInfo[playerid][Weapon3], WeaponInfo[playerid][Weapon3a], WeaponInfo[playerid][Weapon4], WeaponInfo[playerid][Weapon4a], pname);
mysql_query(MySQLQuery);
format(MySQLQuery, sizeof(MySQLQuery), "UPDATE vartotojai SET Ginklas5=%i, Ginklas5a=%i, Ginklas6=%i, Ginklas6a=%i, Ginklas7=%i, Ginklas7a=%i, Ginklas8=%i, Ginklas8a=%i WHERE Vardas='%s'", WeaponInfo[playerid][Weapon5], WeaponInfo[playerid][Weapon5a], WeaponInfo[playerid][Weapon6], WeaponInfo[playerid][Weapon6a],WeaponInfo[playerid][Weapon7], WeaponInfo[playerid][Weapon7a], WeaponInfo[playerid][Weapon8], WeaponInfo[playerid][Weapon8a], pname);
mysql_query(MySQLQuery);
format(MySQLQuery, sizeof(MySQLQuery), "UPDATE vartotojai SET Ginklas9=%i, Ginklas9a=%i, Ginklas10=%i, Ginklas10a=%i, Ginklas11=%i, Ginklas11a=%i, Ginklas12=%i, Ginklas12a=%i WHERE Vardas='%s'", WeaponInfo[playerid][Weapon9], WeaponInfo[playerid][Weapon9a], WeaponInfo[playerid][Weapon10], WeaponInfo[playerid][Weapon10a],WeaponInfo[playerid][Weapon11], WeaponInfo[playerid][Weapon11a], WeaponInfo[playerid][Weapon12], WeaponInfo[playerid][Weapon12a], pname);
mysql_query(MySQLQuery);