Go Back   vb.org Archive > Search Forums
Reload this Page Search Results
FAQ Community Calendar Today's Posts Search

Page 1 of 3 1 23
Showing results 1 to 25 of 71
Search took 0.00 seconds. Search: Posts Made By: Issvar
Forum: Modification Requests/Questions (Unpaid) 01-06-2004, 11:03 AM
Replies: 6
Views: 1,131
Posted By Issvar
UPDATE user SET ipaddress = ""

UPDATE user SET ipaddress = ""
Forum: vB3 Programming Discussions 12-02-2003, 05:36 AM
Replies: 2
Views: 995
Posted By Issvar
$games = $DB_site->query(" SELECT * FROM...

$games = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "clan_game
ORDER BY displayorder
");

while ($game = $DB_site->fetch_array($games))
{
globalize($_POST,...
Forum: vB3 Programming Discussions 11-25-2003, 09:58 AM
Replies: 2
Views: 838
Posted By Issvar
SELECT user.*,post.* FROM user LEFT JOIN post on...

SELECT user.*,post.* FROM user LEFT JOIN post on user.id = post.userid WHERE user.a = 1 OR post.a=1
Forum: vB3 Programming Discussions 11-25-2003, 09:55 AM
Replies: 4
Views: 1,005
Posted By Issvar
Use a query like "SELECT post,date FROM posts...

Use a query like "SELECT post,date FROM posts ORDER BY date", and loop through it, like
$curdate=""
while ($data = mysql_fetch_object($queryresults)) {
if ($data->date != $curdate) {
echo...
Forum: vB3 General Discussions 11-05-2003, 08:49 AM
Replies: 5
Views: 903
Posted By Issvar
Yes, that would be quite simple, would take some...

Yes, that would be quite simple, would take some time to execute though.
Forum: vBulletin.org Site Feedback 11-05-2003, 08:23 AM
Replies: 1
Views: 969
Posted By Issvar
Problem with [SQL] and nested parentheses

I tried posting
SELECT
userid,
username,
COUNT(*) as weekpostcount
FROM
post
WHERE
dateline > (UNIX_TIMESTAMP() - 7*24*60*60)
GROUP BY
Forum: Member Archives 11-05-2003, 08:17 AM
Replies: 8
Views: 853
Posted By Issvar
SELECT userid, username, COUNT(*) as...

SELECT
userid,
username,
COUNT(*) as weekpostcount
FROM
post
WHERE
dateline > (UNIX_TIMESTAMP() - 7*24*60*60)
GROUP BY
username,
Forum: vB3 Programming Discussions 11-05-2003, 07:57 AM
Replies: 3
Views: 979
Posted By Issvar
phpMyAdmin cuts the message field to show it on...

phpMyAdmin cuts the message field to show it on screen, if you elect to change that specific record you will be able to completely read the text.

You could also write a simple PHP script that...
Forum: vB3 Programming Discussions 09-14-2003, 11:25 AM
Replies: 1
Views: 1,043
Posted By Issvar
LIMIT 1 means only one post with userid 0 will be...

LIMIT 1 means only one post with userid 0 will be removed. Remove that if you want to remove all posts which have userid 0. You may also want to make sure you have the correct name for the posts...
Forum: vB3 Programming Discussions 09-13-2003, 06:55 PM
Replies: 2
Views: 893
Posted By Issvar
$query='SELECT DISTINCT...

$query='SELECT DISTINCT session.userid,user.username FROM session LEFT JOIN user ON user.userid=session.userid WHERE user.invisible=0 AND session.userid>0 AND ('.time().'-session.lastactivity-1500)<0...
Forum: vB3 Programming Discussions 09-13-2003, 06:19 PM
Replies: 1
Views: 983
Posted By Issvar
I'm not sure if I understand correctly what your...

I'm not sure if I understand correctly what your templates are like now, but if you want to add something at the front and the end of those templates you could use the mysql query:

UPDATE template...
Forum: Member Archives 08-31-2003, 10:32 AM
Replies: 12
Views: 851
Posted By Issvar
Mysqladmin is not mysql, the passwords in one...

Mysqladmin is not mysql, the passwords in one have nothing to do with the other.

Read the documentation for mysql (and for your dns server, webserver, etc).

Run mysql from the commandline to be...
Forum: Member Archives 08-24-2003, 03:23 PM
Replies: 1
Views: 671
Posted By Issvar
Just make a php page on your server that sets...

Just make a php page on your server that sets cookies based on user supplied data, like in the email give the link http://www.server.com/cookie.php?id=432&pass=8aj83jmas83mma93ka2 which would be the...
Forum: Member Archives 08-24-2003, 03:17 PM
Replies: 4
Views: 751
Posted By Issvar
Open forumdisplay.php, and find $sort =...

Open forumdisplay.php, and find
$sort = array();

And add before this line:
if ($forumid == 5) {
$sortfield = 'dateline';
$sqlsortorder = 'DESC';
}
Forum: Modification Requests/Questions (Unpaid) 08-17-2003, 02:30 PM
Replies: 5
Views: 781
Posted By Issvar
Turn off html in signatures, posts, etc. It's...

Turn off html in signatures, posts, etc. It's easy to hack vb when html is enabled.
Forum: Member Archives 08-03-2003, 03:05 PM
Replies: 1
Views: 670
Posted By Issvar
Include global.php in your non-vb pages, be sure...

Include global.php in your non-vb pages, be sure to add the session data to each link on and to your own site, for the login use a small form that contains something like:

<form...
Forum: vB3 Programming Discussions 03-15-2003, 11:37 PM
Replies: 2
Views: 886
Posted By Issvar
It's the number of seconds since 1/1/1970. You...

It's the number of seconds since 1/1/1970. You can get this number using the time() function in php.

Example, user submits data, get time(), check if time from last data is at least 10 smaller,...
Forum: vB3 General Discussions 03-04-2003, 06:04 PM
Replies: 3
Views: 1,376
Posted By Issvar
Someone could just add the x_forwarded header to...

Someone could just add the x_forwarded header to the output of his browser, and so fake his ip. You should also record the real ip.

Also someone using multiple chained proxies that set x_forwarded...
Forum: vB3 Programming Discussions 10-20-2002, 08:06 PM
Replies: 5
Views: 989
Posted By Issvar
Use the LIMIT option in mysql, and make a next...

Use the LIMIT option in mysql, and make a next and previous link that contain 10 more or less than the current limit.

<?
$server= "myserver";
$user= "myaccount";
$password= "pass"; ...
Forum: Member Archives 09-22-2002, 01:29 AM
Replies: 3
Views: 673
Posted By Issvar
Something like this: <?php if ($x=='') {...

Something like this:
<?php
if ($x=='') { $x=0; }
$y=$x+1000;
while ($x<$y) {
// do your stuff
$x++;
}
echo '<html><body>You got to:...
Forum: Member Archives 09-21-2002, 04:00 AM
Replies: 3
Views: 782
Posted By Issvar
rw for whatever user php is running as, rw-rw-rw-...

rw for whatever user php is running as, rw-rw-rw- will always work.
Forum: Member Archives 09-20-2002, 02:24 AM
Replies: 3
Views: 782
Posted By Issvar
You need a comma right before the line you added,...

You need a comma right before the line you added, just like the lines above. Only the last line doesn't have a comma.
Forum: Member Archives 09-18-2002, 10:22 PM
Replies: 5
Views: 673
Posted By Issvar
If you want it to work on Netscape as well you...

If you want it to work on Netscape as well you can't use iframe, so you need to include a javascript php file.

Advantage of javascript is that the user will download it, so it won't go from server...
Forum: Member Archives 09-14-2002, 09:16 AM
Replies: 5
Views: 751
Posted By Issvar
<script language=JavaScript> if...

<script language=JavaScript>
if (document.location.href == "http://www.wrongsite.com/wrongfile.html") {
document.location.href = "http://www.rightsite.com/rightfile.html";
}
</script>
Forum: Member Archives 09-10-2002, 08:40 PM
Replies: 4
Views: 1,182
Posted By Issvar
This is a tool used on warez boards, the ip is...

This is a tool used on warez boards, the ip is the ip address of a compromised computer loaded with illegal software. This hack is not allowed on this board, see also here...
Showing results 1 to 25 of 71
Page 1 of 3 1 23

 
Forum Jump

All times are GMT. The time now is 07:12 PM.

Contact Us - Archive - Top

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.01764 seconds
  • Memory Usage 2,040KB
  • 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
  • (1)footer
  • (1)forumjump
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (2)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)search_results
  • (25)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (2)threadbit_pagelink 
Phrase Groups Available:
  • global
  • inlinemod
  • prefix
  • search
Included Files:
  • ./search.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/functions_search.php
  • ./includes/functions_databuild.php
  • ./includes/functions_forumlist.php
  • ./includes/functions_misc.php
  • ./includes/functions_forumdisplay.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • search_before_process
  • search_start
  • search_results_start
  • search_results_query_posts
  • search_results_prebits
  • threadbit_process
  • search_results_postbit
  • pagenav_page
  • pagenav_complete
  • forumjump
  • search_complete
  • navbits
  • navbits_complete