[reckst4r]

Code:

C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(2776) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(5990) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6009) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6028) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6059) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6486) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6502) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6551) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6571) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6608) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(6667) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8029) : error 025: function heading differs from prototype
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8029 -- 8037) : error 021: symbol already defined: "command"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8037) : error 025: function heading differs from prototype
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8037 -- 8041) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

How do I make this work?

[Gray]

Sorry sir, but you shouldn't use 'Quartz Roleplay' since it had been on sale and it was leaked.

Carlton wouldn't be proud.

[playbox12]

Quote:

Originally Posted by Y_Less You really SHOULD use Quartz Role Play since it was on sale and was leaked and doing so will hurt the market for selling scripts which shouldn't exist in the first place. There's a reason links to the places are banned here and people only offer scripting services for hire, they don't sell scripts. Screw Carlton. As for your actual question, do you have the correct MySQL plugin for this code?

Thats about the first time I see you act out like that. (I agree)

And, as far as the problem goes, my guess would be, that the script is rigged with a security measure, this is complete guessing, but, the author might've changed a few function names arround, so the original mysql include wouldn't work, its pretty easy to fix, but for a bit more accurate help show the code.

[reckst4r]

Thanks for the notice, Y_Less. Here are the lines:

Line 2776:

Code:

if(mysql_retrieve_row()) //there are actually any rows

Line 5990, 6009, 6028, 6059, 6486, 6502, 6551, 6571, 6608, 6667 Are the same as Line 2776

Line 8029-8037:

Code:

command(help, playerid, params[]) {
	if(IsPlayerServerAdmin(playerid, 1)) {
        ShowPlayerDialog(playerid, DIALOG_SHOW_HELP_2, DIALOG_STYLE_LIST, "Help", "Chat\nVehicle\nWallet\nOOC Rooms\nSupport\nHouse\nBusiness\nBuildings\nFactions\nJob\nViolence\nNotes\nForum\nCell Phone\nUniversity\nJob\nDrugs\nDonator\nBank\nSettings\nMaterials\nAdmin", "Select", "Cancel");
        return 1;
	}
	ShowPlayerDialog(playerid, DIALOG_SHOW_HELP, DIALOG_STYLE_LIST, "Help", "Chat\nVehicle\nWallet\nOOC Rooms\nSupport\nHouse\nBusiness\nBuildings\nFactions\nJob\nViolence\nNotes\nForum\nCell Phone\nUniversity\nJob\nDrugs\nDonator\nBank\nSettings\nMaterials", "Select", "Cancel");
    return 1;
}
command(materials, playerid, params[]) {

Line 8037-8041:

Code:

	command(materials, playerid, params[]) {
    ShowPlayerDialog(playerid, DIALOG_MATERIALS_MENU, DIALOG_STYLE_LIST, string, "9mm - 5\nDesert Eagle - 10\nShotgun - 15\nSawn Off - 20\nTec-9 - 25\nMicro SMG - 25\nMP5 - 30\nAK-47 - 35\nM4 - 40\nRifle - 45\nSniper Rfile - 50\nFlameThrower - 55\nMolotov Cocktail - 60\nGrenade - 65\nMiniGun - 100", "Create","Cancel");
	return 1;
}
command(drugs, playerid, params[]) {

[Gray]

Ohh

We have tons of these script sellers in Thailand.

Is that the reason why we(they) got blacklisted?

EDIT: Are you using G-sTyLeZzZ's MySQL plugin?

Read this: https://sampforum.blast.hk/showthread.php?tid=187809

[reckst4r]

Quote:

Are you kidding me? pawn Code: mysq_fetch_row() Try that.

Ehm, what do I do with that pawn code? Where to I put it? And G-sTyLeZzZ's MySQL Plugin aint an include for pawn

[reckst4r]

Is the a_mysql.inc code supposed too look like this?

Code:

//this example demonstrates how to use more connections
new SQLPtr[2]; //global var
...
Function()
{
   SQLPtr[0] = mysql_connect(...);
   SQLPtr[1] = mysql_connect(...);
   mysql_query("SELECT a FROM table WHERE foo = 'bar'",(-1),(-1),SQLPtr[0]); //select query in the first DB
   mysql_query("UPDATE b SET bar = 'foo'",(-1),(-1),SQLPtr[1]); //update query in the second DB
   mysql_close(SQLPtr[1]); //close the 2nd DB connection, the other connection still exists
   
   Supported formats: (precisions such as %2.f/%10.s are not supported yet)
- %e (escapes data directly without the need to call mysql_escape_string() before)
- %s (string)
- %d / %i (integer)
- %f (float)

new szDestination[100];
mysql_format(connectionHandle, szDestination, "SELECT * FROM `%s` WHERE `bar` = '%e' AND `foobar` = '%f' LIMIT %d", "foobar", "escape'me\"please", 1.2345, 1337);
// the variable 'szDestination' contains now the formatted query (including the escaped string)
mysql_query(szDestination);

Edit: I changed the a_mysql.inc to the code above and now I get this when trying to compile:

Code:

C:\Users\Thomas\Desktop\asdf\pawno\include\a_mysql.inc(3) : error 010: invalid function or declaration
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(12) : warning 203: symbol is never used: "Function"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


1 Error.

Second Edit: I tryed to remove the ... from the a_mysql.inc, now it compiled. When I start the server it says: Script[gamemodes/grp.amx]: Run time error 6: "Invalid Instruction"

What now?

[reckst4r]

Could you upload the right a_mysql.inc? Please?

Edit: Sorry for that stupid question. I got the right a_mysql.inc now and the errors I get now is:

Code:

C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(3785) : error 017: undefined symbol "SCRIPT_UPDATE"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8028) : error 025: function heading differs from prototype
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8028 -- 8036) : error 021: symbol already defined: "command"
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8036) : error 025: function heading differs from prototype
C:\Users\Thomas\Desktop\asdf\gamemodes\qrp.pwn(8036 -- 8040) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


5 Errors.

[=WoR=Varth]

Do you miss any bracket?

[reckst4r]

I used the missing bracket finder and it says that there aint missing any brackets