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. 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. 17. Juni 2006
    1. was is ladder script.

    2. wie sieht der code aus.

     
  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]");

    }









    ?>
     
  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?
     
  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;
     
  6. 18. Juni 2006
    hmm, müsste aber 2 sql Datein geben (war bei der letzten Beta so)
     
  7. Video Script

    Videos zum Themenbereich

    * gefundene Videos auf YouTube, anhand der Überschrift.