Jump to content
FapFap

LuaSQL

Recommended Posts

16 minutes ago, Angelix said:

Do you have LuaSQL added in your GameServer? Check if it was added correctly. 

Yeah i have, also says on top that LuaSql is loaded

Share this post


Link to post
Share on other sites
On 2/25/2019 at 6:31 PM, FapFap said:

@Fomin I'm having this error.. idk what is wrong zzz
124555.png.514823b09fecab57fea8525968647099.png

Wrong MSSQL Server host or login and password pair. Your script cannot connect to the server.


Share this post


Link to post
Share on other sites
On 3/3/2019 at 6:59 PM, Danny said:

Whats your SQL Logins? Screenshot your login + screenshot your sql server management studio login.

I'm trying this other Function and i'm having such problem

LuaErr and LuaSQL Function:

12345.png.2d25323e4f75946babfaf358798f99fb.png

ItemInfo Function (Just Testing):
1234.png.f5eabcc27c558d968a5277aa53d89d48.png

Share this post


Link to post
Share on other sites

image.png.9fca6c16469f077295380e5f1238b8d0.png
why do u have this o.O?

@Angelix  there
image.png.bcd310bcdfa6f62463810e7c095365d8.png

try change this password maybe ?
image.png.c63de40d3d1e6c645dcaadaceaa6b333.png
as vector said 
 

Quote

Wrong MSSQL Server host or login and password pair. Your script cannot connect to the server.

 

Share this post


Link to post
Share on other sites
Just now, mkhzaleh said:

image.png.9fca6c16469f077295380e5f1238b8d0.png
why do u have this o.O?

@Angelix  there
image.png.bcd310bcdfa6f62463810e7c095365d8.png

try change this password maybe ?
image.png.c63de40d3d1e6c645dcaadaceaa6b333.png
as vector said 
 

 

I mean his scripts are going to throw errors when trying to use the item function. He also uses a variable called “amount” and doesn’t declare it anywhere. He also declares the variable “Name” and a table for “Points”, and yet he doesn’t use it, although that’s not a big problem. 

I think the issue is that LuaSQL is not a registered function by seeing the whole “LuaSQL a nil value” thing? Don’t know much to be honest. 

 

Anyway @FapFap, LuaSQL uses the user and password you use for each database at MSSQL, not the encrypted passwords or other users. Also, I don’t know if you have a separate database for the IMPs, if you use IGS, then it should be TradeServer. 

Share this post


Link to post
Share on other sites
9 hours ago, Angelix said:

I mean his scripts are going to throw errors when trying to use the item function. He also uses a variable called “amount” and doesn’t declare it anywhere. He also declares the variable “Name” and a table for “Points”, and yet he doesn’t use it, although that’s not a big problem. 

I think the issue is that LuaSQL is not a registered function by seeing the whole “LuaSQL a nil value” thing? Don’t know much to be honest. 

 

Anyway @FapFap, LuaSQL uses the user and password you use for each database at MSSQL, not the encrypted passwords or other users. Also, I don’t know if you have a separate database for the IMPs, if you use IGS, then it should be TradeServer. 

I'm using same user/pw for all, tho just trying to make it work but without success now it doesn't show those errors in gameserver but only the Nil value error.

Share this post


Link to post
Share on other sites

image.png.06642c404e63c5c43ea0925c87ac475f.png

 

you are not using those variables anywhere in your function, and since you want to make it add 100 imps only so 
remove those unused things

could looks like this 

ImpsPointCard = function(Player, Item)
	AddImpsPoints(Player,100)
	HelpInfo(Player, 0, "bla bla")
end

 

Edited by mkhzaleh

Share this post


Link to post
Share on other sites
23 hours ago, mkhzaleh said:

image.png.06642c404e63c5c43ea0925c87ac475f.png

 

you are not using those variables anywhere in your function, and since you want to make it add 100 imps only so 
remove those unused things

could looks like this 


ImpsPointCard = function(Player, Item)
	AddImpsPoints(Player,100)
	HelpInfo(Player, 0, "bla bla")
end

 

You gave me that function tho XD, still same

Share this post


Link to post
Share on other sites
1 hour ago, FapFap said:

You gave me that function tho XD, still same

not really , wasn't missing as this one,
and your issue to connect your sql ,
one more question is your db have mall_point table?

Edited by mkhzaleh

Share this post


Link to post
Share on other sites
2 hours ago, mkhzaleh said:

not really , wasn't missing as this one,
and your issue to connect your sql ,
one more question is your db have mall_point table?

yes i have mall_point table

Share this post


Link to post
Share on other sites

FapFap has a modified GameServer and somehow it doesn't register the functions, that's why it throws "nil value". He also sent me a GameServer from Lucky's file I think and it's the same thing. When I tried adding LuaSQL to the GameServer provided on files shared by Vector (138 files), it does work. 

Share this post


Link to post
Share on other sites

12345.png.303c0503a89a70aa9880fea128716efe.png

Always same problem when using the Item...
Changed Database & made default sa login & pw and still same errors on GS Console when i use the Item..
Any help? e.e

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...