my Gaming ladder brauche hilfe

Dieses Thema im Forum "Webentwicklung" wurde erstellt von DerFreak, 17. Juni 2006 .

Status des Themas:
Es sind keine weiteren Antworten möglich.
  1. Diese Seite verwendet Cookies. Wenn du dich weiterhin auf dieser Seite aufhältst, akzeptierst du unseren Einsatz von Cookies. Weitere Informationen
  1. #1 17. Juni 2006
    moin moin

    habe mir ebend das ladder script installiert nur halt jetzt habe ich diese fehler hier


    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/f/fightclub-league.com/public_html/ladder/home.php on line 91


    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/f/fightclub-league.com/public_html/ladder/functions/matchdb.php on line 61

    usw
    kan mir jemand sagen was da falsch gelaufen ist????
     

  2. Anzeige
  3. #2 17. Juni 2006
    1. was is ladder script.

    2. wie sieht der code aus.

    :p
     
  4. #3 17. Juni 2006
    ladder ist z.b wo sich leute anmelden und clans gegen clans spielen können

    hier mal der code

    <?

    if(!$indexloaded){
    header("Location: ./index.php");
    }



    function main_page(){
    global $dir, $url, $file, $out, $misc;



    include("$dir[func]/userstats.php");

    $stats=user_stats();



    $tablehead=table_head("show","100%","","left");
    $tablefoot=table_foot("show");


    $bannerhead=table_head("show","488","80","center");
    $bannerfoot=table_foot("show");





    $lastmatches=mysql_query("SELECT matchid,winneralias,loseralias FROM matchdb ORDER by confirmdate DESC LIMIT 5");

    while(list($matchid,$winneralias,$loseralias)=mysql_fetch_row($lastmatches)){
    $recentmatches=$recentmatches."$out[bulletleft] <a href='$url[base]/$file[match]?matchid=$matchid'>$winneralias vs $loseralias</a><br>";
    }

    if(!$recentmatches){
    $recentmatches="$out[bulletleft] No Recent Matches";
    }

    $comingmatches=mysql_query("SELECT challid,challengeralias,challengedalias FROM challenges WHERE finalizedby > '0' ORDER by finalizedtime DESC LIMIT 5");

    while(list($matchid,$winneralias,$loseralias)=mysql_fetch_row($comingmatches)){
    $upcomingmatches=$upcomingmatches."$out[bulletleft] <a href='$url[base]/$file[match]?challid=$matchid'>$winneralias vs $loseralias</a><br>";
    }

    if(!$upcomingmatches){
    $upcomingmatches="$out[bulletleft] No Upcoming Matches";
    }





    //GET LINKS

    $topfiles=mysql_query("SELECT id,name,imageurl FROM links ORDER by id");

    while(list($linkid,$linkname,$linkimage)=mysql_fetch_row($topfiles)){



    if(!$linkimage){

    $linklist=$linklist."$out[bulletleft] <a href='$url[base]/$file[links]?linkid=$linkid' target='top'>$linkname</a><br>";

    }else{

    $linklistb=$linklistb."<br><center><a href='$url[base]/$file[links]?linkid=$linkid' target='top'><img src='$linkimage' border='0' alt='$linkname'></a></center>";

    }

    $linkimage="";

    }



    $linklist="$linklist $linklistb";








    //GET NEWS HEADLINES

    $getnews=mysql_query("SELECT id,question FROM faq ORDER by id DESC LIMIT 5");
    while(list($id,$question)=mysql_fetch_row($getnews)){
    $headlines=$headlines."$out[bulletleft] <a href='$url[base]/$file[help]?faqid=$id'>$question</a><br>";

    }






    $out[body].="



    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' valign='top' align='left' colspan='5'>



    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' height='62' valign='top' align='center'>

    $bannerhead

    $out[banner]

    $bannerfoot</td>

    </tr>

    </table>





    </td>

    </tr>

    <tr>

    <td width='5%' valign='top' align='left'>&nbsp;</td>

    <td width='52%' valign='top' align='left'>





    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' valign='top' align='center'>";





    $out[body].="

    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Headlines</font></strong><br>

    <hr class='catfont' size='1'>

    $headlines

    $tablefoot";





    $out[body].="

    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Recent Matches</font></strong><br>

    <hr class='catfont' size='1'>

    $recentmatches

    $tablefoot



    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Upcoming Matches</font></strong><br>

    <hr class='catfont' size='1'>

    $upcomingmatches

    $tablefoot











    </td>

    </tr>

    </table>



    </td>

    <td width='5%' valign='top'>&nbsp;</td>

    <td width='20%' valign='top'>



    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' valign='top' align='center'>



    <br>



    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Stats</font></strong><br>

    <hr class='catfont' size='1'>

    $stats

    $tablefoot



    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Links</font></strong><br>

    <hr class='catfont' size='1'>

    $linklist

    $tablefoot



    </td>

    </tr>

    </table>



    </td>

    <td width='18%' valign='top' align='right'>&nbsp;</td>

    </tr>

    </table>";



    include("$dir[curtheme]");

    }









    ?>
     
  5. #4 17. Juni 2006
    PHP:
    <?

    if(!
    $indexloaded ){
      
    header ( "Location: ./index.php" );
    }



    function 
    main_page (){
      global 
    $dir $url $file $out $misc ;



      include(
    " $dir [ func ] /userstats.php" );

      
    $stats = user_stats ();



      
    $tablehead = table_head ( "show" , "100%" , "" , "left" );
      
    $tablefoot = table_foot ( "show" );

      
      
    $bannerhead = table_head ( "show" , "488" , "80" , "center" );
      
    $bannerfoot = table_foot ( "show" );





    $lastmatches = mysql_query ( "SELECT matchid,winneralias,loseralias FROM matchdb ORDER by confirmdate DESC LIMIT 5" );

    while(list(
    $matchid , $winneralias , $loseralias )= mysql_fetch_row ( $lastmatches )){
      
    $recentmatches = $recentmatches . " $out [ bulletleft ]  <a href=' $url [ base ] / $file [ match ] ?matchid= $matchid '> $winneralias  vs  $loseralias </a><br>" ;
    }

    if(!
    $recentmatches ){
      
    $recentmatches = " $out [ bulletleft ]  No Recent Matches" ;
    }

    $comingmatches = mysql_query ( "SELECT challid,challengeralias,challengedalias FROM challenges WHERE finalizedby > '0' ORDER by finalizedtime DESC LIMIT 5" );

    while(list(
    $matchid , $winneralias , $loseralias )= mysql_fetch_row ( $comingmatches )){
      
    $upcomingmatches = $upcomingmatches . " $out [ bulletleft ]  <a href=' $url [ base ] / $file [ match ] ?challid= $matchid '> $winneralias  vs  $loseralias </a><br>" ;
    }

    if(!
    $upcomingmatches ){
      
    $upcomingmatches = " $out [ bulletleft ]  No Upcoming Matches" ;
    }





    //GET LINKS

    $topfiles = mysql_query ( "SELECT id,name,imageurl FROM links ORDER by id" );

    while(list(
    $linkid , $linkname , $linkimage )= mysql_fetch_row ( $topfiles )){



     if(!
    $linkimage ){

     
    $linklist = $linklist . " $out [ bulletleft ]  <a href=' $url [ base ] / $file [ links ] ?linkid= $linkid ' target='top'> $linkname </a><br>" ;

     }else{

     
    $linklistb = $linklistb . "<br><center><a href=' $url [ base ] / $file [ links ] ?linkid= $linkid ' target='top'><img src=' $linkimage ' border='0' alt=' $linkname '></a></center>" ;

     }

    $linkimage = "" ;

    }



    $linklist = " $linklist   $linklistb " ;








    //GET NEWS HEADLINES

    $getnews = mysql_query ( "SELECT id,question FROM faq ORDER by id DESC LIMIT 5" );
    while(list(
    $id , $question )= mysql_fetch_row ( $getnews )){
    $headlines = $headlines . " $out [ bulletleft ]  <a href=' $url [ base ] / $file [ help ] ?faqid= $id '> $question </a><br>" ;

    }






    $out [ body ].= "



    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' valign='top' align='left' colspan='5'>



    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' height='62' valign='top' align='center'>

    $bannerhead

    $out [ banner ]

    $bannerfoot </td>

    </tr>

    </table>





    </td>

    </tr>

    <tr>

    <td width='5%' valign='top' align='left'>&nbsp;</td>

    <td width='52%' valign='top' align='left'>





    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' valign='top' align='center'>"
    ;





    $out [ body ].= "

    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Headlines</font></strong><br>

    <hr class='catfont' size='1'>

    $headlines

    $tablefoot " ;





    $out [ body ].= "

    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Recent Matches</font></strong><br>

    <hr class='catfont' size='1'>

    $recentmatches

    $tablefoot



    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Upcoming Matches</font></strong><br>

    <hr class='catfont' size='1'>

    $upcomingmatches

    $tablefoot











    </td>

    </tr>

    </table>



    </td>

    <td width='5%' valign='top'>&nbsp;</td>

    <td width='20%' valign='top'>



    <table width='100%' height='100%' border='0' cellspacing='0' cellpadding='0'>

    <tr>

    <td width='100%' valign='top' align='center'>



    <br>



    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Stats</font></strong><br>

    <hr class='catfont' size='1'>

    $stats

    $tablefoot



    <br>

    $tablehead

    &nbsp; &nbsp;<strong><font class='catfont'>Links</font></strong><br>

    <hr class='catfont' size='1'>

    $linklist

    $tablefoot



    </td>

    </tr>

    </table>



    </td>

    <td width='18%' valign='top' align='right'>&nbsp;</td>

    </tr>

    </table>"
    ;



    include(
    " $dir [ curtheme ] " );

    }









    ?>
    zum besseren erkennen der zeilen nummern... ^^

    edit.

    sicher das du die datenbank struktur richtig hast? ;)
     
  6. #5 17. Juni 2006
    hmmm es war nur dieser inhalt dabei


    # phpMyAdmin SQL Dump
    # version 2.5.4
    # http://www.phpmyadmin.net
    #
    # Host: localhost
    # Generation Time: Apr 13, 2005 at 03:05 PM
    # Server version: 4.0.16
    # PHP Version: 4.3.10
    #
    #

    # --------------------------------------------------------

    #
    # Table structure for table `bancensor`
    #

    DROP TABLE IF EXISTS `bancensor`;
    CREATE TABLE `bancensor` (
    `id` int(10) NOT NULL auto_increment,
    `text` varchar(100) NOT NULL default '',
    `type` int(2) NOT NULL default '0',
    `reason` varchar(250) NOT NULL default '',
    `displayreason` varchar(250) NOT NULL default '',
    `addedby` int(10) NOT NULL default '0',
    `addeddate` datetime NOT NULL default '0000-00-00 00:00:00',
    `lasteditby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=1 ;

    # --------------------------------------------------------

    #
    # Table structure for table `brackets2`
    #

    DROP TABLE IF EXISTS `brackets2`;
    CREATE TABLE `brackets2` (
    `bid` varchar(10) NOT NULL default '0',
    `tid` int(10) NOT NULL default '0',
    `pid` int(10) NOT NULL default '0',
    `name` varchar(25) NOT NULL default ''
    ) TYPE=MyISAM;

    # --------------------------------------------------------

    #
    # Table structure for table `challenges`
    #

    DROP TABLE IF EXISTS `challenges`;
    CREATE TABLE `challenges` (
    `challid` varchar(50) NOT NULL default '',
    `challenger` int(10) NOT NULL default '0',
    `challenged` int(10) NOT NULL default '0',
    `challengeralias` varchar(50) NOT NULL default '',
    `challengedalias` varchar(50) NOT NULL default '',
    `ladderid` int(10) NOT NULL default '0',
    `challengerrank` int(10) NOT NULL default '0',
    `challengedrank` int(10) NOT NULL default '0',
    `challengercomment` varchar(250) NOT NULL default '',
    `challengedby` int(10) NOT NULL default '0',
    `challengedtime` datetime NOT NULL default '0000-00-00 00:00:00',
    `matchtimes` varchar(250) NOT NULL default '',
    `matchmaps` varchar(250) NOT NULL default '',
    `challengedcomment` varchar(250) NOT NULL default '',
    `respondedby` int(10) NOT NULL default '0',
    `respondedtime` datetime NOT NULL default '0000-00-00 00:00:00',
    `finaltime` varchar(250) NOT NULL default '',
    `finalmaps` varchar(250) NOT NULL default '',
    `finalizedby` int(10) NOT NULL default '0',
    `finalizedtime` datetime NOT NULL default '0000-00-00 00:00:00',
    KEY `challid` (`challid`),
    KEY `challenger` (`challenger`),
    KEY `challenged` (`challenged`),
    KEY `ladderid` (`ladderid`),
    KEY `finaltime` (`finaltime`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `default`
    #

    DROP TABLE IF EXISTS `default`;
    CREATE TABLE `default` (
    `val` tinyint(1) NOT NULL default '0',
    PRIMARY KEY (`val`)
    ) TYPE=MyISAM;

    # --------------------------------------------------------

    #
    # Table structure for table `defaults2`
    #

    DROP TABLE IF EXISTS `defaults2`;
    CREATE TABLE `defaults2` (
    `line` tinyint(1) NOT NULL default '0',
    `password` varchar(10) NOT NULL default '',
    `logo` varchar(100) NOT NULL default '',
    `bgcolor` varchar(6) NOT NULL default '',
    `tdcolor` varchar(6) NOT NULL default '',
    `fontcolor` varchar(6) NOT NULL default ''
    ) TYPE=MyISAM;

    INSERT INTO defaults2 VALUES (1, 'admin1', '', '000050', '808080', 'ffffff');

    # --------------------------------------------------------

    #
    # Table structure for table `files`
    #

    DROP TABLE IF EXISTS `files`;
    CREATE TABLE `files` (
    `id` int(10) NOT NULL auto_increment,
    `name` varchar(100) NOT NULL default '',
    `link` varchar(250) NOT NULL default '',
    `count` int(10) NOT NULL default '0',
    `lastdlby` int(10) NOT NULL default '0',
    `lastdl` datetime NOT NULL default '0000-00-00 00:00:00',
    `lasteditby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=1 ;

    # --------------------------------------------------------

    #
    # Table structure for table `games`
    #

    DROP TABLE IF EXISTS `games`;
    CREATE TABLE `games` (
    `id` int(10) NOT NULL auto_increment,
    `gamename` varchar(50) NOT NULL default '0',
    `abbreviation` varchar(25) NOT NULL default '',
    `description` varchar(250) NOT NULL default '',
    `status` tinyint(1) NOT NULL default '0',
    `forumid` int(10) NOT NULL default '0',
    `lasteditby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=2 ;

    # --------------------------------------------------------

    #
    # Table structure for table `ladders`
    #

    DROP TABLE IF EXISTS `ladders`;
    CREATE TABLE `ladders` (
    `id` int(10) NOT NULL auto_increment,
    `gameon` int(10) NOT NULL default '0',
    `laddername` varchar(50) NOT NULL default '',
    `abbreviation` varchar(25) NOT NULL default '',
    `type` tinyint(2) NOT NULL default '0',
    `description` varchar(250) NOT NULL default '',
    `openplay` tinyint(1) NOT NULL default '0',
    `minmembers` tinyint(3) NOT NULL default '0',
    `maxmembers` tinyint(3) NOT NULL default '0',
    `minmaps` tinyint(2) NOT NULL default '0',
    `maxmaps` tinyint(2) NOT NULL default '0',
    `inactivedaysa` int(2) NOT NULL default '0',
    `inactivedrop` tinyint(2) NOT NULL default '0',
    `inactivedaysb` int(2) NOT NULL default '0',
    `challenge` tinyint(1) NOT NULL default '0',
    `challranks` int(10) NOT NULL default '0',
    `respondhours` int(3) NOT NULL default '0',
    `playdays` tinyint(2) NOT NULL default '0',
    `timescangive` tinyint(2) NOT NULL default '0',
    `starthour` tinyint(2) NOT NULL default '0',
    `endhour` tinyint(2) NOT NULL default '0',
    `timezone` varchar(25) NOT NULL default '',
    `mapscangive` tinyint(2) NOT NULL default '0',
    `finalizehours` int(1) NOT NULL default '0',
    `mapscanaccept` tinyint(2) NOT NULL default '0',
    `skillneeded` int(10) NOT NULL default '0',
    `createdby` int(10) NOT NULL default '0',
    `created` datetime NOT NULL default '0000-00-00 00:00:00',
    `lasteditby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `gameon` (`gameon`),
    KEY `laddername` (`laddername`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=3 ;

    # --------------------------------------------------------

    #
    # Table structure for table `links`
    #

    DROP TABLE IF EXISTS `links`;
    CREATE TABLE `links` (
    `id` int(10) NOT NULL auto_increment,
    `name` varchar(250) NOT NULL default '',
    `linkurl` varchar(250) NOT NULL default '',
    `imageurl` varchar(250) NOT NULL default '',
    `count` tinyint(10) NOT NULL default '0',
    `lasteditby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=1 ;

    # --------------------------------------------------------

    #
    # Table structure for table `maps`
    #

    DROP TABLE IF EXISTS `maps`;
    CREATE TABLE `maps` (
    `id` int(10) NOT NULL auto_increment,
    `ladderid` int(10) NOT NULL default '0',
    `mapname` varchar(50) NOT NULL default '',
    `mapfilename` varchar(50) NOT NULL default '',
    `mapinfolink` varchar(100) NOT NULL default '',
    `imageurl` varchar(100) NOT NULL default '',
    `editedby` int(10) NOT NULL default '0',
    `edited` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=1 ;

    # --------------------------------------------------------

    #
    # Table structure for table `matchdb`
    #

    DROP TABLE IF EXISTS `matchdb`;
    CREATE TABLE `matchdb` (
    `matchid` varchar(50) NOT NULL default '',
    `winnerid` int(10) NOT NULL default '0',
    `loserid` int(10) NOT NULL default '0',
    `winneralias` varchar(50) NOT NULL default '',
    `loseralias` varchar(50) NOT NULL default '',
    `ladderid` int(10) NOT NULL default '0',
    `laddername` varchar(50) NOT NULL default '',
    `winrank` int(10) NOT NULL default '0',
    `loserank` int(10) NOT NULL default '0',
    `winscore` int(10) NOT NULL default '0',
    `losescore` int(10) NOT NULL default '0',
    `winmembers` varchar(250) NOT NULL default '',
    `losemembers` varchar(250) NOT NULL default '',
    `mapsplayed` varchar(250) NOT NULL default '',
    `mapswon` varchar(250) NOT NULL default '',
    `wincomment` varchar(250) NOT NULL default '',
    `losecomment` varchar(250) NOT NULL default '',
    `wonpoints` int(10) NOT NULL default '0',
    `wonskill` varchar(10) NOT NULL default '0',
    `reporterid` int(10) NOT NULL default '0',
    `reportdate` datetime NOT NULL default '0000-00-00 00:00:00',
    `reporterip` varchar(16) NOT NULL default '',
    `confirmerid` int(10) NOT NULL default '0',
    `confirmdate` datetime NOT NULL default '0000-00-00 00:00:00',
    `confirmerip` varchar(16) NOT NULL default '',
    KEY `matchid` (`matchid`),
    KEY `winnerid` (`winnerid`),
    KEY `loserid` (`loserid`),
    KEY `ladderid` (`ladderid`),
    KEY `reportdate` (`reportdate`),
    KEY `confirmdate` (`confirmdate`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `matchdbval`
    #

    DROP TABLE IF EXISTS `matchdbval`;
    CREATE TABLE `matchdbval` (
    `matchid` varchar(50) NOT NULL default '',
    `winnerid` int(10) NOT NULL default '0',
    `loserid` int(10) NOT NULL default '0',
    `loseralias` varchar(50) NOT NULL default '',
    `ladderid` int(10) NOT NULL default '0',
    `losersmembers` varchar(250) NOT NULL default '',
    `maps` varchar(250) NOT NULL default '',
    `lcomment` varchar(250) NOT NULL default '',
    `wrank` int(10) NOT NULL default '0',
    `lrank` int(10) NOT NULL default '0',
    `points` int(10) NOT NULL default '0',
    `skill` int(10) NOT NULL default '0',
    `reportedby` int(10) NOT NULL default '0',
    `reporteddate` datetime NOT NULL default '0000-00-00 00:00:00',
    `reportedip` varchar(16) NOT NULL default '',
    PRIMARY KEY (`matchid`),
    KEY `winnerid` (`winnerid`),
    KEY `loserid` (`loserid`),
    KEY `ladderid` (`ladderid`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `news`
    #

    DROP TABLE IF EXISTS `news`;
    CREATE TABLE `news` (
    `id` int(10) NOT NULL auto_increment,
    `headline` varchar(250) NOT NULL default '',
    `content` mediumtext NOT NULL,
    `lasteditedby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `headline` (`headline`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=2 ;

    # --------------------------------------------------------

    #
    # Table structure for table `passrequests`
    #

    DROP TABLE IF EXISTS `passrequests`;
    CREATE TABLE `passrequests` (
    `id` int(10) NOT NULL auto_increment,
    `requestdate` datetime default '0000-00-00 00:00:00',
    `ipaddress` varchar(16) NOT NULL default '0.0.0.0',
    `playerid` int(10) NOT NULL default '0',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=4 ;

    # --------------------------------------------------------

    #
    # Table structure for table `players2`
    #

    DROP TABLE IF EXISTS `players2`;
    CREATE TABLE `players2` (
    `pid` int(10) NOT NULL default '0',
    `tid` int(10) NOT NULL default '0',
    `ipaddress` varchar(15) NOT NULL default '',
    `joined` varchar(14) NOT NULL default '',
    `name` varchar(50) NOT NULL default '',
    `email` varchar(100) NOT NULL default '',
    `field1` varchar(100) NOT NULL default '',
    `field2` varchar(100) NOT NULL default '',
    `field3` varchar(100) NOT NULL default '',
    PRIMARY KEY (`pid`)
    ) TYPE=MyISAM;

    # --------------------------------------------------------

    #
    # Table structure for table `referer`
    #

    DROP TABLE IF EXISTS `referer`;
    CREATE TABLE `referer` (
    `date` timestamp(14) NOT NULL,
    `referer` text
    ) TYPE=MyISAM;

    # --------------------------------------------------------

    #
    # Table structure for table `rules`
    #

    DROP TABLE IF EXISTS `rules`;
    CREATE TABLE `rules` (
    `id` int(10) NOT NULL auto_increment,
    `ladderon` int(10) NOT NULL default '0',
    `ruletitle` varchar(250) NOT NULL default '',
    `rulebody` mediumtext NOT NULL,
    `lasteditby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `ladderon` (`ladderon`),
    KEY `ruletitle` (`ruletitle`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=1 ;

    # --------------------------------------------------------

    #
    # Table structure for table `sessions`
    #

    DROP TABLE IF EXISTS `sessions`;
    CREATE TABLE `sessions` (
    `sessionid` varchar(50) NOT NULL default '',
    `ipaddress` varchar(50) NOT NULL default '',
    `userid` int(10) NOT NULL default '0',
    `useralias` varchar(50) NOT NULL default '',
    `usertype` int(1) NOT NULL default '0',
    `lastactive` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`sessionid`,`ipaddress`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `sessions2`
    #

    DROP TABLE IF EXISTS `sessions2`;
    CREATE TABLE `sessions2` (
    `sessionid` varchar(50) NOT NULL default '',
    `ipaddress` varchar(50) NOT NULL default '',
    `tid` int(10) NOT NULL default '0',
    `password` varchar(10) NOT NULL default '',
    `lastactive` timestamp(14) NOT NULL,
    PRIMARY KEY (`sessionid`)
    ) TYPE=MyISAM;

    # --------------------------------------------------------

    #
    # Table structure for table `staff`
    #

    DROP TABLE IF EXISTS `staff`;
    CREATE TABLE `staff` (
    `id` int(10) NOT NULL auto_increment,
    `displayname` varchar(25) NOT NULL default '0',
    `pass` varchar(10) NOT NULL default '0',
    `email` varchar(50) NOT NULL default '0',
    `title` varchar(25) NOT NULL default '0',
    `access` varchar(10) NOT NULL default '0',
    `contact` varchar(50) NOT NULL default '',
    `addeddate` datetime NOT NULL default '0000-00-00 00:00:00',
    `addedby` varchar(30) NOT NULL default '',
    `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
    `lasteditby` int(10) NOT NULL default '0',
    `lastedit` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=2 ;

    INSERT INTO staff VALUES ( '1', 'admin1', 'admin1', '', '', '99', '', '', '', '', '', '');

    # --------------------------------------------------------

    #
    # Table structure for table `staffaccess`
    #

    DROP TABLE IF EXISTS `staffaccess`;
    CREATE TABLE `staffaccess` (
    `staffid` int(10) NOT NULL default '0',
    `ladderid` int(10) NOT NULL default '0',
    `status` tinyint(1) NOT NULL default '0',
    `joindate` datetime NOT NULL default '0000-00-00 00:00:00',
    KEY `staffid` (`staffid`),
    KEY `ladderid` (`ladderid`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `staffcomments`
    #

    DROP TABLE IF EXISTS `staffcomments`;
    CREATE TABLE `staffcomments` (
    `commentid` int(10) NOT NULL auto_increment,
    `id` int(10) NOT NULL default '0',
    `isateam` tinyint(1) NOT NULL default '0',
    `comment` varchar(250) NOT NULL default '',
    `display` tinyint(1) NOT NULL default '0',
    `addedby` int(10) NOT NULL default '0',
    `added` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`commentid`),
    KEY `id` (`id`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=4 ;

    # --------------------------------------------------------

    #
    # Table structure for table `teammembers`
    #

    DROP TABLE IF EXISTS `teammembers`;
    CREATE TABLE `teammembers` (
    `teamid` int(10) NOT NULL default '0',
    `playerid` int(10) NOT NULL default '0',
    `status` tinyint(1) NOT NULL default '0',
    `joindate` datetime NOT NULL default '0000-00-00 00:00:00',
    KEY `teamid` (`teamid`),
    KEY `playerid` (`playerid`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `teammembersinv`
    #

    DROP TABLE IF EXISTS `teammembersinv`;
    CREATE TABLE `teammembersinv` (
    `teamid` int(10) NOT NULL default '0',
    `playerid` int(10) NOT NULL default '0',
    `inviterid` int(10) NOT NULL default '0',
    `invitedate` datetime NOT NULL default '0000-00-00 00:00:00',
    KEY `teamid` (`teamid`),
    KEY `playerid` (`playerid`),
    KEY `inviterid` (`inviterid`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `teams`
    #

    DROP TABLE IF EXISTS `teams`;
    CREATE TABLE `teams` (
    `id` int(10) NOT NULL auto_increment,
    `teamname` varchar(50) NOT NULL default '0',
    `teamemail` varchar(100) NOT NULL default '',
    `tag` varchar(25) NOT NULL default '0',
    `tagplace` tinyint(1) NOT NULL default '0',
    `website` varchar(100) NOT NULL default '0',
    `logo` varchar(100) NOT NULL default '0',
    `contact` varchar(100) NOT NULL default '',
    `joindate` datetime NOT NULL default '0000-00-00 00:00:00',
    `idcreate` int(10) NOT NULL default '0',
    `ipcreate` varchar(16) NOT NULL default '0.0.0.0',
    `type` tinyint(1) NOT NULL default '0',
    PRIMARY KEY (`id`),
    KEY `teamname` (`teamname`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=11 ;

    # --------------------------------------------------------

    #
    # Table structure for table `tourneys`
    #

    DROP TABLE IF EXISTS `tourneys`;
    CREATE TABLE `tourneys` (
    `tid` int(10) NOT NULL auto_increment,
    `size` tinyint(2) NOT NULL default '0',
    `type` tinyint(2) NOT NULL default '0',
    `active` tinyint(1) NOT NULL default '0',
    `name` varchar(50) NOT NULL default '',
    `details` text NOT NULL,
    `field1` varchar(50) NOT NULL default '',
    `field2` varchar(50) NOT NULL default '',
    `field3` varchar(50) NOT NULL default '',
    `directors` varchar(250) NOT NULL default '',
    `password` varchar(10) NOT NULL default '',
    `logo` varchar(100) NOT NULL default '',
    `bgcolor` varchar(6) NOT NULL default '',
    `tdcolor` varchar(6) NOT NULL default '',
    `fontcolor` varchar(6) NOT NULL default '',
    `ladderid` int(10) NOT NULL default '0',
    `open` tinyint(4) NOT NULL default '1',
    PRIMARY KEY (`tid`)
    ) TYPE=MyISAM AUTO_INCREMENT=11 ;

    # --------------------------------------------------------

    #
    # Table structure for table `users`
    #

    DROP TABLE IF EXISTS `users`;
    CREATE TABLE `users` (
    `id` int(10) NOT NULL auto_increment,
    `alias` varchar(50) NOT NULL default '0',
    `pass` varchar(25) NOT NULL default '0',
    `email` varchar(50) NOT NULL default '0',
    `icq` varchar(10) NOT NULL default '0',
    `aim` varchar(25) NOT NULL default '0',
    `yahoo` varchar(35) NOT NULL default '0',
    `msn` varchar(35) NOT NULL default '0',
    `website` varchar(100) NOT NULL default '0',
    `logo` varchar(100) NOT NULL default '0',
    `newsletter` tinyint(1) NOT NULL default '0',
    `joindate` datetime default '0000-00-00 00:00:00',
    `ipaddress` varchar(16) NOT NULL default '0.0.0.0',
    `matcheswon` int(10) NOT NULL default '0',
    `matcheslost` int(10) NOT NULL default '0',
    `points` int(10) NOT NULL default '0',
    `skill` int(10) NOT NULL default '0',
    `money` int(10) NOT NULL default '0',
    `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
    `theme` varchar(30) NOT NULL default '',
    `country` char(2) NOT NULL default '',
    PRIMARY KEY (`id`),
    KEY `alias` (`alias`)
    ) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=7 ;

    # --------------------------------------------------------

    #
    # Table structure for table `usersinfo`
    #

    DROP TABLE IF EXISTS `usersinfo`;
    CREATE TABLE `usersinfo` (
    `id` int(10) NOT NULL default '0',
    `firstname` varchar(50) NOT NULL default '0',
    `middlename` varchar(50) NOT NULL default '0',
    `lastname` varchar(50) NOT NULL default '0',
    `address` varchar(50) NOT NULL default '0',
    `city` varchar(50) NOT NULL default '0',
    `state` char(2) NOT NULL default '0',
    `zipcode` varchar(10) NOT NULL default '0',
    `phone` bigint(10) NOT NULL default '0',
    `birthday` date NOT NULL default '0000-00-00',
    `occupation` char(2) NOT NULL default '0',
    `required` tinyint(1) NOT NULL default '0',
    PRIMARY KEY (`id`)
    ) TYPE=ISAM PACK_KEYS=1;

    # --------------------------------------------------------

    #
    # Table structure for table `validate`
    #

    DROP TABLE IF EXISTS `validate`;
    CREATE TABLE `validate` (
    `vcode` varchar(50) NOT NULL default '',
    `alias` varchar(50) NOT NULL default '0',
    `pass` varchar(25) NOT NULL default '0',
    `email` varchar(50) NOT NULL default '0',
    `icq` varchar(10) NOT NULL default '0',
    `aim` varchar(25) NOT NULL default '0',
    `yahoo` varchar(50) NOT NULL default '0',
    `msn` varchar(35) NOT NULL default '0',
    `website` varchar(100) NOT NULL default '0',
    `logo` varchar(100) NOT NULL default '0',
    `newsletter` tinyint(1) NOT NULL default '0',
    `joindate` datetime NOT NULL default '0000-00-00 00:00:00',
    `ipaddress` varchar(16) NOT NULL default '0.0.0.0',
    `firstname` varchar(50) NOT NULL default '0',
    `middlename` varchar(50) NOT NULL default '0',
    `lastname` varchar(50) NOT NULL default '0',
    `address` varchar(50) NOT NULL default '0',
    `city` varchar(50) NOT NULL default '0',
    `state` char(2) NOT NULL default '0',
    `zipcode` varchar(10) NOT NULL default '0',
    `phone` bigint(10) NOT NULL default '0',
    `birthday` date NOT NULL default '0000-00-00',
    `occupation` char(2) NOT NULL default '0',
    `theme` varchar(30) NOT NULL default '0',
    `country` char(2) NOT NULL default '',
    PRIMARY KEY (`vcode`)
    ) TYPE=ISAM PACK_KEYS=1;
     
  7. #6 18. Juni 2006
    hmm, müsste aber 2 sql Datein geben (war bei der letzten Beta so)
     

  8. Videos zum Thema
Die Seite wird geladen...
Similar Threads - Gaming ladder brauche
  1. Antworten:
    1
    Aufrufe:
    5.335
  2. Gaming-PC 2017 bis 900€

    asdf2k , 22. Mai 2017 , im Forum: Kaufberatung
    Antworten:
    3
    Aufrufe:
    3.057
  3. Kabelloses Gaming Headset

    Espeks , 12. Januar 2017 , im Forum: Macintosh
    Antworten:
    2
    Aufrufe:
    5.635
  4. Antworten:
    2
    Aufrufe:
    864
  5. Antworten:
    2
    Aufrufe:
    1.479
  • Annonce

  • Annonce