MySQL connection issue - Printable Version

MySQL connection issue - 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 connection issue (/showthread.php?tid=602436)

MySQL connection issue - SsHady - 07.03.2016

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

Re: MySQL connection issue - SickAttack - 07.03.2016

1 if alive, 0 if dead.

1 if alive!

Use:

Quote:

if(!mysql_ping())

Or (which is the same thing as above):

Quote:

if(mysql_ping() == 0)

Re: MySQL connection issue - SsHady - 07.03.2016

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;
	}

Re: MySQL connection issue - SickAttack - 07.03.2016

Then it's not connecting!

The connection (log on) details are incorrect.

Re: MySQL connection issue - SsHady - 07.03.2016

Ugh! It is correct! maybe the port is wrong! I'll check it! and will reply!
Thanks for your help! +2

Re: MySQL connection issue - SsHady - 07.03.2016

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      	© 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;
}

Re: MySQL connection issue - Vince - 07.03.2016

Oh, FFS, read SickAttack's first post again. Also external databases are extremely slow. Be prepared to have an extremely laggy gamemode.

Re: MySQL connection issue - SsHady - 07.03.2016

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

Re: MySQL connection issue - ctopha - 07.03.2016

I think that there is another configuration to mysql i think it is inside any filterscript
Or any file, just search for it well

Re: MySQL connection issue - Vince - 07.03.2016

Quote:

Originally Posted by SsHady

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.