https://www.icyphoenix.com/viewtopic.php?f=4&t=6348
-----------------------------------
Lopalong
Sat 22 Aug, 2009 14:01

DB - Add MOD'S SQL Using Icy Phoenix ACP.
-----------------------------------
8) 

When adding the SQL instructions that you will find in some Icy Phoenix MODS which require database modification - - - - - 

[b]Go To:[/b]

[b]Your forum > ACP > DB And Security > IP MySQLAdmin > Query Your Database: - [u]Click[/u] the SQL icon > Then Paste the MOD SQL into the window > Click "Sumbit Query".[/b]

[b]Note:[/b] You must ensure that the MOD SQL prefix ([b]The Default is usually ip_[/b]) is the same as all of the other prefixes that are in your database. If they are [b]not![/b] then you [b][u]MUST[/u][/b] change them to whatever prefix your Icy Phoenix database uses.

 :mricy:


-----------------------------------
Chaotic
Sat 22 Aug, 2009 19:34

Re: [DOC] How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
Nice work, Lopalong!

- Moving to the Documentation And How To forum.

:)


-----------------------------------
Lopalong
Sun 23 Aug, 2009 00:06

Re: [DOC] How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
Thanks, but I wasn't aware until now that you had done something similar. :)

So now users will have the choice of what they feel more comfortable with.  8)


-----------------------------------
spydie
Sun 23 Aug, 2009 00:08

Re: [DOC] How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
Chaotic´s is a bit more extendent , but at the end the result should be the same.

Good job, Lopa


-----------------------------------
Lopalong
Sun 23 Aug, 2009 00:28

Re: [DOC] How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
I had forgotten about the ACP IP-SQL until I thought about how to do this in the simplest way using the KISS system!  :mryellow: 

I may also look at adding a db_update.php, even if I have to do them manually - Because as I remember, the Auto one no longer works with IP since the code changes made in v1.3*.


-----------------------------------
spydie
Sun 23 Aug, 2009 00:44

Re: [DOC] How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
There´s an auto DB update in the IP-install.

so the auto Update should still run .

and if you have an look at DWho´s MPS mod, there is autoupdate aswell.

Edit file is attached


-----------------------------------
Lopalong
Sun 23 Aug, 2009 04:14

Re: [DOC] How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
Thanks Spydie,

I've added db_update.php to all the MODS that require SQL, and what I hope are some "Simple" instructions.  :mryellow: 

I'll also post something simple a little later that MOD-Makers can use to create their own db_update.php.

And hopefully, that will be the end of that.  :lol:


-----------------------------------
DWho
Sat 29 Aug, 2009 11:42

Re: DB - How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
Glad i can help even if it is not directly...

if I remember icy1.2 and function in the acp that if you added the database changes into the text box and then hit submit it would make an install file for you....

if it is not in icy1.2 I know there is a mod that does it somewhere...

 :mrgreen:  :mrgreen:


-----------------------------------
Mighty Gorgon
Sat 29 Aug, 2009 11:54

Re: DB - How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
I have removed that file... because I thought nobody was using it. :wink:


-----------------------------------
Lopalong
Sat 29 Aug, 2009 12:18

Re: DB - How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
@ Mike,

It was actually part of the Menu (Required Admin Permissions).[b] Edit:[/b] Hang on! I could be wrong there too come to think of it. Maybe it was in the ACP Menu - Damn!  :mricy: 

@MG,

Yes or No? It was useful and as much as I decided against re-visiting IP.1.2* etc to dig it out and possibly have to update it, for the amount of mods being generated (When others could use an example db_install.php)  - Does it really warrant being upgraded and made available. I just stole a copy of Mike's and adjusted it. :P

Just a thought?


-----------------------------------
DWho
Sat 29 Aug, 2009 16:23

Re: DB - How To Add MOD'S SQL Using Icy Phoenix. (Walkthrough)
-----------------------------------
i am going to use that file for when doing mods... I do not want to update the old sql generator file either.. i always for got it was there...

 :mrgreen:  :mrgreen:


