Jump to content

superaktieboy

Members
 View Profile  See their activity

  • Posts

    32

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by superaktieboy

  1. superaktieboy
    hi i have a code like this (selected from a Database, so is different as this, as it is posted by users) [code] <? echo 'this is php higlighted'; ?> <html> this is as html highlighted </html> script language="text/javascript" (with < and > but coz that posting problem) // this is javascript highlighted /script (with < and > but coz that posting problem) <style> /* this is css highlighted */ </style> [/code] now i got for each highlighter it's own function called: highlight_php, highlight_html, highlight_js and highlight_css and next to that i got a function called 'highlight($input, $unparse = false)' now i use this to highlight html [code] preg_match_all('#(<.*?>)#is', $highlighted, $matches); for ($i = 0; $i <= count($matches[0]); $i++) { $replacer = highlight_html($matches[0][$i]); $highlighted = str_replace($matches[0][$i], $replacer, $highlighted); } [/code] this is the function highlight_html(): [code] function highlight_html($input) { /** * These three array will make it easyer to preg_replace to colors */ $commands_boldblue = array ( '#(\ba\b)#', '#(\babbr\b)#', '#(\babove\b)#', '#(\bacronym\b)#', '#(\baddress\b)#', '#(\bapplet\b)#', '#(\barea\b)#', '#(\barray\b)#', '#(\bb\b)#', '#(\bbase\b)#', '#(\bbdo\b)#', '#(\bbgsound\b)#', '#(\bbig\b)#', '#(\bxmp\b)#', '#(\bblink\b)#', '#(\bblockquote\b)#', '#(\bbody\b)#', '#(\bbox\b)#', '#(\bbr\b)#', '#(\bbutton\b)#', '#(\bcaption\b)#', '#(\bcenter\b)#', '#(\bcite\b)#', '#(\bcode\b)#', '#(\bcol\b)#', '#(\bcolgroup\b)#', '#(\bcomment\b)#', '#(\bdd\b)#', '#(\bdel\b)#', '#(\bdfn\b)#', '#(\bdir\b)#', '#(\bdiv\b)#', '#(\bdl\b)#', '#(\bdoctype\b)#', '#(\bdt\b)#', '#(\bem\b)#', '#(\bembed\b)#', '#(\bfieldset\b)#', '#(\bfig\b)#', '#(\bform\b)#', '#(\bframe\b)#', '#(\bframeset\b)#', '#(\btfoot\b)#', '#(\bh\b)#', '#(\bh1\b)#', '#(\bh2\b)#', '#(\bh3\b)#', '#(\bh4\b)#', '#(\bh5\b)#', '#(\bh6\b)#', '#(\bhead\b)#', '#(\bhr\b)#', '#(\bhta\b)#', '#(\bhtml\b)#', '#(\bi\b)#', '#(\biframe\b)#', '#(\bimg\b)#', '#(\binput\b)#', '#(\bins\b)#', '#(\bisindex\b)#', '#(\bkbd\b)#', '#(\blabel\b)#', '#(\blegend\b)#', '#(\bli\b)#', '#(\blink\b)#', '#(\blisting\b)#', '#(\bmap\b)#', '#(\bmarquee\b)#', '#(\bmenu\b)#', '#(\bmeta\b)#', '#(\bmulticol\b)#', '#(\bnextid\b)#', '#(\bnobr\b)#', '#(\bnoframes\b)#', '#(\bnoscript\b)#', '#(\bnote\b)#', '#(\bol\b)#', '#(\boptgroup\b)#', '#(\boption\b)#', '#(\bp\b)#', '#(\bparam\b)#', '#(\bplaintext\b)#', '#(\bpre\b)#', '#(\bq\b)#', '#(\brange\b)#', '#(\broot\b)#', '#(\bs\b)#', '#(\bsamp\b)#', '#(\bselect\b)#', '#(\bsmall\b)#', '#(\bsound\b)#', '#(\bspacer\b)#', '#(\btbody\b)#', '#(\btd\b)#', '#(\bsqrt\b)#', '#(\bstrike\b)#', '#(\bstrong\b)#', '#(\bsub\b)#', '#(\bsup\b)#', '#(\btext\b)#', '#(\btextarea\b)#', '#(\btable\b)#', '#(\btextflow\b)#', '#(\bth\b)#', '#(\bthead\b)#', '#(\btitle\b)#', '#(\btr\b)#', '#(\btt\b)#', '#(\bu\b)#', '#(\bul\b)#', '#(\bvar\b)#', '#(\bwbr\b)#', /** * we replaced the text 'span' in 'c3Bhbg' by using * the function base64_encode(). * so the next text is 'span' */ '#(\bc3Bhbg\b)#', /** * we replaced the text 'style' in 'c3R5bGU' by using * the function base64_encode(). * so the next text is 'style' */ '#(\bc3R5bGU\b)#', /** * we replaced the text 'font' in 'Zm9udA' by using * the function base64_encode(). * so the next two texts are * [1] basefont * [2] font */ '#(\bbaseZm9udA\b)#', '#(\bZm9udA\b)#' ); $commands_red = array ( '#(\baccept\b)#', '#(\baccesskey\b)#', '#(\baction\b)#', '#(\balign\b)#', '#(\balink\b)#', '#(\balt\b)#', '#(\bapplicationname\b)#', '#(\barchive\b)#', '#(\baxis\b)#', '#(\bbackground\b)#', '#(\bbehavior\b)#', '#(\bbelow\b)#', '#(\bcellpadding\b)#', '#(\bbgproperties\b)#', '#(\bborder\b)#', '#(\bcellspacing\b)#', '#(\bchar\b)#', '#(\bcharoff\b)#', '#(\bcharset\b)#', '#(\bchecked\b)#', '#(\bclass\b)#', '#(\bclassid\b)#', '#(\bclear\b)#', '#(\bcodebase\b)#', '#(\bcodetype\b)#', '#(\bcols\b)#',  '#(\bcompact\b)#', '#(\bhttp-equiv\b)#', '#(\bhttp-equiv\b)#', '#(\bcontent\b)#', '#(\bcoords\b)#', '#(\bdata\b)#', '#(\bdatetime\b)#', '#(\bdeclare\b)#', '#(\bdefer\b)#', '#(\bdirection\b)#', '#(\bdisabled\b)#', '#(\bdynsrc\b)#', '#(\benctype\b)#', '#(\bequiv\b)#', '#(\bface\b)#', '#(\bfor\b)#', '#(\bframeborder\b)#', '#(\bframespacing\b)#', '#(\bgutter\b)#', '#(\bheaders\b)#', '#(\bheight\b)#', '#(\bhref\b)#', '#(\bhreflang\b)#', '#(\bhspace\b)#', '#(\bicon\b)#', '#(\bid\b)#', '#(\bismap\b)#', '#(\blanguage\b)#', '#(\bleftmargin\b)#', '#(\blongdesc\b)#', '#(\bloop\b)#', '#(\blowsrc\b)#', '#(\bmarginheight\b)#', '#(\bmarginwidth\b)#', '#(\bmaximizebutton\b)#', '#(\bmaxlength\b)#', '#(\bmedia\b)#', '#(\bmethod\b)#', '#(\bmethods\b)#', '#(\bminimizebutton\b)#', '#(\bmultiple\b)#', '#(\bname\b)#', '#(\bnohref\b)#', '#(\bnoresize\b)#', '#(\bnoshade\b)#', '#(\bnowrap\b)#', '#(\bobject\b)#', '#(\bonabort\b)#', '#(\bonblur\b)#', '#(\bonchange\b)#', '#(\bonclick\b)#', '#(\bondblclick\b)#', '#(\bonfocus\b)#', '#(\bonkeydown\b)#', '#(\bonkeypress\b)#', '#(\bonkeyup\b)#', '#(\bonload\b)#', '#(\bonmousedown\b)#', '#(\bonmousemove\b)#', '#(\bonmouseout\b)#', '#(\bonmouseover\b)#', '#(\bonmouseup\b)#', '#(\bonreset\b)#', '#(\bonselect\b)#', '#(\bonsubmit\b)#', '#(\bonunload\b)#', '#(\bprofile\b)#', '#(\bprompt\b)#', '#(\breadonly\b)#', '#(\brel\b)#', '#(\brev\b)#', '#(\brows\b)#', '#(\brules\b)#', '#(\brunat\b)#', '#(\bscheme\b)#', '#(\bscope\b)#', '#(\bscrollamount\b)#', '#(\bscrolldelay\b)#', '#(\bshape\b)#', '#(\bshowintaskbar\b)#', '#(\bsingleinstance\b)#', '#(\bsize\b)#', '#(\bsrc\b)#', '#(\bstandby\b)#', '#(\bstart\b)#', '#(\bsummary\b)#', '#(\bsysmenu\b)#', '#(\btabindex\b)#', '#(\btarget\b)#', '#(\btopmargin\b)#', '#(\btype\b)#', '#(\burn\b)#', '#(\busemap\b)#', '#(\bvalign\b)#', '#(\bvalue\b)#', '#(\bvaluetype\b)#', '#(\bversion\b)#', '#(\bvlink\b)#', '#(\bvrml\b)#', '#(\bvspace\b)#', '#(\bwidth\b)#', '#(\bwindowstate\b)#', '#(\bwrap\b)#', '#(\bscrolling\b)#', '#(\bselected\b)#', /** * we replaced the text 'color' in 'Y29sb3I' by using * the function base64_encode(). * So the next five texts are * [1] bordercolor * [2] bordercolordark * [3] bordercolorlight * [4] bgcolor * [5] color */ '#(\bborderY29sb3I\b)#', '#(\bborderY29sb3Idark\b)#', '#(\bborderY29sb3Ilight\b)#', '#(\bbgY29sb3I\b)#', '#(\bY29sb3I\b)#', /** * we replaced the text 'span' in 'c3Bhbg' by using * the function base64_encode(). * so the next two texts are * [1] rowspan * [2] colspan */ '#(\browc3Bhbg\b)#', '#(\bcolc3Bhbg\b)#', /** * we replaced the text 'style' in 'c3R5bGU' by using * the function base64_encode(). * so the next text is 'borderstyle' */ '#(\bborderc3R5bGU\b)#' ); $commands_purple = array ( '#(\b_blank\b)#', '#(\bblack\b)#', '#(\bblue\b)#', '#(\bbottom\b)#', '#(\bgreen\b)#', '#(\bhidden\b)#', '#(\bleft\b)#', '#(\bmagenta\b)#', '#(\bmiddle\b)#', '#(\borange\b)#', '#(\bpublic\b)#', '#(\bpurple\b)#', '#(\bred\b)#', '#(\bright\b)#', '#(\btop\b)#', '#(\bwhite\b)#', '#(\byellow\b)#' ); /** * First we make the < and > special html characters, otherwise it won't echo */ $temp = str_replace('<', '&lt;', $input); $temp = str_replace('>', '&gt;', $temp); /** * Then we give the things in the arrays $commands_purple, * $commands_red and $commands_boldblue their own color */ $temp = preg_replace($commands_purple, '<span style="color: #9C029C;font-weight:bold">$1</span>', $temp); $temp = preg_replace($commands_boldblue, '<span style="color: #0000FF;font-weight:bold">$1</span>', $temp); $temp = preg_replace($commands_red, '<span style="color: red;font-weight:bold">$1</span>', $temp); $temp = preg_replace($commands_red, '<span style="color: red;font-weight:bold">$1</span>', $temp); return $temp; } [/code] but when i call this function it also indexes php, script and style. and as far as i know it is this 'preg_match_all('#(<.*?>)#is', $highlighted, $matches);' so does anyone know how to index only html, and ignoring php, script, and style?? greetzz oh btw, i encoded some things coz otherwise it wouldn't work proper. you'll see what they're in the array
  2. superaktieboy
    so you mean like this: [code] SELECT DISTINCT     m.*,     c.id,     dd.id,     dr.id,     fr.id,     nr.id,     p.id,     ss.id,     sr.id,     tt.id,     tr.id,     f.*,     o.*,     c.userid,     dd.dl_userid,     dr.userid,     fr.reply_poster,     nr.news_rp_userid,     p.userid,     ss.userid,     sr.userid,     tt.userid,     tr.userid FROM members AS m     LEFT JOIN calender AS c ON c.userid = m.id     LEFT JOIN dl_downloads AS dd ON dd.dl_userid = m.id     LEFT JOIN dl_reacties AS dr ON dr.userid = m.id     LEFT JOIN forum_replys AS fr ON fr.reply_poster = m.id     LEFT JOIN news_replies AS nr ON    nr.news_rp_userid = m.id     LEFT JOIN online AS o ON    o.userid = m.id     LEFT JOIN pictures AS p ON    p.userid = m.id     LEFT JOIN scripts AS ss ON    ss.userid = m.id     LEFT JOIN sc_reacties AS sr ON    sr.userid = m.id     LEFT JOIN tutorials AS tt ON    tt.userid = m.id     LEFT JOIN tut_reacties AS tr ON    tr.userid = m.id     LEFT JOIN friends AS f ON    f.userid = m.id WHERE     m.id > 0 [/code] i still get lot of the same rows
  3. superaktieboy
    Well i tried that with LEFT JOIN, and i get arround 7000 results.. and all with the same name, from a table with arround 6 rows :S
  4. superaktieboy
    oh ok.. it still doesn't work ??? anyway isn't there anyway that this allows this to return without even having any results, coz the others tables could be empty
  5. superaktieboy
    [b]Why are the other tables in the query?[/b] because (as you probably knew) i use it for a memberslist, there a user can say how they want to order, and what they want to select.. i want them to select like on total online, total new replies etc. [b]Is it so that you only return records in member that have a match in those tables?[/b] well i got the users at (there are 4 users to test) and not all of them have posted, so its not only those who have posted, but every user. [b]Do you  want members listed with no friends records?[/b] i want the user to be able to select that himself with a form [b]Do you want members listed with no online records?[/b] same as above @fenway srry im not really good in MySQL so if you can explain what you mean, i'd appreciate it btw i forgot to say even when i try only "WHERE m.id > 0" it still doesn't give records. greetzz
  6. superaktieboy
    ooh thx .. so can anyone help me with selecting from these tables for a members list page? i need it in one query coz i want the user to be able to choose what to select and what not and how to order. greetzz
  7. superaktieboy
    hi i got this MySQL query but i don't get results back, while i am sure there are results [code]SELECT    m.*,    c.id,    dd.id,    dr.id,    fr.id,    nr.id,    p.id,    ss.id,    sr.id,    tt.id,    tr.id,    f.*,    o.*,    c.userid,    dd.dl_userid,    dr.userid,    fr.reply_poster,    nr.news_rp_userid,    p.userid,    ss.userid,    sr.userid,    tt.userid,    tr.userid FROM    members AS m,    calender AS c,    dl_downloads AS dd,    dl_reacties AS dr,    forum_replys AS fr,    news_replies AS nr,    online AS o,    pictures AS p,    scripts AS ss,    sc_reacties AS sr,    tutorials AS tt,    tut_reacties AS tr,    friends AS f WHERE    m.id > 0 AND    c.userid = m.id AND    dd.dl_userid = m.id AND    dr.userid = m.id AND    fr.reply_poster = m.id AND    nr.news_rp_userid = m.id AND    p.userid = m.id AND    ss.userid = m.id AND    sr.userid = m.id AND    tt.userid = m.id AND    tr.userid = m.id AND    f.userid = m.id AND    o.userid = m.id [/code] these are my tables [code] -- -- Table structure for table `calender` -- CREATE TABLE `calender` (  `id` int(11) NOT NULL auto_increment,  `userid` int(11) NOT NULL,  `date` varchar(10) collate latin1_general_ci NOT NULL default '',  `subject` varchar(255) collate latin1_general_ci NOT NULL,  `description` text collate latin1_general_ci NOT NULL,  `day` int(2) NOT NULL,  `month` int(2) NOT NULL,  `year` int(4) NOT NULL,  UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci PACK_KEYS=0 AUTO_INCREMENT=7 ; -- -------------------------------------------------------- -- -- Table structure for table `dl_downloads` -- CREATE TABLE `dl_downloads` (  `id` int(11) NOT NULL auto_increment,  `dl_dloads` int(11) NOT NULL,  `dl_subcat_id` int(11) NOT NULL,  `dl_userid` int(11) NOT NULL,  `dl_naam` varchar(255) collate latin1_general_ci NOT NULL,  `dl_uitleg` text collate latin1_general_ci NOT NULL,  `dl_url` varchar(255) collate latin1_general_ci NOT NULL,  `dl_datum` int(10) NOT NULL,  `dl_status` int(1) NOT NULL,  `dl_views` int(11) NOT NULL,  `dl_short_uitleg` varchar(255) collate latin1_general_ci NOT NULL,  `dl_screenshot` varchar(255) collate latin1_general_ci NOT NULL,  `dl_download` varchar(255) collate latin1_general_ci NOT NULL,  `dl_autheur` varchar(255) collate latin1_general_ci NOT NULL default '',  `dl_version` varchar(50) collate latin1_general_ci NOT NULL,  `file_size` int(255) NOT NULL,  `dl_last_download` int(10) NOT NULL,  `last_post_date` int(10) NOT NULL,  `dl_icon` int(2) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=88 ; -- -------------------------------------------------------- -- -- Table structure for table `dl_reacties` -- CREATE TABLE `dl_reacties` (  `id` int(11) NOT NULL auto_increment,  `userid` int(11) NOT NULL default '0',  `dl_id` int(11) NOT NULL default '0',  `bericht` text collate latin1_general_ci NOT NULL,  `datum` int(10) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `forum_replys` -- CREATE TABLE `forum_replys` (  `id` int(11) NOT NULL auto_increment,  `topic_id` int(11) NOT NULL,  `is_topic` int(1) NOT NULL,  `reply_poster` int(11) NOT NULL,  `reply_date` int(10) NOT NULL,  `reply_message` text collate latin1_general_ci NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=27 ; -- -------------------------------------------------------- -- -- Table structure for table `forum_topics` -- CREATE TABLE `forum_topics` (  `id` int(11) NOT NULL auto_increment,  `forum_id` int(11) NOT NULL,  `topic_poster` int(11) NOT NULL,  `topic_type` int(1) NOT NULL,  `topic_naam` varchar(40) collate latin1_general_ci NOT NULL,  `topic_date` int(10) NOT NULL,  `topic_locked` int(11) NOT NULL default '0',  `topic_views` int(11) NOT NULL,  `last_post_date` int(10) NOT NULL,  `topic_desc` varchar(255) collate latin1_general_ci NOT NULL,  `poll_added` int(1) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ; -- -------------------------------------------------------- -- -- Table structure for table `friends` -- CREATE TABLE `friends` (  `userid` int(11) NOT NULL,  `userid2` int(11) NOT NULL,  `type` int(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` (  `id` int(11) NOT NULL auto_increment,  `gebruikersnaam` varchar(25) collate latin1_general_ci NOT NULL,  `wachtwoord` varchar(32) collate latin1_general_ci NOT NULL,  `email` varchar(255) collate latin1_general_ci NOT NULL,  `realname` varchar(255) collate latin1_general_ci NOT NULL,  `gender` int(1) NOT NULL,  `birthday` int(10) NOT NULL,  `activated` varchar(20) collate latin1_general_ci NOT NULL,  `website` varchar(255) collate latin1_general_ci NOT NULL,  `status` varchar(100) collate latin1_general_ci NOT NULL default 'Lid',  `avatar` varchar(255) collate latin1_general_ci NOT NULL,  `liddatum` int(10) NOT NULL,  `ondertitel` text collate latin1_general_ci NOT NULL,  `ip` varchar(50) collate latin1_general_ci NOT NULL,  `proxy` varchar(50) collate latin1_general_ci NOT NULL,  `host` varchar(50) collate latin1_general_ci NOT NULL,  `warnings` int(1) NOT NULL default '0',  `posts` int(11) NOT NULL default '0',  `tuts` int(11) NOT NULL default '0',  `dloads` int(11) NOT NULL default '0',  `scripts` int(11) NOT NULL default '0',  `lastvisit` int(11) NOT NULL,  `locatie` varchar(255) collate latin1_general_ci NOT NULL,  `occupation` varchar(255) collate latin1_general_ci NOT NULL,  `icq` varchar(15) collate latin1_general_ci NOT NULL,  `aim` varchar(255) collate latin1_general_ci NOT NULL,  `yim` varchar(255) collate latin1_general_ci NOT NULL,  `msnm` varchar(255) collate latin1_general_ci NOT NULL,  `interests` varchar(255) collate latin1_general_ci NOT NULL,  `tel_home` int(20) NOT NULL,  `fax_home` int(20) NOT NULL,  `tel_occ` int(20) NOT NULL,  `fax_occ` int(20) NOT NULL,  `mobiel` int(20) NOT NULL,  `user_scripts_per_page` int(11) NOT NULL,  `user_language` varchar(40) collate latin1_general_ci NOT NULL default 'dutch',  `user_users_per_page` int(11) NOT NULL,  `user_view_online` int(1) NOT NULL,  `user_view_profile` int(1) NOT NULL,  `user_newsletter` int(1) NOT NULL,  `user_view_email` int(1) NOT NULL,  `user_replys_per_page` int(11) NOT NULL,  `user_notify_forum` int(1) NOT NULL,  `user_notify_dloads` int(1) NOT NULL,  `user_notify_scripts` int(1) NOT NULL,  `user_notify_tutorials` int(1) NOT NULL,  `user_notify_privmsg` int(1) NOT NULL,  `user_popup_by_privmsg` int(1) NOT NULL,  `user_allow_pm` int(1) NOT NULL,  `user_mail_pm` int(1) NOT NULL,  `user_view_signature` int(1) NOT NULL,  `user_view_avatar` int(1) NOT NULL,  `optie_view_web` int(1) NOT NULL,  `optie_view_msg` int(1) NOT NULL,  `optie_view_personal` int(1) NOT NULL,  `user_view_friends` int(1) NOT NULL,  `user_view_blocked` int(1) NOT NULL,  `user_view_friend_of` int(1) NOT NULL,  `user_view_blocked_by` int(1) NOT NULL,  `user_privmsg_p_page` int(5) NOT NULL,  `user_view_quick_reply` int(1) NOT NULL,  PRIMARY KEY  (`id`),  FULLTEXT KEY `gebruikersnaam` (`gebruikersnaam`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12 ; -- -------------------------------------------------------- -- -- Table structure for table `news_replies` -- CREATE TABLE `news_replies` (  `id` int(10) NOT NULL auto_increment,  `news_rp_id` int(10) NOT NULL default '0',  `news_rp_userid` varchar(20) collate latin1_general_ci NOT NULL default '',  `news_rp_bericht` text collate latin1_general_ci NOT NULL,  `news_rp_datum` int(10) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ; -- -------------------------------------------------------- -- -- Table structure for table `online` -- CREATE TABLE `online` (  `id` int(11) NOT NULL auto_increment,  `userid` int(11) NOT NULL default '0',  `ip` varchar(15) collate latin1_general_ci NOT NULL default '',  `datum` int(10) NOT NULL,  `datum_start` int(10) NOT NULL,  `page` varchar(255) collate latin1_general_ci NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=966 ; -- -------------------------------------------------------- -- -- Table structure for table `pictures` -- CREATE TABLE `pictures` (  `id` int(11) NOT NULL auto_increment,  `sid` int(11) NOT NULL,  `userid` int(11) NOT NULL,  `subject` varchar(255) collate latin1_general_ci NOT NULL,  `description` text collate latin1_general_ci NOT NULL,  `location` varchar(1000) collate latin1_general_ci NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `sc_reacties` -- CREATE TABLE `sc_reacties` (  `id` int(11) NOT NULL auto_increment,  `userid` int(11) NOT NULL default '0',  `script_id` int(11) NOT NULL default '0',  `bericht` text collate latin1_general_ci NOT NULL,  `datum` int(10) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `scripts` -- CREATE TABLE `scripts` (  `id` int(11) NOT NULL auto_increment,  `subcat_id` int(11) NOT NULL,  `title` varchar(255) collate latin1_general_ci NOT NULL,  `explain` text collate latin1_general_ci NOT NULL,  `views` int(11) NOT NULL,  `userid` int(11) NOT NULL,  `desc` varchar(300) collate latin1_general_ci NOT NULL,  `source` text collate latin1_general_ci NOT NULL,  `demo_url` varchar(255) collate latin1_general_ci NOT NULL,  `date` int(10) NOT NULL,  `version` varchar(10) collate latin1_general_ci NOT NULL,  `last_post_date` int(10) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `tut_reacties` -- CREATE TABLE `tut_reacties` (  `id` int(11) NOT NULL auto_increment,  `userid` int(11) NOT NULL,  `tut_id` int(11) NOT NULL,  `bericht` text collate latin1_general_ci NOT NULL,  `datum` int(10) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `tutorials` -- CREATE TABLE `tutorials` (  `id` int(11) NOT NULL auto_increment,  `subcat_id` int(11) NOT NULL,  `userid` int(11) NOT NULL,  `title` varchar(255) collate latin1_general_ci NOT NULL,  `inleiding` varchar(300) collate latin1_general_ci NOT NULL,  `text` text collate latin1_general_ci NOT NULL,  `views` int(11) NOT NULL,  `datum` int(10) NOT NULL,  `last_post_date` int(10) NOT NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; [/code] what is the problem with the query? greetzz
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.