vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Records from database (https://vborg.vbsupport.ru/showthread.php?t=246381)

Przemoo 07-12-2010 09:38 PM
1 Attachment(s)
it show up but on the top only (take a look on a screen)

BirdOPrey5 07-12-2010 09:54 PM
That's good, that means there are 4,668 rows in your variable- the SQL statement is right (probably) you just need to figure out how to print it. (Which I realize was your first question to start this thread, but at some point you questioned if the SQL statement was right).

Przemoo 07-13-2010 09:40 AM
its working now, because of $dane

PHP Code:
$gracz = $row["player_username"];   
$admin = $row["admin_username"];   
$data = $row["screenshot_time"];   
$mapa = $row["map"];  
$ip = $row["player_authid"];   
$x++;
$data = date("H:i:s  d.m.Y",$data);  
$dane = (''.$dane.'
    <tr>
    <td class="alt2" align="center" width="2%"><span class="screeny2">&nbsp;'.$x.'</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$gracz.'</span></td>
    <td class="alt2" align="center" width="15%"><span class="screeny2">&nbsp;'.$admin.'&nbsp;</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$ip.'&nbsp;</span></td>      
    <td class="alt2" align="center" width="17%"><span class="screeny2">&nbsp;'.$data.'&nbsp;</span></td>  
    <td class="alt1" align="center" width="13%"><span class="screeny2">&nbsp;'.$mapa.'&nbsp;</span></td>
    </tr>
');
} while( $row = $db->fetch_array($sql) ) ; 

but there is another problem with pagination
i used tha article - https://vborg.vbsupport.ru/showthrea...ght=Paginating

paginating shows up but only for few minutes and then disappeared


that how it is

PHP Code:
<?php 

// ####################### SET PHP ENVIRONMENT ########################### 
error_reporting(E_ALL & ~E_NOTICE); 

// #################### DEFINE IMPORTANT CONSTANTS ####################### 
define('NO_REGISTER_GLOBALS', 1); 
define('THIS_SCRIPT', 'test'); // change this depending on your filename 

// ################### PRE-CACHE TEMPLATES AND DATA ###################### 
// get special phrase groups 
$phrasegroups = array( 

); 

// get special data templates from the datastore 
$specialtemplates = array( 
     
); 

// pre-cache templates used by all actions 
$globaltemplates = array( 
    'screeny', 
); 

// pre-cache templates used by specific actions 
$actiontemplates = array( 

); 

// ######################### REQUIRE BACK-END ############################ 
require_once('./global.php'); 

// ####################################################################### 
// ######################## START MAIN SCRIPT ############################ 
// ####################################################################### 

$navbits = array(); 
$navbits[$parent] = 'Testowa Strona';


$sql_conn = mysql_connect('host', 'login', 'password');
mysql_select_db('database',$sql_conn);

    // Default page variables 
    $perpage = $vbulletin->input->clean_gpc('r', 'perpage', TYPE_UINT);
    $pagenumber = $vbulletin->input->clean_gpc('r', 'pagenumber', TYPE_UINT); 
    
    // Count all log entries 
    $bannedcount = $db->query_first(" 
        SELECT COUNT(`player_username`) AS `bannedcount` 
        FROM `amx_screenshots` 
    "); 
    
    sanitize_pageresults($bannedcount['bannedcount'], $pagenumber, $perpage, 100, 25); 
    
    // Default lower and upper limit variables 
    $limitlower = ($pagenumber - 1) * $perpage + 1; 
    $limitupper = $pagenumber * $perpage; 
    if ($limitupper > $bannedcount['bannedcount']) 
    { 
        // Too many for upper limit 
        $limitupper = $bannedcount['bannedcount']; 
        if ($limitlower > $bannedcount['bannedcount']) 
        { 
            // Too many for lower limit 
            $limitlower = $bannedcount['bannedcount'] - $perpage; 
        } 
    } 
    if ($limitlower <= 0) 
    { 
        // Can't have negative or null lower limit 
        $limitlower = 1; 
    }
    


    
    

$sql = mysql_query("SELECT * FROM amx_screenshots ORDER BY ssid DESC LIMIT " . ($limitlower - 1) . ", $perpage ");
$x=0;
do  
{   

 

$gracz = $row["player_username"];   
$admin = $row["admin_username"];   
$data = $row["screenshot_time"];   
$mapa = $row["map"];  
$ip = $row["player_authid"];   
$x++;
$data = date("H:i:s  d.m.Y",$data);  
$dane = (''.$dane.'
    <tr>
    <td class="alt2" align="center" width="2%"><span class="screeny2">&nbsp;'.$x.'</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$gracz.'</span></td>
    <td class="alt2" align="center" width="15%"><span class="screeny2">&nbsp;'.$admin.'&nbsp;</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$ip.'&nbsp;</span></td>      
    <td class="alt2" align="center" width="17%"><span class="screeny2">&nbsp;'.$data.'&nbsp;</span></td>  
    <td class="alt1" align="center" width="13%"><span class="screeny2">&nbsp;'.$mapa.'&nbsp;</span></td>
    </tr>
');
} while( $row = $db->fetch_array($sql) ) ;
   
$pagenav = construct_page_nav($pagenumber, $perpage, $bannedcount['bannedcount'], 'screeny.php?' . $vbulletin->session->vars['sessionurl'] . 'do=view');  
$navbits = construct_navbits($navbits); 
eval('$navbar = "' . fetch_template('navbar') . '";'); 
eval('print_output("' . fetch_template('screeny') . '");'); 

?>

kh99 07-13-2010 12:06 PM
I'm not sure how that's supposed to work. It looks like you're always starting at the first record instead of calculating " $limitlower " like in the article.

Also, I think you might want to go back to using a "while" loop instead of "do...while", because I think the way you have it you're using the "$row" variable the first time before you've set it.

BTW, you probably don't want to post your database connect info. Is there a reason you're opening a database connection instead of using the one vB opens?

Przemoo 07-13-2010 12:12 PM
Quote:
Originally Posted by kh99 (Post 2068509)
I'm not sure how that's supposed to work. It looks like you're always starting at the first record instead of calculating " $limitlower " like in the article.

Also, I think you might want to go back to using a "while" loop instead of "do...while", because I think the way you have it you're using the "$row" variable the first time before you've set it.

BTW, you probably don't want to post your database connect info. Is there a reason you're opening a database connection instead of using the one vB opens?
omg i forgot to hide it :) ;p thx

my hosting is sux, i've got limit in "max_user_connection" and my script doesn't close the connection thats why am using VPS for that.
pagenav was working yesterday i don't know why is not :/

kh99 07-13-2010 12:24 PM
Oh. Anyway, I see that you *did* calculate $limitlower, you just used 1 in the query, so maybe you were just debugging.

Przemoo 07-13-2010 12:26 PM
could you show me an example ? am not best in php :/

kh99 07-13-2010 12:29 PM
No, it was my mistake, what you have is right. :) Sorry, I was looking at the wrong code.

Przemoo 07-13-2010 12:33 PM
is right but still without pagination :D maybe i will find it somewhere

Przemoo 07-16-2010 04:44 PM
still not working :/ any solutions for that ?


All times are GMT. The time now is 06:28 PM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01077 seconds
  • Memory Usage 1,787KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete