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

Showing results 1 to 23 of 23
Search took 0.00 seconds. Search: Posts Made By: SiGmA_X
Forum: vB3 Programming Discussions 06-16-2003, 06:19 AM
Replies: 2
Views: 764
Posted By SiGmA_X
Double Update

I have two queries I want to combine.. Here they are,UPDATE pchm_setting SET value='7' WHERE class='ads' AND name='next'And:UPDATE pchm_ad_banner SET impressions='105' WHERE id='5'So if you can help,...
Forum: vBulletin 2.x Full Releases 06-15-2003, 10:40 AM
Replies: 45
Views: 8,315
Posted By SiGmA_X
Great hack!

Great hack!
Forum: vB3 General Discussions 06-15-2003, 10:09 AM
Replies: 4
Views: 1,168
Posted By SiGmA_X
On CuteFTP? Did you try using a .htaccess file?...

On CuteFTP? Did you try using a .htaccess file? Works on all Apache servers.. Windows doesn't like them tho ;)
Forum: vB3 Programming Discussions 06-14-2003, 06:23 AM
Replies: 2
Views: 1,101
Posted By SiGmA_X
Nothing. It's just the extension. Most servers...

Nothing. It's just the extension. Most servers allow all the extensions listed above, but some just allow .php. It's a server choice. Most scripts using .php3 are old. The norm. is .php but you can...
Forum: vBulletin 2.x Full Releases 05-29-2003, 01:09 AM
Replies: 82
Views: 17,557
Posted By SiGmA_X
I'm having a strange problem.. Followed all...

I'm having a strange problem.. Followed all directions, and it works IF and only IF you click a 'quote' box. If you do not, it doesn't let you reply. Is there a way to make it so you can click Reply...
Forum: vBulletin 2.x Full Releases 05-29-2003, 12:12 AM
Replies: 942
Views: 142,120
Posted By SiGmA_X
I love this hack :) Customized it a bit (The...

I love this hack :) Customized it a bit (The damned exec() security hole.. (https://vborg.vbsupport.ru/showthread.php?postid=387989#post387989);)) but it works great. Is there a way to get the Apache...
Forum: vB3 Programming Discussions 05-15-2003, 12:25 AM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Thank you Xenon, I see now. 1 sec.. Awsome! It...

Thank you Xenon, I see now. 1 sec.. Awsome! It now works :) Thank you all.

Oh, and about that count problem I was having.. I got it! Just needed a GROUP BY:SELECT news.id AS newsid, COUNT(*) AS...
Forum: vB3 Programming Discussions 05-14-2003, 03:56 PM
Replies: 9
Views: 1,023
Posted By SiGmA_X
So if you need the speed, re-compileing the CVS...

So if you need the speed, re-compileing the CVS might be needed.. :)
Forum: vB3 Programming Discussions 05-14-2003, 03:54 PM
Replies: 7
Views: 1,009
Posted By SiGmA_X
What does the +3153600 do? Being the time is from...

What does the +3153600 do? Being the time is from the Epoch, it will have year.. I am still unsure why you are adding the extra numbers in :\
Forum: vB3 Programming Discussions 05-14-2003, 03:48 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Okay, still is erroring..UPDATE pchm_affiliates...

Okay, still is erroring..UPDATE pchm_affiliates SET impressions = IF (

id = 8,
'977',
IF (
id = 3,
'2062',
IF (
id = 4,
'996',
Forum: vB3 Programming Discussions 05-14-2003, 03:38 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Okay, I'll change that. But it works with...

Okay, I'll change that. But it works with doublequotes in your example and in the short one that I wrote in post 394,761 (https://vborg.vbsupport.ru/showthread.php?postid=394761#post394761) a bit up...
Forum: vB3 Programming Discussions 05-14-2003, 12:02 AM
Replies: 7
Views: 1,009
Posted By SiGmA_X
Hang on, time()...

Hang on, time() (http://www.php.net/manual/en/function.time.php) doesn't have a year in it? It says it does, and in practice seems to, because it records the amount of seconds from the Epoch, which...
Forum: vB3 Programming Discussions 05-13-2003, 11:52 PM
Replies: 4
Views: 943
Posted By SiGmA_X
Is MySQL running? That error reminds me of when I...

Is MySQL running? That error reminds me of when I try to connect to MySQL via console on my Linux server, when the MySQL server isn't started ;) Make sure its running, or contact your host.
Forum: vB3 Programming Discussions 05-13-2003, 11:51 PM
Replies: 9
Views: 1,023
Posted By SiGmA_X
Sure sounds like it! If it's your own server, you...

Sure sounds like it! If it's your own server, you could download the source from CVS and compile it.. Works well, normally :)
Forum: vB3 Programming Discussions 05-13-2003, 11:49 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Humm, okay.. I have been working on this, and got...

Humm, okay.. I have been working on this, and got my loop to work, or so it seems. It returns a error when ran in phpMyAdmin however. Here is the MySQL QueryUPDATE pchm_affiliates SET impressions =...
Forum: vB3 Programming Discussions 05-13-2003, 10:23 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Humm, having a little trouble with a loop for...

Humm, having a little trouble with a loop for this because of the looping parans in the IF. The amount of affiliates could change, so it has to loops and cannot be set. How can I close the ')'s each...
Forum: vB3 Programming Discussions 05-13-2003, 10:12 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Okay, I looked at this thread...

Okay, I looked at this thread (https://vborg.vbsupport.ru/showthread.php?s=&threadid=46676&highlight=MyChenQL) and tried out a IF in a query... Here's the query I tried it with:UPDATE pchm_affiliates...
Forum: vB3 Programming Discussions 05-13-2003, 09:44 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Well, it needs to update all the records based on...

Well, it needs to update all the records based on id, but only one field (impressions) needs updating. The data will be diffrent for each, most likely.

I'll search for the keyword 'MyChenQL' but...
Forum: vB3 Programming Discussions 05-12-2003, 10:58 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
I don't think I fully understand... Can you post...

I don't think I fully understand... Can you post an example?
Forum: vB3 Programming Discussions 05-12-2003, 10:56 PM
Replies: 9
Views: 1,023
Posted By SiGmA_X
This won't be much help, but it doesn't work in...

This won't be much help, but it doesn't work in the normal release of PHP4.3.1 with the following configures:As PHP.net said, perhaps it is only in the CVS version?
Forum: vB3 Programming Discussions 05-12-2003, 10:49 PM
Replies: 13
Views: 1,279
Posted By SiGmA_X
Mass Update (MySQL & PHP)

Okay, I just typed this out in a long message, but IE crashed, so you are getting the short version now!

I need to update 21 records in one batch, that updates the same field and same table. Right...
Forum: vBulletin 2.x Full Releases 04-27-2003, 07:39 PM
Replies: 95
Views: 22,362
Posted By SiGmA_X
And, for <img> tag's to be XHTML1.0 complient,...

And, for <img> tag's to be XHTML1.0 complient, they also need an alt="" and a trailing slash.

Ex: <img src="URL" height="" width="" alt="" />
Forum: vBulletin 2.x Full Releases 04-27-2003, 04:57 PM
Replies: 942
Views: 142,120
Posted By SiGmA_X
First off, I love this hack, really great; thank...

First off, I love this hack, really great; thank you :)

Now, I have a few comments.. Perhaps they have been covered, but I don't want to read through all of the many posts in this thread..

How...
Showing results 1 to 23 of 23

 
Forum Jump

All times are GMT. The time now is 05:28 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.03570 seconds
  • Memory Usage 2,008KB
  • 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)post_thanks_navbar_search
  • (1)search_results
  • (23)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (33)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
  • forumjump
  • search_complete
  • navbits
  • navbits_complete