vBulletin Modifications

FxP Pack Installation Script - Ip to Country

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > Forum Archives > ShavedApe's FxP Pack

Reply
 
LinkBack Thread Tools
Old 12-03-2005, 04:30 PM   #1
Junior Member
Join Date: Dec 2005
Mastercard is on a distinguished road

Default FxP Pack Installation Script - Ip to Country

well first i want to say that i'm really impressed by the nice installer and i'm really looking forward to see the results of the mod..

but when i'm at this point (see topictitle) it gives an error (max execution time exceeded) and the solution is below it but i don't really understand that...

Quote:
you will have to import the iptocountry.sql you can try the install_ips.php
where do i get this install_ips.php? it isn't in the rar file... and how to use it, just go to host.com/forum/install_ips.php?

and if that doesnt work the installer sais i should make smaller files and do it by hand, how does that work?

thanks in advance




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Old 12-04-2005, 01:53 AM   #2
Michael Biddle
Staff
Michael Biddle's Avatar
Join Date: Feb 2005
Real Name: Michael Biddle
Location: Anaheim
Michael Biddle is on a distinguished road

Default

Master Card, they have addressed this before in the release. SA says he doenst even have the file any more, what it means to make it into a smaller file, is to open the ip-to-country.csv, and take it down to smaller bits, and then save them. then login to you phpmyadmin if you have it, and upload them individually. Make sure you remember to put in the sql command first ;)




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 12-30-2005, 07:19 PM   #3
Charter Member
Join Date: Jul 2004
GunVorKinG is on a distinguished road

Default

Any chance you can give that SQL command away?
Really stuck with this problem, and seems noone has a real answer on how it can be fixed.

Thanks.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 12-30-2005, 07:41 PM   #4
Coder
Senna's Avatar
Join Date: Mar 2005
Location: LalaLand
Senna is on a distinguished road

Default

play a bit with this line and you might figure it out ;)

$sql="INSERT INTO iptocountry ( `ip_from` , `ip_to` , `country_code2` , `country_code3` , `country_name` ) VALUES ('" . addslashes($data[0]) . "', '" . addslashes($data[1]) . "', '" . addslashes($data[2]) . "', '" . addslashes($data[3]) . "', '" . addslashes($data[4]) . "');";
$DB_site->query($sql);




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 12-31-2005, 11:33 AM   #5
Charter Member
Join Date: Jul 2004
GunVorKinG is on a distinguished road

Default

Quote:
Originally Posted by Ike013
play a bit with this line and you might figure it out ;)

$sql="INSERT INTO iptocountry ( `ip_from` , `ip_to` , `country_code2` , `country_code3` , `country_name` ) VALUES ('" . addslashes($data[0]) . "', '" . addslashes($data[1]) . "', '" . addslashes($data[2]) . "', '" . addslashes($data[3]) . "', '" . addslashes($data[4]) . "');";
$DB_site->query($sql);

Thanks for responding. Gonna see if i can figure it out, SQL is not my bright side




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 01-01-2006, 10:57 AM   #6
Charter Member
Join Date: Jul 2004
GunVorKinG is on a distinguished road

Default

I read another thread about the same issue, in that post the starter mention he has something in his tables. But to quote SA:
"The table either contains data or it doesnt it doesnt hold anything else."

What does he mean here? I got a table named "iptocountry". It contains:
ip_from
ip_to
country_code2
country_code3
country_name

And i had it before i tried your line Ike013. Could be the reason i getting errors
Cause your line states: $sql="INSERT INTO iptocountry ( `ip_from` , `ip_to` , `country_code2` , `country_code3` , `country_name` )

Quite useless to insert something i already have :p

Well, the real question i got for this post is no more then:
Is it best to delete the "iptocountry" table before i do anything else?

Thanks.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 01-01-2006, 02:33 PM   #7
Coder
Maxx's Avatar
Join Date: Sep 2004
Location: U.K
Maxx is on a distinguished road

Default

there is a free class @ phpclasses.org for importing csv files try there ;)




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old 01-03-2006, 09:45 PM   #8
Charter Member
Join Date: Jul 2004
GunVorKinG is on a distinguished road

Default

Everything worked out just fine.
Thanks for all the help guys.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT -3. The time now is 03:54 AM.

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc. (Patent Pending)