Mysql

[Baseplate]

I know I can do all of that Stuff

[AeroXbird]

Solution is pretty easy, you need to run a simple scanning software or network managing software and see what is running on port 80.

You can try Nmap, works very good for port scanning

[CapY]

Lucky for me i have 2 PC's and i am curenntly on that one where Xampp works , so i am now on PHPMyAdmin...and do i need to create database first ?

Edited August 1, 2011 by Guest

[Baseplate]

yea you need em

[CapY]

How i can create a database throught mysql will be connect ?

[Jaysds1]

ya, Create a Database then add the tables.

EDIT: Sorry about that scanner.

Edited August 1, 2011 by Guest

[Baseplate]

Jaysds1 is right just do what he says

[AeroXbird]

ya, Create a Database then add the tables.

Here's a Scanner:

http://www.kaspersky.com/virusscanner

Why on earth, would he require a VIRUS SCANNER.

When he's making mysql databases. lol

[Baseplate]

cuz Viruses can make anything

[CapY]

So Turismo you can do it via teamviewer ?

[Jaysds1]

let Turismo do it, That's only if he knows Xampp,

and what are you making for mySql?

[CapY]

I will be do some save system.

Btw is any of MTA official resources have any kind of savesystem ?

[Jaysds1]

no, they don't have any save system...

and does the save system saves the player position on logout or quit?

[CapY]

Yep

[Jaysds1]

You don't need to use mySql then,

you could have used setAccountData and getAccountData.

-- WHEN THE PLAYER LOGSOUT 
     local playeraccount = getPlayerAccount ( source ) 
      if ( playeraccount ) then 
            local playermoney = getPlayerMoney ( source ) 
            local playerweapon = getPedWeapon ( source ) 
            setAccountData ( playeraccount, "money", playermoney ) 
            local x,y,z = getElementPosition (source) 
            setAccountData (playeraccount, "s.HandMoney", playermoney) 
            setAccountData (playeraccount, "s.skin", tostring (getPedSkin (source))) 
            setAccountData (playeraccount, "s.x", x) 
            setAccountData (playeraccount, "s.y", y) 
            setAccountData (playeraccount, "s.z", z) 
            setAccountData (playeraccount, "s.int", getElementInterior (source)) 
            setAccountData (playeraccount, "s.dim", getElementDimension (source)) 
            setAccountData (playeraccount, "s.rot", getPedRotation (source)) 
            setAccountData (playeraccount, "s.weap0", getPedWeapon ( source, 0 )) 
            setAccountData (playeraccount, "s.weap1", getPedWeapon ( source, 1 )) 
            setAccountData (playeraccount, "s.weap2", getPedWeapon ( source, 2 )) 
            setAccountData (playeraccount, "s.ammo2", getPedTotalAmmo ( source, 2 )) 
            setAccountData (playeraccount, "s.weap3", getPedWeapon ( source, 3 )) 
            setAccountData (playeraccount, "s.ammo3", getPedTotalAmmo ( source, 3 )) 
            setAccountData (playeraccount, "s.weap4", getPedWeapon ( source, 4 )) 
            setAccountData (playeraccount, "s.ammo4", getPedTotalAmmo ( source, 4 )) 
            setAccountData (playeraccount, "s.weap5", getPedWeapon ( source, 5 )) 
            setAccountData (playeraccount, "s.ammo5", getPedTotalAmmo ( source, 5 )) 
            setAccountData (playeraccount, "s.weap6", getPedWeapon ( source, 6 )) 
            setAccountData (playeraccount, "s.ammo6", getPedTotalAmmo ( source, 6 )) 
            setAccountData (playeraccount, "s.weap7", getPedWeapon ( source, 7 )) 
            setAccountData (playeraccount, "s.ammo7", getPedTotalAmmo ( source, 7 )) 
            setAccountData (playeraccount, "s.weap8", getPedWeapon ( source, 8 )) 
            setAccountData (playeraccount, "s.ammo8", getPedTotalAmmo ( source, 8 )) 
            setAccountData (playeraccount, "s.weap9", getPedWeapon ( source, 9 )) 
            setAccountData (playeraccount, "s.ammo9", getPedTotalAmmo ( source, 9 )) 
            setAccountData (playeraccount, "s.weap10", getPedWeapon ( source, 10 )) 
            setAccountData (playeraccount, "s.weap11", getPedWeapon ( source, 11 )) 
            setAccountData (playeraccount, "s.weap12", getPedWeapon ( source, 12 )) 
      end 
  
-- WHEN THE PLAYER JOINS AGAIN OR LOGIN 
      local playeraccount = getPlayerAccount ( source ) 
      if ( playeraccount ) then 
            local playermoney = getAccountData ( playeraccount, "money" ) 
            -- make sure there was actually a value saved under this key (check if playermoney is not false). 
            -- this will for example not be the case when a player plays the gametype for the first time 
            if ( playermoney ) then 
                  setPlayerMoney ( source, playermoney ) 
            else 
                  setPlayerMoney (source, 99999999) 
            end 
             
            local playerSkin = getAccountData (playeraccount, "s.skin") 
  
            local weap0 = getAccountData(playeraccount, "s.weap0") 
            local weap1 = getAccountData(playeraccount, "s.weap1") 
            local weap2 = getAccountData(playeraccount, "s.weap2") 
            local ammo2 = getAccountData(playeraccount, "s.ammo2") 
            local weap3 = getAccountData(playeraccount, "s.weap3") 
            local ammo3 = getAccountData(playeraccount, "s.ammo3") 
            local weap4 = getAccountData(playeraccount, "s.weap4") 
            local ammo4 = getAccountData(playeraccount, "s.ammo4") 
            local weap5 = getAccountData(playeraccount, "s.weap5") 
            local ammo5 = getAccountData(playeraccount, "s.ammo5") 
            local weap6 = getAccountData(playeraccount, "s.weap6") 
            local ammo6 = getAccountData(playeraccount, "s.ammo6") 
            local weap7 = getAccountData(playeraccount, "s.weap7") 
            local ammo7 = getAccountData(playeraccount, "s.ammo7") 
            local weap8 = getAccountData(playeraccount, "s.weap8") 
            local ammo8 = getAccountData(playeraccount, "s.ammo8") 
            local weap9 = getAccountData(playeraccount, "s.weap9") 
            local ammo9 = getAccountData(playeraccount, "s.ammo9") 
            local weap10 = getAccountData(playeraccount, "s.weap10") 
            local weap11 = getAccountData(playeraccount, "s.weap11") 
            local weap12 = getAccountData(playeraccount, "s.weap12") 
            giveWeapon ( source, weap0, 1 ) 
            giveWeapon ( source, weap1, 1 ) 
            giveWeapon ( source, weap2, ammo2 ) 
            giveWeapon ( source, weap3, ammo3 ) 
            giveWeapon ( source, weap4, ammo4 ) 
            giveWeapon ( source, weap5, ammo5 ) 
            giveWeapon ( source, weap6, ammo6 ) 
            giveWeapon ( source, weap7, ammo7 ) 
            giveWeapon ( source, weap8, ammo8 ) 
            giveWeapon ( source, weap9, ammo9 ) 
            giveWeapon ( source, weap10, 1 ) 
            giveWeapon ( source, weap11, 1 ) 
            giveWeapon ( source, weap12, 1 )         
      end 

Edited August 2, 2011 by Guest

[Baseplate]

lol it dosen't need MySQL it's a simple resource

[CapY]

It needs to be on login to load playerdata

[Jaysds1]

you could still use the code, just add the eventhandler(onPlayerLogin) or (onPlayerLogout) and put the code in a function.

Edited August 3, 2011 by Guest

[CapY]

Server side ?

Errors., lua:2 bad argument getPlayerAccount

lua:40 bad argument getPlayerAccount

[bandi94]

CapY.. that is only a part of script not the full script is missing the handler and ...

[CapY]

http://imageshack.us/f/153/mysqlerror.png/

I has typed all informations in cfg file and this show up .

[Jaysds1]

What did you put in the user_system cfg file?

[CapY]

Host, user, password , database...

[Jaysds1]

ok, Did you edit the privilege tab in phpMyAdmin for your database?

[CapY]

yep