PDA

View Full Version : MySQL connection issue


SsHady
07/03/2016, 04:42 AM
hello everyone,

I have an old and awesome MySQL GM which is pretty beat up at the moment!
It uses MySQL version edited by the original owner. but it doesn't have any "mysql_connect" or "mysql_close" queries anywhere on the server! this is the only part of MySQL under Ongamemodeinit

// Connect to MySQL

if(mysql_ping() != 0)
{
printf("================ [ERROR] ================");
printf("Connection to MySQL failed.");
SendRconCommand("exit");
return 1;
}

also instead of typing the MySQL db configuration in the .pwn it has a MySQL.cfg in the samp-server.exe folder! but I was unable to find any part that reads the config from that cfg file!
I don't plan on updating it to the latest MySQL yet I just want to make it work!
Here's the mysql.cfg
www.db4free.net tayyabnakar pewpew uogdb 3306

The above provided MySQL config is working but it is not connecting to the MySQL database!

I'll be waiting for your help!
cheers

SickAttack
07/03/2016, 05:08 AM
1 if alive, 0 if dead.

1 if alive!

Use:

if(!mysql_ping())

Or (which is the same thing as above):

if(mysql_ping() == 0)

SsHady
07/03/2016, 05:13 AM
I edited that! Still its not connecting to the database!
[11:12:37] Connection to MySQL failed.
[11:12:37] Number of vehicle models: 0
[11:12:37] --- Server Shutting Down.
Here's what I did
if(!mysql_ping())
{
printf("================ [ERROR] ================");
printf("Connection to MySQL failed.");
SendRconCommand("exit");
return 1;
}

SickAttack
07/03/2016, 05:16 AM
Then it's not connecting!

The connection (log on) details are incorrect.

SsHady
07/03/2016, 05:19 AM
Ugh! It is correct! maybe the port is wrong! I'll check it! and will reply!
Thanks for your help! +2

SsHady
07/03/2016, 11:03 AM
This is still not working! The MySQL details are 100% correct but still its not connecting
Can anyone help me? As I said earlier I wasn't able to find "Mysql_connect" anywhere on the script!
the ongamemodeinit! no mysql connect can be seen here :/
public OnGameModeInit()
{
// Basic Config
SetGameModeText("Stunt•Freeroam");
SendRconCommand("hostname " HOSTNAME_1);
SendRconCommand("mapname " "Freeroam World");
UsePlayerPedAnims();
EnableVehicleFriendlyFire();
EnableStuntBonusForAll(0);
AllowInteriorWeapons(1);
DisableInteriorEnterExits();
DisableNameTagLOS();
SetWorldTime(10);
SetWeather(24);

// Connect to MySQL

if(mysql_ping() != 0)
{
printf("================ [ERROR] ================");
printf("Connection to MySQL failed.");
SendRconCommand("exit");
return 1;
}

// Reaction Test
xChars = "1+1=fish";

// Pickups
CreateDynamicPickup(371, 23, 1524.3234, -1358.6941, 330.0000, -1); // Parachute (1)
CreateDynamicPickup(371, 23, 1526.6659, -1346.5205, 329.9922, -1); // Parachute (2)
CreateDynamicPickup(371, 23, 1537.1620, -1338.4463, 330.0536, -1); // Parachute (3)
CreateDynamicPickup(1310, 23, 402.3224,2530.8486,16.9003, -1); // Dive (4)
CreateDynamicPickup(1310, 23, -2630.8696,1399.9384,7.0938, -1); // Dive (5)
CreateDynamicPickup(1310, 3, -1826.1458, 567.2424, 277.6880,-1); // HayClimb (6)
CreateDynamicPickup(1310, 3, 2688.4822,-1860.4713,186.3743,-1); // Parkour (7)

CreateDynamicPickup(19130, 2, -2339.4851,-1604.3956,483.7069, -1); // TelePC (8)
CreateDynamicPickup(19130, 2, 392.4084,2451.4614,17.0703, -1); // TelePC (9)
CreateDynamicPickup(19130, 2, 376.9973,2532.1228,16.9003, -1); // TelePC (10)
CreateDynamicPickup(19130, 2, -1183.0519,24.5742,14.3903, -1); // TelePC (11)
CreateDynamicPickup(19130, 2, -2646.0896,1380.1772,7.1684, -1); // TelePC (12)
CreateDynamicPickup(19130, 2, 2161.8206,1671.8610,10.8203, -1); // TelePC (13)
CreateDynamicPickup(19130, 2, 1316.5116,1282.1577,10.8203, -1); // TelePC (14)
CreateDynamicPickup(19130, 2, 2506.0498,-1675.2979,13.1480, -1); // TelePC (15)
CreateDynamicPickup(19130, 2, 429.4098,3236.1636,739.8063, -1); // TelePC (16)

CreateDynamicPickup(19132, 2, -2302.5461,-1636.9451,483.6979, -1); // vPC (17)
CreateDynamicPickup(19132, 2, 332.9260,2531.7275,16.8040, -1); // vPC (18)
CreateDynamicPickup(19132, 2, -1196.1881,16.9466,14.3903, -1); // vPC (19)
CreateDynamicPickup(19132, 2, -2617.6138,1365.4655,7.0502, -1); // vPC (20)
CreateDynamicPickup(19132, 2, 2162.0547,1682.8297,10.8203, -1); // vPC (21)
CreateDynamicPickup(19132, 2, 2091.9294,-2598.9846,13.5469, -1); // vPC (22)
CreateDynamicPickup(19132, 2, 400.1298,2451.9253,17.0703, -1); // vPC (23)
CreateDynamicPickup(19132, 2, -2662.8435,1349.7847,17.0603, -1); // vPC (24)
CreateDynamicPickup(19132, 2, 421.9639,3245.4871,739.6420, -1); // vPC (25)

CreateDynamicPickup(1313, 1, -3957.7227,1312.4315,2.2741, -1); // Bar (26)
CreateDynamicPickup(1550, 2, 0, 0, 400, -1); // MoneyBag (27)

CreateDynamicPickup(1310, 23, 418.8626,2440.7043,16.9800, -1); // Dive (28)
CreateDynamicPickup(1310, 23, 2093.9438,-2634.3557,13.5803, -1); // Dive (29)
CreateDynamicPickup(1310, 23, -1224.6686,49.1064,14.3903, -1); // Dive (30)
CreateDynamicPickup(1310, 23, -2299.0886,-1626.4368,483.8803, -1); // Dive (31)
CreateDynamicPickup(1313, 1, 602.7739,-1520.6984,15.1956, -1); // Bar 2(32)

// Jetpack Pickups
CreateDynamicPickup(370, 15, 388.6886,2539.0339,16.5391, -1);//chilliad
CreateDynamicPickup(370, 15, -2645.9111,1377.4677,7.1677, -1);//aa1
CreateDynamicPickup(370, 15, 345.7805,2531.9968,16.7604, -1); //sfair
CreateDynamicPickup(370, 15, -1267.1456,29.6771,14.1484, -1); //sf
CreateDynamicPickup(370, 15, -2336.0994,-1615.5430,483.7162, -1); //lv
CreateDynamicPickup(370, 15, 2088.5835,-2612.4033,13.5469, -1); //lsair
CreateDynamicPickup(370, 15, 2149.5339,1675.5690,10.8203, -1); //
CreateDynamicPickup(370, 15, 389.8772,2450.2734,17.0703, -1); //

// Checkpoints
CreateDynamicCP(356.9608,2547.1243,16.3083, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel(""ORANGE_E"Tune Menu", COLOR_WHITE, 356.9608,2547.1243,16.3083, 60.0, .testlos = 1); //AA
CreateDynamicCP(2150.4426,1683.3350,10.8125, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel(""ORANGE_E"Tune Menu)", COLOR_WHITE, 2150.4426,1683.3350,10.8125, 60.0, .testlos = 1); //LV
CreateDynamicCP(-2614.5774,1354.7023,7.1495, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel(""ORANGE_E"Tune Menu", COLOR_WHITE, -2614.3748,1354.5983,7.1515, 60.0, .testlos = 1); //SF
CreateDynamicCP(-1228.8936,7.4453,14.3903, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel(""ORANGE_E"Tune Menu", COLOR_WHITE, -1228.8936,7.4453,14.3903, 60.0, .testlos = 1); //SFAir

CreateDynamicCP(-2624.0850,1411.7439,7.0938, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel(""WHITE_E"Regular Players Club "LB2_E"SF", COLOR_WHITE, -2624.0850,1411.7439,7.0938, 60.0, .testlos = 1); //RPC SF
CreateDynamicCP(-26.1917,2531.7217,17.4203, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel(""WHITE_E"Regular Players Club "LB2_E"AA", COLOR_WHITE, -26.1917,2531.7217,17.4203, 60.0, .testlos = 1); //RPC AA
CreateDynamicCP(-3936.5137,1303.7280,1.4587, 1.5, -1, -1, -1, 100.0); //RPC Exit

CreateDynamicCP(2225.7664,1838.6151,10.8203, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel(""WHITE_E"Regular Players Club "LB2_E"LV", COLOR_WHITE, 2225.7664,1838.6151,10.8203, 60.0, .testlos = 1); //RPC
CreateDynamicCP(967.5002,-53.1265,1001.1246, 1.5, 10, -1, -1, 100.0); //RPC Exit

//HQ
CreateDynamicCP(354.1575,2475.8054,17.0303, 2.0, -1, -1, -1, 100.0);
CreateDynamic3DTextLabel("Stunt Freeroam Evolution"LB_E"HQ", COLOR_WHITE, 354.1575,2475.8054,17.0303, 60.0, .testlos = 1); //HQ
CreateDynamicCP(389.7614,173.6989,1008.3828, 2.0, -1, -1, -1, 100.0); //hq exit

CreateDynamicCP(1747.4559,-3008.4915,39.4380, 8.0, -1, -1, -1, 100.0); // Monster Challenge Reward
CreateDynamicCP(-3249.0808,990.8794,40.6221, 5.0, -1, -1, -1, 100.0); // QuadParkour Reward
CreateDynamicCP(1024.6803,1292.1177,20.3791, 5.0, -1, -1, -1, 100.0); // Bike Challenge Reward
CreateDynamicCP(3896.1235,3884.3840,184.7534, 12.0, -1, -1, -1, 100.0); // SkyDive1 Reward
CreateDynamicCP(-1278.9248,-34.3641,1122.3420, 12.0, -1, -1, -1, 100.0); // SkyDive2 Reward

// Refill Stations
CreateDynamicCP(2199.9460,2474.7231,10.8203, 3.0, -1, -1, -1, 100.0); //
CreateDynamicCP(1596.1165,2196.8958,10.8203, 3.0, -1, -1, -1, 100.0); //
CreateDynamicCP(2116.7163,922.6126,10.8203, 3.0, -1, -1, -1, 100.0); //
CreateDynamicCP(2637.9185,1103.4926,10.8203, 3.0, -1, -1, -1, 100.0); //

// Robbery Locations
CreateDynamicCP(2097.5847,2224.0974,11.0234, 3.0, -1, -1, -1, 100.0); //24/7
CreateDynamicCP(2194.4106,1990.7670,12.2969, 3.0, -1, -1, -1, 100.0); // 24/7 2
CreateDynamicCP(2167.2432,2114.3831,10.8203, 3.0, -1, -1, -1, 100.0); // Casino
CreateDynamicCP(2159.0449,943.1320,10.8203, 3.0, -1, -1, -1, 100.0); // Ammunation

CreateDynamic3DTextLabel("24/7", COLOR_ORANGE, 2097.5847,2224.0974,11.0234, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("24/7", COLOR_ORANGE, 2194.4106,1990.7670,12.2969, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("Casino", COLOR_ORANGE, 2167.2432,2114.3831,10.8203, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("Ammunation", COLOR_ORANGE, 2159.0449,943.1320,10.8203, 80.0, .testlos = 1);

// Exits
CreateDynamicCP(-31.0415,-92.0112,1003.5469, 2.0, -1, -1, -1, 50.0); //24/7
CreateDynamicCP(-25.4077,-188.2529,1003.5469, 2.0, -1, -1, -1, 50.0); // 24/7 2
CreateDynamicCP(1132.9701,-14.2267,1000.6797, 2.0, -1, -1, -1, 50.0); // Casino
CreateDynamicCP(286.1115,-41.6959,1001.5156, 2.0, -1, -1, -1, 50.0); // Ammunation

CreateDynamicCP(294.4077,-38.3232,1001.5156, 2.0, -1, -1, -1, 50.0); // Ammunation Menu

CreateDynamicCP(2297.6804,2466.7480,3.2734, 2.0, -1, -1, -1, 50.0); // PD Refill
CreateDynamicCP(1291.7106,2672.7725,11.2392, 2.0, -1, -1, -1, 50.0); // Robber Refill
CreateDynamic3DTextLabel("LVPD Refill", COLOR_BLUE, 2297.6804,2466.7480,3.2734, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Robber Refill", COLOR_ORANGE, 1291.7106,2672.7725,11.2392, 60.0, .testlos = 1);

CreateDynamicCP(3257.1375,-1835.1937,170.1105, 3.0, -1, -1, -1, 100.0); // BMX Reward

CreateDynamicCP(2287.0718,2432.3665,10.8203, 2.0, -1, -1, -1, 75.0); // PD Entrance
CreateDynamicCP(238.7167,138.6336,1003.0234, 2.0, -1, -1, -1, 75.0); // PD Exit

CreateDynamicCP(2271.0574,2293.2908,10.8203, 2.0, -1, -1, -1, 75.0); // Roca Escalente Bank
CreateDynamicCP(2355.3020,1544.3804,10.8203, 2.0, -1, -1, -1, 75.0); // LV Bank
CreateDynamicCP(2305.3713,-16.0632,26.7496, 2.0, -1, -1, -1, 75.0); // Roca/LV Bank Exit

CreateDynamicCP(2019.7651,1007.6656,10.8203, 2.0, -1, -1, -1, 75.0); // 4D Casino
CreateDynamicCP(2019.0719,1017.8808,996.8750, 2.0, -1, -1, -1, 75.0); // 4D Exit

CreateDynamicCP(2089.7944,1514.4180,10.8203, 2.0, -1, -1, -1, 75.0); // Royal Casino
CreateDynamicCP(2539.2773,2083.7363,10.8203, 2.0, -1, -1, -1, 75.0); // Ammunation

CreateDynamicCP(2196.8345,1677.1240,12.3672, 2.0, -1, -1, -1, 75.0); // Caligulas Casino
CreateDynamicCP(2234.1003,1714.3649,1012.3828, 2.0, -1, -1, -1, 75.0); // Caligulas Exit

CreateDynamicCP(1391.6522,2693.8896,10.8203, 1.5, -1, -1, -1, 75.0); // Robbers Gate
CreateDynamicCP(1400.9669,2685.9114,10.8203, 1.5, -1, -1, -1, 75.0); // Robbers Gate

CreateDynamicCP(414.1409,2469.6448,16.9303, 1.5, -1, -1, -1, 75.0); // Cheetah PC

CreateDynamicCP(-1550.4073,1168.7106,7.1875, 2.0, -1, -1, -1, 75.0); // Bank
CreateDynamicCP(-2455.3555,503.9716,30.0781, 2.0, -1, -1, -1, 75.0); // Bank
CreateDynamicCP(1877.7257,-1737.5585,13.3501, 2.0, -1, -1, -1, 75.0); // Bank
CreateDynamicCP(1550.1409,-1790.7477,15.2916, 2.0, -1, -1, -1, 75.0); // Bank
CreateDynamicCP(1462.5692,-1010.9126,26.8438, 2.0, -1, -1, -1, 75.0); // Bank
CreateDynamicCP(1498.3008,-1581.9375,13.5498, 2.0, -1, -1, -1, 75.0); // Bank
CreateDynamicCP(368.8708,2580.0532,16.9099, 2.0, -1, -1, -1, 75.0); // Bank

CreateDynamicCP(2315.8379,-4.8086,26.7422, 1.5, -1, -1, -1, 75.0); // Bank Inside Checkpoint


// Map Icons
CreateDynamicMapIcon(314.0212,2527.3538,16.9800, 38, 0, -1, -1, -1, 250); //AA
CreateDynamicMapIcon(2101.0896,-2634.5125,13.5803, 38, 0, -1, -1, -1, 250); //LSAIR
CreateDynamicMapIcon(-2345.8896,-1619.8459,483.8803, 38, 0, -1, -1, -1, 250); //CHILLIAD
CreateDynamicMapIcon(-1176.9082,31.2369,14.3903, 38, 0, -1, -1, -1, 250); //SFAIR
CreateDynamicMapIcon(-2636.6479,1394.6975,7.1016, 38, 0, -1, -1, -1, 250); //SF
CreateDynamicMapIcon(2124.5210,1683.1649,10.5078, 38, 0, -1, -1, -1, 250); //LV
CreateDynamicMapIcon(436.4680,3247.7400,739.6344, 38, 0, -1, -1, -1, 250); //AAJUMP
CreateDynamicMapIcon(1307.9390,2673.0037,11.2392, 23, 0, -1, -1, -1, 400); //Robber Base
CreateDynamicMapIcon(2282.3904,2457.2788,10.8203, 30, 0, -1, -1, -1, 400); //PD BASE
CreateDynamicMapIcon(1318.7045,1250.7703,10.8268, 30, 0, -1, -1, -1, 400); //PD BASE LVAIR

//Stores
CreateDynamicMapIcon(2539.3477,2081.2295,10.8203, 6, 0, -1, -1, -1, 200); //Ammunation 1
CreateDynamicMapIcon(2159.0449,943.1320,10.8203, 6, 0, -1, -1, -1, 200); //Ammunation 2
CreateDynamicMapIcon(2097.5847,2224.0974,11.0234, 49, 0, -1, -1, -1, 200); //24/7 1
CreateDynamicMapIcon(2194.4106,1990.7670,12.2969, 49, 0, -1, -1, -1, 200); //24/7 2
CreateDynamicMapIcon(2196.8345,1677.1240,12.3672, 25, 0, -1, -1, -1, 200); //Caligulas
CreateDynamicMapIcon(2019.7651,1007.6656,10.8203, 25, 0, -1, -1, -1, 200); //4D
CreateDynamicMapIcon(2167.2432,2114.3831,10.8203, 25, 0, -1, -1, -1, 200); //Other Casino
CreateDynamicMapIcon(2271.0574,2293.2908,10.8203, 52, 0, -1, -1, -1, 200); //Bank
CreateDynamicMapIcon(2355.3020,1544.3804,10.8203, 52, 0, -1, -1, -1, 200); //Bank 2

CreateDynamicMapIcon(-1550.4073,1168.7106,7.1875, 52, 0, -1, -1, -1, 200); //Bank
CreateDynamicMapIcon(-2455.3555,503.9716,30.0781, 52, 0, -1, -1, -1, 200); //Bank
CreateDynamicMapIcon(1877.7257,-1737.5585,13.3501, 52, 0, -1, -1, -1, 200); //Bank
CreateDynamicMapIcon(1550.1409,-1790.7477,15.2916, 52, 0, -1, -1, -1, 200); //Bank
CreateDynamicMapIcon(1462.5692,-1010.9126,26.8438, 52, 0, -1, -1, -1, 200); //Bank
CreateDynamicMapIcon(1498.3008,-1581.9375,13.5498, 52, 0, -1, -1, -1, 200); //Bank
CreateDynamicMapIcon(368.8708,2580.0532,16.9099, 52, 0, -1, -1, -1, 200); //Bank

CreateDynamicMapIcon(2225.7664,1838.6151,10.8203, 48, 0, -1, -1, -1, 200); // RPC 1
CreateDynamicMapIcon(-26.1917,2531.7217,17.4203, 48, 0, -1, -1, -1, 200); // RPC 2
CreateDynamicMapIcon(-2624.0850,1411.7439,7.0938, 48, 0, -1, -1, -1, 200); // RPC 3


// 3D Text Labels
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, -2339.4851,-1604.3956,483.7069, 70.0, .testlos = 1); //chill
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, 392.4084,2451.4614,17.0703, 30.0, .testlos = 1); //aa1
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, 376.9973,2532.1228,16.9003, 50.0, .testlos = 1); //aa2
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, 1316.5116,1282.1577,10.8203, 50.0, .testlos = 1); //aa3
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, -1183.0519,24.5742,14.3903, 50.0, .testlos = 1); //sfair
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, -2646.0896,1380.1772,7.1684, 50.0, .testlos = 1); //sf
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, 2161.8206,1671.8610,10.8203, 50.0, .testlos = 1); //lv
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, 2506.0498,-1675.2979,13.1480, 50.0, .testlos = 1); //lsair
CreateDynamic3DTextLabel(""LG_E"Teleport Menu"PINK_E"(/tele)", COLOR_WHITE, 429.4098,3236.1636,739.8063, 50.0, .testlos = 1); //AAJUMP

CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, -2302.5461,-1636.9451,483.6979, 40.0, .testlos = 1); //chill
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, 332.9260,2531.7275,16.8040, 40.0, .testlos = 1); //aa1
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, -1196.1881,16.9466,14.3903, 40.0, .testlos = 1); //sfair
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, -2617.6138,1365.4655,7.0502, 40.0, .testlos = 1); //sf
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, 2162.0547,1682.8297,10.8203, 40.0, .testlos = 1); //lv
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, 2091.9294,-2598.9846,13.5469, 40.0, .testlos = 1); //lsair
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, 400.1298,2451.9253,17.0703, 40.0, .testlos = 1); //AAGarage
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, -2662.8435,1349.7847,17.0603, 40.0, .testlos = 1); //SF
CreateDynamic3DTextLabel(""LB_E"Vehicle Menu"PINK_E"(/v)", COLOR_WHITE, 421.9639,3245.4871,739.6420, 40.0, .testlos = 1); //AAJUMP

CreateDynamic3DTextLabel(""ORANGE_E"Bar", COLOR_WHITE, -3957.7227,1312.4315,2.2741, 60.0, .testlos = 1); //Bar
CreateDynamic3DTextLabel(""ORANGE_E"Bar", COLOR_WHITE, 602.7739,-1520.6984,15.1956, 60.0, .testlos = 1); //Bar

CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"Abandoned Airport", COLOR_WHITE, 386.7054,2532.3589,17.0703, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"AA Jump", COLOR_WHITE, 418.5897,3199.0986,739.8063, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"Los Santos Airport", COLOR_WHITE, 2100.1575,-2598.9028,13.5469, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"Mount Chilliad", COLOR_WHITE, -2340.5293,-1624.4954,483.8803, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"Las Venturas", COLOR_WHITE, 2170.7761,1678.0466,10.8803, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"San Fierro", COLOR_WHITE, -2617.1680,1384.0463,7.1911, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"San Fierro Airport", COLOR_WHITE, -1231.4115,30.2661,14.3903, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("["LB2_E"SFE"WHITE_E"]\n"GREEN_E"Las Venturas Airport", COLOR_WHITE, 1319.8982,1312.0378,10.8268, 80.0, .testlos = 1);
CreateDynamic3DTextLabel("LVPD", COLOR_LIGHTBLUE, 2287.0718,2432.3665,10.8203, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Bank", COLOR_GREEN, 2271.0574,2293.2908,10.8203, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Bank", COLOR_GREEN, 2355.3020,1544.3804,10.8203, 60.0, .testlos = 1);

CreateDynamic3DTextLabel("Bank", COLOR_GREEN, -1550.4073,1168.7106,7.1875, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Bank", COLOR_GREEN, -2455.3555,503.9716,30.0781, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Bank", COLOR_GREEN, 1550.1409,-1790.7477,15.2916, 60.0, .testlos = 1);

CreateDynamic3DTextLabel("Bank", COLOR_GREEN, 1877.7257,-1737.5585,13.3501, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Bank", COLOR_GREEN, 1462.5692,-1010.9126,26.8438, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Bank", COLOR_GREEN, 1498.3008,-1581.9375,13.5498, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Bank", COLOR_GREEN, 368.8708,2580.0532,16.9099, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("4 Dragons", COLOR_ORANGE, 2019.7651,1007.6656,10.8203, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Royal Casino", COLOR_PINK, 2089.7944,1514.4180,10.8203, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Ammunation", COLOR_ORANGE, 2539.2773,2083.7363,10.8203, 60.0, .testlos = 1);

CreateDynamic3DTextLabel("Open Gate", COLOR_ORANGE, 1391.6522,2693.8896,10.8203, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Open Gate", COLOR_ORANGE, 1400.9669,2685.9114,10.8203, 60.0, .testlos = 1);
CreateDynamic3DTextLabel("Cheetah", COLOR_ORANGE, 414.1409,2469.6448,16.9303, 60.0, .testlos = 1);

CreateDynamic3DTextLabel("Dive", COLOR_WHITE, 402.3224,2530.8486,16.9003, 65.0, .testlos = 1);
CreateDynamic3DTextLabel("Dive", COLOR_WHITE, -2630.8696,1399.9384,7.0938, 65.0, .testlos = 1);
CreateDynamic3DTextLabel("Dive", COLOR_WHITE, 418.8626,2440.7043,16.9800, 65.0, .testlos = 1);
CreateDynamic3DTextLabel("Dive", COLOR_WHITE, 2093.9438,-2634.3557,13.5803, 65.0, .testlos = 1);
CreateDynamic3DTextLabel("Dive", COLOR_WHITE, -2299.0886,-1626.4368,483.8803, 65.0, .testlos = 1);
CreateDynamic3DTextLabel("Dive", COLOR_WHITE, -1224.6686,49.1064,14.3903, 65.0, .testlos = 1);

// GangZones
Zone[0] = GangZoneCreate(156,2436,432,2610); // AA
Zone[1] = GangZoneCreate(1908,-2646,2142,-2442); // LSAir
Zone[2] = GangZoneCreate(-2472,-1788,-2148,-1470); // Chilliad
Zone[3] = GangZoneCreate(-2748,1284,-2568,1506); // SF
Zone[4] = GangZoneCreate(-1350,-54,-1140,96); // SFAir
Zone[5] = GangZoneCreate(2064,1536,2208,1776); // LV
Zone[6] = GangZoneCreate(36,1776,420,2118); // WAR
Create_TextDraws();

LoadHouses(); // Load houses

// Skins
AddPlayerClass(23 , 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0); //0
AddPlayerClass(291, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//1
AddPlayerClass(293, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//2
AddPlayerClass(0, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//3
AddPlayerClass(29, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//4
AddPlayerClass(292, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//5
AddPlayerClass(264, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//6
AddPlayerClass(297, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//7
AddPlayerClass(289, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //8 Zero
AddPlayerClass(290, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //9
AddPlayerClass(295, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //10
AddPlayerClass(298, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //11
AddPlayerClass(119, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //12
AddPlayerClass(270, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //13
AddPlayerClass(271, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //14
AddPlayerClass(149, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //15
AddPlayerClass(1, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //16
AddPlayerClass(2, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //17
AddPlayerClass(4, -2672.5156, 1354.6123, 16.9978, 105.0531, 0, 0, 0, 0, 0, 0); //18
AddPlayerClass(193, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//19
AddPlayerClass(152, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//20
AddPlayerClass(181, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//21
AddPlayerClass(285, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//22
AddPlayerClass(287, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//23
AddPlayerClass(294, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//24
AddPlayerClass(296, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//25
AddPlayerClass(98, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//26
AddPlayerClass(82, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//27
AddPlayerClass(84, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//28
AddPlayerClass(126, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//29
AddPlayerClass(171, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//30
AddPlayerClass(177, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//31
AddPlayerClass(180, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//32
AddPlayerClass(100, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//33
AddPlayerClass(99, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//34
AddPlayerClass(211, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//35
AddPlayerClass(217, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//36
AddPlayerClass(299, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//37
AddPlayerClass(167, 402.8499, 2552.1418, 20.3837, 0, 0, 0, 0, 0, 0, 0);//38

// Variables that need to be reset.
NumCageFighters = 0;
DerbyPlayers = 0;
NumCurrentFighters = 0;
CageFight = 0;
CurrentPos = 0;
CageFightOn = 0;
CurrentPosOn = 0;
EventGoingOn = 0;
EventStarted = 0;

// Load Skins
skinlist = LoadModelSelectionMenu("skins.txt");

// Static Objects.
CreateObject(18759, 2736.0537109375, -1765.4870605469, 78.151954650879, 0, 0, 0); // Event Cage
CreateObject(13657, -3676.96, -688.71, 12.10, 0.00, 0.00, 180.00); // TDM Floor
CreateObject(18856, 405.11, 2473.77, 36.19, 0.00, 0.00, 0.41); // Jail
CreateObject(986, 1385.98, 2643.14, 11.81, 0.00, 0.00, 90.13); // Robbers Gate
Gate[0] = CreateObject(976, 1397.24, 2694.51, 9.91, 0.00, 0.00, 269.23);
Gate[1] = CreateObject(976, 1397.24, 2693.86, 9.91, 0.00, 0.00, 90.07);

SetTimer("Maths", 400000, true);
SetTimer("MoneyBag", 320000, true);
SetTimer("RaceRotation", 300000, true);
SetTimer("ReactionTest", 290000, true);
SetTimer("RandMsgs", 45000, true);
SetTimer("onlineTimer", 1000, true);
SetTimer("SETimer", 500, true);

print("\n - - - - - - - - - - - - - - - - - - - ");
print("\n StunT Freeroam Evolution[0.3x] ");
print("\n (C) 2013 - Build 1337! ");
print("\n - - - - - - - - - - - - - - - - - - - ");

// Load IRC
IRC_SetUp();

// Load Vehicles
SE_vehicles();

// Display some info
printf("> Number of objects loaded: %d", CountDynamicObjects());
new tmpVeh;
tmpVeh = CreateVehicle(411, 0.0, 0.0, -100.0, 0.0, 0, 0, -1);
DestroyVehicle(tmpVeh);
printf("> Number of vehicles loaded: %d", (tmpVeh-1));
for (ii = 0; ii != MAX_VEHICLES; ++ii)
{
SetVehicleNumberPlate(ii, ""BLUE_E"SFE"RED_E"v2");
}
return true;
}

Vince
07/03/2016, 11:45 AM
Oh, FFS, read SickAttack's first post again. Also external databases are extremely slow. Be prepared to have an extremely laggy gamemode.

SsHady
07/03/2016, 11:51 AM
Ugh! I don't seem to understand SickAttack's first post! can you please demonstrate it!? I edited my code according to this reply! still no luck

ctopha
07/03/2016, 12:02 PM
I think that there is another configuration to mysql i think it is inside any filterscript
Or any file, just search for it well

SsHady
07/03/2016, 12:48 PM
It is not present inside the main GM or any other FS!
It is present in the directory same as samp-server.exe in the file named "mysql.cfg"
but it is saying that "Cannot connect to DB" whereas the Configuration is correct!

Vince
07/03/2016, 01:01 PM
Ugh! I don't seem to understand SickAttack's first post! can you please demonstrate it!? I edited my code according to this reply! still no luck

Literally all you had to do was copy one of those lines. Yet your code is still the same as in your first post. This is just mind bogging stupidity.

SsHady
07/03/2016, 01:12 PM
Edited mine to this
if(!mysql_ping())
{
printf("================ [ERROR] ================");
printf("Connection to MySQL failed.");
SendRconCommand("exit");
return 1;
}

Still not connecting!

ctopha
07/03/2016, 01:17 PM
Are you sure that you write the right details?

SsHady
07/03/2016, 01:20 PM
Yes they're working in another GM but not in this one! As I saw on wiki the mysql queries also have a variable of their mysql database like this
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `Username` = '%e' LIMIT 1", Name[playerid]);
but mine skips the connection handle
mysql_function_query(query, false, "NoReturnQuery", "");

ctopha
07/03/2016, 02:04 PM
I think it is because of your old mysql, try to update the queries

SsHady
08/03/2016, 05:02 AM
Bumping as the day has passed and the new day has arived!
Still no luck with it! any kind of help would really be appreciated and +2 rep