K4stic

it will send you to interior at any marker because have root addEventHandler ( "onPlayerMarkerHit", root, warpinto1 ) so use this better Weaponshop1 = createMarker ( 1368, -1279.8, 12.7, "cylinder", 1.5, 255, 255, 255, 255 ) function warpinto1 ( player ) if ( source == Weaponshop1 ) then setElementInterior ( player, 1, 286, -40, 1001 ) end end addEventHandler ( "onPlayerMarkerHit", root, warpinto1 )

Thx

at connection just don't show it just asking if i do true the code

so this is good? dbQuery(handler, "CREATE TABLE IF NOT EXISTS accounts(username, password)")

executeSQLQuery This function executes an arbitrary SQL query and returns the result rows if there are any. It allows parameter binding for security (SQL injection is rendered impossible). that function SQL only i need MySQL

this using to connect to the MySQL or SQL no to create tables

with what function dbExec dbQuery and how like i wonna create a table bans and to have indexes: username serial

realy was so easy? feeling so noob -.-" but thx

addEventHandler('onClientPlayerJoin', root, function() outputChatBox('* ' .. getPlayerName(source) .. ' has joined the game', 255, 255, 255) end ) addEventHandler('onClientPlayerChangeNick', root, function(oldNick, newNick) outputChatBox('* ' .. oldNick .. ' is now known as ' .. newNick, 255, 255, 255) end ) addEventHandler('onClientPlayerQuit', root, function(reason) outputChatBox('* ' .. getPlayerName(source) .. ' has left the game [' .. reason .. ']', 255, 255, 255) end ) this is by default JoinQuit i wonna to the players name if that player have color nick to show it now showing it: #000000Tram#454545zelo to show it: Tramzelo

Very Nice map

Good map i like it

1. UserPanel 2. Fix your Turf system ( because can't turf on 2 or more turfs at same time like if 5 players online every going turf with 1 turf for player they can't turf same time ) 3. Phone 4. Any shop ( weapon shop,24/7 shop e.t.c ) 5. House system 6. New Admin Panel 7. something that Community no have

to do players life 200 their Health stat must be 1000 so Try this: function giveHealth(source) local accountname = getAccountName (getPlayerAccount(source)) if isObjectInACLGroup ( "user." .. accountname, aclGetGroup ( "Admin" ) ) then for i,player in ipairs(getElementsByType("player")) do setPlayerStat ( player, 24, 1000 ) setElementHealth(player, 200) end setTimer(outputChatBox,50,1,"#00FFFF[#00FFFFSERVER#00FFFF] #00FFFF"..getPlayerName (source) .. " #00FFFFDeu Vida Para todos os Jogadores",getRootElement(),171,205,239,true) else outputChatBox("#ABCDEF* Você não é um Administrador.",source,171,205,239,true) end end addCommandHandler("darvida",giveHealth) it would be right or no by how you will make it

Good Job Bro like always you making Perfect maps

i know then one script is server or Client side

same Problem at line 13

one ask i wonna make to it each serial can register max 2 accounts

maybe i use wrong the ExecuteSQLQuery i see how use it wiki the SELECT so how make it? https://wiki.multitheftauto.com/wiki/ExecuteSQLQuery

and what will with other?

what you mean?

Error line 2 : Database query failed: no such table : accounts Error line 3 : attempt to get lenght of local 'serialCheck' (a boolean value) function onPlayerRegister(user,pass) local serialCheck = executeSQLQuery( "SELECT * FROM accounts WHERE serial = ?", getPlayerSerial( source ) ) if ( #serialCheck < 3 ) then if (user) and (pass) then local account = getAccount(user,pass) if (account == false) then addAccount(user,pass) local account = getAccount(user,pass) logIn(source,account,pass) triggerClientEvent(source,"Login:closeLoginPanel",source) exports.SCGhelp:createNewHelpMessageForPlayer( source,"You have registered!", 0, 255, 0) showPlayerHudComponent(source,'all',true) showChat(source,true) else exports.SCGhelp:createNewHelpMessageForPlayer( source,"You can only register 2 accounts for each serial!", 225, 0, 0 ) end else exports.SCGhelp:createNewHelpMessageForPlayer( source,"That account already exists.", 255, 0, 0) end else exports.SCGhelp:createNewHelpMessageForPlayer( source,"Fatal Register Error ~ Server Side", 255, 0, 0) return end end addEvent("Login:onPlayerRegister",true) addEventHandler("Login:onPlayerRegister",root,onPlayerRegister) look here the database http://i79.servimg.com/u/f79/17/22/60/79/tables10.jpg

it's the default name of table

local serialCheck = executeSQLQuery( "SELECT * FROM accounts WHERE serial = ?", getPlayerSerial( source ) ) i think this is ok

how

then you create account it's save the serial