[BETA] Users Of The Day

Misc MOD Downloads for phpBB3 -- Any MOD that does not fit into any other category
Forum rules
Image Please feel free to download any MOD's here, support for each MOD is located it's own thread.

To post your own MOD, please first read the MOD Guidelines

Re: [BETA] Users Of The Day

Postby Sniper_E » 04 Nov 2008, 19:24

Woody, all the mods you download have an install.xml file with the download that you open in your web browser.
Just look for the .xml file that comes with the download.
This mod one has a users_of_the_day.xml file in it's download. Open users_of_the_day.xml with your web browser.
There are sql commands you have to do when installing this mod also.
No is NEVER an Option and NEVER is the only Option when it comes to Giving Up!
User avatar
Sniper_E    
STG Jedi Master
STG Jedi Master
 
Posts: 7003
Joined: 31 May 2006, 06:29
Location: Shreveport, LA
Favorite Team: The STG Team
Gender: Male
phpBB Knowledge: 6


Re: [BETA] Users Of The Day

Postby woody2k4 » 05 Nov 2008, 09:31

I'm not sure on how i would do that. Maybe ill leave it
woody2k4    
Lt. Jr Grade
Lt. Jr Grade
 
Posts: 137
Joined: 28 Jul 2008, 15:07
Location: England
Favorite Team: West Ham
Gender: Male
phpBB Knowledge: 2

Re: [BETA] Users Of The Day

Postby Ladysarajane » 05 Nov 2008, 12:38

woody2k4 wrote:I'm not sure on how i would do that. Maybe ill leave it


After you downloaded the mod...extract it (unzip it) Now look in the extracted file and you should see 3 files in there. A root file, a users_of_the_day.XML document and a modx.prosilver.en file
Now to open the instructions...double click on the users_of the_day.XML file. Now give it a minute and it should open up your browser and display the the instructions there. If it doesn't open, then open your browser, click on file on your toolbar->Open File and browse your computer till you find the XML file that you have extracted. Click on that and the instructions should display in the browser window. Follow those to install the mod.
Warning: Stay away from Deck 15 if you don't have security clearance level 6 or above! Unauthorized access is prohibited.
Image
User avatar
Ladysarajane
STG Moderator
STG Moderator
 
Posts: 1962
Joined: 21 Mar 2007, 23:35
Favorite Team: Bengals
Gender: Female
phpBB Knowledge: 5

Re: [BETA] Users Of The Day

Postby woody2k4 » 08 Nov 2008, 06:17

How do i make the sql edits? i assume i do this in my php admin? which i have not even attempted to use yet?
woody2k4    
Lt. Jr Grade
Lt. Jr Grade
 
Posts: 137
Joined: 28 Jul 2008, 15:07
Location: England
Favorite Team: West Ham
Gender: Male
phpBB Knowledge: 2

Re: [BETA] Users Of The Day

Postby Ladysarajane » 08 Nov 2008, 13:01

woody2k4 wrote:How do i make the sql edits? i assume i do this in my php admin? which i have not even attempted to use yet?


Correct and it isn't that hard. Go to phpmyadmin. On the left look for your database name and click on that. If it is already showing (if it is the only database in there, it may show it by default), Take a look at the prefix before the tables name. Usually it is phpbb_ but sometimes it can have a different prefix such as phpbb3_
You need to note that for when you run the sql statement.
Now on the phpmyadmin in the right pane (main window) you will see some tabs going across it.They should be like "Structure SQL Search Query etc"
Click on the SQL one.
Now you will have a Big text box and above it, it will say "Run SQL query/queries on database (Your database Name)
Now go to your instructions and copy and paste the sql into that text box. Make sure you change the table prefixes to the prefixes that your database uses.

Code: Select all
ALTER TABLE phpbb_users ADD user_lastrefresh INT( 11 ) NOT NULL AFTER user_lastvisit;
is the default....but if your prefix is ' phpbb3_ '
Then you would alter it to be:
Code: Select all
ALTER TABLE phpbb3_users ADD user_lastrefresh INT( 11 ) NOT NULL AFTER user_lastvisit;


In this case 'phpbb_" is the prefix and 'users' is the table name.
Now after you copy and paste the code and make sure that the prefix match your tables prefixes, then click on GO under the text box on the right hand side. The page should start refreshing, and make take a moment or tow, then it should tell you if it was successful or not in making the changes.
Warning: Stay away from Deck 15 if you don't have security clearance level 6 or above! Unauthorized access is prohibited.
Image
User avatar
Ladysarajane
STG Moderator
STG Moderator
 
Posts: 1962
Joined: 21 Mar 2007, 23:35
Favorite Team: Bengals
Gender: Female
phpBB Knowledge: 5

Re: [BETA] Users Of The Day

Postby woody2k4 » 09 Nov 2008, 12:41

it already has this code in

SELECT * FROM `phpbb_users` WHERE 1
user_lastrefresh INT( 11 ) NOT NULL AFTER user_lastvisit;

shall, i leave it in so it would look like this?
woody2k4    
Lt. Jr Grade
Lt. Jr Grade
 
Posts: 137
Joined: 28 Jul 2008, 15:07
Location: England
Favorite Team: West Ham
Gender: Male
phpBB Knowledge: 2

Re: [BETA] Users Of The Day

Postby woody2k4 » 09 Nov 2008, 16:25

i hate not knowing what i'm doing
woody2k4    
Lt. Jr Grade
Lt. Jr Grade
 
Posts: 137
Joined: 28 Jul 2008, 15:07
Location: England
Favorite Team: West Ham
Gender: Male
phpBB Knowledge: 2

Re: [BETA] Users Of The Day

Postby woody2k4 » 13 Nov 2008, 08:43

can anyone help?
woody2k4    
Lt. Jr Grade
Lt. Jr Grade
 
Posts: 137
Joined: 28 Jul 2008, 15:07
Location: England
Favorite Team: West Ham
Gender: Male
phpBB Knowledge: 2

Re: [BETA] Users Of The Day

Postby Ladysarajane » 13 Nov 2008, 20:47

I am not sure what you are asking...All I can say it to reread my post on how to copy SQL instructions from a mod to phpmyadmin to run a query.
Warning: Stay away from Deck 15 if you don't have security clearance level 6 or above! Unauthorized access is prohibited.
Image
User avatar
Ladysarajane
STG Moderator
STG Moderator
 
Posts: 1962
Joined: 21 Mar 2007, 23:35
Favorite Team: Bengals
Gender: Female
phpBB Knowledge: 5

Re: [BETA] Users Of The Day

Postby woody2k4 » 15 Nov 2008, 12:33

i hit go and got an error


Error
SQL query:

SELECT *
FROM `phpbb_users`
WHERE 1
ALTER TABLE phpbb_users ADD user_lastrefresh INT( 11 ) NOT NULL AFTER user_lastvisit LIMIT 0 ,
30

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE phpbb_users ADD user_lastrefresh INT ( 11 ) NOT NULL AFTER user_last' at line 1
woody2k4    
Lt. Jr Grade
Lt. Jr Grade
 
Posts: 137
Joined: 28 Jul 2008, 15:07
Location: England
Favorite Team: West Ham
Gender: Male
phpBB Knowledge: 2

PreviousNext

Return to Miscellaneous MODs, Hacks and Downloads

Who is online

Users browsing this forum: Google Adsense [Bot] and 4 guests