04.11.2014, 12:08
Hi there, i'm trying to create a new mysql code line but there are some problems about character data upload, i can't create a new collum. For now I'm using 25 collums but the code i created wont read 26th collum. One with the case lines are okay but i'cant add a new one. I'm currently using wampserver, i can open the mode there but when i want to enter the game it won't read it <<>> spawn screen won't see the data and it loops.
Код:
stock PlayerLoginLoad(playerid)
{
new query[128];
format(query, sizeof(query), "SELECT * FROM `users` WHERE `id` = '%d'", Users[playerid][sqlid]);
mysql_query(query);
mysql_store_result();
mysql_fetch_row_format(query, "|");
new arrCoords[128];
new d, li;
new aNum;
new len;
while(d <= strlen(query))
{
if(query[d]=='|' || d==strlen(query))
{
len = strmid(arrCoords, query, li, d, 128);
arrCoords[len] = 0;
switch(aNum)
{
case 0: Users[playerid][sqlid] = strval(arrCoords);
case 3: Users[playerid][posx] = strval(arrCoords);
case 4: Users[playerid][posy] = strval(arrCoords);
case 5: Users[playerid][posz] = strval(arrCoords);
case 6: Users[playerid][interior] = strval(arrCoords);
case 7: Users[playerid][vworld] = strval(arrCoords);
case 8: Users[playerid][level] = strval(arrCoords);
case 9: Users[playerid][cash] = strval(arrCoords);
case 10: Users[playerid][skin] = strval(arrCoords);
case 11: Users[playerid][hp] = strval(arrCoords);
case 12: Users[playerid][licenseidno] = strval(arrCoords);
case 13: Users[playerid][adminlevel] = strval(arrCoords);
case 14: Users[playerid][ban] = strval(arrCoords);
case 15: strmid(Users[playerid][reason], arrCoords[15], 0, strlen(arrCoords[15]), 255);
case 16: Users[playerid][chattype] = strval(arrCoords);
case 17: Users[playerid][payday] = strval(arrCoords);
case 18: Users[playerid][time] = strval(arrCoords);
case 19: Users[playerid][paydaybonus] = strval(arrCoords);
case 20: Users[playerid][exp] = strval(arrCoords);
case 21: Users[playerid][bank] = strval(arrCoords);
case 22: Users[playerid][bankno] = strval(arrCoords);
case 23: Users[playerid][phonenumber] = strval(arrCoords);
}
li = d+1;
aNum++;
printf("%d", strval(arrCoords));
}
d++;
}
mysql_free_result();
