[BETA] Users Of The Day

[Sniper_E]

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.

[woody2k4 dean]

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

[Ladysarajane]

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.

[woody2k4 dean]

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?

[Ladysarajane]

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.

[woody2k4 dean]

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 dean]

i hate not knowing what i'm doing

[woody2k4 dean]

can anyone help?

[Ladysarajane]

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.

[woody2k4 dean]

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