SA-MP Forums Archive
MySQL Problem ( switching from the old version to the new version R-39) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Problem ( switching from the old version to the new version R-39) (/showthread.php?tid=628267)



MySQL Problem ( switching from the old version to the new version R-39) - Barnwell - 08.02.2017

MySQL Problem ( switching from the old version to the new version R-39)
I made register system in 2013 so its very old
The problem
I dont want to use MySQL R5 i want to use MySQL R-39

pawn Code:
//Native functions

#define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
#define mysql_next_row() mysql_retrieve_row()
#define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)

native mysql_affected_rows(connectionHandle = 1);
native mysql_close(connectionHandle = 1);
native mysql_connect(const host[],const user[],const database[],const password[]);
native mysql_debug(enable = 1);
native mysql_errno(connectionHandle = 1);
native mysql_fetch_int(connectionHandle = 1);
native mysql_fetch_field(number,dest[],connectionHandle = 1);
native mysql_fetch_field_row(string[],const fieldname[],connectionHandle = 1);
native mysql_fetch_float(&Float:result,connectionHandle = 1);
native mysql_fetch_row_format(string[],const delimiter[] = "|",connectionHandle = 1);
native mysql_field_count(connectionHandle = 1);
native mysql_free_result(connectionHandle = 1);
native mysql_get_charset(destination[],connectionHandle = 1);
native mysql_insert_id(connectionHandle = 1);
native mysql_num_rows(connectionHandle = 1);
native mysql_num_fields(connectionHandle = 1);
native mysql_ping(connectionHandle = 1);
native mysql_query(query[],resultid = (-1),extraid = (-1),connectionHandle = 1);
native mysql_query_callback(index,query[],callback[],extraid = (-1),connectionHandle = 1);
native mysql_real_escape_string(const source[],destination[],connectionHandle = 1);
native mysql_reconnect(connectionHandle = 1);
native mysql_reload(connectionHandle = 1);
native mysql_retrieve_row(connectionHandle = 1);
native mysql_set_charset(charset[],connectionHandle = 1);
native mysql_stat(const destination[],connectionHandle = 1);
native mysql_store_result(connectionHandle = 1);
native mysql_warning_count(connectionHandle = 1);
I need someone to replace this function from R5 to R39
+ REP


Re: MySQL Problem ( switching from the old version to the new version R-39) - Barnwell - 08.02.2017

pawn Code:
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(138) : error 017: undefined symbol "mysql_store_result"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(139) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(141) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(145) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(147) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(148) : error 006: must be assigned to an array
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(149) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(152) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(154) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(156) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(158) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(160) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(162) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(164) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(166) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(168) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(170) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(172) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(174) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(176) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(179) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(181) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(182) : error 006: must be assigned to an array
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(183) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(185) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(186) : error 017: undefined symbol "pPayday"

Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


26 Errors.
Im using MySQL R39


Re: MySQL Problem ( switching from the old version to the new version R-39) - princejeet1510 - 08.02.2017

Are you using correct version??
PS: try to recompile it and maybe Download that version.


Re: MySQL Problem ( switching from the old version to the new version R-39) - Barnwell - 08.02.2017

I need to switch from R5 to R-39
like replace the functions.


Re: MySQL Problem ( switching from the old version to the new version R-39) - Barnwell - 08.02.2017

ANYONE HELP!


Re: MySQL Problem ( switching from the old version to the new version R-39) - Sew_Sumi - 08.02.2017

You made this, and yet you need help to "fix" it?

You obviously need to update your code to cope with the newer methods...


Re: MySQL Problem ( switching from the old version to the new version R-39) - Barnwell - 08.02.2017

Anyone reply here I need to replace functions from R5- R39
mysql_fetch_field_row What is the change of this row on MySQL R39?


Re: MySQL Problem ( switching from the old version to the new version R-39) - Barnwell - 08.02.2017

anyone help?


Re: MySQL Problem ( switching from the old version to the new version R-39) - Sew_Sumi - 08.02.2017

Stop bumping your topic... 24 hour bumps only.

If you made it, then you should be able to update it to the latest functions, as that's your issue.