Jump to content

trajik

Members
  • Posts

    31
  • Joined

  • Last visited

Everything posted by trajik

  1. I don't understand...you want to be able to try to shoot a gun with no ammo for roleplay? or replace a bullet with another object?
  2. yeah still not what I'm looking for...in a nutshell this is what I mean function changeTheButtons() local query = (look for the players account name) if (query) then while true local find =(look back at the players account name and see if they have a character) if(find) then spawnCharacter() else createCharacter() end end freeResults.....ect. end I know it's not real code....but that's what I mean and what I need.
  3. That's just the basic structure of my db...the one used in the usersystem resource EDIT: I basically need a script that looks at one table getting the local players name then checking if it's in the database and if it is then it looks back into the database for a character...if the account has a character then it spawns it If not it sends the player to the character creation screen..so how could this be done what steps do I take? NOTE from 50p: Is it so hard to hit edit button?
  4. that's not the issue though... In my database I have it set up like this: mySQL database Roleplayer: Players: account - password - charName - ect.... now I have it set up so it looks at the account and retrieves the charName table to check if the account has a character. Am i doing it right or do I need a whole new code? That's my problem thanks in advance
  5. Is it possible to replace say skin ID 11 to be another CJ (like a white cj or Asian cj, ect.) so if a player selects skin ID 0 or skin ID 11 he has full customization of the character as far as hair, clothes, ect. And is it possible to add skin IDs?
  6. post your code your using because as of right now I have no clue where to begin it could be numerous things....
  7. should I be using this instead? table mysql_fetch_field ( MySQLResult result )
  8. yeah that was my problem...I needed to search for the account not the players name lol so simple....but now it doesn't spawn me which brings me back to my spawn script ^^ edit wait no never mind now if they register it says they have a character created without acually making one....an account and a character are different
  9. ohhhh I see the problem..."theUser" is the local player so it would give the account name so right now when my function is called it is giving the account name rather than the char name....if that makes sence I will try to fix it now and post my resaults
  10. anyone? sorry if i appear to be annoying but this is driving me crazy lol
  11. well to get you started.... https://wiki.multitheftauto.com/wiki/CreatePed read wiki it has most of your questions. Read up and study and practice and you'll get the hang of it.
  12. I know it, there's scripts there that numerous people request here on the forums.....
  13. okay im going to break it down... the client side function to call my serverside function function button() triggerServerEvent("changeTheButton", getRootElement(), getLocalPlayer()) end triggered by gui click current code playerState = 0 function changeTheButton(theUser) if( not connect_mysql ) then outputChatBox( no_connect_sql_message ) else local query = mysql_query( connect_mysql, "SELECT * FROM `players` WHERE charName='" .. getPlayerName( theUser ) .. "'" ) outputDebugString("Result: "..tostring(mysql_num_rows(query))) if mysql_num_rows(query)== 1 then playerState = 1 ---Theres a character created outputDebugString ("theres a created character") else playerState = 0 ---The player is new outputDebugString ("no user data") end if (playerState == 1) then triggerEvent("spawnTheCharacter", getRootElement(), theUser) outputDebugString ("the data is loaded") elseif (playerstate == 0) then triggerClientEvent("move1", getRootElement()) outputDebugString ("move to create a char") end end end addEvent ("changeTheButton", true) addEventHandler ("changeTheButton", getRootElement(), changeTheButton) should be working don't know why it isn't
  14. thank you and Result: 0 so this means nothings coming back at all...
  15. isn't that what I did when using "theres a character created"? If not how would I set that up? perhaps... local query = mysql_query( connect_mysql, "SELECT * FROM `players` WHERE charName='" .. getPlayerName( theUser ) .. "'" ) if mysql_num_rows(query)== 1 outputDebugString {"blah blah blah") then playerState = 1 ---Theres a character created outputDebugString ("theres a created character") else playerState = 0 ---The player is new outputDebugString ("no user data") end
  16. I've tried that and other configurations but it still doesn't change that the script thinks my character is nonexistent.... Just tried it with if mysql_num_rows(query)== 1 then still gives the same error
  17. playerState = 0 function changeTheButton(theUser) if( not connect_mysql ) then outputChatBox( no_connect_sql_message ) else local query = mysql_query( connect_mysql, "SELECT * FROM `players` WHERE charName='" .. getPlayerName( theUser ) .. "'" ) if mysql_num_rows(query) > 2 then playerState = 1 ---Theres a character created outputDebugString ("theres a created character") else playerState = 0 ---The player is new outputDebugString ("no user data") end if (playerState == 1) then triggerEvent("spawnTheCharacter", getRootElement(), theUser) outputDebugString ("the data is loaded") elseif (playerstate == 0) then triggerClientEvent("move1", getRootElement()) outputDebugString ("move to create a char") end end end addEvent ("changeTheButton", true) addEventHandler ("changeTheButton", getRootElement(), changeTheButton) it tells me "no user data" which is treating me like I am a new player.....but in the MySQL db all my account information is properly logged in there so it shouldn't be treating me as if I just created an account. It doesn't even send me to the character creation page either (move1). I have been stumped for hours now.
  18. still doesn't work....I added some outputDebugString and still can't find an error
  19. Hi, I began talking about this on a previous thread so I decided to post a new one. Thanks to Uniqu3 I have the idea and I believe I am heading in the right direction....here's what I have so far... playerState = 0 function changeTheButton(theUser) if( not connect_mysql ) then outputChatBox( no_connect_sql_message ) else local query = mysql_query( connect_mysql, "SELECT * FROM `players` WHERE charName='" .. getPlayerName( theUser ) .. "'" ) if( query )> 2 then playerState = 1 ---Theres a character created else playerState = 0 ---The player is new end if (playerState == 1) then triggerEvent("spawnTheCharacter", getRootElement(), theUser) ---spawn the character previously created elseif (playerstate == 0) then triggerClientEvent("move1", getRootElement()) ---move the camera to the character creation section end end end I have tried it and it doesn't work...however I am also begining to question my "spawnTheCharacter" function as well that is function spawnTheCharacter(theUser) local playerName = getPlayerName (theUser) local spawnChar = mysql_query(connect_mysql, "SELECT * FROM `players` WHERE `saveX`, `saveY`, `saveZ` WHERE `charName`='"..playerName.."'") if (spawnChar) == nil then outputChatBox("error") else spawnPlayer (theUser, spawnChar) end end If someone could help me out I'd really appreciate it. Thanks Everyone
  20. https://community.multitheftauto.com/index.html?p ... ils&id=128 add to your resources and start it up
  21. okay, so I made a script that has a scripted character selection screen. It has one button and if your a first time user to the sever it sends you to another screen to create your character. After the player clicks finish to finish creating his character how would I go about making that same button he clicked on to create the character, to spawn the character he just created? Basically I'm asking how can I change a function of a button when I acquire new information?
  22. yeah thank you! I understand it now but now how could I use this to achieve my goal as stated above?
  23. I understand the basic concepts of lua, however I am in a bit of a bind when it comes to tables. In my server I have a button that creates a character but when it is complete the information is logged in my MySQL db but I don't know how I could use that information to make that same button spawn the created character, I believe if I use a table I could use that to achieve my goal...could anyone help me out?
×
×
  • Create New...