Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 07-02-2008, 12:18 PM
cybernine186
Sarnak
 
Join Date: Feb 2008
Posts: 87
Default

FYI: This only works with characters that is offline. If you do make changes to a character the changes are not permanent.
Reply With Quote
  #2  
Old 07-02-2008, 12:57 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

Quote:
Originally Posted by cybernine186 View Post
FYI: This only works with characters that is offline. If you do make changes to a character the changes are not permanent.
you mean changes NOT permanent to a char who is ONLINE, or they.. never permanent? =)
Reply With Quote
  #3  
Old 07-02-2008, 01:33 PM
cybernine186
Sarnak
 
Join Date: Feb 2008
Posts: 87
Default

Changes only work with characters that is offline. (With the exception of Account Table Changes such as: GM, Account Status, Revoked, and Inventory.)


You can view any character at any time no matter if they are online or offline.

If you change anything on a character while they are playing the change is simply ignored by the client because this edits the database directly. Then when the client sends changes and saves the profile to the servers database the entire profile in the database is overwritten by what the client has.


Try it out for your self and post your results......
Reply With Quote
  #4  
Old 07-02-2008, 01:37 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

I've got it installed and edited the configuration.php file, but it continuously asks me for a username/password.

any thoughts?
Reply With Quote
  #5  
Old 07-02-2008, 02:12 PM
cybernine186
Sarnak
 
Join Date: Feb 2008
Posts: 87
Default

That is the login username and password...

Default is.
Username: admin
password: admin

You can change it in the configuration.php file
Reply With Quote
  #6  
Old 07-02-2008, 03:31 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

This is going to be a huge help to me, thank you! Much thanks for writing it in PHP, as that's what I limited to using.
Reply With Quote
  #7  
Old 07-02-2008, 03:59 PM
cybernine186
Sarnak
 
Join Date: Feb 2008
Posts: 87
Default

The Coin Wipe under the Maintenance section doesn't work....

This is the proper script for the coin_wipe.php under the scripts folder


PHP Code:
<?php
include("../includes/global.php");


$wipe = new mysql_db;
$wipe->sql "SELECT `id` FROM `character_`";
$wipe->query();

while(
$row $wipe->fetch_assoc()){
    
$profile = new eq;
    
$profile->LoadProfile($row['id']);
    
$profile->SetValue(0'platinum');
    
$profile->SetValue(0'gold');
    
$profile->SetValue(0'silver');
    
$profile->SetValue(0'copper');
    
$profile->SetValue(0'platinum_bank');
    
$profile->SetValue(0'gold_bank');
    
$profile->SetValue(0'silver_bank');
    
$profile->SetValue(0'copper_bank');
    
$profile->SetValue(0'platinum_cursor');
    
$profile->SetValue(0'gold_cursor');
    
$profile->SetValue(0'silver_cursor');
    
$profile->SetValue(0'copper_cursor');
    
$profile->SetValue(0'platinum_shared');
    
$profile->SaveProfile();
    
printf("%d | "$row['id']);
}
?>
Reply With Quote
Reply

Thread Tools
Display Modes

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

Forum Jump

   

All times are GMT -4. The time now is 01:22 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3