Gamemod doesn't connect to the database
#4

Well, my OnGameModeInit code looks like this:
Код:
if(mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS)) print("Mysql Connected");
else print("Mysql Failed To Connected");
	print("tick");
	#if DEBUG 1
		format(debugs,256,"DEBUG | OngameModeInit start.");
		debugLog(debugs);
	#endif
	/*admintext = TextDrawCreate(1.000000,430.000000,"crap");
	TextDrawAlignment(admintext,0);
	TextDrawBackgroundColor(admintext,0x000000ff);
	TextDrawFont(admintext,3);
	TextDrawLetterSize(admintext,0.500000,1.000000);
	TextDrawColor(admintext,0xffffff99);
	TextDrawSetOutline(admintext,1);
	TextDrawSetProportional(admintext,1);
	TextDrawSetShadow(admintext,2);*/
	
	//ShowPlayerMarkers(false);
	SetGameModeText(scriptVersion);
    AddPlayerClass(0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0);
	mysql_debug(1);
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
 	new string[MAX_STRING1];
	format(String,256,"TRUNCATE TABLE `donated`");
	mysql_query(String);
	format(String,256,"TRUNCATE TABLE `drugpos`");
	mysql_query(String);
	format(String,256,"UPDATE `users` SET  `online`='0'");
	mysql_query(String);
	format(String,256,"UPDATE `objects` SET `state`='0'");
	mysql_query(String);
	carmenu = CreateMenu("Private Car Menu:", 1, 200.0, 100.0, 150.0, 150.0);
	SetMenuColumnHeader(carmenu,0,"Select:");
	AddMenuItem(carmenu,0,"Lock vehicle.");
	AddMenuItem(carmenu,0,"Unlock vehicle.");
	AddMenuItem(carmenu,0,"Purchase locks.");
	AddMenuItem(carmenu,0,"Repaint your vehicle.");
	AddMenuItem(carmenu,0,"Buy a GPS system.");
	AddMenuItem(carmenu,0,"Install Tinted Windows.");
	AddMenuItem(carmenu,0,"Repark your vehicle.");
	AddMenuItem(carmenu,0,"Sell vehicle.");
	semicarmenu=CreateMenu("faction/job Car Menu:", 1, 200.0, 100.0, 150.0, 150.0);
	SetMenuColumnHeader(semicarmenu,0,"Select:");
	AddMenuItem(semicarmenu,0,"Park vehicle.");
	AddMenuItem(semicarmenu,0,"Delete vehicle.");
	lockmenu= CreateMenu("Locks Menu:",2, 200.0, 100.0, 150.0, 150.0);
	SetMenuColumnHeader(lockmenu,0,"Lock Name:");
	SetMenuColumnHeader(lockmenu,1,"Price:");
	for(new i=0;i<sizeof(locks);i++)
	{
	    AddMenuItem(lockmenu,0,locks[i][lockname]);
		format(string,MAX_STRING1,"%d",locks[i][lockprice],100-locks[i][percents]);
		AddMenuItem(lockmenu,1,string);
	}
	carcolor= CreateMenu("Colors Menu:",1,200.0, 100.0, 150.0, 150.0);
	SetMenuColumnHeader(carcolor,0,"Select:");
	AddMenuItem(carcolor,0,"Black");
	AddMenuItem(carcolor,0,"White");
	AddMenuItem(carcolor,0,"Red");
	AddMenuItem(carcolor,0,"Green");
	AddMenuItem(carcolor,0,"Blue");
	AddMenuItem(carcolor,0,"Orange");
	AddMenuItem(carcolor,0,"Purple");
	AddMenuItem(carcolor,0,"Pink");
	new hour,mins,secs;
	gettime(hour,mins,secs);
	AllowAdminTeleport(1); // ray tp
	//new File:hFile;
//---------------------------/eatmenu-------------------------------------------
    eatmenu = CreateMenu("Food", 1, 200.0, 100.0, 150.0, 150.0);
	SetMenuColumnHeader(eatmenu,0,"Food type");
	SetMenuColumnHeader(eatmenu,1,"Price");
	for(new i=0;i<sizeof(foods);i++)
	{
	    AddMenuItem(eatmenu,0,foods[i][fname]);
	    AddMenuItem(eatmenu,1,foods[i][fprice]);
	}
//----------------------------[City Hall menu]----------------------------------
    cityhallmenu = CreateMenu("Employment",  1, 200.0, 100.0, 150.0, 150.0);
    SetMenuColumnHeader(cityhallmenu,0,"Select:");
	for(new i=1;i<sizeof(jobs);i++)
	    AddMenuItem(cityhallmenu, 0, jobs[i][jname]);
//----------------------------[Help Menu----------------------------------------
    helpmenu = CreateMenu("Helps", 1, 200.0, 100.0, 150.0, 150.0);
    new File:hFile=fopen("helps/types.txt",io_read);
    SetMenuColumnHeader(helpmenu,0,"Select:");
	while(fread(hFile,String))
	    AddMenuItem(helpmenu, 0, String);
	fclose(hFile);
	shopmenu1 = CreateMenu("24/7", 2, 200.0, 100.0, 150.0, 150.0);
	SetMenuColumnHeader(shopmenu1,0,"Product:");
	SetMenuColumnHeader(shopmenu1,1,"Price:");
	AddMenuItem(shopmenu1,0,"Cell Phone");
	AddMenuItem(shopmenu1,1,"100$");
	AddMenuItem(shopmenu1,0,"Cell Phone Memory Card");
	AddMenuItem(shopmenu1,1,"500$");
	AddMenuItem(shopmenu1,0,"Phone Book");
	AddMenuItem(shopmenu1,1,"10$");
	AddMenuItem(shopmenu1,0,"Camera");
	AddMenuItem(shopmenu1,1,"100$");
	AddMenuItem(shopmenu1,0,"Scratch Card");
	AddMenuItem(shopmenu1,1,"50$");
	AddMenuItem(shopmenu1,0,"Dice");
	AddMenuItem(shopmenu1,1,"30$");
	AddMenuItem(shopmenu1,0,"Spray color");
	AddMenuItem(shopmenu1,1,"13$");
	AddMenuItem(shopmenu1,0,"Pager");
	AddMenuItem(shopmenu1,1,"50$");
	AddMenuItem(shopmenu1,0,"A shaker");
	AddMenuItem(shopmenu1,1,"120$");
	AddMenuItem(shopmenu1,0,"A small bin");	//instead of condome
	AddMenuItem(shopmenu1,1,"35$");
	AddMenuItem(shopmenu1,0,"A bottle kerosene");
	AddMenuItem(shopmenu1,1,"60$");
	AddMenuItem(shopmenu1,0,"A filter");
	AddMenuItem(shopmenu1,1,"40$");
	shopmenu2 = CreateMenu("24/7", 2, 200.0, 100.0, 150.0, 150.0);	//rayshop
	SetMenuColumnHeader(shopmenu2,0,"Product:");
	SetMenuColumnHeader(shopmenu2,1,"Price:");
	AddMenuItem(shopmenu2,0,"Gas Can");
	AddMenuItem(shopmenu2,1,"150$");
	AddMenuItem(shopmenu2,0,"Oxidizing Agent");
	AddMenuItem(shopmenu2,1,"250$");
	AddMenuItem(shopmenu2,0,"Mask");
	AddMenuItem(shopmenu2,1,"100$");
	AddMenuItem(shopmenu2,0,"Baseball Bat");
	AddMenuItem(shopmenu2,1,"50$");
	AddMenuItem(shopmenu2,0,"A knife");
	AddMenuItem(shopmenu2,1,"150$");
	format(String,256,"SELECT `mid`,`x`,`y`,`z`,`rx`,`ry`,`rz`,`id` FROM `objects`");
	mysql_query(String);
	mysql_store_result();
	while(mysql_fetch_row_default(String))
	{
	    magicstrtok(string,"|",String);
		new mid=strvalEx(string);
		magicstrtok(string,"|","");
		new Float:x=floatstr(string);
	    magicstrtok(string,"|","");
	    new Float:y=floatstr(string);
	    magicstrtok(string,"|","");
	    new Float:z=floatstr(string);
	    magicstrtok(string,"|","");
	    new Float:rx=floatstr(string);
	    magicstrtok(string,"|","");
	    new Float:ry=floatstr(string);
	    magicstrtok(string,"|","");
	    new Float:rz=floatstr(string);
	    new oid=CreateObject(mid,x,y,z,rx,ry,rz);
	    magicstrtok(string,"|","");
	    format(string,MAX_STRING1,"UPDATE `objects` SET `oid`='%d' WHERE `id`='%d'",oid,strvalEx(string));
	    mysql_query(string);
	}
	mysql_free_result();
	AllowInteriorWeapons(1);
    SetNameTagDrawDistance(10.0);
 	//UsePlayerPedAnims();
    DisableInteriorEnterExits();
	format(string,MAX_STRING1,"SELECT `id`,`x`,`y`,`z`,`owner` FROM `houses` WHERE `price`>0");
	mysql_query(string);
	mysql_store_result();
	while(mysql_fetch_row_default(String))
	{
	    magicstrtok(string,"|",String);
		new id=strvalEx(string);
		magicstrtok(string,"|","");
		new Float:x=floatstr(string);
		magicstrtok(string,"|","");
		new Float:y=floatstr(string);
		magicstrtok(string,"|","");
		new Float:z=floatstr(string);
		magicstrtok(string,"|","");
		new pid;
		if(!strcmp(string,"No",true))
			pid=CreatePickup(GREEN_PICKUP,1,x,y,z);
		else
		    pid=CreatePickup(BLUE_PICKUP,1,x,y,z);
		format(String,256,"UPDATE `houses` SET `pid`='%d' WHERE `id`='%d' AND `price`>0",pid,id);
		mysql_query(String);
	}
	mysql_free_result();
	format(string,MAX_STRING1,"SELECT `id`,`x`,`y`,`z`,`owner` FROM `houses` WHERE `price`<0");
	mysql_query(string);
	mysql_store_result();
	while(mysql_fetch_row_default(String))
	{
	    magicstrtok(string,"|",String);
		new id=strvalEx(string);
		magicstrtok(string,"|","");
		new Float:x=floatstr(string);
		magicstrtok(string,"|","");
		new Float:y=floatstr(string);
		magicstrtok(string,"|","");
		new Float:z=floatstr(string);
		magicstrtok(string,"|","");
		new pid;
		pid=CreatePickup(INFO_PICKUP,1,x,y,z);
		format(String,256,"UPDATE `houses` SET `pid`='%d' WHERE `id`='%d' AND `price`<0",pid,id);
		mysql_query(String);
	}
	mysql_free_result();
	for(new i=1;i<sizeof(jobs);i++)
	    CreatePickup(INFO_PICKUP,1,jobs[i][jx],jobs[i][jy],jobs[i][jz]);
	format(string,MAX_STRING1,"SELECT `id`,`x`,`y`,`z` FROM `houses` WHERE `price`='0'");
	mysql_query(string);
	mysql_store_result();
	while(mysql_fetch_row_default(String))
	{
	    magicstrtok(string,"|",String);
		new id=strvalEx(string);
		magicstrtok(string,"|","");
		new Float:x=floatstr(string);
		magicstrtok(string,"|","");
		new Float:y=floatstr(string);
		magicstrtok(string,"|","");
		new Float:z=floatstr(string);
		new pid=CreatePickup(INFO_PICKUP,1,x,y,z);
		format(String,256,"UPDATE `houses` SET `pid`='%d' WHERE `id`='%d'",pid,id);
		mysql_query(String);
	}
	mysql_free_result();
//	UsePlayerPedAnims();
	EnableStuntBonusForAll(0);
	SetTimer("SecTimer",1000,1);
	SetTimer("keepfrizing",1000,1);
	SetTimer("eatgeneretor",45*1000,1);
	SetTimer("moneycheat",1137,1);
//	SetTimer("weaponcheat",1000,1);
	SetTimer("AntiWeaponHack",1000,1);
	SetTimer("Afk",1000,1);
	SetTimer("update",1000*60*5,1);
	SetTimer("recover",MAX_STRING1,1);
	SetTimer("CarSpeed",1000,1);
	// LoadBusiness();
	CV();
	
	for(new i=0; i < MAX_PLAYERS; i++)
	{
		PMAllowed[i] = true;
	}
	#if DEBUG 1
		format(debugs,256,"DEBUG | OngameModeInit end.");
		debugLog(debugs);
	#endif
This is my server log:
Код:
SA-MP Dedicated Server
----------------------
v0.3a R7, ©2005-2010 SA-MP Team

[12:01:21] filterscripts = ""  (string)
[12:01:21] 
[12:01:21] Server Plugins
[12:01:21] --------------
[12:01:21]  Loading plugin: mysql
[12:01:21] 

  > MySQL plugin R4-2 successfully loaded.

[12:01:21]   Loaded.
[12:01:21]  Loaded 1 plugins.

[12:01:21] 
[12:01:21] Filter Scripts
[12:01:21] ---------------
[12:01:21]   Loaded 0 filter scripts.

[12:01:21] Mysql Connected
[12:01:21] tick
It does connets to the MYSQL server, but from an unknown reason it shuts the server down right when I start it.

Any ideas?

EDIT: Well, I do realized whats the problem is. I have no scriptfiles folder with my script. I mean I do have one, but without all needed files for the gamemode. The seller has never gave me the files, and he has disapeared.
Reply


Messages In This Thread
Gamemod doesn't connect to the database - by Ed2ka49 - 04.08.2010, 19:17
Re: Gamemod doesn't connect to the database - by JaTochNietDan - 04.08.2010, 21:28
Re: Gamemod doesn't connect to the database - by Cameltoe - 04.08.2010, 21:31
Re: Gamemod doesn't connect to the database - by Ed2ka49 - 05.08.2010, 09:00
Re: Gamemod doesn't connect to the database - by Mike Garber - 05.08.2010, 09:03
Re: Gamemod doesn't connect to the database - by Ed2ka49 - 05.08.2010, 09:21
Re: Gamemod doesn't connect to the database - by playbox12 - 05.08.2010, 09:22
Re: Gamemod doesn't connect to the database - by Ed2ka49 - 05.08.2010, 09:45
Re: Gamemod doesn't connect to the database - by Mimic - 05.08.2010, 11:30

Forum Jump:


Users browsing this thread: 1 Guest(s)