Jump to content

Search the Community

Showing results for tags 'sql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Multi Theft Auto: San Andreas 1.x
    • Support for MTA:SA 1.x
    • User Guides
    • Open Source Contributors
    • Suggestions
    • Ban appeals
  • General MTA
    • News
    • Media
    • Site/Forum/Discord/Mantis/Wiki related
    • MTA Chat
    • Other languages
  • MTA Community
    • Scripting
    • Maps
    • Resources
    • Other Creations & GTA modding
    • Competitive gameplay
    • Servers
  • Other
    • General
    • Multi Theft Auto 0.5r2
    • Third party GTA mods
  • Archive
    • Archived Items
    • Trash

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Gang


Location


Occupation


Interests

  1. O que é? Pra que serve? Um banco de dados é onde ficam salvos diversos tipos de dados que são usados entre as sessões dos jogadores e do servidor, isto significa que mesmo se o jogador relogar no servidor ou até mesmo o servidor reiniciar, os dados salvos no banco de dados não são perdidos. (se o script que salvou lá foi feito corretamente). O que posso salvar neles? O MTA já cria 2 bancos de dados padrão quando vc cria seu servidor, são eles: internal.db - Onde são salvos todos os dados das contas dos jogadores, login, senha, grana do bolso, posição do jogador quando deslogou,
  2. can anyone please send me and Database file/script for a dayz server or a video how i can make it cose im new to making servers and i realy don't understand anything
  3. Olá, tenho um mod de inventario para mta que usa MySql como database, gostaria de saber se teria como converte-lo para SqlLite, vou estar deixando o link para que alguém que manje de database, o mod não é exclusivo então não vejo problemas em deixa-lo o link aqui. https://www.mediafire.com/file/utjoiptsiv2v40s/vz_inventario.7z/file
  4. Olá, eu estou desenvolvendo um código e me vi a necessidade de usar uma database, porém não entendo nada do assunto, eu andei dando uma lida no tutorial do @Lord Henry porém não entendi como por cada coisa em pratica; O que eu quero fazer: Uma Loja de Skins, que a mesma tem um botão de usar, na hora que ele apertar o botão de Comprar, se ele já tiver a Skin comprada, aparece uma mensagem para apertar no outro botão (Botão de usar a Skin), porém estou em dúvidas nessa parte de obter se ele tem a skin... Enfim, na Database em Geral. Se pudessem me ajudar ficaria agradecido function Del
  5. -- This piece of code in located in the 'onPlayerQuit' event handler. It saves the player's weapons and ammo if he has any, this is all working correctly local weapons = {} for slot = 1, 12 do local weapon = getPedWeapon(source, slot) if weapon > 0 then local ammo = getPedTotalAmmo(source, slot) if ammo > 0 then table.insert(weapons, {weapon, ammo}) end end end -- This is what appears under the 'weapons' column in the player's account table entry [ [ [ 30, 176 ] ] ] -- Which means the player left the server and had an AK-47 with total 176 ammo left -- And this i
  6. Alaan

    SQL Help/Ayuda

    Good people, I would like to know if someone could help me to pass a database sql to a saved by folder or something that is not sql or mysql because the host I hire is not mysql or sql and I need to save it in another way , Thank you very much already Buenas gente, quisiera saber si alguien me podria ayudar en pasar una base de datos sql a un guardado por carpeta u algo asi que no sea sql ni mysql por que el host que contrate no es mysql ni sql y necesito que se guarde de otra manera, desde ya muchisimas gracias
  7. Alaan

    Help/Ayuda SQL

    Hola buenas tardes/noches/dias, quisiera saber como utilizar SQL, tengo un resource de autos pero al reiniciar el servidor se salen los autos que compré, me trajo un archivo SQL que supongo que es para que no pase eso y no se como instalarla, si alguien me da una mano por favor se lo agradezco mucho. Hello good afternoon / nights / days, I would like to know how to use SQL, I have a resource of cars but when restarting the server the cars that I bought come out, I brought an SQL file that I guess it is so that it does not happen and I do not know how to install it , if someone gives me a
  8. السلام عليكم ورحمة الله وبركاته بما ان موضوع setElementData getElementData يضعف البروسيسور حق الخادم وايضاً ماهو محفوظ بشكل يدوم فترة طويلة سويت هذه الوظيفة البسيطة نفس طريقة تشغيل الـ set/getElementData لكن محفوظة واهم شي بيانات اللاعبين نفسهم وكمان ما تضعف البروسيسور حق الخادم المهم لازم تحمل المود و تابع باقي الشرح ملاحظة طريقة الحفظ بملفات db او اللي هي Database يعني تقدر تاخذ الملف اللي عليه الداتا في انك اغلقت ملاحظة الموضوع لملف سيرفر فقط وكمان ملاحظة الموضوع تجريبي لكن شغال تمام ان شاء الله طبعاً اللي تواجهه مشاكل يقول للمساعدة في تطويره اول
  9. Hello guyz. I have the following problem: I have an mta:sa server, and I'm trying to connect it to mysql, but it doesn't work. It finds the table, but the table has records in it, which cannot be found.
  10. السلام عليكم ورحمة الله وبركاتة كيف الحال ان شاء الله بخير اليوم انا بدي منكو بعض الافكار : اول فكرة ايش احط نوع المتغير الخاص بموضوع كامل text يعني انا بسوي موقع الان لما الناس تنشر توبك اخلي نوع التوبك ذا في قاعدة البيانات ولا في افضل الامر الأخر : الان انا بدي الناس تقدر تحط لايك الان الايك ويظهر عند الموضوع عدد الايكات زبط معي كل شي بس ضل قصة هي ابي يظهر مين الي حطو لايكات كيف اربطهم بالقاعدة الخاصة بالبيانات عقل يقول اسوي جدول للايكات لوحده واربطه مع الجدول التوبك وش قلتو ابي اشوف اذا في طرق افضل
  11. السلآم عليكم ورحمة الله وبركاته طلبي وآضح فوق File بإستخدام ال هل ينحفظن ولا لا ؟
  12. Hey I have recently made a script and to save its data and keep it safe in case script was restarted/server was shutdown I moved the data into a SQL using executeSQLQuery function. I believe such function saves the data in the internal DB right? Anyway, I did that in my local server and everything worked fine. But when I moved the script into another (hosted) server, An error showed up in the debug section saying 'Database query failed: file is encrypted or is not database'. I don't know what the heck they talking about, but I need help. Any ideas?
  13. SOMEONE CAN GIVE ME ACCOUNT.sql , because one idiot hacked my server and deleted account table from data de base , i don't know what to do now , need help guys!
  14. [2018-01-12 14:55:12] ERROR: Could not load /home/gameservers/mta/turbo1/x64/./dbconmy.so - /home/gameservers/mta/turbo1/x64/./dbconmy.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference[2018-01-12 14:55:12] ERROR: san_mysql/server.lua:19: dbConnect failed; Could not connect [2018-01-12 14:55:12] INFO: [mysql]: Sikertelen MYSQL csatlakozás! please help me, how to fix this?
  15. السلام عليكم ورحمة الله وبركاته كيف الحال شباب باذن الله اليوم بشرحلكم كيف تستخمون executeSQLQuery بطريقه مفصله بس اهم شي دعواتكم لي في الاختبار +_+ حق القدرات والله المستعان بس بسم الله نبدا طيب اولا executeSQLQuery هي وظيفه ثابته ما تتغير لكن فقط ما بين الاقواس هو اللي يتغير يعني انا شرحي ما اعرف اوصل المعلومه صح لكن حاولو تفهمو مني على قدر استطاعتكم +_+ نبدا باول وظيفه وهي انشاء قاعدة بيانات او بمعنى اصح تيبل executeSQLQuery("CREATE TABLE IF NOT EXISTS players (clothes_head_texture TEXT, clothes_head_model TEXT, name TEXT)") طيب
  16. السلام عليكم ورحمة الله وبركاته function E1 ( player, _, playerName ) if playerName and getPlayerFromName ( playerName ) then db = dbConnect("sqlite", "killerProject.db") dbExec(db, "CREATE TABLE IF NOT EXISTS MYSQLTable ( playerName, playerMoney )") dbExec(db, "INSERT INTO MYSQLTable VALUES ( ?, ? )", getPlayerName (player), getPlayerMoney (player) ) playSoundFrontEnd(player, 43) for i, rTable in ipairs( dbPoll( dbQuery( db, "SELECT * FROM MYSQLTable WHERE playerName = ?", playerName ) , -1 ) ) do outputChatBox ( "* Play
  17. Hi guys. Can u tell me which fuctions from mta:wiki should I use to make this system. I want in this system: saving group to the player based on sql, indvidual commands for group. Like a Police - /arrest, Medics /heal. For all groups leader panel inlc. cmd /invite /kick. For admin /creategroup /setownergroup. I think in sql I need some table which saves values like a loginplayer, nicknameplayer, idGroup, nameGroup, leaderGroup, membersGroup? and make permission system for indvidual cmd but which fuction is responsible for that ?
  18. السلام عليكم ورحمة الله وبركاته عندي مشكلة , صار لي ساعة عليها _ المهم المشكلة إنه مستدعي بيانات الاعب بس ما يجيبهن بقريد ليست aServer Side local aSelect = executeSQLQuery ( 'SELECT * FROM CreateSystem WHERE aSerial_ =? ' , aSerial_ ) triggerClientEvent ( source , 'Attention' , source , aSelect ) aClientSide addEvent ( 'Attention' , true ) addEventHandler ( 'Attention' , root , function ( aSelect ) guiGridListClear ( GUIEditor2.gridlist[2] ) for i , v in ipairs ( aSelect ) do local aRow_ = guiGridListAddRow( GUIEditor2.gridlist[2] ) guiGridListSetItemTex
  19. Hello fellas i have an important question about the databases in lua scripting, i have made a carshop system which stores the vehicles inside the database and i have made a menu which the user selects to spawn despawn his vehicle. if the user has 2 same vehicles how the script will know wich one from the database will pick? image of database:
  20. Hello fellows how are you ? Today i want to use database connections Into a simple script that im gonna make about user settings The script is simple a gui opens up and the user selects if he wants to enable disable some graphical settings (car reflection, water, detail, contrast, show fps counter etc blah blah) Script is made and works perfect but i want to save each user settings to database(sqlite for now since i don't want to have remote control of database for now so mysql is not needed) so when he logs on to server the settings he set before will be applied, and also if hes n
  21. Olá pessoas peçonhentas. Bom, estou fazendo uns testes com portão que abre somente para determinado jogador cuja conta seja igual a um determinado campo do banco de dados. Por exemplo, quero que o portão abra somente quando o jogador da conta "lordhenry" se aproxime, mas não é tão simples, pois essa conta pode mudar caso ele venda a casa, dai o valor passa a ser vazio. Dai se outra pessoa comprar a casa, dai a conta dessa pessoa fica naquele campo que estava vazio e o portão passa a abrir somente com a conta dessa pessoa. Eu estou pensando em usar executeSQLQuery("SELECT....
  22. DarkxD

    SaveAccount

    Hallo, please help me!
  23. السلام عليكم ورحمة الله وبركاته يمكنكم الان تعلم لغة الاس كيو ال عن طريق هذا الموقع http://www.w3schools.com/sql/default.asp في لغات كثيرة PHP HTML اتمنى قد اكون وفيت وكفيت
  24. اخواني لو سمحتو الان انا ابيه يحذف رو واحد فقط ما ابيه يحذف كل الرو اللي باسم اللاعب يعني اللاعب مقدم اكثر من طلب انا لما اضغط زر دليت يحذف كل طلبات اللاعب انا ابيه يحذف طلب 1 فقط addEvent("delete",true) addEventHandler("delete",root,function(a1,a2,a3,a4) executeSQLQuery( ' DELETE FROM `Master` WHERE NAME=? ', a1 ) executeSQLQuery( ' DELETE FROM `Master` WHERE Card=? ', a2 ) executeSQLQuery( ' DELETE FROM `Master` WHERE PRICE=? ', a3 ) executeSQLQuery( ' DELETE FROM `Master` WHERE HOU22=? ', a4 ) triggerEvent("getUsers1",root) end )
  25. Hey there, I'm working on a roleplay project to update some older scripts, however, I can not get the mysql to work. The mysql resource is connect to the database, but doesn't work with it. It gives no error messages besides this one, when trying to login: *ERROR: account-system/s_login.lua:44: attempt to concatenate local 's afepassword' (a nil value)* The resources has worked before with the database, just to confirm that. I'm running a 32bit linux server with the modules from https://linux.mtasa.com/
×
×
  • Create New...