View Single Post
  #319  
Old 04-20-2009, 02:49 AM
mariocaz mariocaz is offline
 
Join Date: Feb 2008
Location: Mexico, D.F.
Posts: 424
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ted,

I checked the prodict file, and the part that you told me to add a // alrady have it in the file that I downloaded here, check it:

Code:
				// check if mod is already installed
				
				$db->reporterror = 0;
				$lgvtbl = $db->query_first("SELECT COUNT(id) as lgv FROM ". TABLE_PREFIX ." lgv");
				
				if (!$lgvtbl['cnt']){
					
					// create the table										
					$db->query_write("CREATE TABLE ". TABLE_PREFIX ." lgv (
						  id smallint(5) unsigned NOT NULL auto_increment,
						  ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',
							firstaccess INT UNSIGNED NOT NULL DEFAULT '0',
							views INT(4) NOT NULL DEFAULT '0',
							lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
						  PRIMARY KEY (id),
						  KEY indexs (ipaddress,views,lastactivity)
						) TYPE=MyISAM
					");
					
					// insert the first record
					$db->query_write("
						INSERT INTO " . TABLE_PREFIX . "lgv SET 
						ipaddress =  '123.456.789.012',
						firstaccess  = ". TIMENOW .",
						views = 1,
						lastactivity = ". TIMENOW ."
					");
									
					echo "<font size=\"1\">Added mySQL Tables</font><br /><br />";
					
				} else {					
					echo "mySQL table already exists.";					
				}
But maybe I am wrong, just tell me.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01654 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete