GTA Közösség - A magyar GTA fórum

San Andreas Multiplayer (SA-MP) => SA-MP: Szerverfejlesztés => Segítségkérés => A témát indította: norbinator09 - 2015. Március 27. - 14:37:03

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 27. - 14:37:03

Sziasztok!
Elkezdtem írogatni egy modot, és mysql-al szeretné menteni.... csakhogy nem vagyok túl jó mysql-ban :( na mind1 találtam egy jó tutorialt YT-n és azalapján megcsináltam. Ezzel eddig nincs gond, csakhogy betöltésnél egyszerűn nem csinál semmit, majd leáll a szerver. Fogalmam nincs miért hátha ti tudtok segíteni :hmmm:
 

            format(query,sizeof(query), \"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
            mysql_query(query);
            mysql_store_result();
            
            
            INFO(playerid, \"Kérlek várj!\");
            new pos[32];
            new int[32];
            while(mysql_fetch_row_format(query, \"|\"))
            {
                mysql_fetch_field_row(int, \"Created1\"); pInfo[playerid][1][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created2\"); pInfo[playerid][2][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created3\"); pInfo[playerid][3][Created] = strval(int);
                mysql_fetch_field_row(nstr[1][playerid], \"CharName1\");
                mysql_fetch_field_row(nstr[2][playerid], \"CharName2\");
                mysql_fetch_field_row(nstr[3][playerid], \"CharName3\");
                mysql_fetch_field_row(int, \"Age1\"); pInfo[playerid][1][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age2\"); pInfo[playerid][2][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age3\"); pInfo[playerid][3][Age] = strval(int);
                mysql_fetch_field_row(int, \"Hati1\"); pInfo[playerid][1][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati2\"); pInfo[playerid][2][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati3\"); pInfo[playerid][3][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Sex1\"); pInfo[playerid][1][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex2\"); pInfo[playerid][2][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex3\"); pInfo[playerid][3][sex] = strval(int);
                mysql_fetch_field_row(int, \"Skin1\"),pInfo[playerid][1][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin2\"); pInfo[playerid][2][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin3\"); pInfo[playerid][3][skin] = strval(int);
                mysql_fetch_field_row(pos, \"pX1\"); pInfo[playerid][1][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX2\"); pInfo[playerid][2][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX3\"); pInfo[playerid][3][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY1\"); pInfo[playerid][1][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY2\"); pInfo[playerid][2][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY3\"); pInfo[playerid][3][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ1\"); pInfo[playerid][1][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ2\"); pInfo[playerid][2][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ3\"); pInfo[playerid][3][pZ] = floatstr(pos);
                mysql_fetch_field_row(int, \"Money1\"); pInfo[playerid][1][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money2\"); pInfo[playerid][2][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money3\"); pInfo[playerid][3][Money] = strval(int);
                mysql_fetch_field_row(int, \"Admin1\"); pInfo[playerid][1][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin2\"); pInfo[playerid][2][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin3\"); pInfo[playerid][3][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Ora1\"); pInfo[playerid][1][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora2\"); pInfo[playerid][2][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora3\"); pInfo[playerid][3][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Perc1\"); pInfo[playerid][1][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc2\"); pInfo[playerid][2][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc3\"); pInfo[playerid][3][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio1\"); pInfo[playerid][1][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio2\"); pInfo[playerid][2][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio3\"); pInfo[playerid][3][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Leader1\"); pInfo[playerid][1][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader2\"); pInfo[playerid][2][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader3\"); pInfo[playerid][3][Leader] = strval(int);
                mysql_fetch_field_row(int, \"FFizu1\"); pInfo[playerid][1][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu2\"); pInfo[playerid][2][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu3\"); pInfo[playerid][3][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu1\"); pInfo[playerid][1][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu2\"); pInfo[playerid][2][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu3\"); pInfo[playerid][3][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz1\"); pInfo[playerid][1][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz2\"); pInfo[playerid][2][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz3\"); pInfo[playerid][3][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Munka1\"); pInfo[playerid][1][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka2\"); pInfo[playerid][2][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka3\"); pInfo[playerid][3][Munka] = strval(int);
                
                mysql_fetch_field_row(int, \"INV_Slot1_1\"); pInfo[playerid][1][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_2\"); pInfo[playerid][2][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_3\"); pInfo[playerid][3][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_1\"); pInfo[playerid][1][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_2\"); pInfo[playerid][2][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_3\"); pInfo[playerid][3][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_1\"); pInfo[playerid][1][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_2\"); pInfo[playerid][2][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_3\"); pInfo[playerid][3][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_1\"); pInfo[playerid][1][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_2\"); pInfo[playerid][2][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_3\"); pInfo[playerid][3][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_1\"); pInfo[playerid][1][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_2\"); pInfo[playerid][2][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_3\"); pInfo[playerid][3][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_1\"); pInfo[playerid][1][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_2\"); pInfo[playerid][2][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_3\"); pInfo[playerid][3][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_1\"); pInfo[playerid][1][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_2\"); pInfo[playerid][2][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_3\"); pInfo[playerid][3][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_1\"); pInfo[playerid][1][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_2\"); pInfo[playerid][2][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_3\"); pInfo[playerid][3][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_1\"); pInfo[playerid][1][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_2\"); pInfo[playerid][2][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_3\"); pInfo[playerid][3][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_1\"); pInfo[playerid][1][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_2\"); pInfo[playerid][2][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_3\"); pInfo[playerid][3][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_1\"); pInfo[playerid][1][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_2\"); pInfo[playerid][2][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_3\"); pInfo[playerid][3][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_1\"); pInfo[playerid][1][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_2\"); pInfo[playerid][2][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_3\"); pInfo[playerid][3][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_1\"); pInfo[playerid][1][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_2\"); pInfo[playerid][2][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_3\"); pInfo[playerid][3][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_1\"); pInfo[playerid][1][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_2\"); pInfo[playerid][2][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_3\"); pInfo[playerid][3][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_1\"); pInfo[playerid][1][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_2\"); pInfo[playerid][2][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_3\"); pInfo[playerid][3][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_1\"); pInfo[playerid][1][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_2\"); pInfo[playerid][2][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_3\"); pInfo[playerid][3][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_1\"); pInfo[playerid][1][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_2\"); pInfo[playerid][2][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_3\"); pInfo[playerid][3][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_1\"); pInfo[playerid][1][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_2\"); pInfo[playerid][2][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_3\"); pInfo[playerid][3][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_1\"); pInfo[playerid][1][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_2\"); pInfo[playerid][2][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_3\"); pInfo[playerid][3][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_1\"); pInfo[playerid][1][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_2\"); pInfo[playerid][2][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_3\"); pInfo[playerid][3][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_1\"); pInfo[playerid][1][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_2\"); pInfo[playerid][2][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_3\"); pInfo[playerid][3][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_1\"); pInfo[playerid][1][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_2\"); pInfo[playerid][2][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_3\"); pInfo[playerid][3][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_1\"); pInfo[playerid][1][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_2\"); pInfo[playerid][2][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_3\"); pInfo[playerid][3][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_1\"); pInfo[playerid][1][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_2\"); pInfo[playerid][2][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_3\"); pInfo[playerid][3][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_1\"); pInfo[playerid][1][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_2\"); pInfo[playerid][2][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_3\"); pInfo[playerid][3][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_1\"); pInfo[playerid][1][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_2\"); pInfo[playerid][2][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_3\"); pInfo[playerid][3][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_1\"); pInfo[playerid][1][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_2\"); pInfo[playerid][2][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_3\"); pInfo[playerid][3][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_1\"); pInfo[playerid][1][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_2\"); pInfo[playerid][2][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_3\"); pInfo[playerid][3][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_1\"); pInfo[playerid][1][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_2\"); pInfo[playerid][2][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_3\"); pInfo[playerid][3][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_1\"); pInfo[playerid][1][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_2\"); pInfo[playerid][2][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_3\"); pInfo[playerid][3][iNV_Star15] = strval(int);
                
            }

 
Ez lenne felelős betölteni az adatokat, minden a videó alapján van és mégse jó.... Tapasztalat: azt még kiírja h várjak, de a while-t egyszerűen \"nem indítja el\".
Itt az a videó(sorozat) és annak a része:

 Remélem valaki tud segíteni, előre is köszi :)

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 27. - 18:01:51

így elég nehézkes rá jönni de nem tudom milyen mód az amiben így kell betölteni 1 DB koordinátát..
 

                              mysql_fetch_field_row(pos, \"pX1\"); pInfo[playerid][1][pX] = floatstr(pos);
                                mysql_fetch_field_row(pos, \"pX2\"); pInfo[playerid][2][pX] = floatstr(pos);
                                mysql_fetch_field_row(pos, \"pX3\"); pInfo[playerid][3][pX] = floatstr(pos);

 
és az érdekesség az hogy ez Y al és Z vel is megvan...

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 27. - 18:05:34

3 karit lehet létrehozni egy acc-on ha kicsit gondolkodsz(nem sértés) rájössz hogy a \"pX1\" az X pozícióját jelenti az 1 karakternek, és ugyan így a töbinél, nem tudod miért nem akar jó lenni? elv. működnie kéne

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 27. - 19:02:59

sajnálom bocsi ne bánts... bár érdekes... Az én \"gondolkodási módszerem szerint\"
1 ucp_fh tábla + 1 playerek tábla és akkor lehet hogy nem néz ki így... sry bocsi akkor [Így néz ki az én módomban de én tulajdonképpen kivagyok?]
viszont bizonyára azt tudod hogy a crashdetect lehet hogy ki írja mi a baj + spawnplayer(playerid); nem látok tehát ezért nehezebb a dolgok...

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 27. - 19:25:15

upc-t nem tudok mivel nem értek PHP-hoz, crashdetect-t mingy kipróbálom amúgy bemásolom azzal eggyüt ami van a betöltés után
 

format(query,sizeof(query), \"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
            mysql_query(query);
            mysql_store_result();
            
            
            INFO(playerid, \"Kérlek várj!\");
            new pos[32];
            new int[32];
            while(mysql_fetch_row_format(query, \"|\"))
            {
                mysql_fetch_field_row(int, \"Created1\"); pInfo[playerid][1][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created2\"); pInfo[playerid][2][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created3\"); pInfo[playerid][3][Created] = strval(int);
                mysql_fetch_field_row(nstr[1][playerid], \"CharName1\");
                mysql_fetch_field_row(nstr[2][playerid], \"CharName2\");
                mysql_fetch_field_row(nstr[3][playerid], \"CharName3\");
                mysql_fetch_field_row(int, \"Age1\"); pInfo[playerid][1][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age2\"); pInfo[playerid][2][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age3\"); pInfo[playerid][3][Age] = strval(int);
                mysql_fetch_field_row(int, \"Hati1\"); pInfo[playerid][1][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati2\"); pInfo[playerid][2][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati3\"); pInfo[playerid][3][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Sex1\"); pInfo[playerid][1][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex2\"); pInfo[playerid][2][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex3\"); pInfo[playerid][3][sex] = strval(int);
                mysql_fetch_field_row(int, \"Skin1\"),pInfo[playerid][1][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin2\"); pInfo[playerid][2][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin3\"); pInfo[playerid][3][skin] = strval(int);
                mysql_fetch_field_row(pos, \"pX1\"); pInfo[playerid][1][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX2\"); pInfo[playerid][2][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX3\"); pInfo[playerid][3][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY1\"); pInfo[playerid][1][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY2\"); pInfo[playerid][2][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY3\"); pInfo[playerid][3][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ1\"); pInfo[playerid][1][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ2\"); pInfo[playerid][2][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ3\"); pInfo[playerid][3][pZ] = floatstr(pos);
                mysql_fetch_field_row(int, \"Money1\"); pInfo[playerid][1][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money2\"); pInfo[playerid][2][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money3\"); pInfo[playerid][3][Money] = strval(int);
                mysql_fetch_field_row(int, \"Admin1\"); pInfo[playerid][1][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin2\"); pInfo[playerid][2][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin3\"); pInfo[playerid][3][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Ora1\"); pInfo[playerid][1][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora2\"); pInfo[playerid][2][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora3\"); pInfo[playerid][3][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Perc1\"); pInfo[playerid][1][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc2\"); pInfo[playerid][2][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc3\"); pInfo[playerid][3][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio1\"); pInfo[playerid][1][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio2\"); pInfo[playerid][2][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio3\"); pInfo[playerid][3][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Leader1\"); pInfo[playerid][1][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader2\"); pInfo[playerid][2][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader3\"); pInfo[playerid][3][Leader] = strval(int);
                mysql_fetch_field_row(int, \"FFizu1\"); pInfo[playerid][1][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu2\"); pInfo[playerid][2][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu3\"); pInfo[playerid][3][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu1\"); pInfo[playerid][1][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu2\"); pInfo[playerid][2][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu3\"); pInfo[playerid][3][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz1\"); pInfo[playerid][1][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz2\"); pInfo[playerid][2][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz3\"); pInfo[playerid][3][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Munka1\"); pInfo[playerid][1][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka2\"); pInfo[playerid][2][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka3\"); pInfo[playerid][3][Munka] = strval(int);
                
                mysql_fetch_field_row(int, \"INV_Slot1_1\"); pInfo[playerid][1][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_2\"); pInfo[playerid][2][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_3\"); pInfo[playerid][3][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_1\"); pInfo[playerid][1][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_2\"); pInfo[playerid][2][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_3\"); pInfo[playerid][3][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_1\"); pInfo[playerid][1][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_2\"); pInfo[playerid][2][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_3\"); pInfo[playerid][3][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_1\"); pInfo[playerid][1][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_2\"); pInfo[playerid][2][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_3\"); pInfo[playerid][3][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_1\"); pInfo[playerid][1][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_2\"); pInfo[playerid][2][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_3\"); pInfo[playerid][3][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_1\"); pInfo[playerid][1][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_2\"); pInfo[playerid][2][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_3\"); pInfo[playerid][3][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_1\"); pInfo[playerid][1][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_2\"); pInfo[playerid][2][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_3\"); pInfo[playerid][3][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_1\"); pInfo[playerid][1][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_2\"); pInfo[playerid][2][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_3\"); pInfo[playerid][3][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_1\"); pInfo[playerid][1][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_2\"); pInfo[playerid][2][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_3\"); pInfo[playerid][3][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_1\"); pInfo[playerid][1][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_2\"); pInfo[playerid][2][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_3\"); pInfo[playerid][3][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_1\"); pInfo[playerid][1][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_2\"); pInfo[playerid][2][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_3\"); pInfo[playerid][3][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_1\"); pInfo[playerid][1][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_2\"); pInfo[playerid][2][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_3\"); pInfo[playerid][3][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_1\"); pInfo[playerid][1][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_2\"); pInfo[playerid][2][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_3\"); pInfo[playerid][3][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_1\"); pInfo[playerid][1][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_2\"); pInfo[playerid][2][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_3\"); pInfo[playerid][3][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_1\"); pInfo[playerid][1][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_2\"); pInfo[playerid][2][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_3\"); pInfo[playerid][3][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_1\"); pInfo[playerid][1][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_2\"); pInfo[playerid][2][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_3\"); pInfo[playerid][3][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_1\"); pInfo[playerid][1][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_2\"); pInfo[playerid][2][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_3\"); pInfo[playerid][3][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_1\"); pInfo[playerid][1][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_2\"); pInfo[playerid][2][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_3\"); pInfo[playerid][3][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_1\"); pInfo[playerid][1][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_2\"); pInfo[playerid][2][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_3\"); pInfo[playerid][3][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_1\"); pInfo[playerid][1][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_2\"); pInfo[playerid][2][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_3\"); pInfo[playerid][3][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_1\"); pInfo[playerid][1][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_2\"); pInfo[playerid][2][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_3\"); pInfo[playerid][3][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_1\"); pInfo[playerid][1][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_2\"); pInfo[playerid][2][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_3\"); pInfo[playerid][3][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_1\"); pInfo[playerid][1][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_2\"); pInfo[playerid][2][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_3\"); pInfo[playerid][3][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_1\"); pInfo[playerid][1][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_2\"); pInfo[playerid][2][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_3\"); pInfo[playerid][3][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_1\"); pInfo[playerid][1][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_2\"); pInfo[playerid][2][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_3\"); pInfo[playerid][3][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_1\"); pInfo[playerid][1][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_2\"); pInfo[playerid][2][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_3\"); pInfo[playerid][3][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_1\"); pInfo[playerid][1][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_2\"); pInfo[playerid][2][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_3\"); pInfo[playerid][3][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_1\"); pInfo[playerid][1][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_2\"); pInfo[playerid][2][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_3\"); pInfo[playerid][3][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_1\"); pInfo[playerid][1][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_2\"); pInfo[playerid][2][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_3\"); pInfo[playerid][3][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_1\"); pInfo[playerid][1][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_2\"); pInfo[playerid][2][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_3\"); pInfo[playerid][3][iNV_Star15] = strval(int);
                
            }
            
          IsLoggedIn[playerid] = true;
          
          INFO(playerid, \"Sikeres bejelentkezés!\");
          IsLoggedIn[playerid] = true;
          format(str,sizeof(str),\"Karaktereid:\");
          if(pInfo[playerid][1][Created] == 1)
          {
              format(str,sizeof(str),\"%s %s\",str, nstr[1][playerid]);
          }
          if(pInfo[playerid][2][Created] == 1)
          {
              format(str,sizeof(str),\"%s, %s\",str, nstr[2][playerid]);
          }
          if(pInfo[playerid][3][Created] == 1)
          {
              format(str,sizeof(str),\"%s, %s\",str, nstr[3][playerid]);
          }
          INFO(playerid, str);
          CancelSelectTextDraw(playerid);
          TextDrawHideForPlayer(playerid, td_LOG_LEC1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_LEC2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_LEC3[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BOX1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BOX2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BOX3[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG3[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG4[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG5[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BFEL1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BFEL2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BJEL1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BJEL2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BLOG[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BREG[playerid]);
          SetPlayerColor(playerid, -1);
          TakePlayerToCharChanger(playerid);// ez beviszi a karakterválasztóba(ez úgymond a spawnplayer helyett van itt érted)

 
E: megnéztem, crashdetect nem ír ki semmit

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 27. - 19:54:00

Hogy nehogy úgy tűnjön hogy nem válaszolok , szóval válaszolok inkább...
1. körben nem tudom mi lehet a baj..... pasz fogalmam sincs...
2. körben senki nem mondta hogy UCP-t kell rá írni... egyszerűen át tekinthetőbb... és egyszerűbb de te érzed.
3. körben mysql R37 / R39 et ajánlanám... NEM R7 est ....

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 27. - 19:56:49

rendben, kössz a jó tanácsokat, amúgy ez R5-ös xD nemtom mibaj van az R5-el amúgy, de kipróbálom az R39-t(a témát azért hagyom még egy ideig, hátha valaki tud valamit)

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 27. - 20:40:59

R5 - R7 lényegében ugyan az a hibája [ Elavult.]

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 27. - 20:58:58

ja értem, de most próbálom az R39(-3 asszem) és egy csmó faszgáot kiírt mysql_store_result-ra meg...(valószínűleg ezek ki lettek cserélve) most nézelődök hogy lehetne ezeket javítani

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 27. - 21:42:44

Igen. Többek közt ez is!
Én picit másabb helyzetben voltam mivel én mysql 3.1.1 ről mentem át mysql R37 re [Ez 2 külön kiadó mysqlja és hidd el nagyon megérte :D kuvva nehéz volt de megérte :D]
 

[21:42:15] [DEBUG] CMySQLQuery::Execute[LoadPorno] - query was successfully executed within 227.113 milliseconds

 
ez tetszik benne majdnem a legjobban :$ hogy ki írja hogy mennyi idő alatt töltötte be XDDD
meg sokkal átláthatóbb tehát ha 1x megszokod onnastól kezdve gyerek játék... és mindent tehát MINDENT megtudsz írni... [Hidd el elég sok gyökérséget megírtam azzal pluginnal x\"DDD 26767 soros az én módom ami mysql R39-3 as]

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 27. - 22:29:08

nah sikerült megtalálni hogy mit mire kel és hogy lecserélni, legyen türelmem átírni és akkor megnézem miújság vele(mert eddig jó)
 

[21:42:15] [DEBUG] CMySQLQuery::Execute[LoadPorno] - query was successfully executed within 227.113 milliseconds[/quote]
ezt hogyan lehet kiiratni konzolba?
 am khm...

[LoadPorno][/quote]  xD

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 27. - 23:04:31

consolba sehogy nem fogod tudni a mysql_log.txt
 

mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG, LOG_TYPE_TEXT); 

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 27. - 23:33:20

Idézetet írta: norbinator09 date=1427491748\" data-ipsquote-contentapp=\"forums\" data-ipsquote-contenttype=\"forums\" data-ipsquote-contentid=\"53468\" data-ipsquote-contentclass=\"forums_Topic

am khm...

[LoadPorno]

  xD
[/quote]
Mondtam hogy gyökerséget megcsinálok HCRPs szerón dolgozok xd

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 30. - 21:56:32

hát beraktam mindent, az 1 dolog hogy nem fagy ki  aszerver viszont nem tölt be lószart se...
 

            format(query,sizeof(query), \"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
            mysql_query(MySQL, query,);
            
            new rows, fields;
            cache_get_data(rows, fields);
            
            pInfo[playerid][1][Created] = cache_get_field_content_int(rows, \"Created1\");
            pInfo[playerid][2][Created] = cache_get_field_content_int(rows, \"Created2\");
            pInfo[playerid][3][Created] = cache_get_field_content_int(rows, \"Created3\");
            cache_get_field_content(rows, \"CharName1\", nstr[1][playerid]);
            cache_get_field_content(rows, \"CharName2\", nstr[2][playerid]);
            cache_get_field_content(rows, \"CharName3\", nstr[3][playerid]);
            pInfo[playerid][1][skin] = cache_get_field_content_int(rows, \"Skin1\");
            pInfo[playerid][2][skin] = cache_get_field_content_int(rows, \"Skin2\");
            pInfo[playerid][3][skin] = cache_get_field_content_int(rows, \"Skin3\");
           

 
először betöltetem vele a karakterek 3 fő információját aztán amelyikre klikkel azt töltöm be:
 

   new now = hasznal[playerid];
    
    INFO(playerid, \"Karakter betöltése...\");
    new query[512];
    format(query, sizeof(query),\"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
    mysql_query(MySQL, query, true);
    
new rows, fields, int[256];
cache_get_data(rows, fields);
switch(now)
{
    case 1:
    {
        pInfo[playerid][1][Age] = cache_get_field_content_int(rows, \"Age1\");
        pInfo[playerid][1][Hatizsak] = cache_get_field_content_int(rows, \"Hati1\");
        pInfo[playerid][1][sex] = cache_get_field_content_int(rows, \"Sex1\");
        cache_get_field_content(rows, \"pX1\", int), pInfo[playerid][1][pX] = floatstr(int);
        cache_get_field_content(rows, \"pY1\", int), pInfo[playerid][1][pY] = floatstr(int);
        cache_get_field_content(rows, \"pZ1\", int), pInfo[playerid][1][pZ] = floatstr(int);
        pInfo[playerid][1][Money] = cache_get_field_content_int(rows, \"Money1\");
        pInfo[playerid][1][Admin] = cache_get_field_content_int(rows, \"Admin1\");
        pInfo[playerid][1][Ora] = cache_get_field_content_int(rows, \"Ora1\");
        pInfo[playerid][1][Perc] = cache_get_field_content_int(rows, \"Perc1\");
        pInfo[playerid][1][Frakcio] = cache_get_field_content_int(rows, \"Frakcio1\");
        pInfo[playerid][1][Munka] = cache_get_field_content_int(rows, \"Munka1\");
        pInfo[playerid][1][Leader] = cache_get_field_content_int(rows, \"Leader1\");
        pInfo[playerid][1][FFizu] = cache_get_field_content_int(rows, \"FFizu1\");
        pInfo[playerid][1][MFizu] = cache_get_field_content_int(rows, \"MFizu1\");
        pInfo[playerid][1][Felfiz] = cache_get_field_content_int(rows, \"Felfiz1\");
        
        pInfo[playerid][now][iNV_Slot1] = cache_get_field_content_int(rows, \"INV_Slot1_1\");
        pInfo[playerid][now][iNV_Slot2] = cache_get_field_content_int(rows, \"INV_Slot2_1\");
        pInfo[playerid][now][iNV_Slot3] = cache_get_field_content_int(rows, \"INV_Slot3_1\");
        pInfo[playerid][now][iNV_Slot4] = cache_get_field_content_int(rows, \"INV_Slot4_1\");
        pInfo[playerid][now][iNV_Slot5] = cache_get_field_content_int(rows, \"INV_Slot5_1\");
        pInfo[playerid][now][iNV_Slot6] = cache_get_field_content_int(rows, \"INV_Slot6_1\");
        pInfo[playerid][now][iNV_Slot7] = cache_get_field_content_int(rows, \"INV_Slot7_1\");
        pInfo[playerid][now][iNV_Slot8] = cache_get_field_content_int(rows, \"INV_Slot8_1\");
        pInfo[playerid][now][iNV_Slot9] = cache_get_field_content_int(rows, \"INV_Slot9_1\");
        pInfo[playerid][now][iNV_Slot10] = cache_get_field_content_int(rows, \"INV_Slot10_1\");
        pInfo[playerid][now][iNV_Slot11] = cache_get_field_content_int(rows, \"INV_Slot11_1\");
        pInfo[playerid][now][iNV_Slot12] = cache_get_field_content_int(rows, \"INV_Slot12_1\");
        pInfo[playerid][now][iNV_Slot13] = cache_get_field_content_int(rows, \"INV_Slot13_1\");
        pInfo[playerid][now][iNV_Slot14] = cache_get_field_content_int(rows, \"INV_Slot14_1\");
        pInfo[playerid][now][iNV_Slot15] = cache_get_field_content_int(rows, \"INV_Slot15_1\");
        pInfo[playerid][now][iNV_Star1] = cache_get_field_content_int(rows, \"INV_Star1_1\");
        pInfo[playerid][now][iNV_Star2] = cache_get_field_content_int(rows, \"INV_Star2_1\");
        pInfo[playerid][now][iNV_Star3] = cache_get_field_content_int(rows, \"INV_Star3_1\");
        pInfo[playerid][now][iNV_Star4] = cache_get_field_content_int(rows, \"INV_Star4_1\");
        pInfo[playerid][now][iNV_Star5] = cache_get_field_content_int(rows, \"INV_Star5_1\");
        pInfo[playerid][now][iNV_Star6] = cache_get_field_content_int(rows, \"INV_Star6_1\");
        pInfo[playerid][now][iNV_Star7] = cache_get_field_content_int(rows, \"INV_Star7_1\");
        pInfo[playerid][now][iNV_Star8] = cache_get_field_content_int(rows, \"INV_Star8_1\");
        pInfo[playerid][now][iNV_Star9] = cache_get_field_content_int(rows, \"INV_Star9_1\");
        pInfo[playerid][now][iNV_Star10] = cache_get_field_content_int(rows, \"INV_Star10_1\");
        pInfo[playerid][now][iNV_Star11] = cache_get_field_content_int(rows, \"INV_Star11_1\");
        pInfo[playerid][now][iNV_Star12] = cache_get_field_content_int(rows, \"INV_Star12_1\");
        pInfo[playerid][now][iNV_Star13] = cache_get_field_content_int(rows, \"INV_Star13_1\");
        pInfo[playerid][now][iNV_Star14] = cache_get_field_content_int(rows, \"INV_Star14_1\");
        pInfo[playerid][now][iNV_Star15] = cache_get_field_content_int(rows, \"INV_Star15_1\");
    }
case 2:
{
    pInfo[playerid][2][Age] = cache_get_field_content_int(rows, \"Age2\");
    pInfo[playerid][2][Hatizsak] = cache_get_field_content_int(rows, \"Hati2\");
    pInfo[playerid][2][sex] = cache_get_field_content_int(rows, \"Sex2\");
    cache_get_field_content(rows, \"pX2\", int), pInfo[playerid][2][pX] = floatstr(int);
        cache_get_field_content(rows, \"pY2\", int), pInfo[playerid][2][pY] = floatstr(int);
        cache_get_field_content(rows, \"pZ2\", int), pInfo[playerid][2][pZ] = floatstr(int);
    pInfo[playerid][2][Money] = cache_get_field_content_int(rows, \"Money2\");
    pInfo[playerid][2][Admin] = cache_get_field_content_int(rows, \"Admin2\");
    pInfo[playerid][2][Ora] = cache_get_field_content_int(rows, \"Ora2\");
    pInfo[playerid][2][Perc] = cache_get_field_content_int(rows, \"Perc2\");
    pInfo[playerid][2][Frakcio] = cache_get_field_content_int(rows, \"Frakcio2\");
    pInfo[playerid][2][Munka] = cache_get_field_content_int(rows, \"Munka2\");
            pInfo[playerid][2][Leader] = cache_get_field_content_int(rows, \"Leader2\");
            pInfo[playerid][2][FFizu] = cache_get_field_content_int(rows, \"FFizu2\");
            pInfo[playerid][2][MFizu] = cache_get_field_content_int(rows, \"MFizu2\");
            pInfo[playerid][2][Felfiz] = cache_get_field_content_int(rows, \"Felfiz2\");
            
            pInfo[playerid][now][iNV_Slot1] = cache_get_field_content_int(rows, \"INV_Slot1_2\");
        pInfo[playerid][now][iNV_Slot2] = cache_get_field_content_int(rows, \"INV_Slot2_2\");
        pInfo[playerid][now][iNV_Slot3] = cache_get_field_content_int(rows, \"INV_Slot3_2\");
        pInfo[playerid][now][iNV_Slot4] = cache_get_field_content_int(rows, \"INV_Slot4_2\");
        pInfo[playerid][now][iNV_Slot5] = cache_get_field_content_int(rows, \"INV_Slot5_2\");
        pInfo[playerid][now][iNV_Slot6] = cache_get_field_content_int(rows, \"INV_Slot6_2\");
        pInfo[playerid][now][iNV_Slot7] = cache_get_field_content_int(rows, \"INV_Slot7_2\");
        pInfo[playerid][now][iNV_Slot8] = cache_get_field_content_int(rows, \"INV_Slot8_2\");
        pInfo[playerid][now][iNV_Slot9] = cache_get_field_content_int(rows, \"INV_Slot9_2\");
        pInfo[playerid][now][iNV_Slot10] = cache_get_field_content_int(rows, \"INV_Slot10_2\");
        pInfo[playerid][now][iNV_Slot11] = cache_get_field_content_int(rows, \"INV_Slot11_2\");
        pInfo[playerid][now][iNV_Slot12] = cache_get_field_content_int(rows, \"INV_Slot12_2\");
        pInfo[playerid][now][iNV_Slot13] = cache_get_field_content_int(rows, \"INV_Slot13_2\");
        pInfo[playerid][now][iNV_Slot14] = cache_get_field_content_int(rows, \"INV_Slot14_2\");
        pInfo[playerid][now][iNV_Slot15] = cache_get_field_content_int(rows, \"INV_Slot15_2\");
        pInfo[playerid][now][iNV_Star1] = cache_get_field_content_int(rows, \"INV_Star1_2\");
        pInfo[playerid][now][iNV_Star2] = cache_get_field_content_int(rows, \"INV_Star2_2\");
        pInfo[playerid][now][iNV_Star3] = cache_get_field_content_int(rows, \"INV_Star3_2\");
        pInfo[playerid][now][iNV_Star4] = cache_get_field_content_int(rows, \"INV_Star4_2\");
        pInfo[playerid][now][iNV_Star5] = cache_get_field_content_int(rows, \"INV_Star5_2\");
        pInfo[playerid][now][iNV_Star6] = cache_get_field_content_int(rows, \"INV_Star6_2\");
        pInfo[playerid][now][iNV_Star7] = cache_get_field_content_int(rows, \"INV_Star7_2\");
        pInfo[playerid][now][iNV_Star8] = cache_get_field_content_int(rows, \"INV_Star8_2\");
        pInfo[playerid][now][iNV_Star9] = cache_get_field_content_int(rows, \"INV_Star9_2\");
        pInfo[playerid][now][iNV_Star10] = cache_get_field_content_int(rows, \"INV_Star10_2\");
        pInfo[playerid][now][iNV_Star11] = cache_get_field_content_int(rows, \"INV_Star11_2\");
        pInfo[playerid][now][iNV_Star12] = cache_get_field_content_int(rows, \"INV_Star12_2\");
        pInfo[playerid][now][iNV_Star13] = cache_get_field_content_int(rows, \"INV_Star13_2\");
        pInfo[playerid][now][iNV_Star14] = cache_get_field_content_int(rows, \"INV_Star14_2\");
        pInfo[playerid][now][iNV_Star15] = cache_get_field_content_int(rows, \"INV_Star15_2\");
}
case 3:
{
    pInfo[playerid][3][Age] = cache_get_field_content_int(rows, \"Age3\");
    pInfo[playerid][3][Hatizsak] = cache_get_field_content_int(rows, \"Hati3\");
    pInfo[playerid][3][sex] = cache_get_field_content_int(rows, \"Sex3\");
    cache_get_field_content(rows, \"pX3\", int), pInfo[playerid][3][pX] = floatstr(int);
        cache_get_field_content(rows, \"pY3\", int), pInfo[playerid][3][pY] = floatstr(int);
        cache_get_field_content(rows, \"pZ3\", int), pInfo[playerid][3][pZ] = floatstr(int);
    pInfo[playerid][3][Money] = cache_get_field_content_int(rows, \"Money3\");
    pInfo[playerid][3][Admin] = cache_get_field_content_int(rows, \"Admin3\");
    pInfo[playerid][3][Ora] = cache_get_field_content_int(rows, \"Ora3\");
    pInfo[playerid][3][Perc] = cache_get_field_content_int(rows, \"Perc3\");
    pInfo[playerid][3][Frakcio] = cache_get_field_content_int(rows, \"Frakcio3\");
    pInfo[playerid][3][Munka] = cache_get_field_content_int(rows, \"Munka3\");
    pInfo[playerid][3][Leader] = cache_get_field_content_int(rows, \"Leader3\");
    pInfo[playerid][3][FFizu] = cache_get_field_content_int(rows, \"FFizu3\");
    pInfo[playerid][3][MFizu] = cache_get_field_content_int(rows, \"MFizu3\");
    pInfo[playerid][3][Felfiz] = cache_get_field_content_int(rows, \"Felfiz3\");
    
    pInfo[playerid][now][iNV_Slot1] = cache_get_field_content_int(rows, \"INV_Slot1_3\");
        pInfo[playerid][now][iNV_Slot2] = cache_get_field_content_int(rows, \"INV_Slot2_3\");
        pInfo[playerid][now][iNV_Slot3] = cache_get_field_content_int(rows, \"INV_Slot3_3\");
        pInfo[playerid][now][iNV_Slot4] = cache_get_field_content_int(rows, \"INV_Slot4_3\");
        pInfo[playerid][now][iNV_Slot5] = cache_get_field_content_int(rows, \"INV_Slot5_3\");
        pInfo[playerid][now][iNV_Slot6] = cache_get_field_content_int(rows, \"INV_Slot6_3\");
        pInfo[playerid][now][iNV_Slot7] = cache_get_field_content_int(rows, \"INV_Slot7_3\");
        pInfo[playerid][now][iNV_Slot8] = cache_get_field_content_int(rows, \"INV_Slot8_3\");
        pInfo[playerid][now][iNV_Slot9] = cache_get_field_content_int(rows, \"INV_Slot9_3\");
        pInfo[playerid][now][iNV_Slot10] = cache_get_field_content_int(rows, \"INV_Slot10_3\");
        pInfo[playerid][now][iNV_Slot11] = cache_get_field_content_int(rows, \"INV_Slot11_3\");
        pInfo[playerid][now][iNV_Slot12] = cache_get_field_content_int(rows, \"INV_Slot12_3\");
        pInfo[playerid][now][iNV_Slot13] = cache_get_field_content_int(rows, \"INV_Slot13_3\");
        pInfo[playerid][now][iNV_Slot14] = cache_get_field_content_int(rows, \"INV_Slot14_3\");
        pInfo[playerid][now][iNV_Slot15] = cache_get_field_content_int(rows, \"INV_Slot15_\");
        pInfo[playerid][now][iNV_Star1] = cache_get_field_content_int(rows, \"INV_Star1_3\");
        pInfo[playerid][now][iNV_Star2] = cache_get_field_content_int(rows, \"INV_Star2_3\");
        pInfo[playerid][now][iNV_Star3] = cache_get_field_content_int(rows, \"INV_Star3_3\");
        pInfo[playerid][now][iNV_Star4] = cache_get_field_content_int(rows, \"INV_Star4_3\");
        pInfo[playerid][now][iNV_Star5] = cache_get_field_content_int(rows, \"INV_Star5_3\");
        pInfo[playerid][now][iNV_Star6] = cache_get_field_content_int(rows, \"INV_Star6_3\");
        pInfo[playerid][now][iNV_Star7] = cache_get_field_content_int(rows, \"INV_Star7_3\");
        pInfo[playerid][now][iNV_Star8] = cache_get_field_content_int(rows, \"INV_Star8_3\");
        pInfo[playerid][now][iNV_Star9] = cache_get_field_content_int(rows, \"INV_Star9_3\");
        pInfo[playerid][now][iNV_Star10] = cache_get_field_content_int(rows, \"INV_Star10_3\");
        pInfo[playerid][now][iNV_Star11] = cache_get_field_content_int(rows, \"INV_Star11_3\");
        pInfo[playerid][now][iNV_Star12] = cache_get_field_content_int(rows, \"INV_Star12_3\");
        pInfo[playerid][now][iNV_Star13] = cache_get_field_content_int(rows, \"INV_Star13_3\");
        pInfo[playerid][now][iNV_Star14] = cache_get_field_content_int(rows, \"INV_Star14_3\");
        pInfo[playerid][now][iNV_Star15] = cache_get_field_content_int(rows, \"INV_Star15_3\");
}
}

 
alap belépéskor sem tölti be a dolgotkat a szerver így esélyem sincs arra hogy a  karakter betöltésést leteszteljem :( (jah tudom kicsit retardáltan néz ki a 3 karakter miatt xD)
nemtod mit csesztem el? esetleg valamit kifelejtettem belőle?

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 30. - 22:46:26

Én nem így csinálgattam.
Én ezt használtam : http://wiki.sa-mp.com/wiki/MySQL/R33#mysql_tquery
A lényeg hogy kell mindenre egy külön public..
http://sampforum.hu/index.php?topic=57995.msg534822#msg534822 Nézd meg itt segítettem egy tagnak aki r39-3 ast használt és ez jó így próbálkozz

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 31. - 16:25:04

még mindog fos... nemértem miért mindent úgy csináltam ahogy írtad
 

public OnPlayerLogin(playerid)
{
new rows, fields;
cache_get_data(rows, fields);
get_int(rows, \"Created1\", pInfo[playerid][1][Created]);
get_int(rows, \"Created2\", pInfo[playerid][2][Created]);
get_int(rows, \"Created3\", pInfo[playerid][3][Created]);
get_int(rows, \"Skin1\", pInfo[playerid][1][skin]);
get_int(rows, \"Skin2\", pInfo[playerid][2][skin]);
get_int(rows, \"Skin3\", pInfo[playerid][3][skin]);
get_string(rows, \"CharName1\", nstr[1][playerid]);
get_string(rows, \"CharName2\", nstr[2][playerid]);
get_string(rows, \"CharName3\", nstr[3][playerid]);
}
            format(query,sizeof(query), \"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
            mysql_tquery(MySQL, query, \"OnPlayerLogin\", \"d\", playerid);

 

public OnCharacterDataLoading(playerid, now)
{
new rows, fields, name[512];
new pos[32];
cache_get_data(rows, fields);
format(name,sizeof(name), \"Admin%d\", now);
get_int(rows, name, pInfo[playerid][now][Admin]);
format(name,sizeof(name), \"Money%d\", now);
get_int(rows, name, pInfo[playerid][now][Money]);
format(name,sizeof(name), \"Hati%d\", now);
get_int(rows, name, pInfo[playerid][now][Hatizsak]);
format(name,sizeof(name), \"Sex%d\", now);
get_int(rows, name, pInfo[playerid][now][sex]);
format(name,sizeof(name), \"Age%d\", now);
get_int(rows, name, pInfo[playerid][now][Age]);
format(name,sizeof(name), \"Ora%d\", now);
get_int(rows, name, pInfo[playerid][now][Ora]);
format(name,sizeof(name), \"Perc%d\", now);
get_int(rows, name, pInfo[playerid][now][Perc]);
format(name,sizeof(name), \"Frakcio%d\", now);
get_int(rows, name, pInfo[playerid][now][Frakcio]);
format(name,sizeof(name), \"Munka%d\", now);
get_int(rows, name, pInfo[playerid][now][Munka]);
format(name,sizeof(name), \"Leader%d\", now);
get_int(rows, name, pInfo[playerid][now][Leader]);
format(name,sizeof(name), \"FFizu%d\", now);
get_int(rows, name, pInfo[playerid][now][FFizu]);
format(name,sizeof(name), \"MFizu%d\", now);
get_int(rows, name, pInfo[playerid][now][MFizu]);
format(name,sizeof(name), \"Felfiz%d\", now);
get_int(rows, name, pInfo[playerid][now][Felfiz]);
format(name,sizeof(name), \"pX%d\", now);
get_string(rows, name, pos);
pInfo[playerid][now][pX] = floatstr(pos);
format(name,sizeof(name), \"pY%d\", now);
get_string(rows, name, pos);
pInfo[playerid][now][pY] = floatstr(pos);
format(name,sizeof(name), \"pZ%d\", now);
get_string(rows, name, pos);
pInfo[playerid][now][pZ] = floatstr(pos);
format(name,sizeof(name), \"INV_Slot1_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot1]);
format(name,sizeof(name), \"INV_Slot2_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot2]);
format(name,sizeof(name), \"INV_Slot3_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot3]);
format(name,sizeof(name), \"INV_Slot4_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot4]);
format(name,sizeof(name), \"INV_Slot5_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot5]);
format(name,sizeof(name), \"INV_Slot6_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot6]);
format(name,sizeof(name), \"INV_Slot7_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot7]);
format(name,sizeof(name), \"INV_Slot8_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot8]);
format(name,sizeof(name), \"INV_Slot9_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot9]);
format(name,sizeof(name), \"INV_Slot10_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot10]);
format(name,sizeof(name), \"INV_Slot11_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot11]);
format(name,sizeof(name), \"INV_Slot12_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot12]);
format(name,sizeof(name), \"INV_Slot13_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot13]);
format(name,sizeof(name), \"INV_Slot14_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot14]);
format(name,sizeof(name), \"INV_Slot15_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Slot15]);
format(name,sizeof(name), \"INV_Star1_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star1]);
format(name,sizeof(name), \"INV_Star2_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star2]);
format(name,sizeof(name), \"INV_Star3_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star3]);
format(name,sizeof(name), \"INV_Star4_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star4]);
format(name,sizeof(name), \"INV_Star5_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star5]);
format(name,sizeof(name), \"INV_Star6_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star6]);
format(name,sizeof(name), \"INV_Star7_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star7]);
format(name,sizeof(name), \"INV_Star8_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star8]);
format(name,sizeof(name), \"INV_Star9_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star9]);
format(name,sizeof(name), \"INV_Star10_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star10]);
format(name,sizeof(name), \"INV_Star11_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star11]);
format(name,sizeof(name), \"INV_Star12_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star12]);
format(name,sizeof(name), \"INV_Star13_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star13]);
format(name,sizeof(name), \"INV_Star14_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star14]);
format(name,sizeof(name), \"INV_Star15_%d\", now);
get_int(rows, name, pInfo[playerid][now][iNV_Star15]);
}
    format(query, sizeof(query),\"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
    mysql_tquery(MySQL, query, \"OnCharacterDataLoading\", \"dd\", playerid,now);//OnCharacterDataLoading

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 31. - 16:42:28

OnCharacterDataLoading ezt hogy hívod meg?

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 31. - 17:04:42

így:
 

format(query, sizeof(query),\"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
    mysql_tquery(MySQL, query, \"OnCharacterDataLoading\", \"dd\", playerid,now);//OnCharacterDataLoading

 
de már az OnPlayerLogint sem megy, legalábbis nem tölti be az alapokat ami kéne(ugyanígy van meghívva) :(

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 31. - 18:58:11

mysql log?

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 31. - 19:03:51

[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] cache_get_field_content_int - invalid datatype
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] cache_get_field_content_int - invalid datatype
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] cache_get_field_content_int - invalid datatype
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] cache_get_field_content_int - invalid datatype
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] cache_get_field_content_int - invalid datatype
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] cache_get_field_content_int - invalid datatype
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[17:07:15] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 31. - 19:46:38

format(query, sizeof(query),\"SELECT * FROM `karakterek` WHERE UserName = \'%s\'\",UserName[playerid]);

 
És ahol d t használsz tquerybe tehát pl \"dd\",playerid,rows mondjuk ott az 1. Tedd i re

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Március 31. - 21:37:17

úgyse jó :(
mysql_log(tele van errorokkal)
 

[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:29] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:53] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:54] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype
[21:34:55] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index (\'1\')
[21:34:55] [ERROR] cache_get_field_content_int - invalid datatype

Cím: MySQL betöltés probléma
Írta: Kyosuke_Hiroshi - 2015. Március 31. - 22:33:22

Láttam nem tudom mi lehet most már... :/
eddig nekem mindig ment a mysql.. sose volt ilyen hiba..
Ha gondolod megnézem holnap délután de nem igérek semmit..

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Április 01. - 16:52:35

okés, köszi hogy ilyen kitartóan segítessz :)

Cím: MySQL betöltés probléma
Írta: SnooP - 2015. Április 01. - 17:32:07

[mod]Offok törölve. Ezt ne itt tessék megbeszélni, köszönöm. :)(HCRP-re gondoltam)[/mod]

Cím: MySQL betöltés probléma
Írta: norbinator09 - 2015. Április 02. - 19:32:41

Megoldottam! rows helyett 0-t kell írni és így jó :)
Zárok