คอมพายไม่ผ่านสักที ช้วยดูให้ทีครับผม
ผมลองเปรียนเป็น new Mysql:dbhandle; มันก็เหมือนเดิมแล้วลอง ไม่ใส่ เป็น
mysql_connect("DB_HOST","DB_USER","DB_PASS","DB_DB");
ประโยคด่านล่างก็ทำงานคือ ไม่สามารถเชืมต่อได้
print("Could not connect to database!");
filterscripts = ""(string)
Server Plugins
--------------
Loading plugin: nativechecker.dll
Loaded.
Loading plugin: mysql.dll
>> plugin.mysql: R39 successfully loaded.
Loaded.
Loaded 2 plugins.
Filterscripts
---------------
Loaded 0 filterscripts.
Error: Function not registered: 'mysql_connect'
Error: Function not registered: 'mysql_errno'
Could not connect to database!
----------------------------------
Blank Gamemode by your name here
----------------------------------
Number of vehicle models: 0
-----------------------------------------
#include <a_samp>
#include <a_mysql>
//#include <sscanf>
#include <zcmd>
#if defined FILTERSCRIPT
#define DB_HOST "localhost"
#define DB_USER "root"
#define DB_PASS "12345678"
#define DB_DB "samp"
new dbhandle;
public OnFilterScriptInit()
{
print("\n--------------------------------------");
print(" Blank Filterscript by your name here");
print("--------------------------------------\n");
return 1;
}
public OnFilterScriptExit()
{
return 1;
}
#else
main()
{
print("\n----------------------------------");
print(" Blank Gamemode by your name here");
print("----------------------------------\n");
}
#endif
public OnGameModeInit()
{
SetGameModeText("HELLO WTF WTF ");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
dbhandle = mysql_connect("DB_HOST","DB_USER","DB_PASS","DB_DB");
if(mysql_errno() != 0)
print("Could not connect to database!");
else
print("Could connect to database");
return 1;
}
public OnGameModeExit()
{
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
return 1;
}
public OnPlayerConnect(playerid)
{
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
return 1;
}
public OnPlayerSpawn(playerid)
{
return 1;
}
public OnPlayerDeath(playerid, killerid, reason)
{
return 1;
}
public OnVehicleSpawn(vehicleid)
{
return 1;
}
public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}
public OnPlayerText(playerid, text[])
{
return 1;
}
public OnPlayerCommandText(playerid, cmdtext[])
{
if (strcmp("/mycommand", cmdtext, true, 10) == 0)
{
// Do something here
return 1;
}
return 0;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}
public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}
public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}
public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}
public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}
public OnRconCommand(cmd[])
{
return 1;
}
public OnPlayerRequestSpawn(playerid)
{
return 1;
}
public OnObjectMoved(objectid)
{
return 1;
}
public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}
public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}
public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}
public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}
public OnPlayerExitedMenu(playerid)
{
return 1;
}
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}
public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}
public OnPlayerUpdate(playerid)
{
return 1;
}
public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}
public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}
public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}
public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}
replace dbhandle = mysql_connect("DB_HOST","DB_USER","DB_PASS","DB_DB");
TO
dbhandle = mysql_connect(DB_HOST,DB_USER,DB_DB,DB_PASS); แบบของพี่ ใช้ mysql รุ่นไหนครับผม ผมลองdbhandle = mysql_connect("DB_HOST","DB_USER","DB_PASS","DB_DB"); ไปว่าง dbhandle = mysql_connect(DB_HOST,DB_USER,DB_DB,DB_PASS); มันไม่ได้ครับ
ผมลองใช้mysql3941 ก็รันคอมไพล์ไม่ผ่าน plugins ติดต่อได้ปกติ แต่เวลาเขียนสคิปให้ dbhandle เก็บการ connectของ mysql มันจะไม่ผ่าน ผมงงมากๆ แต่ก่อนนี้ก็มีปัญหา เช่น xsam mysl ไม่ได้ต้องลงวินใหม่ไหนจะเรือง ลืมลง c++ เกือบทุกเวอชันเพือ่ลงmysql ผมใช้เวลาเลย7วัน ยังทำไม่ถึงไหนเลยครับ ผมมันมีปัญหามาตลอดพี่ๆที ทำมานาๆน ช้วยดูให้ผมทีครับ ..........................
หน้า:
[1]