Raised This Month: $ Target: $400
 0% 

[ERROR] Sql problem


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
omer
Senior Member
Join Date: Nov 2011
Old 09-15-2012 , 03:39   [ERROR] Sql problem
Reply With Quote #1

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
__________________


Last edited by omer; 09-15-2012 at 09:00.
omer is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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