Sprijin quest Tiki.

catalin9325 · March 11, 2016

Problema intalnita (descriere): Nu mi se salveaza pTiki , pTikix in baza de date .
Ero(area / rile) / warning-(ul / urile): Dau relog , si pot sa il iau pe acelasi din nou.
Liniile de cod / sursa / script-ul(obligatoriu): MYsql - Tiki
Imagini / Video (optional):-
Ati incercat sa rezolvati singur?: Da , dar tot nu se salveaza , va multumesc !

Tud0r. #Codat #Imparat · March 11, 2016

Refaci sistemul.Faci pt. fiecare tiki cate un tabel in baza de date la conturi.

catalin9325 · March 11, 2016

Am facut asta , dar nu se salveaza in mysql.

BuNiCu-RP · March 11, 2016

Urmeaza sa faci asa:

Cand intra in tiki #2 - sa ii arate mesajul iar mysql sa salveze:

mysql_format(conn, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name`='%e' AND TIKI='%d' ", pTikix);

mysql_query(conn, str);

Sper ca ai inteles !

catalin9325 · March 11, 2016

Acum 13 minute, [PAWN]Stark.7 a spus:
Urmeaza sa faci asa:

Cand intra in tiki #2 - sa ii arate mesajul iar mysql sa salveze:
mysql_format(conn, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name`='%e' AND TIKI='%d' ", pTikix);

mysql_query(conn, str);
Sper ca ai inteles !

am facut asa , tot nu merge..

BuNiCu-RP · March 11, 2016

Uite un mic exemplu, nu sunt sigur ca este si functionabil.

new pickup_tiki[25];
#define pTikix1 0
#define pTikix2 1
#define pTikix3 2
#define pTikix4 3
#define pTikix5 4
#define pTikix6 5
#define pTikix7 6
#define pTikix8 7
#define pTikix9 8
#define pTikix10 9
#define pTikix11 10
#define pTikix12 11
// [...]

public OnGameModeInit()
{
    pickup_tiki[0] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #1
		pickup_tiki[1] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #2
		pickup_tiki[2] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #3
		pickup_tiki[3] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #4
		pickup_tiki[4] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #5
		pickup_tiki[5] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #6
    return 1;
}
 
forward UpdateTiki(playerid, type);
public UpdateTiki(playerid, type) {
	switch(type)
	{
		case pTikix1: // Tiki #1 
		{
			new str[128];
			mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", playerid, pTikix1);
			mysql_query(cHandle, str);
		}
		
		case pTikix2: // Tiki #2 
		{
			new str[128];
			mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", playerid, pTikix1);
			mysql_query(cHandle, str);
		}
	}
}
 
public OnPlayerPickUpPickup(playerid, pickupid)
{
    if(pickupid == pickup_tiki[0])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (1/25).");
			UpdateTiki(playerid, pTikix1);
    }
    else if(pickupid == pickup_tiki[1])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (2/25).");
			UpdateTiki(playerid, pTikix2);
    }
    else if(pickupid == pickup_tiki[2])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (3/25).");
			UpdateTiki(playerid, pTikix3);
    }
    else if(pickupid == pickup_tiki[3])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (4/25).");
			UpdateTiki(playerid, pTikix4);
    }
    return 1;
}

catalin9325 · March 11, 2016

Acum 1 minut, [PAWN]Stark.7 a spus:

Uite un mic exemplu, nu sunt sigur ca este si functionabil.


new pickup_tiki[25];
#define pTikix1 0
#define pTikix2 1
#define pTikix3 2
#define pTikix4 3
#define pTikix5 4
#define pTikix6 5
#define pTikix7 6
#define pTikix8 7
#define pTikix9 8
#define pTikix10 9
#define pTikix11 10
#define pTikix12 11
// [...]

public OnGameModeInit()
{
    pickup_tiki[0] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #1
		pickup_tiki[1] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #2
		pickup_tiki[2] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #3
		pickup_tiki[3] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #4
		pickup_tiki[4] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #5
		pickup_tiki[5] = CreatePickup(1274, 2, 0.0, 0.0, 9.0); // Tiki #6
    return 1;
}
 
forward UpdateTiki(playerid, type);
public UpdateTiki(playerid, type) {
	switch(type)
	{
		case pTikix1: // Tiki #1 
		{
			new str[128];
			mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", playerid, pTikix1);
			mysql_query(cHandle, str);
		}
		
		case pTikix2: // Tiki #2 
		{
			new str[128];
			mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", playerid, pTikix1);
			mysql_query(cHandle, str);
		}
	}
}
 
public OnPlayerPickUpPickup(playerid, pickupid)
{
    if(pickupid == pickup_tiki[0])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (1/25).");
			UpdateTiki(playerid, pTikix1);
    }
    else if(pickupid == pickup_tiki[1])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (2/25).");
			UpdateTiki(playerid, pTikix2);
    }
    else if(pickupid == pickup_tiki[2])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (3/25).");
			UpdateTiki(playerid, pTikix3);
    }
    else if(pickupid == pickup_tiki[3])
    {
      SendClientMessage(playerid, -1, "[QUEST]: Ai gasit o statuit Tiki (4/25).");
			UpdateTiki(playerid, pTikix4);
    }
    return 1;
}

fix la fel am si eu

Ce sa fac sa se salveze in sql ? ...

BuNiCu-RP · March 11, 2016

Posteaza aici cum ai definita conexiunea cu baza de date, nu ma intreseaza parola sau alte detalii !

Trebuie sa ai ceva de genul:

cHandle = mysql_connect("host", "user", "db", "pass");, sql = mysql_connect("host", "user", "db", "pass");

catalin9325 · March 11, 2016

Imi merg toate , acolo cand sa adaug in MYSQL , Tiki1 , nu stiu ce sa pun pe acolo la alea libere.

BuNiCu-RP · March 11, 2016

Pai cum adica? Ai un tabel in baza de date, unde sa se salveze si de unde sa se incarce?

catalin9325 · March 11, 2016

Trebuie sa creez in mysql acolo tabele , de exp : Inima , Inimi , ce trebuie sa pun,null , 0 etc...nu trebuie si acolo configurat?

BuNiCu-RP · March 11, 2016

Uite ceva de genul trebuie sa ai tu un tabel:

CREATE TABLE `tabel_tau`.`tiki`
(`PlayerName` VARCHAR(32) NOT NULL,
`Tiki1` INT(11) NULL DEFAULT '-1',
`Tiki2` INT(11) NOT NULL DEFAULT '-1',
`Tiki3` INT(11) NOT NULL DEFAULT '-1',
`Tiki4` INT(11) NOT NULL DEFAULT '-1',
`Tiki5` INT(11) NOT NULL DEFAULT '-1',
`Tiki6` INT(11) NOT NULL DEFAULT '-1',
`Tiki7` INT(11) NOT NULL DEFAULT '-1',
`Tiki8` INT(11) NOT NULL DEFAULT '-1',
`Tiki9` INT(11) NOT NULL DEFAULT '-1',
`Tiki10` INT(11) NOT NULL DEFAULT '-1'
) ENGINE = InnoDB;

catalin9325 · March 11, 2016

Da-mi o poza acolo cum completezi tu te rog..

catalin9325 · March 12, 2016

Cineva va rog ? Help..

Mister · March 12, 2016

Tu ai asa

case pTikix1: // Tiki #1 
		{
			new str[128];
			mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", playerid, pTikix1);
			mysql_query(cHandle, str);
		}

trebuie sa ai ma gandesc in loc de playerid sa ai numele

adica

case pTikix1: // Tiki #1 
		{
			new str[128],named[4];
			GetPlayerName(playerid,named,sizeof(named));
			mysql_format(cHandle, str, sizeof(str), "UPDATE * FROM `tiki_quest` WHERE `Name` = '%e' AND `TikiID` = '%d'", named, pTikix1);
			mysql_query(cHandle, str);
		}

BuNiCu-RP · March 12, 2016

@Mister - ce i-ai oferit tu, nu il ajuta.

Mane tu ai nevoie sa ii faci in onplayer login un public din care sa preia ce este in db...

Gen cum ai la OnPlayerLoad (); adica sa verifice daca x a intrat in xtiki si sa ii returneze 1;

catalin9325 · March 12, 2016

Baieti , acum se salveaza , dar acolo la Total Tiki , in loc de 1/20 , poate sa scrie 19/20 sau -4/20 , ce pot face ?

Zic la scrisul Total Tiki : x/20 ..

BuNiCu-RP · March 14, 2016

Uite, am reusit sa rezolv sa iti faca si restrictie pe statuete !

Tiki Quest - Pawn !

Tiki Quest - SQL

EquiNoxAdv · March 19, 2016

48 ore fara raspuns. T/C

BuNiCu-RP · March 11, 2016

http://imgur.com/a/kp1kK

Sign In

Sprijin quest Tiki.

Question

Link to comment

Share on other sites

19 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Similar Content

Recently Browsing 0 members

Important Information