ArcEmu: Lua + Mysql - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Lua + Mysql :)

#1 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 17 October 2009 - 05:37 AM

Lets begin
need
http://luaforge.net/...&release_id=703 file lua5_1_4_Win32_dll9_lib.zip
http://luaforge.net/...&release_id=847 file luasql-2.1.1-mysql50-win32-lua51.zip

in server root make folder luasql and extact luasql-2.1.1-mysql50-win32-lua51.zip in to this folder
like this
c:\arcemu\luasql\mysql.dll
extract lua5_1_4_Win32_dll9_lib.zip and put lua5.1.dll to root server folder

in script folder make example file

require "luasql.mysql"
mysql = assert(luasql.mysql())

db_name = "" -- db name
db_host = "" -- host
db_user = "" -- user
db_pass = "" -- password

con = assert(mysql:connect(db_name, db_user, db_pass, db_host))
cur = assert(con:execute("SELECT version()"))

print("<mysql> MYSQL driver version is: "..luasql._MYSQLVERSION)
print("<mysql> "..luasql._COPYRIGHT)
print("<mysql> "..luasql._DESCRIPTION)
print("<mysql> "..luasql._VERSION)

con:close()
mysql:close()

if all ok in console you see

Quote

<mysql> MYSQL driver version is: 5.0.41
<mysql> Copyright © 2003-2007 Kepler Project
<mysql> LuaSQL is a simple interface from Lua to a DBMS
<mysql> LuaSQL 2.1.0

its all :D


example save user chat to base
DROP TABLE IF EXISTS `chat_log`;

CREATE TABLE `chat_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `char` char(15) CHARACTER SET utf8 DEFAULT NULL,
  `say` text CHARACTER SET utf8
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;


db_name = "arc" -- имя бд
db_host = "127.0.0.1" -- хост
db_user = "arc" -- пользователь
db_pass = "arc" -- пароль

function OnChat(event, plr, message, type, language)
require "luasql.mysql"
mysql = assert(luasql.mysql())
con = assert(mysql:connect(db_name, db_user, db_pass, db_host))
cur = assert(con:execute("insert into `chat_log`(`char`,`say`) values ('"..plr:GetName().."','"..message.."');"))
con:close()
mysql:close()
end

RegisterServerHook(16, "OnChat")


0

#2 User is offline   Xalotas 

  • Newbie
  • Group: Members
  • Posts: 3
  • Joined: 29-October 08

Posted 25 September 2010 - 08:30 AM

Could anybody reupload these two packages required to use this?
0

#3 User is offline   Garvey 

  • is a cool guy
  • Group: Super Moderator
  • Posts: 331
  • Joined: 23-November 09
  • Gender:Male
  • Location:England
  • Server OS:Windows

Posted 25 September 2010 - 08:44 AM

http://www.mirrorser...32_dll9_lib.zip

That's the first one, it was like the 5th result on google >.> Not very hard to find.

The other one, you're on your own with.
But I, being poor, have only my dreams;
I have spread my dreams under your feet;
Tread softly because you tread on my dreams.
0

#4 User is offline   iEzri 

  • < Ace of spades >
  • Group: Contributor
  • Posts: 1,692
  • Joined: 22-December 08
  • Gender:Female
  • Interests:I'm likely to cause mischief
  • Server OS:Linux

Posted 25 September 2010 - 09:18 AM

View PostGarvey, on 25 September 2010 - 08:44 AM, said:

http://www.mirrorser...32_dll9_lib.zip

That's the first one, it was like the 5th result on google >.> Not very hard to find.

The other one, you're on your own with.


what is this i don't even... ? ;)
Posted Image I do not join. I lead.
0

#5 User is offline   Garvey 

  • is a cool guy
  • Group: Super Moderator
  • Posts: 331
  • Joined: 23-November 09
  • Gender:Male
  • Location:England
  • Server OS:Windows

Posted 25 September 2010 - 09:41 AM

View PostiEzri, on 25 September 2010 - 09:18 AM, said:

what is this i don't even... ? ;)


lolwat?

It's what he asked for :P A link to a lua5_1_4_Win32_dll9_lib.zip download.
But I, being poor, have only my dreams;
I have spread my dreams under your feet;
Tread softly because you tread on my dreams.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users