AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   [ERROR] Sql problem (https://forums.alliedmods.net/showthread.php?t=196075)

omer 09-15-2012 03:39

[ERROR] Sql problem
 
In real plugin this line was:
PHP Code:

new query_create[1001]
    
format(query_create,1000,"CREATE TABLE IF NOT EXISTS `%s` (`id` int(11) NOT NULL auto_increment,`admin_name` varchar(32) NOT NULL default '',`admin_authid` varchar(32) NOT NULL default '',`cmd` varchar(255) NOT NULL default '',`cmd_value` varchar(100) NOT NULL default '',`date` date NOT NULL default '0000-00-00',`time` time NOT NULL default '00:00:00',`target_name` varchar(35) NOT NULL default '',`target_authid` varchar(35) NOT NULL default '',PRIMARY KEY  (`id`))",table)
    
SQL_ThreadQuery(g_Sqls,"QueryHandle",query_create

Then I change this to:
PHP Code:

line=53>    new query_create[1001]
line=54>    format(query_create,1000,"CREATE TABLE IF NOT EXISTS `%s` (`id` int(11) NOT NULL auto_increment,`admin_name` varchar(32) NOT NULL default '',`admin_authid` varchar(32) NOT NULL default '',`admin_ip` varchar(32) NOT NULL default '',`cmd` varchar(255) NOT NULL default '',`cmd_value` varchar(100) NOT NULL default '',`date` date NOT NULL default '0000-00-00',`time` time NOT NULL default '00:00:00',`target_name` varchar(35) NOT NULL default '',`target_authid` varchar(32) NOT NULL default '',`target_ip` varchar(32) NOT NULL default '',PRIMARY KEY  (`id`))",table)
line=55>    SQL_ThreadQuery(g_Sqls,"QueryHandle",query_create

What's problem with this code?
When compiling got these errors :(
HTML Code:

Error: Input line too long (after substitutions) on line 53
Error: Invalid string (possibly non-terminated string) on line 54
Warning: Loose indentation on line 55
Error: Undefined symbol "r" on line 55
Error: Undefined symbol "NOT" on line 55
Error: Invalid expression, assumed zero on line 55
Error: Too many error messages on one line on line 55


omer 09-15-2012 09:01

Re: [ERROR] Sql problem
 
I have tried this but didn't work :( Please Help
PHP Code:

    new query_create[1001]
    
format(query_create,1000,"CREATE TABLE IF NOT EXISTS `%s` (\
    `id` int(11) NOT NULL auto_increment,`admin_name` varchar(32) NOT NULL default '',`admin_authid` varchar(32) NOT NULL default '',`admin_ip` varchar(32) NOT NULL default '',`cmd` varchar(255) NOT NULL default '',\
    `cmd_value` varchar(100) NOT NULL default '',`date` date NOT NULL default '0000-00-00',`time` time NOT NULL default '00:00:00',`target_name` varchar(35) NOT NULL default '',\
    `target_authid` varchar(32) NOT NULL default '',`target_ip` varchar(32) NOT NULL default '',PRIMARY KEY  (`id`))"
,table)
    
SQL_ThreadQuery(g_Sqls,"QueryHandle",query_create


omer 10-01-2012 07:34

Re: [ERROR] Sql problem
 
14 days passed :( :( :( Please Someone Help...!!!

Neeeeeeeeeel.- 10-01-2012 09:29

Re: [ERROR] Sql problem
 
What you are showing hasn't any meaning. The syntax is right, so you won't get any error.
PHP Code:

ErrorUndefined symbol "r" on line 55 ErrorUndefined symbol "NOT" on line 55 

You don't have "r" or "NOT" on line 55...


All times are GMT -4. The time now is 08:11.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.