Hallo,
alle Waffen des Spielers sollen in einer Datenbank gespeichert werden. Ich habe mir eine Schalldämpferpistole gegeben und '/save' eingegeben, allerdings wird in der Datenbank nun jede Slot-Spalte mit der Weapon-ID '23' gefüllt und jede Ammo-Spalte mit der Zahl '17' gefüllt, obwohl nur in der Spalte 'WSlot2' eine '23' eingetragen werden müsste.
Externer Inhalt
s7.directupload.net
Inhalte von externen Seiten werden ohne Ihre Zustimmung nicht automatisch geladen und angezeigt.
Lua
function savePos(source)
if getElementData(source, "LoggedIn") then
if not isPedInVehicle(source) then
setPedWeaponSlot(source, 0)
local slot0 = getPedWeapon(source)
setPedWeaponSlot(source, 1)
local slot1 = getPedWeapon(source)
setPedWeaponSlot(source, 2)
local slot2 = getPedWeapon(source)
local ammo2 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 3)
local slot3 = getPedWeapon(source)
local ammo3 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 4)
local slot4 = getPedWeapon(source)
local ammo4 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 5)
local slot5 = getPedWeapon(source)
local ammo5 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 6)
local slot6 = getPedWeapon(source)
local ammo6 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 7)
local slot7 = getPedWeapon(source)
local ammo7 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 8)
local slot8 = getPedWeapon(source)
local ammo8 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 9)
local slot9 = getPedWeapon(source)
local ammo9 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 10)
local slot10 = getPedWeapon(source)
local ammo10 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 11)
local slot11 = getPedWeapon(source)
local ammo11 = getPedAmmoInClip(source)
setPedWeaponSlot(source, 12)
local slot12 = getPedWeapon(source)
local result = mysql_query(sqlcon,"SELECT * FROM weapon_data WHERE WeaponOwner='"..getPlayerName(source).."';")
if result then
rows = mysql_num_rows(result)
if rows == 1 then
row = mysql_fetch_row(result)
end
mysql_free_result(result)
end
if rows == 1 then
local result = mysql_query(sqlcon, "UPDATE weapon_data SET WSlot0='"..slot0.."', WSlot1='"..slot1.."', WSlot2='"..slot2.."', WSlot3='"..slot3.."', WSlot4='"..slot4.."', WSlot5='"..slot5.."', WSlot6='"..slot6.."', WSlot7='"..slot7.."', WSlot8='"..slot8.."', WSlot9='"..slot9.."', WSlot10='"..slot10.."', WSlot11='"..slot11.."', WSlot12='"..slot12.."', WAmmo2='"..ammo2.."', WAmmo3='"..ammo3.."', WAmmo4='"..ammo4.."', WAmmo5='"..ammo5.."', WAmmo6='"..ammo6.."', WAmmo7='"..ammo7.."', WAmmo8='"..ammo8.."', WAmmo9='"..ammo9.."', WAmmo10='"..ammo10.."', WAmmo11='"..ammo11.."' WHERE WeaponOwner='"..getPlayerName(source).."';")
mysql_free_result(result)
else
local result = mysql_query(sqlcon, "INSERT INTO weapon_data SET WeaponOwner='"..getPlayerName(source).."', WSlot0='"..slot0.."', WSlot1='"..slot1.."', WSlot2='"..slot2.."', WSlot3='"..slot3.."', WSlot4='"..slot4.."', WSlot5='"..slot5.."', WSlot6='"..slot6.."', WSlot7='"..slot7.."', WSlot8='"..slot8.."', WSlot9='"..slot9.."', WSlot10='"..slot10.."', WSlot11='"..slot11.."', WSlot12='"..slot12.."', WAmmo2='"..ammo2.."', WAmmo3='"..ammo3.."', WAmmo4='"..ammo4.."', WAmmo5='"..ammo5.."', WAmmo6='"..ammo6.."', WAmmo7='"..ammo7.."', WAmmo8='"..ammo8.."', WAmmo9='"..ammo9.."', WAmmo10='"..ammo10.."', WAmmo11='"..ammo11.."';")
mysql_free_result(result)
end
end
end
end
addCommandHandler("save", savePos)VG