• 01-11-2008, 18:47:37
    #1
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\siteadi.com\httpdocs\_ip_block.p hp on line 14

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\siteadi.com\httpdocs\_ip_block.p hp on line 15

    arkadaşlar php ye yeniyim bi script kuruyorum bu hatayı alıyorum problem neden kaynaklanıyo olabilir.nereyi düzeltmem gerekir? teşekkürler...
  • 01-11-2008, 18:56:06
    #2
    Üyeliği durduruldu
    14 ve 15. satırlardaki kodları buraya kopyala yapıştır yapar mısın.
  • 01-11-2008, 18:57:49
    #3
    tabiiki _ipblock klasöründe 14.15 satırlar

    $data = mysql_fetch_array($resultLijstIp);
    if (mysql_num_rows($resultLijstIp) == 1) {

    bu kodlar var
  • 01-11-2008, 19:51:36
    #4
    $resultLijstIp degişkenindeki sorguda hata var..

    bu kodlarla sana anca bu kadar yardım edebilirim..
  • 01-11-2008, 22:42:39
    #5
    sana yardım edebilmemiz için sql sorgusunu yazman gerek
  • 02-11-2008, 04:27:11
    #6
    Üyeliği durduruldu
    Sorgudaki, MySQL Tablosuna Ait 1 Yada 1'den Fazla Sütün Eksik Yada Fazla.
    Order by, Group by , Where vs.. Kontrol ediniz.
  • 02-11-2008, 04:54:45
    #7
    Kimlik doğrulama veya yönetimden onay bekliyor.
    tetik77 adlı üyeden alıntı: mesajı görüntüle
    tabiiki _ipblock klasöründe 14.15 satırlar

    $data = mysql_fetch_array($resultLijstIp);
    if (mysql_num_rows($resultLijstIp) == 1) {

    bu kodlar var
    arkadaşlarında dediği gibi $resultLijstIp bu bölümde sorun var ancak mantıkdan yola çıkıp isim den hareket edersek eğer ( kodlarını bilmiyoruz sonuçta resultLijstIp'i nasıl çektirdiğini ve tablo yapını bilmediğimizden ) resultLijstIp = result List Ip olabilir mi acaba arada bir j fazla var gibi, yani $resultLijstIp değilde $resultListIp ... Eğer böyle değilse $resultLijstIp'i nasıl çektirdiğini ve tablo yapını yayınlarsan yardımcı olabiliriz...
  • 02-11-2008, 18:05:49
    #8
    merhabalar tablo yapısı budur umarım db dosyasında olan şeyleri yapıştırdım

    CREATE TABLE `[land]` (
    `owner` varchar(255) NOT NULL default '',
    `id` int(255) NOT NULL default '0',
    `type` int(255) NOT NULL default '0'
    ) TYPE=MyISAM;

    INSERT INTO `[land]` VALUES ('none', 1, 0);
    INSERT INTO `[land]` VALUES ('none', 2, 0);
    INSERT INTO `[land]` VALUES ('none', 3, 0);
    INSERT INTO `[land]` VALUES ('none', 4, 0);
    INSERT INTO `[land]` VALUES ('none', 5, 0);
    INSERT INTO `[land]` VALUES ('none', 6, 0);
    INSERT INTO `[land]` VALUES ('none', 7, 0);
    INSERT INTO `[land]` VALUES ('none', 8, 0);
    INSERT INTO `[land]` VALUES ('none', 9, 0);
    INSERT INTO `[land]` VALUES ('none', 10, 0);
    INSERT INTO `[land]` VALUES ('none', 11, 0);
    INSERT INTO `[land]` VALUES ('none', 12, 0);
    INSERT INTO `[land]` VALUES ('none', 13, 0);
    INSERT INTO `[land]` VALUES ('none', 14, 0);
    INSERT INTO `[land]` VALUES ('none', 15, 0);
    INSERT INTO `[land]` VALUES ('none', 16, 0);
    INSERT INTO `[land]` VALUES ('none', 17, 0);
    INSERT INTO `[land]` VALUES ('none', 18, 0);
    INSERT INTO `[land]` VALUES ('none', 19, 0);
    INSERT INTO `[land]` VALUES ('none', 20, 0);
    INSERT INTO `[land]` VALUES ('none', 21, 0);
    INSERT INTO `[land]` VALUES ('none', 22, 0);
    INSERT INTO `[land]` VALUES ('none', 23, 0);
    INSERT INTO `[land]` VALUES ('none', 24, 0);
    INSERT INTO `[land]` VALUES ('none', 25, 0);
    INSERT INTO `[land]` VALUES ('none', 26, 0);
    INSERT INTO `[land]` VALUES ('none', 27, 0);
    INSERT INTO `[land]` VALUES ('none', 28, 0);
    INSERT INTO `[land]` VALUES ('none', 29, 0);
    INSERT INTO `[land]` VALUES ('none', 30, 0);
    INSERT INTO `[land]` VALUES ('none', 31, 0);
    INSERT INTO `[land]` VALUES ('none', 32, 0);
    INSERT INTO `[land]` VALUES ('none', 33, 0);
    INSERT INTO `[land]` VALUES ('none', 34, 0);
    INSERT INTO `[land]` VALUES ('none', 35, 0);
    INSERT INTO `[land]` VALUES ('none', 36, 0);
    INSERT INTO `[land]` VALUES ('none', 37, 0);
    INSERT INTO `[land]` VALUES ('none', 38, 0);
    INSERT INTO `[land]` VALUES ('none', 39, 0);
    INSERT INTO `[land]` VALUES ('none', 40, 0);
    INSERT INTO `[land]` VALUES ('none', 41, 0);
    INSERT INTO `[land]` VALUES ('none', 42, 0);
    INSERT INTO `[land]` VALUES ('none', 44, 0);
    INSERT INTO `[land]` VALUES ('none', 43, 0);
    INSERT INTO `[land]` VALUES ('none', 45, 0);
    INSERT INTO `[land]` VALUES ('none', 46, 0);
    INSERT INTO `[land]` VALUES ('none', 47, 0);
    INSERT INTO `[land]` VALUES ('none', 48, 0);
    INSERT INTO `[land]` VALUES ('none', 49, 0);
    INSERT INTO `[land]` VALUES ('none', 50, 0);
    INSERT INTO `[land]` VALUES ('none', 51, 0);
    INSERT INTO `[land]` VALUES ('none', 52, 0);
    INSERT INTO `[land]` VALUES ('none', 53, 0);
    INSERT INTO `[land]` VALUES ('none', 54, 0);
    INSERT INTO `[land]` VALUES ('none', 55, 0);

    CREATE TABLE `auctions` (
    `id` int(255) NOT NULL auto_increment,
    `what` varchar(255) default NULL,
    `by` varchar(255) default NULL,
    `country` varchar(255) default NULL,
    `hbid` int(255) NOT NULL default '0',
    `reason` varchar(255) default NULL,
    `datem` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=13 ;

    CREATE TABLE `auctions_data` (
    `id` int(255) NOT NULL auto_increment,
    `itemid` int(255) default NULL,
    `who` varchar(255) default NULL,
    `money` int(255) default '0',
    `datem` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=20 ;

    CREATE TABLE `berichten` (
    `id` int(11) NOT NULL auto_increment,
    `username` varchar(255) default NULL,
    `bericht` varchar(255) default NULL,
    `topic` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=2 ;

    CREATE TABLE `blackjack` (
    `id` int(255) NOT NULL auto_increment,
    `better` varchar(255) default NULL,
    `bet` int(255) NOT NULL default '0',
    `state` varchar(255) default NULL,
    `card1` varchar(255) default NULL,
    `card2` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=4 ;

    CREATE TABLE `booze` (
    `Beer` varchar(255) default '0',
    `Rum` varchar(255) default '0',
    `Whiskey` varchar(255) default '0',
    `Vodka` varchar(255) default '0',
    `state` varchar(255) default NULL
    ) TYPE=MyISAM;

    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Netherlands');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Italy');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'United States');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Japan');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Poland');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Russia');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Columbia');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'China');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'France');
    INSERT INTO `booze` VALUES ('5724', '467', '7953', '157', 'Australia');

    CREATE TABLE `booze_units` (
    `id` int(255) NOT NULL auto_increment,
    `booze_` varchar(255) default NULL,
    `ammount` int(255) NOT NULL default '0',
    `user_booze_` varchar(255) default NULL,
    `state` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=3 ;

    CREATE TABLE `casino` (
    `id` varchar(255) default NULL,
    `owner_casino` varchar(255) default NULL,
    `max_bet` varchar(255) NOT NULL default '2000',
    `state_cas` varchar(255) default NULL
    ) TYPE=MyISAM;

    INSERT INTO `casino` VALUES ('2', 'GaLiL', '50000', 'Italy');
    INSERT INTO `casino` VALUES ('3', 'GaLiL', '2000', 'United States');
    INSERT INTO `casino` VALUES ('4', 'GaLiL', '2000', 'Japan');
    INSERT INTO `casino` VALUES ('5', 'GaLiL', '2000', 'Poland');
    INSERT INTO `casino` VALUES ('6', 'GaLiL', '2000', 'Russia');
    INSERT INTO `casino` VALUES ('7', 'GaLiL', '2000', 'Columbia');
    INSERT INTO `casino` VALUES ('8', 'GaLiL', '2000', 'China');
    INSERT INTO `casino` VALUES ('9', 'GaLiL', '2000', 'Netherlands');
    INSERT INTO `casino` VALUES ('10', 'GaLiL', '2000', 'France');
    INSERT INTO `casino` VALUES ('11', 'GaLiL', '2000', 'Australia');



    CREATE TABLE `crews` (
    `id` int(255) NOT NULL auto_increment,
    `name` varchar(255) default NULL,
    `boss` varchar(255) default NULL,
    `bank` varchar(255) NOT NULL default '2000',
    `recruiter` varchar(255) default NULL,
    `cleaner` varchar(255) default NULL,
    `rang` varchar(255) NOT NULL default '1',
    UNIQUE KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=14 ;


    CREATE TABLE `death` (
    `id` int(255) NOT NULL auto_increment,
    `who` varchar(255) default NULL,
    `bywho` varchar(255) default NULL,
    `when` varchar(255) default NULL,
    `rank` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;


    CREATE TABLE `factory` (
    `id` int(255) NOT NULL auto_increment,
    `owner` varchar(255) default NULL,
    `bullets` int(255) NOT NULL default '2000',
    `producing` varchar(255) NOT NULL default '10',
    `offer` varchar(255) default NULL,
    `state` varchar(255) default NULL,
    `stamp` varchar(255) default NULL,
    `price` int(255) NOT NULL default '500',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=11 ;

    INSERT INTO `factory` VALUES (1, 'admin', 3500, '0', NULL, 'Italy', '1128097350', 500);
    INSERT INTO `factory` VALUES (2, 'GaLiL', 3500, '0', NULL, 'United States', '1128097350', 500);
    INSERT INTO `factory` VALUES (3, 'GaLiL', 3500, '0', NULL, 'Japan', '1128097350', 500);
    INSERT INTO `factory` VALUES (4, 'GaLiL', 3500, '0', NULL, 'Poland', '1128097350', 500);
    INSERT INTO `factory` VALUES (5, 'GaLiL', 3500, '0', NULL, 'Russia', '1128097350', 500);
    INSERT INTO `factory` VALUES (6, 'GaLiL', 3500, '0', NULL, 'Columbia', '1128097350', 500);
    INSERT INTO `factory` VALUES (7, 'GaLiL', 3500, '0', NULL, 'China', '1128097350', 500);
    INSERT INTO `factory` VALUES (8, 'GaLiL', 3500, '0', NULL, 'Netherlands', '1128097350', 500);
    INSERT INTO `factory` VALUES (9, 'GaLiL', 3500, '0', NULL, 'France', '1128097350', 500);
    INSERT INTO `factory` VALUES (10, 'GaLiL', 3500, '0', NULL, 'Australia', '1128097350', 500);

    CREATE TABLE `forum` (
    `id` int(11) NOT NULL auto_increment,
    `username` varchar(255) default NULL,
    `naam` varchar(255) default NULL,
    `datum` varchar(255) default NULL,
    `locked` int(1) NOT NULL default '0',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=3 ;

    CREATE TABLE `forummess` (
    `datum` datetime NOT NULL default '0000-00-00 00:00:00',
    `titel` varchar(255) NOT NULL default '',
    `text` text NOT NULL,
    `schrijver` varchar(255) NOT NULL default '',
    `forum` int(255) NOT NULL default '1',
    `id` int(255) NOT NULL auto_increment,
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=2313 ;

    INSERT INTO `forummess` VALUES ('0000-00-00 00:00:00', 'Welcome', 'Welcome to the bugs section.', 'GaLiL', 2, 2311);

    CREATE TABLE `gta` (
    `id` int(255) NOT NULL auto_increment,
    `type` varchar(255) default NULL,
    `damage` varchar(255) default NULL,
    `location_car` varchar(255) default NULL,
    `owner_car` varchar(255) default NULL,
    `orginal` varchar(255) default NULL,
    `ship_time` varchar(255) default NULL,
    `when` varchar(255) default NULL,
    `3` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=69 ;

    CREATE TABLE `hitlist` (
    `id` int(11) NOT NULL auto_increment,
    `target` varchar(255) NOT NULL default '',
    `payer` varchar(255) NOT NULL default '',
    `ammount` int(255) NOT NULL default '0',
    `reason` varchar(255) NOT NULL default '',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=5 ;


    CREATE TABLE `inbox` (
    `id` int(5) NOT NULL auto_increment,
    `username` varchar(255) default NULL,
    `reciever` varchar(255) default NULL,
    `datem` varchar(255) default NULL,
    `baricht` text,
    `unread` int(1) NOT NULL default '0',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=97 ;

    CREATE TABLE `ip_block` (
    `ip` varchar(255) default NULL
    ) TYPE=MyISAM;

    CREATE TABLE `jail` (
    `id` int(11) NOT NULL auto_increment,
    `whoinjail` varchar(255) default NULL,
    `whenarrest` varchar(255) default NULL,
    `tillwhen` varchar(255) default NULL,
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=80 ;

    CREATE TABLE `jailbox` (
    `id` int(5) NOT NULL auto_increment,
    `sender` varchar(255) default NULL,
    `reciever` varchar(255) default NULL,
    `datem` varchar(255) default NULL,
    `baricht` text,
    `unread` int(1) NOT NULL default '0',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=32 ;

    CREATE TABLE `loggedin` (
    `username` varchar(255) default NULL,
    `password` varchar(255) default NULL,
    `datem` varchar(255) default NULL,
    `ip` varchar(255) default NULL
    ) TYPE=MyISAM;

    CREATE TABLE `oc` (
    `id` int(255) NOT NULL auto_increment,
    `leader` varchar(255) default NULL,
    `weapon_expert` varchar(255) default NULL,
    `explosive_expert` varchar(255) default NULL,
    `driver` varchar(255) default NULL,
    `location_oc` varchar(255) default NULL,
    `datem` varchar(255) default NULL,
    `we` varchar(255) default NULL,
    `ee` varchar(255) default NULL,
    `dr` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=6 ;


    CREATE TABLE `oc_offers` (
    `id` int(255) NOT NULL auto_increment,
    `who` varchar(255) default NULL,
    `towho` varchar(255) default NULL,
    `state` varchar(255) default NULL,
    `bewhat` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=5 ;


    CREATE TABLE `offerscrew` (
    `id` int(255) NOT NULL auto_increment,
    `name` varchar(255) default NULL,
    `crew` varchar(255) default NULL,
    `accepted` char(1) NOT NULL default '0',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=7 ;

    CREATE TABLE `online` (
    `ip` varchar(255) default NULL,
    `login` varchar(255) default NULL
    ) TYPE=MyISAM;

    CREATE TABLE `playermess` (
    `titel` varchar(255) NOT NULL default '',
    `datum` datetime NOT NULL default '0000-00-00 00:00:00',
    `forum` int(255) NOT NULL default '1',
    `text` text NOT NULL,
    `poster` varchar(255) NOT NULL default '',
    `id` int(255) NOT NULL auto_increment,
    `last` datetime NOT NULL default '0000-00-00 00:00:00',
    `type` int(1) NOT NULL default '0',
    `locked` int(1) NOT NULL default '0',
    `protected` int(1) NOT NULL default '0',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=520 ;

    INSERT INTO `playermess` VALUES ('Read This First!', '2005-09-25 22:03:35', 2, 'Welcome to the bugs section.\r\nPlease read all another bugs first before posting your own found bug!', 'GaLiL', 517, '2005-09-25 22:03:35', 3, 1, 0);


    CREATE TABLE `search` (
    `id` int(255) NOT NULL auto_increment,
    `killer` varchar(255) NOT NULL default '',
    `target` varchar(255) NOT NULL default '',
    `detective` varchar(255) NOT NULL default '',
    `searchdate` varchar(255) NOT NULL default '',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=5 ;

    CREATE TABLE `stats` (
    `type` int(1) NOT NULL default '0',
    `extra` varchar(100) NOT NULL default '',
    `value1` int(11) NOT NULL default '0',
    `value2` int(11) NOT NULL default '0',
    `datum` int(20) NOT NULL default '0',
    `maand` int(20) NOT NULL default '0',
    `jaar` int(20) NOT NULL default '0',
    `ip` varchar(100) NOT NULL default ''
    ) TYPE=MyISAM;

    INSERT INTO `stats` VALUES (2, '', 1, 614, 1127944800, 9, 2005, '');
    INSERT INTO `stats` VALUES (3, 'Grand Theft Auto', 127, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Crime', 123, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (1, '', 1, 1216, 1050247515, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Forum', 26, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Travel', 31, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Find Player', 8, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'View Profile', 8, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Users Online', 5, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Organised Crime', 60, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Faq', 5, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Mobile Zone', 3, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Stats', 8, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Crew', 21, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Jail', 51, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Inbox', 28, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Jailbox', 8, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'At Home', 13, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Bank', 7, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Booze Cartel', 13, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Buy Stuff', 5, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Bullet Factory', 125, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Search/Kill', 4, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Hitlist', 336, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'BlackJack', 44, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Disconnect', 47, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Index', 112, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (3, 'Supported phones', 1, 0, 0, 0, 0, '');
    INSERT INTO `stats` VALUES (4, '', 0, 0, 1128031200, 0, 0, '127.0.0.1');
    INSERT INTO `stats` VALUES (2, '', 1, 606, 1128031200, 9, 2005, '');
    INSERT INTO `stats` VALUES (3, 'Screenshots', 1, 0, 0, 0, 0, '');

    CREATE TABLE `steden` (
    `id` int(255) NOT NULL auto_increment,
    `welke` varchar(255) default NULL,
    `prijs` int(255) NOT NULL default '0',
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=11 ;

    INSERT INTO `steden` VALUES (1, 'Italy', 200);
    INSERT INTO `steden` VALUES (2, 'United States', 0);
    INSERT INTO `steden` VALUES (3, 'Japan', 0);
    INSERT INTO `steden` VALUES (4, 'Poland', 200);
    INSERT INTO `steden` VALUES (5, 'Russia', 200);
    INSERT INTO `steden` VALUES (6, 'Columbia', 0);
    INSERT INTO `steden` VALUES (7, 'China', 0);
    INSERT INTO `steden` VALUES (8, 'Netherlands', 0);
    INSERT INTO `steden` VALUES (9, 'France', 0);
    INSERT INTO `steden` VALUES (10, 'Australia', 0);

    CREATE TABLE `transfers` (
    `id` int(255) NOT NULL auto_increment,
    `whosend` varchar(255) default NULL,
    `whoreceived` varchar(255) default NULL,
    `moneywhat` varchar(255) default NULL,
    `when` varchar(255) default NULL,
    KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=3 ;

    CREATE TABLE `users` (
    `id` int(5) NOT NULL auto_increment,
    `username` varchar(255) default NULL,
    `password` varchar(255) default NULL,
    `rang` varchar(255) NOT NULL default '0',
    `geld` int(255) NOT NULL default '1500',
    `crew` varchar(255) NOT NULL default '0',
    `health` varchar(255) NOT NULL default '100',
    `gun` varchar(255) NOT NULL default '0',
    `protection` varchar(255) NOT NULL default '0',
    `quote` varchar(255) NOT NULL default 'No quote',
    `kills` varchar(255) NOT NULL default '0',
    `crime` varchar(255) NOT NULL default '0',
    `gta` varchar(255) NOT NULL default '0',
    `oc` varchar(255) NOT NULL default '0',
    `locatie` varchar(255) NOT NULL default 'Roggel',
    `recover` varchar(255) NOT NULL default '0',
    `travel` varchar(255) NOT NULL default '0',
    `bank` varchar(255) NOT NULL default '0',
    `timebank` varchar(255) NOT NULL default '0',
    `online` varchar(255) NOT NULL default '0',
    `moderator` varchar(255) NOT NULL default '0',
    `signedup` varchar(255) default NULL,
    `blank` varchar(255) NOT NULL default '0',
    `latina` varchar(255) NOT NULL default '0',
    `asian` varchar(255) NOT NULL default '0',
    `black` varchar(255) NOT NULL default '0',
    `specialised` varchar(255) NOT NULL default '0',
    `email` varchar(255) default NULL,
    KEY `userid` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=7 ;

    CREATE TABLE `woman` (
    `blank` varchar(255) NOT NULL default '0',
    `latina` varchar(255) NOT NULL default '0',
    `asian` varchar(255) NOT NULL default '0',
    `black` varchar(255) NOT NULL default '0',
    `state` varchar(255) default NULL
    ) TYPE=MyISAM;
  • 02-11-2008, 18:16:51
    #9
    arkadaşlar scriptide paylaşıyım kuramadığım scripti daha önce verildi zaaten birçok defa

    RapidShare: Easy Filehosting bunu kuramadım yardımcı olacak arkadaşlar olursa çok sevinirim çünkü php den pek anlamıyorum.teşekkürler...