[Doc-Holiday]

So i have never run across this before. I tried to compile the .sma and normally when its got errors it will tell you. But for some reason it just sits on the compile screen and never advances. What would cause this?

Like i said I have never seen it before. I added in normal SQLx and then this started happening. Hopefully some one knows.

Files below

[fysiks]

..\compile.sma(2195) : error 075: input line too long (after substitutions)

Also, you can't use "#pragma semicolon 1" because colorchat.inc does not adhere to that directive.

[Doc-Holiday]

Originally Posted by fysiks ..\compile.sma(2195) : error 075: input line too long (after substitutions) Also, you can't use "#pragma semicolon 1" because colorchat.inc does not adhere to that directive.

I added the semi colons to the colorchat inc. if that's what your saying.

How did you get yours to give you that error mine just sits on the black screen sitting and waiting to compile (or does it just take an extra long time)

[fysiks]

Originally Posted by Doc-Holiday I added the semi colons to the colorchat inc. if that's what your saying. How did you get yours to give you that error mine just sits on the black screen sitting and waiting to compile (or does it just take an extra long time)

It's this thing I call "debugging". EDIT: I guess I should elaborate here. I commented every line starting at line 283 to the end of the file.

Also, it's not a good idea to change a well published include file if the change is not negligible (in this case it is certainly not negligible). Unless you never plan on releasing your completed plugin to the public. Just remove the semicolon pragma and all will be good.

[Doc-Holiday]

Originally Posted by fysiks It's this thing I call "debugging". EDIT: I guess I should elaborate here. I commented every line starting at line 283 to the end of the file. Also, it's not a good idea to change a well published include file if the change is not negligible (in this case it is certainly not negligible). Unless you never plan on releasing your completed plugin to the public. Just remove the semicolon pragma and all will be good.

From what i gather the error means the variable is to small for all of the text once its substituted. Am i correct?

I made the variable larger and still receive the same error. and by larger i mean i went from the small number up to 2k in increments of 100.

Edit:
Or is it from the compiler saying that the text line is too large...

LOL if thats the case (which couldnt be changed) is there away to save all the same data with out such a long ass string.

[fysiks]

Originally Posted by Doc-Holiday From what i gather the error means the variable is to small for all of the text once its substituted. Am i correct?

No, it has nothing to do with the variable itself. It's a compiler limitation, IIRC. Search for the many threads that have the same issue.

[Doc-Holiday]

Originally Posted by fysiks No, it has nothing to do with the variable itself. It's a compiler limitation, IIRC. Search for the many threads that have the same issue.

So i have to make multiple queries to save/load my data due to the size of the string correct?

Edit: I dont know much about sql so please dont be SUPER harsh lol. but is this something i would have to do

Create 2 tables one saving half the data the second one saving the rest. Or is there away to append one query to the next.

like this

Query 1: player id, name, class1, class2
Query 3: class3, class4, class5, class 6

And have them added to the same entry on the DB?

(Not a seperate issue still trying to fix the first one)

According to exolent he said you can

Originally Posted by Exolent[jNr] The string is too long for the compiler. Solutions: - Format the string into the variable one piece at a time. <---What does he mean by this? - Execute each query separately.

using mulitple formatex ? and add two separate strings together before the query?

EDIT:!!! Ignore the above..

I think i figured out what i had to do.

PHP Code:

        formatex(szQueryOne, charsmax(szQueryOne), "REPLACE INTO `XpTable` (`player_id`, `player_name`, `player_total_xp`, `player_class_assault_xp`, `player_class_specops_xp`, `player_class_sniper_xp`, `player_class_engineer_xp`, `player_class_medic_xp`, `player_class_support_xp`)");
        formatex(szQueryTwo, charsmax(szQueryTwo), "VALUES (`%s`, `%s`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`);", g_szAuthID[id], szName, g_XP[id][TotalXP], g_XP[id][XP][CLASS_ASSAULT], g_XP[id][XP][CLASS_SPECOPS], g_XP[id][XP][CLASS_SNIPER], g_XP[id][XP][CLASS_ENGINEER], g_XP[id][XP][CLASS_MEDIC], g_XP[id][XP][CLASS_SUPPORT]);
        formatex(szQuery, charsmax(szQuery), "%s %s", szQueryOne, szQueryTwo); 


[fysiks]

Originally Posted by fysiks Search for the many threads that have the same issue.

I can't tell you any more than that because I don't know for sure.

[Doc-Holiday]

Originally Posted by fysiks I can't tell you any more than that because I don't know for sure.

See edit above

[Sylwester]

Originally Posted by Doc-Holiday So i have to make multiple queries to save/load my data due to the size of the string correct?

No. The problem is the length of the line in editor, so it will work if you do this:

PHP Code:

formatex(szQuery, charsmax(szQuery), "REPLACE INTO `XpTable` (`player_id`, `player_total_xp`, `player_class_assault_xp`, `player_class_specops_xp`, `player_class_sniper_xp`, `player_class_engineer_xp`, `player_class_medic_xp`, `player_class_support_xp`) VALUES (`%s`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`);", g_szAuthID[id], g_XP[id][TotalXP], g_XP[id][XP][CLASS_ASSAULT], g_XP[id][XP][CLASS_SPECOPS], g_XP[id][XP][CLASS_SNIPER], g_XP[id][XP][CLASS_ENGINEER], g_XP[id][XP][CLASS_MEDIC], g_XP[id][XP][CLASS_SUPPORT]); 


->

PHP Code:

formatex(szQuery, charsmax(szQuery), "REPLACE INTO `XpTable` (`player_id`, `player_total_xp`, `player_class_assault_xp`, `player_class_specops_xp`, `player_class_sniper_xp`, `player_class_engineer_xp`, `player_class_medic_xp`, `player_class_support_xp`) VALUES (`%s`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`, `%d`);", 
g_szAuthID[id], g_XP[id][TotalXP], g_XP[id][XP][CLASS_ASSAULT], g_XP[id][XP][CLASS_SPECOPS], g_XP[id][XP][CLASS_SNIPER], g_XP[id][XP][CLASS_ENGINEER], g_XP[id][XP][CLASS_MEDIC], g_XP[id][XP][CLASS_SUPPORT]); 


If you want to keep whole formatex function in a single line, or if the string "REPLACE ...." itself is too long then you just need to create the whole things using parts like this:

PHP Code:


new pos
pos += formatex(szQuery[pos], charsmax(szQuery)-pos, "REPLACE INTO `XpTable` (`player_id`, `player_total_xp`, `player_class_assault_xp`, `player_class_specops_xp`,");
pos += formatex(szQuery[pos], charsmax(szQuery)-pos, " `player_class_sniper_xp`, `player_class_engineer_xp`, `player_class_medic_xp`, `player_class_support_xp`)");
pos += formatex(szQuery[pos], charsmax(szQuery)-pos, " VALUES (`%s`, `%d`, `%d`,", g_szAuthID[id], g_XP[id][TotalXP], g_XP[id][XP][CLASS_ASSAULT]);
pos += formatex(szQuery[pos], charsmax(szQuery)-pos, " `%d`, `%d`, `%d`, `%d`, `%d`);", g_XP[id][XP][CLASS_SPECOPS], g_XP[id][XP][CLASS_SNIPER], g_XP[id][XP][CLASS_ENGINEER], g_XP[id][XP][CLASS_MEDIC], g_XP[id][XP][CLASS_SUPPORT]);