ArcEmu: aowow for arcemu - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

aowow for arcemu

#1 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 21 September 2009 - 06:40 AM

Quote

http://sourceforge.net/projects/aowow/
Web Interface for a MaNGOS


i make for Russian localized

items 100% works

2

#2 User is offline   pingue 

  • Member
  • Pip
  • Group: Members
  • Posts: 99
  • Joined: 18-July 09
  • Gender:Male
  • Location:EARTH LULZ!
  • Interests:web designing.. grilz n titz, wow :3

Posted 21 September 2009 - 07:06 AM

Woah, very nice :( 2 thumbs up
Posted Image
0

#3 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 21 September 2009 - 04:21 PM

Lol. Swifty, this dude beat us to it :D

And dude, one quick q. I'm not sure exactly what to do. Am I supposed to download the SVN, images, maps and then run your SQL you put as an attachment?
0

#4 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 22 September 2009 - 12:27 AM

i don't want change code
my sql make view table (like fake mangos base structure)

0

#5 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 22 September 2009 - 03:30 AM

I finish
who want look
http://lking.ru/whl/

0

#6 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 22 September 2009 - 07:27 AM

Nice job! But how do you run the SQL you gave us?

I tried to run it, but it returned as incorrect SQL :)
0

#7 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 22 September 2009 - 07:57 AM

hmm
try this
http://www.mediafire...php?z20ioyznbtn

svn
https://aowow.svn.so...t/svnroot/aowow

0

#8 User is offline   Navid 

  • Persian Prance of ArcEmu
  • Group: Super Moderator
  • Posts: 718
  • Joined: 30-June 09
  • IRC:Lurker-
  • Gender:Male
  • Location:Iran
  • Interests:PHP,C++,ArcEmu and exactly our lovely community and specially money xD
  • Server OS:Windows

Posted 22 September 2009 - 11:11 AM

hmm,looks good,must check it.
I'm here to check,lurk and kill you so behave or you will be lurked

Posted Image
0

#9 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 22 September 2009 - 11:58 AM

http://github.com/Lo...aowow/downloads
latest version here i find

0

#10 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 22 September 2009 - 05:21 PM

Your thing still doesn't work.

I attempted to do the modifications myself from the error reporter- so I have a few things working (Account page, some of the items stuff)
0

#11 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 23 September 2009 - 12:46 AM

damn
ok
try make this query

DELIMITER $$

DROP VIEW IF EXISTS `page_text`$$

CREATE VIEW `page_text` AS (select `itempages`.`entry` AS `entry`,`itempages`.`text` AS `text`,`itempages`.`next_page` AS `next_page` from `itempages`)$$

DELIMITER ;


0

#12 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 23 September 2009 - 07:27 AM

Two errors:

error : Table 'test.itempages' doesn't exist


error : 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 'DELIMITER' at line 1


Those are both after you dropped the table 'page_text'

Could you give us a dump of your MySQL Database and a compressed version of your site (http://lking.ru/whl/)? That would be extremely helpful :)

Edit: I looked on your site. And wow dude, everything works. Gratz! :D
0

#13 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 23 September 2009 - 07:59 AM

i can but this not help you
because view table its fake table
Me hard explain but if open view file
for example e:\MySQL\data\arcemu\page_text.frm
u see

Quote

TYPE=VIEW
query=(select `arcemu`.`itempages`.`entry` AS `entry`,`arcemu`.`itempages`.`text` AS `text`,`arcemu`.`itempages`.`next_page` AS `next_page` from `arcemu`.`itempages`)
md5=123456sdasd123
updatable=1
algorithm=0
definer_user=server
definer_host=%
suid=2
with_check_option=0
timestamp=2009-09-22 16:27:24
create-version=1
source=(SELECT * FROM itempages)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=(select `arcemu`.`itempages`.`entry` AS `entry`,`arcemu`.`itempages`.`text` AS `text`,`arcemu`.`itempages`.`next_page` AS `next_page` from `arcemu`.`itempages`)



try
DROP VIEW IF EXISTS `page_text`;
CREATE VIEW `page_text` AS (select `itempages`.`entry` AS `entry`,`itempages`.`text` AS `text`,`itempages`.`next_page` AS `next_page` from `itempages`);



error : Table 'test.itempages' doesn't exist - you must have this table

Quote

create table `itempages` (
`entry` double ,
`text` blob ,
`next_page` double
);


0

#14 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 23 September 2009 - 03:54 PM

Okay, all the queries you posted work so far. I'm going to test all the other ones soon.
0

#15 User is offline   Muffler 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 366
  • Joined: 17-June 08
  • Gender:Male
  • Location:CCCP

Posted 24 September 2009 - 03:12 AM

http://dev.mysql.com...reate-view.html for education :P
more time ago i write about use view table for merge mangos+arcemu in one base
http://arcemu.org/fo...showtopic=11964

0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users