Takezone (ยึดโซน) แล้วไม่เซฟใน SQL ครับ

underthegames · โพสต์ 2016-5-5 15:00:13

คือปกติมันจะเซฟใน SQL เวลายึด zone ครับ ไฟล์ SQL คือ gangzones

ส่วนนี้คือค่าตัวแปลทั้งหมดครับ
// SaveZone
SaveZone(id)
{
new
      query[128];

format(query, sizeof(query), "UPDATE `gangzones` SET `zoneOwnerID` = '%d', `gZoneAttackDelay` = '%d' WHERE `zoneindex` = '%d'",
      GangZoneInfo[id][gZoneOwner],
      GangZoneInfo[id][gZoneAttackDelay],
      GangZoneInfo[id][gZoneSID]
);

return mysql_tquery(g_iHandle, query);
}

// Server_Load(

Server_Load();
mysql_tquery(g_iHandle, "SELECT * FROM `billboards`", "Billboard_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `houses`", "House_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `businesses`", "Business_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `dropped`", "Dropped_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `entrances`", "Entrance_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `cars` WHERE truncated = 0", "Car_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `jobs`", "Job_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `crates`", "Crate_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `plants`", "Plant_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `factions`", "Faction_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `arrestpoints`", "Arrest_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `gates`", "Gate_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `backpacks`", "Backpack_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `impoundlots`", "Impound_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `atm`", "ATM_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `garbage`", "Garbage_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `vendors`", "Vendor_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `gunracks`", "Rack_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `speedcameras`", "Speed_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `graffiti`", "Graffiti_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `detectors`", "Detector_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `gangzones`", "ZoneLoad", "");
mysql_tquery(g_iHandle, "SELECT * FROM `rp_vehicle_models`", "VehicleModel_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `rp_radio`", "Radio_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `spray`", "Spray_Load", "");
mysql_tquery(g_iHandle, "SELECT * FROM `wood`", "Wood_Load", "");

// public OnPlayerSpawn

GangZoneShowForPlayer(playerid, GangZoneWar[i], GetFactionColor(GangZoneInfo[i][gZoneOwner]));

CMD:editzone(playerid, params[])
{
if(PlayerData[playerid][pAdmin] >= 1) {
new
ans,
i;

if(sscanf(params, "i", ans))
{
SyntaxMsg(playerid, "/editzone [factionid]");
}
else
{
      if(ans == -1)
{
i = GetPlayerGZone(playerid);
GangZoneStopFlashForAll(GangZoneWar[i]);
GangZoneInfo[i][gZoneOwner] = -1;
GangZoneInfo[i][gZoneAttackDelay] = 0;
GangZoneShowForAll(GangZoneWar[i], GetFactionColor(-1));
SaveZone(i);
}
else
{
      if (FactionData[ans][factionType] != FACTION_GANG)
      {

i = GetPlayerGZone(playerid);
GangZoneStopFlashForAll(GangZoneWar[i]);
GangZoneInfo[i][gZoneOwner] = ans;
GangZoneInfo[i][gZoneAttackDelay] = 0;
GangZoneShowForAll(GangZoneWar[i], GetFactionColor(ans));
SaveZone(i);

}
else ErrorMsg(playerid, "äÍ´Õ¡ÅØèÁ/á¡ê§¤ì·ÕèÃÐºØäÁèãªèá¡ê§¤ì");
}
}
}
return 1;
}

พระเอกของเราคำสั่ง takezone

CMD:takezone(playerid, params[]) {//AddGang

new gang = PlayerData[playerid][pFaction];

if (PlayerData[playerid][pFactionRank] < FactionData[gang][factionRanks] - 1)
      return ErrorMsg(playerid, "¤Ø³µéÍ§ÁÕÂÈÍÂèÒ§µèÓ %d", FactionData[gang][factionRanks] - 1);

if(FactionData[gang][factionType] == FACTION_GANG && gang != -1)
{
new stillzone;

if((stillzone = GetPlayerGZone(playerid)) != -1)
{
new eminem = GangZoneInfo[stillzone][gZoneOwner];

if(gang != eminem)
{
      if(GangZoneInfo[stillzone][gZoneAttackDelay] <= 0)
      {
         if(eminem == -1)
         {
                 SendFactionMessage(gang, COLOR_RADIO, "RADIO: %s ä´éÂÖ´â«¹·ÕèäÁèÁÕà¨éÒ¢Í§", ReturnName(playerid, 0));

      GangZoneInfo[stillzone][gZoneOwner] = gang;
         GangZoneShowForAll(GangZoneWar[stillzone], GetFactionColor(gang));
               GangZoneInfo[stillzone][gZoneAttack] = -1;

         SaveZone(stillzone);
         }
         else
         {
if(!IsGangAttack(gang) && !IsGangAttack(eminem))
{
      new alleminem = GangOnline(eminem), allfriendly = GangOnlineInSameZone(gang, stillzone);

      /*foreach(new x: Player)
      {
         if(IsPlayerConnected(x) && PlayerData[x][pFaction] == gang && IsPlayerInGZone(x, stillzone))
         {
                              allfriendly++;
         }
         if(IsPlayerConnected(x) && PlayerData[x][pFaction] == eminem)
         {
                              alleminem++;
         }
      }*/

      if(allfriendly >= 3)
      {
if(alleminem >= 3)
{
                              SendClientMessageToAllEx(-1, "DEBUG: ½èÒÂ·éÒ (/takezone) ÁÕ¾ÃÃ¤¾Ç¡ %d ªÕÇÔµáÅÐÈÑµÃÙ¡ÇèÒ %d ªÕÇÔµ", allfriendly, alleminem);

GangZoneInfo[stillzone][gZoneAttack] = gang;
GangZoneInfo[stillzone][gZoneAttackTime] = 0;
GangZoneInfo[stillzone][gZoneAttackNon] = 0;
GangZoneFlashForAll(GangZoneWar[stillzone], GetFactionColor(gang));

                     SendFactionMessage(gang, COLOR_RADIO, "RADIO: à¢µâ«¹¢Í§ %s ¡ÓÅÑ§¶Ù¡ %s ÂÖ´¾×é¹·Õè", GetFactionName(eminem), GetFactionName(gang));
                        SendFactionMessage(eminem, COLOR_RADIO, "RADIO: %s ¾ÂÒÂÒÁ·Õè¨ÐÂÖ´¾×é¹·Õè¢Í§ %s", GetFactionName(gang), GetFactionName(eminem));
}
           else
      {
         SendClientMessage(playerid, COLOR_GREY, " µéÍ§ÁÕÈÑµÃÙ·Õèà»ç¹à¨éÒ¢Í§â«¹¹ÕéÍÍ¹äÅ¹ìÁÒ¡¡ÇèÒ 10 ¤¹¢Öé¹ä»");
      }
      }
      else
      {
         SendClientMessage(playerid, COLOR_GREY, " µéÍ§ÁÕÊÁÒªÔ¡ÍÂÙèã¹â«¹à´ÕÂÇ¡Ñº¤Ø³ÁÒ¡¡ÇèÒ 6 ¤¹¢Öé¹ä»");
      }
}
else
{
      SendClientMessage(playerid, COLOR_GREY, " ÁÕâ«¹Í×è¹¢Í§¤Ø³ËÃ×Í¢Í§ÈÑµÃÙ¡ÓÅÑ§¡ÃÐ¾ÃÔºÍÂÙè");
}
}
}
else
{
      SendClientMessage(playerid, COLOR_GREY, " â«¹¹ÕéÍÂÙèã¹ªèÇ§ Cooldown");
}
}
else
{
      SendClientMessage(playerid, COLOR_GREY, " â«¹¹Õéà»ç¹¢Í§¤Ø³ÍÂÙèáÅéÇ");
}
}
}
else
{
      SendClientMessage(playerid, COLOR_GREY, " ¤Ø³äÁèãªè¼Ùé¹Ó¡ÅØèÁ/á¡ê§¤ì");
}
return 1;
}

jamgames · โพสต์ 2016-5-5 15:17:46

ขอดู public ZoneLoad เพิ่มเติมครับ

underthegames · โพสต์ 2016-5-5 15:34:11

jamgames ตอบกลับเมื่อ 2016-5-5 15:17
ขอดู public ZoneLoad เพิ่มเติมครับ

forward ZoneLoad();
public ZoneLoad()
{
new
rows,
fields;

cache_get_data(rows, fields, g_iHandle);

for (new i = 0; i < rows; i ++)
{
new x = cache_get_field_content_int(i, "zoneindex");
GangZoneInfo[x][gZoneSID] = x;
GangZoneInfo[x][gZoneOwner] = cache_get_field_content_int(i, "zoneOwnerID");
GangZoneInfo[x][gZoneAttackDelay] = cache_get_field_content_int(i, "gZoneAttackDelay");
}
return 1;
}

ครับผมไม่แน่ใจเป็นเพราะ SQL ผมเน่าป่าว แต่อย่างอื่นเซฟปกติ ยกเว้นอันนี้

jamgames · โพสต์ 2016-5-5 16:20:20

ok จะบอกวิธีเช็คให้ ก่อนอื่น ให้ลอง takezone ก่อน ลองยึดโซนแล้วไปดูใน database ว่ามัน update ใหม

อย่างที่ 2 มาดู ZoneLoad

เราสามารถแสดงค่าที่มัน query ข้อมูลออกมาทาง cmd หรือหน้ารันเซิฟได้โดยใช้คำสั่ง

printf("ข้อความ");

เวลาจะเอาตัวแปรมาร่วมใช้งาน
new a =  GangZoneInfo[x][gZoneSID];
new b = GangZoneInfo[x][gZoneOwner];
printf("Zone id : %d    Zone Owner: %d", a,b);

โดยปกติ ตัวโค๊ตนั้น มันจะอ่านจากบนลงล่าง ทีนี้ ดูจากระบบ

forward ZoneLoad();
public ZoneLoad()
{
      new
         rows,
         fields;

      cache_get_data(rows, fields, g_iHandle);

      for (new i = 0; i < rows; i ++)
      {
            new x = cache_get_field_content_int(i, "zoneindex");
            GangZoneInfo[x][gZoneSID] = x;
            GangZoneInfo[x][gZoneOwner] = cache_get_field_content_int(i, "zoneOwnerID");
            GangZoneInfo[x][gZoneAttackDelay] = cache_get_field_content_int(i, "gZoneAttackDelay");
//เอามาแทรกไว้ตรงนี้ ในเมื่อ GangZoneInfo ถูกตั้งค่าตัวแปรไว้แล้วจากด้านบนก็เอามาใช้งานได้เลย
new a =  GangZoneInfo[x][gZoneSID];
new b = GangZoneInfo[x][gZoneOwner];
printf("Zone id : %d    Zone Owner: %d", a,b);
      }
      return 1;
}

Takezone (ยึดโซน) แล้วไม่เซฟใน SQL ครับ

เว็บมาสเตอร์แนะนำ /1