18.05.2013, 18:50
Hello,
I have bought a VPS and I tried to start my script but I discovered that it is not loading the vehicles/houses/factions bans etc...
I use BlueG R7, and my VPS is linux Cent OS.
What can be the problem? Is there something wrong with the plugins or is it the script?
On my Windows7 Localhost it all worked fine...
I have bought a VPS and I tried to start my script but I discovered that it is not loading the vehicles/houses/factions bans etc...
pawn Код:
stock InitFactions()
{
new query[400];
for(new id; id < MAX_FACTIONS; id++) // Goes through all the slots, looking for the data
{
format(query, sizeof(query), "SELECT * FROM `Factions` WHERE `FactionID` = %d", id); // Selects all the information from the table
mysql_function_query(g_connectionHandle, query, true, "LoadFactionsCallback", "d", id);
}
return 1;
}
stock InitVehicles()
{
new query[400];
for(new id; id < MAX_VEHICLES; id++) // Goes through all the slots, looking for the data
{
format(query, sizeof(query), "SELECT * FROM `Vehicles` WHERE `CarFileID` = %d", id); // Selects all the information from the table
mysql_function_query(g_connectionHandle, query, true, "LoadVehiclesCallback", "d", id);
}
return 1;
}
stock InitHouses()
{
new query[400];
for(new id; id < MAX_HOUSES; id++) // Goes through all the slots, looking for the data
{
format(query, sizeof(query), "SELECT * FROM `Houses` WHERE `HouseID` = %d", id); // Selects all the information from the table
mysql_function_query(g_connectionHandle, query, true, "LoadHousesCallback", "d", id);
}
return 1;
}
public LoadFactionsCallback(factionid)
{
new
rows,
fields;
cache_get_data(rows, fields);
if(rows == 1)
{
new temp[50];
cache_get_row(0, 0, temp); // #0 = #1 in the DB
Factions[factionid][FactionID] = strval(temp);
cache_get_row(0, 1, Factions[factionid][FactionName]);
cache_get_row(0, 2, temp);
Factions[factionid][CommandTypes] = strval(temp);
cache_get_row(0, 3, Factions[factionid][RankName1]);
cache_get_row(0, 4, Factions[factionid][RankName2]);
cache_get_row(0, 5, Factions[factionid][RankName3]);
cache_get_row(0, 6, Factions[factionid][RankName4]);
cache_get_row(0, 7, Factions[factionid][RankName5]);
cache_get_row(0, 8, Factions[factionid][RankName6]);
cache_get_row(0, 9, Factions[factionid][RankName7]);
cache_get_row(0, 10, temp);
Factions[factionid][Skin1] = strval(temp);
cache_get_row(0, 11, temp);
Factions[factionid][Skin2] = strval(temp);
cache_get_row(0, 12, temp);
Factions[factionid][Skin3] = strval(temp);
cache_get_row(0, 13, temp);
Factions[factionid][Skin4] = strval(temp);
cache_get_row(0, 14, temp);
Factions[factionid][Skin5] = strval(temp);
cache_get_row(0, 15, temp);
Factions[factionid][Skin6] = strval(temp);
cache_get_row(0, 16, temp);
Factions[factionid][Skin7] = strval(temp);
cache_get_row(0, 17, temp);
Factions[factionid][HQInteriorID] = strval(temp);
cache_get_row(0, 18, temp);
Factions[factionid][HQInteriorX] = floatstr(temp);
cache_get_row(0, 19, temp);
Factions[factionid][HQInteriorY] = floatstr(temp);
cache_get_row(0, 20, temp);
Factions[factionid][HQInteriorZ] = floatstr(temp);
cache_get_row(0, 21, temp);
Factions[factionid][HQInteriorA] = floatstr(temp);
cache_get_row(0, 22, temp);
Factions[factionid][HQExteriorID] = strval(temp);
cache_get_row(0, 23, temp);
Factions[factionid][HQExteriorX] = floatstr(temp);
cache_get_row(0, 24, temp);
Factions[factionid][HQExteriorY] = floatstr(temp);
cache_get_row(0, 25, temp);
Factions[factionid][HQExteriorZ] = floatstr(temp);
cache_get_row(0, 26, temp);
Factions[factionid][HQExteriorA] = floatstr(temp);
cache_get_row(0, 27, temp);
Factions[factionid][SafeInteriorID] = strval(temp);
cache_get_row(0, 28, temp);
Factions[factionid][SafeX] = floatstr(temp);
cache_get_row(0, 29, temp);
Factions[factionid][SafeY] = floatstr(temp);
cache_get_row(0, 30, temp);
Factions[factionid][SafeZ] = floatstr(temp);
cache_get_row(0, 31, temp);
Factions[factionid][SafeWorld] = strval(temp);
cache_get_row(0, 32, temp);
Factions[factionid][HQLock] = strval(temp);
cache_get_row(0, 33, Factions[factionid][FOwner]);
Factions[factionid][HQExteriorPickupID] = CreateObject(1559,Factions[factionid][HQExteriorX],Factions[factionid][HQExteriorY],Factions[factionid][HQExteriorZ]+0.700, 0,0,0,250.0);
Factions[factionid][HQInteriorPickupID] = CreatePickup(1314,1,Factions[factionid][HQInteriorX],Factions[factionid][HQInteriorY],Factions[factionid][HQInteriorZ], 45000+factionid);
Factions[factionid][SafePickupID] = CreateDynamicPickup(1274, 23, Factions[factionid][SafeX], Factions[factionid][SafeY], Factions[factionid][SafeZ],Factions[factionid][SafeWorld], -1, -1, 150.0);
printf("[System] Faction %d with faction name: %s spawned.", factionid, Factions[factionid][FactionName]);
}
return 1;
}
public LoadVehiclesCallback(vehicleid)
{
new
rows,
fields;
cache_get_data(rows, fields);
if(rows == 1)
{
new temp[50];
cache_get_row(0, 0, temp); // #0 = #1 in the DB
Vehicles[vehicleid][CarFileID] = strval(temp);
cache_get_row(0, 2, temp);
Vehicles[vehicleid][ModelID] = strval(temp);
cache_get_row(0, 3, temp);
Vehicles[vehicleid][Color1] = strval(temp);
cache_get_row(0, 4, temp);
Vehicles[vehicleid][Color2] = strval(temp);
cache_get_row(0, 5, temp);
Vehicles[vehicleid][VPosX] = floatstr(temp);
cache_get_row(0, 6, temp);
Vehicles[vehicleid][VPosY] = floatstr(temp);
cache_get_row(0, 7, temp);
Vehicles[vehicleid][VPosZ] = floatstr(temp);
cache_get_row(0, 8, temp);
Vehicles[vehicleid][VPosAngle] = floatstr(temp);
cache_get_row(0, 9, temp);
Vehicles[vehicleid][LockStatus] = strval(temp);
cache_get_row(0, 10, temp);
Vehicles[vehicleid][FactionCar] = strval(temp);
cache_get_row(0, 11, Vehicles[vehicleid][VOwner]);
cache_get_row(0, 12, Vehicles[vehicleid][VPlate]);
cache_get_row(0, 13, temp);
Vehicles[vehicleid][VehicleWorld] = strval(temp);
cache_get_row(0, 14, temp);
Vehicles[vehicleid][VehicleInteriorID] = strval(temp);
cache_get_row(0, 15, temp);
Vehicles[vehicleid][SpeedoColor] = strval(temp);
Vehicles[vehicleid][VehicleID] = AddStaticVehicleEx(Vehicles[vehicleid][ModelID], Vehicles[vehicleid][VPosX], Vehicles[vehicleid][VPosY], Vehicles[vehicleid][VPosZ], Vehicles[vehicleid][VPosAngle], Vehicles[vehicleid][Color1], Vehicles[vehicleid][Color2], -1);
SetVehicleVirtualWorld(Vehicles[vehicleid][VehicleID], Vehicles[vehicleid][VehicleWorld]);//set vw
LinkVehicleToInterior(Vehicles[vehicleid][VehicleID], Vehicles[vehicleid][VehicleInteriorID]);//set int
SetVehicleNumberPlate(Vehicles[vehicleid][VehicleID], Vehicles[vehicleid][VPlate]);
Vehicles[vehicleid][Fuel] = 100;
Vehicles[vehicleid][Battery] = 100;
new query[500];
format(query, sizeof(query), "UPDATE `Vehicles` SET `VehicleID` = %d WHERE `CarFileID` = %d", Vehicles[vehicleid][VehicleID], vehicleid);
mysql_function_query(g_connectionHandle, query, false, "DefaultCallback", "");
printf("[System] Vehicle %d has been succesfully spawned!", vehicleid);
SpawnedVehicles++;
}
return 1;
}
public LoadHousesCallback(houseid)
{
new
rows,
fields;
cache_get_data(rows, fields);
if(rows == 1)
{
new temp[50];
cache_get_row(0, 0, temp); // #0 = #1 in the DB
Houses[houseid][HouseID] = strval(temp);
cache_get_row(0, 1, temp);
Houses[houseid][hInteriorID] = strval(temp);
cache_get_row(0, 2, temp);
Houses[houseid][hInteriorX] = floatstr(temp);
cache_get_row(0, 3, temp);
Houses[houseid][hInteriorY] = floatstr(temp);
cache_get_row(0, 4, temp);
Houses[houseid][hInteriorZ] = floatstr(temp);
cache_get_row(0, 5, temp);
Houses[houseid][hInteriorA] = floatstr(temp);
cache_get_row(0, 6, temp);
Houses[houseid][hExteriorID] = strval(temp);
cache_get_row(0, 7, temp);
Houses[houseid][hExteriorX] = floatstr(temp);
cache_get_row(0, 8, temp);
Houses[houseid][hExteriorY] = floatstr(temp);
cache_get_row(0, 9, temp);
Houses[houseid][hExteriorZ] = floatstr(temp);
cache_get_row(0, 10, temp);
Houses[houseid][hExteriorA] = floatstr(temp);
cache_get_row(0, 11, temp);
Houses[houseid][hSpawnID] = strval(temp);
cache_get_row(0, 12, temp);
Houses[houseid][hSpawnX] = floatstr(temp);
cache_get_row(0, 13, temp);
Houses[houseid][hSpawnY] = floatstr(temp);
cache_get_row(0, 14, temp);
Houses[houseid][hSpawnZ] = floatstr(temp);
cache_get_row(0, 15, temp);
Houses[houseid][hSpawnA] = floatstr(temp);
cache_get_row(0, 16, Houses[houseid][hOwner]);
cache_get_row(0, 17, Houses[houseid][hAddress]);
cache_get_row(0, 18, temp);
Houses[houseid][HousePrice] = strval(temp);
cache_get_row(0, 19, temp);
Houses[houseid][hLockStatus] = strval(temp);
cache_get_row(0, 20, Houses[houseid][hType]);
cache_get_row(0, 21, temp);
Houses[houseid][LastLoginDay] = strval(temp);
cache_get_row(0, 22, temp);
Houses[houseid][LastLoginMonth] = strval(temp);
cache_get_row(0, 23, temp);
Houses[houseid][LastLoginYear] = strval(temp);
if(strcmp(Houses[houseid][hOwner], "Nobody", true) == 0)
{
Houses[houseid][hLockStatus] = 1;
Houses[houseid][HPickupID] = CreatePickup(1273, 23, Houses[houseid][hExteriorX], Houses[houseid][hExteriorY], Houses[houseid][hExteriorZ], 0);
}
else
{
Houses[houseid][HPickupID] = CreateObject(1559,Houses[houseid][hExteriorX],Houses[houseid][hExteriorY],Houses[houseid][hExteriorZ]+0.700, 0,0,0,250.0);
}
printf("[System] House %d has been succesfully spawned!", houseid);
SpawnedHouses++;
}
/*if(rows == 0) return print("Error -> Empty Houses Database!");
if(rows > MAX_HOUSES) return print("Error -> Too Many Data Row! [Houses DB]");*/
return 1;
}
public OnGameModeInit()
{
mysql_debug(SQL_DEBUG);
//mysql_log(LOG_ERROR | LOG_WARNING);
g_connectionHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
if(mysql_ping() == 1) print(" * Connecting to MySQL: Success"); //Als mysql_ping gelijk staat aan 1 betekent dat dat er connectie is.
else print(" x [ERROR] Connecting to MySQL: Failed"); //Zo niet, dan niet :O!
Streamer_VisibleItems(STREAMER_TYPE_OBJECT, 1000);
SetGameModeText(""#SCRIPT_MODE" "#SCRIPT_VERSION"");
EnableStuntBonusForAll(0);
DisableInteriorEnterExits();
ManualVehicleEngineAndLights();
ShowPlayerMarkers(0);
InitFactions();
InitVehicles();
InitHouses();
LoadObjects();
FadeInit();
}
return 1;
}
What can be the problem? Is there something wrong with the plugins or is it the script?
On my Windows7 Localhost it all worked fine...