Eliezer

Não deu certo n. não me dar nenhum retorno

hm.. mais tipo existe algum tipo de sql ? ou funcao? que quando o usuario logar e for redirencionado pra uma pagina essa pagina mostar o seu ID?

Aqui não funcionou.. Coloquei o código e não apareceu nada. O que eu queria é que a variavel $user possuise o ID do usuario q logou. $sql="SELECT c.id,c.fullname FROM mdl_role_assignments rs INNER JOIN mdl_context e ON rs.contextid=e.id INNER JOIN mdl_course c ON c.id = e.instanceid WHERE e.contextlevel=50 AND rs.roleid=5 AND rs.userid=$user";

Olá gostaria de saber como pegar o id do usuario depois dele logado? <?php require_once("config.php"); $user=$_POST['user']; if(empty($user)){echo "Id do usuario &eacute; um par&acirc;metro obrigat&oacute;rio";exit;} $sql="SELECT c.id,c.fullname FROM mdl_role_assignments rs INNER JOIN mdl_context e ON rs.contextid=e.id INNER JOIN mdl_course c ON c.id = e.instanceid WHERE e.contextlevel=50 AND rs.roleid=5 AND rs.userid=$user"; ?> já utilizei o GET e o POST.

<div style="margin-left: 77px; margin-top: -16px;" id="campos"><br /><span style="font-size: 12px; font-family: Verdana,Geneva,sans-serif; color: #ffffff;" color="#ffffff"><b>ÁREA EXCLUSIVA</b></span><br /><br /><form action="http://localhost/moodle/login/index.php" method="post" name="frmMoodle"> <div id="profilelogin"> <table style="width: 0px;" border="0" cellspacing="0"> <tbody> <tr valign="middle"> <td valign="middle"><label for="username">Nome de Usuário:</label></td> </tr> <tr valign="middle"> <td valign="middle"><input name="username" value="login" onfocus="if(this.value=='login') this.value='';" type="text" /></td> </tr> <tr valign="middle"> <td valign="middle"><label for="password">Senha:</label></td> </tr> <tr valign="middle"> <td valign="middle"><input name="password" value="senha" onfocus="if(this.value=='senha') this.value='';" type="password" /></td> </tr> <tr valign="middle"> <td> </td> </tr> <tr valign="middle"> <td valign="middle"><input value="Entrar" type="submit" /></td> </tr> </tbody> </table> </div> </form></div Bom pessoal esse codigo é um formalario de login pro moodle. como faço pra ele logar desse modo ai e logo depois na mesma pagina ser redirecionada para outra?

conseguir resolver na função get_record_sql é pra ser get_records_sql esquecir de colocar o "s" e no echo $usr->fullname é pra ser echo $user->fullname

pois então, no phpadmin ele ta fucionando normalmente por exp. se o usuario tem 3 cursos no phpadmin ele mostra os 3 cursos. já ai, ele mostra o ultimo curso inscrito 2 vezes!

<?php require_once("../config.php"); $user=$_GET['user']; $sql="SELECT c.id,c.fullname FROM mdl_role_assignments rs INNER JOIN mdl_context e ON rs.contextid=e.id INNER JOIN mdl_course c ON c.id = e.instanceid WHERE e.contextlevel=50 AND rs.roleid=5 AND rs.userid=4"; $usr=$DB->get_record_sql($sql); foreach ($usr as $user){ echo $usr->fullname."<br>"; } ?> esse codigo puxa do banco de dados do moodle e imprime os cursos do usuario cadastrado. so q esse comando não importa quantos cursos tem cadastrado ele so ta imprimindo 2 cursos e repetido. alguém entendE?

tipo instalei um moodle pra teste e estou utilizando o wamp. o banco de dados do moodle é mysql neste caso eu queria fazer o seguinte. quando o usuario logar, aparecer somente a lista dos cursos. sem nenhum template nem nada. so a lista dos curso q ele ta cadastrado. quando o usuario logar vai abrir esta index. e o q me interessa é o q coloquei em negrito.. q vai ser onde ele vai puxar cursos do usuario logado. entende? <?php if (!file_exists('./config.php')) { header('Location: install.php'); die; } require_once('config.php'); require_once($CFG->dirroot .'/course/lib.php'); require_once($CFG->libdir .'/filelib.php'); redirect_if_major_upgrade_required(); if ($CFG->forcelogin) { require_login(); } else { user_accesstime_log(); } $hassiteconfig = has_capability('moodle/site:config', get_context_instance(CONTEXT_SYSTEM)); $PAGE->set_url('/'); $PAGE->set_course($SITE); /// If the site is currently under maintenance, then print a message if (!empty($CFG->maintenance_enabled) and !$hassiteconfig) { print_maintenance_message(); } if ($hassiteconfig && moodle_needs_upgrading()) { redirect($CFG->wwwroot .'/'. $CFG->admin .'/index.php'); } if (get_home_page() != HOMEPAGE_SITE) { // Redirect logged-in users to My Moodle overview if required if (optional_param('setdefaulthome', false, PARAM_BOOL)) { set_user_preference('user_home_page_preference', HOMEPAGE_SITE); } else if ($CFG->defaulthomepage == HOMEPAGE_MY && (optional_param('redirect', true, PARAM_BOOL) || !$hassiteconfig)) { redirect($CFG->wwwroot .'/my/'); } else if (!empty($CFG->defaulthomepage) && $CFG->defaulthomepage == HOMEPAGE_USER) { $PAGE->settingsnav->get('usercurrentsettings')->add(get_string('makethismyhome'), new moodle_url('/', array('setdefaulthome'=>true)), navigation_node::TYPE_SETTING); } } if (isloggedin()) { add_to_log(SITEID, 'course', 'view', 'view.php?id='.SITEID, SITEID); } /// If the hub plugin is installed then we let it take over the homepage here if (get_config('local_hub', 'hubenabled') && file_exists($CFG->dirroot.'/local/hub/lib.php')) { require_once($CFG->dirroot.'/local/hub/lib.php'); $hub = new local_hub(); $continue = $hub->display_homepage(); //display_homepage() return true if the hub home page is not displayed //mostly when search form is not displayed for not logged users if (empty($continue)) { exit; } } $PAGE->set_pagetype('site-index'); $PAGE->set_other_editing_capability('moodle/course:manageactivities'); $PAGE->set_docs_path(''); $PAGE->set_pagelayout('frontpage'); $editing = $PAGE->user_is_editing(); $PAGE->set_title($SITE->fullname); $PAGE->set_heading($SITE->fullname); echo $OUTPUT->header(); /// Print Section or custom info if (!empty($CFG->customfrontpageinclude)) { include($CFG->customfrontpageinclude); } else if ($SITE->numsections > 0) { if (!$section = $DB->get_record('course_sections', array('course'=>$SITE->id, 'section'=>1))) { $DB->delete_records('course_sections', array('course'=>$SITE->id, 'section'=>1)); // Just in case $section->course = $SITE->id; $section->section = 1; $section->summary = ''; $section->summaryformat = FORMAT_HTML; $section->sequence = ''; $section->visible = 1; $section->id = $DB->insert_record('course_sections', $section); } if (!empty($section->sequence) or !empty($section->summary) or $editing) { echo $OUTPUT->box_start('generalbox sitetopic'); /// If currently moving a file then show the current clipboard if (ismoving($SITE->id)) { $stractivityclipboard = strip_tags(get_string('activityclipboard', '', $USER->activitycopyname)); echo '<p><font size="2">'; echo "$stractivityclipboard&nbsp;&nbsp;(<a href=\"course/mod.php?cancelcopy=true&amp;sesskey=".sesskey()."\">". get_string('cancel') .'</a>)'; echo '</font></p>'; } $context = get_context_instance(CONTEXT_COURSE, SITEID); $summarytext = file_rewrite_pluginfile_urls($section->summary, 'pluginfile.php', $context->id, 'course', 'section', $section->id); $summaryformatoptions = new stdClass(); $summaryformatoptions->noclean = true; $summaryformatoptions->overflowdiv = true; echo format_text($summarytext, $section->summaryformat, $summaryformatoptions); if ($editing) { $streditsummary = get_string('editsummary'); echo "<a title=\"$streditsummary\" ". " href=\"course/editsection.php?id=$section->id\"><img src=\"" . $OUTPUT->pix_url('t/edit') . "\" ". " class=\"iconsmall\" alt=\"$streditsummary\" /></a><br /><br />"; } get_all_mods($SITE->id, $mods, $modnames, $modnamesplural, $modnamesused); print_section($SITE, $section, $mods, $modnamesused, true); if ($editing) { print_section_add_menus($SITE, $section->section, $modnames); } echo $OUTPUT->box_end(); } } if (isloggedin() and !isguestuser() and isset($CFG->frontpageloggedin)) { $frontpagelayout = $CFG->frontpageloggedin; } else { $frontpagelayout = $CFG->frontpage; } foreach (explode(',',$frontpagelayout) as $v) { switch ($v) { /// Display the main part of the front page. case FRONTPAGENEWS: if ($SITE->newsitems) { // Print forums only when needed require_once($CFG->dirroot .'/mod/forum/lib.php'); if (! $newsforum = forum_get_course_forum($SITE->id, 'news')) { print_error('cannotfindorcreateforum', 'forum'); } // fetch news forum context for proper filtering to happen $newsforumcm = get_coursemodule_from_instance('forum', $newsforum->id, $SITE->id, false, MUST_EXIST); $newsforumcontext = get_context_instance(CONTEXT_MODULE, $newsforumcm->id, MUST_EXIST); $forumname = format_string($newsforum->name, true, array('context' => $newsforumcontext)); echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(strip_tags($forumname))), array('href'=>'#skipsitenews', 'class'=>'skip-block')); if (isloggedin()) { $SESSION->fromdiscussion = $CFG->wwwroot; $subtext = ''; if (forum_is_subscribed($USER->id, $newsforum)) { if (!forum_is_forcesubscribed($newsforum)) { $subtext = get_string('unsubscribe', 'forum'); } } else { $subtext = get_string('subscribe', 'forum'); } echo $OUTPUT->heading($forumname, 2, 'headingblock header'); $suburl = new moodle_url('/mod/forum/subscribe.php', array('id' => $newsforum->id, 'sesskey' => sesskey())); echo html_writer::tag('div', html_writer::link($suburl, $subtext), array('class' => 'subscribelink')); } else { echo $OUTPUT->heading($forumname, 2, 'headingblock header'); } forum_print_latest_discussions($SITE, $newsforum, $SITE->newsitems, 'plain', 'p.modified DESC'); echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipsitenews')); } break; case FRONTPAGECOURSELIST: if (isloggedin() and !$hassiteconfig and !isguestuser() and empty($CFG->disablemycourses)) { echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('mycourses'))), array('href'=>'#skipmycourses', 'class'=>'skip-block')); echo $OUTPUT->heading(get_string('mycourses'), 2, 'headingblock header'); print_my_moodle(); echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipmycourses')); } else if ((!$hassiteconfig and !isguestuser()) or ($DB->count_records('course') <= FRONTPAGECOURSELIMIT)) { // admin should not see list of courses when there are too many of them echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('availablecourses'))), array('href'=>'#skipavailablecourses', 'class'=>'skip-block')); echo $OUTPUT->heading(get_string('availablecourses'), 2, 'headingblock header'); print_courses(0); echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipavailablecourses')); } break; case FRONTPAGECATEGORYNAMES: echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('categories'))), array('href'=>'#skipcategories', 'class'=>'skip-block')); echo $OUTPUT->heading(get_string('categories'), 2, 'headingblock header'); echo $OUTPUT->box_start('generalbox categorybox'); print_whole_category_list(NULL, NULL, NULL, -1, false); echo $OUTPUT->box_end(); print_course_search('', false, 'short'); echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipcategories')); break; case FRONTPAGECATEGORYCOMBO: echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('courses'))), array('href'=>'#skipcourses', 'class'=>'skip-block')); echo $OUTPUT->heading(get_string('courses'), 2, 'headingblock header'); $renderer = $PAGE->get_renderer('core','course'); // if there are too many courses, budiling course category tree could be slow, // users should go to course index page to see the whole list. $coursecount = $DB->count_records('course'); if (empty($CFG->numcoursesincombo)) { // if $CFG->numcoursesincombo hasn't been set, use default value 500 $CFG->numcoursesincombo = 500; } if ($coursecount > $CFG->numcoursesincombo) { $link = new moodle_url('/course/'); echo $OUTPUT->notification(get_string('maxnumcoursesincombo', 'moodle', array('link'=>$link->out(), 'maxnumofcourses'=>$CFG->numcoursesincombo, 'numberofcourses'=>$coursecount))); } else { echo $renderer->course_category_tree(get_course_category_tree()); } print_course_search('', false, 'short'); echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipcourses')); break; case FRONTPAGETOPICONLY: // Do nothing!! :-) break; } echo '<br />'; } echo $OUTPUT->footer(); ------------------------------------------------------ o codigo abaixo é o q faz parte da config.php q no caso ele utiliza pra conectar com o banco de dados. <?php unset($CFG); global $CFG; $CFG = new stdClass(); $CFG->dbtype = 'mysqli'; $CFG->dblibrary = 'native'; $CFG->dbhost = 'localhost'; $CFG->dbname = 'moodle'; $CFG->dbuser = 'root'; $CFG->dbpass = ''; $CFG->prefix = 'mdl_'; $CFG->dboptions = array ( 'dbpersist' => 0, 'dbsocket' => 0, ); $CFG->wwwroot = 'http://localhost/moodle'; $CFG->dataroot = 'C:\\wamp\\moodledata'; $CFG->admin = 'admin'; $CFG->directorypermissions = 0777; $CFG->passwordsaltmain = '=bHsQ<v6l8-lkvNS0]FXm1*JGQ4b^3ZH'; require_once(dirname(__FILE__) . '/lib/setup.php');

Como fazer para que eu crie um url php separado so buscando os dados do moodle. por ex. Queria abrir em uma nova pagina os Cursos disponivel do usuario logado. como se fosse listado.. sem o template. sem imagem sem nada, so a lista de curso disponivel?