egghelp.org community Forum Index
[ egghelp.org home | forum home ]
egghelp.org community
Discussion of eggdrop bots, shell accounts and tcl scripts.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

mysql

 
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help
View previous topic :: View next topic  
Author Message
MrBoss
Voice


Joined: 21 Nov 2009
Posts: 7

PostPosted: Sun May 09, 2010 5:43 pm    Post subject: mysql Reply with quote

how i can show my all infos registred in my db?
I can connect so I can't show all infos.
Back to top
View user's profile Send private message
raider2k
Op


Joined: 01 Jan 2008
Posts: 140

PostPosted: Sun May 09, 2010 10:34 pm    Post subject: Reply with quote

using tcl or what is it you are asking for exactly?

either way - my advice is to look at existing tcl scripts how mysql is being called and mysql.org if needed for more information about mysql usage.
Back to top
View user's profile Send private message
MrBoss
Voice


Joined: 21 Nov 2009
Posts: 7

PostPosted: Mon May 10, 2010 6:01 am    Post subject: Tcl-Sql Reply with quote

How i can install the tcl-sql ?

I have try

Code:

fenix:~/tcl-sql/tcl-sql# chmod +w Makefile
fenix:~/tcl-sql/tcl-sql# make clean
Cleaned
fenix:~/tcl-sql/tcl-sql# make
g++ -c -I/usr/local/include -I/usr/include/mysql -I/usr/local/mysql/include -fPIC  -Wall -o obj/sql-mysql.o sql-mysql.cc
sql-mysql.cc:1:17: error: tcl.h: No such file or directory
In file included from sql-mysql.cc:2:
sql-mysql.h:2:19: error: mysql.h: No such file or directory
In file included from sql-mysql.h:3,
                 from sql-mysql.cc:2:
sql-interface.h: In member function ‘virtual Sql_row* Sql_interface::fetchrow(int)’:
sql-interface.h:49: error: ‘NULL’ was not declared in this scope
sql-interface.h: In member function ‘virtual char* Sql_interface::getErrorMsg()’:
sql-interface.h:56: error: ‘NULL’ was not declared in this scope
sql-interface.h: In member function ‘char* Sql_row::getColumn(int)’:
sql-interface.h:81: error: ‘NULL’ was not declared in this scope
In file included from sql-mysql.cc:2:
sql-mysql.h: At global scope:
sql-mysql.h:9: error: ‘MYSQL’ does not name a type
sql-mysql.h:10: error: ISO C++ forbids declaration of ‘MYSQL_RES’ with no type
sql-mysql.h:10: error: expected ‘;’ before ‘*’ token
sql-mysql.h:11: error: ‘MYSQL_ROW’ does not name a type
sql-mysql.cc: In constructor ‘Sql_mysql::Sql_mysql()’:
sql-mysql.cc:7: error: ‘results’ was not declared in this scope
sql-mysql.cc:7: error: ‘NULL’ was not declared in this scope
sql-mysql.cc:9: error: ‘NULL’ was not declared in this scope
sql-mysql.cc: In constructor ‘Sql_mysql::Sql_mysql(int, char**)’:
sql-mysql.cc:15: error: ‘results’ was not declared in this scope
sql-mysql.cc:15: error: ‘NULL’ was not declared in this scope
sql-mysql.cc: In member function ‘virtual char* Sql_mysql::getErrorMsg()’:
sql-mysql.cc:23: error: ‘mysql’ was not declared in this scope
sql-mysql.cc:23: error: ‘mysql_error’ was not declared in this scope
sql-mysql.cc: In member function ‘virtual int Sql_mysql::connect(int, char**)’:
sql-mysql.cc:35: error: ‘NULL’ was not declared in this scope
sql-mysql.cc:43: error: ‘mysql’ was not declared in this scope
sql-mysql.cc:43: error: ‘mysql_connect’ was not declared in this scope
sql-mysql.cc: In member function ‘virtual int Sql_mysql::selectdb(char*)’:
sql-mysql.cc:56: error: ‘mysql’ was not declared in this scope
sql-mysql.cc:56: error: ‘mysql_select_db’ was not declared in this sc
sql-mysql.cc: In member function ‘virtual int Sql_mysql::exec(char*)’:
sql-mysql.cc:66: error: ‘mysql’ was not declared in this scope
sql-mysql.cc:66: error: ‘mysql_query’ was not declared in this scope
sql-mysql.cc: At global scope:
sql-mysql.cc:74: error: default argument given for parameter 1 of ‘int Sql_mysql::numRows(int)’
sql-mysql.h:29: error: after previous specification in ‘virtual int Sql_mysql::numRows(int)’
sql-mysql.cc: In member function ‘virtual int Sql_mysql::numRows(int)’:
sql-mysql.cc:75: error: ‘results’ was not declared in this scope
sql-mysql.cc:76: error: ‘results’ was not declared in this scope
sql-mysql.cc:76: error: ‘mysql_num_rows’ was not declared in this scope
sql-mysql.cc: In member function ‘int Sql_mysql::getFreeResultHandle()’:
sql-mysql.cc:83: error: ‘results’ was not declared in this scope
sql-mysql.cc: In member function ‘virtual int Sql_mysql::query(char*)’:
sql-mysql.cc:96: error: ‘MYSQL_RES’ was not declared in this scope
sql-mysql.cc:96: error: ‘res’ was not declared in this scope
sql-mysql.cc:99: error: ‘sprintf’ was not declared in this scope
sql-mysql.cc:103: error: ‘mysql’ was not declared in this scope
sql-mysql.cc:103: error: ‘mysql_query’ was not declared in this scope
sql-mysql.cc:104: error: ‘mysql’ was not declared in this scope
sql-mysql.cc:104: error: ‘mysql_store_result’ was not declared in this scope
sql-mysql.cc:106: error: ‘results’ was not declared in this scope
sql-mysql.cc: At global scope:
sql-mysql.cc:112: error: default argument given for parameter 1 of ‘void Sql_mysql::endquery(int)’
sql-mysql.h:30: error: after previous specification in ‘virtual void Sql_mysql::endquery(int)’
sql-mysql.cc: In member function ‘virtual void Sql_mysql::endquery(int)’:
sql-mysql.cc:113: error: ‘results’ was not declared in this scope
sql-mysql.cc:114: error: ‘results’ was not declared in this scope
sql-mysql.cc:114: error: ‘mysql_free_result’ was not declared in this scope
sql-mysql.cc:115: error: ‘NULL’ was not declared in this scope
sql-mysql.cc: At global scope:
sql-mysql.cc:123: error: default argument given for parameter 1 of ‘Sql_row* Sql_mysql::fetchrow(int)’
sql-mysql.h:31: error: after previous specification in ‘virtual Sql_row* Sql_mysql::fetchrow(int)’
sql-mysql.cc: In member function ‘virtual Sql_row* Sql_mysql::fetchrow(int)’:
sql-mysql.cc:125: error: ‘results’ was not declared in this scope
sql-mysql.cc:126: error: ‘sprintf’ was not declared in this scope
sql-mysql.cc:127: error: ‘NULL’ was not declared in this scope
sql-mysql.cc:130: error: ‘MYSQL_ROW’ was not declared in this scope
sql-mysql.cc:131: error: ‘results’ was not declared in this scope
sql-mysql.cc:132: error: ‘row’ was not declared in this scope
sql-mysql.cc:132: error: ‘mysql_fetch_row’ was not declared in this scope
sql-mysql.cc:133: error: ‘NULL’ was not declared in this scope
sql-mysql.cc:135: error: ‘mysql_num_fields’ was not declared in this scope
sql-mysql.cc: In destructor ‘virtual Sql_mysql::~Sql_mysql()’:
sql-mysql.cc:145: error: ‘results’ was not declared in this scope
sql-mysql.cc:147: error: ‘mysql’ was not declared in this scope
sql-mysql.cc:147: error: ‘mysql_close’ was not declared in this scope
make: *** [obj/sql-mysql.o] Error 1
Back to top
View user's profile Send private message
raider2k
Op


Joined: 01 Jan 2008
Posts: 140

PostPosted: Mon May 10, 2010 9:19 am    Post subject: Reply with quote

dont know what tcl-sql is supposed to be, what you need is called mysqltcl
and please try to use proper english in here as well.
Back to top
View user's profile Send private message
MrBoss
Voice


Joined: 21 Nov 2009
Posts: 7

PostPosted: Mon May 10, 2010 11:58 am    Post subject: Reply with quote

you use in your tcls the mysqltcl?
Back to top
View user's profile Send private message
caesar
Mint Rubber


Joined: 14 Oct 2001
Posts: 3741
Location: Mint Factory

PostPosted: Tue May 11, 2010 6:56 am    Post subject: Reply with quote

Mysqltcl is a simple API for Mysql-Database and Tcl scripting language, so yes, you have to use it.
_________________
Once the game is over, the king and the pawn go back in the same box.
Back to top
View user's profile Send private message
MrBoss
Voice


Joined: 21 Nov 2009
Posts: 7

PostPosted: Mon Jan 03, 2011 4:50 pm    Post subject: Reply with quote

I can install use "apt-get install mysqltcl" ?
Back to top
View user's profile Send private message
thommey
Halfop


Joined: 01 Apr 2008
Posts: 73

PostPosted: Mon Jan 03, 2011 10:16 pm    Post subject: Reply with quote

It took you 7 months to figure that out?
Yes, you can 'apt-get install mysqltcl'. You load it in your script using 'package require mysqltcl', the documentation is here: http://www.xdobry.de/mysqltcl/mysqltcl.html
You can find examples here and more documentation at http://wiki.tcl.tk/mysqltcl
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Forum hosting provided by Reverse.net

Powered by phpBB © 2001, 2005 phpBB Group
subGreen style by ktauber