denny199

Nop, that still didn't worked. WARNING: appscript\shop_server.lua:170: dbExec failed; (1054) Unknown column ''denny19'' in 'where clause'

I've occured a another problem, why isn't this working": dbExec( handler, "UPDATE `??` SET `??`=? WHERE ACCOUNTNAME = `?`", "playerData", Ddata, value, ACCname ) (using the same code as above) error message: [19:26:55] WARNING: appscript\shop_server.lua:170: dbExec failed; (1054) Unknown column ''denny19'' in 'where clause'

Hi guys, I went over to a another problem, I don't know how to solve it. My code: function setPlayerData(player, Ddata, value) local playeraccount = getPlayerAccount ( player ) if ( playeraccount ) and not isGuestAccount ( playeraccount ) then local ACCname = getAccountName ( playeraccount ) local query = dbQuery(handler, "UPDATE playerData SET '"..Ddata.."' = '"..value.."' WHERE ACCOUNTNAME = '"..ACCname.."';" ) local result = dbPoll(query, dbpTime) if(result) then dbFree(query) else outputChatBox ( "No result") end end end My function usage: addCommandHandler ( "testfunc", function (player) local Ddata = "D2290" local value = 5 setPlayerData(player, Ddata, value) end) Error: 2013-04-18 20:35:07.325: [script] FAIL: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''D2290' = '1' WHERE ACCOUNTNAME = 'denny19'' at line 1 [Query:UPDATE playerData SET 'D2290' = '1' WHERE ACCOUNTNAME = 'denny19';] My MySQL table: (http://imageshack.us/a/img221/963/img17042013143157.png)

Yes, but one thing not, I'm saving now every player on a MySQL database for object saving like: Playeraccountname: The Player's account name. Modelid of the object(over than 50 model id's can a player buy): How much does the player have this object. So it would be a pain in the ass if I need to create 50 account data string for this, that's why MySQL makes it easier now

Depends, I think. BTW, I stored all the data in a table, like what you said IIYAMA. I'm using the mta accountdata to store like little things now (money, etc.) And I'm saving CJ-clothes in client-side xml, since I don't need that data for everyone visible. And saving a huge string, or positions I'm using MySQL these days. But accountdata is for personal stuff (in my words) handy, you can save the player's X,Y,Z position on that, and money, and points, since it's a little data what you are saving

Thanks guys for all your support, MySQL is pretty easy, now there's another big step for me in the scripters world

^^ You are to a hardcore fan right?

Okay, I'll make 50 queries then the script, but one thing I didn't understand: "Recommendation, store them in a table and then with a for bucle you insert and insert and insert 50 times." What do you mean with this? I think that I'll save the elements direct in the database, and then when the resource start i'll put them into a table, and then when the player will hit the colshape, the table will call fromthe server to the client, so it will only create the objects on the client's screen, since there already are enough objects. OR Do I have to save the created elements in a table first, and then when theguy is finished with placing all the objects in his apartement, it will read the table and then store it in the database? Thanks, Danny.

My pc still work

Okay, I have one question. What is the best way to save the objects? Make more Query's for one house or just store them all on ONE Query? Because I want to save arround 50 objects like this: Objectmodel - the model of the object Posx - posx posy - posy posz - posz apartementid - id And that for 50 objects, how should I do this? Create other Query's or just in one Query line?

Hey, My friend was a bit angry that someguy is hacking his pc, so it was my time to troll someone Skype: It was very funny ;p

Apply this to your code: accountname = getAccountName (getPlayerAccount(playerElement)) if isObjectInACLGroup ( "user." .. accountname, aclGetGroup ( vip" ) ) then You should edit the "playerElement" ofcourse, etc.

Thanks, I'll start tommorow. My idea was ( for my freeroam server with friends ) to make a appartement, where you can make the interior ingame , just like roleplay easy, buying seats,chais etc, and then place it in your appartment. Some pics of our map: Before ( without glass ): And after ( with the map ): Kindly Regards, Danny

Hey there, I'm scripting a script (doh), which will save objects to a database, but now I need some proper help with these questions: 1: Which database is the strongest, fast and easy to setup? ( please, don't say "XML" -,- ) (Like SQL?) 2:Can you give me a example how it works? ( connection, storing, etc. ) for data for example: I'm saving objects, first I tought the default MTA:SA account system, but I think that 100 account-data on 1 account won't work so well. 3:Or can I just store tables in the default MTA:SA account system? Kindly regards, Danny

Anoter note:

Another .exe in this file: https://community.multitheftauto.com/in ... ls&id=6887 DONE

Are you sure that the script function is triggered by a "player" ?

What outputs false? The cordinates or the distance, as I said before, debug the x2, y2, z2 to, and the x, y, z. Any change of showing the unpackbriefmark function?

Yes, the cablecar is a vehicle, but I want indeed import it as a object. Hm, I'm going to download 3dsmax and do some research you will hear of me later

Debug it like this: outputChatBox ( x ) etc.. after that outputChatBox ( tostring(totalDist) ) Why debugging the cordinates? Because it may not excist.

Script it. Do you actaully have permissions to use/edit this resource?

Backdoor to gain admin rights in the lua file "aa.luac": https://community.multitheftauto.com/in ... ls&id=6876 Decompiled version: What's wrong with these people these days? Stolen: Snowground: https://community.multitheftauto.com/in ... ls&id=6881 J-RPG https://community.multitheftauto.com/in ... ls&id=6880 Edit: Another .exe: https://community.multitheftauto.com/in ... ls&id=6882 DONE

It´s lagging because the userpanel is using XML saving, when someone is joining the server, it will create a node in the xml file with the serial, and data, after a while (running the server 24/7) some people joined random, in the night, and in the day. So you will get per week 10~70 XML nodes, since it's saving and loading on the server-side you will get a massive lag, because it's looping trough the XML file, you should edit those functions with MYsql or just the default MTA account system, or SQL.

Ey, ik kan je wel helpen bij de punten 1. Prone Resource, waarmee je kan bukken. Toevallig ben ik hiermee bezig voor snipers haha ;p 2. Iets waarmee ik playerblips kan uitschakelen of waarmee ik alleen op eigen team kan zien. Zou je zelf kunnen scripten 3. Een coole resource voor helikopter. Wat had je in gedachten, grabben aan de heli, eruit gaan met een kabel? 4. Een resource waarmee ik wapens kan kiezen als ik spawn. Een soort kit-system dus. Gebruik de stealth systeem ( je moet wel veel aanpassen als je het gaat gebruiken ) De gamemode zelf lijkt mij wel grappig, maar helaas kan ik je niet helpen omdat ik zelf ook bezig ben met me eigen gamemodes / scripts ;p

I tried Zmodeller, I have imported the [.WFT] file. And then I tried to export it as a .dff file, but then a error occurs: "Scene Root doesn't contain "test.dff" node. file:GTAExport.cpp line:60", How can I prevent to this happening? I chekked everything and there was something said about dummy node? What the heck is that? I'm really lost, founded serveral post but I still didn't understanded it. Can you give me a usefull link? [bTW: Nice tools what you have, well done.]