[karaulov]

DELIMITER //
create procedure INIT_TABLES(  )

BEGIN CREATE TABLE IF NOT EXISTS unique_stats_yesterday ( `unuque_type` int(11) DEFAULT NULL, `steamid` varchar(64) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `ip` varchar(64) DEFAULT NULL ) DEFAULT CHARSET=utf8; 
CREATE TABLE IF NOT EXISTS unique_stats_today ( `unuque_type` int(11) DEFAULT NULL, `steamid` varchar(64) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `ip` varchar(64) DEFAULT NULL ) DEFAULT CHARSET=utf8;   
CREATE TABLE IF NOT EXISTS unique_stats_week ( `day1` int(11) DEFAULT NULL, `day2` int(11) DEFAULT NULL, `day3` int(11) DEFAULT NULL, `day4` int(11) DEFAULT NULL, `day5` int(11) DEFAULT NULL, `day6` int(11) DEFAULT NULL, `day7` int(11) DEFAULT NULL); END; //
DELIMITER ; CALL INIT_TABLES();
DROP PROCEDURE INIT_TABLES;

It just for example.

I tried add "^n" at end for every line, but it not works.

How to format multiline sql query for execute PROCEDURES/FUNCTIONS ?

[Shadows Adi]

Example:

CREATE TABLE IF NOT EXISTS `my_table` \
(`ID` INT NOT NULL AUTO_INCREMENT,\
PRIMARY KEY(ID));

You need to use '\' at the end of the line to get continued on next line.

[karaulov]

Originally Posted by Shadows Adi Example: CREATE TABLE IF NOT EXISTS `my_table` \ (`ID` INT NOT NULL AUTO_INCREMENT,\ PRIMARY KEY(ID)); You need to use '\' at the end of the line to get continued on next line.

Have you checked it works? Is the request being executed?

Because I'm not sure in your method.

[LondoN]

#include <amxmodx>
#include <amxmisc>
#include <sqlx>

new Handle:SQL_ConnectTuple;

public plugin_precache()
{
	SQL_ConnectTuple = SQL_MakeDbTuple("host", "useR", "pass", "db");


	new file[128], buffer[1024];
	get_configsdir(file, charsmax(file));
	formatex(file, charsmax(file), "%s/sql_queryes.txt", file);

	if(file_exists(file))
	{
		new iHandle = fopen(file, "r");

		if(iHandle)
		{
			while(!feof(iHandle))
			{
				fgets(iHandle, buffer, charsmax(buffer));
				trim(buffer);
			}
		}
	}

	SQL_QueryAndIgnore(SQL_ConnectTuple, buffer);
}

For a large amount of data to insert in db i recommend getting from file and then just insert the buffer.

[Shadows Adi]

Originally Posted by karaulov Have you checked it works? Is the request being executed? Because I'm not sure in your method.

Yes, it works, of course in AmxModX, using format / formatex

[karaulov]

Originally Posted by Shadows Adi Yes, it works, of course in AmxModX, using format / formatex

You tried your sample or my ?

CREATE TABLE IF NOT EXISTS unique_stats_yesterday ( `unuque_type` int(11) DEFAULT NULL, `steamid` varchar(64) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `ip` varchar(64) DEFAULT NULL ) DEFAULT CHARSET=utf8;

works withouts problem, but

DELIMITER //

create procedure INIT_TABLES(  )
BEGIN 
DECLARE sum1 INT;

CREATE TABLE IF NOT EXISTS unique_stats_yesterday ( `unuque_type` int(11) DEFAULT NULL, `steamid` varchar(64) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `ip` varchar(64) DEFAULT NULL ) DEFAULT CHARSET=utf8; 
CREATE TABLE IF NOT EXISTS unique_stats_today ( `unuque_type` int(11) DEFAULT NULL, `steamid` varchar(64) DEFAULT NULL, `username` varchar(64) DEFAULT NULL, `ip` varchar(64) DEFAULT NULL ) DEFAULT CHARSET=utf8;   
CREATE TABLE IF NOT EXISTS unique_stats_week ( `day1` int(11) DEFAULT NULL, `day2` int(11) DEFAULT NULL, `day3` int(11) DEFAULT NULL, `day4` int(11) DEFAULT NULL, `day5` int(11) DEFAULT NULL, `day6` int(11) DEFAULT NULL, `day7` int(11) DEFAULT NULL);  

SET sum1 = (SELECT COUNT(*) FROM unique_stats_week);
IF sum1 = 0 THEN
	INSERT INTO unique_stats_week (`day1`, `day2`, `day3`, `day4`, `day5`, `day6`, `day7`) VALUES ('0', '0', '0', '0', '0', '0', '0');
END IF;

END; 

//

DELIMITER ;
CALL INIT_TABLES();
DROP PROCEDURE INIT_TABLES;

I got nothing when tried to execute these query!