Sziasztok kurta féle reg rendszert épitettem be a modomba majd épitettem felefel csak sajnos nem ment semmit mi lehet a gond?másolom a dolgokat
[18:53:27]
[18:53:27] ---------------------------
[18:53:27] MySQL Debugging activated (09/07/12)
[18:53:27] ---------------------------
[18:53:27]
[18:53:27] >> mysql_connect( )
[18:53:27] CMySQLHandler::CMySQLHandler() - constructor called.
[18:53:27] CMySQLHandler::CMySQLHandler() - Connecting to \"localhost\" | DB: \"fly\" | Username: \"root\" ...
[18:53:27] CMySQLHandler::Connect() - Connection was successful.
[18:53:27] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[18:53:27] >> mysql_ping( Connection handle: 1 )
[18:53:27] CMySQLHandler::Ping() - Connection is still alive.
[18:53:27] >> mysql_reconnect( Connection handle: 1 )
[18:53:27] CMySQLHandler::Disconnect() - Connection was closed.
[18:53:27] CMySQLHandler::Connect() - Connection was successful.
[18:53:27] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[18:53:27] >> mysql_query( Connection handle: 1 )
[18:53:27] CMySQLHandler::Query(SELECT * FROM `hazak` WHERE `hid` < 500 ORDER BY hID) - Successfully executed.
[18:53:27] >> mysql_store_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::StoreResult() - Result was stored.
[18:53:27] >> mysql_num_rows( Connection handle: 1 )
[18:53:27] CMySQLHandler::NumRows() - Returned 2 row(s)
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: -2097.03|16.7536|35.3203|2233.66|-1115.03|1050.88|Kyosuke_Hirino|10000000|0|1|5|1|1
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: -2096.47|21.0341|35.3203|235.323|1187.23|1080.26|Silverson_Camper|25000000|1|1|6|2|2
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] >> mysql_free_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[18:53:27] >> mysql_query( Connection handle: 1 )
[18:53:27] CMySQLHandler::Query(SELECT * FROM `vehicles`) - Successfully executed.
[18:53:27] >> mysql_store_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::StoreResult() - Result was stored.
[18:53:27] >> mysql_num_rows( Connection handle: 1 )
[18:53:27] CMySQLHandler::NumRows() - Returned 46 row(s)
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 560|-2072.67|-84.2226|34.8687|179.209|120|4|4|-21316.2|53|Sultan
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 549|-2077.17|-84.1672|34.8613|179.401|120|4|4|-8125.37|52|Tampa
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 410|-2081.31|-84.367|34.8182|180.08|120|4|4|-11982.2|51|Manana
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 408|-2226.66|293.078|35.6505|0.76685|3|6|6|-7329.42|50|Trashmaster
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 408|-2222.87|293.122|35.6626|359.863|3|6|6|-552.102|49|Trashmaster
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 408|-2218.27|293.532|35.6471|0.069785|3|6|6|35.8883|48|Trashmaster
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 408|-2214.08|293.124|35.6544|0.990259|3|6|6|1000|47|Trashmaster
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 408|-2209.66|293.809|35.6664|0.048465|3|6|6|967.299|46|Trashmaster
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 572|-1899.25|1105.73|45.2429|90.5971|2|4|4|945.236|45|Mower
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 572|-1899.06|1103.25|45.2218|89.5373|2|4|4|859.731|44|Mower
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 572|-1899.22|1101.27|45.2506|90.06|2|2|2|800.725|43|Mower
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 572|-1899.19|1099.4|45.2601|91.2334|2|1|1|974.985|42|Mower
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 574|-2201.31|291.867|34.8423|357.925|1|1|1|577.857|41|Sweeper
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 574|-2197.18|291.725|34.8424|359.564|1|1|1|884.962|40|Sweeper
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 574|-2192.47|291.753|34.8423|0.074018|1|1|1|628.967|39|Sweeper
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 574|-2188.33|291.773|34.8406|2.22541|1|1|1|1000|38|Sweeper
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 574|-2184.36|291.551|34.8424|359.469|1|1|1|964.59|37|Sweeper
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 574|-2179.97|291.594|34.8475|357.679|1|1|1|1000|36|Sweeper
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 532|-31.9038|45.0616|4.09023|252.143|4|0|0|968.889|54|Combine
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 531|-34.467|38.3856|3.08473|252.007|4|0|0|906.381|55|Tractor
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 531|-35.7001|35.2372|3.0837|249.023|4|0|0|-1698.02|56|Tractor
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 532|-36.5145|30.2154|4.09495|249.699|4|0|0|605.222|57|Combine
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 597|-1620.79|694.455|-5.42571|178.665|1|3|3|996.495|58|Police Car (SFPD)
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 597|-1616.6|694.672|-5.44252|178.412|1|0|0|1000|59|Police Car (SFPD)
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 597|-1612.81|694.668|-5.44534|178.049|1|0|1|1000|60|Police Car (SFPD)
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 597|-1608.52|694.649|-5.45085|179.972|1|0|1|1000|61|Police Car (SFPD)
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 523|-1595.56|674.479|-5.67118|330.815|1|0|1|1000|62|HPV-1000
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 523|-1598.38|673.939|-5.67074|334.516|1|0|1|1000|63|HPV-1000
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 427|-1639.93|686.477|-5.08529|269.191|1|0|1|879.137|64|Enforcer
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 599|-1640.81|682.279|-5.05278|270.017|1|0|1|986.889|65|Police Ranger
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2591.83|666.158|27.9601|269.614|2|0|0|1000|66|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2592.03|655.85|27.9617|270.739|2|6|1|1000|67|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2591.98|660.506|27.9665|269.908|2|6|1|1000|68|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2592|650.34|27.9616|270.255|2|6|1|1000|69|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2591.88|645.602|27.9614|268.7|2|6|1|1000|70|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2591.92|639.876|27.962|269.23|2|6|1|1000|71|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2592.02|635.051|27.9616|269.853|2|6|1|1000|72|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2584.05|626.366|27.9616|358.544|2|6|1|1000|73|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 416|-2578.86|626.192|27.9616|1.01202|2|6|1|1000|74|Ambulance
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 418|-2573.32|626.317|27.8994|0.476423|2|6|1|1000|75|Moonbeam
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 418|-2568.16|625.962|27.8996|0.254877|2|6|1|1000|76|Moonbeam
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 418|-2563.48|625.808|27.8997|358.193|2|6|1|1000|77|Moonbeam
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 523|-2557.76|627.018|27.3759|357.596|2|6|1|1000|78|HPV-1000
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 523|-2553.2|626.618|27.3855|352.884|2|6|1|1000|79|HPV-1000
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 417|-2646.42|658.115|66.1835|92.2045|2|6|1|1000|80|Leviathan
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] CMySQLHandler::FetchRow() - Return: 417|-2645.81|674.377|66.1835|93.19|2|6|1|1000|81|Leviathan
[18:53:27] >> mysql_fetch_row_format( Connection handle: 1 )
[18:53:27] >> mysql_free_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[18:53:27] >> mysql_query( Connection handle: 1 )
[18:53:27] CMySQLHandler::Query(SELECT * FROM `players` WHERE `name` = \'BuszNpc1\') - Successfully executed.
[18:53:27] >> mysql_store_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::StoreResult() - Result was stored.
[18:53:27] >> mysql_num_rows( Connection handle: 1 )
[18:53:27] CMySQLHandler::NumRows() - Returned 0 row(s)
[18:53:27] >> mysql_free_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[18:53:27] >> mysql_query( Connection handle: 1 )
[18:53:27] CMySQLHandler::Query(SELECT * FROM `players` WHERE `name` = \'Paraszt\') - Successfully executed.
[18:53:27] >> mysql_store_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::StoreResult() - Result was stored.
[18:53:27] >> mysql_num_rows( Connection handle: 1 )
[18:53:27] CMySQLHandler::NumRows() - Returned 0 row(s)
[18:53:27] >> mysql_free_result( Connection handle: 1 )
[18:53:27] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[18:53:54] >> mysql_query( Connection handle: 1 )
[18:53:54] CMySQLHandler::Query(SELECT * FROM `players` WHERE `name` = \'Kyosuke_Vanda\') - Successfully executed.
[18:53:54] >> mysql_store_result( Connection handle: 1 )
[18:53:54] CMySQLHandler::StoreResult() - Result was stored.
[18:53:54] >> mysql_num_rows( Connection handle: 1 )
[18:53:54] CMySQLHandler::NumRows() - Returned 1 row(s)
[18:53:54] >> mysql_free_result( Connection handle: 1 )
[18:53:54] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[18:54:31] >> mysql_real_escape_string( Connection handle: 1 )
[18:54:31] CMySQLHandler::EscapeString(asd); - Escaped 3 characters to asd.
[18:54:31] >> mysql_query( Connection handle: 1 )
[18:54:31] CMySQLHandler::Query(SELECT * FROM `players` WHERE `name` = \'Kyosuke_Vanda\' AND `pass` COLLATE `utf8_bin` LIKE \'asd\') - Successfully executed.
[18:54:31] >> mysql_store_result( Connection handle: 1 )
[18:54:31] CMySQLHandler::StoreResult() - Result was stored.
[18:54:31] >> mysql_num_rows( Connection handle: 1 )
[18:54:31] CMySQLHandler::NumRows() - Returned 1 row(s)
[18:54:31] >> mysql_fetch_row_format( Connection handle: 1 )
[18:54:31] CMySQLHandler::FetchRow() - Return: 79|Kyosuke_Vanda|31.200.153.77|asd|2012.09.07/15.40.45|2012.09.07/15.40.45|0|0|0|0|0|4|0|2021.73|2246.97|2103.95|0|0|0|0|0|0|0|0|0
[18:54:31] >> mysql_free_result( Connection handle: 1 )
[18:54:31] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[18:54:44] >> mysql_real_escape_string( Connection handle: 1 )
[18:54:44] CMySQLHandler::EscapeString(Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5); - Escaped 72 characters to Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5.
[18:54:44] >> mysql_query( Connection handle: 1 )
[18:54:44] CMySQLHandler::Query(INSERT INTO adminLog (value, tickcount) VALUES(\'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'1918367047\')) - Successfully executed.
[/quote]
sql lekérdezésnél ezt irja
mysql lekérésnél meg ezt irja:
#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 \'[18:27:13] >> mysql_query( Connection handle: 1 ) [18:27:13] CMySQLHandler::Que\' at line 1
meg valami olyasmit hogy escaped 72 characters vagy mit.
parancs a mentéshez
stock SavePlayer(playerid)
{
if(!GetPVarInt(playerid, \"LoggedIn\")) return 0;
//if(!IsPlayerNPC(playerid))
{
getdate(year, month, day);
gettime(hour, minute, second);
new Float:x;
new Float:y;
new Float:z;
GetPlayerPos(playerid,x,y,z);
format(query,sizeof(query),\"UPDATE `players` SET `laston` = \'%02d.%02d.%02d/%02d.%02d.%.%02d.%02d.%02d/%02d.%02d.%\', `money` = \'%d\', `munka` = \'%d\', `kills` = \'%d\', `deaths` = \'%d\', `fightingstyle` = \'%d\',`playerAdminLevel` = \'%d\', `playerPosX` = \'%f\', `playerPosY` = \'%f\', `playerPosZ` = \'%f\', `fizetes` = \'%d\', `hazkulcs` = \'%d\', `frakcio` = \'%d\', `telefon` = \'%d\', `ruha`= \'%d\', `telefonkonyv` = \'%d\', `ora` = \'%d\', `elsosegelylada` = \'%d\', `rang` = \'%d\' WHERE `reg_id` = \'%d\'\",
year, month, day, hour, minute, second, PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pJob], GetPVarInt(playerid, \"Kills\"), GetPVarInt(playerid, \"Deaths\"), GetPlayerFightingStyle(playerid),PlayerInfo[playerid][pAdminLevel],x,y,z,PlayerInfo[playerid][pFizetes],PlayerInfo[playerid][pHazkulcs],PlayerInfo[playerid][pFrakcio],PlayerInfo[playerid][pPhoneNumber],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][idoora],PlayerInfo[playerid][pKotszer],
PlayerInfo[playerid][pFrakcioRang],GetPVarInt(playerid, \"RegID\"));
// Ha minden igaz , mostmár nem a kézben lévõ (alap ) pénzt nézi , hanem a PlayerInfo[playerid][pMoney] értékét 
azaz Penz anticheat (Pipa), Pénz rendszer (99%)
mysql_query(query);
// %02d azt jelenti, hogyha a szám egyjegyû (1, 5, 7, stb... ), akkor tegyen elé egy 0-t. Pl: 05, 07...
// Ezt általában idõre használják, mivel így \'érthetõbb\'...
// Ez ugyanúgy mûködik %03d-vel %04d-vel, és így továb... ^
}
return 1;
}
sql tábla:
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Hoszt: localhost
-- Létrehozás ideje: 2012. szept. 08. 10:31
-- Szerver verzió: 5.5.16
-- PHP verzió: 5.3.8
SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";
SET time_zone = \"+00:00\";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Adatbázis: `fly`
--
-- --------------------------------------------------------
--
-- Tábla szerkezet: `adminlog`
--
CREATE TABLE IF NOT EXISTS `adminlog` (
`entryID` int(11) NOT NULL,
`value` varchar(255) NOT NULL,
`entryTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`tickcount` int(12) NOT NULL DEFAULT \'0\'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- A tábla adatainak kiíratása `adminlog`
--
INSERT INTO `adminlog` (`entryID`, `value`, `entryTime`, `tickcount`) VALUES
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 14:43:45\', 1910508289),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 15:16:27\', 1912469929),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 15:48:25\', 1914388339),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 15:54:41\', 1914764032),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 16:04:48\', 1915371193),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 16:10:07\', 1915690147),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 16:24:15\', 1916537711),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 16:54:44\', 1918367047),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 17:50:24\', 1921706829),
(0, \'Figyelem Kyosuke_Vanda kinevezte Kyosuke_Vanda-t adminnak. Adminszint: 5\', \'2012-09-07 18:07:58\', 1922761233),
(0, \'Figyelem Kyosuke_Vanda kinevezte Horvath_Tamas-t adminnak. Adminszint: 5\', \'2012-09-07 18:11:26\', 1922968652),
(0, \'Figyelem Kyosuke_Vanda kinevezte Roberto_Rashenkaz-t adminnak. Adminszint: 5\', \'2012-09-07 18:14:11\', 1923133948);
-- --------------------------------------------------------
--
-- Tábla szerkezet: `bankszamlak`
--
CREATE TABLE IF NOT EXISTS `bankszamlak` (
`bszsz` int(10) NOT NULL,
`bszj` int(10) NOT NULL,
`osszeg` int(15) NOT NULL,
`tulaj` varchar(24) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- A tábla adatainak kiíratása `bankszamlak`
--
INSERT INTO `bankszamlak` (`bszsz`, `bszj`, `osszeg`, `tulaj`) VALUES
(357709, 9786, 0, \'Silverson_Camper\'),
(847789, 9084, 10000, \'Kyosuke_Hirino\'),
(330027, 9979, 0, \'Vin_Diesel\'),
(996118, 2442, 0, \'Kyosuke_Hirino\'),
(379653, 8203, 0, \'Kyosuke_Hirino\'),
(825530, 3346, 0, \'Kosuke_Hirino\'),
(560527, 9249, 0, \'Bryan_Delfuego\'),
(869587, 3587, 0, \'Eddy_Morphy\');
-- --------------------------------------------------------
--
-- Tábla szerkezet: `connections`
--
CREATE TABLE IF NOT EXISTS `connections` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(21) NOT NULL,
`ip` varchar(16) NOT NULL,
`serial` varchar(128) NOT NULL,
`time` varchar(24) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Tábla szerkezet: `frakciok`
--
CREATE TABLE IF NOT EXISTS `frakciok` (
`nev` varchar(50) CHARACTER SET utf8 NOT NULL,
`rang1` varchar(50) CHARACTER SET utf8 NOT NULL,
`rang2` varchar(50) NOT NULL,
`rang3` varchar(50) NOT NULL,
`rang4` varchar(50) NOT NULL,
`rang5` varchar(50) NOT NULL,
`rang6` varchar(50) NOT NULL,
`rang7` varchar(50) NOT NULL,
`rang8` varchar(50) NOT NULL,
`rang9` varchar(50) NOT NULL,
`rang10` varchar(50) NOT NULL,
`rang11` varchar(50) NOT NULL,
`rang12` varchar(50) NOT NULL,
`rang13` varchar(50) NOT NULL,
`fizu1` int(11) NOT NULL,
`fizu2` int(11) NOT NULL,
`fizu3` int(11) NOT NULL,
`fizu4` int(11) NOT NULL,
`fizu5` int(11) NOT NULL,
`fizu6` int(11) NOT NULL,
`fizu7` int(11) NOT NULL,
`fizu8` int(11) NOT NULL,
`fizu9` int(11) NOT NULL,
`fizu10` int(11) NOT NULL,
`fizu11` int(11) NOT NULL,
`fizu12` int(11) NOT NULL,
`fizu13` int(11) NOT NULL,
`id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tábla szerkezet: `hazak`
--
CREATE TABLE IF NOT EXISTS `hazak` (
`X` float NOT NULL,
`Y` float NOT NULL,
`Z` float NOT NULL,
`EX` float NOT NULL,
`EY` float NOT NULL,
`EZ` float NOT NULL,
`tulaj` varchar(24) NOT NULL,
`ar` int(9) NOT NULL,
`zarva` int(1) NOT NULL,
`tulaja` int(1) NOT NULL,
`interior` int(2) NOT NULL,
`virworld` int(4) NOT NULL,
`hid` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- A tábla adatainak kiíratása `hazak`
--
INSERT INTO `hazak` (`X`, `Y`, `Z`, `EX`, `EY`, `EZ`, `tulaj`, `ar`, `zarva`, `tulaja`, `interior`, `virworld`, `hid`) VALUES
(-2097.03, 16.7536, 35.3203, 2233.66, -1115.03, 1050.88, \'Kyosuke_Hirino\', 10000000, 0, 1, 5, 1, 1),
(-2096.47, 21.0341, 35.3203, 235.323, 1187.23, 1080.26, \'Silverson_Camper\', 25000000, 1, 1, 6, 2, 2);
-- --------------------------------------------------------
--
-- Tábla szerkezet: `namechanges`
--
CREATE TABLE IF NOT EXISTS `namechanges` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`reg_id` mediumint(
NOT NULL,
`oldname` varchar(21) NOT NULL,
`newname` varchar(21) NOT NULL,
`time` varchar(24) NOT NULL,
PRIMARY KEY (`id`),
KEY `reg_id` (`reg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tábla szerkezet: `namechanges_p`
--
CREATE TABLE IF NOT EXISTS `namechanges_p` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`reg_id` mediumint( NOT NULL,
`name` varchar(24) NOT NULL,
`oldpass` varchar(21) NOT NULL,
`newpass` varchar(21) NOT NULL,
`time` varchar(24) NOT NULL,
PRIMARY KEY (`id`),
KEY `reg_id` (`reg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- A tábla adatainak kiíratása `namechanges_p`
--
INSERT INTO `namechanges_p` (`id`, `reg_id`, `name`, `oldpass`, `newpass`, `time`) VALUES
(1, 18, \'Silverson_Camper\', \'asdasd\', \'123\', \'2012.07.30/21.40.58\'),
(2, 18, \'Silverson_Camper\', \'123\', \'asdasd\', \'2012.07.30/21.41.03\');
-- --------------------------------------------------------
--
-- Tábla szerkezet: `players`
--
CREATE TABLE IF NOT EXISTS `players` (
`reg_id` mediumint( unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`ip` varchar(20) NOT NULL,
`pass` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`reg_date` varchar(24) NOT NULL,
`laston` varchar(24) NOT NULL,
`spawn1` int(11) NOT NULL DEFAULT \'1\',
`money` int(11) NOT NULL DEFAULT \'0\',
`munka` int(11) NOT NULL DEFAULT \'0\',
`kills` mediumint(11) unsigned NOT NULL DEFAULT \'0\',
`deaths` mediumint(11) unsigned NOT NULL DEFAULT \'0\',
`fightingstyle` enum(\'4\',\'5\',\'6\',\'7\',\'15\',\'16\') NOT NULL DEFAULT \'4\',
`playerAdminLevel` int(6) NOT NULL DEFAULT \'0\',
`playerPosX` float DEFAULT \'2021.73\',
`playerPosY` float DEFAULT \'2246.97\',
`playerPosZ` float DEFAULT \'2103.95\',
`Fizetes` int(11) NOT NULL,
`hazkulcs` int(11) NOT NULL,
`frakcio` int(11) NOT NULL,
`telefon` int(11) NOT NULL DEFAULT \'0\',
`ruha` int(11) NOT NULL DEFAULT \'0\',
`telefonkonyv` int(11) NOT NULL DEFAULT \'0\',
`ora` int(11) NOT NULL DEFAULT \'0\',
`elsosegelylada` int(11) NOT NULL DEFAULT \'0\',
`rang` int(11) NOT NULL,
PRIMARY KEY (`reg_id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=82 ;
--
-- A tábla adatainak kiíratása `players`
--
INSERT INTO `players` (`reg_id`, `name`, `ip`, `pass`, `reg_date`, `laston`, `spawn1`, `money`, `munka`, `kills`, `deaths`, `fightingstyle`, `playerAdminLevel`, `playerPosX`, `playerPosY`, `playerPosZ`, `Fizetes`, `hazkulcs`, `frakcio`, `telefon`, `ruha`, `telefonkonyv`, `ora`, `elsosegelylada`, `rang`) VALUES
(81, \'Roberto_Rashenkaz\', \'78.153.104.195\', \'asdasd\', \'2012.09.07/20.12.46\', \'2012.09.07/20.12.46\', 0, 0, 0, 0, 0, \'4\', 0, 2021.73, 2246.97, 2103.95, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(80, \'Horvath_Tamas\', \'145.236.104.95\', \'Sanyi1993\', \'2012.09.07/20.07.08\', \'2012.09.07/20.07.08\', 0, 0, 0, 0, 0, \'4\', 0, 2021.73, 2246.97, 2103.95, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79, \'Kyosuke_Vanda\', \'31.200.153.77\', \'asd\', \'2012.09.07/15.40.45\', \'2012.09.07/15.40.45\', 0, 0, 0, 0, 0, \'4\', 0, 2021.73, 2246.97, 2103.95, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Tábla szerkezet: `queryerrors`
--
CREATE TABLE IF NOT EXISTS `queryerrors` (
`id` mediumint(7) NOT NULL AUTO_INCREMENT,
`errorid` int(11) NOT NULL,
`error` text NOT NULL,
`resultid` mediumint(7) NOT NULL,
`extraid` mediumint(7) NOT NULL,
`callback` varchar(512) NOT NULL,
`sql_query` varchar(512) NOT NULL,
`connectionHandle` mediumint(7) NOT NULL,
`time` varchar(24) NOT NULL,
PRIMARY KEY (`id`),
KEY `errorid` (`errorid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tábla szerkezet: `vehicles`
--
CREATE TABLE IF NOT EXISTS `vehicles` (
`VehicleModel` int(3) NOT NULL,
`VehicleX` float NOT NULL,
`VehicleY` float NOT NULL,
`VehicleZ` float NOT NULL,
`VehicleAngle` float NOT NULL,
`munka` int(2) NOT NULL,
`Szin1` int(3) NOT NULL,
`Szin2` int(3) NOT NULL,
`Health` float NOT NULL,
`ID` int(4) NOT NULL AUTO_INCREMENT,
`Tipus` varchar(30) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;
--
-- A tábla adatainak kiíratása `vehicles`
--
INSERT INTO `vehicles` (`VehicleModel`, `VehicleX`, `VehicleY`, `VehicleZ`, `VehicleAngle`, `munka`, `Szin1`, `Szin2`, `Health`, `ID`, `Tipus`) VALUES
(560, -2072.67, -84.2226, 34.8687, 179.209, 120, 4, 4, -21316.2, 53, \'Sultan\'),
(549, -2077.17, -84.1672, 34.8613, 179.401, 120, 4, 4, -8125.37, 52, \'Tampa\'),
(410, -2081.31, -84.367, 34.8182, 180.08, 120, 4, 4, -11982.2, 51, \'Manana\'),
(408, -2226.66, 293.078, 35.6505, 0.76685, 3, 6, 6, -7329.42, 50, \'Trashmaster\'),
(408, -2222.87, 293.122, 35.6626, 359.863, 3, 6, 6, -552.102, 49, \'Trashmaster\'),
(408, -2218.27, 293.532, 35.6471, 0.069785, 3, 6, 6, 35.8883, 48, \'Trashmaster\'),
(408, -2214.08, 293.124, 35.6544, 0.990259, 3, 6, 6, 1000, 47, \'Trashmaster\'),
(408, -2209.66, 293.809, 35.6664, 0.048465, 3, 6, 6, 967.299, 46, \'Trashmaster\'),
(572, -1899.25, 1105.73, 45.2429, 90.5971, 2, 4, 4, 945.236, 45, \'Mower\'),
(572, -1899.06, 1103.25, 45.2218, 89.5373, 2, 4, 4, 859.731, 44, \'Mower\'),
(572, -1899.22, 1101.27, 45.2506, 90.06, 2, 2, 2, 800.725, 43, \'Mower\'),
(572, -1899.19, 1099.4, 45.2601, 91.2334, 2, 1, 1, 974.985, 42, \'Mower\'),
(574, -2201.31, 291.867, 34.8423, 357.925, 1, 1, 1, 577.857, 41, \'Sweeper\'),
(574, -2197.18, 291.725, 34.8424, 359.564, 1, 1, 1, 884.962, 40, \'Sweeper\'),
(574, -2192.47, 291.753, 34.8423, 0.074018, 1, 1, 1, 628.967, 39, \'Sweeper\'),
(574, -2188.33, 291.773, 34.8406, 2.22541, 1, 1, 1, 1000, 38, \'Sweeper\'),
(574, -2184.36, 291.551, 34.8424, 359.469, 1, 1, 1, 964.59, 37, \'Sweeper\'),
(574, -2179.97, 291.594, 34.8475, 357.679, 1, 1, 1, 1000, 36, \'Sweeper\'),
(532, -31.9038, 45.0616, 4.09023, 252.143, 4, 0, 0, 968.889, 54, \'Combine\'),
(531, -34.467, 38.3856, 3.08473, 252.007, 4, 0, 0, 906.381, 55, \'Tractor\'),
(531, -35.7001, 35.2372, 3.0837, 249.023, 4, 0, 0, -1698.02, 56, \'Tractor\'),
(532, -36.5145, 30.2154, 4.09495, 249.699, 4, 0, 0, 605.222, 57, \'Combine\'),
(597, -1620.79, 694.455, -5.42571, 178.665, 1, 3, 3, 996.495, 58, \'Police Car (SFPD)\'),
(597, -1616.6, 694.672, -5.44252, 178.412, 1, 0, 0, 1000, 59, \'Police Car (SFPD)\'),
(597, -1612.81, 694.668, -5.44534, 178.049, 1, 0, 1, 1000, 60, \'Police Car (SFPD)\'),
(597, -1608.52, 694.649, -5.45085, 179.972, 1, 0, 1, 1000, 61, \'Police Car (SFPD)\'),
(523, -1595.56, 674.479, -5.67118, 330.815, 1, 0, 1, 1000, 62, \'HPV-1000\'),
(523, -1598.38, 673.939, -5.67074, 334.516, 1, 0, 1, 1000, 63, \'HPV-1000\'),
(427, -1639.93, 686.477, -5.08529, 269.191, 1, 0, 1, 879.137, 64, \'Enforcer\'),
(599, -1640.81, 682.279, -5.05278, 270.017, 1, 0, 1, 986.889, 65, \'Police Ranger\'),
(416, -2591.83, 666.158, 27.9601, 269.614, 2, 0, 0, 1000, 66, \'Ambulance\'),
(416, -2592.03, 655.85, 27.9617, 270.739, 2, 6, 1, 1000, 67, \'Ambulance\'),
(416, -2591.98, 660.506, 27.9665, 269.908, 2, 6, 1, 1000, 68, \'Ambulance\'),
(416, -2592, 650.34, 27.9616, 270.255, 2, 6, 1, 1000, 69, \'Ambulance\'),
(416, -2591.88, 645.602, 27.9614, 268.7, 2, 6, 1, 1000, 70, \'Ambulance\'),
(416, -2591.92, 639.876, 27.962, 269.23, 2, 6, 1, 1000, 71, \'Ambulance\'),
(416, -2592.02, 635.051, 27.9616, 269.853, 2, 6, 1, 1000, 72, \'Ambulance\'),
(416, -2584.05, 626.366, 27.9616, 358.544, 2, 6, 1, 1000, 73, \'Ambulance\'),
(416, -2578.86, 626.192, 27.9616, 1.01202, 2, 6, 1, 1000, 74, \'Ambulance\'),
(418, -2573.32, 626.317, 27.8994, 0.476423, 2, 6, 1, 1000, 75, \'Moonbeam\'),
(418, -2568.16, 625.962, 27.8996, 0.254877, 2, 6, 1, 1000, 76, \'Moonbeam\'),
(418, -2563.48, 625.808, 27.8997, 358.193, 2, 6, 1, 1000, 77, \'Moonbeam\'),
(523, -2557.76, 627.018, 27.3759, 357.596, 2, 6, 1, 1000, 78, \'HPV-1000\'),
(523, -2553.2, 626.618, 27.3855, 352.884, 2, 6, 1, 1000, 79, \'HPV-1000\'),
(417, -2646.42, 658.115, 66.1835, 92.2045, 2, 6, 1, 1000, 80, \'Leviathan\'),
(417, -2645.81, 674.377, 66.1835, 93.19, 2, 6, 1, 1000, 81, \'Leviathan\');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
query sting érték
new // +1, mert valahol a \'0-t is tárolni kell \'
query[1024], // lekérdezéseket ebben tároljuk
line[128 +1],
i_str[128 +1],
tmp[128 +1],
name[24 +1],
ip[16 +1];
Köszönöm elöre is fontos lenne
