Author |
Message |
providence
Regular


Joined: Apr 23, 2005
Posts: 95
|
Posted:
Thu Sep 08, 2005 2:00 pm |
|
Hi i was using traffic from nukescripts but i had to reinstall a new phpnuke, all databases were loss
any idea how to edit the traffic counts?
thanks |
|
|
|
 |
hitwalker
Sells PC To Pay For Divorce

Joined:
Posts: 5661
|
Posted:
Thu Sep 08, 2005 2:05 pm |
|
why?
Thats probably the most unreliable thing of nuke..
Sure it must be possible to set it to 200.000.000 page visits.. |
|
|
|
 |
providence

|
Posted:
Thu Sep 08, 2005 2:43 pm |
|
|
|
 |
hitwalker

|
Posted:
Thu Sep 08, 2005 2:47 pm |
|
no...but to be honest...if i knew i wouldnt tell.
but i doubt if its possible that easy...
Usualy when i say its not possible someone comes along saying it can so see if that happens again.....lol
Just a matter of fooling your system but i dont think its that easy..  |
|
|
|
 |
providence

|
Posted:
Thu Sep 08, 2005 3:13 pm |
|
fooling my system?
I have proof that I had hits
I can show them to you, its on my backup sql but i dont know how to restore the file for just the hits
why would anyone request for this if he would just like to display thousands of hits??
my site has 14,000hits and the database went corrupted that is why i had to reinstall nuke |
|
|
|
 |
hitwalker

|
Posted:
Thu Sep 08, 2005 3:16 pm |
|
Dont take it to serious,14.000 hits isnt that much.
Just start over again .... |
|
|
|
 |
providence

|
Posted:
Thu Sep 08, 2005 3:22 pm |
|
14000 hits is big for a small site! |
|
|
|
 |
Raven
Site Admin/Owner

Joined: Aug 27, 2002
Posts: 17088
|
Posted:
Thu Sep 08, 2005 3:24 pm |
|
Yes, it is, and I can understand your concern. If you have the backup tables you should be able to just use phpMyAdmin and load them into your new database. |
|
|
|
 |
hitwalker

|
Posted:
Thu Sep 08, 2005 3:31 pm |
|
well raven,like he wrote in his 1e entry...."all databases were loss"..so i guess that includes everything...meaning a backup to,if there was one..... |
|
|
|
 |
Raven

|
Posted:
Thu Sep 08, 2005 3:33 pm |
|
providence wrote: | fooling my system?
I have proof that I had hits
I can show them to you, its on my backup sql but i dont know how to restore the file for just the hits
why would anyone request for this if he would just like to display thousands of hits??
my site has 14,000hits and the database went corrupted that is why i had to reinstall nuke | That sounds to me like he has them. |
|
|
|
 |
providence

|
Posted:
Thu Sep 08, 2005 3:36 pm |
|
my bad then sorry.. I had a backup but
I just cant restore all
the new site is different now
do you guys know which one i should restore?
Code:
# Table structure for table 'nuke_traffic'
#
CREATE TABLE nuke_traffic (
id int(9) NOT NULL auto_increment,
counter_style varchar(10) NOT NULL,
bullet_style varchar(10) NOT NULL,
display_server_time varchar(10) NOT NULL,
view varchar(10) NOT NULL,
image_border varchar(10) NOT NULL,
show_text_colors varchar(10) NOT NULL,
trafficstartdatemonth char(2) NOT NULL,
trafficstartdateyear varchar(4) NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'nuke_traffic'
#
INSERT INTO nuke_traffic VALUES ( '1', 'image', 'middot', '0', '1', '0', '1', '4', '2005');
# --------------------------------------------------------
|
is this right? |
|
|
|
 |
hitwalker

|
Posted:
Thu Sep 08, 2005 3:37 pm |
|
well he said it went corrupted...so i didnt pay any attention to the idea of repairing it.. |
|
|
|
 |
providence

|
Posted:
Thu Sep 08, 2005 3:49 pm |
|
sorry for the misunderstanding hitwalker and raven |
|
|
|
 |
Raven

|
Posted:
Thu Sep 08, 2005 4:58 pm |
|
No apologies necessary. It wasn't your misunderstanding. |
|
|
|
 |
providence

|
Posted:
Fri Sep 09, 2005 4:01 pm |
|
by the way which database should i restore? |
|
|
|
 |
Raven

|
Posted:
Fri Sep 09, 2005 4:16 pm |
|
Tables, not databases. Restore all the nuke_stats_* tables. |
|
|
|
 |
providence

|
Posted:
Fri Sep 09, 2005 4:41 pm |
|
i had no luck i deleted the old nuke_stats and replaced them with this one
Code:
# --------------------------------------------------------
#
# Table structure for table 'nuke_stats_year'
#
CREATE TABLE nuke_stats_year (
year smallint(6) DEFAULT '0' NOT NULL,
hits bigint(20) DEFAULT '0' NOT NULL
);
#
# Dumping data for table 'nuke_stats_year'
#
INSERT INTO nuke_stats_year VALUES ( '2005', '14392');
|
I replaced all 4 tables, just didnt post them, it was too long
14392 hits gone hehe
still doesnt show 14,000+ hits |
|
|
|
 |
Raven

|
Posted:
Fri Sep 09, 2005 4:51 pm |
|
I see from your first post you are using a different table nuke_traffic. Try restoring that one. |
|
|
|
 |
providence

|
Posted:
Fri Sep 09, 2005 5:09 pm |
|
hmm so far it doesnt work, stilll the same
thanks though! |
|
|
|
 |
Raven

|
Posted:
Sat Sep 10, 2005 1:40 am |
|
You need to determine what tables are being used to display your traffic and then restore those tables from your backups. If your backups do not contain the data you need then you may have to jury-rig the tables. |
|
|
|
 |
|