Posts: 558
Threads: 112
Joined: May 2014
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
Posts: 558
Threads: 112
Joined: May 2014
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
Posts: 115
Threads: 7
Joined: Mar 2016
Reputation:
0
Are you using correct version??
PS: try to recompile it and maybe Download that version.
Posts: 558
Threads: 112
Joined: May 2014
I need to switch from R5 to R-39
like replace the functions.
Posts: 558
Threads: 112
Joined: May 2014
Posts: 6,242
Threads: 8
Joined: Jun 2008
You made this, and yet you need help to "fix" it?
You obviously need to update your code to cope with the newer methods...
Posts: 558
Threads: 112
Joined: May 2014
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?
Posts: 558
Threads: 112
Joined: May 2014
Posts: 6,242
Threads: 8
Joined: Jun 2008
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.
